Debian Codegraph @

mysql-test/suite/gcol/t/gcol_partition_innodb.test

raw
1 ################################################################################
2 # t/gcol_partition_innodb.test #
3 # #
4 # Purpose: #
5 # Testing partitioning tables with generated columns. #
6 # #
7 # InnoDB branch #
8 # #
9 #------------------------------------------------------------------------------#
10 # Original Author: Andrey Zhakov #
11 # Original Date: 2008-09-04 #
12 # Change Author: #
13 # Change Date: #
14 # Change: #
15 ################################################################################
16
17 #
18 # NOTE: PLEASE DO NOT ADD NOT MYISAM SPECIFIC TESTCASES HERE !
19 # TESTCASES WHICH MUST BE APPLIED TO ALL STORAGE ENGINES MUST BE ADDED IN
20 # THE SOURCED FILES ONLY.
21 #
22
23 #------------------------------------------------------------------------------#
24 # General not engine specific settings and requirements
25
26 #------------------------------------------------------------------------------#
27 # Engine specific settings and requirements
28
29 ##### Storage engine to be tested
30 # Set the session storage engine
31 --source include/have_innodb.inc
32 SET @save_stats_persistent = @@GLOBAL.innodb_stats_persistent;
33 SET GLOBAL innodb_stats_persistent = 0;
34 SET default_storage_engine = 'InnoDB';
35
36 ##### Workarounds for known open engine specific bugs
37 # none
38
39 #------------------------------------------------------------------------------#
40 # Execute the tests to be applied to all storage engines
41 --source suite/gcol/inc/gcol_partition.inc
42
43 #------------------------------------------------------------------------------#
44 # Execute storage engine specific tests
45
46 --echo #
47 --echo # MDEV-16980 Wrongly set tablename len while opening the
48 --echo # table for purge thread
49 --echo #
50
51 CREATE TABLE t1(pk SERIAL, d DATE, vd DATE AS (d) VIRTUAL,
52 PRIMARY KEY(pk), KEY (vd))ENGINE=InnoDB
53 PARTITION BY HASH(pk) PARTITIONS 2;
54
55 INSERT IGNORE INTO t1 (d) VALUES ('2015-04-14');
56 SET sql_mode= '';
57 REPLACE INTO t1 SELECT * FROM t1;
58
59 # Cleanup
60 DROP TABLE t1;
61
62 --source suite/innodb/include/wait_all_purged.inc
63
64 SET GLOBAL innodb_stats_persistent = @save_stats_persistent;
65
66 #------------------------------------------------------------------------------#
67 # Cleanup
68 --source suite/gcol/inc/gcol_cleanup.inc