Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
N/A
-
None
-
Q1/2027 Server Maintenance
Description
CREATE TABLE t1 (a INT); |
UPDATE t1 SET a=a+1 WHERE 1=0 RETURNING a INTO @a; |
|
|
INSERT INTO t1 VALUES (1),(2); |
|
|
--error ER_SP_FETCH_NO_DATA
|
UPDATE t1 SET a=a+1 WHERE a=123 RETURNING a INTO @a; |
|
|
UPDATE t1 SET a=a+1 WHERE 1=0 RETURNING a INTO @a; |
UPDATE t1 SET a=a+1 limit 0 RETURNING a INTO @a; |
|
|
DROP TABLE t1; |
CREATE TABLE t1 (a INT);
|
UPDATE t1 SET a=a+1 WHERE 1=0 RETURNING a INTO @a;
|
INSERT INTO t1 VALUES (1),(2);
|
UPDATE t1 SET a=a+1 WHERE a=123 RETURNING a INTO @a;
|
ERROR 02000: No data - zero rows fetched, selected, or processed
|
UPDATE t1 SET a=a+1 WHERE 1=0 RETURNING a INTO @a;
|
UPDATE t1 SET a=a+1 limit 0 RETURNING a INTO @a;
|
DROP TABLE t1;
|
Attachments
Issue Links
- is caused by
-
MDEV-39563 Implement UPDATE ... RETURNING ... INTO
-
- In Testing
-