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

misleading error when partitioning a table with an utf8 space after backticks on partition names

    XMLWordPrintable

Details

    • Bug
    • Status: Confirmed (View Workflow)
    • Minor
    • Resolution: Unresolved
    • 5.5, 10.0, 10.1, 10.1.33, 10.2.14, 10.2, 10.3
    • 10.4
    • Parser, Server

    Description

      mysql -A
      Welcome to the MariaDB monitor.  Commands end with ; or \g.
      Your MariaDB connection id is 13
      Server version: 10.1.33-MariaDB MariaDB Server
       
      Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
       
      Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
       
      MariaDB [(none)]> use test
      Database changed
      MariaDB [test]> CREATE TABLE actor_backticks_around_p1 (   actor_id smallint(5) unsigned NOT NULL AUTO_INCREMENT,   first_name varchar(45) NOT NULL,   last_name varchar(45) NOT NULL,   last_update timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),   PRIMARY KEY (actor_id,last_update),   KEY idx_actor_last_name (last_name),   KEY last_update (last_update) ) ENGINE=InnoDB DEFAULT CHARSET=utf8  PARTITION BY RANGE (unix_timestamp(last_update)) (PARTITION p0  VALUES LESS THAN (1522900800) ENGINE = InnoDB,  PARTITION `p1`  VALUES LESS THAN (1522987200) ENGINE = InnoDB);
      ERROR 1479 (HY000): Syntax error: RANGE PARTITIONING requires definition of VALUES LESS THAN for each partition
      

      Can be reproduced on 10.1 and 10.2
      Will work fine if no backticks around 'p1'

      Attachments

        Activity

          People

            serg Sergei Golubchik
            rpizzi Rick Pizzi
            Votes:
            0 Vote for this issue
            Watchers:
            3 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.