! f_char1 CHAR(20),
! f_char2 CHAR(20),
! f_charbig VARCHAR(1000)
! )
! PARTITION BY HASH(f_int1) PARTITIONS "GARBAGE";
! ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '"GARBAGE"' at line 8
! CREATE TABLE t1 (
! f_int1 INTEGER,
! f_int2 INTEGER,
! f_char1 CHAR(20),
! f_char2 CHAR(20),
! f_charbig VARCHAR(1000)
! )
! PARTITION BY RANGE(f_int1) SUBPARTITION BY HASH(f_int1)
! SUBPARTITIONS "GARBAGE"
! (PARTITION part1 VALUES LESS THAN (10),
! PARTITION part2 VALUES LESS THAN (2147483646));
! ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '"GARBAGE"
! (PARTITION part1 VALUES LESS THAN (10),
! PARTITION part2 VALUES LESS TH' at line 9
! # 4.2.6 (negative) partition/subpartition numbers per @variables
! SET @aux = 5;
! CREATE TABLE t1 (
! f_int1 INTEGER,
! f_int2 INTEGER,
! f_char1 CHAR(20),
! f_char2 CHAR(20),
! f_charbig VARCHAR(1000)
! )
! PARTITION BY HASH(f_int1) PARTITIONS @aux;
! ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '@aux' at line 8
! CREATE TABLE t1 (
! f_int1 INTEGER,
! f_int2 INTEGER,
! f_char1 CHAR(20),
! f_char2 CHAR(20),
! f_charbig VARCHAR(1000)
! )
! PARTITION BY RANGE(f_int1) SUBPARTITION BY HASH(f_int1)
! SUBPARTITIONS @aux = 5
! (PARTITION part1 VALUES LESS THAN (10),
! PARTITION part2 VALUES LESS THAN (2147483646));
! ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '@aux = 5
! (PARTITION part1 VALUES LESS THAN (10),
! PARTITION part2 VALUES LESS THA' at line 9
! #------------------------------------------------------------------------
! # 4.3 Mixups of assigned partition/subpartition numbers and names
! #------------------------------------------------------------------------
! # 4.3.1 (positive) number of partition/subpartition
! #                         = number of named partition/subpartition
! CREATE TABLE t1 (
! f_int1 INTEGER,
! f_int2 INTEGER,
! f_char1 CHAR(20),
! f_char2 CHAR(20),
! f_charbig VARCHAR(1000)
! )
! PARTITION BY HASH(f_int1) PARTITIONS 2 ( PARTITION part1, PARTITION part2 ) ;
! create_command
! SHOW CREATE TABLE t1;
! Table Create Table
! t1    CREATE TABLE `t1` (
!   `f_int1` int(11) DEFAULT NULL,
!   `f_int2` int(11) DEFAULT NULL,
!   `f_char1` char(20) DEFAULT NULL,
!   `f_char2` char(20) DEFAULT NULL,
!   `f_charbig` varchar(1000) DEFAULT NULL
! ) ENGINE=InnoDB DEFAULT CHARSET=latin1 /*!50100 PARTITION BY HASH (f_int1) (PARTITION part1 ENGINE = InnoDB, PARTITION part2 ENGINE = InnoDB) */
! 
! DROP TABLE t1;
! CREATE TABLE t1 (
! f_int1 INTEGER,
! f_int2 INTEGER,
! f_char1 CHAR(20),
! f_char2 CHAR(20),
! f_charbig VARCHAR(1000)
! )
! PARTITION BY RANGE(f_int1) PARTITIONS 2
! SUBPARTITION BY HASH(f_int1) SUBPARTITIONS 2
! ( PARTITION part1 VALUES LESS THAN (1000)
! (SUBPARTITION subpart11, SUBPARTITION subpart12),
! PARTITION part2 VALUES LESS THAN (2147483646)
! (SUBPARTITION subpart21, SUBPARTITION subpart22)
! );
! create_command
! SHOW CREATE TABLE t1;
! Table Create Table
! t1    CREATE TABLE `t1` (
!   `f_int1` int(11) DEFAULT NULL,
!   `f_int2` int(11) DEFAULT NULL,
!   `f_char1` char(20) DEFAULT NULL,
!   `f_char2` char(20) DEFAULT NULL,
!   `f_charbig` varchar(1000) DEFAULT NULL
! ) ENGINE=InnoDB DEFAULT CHARSET=latin1 /*!50100 PARTITION BY RANGE (f_int1) SUBPARTITION BY HASH (f_int1) (PARTITION part1 VALUES LESS THAN (1000) (SUBPARTITION subpart11 ENGINE = InnoDB, SUBPARTITION subpart12 ENGINE = InnoDB), PARTITION part2 VALUES LESS THAN (2147483646) (SUBPARTITION subpart21 ENGINE = InnoDB, SUBPARTITION subpart22 ENGINE = InnoDB)) */
! 
! DROP TABLE t1;
! # 4.3.2 (positive) number of partition/subpartition ,
! #                  0 (= no) named partition/subpartition
! #                  already checked above
! # 4.3.3 (negative) number of partitions/subpartitions
! #                         > number of named partitions/subpartitions
! CREATE TABLE t1 (
! f_int1 INTEGER,
! f_int2 INTEGER,
! f_char1 CHAR(20),
! f_char2 CHAR(20),
! f_charbig VARCHAR(1000)
! )
! PARTITION BY HASH(f_int1) PARTITIONS 2 ( PARTITION part1 ) ;
! ERROR 42000: Wrong number of partitions defined, mismatch with previous setting near ')' at line 8
! CREATE TABLE t1 (
! f_int1 INTEGER,
! f_int2 INTEGER,
! f_char1 CHAR(20),
! f_char2 CHAR(20),
! f_charbig VARCHAR(1000)
! )
! PARTITION BY RANGE(f_int1)
! SUBPARTITION BY HASH(f_int1) SUBPARTITIONS 2
! ( PARTITION part1 VALUES LESS THAN (1000)
! (SUBPARTITION subpart11 ),
! PARTITION part2 VALUES LESS THAN (2147483646)
! (SUBPARTITION subpart21, SUBPARTITION subpart22)
! );
! ERROR 42000: Wrong number of subpartitions defined, mismatch with previous setting near '),
! PARTITION part2 VALUES LESS THAN (2147483646)
! (SUBPARTITION subpart21, SUBPAR' at line 11
! CREATE TABLE t1 (
! f_int1 INTEGER,
! f_int2 INTEGER,
! f_char1 CHAR(20),
! f_char2 CHAR(20),
! f_charbig VARCHAR(1000)
! )
! PARTITION BY RANGE(f_int1)
! SUBPARTITION BY HASH(f_int1) SUBPARTITIONS 2
! ( PARTITION part1 VALUES LESS THAN (1000)
! (SUBPARTITION subpart11, SUBPARTITION subpart12),
! PARTITION part2 VALUES LESS THAN (2000)
! (SUBPARTITION subpart21 ),
! PARTITION part3 VALUES LESS THAN (2147483646)
! (SUBPARTITION subpart31, SUBPARTITION subpart32)
! );
! ERROR 42000: Wrong number of subpartitions defined, mismatch with previous setting near '),
! PARTITION part3 VALUES LESS THAN (2147483646)
! (SUBPARTITION subpart31, SUBPAR' at line 13
! CREATE TABLE t1 (
! f_int1 INTEGER,
! f_int2 INTEGER,
! f_char1 CHAR(20),
! f_char2 CHAR(20),
! f_charbig VARCHAR(1000)
! )
! PARTITION BY RANGE(f_int1) PARTITIONS 2
! SUBPARTITION BY HASH(f_int1) SUBPARTITIONS 2
! ( PARTITION part1 VALUES LESS THAN (1000)
! (SUBPARTITION subpart11, SUBPARTITION subpart12),
! PARTITION part2 VALUES LESS THAN (2147483646)
! (SUBPARTITION subpart21                        )
! );
! ERROR 42000: Wrong number of subpartitions defined, mismatch with previous setting near ')
! )' at line 13
! # 4.3.4 (negative) number of partitions < number of named partitions
! CREATE TABLE t1 (
! f_int1 INTEGER,
! f_int2 INTEGER,
! f_char1 CHAR(20),
! f_char2 CHAR(20),
! f_charbig VARCHAR(1000)
! )
! PARTITION BY HASH(f_int1) PARTITIONS 1 ( PARTITION part1, PARTITION part2 ) ;
! ERROR 42000: Wrong number of partitions defined, mismatch with previous setting near ')' at line 8
! CREATE TABLE t1 (
! f_int1 INTEGER,
! f_int2 INTEGER,
! f_char1 CHAR(20),
! f_char2 CHAR(20),
! f_charbig VARCHAR(1000)
! )
! PARTITION BY RANGE(f_int1)
! SUBPARTITION BY HASH(f_int1) SUBPARTITIONS 1
! ( PARTITION part1 VALUES LESS THAN (1000)
! (SUBPARTITION subpart11, SUBPARTITION subpart12),
! PARTITION part2 VALUES LESS THAN (2147483646)
! (SUBPARTITION subpart21, SUBPARTITION subpart22)
! );
! ERROR 42000: Wrong number of subpartitions defined, mismatch with previous setting near '),
! PARTITION part2 VALUES LESS THAN (2147483646)
! (SUBPARTITION subpart21, SUBPAR' at line 11
! CREATE TABLE t1 (
! f_int1 INTEGER,
! f_int2 INTEGER,
! f_char1 CHAR(20),
! f_char2 CHAR(20),
! f_charbig VARCHAR(1000)
! )
! PARTITION BY RANGE(f_int1)
! SUBPARTITION BY HASH(f_int1) SUBPARTITIONS 1
! ( PARTITION part1 VALUES LESS THAN (1000)
! (SUBPARTITION subpart11, SUBPARTITION subpart12),
! PARTITION part2 VALUES LESS THAN (2000)
! (SUBPARTITION subpart21                        ),
! PARTITION part3 VALUES LESS THAN (2147483646)
! (SUBPARTITION subpart31, SUBPARTITION subpart32)
! );
! ERROR 42000: Wrong number of subpartitions defined, mismatch with previous setting near '),
! PARTITION part2 VALUES LESS THAN (2000)
! (SUBPARTITION subpart21              ' at line 11
! CREATE TABLE t1 (
! f_int1 INTEGER,
! f_int2 INTEGER,
! f_char1 CHAR(20),
! f_char2 CHAR(20),
! f_charbig VARCHAR(1000)
! )
! PARTITION BY RANGE(f_int1)
! SUBPARTITION BY HASH(f_int1) SUBPARTITIONS 1
! ( PARTITION part1 VALUES LESS THAN (1000)
! (SUBPARTITION subpart11, SUBPARTITION subpart12),
! PARTITION part2 VALUES LESS THAN (2147483646)
! (SUBPARTITION subpart21, SUBPARTITION subpart22)
! );
! ERROR 42000: Wrong number of subpartitions defined, mismatch with previous setting near '),
! PARTITION part2 VALUES LESS THAN (2147483646)
! (SUBPARTITION subpart21, SUBPAR' at line 11
! 
! #========================================================================
! #  5. Checks of logical partition/subpartition name
! #     file name clashes during CREATE TABLE
! #========================================================================
! DROP TABLE IF EXISTS t1;
! #------------------------------------------------------------------------
! #  5.1 (negative) A partition/subpartition name used more than once
! #------------------------------------------------------------------------
! #  5.1.1 duplicate partition name
! CREATE TABLE t1 (
! f_int1 INTEGER,
! f_int2 INTEGER,
! f_char1 CHAR(20),
! f_char2 CHAR(20),
! f_charbig VARCHAR(1000)
! )
! PARTITION BY HASH(f_int1) (PARTITION part1, PARTITION part1);
! ERROR HY000: Duplicate partition name part1
! #  5.1.2 duplicate subpartition name
! CREATE TABLE t1 (
! f_int1 INTEGER,
! f_int2 INTEGER,
! f_char1 CHAR(20),
! f_char2 CHAR(20),
! f_charbig VARCHAR(1000)
! )
! PARTITION BY RANGE(f_int1)
! SUBPARTITION BY HASH(f_int1)
! ( PARTITION part1 VALUES LESS THAN (1000)
! (SUBPARTITION subpart11, SUBPARTITION subpart11)
! );
! ERROR HY000: Duplicate partition name subpart11
! DROP VIEW  IF EXISTS v1;
! DROP TABLE IF EXISTS t1;
! DROP TABLE IF EXISTS t0_aux;
! DROP TABLE IF EXISTS t0_definition;
! DROP TABLE IF EXISTS t0_template;
--- 928,935 ----
  )
  PARTITION BY HASH(f_int1) PARTITIONS 0;
  ERROR HY000: Number of partitions = 0 is not an allowed value
! #      The last command got an unexepected error response.
! #      Expected/handled SQL codes are 0,1064,1487,1492
! 
! #      SQL code we got was:   1501
! #      Sorry, have to abort.
-------------------------------------------------------
Please follow the instructions outlined at
http://www.mysql.com/doc/en/Reporting_mysqltest_bugs.html
to find the reason to this problem and how to report this.


Stopping All Servers
Restoring snapshot of databases
Resuming Tests

partition_syntax_myisam        [ fail ]

Errors are (from /home/greno/redhat/tmp/mysql-5.1.20-beta/mysql-release-5.1.20-beta/mysql-test/var/log/mysqltest-time) :
mysqltest: In included file "./suite/parts/inc/partition_syntax_1.inc": Result length mismatch
(the last lines may be the most important ones)
Below are the diffs between actual and expected results:
-------------------------------------------------------
*** /home/greno/redhat/tmp/mysql-5.1.20-beta/mysql-release-5.1.20-beta/mysql-test/suite/parts/r/partition_syntax_myisam.result Thu Jun 28 13:18:53 2007
--- /home/greno/redhat/tmp/mysql-5.1.20-beta/mysql-release-5.1.20-beta/mysql-test/suite/parts/r/partition_syntax_myisam.reject Wed Jul 11 15:23:27 2007
***************
*** 1010,1840 ****
  )
  PARTITION BY HASH(f_int1) PARTITIONS 0;
  ERROR HY000: Number of partitions = 0 is not an allowed value
! CREATE TABLE t1 (
! f_int1 INTEGER,
! f_int2 INTEGER,
! f_char1 CHAR(20),
! f_char2 CHAR(20),
! f_charbig VARCHAR(1000)
! )
! PARTITION BY RANGE(f_int1) SUBPARTITION BY HASH(f_int1)
! SUBPARTITIONS 0
! (PARTITION part1 VALUES LESS THAN (10),
! PARTITION part2 VALUES LESS THAN (2147483646));
! ERROR HY000: Number of subpartitions = 0 is not an allowed value
! CREATE TABLE t1 (
! f_int1 INTEGER,
! f_int2 INTEGER,
! f_char1 CHAR(20),
! f_char2 CHAR(20),
! f_charbig VARCHAR(1000)
! )
! PARTITION BY HASH(f_int1) PARTITIONS -1;
! ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-1' at line 8
! CREATE TABLE t1 (
! f_int1 INTEGER,
! f_int2 INTEGER,
! f_char1 CHAR(20),
! f_char2 CHAR(20),
! f_charbig VARCHAR(1000)
! )
! PARTITION BY RANGE(f_int1) SUBPARTITION BY HASH(f_int1)
! SUBPARTITIONS -1
! (PARTITION part1 VALUES LESS THAN (10),
! PARTITION part2 VALUES LESS THAN (2147483646));
! ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-1
! (PARTITION part1 VALUES LESS THAN (10),
! PARTITION part2 VALUES LESS THAN (214' at line 9
! CREATE TABLE t1 (
! f_int1 INTEGER,
! f_int2 INTEGER,
! f_char1 CHAR(20),
! f_char2 CHAR(20),
! f_charbig VARCHAR(1000)
! )
! PARTITION BY HASH(f_int1) PARTITIONS 1000000;
! ERROR HY000: Too many partitions (including subpartitions) were defined
! CREATE TABLE t1 (
! f_int1 INTEGER,
! f_int2 INTEGER,
! f_char1 CHAR(20),
! f_char2 CHAR(20),
! f_charbig VARCHAR(1000)
! )
! PARTITION BY RANGE(f_int1) SUBPARTITION BY HASH(f_int1)
! SUBPARTITIONS 1000000
! (PARTITION part1 VALUES LESS THAN (10),
! PARTITION part2 VALUES LESS THAN (2147483646));
! ERROR HY000: Too many partitions (including subpartitions) were defined
! # 4.2.2 partition/subpartition numbers DECIMAL notation
! CREATE TABLE t1 (
! f_int1 INTEGER,
! f_int2 INTEGER,
! f_char1 CHAR(20),
! f_char2 CHAR(20),
! f_charbig VARCHAR(1000)
! )
! PARTITION BY HASH(f_int1) PARTITIONS 2.0;
! ERROR 42000: Only integers allowed as number here near '2.0' at line 8
! CREATE TABLE t1 (
! f_int1 INTEGER,
! f_int2 INTEGER,
! f_char1 CHAR(20),
! f_char2 CHAR(20),
! f_charbig VARCHAR(1000)
! )
! PARTITION BY RANGE(f_int1) SUBPARTITION BY HASH(f_int1)
! SUBPARTITIONS 2.0
! (PARTITION part1 VALUES LESS THAN (10),
! PARTITION part2 VALUES LESS THAN (2147483646));
! ERROR 42000: Only integers allowed as number here near '2.0
! (PARTITION part1 VALUES LESS THAN (10),
! PARTITION part2 VALUES LESS THAN (21' at line 9
! CREATE TABLE t1 (
! f_int1 INTEGER,
! f_int2 INTEGER,
! f_char1 CHAR(20),
! f_char2 CHAR(20),
! f_charbig VARCHAR(1000)
! )
! PARTITION BY HASH(f_int1) PARTITIONS -2.0;
! ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-2.0' at line 8
! CREATE TABLE t1 (
! f_int1 INTEGER,
! f_int2 INTEGER,
! f_char1 CHAR(20),
! f_char2 CHAR(20),
! f_charbig VARCHAR(1000)
! )
! PARTITION BY RANGE(f_int1) SUBPARTITION BY HASH(f_int1)
! SUBPARTITIONS -2.0
! (PARTITION part1 VALUES LESS THAN (10),
! PARTITION part2 VALUES LESS THAN (2147483646));
! ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-2.0
! (PARTITION part1 VALUES LESS THAN (10),
! PARTITION part2 VALUES LESS THAN (2' at line 9
! CREATE TABLE t1 (
! f_int1 INTEGER,
! f_int2 INTEGER,
! f_char1 CHAR(20),
! f_char2 CHAR(20),
! f_charbig VARCHAR(1000)
! )
! PARTITION BY HASH(f_int1) PARTITIONS 0.0;
! ERROR 42000: Only integers allowed as number here near '0.0' at line 8
! CREATE TABLE t1 (
! f_int1 INTEGER,
! f_int2 INTEGER,
! f_char1 CHAR(20),
! f_char2 CHAR(20),
! f_charbig VARCHAR(1000)
! )
! PARTITION BY RANGE(f_int1) SUBPARTITION BY HASH(f_int1)
! SUBPARTITIONS 0.0
! (PARTITION part1 VALUES LESS THAN (10),
! PARTITION part2 VALUES LESS THAN (2147483646));
! ERROR 42000: Only integers allowed as number here near '0.0
! (PARTITION part1 VALUES LESS THAN (10),
! PARTITION part2 VALUES LESS THAN (21' at line 9
! CREATE TABLE t1 (
! f_int1 INTEGER,
! f_int2 INTEGER,
! f_char1 CHAR(20),
! f_char2 CHAR(20),
! f_charbig VARCHAR(1000)
! )
! PARTITION BY HASH(f_int1) PARTITIONS 999999999999999999999999999999.999999999999999999999999999999;
! ERROR 42000: Only integers allowed as number here near '999999999999999999999999999999.999999999999999999999999999999' at line 8
! CREATE TABLE t1 (
! f_int1 INTEGER,
! f_int2 INTEGER,
! f_char1 CHAR(20),
! f_char2 CHAR(20),
! f_charbig VARCHAR(1000)
! )
! PARTITION BY RANGE(f_int1) SUBPARTITION BY HASH(f_int1)
! SUBPARTITIONS 999999999999999999999999999999.999999999999999999999999999999
! (PARTITION part1 VALUES LESS THAN (10),
! PARTITION part2 VALUES LESS THAN (2147483646));
! ERROR 42000: Only integers allowed as number here near '999999999999999999999999999999.999999999999999999999999999999
! (PARTITION part1 V' at line 9
! CREATE TABLE t1 (
! f_int1 INTEGER,
! f_int2 INTEGER,
! f_char1 CHAR(20),
! f_char2 CHAR(20),
! f_charbig VARCHAR(1000)
! )
! PARTITION BY HASH(f_int1) PARTITIONS 0.000000000000000000000000000001;
! ERROR 42000: Only integers allowed as number here near '0.000000000000000000000000000001' at line 8
! CREATE TABLE t1 (
! f_int1 INTEGER,
! f_int2 INTEGER,
! f_char1 CHAR(20),
! f_char2 CHAR(20),
! f_charbig VARCHAR(1000)
! )
! PARTITION BY RANGE(f_int1) SUBPARTITION BY HASH(f_int1)
! SUBPARTITIONS 0.000000000000000000000000000001
! (PARTITION part1 VALUES LESS THAN (10),
! PARTITION part2 VALUES LESS THAN (2147483646));
! ERROR 42000: Only integers allowed as number here near '0.000000000000000000000000000001
! (PARTITION part1 VALUES LESS THAN (10),
! PARTITI' at line 9
! # 4.2.3 partition/subpartition numbers FLOAT notation
! CREATE TABLE t1 (
! f_int1 INTEGER,
! f_int2 INTEGER,
! f_char1 CHAR(20),
! f_char2 CHAR(20),
! f_charbig VARCHAR(1000)
! )
! PARTITION BY HASH(f_int1) PARTITIONS 2.0E+0;
! ERROR 42000: Only integers allowed as number here near '2.0E+0' at line 8
! CREATE TABLE t1 (
! f_int1 INTEGER,
! f_int2 INTEGER,
! f_char1 CHAR(20),
! f_char2 CHAR(20),
! f_charbig VARCHAR(1000)
! )
! PARTITION BY RANGE(f_int1) SUBPARTITION BY HASH(f_int1)
! SUBPARTITIONS 2.0E+0
! (PARTITION part1 VALUES LESS THAN (10),
! PARTITION part2 VALUES LESS THAN (2147483646));
! ERROR 42000: Only integers allowed as number here near '2.0E+0
! (PARTITION part1 VALUES LESS THAN (10),
! PARTITION part2 VALUES LESS THAN ' at line 9
! CREATE TABLE t1 (
! f_int1 INTEGER,
! f_int2 INTEGER,
! f_char1 CHAR(20),
! f_char2 CHAR(20),
! f_charbig VARCHAR(1000)
! )
! PARTITION BY HASH(f_int1) PARTITIONS -2.0E+0;
! ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-2.0E+0' at line 8
! CREATE TABLE t1 (
! f_int1 INTEGER,
! f_int2 INTEGER,
! f_char1 CHAR(20),
! f_char2 CHAR(20),
! f_charbig VARCHAR(1000)
! )
! PARTITION BY RANGE(f_int1) SUBPARTITION BY HASH(f_int1)
! SUBPARTITIONS -2.0E+0
! (PARTITION part1 VALUES LESS THAN (10),
! PARTITION part2 VALUES LESS THAN (2147483646));
! ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-2.0E+0
! (PARTITION part1 VALUES LESS THAN (10),
! PARTITION part2 VALUES LESS THAN' at line 9
! CREATE TABLE t1 (
! f_int1 INTEGER,
! f_int2 INTEGER,
! f_char1 CHAR(20),
! f_char2 CHAR(20),
! f_charbig VARCHAR(1000)
! )
! PARTITION BY HASH(f_int1) PARTITIONS 0.0E+300;
! ERROR 42000: Only integers allowed as number here near '0.0E+300' at line 8
! CREATE TABLE t1 (
! f_int1 INTEGER,
! f_int2 INTEGER,
! f_char1 CHAR(20),
! f_char2 CHAR(20),
! f_charbig VARCHAR(1000)
! )
! PARTITION BY RANGE(f_int1) SUBPARTITION BY HASH(f_int1)
! SUBPARTITIONS 0.0E+300
! (PARTITION part1 VALUES LESS THAN (10),
! PARTITION part2 VALUES LESS THAN (2147483646));
! ERROR 42000: Only integers allowed as number here near '0.0E+300
! (PARTITION part1 VALUES LESS THAN (10),
! PARTITION part2 VALUES LESS THA' at line 9
! # 4.2.4 partition/subpartition numbers STRING notation
! CREATE TABLE t1 (
! f_int1 INTEGER,
! f_int2 INTEGER,
! f_char1 CHAR(20),
! f_char2 CHAR(20),
! f_charbig VARCHAR(1000)
! )
! PARTITION BY HASH(f_int1) PARTITIONS '2';
! ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''2'' at line 8
! CREATE TABLE t1 (
! f_int1 INTEGER,
! f_int2 INTEGER,
! f_char1 CHAR(20),
! f_char2 CHAR(20),
! f_charbig VARCHAR(1000)
! )
! PARTITION BY RANGE(f_int1) SUBPARTITION BY HASH(f_int1)
! SUBPARTITIONS '2'
! (PARTITION part1 VALUES LESS THAN (10),
! PARTITION part2 VALUES LESS THAN (2147483646));
! ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''2'
! (PARTITION part1 VALUES LESS THAN (10),
! PARTITION part2 VALUES LESS THAN (21' at line 9
! CREATE TABLE t1 (
! f_int1 INTEGER,
! f_int2 INTEGER,
! f_char1 CHAR(20),
! f_char2 CHAR(20),
! f_charbig VARCHAR(1000)
! )
! PARTITION BY HASH(f_int1) PARTITIONS '2.0';
! ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''2.0'' at line 8
! CREATE TABLE t1 (
! f_int1 INTEGER,
! f_int2 INTEGER,
! f_char1 CHAR(20),
! f_char2 CHAR(20),
! f_charbig VARCHAR(1000)
! )
! PARTITION BY RANGE(f_int1) SUBPARTITION BY HASH(f_int1)
! SUBPARTITIONS '2.0'
! (PARTITION part1 VALUES LESS THAN (10),
! PARTITION part2 VALUES LESS THAN (2147483646));
! ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''2.0'
! (PARTITION part1 VALUES LESS THAN (10),
! PARTITION part2 VALUES LESS THAN (' at line 9
! CREATE TABLE t1 (
! f_int1 INTEGER,
! f_int2 INTEGER,
! f_char1 CHAR(20),
! f_char2 CHAR(20),
! f_charbig VARCHAR(1000)
! )
! PARTITION BY HASH(f_int1) PARTITIONS '0.2E+1';
! ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''0.2E+1'' at line 8
! CREATE TABLE t1 (
! f_int1 INTEGER,
! f_int2 INTEGER,
! f_char1 CHAR(20),
! f_char2 CHAR(20),
! f_charbig VARCHAR(1000)
! )
! PARTITION BY RANGE(f_int1) SUBPARTITION BY HASH(f_int1)
! SUBPARTITIONS '0.2E+1'
! (PARTITION part1 VALUES LESS THAN (10),
! PARTITION part2 VALUES LESS THAN (2147483646));
! ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''0.2E+1'
! (PARTITION part1 VALUES LESS THAN (10),
! PARTITION part2 VALUES LESS THA' at line 9
! CREATE TABLE t1 (
! f_int1 INTEGER,
! f_int2 INTEGER,
! f_char1 CHAR(20),
! f_char2 CHAR(20),
! f_charbig VARCHAR(1000)
! )
! PARTITION BY HASH(f_int1) PARTITIONS '2A';
! ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''2A'' at line 8
! CREATE TABLE t1 (
! f_int1 INTEGER,
! f_int2 INTEGER,
! f_char1 CHAR(20),
! f_char2 CHAR(20),
! f_charbig VARCHAR(1000)
! )
! PARTITION BY RANGE(f_int1) SUBPARTITION BY HASH(f_int1)
! SUBPARTITIONS '2A'
! (PARTITION part1 VALUES LESS THAN (10),
! PARTITION part2 VALUES LESS THAN (2147483646));
! ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''2A'
! (PARTITION part1 VALUES LESS THAN (10),
! PARTITION part2 VALUES LESS THAN (2' at line 9
! CREATE TABLE t1 (
! f_int1 INTEGER,
! f_int2 INTEGER,
! f_char1 CHAR(20),
! f_char2 CHAR(20),
! f_charbig VARCHAR(1000)
! )
! PARTITION BY HASH(f_int1) PARTITIONS 'A2';
! ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''A2'' at line 8
! CREATE TABLE t1 (
! f_int1 INTEGER,
! f_int2 INTEGER,
! f_char1 CHAR(20),
! f_char2 CHAR(20),
! f_charbig VARCHAR(1000)
! )
! PARTITION BY RANGE(f_int1) SUBPARTITION BY HASH(f_int1)
! SUBPARTITIONS 'A2'
! (PARTITION part1 VALUES LESS THAN (10),
! PARTITION part2 VALUES LESS THAN (2147483646));
! ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''A2'
! (PARTITION part1 VALUES LESS THAN (10),
! PARTITION part2 VALUES LESS THAN (2' at line 9
! CREATE TABLE t1 (
! f_int1 INTEGER,
! f_int2 INTEGER,
! f_char1 CHAR(20),
! f_char2 CHAR(20),
! f_charbig VARCHAR(1000)
! )
! PARTITION BY HASH(f_int1) PARTITIONS '';
! ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '''' at line 8
! CREATE TABLE t1 (
! f_int1 INTEGER,
! f_int2 INTEGER,
! f_char1 CHAR(20),
! f_char2 CHAR(20),
! f_charbig VARCHAR(1000)
! )
! PARTITION BY RANGE(f_int1) SUBPARTITION BY HASH(f_int1)
! SUBPARTITIONS ''
! (PARTITION part1 VALUES LESS THAN (10),
! PARTITION part2 VALUES LESS THAN (2147483646));
! ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '''
! (PARTITION part1 VALUES LESS THAN (10),
! PARTITION part2 VALUES LESS THAN (214' at line 9
! CREATE TABLE t1 (
! f_int1 INTEGER,
! f_int2 INTEGER,
! f_char1 CHAR(20),
! f_char2 CHAR(20),
! f_charbig VARCHAR(1000)
! )
! PARTITION BY HASH(f_int1) PARTITIONS 'GARBAGE';
! ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''GARBAGE'' at line 8
! CREATE TABLE t1 (
! f_int1 INTEGER,
! f_int2 INTEGER,
! f_char1 CHAR(20),
! f_char2 CHAR(20),
! f_charbig VARCHAR(1000)
! )
! PARTITION BY RANGE(f_int1) SUBPARTITION BY HASH(f_int1)
! SUBPARTITIONS 'GARBAGE'
! (PARTITION part1 VALUES LESS THAN (10),
! PARTITION part2 VALUES LESS THAN (2147483646));
! ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''GARBAGE'
! (PARTITION part1 VALUES LESS THAN (10),
! PARTITION part2 VALUES LESS TH' at line 9
! # 4.2.5 partition/subpartition numbers other notations
! CREATE TABLE t1 (
! f_int1 INTEGER,
! f_int2 INTEGER,
! f_char1 CHAR(20),
! f_char2 CHAR(20),
! f_charbig VARCHAR(1000)
! )
! PARTITION BY HASH(f_int1) PARTITIONS 2A;
! ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '2A' at line 8
! CREATE TABLE t1 (
! f_int1 INTEGER,
! f_int2 INTEGER,
! f_char1 CHAR(20),
! f_char2 CHAR(20),
! f_charbig VARCHAR(1000)
! )
! PARTITION BY RANGE(f_int1) SUBPARTITION BY HASH(f_int1)
! SUBPARTITIONS 2A
! (PARTITION part1 VALUES LESS THAN (10),
! PARTITION part2 VALUES LESS THAN (2147483646));
! ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '2A
! (PARTITION part1 VALUES LESS THAN (10),
! PARTITION part2 VALUES LESS THAN (214' at line 9
! CREATE TABLE t1 (
! f_int1 INTEGER,
! f_int2 INTEGER,
! f_char1 CHAR(20),
! f_char2 CHAR(20),
! f_charbig VARCHAR(1000)
! )
! PARTITION BY HASH(f_int1) PARTITIONS A2;
! ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'A2' at line 8
! CREATE TABLE t1 (
! f_int1 INTEGER,
! f_int2 INTEGER,
! f_char1 CHAR(20),
! f_char2 CHAR(20),
! f_charbig VARCHAR(1000)
! )
! PARTITION BY RANGE(f_int1) SUBPARTITION BY HASH(f_int1)
! SUBPARTITIONS A2
! (PARTITION part1 VALUES LESS THAN (10),
! PARTITION part2 VALUES LESS THAN (2147483646));
! ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'A2
! (PARTITION part1 VALUES LESS THAN (10),
! PARTITION part2 VALUES LESS THAN (214' at line 9
! CREATE TABLE t1 (
! f_int1 INTEGER,
! f_int2 INTEGER,
! f_char1 CHAR(20),
! f_char2 CHAR(20),
! f_charbig VARCHAR(1000)
! )
! PARTITION BY HASH(f_int1) PARTITIONS GARBAGE;
! ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'GARBAGE' at line 8
! CREATE TABLE t1 (
! f_int1 INTEGER,
! f_int2 INTEGER,
! f_char1 CHAR(20),
! f_char2 CHAR(20),
! f_charbig VARCHAR(1000)
! )
! PARTITION BY RANGE(f_int1) SUBPARTITION BY HASH(f_int1)
! SUBPARTITIONS GARBAGE
! (PARTITION part1 VALUES LESS THAN (10),
! PARTITION part2 VALUES LESS THAN (2147483646));
! ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'GARBAGE
! (PARTITION part1 VALUES LESS THAN (10),
! PARTITION part2 VALUES LESS THAN' at line 9
! CREATE TABLE t1 (
! f_int1 INTEGER,
! f_int2 INTEGER,
! f_char1 CHAR(20),
! f_char2 CHAR(20),
! f_charbig VARCHAR(1000)
! )
! PARTITION BY HASH(f_int1) PARTITIONS "2";
! ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '"2"' at line 8
! CREATE TABLE t1 (
! f_int1 INTEGER,
! f_int2 INTEGER,
! f_char1 CHAR(20),
! f_char2 CHAR(20),
! f_charbig VARCHAR(1000)
! )
! PARTITION BY RANGE(f_int1) SUBPARTITION BY HASH(f_int1)
! SUBPARTITIONS "2"
! (PARTITION part1 VALUES LESS THAN (10),
! PARTITION part2 VALUES LESS THAN (2147483646));
! ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '"2"
! (PARTITION part1 VALUES LESS THAN (10),
! PARTITION part2 VALUES LESS THAN (21' at line 9
! CREATE TABLE t1 (
! f_int1 INTEGER,
! f_int2 INTEGER,
! f_char1 CHAR(20),
! f_char2 CHAR(20),
! f_charbig VARCHAR(1000)
! )
! PARTITION BY HASH(f_int1) PARTITIONS "2A";
! ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '"2A"' at line 8
! CREATE TABLE t1 (
! f_int1 INTEGER,
! f_int2 INTEGER,
! f_char1 CHAR(20),
! f_char2 CHAR(20),
! f_charbig VARCHAR(1000)
! )
! PARTITION BY RANGE(f_int1) SUBPARTITION BY HASH(f_int1)
! SUBPARTITIONS "2A"
! (PARTITION part1 VALUES LESS THAN (10),
! PARTITION part2 VALUES LESS THAN (2147483646));
! ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '"2A"
! (PARTITION part1 VALUES LESS THAN (10),
! PARTITION part2 VALUES LESS THAN (2' at line 9
! CREATE TABLE t1 (
! f_int1 INTEGER,
! f_int2 INTEGER,
! f_char1 CHAR(20),
! f_char2 CHAR(20),
! f_charbig VARCHAR(1000)
! )
! PARTITION BY HASH(f_int1) PARTITIONS "A2";
! ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '"A2"' at line 8
! CREATE TABLE t1 (
! f_int1 INTEGER,
! f_int2 INTEGER,
! f_char1 CHAR(20),
! f_char2 CHAR(20),
! f_charbig VARCHAR(1000)
! )
! PARTITION BY RANGE(f_int1) SUBPARTITION BY HASH(f_int1)
! SUBPARTITIONS "A2"
! (PARTITION part1 VALUES LESS THAN (10),
! PARTITION part2 VALUES LESS THAN (2147483646));
! ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '"A2"
! (PARTITION part1 VALUES LESS THAN (10),
! PARTITION part2 VALUES LESS THAN (2' at line 9
! CREATE TABLE t1 (
! f_int1 INTEGER,
! f_int2 INTEGER,
! f_char1 CHAR(20),
! f_char2 CHAR(20),
! f_charbig VARCHAR(1000)
! )
! PARTITION BY HASH(f_int1) PARTITIONS "GARBAGE";
! ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '"GARBAGE"' at line 8
! CREATE TABLE t1 (
! f_int1 INTEGER,
! f_int2 INTEGER,
! f_char1 CHAR(20),
! f_char2 CHAR(20),
! f_charbig VARCHAR(1000)
! )
! PARTITION BY RANGE(f_int1) SUBPARTITION BY HASH(f_int1)
! SUBPARTITIONS "GARBAGE"
! (PARTITION part1 VALUES LESS THAN (10),
! PARTITION part2 VALUES LESS THAN (2147483646));
! ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '"GARBAGE"
! (PARTITION part1 VALUES LESS THAN (10),
! PARTITION part2 VALUES LESS TH' at line 9
! # 4.2.6 (negative) partition/subpartition numbers per @variables
! SET @aux = 5;
! CREATE TABLE t1 (
! f_int1 INTEGER,
! f_int2 INTEGER,
! f_char1 CHAR(20),
! f_char2 CHAR(20),
! f_charbig VARCHAR(1000)
! )
! PARTITION BY HASH(f_int1) PARTITIONS @aux;
! ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '@aux' at line 8
! CREATE TABLE t1 (
! f_int1 INTEGER,
! f_int2 INTEGER,
! f_char1 CHAR(20),
! f_char2 CHAR(20),
! f_charbig VARCHAR(1000)
! )
! PARTITION BY RANGE(f_int1) SUBPARTITION BY HASH(f_int1)
! SUBPARTITIONS @aux = 5
! (PARTITION part1 VALUES LESS THAN (10),
! PARTITION part2 VALUES LESS THAN (2147483646));
! ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '@aux = 5
! (PARTITION part1 VALUES LESS THAN (10),
! PARTITION part2 VALUES LESS THA' at line 9
! #------------------------------------------------------------------------
! # 4.3 Mixups of assigned partition/subpartition numbers and names
! #------------------------------------------------------------------------
! # 4.3.1 (positive) number of partition/subpartition
! #                         = number of named partition/subpartition
! CREATE TABLE t1 (
! f_int1 INTEGER,
! f_int2 INTEGER,
! f_char1 CHAR(20),
! f_char2 CHAR(20),
! f_charbig VARCHAR(1000)
! )
! PARTITION BY HASH(f_int1) PARTITIONS 2 ( PARTITION part1, PARTITION part2 ) ;
! create_command
! SHOW CREATE TABLE t1;
! Table Create Table
! t1    CREATE TABLE `t1` (
!   `f_int1` int(11) DEFAULT NULL,
!   `f_int2` int(11) DEFAULT NULL,
!   `f_char1` char(20) DEFAULT NULL,
!   `f_char2` char(20) DEFAULT NULL,
!   `f_charbig` varchar(1000) DEFAULT NULL
! ) ENGINE=MyISAM DEFAULT CHARSET=latin1 /*!50100 PARTITION BY HASH (f_int1) (PARTITION part1 ENGINE = MyISAM, PARTITION part2 ENGINE = MyISAM) */
! 
! unified filelist
! $MYSQLTEST_VARDIR/master-data/test/t1#P#part1.MYD
! $MYSQLTEST_VARDIR/master-data/test/t1#P#part1.MYI
! $MYSQLTEST_VARDIR/master-data/test/t1#P#part2.MYD
! $MYSQLTEST_VARDIR/master-data/test/t1#P#part2.MYI
! $MYSQLTEST_VARDIR/master-data/test/t1.frm
! $MYSQLTEST_VARDIR/master-data/test/t1.par
! 
! DROP TABLE t1;
! CREATE TABLE t1 (
! f_int1 INTEGER,
! f_int2 INTEGER,
! f_char1 CHAR(20),
! f_char2 CHAR(20),
! f_charbig VARCHAR(1000)
! )
! PARTITION BY RANGE(f_int1) PARTITIONS 2
! SUBPARTITION BY HASH(f_int1) SUBPARTITIONS 2
! ( PARTITION part1 VALUES LESS THAN (1000)
! (SUBPARTITION subpart11, SUBPARTITION subpart12),
! PARTITION part2 VALUES LESS THAN (2147483646)
! (SUBPARTITION subpart21, SUBPARTITION subpart22)
! );
! create_command
! SHOW CREATE TABLE t1;
! Table Create Table
! t1    CREATE TABLE `t1` (
!   `f_int1` int(11) DEFAULT NULL,
!   `f_int2` int(11) DEFAULT NULL,
!   `f_char1` char(20) DEFAULT NULL,
!   `f_char2` char(20) DEFAULT NULL,
!   `f_charbig` varchar(1000) DEFAULT NULL
! ) ENGINE=MyISAM DEFAULT CHARSET=latin1 /*!50100 PARTITION BY RANGE (f_int1) SUBPARTITION BY HASH (f_int1) (PARTITION part1 VALUES LESS THAN (1000) (SUBPARTITION subpart11 ENGINE = MyISAM, SUBPARTITION subpart12 ENGINE = MyISAM), PARTITION part2 VALUES LESS THAN (2147483646) (SUBPARTITION subpart21 ENGINE = MyISAM, SUBPARTITION subpart22 ENGINE = MyISAM)) */
! 
! unified filelist
! $MYSQLTEST_VARDIR/master-data/test/t1#P#part1#SP#subpart11.MYD
! $MYSQLTEST_VARDIR/master-data/test/t1#P#part1#SP#subpart11.MYI
! $MYSQLTEST_VARDIR/master-data/test/t1#P#part1#SP#subpart12.MYD
! $MYSQLTEST_VARDIR/master-data/test/t1#P#part1#SP#subpart12.MYI
! $MYSQLTEST_VARDIR/master-data/test/t1#P#part2#SP#subpart21.MYD
! $MYSQLTEST_VARDIR/master-data/test/t1#P#part2#SP#subpart21.MYI
! $MYSQLTEST_VARDIR/master-data/test/t1#P#part2#SP#subpart22.MYD
! $MYSQLTEST_VARDIR/master-data/test/t1#P#part2#SP#subpart22.MYI
! $MYSQLTEST_VARDIR/master-data/test/t1.frm
! $MYSQLTEST_VARDIR/master-data/test/t1.par
! 
! DROP TABLE t1;
! # 4.3.2 (positive) number of partition/subpartition ,
! #                  0 (= no) named partition/subpartition
! #                  already checked above
! # 4.3.3 (negative) number of partitions/subpartitions
! #                         > number of named partitions/subpartitions
! CREATE TABLE t1 (
! f_int1 INTEGER,
! f_int2 INTEGER,
! f_char1 CHAR(20),
! f_char2 CHAR(20),
! f_charbig VARCHAR(1000)
! )
! PARTITION BY HASH(f_int1) PARTITIONS 2 ( PARTITION part1 ) ;
! ERROR 42000: Wrong number of partitions defined, mismatch with previous setting near ')' at line 8
! CREATE TABLE t1 (
! f_int1 INTEGER,
! f_int2 INTEGER,
! f_char1 CHAR(20),
! f_char2 CHAR(20),
! f_charbig VARCHAR(1000)
! )
! PARTITION BY RANGE(f_int1)
! SUBPARTITION BY HASH(f_int1) SUBPARTITIONS 2
! ( PARTITION part1 VALUES LESS THAN (1000)
! (SUBPARTITION subpart11 ),
! PARTITION part2 VALUES LESS THAN (2147483646)
! (SUBPARTITION subpart21, SUBPARTITION subpart22)
! );
! ERROR 42000: Wrong number of subpartitions defined, mismatch with previous setting near '),
! PARTITION part2 VALUES LESS THAN (2147483646)
! (SUBPARTITION subpart21, SUBPAR' at line 11
! CREATE TABLE t1 (
! f_int1 INTEGER,
! f_int2 INTEGER,
! f_char1 CHAR(20),
! f_char2 CHAR(20),
! f_charbig VARCHAR(1000)
! )
! PARTITION BY RANGE(f_int1)
! SUBPARTITION BY HASH(f_int1) SUBPARTITIONS 2
! ( PARTITION part1 VALUES LESS THAN (1000)
! (SUBPARTITION subpart11, SUBPARTITION subpart12),
! PARTITION part2 VALUES LESS THAN (2000)
! (SUBPARTITION subpart21 ),
! PARTITION part3 VALUES LESS THAN (2147483646)
! (SUBPARTITION subpart31, SUBPARTITION subpart32)
! );
! ERROR 42000: Wrong number of subpartitions defined, mismatch with previous setting near '),
! PARTITION part3 VALUES LESS THAN (2147483646)
! (SUBPARTITION subpart31, SUBPAR' at line 13
! CREATE TABLE t1 (
! f_int1 INTEGER,
! f_int2 INTEGER,
! f_char1 CHAR(20),
! f_char2 CHAR(20),
! f_charbig VARCHAR(1000)
! )
! PARTITION BY RANGE(f_int1) PARTITIONS 2
! SUBPARTITION BY HASH(f_int1) SUBPARTITIONS 2
! ( PARTITION part1 VALUES LESS THAN (1000)
! (SUBPARTITION subpart11, SUBPARTITION subpart12),
! PARTITION part2 VALUES LESS THAN (2147483646)
! (SUBPARTITION subpart21                        )
! );
! ERROR 42000: Wrong number of subpartitions defined, mismatch with previous setting near ')
! )' at line 13
! # 4.3.4 (negative) number of partitions < number of named partitions
! CREATE TABLE t1 (
! f_int1 INTEGER,
! f_int2 INTEGER,
! f_char1 CHAR(20),
! f_char2 CHAR(20),
! f_charbig VARCHAR(1000)
! )
! PARTITION BY HASH(f_int1) PARTITIONS 1 ( PARTITION part1, PARTITION part2 ) ;
! ERROR 42000: Wrong number of partitions defined, mismatch with previous setting near ')' at line 8
! CREATE TABLE t1 (
! f_int1 INTEGER,
! f_int2 INTEGER,
! f_char1 CHAR(20),
! f_char2 CHAR(20),
! f_charbig VARCHAR(1000)
! )
! PARTITION BY RANGE(f_int1)
! SUBPARTITION BY HASH(f_int1) SUBPARTITIONS 1
! ( PARTITION part1 VALUES LESS THAN (1000)
! (SUBPARTITION subpart11, SUBPARTITION subpart12),
! PARTITION part2 VALUES LESS THAN (2147483646)
! (SUBPARTITION subpart21, SUBPARTITION subpart22)
! );
! ERROR 42000: Wrong number of subpartitions defined, mismatch with previous setting near '),
! PARTITION part2 VALUES LESS THAN (2147483646)
! (SUBPARTITION subpart21, SUBPAR' at line 11
! CREATE TABLE t1 (
! f_int1 INTEGER,
! f_int2 INTEGER,
! f_char1 CHAR(20),
! f_char2 CHAR(20),
! f_charbig VARCHAR(1000)
! )
! PARTITION BY RANGE(f_int1)
! SUBPARTITION BY HASH(f_int1) SUBPARTITIONS 1
! ( PARTITION part1 VALUES LESS THAN (1000)
! (SUBPARTITION subpart11, SUBPARTITION subpart12),
! PARTITION part2 VALUES LESS THAN (2000)
! (SUBPARTITION subpart21                        ),
! PARTITION part3 VALUES LESS THAN (2147483646)
! (SUBPARTITION subpart31, SUBPARTITION subpart32)
! );
! ERROR 42000: Wrong number of subpartitions defined, mismatch with previous setting near '),
! PARTITION part2 VALUES LESS THAN (2000)
! (SUBPARTITION subpart21              ' at line 11
! CREATE TABLE t1 (
! f_int1 INTEGER,
! f_int2 INTEGER,
! f_char1 CHAR(20),
! f_char2 CHAR(20),
! f_charbig VARCHAR(1000)
! )
! PARTITION BY RANGE(f_int1)
! SUBPARTITION BY HASH(f_int1) SUBPARTITIONS 1
! ( PARTITION part1 VALUES LESS THAN (1000)
! (SUBPARTITION subpart11, SUBPARTITION subpart12),
! PARTITION part2 VALUES LESS THAN (2147483646)
! (SUBPARTITION subpart21, SUBPARTITION subpart22)
! );
! ERROR 42000: Wrong number of subpartitions defined, mismatch with previous setting near '),
! PARTITION part2 VALUES LESS THAN (2147483646)
! (SUBPARTITION subpart21, SUBPAR' at line 11
! 
! #========================================================================
! #  5. Checks of logical partition/subpartition name
! #     file name clashes during CREATE TABLE
! #========================================================================
! DROP TABLE IF EXISTS t1;
! #------------------------------------------------------------------------
! #  5.1 (negative) A partition/subpartition name used more than once
! #------------------------------------------------------------------------
! #  5.1.1 duplicate partition name
! CREATE TABLE t1 (
! f_int1 INTEGER,
! f_int2 INTEGER,
! f_char1 CHAR(20),
! f_char2 CHAR(20),
! f_charbig VARCHAR(1000)
! )
! PARTITION BY HASH(f_int1) (PARTITION part1, PARTITION part1);
! ERROR HY000: Duplicate partition name part1
! #  5.1.2 duplicate subpartition name
! CREATE TABLE t1 (
! f_int1 INTEGER,
! f_int2 INTEGER,
! f_char1 CHAR(20),
! f_char2 CHAR(20),
! f_charbig VARCHAR(1000)
! )
! PARTITION BY RANGE(f_int1)
! SUBPARTITION BY HASH(f_int1)
! ( PARTITION part1 VALUES LESS THAN (1000)
! (SUBPARTITION subpart11, SUBPARTITION subpart11)
! );
! ERROR HY000: Duplicate partition name subpart11
! DROP VIEW  IF EXISTS v1;
! DROP TABLE IF EXISTS t1;
! DROP TABLE IF EXISTS t0_aux;
! DROP TABLE IF EXISTS t0_definition;
! DROP TABLE IF EXISTS t0_template;
--- 1010,1017 ----
  )
  PARTITION BY HASH(f_int1) PARTITIONS 0;
  ERROR HY000: Number of partitions = 0 is not an allowed value
! #      The last command got an unexepected error response.
! #      Expected/handled SQL codes are 0,1064,1487,1492
! 
! #      SQL code we got was:   1501
! #      Sorry, have to abort.
-------------------------------------------------------
Please follow the instructions outlined at
http://www.mysql.com/doc/en/Reporting_mysqltest_bugs.html
to find the reason to this problem and how to report this.


Stopping All Servers
Restoring snapshot of databases
Resuming Tests

partition_syntax_ndb           [ disabled ]  cannot create t1
partition_value_innodb         [ pass ]            487
partition_value_myisam         [ pass ]            215
partition_value_ndb            [ disabled ]  cannot create t1
rpl_ndb_dd_partitions          [ skipped ]   Requiring binlog format 'row'
-------------------------------------------------------
Stopping All Servers
mysql-test-run: WARNING: Forcing kill of process 28931
Failed 15/35 tests, 57.14% were successful.