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

Can't update select sepecial field names

    XMLWordPrintable

Details

    • Can result in unexpected behaviour

    Description

      In 10.11.17, updating specially named fields select and update no longer works, while it worked correctly in version 10.11.16.

      CREATE OR REPLACE TEMPORARY TABLE _tmp(
      		 
      	rowid INT UNSIGNED NOT NULL DEFAULT '0' ,
      		 
      	180ah_2_ev TINYINT UNSIGNED NOT NULL DEFAULT 0 ,
      		 
      	PRIMARY KEY (rowid)
      		 
      )
      		 
       
      ;
      		 
       
      update _tmp k set k.180ah_2_ev =1;
      		 
      select  k.180ah_2_ev from _tmp as k;

      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 '.180ah_2_ev from _tmp as k' at line 1

      Attachments

        Issue Links

          duplicates

          Bug - A problem which impairs or prevents the functions of the product. MDEV-39654 schema-qualified unquoted table name starting with digit fails to parse

          • Blocker - Blocks development and/or testing work, production could not run.
          • Closed
          relates to

          New Feature - A new feature of the product, which has yet to be developed. MDEV-17677 parse keywords followed by a dot as keywords

          • Critical - Crashes, loss of data, severe memory leak.
          • Stalled

          Activity

            People

              Unassigned Unassigned
              bulepage bulepage
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

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