diff options
| author | unknown <serg@serg.mylan> | 2003-07-20 12:26:18 +0200 |
|---|---|---|
| committer | unknown <serg@serg.mylan> | 2003-07-20 12:26:18 +0200 |
| commit | c1ed639cb654cc12f2971d840a541c0d9fa80327 (patch) | |
| tree | f5346590101ec960b64abe165293a334df435f5b /mysql-test/r/bigint.result | |
| parent | 56b220b11e06c5b6074c49cc114c39ee50be1cd1 (diff) | |
| download | mariadb-git-c1ed639cb654cc12f2971d840a541c0d9fa80327.tar.gz | |
bug #715: SELECT YEAR+0 FROM foobar is parsed as 'SELECT' 'YEAR' '+0' => syntax error
mysql-test/r/bigint.result:
test results updated
mysql-test/r/type_decimal.result:
test results updated
mysql-test/t/bigint.test:
new tests added
mysql-test/t/type_decimal.test:
error numbers updated
sql/item.h:
round(9999999999999999999) fixed
sql/sql_yacc.yy:
bug #715: SELECT YEAR+0 FROM foobar is parsed as 'SELECT' 'YEAR' '+0' => syntax error
unary '+' added
Diffstat (limited to 'mysql-test/r/bigint.result')
| -rw-r--r-- | mysql-test/r/bigint.result | 7 |
1 files changed, 5 insertions, 2 deletions
diff --git a/mysql-test/r/bigint.result b/mysql-test/r/bigint.result index 12dc146ba2b..93214ae8479 100644 --- a/mysql-test/r/bigint.result +++ b/mysql-test/r/bigint.result @@ -1,12 +1,12 @@ drop table if exists t1; select 0,256,00000000000000065536,2147483647,-2147483648,2147483648,+4294967296; -0 256 00000000000000065536 2147483647 -2147483648 2147483648 +4294967296 +0 256 00000000000000065536 2147483647 -2147483648 2147483648 4294967296 0 256 65536 2147483647 -2147483648 2147483648 4294967296 select 9223372036854775807,-009223372036854775808; 9223372036854775807 -009223372036854775808 9223372036854775807 -9223372036854775808 select +9999999999999999999,-9999999999999999999; -+9999999999999999999 -9999999999999999999 +9999999999999999999 -9999999999999999999 9999999999999999999 -10000000000000000000 select cast(9223372036854775808 as unsigned)+1; cast(9223372036854775808 as unsigned)+1 @@ -14,6 +14,9 @@ cast(9223372036854775808 as unsigned)+1 select 9223372036854775808+1; 9223372036854775808+1 9223372036854775809 +select -(0-3),round(-(0-3)), round(9999999999999999999); +-(0-3) round(-(0-3)) round(9999999999999999999) +3 3 10000000000000000000 create table t1 (a bigint unsigned not null, primary key(a)); insert into t1 values (18446744073709551615), (0xFFFFFFFFFFFFFFFE); select * from t1; |