diff options
Diffstat (limited to 'mysql-test/suite/galera/r/galera_toi_alter_auto_increment.result')
-rw-r--r-- | mysql-test/suite/galera/r/galera_toi_alter_auto_increment.result | 42 |
1 files changed, 42 insertions, 0 deletions
diff --git a/mysql-test/suite/galera/r/galera_toi_alter_auto_increment.result b/mysql-test/suite/galera/r/galera_toi_alter_auto_increment.result new file mode 100644 index 00000000000..f91415323ec --- /dev/null +++ b/mysql-test/suite/galera/r/galera_toi_alter_auto_increment.result @@ -0,0 +1,42 @@ +CREATE TABLE ten (f1 INTEGER) ENGINE=InnoDB; +INSERT INTO ten VALUES (1),(2),(3),(4),(5),(6),(7),(8),(9),(10); +CREATE TABLE t1 (f1 INTEGER AUTO_INCREMENT PRIMARY KEY, f2 INTEGER) ENGINE=InnoDB; +INSERT INTO t1 (f2) SELECT 1 FROM ten; +INSERT INTO t1 (f2) SELECT 1 FROM ten; +ALTER TABLE t1 AUTO_INCREMENT = 1000; +INSERT INTO t1 (f2) SELECT 1 FROM ten; +INSERT INTO t1 (f2) SELECT 1 FROM ten; +SELECT MIN(f1) >= 1000, COUNT(*) = 20, COUNT(DISTINCT f1) = 20 FROM t1 WHERE f1 >= 1000; +MIN(f1) >= 1000 COUNT(*) = 20 COUNT(DISTINCT f1) = 20 +1 1 1 +SELECT MIN(f1) >= 1000, COUNT(*) = 20, COUNT(DISTINCT f1) = 20 FROM t1 WHERE f1 >= 1000; +MIN(f1) >= 1000 COUNT(*) = 20 COUNT(DISTINCT f1) = 20 +1 1 1 +ALTER TABLE t1 AUTO_INCREMENT = 5; +INSERT INTO t1 (f2) SELECT 1 FROM ten; +INSERT INTO t1 (f2) SELECT 1 FROM ten; +SELECT MIN(f1) >= 1000, COUNT(*) = 40, COUNT(DISTINCT f1) = 40 FROM t1 WHERE f1 >= 1000; +MIN(f1) >= 1000 COUNT(*) = 40 COUNT(DISTINCT f1) = 40 +1 1 1 +SELECT MIN(f1) >= 1000, COUNT(*) = 40, COUNT(DISTINCT f1) = 40 FROM t1 WHERE f1 >= 1000; +MIN(f1) >= 1000 COUNT(*) = 40 COUNT(DISTINCT f1) = 40 +1 1 1 +DROP TABLE t1; +SET GLOBAL wsrep_auto_increment_control = OFF; +SET GLOBAL auto_increment_increment = 1; +SET GLOBAL auto_increment_offset = 1; +SET GLOBAL wsrep_auto_increment_control = OFF; +SET GLOBAL auto_increment_increment = 1; +SET GLOBAL auto_increment_offset = 1; +CREATE TABLE t1 (f1 INTEGER AUTO_INCREMENT PRIMARY KEY, f2 INTEGER) ENGINE=InnoDB; +ALTER TABLE t1 AUTO_INCREMENT=100; +INSERT INTO t1 (f2) SELECT 1 FROM ten; +INSERT INTO t1 (f2) SELECT 1 FROM ten; +SELECT MIN(f1) = 100, MAX(f1) = 119, COUNT(f1) = 20, COUNT(DISTINCT f1) = 20 FROM t1; +MIN(f1) = 100 MAX(f1) = 119 COUNT(f1) = 20 COUNT(DISTINCT f1) = 20 +1 1 1 1 +SELECT MIN(f1) = 100, MAX(f1) = 119, COUNT(f1) = 20, COUNT(DISTINCT f1) = 20 FROM t1; +MIN(f1) = 100 MAX(f1) = 119 COUNT(f1) = 20 COUNT(DISTINCT f1) = 20 +1 1 1 1 +DROP TABLE t1; +DROP TABLE ten; |