Created
July 30, 2016 19:23
-
-
Save nirbhayc/df257b1088f39210dc2bf757a8dd7d38 to your computer and use it in GitHub Desktop.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
--source include/galera_cluster.inc | |
--source include/have_innodb.inc | |
--connection node_1 | |
CREATE TABLE t1(i INT) ENGINE=INNODB; | |
INSERT INTO t1 VALUES (1), (2), (3), (4), (5); | |
# Open a new connection to perform a parallel ALTER TABLE. | |
--let $galera_connection_name = node_1a | |
--let $galera_server_number = 1 | |
--source include/galera_connect.inc | |
--connection node_1 | |
SET SESSION debug_dbug='+d,wsrep_sleep_on_query_committing'; | |
--send INSERT INTO t1 VALUES (6); | |
--connection node_1a | |
ALTER TABLE t1 ADD COLUMN j INT; | |
--connection node_1 | |
--echo # Reaping INSERT. | |
--error ER_WRONG_VALUE_COUNT_ON_ROW | |
--reap | |
SELECT * FROM t1; | |
# Cleanup | |
DROP TABLE t1; | |
--source include/galera_end.inc |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment