diff options
| author | monty@hundin.mysql.fi <> | 2002-01-03 00:46:43 +0200 |
|---|---|---|
| committer | monty@hundin.mysql.fi <> | 2002-01-03 00:46:43 +0200 |
| commit | 2597b1aadd45f166c2c8efe04d0e5444e4389ea6 (patch) | |
| tree | 4e18e3ee4d74189f2a784d419334e02f025eacd1 /mysql-test/r/bigint.result | |
| parent | b0ea238d2ea39e24b4d47be6cd671702fb94f59c (diff) | |
| download | mariadb-git-2597b1aadd45f166c2c8efe04d0e5444e4389ea6.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.
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 |