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

CHECK under EMPTY_STRING_IS_NULL reports a misplaced row on partitioned table with virtual column

    XMLWordPrintable

Details

    Description

      --source include/have_partition.inc
       
      CREATE TABLE t1 (b BINARY GENERATED ALWAYS AS ('') VIRTUAL) PARTITION BY KEY(b) PARTITIONS 2;
      INSERT INTO t1 () VALUES ();
      FLUSH TABLES;
      SET SQL_MODE= CONCAT(@@sql_mode,',EMPTY_STRING_IS_NULL');
      CHECK TABLE t1;
       
      # Cleanup
      DROP TABLE t1;
      

      10.3 d72038a7

      CHECK TABLE t1;
      Table	Op	Msg_type	Msg_text
      test.t1	check	error	Found a misplaced row
      test.t1	check	error	Partition p1 returned error
      test.t1	check	error	Upgrade required. Please do "REPAIR TABLE `t1`" or dump/reload to fix it!
      

      Reproducible with at least MyISAM and InnoDB on 10.3-10.5.
      The test case is not applicable to 10.2 due to the sql mode.

      Attachments

        Issue Links

          Activity

            People

              pranav.tiwari@mariadb.com Pranav Kumar Tiwari
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:

                Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - Not Specified
                  Not Specified
                  Logged:
                  Time Spent - 1.5h
                  1.5h

                  Git Integration

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