diff options
| author | unknown <Sinisa@sinisa.nasamreza.org> | 2001-12-29 15:15:51 +0200 |
|---|---|---|
| committer | unknown <Sinisa@sinisa.nasamreza.org> | 2001-12-29 15:15:51 +0200 |
| commit | 6ffd555155360ad13ab9bf1f8b050f3d46edb17d (patch) | |
| tree | e570d4c59b3a7727411fc9c0a6fe51a149353d6f /mysql-test | |
| parent | c865e96362b75d1d59ac31c9a2fd34ee1ccdf058 (diff) | |
| download | mariadb-git-6ffd555155360ad13ab9bf1f8b050f3d46edb17d.tar.gz | |
Code that had to be changed so that CREATE ... SELECT ... always
creates proper column types, out of any function, expression or from
other tables.
mysql-test/r/create.result:
This is a result for the test which creates all proper column types
out of CREATE ... SELECT ...
Diffstat (limited to 'mysql-test')
| -rw-r--r-- | mysql-test/r/create.result | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/mysql-test/r/create.result b/mysql-test/r/create.result index 1bb3249bdc5..da0cb693be9 100644 --- a/mysql-test/r/create.result +++ b/mysql-test/r/create.result @@ -76,4 +76,14 @@ x varchar(50) YES NULL describe t2; Field Type Null Key Default Extra x char(50) YES NULL +drop table t2; +create table t2 select now() as a , curtime() as b, curdate() as c , 1+1 as d , 1.0 + 1 as e , 33333333333333333 + 3 as f; +describe t2; +Field Type Null Key Default Extra +a datetime 0000-00-00 00:00:00 +b time 00:00:00 +c date 0000-00-00 +d bigint(17) 0 +e double(18,1) 0.0 +f bigint(17) 0 drop table t1,t2; |