Debian Codegraph @

mysql-test/suite/compat/oracle/r/update_innodb.result

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