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

CREATE TABLE: field references qualified by a wrong table name succeed

Details

    Description

      Reproduce

      --error ER_BAD_FIELD_ERROR
      		 
      create table t1 (x int, y int generated always as (t2.x));
      		 
      --error ER_BAD_FIELD_ERROR
      		 
      create table t1 (x int, check (t2.x > 0));
      		 
      --error ER_BAD_FIELD_ERROR
      		 
      create table t1 (x int, z int default t2.x);

      Result

      The above commands don't fail. The resulting table misses "t2" qualifier in expressions.

      Expected

      The above CREATE TABLE commands fail.

      Attachments

        Issue Links

          causes

          Bug - A problem which impairs or prevents the functions of the product. MDEV-25672 table alias from previous statement interferes later commands

          • 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-25673 MariaDB fail to execute CONVERT TO CHARACTER

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

          New Feature - A new feature of the product, which has yet to be developed. MDEV-12483 Add foreign keys support for partitioned tables

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

          Activity

            Ascending order - Click to sort in descending order
            midenok Aleksey Midenkov created issue -
            midenok Aleksey Midenkov made changes -
            Field Original Value New Value
            midenok Aleksey Midenkov made changes -
            Summary CREATE TABLE field references qualified by a wrong table name succeed CREATE TABLE: field references qualified by a wrong table name succeed
            midenok Aleksey Midenkov made changes -
            Component/s Data Definition - Create Table [ 14503 ]
            midenok Aleksey Midenkov made changes -
            Status Open [ 1 ] In Progress [ 3 ]
            midenok Aleksey Midenkov made changes -
            Assignee Aleksey Midenkov [ midenok ] Nikita Malyavin [ nikitamalyavin ]
            Status In Progress [ 3 ] In Review [ 10002 ]
            nikitamalyavin Nikita Malyavin added a comment -

            oktopush�

            nikitamalyavin Nikita Malyavin added a comment - oktopush�
            nikitamalyavin Nikita Malyavin made changes -
            Assignee Nikita Malyavin [ nikitamalyavin ] Aleksey Midenkov [ midenok ]
            Status In Review [ 10002 ] Stalled [ 10000 ]
            midenok Aleksey Midenkov made changes -
            Status Stalled [ 10000 ] In Progress [ 3 ]
            midenok Aleksey Midenkov made changes -
            issue.field.resolutiondate 2021-04-23 13:33:12.0 2021-04-23 13:33:12.701
            midenok Aleksey Midenkov made changes -
            Fix Version/s 10.2.38 [ 25207 ]
            Fix Version/s 10.3.29 [ 25206 ]
            Fix Version/s 10.4.19 [ 25205 ]
            Fix Version/s 10.5.10 [ 25204 ]
            Fix Version/s 10.2 [ 14601 ]
            Fix Version/s 10.3 [ 22126 ]
            Fix Version/s 10.4 [ 22408 ]
            Fix Version/s 10.5 [ 23123 ]
            Resolution Fixed [ 1 ]
            Status In Progress [ 3 ] Closed [ 6 ]
            serg Sergei Golubchik made changes -
            serg Sergei Golubchik made changes -
            alice Alice Sherepa made changes -
            alice Alice Sherepa made changes -
            serg Sergei Golubchik made changes -
            serg Sergei Golubchik made changes -
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 119948 ] MariaDB v4 [ 159004 ]

            People

              midenok Aleksey Midenkov
              midenok Aleksey Midenkov
              Votes:
              0 Vote for this issue
              Watchers:
              3 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.