diff options
| author | unknown <svoj@april.(none)> | 2006-09-18 16:23:45 +0500 |
|---|---|---|
| committer | unknown <svoj@april.(none)> | 2006-09-18 16:23:45 +0500 |
| commit | dfb219f6c91e19293c23e64f1bc98d0bb9696fee (patch) | |
| tree | 6d1754293628ba876befcd642131930d508976fa /mysql-test/include | |
| parent | 24cdd48020634acc1c2c2309a5c27d28368e0ba9 (diff) | |
| parent | 0509d3ebd32d736d3c908dee8f92d2b9f16a4da6 (diff) | |
| download | mariadb-git-dfb219f6c91e19293c23e64f1bc98d0bb9696fee.tar.gz | |
Merge svojtovich@bk-internal.mysql.com:/home/bk/mysql-5.0
into april.(none):/home/svoj/devel/mysql/merge/mysql-5.0-engines
mysql-test/r/myisam.result:
Auto merged
mysql-test/t/myisam.test:
Auto merged
sql/ha_ndbcluster.cc:
Auto merged
sql/opt_range.cc:
Auto merged
sql/share/errmsg.txt:
SCCS merged
Diffstat (limited to 'mysql-test/include')
| -rw-r--r-- | mysql-test/include/strict_autoinc.inc | 28 |
1 files changed, 28 insertions, 0 deletions
diff --git a/mysql-test/include/strict_autoinc.inc b/mysql-test/include/strict_autoinc.inc new file mode 100644 index 00000000000..6960440f3a7 --- /dev/null +++ b/mysql-test/include/strict_autoinc.inc @@ -0,0 +1,28 @@ +# +# Test for strict-mode autoincrement +# + +set @org_mode=@@sql_mode; +eval create table t1 +( + `a` tinyint(4) NOT NULL auto_increment, + primary key (`a`) +) engine = $type ; +set @@sql_mode='strict_all_tables'; +--error ER_WARN_DATA_OUT_OF_RANGE +insert into t1 values(1000); +select count(*) from t1; + +set auto_increment_increment=1000; +set auto_increment_offset=700; +--error ER_WARN_DATA_OUT_OF_RANGE +insert into t1 values(null); +select count(*) from t1; + +set @@sql_mode=@org_mode; +insert into t1 values(null); +select * from t1; + +drop table t1; + +# End of test |