Debian Codegraph @

mysql-test/suite/ndb/r/strict_autoinc_5ndb.result

raw
1 drop table if exists t1;
2 set @org_mode=@@sql_mode;
3 create table t1
4 (
5 `a` tinyint(4) NOT NULL auto_increment,
6 primary key (`a`)
7 ) engine = 'NDB' ;
8 Warnings:
9 Warning 1681 Integer display width is deprecated and will be removed in a future release.
10 Warning 1063 Max value for column a in table test.t1 is less than autoincrement prefetch size. Please decrease ndb_autoincrement_prefetch_sz
11 set @@sql_mode='strict_all_tables';
12 Warnings:
13 Warning 3135 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release.
14 insert into t1 values(1000);
15 ERROR 22003: Out of range value for column 'a' at row 1
16 select count(*) from t1;
17 count(*)
18 0
19 set auto_increment_increment=1000;
20 set auto_increment_offset=700;
21 insert into t1 values(null);
22 ERROR 22003: Out of range value for column 'a' at row 1
23 select count(*) from t1;
24 count(*)
25 0
26 set @@sql_mode=@org_mode;
27 insert ignore into t1 values(null);
28 Warnings:
29 Warning 1264 Out of range value for column 'a' at row 1
30 select * from t1;
31 a
32 127
33 drop table t1;