[GitHub] [doris] nextdreamblue commented on issue #13465: [Bug] Cast as date query error

[GitBox <gi...@apache.org>]

nextdreamblue commented on issue #13465:
URL: https://github.com/apache/doris/issues/13465#issuecomment-1288713604

   produce:
   MySQL [test]> 
   CREATE TABLE `canal_test1` (
     `a` int(11) NOT NULL COMMENT "",
     `b` datetime NOT NULL COMMENT ""
   ) ENGINE=OLAP
   UNIQUE KEY(`a`)
   COMMENT "OLAP"
   DISTRIBUTED BY HASH(`a`) BUCKETS 8
   PROPERTIES (
   "replication_allocation" = "tag.location.default: 1",
   "in_memory" = "false",
   "storage_format" = "V2"
   );
   
   MySQL [test]> insert into canal_test1 values(1,'2022-08-29 17:19:08');
   MySQL [test]> insert into canal_test1 values(2,'2022-08-30 17:19:08');
   MySQL [test]> insert into canal_test1 values(3,'2022-08-31 17:19:08');
   
   MySQL [test]> select b from canal_test1  where     cast(b as date) in ( '2022-08-31');
   Empty set (0.01 sec)
   
   MySQL [test]> select b from canal_test1  where     cast(b as date) = '2022-08-31';
   Empty set (0.01 sec)
   
   MySQL [test]> select b from canal_test1  where     cast(b as date) bETWEEN '2022-01-01' and '2022-08-31';
   +---------------------+
   | b                   |
   +---------------------+
   | 2022-08-30 17:19:08 |
   | 2022-08-29 17:19:08 |
   +---------------------+
   2 rows in set (0.01 sec)
   
   3个查询结果都不正确，应该都可以返回 2022-08-31 17:19:08


-- 
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.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org