Debian Codegraph @

mysql-test/suite/perfschema/t/lowercase_fs_off.test

raw
1 #
2 # Specific tests for case sensitive file systems
3 # i.e. lower_case_filesystem=OFF
4 #
5 --source include/have_case_sensitive_file_system.inc
6 --source include/have_perfschema.inc
7 --source include/not_embedded.inc
8
9 --echo #
10 --echo # MDEV-33020 The database part is not case sensitive in SP names in PERFORMANCE_SCHEMA
11 --echo #
12
13 # the m33020_ prefix was added to the database names
14 # to temporarily address MDEV-34817
15
16 CREATE OR REPLACE DATABASE m33020_DB1;
17 CREATE OR REPLACE DATABASE m33020_db1;
18 CREATE PROCEDURE m33020_DB1.sp() SELECT 'This is m33020_DB1.sp';
19 CREATE PROCEDURE m33020_db1.sp() SELECT 'This is m33020_db1.sp';
20 CALL m33020_DB1.sp();
21 # This is needed to reset the SP cache (a MDEV-33019 workaround)
22 CREATE PROCEDURE m33020_DB1.sp2() SELECT 'This is m33020_DB1.sp2';
23 CALL m33020_db1.sp();
24
25 SELECT object_type, object_schema, object_name, count_star, count_statements, sum_rows_sent
26 FROM performance_schema.events_statements_summary_by_program
27 WHERE object_type='procedure' AND LOWER(object_schema)='m33020_db1';
28
29 DROP DATABASE m33020_db1;
30 DROP DATABASE m33020_DB1;