diff options
| author | Sergei Golubchik <sergii@pisem.net> | 2011-03-24 15:55:52 +0100 |
|---|---|---|
| committer | Sergei Golubchik <sergii@pisem.net> | 2011-03-24 15:55:52 +0100 |
| commit | c41b66c07f4c8de57154644aae97d075f4766170 (patch) | |
| tree | 546aad41aac8461150f0bb2dad86a12402b64850 /mysql-test/suite/funcs_1/r/innodb_func_view.result | |
| parent | e06f8fbbae57199d72ed1253b4bbcc7156dafc1b (diff) | |
| download | mariadb-git-c41b66c07f4c8de57154644aae97d075f4766170.tar.gz | |
fixes for funcs_1 suite
Diffstat (limited to 'mysql-test/suite/funcs_1/r/innodb_func_view.result')
| -rw-r--r-- | mysql-test/suite/funcs_1/r/innodb_func_view.result | 16 |
1 files changed, 8 insertions, 8 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 4beb0c8aaf2..a65e82d0ea8 100644 --- a/mysql-test/suite/funcs_1/r/innodb_func_view.result +++ b/mysql-test/suite/funcs_1/r/innodb_func_view.result @@ -3908,13 +3908,13 @@ my_time, id FROM t1_values WHERE select_id = 46 OR select_id IS NULL order by id; CAST(my_time AS DATETIME) my_time id NULL NULL 1 -0000-00-00 00:00:00 -838:59:59 2 -0000-00-00 00:00:00 838:59:59 3 +NULL -838:59:59 2 +NULL 838:59:59 3 0000-00-00 13:00:00 13:00:00 4 0000-00-00 10:00:00 10:00:00 5 Warnings: -Warning 1292 Incorrect datetime value: '0000-00-00 838:59:59' -Warning 1292 Incorrect datetime value: '0000-00-00 838:59:59' +Warning 1292 Truncated incorrect datetime value: '-838:59:59' +Warning 1292 Truncated incorrect datetime value: '838:59:59' 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_time` as datetime) AS `CAST(my_time AS DATETIME)`,`t1_values`.`my_time` AS `my_time`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci @@ -3923,13 +3923,13 @@ WHERE v1.id IN (SELECT id FROM t1_values WHERE select_id = 46 OR select_id IS NULL) order by id; CAST(my_time AS DATETIME) my_time id NULL NULL 1 -0000-00-00 00:00:00 -838:59:59 2 -0000-00-00 00:00:00 838:59:59 3 +NULL -838:59:59 2 +NULL 838:59:59 3 0000-00-00 13:00:00 13:00:00 4 0000-00-00 10:00:00 10:00:00 5 Warnings: -Warning 1292 Incorrect datetime value: '0000-00-00 838:59:59' -Warning 1292 Incorrect datetime value: '0000-00-00 838:59:59' +Warning 1292 Truncated incorrect datetime value: '-838:59:59' +Warning 1292 Truncated incorrect datetime value: '838:59:59' DROP VIEW v1; |