Debian Codegraph @

mysql-test/suite/perfschema/r/lowercase_fs_off.result

raw
1 #
2 # MDEV-33020 The database part is not case sensitive in SP names in PERFORMANCE_SCHEMA
3 #
4 CREATE OR REPLACE DATABASE m33020_DB1;
5 CREATE OR REPLACE DATABASE m33020_db1;
6 CREATE PROCEDURE m33020_DB1.sp() SELECT 'This is m33020_DB1.sp';
7 CREATE PROCEDURE m33020_db1.sp() SELECT 'This is m33020_db1.sp';
8 CALL m33020_DB1.sp();
9 This is m33020_DB1.sp
10 This is m33020_DB1.sp
11 CREATE PROCEDURE m33020_DB1.sp2() SELECT 'This is m33020_DB1.sp2';
12 CALL m33020_db1.sp();
13 This is m33020_db1.sp
14 This is m33020_db1.sp
15 SELECT object_type, object_schema, object_name, count_star, count_statements, sum_rows_sent
16 FROM performance_schema.events_statements_summary_by_program
17 WHERE object_type='procedure' AND LOWER(object_schema)='m33020_db1';
18 object_type object_schema object_name count_star count_statements sum_rows_sent
19 PROCEDURE m33020_DB1 sp 1 1 1
20 PROCEDURE m33020_db1 sp 1 1 1
21 DROP DATABASE m33020_db1;
22 DROP DATABASE m33020_DB1;