Skip to content

Instantly share code, notes, and snippets.

@nirbhayc
Created July 30, 2016 19:23
Show Gist options
  • Save nirbhayc/df257b1088f39210dc2bf757a8dd7d38 to your computer and use it in GitHub Desktop.
Save nirbhayc/df257b1088f39210dc2bf757a8dd7d38 to your computer and use it in GitHub Desktop.
--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