diff options
| author | Nirbhay Choubey <nirbhay@mariadb.com> | 2015-01-24 18:46:48 -0500 |
|---|---|---|
| committer | Nirbhay Choubey <nirbhay@mariadb.com> | 2015-01-24 18:46:48 -0500 |
| commit | 53b9f755aff1d6ef5753e0fbca50859126927752 (patch) | |
| tree | 903cdf1c84822affe822cb73abffefe923d9c8bd /mysql-test/suite | |
| parent | b5201200407e6d69ddceb5f482d966f95f5b30ac (diff) | |
| download | mariadb-git-53b9f755aff1d6ef5753e0fbca50859126927752.tar.gz | |
MDEV-7374 : Losing connection to MySQL while running ALTER TABLE
Backport from 10.1.
Diffstat (limited to 'mysql-test/suite')
| -rw-r--r-- | mysql-test/suite/wsrep/r/alter_table_innodb.result | 8 | ||||
| -rw-r--r-- | mysql-test/suite/wsrep/t/alter_table_innodb.opt | 1 | ||||
| -rw-r--r-- | mysql-test/suite/wsrep/t/alter_table_innodb.test | 10 |
3 files changed, 19 insertions, 0 deletions
diff --git a/mysql-test/suite/wsrep/r/alter_table_innodb.result b/mysql-test/suite/wsrep/r/alter_table_innodb.result new file mode 100644 index 00000000000..85017cec6e0 --- /dev/null +++ b/mysql-test/suite/wsrep/r/alter_table_innodb.result @@ -0,0 +1,8 @@ +# +# MDEV-7374 : Losing connection to MySQL while running ALTER TABLE +# +CREATE TABLE t1(i INT) ENGINE=INNODB; +INSERT INTO t1 VALUES (1),(2),(3),(4),(5),(6),(7),(8); +INSERT INTO t1 SELECT a.* FROM t1 a, t1 b, t1 c, t1 d, t1 e; +ALTER TABLE t1 MODIFY i FLOAT; +DROP TABLE t1; diff --git a/mysql-test/suite/wsrep/t/alter_table_innodb.opt b/mysql-test/suite/wsrep/t/alter_table_innodb.opt new file mode 100644 index 00000000000..1e84570d7f6 --- /dev/null +++ b/mysql-test/suite/wsrep/t/alter_table_innodb.opt @@ -0,0 +1 @@ +--wsrep-on=0 diff --git a/mysql-test/suite/wsrep/t/alter_table_innodb.test b/mysql-test/suite/wsrep/t/alter_table_innodb.test new file mode 100644 index 00000000000..ca06be02a85 --- /dev/null +++ b/mysql-test/suite/wsrep/t/alter_table_innodb.test @@ -0,0 +1,10 @@ +--source include/have_innodb.inc + +--echo # +--echo # MDEV-7374 : Losing connection to MySQL while running ALTER TABLE +--echo # +CREATE TABLE t1(i INT) ENGINE=INNODB; +INSERT INTO t1 VALUES (1),(2),(3),(4),(5),(6),(7),(8); +INSERT INTO t1 SELECT a.* FROM t1 a, t1 b, t1 c, t1 d, t1 e; +ALTER TABLE t1 MODIFY i FLOAT; +DROP TABLE t1; |