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

Correlation names for delete

    XMLWordPrintable

    Details

      Description

      In almost all circumstances you can use a correlation name as a short cut to a table name for example MT in the following query

      SELECT MT.*
      FROM MYTABLE MT
      WHERE MT.MYKEY = 5;
      

      However it looks like you cannot use a correlation name on a delete statement in mariadb so the following generates an error.

      DELETE FROM MYTABLE MT
      WHERE MT.KEY = 5;
      

      You can use a correlation name in this manner in most other databases.

      This is not that big an issue, but an irritation.

        Attachments

          Activity

            People

            Assignee:
            Unassigned
            Reporter:
            nick.denning@diegesis.co.uk Nicholas Denning
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Dates

              Created:
              Updated: