diff options
Diffstat (limited to 'mysql-test/suite/galera/r/galera_rsu_add_pk.result')
-rw-r--r-- | mysql-test/suite/galera/r/galera_rsu_add_pk.result | 26 |
1 files changed, 26 insertions, 0 deletions
diff --git a/mysql-test/suite/galera/r/galera_rsu_add_pk.result b/mysql-test/suite/galera/r/galera_rsu_add_pk.result new file mode 100644 index 00000000000..3fd24af9ad7 --- /dev/null +++ b/mysql-test/suite/galera/r/galera_rsu_add_pk.result @@ -0,0 +1,26 @@ +CREATE TABLE ten (f1 INTEGER); +INSERT INTO ten VALUES (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); +CREATE TABLE t1 (f1 INTEGER) Engine=InnoDB; +INSERT INTO t1 (f1) SELECT 000000 + (10000 * a1.f1) + (1000 * a2.f1) + (100 * a3.f1) + (10 * a4.f1) + a5.f1 FROM ten AS a1, ten AS a2, ten AS a3, ten AS a4, ten AS a5; +INSERT INTO t1 (f1) SELECT 100000 + (10000 * a1.f1) + (1000 * a2.f1) + (100 * a3.f1) + (10 * a4.f1) + a5.f1 FROM ten AS a1, ten AS a2, ten AS a3, ten AS a4, ten AS a5;; +SET SESSION wsrep_OSU_method = "RSU"; +ALTER TABLE t1 ADD PRIMARY KEY (f1); +SET SESSION wsrep_OSU_method = "TOI"; +INSERT INTO t1 (f1) SELECT 200000 + (10000 * a1.f1) + (1000 * a2.f1) + (100 * a3.f1) + (10 * a4.f1) + a5.f1 FROM ten AS a1, ten AS a2, ten AS a3, ten AS a4, ten AS a5; +SELECT COUNT(*) = 300000 FROM t1; +COUNT(*) = 300000 +1 +SELECT MAX(f1) = 299999 FROM t1; +MAX(f1) = 299999 +1 +SELECT COUNT(*) = 300000 FROM t1; +COUNT(*) = 300000 +1 +SELECT MAX(f1) = 299999 FROM t1; +MAX(f1) = 299999 +1 +SET SESSION wsrep_OSU_method = "RSU"; +ALTER TABLE t1 ADD PRIMARY KEY (f1); +SET SESSION wsrep_OSU_method = "TOI"; +DROP TABLE t1; +DROP TABLE ten; |