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

Multi-table DELETE + RETURNING = parse error

        Details

        • Type: Bug
        • Status: Closed
        • Priority: Major
        • Resolution: Fixed
        • Affects Version/s: 10.0.9
        • Fix Version/s: 10.0.10
        • Component/s: None
        • Labels:
          None

          Description

          This page:

          https://mariadb.com/kb/en/delete/

          says that the following syntax is supported:

          DELETE [LOW_PRIORITY] [QUICK] [IGNORE]
    tbl_name[.*] [, tbl_name[.*]] ...
    FROM table_references
    [WHERE where_condition]
    [RETURNING select_expr [, select_expr ...]]

          But if I use it I get an error:

          MariaDB [test]> DELETE post FROM blog INNER JOIN post WHERE blog.id = post.blog_id RETURNING post.title;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'RETURNING post.title' at line 1

            Gliffy Diagrams

              Attachments

                Activity

                Ascending order - Click to sort in descending order
                Hide
                Permalink
                elenst Elena Stepanova added a comment -

                I think the documentation is overly optimistic. MDEV-3814 which introduced the new syntax only specifies it for a single table:

                DELETE [LOW_PRIORITY] [QUICK] [IGNORE] FROM tbl_name
    [WHERE where_condition]
    [ORDER BY col_name | expr | position} [ASC | DESC], ...]
    [LIMIT row_count]
RETURNING select_expr [, select_expr ...]
                Show
                elenst Elena Stepanova added a comment - I think the documentation is overly optimistic. MDEV-3814 which introduced the new syntax only specifies it for a single table: DELETE [LOW_PRIORITY] [QUICK] [IGNORE] FROM tbl_name [ WHERE where_condition] [ORDER BY col_name | expr | position} [ASC | DESC], ...] [LIMIT row_count] RETURNING select_expr [, select_expr ...]
                Hide
                Permalink
                greenman Ian Gilfillan added a comment - - edited

                The documentation has been amended.

                Show
                greenman Ian Gilfillan added a comment - - edited The documentation has been amended.

                  People

                  • Assignee:
                    greenman Ian Gilfillan
                    Reporter:
                    f_razzoli Federico Razzoli
                  • Votes:
                    0 Vote for this issue
                    Watchers:
                    4 Start watching this issue

                    Dates

                    • Created:
                      Updated:
                      Resolved: