mirror of
https://github.com/MariaDB/server.git
synced 2025-02-04 21:02:17 +01:00
33 lines
705 B
Text
33 lines
705 B
Text
--source include/have_innodb.inc
|
|
|
|
--echo #
|
|
--echo # MDEV-19535 sql_mode=ORACLE: 'SELECT INTO @var FOR UPDATE' does not lock the table
|
|
--echo #
|
|
|
|
SET sql_mode='ORACLE';
|
|
CREATE TABLE t1 (a INT NOT NULL PRIMARY KEY) engine=innodb;
|
|
INSERT INTO t1 VALUES (1);
|
|
START TRANSACTION;
|
|
--disable_cursor_protocol
|
|
--enable_prepare_warnings
|
|
SELECT a AS a_con1 FROM t1 INTO @a FOR UPDATE;
|
|
--enable_cursor_protocol
|
|
|
|
--connect(con2,localhost,root,,)
|
|
SET sql_mode='ORACLE';
|
|
START TRANSACTION;
|
|
--send SELECT a AS a_con2 FROM t1 INTO @a FOR UPDATE;
|
|
|
|
--connection default
|
|
UPDATE t1 SET a=a+100;
|
|
COMMIT;
|
|
|
|
--connection con2
|
|
--reap
|
|
SELECT a AS con2 FROM t1;
|
|
COMMIT;
|
|
|
|
--disable_prepare_warnings
|
|
|
|
--connection default
|
|
DROP TABLE t1;
|