[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()

Alexander Barkov created issue - 2023-12-22 06:32

Alexander Barkov made changes - 2023-12-22 07:57

Field	Original Value	New Value
Link		This issue relates to ~~MDEV-31340~~ [ ~~MDEV-31340~~ ]

Alexander Barkov made changes - 2024-05-21 13:07

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

Resolution		Fixed [ 1 ]
Status	Open [ 1 ]	Closed [ 6 ]

Daniel Bartholomew made changes - 2024-05-29 17:14

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

MariaDB Server