Repository navigation
[Bug] Mysql date formate error where conditions in #12088
Description
Search before asking
- I had searched in the issues and found no similar issues.
Version
apache-doris-1.1.1
What's Wrong?
when use from_unixtime function in mysql client , it return wrong count and detail data from sql . like below:
What You Expected?
it should return the same data with %s and %S in mysql date formate .
which in my examle , it should also return 24 record instead of 18 record.
How to Reproduce?
create a unique table with long type of createtime. then select the data from it with from_unixtime and use %s or %s formate.
Anything Else?
No response
Are you willing to submit PR?
- Yes I am willing to submit a PR!
Code of Conduct
- I agree to follow this project's Code of Conduct
Activity
sogngenWang commentedon Aug 26, 2022
CREATE TABLE
l_test_log_3(uniqueidvarchar(40) NULL COMMENT "",kidint(11) NULL COMMENT "",createtimeint(11) NULL COMMENT "",dorisdatedate NULL COMMENT "") ENGINE=OLAP
UNIQUE KEY(
uniqueid,kid,createtime,dorisdate)COMMENT "OLAP"
PARTITION BY RANGE(
dorisdate)()DISTRIBUTED BY HASH(
uniqueid) BUCKETS 1PROPERTIES (
"replication_allocation" = "tag.location.default: 1",
"dynamic_partition.enable" = "true",
"dynamic_partition.time_unit" = "DAY",
"dynamic_partition.time_zone" = "-05:00",
"dynamic_partition.start" = "-3",
"dynamic_partition.end" = "1",
"dynamic_partition.prefix" = "p",
"dynamic_partition.replication_allocation" = "tag.location.default: 1",
"dynamic_partition.buckets" = "1",
"dynamic_partition.create_history_partition" = "true",
"dynamic_partition.history_partition_num" = "3",
"dynamic_partition.hot_partition_num" = "0",
"dynamic_partition.reserved_history_periods" = "NULL",
"in_memory" = "false",
"storage_format" = "V2"
) ;
insert into
l_test_log_3values('0',1,1661339109,'2022-08-24');insert into
l_test_log_3values('1',1,1661339109,'2022-08-24');insert into
l_test_log_3values('2',1,1661339109,'2022-08-24');insert into
l_test_log_3values('3',1,1661339109,'2022-08-24');insert into
l_test_log_3values('4',1,1661339109,'2022-08-24');insert into
l_test_log_3values('5',1,1661339109,'2022-08-24');insert into
l_test_log_3values('6',1,1661339109,'2022-08-24');insert into
l_test_log_3values('7',1,1661339109,'2022-08-24');insert into
l_test_log_3values('8',1,1661339109,'2022-08-24');insert into
l_test_log_3values('9',1,1661339109,'2022-08-24');select count(1) from
l_test_log_3where from_unixtime(createtime,'%Y-%m-%d %H:%i:%s')='2022-08-24 19:05:09' ;select count(1) from
l_test_log_3where from_unixtime(createtime,'%Y-%m-%d %H:%i:%S')='2022-08-24 19:05:09' ;sogngenWang commentedon Aug 26, 2022
sogngenWang commentedon Aug 28, 2022
It is ok in version apache doris release v1.1.2