Debian Codegraph @

mysql-test/suite/compat/oracle/t/update_innodb.test

raw
1 --source include/have_innodb.inc
2
3 --echo #
4 --echo # MDEV-19535 sql_mode=ORACLE: 'SELECT INTO @var FOR UPDATE' does not lock the table
5 --echo #
6
7 SET sql_mode='ORACLE';
8 CREATE TABLE t1 (a INT NOT NULL PRIMARY KEY) engine=innodb;
9 INSERT INTO t1 VALUES (1);
10 START TRANSACTION;
11 --disable_cursor_protocol
12 --enable_prepare_warnings
13 SELECT a AS a_con1 FROM t1 INTO @a FOR UPDATE;
14 --enable_cursor_protocol
15
16 --connect(con2,localhost,root,,)
17 SET sql_mode='ORACLE';
18 START TRANSACTION;
19 --send SELECT a AS a_con2 FROM t1 INTO @a FOR UPDATE;
20
21 --connection default
22 UPDATE t1 SET a=a+100;
23 COMMIT;
24
25 --connection con2
26 --reap
27 SELECT a AS con2 FROM t1;
28 COMMIT;
29
30 --disable_prepare_warnings
31
32 --connection default
33 DROP TABLE t1;