alter_table_part: ALTER TABLE table_names ; c_t_begin: CREATE TABLE IF NOT EXISTS ; c_t_mid: ( non_generated_cols ) ; col_int_properties: { $col_name= "col_int" ; $col_type= "INTEGER" ; return undef } ; col_string_properties: string_col_name ; col_text_properties: { $col_name= "col_text" ; $col_type= "TEXT" ; return undef } ; col_varchar_properties: { $col_name= "col_varchar" ; $col_type= "VARCHAR(500)" ; return undef } ; create_table: c_t_begin t1 c_t_mid ENGINE = InnoDB ROW_FORMAT = Dynamic ; c_t_begin t2 c_t_mid ENGINE = InnoDB ROW_FORMAT = Compressed ; c_t_begin t3 c_t_mid ENGINE = InnoDB ROW_FORMAT = Compact ; c_t_begin t4 c_t_mid ENGINE = InnoDB ROW_FORMAT = Redundant ; c_t_begin t5 c_t_mid ENGINE = InnoDB ROW_FORMAT = Compact ENCRYPTED=YES ENCRYPTION_KEY_ID=1 ; c_t_begin t6 c_t_mid ENGINE = InnoDB ROW_FORMAT = Compact PAGE_COMPRESSED=1 ; c_t_begin t7 c_t_mid ENGINE = InnoDB ROW_FORMAT = Compact PAGE_COMPRESSED=1 ENCRYPTED=YES ENCRYPTION_KEY_ID=33 ; ddl: alter_table_part , | alter_table_part , | replace_column | | | | ; dml: insert_part ( my_int , $my_int, $my_int, string_fill, REPEAT(SUBSTR(CAST( $my_int - 1 fill_end ) ; fill_end: AS CHAR),1,1), @fill_amount) ; get_cdigit: {$cdigit = $prng->int(1,10); return undef} ; insert_part: INSERT INTO table_names (col1,col2,col_int_properties $col_name, col_string_properties $col_name, col_text_properties $col_name) VALUES ; my_int: { $my_int= $prng->int( 65, 512) } ; name_convert: get_cdigit {if ($cdigit > length($name)) { $cdigit = length($name)} ; $val = substr($name, 0, $cdigit - 1) . uc(substr($name, $cdigit - 1, 1)) . substr($name, $cdigit) ; return $val} ; non_generated_cols: col1 INT PRIMARY KEY, col2 INT, col_int_properties $col_name $col_type , col_string_properties $col_name $col_type, col_varchar_properties $col_name $col_type, col_text_properties $col_name $col_type ; query: ddl | dml | dml ; replace_column: replace_column_add ; replace_column_drop ; replace_column_rename ; replace_column_add: alter_table_part ADD COLUMN {$forget= $col_name."_copy"} $col_type FIRST ; replace_column_drop: alter_table_part DROP COLUMN $col_name ; replace_column_rename: alter_table_part CHANGE COLUMN $forget {$name = $col_name; return undef} name_convert $col_type ; string_col_name: { $col_name= "col_string" ; return undef } ; string_fill: REPEAT(SUBSTR(CAST( $my_int AS CHAR),1,1), 10) ; table_names: { $table_name = "t1" } | { $table_name = "t7" } ; thread1: query ; thread1_connect: ; thread1_init: create_table ; ################ Generated by grammar simplifier ################ # Order id list : 364 # Order id 364 # -------------- ddl: replace_column | | | | ;