RW4QnNpS

1engines/funcs.tc_partition_list_directory 'innodb' w2 [ fail ]
2        Test ended at 2016-09-13 15:49:12
3
4CURRENT_TEST: engines/funcs.tc_partition_list_directory
5mysqltest: At line 17: query 'CREATE TABLE t1 (id INTEGER NOT NULL, name VARCHAR(30), adate DATE)
6PARTITION BY LIST(YEAR(adate))
7(
8PARTITION p1999 VALUES IN (1995, 1999, 2003)
9DATA DIRECTORY = '$MYSQLTEST_VARDIR/tmp/tc_partition_list_directory/p1999/data'
10    INDEX DIRECTORY = '$MYSQLTEST_VARDIR/tmp/tc_partition_list_directory/p1999/idx',
11PARTITION p2000 VALUES IN (1996, 2000, 2004)
12DATA DIRECTORY = '$MYSQLTEST_VARDIR/tmp/tc_partition_list_directory/p2000/data'
13    INDEX DIRECTORY = '$MYSQLTEST_VARDIR/tmp/tc_partition_list_directory/p2000/idx',
14PARTITION p2001 VALUES IN (1997, 2001, 2005)
15DATA DIRECTORY = '$MYSQLTEST_VARDIR/tmp/tc_partition_list_directory/p2001/data'
16    INDEX DIRECTORY = '$MYSQLTEST_VARDIR/tmp/tc_partition_list_directory/p2001/idx'
17)' failed: 1005: Can't create table `test`.`t1` (errno: 140 "Wrong create options")
18
19The result from queries just before the failure was:
20DROP TABLE IF EXISTS t1;
21CREATE TABLE t1 (id INTEGER NOT NULL, name VARCHAR(30), adate DATE)
22PARTITION BY LIST(YEAR(adate))
23(
24PARTITION p1999 VALUES IN (1995, 1999, 2003)
25DATA DIRECTORY = 'MYSQLTEST_VARDIR/tmp/tc_partition_list_directory/p1999/data'
26    INDEX DIRECTORY = 'MYSQLTEST_VARDIR/tmp/tc_partition_list_directory/p1999/idx',
27PARTITION p2000 VALUES IN (1996, 2000, 2004)
28DATA DIRECTORY = 'MYSQLTEST_VARDIR/tmp/tc_partition_list_directory/p2000/data'
29    INDEX DIRECTORY = 'MYSQLTEST_VARDIR/tmp/tc_partition_list_directory/p2000/idx',
30PARTITION p2001 VALUES IN (1997, 2001, 2005)
31DATA DIRECTORY = 'MYSQLTEST_VARDIR/tmp/tc_partition_list_directory/p2001/data'
32    INDEX DIRECTORY = 'MYSQLTEST_VARDIR/tmp/tc_partition_list_directory/p2001/idx'
33);