[MDEV-3391] LP:784297 - Failure in multi-update that uses a derived table. Created: 2011-05-17  Updated: 2015-02-02  Resolved: 2012-10-04

Status: Closed
Project: MariaDB Server
Component/s: None
Affects Version/s: None
Fix Version/s: None

Type: Bug Priority: Critical
Reporter: Igor Babaev Assignee: Oleksandr Byelkin
Resolution: Fixed Votes: 0
Labels: Launchpad

Attachments: XML File LPexportBug784297.xml    

 Description   

When trying to execute the test test case of bug #52157 from mysql-test/t/multi_update.test on the LP tree
maria-5.3-mwl106 you get:

MariaDB [test]> CREATE FUNCTION f1 () RETURNS BLOB RETURN 1;
Query OK, 0 rows affected (0.00 sec)

MariaDB [test]> CREATE TABLE t1 (f1 DATE);
Query OK, 0 rows affected (0.01 sec)

MariaDB [test]> INSERT INTO t1 VALUES('2001-01-01');
Query OK, 1 row affected (0.00 sec)

MariaDB [test]> UPDATE (SELECT 1 FROM t1 WHERE f1 = (SELECT f1() FROM t1)) x, t1 SET f1 = 1;
ERROR 1093 (HY000): You can't specify target table 'x' for update in FROM clause

Yet, on the 5.3 tree the last statement works fine:

MariaDB [test]> UPDATE (SELECT 1 FROM t1 WHERE f1 = (SELECT f1() FROM t1)) x, t1 SET f1 = 1;
Query OK, 0 rows affected, 1 warning (0.01 sec)
Rows matched: 0 Changed: 0 Warnings: 0

 Comments   
Comment by Igor Babaev [ 2011-05-19 ]

Re: Failure in multi-update that uses a derived table.
The failure in innodb_multi_update.test with the test case for bug#54475 is probably of same nature (observed only in maria-5.3-mwl106)

Comment by Rasmus Johansson (Inactive) [ 2011-07-29 ]

Launchpad bug id: 784297

Generated at Thu Feb 08 06:48:16 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.