diff options
Diffstat (limited to 'mysql-test/main/cache_temporal_4265.result')
| -rw-r--r-- | mysql-test/main/cache_temporal_4265.result | 22 |
1 files changed, 22 insertions, 0 deletions
diff --git a/mysql-test/main/cache_temporal_4265.result b/mysql-test/main/cache_temporal_4265.result new file mode 100644 index 00000000..1cda7004 --- /dev/null +++ b/mysql-test/main/cache_temporal_4265.result @@ -0,0 +1,22 @@ +create table t1 (a date); +insert t1 values ('2000-01-02'), ('2001-02-03'), ('2002-03-04'); +SET STATEMENT debug_dbug='d,str_to_datetime_warn' for +select * from t1 where a > date_add('2000-01-01', interval 5 day); +a +2001-02-03 +2002-03-04 +Warnings: +Note 1003 2000-01-01 +drop table t1; +create table t1 (id int not null, ut timestamp(6) not null); +insert into t1 values(1, '2001-01-01 00:00:00.2'); +insert into t1 values(1, '2001-01-01 00:00:00.1'); +select * from t1; +id ut +1 2001-01-01 00:00:00.200000 +1 2001-01-01 00:00:00.100000 +select (select max(m2.ut) from t1 m2 where m1.id <> 0) from t1 m1; +(select max(m2.ut) from t1 m2 where m1.id <> 0) +2001-01-01 00:00:00.200000 +2001-01-01 00:00:00.200000 +drop table t1; |