################################################################################ # t/partition_alter2_2_maria.test # # # # Purpose: # # Tests around Alter column used in partitioning function # # Aria branch # # # #------------------------------------------------------------------------------# # Original Author: mleich # # Original Date: 2006-03-05 # # Change Author: # # Change Date: # # Change: # ################################################################################ # # NOTE: PLEASE DO NOT ADD NOT Aria 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 # Lots of ALTER TABLE, slow in Maria (disk syncs), takes ~15 minutes --source include/big_test.inc #------------------------------------------------------------------------------# # Engine specific settings and requirements ##### Storage engine to be tested --source include/have_maria.inc let $engine= 'Aria'; ##### Execute the test of "table" files # MAARIA has files per PK, UI, ... let $do_file_tests= 1; ##### Execute PRIMARY KEY tests ##### # AFAIK Aria 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