diff options
Diffstat (limited to 'mysql-test/r/temporal_literal.result')
| -rw-r--r-- | mysql-test/r/temporal_literal.result | 24 |
1 files changed, 15 insertions, 9 deletions
diff --git a/mysql-test/r/temporal_literal.result b/mysql-test/r/temporal_literal.result index f4f43fe9ba3..84a69d7789e 100644 --- a/mysql-test/r/temporal_literal.result +++ b/mysql-test/r/temporal_literal.result @@ -13,6 +13,7 @@ SELECT DATE'2001'; ERROR HY000: Incorrect DATE value: '2001' SELECT DATE'2001-01'; ERROR HY000: Incorrect DATE value: '2001-01' +SET sql_mode = ''; SELECT DATE'2001-00-00'; DATE'2001-00-00' 2001-00-00 @@ -22,6 +23,7 @@ DATE'2001-01-00' SELECT DATE'0000-00-00'; DATE'0000-00-00' 0000-00-00 +SET sql_mode = DEFAULT; SELECT DATE'2001-01-01 00:00:00'; ERROR HY000: Incorrect DATE value: '2001-01-01 00:00:00' SELECT DATE'01:01:01'; @@ -278,6 +280,7 @@ id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE NULL NULL NULL NULL NULL NULL NULL NULL No tables used Warnings: Note 1003 select TIMESTAMP'2010-01-01 10:10:10' AS `TIMESTAMP'2010-01-01 10:10:10'` +SET sql_mode = ''; # # Testing nanosecond rounding for TIMESTAMP literals with bad dates # @@ -356,6 +359,7 @@ a 2001-00-01 00:00:00 2001-01-00 00:00:00 DROP TABLE t1; +SET sql_mode = DEFAULT; # # Testing Item_date_literal::eq # @@ -487,7 +491,7 @@ INSERT INTO t1 VALUES ('2001','toy',103); INSERT INTO t1 VALUES ('2002','car',201); INSERT INTO t1 VALUES ('2002','gas',202); INSERT INTO t1 VALUES ('2002','toy',203); -SET sql_mode=DEFAULT; +SET sql_mode= ''; PREPARE stmt FROM "SELECT DATE'2001-00-00' AS c,year, SUM(profit) FROM t1 GROUP BY c,year WITH ROLLUP"; EXECUTE stmt; c year SUM(profit) @@ -523,7 +527,7 @@ DROP TABLE t1; # # MDEV-5971 Asymmetry between CAST(DATE'2001-00-00') to INT and TO CHAR in prepared statements # -SET sql_mode=DEFAULT; +SET sql_mode=''; PREPARE stmt FROM "SELECT CAST(DATE'2001-00-00' AS SIGNED) AS c"; SET sql_mode='no_zero_in_date'; EXECUTE stmt; @@ -531,7 +535,7 @@ c NULL Warnings: Warning 1292 Incorrect datetime value: '2001-00-00' -SET sql_mode=DEFAULT; +SET sql_mode=''; PREPARE stmt FROM "SELECT CAST(DATE'2001-00-00' AS CHAR) AS c"; SET sql_mode='no_zero_in_date'; EXECUTE stmt; @@ -539,7 +543,7 @@ c NULL Warnings: Warning 1292 Incorrect datetime value: '2001-00-00' -SET sql_mode=DEFAULT; +SET sql_mode=''; PREPARE stmt FROM "SELECT CAST(DATE'2001-00-00' AS DECIMAL(30,0)) AS c"; SET sql_mode='no_zero_in_date'; EXECUTE stmt; @@ -547,7 +551,7 @@ c NULL Warnings: Warning 1292 Incorrect datetime value: '2001-00-00' -SET sql_mode=DEFAULT; +SET sql_mode=''; PREPARE stmt FROM "SELECT CAST(DATE'2001-00-00' AS DOUBLE) AS c"; SET sql_mode='no_zero_in_date'; EXECUTE stmt; @@ -555,11 +559,12 @@ c NULL Warnings: Warning 1292 Incorrect datetime value: '2001-00-00' +SET sql_mode=DEFAULT; # # Zero month or zero day automatically mean NULL flag, no matter SQL_MODE is. # Only zero year is OK for NOT NULL. # -SET sql_mode=DEFAULT; +SET sql_mode=''; PREPARE stmt FROM "CREATE TABLE t1 AS SELECT CAST(DATE'2001-00-00' AS CHAR) AS c"; EXECUTE stmt; SHOW COLUMNS FROM t1; @@ -580,7 +585,7 @@ SELECT * FROM t1; c NULL DROP TABLE t1; -SET sql_mode=DEFAULT; +SET sql_mode=''; CREATE TABLE t1 AS SELECT DATE'2001-01-01', DATE'0000-01-01', @@ -613,10 +618,11 @@ t1 CREATE TABLE `t1` ( `TIMESTAMP'2001-01-00 00:00:00'` datetime DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1 DROP TABLE t1; +SET sql_mode = DEFAULT; # # MDEV-5975 Prepared statements with DATE literals do not honor NO_ZERO_IN_DATE # -SET sql_mode=DEFAULT; +SET sql_mode=''; PREPARE stmt FROM "SELECT (SELECT DATE'2001-00-00') AS c"; EXECUTE stmt; c @@ -628,7 +634,7 @@ NULL Warnings: Warning 1292 Incorrect datetime value: '2001-00-00' DEALLOCATE PREPARE stmt; -SET sql_mode=DEFAULT; +SET sql_mode=''; PREPARE stmt FROM "SELECT (SELECT TIMESTAMP'2001-00-00 10:20:30') AS c"; EXECUTE stmt; c |