diff options
| author | Sinisa@sinisa.nasamreza.org <> | 2001-12-29 15:15:51 +0200 |
|---|---|---|
| committer | Sinisa@sinisa.nasamreza.org <> | 2001-12-29 15:15:51 +0200 |
| commit | d82830c591942a21e72f55e76c7193ea1c56ecea (patch) | |
| tree | e570d4c59b3a7727411fc9c0a6fe51a149353d6f /mysql-test | |
| parent | 1cef60bff682d765c53bc307e60797683a67d3d2 (diff) | |
| download | mariadb-git-d82830c591942a21e72f55e76c7193ea1c56ecea.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.
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; |