Details
-
Technical task
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Fixed
-
10.3(EOL)
-
10.2.2-3, 10.2.2-1, 10.2.2-2, 10.2.2-4, 10.1.18
Description
This script works fine in Oracle (and PostgreSQL):
DROP TABLE t1; |
CREATE TABLE t1 (c1 INT, c2 INT); |
INSERT INTO t1 VALUES (10,10); |
INSERT INTO t1 VALUES (20,20); |
UPDATE t1 SET c1=c1+1 WHERE c2=(SELECT MAX(c2) FROM t1); |
SELECT * FROM t1; |
SQL> SELECT * FROM t1;
|
 |
C1 C2
|
---------- ----------
|
10 10
|
21 20
|
Notice, the table t1 is used twice in the UPDATE query, as a target and as a source.
Under term of this tasks will allow to use the same table as a source and as a target in UPDATE statements in MariaDB.
Currently its not allowed and returns this error:
ERROR 1093 (HY000): Table 't1' is specified twice, both as a target for 'UPDATE' and as a separate source for data
|
Attachments
Issue Links
- is blocked by
-
MDEV-13911 Support ORDER BY and LIMIT in multi-table update
- Closed
- relates to
-
MDEV-12137 DELETE statement with the same source and target
- Closed
- links to