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

DROP DATABASE MYSQL -- does not drop SP with lower-case-table-names=0

    XMLWordPrintable

Details

    Description

      I execute this SQL script with a Linux MariaDB server running with --lower-case-table-names=0:

      DROP FUNCTION IF EXISTS MYSQL.f1;
      CREATE OR REPLACE DATABASE MYSQL; -- Upper case letters
      CREATE FUNCTION MYSQL.f1() RETURNS INT RETURN 1;
      DROP DATABASE MYSQL;
      SELECT db, name, body FROM mysql.proc WHERE db=BINARY 'MYSQL' AND name='f1';
      

      +-------+------+----------+
      | db    | name | body     |
      +-------+------+----------+
      | MYSQL | f1   | RETURN 1 |
      +-------+------+----------+
      

      The above is wrong: the function still exists after the database was dropped.

      Attachments

        Issue Links

          Activity

            People

              bar Alexander Barkov
              bar Alexander Barkov
              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.