Details
-
Bug
-
Status: Closed
-
Major
-
Resolution: Fixed
-
None
-
None
Description
Repro
CREATE TABLE table_16 ( timestamp_col_19 timestamp, timestamp_col_29 timestamp, int_col_27 int, int_col_39 int, boolean_col_18 boolean, varchar0045_col_23 varchar(45) ); CREATE TABLE table_7 ( int_col_10 int, bigint_col_3 bigint ); CREATE TABLE table_10 ( boolean_col_8 boolean, boolean_col_16 boolean, timestamp_col_5 timestamp, timestamp_col_15 timestamp, timestamp_col_30 timestamp, decimal3825_col_26 decimal(38, 25), smallint_col_9 smallint, int_col_18 int ); explain cbo SELECT DISTINCT COALESCE(a4.timestamp_col_15, IF(a4.boolean_col_16, a4.timestamp_col_30, a4.timestamp_col_5)) AS timestamp_col FROM table_7 a3 RIGHT JOIN table_10 a4 WHERE (a3.bigint_col_3) >= (a4.int_col_18) INTERSECT ALL SELECT COALESCE(LEAST( COALESCE(a1.timestamp_col_19, CAST('2010-03-29 00:00:00' AS TIMESTAMP)), COALESCE(a1.timestamp_col_29, CAST('2014-08-16 00:00:00' AS TIMESTAMP)) ), GREATEST(COALESCE(a1.timestamp_col_19, CAST('2013-07-01 00:00:00' AS TIMESTAMP)), COALESCE(a1.timestamp_col_29, CAST('2028-06-18 00:00:00' AS TIMESTAMP))) ) AS timestamp_col FROM table_16 a1 GROUP BY COALESCE(LEAST( COALESCE(a1.timestamp_col_19, CAST('2010-03-29 00:00:00' AS TIMESTAMP)), COALESCE(a1.timestamp_col_29, CAST('2014-08-16 00:00:00' AS TIMESTAMP)) ), GREATEST( COALESCE(a1.timestamp_col_19, CAST('2013-07-01 00:00:00' AS TIMESTAMP)), COALESCE(a1.timestamp_col_29, CAST('2028-06-18 00:00:00' AS TIMESTAMP))) );