Hi, Alexander, On Dec 14, Alexander Barkov wrote:
something like this:
create database FOO; create database foo; create procedure FOO.sp () select 1; create procedure foo.sp () select 2; call FOO.sp(); call foo.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'; drop database FOO; drop database foo;
Thanks. This script helped. There is a bug indeed. There are even two bugs :)
I reported them as:
- MDEV-33020 The database part is not case sensitive in SP names in PERFORMANCE_SCHEMA (for the problem that you noticed during the review)
- MDEV-33019 The database part is not case sensitive in SP names (for another problem that I found)
Ouch. I didn't expect that :( So the performance_schema was in fact right in my test, it actually was one sp called twice.
I suggest we fix both MDEV-33020 and MDEV-33019 should be fixed starting from 10.4.
Sure thing. Thanks. Regards, Sergei Chief Architect, MariaDB Server and security@mariadb.org