[MDEV-33109] DROP DATABASE MYSQL -- does not drop SP with lower-case-table-names=0 - Jira

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.

relates to

MDEV-31340 Remove MY_COLLATION_HANDLER::strcasecmp()

Transition	Time In Source Status	Execution Times

Alexander Barkov made transition - 2024-05-21 13:09

Open

Closed

151d 6h 36m

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

MariaDB Server