[MDEV-33019] The database part is not case sensitive in SP names - Jira

Type: Bug
Status: Closed (View Workflow)
Priority: Blocker
Resolution: Fixed
Affects Version/s: 10.4(EOL), 10.5, 10.6, 10.7(EOL), 10.8(EOL), 10.9(EOL), 10.10(EOL), 10.11, 11.0(EOL), 11.1(EOL), 11.2(EOL), 11.3(EOL), 11.4
Fix Version/s: 10.8.8, 10.4.33, 10.5.24, 10.6.17, 10.11.7, 11.0.5, 11.1.4, 11.2.3, 11.3.2, 11.4.1
Component/s: Stored routines
Labels:
None

I start MariaDB with lower-case-table-names=0 and run this script:

CREATE DATABASE DB1;

CREATE DATABASE db1;

CREATE PROCEDURE DB1.sp() SELECT 'This is DB1.sp';

CREATE PROCEDURE db1.sp() SELECT 'This is db1.sp';

CALL DB1.sp();

+----------------+

| This is DB1.sp |

+----------------+

| This is DB1.sp |

+----------------+

So far so good. The first procedure DB1 works fine.

Now I call the second procedure db1.

CALL db1.sp();

+----------------+

| This is DB1.sp |

+----------------+

| This is DB1.sp |

+----------------+

Notice, it erroneously called the first procedure DB1.

relates to

MDEV-31531 Remove my_casedn_str() and my_caseup_str()

MDEV-33020 The database part is not case sensitive in SP names in PERFORMANCE_SCHEMA

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

MariaDB Server