mirror of
https://github.com/MariaDB/server.git
synced 2025-10-31 02:46:29 +01:00
26 lines
660 B
Text
26 lines
660 B
Text
#
|
|
# Test that checks transactions and MVCC
|
|
#
|
|
|
|
#
|
|
# This is a taken from parts.partition_auto_increment_maria. It originally
|
|
# crashed because con1 could read the first record from t1, which confused
|
|
# the optimizer.
|
|
#
|
|
|
|
connect(con1, localhost, root,,);
|
|
connection default;
|
|
CREATE TABLE t1 (c1 INT NOT NULL AUTO_INCREMENT, PRIMARY KEY (c1))
|
|
ENGINE = aria;
|
|
START TRANSACTION;
|
|
INSERT INTO t1 (c1) VALUES (2);
|
|
INSERT INTO t1 (c1) VALUES (4);
|
|
connection con1;
|
|
START TRANSACTION;
|
|
# When Aria properly supports MVCC, the following two queries will not see
|
|
# any rows
|
|
select * from t1;
|
|
select * from t1 where c1=2;
|
|
disconnect con1;
|
|
connection default;
|
|
drop table t1;
|