diff options
| author | Michael Widenius <monty@mariadb.org> | 2018-03-09 14:05:35 +0200 |
|---|---|---|
| committer | Monty <monty@mariadb.org> | 2018-03-29 13:59:44 +0300 |
| commit | a7abddeffa6a760ce948c2dfb007cdf3f1a369d5 (patch) | |
| tree | 70eb743fa965a17380bbc0ac88ae79ca1075b896 /mysql-test/r/str_to_datetime_457.result | |
| parent | ab1941266c59a19703a74b5593cf3f508a5752d7 (diff) | |
| download | mariadb-git-a7abddeffa6a760ce948c2dfb007cdf3f1a369d5.tar.gz | |
Create 'main' test directory and move 't' and 'r' there
Diffstat (limited to 'mysql-test/r/str_to_datetime_457.result')
| -rw-r--r-- | mysql-test/r/str_to_datetime_457.result | 51 |
1 files changed, 0 insertions, 51 deletions
diff --git a/mysql-test/r/str_to_datetime_457.result b/mysql-test/r/str_to_datetime_457.result deleted file mode 100644 index 4fd0d00691c..00000000000 --- a/mysql-test/r/str_to_datetime_457.result +++ /dev/null @@ -1,51 +0,0 @@ -select cast('01:02:03 ' as time), cast('01:02:03 ' as time); -cast('01:02:03 ' as time) cast('01:02:03 ' as time) -01:02:03 00:00:00 -select cast('2002-011-012' as date), cast('2002.11.12' as date), cast('2002.011.012' as date); -cast('2002-011-012' as date) cast('2002.11.12' as date) cast('2002.011.012' as date) -2002-11-12 2002-11-12 2002-11-12 -select cast('2012103123595912' as datetime(6)), cast('20121031235959123' as datetime(6)); -cast('2012103123595912' as datetime(6)) cast('20121031235959123' as datetime(6)) -2012-10-31 23:59:59.000000 2012-10-31 23:59:59.000000 -Warnings: -Warning 1292 Truncated incorrect datetime value: '2012103123595912' -Warning 1292 Truncated incorrect datetime value: '20121031235959123' -select cast(0 as date), cast('0000-00-00' as date), cast('0' as date); -cast(0 as date) cast('0000-00-00' as date) cast('0' as date) -0000-00-00 0000-00-00 NULL -Warnings: -Warning 1292 Incorrect datetime value: '0' -select extract(hour from '100000:02:03'), extract(hour from '100000:02:03 '); -extract(hour from '100000:02:03') extract(hour from '100000:02:03 ') -NULL NULL -Warnings: -Warning 1292 Truncated incorrect time value: '100000:02:03' -Warning 1292 Truncated incorrect time value: '100000:02:03 ' -# -# backward compatibility craziness -# -select cast('12:00:00.12.34.56' as time); -cast('12:00:00.12.34.56' as time) -12:00:00 -Warnings: -Warning 1292 Truncated incorrect time value: '12:00:00.12.34.56' -select cast('12:00:00 12.34.56' as time); -cast('12:00:00 12.34.56' as time) -12:34:56 -select cast('12:00:00-12.34.56' as time); -cast('12:00:00-12.34.56' as time) -12:00:00 -Warnings: -Warning 1292 Truncated incorrect time value: '12:00:00-12.34.56' -select cast('12:00:00.12.34.56' as datetime); -cast('12:00:00.12.34.56' as datetime) -2012-00-00 12:34:56 -select cast('12:00:00-12.34.56' as datetime); -cast('12:00:00-12.34.56' as datetime) -2012-00-00 12:34:56 -select cast('12:00:00 12.34.56' as datetime); -cast('12:00:00 12.34.56' as datetime) -2012-00-00 12:34:56 -select cast('12:00:00.123456' as time); -cast('12:00:00.123456' as time) -12:00:00 |