SELECT VERSION();
# Storage engine to be tested
let $engine= 'MYISAM';
eval SET SESSION storage_engine=$engine;

--echo #  1.2.1 PRIMARY KEY consisting of one column
# Crash let $unique= , PRIMARY KEY(f_int1);
# Crash let $unique= , UNIQUE INDEX(f_int1);
# Crash let $unique= , UNIQUE INDEX(f_int2,f_int1);
let $unique= , UNIQUE INDEX(f_int1);

--disable_abort_on_error
#--source include/partition_unique1.inc
--disable_warnings
DROP TABLE IF EXISTS t1;
--enable_warnings

#----------- PARTITION BY RANGE -- SUBPARTITION BY HASH
# harmless (at least with the following stuff) PARTITION BY RANGE(f_int1) SUBPARTITION BY HASH(f_int1) SUBPARTITIONS 2
# harmless (at least with the following stuff) PARTITION BY RANGE(f_int1 DIV 2)
# Crash PARTITION BY RANGE(f_int1 DIV 2) SUBPARTITION BY HASH(f_int1) SUBPARTITIONS 2
eval CREATE TABLE t1 (
 f_int1 INTEGER,
f_int2 INTEGER
$unique
)
PARTITION BY RANGE(f_int1 DIV 2) SUBPARTITION BY HASH(f_int1) SUBPARTITIONS 2
(
 PARTITION partb VALUES LESS THAN (2),
 PARTITION parte VALUES LESS THAN (4),
 PARTITION partf VALUES LESS THAN (10000));

# harmless SELECT * FROM t1;
# harmless SELECT * FROM t1 WHERE f_int1 = 3;
# Crash SELECT * FROM t1 WHERE f_int1 = 10;
SELECT * FROM t1 WHERE f_int1 = 10;