Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.5, 10.6, 10.11, 11.1(EOL), 11.2, 11.4, 10.4(EOL), 10.7(EOL), 10.8(EOL), 10.9(EOL), 10.10(EOL), 11.0(EOL), 11.3(EOL)
-
None
Description
I start MariaDB with:
lower-case-table-names=0
|
performance-schema=1
|
and run this script:
CREATE OR REPLACE DATABASE DB1; |
CREATE OR REPLACE 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 needed to reset the SP cache (a MDEV-33019 workaround) |
CREATE PROCEDURE DB1.sp2() SELECT 'This is DB1.sp2'; |
CALL db1.sp();
|
select object_type, object_schema, object_name, count_star, count_statements, sum_rows_sent from performance_schema.events_statements_summary_by_program where object_type='procedure'; |
+-------------+---------------+-------------+------------+------------------+---------------+
|
| object_type | object_schema | object_name | count_star | count_statements | sum_rows_sent |
|
+-------------+---------------+-------------+------------+------------------+---------------+
|
| PROCEDURE | db1 | sp | 2 | 0 | 0 |
|
+-------------+---------------+-------------+------------+------------------+---------------+
|
The result looks wrong. The expected result would be two records:
- one record for DB1.sp
- one record for db1.sp
Attachments
Issue Links
- relates to
-
MDEV-31531 Remove my_casedn_str() and my_caseup_str()
- Closed
-
MDEV-33019 The database part is not case sensitive in SP names
- Closed