Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-8308

Implement SQL standard Common Table Expression (CTE) support

        Details

          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;

            Gliffy Diagrams

              Attachments

                Activity

                Hide
                Permalink
                colin Colin Charles added a comment -

                I spoke to D. Richard Hipp (creator of SQLite), and he too would like to see CTE support. We kind of have some of the parts to make this work – virtual columns, DELETE ... RETURNING.

                Show
                colin Colin Charles added a comment - I spoke to D. Richard Hipp (creator of SQLite), and he too would like to see CTE support. We kind of have some of the parts to make this work – virtual columns, DELETE ... RETURNING.

                  People

                  • Assignee:
                    Unassigned
                    Reporter:
                    GeoffMontee Geoff Montee
                  • Votes:
                    4 Vote for this issue
                    Watchers:
                    4 Start watching this issue

                    Dates

                    • Created:
                      Updated: