blob: 0c9922fe19e68dd333f8fc3e59bdca608bb0e6d9 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
|
#
# MDEV-19535 sql_mode=ORACLE: 'SELECT INTO @var FOR UPDATE' does not lock the table
#
SET sql_mode='ORACLE';
CREATE TABLE t1 (a INT NOT NULL PRIMARY KEY) engine=innodb;
INSERT INTO t1 VALUES (1);
START TRANSACTION;
SELECT a AS a_con1 FROM t1 INTO @a FOR UPDATE;
connect con2,localhost,root,,;
SET sql_mode='ORACLE';
START TRANSACTION;
SELECT a AS a_con2 FROM t1 INTO @a FOR UPDATE;;
connection default;
UPDATE t1 SET a=a+100;
COMMIT;
connection con2;
SELECT a AS con2 FROM t1;
con2
101
COMMIT;
connection default;
DROP TABLE t1;
|
