Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-41801

"performance_schema" is compared case-sensitively in the engine, case-insensitively elsewhere

    XMLWordPrintable

Details

    • Can result in unexpected behaviour

    Description

      With lower_case_table_names=0, the server compares the name "performance_schema" case-insensitively in some places and case-sensitively in others:

      • Case-insensitive: the ACL internal schema registry (ACL_internal_schema_registry::lookup()), is_perfschema_db() (table category, SHOW EVENTS), and mariadb-dump's skip list.
      • Case-sensitive: the performance_schema engine itself (compare_database_names(), pfs_discover_table_names()). It discovers its tables only under the exact name.

      Thus a database named PERFORMANCE_SCHEMA is an ordinary database as far as the engine is concerned, but gets performance_schema treatment everywhere else.

      Let's consistently compare this name case-insensitively to match the information_schema behavior.

      Attachments

        Activity

          People

            serg Sergei Golubchik
            serg Sergei Golubchik
            Votes:
            1 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.