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

no error for DROP TABLE and no warning for DROP TABLE IF EXISTS with absent table when Spider plugin is included

    XMLWordPrintable

Details

    • 2022-22

    Description

      Tested with 10.6.11-6-MariaDB server,
      rocky linux 8 (also seen at several more RPM-linuxes),
      only if spider plugin is enabled during MariaDB server build (cmake -DPLUGIN_SPIDER=YES).

      Use any database and any non-existing table name.

      DROP TABLE non_existing_table;

      • should be:
        ERROR 42S02: Unknown table 'auto_test_local.non_existing_table'
      • actual:
        Query OK, 0 rows affected (0.005 sec)

      DROP TABLE IF EXISTS non_existing_table;

      • should be:
        Warnings: Note 1051 Unknown table 'non_existing_table'
      • actual:
        Query OK, 0 rows affected (0.005 sec)

      Attachments

        Issue Links

          Activity

            People

              ycp Yuchen Pei
              drrtuy Roman
              Votes:
              0 Vote for this issue
              Watchers:
              8 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.