summaryrefslogtreecommitdiff
path: root/mysql-test/r/func_time.result
diff options
context:
space:
mode:
authorhery.ramilison@oracle.com <>2011-03-16 15:11:20 +0100
committerMySQL Build Team <build@mysql.com>2011-03-16 15:11:20 +0100
commit18d2e55c51525003e2267e06e7de5699f90a80f7 (patch)
tree3b31ba86b07ae94f5ca16e551fc8157d0188b2ab /mysql-test/r/func_time.result
parent5aed24509824dae9fb61f4cdc17510707ec314ad (diff)
parenteea75513c22f074c6d7e46f14acf693bcbb0da56 (diff)
downloadmariadb-git-18d2e55c51525003e2267e06e7de5699f90a80f7.tar.gz
Merge from mysql-5.5.10-release
Diffstat (limited to 'mysql-test/r/func_time.result')
-rw-r--r--mysql-test/r/func_time.result12
1 files changed, 12 insertions, 0 deletions
diff --git a/mysql-test/r/func_time.result b/mysql-test/r/func_time.result
index bbc86ddeda0..09b0af61ea5 100644
--- a/mysql-test/r/func_time.result
+++ b/mysql-test/r/func_time.result
@@ -1376,3 +1376,15 @@ NULL 1 NULL
SET storage_engine=NULL;
ERROR 42000: Variable 'storage_engine' can't be set to the value of 'NULL'
#
+# Bug #59686 crash in String::copy() with time data type
+#
+SELECT min(timestampadd(month, 1>'', from_days('%Z')));
+min(timestampadd(month, 1>'', from_days('%Z')))
+NULL
+Warnings:
+Warning 1292 Truncated incorrect INTEGER value: '%Z'
+create table t1(a time);
+insert into t1 values ('00:00:00'),('00:01:00');
+select 1 from t1 where 1 < some (select cast(a as datetime) from t1);
+1
+drop table t1;