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

Queries from I_S.KEY_PERIOD_USAGE do not obey case-sensitivity

    XMLWordPrintable

Details

    Description

      INFORMATION_SCHEMA.PERIODS (and at least some older I_S views, e.g. TABLES) work as expected with case-sensitive collations, but KEY_PERIOD_USAGE does not.

      --source include/have_innodb.inc
      		 
       
      		 
      create table t (a int, b date, c date, period for app(b,c), primary key(a, app without overlaps));
      		 
       
      		 
      set names latin1 collate latin1_bin;
      		 
       
      		 
      select table_schema, table_name, period from information_schema.periods where table_schema = 'TEST';
      		 
      select table_schema, table_name, period_name from information_schema.key_period_usage where table_schema = 'TEST';
      		 
       
      		 
      set names latin1 collate latin1_general_cs;
      		 
       
      		 
      select table_schema, table_name, period from information_schema.periods where table_schema = 'TEST';
      		 
      select table_schema, table_name, period_name from information_schema.key_period_usage where table_schema = 'TEST';
      		 
       
      		 
      # Cleanup
      		 
      drop table t;

      bb-11.3-periods-schema 24018c74fae6e5a93b93c2efefd60bde4ad1488e

      		 
      set names latin1 collate latin1_bin;
      		 
      select table_schema, table_name, period from information_schema.periods where table_schema = 'TEST';
      		 
      table_schema	table_name	period
      		 
      select table_schema, table_name, period_name from information_schema.key_period_usage where table_schema = 'TEST';
      		 
      table_schema	table_name	period_name
      		 
      test	t	app
      		 
      set names latin1 collate latin1_general_cs;
      		 
      select table_schema, table_name, period from information_schema.periods where table_schema = 'TEST';
      		 
      table_schema	table_name	period
      		 
      select table_schema, table_name, period_name from information_schema.key_period_usage where table_schema = 'TEST';
      		 
      table_schema	table_name	period_name
      		 
      test	t	app

      Attachments

        Issue Links

          is caused by

          New Feature - A new feature of the product, which has yet to be developed. MDEV-22597 Add views for periods in information_schema

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed
          is duplicated by

          Bug - A problem which impairs or prevents the functions of the product. MDEV-32504 Search by I_S.KEY_PERIOD_USAGE.CONSTRAINT_NAME does not work

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Activity

            People

              nikitamalyavin Nikita Malyavin
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              3 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.