diff options
author | Alexander Barkov <bar@mariadb.org> | 2015-09-23 20:42:28 +0400 |
---|---|---|
committer | Alexander Barkov <bar@mariadb.org> | 2015-09-23 20:42:28 +0400 |
commit | 3ad035f66b74284f515b2786f7d4553dba5c14a2 (patch) | |
tree | 4112fdc64b1dd77aa31389e6a92e0bda7cbaba49 /mysql-test/suite/funcs_1/r | |
parent | b9da3ba45e6a6bad152203f56af47abe79e550ad (diff) | |
download | mariadb-git-3ad035f66b74284f515b2786f7d4553dba5c14a2.tar.gz |
MDEV-8658 DATE(zerofill_column) and DATE(COALESCE(zerofill_column)) return different results
MDEV-8660 TIME(int_zerofill_column) returns a wrong result
Diffstat (limited to 'mysql-test/suite/funcs_1/r')
-rw-r--r-- | mysql-test/suite/funcs_1/r/innodb_func_view.result | 56 | ||||
-rw-r--r-- | mysql-test/suite/funcs_1/r/memory_func_view.result | 56 | ||||
-rw-r--r-- | mysql-test/suite/funcs_1/r/myisam_func_view.result | 56 |
3 files changed, 78 insertions, 90 deletions
diff --git a/mysql-test/suite/funcs_1/r/innodb_func_view.result b/mysql-test/suite/funcs_1/r/innodb_func_view.result index 1e604cb1378..357c8200f34 100644 --- a/mysql-test/suite/funcs_1/r/innodb_func_view.result +++ b/mysql-test/suite/funcs_1/r/innodb_func_view.result @@ -3743,14 +3743,14 @@ my_bigint, id FROM t1_values WHERE select_id = 52 OR select_id IS NULL order by id; CAST(my_bigint AS TIME) my_bigint id NULL NULL 1 -NULL -9223372036854775808 2 -NULL 9223372036854775807 3 +-838:59:59 -9223372036854775808 2 +838:59:59 9223372036854775807 3 00:00:00 0 4 -00:00:01 -1 5 00:17:58 1758 24 Warnings: -Warning 1292 Truncated incorrect time value: '-9223372036854775808' -Warning 1292 Truncated incorrect time value: '9223372036854775807' +Warning 1292 Incorrect time value: '-9223372036854775808' for column 'my_bigint' at row 2 +Warning 1292 Incorrect time value: '9223372036854775807' for column 'my_bigint' at row 3 SHOW CREATE VIEW v1; View Create View character_set_client collation_connection v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select cast(`t1_values`.`my_bigint` as time) AS `CAST(my_bigint AS TIME)`,`t1_values`.`my_bigint` AS `my_bigint`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci @@ -3759,14 +3759,14 @@ WHERE v1.id IN (SELECT id FROM t1_values WHERE select_id = 52 OR select_id IS NULL) order by id; CAST(my_bigint AS TIME) my_bigint id NULL NULL 1 -NULL -9223372036854775808 2 -NULL 9223372036854775807 3 +-838:59:59 -9223372036854775808 2 +838:59:59 9223372036854775807 3 00:00:00 0 4 -00:00:01 -1 5 00:17:58 1758 24 Warnings: -Warning 1292 Truncated incorrect time value: '-9223372036854775808' -Warning 1292 Truncated incorrect time value: '9223372036854775807' +Warning 1292 Incorrect time value: '-9223372036854775808' for column 'my_bigint' at row 1 +Warning 1292 Incorrect time value: '9223372036854775807' for column 'my_bigint' at row 1 DROP VIEW v1; @@ -4095,15 +4095,14 @@ CAST(my_bigint AS DATETIME) my_bigint id NULL NULL 1 NULL -9223372036854775808 2 NULL 9223372036854775807 3 -NULL 0 4 +0000-00-00 00:00:00 0 4 NULL -1 5 NULL 200506271758 18 Warnings: -Warning 1292 Incorrect datetime value: '-9223372036854775808' -Warning 1292 Incorrect datetime value: '9223372036854775807' -Warning 1292 Incorrect datetime value: '0' -Warning 1292 Incorrect datetime value: '-1' -Warning 1292 Incorrect datetime value: '200506271758' +Warning 1292 Incorrect datetime value: '-9223372036854775808' for column 'my_bigint' at row 2 +Warning 1292 Incorrect datetime value: '9223372036854775807' for column 'my_bigint' at row 3 +Warning 1292 Incorrect datetime value: '-1' for column 'my_bigint' at row 5 +Warning 1292 Incorrect datetime value: '200506271758' for column 'my_bigint' at row 18 SHOW CREATE VIEW v1; View Create View character_set_client collation_connection v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select cast(`t1_values`.`my_bigint` as datetime) AS `CAST(my_bigint AS DATETIME)`,`t1_values`.`my_bigint` AS `my_bigint`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci @@ -4114,15 +4113,14 @@ CAST(my_bigint AS DATETIME) my_bigint id NULL NULL 1 NULL -9223372036854775808 2 NULL 9223372036854775807 3 -NULL 0 4 +0000-00-00 00:00:00 0 4 NULL -1 5 NULL 200506271758 18 Warnings: -Warning 1292 Incorrect datetime value: '-9223372036854775808' -Warning 1292 Incorrect datetime value: '9223372036854775807' -Warning 1292 Incorrect datetime value: '0' -Warning 1292 Incorrect datetime value: '-1' -Warning 1292 Incorrect datetime value: '200506271758' +Warning 1292 Incorrect datetime value: '-9223372036854775808' for column 'my_bigint' at row 1 +Warning 1292 Incorrect datetime value: '9223372036854775807' for column 'my_bigint' at row 1 +Warning 1292 Incorrect datetime value: '-1' for column 'my_bigint' at row 1 +Warning 1292 Incorrect datetime value: '200506271758' for column 'my_bigint' at row 1 DROP VIEW v1; @@ -4455,14 +4453,13 @@ CAST(my_bigint AS DATE) my_bigint id NULL NULL 1 NULL -9223372036854775808 2 NULL 9223372036854775807 3 -NULL 0 4 +0000-00-00 0 4 NULL -1 5 2005-06-27 20050627 12 Warnings: -Warning 1292 Incorrect datetime value: '-9223372036854775808' -Warning 1292 Incorrect datetime value: '9223372036854775807' -Warning 1292 Incorrect datetime value: '0' -Warning 1292 Incorrect datetime value: '-1' +Warning 1292 Incorrect datetime value: '-9223372036854775808' for column 'my_bigint' at row 2 +Warning 1292 Incorrect datetime value: '9223372036854775807' for column 'my_bigint' at row 3 +Warning 1292 Incorrect datetime value: '-1' for column 'my_bigint' at row 5 SHOW CREATE VIEW v1; View Create View character_set_client collation_connection v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select cast(`t1_values`.`my_bigint` as date) AS `CAST(my_bigint AS DATE)`,`t1_values`.`my_bigint` AS `my_bigint`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci @@ -4473,14 +4470,13 @@ CAST(my_bigint AS DATE) my_bigint id NULL NULL 1 NULL -9223372036854775808 2 NULL 9223372036854775807 3 -NULL 0 4 +0000-00-00 0 4 NULL -1 5 2005-06-27 20050627 12 Warnings: -Warning 1292 Incorrect datetime value: '-9223372036854775808' -Warning 1292 Incorrect datetime value: '9223372036854775807' -Warning 1292 Incorrect datetime value: '0' -Warning 1292 Incorrect datetime value: '-1' +Warning 1292 Incorrect datetime value: '-9223372036854775808' for column 'my_bigint' at row 1 +Warning 1292 Incorrect datetime value: '9223372036854775807' for column 'my_bigint' at row 1 +Warning 1292 Incorrect datetime value: '-1' for column 'my_bigint' at row 1 DROP VIEW v1; diff --git a/mysql-test/suite/funcs_1/r/memory_func_view.result b/mysql-test/suite/funcs_1/r/memory_func_view.result index a37213fdcaa..df57c83164e 100644 --- a/mysql-test/suite/funcs_1/r/memory_func_view.result +++ b/mysql-test/suite/funcs_1/r/memory_func_view.result @@ -3744,14 +3744,14 @@ my_bigint, id FROM t1_values WHERE select_id = 52 OR select_id IS NULL order by id; CAST(my_bigint AS TIME) my_bigint id NULL NULL 1 -NULL -9223372036854775808 2 -NULL 9223372036854775807 3 +-838:59:59 -9223372036854775808 2 +838:59:59 9223372036854775807 3 00:00:00 0 4 -00:00:01 -1 5 00:17:58 1758 24 Warnings: -Warning 1292 Truncated incorrect time value: '-9223372036854775808' -Warning 1292 Truncated incorrect time value: '9223372036854775807' +Warning 1292 Incorrect time value: '-9223372036854775808' for column 'my_bigint' at row 2 +Warning 1292 Incorrect time value: '9223372036854775807' for column 'my_bigint' at row 3 SHOW CREATE VIEW v1; View Create View character_set_client collation_connection v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select cast(`t1_values`.`my_bigint` as time) AS `CAST(my_bigint AS TIME)`,`t1_values`.`my_bigint` AS `my_bigint`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci @@ -3760,14 +3760,14 @@ WHERE v1.id IN (SELECT id FROM t1_values WHERE select_id = 52 OR select_id IS NULL) order by id; CAST(my_bigint AS TIME) my_bigint id NULL NULL 1 -NULL -9223372036854775808 2 -NULL 9223372036854775807 3 +-838:59:59 -9223372036854775808 2 +838:59:59 9223372036854775807 3 00:00:00 0 4 -00:00:01 -1 5 00:17:58 1758 24 Warnings: -Warning 1292 Truncated incorrect time value: '-9223372036854775808' -Warning 1292 Truncated incorrect time value: '9223372036854775807' +Warning 1292 Incorrect time value: '-9223372036854775808' for column 'my_bigint' at row 1 +Warning 1292 Incorrect time value: '9223372036854775807' for column 'my_bigint' at row 1 DROP VIEW v1; @@ -4096,15 +4096,14 @@ CAST(my_bigint AS DATETIME) my_bigint id NULL NULL 1 NULL -9223372036854775808 2 NULL 9223372036854775807 3 -NULL 0 4 +0000-00-00 00:00:00 0 4 NULL -1 5 NULL 200506271758 18 Warnings: -Warning 1292 Incorrect datetime value: '-9223372036854775808' -Warning 1292 Incorrect datetime value: '9223372036854775807' -Warning 1292 Incorrect datetime value: '0' -Warning 1292 Incorrect datetime value: '-1' -Warning 1292 Incorrect datetime value: '200506271758' +Warning 1292 Incorrect datetime value: '-9223372036854775808' for column 'my_bigint' at row 2 +Warning 1292 Incorrect datetime value: '9223372036854775807' for column 'my_bigint' at row 3 +Warning 1292 Incorrect datetime value: '-1' for column 'my_bigint' at row 5 +Warning 1292 Incorrect datetime value: '200506271758' for column 'my_bigint' at row 6 SHOW CREATE VIEW v1; View Create View character_set_client collation_connection v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select cast(`t1_values`.`my_bigint` as datetime) AS `CAST(my_bigint AS DATETIME)`,`t1_values`.`my_bigint` AS `my_bigint`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci @@ -4115,15 +4114,14 @@ CAST(my_bigint AS DATETIME) my_bigint id NULL NULL 1 NULL -9223372036854775808 2 NULL 9223372036854775807 3 -NULL 0 4 +0000-00-00 00:00:00 0 4 NULL -1 5 NULL 200506271758 18 Warnings: -Warning 1292 Incorrect datetime value: '-9223372036854775808' -Warning 1292 Incorrect datetime value: '9223372036854775807' -Warning 1292 Incorrect datetime value: '0' -Warning 1292 Incorrect datetime value: '-1' -Warning 1292 Incorrect datetime value: '200506271758' +Warning 1292 Incorrect datetime value: '-9223372036854775808' for column 'my_bigint' at row 1 +Warning 1292 Incorrect datetime value: '9223372036854775807' for column 'my_bigint' at row 1 +Warning 1292 Incorrect datetime value: '-1' for column 'my_bigint' at row 1 +Warning 1292 Incorrect datetime value: '200506271758' for column 'my_bigint' at row 1 DROP VIEW v1; @@ -4456,14 +4454,13 @@ CAST(my_bigint AS DATE) my_bigint id NULL NULL 1 NULL -9223372036854775808 2 NULL 9223372036854775807 3 -NULL 0 4 +0000-00-00 0 4 NULL -1 5 2005-06-27 20050627 12 Warnings: -Warning 1292 Incorrect datetime value: '-9223372036854775808' -Warning 1292 Incorrect datetime value: '9223372036854775807' -Warning 1292 Incorrect datetime value: '0' -Warning 1292 Incorrect datetime value: '-1' +Warning 1292 Incorrect datetime value: '-9223372036854775808' for column 'my_bigint' at row 2 +Warning 1292 Incorrect datetime value: '9223372036854775807' for column 'my_bigint' at row 3 +Warning 1292 Incorrect datetime value: '-1' for column 'my_bigint' at row 5 SHOW CREATE VIEW v1; View Create View character_set_client collation_connection v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select cast(`t1_values`.`my_bigint` as date) AS `CAST(my_bigint AS DATE)`,`t1_values`.`my_bigint` AS `my_bigint`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci @@ -4474,14 +4471,13 @@ CAST(my_bigint AS DATE) my_bigint id NULL NULL 1 NULL -9223372036854775808 2 NULL 9223372036854775807 3 -NULL 0 4 +0000-00-00 0 4 NULL -1 5 2005-06-27 20050627 12 Warnings: -Warning 1292 Incorrect datetime value: '-9223372036854775808' -Warning 1292 Incorrect datetime value: '9223372036854775807' -Warning 1292 Incorrect datetime value: '0' -Warning 1292 Incorrect datetime value: '-1' +Warning 1292 Incorrect datetime value: '-9223372036854775808' for column 'my_bigint' at row 1 +Warning 1292 Incorrect datetime value: '9223372036854775807' for column 'my_bigint' at row 1 +Warning 1292 Incorrect datetime value: '-1' for column 'my_bigint' at row 1 DROP VIEW v1; diff --git a/mysql-test/suite/funcs_1/r/myisam_func_view.result b/mysql-test/suite/funcs_1/r/myisam_func_view.result index a37213fdcaa..df57c83164e 100644 --- a/mysql-test/suite/funcs_1/r/myisam_func_view.result +++ b/mysql-test/suite/funcs_1/r/myisam_func_view.result @@ -3744,14 +3744,14 @@ my_bigint, id FROM t1_values WHERE select_id = 52 OR select_id IS NULL order by id; CAST(my_bigint AS TIME) my_bigint id NULL NULL 1 -NULL -9223372036854775808 2 -NULL 9223372036854775807 3 +-838:59:59 -9223372036854775808 2 +838:59:59 9223372036854775807 3 00:00:00 0 4 -00:00:01 -1 5 00:17:58 1758 24 Warnings: -Warning 1292 Truncated incorrect time value: '-9223372036854775808' -Warning 1292 Truncated incorrect time value: '9223372036854775807' +Warning 1292 Incorrect time value: '-9223372036854775808' for column 'my_bigint' at row 2 +Warning 1292 Incorrect time value: '9223372036854775807' for column 'my_bigint' at row 3 SHOW CREATE VIEW v1; View Create View character_set_client collation_connection v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select cast(`t1_values`.`my_bigint` as time) AS `CAST(my_bigint AS TIME)`,`t1_values`.`my_bigint` AS `my_bigint`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci @@ -3760,14 +3760,14 @@ WHERE v1.id IN (SELECT id FROM t1_values WHERE select_id = 52 OR select_id IS NULL) order by id; CAST(my_bigint AS TIME) my_bigint id NULL NULL 1 -NULL -9223372036854775808 2 -NULL 9223372036854775807 3 +-838:59:59 -9223372036854775808 2 +838:59:59 9223372036854775807 3 00:00:00 0 4 -00:00:01 -1 5 00:17:58 1758 24 Warnings: -Warning 1292 Truncated incorrect time value: '-9223372036854775808' -Warning 1292 Truncated incorrect time value: '9223372036854775807' +Warning 1292 Incorrect time value: '-9223372036854775808' for column 'my_bigint' at row 1 +Warning 1292 Incorrect time value: '9223372036854775807' for column 'my_bigint' at row 1 DROP VIEW v1; @@ -4096,15 +4096,14 @@ CAST(my_bigint AS DATETIME) my_bigint id NULL NULL 1 NULL -9223372036854775808 2 NULL 9223372036854775807 3 -NULL 0 4 +0000-00-00 00:00:00 0 4 NULL -1 5 NULL 200506271758 18 Warnings: -Warning 1292 Incorrect datetime value: '-9223372036854775808' -Warning 1292 Incorrect datetime value: '9223372036854775807' -Warning 1292 Incorrect datetime value: '0' -Warning 1292 Incorrect datetime value: '-1' -Warning 1292 Incorrect datetime value: '200506271758' +Warning 1292 Incorrect datetime value: '-9223372036854775808' for column 'my_bigint' at row 2 +Warning 1292 Incorrect datetime value: '9223372036854775807' for column 'my_bigint' at row 3 +Warning 1292 Incorrect datetime value: '-1' for column 'my_bigint' at row 5 +Warning 1292 Incorrect datetime value: '200506271758' for column 'my_bigint' at row 6 SHOW CREATE VIEW v1; View Create View character_set_client collation_connection v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select cast(`t1_values`.`my_bigint` as datetime) AS `CAST(my_bigint AS DATETIME)`,`t1_values`.`my_bigint` AS `my_bigint`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci @@ -4115,15 +4114,14 @@ CAST(my_bigint AS DATETIME) my_bigint id NULL NULL 1 NULL -9223372036854775808 2 NULL 9223372036854775807 3 -NULL 0 4 +0000-00-00 00:00:00 0 4 NULL -1 5 NULL 200506271758 18 Warnings: -Warning 1292 Incorrect datetime value: '-9223372036854775808' -Warning 1292 Incorrect datetime value: '9223372036854775807' -Warning 1292 Incorrect datetime value: '0' -Warning 1292 Incorrect datetime value: '-1' -Warning 1292 Incorrect datetime value: '200506271758' +Warning 1292 Incorrect datetime value: '-9223372036854775808' for column 'my_bigint' at row 1 +Warning 1292 Incorrect datetime value: '9223372036854775807' for column 'my_bigint' at row 1 +Warning 1292 Incorrect datetime value: '-1' for column 'my_bigint' at row 1 +Warning 1292 Incorrect datetime value: '200506271758' for column 'my_bigint' at row 1 DROP VIEW v1; @@ -4456,14 +4454,13 @@ CAST(my_bigint AS DATE) my_bigint id NULL NULL 1 NULL -9223372036854775808 2 NULL 9223372036854775807 3 -NULL 0 4 +0000-00-00 0 4 NULL -1 5 2005-06-27 20050627 12 Warnings: -Warning 1292 Incorrect datetime value: '-9223372036854775808' -Warning 1292 Incorrect datetime value: '9223372036854775807' -Warning 1292 Incorrect datetime value: '0' -Warning 1292 Incorrect datetime value: '-1' +Warning 1292 Incorrect datetime value: '-9223372036854775808' for column 'my_bigint' at row 2 +Warning 1292 Incorrect datetime value: '9223372036854775807' for column 'my_bigint' at row 3 +Warning 1292 Incorrect datetime value: '-1' for column 'my_bigint' at row 5 SHOW CREATE VIEW v1; View Create View character_set_client collation_connection v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select cast(`t1_values`.`my_bigint` as date) AS `CAST(my_bigint AS DATE)`,`t1_values`.`my_bigint` AS `my_bigint`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci @@ -4474,14 +4471,13 @@ CAST(my_bigint AS DATE) my_bigint id NULL NULL 1 NULL -9223372036854775808 2 NULL 9223372036854775807 3 -NULL 0 4 +0000-00-00 0 4 NULL -1 5 2005-06-27 20050627 12 Warnings: -Warning 1292 Incorrect datetime value: '-9223372036854775808' -Warning 1292 Incorrect datetime value: '9223372036854775807' -Warning 1292 Incorrect datetime value: '0' -Warning 1292 Incorrect datetime value: '-1' +Warning 1292 Incorrect datetime value: '-9223372036854775808' for column 'my_bigint' at row 1 +Warning 1292 Incorrect datetime value: '9223372036854775807' for column 'my_bigint' at row 1 +Warning 1292 Incorrect datetime value: '-1' for column 'my_bigint' at row 1 DROP VIEW v1; |