| 1 |
################################################################################ |
| 2 |
# t/partition_syntax_innodb.test # |
| 3 |
# # |
| 4 |
# Purpose: # |
| 5 |
# Tests around Create Partitioned table syntax # |
| 6 |
# InnoDB branch # |
| 7 |
# # |
| 8 |
#------------------------------------------------------------------------------# |
| 9 |
# Original Author: mleich # |
| 10 |
# Original Date: 2006-03-05 # |
| 11 |
# Change Author: # |
| 12 |
# Change Date: # |
| 13 |
# Change: # |
| 14 |
################################################################################ |
| 15 |
|
| 16 |
# |
| 17 |
# NOTE: PLEASE DO NOT ADD NOT INNODB SPECIFIC TESTCASES HERE ! |
| 18 |
# TESTCASES WHICH MUST BE APPLIED TO ALL STORAGE ENGINES MUST BE ADDED IN |
| 19 |
# THE SOURCED FILES ONLY. |
| 20 |
# |
| 21 |
# Please read the README at the end of inc/partition.pre before changing |
| 22 |
# any of the variables. |
| 23 |
# |
| 24 |
|
| 25 |
#------------------------------------------------------------------------------# |
| 26 |
# General not engine specific settings and requirements |
| 27 |
|
| 28 |
##### Options, for debugging support ##### |
| 29 |
let $debug= 0; |
| 30 |
|
| 31 |
##### Option, for displaying files ##### |
| 32 |
let $ls= 1; |
| 33 |
|
| 34 |
##### Number of rows for the INSERT/UPDATE/DELETE/SELECT experiments ##### |
| 35 |
# on partioned tables |
| 36 |
SET @max_row = 20; |
| 37 |
|
| 38 |
##### Execute more tests ##### |
| 39 |
let $more_trigger_tests= 0; |
| 40 |
let $more_pk_ui_tests= 0; |
| 41 |
|
| 42 |
|
| 43 |
#------------------------------------------------------------------------------# |
| 44 |
# Engine specific settings and requirements |
| 45 |
|
| 46 |
##### Storage engine to be tested |
| 47 |
let $engine= 'InnoDB'; |
| 48 |
|
| 49 |
##### Execute the test of "table" files |
| 50 |
# InnoDB has no files per PK, UI, ... |
| 51 |
let $do_file_tests= 0; |
| 52 |
|
| 53 |
##### Execute PRIMARY KEY tests ##### |
| 54 |
# AFAIK InnoDB clusters the data following the PRIMARY KEY. |
| 55 |
let $do_pk_tests= 1; |
| 56 |
|
| 57 |
##### Assign a big number smaller than the maximum value for partitions ##### |
| 58 |
# and smaller than the maximum value of SIGNED INTEGER |
| 59 |
let $MAX_VALUE= (2147483646); |
| 60 |
|
| 61 |
# Generate the prerequisites ($variables, @variables, tables) needed |
| 62 |
--source suite/parts/inc/partition.pre |
| 63 |
|
| 64 |
##### Workarounds for known open engine specific bugs |
| 65 |
# none |
| 66 |
|
| 67 |
#------------------------------------------------------------------------------# |
| 68 |
# Execute the tests to be applied to all storage engines |
| 69 |
--source suite/parts/inc/partition_syntax.inc |
| 70 |
|
| 71 |
#------------------------------------------------------------------------------# |
| 72 |
# Execute storage engine specific tests |
| 73 |
|
| 74 |
#------------------------------------------------------------------------------# |
| 75 |
# Cleanup |
| 76 |
--source suite/parts/inc/partition_cleanup.inc |