Details
-
Type:
Task
-
Status: Closed (View Workflow)
-
Priority:
Major
-
Resolution: Fixed
-
Fix Version/s: 10.2.2
-
Component/s: Data Manipulation - Subquery, Parser
-
Labels:
-
Epic Link:
Description
It would be great if MariaDB supported SQL standard Common Table Expressions (CTEs).
WITH moved_rows AS (
|
DELETE FROM products
|
WHERE
|
"date" >= '2010-10-01' AND
|
"date" < '2010-11-01'
|
RETURNING *
|
)
|
INSERT INTO products_log
|
SELECT * FROM moved_rows;
|
Attachments
Issue Links
- duplicates
-
MDEV-9956 suport hierachy query (connect by)
-
- Closed
-
-
MDEV-10116 Equivalent of DB2 WITH statement
-
- Closed
-
- is part of
-
MDEV-10137 Providing compatibility to other databases
-
- Open
-
There are no Sub-Tasks for this issue.