################################################################################ # t/partition_alter2_2_myisam.test # # # # Purpose: # # Tests around Alter column used in partitioning function # # MyISAM branch # # # #------------------------------------------------------------------------------# # Original Author: mleich # # Original Date: 2006-03-05 # # Change Author: # # Change Date: # # Change: # ################################################################################ # # NOTE: PLEASE DO NOT ADD NOT MYISAM SPECIFIC TESTCASES HERE ! # TESTCASES WHICH MUST BE APPLIED TO ALL STORAGE ENGINES MUST BE ADDED IN # THE SOURCED FILES ONLY. # # Please read the README at the end of inc/partition.pre before changing # any of the variables. # #------------------------------------------------------------------------------# # General not engine specific settings and requirements ##### Options, for debugging support ##### let $debug= 0; let $with_partitioning= 1; ##### Option, for displaying files ##### let $ls= 1; ##### Number of rows for the INSERT/UPDATE/DELETE/SELECT experiments ##### # on partioned tables SET @max_row = 20; ##### Execute more tests ##### let $more_trigger_tests= 0; let $more_pk_ui_tests= 0; # This test relies on connecting externally from mysqltest, doesn't # work with embedded. --source include/not_embedded.inc # The server must support partitioning. --source include/have_partition.inc #------------------------------------------------------------------------------# # Engine specific settings and requirements ##### Storage engine to be tested let $engine= 'MyISAM'; ##### Execute the test of "table" files # MyISAM has files per PK, UI, ... let $do_file_tests= 1; ##### Execute PRIMARY KEY tests ##### # AFAIK MyISAM treats PRIMARY KEYs like UNIQUE INDEXes let $do_pk_tests= 0; ##### Assign a big number smaller than the maximum value for partitions ##### # and smaller than the maximum value of SIGNED INTEGER let $MAX_VALUE= (2147483646); # Generate the prerequisites ($variables, @variables, tables) needed --source suite/parts/inc/partition.pre ##### Workarounds for known open engine specific bugs # none #------------------------------------------------------------------------------# # Execute the tests to be applied to all storage engines --source suite/parts/inc/partition_alter2_2.inc #------------------------------------------------------------------------------# # Execute storage engine specific tests #------------------------------------------------------------------------------# # Cleanup --source suite/parts/inc/partition_cleanup.inc