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

[MDEV-33019] The database part is not case sensitive in SP names Created: 2023-12-14 Updated: 2023-12-27 Resolved: 2023-12-27
Status:	Closed
Project:	MariaDB Server
Component/s:	Stored routines
Affects Version/s:	10.4, 10.5, 10.6, 10.7, 10.8, 10.9, 10.10, 10.11, 11.0, 11.1, 11.2, 11.3, 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

Type:

Bug

Priority:

Blocker

Reporter:

Alexander Barkov

Assignee:

Alexander Barkov

Resolution:

Fixed

Votes:

Labels:

None

Issue Links:

Relates
relates to	MDEV-31531	Remove my_casedn_str() and my_caseup_...	In Testing
relates to	MDEV-33020	The database part is not case sensiti...	Open

Description

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.

Generated at Thu Feb 08 10:35:47 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.