diff options
Diffstat (limited to 'mysql-test/r/bigint.result')
| -rw-r--r-- | mysql-test/r/bigint.result | 6 |
1 files changed, 5 insertions, 1 deletions
diff --git a/mysql-test/r/bigint.result b/mysql-test/r/bigint.result index e58cce67d6a..e49a001399f 100644 --- a/mysql-test/r/bigint.result +++ b/mysql-test/r/bigint.result @@ -60,9 +60,11 @@ min(big) max(big) max(big)-1 select min(big),max(big),max(big)-1 from t1 group by a; min(big) max(big) max(big)-1 -1 9223372036854775807 9223372036854775806 +set sql_mode = 'NO_ENGINE_SUBSTITUTION'; alter table t1 modify big bigint unsigned not null; Warnings: Warning 1264 Out of range value for column 'big' at row 1 +set sql_mode = DEFAULT; select min(big),max(big),max(big)-1 from t1; min(big) max(big) max(big)-1 0 9223372036854775807 9223372036854775806 @@ -90,9 +92,11 @@ min(big) max(big) max(big)-1 select min(big),max(big),max(big)-1 from t1 group by a; min(big) max(big) max(big)-1 0 18446744073709551615 18446744073709551614 +set sql_mode = 'NO_ENGINE_SUBSTITUTION'; alter table t1 modify big bigint not null; Warnings: Warning 1264 Out of range value for column 'big' at row 5 +set sql_mode = DEFAULT; select * from t1; a big 1 0 @@ -208,7 +212,7 @@ a b c d 18446744073709551615 18446744073709551615 18446744073709551615 18446744073709551615 drop table t1; create table t1 ( quantity decimal(2) unsigned); -insert into t1 values (500), (-500), (~0), (-1); +insert ignore into t1 values (500), (-500), (~0), (-1); Warnings: Warning 1264 Out of range value for column 'quantity' at row 1 Warning 1264 Out of range value for column 'quantity' at row 2 |