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

Spider: DROP TABLE succeeds where it should not

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

            Possible cause MDEV-11412?

            Roel Roel Van de Paar added a comment - Possible cause MDEV-11412 ?
            ycp Yuchen Pei added a comment -

            Duplicate of MDEV-30170

            ycp Yuchen Pei added a comment - Duplicate of MDEV-30170

            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.