summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorigor@olga.mysql.com <>2007-05-07 16:58:38 -0700
committerigor@olga.mysql.com <>2007-05-07 16:58:38 -0700
commitefb13e1bfe9b7e438325e85cae51d1bf9de476ad (patch)
tree0385777a590da2332df1116977a2e2bd5923577c
parentafbfcd8480ac2ef9c0ad0ae82394afa49c38f55d (diff)
downloadmariadb-git-efb13e1bfe9b7e438325e85cae51d1bf9de476ad.tar.gz
Adjusted results after the latest addition of test cases.
-rw-r--r--mysql-test/r/type_datetime.result6
1 files changed, 6 insertions, 0 deletions
diff --git a/mysql-test/r/type_datetime.result b/mysql-test/r/type_datetime.result
index 0316ed7e428..8e671597bca 100644
--- a/mysql-test/r/type_datetime.result
+++ b/mysql-test/r/type_datetime.result
@@ -325,6 +325,12 @@ greatest(cast('01-01-01' as date), '01-01-02') + 0
select least(cast('01-01-01' as datetime), '01-01-02') + 0;
least(cast('01-01-01' as datetime), '01-01-02') + 0
20010101000000
+select cast(least(cast('01-01-01' as datetime), '01-01-02') as signed);
+cast(least(cast('01-01-01' as datetime), '01-01-02') as signed)
+20010101000000
+select cast(least(cast('01-01-01' as datetime), '01-01-02') as decimal);
+cast(least(cast('01-01-01' as datetime), '01-01-02') as decimal)
+20010101000000.00
DROP PROCEDURE IF EXISTS test27759 ;
CREATE PROCEDURE test27759()
BEGIN