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

DELETE ... RETURNING broken with joins

        Details

        • Type: Bug
        • Status: Closed
        • Priority: Major
        • Resolution: Not a Bug
        • Affects Version/s: 10.0.20
        • Fix Version/s: N/A
        • Component/s: Data Manipulation - Delete
        • Labels:
          None

          Description

          The newly added DELETE ... RETURNING fails to include support for DELETEs featuring JOINs.

          Minimal test case (based off an example in the docs) is attached.

            Gliffy Diagrams

              Attachments

                Activity

                Ascending order - Click to sort in descending order
                Hide
                Permalink
                anthonyryan1 Anthony Ryan added a comment -

                After re-reading the documentation and trying a few other combinations ORDER BY, LIMIT, etc. It seems that the multi-table syntax doesn't support any of these, so I'm less convinced this is a bug.

                Show
                anthonyryan1 Anthony Ryan added a comment - After re-reading the documentation and trying a few other combinations ORDER BY, LIMIT, etc. It seems that the multi-table syntax doesn't support any of these, so I'm less convinced this is a bug.
                Hide
                Permalink
                elenst Elena Stepanova added a comment -

                That's right, see MDEV-5872.
                There used to be a discrepancy between documentation and the initial task/implementation (MDEV-3814), but it was fixed on the documentation side. RETURNING clause just was not implemented for multi-table updates.

                Show
                elenst Elena Stepanova added a comment - That's right, see MDEV-5872 . There used to be a discrepancy between documentation and the initial task/implementation ( MDEV-3814 ), but it was fixed on the documentation side. RETURNING clause just was not implemented for multi-table updates.

                  People

                  • Assignee:
                    Unassigned
                    Reporter:
                    anthonyryan1 Anthony Ryan
                  • Votes:
                    0 Vote for this issue
                    Watchers:
                    3 Start watching this issue

                    Dates

                    • Created:
                      Updated:
                      Resolved: