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

table alias from previous statement interferes later commands

Details

    Description

      When an Update Statement happens with an alias. The alias seems to replace the table name.

      See below an example Query to reproduce the failure:

      DROP TABLE IF EXISTS `test_table`;
      		 
       
      		 
      CREATE TABLE `test_table` (
      		 
        `id` int NOT NULL AUTO_INCREMENT PRIMARY KEY,
      		 
        `order_date` datetime NOT NULL,
      		 
        `language_id` BINARY(16) NULL 
      );
      		 
       
      		 
      ALTER TABLE `test_table` CHANGE `order_date` `order_date_time` DATETIME(3) NOT NULL;
      		 
       
      		 
      ALTER TABLE `test_table` ADD COLUMN `order_date` DATE GENERATED ALWAYS AS (CONVERT(`order_date_time`, DATE)) STORED AFTER `order_date_time`;
      		 
       
      		 
      UPDATE `test_table` as `x` SET order_date = NULL;
      		 
       
      		 
      ALTER TABLE `test_table` MODIFY COLUMN `language_id` BINARY(16) NOT NULL;

      Results in the following error on the ALTER TABLE statement:

      Unknown column '`test`.`x`.`order_date_time`' in 'GENERATED ALWAYS'

      Attachments

        Issue Links

          duplicates

          Bug - A problem which impairs or prevents the functions of the product. MDEV-25673 MariaDB fail to execute CONVERT TO CHARACTER

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-25676 Alias in a view on a table with virtual column avoid index creation

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-25699 Cannot create new column - check constraint issue reported on an existing json column

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-25732 Error while removing the constraint

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-25733 Select with table name alias prevents foreign key deletion

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-25763 optimize table : Unknown column

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-25868 CHECK constaint refers to old table name after temporary table rename

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-25879 Problem with modifing tables with STORED columns used in procedures

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-25932 Error 1054 on DROP INDEX for tables having virtual column and view referencing it

          • Major - Major loss of function.
          • Closed
          is caused by

          Bug - A problem which impairs or prevents the functions of the product. MDEV-25091 CREATE TABLE: field references qualified by a wrong table name succeed

          • Major - Major loss of function.
          • Closed
          is duplicated by

          Bug - A problem which impairs or prevents the functions of the product. MDEV-25997 ALTER TABLE command works on one table, but not the other

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-10355 Weird error message upon CREATE TABLE with DEFAULT: Function or expression 'cache' cannot be used in the ??? clause

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-16039 Crash when selecting virtual columns generated using functions with DAYNAME()

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-24176 Server crashes after insert in the table with virtual column generated using date_format() and if()

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-25794 vcol_info refix during lock_tables() leads to memory leak until table flush

          • Major - Major loss of function.
          • Open

          Activity

            Ascending order - Click to sort in descending order
            View 4 older comments
            midenok Aleksey Midenkov added a comment -

            Please review 2 commits in bb-10.2-midenok

            midenok Aleksey Midenkov added a comment - Please review 2 commits in bb-10.2-midenok
            nikitamalyavin Nikita Malyavin added a comment - - edited

            FYI git bisect points to
            42f8548f MDEV-25091 CREATE TABLE: field references qualified by a wrong table name succeed

            nikitamalyavin Nikita Malyavin added a comment - - edited FYI git bisect points to 42f8548f MDEV-25091 CREATE TABLE: field references qualified by a wrong table name succeed
            midenok Aleksey Midenkov added a comment - - edited

            nikitamalyavin just look at Issue Links caused by.

            midenok Aleksey Midenkov added a comment - - edited nikitamalyavin just look at Issue Links caused by.
            midenok Aleksey Midenkov added a comment - - edited

            ralf.gebhardt@mariadb.com serg If there is no time for this fix to be properly tested then MDEV-25091 should be reverted until the fix pushed.

            midenok Aleksey Midenkov added a comment - - edited ralf.gebhardt@mariadb.com serg If there is no time for this fix to be properly tested then MDEV-25091 should be reverted until the fix pushed.
            serg Sergei Golubchik added a comment -

            I'd rather push a one-liner, as discussed on slack. I'll fix the bug without reopening MDEV-25091.

            serg Sergei Golubchik added a comment - I'd rather push a one-liner, as discussed on slack. I'll fix the bug without reopening MDEV-25091 .

            People

              serg Sergei Golubchik
              shyim Soner Sayakci
              Votes:
              0 Vote for this issue
              Watchers:
              11 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.