diff options
| author | unknown <monty@narttu.mysql.fi> | 2003-02-27 02:10:19 +0200 |
|---|---|---|
| committer | unknown <monty@narttu.mysql.fi> | 2003-02-27 02:10:19 +0200 |
| commit | 3f9ea80268126f8401bd27f03b842cd03cde7c9f (patch) | |
| tree | 100a0bcb7776279c8d8c822cac9164e8c17acc14 /mysql-test/r/bigint.result | |
| parent | 66afa065530f724702b82e51c3c88a8770330230 (diff) | |
| download | mariadb-git-3f9ea80268126f8401bd27f03b842cd03cde7c9f.tar.gz | |
Integer values between 9223372036854775807 and 9999999999999999999 are now
regarded as unsigned longlongss, not as floats. This make these values work
similar to values between 10000000000000000000 and 18446744073709551615.
mysql-test/r/bigint.result:
Fixed results for bigints
mysql-test/t/bigint.test:
Fixed results for bigints
sql/item.h:
Mark unsigned big ints as unsigned
sql/sql_lex.cc:
Returns numbers between 9223372036854775807 and 9999999999999999999 as unsigned 64 bit numbers
Diffstat (limited to 'mysql-test/r/bigint.result')
| -rw-r--r-- | mysql-test/r/bigint.result | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/mysql-test/r/bigint.result b/mysql-test/r/bigint.result index 40d29e17237..d7d811dc5f3 100644 --- a/mysql-test/r/bigint.result +++ b/mysql-test/r/bigint.result @@ -6,13 +6,13 @@ select 9223372036854775807,-009223372036854775808; 9223372036854775807 -9223372036854775808 select +9999999999999999999,-9999999999999999999; +9999999999999999999 -9999999999999999999 -10000000000000000000 -10000000000000000000 +9999999999999999999 -10000000000000000000 select cast(9223372036854775808 as unsigned)+1; cast(9223372036854775808 as unsigned)+1 9223372036854775809 select 9223372036854775808+1; 9223372036854775808+1 -9223372036854775808 +9223372036854775809 drop table if exists t1; create table t1 (a bigint unsigned not null, primary key(a)); insert into t1 values (18446744073709551615), (0xFFFFFFFFFFFFFFFE); |