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

Spider: DROP TABLE succeeds where it should not

    XMLWordPrintable

Details

    Description

      INSTALL PLUGIN Spider SONAME 'ha_spider.so';
      --error ER_BAD_TABLE_ERROR
      DROP TABLE t1;
      

      Leads to:

      10.5.23 6b343de8ef51e4c92f0ea2bf62f27f0aab32204d (Debug)

      CURRENT_TEST: main.test
      mysqltest: At line 3: query 'DROP TABLE t1' succeeded - should have failed with errno 1051...
      

      The DROP TABLE t1 should fail (and thus the MTR testcase should succeed as --error ER_BAD_TABLE_ERROR was specified). However, it succeeds. There are possibly other more serious variations/implications of this scenario. If a code check shows that the issue is limited to an incorrect "Query OK" return only, the priority can be lowered.

      Attachments

        Issue Links

          Activity

            People

              ycp Yuchen Pei
              Roel Roel Van de Paar
              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.