*** Bug #28006 ***
SET @@storage_engine = 'Falcon';
DROP TABLE IF EXISTS t1;
SET @@tx_isolation = 'REPEATABLE-READ';
SET @@autocommit = 0;
CREATE TABLE t1 (a int);
INSERT INTO t1 VALUES (1);
COMMIT;
# Establish connection conn1
SET storage_engine = 'Falcon';
SET @@tx_isolation = 'REPEATABLE-READ';
SET @@autocommit = 0;
# Switch to connection default
BEGIN;
SELECT * FROM t1;
a
1
# Switch to connection conn1
ALTER TABLE t1 ADD COLUMN b int;
ALTER TABLE t1 DROP COLUMN a;
# Switch to connection default
SELECT * FROM t1;
a
1
COMMIT;
SELECT count(*) FROM t1;
count(*)
1
COMMIT;
# Switch to connection conn1
COMMIT;
# Switch to connection default
DROP TABLE t1;