diff options
author | Vasil Dimov <vasil.dimov@oracle.com> | 2010-04-16 19:19:07 +0300 |
---|---|---|
committer | Vasil Dimov <vasil.dimov@oracle.com> | 2010-04-16 19:19:07 +0300 |
commit | eaadb377af7cf6145e324acd008d8f2d3cc00aaf (patch) | |
tree | 71463e53ee744af5c89101393ffdba2fdd955ff5 /mysql-test/suite/innodb/r/innodb-autoinc-44030.result | |
parent | 23dd437b8089c6f7e7b021c48bb8becdbe06c35b (diff) | |
download | mariadb-git-eaadb377af7cf6145e324acd008d8f2d3cc00aaf.tar.gz |
Move InnoDB mysql-tests to the innodb suite.
Diffstat (limited to 'mysql-test/suite/innodb/r/innodb-autoinc-44030.result')
-rw-r--r-- | mysql-test/suite/innodb/r/innodb-autoinc-44030.result | 30 |
1 files changed, 30 insertions, 0 deletions
diff --git a/mysql-test/suite/innodb/r/innodb-autoinc-44030.result b/mysql-test/suite/innodb/r/innodb-autoinc-44030.result new file mode 100644 index 00000000000..54e972843f5 --- /dev/null +++ b/mysql-test/suite/innodb/r/innodb-autoinc-44030.result @@ -0,0 +1,30 @@ +drop table if exists t1; +SET @@SESSION.AUTO_INCREMENT_INCREMENT=1, @@SESSION.AUTO_INCREMENT_OFFSET=1; +CREATE TABLE t1 (c1 INT PRIMARY KEY AUTO_INCREMENT) ENGINE=InnoDB; +INSERT INTO t1 VALUES (null); +INSERT INTO t1 VALUES (null); +ALTER TABLE t1 CHANGE c1 d1 INT NOT NULL AUTO_INCREMENT; +SELECT * FROM t1; +d1 +1 +2 +SELECT * FROM t1; +d1 +1 +2 +INSERT INTO t1 VALUES(null); +ALTER TABLE t1 AUTO_INCREMENT = 3; +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `d1` int(11) NOT NULL AUTO_INCREMENT, + PRIMARY KEY (`d1`) +) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1 +INSERT INTO t1 VALUES(null); +SELECT * FROM t1; +d1 +1 +2 +3 +4 +DROP TABLE t1; |