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

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

            Dates

              Created:
              Updated:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.