mirror of
https://github.com/MariaDB/server.git
synced 2025-02-12 00:15:35 +01:00
![Monty](/assets/img/avatar_default.png)
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)
19 lines
439 B
Text
19 lines
439 B
Text
CREATE TABLE bug51920 (i INT) ENGINE=InnoDB;
|
|
INSERT INTO bug51920 VALUES (1);
|
|
BEGIN;
|
|
SELECT * FROM bug51920 FOR UPDATE;
|
|
i
|
|
1
|
|
connect con1,localhost,root,,;
|
|
connection con1;
|
|
UPDATE bug51920 SET i=2;
|
|
connection default;
|
|
SELECT ID FROM INFORMATION_SCHEMA.PROCESSLIST
|
|
WHERE INFO="UPDATE bug51920 SET i=2"
|
|
INTO @thread_id;
|
|
KILL @thread_id;
|
|
connection con1;
|
|
Got one of the listed errors
|
|
connection default;
|
|
DROP TABLE bug51920;
|
|
disconnect con1;
|