Bug in MIN function
We have a very large table (7T rows) with time series data, with ts_date indicating the date associated with the recorded events.
When running the query below returning 2020-01-04 as the earliest day:
SELECT min(ts_date) FROM mlog.f_event_log; MIN ---------- 2020-01-04
However, when running a query with a filter, I am getting a lower number!
SELECT MIN(ts_date) FROM mlog.f_event_log WHERE s3_bucket_date ='2019-01-01'; MIN ---------- 2016-05-01
Updating statistics now, but this seem like a massive bug in the system. Running v9.2.1-6
Has anybody seen this bug? Any suggestion how to see if this is a know issue?
Thanks for any tips / suggestion!