diff options
Diffstat (limited to 'mysql-test/r/bigint.result')
| -rw-r--r-- | mysql-test/r/bigint.result | 14 |
1 files changed, 7 insertions, 7 deletions
diff --git a/mysql-test/r/bigint.result b/mysql-test/r/bigint.result index 3cdf4b17027..eac6ffbde15 100644 --- a/mysql-test/r/bigint.result +++ b/mysql-test/r/bigint.result @@ -47,7 +47,7 @@ drop table t1; create table t1 ( a int not null default 1, big bigint ); insert into t1 (big) values (-1),(12345678901234567),(9223372036854775807),(18446744073709551615); Warnings: -Warning 1264 Out of range value adjusted for column 'big' at row 4 +Warning 1264 Out of range value for column 'big' at row 4 select * from t1; a big 1 -1 @@ -62,7 +62,7 @@ min(big) max(big) max(big)-1 -1 9223372036854775807 9223372036854775806 alter table t1 modify big bigint unsigned not null; Warnings: -Warning 1264 Out of range value adjusted for column 'big' at row 1 +Warning 1264 Out of range value for column 'big' at row 1 select min(big),max(big),max(big)-1 from t1; min(big) max(big) max(big)-1 0 9223372036854775807 9223372036854775806 @@ -92,7 +92,7 @@ min(big) max(big) max(big)-1 0 18446744073709551615 18446744073709551614 alter table t1 modify big bigint not null; Warnings: -Warning 1264 Out of range value adjusted for column 'big' at row 5 +Warning 1264 Out of range value for column 'big' at row 5 select * from t1; a big 1 0 @@ -204,10 +204,10 @@ drop table t1; create table t1 ( quantity decimal(2) unsigned); insert into t1 values (500), (-500), (~0), (-1); Warnings: -Warning 1264 Out of range value adjusted for column 'quantity' at row 1 -Warning 1264 Out of range value adjusted for column 'quantity' at row 2 -Warning 1264 Out of range value adjusted for column 'quantity' at row 3 -Warning 1264 Out of range value adjusted for column 'quantity' at row 4 +Warning 1264 Out of range value for column 'quantity' at row 1 +Warning 1264 Out of range value for column 'quantity' at row 2 +Warning 1264 Out of range value for column 'quantity' at row 3 +Warning 1264 Out of range value for column 'quantity' at row 4 select * from t1; quantity 99 |