diff options
| author | unknown <monty@hundin.mysql.fi> | 2002-01-03 00:46:43 +0200 |
|---|---|---|
| committer | unknown <monty@hundin.mysql.fi> | 2002-01-03 00:46:43 +0200 |
| commit | b79170b7fd6b77bbc6cc083fbcaa13faf7f02f92 (patch) | |
| tree | 4e18e3ee4d74189f2a784d419334e02f025eacd1 /mysql-test/r/create.result | |
| parent | 301cdf9f240106978b04d4f8044b24e4a3fa6d00 (diff) | |
| download | mariadb-git-b79170b7fd6b77bbc6cc083fbcaa13faf7f02f92.tar.gz | |
New CAST syntax
Cleanup of multi-table-delete in sql_yacc.yy
Changed syntax of MAXIMUM QUERIES PER HOUR to MAX_QUERIES_PER_HOUR to
not get too many reserved words.
Docs/manual.texi:
Updated information about CAST
mysql-test/r/bigint.result:
New CAST syntax
mysql-test/r/create.result:
New CAST syntax
mysql-test/r/variables.result:
Fix after merge with 3.23
mysql-test/t/bigint.test:
New CAST syntax
mysql-test/t/create.test:
New CAST syntax
sql/item_create.cc:
New CAST syntax
sql/item_func.h:
New CAST syntax
sql/item_timefunc.cc:
New CAST syntax
sql/item_timefunc.h:
New CAST syntax
sql/lex.h:
Changed syntax to MAX_QUERIES_PER_HOUR to not get too many reserved words.
sql/mysql_priv.h:
Cleanup multi-delete
sql/sql_parse.cc:
Cleanup multi-delete
sql/sql_yacc.yy:
Cleanup multi-delete.
New CAST syntax.
Removed some restricted words.
Diffstat (limited to 'mysql-test/r/create.result')
| -rw-r--r-- | mysql-test/r/create.result | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/mysql-test/r/create.result b/mysql-test/r/create.result index 21c2f1efaf4..625b84ae837 100644 --- a/mysql-test/r/create.result +++ b/mysql-test/r/create.result @@ -87,7 +87,7 @@ d bigint(17) 0 e double(18,1) 0.0 f bigint(17) 0 drop table t2; -create table t2 select DATE "2001-12-29" as d, TIME "20:45:11" as t, DATETIME "2001-12-29 20:45:11" as dt; +create table t2 select CAST("2001-12-29" AS DATE) as d, CAST("20:45:11" AS TIME) as t, CAST("2001-12-29 20:45:11" AS DATETIME) as dt; describe t2; Field Type Null Key Default Extra d date 0000-00-00 |