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

Backport DELETE (single table) with alias

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Won't Fix
    • 10.11, 11.4
    • N/A
    • Optimizer
    • None
    • Not for Release Notes
    • The syntax of DELETE (single table) with an alias is now supported.

    Description

      MDEV-33988 added the syntax to do DELETE with on a single table with an alias. As this has been in the server stable for over a year without a problem, lets backport this to 10.11 and 11.4.

      The 11.4 is s straight backport of the MDEV-33988 commit.

      10.11 as changes listed in MDEV-33988 are slightly different.

      Adding this functionality adds a MySQL compatible syntax (when they added it in 8.0.2x approximately) and saves users from a syntax error that can be easily executed.

      Attachments

        Issue Links

          is part of

          Task - A task that needs to be done. MDEV-28906 MySQL 8.0 desired compatibility

          • Major - Major loss of function.
          • Open
          relates to

          New Feature - A new feature of the product, which has yet to be developed. MDEV-33988 DELETE (single table) to support table aliases

          • Major - Major loss of function.
          • Closed

          Activity

            People

              danblack Daniel Black
              danblack Daniel Black
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: