25 lines
988 B
Plaintext
25 lines
988 B
Plaintext
# -- WARNING ----------------------------------------------------------------
|
|
# According to I_S.ENGINES, does not support transactions.
|
|
# If it is true, the test will most likely fail; you can
|
|
# either create an rdiff file, or add the test to disabled.def.
|
|
# If transactions should be supported, check the data in Information Schema.
|
|
# ---------------------------------------------------------------------------
|
|
DROP TABLE IF EXISTS t1;
|
|
connect con1,localhost,root,,;
|
|
connect con2,localhost,root,,;
|
|
connection con1;
|
|
CREATE TABLE t1 (a INT, pk INT AUTO_INCREMENT PRIMARY KEY) ENGINE=XENGINE;
|
|
SET SESSION TRANSACTION ISOLATION LEVEL SERIALIZABLE;
|
|
START TRANSACTION WITH CONSISTENT SNAPSHOT;
|
|
connection con2;
|
|
INSERT INTO t1 (a) VALUES (1);
|
|
connection con1;
|
|
# If consistent read works on this isolation level (SERIALIZABLE), the following SELECT should not return the value we inserted (1)
|
|
SELECT a FROM t1;
|
|
a
|
|
COMMIT;
|
|
connection default;
|
|
disconnect con1;
|
|
disconnect con2;
|
|
DROP TABLE t1;
|