-
Notifications
You must be signed in to change notification settings - Fork 8.3k
Wrong aggregation result? #2509
Copy link
Copy link
Closed
Labels
Description
I have an empty table:
create table history
(
sensorId String,
date Date default toDate(time),
time DateTime,
value Float64
)
ENGINE = MergeTree(date, (sensorId, date, time), 8192)When I execute the query:
select min(time) as t from historyI expect NULL but receive 0:
┌───────────────────t─┐
│ 0000-00-00 00:00:00 │
└─────────────────────┘
1 rows in set. Elapsed: 0.004 sec.
This behaviour started recently after updating to the latest version - 1.1.54385.
Is it correct behaviour?
Reactions are currently unavailable