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

PARTITION BY ... COLUMNS allows unsupported data types

    XMLWordPrintable

Details

    Description

      According to the manual, float and some other data types are not supported:
      http://dev.mysql.com/doc/refman/5.6/en/partitioning-columns.html

      CREATE TABLE t1 (f float) PARTITION BY LIST COLUMNS (f) (PARTITION pnull VALUES IN (NULL));
      

      MariaDB [test]> CREATE TABLE t1 (f float) PARTITION BY LIST COLUMNS (f) (PARTITION pnull VALUES IN (NULL));
      Query OK, 0 rows affected (0.40 sec)
       
      MariaDB [test]> show create table t1 \G
      *************************** 1. row ***************************
             Table: t1
      Create Table: CREATE TABLE `t1` (
        `f` float DEFAULT NULL
      ) ENGINE=InnoDB DEFAULT CHARSET=latin1
       PARTITION BY LIST  COLUMNS(f)
      (PARTITION pnull VALUES IN (NULL) ENGINE = InnoDB)
      1 row in set (0.00 sec)
       
      MariaDB [test]> insert into t1 values (null);
      Query OK, 1 row affected (0.10 sec)
      

      Same for some other data types.

      Attachments

        Activity

          People

            Unassigned Unassigned
            elenst Elena Stepanova
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

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