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

Error on partitioning by virtual column

    XMLWordPrintable

    Details

      Description

      10.1 commit 31a19683f5289f08439b848da23a28f49ff0accc
      – 10.1.33-MariaDB-debug
      10.2 commit 87af52d7dd733e71fc7a9e39b882a4fd44f41fec
      – 10.2.15-MariaDB-debug
      10.3 commit 8fce4065e542ad64438d45f60421241dd383815f
      – 10.3.7-MariaDB-debug

      CREATE TABLE test . t1 ( c1 INT, c2 INT AS (c1) VIRTUAL );
      INSERT INTO test . t1 (c1) VALUES(1);
      COMMIT ;
      ALTER TABLE test . t1 ENGINE = InnoDB PARTITION BY KEY(c2) PARTITIONS 4 ;
      SHOW CREATE TABLE t1;
      Table   Create Table
      t1      CREATE TABLE `t1` (
        `c1` int(11) DEFAULT NULL,
        `c2` int(11) AS (c1) VIRTUAL
      ) ENGINE=InnoDB DEFAULT CHARSET=latin1
      /*!50100 PARTITION BY KEY (c2)
      PARTITIONS 4 */
      CHECK TABLE t1 EXTENDED;
      

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

      The same test works well for c2 INT AS (c1) PERSISTENT.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              serg Sergei Golubchik
              Reporter:
              mleich Matthias Leich
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: