sql - postgres (w/timescaledb) order by 返回没有行

Question

我有一种我不理解的行为。当我向查询添加 ORDER BY 子句时，它不再返回任何行

注意:事件是一个 timescaledb hypertable

SELECT "event"."id" AS "event_id",
"event"."value" AS "event_value",
 "event"."timestamp" AS "event_timestamp"
 FROM "event" "event"
WHERE event."customerId" = '8e3a1557-6f00-484d-828e-b57794bf54a7'
AND event."signalId" = 'c6c372f7-b6bd-4b19-9217-676accf723d3'

返回一行

但是如果我通过以下方式添加订单

SELECT "event"."id" AS "event_id",
"event"."value" AS "event_value",
 "event"."timestamp" AS "event_timestamp"
 FROM "event" "event"
WHERE event."customerId" = '8e3a1557-6f00-484d-828e-b57794bf54a7'
AND event."signalId" = 'c6c372f7-b6bd-4b19-9217-676accf723d3'
ORDER BY "event"."timestamp" DESC

它不返回任何行!

我做错了什么？!

===========截图

Answer 1

这是 timescaledb 与 1.4.0(可能更早)的问题升级到 1.4.1 及更高版本解决了这个问题