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/bigint.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/bigint.result')
| -rw-r--r-- | mysql-test/r/bigint.result | 12 |
1 files changed, 6 insertions, 6 deletions
diff --git a/mysql-test/r/bigint.result b/mysql-test/r/bigint.result index 1618f3f27a2..b7eaa179484 100644 --- a/mysql-test/r/bigint.result +++ b/mysql-test/r/bigint.result @@ -55,12 +55,12 @@ select min(big),max(big),max(big)-1 from t1 group by a; min(big) max(big) max(big)-1 -1 9223372036854775807 9223372036854775806 drop table t1; -select UNSIGNED 1-2; -UNSIGNED 1-2 +select CAST(1-2 AS UNSIGNED); +CAST(1-2 AS UNSIGNED) 18446744073709551615 -select SIGNED (UNSIGNED 1-2); -SIGNED (UNSIGNED 1-2) +select CAST(CAST(1-2 AS UNSIGNED) AS SIGNED INTEGER); +CAST(CAST(1-2 AS UNSIGNED) AS SIGNED INTEGER) -1 -select UNSIGNED '-1'; -UNSIGNED '-1' +select CONVERT('-1',UNSIGNED); +CONVERT('-1',UNSIGNED) 18446744073709551615 |