kangkaisen opened a new issue #2946: coalesce date result is wrong URL: https://github.com/apache/incubator-doris/issues/2946 **Describe the bug** ``` CREATE TABLE `baseall_date` ( `k1` date not NULL COMMENT "", `k3` int(11) not NULL COMMENT "", `k9` float not NULL COMMENT "" ) ENGINE=OLAP DUPLICATE KEY(`k1`, `k3`) PARTITION BY RANGE (k1) ( PARTITION p1 VALUES LESS THAN ("2020-02-15"), PARTITION p2 VALUES LESS THAN ("2020-02-16"), PARTITION p3 VALUES LESS THAN ("2020-02-17") ) DISTRIBUTED BY HASH(`k3`) BUCKETS 10 PROPERTIES ( "replication_num" = "1" ); insert into baseall_date (k1,k3,k9) values ('2020-02-16', 2147483647, 12.17); ``` ``` select coalesce(k1, k1) from baseall_date; ``` The result is `20200216`, should be `2020-02-16`
---------------------------------------------------------------- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: [email protected] With regards, Apache Git Services --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
