diff options
| author | Sergei Golubchik <sergii@pisem.net> | 2011-03-18 14:52:20 +0100 |
|---|---|---|
| committer | Sergei Golubchik <sergii@pisem.net> | 2011-03-18 14:52:20 +0100 |
| commit | 6998bacfb34ba23c3298510ec86ff7e4b06b9261 (patch) | |
| tree | bc1a76e9f1c0febf77f47f6bb64f552e87c2fffa /mysql-test/r/cast.result | |
| parent | db9c46de40549d26fd71e43cee38355f5141c549 (diff) | |
| download | mariadb-git-6998bacfb34ba23c3298510ec86ff7e4b06b9261.tar.gz | |
lp:737458 Casting dates and times into integers works differently in 5.1-micro
better default for Field::cast_to_int_type()
Diffstat (limited to 'mysql-test/r/cast.result')
| -rw-r--r-- | mysql-test/r/cast.result | 6 |
1 files changed, 6 insertions, 0 deletions
diff --git a/mysql-test/r/cast.result b/mysql-test/r/cast.result index 0917c1762f6..2d65f8816e7 100644 --- a/mysql-test/r/cast.result +++ b/mysql-test/r/cast.result @@ -452,3 +452,9 @@ SELECT CONVERT(t2.a USING UTF8) FROM t1, t1 t2 LIMIT 1 1 DROP TABLE t1; End of 5.1 tests +create table t1 (f1 time, f2 date, f3 datetime); +insert into t1 values ('11:22:33','2011-12-13','2011-12-13 11:22:33'); +select cast(f1 as unsigned), cast(f2 as unsigned), cast(f3 as unsigned) from t1; +cast(f1 as unsigned) cast(f2 as unsigned) cast(f3 as unsigned) +112233 20111213 20111213112233 +drop table t1; |