mirror of
https://github.com/MariaDB/server.git
synced 2025-10-31 10:56:12 +01:00
1f4a9f086a
This was done after discussions with Igor, Sanja and Bar. The main reason for removing the deprication was to ensure that MariaDB is always backward compatible whenever possible. Other things: - Added statistics counters, mainly for the feedback plugin. - INTO OUTFILE - INTO variable - If INTO is using the old syntax (end of query)
22 lines
531 B
Text
22 lines
531 B
Text
#
|
|
# 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;
|