Skip to content

Wrong aggregation result? #2509

@AlexMAS

Description

@AlexMAS

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 history

I 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?

Metadata

Metadata

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions