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

Table is not locked with LOCK TABLES for DELETE with alias

    XMLWordPrintable

Details

    Description

      Testcase:

      CREATE TABLE t1 (a tinyint(3), b tinyint(5));
      		 
      INSERT INTO t1 VALUES (1,1);
      		 
       
      		 
      LOCK TABLE t1 write;
      		 
      INSERT INTO t1 VALUES (1,2);
      		 
      delete from t1 as at;
      		 
      UNLOCK TABLES;
      		 
       
      		 
      drop table t1;

      Actual result:

      At line 10: query 'delete from t1 as at' failed: ER_TABLE_NOT_LOCKED (1100): Table 'at' was not locked with LOCK TABLES

      Expected result:
      Delete was successful

      Attachments

        Issue Links

          is caused by

          New Feature - A new feature of the product, which has yet to be developed. MDEV-33988 DELETE (single table) to support table aliases

          • Major - Major loss of function.
          • Closed

          Activity

            People

              lstartseva Lena Startseva
              lstartseva Lena Startseva
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0d
                  0d
                  Logged:
                  Time Spent - 0.75h
                  0.75h

                  Git Integration

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