D:/qa-win-debug/build/sql/debug/mysqld.exe, Version: 10.3.3-MariaDB-debug-log (Source distribution). started with: TCP Port: 11500, Named Pipe: D:\TEMP\BKlYoig3zd/master.sock Time Id Command Argument 171012 18:12:07 8 Connect root@127.0.0.1 as anonymous on test 171012 18:12:08 9 Connect root@127.0.0.1 as anonymous on test 9 Query SELECT VERSION() 9 Query SET optimizer_switch=(SELECT variable_value FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES WHERE VARIABLE_NAME='optimizer_switch') 9 Query SELECT DATABASE() 9 Query SELECT CONNECTION_ID() 9 Query SELECT CURRENT_USER() 9 Query SET SQL_MODE= CONCAT(@@sql_mode,',NO_ENGINE_SUBSTITUTION') /* QNO 1 CON_ID 9 */ 9 Query CREATE SCHEMA /*!IF NOT EXISTS*/ test /* QNO 2 CON_ID 9 */ 9 Query SHOW WARNINGS 9 Query USE test /* QNO 3 CON_ID 9 */ 9 Query SELECT DATABASE() 9 Query DROP TABLE /*! IF EXISTS*/ table0_int /* QNO 4 CON_ID 9 */ 9 Query SHOW WARNINGS 9 Query CREATE TABLE `table0_int` ( pk int, `col_int` int, /*Indices*/ primary key (pk)) /* QNO 5 CON_ID 9 */ 171012 18:12:09 9 Query ALTER TABLE `table0_int` DISABLE KEYS /* QNO 6 CON_ID 9 */ 9 Query SHOW WARNINGS 9 Query COMMIT /* QNO 7 CON_ID 9 */ 9 Query ALTER TABLE `table0_int` ENABLE KEYS /* QNO 8 CON_ID 9 */ 9 Query SHOW WARNINGS 9 Query COMMIT /* QNO 9 CON_ID 9 */ 9 Query USE test /* QNO 10 CON_ID 9 */ 9 Query SELECT DATABASE() 9 Quit 10 Connect root@127.0.0.1 as anonymous on test 10 Query SHOW VARIABLES 10 Query SHOW SLAVE HOSTS 10 Query SELECT PLUGIN_NAME, PLUGIN_LIBRARY FROM INFORMATION_SCHEMA.PLUGINS WHERE PLUGIN_LIBRARY IS NOT NULL 10 Quit 171012 18:12:11 11 Connect root@127.0.0.1 as anonymous on test 11 Query SHOW VARIABLES 11 Query SHOW SLAVE HOSTS 11 Query SELECT PLUGIN_NAME, PLUGIN_LIBRARY FROM INFORMATION_SCHEMA.PLUGINS WHERE PLUGIN_LIBRARY IS NOT NULL 11 Quit 171012 18:12:13 12 Connect root@127.0.0.1 as anonymous on test 12 Query SHOW VARIABLES 12 Query SHOW SLAVE HOSTS 12 Query SELECT PLUGIN_NAME, PLUGIN_LIBRARY FROM INFORMATION_SCHEMA.PLUGINS WHERE PLUGIN_LIBRARY IS NOT NULL 12 Quit 171012 18:12:15 13 Connect root@127.0.0.1 as anonymous on test 13 Query SHOW VARIABLES 13 Query SHOW SLAVE HOSTS 13 Query SELECT PLUGIN_NAME, PLUGIN_LIBRARY FROM INFORMATION_SCHEMA.PLUGINS WHERE PLUGIN_LIBRARY IS NOT NULL 13 Quit 171012 18:12:17 14 Connect root@127.0.0.1 as anonymous on test 14 Query SHOW VARIABLES 14 Query SHOW SLAVE HOSTS 14 Query SELECT PLUGIN_NAME, PLUGIN_LIBRARY FROM INFORMATION_SCHEMA.PLUGINS WHERE PLUGIN_LIBRARY IS NOT NULL 14 Quit 171012 18:12:19 15 Connect root@127.0.0.1 as anonymous on test 15 Query SET optimizer_switch=(SELECT variable_value FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES WHERE VARIABLE_NAME='optimizer_switch') 15 Query SELECT DATABASE() 15 Query SELECT CONNECTION_ID() 15 Query SELECT CURRENT_USER() 15 Query SELECT DISTINCT CASE WHEN table_schema = 'information_schema' THEN 'INFORMATION_SCHEMA' ELSE table_schema END AS table_schema, table_name, CASE WHEN table_type = 'BASE TABLE' THEN 'table' WHEN table_type = 'VIEW' THEN 'view' WHEN table_type = 'SYSTEM VIEW' then 'view' ELSE 'misc' END AS table_type, column_name, CASE WHEN column_key = 'PRI' THEN 'primary' WHEN column_key IN ('MUL','UNI') THEN 'indexed' WHEN index_name = 'PRIMARY' THEN 'primary' WHEN non_unique IS NOT NULL THEN 'indexed' ELSE 'ordinary' END AS column_key, CASE WHEN data_type IN ('bit','tinyint','smallint','mediumint','int','bigint') THEN 'int' WHEN data_type IN ('float','double') THEN 'float' WHEN data_type IN ('decimal') THEN 'decimal' WHEN data_type IN ('datetime','timestamp') THEN 'timestamp' WHEN data_type IN ('char','varchar','binary','varbinary') THEN 'char' WHEN data_type IN ('tinyblob','blob','mediumblob','longblob') THEN 'blob' WHEN data_type IN ('tinytext','text','mediumtext','longtext') THEN 'text' ELSE data_type END AS data_type_normalized, data_type, character_maximum_length, table_rows FROM information_schema.tables INNER JOIN information_schema.columns USING(table_schema,table_name) LEFT JOIN information_schema.statistics USING(table_schema,table_name,column_name) WHERE table_name <> 'DUMMY' 171012 18:12:20 15 Query SELECT COUNT(*) FROM mysql.column_stats 15 Query SELECT COUNT(*) FROM mysql.columns_priv 15 Query SELECT COUNT(*) FROM mysql.db 15 Query SELECT COUNT(*) FROM mysql.event 15 Query SELECT COUNT(*) FROM mysql.func 15 Query SELECT COUNT(*) FROM mysql.gtid_slave_pos 15 Query SELECT COUNT(*) FROM mysql.help_category 15 Query SELECT COUNT(*) FROM mysql.help_keyword 15 Query SELECT COUNT(*) FROM mysql.help_relation 15 Query SELECT COUNT(*) FROM mysql.help_topic 15 Query SELECT COUNT(*) FROM mysql.host 15 Query SELECT COUNT(*) FROM mysql.index_stats 15 Query SELECT COUNT(*) FROM mysql.innodb_index_stats 15 Query SELECT COUNT(*) FROM mysql.innodb_table_stats 15 Query SELECT COUNT(*) FROM mysql.plugin 15 Query SELECT COUNT(*) FROM mysql.proc 15 Query SELECT COUNT(*) FROM mysql.procs_priv 15 Query SELECT COUNT(*) FROM mysql.proxies_priv 15 Query SELECT COUNT(*) FROM mysql.roles_mapping 15 Query SELECT COUNT(*) FROM mysql.servers 15 Query SELECT COUNT(*) FROM mysql.table_stats 15 Query SELECT COUNT(*) FROM mysql.tables_priv 15 Query SELECT COUNT(*) FROM mysql.time_zone 15 Query SELECT COUNT(*) FROM mysql.time_zone_leap_second 15 Query SELECT COUNT(*) FROM mysql.time_zone_name 15 Query SELECT COUNT(*) FROM mysql.time_zone_transition 15 Query SELECT COUNT(*) FROM mysql.time_zone_transition_type 15 Query SELECT COUNT(*) FROM mysql.user 15 Query SELECT COUNT(*) FROM test.table0_int 15 Query SELECT COUNT(*) FROM INFORMATION_SCHEMA.ALL_PLUGINS 15 Query SELECT COUNT(*) FROM INFORMATION_SCHEMA.ALL_PLUGINS 15 Query SELECT COUNT(*) FROM INFORMATION_SCHEMA.ALL_PLUGINS 15 Query SELECT COUNT(*) FROM INFORMATION_SCHEMA.ALL_PLUGINS 15 Query SELECT COUNT(*) FROM INFORMATION_SCHEMA.ALL_PLUGINS 15 Query SELECT COUNT(*) FROM INFORMATION_SCHEMA.ALL_PLUGINS 15 Query SELECT COUNT(*) FROM INFORMATION_SCHEMA.ALL_PLUGINS 15 Query SELECT COUNT(*) FROM INFORMATION_SCHEMA.ALL_PLUGINS 15 Query SELECT COUNT(*) FROM INFORMATION_SCHEMA.ALL_PLUGINS 15 Query SELECT COUNT(*) FROM INFORMATION_SCHEMA.ALL_PLUGINS 15 Query SELECT COUNT(*) FROM INFORMATION_SCHEMA.ALL_PLUGINS 15 Query SELECT COUNT(*) FROM INFORMATION_SCHEMA.ALL_PLUGINS 15 Query SELECT COUNT(*) FROM INFORMATION_SCHEMA.ALL_PLUGINS 15 Query SELECT COUNT(*) FROM INFORMATION_SCHEMA.APPLICABLE_ROLES 15 Query SELECT COUNT(*) FROM INFORMATION_SCHEMA.CHARACTER_SETS 15 Query SELECT COUNT(*) FROM INFORMATION_SCHEMA.COLLATIONS 15 Query SELECT COUNT(*) FROM INFORMATION_SCHEMA.COLLATION_CHARACTER_SET_APPLICABILITY 15 Query SELECT COUNT(*) FROM INFORMATION_SCHEMA.COLUMNS 15 Query SELECT COUNT(*) FROM INFORMATION_SCHEMA.COLUMN_PRIVILEGES 15 Query SELECT COUNT(*) FROM INFORMATION_SCHEMA.ENABLED_ROLES 15 Query SELECT COUNT(*) FROM INFORMATION_SCHEMA.ENGINES 15 Query SELECT COUNT(*) FROM INFORMATION_SCHEMA.EVENTS 15 Query SELECT COUNT(*) FROM INFORMATION_SCHEMA.FILES 15 Query SELECT COUNT(*) FROM INFORMATION_SCHEMA.GLOBAL_STATUS 15 Query SELECT COUNT(*) FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 15 Query SELECT COUNT(*) FROM INFORMATION_SCHEMA.KEY_CACHES 15 Query SELECT COUNT(*) FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE 171012 18:12:21 15 Query SELECT COUNT(*) FROM INFORMATION_SCHEMA.PARAMETERS 15 Query SELECT COUNT(*) FROM INFORMATION_SCHEMA.PARTITIONS 15 Query SELECT COUNT(*) FROM INFORMATION_SCHEMA.PLUGINS 15 Query SELECT COUNT(*) FROM INFORMATION_SCHEMA.PROCESSLIST 15 Query SELECT COUNT(*) FROM INFORMATION_SCHEMA.PROFILING 15 Query SELECT COUNT(*) FROM INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS 15 Query SELECT COUNT(*) FROM INFORMATION_SCHEMA.ROUTINES 15 Query SELECT COUNT(*) FROM INFORMATION_SCHEMA.SCHEMATA 15 Query SELECT COUNT(*) FROM INFORMATION_SCHEMA.SCHEMA_PRIVILEGES 15 Query SELECT COUNT(*) FROM INFORMATION_SCHEMA.SESSION_STATUS 15 Query SELECT COUNT(*) FROM INFORMATION_SCHEMA.SESSION_VARIABLES 15 Query SELECT COUNT(*) FROM INFORMATION_SCHEMA.STATISTICS 15 Query SELECT COUNT(*) FROM INFORMATION_SCHEMA.SYSTEM_VARIABLES 15 Query SELECT COUNT(*) FROM INFORMATION_SCHEMA.TABLES 15 Query SELECT COUNT(*) FROM INFORMATION_SCHEMA.TABLESPACES 15 Query SELECT COUNT(*) FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS 15 Query SELECT COUNT(*) FROM INFORMATION_SCHEMA.TABLE_PRIVILEGES 15 Query SELECT COUNT(*) FROM INFORMATION_SCHEMA.TRIGGERS 15 Query SELECT COUNT(*) FROM INFORMATION_SCHEMA.USER_PRIVILEGES 15 Query SELECT COUNT(*) FROM INFORMATION_SCHEMA.VIEWS 15 Query SELECT COUNT(*) FROM INFORMATION_SCHEMA.GEOMETRY_COLUMNS 15 Query SELECT COUNT(*) FROM INFORMATION_SCHEMA.SPATIAL_REF_SYS 15 Query SELECT COUNT(*) FROM INFORMATION_SCHEMA.CLIENT_STATISTICS 15 Query SELECT COUNT(*) FROM INFORMATION_SCHEMA.INDEX_STATISTICS 15 Query SELECT COUNT(*) FROM INFORMATION_SCHEMA.INNODB_SYS_DATAFILES 15 Query SELECT COUNT(*) FROM INFORMATION_SCHEMA.USER_STATISTICS 15 Query SELECT COUNT(*) FROM INFORMATION_SCHEMA.INNODB_SYS_TABLESTATS 15 Query SELECT COUNT(*) FROM INFORMATION_SCHEMA.INNODB_LOCKS 15 Query SELECT COUNT(*) FROM INFORMATION_SCHEMA.INNODB_MUTEXES 15 Query SELECT COUNT(*) FROM INFORMATION_SCHEMA.INNODB_CMPMEM 15 Query SELECT COUNT(*) FROM INFORMATION_SCHEMA.INNODB_CMP_PER_INDEX 15 Query SELECT COUNT(*) FROM INFORMATION_SCHEMA.INNODB_CMP 15 Query SELECT COUNT(*) FROM INFORMATION_SCHEMA.INNODB_FT_DELETED 15 Query SELECT COUNT(*) FROM INFORMATION_SCHEMA.INNODB_CMP_RESET 15 Query SELECT COUNT(*) FROM INFORMATION_SCHEMA.INNODB_LOCK_WAITS 15 Query SELECT COUNT(*) FROM INFORMATION_SCHEMA.TABLE_STATISTICS 15 Query SELECT COUNT(*) FROM INFORMATION_SCHEMA.INNODB_TABLESPACES_ENCRYPTION 15 Query SELECT COUNT(*) FROM INFORMATION_SCHEMA.INNODB_BUFFER_PAGE_LRU 15 Query SELECT COUNT(*) FROM INFORMATION_SCHEMA.INNODB_SYS_FIELDS 15 Query SELECT COUNT(*) FROM INFORMATION_SCHEMA.INNODB_CMPMEM_RESET 15 Query SELECT COUNT(*) FROM INFORMATION_SCHEMA.INNODB_SYS_COLUMNS 15 Query SELECT COUNT(*) FROM INFORMATION_SCHEMA.INNODB_FT_INDEX_TABLE 15 Query SELECT COUNT(*) FROM INFORMATION_SCHEMA.INNODB_CMP_PER_INDEX_RESET 15 Query SELECT COUNT(*) FROM INFORMATION_SCHEMA.user_variables 15 Query SELECT COUNT(*) FROM INFORMATION_SCHEMA.INNODB_FT_INDEX_CACHE 15 Query SELECT COUNT(*) FROM INFORMATION_SCHEMA.INNODB_SYS_FOREIGN_COLS 15 Query SELECT COUNT(*) FROM INFORMATION_SCHEMA.INNODB_FT_BEING_DELETED 15 Query SELECT COUNT(*) FROM INFORMATION_SCHEMA.INNODB_BUFFER_POOL_STATS 15 Query SELECT COUNT(*) FROM INFORMATION_SCHEMA.INNODB_TRX 15 Query SELECT COUNT(*) FROM INFORMATION_SCHEMA.INNODB_SYS_FOREIGN 15 Query SELECT COUNT(*) FROM INFORMATION_SCHEMA.INNODB_SYS_TABLES 15 Query SELECT COUNT(*) FROM INFORMATION_SCHEMA.INNODB_FT_DEFAULT_STOPWORD 15 Query SELECT COUNT(*) FROM INFORMATION_SCHEMA.INNODB_FT_CONFIG 15 Query SELECT COUNT(*) FROM INFORMATION_SCHEMA.INNODB_BUFFER_PAGE 15 Query SELECT COUNT(*) FROM INFORMATION_SCHEMA.INNODB_SYS_TABLESPACES 15 Query SELECT COUNT(*) FROM INFORMATION_SCHEMA.INNODB_METRICS 15 Query SELECT COUNT(*) FROM INFORMATION_SCHEMA.INNODB_SYS_INDEXES 15 Query SELECT COUNT(*) FROM INFORMATION_SCHEMA.INNODB_SYS_VIRTUAL 15 Query SELECT COUNT(*) FROM INFORMATION_SCHEMA.INNODB_TABLESPACES_SCRUBBING 15 Query SELECT COUNT(*) FROM INFORMATION_SCHEMA.INNODB_SYS_SEMAPHORE_WAITS 15 Query SELECT COUNT(*) FROM mysql.general_log 15 Query SELECT COUNT(*) FROM mysql.slow_log 15 Query SELECT COUNT(*) FROM performance_schema.accounts 15 Query SELECT COUNT(*) FROM performance_schema.cond_instances 15 Query SELECT COUNT(*) FROM performance_schema.events_stages_current 15 Query SELECT COUNT(*) FROM performance_schema.events_stages_history 15 Query SELECT COUNT(*) FROM performance_schema.events_stages_history_long 15 Query SELECT COUNT(*) FROM performance_schema.events_stages_summary_by_account_by_event_name 15 Query SELECT COUNT(*) FROM performance_schema.events_stages_summary_by_host_by_event_name 15 Query SELECT COUNT(*) FROM performance_schema.events_stages_summary_by_thread_by_event_name 15 Query SELECT COUNT(*) FROM performance_schema.events_stages_summary_by_user_by_event_name 15 Query SELECT COUNT(*) FROM performance_schema.events_stages_summary_global_by_event_name 15 Query SELECT COUNT(*) FROM performance_schema.events_statements_current 15 Query SELECT COUNT(*) FROM performance_schema.events_statements_history 15 Query SELECT COUNT(*) FROM performance_schema.events_statements_history_long 15 Query SELECT COUNT(*) FROM performance_schema.events_statements_summary_by_account_by_event_name 15 Query SELECT COUNT(*) FROM performance_schema.events_statements_summary_by_digest 15 Query SELECT COUNT(*) FROM performance_schema.events_statements_summary_by_host_by_event_name 15 Query SELECT COUNT(*) FROM performance_schema.events_statements_summary_by_thread_by_event_name 15 Query SELECT COUNT(*) FROM performance_schema.events_statements_summary_by_user_by_event_name 15 Query SELECT COUNT(*) FROM performance_schema.events_statements_summary_global_by_event_name 15 Query SELECT COUNT(*) FROM performance_schema.events_waits_current 15 Query SELECT COUNT(*) FROM performance_schema.events_waits_history 15 Query SELECT COUNT(*) FROM performance_schema.events_waits_history_long 15 Query SELECT COUNT(*) FROM performance_schema.events_waits_summary_by_account_by_event_name 15 Query SELECT COUNT(*) FROM performance_schema.events_waits_summary_by_host_by_event_name 15 Query SELECT COUNT(*) FROM performance_schema.events_waits_summary_by_instance 15 Query SELECT COUNT(*) FROM performance_schema.events_waits_summary_by_thread_by_event_name 15 Query SELECT COUNT(*) FROM performance_schema.events_waits_summary_by_user_by_event_name 15 Query SELECT COUNT(*) FROM performance_schema.events_waits_summary_global_by_event_name 15 Query SELECT COUNT(*) FROM performance_schema.file_instances 15 Query SELECT COUNT(*) FROM performance_schema.file_summary_by_event_name 15 Query SELECT COUNT(*) FROM performance_schema.file_summary_by_instance 15 Query SELECT COUNT(*) FROM performance_schema.host_cache 15 Query SELECT COUNT(*) FROM performance_schema.hosts 15 Query SELECT COUNT(*) FROM performance_schema.mutex_instances 15 Query SELECT COUNT(*) FROM performance_schema.objects_summary_global_by_type 15 Query SELECT COUNT(*) FROM performance_schema.performance_timers 15 Query SELECT COUNT(*) FROM performance_schema.rwlock_instances 15 Query SELECT COUNT(*) FROM performance_schema.session_account_connect_attrs 15 Query SELECT COUNT(*) FROM performance_schema.session_connect_attrs 15 Query SELECT COUNT(*) FROM performance_schema.setup_actors 15 Query SELECT COUNT(*) FROM performance_schema.setup_consumers 15 Query SELECT COUNT(*) FROM performance_schema.setup_instruments 15 Query SELECT COUNT(*) FROM performance_schema.setup_objects 15 Query SELECT COUNT(*) FROM performance_schema.setup_timers 15 Query SELECT COUNT(*) FROM performance_schema.socket_instances 15 Query SELECT COUNT(*) FROM performance_schema.socket_summary_by_event_name 15 Query SELECT COUNT(*) FROM performance_schema.socket_summary_by_instance 15 Query SELECT COUNT(*) FROM performance_schema.table_io_waits_summary_by_index_usage 15 Query SELECT COUNT(*) FROM performance_schema.table_io_waits_summary_by_table 15 Query SELECT COUNT(*) FROM performance_schema.table_lock_waits_summary_by_table 15 Query SELECT COUNT(*) FROM performance_schema.threads 15 Query SELECT COUNT(*) FROM performance_schema.users 15 Query SELECT collation_name,character_set_name FROM information_schema.collations 15 Query SHOW VARIABLES LIKE 'datadir' /* QNO 11 CON_ID 15 */ 15 Quit 171012 18:12:22 16 Connect root@127.0.0.1 as anonymous on test 16 Query SET optimizer_switch=(SELECT variable_value FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES WHERE VARIABLE_NAME='optimizer_switch') 16 Query SELECT DATABASE() 16 Query SELECT CONNECTION_ID() 16 Query SELECT CURRENT_USER() 16 Query SELECT collation_name,character_set_name FROM information_schema.collations 17 Connect root@127.0.0.1 as anonymous on test 17 Query SET optimizer_switch=(SELECT variable_value FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES WHERE VARIABLE_NAME='optimizer_switch') 17 Query SELECT DATABASE() 17 Query SELECT CONNECTION_ID() 17 Query SELECT CURRENT_USER() 17 Query SELECT collation_name,character_set_name FROM information_schema.collations 18 Connect root@127.0.0.1 as anonymous on test 18 Query SET optimizer_switch=(SELECT variable_value FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES WHERE VARIABLE_NAME='optimizer_switch') 18 Query SELECT DATABASE() 18 Query SELECT CONNECTION_ID() 18 Query SELECT CURRENT_USER() 18 Query SELECT collation_name,character_set_name FROM information_schema.collations 19 Connect root@127.0.0.1 as anonymous on test 19 Query SET optimizer_switch=(SELECT variable_value FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES WHERE VARIABLE_NAME='optimizer_switch') 19 Query SELECT DATABASE() 19 Query SELECT CONNECTION_ID() 19 Query SELECT CURRENT_USER() 19 Query SELECT collation_name,character_set_name FROM information_schema.collations 21 Connect root@127.0.0.1 as anonymous on test 21 Query SET optimizer_switch=(SELECT variable_value FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES WHERE VARIABLE_NAME='optimizer_switch') 21 Query SELECT DATABASE() 21 Query SELECT CONNECTION_ID() 21 Query SELECT CURRENT_USER() 21 Query SELECT collation_name,character_set_name FROM information_schema.collations 20 Connect root@127.0.0.1 as anonymous on test 20 Query SHOW FULL PROCESSLIST 20 Quit 171012 18:12:23 22 Connect root@127.0.0.1 as anonymous on test 22 Query SHOW FULL PROCESSLIST 22 Quit 171012 18:12:27 16 Query SET AUTOCOMMIT = 0 /* QNO 12 CON_ID 16 */ 16 Query CREATE DATABASE IF NOT EXISTS transforms 16 Query CREATE OR REPLACE VIEW transforms.view_12936_probe AS SET AUTOCOMMIT = 0 /* QNO 12 CON_ID 16 */ /* QNO 13 CON_ID 16 */ 16 Query CREATE TABLE IF NOT EXISTS t1 (col1 INT, col2 INT, col3 INT, col4 TEXT) ENGINE = InnoDB /* QNO 14 CON_ID 16 */ 17 Query SET AUTOCOMMIT = 0 /* QNO 12 CON_ID 17 */ 17 Query CREATE DATABASE IF NOT EXISTS transforms 17 Query CREATE OR REPLACE VIEW transforms.view_10968_probe AS SET AUTOCOMMIT = 0 /* QNO 12 CON_ID 17 */ /* QNO 13 CON_ID 17 */ 17 Query SHOW WARNINGS 17 Query CREATE TABLE IF NOT EXISTS t1 (col1 INT, col2 INT, col3 INT, col4 TEXT) ENGINE = InnoDB /* QNO 14 CON_ID 17 */ 17 Query SHOW WARNINGS 17 Query SET @fill_amount = (@@innodb_page_size / 2 ) + 1 /* QNO 15 CON_ID 17 */ 17 Query CREATE OR REPLACE VIEW transforms.view_10968_probe AS SET @fill_amount = (@@innodb_page_size / 2 ) + 1 /* QNO 15 CON_ID 17 */ /* QNO 16 CON_ID 17 */ 17 Query SET @dummy=1 /* QNO 17 CON_ID 17 */ 17 Query CREATE OR REPLACE VIEW transforms.view_10968_probe AS SET @dummy=1 /* QNO 17 CON_ID 17 */ /* QNO 18 CON_ID 17 */ 17 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES ( 4, 4 - 1, 4, REPEAT(CAST(4 AS CHAR(1)),@fill_amount)) /* QNO 19 CON_ID 17 */ 16 Query CREATE OR REPLACE VIEW transforms.view_12936_probe AS CREATE TABLE IF NOT EXISTS t1 (col1 INT, col2 INT, col3 INT, col4 TEXT) ENGINE = InnoDB /* QNO 14 CON_ID 16 */ /* QNO 15 CON_ID 16 */ 16 Query SET @fill_amount = (@@innodb_page_size / 2 ) + 1 /* QNO 16 CON_ID 16 */ 16 Query CREATE OR REPLACE VIEW transforms.view_12936_probe AS SET @fill_amount = (@@innodb_page_size / 2 ) + 1 /* QNO 16 CON_ID 16 */ /* QNO 17 CON_ID 16 */ 16 Query SET @dummy=1, SQL_MODE = CONCAT(@@sql_mode, ',ONLY_FULL_GROUP_BY') /* QNO 18 CON_ID 16 */ 16 Query CREATE OR REPLACE VIEW transforms.view_12936_probe AS SET @dummy=1, SQL_MODE = CONCAT(@@sql_mode, ',ONLY_FULL_GROUP_BY') /* QNO 18 CON_ID 16 */ /* QNO 19 CON_ID 16 */ 16 Query LOCK TABLE table0_int WRITE /* QNO 20 CON_ID 16 */ 16 Query CREATE OR REPLACE VIEW transforms.view_12936_probe AS LOCK TABLE table0_int WRITE /* QNO 20 CON_ID 16 */ /* QNO 21 CON_ID 16 */ 16 Query UPDATE table0_int SET `col_int` = 0 /* QNO 22 CON_ID 16 */ 16 Query /* GenTest::Transform::DisableOptimizations */ SET @switch_saved = @@optimizer_switch /* QNO 23 CON_ID 16 */ 16 Query SET SESSION optimizer_switch = REPLACE( @@optimizer_switch, '=on', '=off' ) /* QNO 24 CON_ID 16 */ 16 Query SET SESSION optimizer_switch = 'in_to_exists=on' /* QNO 25 CON_ID 16 */ 16 Query UPDATE table0_int SET `col_int` = 0 /* QNO 22 CON_ID 16 */ /* TRANSFORM_OUTCOME_UNORDERED_MATCH */ /* QNO 26 CON_ID 16 */ 16 Query /* GenTest::Transform::DisableOptimizations */ /* TRANSFORM_CLEANUP */ SET SESSION optimizer_switch=@switch_saved /* QNO 27 CON_ID 16 */ 16 Query /* GenTest::Transform::EnableOptimizations */ SET @switch_saved = @@optimizer_switch /* QNO 28 CON_ID 16 */ 16 Query SET SESSION optimizer_switch = REPLACE( @@optimizer_switch, '=off', '=on' ) /* QNO 29 CON_ID 16 */ 17 Query CREATE OR REPLACE VIEW transforms.view_10968_probe AS INSERT INTO t1 (col1,col2,col3,col4) VALUES ( 4, 4 - 1, 4, REPEAT(CAST(4 AS CHAR(1)),@fill_amount)) /* QNO 19 CON_ID 17 */ /* QNO 20 CON_ID 17 */ 16 Query SHOW WARNINGS 16 Query UPDATE table0_int SET `col_int` = 0 /* QNO 22 CON_ID 16 */ /* TRANSFORM_OUTCOME_UNORDERED_MATCH */ /* QNO 30 CON_ID 16 */ 17 Query COMMIT /* QNO 21 CON_ID 17 */ 16 Query /* GenTest::Transform::EnableOptimizations */ /* TRANSFORM_CLEANUP */ SET SESSION optimizer_switch=@switch_saved /* QNO 31 CON_ID 16 */ 16 Query CREATE OR REPLACE VIEW transforms.view_12936_probe AS UPDATE table0_int SET `col_int` = 0 /* QNO 22 CON_ID 16 */ /* QNO 32 CON_ID 16 */ 16 Query ALTER TABLE table0_int MODIFY col_int INT AUTO_INCREMENT PRIMARY KEY /* QNO 33 CON_ID 16 */ 16 Query UNLOCK TABLES /* QNO 34 CON_ID 16 */ 16 Query CREATE OR REPLACE VIEW transforms.view_12936_probe AS UNLOCK TABLES /* QNO 34 CON_ID 16 */ /* QNO 35 CON_ID 16 */ 16 Query LOCK TABLE table0_int WRITE /* QNO 36 CON_ID 16 */ 16 Query CREATE OR REPLACE VIEW transforms.view_12936_probe AS LOCK TABLE table0_int WRITE /* QNO 36 CON_ID 16 */ /* QNO 37 CON_ID 16 */ 16 Query UPDATE table0_int SET `pk` = 0 /* QNO 38 CON_ID 16 */ 16 Query /* GenTest::Transform::DisableOptimizations */ SET @switch_saved = @@optimizer_switch /* QNO 39 CON_ID 16 */ 16 Query SET SESSION optimizer_switch = REPLACE( @@optimizer_switch, '=on', '=off' ) /* QNO 40 CON_ID 16 */ 16 Query SET SESSION optimizer_switch = 'in_to_exists=on' /* QNO 41 CON_ID 16 */ 16 Query UPDATE table0_int SET `pk` = 0 /* QNO 38 CON_ID 16 */ /* TRANSFORM_OUTCOME_UNORDERED_MATCH */ /* QNO 42 CON_ID 16 */ 16 Query /* GenTest::Transform::DisableOptimizations */ /* TRANSFORM_CLEANUP */ SET SESSION optimizer_switch=@switch_saved /* QNO 43 CON_ID 16 */ 16 Query /* GenTest::Transform::EnableOptimizations */ SET @switch_saved = @@optimizer_switch /* QNO 44 CON_ID 16 */ 16 Query SET SESSION optimizer_switch = REPLACE( @@optimizer_switch, '=off', '=on' ) /* QNO 45 CON_ID 16 */ 16 Query SHOW WARNINGS 16 Query UPDATE table0_int SET `pk` = 0 /* QNO 38 CON_ID 16 */ /* TRANSFORM_OUTCOME_UNORDERED_MATCH */ /* QNO 46 CON_ID 16 */ 16 Query /* GenTest::Transform::EnableOptimizations */ /* TRANSFORM_CLEANUP */ SET SESSION optimizer_switch=@switch_saved /* QNO 47 CON_ID 16 */ 16 Query CREATE OR REPLACE VIEW transforms.view_12936_probe AS UPDATE table0_int SET `pk` = 0 /* QNO 38 CON_ID 16 */ /* QNO 48 CON_ID 16 */ 16 Query ALTER TABLE table0_int MODIFY pk INT AUTO_INCREMENT PRIMARY KEY /* QNO 49 CON_ID 16 */ 17 Query CREATE OR REPLACE VIEW transforms.view_10968_probe AS COMMIT /* QNO 21 CON_ID 17 */ /* QNO 22 CON_ID 17 */ 17 Query ALTER TABLE t1 ADD PRIMARY KEY ( col4(10) ) /* QNO 23 CON_ID 17 */ 16 Query UNLOCK TABLES /* QNO 50 CON_ID 16 */ 16 Query CREATE OR REPLACE VIEW transforms.view_12936_probe AS UNLOCK TABLES /* QNO 50 CON_ID 16 */ /* QNO 51 CON_ID 16 */ 16 Query LOCK TABLE table0_int WRITE /* QNO 52 CON_ID 16 */ 16 Query CREATE OR REPLACE VIEW transforms.view_12936_probe AS LOCK TABLE table0_int WRITE /* QNO 52 CON_ID 16 */ /* QNO 53 CON_ID 16 */ 16 Query UPDATE table0_int SET `pk` = 0 /* QNO 54 CON_ID 16 */ 16 Query /* GenTest::Transform::DisableOptimizations */ SET @switch_saved = @@optimizer_switch /* QNO 55 CON_ID 16 */ 16 Query SET SESSION optimizer_switch = REPLACE( @@optimizer_switch, '=on', '=off' ) /* QNO 56 CON_ID 16 */ 16 Query SET SESSION optimizer_switch = 'in_to_exists=on' /* QNO 57 CON_ID 16 */ 16 Query UPDATE table0_int SET `pk` = 0 /* QNO 54 CON_ID 16 */ /* TRANSFORM_OUTCOME_UNORDERED_MATCH */ /* QNO 58 CON_ID 16 */ 16 Query /* GenTest::Transform::DisableOptimizations */ /* TRANSFORM_CLEANUP */ SET SESSION optimizer_switch=@switch_saved /* QNO 59 CON_ID 16 */ 16 Query /* GenTest::Transform::EnableOptimizations */ SET @switch_saved = @@optimizer_switch /* QNO 60 CON_ID 16 */ 16 Query SET SESSION optimizer_switch = REPLACE( @@optimizer_switch, '=off', '=on' ) /* QNO 61 CON_ID 16 */ 16 Query SHOW WARNINGS 16 Query UPDATE table0_int SET `pk` = 0 /* QNO 54 CON_ID 16 */ /* TRANSFORM_OUTCOME_UNORDERED_MATCH */ /* QNO 62 CON_ID 16 */ 16 Query /* GenTest::Transform::EnableOptimizations */ /* TRANSFORM_CLEANUP */ SET SESSION optimizer_switch=@switch_saved /* QNO 63 CON_ID 16 */ 16 Query CREATE OR REPLACE VIEW transforms.view_12936_probe AS UPDATE table0_int SET `pk` = 0 /* QNO 54 CON_ID 16 */ /* QNO 64 CON_ID 16 */ 16 Query ALTER TABLE table0_int MODIFY pk INT AUTO_INCREMENT PRIMARY KEY /* QNO 65 CON_ID 16 */ 18 Query SET AUTOCOMMIT = 0 /* QNO 12 CON_ID 18 */ 18 Query CREATE DATABASE IF NOT EXISTS transforms 18 Query CREATE OR REPLACE VIEW transforms.view_3564_probe AS SET AUTOCOMMIT = 0 /* QNO 12 CON_ID 18 */ /* QNO 13 CON_ID 18 */ 16 Query UNLOCK TABLES /* QNO 66 CON_ID 16 */ 18 Query SHOW WARNINGS 18 Query CREATE TABLE IF NOT EXISTS t1 (col1 INT, col2 INT, col3 INT, col4 TEXT) ENGINE = InnoDB /* QNO 14 CON_ID 18 */ 16 Query CREATE OR REPLACE VIEW transforms.view_12936_probe AS UNLOCK TABLES /* QNO 66 CON_ID 16 */ /* QNO 67 CON_ID 16 */ 18 Query SHOW WARNINGS 18 Query SET @fill_amount = (@@innodb_page_size / 2 ) + 1 /* QNO 15 CON_ID 18 */ 16 Query LOCK TABLE table0_int WRITE /* QNO 68 CON_ID 16 */ 18 Query CREATE OR REPLACE VIEW transforms.view_3564_probe AS SET @fill_amount = (@@innodb_page_size / 2 ) + 1 /* QNO 15 CON_ID 18 */ /* QNO 16 CON_ID 18 */ 16 Query CREATE OR REPLACE VIEW transforms.view_12936_probe AS LOCK TABLE table0_int WRITE /* QNO 68 CON_ID 16 */ /* QNO 69 CON_ID 16 */ 18 Query SET @dummy=1 /*!100000, USE_STAT_TABLES = PREFERABLY */ /* QNO 17 CON_ID 18 */ 16 Query UPDATE table0_int SET `pk` = 0 /* QNO 70 CON_ID 16 */ 18 Query CREATE OR REPLACE VIEW transforms.view_3564_probe AS SET @dummy=1 /*!100000, USE_STAT_TABLES = PREFERABLY */ /* QNO 17 CON_ID 18 */ /* QNO 18 CON_ID 18 */ 16 Query /* GenTest::Transform::DisableOptimizations */ SET @switch_saved = @@optimizer_switch /* QNO 71 CON_ID 16 */ 16 Query SET SESSION optimizer_switch = REPLACE( @@optimizer_switch, '=on', '=off' ) /* QNO 72 CON_ID 16 */ 16 Query SET SESSION optimizer_switch = 'in_to_exists=on' /* QNO 73 CON_ID 16 */ 18 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES ( 3, 3, 3, REPEAT(CAST(3 - 1 AS CHAR(1)),@fill_amount)) /* QNO 19 CON_ID 18 */ 16 Query UPDATE table0_int SET `pk` = 0 /* QNO 70 CON_ID 16 */ /* TRANSFORM_OUTCOME_UNORDERED_MATCH */ /* QNO 74 CON_ID 16 */ 16 Query /* GenTest::Transform::DisableOptimizations */ /* TRANSFORM_CLEANUP */ SET SESSION optimizer_switch=@switch_saved /* QNO 75 CON_ID 16 */ 16 Query /* GenTest::Transform::EnableOptimizations */ SET @switch_saved = @@optimizer_switch /* QNO 76 CON_ID 16 */ 16 Query SET SESSION optimizer_switch = REPLACE( @@optimizer_switch, '=off', '=on' ) /* QNO 77 CON_ID 16 */ 16 Query SHOW WARNINGS 16 Query UPDATE table0_int SET `pk` = 0 /* QNO 70 CON_ID 16 */ /* TRANSFORM_OUTCOME_UNORDERED_MATCH */ /* QNO 78 CON_ID 16 */ 16 Query /* GenTest::Transform::EnableOptimizations */ /* TRANSFORM_CLEANUP */ SET SESSION optimizer_switch=@switch_saved /* QNO 79 CON_ID 16 */ 16 Query CREATE OR REPLACE VIEW transforms.view_12936_probe AS UPDATE table0_int SET `pk` = 0 /* QNO 70 CON_ID 16 */ /* QNO 80 CON_ID 16 */ 16 Query ALTER TABLE table0_int MODIFY pk INT AUTO_INCREMENT PRIMARY KEY /* QNO 81 CON_ID 16 */ 16 Query UNLOCK TABLES /* QNO 82 CON_ID 16 */ 16 Query CREATE OR REPLACE VIEW transforms.view_12936_probe AS UNLOCK TABLES /* QNO 82 CON_ID 16 */ /* QNO 83 CON_ID 16 */ 16 Query LOCK TABLE table0_int WRITE /* QNO 84 CON_ID 16 */ 16 Query CREATE OR REPLACE VIEW transforms.view_12936_probe AS LOCK TABLE table0_int WRITE /* QNO 84 CON_ID 16 */ /* QNO 85 CON_ID 16 */ 16 Query UPDATE table0_int SET `col_int` = 0 /* QNO 86 CON_ID 16 */ 16 Query /* GenTest::Transform::DisableOptimizations */ SET @switch_saved = @@optimizer_switch /* QNO 87 CON_ID 16 */ 16 Query SET SESSION optimizer_switch = REPLACE( @@optimizer_switch, '=on', '=off' ) /* QNO 88 CON_ID 16 */ 16 Query SET SESSION optimizer_switch = 'in_to_exists=on' /* QNO 89 CON_ID 16 */ 16 Query UPDATE table0_int SET `col_int` = 0 /* QNO 86 CON_ID 16 */ /* TRANSFORM_OUTCOME_UNORDERED_MATCH */ /* QNO 90 CON_ID 16 */ 16 Query /* GenTest::Transform::DisableOptimizations */ /* TRANSFORM_CLEANUP */ SET SESSION optimizer_switch=@switch_saved /* QNO 91 CON_ID 16 */ 16 Query /* GenTest::Transform::EnableOptimizations */ SET @switch_saved = @@optimizer_switch /* QNO 92 CON_ID 16 */ 16 Query SET SESSION optimizer_switch = REPLACE( @@optimizer_switch, '=off', '=on' ) /* QNO 93 CON_ID 16 */ 16 Query SHOW WARNINGS 16 Query UPDATE table0_int SET `col_int` = 0 /* QNO 86 CON_ID 16 */ /* TRANSFORM_OUTCOME_UNORDERED_MATCH */ /* QNO 94 CON_ID 16 */ 16 Query /* GenTest::Transform::EnableOptimizations */ /* TRANSFORM_CLEANUP */ SET SESSION optimizer_switch=@switch_saved /* QNO 95 CON_ID 16 */ 16 Query CREATE OR REPLACE VIEW transforms.view_12936_probe AS UPDATE table0_int SET `col_int` = 0 /* QNO 86 CON_ID 16 */ /* QNO 96 CON_ID 16 */ 16 Query ALTER TABLE table0_int MODIFY col_int INT AUTO_INCREMENT PRIMARY KEY /* QNO 97 CON_ID 16 */ 16 Query UNLOCK TABLES /* QNO 98 CON_ID 16 */ 16 Query CREATE OR REPLACE VIEW transforms.view_12936_probe AS UNLOCK TABLES /* QNO 98 CON_ID 16 */ /* QNO 99 CON_ID 16 */ 16 Query LOCK TABLE table0_int WRITE /* QNO 100 CON_ID 16 */ 16 Query CREATE OR REPLACE VIEW transforms.view_12936_probe AS LOCK TABLE table0_int WRITE /* QNO 100 CON_ID 16 */ /* QNO 101 CON_ID 16 */ 16 Query UPDATE table0_int SET `col_int` = 0 /* QNO 102 CON_ID 16 */ 16 Query /* GenTest::Transform::DisableOptimizations */ SET @switch_saved = @@optimizer_switch /* QNO 103 CON_ID 16 */ 16 Query SET SESSION optimizer_switch = REPLACE( @@optimizer_switch, '=on', '=off' ) /* QNO 104 CON_ID 16 */ 16 Query SET SESSION optimizer_switch = 'in_to_exists=on' /* QNO 105 CON_ID 16 */ 16 Query UPDATE table0_int SET `col_int` = 0 /* QNO 102 CON_ID 16 */ /* TRANSFORM_OUTCOME_UNORDERED_MATCH */ /* QNO 106 CON_ID 16 */ 16 Query /* GenTest::Transform::DisableOptimizations */ /* TRANSFORM_CLEANUP */ SET SESSION optimizer_switch=@switch_saved /* QNO 107 CON_ID 16 */ 16 Query /* GenTest::Transform::EnableOptimizations */ SET @switch_saved = @@optimizer_switch /* QNO 108 CON_ID 16 */ 16 Query SET SESSION optimizer_switch = REPLACE( @@optimizer_switch, '=off', '=on' ) /* QNO 109 CON_ID 16 */ 16 Query SHOW WARNINGS 16 Query UPDATE table0_int SET `col_int` = 0 /* QNO 102 CON_ID 16 */ /* TRANSFORM_OUTCOME_UNORDERED_MATCH */ /* QNO 110 CON_ID 16 */ 16 Query /* GenTest::Transform::EnableOptimizations */ /* TRANSFORM_CLEANUP */ SET SESSION optimizer_switch=@switch_saved /* QNO 111 CON_ID 16 */ 16 Query CREATE OR REPLACE VIEW transforms.view_12936_probe AS UPDATE table0_int SET `col_int` = 0 /* QNO 102 CON_ID 16 */ /* QNO 112 CON_ID 16 */ 16 Query ALTER TABLE table0_int MODIFY col_int INT AUTO_INCREMENT PRIMARY KEY /* QNO 113 CON_ID 16 */ 16 Query UNLOCK TABLES /* QNO 114 CON_ID 16 */ 16 Query CREATE OR REPLACE VIEW transforms.view_12936_probe AS UNLOCK TABLES /* QNO 114 CON_ID 16 */ /* QNO 115 CON_ID 16 */ 16 Query ALTER TABLE `table0_int` ADD KEY rkr_index_1 ( `pk`, `pk` ) /* QNO 116 CON_ID 16 */ 16 Query ALTER TABLE `table0_int` ADD KEY rkr_index_2 ( `col_int`, `col_int` ) /* QNO 117 CON_ID 16 */ 17 Query CREATE OR REPLACE VIEW transforms.view_10968_probe AS ALTER TABLE t1 ADD PRIMARY KEY ( col4(10) ) /* QNO 23 CON_ID 17 */ /* QNO 24 CON_ID 17 */ 17 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES ( 1, 1, 1, REPEAT(CAST(1 AS CHAR(1)),@fill_amount)) /* QNO 25 CON_ID 17 */ 16 Query ALTER TABLE `table0_int` ADD UNIQUE KEY rkr_index_3 ( `pk` ) /* QNO 118 CON_ID 16 */ 18 Query CREATE OR REPLACE VIEW transforms.view_3564_probe AS INSERT INTO t1 (col1,col2,col3,col4) VALUES ( 3, 3, 3, REPEAT(CAST(3 - 1 AS CHAR(1)),@fill_amount)) /* QNO 19 CON_ID 18 */ /* QNO 20 CON_ID 18 */ 18 Query ROLLBACK /* QNO 21 CON_ID 18 */ 17 Query CREATE OR REPLACE VIEW transforms.view_10968_probe AS INSERT INTO t1 (col1,col2,col3,col4) VALUES ( 1, 1, 1, REPEAT(CAST(1 AS CHAR(1)),@fill_amount)) /* QNO 25 CON_ID 17 */ /* QNO 26 CON_ID 17 */ 17 Query COMMIT /* QNO 27 CON_ID 17 */ 17 Query CREATE OR REPLACE VIEW transforms.view_10968_probe AS COMMIT /* QNO 27 CON_ID 17 */ /* QNO 28 CON_ID 17 */ 17 Query ALTER TABLE t1 DROP KEY uidx /* QNO 29 CON_ID 17 */ 17 Query DELETE FROM t1 WHERE col1 = 4 OR col1 IS NULL /* QNO 30 CON_ID 17 */ 19 Query SET AUTOCOMMIT = 0 /* QNO 12 CON_ID 19 */ 19 Query CREATE DATABASE IF NOT EXISTS transforms 19 Query CREATE OR REPLACE VIEW transforms.view_8236_probe AS SET AUTOCOMMIT = 0 /* QNO 12 CON_ID 19 */ /* QNO 13 CON_ID 19 */ 19 Query SHOW WARNINGS 16 Query CREATE OR REPLACE VIEW transforms.view_12936_probe AS ALTER TABLE `table0_int` ADD UNIQUE KEY rkr_index_3 ( `pk` ) /* QNO 118 CON_ID 16 */ /* QNO 119 CON_ID 16 */ 19 Query CREATE TABLE IF NOT EXISTS t1 (col1 INT, col2 INT, col3 INT, col4 TEXT) ENGINE = InnoDB /* QNO 14 CON_ID 19 */ 19 Query SHOW WARNINGS 16 Query ALTER TABLE `table0_int` ADD UNIQUE KEY rkr_index_4 ( `col_int`, `col_int`, `pk` ) /* QNO 120 CON_ID 16 */ 19 Query SET @fill_amount = (@@innodb_page_size / 2 ) + 1 /* QNO 15 CON_ID 19 */ 19 Query CREATE OR REPLACE VIEW transforms.view_8236_probe AS SET @fill_amount = (@@innodb_page_size / 2 ) + 1 /* QNO 15 CON_ID 19 */ /* QNO 16 CON_ID 19 */ 19 Query SET @dummy=1 /*!100000, HISTOGRAM_SIZE = 128 */ /*!100000, HISTOGRAM_SIZE = 128 */ /* QNO 17 CON_ID 19 */ 16 Query ALTER TABLE `table0_int` ADD KEY rkr_index_5 ( `col_int`, `col_int` ) /* QNO 121 CON_ID 16 */ 19 Query CREATE OR REPLACE VIEW transforms.view_8236_probe AS SET @dummy=1 /*!100000, HISTOGRAM_SIZE = 128 */ /*!100000, HISTOGRAM_SIZE = 128 */ /* QNO 17 CON_ID 19 */ /* QNO 18 CON_ID 19 */ 19 Query DELETE FROM t1 WHERE MATCH(col4) AGAINST (TRIM(' 4 ') IN BOOLEAN MODE) OR col3 IS NULL /* QNO 19 CON_ID 19 */ 16 Query ALTER TABLE `table0_int` ADD KEY rkr_index_6 ( `col_int`, `col_int` ) /* QNO 122 CON_ID 16 */ 17 Query /* GenTest::Transform::DisableOptimizations */ SET @switch_saved = @@optimizer_switch /* QNO 31 CON_ID 17 */ 17 Query SET SESSION optimizer_switch = REPLACE( @@optimizer_switch, '=on', '=off' ) /* QNO 32 CON_ID 17 */ 17 Query SET SESSION optimizer_switch = 'in_to_exists=on' /* QNO 33 CON_ID 17 */ 17 Query DELETE FROM t1 WHERE col1 = 4 OR col1 IS NULL /* QNO 30 CON_ID 17 */ /* TRANSFORM_OUTCOME_UNORDERED_MATCH */ /* QNO 34 CON_ID 17 */ 19 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES /* 3 */ (3,3,3,REPEAT(CAST(3 AS CHAR(1)),@fill_amount)), (3,3,3,REPEAT(CAST(3 AS CHAR(1)),@fill_amount)) /* QNO 20 CON_ID 19 */ 17 Query /* GenTest::Transform::DisableOptimizations */ /* TRANSFORM_CLEANUP */ SET SESSION optimizer_switch=@switch_saved /* QNO 35 CON_ID 17 */ 17 Query /* GenTest::Transform::EnableOptimizations */ SET @switch_saved = @@optimizer_switch /* QNO 36 CON_ID 17 */ 17 Query SET SESSION optimizer_switch = REPLACE( @@optimizer_switch, '=off', '=on' ) /* QNO 37 CON_ID 17 */ 17 Query SHOW WARNINGS 17 Query DELETE FROM t1 WHERE col1 = 4 OR col1 IS NULL /* QNO 30 CON_ID 17 */ /* TRANSFORM_OUTCOME_UNORDERED_MATCH */ /* QNO 38 CON_ID 17 */ 17 Query /* GenTest::Transform::EnableOptimizations */ /* TRANSFORM_CLEANUP */ SET SESSION optimizer_switch=@switch_saved /* QNO 39 CON_ID 17 */ 17 Query CREATE OR REPLACE VIEW transforms.view_10968_probe AS DELETE FROM t1 WHERE col1 = 4 OR col1 IS NULL /* QNO 30 CON_ID 17 */ /* QNO 40 CON_ID 17 */ 17 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES /* NULL */ (NULL,NULL,NULL,REPEAT(CAST(NULL AS CHAR(1)),@fill_amount)), (NULL,NULL,NULL,REPEAT(CAST(NULL AS CHAR(1)),@fill_amount)) /* QNO 41 CON_ID 17 */ 18 Query CREATE OR REPLACE VIEW transforms.view_3564_probe AS ROLLBACK /* QNO 21 CON_ID 18 */ /* QNO 22 CON_ID 18 */ 18 Query ALTER TABLE t1 ADD UNIQUE KEY uidx ( col3 ) /* QNO 23 CON_ID 18 */ 16 Query ALTER TABLE `table0_int` ADD KEY rkr_index_7 ( `pk`, `col_int` ) /* QNO 123 CON_ID 16 */ 17 Query ROLLBACK /* QNO 42 CON_ID 17 */ 21 Query SET AUTOCOMMIT = 0 /* QNO 12 CON_ID 21 */ 21 Query CREATE DATABASE IF NOT EXISTS transforms 21 Query CREATE OR REPLACE VIEW transforms.view_4616_probe AS SET AUTOCOMMIT = 0 /* QNO 12 CON_ID 21 */ /* QNO 13 CON_ID 21 */ 17 Query CREATE OR REPLACE VIEW transforms.view_10968_probe AS ROLLBACK /* QNO 42 CON_ID 17 */ /* QNO 43 CON_ID 17 */ 17 Query ALTER TABLE t1 DROP KEY idx /* QNO 44 CON_ID 17 */ 21 Query SHOW WARNINGS 21 Query CREATE TABLE IF NOT EXISTS t1 (col1 INT, col2 INT, col3 INT, col4 TEXT) ENGINE = InnoDB /* QNO 14 CON_ID 21 */ 21 Query SHOW WARNINGS 21 Query SET @fill_amount = (@@innodb_page_size / 2 ) + 1 /* QNO 15 CON_ID 21 */ 21 Query CREATE OR REPLACE VIEW transforms.view_4616_probe AS SET @fill_amount = (@@innodb_page_size / 2 ) + 1 /* QNO 15 CON_ID 21 */ /* QNO 16 CON_ID 21 */ 21 Query SET @dummy=1 /* QNO 17 CON_ID 21 */ 21 Query CREATE OR REPLACE VIEW transforms.view_4616_probe AS SET @dummy=1 /* QNO 17 CON_ID 21 */ /* QNO 18 CON_ID 21 */ 21 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES ( 4, 4 - 1, 4, REPEAT(CAST(4 AS CHAR(1)),@fill_amount)) /* QNO 19 CON_ID 21 */ 19 Query ROLLBACK /* QNO 21 CON_ID 19 */ 16 Query CREATE OR REPLACE VIEW transforms.view_12936_probe AS ALTER TABLE `table0_int` ADD KEY rkr_index_7 ( `pk`, `col_int` ) /* QNO 123 CON_ID 16 */ /* QNO 124 CON_ID 16 */ 16 Query ALTER TABLE `table0_int` ADD KEY rkr_index_8 ( `col_int` ) /* QNO 125 CON_ID 16 */ 19 Query CREATE OR REPLACE VIEW transforms.view_8236_probe AS ROLLBACK /* QNO 21 CON_ID 19 */ /* QNO 22 CON_ID 19 */ 19 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES ( 1, 1 - 1, 1, REPEAT(CAST(1 AS CHAR(1)),@fill_amount)) /* QNO 23 CON_ID 19 */ 21 Query COMMIT /* QNO 20 CON_ID 21 */ 21 Query CREATE OR REPLACE VIEW transforms.view_4616_probe AS COMMIT /* QNO 20 CON_ID 21 */ /* QNO 21 CON_ID 21 */ 21 Query ALTER TABLE t1 DROP KEY idx /* QNO 22 CON_ID 21 */ 19 Query COMMIT /* QNO 24 CON_ID 19 */ 19 Query CREATE OR REPLACE VIEW transforms.view_8236_probe AS COMMIT /* QNO 24 CON_ID 19 */ /* QNO 25 CON_ID 19 */ 171012 18:12:28 19 Query UPDATE t1 SET col3 = 1 LIMIT 2 /* QNO 26 CON_ID 19 */ 19 Query /* GenTest::Transform::DisableOptimizations */ SET @switch_saved = @@optimizer_switch /* QNO 27 CON_ID 19 */ 19 Query SET SESSION optimizer_switch = REPLACE( @@optimizer_switch, '=on', '=off' ) /* QNO 28 CON_ID 19 */ 16 Query CREATE OR REPLACE VIEW transforms.view_12936_probe AS ALTER TABLE `table0_int` ADD KEY rkr_index_8 ( `col_int` ) /* QNO 125 CON_ID 16 */ /* QNO 126 CON_ID 16 */ 19 Query SET SESSION optimizer_switch = 'in_to_exists=on' /* QNO 29 CON_ID 19 */ 19 Query UPDATE t1 SET col3 = 1 LIMIT 2 /* QNO 26 CON_ID 19 */ /* TRANSFORM_OUTCOME_UNORDERED_MATCH */ /* QNO 30 CON_ID 19 */ 16 Query ALTER TABLE `table0_int` ADD UNIQUE KEY rkr_index_9 ( `pk`, `col_int` ) /* QNO 127 CON_ID 16 */ 19 Query /* GenTest::Transform::DisableOptimizations */ /* TRANSFORM_CLEANUP */ SET SESSION optimizer_switch=@switch_saved /* QNO 31 CON_ID 19 */ 19 Query /* GenTest::Transform::EnableOptimizations */ SET @switch_saved = @@optimizer_switch /* QNO 32 CON_ID 19 */ 19 Query SET SESSION optimizer_switch = REPLACE( @@optimizer_switch, '=off', '=on' ) /* QNO 33 CON_ID 19 */ 19 Query SHOW WARNINGS 19 Query UPDATE t1 SET col3 = 1 LIMIT 2 /* QNO 26 CON_ID 19 */ /* TRANSFORM_OUTCOME_UNORDERED_MATCH */ /* QNO 34 CON_ID 19 */ 19 Query /* GenTest::Transform::EnableOptimizations */ /* TRANSFORM_CLEANUP */ SET SESSION optimizer_switch=@switch_saved /* QNO 35 CON_ID 19 */ 19 Query CREATE OR REPLACE VIEW transforms.view_8236_probe AS UPDATE t1 SET col3 = 1 LIMIT 2 /* QNO 26 CON_ID 19 */ /* QNO 36 CON_ID 19 */ 19 Query ROLLBACK /* QNO 37 CON_ID 19 */ 16 Query CREATE OR REPLACE VIEW transforms.view_12936_probe AS ALTER TABLE `table0_int` ADD UNIQUE KEY rkr_index_9 ( `pk`, `col_int` ) /* QNO 127 CON_ID 16 */ /* QNO 128 CON_ID 16 */ 16 Query ALTER TABLE `table0_int` ADD KEY rkr_index_10 ( `col_int`, `pk` ) /* QNO 129 CON_ID 16 */ 19 Query CREATE OR REPLACE VIEW transforms.view_8236_probe AS ROLLBACK /* QNO 37 CON_ID 19 */ /* QNO 38 CON_ID 19 */ 19 Query ALTER TABLE t1 ADD PRIMARY KEY ( col3 ), ADD FULLTEXT KEY ftidx ( col4 ) /* QNO 39 CON_ID 19 */ 18 Query ALTER TABLE t1 ADD KEY idx ( col3 ), ADD PRIMARY KEY ( col4(10), col3 ) /* QNO 24 CON_ID 18 */ 16 Query CREATE OR REPLACE VIEW transforms.view_12936_probe AS ALTER TABLE `table0_int` ADD KEY rkr_index_10 ( `col_int`, `pk` ) /* QNO 129 CON_ID 16 */ /* QNO 130 CON_ID 16 */ 17 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES ( 2, 2 - 1, 2, REPEAT(CAST(2 AS CHAR(1)),@fill_amount)) /* QNO 45 CON_ID 17 */ 16 Query ALTER TABLE `table0_int` ADD KEY rkr_index_11 ( `col_int`, `col_int` ) /* QNO 131 CON_ID 16 */ 21 Query UPDATE t1 SET col1 = 4 LIMIT 2 /* QNO 23 CON_ID 21 */ 17 Query CREATE OR REPLACE VIEW transforms.view_10968_probe AS INSERT INTO t1 (col1,col2,col3,col4) VALUES ( 2, 2 - 1, 2, REPEAT(CAST(2 AS CHAR(1)),@fill_amount)) /* QNO 45 CON_ID 17 */ /* QNO 46 CON_ID 17 */ 17 Query COMMIT /* QNO 47 CON_ID 17 */ 19 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES ( 1, 1, 1, REPEAT(CAST(1 AS CHAR(1)),@fill_amount)) /* QNO 40 CON_ID 19 */ 21 Query /* GenTest::Transform::DisableOptimizations */ SET @switch_saved = @@optimizer_switch /* QNO 24 CON_ID 21 */ 21 Query SET SESSION optimizer_switch = REPLACE( @@optimizer_switch, '=on', '=off' ) /* QNO 25 CON_ID 21 */ 18 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES ( 3, 3, 3 - 1, REPEAT(CAST(3 AS CHAR(1)),@fill_amount)) /* QNO 25 CON_ID 18 */ 21 Query SET SESSION optimizer_switch = 'in_to_exists=on' /* QNO 26 CON_ID 21 */ 21 Query UPDATE t1 SET col1 = 4 LIMIT 2 /* QNO 23 CON_ID 21 */ /* TRANSFORM_OUTCOME_UNORDERED_MATCH */ /* QNO 27 CON_ID 21 */ 21 Query /* GenTest::Transform::DisableOptimizations */ /* TRANSFORM_CLEANUP */ SET SESSION optimizer_switch=@switch_saved /* QNO 28 CON_ID 21 */ 21 Query /* GenTest::Transform::EnableOptimizations */ SET @switch_saved = @@optimizer_switch /* QNO 29 CON_ID 21 */ 16 Query ALTER TABLE `table0_int` ADD KEY rkr_index_12 ( `pk` ) /* QNO 132 CON_ID 16 */ 21 Query SET SESSION optimizer_switch = REPLACE( @@optimizer_switch, '=off', '=on' ) /* QNO 30 CON_ID 21 */ 21 Query SHOW WARNINGS 21 Query UPDATE t1 SET col1 = 4 LIMIT 2 /* QNO 23 CON_ID 21 */ /* TRANSFORM_OUTCOME_UNORDERED_MATCH */ /* QNO 31 CON_ID 21 */ 21 Query /* GenTest::Transform::EnableOptimizations */ /* TRANSFORM_CLEANUP */ SET SESSION optimizer_switch=@switch_saved /* QNO 32 CON_ID 21 */ 21 Query CREATE OR REPLACE VIEW transforms.view_4616_probe AS UPDATE t1 SET col1 = 4 LIMIT 2 /* QNO 23 CON_ID 21 */ /* QNO 33 CON_ID 21 */ 21 Query ROLLBACK /* QNO 34 CON_ID 21 */ 19 Query COMMIT /* QNO 41 CON_ID 19 */ 19 Query CREATE OR REPLACE VIEW transforms.view_8236_probe AS COMMIT /* QNO 41 CON_ID 19 */ /* QNO 42 CON_ID 19 */ 19 Query ALTER TABLE t1 ADD UNIQUE KEY uidx ( col2 ) /* QNO 43 CON_ID 19 */ 17 Query CREATE OR REPLACE VIEW transforms.view_10968_probe AS COMMIT /* QNO 47 CON_ID 17 */ /* QNO 48 CON_ID 17 */ 17 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES ( 4, 4, 4, REPEAT(CAST(4 AS CHAR(1)),@fill_amount)) /* QNO 49 CON_ID 17 */ 18 Query CREATE OR REPLACE VIEW transforms.view_3564_probe AS INSERT INTO t1 (col1,col2,col3,col4) VALUES ( 3, 3, 3 - 1, REPEAT(CAST(3 AS CHAR(1)),@fill_amount)) /* QNO 25 CON_ID 18 */ /* QNO 26 CON_ID 18 */ 18 Query COMMIT /* QNO 27 CON_ID 18 */ 21 Query CREATE OR REPLACE VIEW transforms.view_4616_probe AS ROLLBACK /* QNO 34 CON_ID 21 */ /* QNO 35 CON_ID 21 */ 21 Query ALTER TABLE t1 DROP KEY idx /* QNO 36 CON_ID 21 */ 18 Query CREATE OR REPLACE VIEW transforms.view_3564_probe AS COMMIT /* QNO 27 CON_ID 18 */ /* QNO 28 CON_ID 18 */ 18 Query ALTER TABLE t1 DROP KEY uidx /* QNO 29 CON_ID 18 */ 16 Query CREATE OR REPLACE VIEW transforms.view_12936_probe AS ALTER TABLE `table0_int` ADD KEY rkr_index_12 ( `pk` ) /* QNO 132 CON_ID 16 */ /* QNO 133 CON_ID 16 */ 16 Query ALTER TABLE `table0_int` ADD KEY rkr_index_13 ( `pk` ) /* QNO 134 CON_ID 16 */ 21 Query ALTER TABLE t1 ADD PRIMARY KEY ( col3 ), ADD FULLTEXT KEY ftidx ( col4 ) /* QNO 37 CON_ID 21 */ 21 Query CHECK TABLE t1 /* QNO 38 CON_ID 21 */ 17 Query ROLLBACK /* QNO 50 CON_ID 17 */ 18 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES ( 2, 2, 2, REPEAT(CAST(2 AS CHAR(1)),@fill_amount)) /* QNO 30 CON_ID 18 */ 17 Query CREATE OR REPLACE VIEW transforms.view_10968_probe AS ROLLBACK /* QNO 50 CON_ID 17 */ /* QNO 51 CON_ID 17 */ 18 Query COMMIT /* QNO 31 CON_ID 18 */ 18 Query CREATE OR REPLACE VIEW transforms.view_3564_probe AS COMMIT /* QNO 31 CON_ID 18 */ /* QNO 32 CON_ID 18 */ 19 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES ( 2, 2, 2, REPEAT(CAST(2 - 1 AS CHAR(1)),@fill_amount)) /* QNO 44 CON_ID 19 */ 17 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES ( 1, 1 - 1, 1, REPEAT(CAST(1 AS CHAR(1)),@fill_amount)) /* QNO 52 CON_ID 17 */ 19 Query ROLLBACK /* QNO 45 CON_ID 19 */ 19 Query CREATE OR REPLACE VIEW transforms.view_8236_probe AS ROLLBACK /* QNO 45 CON_ID 19 */ /* QNO 46 CON_ID 19 */ 17 Query COMMIT /* QNO 53 CON_ID 17 */ 18 Query DELETE FROM t1 WHERE col3 = 3 OR col3 IS NULL /* QNO 33 CON_ID 18 */ 19 Query ALTER TABLE t1 DROP KEY uidx, ADD UNIQUE KEY uidx ( col3 ) /* QNO 47 CON_ID 19 */ 17 Query CREATE OR REPLACE VIEW transforms.view_10968_probe AS COMMIT /* QNO 53 CON_ID 17 */ /* QNO 54 CON_ID 17 */ 18 Query /* GenTest::Transform::DisableOptimizations */ SET @switch_saved = @@optimizer_switch /* QNO 34 CON_ID 18 */ 21 Query CREATE OR REPLACE VIEW transforms.view_4616_probe AS CHECK TABLE t1 /* QNO 38 CON_ID 21 */ /* QNO 39 CON_ID 21 */ 19 Query ALTER TABLE t1 ADD KEY idx ( col4(10), col2 ) /* QNO 48 CON_ID 19 */ 18 Query SET SESSION optimizer_switch = REPLACE( @@optimizer_switch, '=on', '=off' ) /* QNO 35 CON_ID 18 */ 21 Query ALTER TABLE t1 DROP KEY uidx /* QNO 40 CON_ID 21 */ 18 Query SET SESSION optimizer_switch = 'in_to_exists=on' /* QNO 36 CON_ID 18 */ 17 Query DELETE FROM t1 WHERE MATCH(col4) AGAINST (TRIM(' 2 ') IN BOOLEAN MODE) OR col1 IS NULL /* QNO 55 CON_ID 17 */ 18 Query DELETE FROM t1 WHERE col3 = 3 OR col3 IS NULL /* QNO 33 CON_ID 18 */ /* TRANSFORM_OUTCOME_UNORDERED_MATCH */ /* QNO 37 CON_ID 18 */ 17 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES /* 1 */ (1,1,1,REPEAT(CAST(1 AS CHAR(1)),@fill_amount)), (1,1,1,REPEAT(CAST(1 AS CHAR(1)),@fill_amount)) /* QNO 56 CON_ID 17 */ 18 Query /* GenTest::Transform::DisableOptimizations */ /* TRANSFORM_CLEANUP */ SET SESSION optimizer_switch=@switch_saved /* QNO 38 CON_ID 18 */ 18 Query /* GenTest::Transform::EnableOptimizations */ SET @switch_saved = @@optimizer_switch /* QNO 39 CON_ID 18 */ 18 Query SET SESSION optimizer_switch = REPLACE( @@optimizer_switch, '=off', '=on' ) /* QNO 40 CON_ID 18 */ 18 Query SHOW WARNINGS 18 Query DELETE FROM t1 WHERE col3 = 3 OR col3 IS NULL /* QNO 33 CON_ID 18 */ /* TRANSFORM_OUTCOME_UNORDERED_MATCH */ /* QNO 41 CON_ID 18 */ 18 Query /* GenTest::Transform::EnableOptimizations */ /* TRANSFORM_CLEANUP */ SET SESSION optimizer_switch=@switch_saved /* QNO 42 CON_ID 18 */ 18 Query CREATE OR REPLACE VIEW transforms.view_3564_probe AS DELETE FROM t1 WHERE col3 = 3 OR col3 IS NULL /* QNO 33 CON_ID 18 */ /* QNO 43 CON_ID 18 */ 18 Query COMMIT /* QNO 44 CON_ID 18 */ 18 Query CREATE OR REPLACE VIEW transforms.view_3564_probe AS COMMIT /* QNO 44 CON_ID 18 */ /* QNO 45 CON_ID 18 */ 17 Query ROLLBACK /* QNO 57 CON_ID 17 */ 18 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES ( 4, 4, 4, REPEAT(CAST(4 AS CHAR(1)),@fill_amount)) /* QNO 46 CON_ID 18 */ 17 Query CREATE OR REPLACE VIEW transforms.view_10968_probe AS ROLLBACK /* QNO 57 CON_ID 17 */ /* QNO 58 CON_ID 17 */ 17 Query ALTER TABLE t1 DROP PRIMARY KEY /* QNO 59 CON_ID 17 */ 16 Query SHOW WARNINGS 16 Query ALTER TABLE `table0_int` ADD KEY rkr_index_14 ( `pk` ) /* QNO 135 CON_ID 16 */ 18 Query ROLLBACK /* QNO 47 CON_ID 18 */ 18 Query CREATE OR REPLACE VIEW transforms.view_3564_probe AS ROLLBACK /* QNO 47 CON_ID 18 */ /* QNO 48 CON_ID 18 */ 18 Query DELETE FROM t1 WHERE MATCH(col4) AGAINST (TRIM(' 3 ') IN BOOLEAN MODE) OR col2 IS NULL /* QNO 49 CON_ID 18 */ 18 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES /* 1 */ (1,1,1,REPEAT(CAST(1 AS CHAR(1)),@fill_amount)), (1,1,1,REPEAT(CAST(1 AS CHAR(1)),@fill_amount)) /* QNO 50 CON_ID 18 */ 18 Query ROLLBACK /* QNO 51 CON_ID 18 */ 18 Query CREATE OR REPLACE VIEW transforms.view_3564_probe AS ROLLBACK /* QNO 51 CON_ID 18 */ /* QNO 52 CON_ID 18 */ 18 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES ( 4, 4 - 1, 4, REPEAT(CAST(4 AS CHAR(1)),@fill_amount)) /* QNO 53 CON_ID 18 */ 18 Query ROLLBACK /* QNO 54 CON_ID 18 */ 18 Query CREATE OR REPLACE VIEW transforms.view_3564_probe AS ROLLBACK /* QNO 54 CON_ID 18 */ /* QNO 55 CON_ID 18 */ 18 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES ( 3, 3 - 1, 3, REPEAT(CAST(3 AS CHAR(1)),@fill_amount)) /* QNO 56 CON_ID 18 */ 18 Query COMMIT /* QNO 57 CON_ID 18 */ 18 Query CREATE OR REPLACE VIEW transforms.view_3564_probe AS COMMIT /* QNO 57 CON_ID 18 */ /* QNO 58 CON_ID 18 */ 18 Query ALTER TABLE t1 ADD KEY idx ( col4(10), col2 ) /* QNO 59 CON_ID 18 */ 16 Query SHOW WARNINGS 16 Query ALTER TABLE `table0_int` ADD KEY rkr_index_15 ( `col_int` ) /* QNO 136 CON_ID 16 */ 16 Query SHOW WARNINGS 21 Query ALTER TABLE t1 DROP KEY ftidx /* QNO 41 CON_ID 21 */ 19 Query CREATE OR REPLACE VIEW transforms.view_8236_probe AS ALTER TABLE t1 ADD KEY idx ( col4(10), col2 ) /* QNO 48 CON_ID 19 */ /* QNO 49 CON_ID 19 */ 16 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES ( 2, 2, 2 - 1, REPEAT(CAST(2 AS CHAR(1)),@fill_amount)) /* QNO 137 CON_ID 16 */ 19 Query ALTER TABLE t1 ADD PRIMARY KEY ( col1 ) /* QNO 50 CON_ID 19 */ 171012 18:12:29 18 Query DELETE FROM t1 WHERE MATCH(col4) AGAINST (TRIM(' 3 ') IN BOOLEAN MODE) OR col3 IS NULL /* QNO 60 CON_ID 18 */ 21 Query ALTER TABLE t1 DROP KEY idx /* QNO 42 CON_ID 21 */ 16 Query CREATE OR REPLACE VIEW transforms.view_12936_probe AS INSERT INTO t1 (col1,col2,col3,col4) VALUES ( 2, 2, 2 - 1, REPEAT(CAST(2 AS CHAR(1)),@fill_amount)) /* QNO 137 CON_ID 16 */ /* QNO 138 CON_ID 16 */ 17 Query CREATE OR REPLACE VIEW transforms.view_10968_probe AS ALTER TABLE t1 DROP PRIMARY KEY /* QNO 59 CON_ID 17 */ /* QNO 60 CON_ID 17 */ 16 Query COMMIT /* QNO 139 CON_ID 16 */ 17 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES ( 1, 1, 1, REPEAT(CAST(1 AS CHAR(1)),@fill_amount)) /* QNO 61 CON_ID 17 */ 16 Query CREATE OR REPLACE VIEW transforms.view_12936_probe AS COMMIT /* QNO 139 CON_ID 16 */ /* QNO 140 CON_ID 16 */ 16 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES ( 1, 1, 1 - 1, REPEAT(CAST(1 AS CHAR(1)),@fill_amount)) /* QNO 141 CON_ID 16 */ 19 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES ( 4, 4, 4, REPEAT(CAST(4 - 1 AS CHAR(1)),@fill_amount)) /* QNO 51 CON_ID 19 */ 18 Query COMMIT /* QNO 61 CON_ID 18 */ 18 Query CREATE OR REPLACE VIEW transforms.view_3564_probe AS COMMIT /* QNO 61 CON_ID 18 */ /* QNO 62 CON_ID 18 */ 17 Query CREATE OR REPLACE VIEW transforms.view_10968_probe AS INSERT INTO t1 (col1,col2,col3,col4) VALUES ( 1, 1, 1, REPEAT(CAST(1 AS CHAR(1)),@fill_amount)) /* QNO 61 CON_ID 17 */ /* QNO 62 CON_ID 17 */ 18 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES ( 3, 3, 3, REPEAT(CAST(3 AS CHAR(1)),@fill_amount)) /* QNO 63 CON_ID 18 */ 17 Query ROLLBACK /* QNO 63 CON_ID 17 */ 16 Query CREATE OR REPLACE VIEW transforms.view_12936_probe AS INSERT INTO t1 (col1,col2,col3,col4) VALUES ( 1, 1, 1 - 1, REPEAT(CAST(1 AS CHAR(1)),@fill_amount)) /* QNO 141 CON_ID 16 */ /* QNO 142 CON_ID 16 */ 16 Query ROLLBACK /* QNO 143 CON_ID 16 */ 17 Query CREATE OR REPLACE VIEW transforms.view_10968_probe AS ROLLBACK /* QNO 63 CON_ID 17 */ /* QNO 64 CON_ID 17 */ 16 Query CREATE OR REPLACE VIEW transforms.view_12936_probe AS ROLLBACK /* QNO 143 CON_ID 16 */ /* QNO 144 CON_ID 16 */ 17 Query DELETE FROM t1 WHERE col1 = 4 OR col1 IS NULL /* QNO 65 CON_ID 17 */ 16 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES ( 3, 3, 3, REPEAT(CAST(3 AS CHAR(1)),@fill_amount)) /* QNO 145 CON_ID 16 */ 18 Query CREATE OR REPLACE VIEW transforms.view_3564_probe AS INSERT INTO t1 (col1,col2,col3,col4) VALUES ( 3, 3, 3, REPEAT(CAST(3 AS CHAR(1)),@fill_amount)) /* QNO 63 CON_ID 18 */ /* QNO 64 CON_ID 18 */ 19 Query CREATE OR REPLACE VIEW transforms.view_8236_probe AS INSERT INTO t1 (col1,col2,col3,col4) VALUES ( 4, 4, 4, REPEAT(CAST(4 - 1 AS CHAR(1)),@fill_amount)) /* QNO 51 CON_ID 19 */ /* QNO 52 CON_ID 19 */ 18 Query ROLLBACK /* QNO 65 CON_ID 18 */ 19 Query ROLLBACK /* QNO 53 CON_ID 19 */ 18 Query CREATE OR REPLACE VIEW transforms.view_3564_probe AS ROLLBACK /* QNO 65 CON_ID 18 */ /* QNO 66 CON_ID 18 */ 18 Query ALTER TABLE t1 ADD KEY idx ( col4(10) ) /* QNO 67 CON_ID 18 */ 19 Query CREATE OR REPLACE VIEW transforms.view_8236_probe AS ROLLBACK /* QNO 53 CON_ID 19 */ /* QNO 54 CON_ID 19 */ 19 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES ( NULL, NULL, NULL, REPEAT(CAST(NULL - 1 AS CHAR(1)),@fill_amount)) /* QNO 55 CON_ID 19 */ 21 Query CREATE OR REPLACE VIEW transforms.view_4616_probe AS ALTER TABLE t1 DROP KEY idx /* QNO 42 CON_ID 21 */ /* QNO 43 CON_ID 21 */ 21 Query ALTER TABLE t1 DROP PRIMARY KEY, ADD PRIMARY KEY ( col2 ) /* QNO 44 CON_ID 21 */ 19 Query ROLLBACK /* QNO 56 CON_ID 19 */ 17 Query /* GenTest::Transform::DisableOptimizations */ SET @switch_saved = @@optimizer_switch /* QNO 66 CON_ID 17 */ 17 Query SET SESSION optimizer_switch = REPLACE( @@optimizer_switch, '=on', '=off' ) /* QNO 67 CON_ID 17 */ 19 Query CREATE OR REPLACE VIEW transforms.view_8236_probe AS ROLLBACK /* QNO 56 CON_ID 19 */ /* QNO 57 CON_ID 19 */ 17 Query SET SESSION optimizer_switch = 'in_to_exists=on' /* QNO 68 CON_ID 17 */ 17 Query DELETE FROM t1 WHERE col1 = 4 OR col1 IS NULL /* QNO 65 CON_ID 17 */ /* TRANSFORM_OUTCOME_UNORDERED_MATCH */ /* QNO 69 CON_ID 17 */ 17 Query /* GenTest::Transform::DisableOptimizations */ /* TRANSFORM_CLEANUP */ SET SESSION optimizer_switch=@switch_saved /* QNO 70 CON_ID 17 */ 17 Query /* GenTest::Transform::EnableOptimizations */ SET @switch_saved = @@optimizer_switch /* QNO 71 CON_ID 17 */ 17 Query SET SESSION optimizer_switch = REPLACE( @@optimizer_switch, '=off', '=on' ) /* QNO 72 CON_ID 17 */ 17 Query SHOW WARNINGS 17 Query DELETE FROM t1 WHERE col1 = 4 OR col1 IS NULL /* QNO 65 CON_ID 17 */ /* TRANSFORM_OUTCOME_UNORDERED_MATCH */ /* QNO 73 CON_ID 17 */ 17 Query /* GenTest::Transform::EnableOptimizations */ /* TRANSFORM_CLEANUP */ SET SESSION optimizer_switch=@switch_saved /* QNO 74 CON_ID 17 */ 19 Query ALTER TABLE t1 DROP KEY ftidx /* QNO 58 CON_ID 19 */ 17 Query CREATE OR REPLACE VIEW transforms.view_10968_probe AS DELETE FROM t1 WHERE col1 = 4 OR col1 IS NULL /* QNO 65 CON_ID 17 */ /* QNO 75 CON_ID 17 */ 17 Query COMMIT /* QNO 76 CON_ID 17 */ 16 Query CREATE OR REPLACE VIEW transforms.view_12936_probe AS INSERT INTO t1 (col1,col2,col3,col4) VALUES ( 3, 3, 3, REPEAT(CAST(3 AS CHAR(1)),@fill_amount)) /* QNO 145 CON_ID 16 */ /* QNO 146 CON_ID 16 */ 16 Query ROLLBACK /* QNO 147 CON_ID 16 */ 17 Query CREATE OR REPLACE VIEW transforms.view_10968_probe AS COMMIT /* QNO 76 CON_ID 17 */ /* QNO 77 CON_ID 17 */ 17 Query ALTER TABLE t1 ADD COLUMN extra INT /* QNO 78 CON_ID 17 */ 16 Query CREATE OR REPLACE VIEW transforms.view_12936_probe AS ROLLBACK /* QNO 147 CON_ID 16 */ /* QNO 148 CON_ID 16 */ 16 Query ALTER TABLE t1 DROP KEY uidx, ADD UNIQUE KEY uidx ( col2 ) /* QNO 149 CON_ID 16 */ 18 Query CREATE OR REPLACE VIEW transforms.view_3564_probe AS ALTER TABLE t1 ADD KEY idx ( col4(10) ) /* QNO 67 CON_ID 18 */ /* QNO 68 CON_ID 18 */ 21 Query ALTER TABLE t1 ADD UNIQUE KEY uidx ( col4(10), col2 ) /* QNO 45 CON_ID 21 */ 19 Query ALTER TABLE t1 DROP KEY uidx /* QNO 59 CON_ID 19 */ 18 Query ALTER TABLE t1 DROP KEY idx /* QNO 69 CON_ID 18 */ 16 Query UPDATE t1 SET col3 = 1 LIMIT 2 /* QNO 150 CON_ID 16 */ 17 Query CREATE OR REPLACE VIEW transforms.view_10968_probe AS ALTER TABLE t1 ADD COLUMN extra INT /* QNO 78 CON_ID 17 */ /* QNO 79 CON_ID 17 */ 17 Query UPDATE t1 SET extra = col2 /* QNO 80 CON_ID 17 */ 16 Query /* GenTest::Transform::DisableOptimizations */ SET @switch_saved = @@optimizer_switch /* QNO 151 CON_ID 16 */ 16 Query SET SESSION optimizer_switch = REPLACE( @@optimizer_switch, '=on', '=off' ) /* QNO 152 CON_ID 16 */ 16 Query SET SESSION optimizer_switch = 'in_to_exists=on' /* QNO 153 CON_ID 16 */ 16 Query UPDATE t1 SET col3 = 1 LIMIT 2 /* QNO 150 CON_ID 16 */ /* TRANSFORM_OUTCOME_UNORDERED_MATCH */ /* QNO 154 CON_ID 16 */ 16 Query /* GenTest::Transform::DisableOptimizations */ /* TRANSFORM_CLEANUP */ SET SESSION optimizer_switch=@switch_saved /* QNO 155 CON_ID 16 */ 16 Query /* GenTest::Transform::EnableOptimizations */ SET @switch_saved = @@optimizer_switch /* QNO 156 CON_ID 16 */ 16 Query SET SESSION optimizer_switch = REPLACE( @@optimizer_switch, '=off', '=on' ) /* QNO 157 CON_ID 16 */ 16 Query SHOW WARNINGS 16 Query UPDATE t1 SET col3 = 1 LIMIT 2 /* QNO 150 CON_ID 16 */ /* TRANSFORM_OUTCOME_UNORDERED_MATCH */ /* QNO 158 CON_ID 16 */ 16 Query /* GenTest::Transform::EnableOptimizations */ /* TRANSFORM_CLEANUP */ SET SESSION optimizer_switch=@switch_saved /* QNO 159 CON_ID 16 */ 16 Query CREATE OR REPLACE VIEW transforms.view_12936_probe AS UPDATE t1 SET col3 = 1 LIMIT 2 /* QNO 150 CON_ID 16 */ /* QNO 160 CON_ID 16 */ 16 Query ROLLBACK /* QNO 161 CON_ID 16 */ 17 Query /* GenTest::Transform::DisableOptimizations */ SET @switch_saved = @@optimizer_switch /* QNO 81 CON_ID 17 */ 17 Query SET SESSION optimizer_switch = REPLACE( @@optimizer_switch, '=on', '=off' ) /* QNO 82 CON_ID 17 */ 17 Query SET SESSION optimizer_switch = 'in_to_exists=on' /* QNO 83 CON_ID 17 */ 17 Query UPDATE t1 SET extra = col2 /* QNO 80 CON_ID 17 */ /* TRANSFORM_OUTCOME_UNORDERED_MATCH */ /* QNO 84 CON_ID 17 */ 17 Query /* GenTest::Transform::DisableOptimizations */ /* TRANSFORM_CLEANUP */ SET SESSION optimizer_switch=@switch_saved /* QNO 85 CON_ID 17 */ 17 Query /* GenTest::Transform::EnableOptimizations */ SET @switch_saved = @@optimizer_switch /* QNO 86 CON_ID 17 */ 17 Query SET SESSION optimizer_switch = REPLACE( @@optimizer_switch, '=off', '=on' ) /* QNO 87 CON_ID 17 */ 17 Query SHOW WARNINGS 17 Query UPDATE t1 SET extra = col2 /* QNO 80 CON_ID 17 */ /* TRANSFORM_OUTCOME_UNORDERED_MATCH */ /* QNO 88 CON_ID 17 */ 17 Query /* GenTest::Transform::EnableOptimizations */ /* TRANSFORM_CLEANUP */ SET SESSION optimizer_switch=@switch_saved /* QNO 89 CON_ID 17 */ 17 Query CREATE OR REPLACE VIEW transforms.view_10968_probe AS UPDATE t1 SET extra = col2 /* QNO 80 CON_ID 17 */ /* QNO 90 CON_ID 17 */ 17 Query ALTER TABLE t1 DROP COLUMN col2 /* QNO 91 CON_ID 17 */ 171012 18:12:30 16 Query CREATE OR REPLACE VIEW transforms.view_12936_probe AS ROLLBACK /* QNO 161 CON_ID 16 */ /* QNO 162 CON_ID 16 */ 16 Query ALTER TABLE t1 ADD KEY idx ( col2 ) /* QNO 163 CON_ID 16 */ 21 Query CREATE OR REPLACE VIEW transforms.view_4616_probe AS ALTER TABLE t1 ADD UNIQUE KEY uidx ( col4(10), col2 ) /* QNO 45 CON_ID 21 */ /* QNO 46 CON_ID 21 */ 21 Query CHECK TABLE t1 /* QNO 47 CON_ID 21 */ 19 Query CREATE OR REPLACE VIEW transforms.view_8236_probe AS ALTER TABLE t1 DROP KEY uidx /* QNO 59 CON_ID 19 */ /* QNO 60 CON_ID 19 */ 19 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES ( NULL, NULL, NULL, REPEAT(CAST(NULL - 1 AS CHAR(1)),@fill_amount)) /* QNO 61 CON_ID 19 */ 19 Query COMMIT /* QNO 62 CON_ID 19 */ 19 Query CREATE OR REPLACE VIEW transforms.view_8236_probe AS COMMIT /* QNO 62 CON_ID 19 */ /* QNO 63 CON_ID 19 */ 19 Query ALTER TABLE t1 DROP KEY ftidx /* QNO 64 CON_ID 19 */ 21 Query CREATE OR REPLACE VIEW transforms.view_4616_probe AS CHECK TABLE t1 /* QNO 47 CON_ID 21 */ /* QNO 48 CON_ID 21 */ 21 Query ALTER TABLE t1 DROP KEY idx /* QNO 49 CON_ID 21 */ 18 Query CREATE OR REPLACE VIEW transforms.view_3564_probe AS ALTER TABLE t1 DROP KEY idx /* QNO 69 CON_ID 18 */ /* QNO 70 CON_ID 18 */ 18 Query UPDATE t1 SET col1 = NULL LIMIT 2 /* QNO 71 CON_ID 18 */ 18 Query /* GenTest::Transform::DisableOptimizations */ SET @switch_saved = @@optimizer_switch /* QNO 72 CON_ID 18 */ 18 Query SET SESSION optimizer_switch = REPLACE( @@optimizer_switch, '=on', '=off' ) /* QNO 73 CON_ID 18 */ 18 Query SET SESSION optimizer_switch = 'in_to_exists=on' /* QNO 74 CON_ID 18 */ 18 Query UPDATE t1 SET col1 = NULL LIMIT 2 /* QNO 71 CON_ID 18 */ /* TRANSFORM_OUTCOME_UNORDERED_MATCH */ /* QNO 75 CON_ID 18 */ 18 Query /* GenTest::Transform::DisableOptimizations */ /* TRANSFORM_CLEANUP */ SET SESSION optimizer_switch=@switch_saved /* QNO 76 CON_ID 18 */ 18 Query /* GenTest::Transform::EnableOptimizations */ SET @switch_saved = @@optimizer_switch /* QNO 77 CON_ID 18 */ 18 Query SET SESSION optimizer_switch = REPLACE( @@optimizer_switch, '=off', '=on' ) /* QNO 78 CON_ID 18 */ 18 Query SHOW WARNINGS 18 Query UPDATE t1 SET col1 = NULL LIMIT 2 /* QNO 71 CON_ID 18 */ /* TRANSFORM_OUTCOME_UNORDERED_MATCH */ /* QNO 79 CON_ID 18 */ 18 Query /* GenTest::Transform::EnableOptimizations */ /* TRANSFORM_CLEANUP */ SET SESSION optimizer_switch=@switch_saved /* QNO 80 CON_ID 18 */ 18 Query CREATE OR REPLACE VIEW transforms.view_3564_probe AS UPDATE t1 SET col1 = NULL LIMIT 2 /* QNO 71 CON_ID 18 */ /* QNO 81 CON_ID 18 */ 18 Query ROLLBACK /* QNO 82 CON_ID 18 */ 18 Query CREATE OR REPLACE VIEW transforms.view_3564_probe AS ROLLBACK /* QNO 82 CON_ID 18 */ /* QNO 83 CON_ID 18 */ 18 Query DELETE FROM t1 WHERE col1 = 1 OR col1 IS NULL /* QNO 84 CON_ID 18 */ 18 Query /* GenTest::Transform::DisableOptimizations */ SET @switch_saved = @@optimizer_switch /* QNO 85 CON_ID 18 */ 18 Query SET SESSION optimizer_switch = REPLACE( @@optimizer_switch, '=on', '=off' ) /* QNO 86 CON_ID 18 */ 18 Query SET SESSION optimizer_switch = 'in_to_exists=on' /* QNO 87 CON_ID 18 */ 18 Query DELETE FROM t1 WHERE col1 = 1 OR col1 IS NULL /* QNO 84 CON_ID 18 */ /* TRANSFORM_OUTCOME_UNORDERED_MATCH */ /* QNO 88 CON_ID 18 */ 18 Query /* GenTest::Transform::DisableOptimizations */ /* TRANSFORM_CLEANUP */ SET SESSION optimizer_switch=@switch_saved /* QNO 89 CON_ID 18 */ 18 Query /* GenTest::Transform::EnableOptimizations */ SET @switch_saved = @@optimizer_switch /* QNO 90 CON_ID 18 */ 18 Query SET SESSION optimizer_switch = REPLACE( @@optimizer_switch, '=off', '=on' ) /* QNO 91 CON_ID 18 */ 18 Query SHOW WARNINGS 18 Query DELETE FROM t1 WHERE col1 = 1 OR col1 IS NULL /* QNO 84 CON_ID 18 */ /* TRANSFORM_OUTCOME_UNORDERED_MATCH */ /* QNO 92 CON_ID 18 */ 18 Query /* GenTest::Transform::EnableOptimizations */ /* TRANSFORM_CLEANUP */ SET SESSION optimizer_switch=@switch_saved /* QNO 93 CON_ID 18 */ 18 Query CREATE OR REPLACE VIEW transforms.view_3564_probe AS DELETE FROM t1 WHERE col1 = 1 OR col1 IS NULL /* QNO 84 CON_ID 18 */ /* QNO 94 CON_ID 18 */ 18 Query COMMIT /* QNO 95 CON_ID 18 */ 18 Query CREATE OR REPLACE VIEW transforms.view_3564_probe AS COMMIT /* QNO 95 CON_ID 18 */ /* QNO 96 CON_ID 18 */ 18 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES ( 4, 4, 4, REPEAT(CAST(4 - 1 AS CHAR(1)),@fill_amount)) /* QNO 97 CON_ID 18 */ 16 Query CREATE OR REPLACE VIEW transforms.view_12936_probe AS ALTER TABLE t1 ADD KEY idx ( col2 ) /* QNO 163 CON_ID 16 */ /* QNO 164 CON_ID 16 */ 18 Query CREATE OR REPLACE VIEW transforms.view_3564_probe AS INSERT INTO t1 (col1,col2,col3,col4) VALUES ( 4, 4, 4, REPEAT(CAST(4 - 1 AS CHAR(1)),@fill_amount)) /* QNO 97 CON_ID 18 */ /* QNO 98 CON_ID 18 */ 18 Query ROLLBACK /* QNO 99 CON_ID 18 */ 16 Query DELETE FROM t1 WHERE col2 = 2 OR col2 IS NULL /* QNO 165 CON_ID 16 */ 16 Query /* GenTest::Transform::DisableOptimizations */ SET @switch_saved = @@optimizer_switch /* QNO 166 CON_ID 16 */ 16 Query SET SESSION optimizer_switch = REPLACE( @@optimizer_switch, '=on', '=off' ) /* QNO 167 CON_ID 16 */ 16 Query SET SESSION optimizer_switch = 'in_to_exists=on' /* QNO 168 CON_ID 16 */ 16 Query DELETE FROM t1 WHERE col2 = 2 OR col2 IS NULL /* QNO 165 CON_ID 16 */ /* TRANSFORM_OUTCOME_UNORDERED_MATCH */ /* QNO 169 CON_ID 16 */ 16 Query /* GenTest::Transform::DisableOptimizations */ /* TRANSFORM_CLEANUP */ SET SESSION optimizer_switch=@switch_saved /* QNO 170 CON_ID 16 */ 16 Query /* GenTest::Transform::EnableOptimizations */ SET @switch_saved = @@optimizer_switch /* QNO 171 CON_ID 16 */ 16 Query SET SESSION optimizer_switch = REPLACE( @@optimizer_switch, '=off', '=on' ) /* QNO 172 CON_ID 16 */ 16 Query SHOW WARNINGS 16 Query DELETE FROM t1 WHERE col2 = 2 OR col2 IS NULL /* QNO 165 CON_ID 16 */ /* TRANSFORM_OUTCOME_UNORDERED_MATCH */ /* QNO 173 CON_ID 16 */ 18 Query CREATE OR REPLACE VIEW transforms.view_3564_probe AS ROLLBACK /* QNO 99 CON_ID 18 */ /* QNO 100 CON_ID 18 */ 18 Query ALTER TABLE t1 ADD COLUMN extra INT /* QNO 101 CON_ID 18 */ 16 Query /* GenTest::Transform::EnableOptimizations */ /* TRANSFORM_CLEANUP */ SET SESSION optimizer_switch=@switch_saved /* QNO 174 CON_ID 16 */ 16 Query CREATE OR REPLACE VIEW transforms.view_12936_probe AS DELETE FROM t1 WHERE col2 = 2 OR col2 IS NULL /* QNO 165 CON_ID 16 */ /* QNO 175 CON_ID 16 */ 16 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES /* NULL */ (NULL,NULL,NULL,REPEAT(CAST(NULL AS CHAR(1)),@fill_amount)), (NULL,NULL,NULL,REPEAT(CAST(NULL AS CHAR(1)),@fill_amount)) /* QNO 176 CON_ID 16 */ 16 Query SHOW WARNINGS 16 Query ROLLBACK /* QNO 177 CON_ID 16 */ 16 Query CREATE OR REPLACE VIEW transforms.view_12936_probe AS ROLLBACK /* QNO 177 CON_ID 16 */ /* QNO 178 CON_ID 16 */ 16 Query ALTER TABLE t1 ADD COLUMN extra INT /* QNO 179 CON_ID 16 */ 19 Query ALTER TABLE t1 DROP PRIMARY KEY /* QNO 65 CON_ID 19 */ 17 Query CREATE OR REPLACE VIEW transforms.view_10968_probe AS ALTER TABLE t1 DROP COLUMN col2 /* QNO 91 CON_ID 17 */ /* QNO 92 CON_ID 17 */ 18 Query UPDATE t1 SET extra = col1 /* QNO 102 CON_ID 18 */ 19 Query ALTER TABLE t1 DROP KEY ftidx /* QNO 66 CON_ID 19 */ 21 Query ALTER TABLE t1 ADD KEY idx ( col4(10) ) /* QNO 50 CON_ID 21 */ 16 Query UPDATE t1 SET extra = col3 /* QNO 180 CON_ID 16 */ 18 Query /* GenTest::Transform::DisableOptimizations */ SET @switch_saved = @@optimizer_switch /* QNO 103 CON_ID 18 */ 17 Query ALTER TABLE t1 CHANGE COLUMN extra col2 INT /* QNO 93 CON_ID 17 */ 18 Query SET SESSION optimizer_switch = REPLACE( @@optimizer_switch, '=on', '=off' ) /* QNO 104 CON_ID 18 */ 18 Query SET SESSION optimizer_switch = 'in_to_exists=on' /* QNO 105 CON_ID 18 */ 18 Query UPDATE t1 SET extra = col1 /* QNO 102 CON_ID 18 */ /* TRANSFORM_OUTCOME_UNORDERED_MATCH */ /* QNO 106 CON_ID 18 */ 18 Query /* GenTest::Transform::DisableOptimizations */ /* TRANSFORM_CLEANUP */ SET SESSION optimizer_switch=@switch_saved /* QNO 107 CON_ID 18 */ 18 Query /* GenTest::Transform::EnableOptimizations */ SET @switch_saved = @@optimizer_switch /* QNO 108 CON_ID 18 */ 18 Query SET SESSION optimizer_switch = REPLACE( @@optimizer_switch, '=off', '=on' ) /* QNO 109 CON_ID 18 */ 18 Query SHOW WARNINGS 18 Query UPDATE t1 SET extra = col1 /* QNO 102 CON_ID 18 */ /* TRANSFORM_OUTCOME_UNORDERED_MATCH */ /* QNO 110 CON_ID 18 */ 18 Query /* GenTest::Transform::EnableOptimizations */ /* TRANSFORM_CLEANUP */ SET SESSION optimizer_switch=@switch_saved /* QNO 111 CON_ID 18 */ 18 Query CREATE OR REPLACE VIEW transforms.view_3564_probe AS UPDATE t1 SET extra = col1 /* QNO 102 CON_ID 18 */ /* QNO 112 CON_ID 18 */ 18 Query ALTER TABLE t1 DROP COLUMN col1 /* QNO 113 CON_ID 18 */ 171012 18:12:31 16 Query /* GenTest::Transform::DisableOptimizations */ SET @switch_saved = @@optimizer_switch /* QNO 181 CON_ID 16 */ 16 Query SET SESSION optimizer_switch = REPLACE( @@optimizer_switch, '=on', '=off' ) /* QNO 182 CON_ID 16 */ 16 Query SET SESSION optimizer_switch = 'in_to_exists=on' /* QNO 183 CON_ID 16 */ 16 Query UPDATE t1 SET extra = col3 /* QNO 180 CON_ID 16 */ /* TRANSFORM_OUTCOME_UNORDERED_MATCH */ /* QNO 184 CON_ID 16 */ 16 Query /* GenTest::Transform::DisableOptimizations */ /* TRANSFORM_CLEANUP */ SET SESSION optimizer_switch=@switch_saved /* QNO 185 CON_ID 16 */ 16 Query /* GenTest::Transform::EnableOptimizations */ SET @switch_saved = @@optimizer_switch /* QNO 186 CON_ID 16 */ 16 Query SET SESSION optimizer_switch = REPLACE( @@optimizer_switch, '=off', '=on' ) /* QNO 187 CON_ID 16 */ 16 Query SHOW WARNINGS 16 Query UPDATE t1 SET extra = col3 /* QNO 180 CON_ID 16 */ /* TRANSFORM_OUTCOME_UNORDERED_MATCH */ /* QNO 188 CON_ID 16 */ 16 Query /* GenTest::Transform::EnableOptimizations */ /* TRANSFORM_CLEANUP */ SET SESSION optimizer_switch=@switch_saved /* QNO 189 CON_ID 16 */ 16 Query CREATE OR REPLACE VIEW transforms.view_12936_probe AS UPDATE t1 SET extra = col3 /* QNO 180 CON_ID 16 */ /* QNO 190 CON_ID 16 */ 16 Query ALTER TABLE t1 DROP COLUMN col3 /* QNO 191 CON_ID 16 */ 21 Query CREATE OR REPLACE VIEW transforms.view_4616_probe AS ALTER TABLE t1 ADD KEY idx ( col4(10) ) /* QNO 50 CON_ID 21 */ /* QNO 51 CON_ID 21 */ 19 Query ALTER TABLE t1 ADD PRIMARY KEY ( col2 ), ADD FULLTEXT KEY ftidx ( col4 ) /* QNO 67 CON_ID 19 */ 21 Query DELETE FROM t1 WHERE MATCH(col4) AGAINST (TRIM(' 3 ') IN BOOLEAN MODE) OR col3 IS NULL /* QNO 52 CON_ID 21 */ 17 Query CREATE OR REPLACE VIEW transforms.view_10968_probe AS ALTER TABLE t1 CHANGE COLUMN extra col2 INT /* QNO 93 CON_ID 17 */ /* QNO 94 CON_ID 17 */ 21 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES /* 1 */ (1,1,1,REPEAT(CAST(1 AS CHAR(1)),@fill_amount)), (1,1,1,REPEAT(CAST(1 AS CHAR(1)),@fill_amount)) /* QNO 53 CON_ID 21 */ 17 Query ALTER TABLE t1 ADD UNIQUE KEY uidx ( col4(10), col1 ) /* QNO 95 CON_ID 17 */ 21 Query CREATE OR REPLACE VIEW transforms.view_4616_probe AS INSERT INTO t1 (col1,col2,col3,col4) VALUES /* 1 */ (1,1,1,REPEAT(CAST(1 AS CHAR(1)),@fill_amount)), (1,1,1,REPEAT(CAST(1 AS CHAR(1)),@fill_amount)) /* QNO 53 CON_ID 21 */ /* QNO 54 CON_ID 21 */ 21 Query COMMIT /* QNO 55 CON_ID 21 */ 21 Query CREATE OR REPLACE VIEW transforms.view_4616_probe AS COMMIT /* QNO 55 CON_ID 21 */ /* QNO 56 CON_ID 21 */ 21 Query UPDATE t1 SET col2 = 4 LIMIT 2 /* QNO 57 CON_ID 21 */ 21 Query /* GenTest::Transform::DisableOptimizations */ SET @switch_saved = @@optimizer_switch /* QNO 58 CON_ID 21 */ 21 Query SET SESSION optimizer_switch = REPLACE( @@optimizer_switch, '=on', '=off' ) /* QNO 59 CON_ID 21 */ 21 Query SET SESSION optimizer_switch = 'in_to_exists=on' /* QNO 60 CON_ID 21 */ 21 Query UPDATE t1 SET col2 = 4 LIMIT 2 /* QNO 57 CON_ID 21 */ /* TRANSFORM_OUTCOME_UNORDERED_MATCH */ /* QNO 61 CON_ID 21 */ 21 Query /* GenTest::Transform::DisableOptimizations */ /* TRANSFORM_CLEANUP */ SET SESSION optimizer_switch=@switch_saved /* QNO 62 CON_ID 21 */ 21 Query /* GenTest::Transform::EnableOptimizations */ SET @switch_saved = @@optimizer_switch /* QNO 63 CON_ID 21 */ 21 Query SET SESSION optimizer_switch = REPLACE( @@optimizer_switch, '=off', '=on' ) /* QNO 64 CON_ID 21 */ 21 Query SHOW WARNINGS 21 Query UPDATE t1 SET col2 = 4 LIMIT 2 /* QNO 57 CON_ID 21 */ /* TRANSFORM_OUTCOME_UNORDERED_MATCH */ /* QNO 65 CON_ID 21 */ 21 Query /* GenTest::Transform::EnableOptimizations */ /* TRANSFORM_CLEANUP */ SET SESSION optimizer_switch=@switch_saved /* QNO 66 CON_ID 21 */ 21 Query CREATE OR REPLACE VIEW transforms.view_4616_probe AS UPDATE t1 SET col2 = 4 LIMIT 2 /* QNO 57 CON_ID 21 */ /* QNO 67 CON_ID 21 */ 21 Query ROLLBACK /* QNO 68 CON_ID 21 */ 21 Query CREATE OR REPLACE VIEW transforms.view_4616_probe AS ROLLBACK /* QNO 68 CON_ID 21 */ /* QNO 69 CON_ID 21 */ 21 Query ALTER TABLE t1 DROP KEY uidx /* QNO 70 CON_ID 21 */ 18 Query CREATE OR REPLACE VIEW transforms.view_3564_probe AS ALTER TABLE t1 DROP COLUMN col1 /* QNO 113 CON_ID 18 */ /* QNO 114 CON_ID 18 */ 18 Query ALTER TABLE t1 CHANGE COLUMN extra col1 INT /* QNO 115 CON_ID 18 */ 171012 18:12:32 16 Query CREATE OR REPLACE VIEW transforms.view_12936_probe AS ALTER TABLE t1 DROP COLUMN col3 /* QNO 191 CON_ID 16 */ /* QNO 192 CON_ID 16 */ 16 Query ALTER TABLE t1 CHANGE COLUMN extra col3 INT /* QNO 193 CON_ID 16 */ 171012 18:12:33 19 Query ALTER TABLE t1 ADD PRIMARY KEY ( col2 ) /* QNO 68 CON_ID 19 */ 17 Query ALTER TABLE t1 DROP KEY ftidx /* QNO 96 CON_ID 17 */ 21 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES ( 4, 4 - 1, 4, REPEAT(CAST(4 AS CHAR(1)),@fill_amount)) /* QNO 71 CON_ID 21 */ 16 Query ALTER TABLE t1 DROP PRIMARY KEY, DROP PRIMARY KEY /* QNO 194 CON_ID 16 */ 18 Query CHECK TABLE t1 /* QNO 116 CON_ID 18 */ 18 Query CREATE OR REPLACE VIEW transforms.view_3564_probe AS CHECK TABLE t1 /* QNO 116 CON_ID 18 */ /* QNO 117 CON_ID 18 */ 18 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES ( 2, 2, 2 - 1, REPEAT(CAST(2 AS CHAR(1)),@fill_amount)) /* QNO 118 CON_ID 18 */ 17 Query UPDATE t1 SET col3 = 4 LIMIT 2 /* QNO 97 CON_ID 17 */ 19 Query DELETE FROM t1 WHERE MATCH(col4) AGAINST (TRIM(' 2 ') IN BOOLEAN MODE) OR col2 IS NULL /* QNO 69 CON_ID 19 */ 21 Query ROLLBACK /* QNO 72 CON_ID 21 */ 18 Query COMMIT /* QNO 119 CON_ID 18 */ 17 Query COMMIT /* QNO 98 CON_ID 17 */ 19 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES /* 3 */ (3,3,3,REPEAT(CAST(3 AS CHAR(1)),@fill_amount)), (3,3,3,REPEAT(CAST(3 AS CHAR(1)),@fill_amount)) /* QNO 70 CON_ID 19 */ 21 Query CREATE OR REPLACE VIEW transforms.view_4616_probe AS ROLLBACK /* QNO 72 CON_ID 21 */ /* QNO 73 CON_ID 21 */ 17 Query CREATE OR REPLACE VIEW transforms.view_10968_probe AS COMMIT /* QNO 98 CON_ID 17 */ /* QNO 99 CON_ID 17 */ 18 Query CREATE OR REPLACE VIEW transforms.view_3564_probe AS COMMIT /* QNO 119 CON_ID 18 */ /* QNO 120 CON_ID 18 */ 16 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES ( 3, 3, 3 - 1, REPEAT(CAST(3 AS CHAR(1)),@fill_amount)) /* QNO 195 CON_ID 16 */ 17 Query ALTER TABLE t1 DROP KEY idx /* QNO 100 CON_ID 17 */ 18 Query DELETE FROM t1 WHERE MATCH(col4) AGAINST (TRIM(' 2 ') IN BOOLEAN MODE) OR col3 IS NULL /* QNO 121 CON_ID 18 */ 19 Query COMMIT /* QNO 71 CON_ID 19 */ 18 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES /* 2 */ (2,2,2,REPEAT(CAST(2 AS CHAR(1)),@fill_amount)), (2,2,2,REPEAT(CAST(2 AS CHAR(1)),@fill_amount)) /* QNO 122 CON_ID 18 */ 16 Query COMMIT /* QNO 196 CON_ID 16 */ 21 Query UPDATE t1 SET col1 = NULL LIMIT 2 /* QNO 74 CON_ID 21 */ 19 Query CREATE OR REPLACE VIEW transforms.view_8236_probe AS COMMIT /* QNO 71 CON_ID 19 */ /* QNO 72 CON_ID 19 */ 18 Query COMMIT /* QNO 123 CON_ID 18 */ 16 Query CREATE OR REPLACE VIEW transforms.view_12936_probe AS COMMIT /* QNO 196 CON_ID 16 */ /* QNO 197 CON_ID 16 */ 18 Query CREATE OR REPLACE VIEW transforms.view_3564_probe AS COMMIT /* QNO 123 CON_ID 18 */ /* QNO 124 CON_ID 18 */ 19 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES ( 3, 3 - 1, 3, REPEAT(CAST(3 AS CHAR(1)),@fill_amount)) /* QNO 73 CON_ID 19 */ 18 Query ALTER TABLE t1 DROP KEY uidx, DROP KEY idx /* QNO 125 CON_ID 18 */ 16 Query DELETE FROM t1 WHERE MATCH(col4) AGAINST (TRIM(' NULL ') IN BOOLEAN MODE) OR col2 IS NULL /* QNO 198 CON_ID 16 */ 19 Query ROLLBACK /* QNO 74 CON_ID 19 */ 21 Query ROLLBACK /* QNO 75 CON_ID 21 */ 21 Query CREATE OR REPLACE VIEW transforms.view_4616_probe AS ROLLBACK /* QNO 75 CON_ID 21 */ /* QNO 76 CON_ID 21 */ 21 Query ALTER TABLE t1 DROP PRIMARY KEY /* QNO 77 CON_ID 21 */ 19 Query CREATE OR REPLACE VIEW transforms.view_8236_probe AS ROLLBACK /* QNO 74 CON_ID 19 */ /* QNO 75 CON_ID 19 */ 19 Query ALTER TABLE t1 DROP KEY idx, DROP KEY uidx /* QNO 76 CON_ID 19 */ 17 Query CREATE OR REPLACE VIEW transforms.view_10968_probe AS ALTER TABLE t1 DROP KEY idx /* QNO 100 CON_ID 17 */ /* QNO 101 CON_ID 17 */ 18 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES ( 3, 3, 3, REPEAT(CAST(3 AS CHAR(1)),@fill_amount)) /* QNO 126 CON_ID 18 */ 16 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES /* 1 */ (1,1,1,REPEAT(CAST(1 AS CHAR(1)),@fill_amount)), (1,1,1,REPEAT(CAST(1 AS CHAR(1)),@fill_amount)) /* QNO 199 CON_ID 16 */ 18 Query COMMIT /* QNO 127 CON_ID 18 */ 21 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES ( 1, 1, 1, REPEAT(CAST(1 AS CHAR(1)),@fill_amount)) /* QNO 78 CON_ID 21 */ 19 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES ( 2, 2, 2, REPEAT(CAST(2 - 1 AS CHAR(1)),@fill_amount)) /* QNO 77 CON_ID 19 */ 18 Query CREATE OR REPLACE VIEW transforms.view_3564_probe AS COMMIT /* QNO 127 CON_ID 18 */ /* QNO 128 CON_ID 18 */ 17 Query ALTER TABLE t1 ADD FULLTEXT KEY ftidx ( col4 ) /* QNO 102 CON_ID 17 */ 16 Query COMMIT /* QNO 200 CON_ID 16 */ 21 Query COMMIT /* QNO 79 CON_ID 21 */ 19 Query ROLLBACK /* QNO 78 CON_ID 19 */ 18 Query ALTER TABLE t1 DROP PRIMARY KEY, ADD UNIQUE KEY uidx ( col4(10), col3 ) /* QNO 129 CON_ID 18 */ 21 Query CREATE OR REPLACE VIEW transforms.view_4616_probe AS COMMIT /* QNO 79 CON_ID 21 */ /* QNO 80 CON_ID 21 */ 16 Query CREATE OR REPLACE VIEW transforms.view_12936_probe AS COMMIT /* QNO 200 CON_ID 16 */ /* QNO 201 CON_ID 16 */ 19 Query CREATE OR REPLACE VIEW transforms.view_8236_probe AS ROLLBACK /* QNO 78 CON_ID 19 */ /* QNO 79 CON_ID 19 */ 21 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES ( 4, 4, 4, REPEAT(CAST(4 AS CHAR(1)),@fill_amount)) /* QNO 81 CON_ID 21 */ 16 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES ( NULL, NULL - 1, NULL, REPEAT(CAST(NULL AS CHAR(1)),@fill_amount)) /* QNO 202 CON_ID 16 */ 19 Query ALTER TABLE t1 ADD KEY idx ( col3 ) /* QNO 80 CON_ID 19 */ 171012 18:12:34 23 Connect root@127.0.0.1 as anonymous on test 23 Query SHOW FULL PROCESSLIST 23 Quit 17 Query SHOW WARNINGS 16 Query COMMIT /* QNO 203 CON_ID 16 */ 16 Query CREATE OR REPLACE VIEW transforms.view_12936_probe AS COMMIT /* QNO 203 CON_ID 16 */ /* QNO 204 CON_ID 16 */ 18 Query ALTER TABLE t1 ADD KEY idx ( col3 ) /* QNO 130 CON_ID 18 */ 21 Query COMMIT /* QNO 82 CON_ID 21 */ 17 Query DELETE FROM t1 WHERE MATCH(col4) AGAINST (TRIM(' 4 ') IN BOOLEAN MODE) OR col2 IS NULL /* QNO 103 CON_ID 17 */ 18 Query ALTER TABLE t1 DROP KEY ftidx /* QNO 131 CON_ID 18 */ 21 Query CREATE OR REPLACE VIEW transforms.view_4616_probe AS COMMIT /* QNO 82 CON_ID 21 */ /* QNO 83 CON_ID 21 */ 16 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES ( 4, 4, 4, REPEAT(CAST(4 AS CHAR(1)),@fill_amount)) /* QNO 205 CON_ID 16 */ 21 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES ( 4, 4, 4, REPEAT(CAST(4 AS CHAR(1)),@fill_amount)) /* QNO 84 CON_ID 21 */ 19 Query ALTER TABLE t1 ADD PRIMARY KEY ( col2 ), ADD PRIMARY KEY ( col2 ) /* QNO 81 CON_ID 19 */ 17 Query /* GenTest::Transform::DisableOptimizations */ SET @switch_saved = @@optimizer_switch /* QNO 104 CON_ID 17 */ 17 Query SET SESSION optimizer_switch = REPLACE( @@optimizer_switch, '=on', '=off' ) /* QNO 105 CON_ID 17 */ 17 Query SET SESSION optimizer_switch = 'in_to_exists=on' /* QNO 106 CON_ID 17 */ 17 Query DELETE FROM t1 WHERE MATCH(col4) AGAINST (TRIM(' 4 ') IN BOOLEAN MODE) OR col2 IS NULL /* QNO 103 CON_ID 17 */ /* TRANSFORM_OUTCOME_UNORDERED_MATCH */ /* QNO 107 CON_ID 17 */ 17 Query /* GenTest::Transform::DisableOptimizations */ /* TRANSFORM_CLEANUP */ SET SESSION optimizer_switch=@switch_saved /* QNO 108 CON_ID 17 */ 17 Query /* GenTest::Transform::EnableOptimizations */ SET @switch_saved = @@optimizer_switch /* QNO 109 CON_ID 17 */ 17 Query SET SESSION optimizer_switch = REPLACE( @@optimizer_switch, '=off', '=on' ) /* QNO 110 CON_ID 17 */ 17 Query SHOW WARNINGS 17 Query DELETE FROM t1 WHERE MATCH(col4) AGAINST (TRIM(' 4 ') IN BOOLEAN MODE) OR col2 IS NULL /* QNO 103 CON_ID 17 */ /* TRANSFORM_OUTCOME_UNORDERED_MATCH */ /* QNO 111 CON_ID 17 */ 17 Query /* GenTest::Transform::EnableOptimizations */ /* TRANSFORM_CLEANUP */ SET SESSION optimizer_switch=@switch_saved /* QNO 112 CON_ID 17 */ 17 Query CREATE OR REPLACE VIEW transforms.view_10968_probe AS DELETE FROM t1 WHERE MATCH(col4) AGAINST (TRIM(' 4 ') IN BOOLEAN MODE) OR col2 IS NULL /* QNO 103 CON_ID 17 */ /* QNO 113 CON_ID 17 */ 17 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES /* NULL */ (NULL,NULL,NULL,REPEAT(CAST(NULL AS CHAR(1)),@fill_amount)), (NULL,NULL,NULL,REPEAT(CAST(NULL AS CHAR(1)),@fill_amount)) /* QNO 114 CON_ID 17 */ 17 Query COMMIT /* QNO 115 CON_ID 17 */ 21 Query COMMIT /* QNO 85 CON_ID 21 */ 17 Query CREATE OR REPLACE VIEW transforms.view_10968_probe AS COMMIT /* QNO 115 CON_ID 17 */ /* QNO 116 CON_ID 17 */ 21 Query CREATE OR REPLACE VIEW transforms.view_4616_probe AS COMMIT /* QNO 85 CON_ID 21 */ /* QNO 86 CON_ID 21 */ 16 Query ROLLBACK /* QNO 206 CON_ID 16 */ 17 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES ( 1, 1, 1 - 1, REPEAT(CAST(1 AS CHAR(1)),@fill_amount)) /* QNO 117 CON_ID 17 */ 21 Query ALTER TABLE t1 ADD COLUMN extra INT /* QNO 87 CON_ID 21 */ 16 Query CREATE OR REPLACE VIEW transforms.view_12936_probe AS ROLLBACK /* QNO 206 CON_ID 16 */ /* QNO 207 CON_ID 16 */ 16 Query ALTER TABLE t1 ADD PRIMARY KEY ( col3 ) /* QNO 208 CON_ID 16 */ 19 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES ( 4, 4 - 1, 4, REPEAT(CAST(4 AS CHAR(1)),@fill_amount)) /* QNO 82 CON_ID 19 */ 18 Query CREATE OR REPLACE VIEW transforms.view_3564_probe AS ALTER TABLE t1 DROP KEY ftidx /* QNO 131 CON_ID 18 */ /* QNO 132 CON_ID 18 */ 17 Query COMMIT /* QNO 118 CON_ID 17 */ 17 Query CREATE OR REPLACE VIEW transforms.view_10968_probe AS COMMIT /* QNO 118 CON_ID 17 */ /* QNO 119 CON_ID 17 */ 17 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES ( 2, 2 - 1, 2, REPEAT(CAST(2 AS CHAR(1)),@fill_amount)) /* QNO 120 CON_ID 17 */ 18 Query UPDATE t1 SET col1 = 2 LIMIT 2 /* QNO 133 CON_ID 18 */ 24 Connect root@127.0.0.1 as anonymous on test 24 Query SHOW FULL PROCESSLIST 24 Quit 17 Query COMMIT /* QNO 121 CON_ID 17 */ 18 Query ROLLBACK /* QNO 134 CON_ID 18 */ 17 Query CREATE OR REPLACE VIEW transforms.view_10968_probe AS COMMIT /* QNO 121 CON_ID 17 */ /* QNO 122 CON_ID 17 */ 18 Query CREATE OR REPLACE VIEW transforms.view_3564_probe AS ROLLBACK /* QNO 134 CON_ID 18 */ /* QNO 135 CON_ID 18 */ 18 Query ALTER TABLE t1 ADD PRIMARY KEY ( col2 ) /* QNO 136 CON_ID 18 */ 17 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES ( 3, 3 - 1, 3, REPEAT(CAST(3 AS CHAR(1)),@fill_amount)) /* QNO 123 CON_ID 17 */ 17 Query COMMIT /* QNO 124 CON_ID 17 */ 19 Query ROLLBACK /* QNO 83 CON_ID 19 */ 19 Query CREATE OR REPLACE VIEW transforms.view_8236_probe AS ROLLBACK /* QNO 83 CON_ID 19 */ /* QNO 84 CON_ID 19 */ 17 Query CREATE OR REPLACE VIEW transforms.view_10968_probe AS COMMIT /* QNO 124 CON_ID 17 */ /* QNO 125 CON_ID 17 */ 19 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES ( 2, 2, 2 - 1, REPEAT(CAST(2 AS CHAR(1)),@fill_amount)) /* QNO 85 CON_ID 19 */ 17 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES ( 2, 2 - 1, 2, REPEAT(CAST(2 AS CHAR(1)),@fill_amount)) /* QNO 126 CON_ID 17 */ 19 Query COMMIT /* QNO 86 CON_ID 19 */ 17 Query COMMIT /* QNO 127 CON_ID 17 */ 17 Query CREATE OR REPLACE VIEW transforms.view_10968_probe AS COMMIT /* QNO 127 CON_ID 17 */ /* QNO 128 CON_ID 17 */ 17 Query CHECK TABLE t1 /* QNO 129 CON_ID 17 */ 19 Query CREATE OR REPLACE VIEW transforms.view_8236_probe AS COMMIT /* QNO 86 CON_ID 19 */ /* QNO 87 CON_ID 19 */ 19 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES ( 4, 4, 4 - 1, REPEAT(CAST(4 AS CHAR(1)),@fill_amount)) /* QNO 88 CON_ID 19 */ 19 Query COMMIT /* QNO 89 CON_ID 19 */ 19 Query CREATE OR REPLACE VIEW transforms.view_8236_probe AS COMMIT /* QNO 89 CON_ID 19 */ /* QNO 90 CON_ID 19 */ 19 Query DELETE FROM t1 WHERE MATCH(col4) AGAINST (TRIM(' 2 ') IN BOOLEAN MODE) OR col2 IS NULL /* QNO 91 CON_ID 19 */ 19 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES /* NULL */ (NULL,NULL,NULL,REPEAT(CAST(NULL AS CHAR(1)),@fill_amount)), (NULL,NULL,NULL,REPEAT(CAST(NULL AS CHAR(1)),@fill_amount)) /* QNO 92 CON_ID 19 */ 19 Query COMMIT /* QNO 93 CON_ID 19 */ 19 Query CREATE OR REPLACE VIEW transforms.view_8236_probe AS COMMIT /* QNO 93 CON_ID 19 */ /* QNO 94 CON_ID 19 */ 19 Query UPDATE t1 SET col1 = 1 LIMIT 2 /* QNO 95 CON_ID 19 */ 19 Query COMMIT /* QNO 96 CON_ID 19 */ 19 Query CREATE OR REPLACE VIEW transforms.view_8236_probe AS COMMIT /* QNO 96 CON_ID 19 */ /* QNO 97 CON_ID 19 */ 19 Query ALTER TABLE t1 ADD UNIQUE KEY uidx ( col2 ) /* QNO 98 CON_ID 19 */ 17 Query CREATE OR REPLACE VIEW transforms.view_10968_probe AS CHECK TABLE t1 /* QNO 129 CON_ID 17 */ /* QNO 130 CON_ID 17 */ 17 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES ( NULL, NULL - 1, NULL, REPEAT(CAST(NULL AS CHAR(1)),@fill_amount)) /* QNO 131 CON_ID 17 */ 17 Query COMMIT /* QNO 132 CON_ID 17 */ 17 Query CREATE OR REPLACE VIEW transforms.view_10968_probe AS COMMIT /* QNO 132 CON_ID 17 */ /* QNO 133 CON_ID 17 */ 17 Query UPDATE t1 SET col2 = 3 LIMIT 2 /* QNO 134 CON_ID 17 */ 17 Query /* GenTest::Transform::DisableOptimizations */ SET @switch_saved = @@optimizer_switch /* QNO 135 CON_ID 17 */ 17 Query SET SESSION optimizer_switch = REPLACE( @@optimizer_switch, '=on', '=off' ) /* QNO 136 CON_ID 17 */ 17 Query SET SESSION optimizer_switch = 'in_to_exists=on' /* QNO 137 CON_ID 17 */ 17 Query UPDATE t1 SET col2 = 3 LIMIT 2 /* QNO 134 CON_ID 17 */ /* TRANSFORM_OUTCOME_UNORDERED_MATCH */ /* QNO 138 CON_ID 17 */ 17 Query /* GenTest::Transform::DisableOptimizations */ /* TRANSFORM_CLEANUP */ SET SESSION optimizer_switch=@switch_saved /* QNO 139 CON_ID 17 */ 17 Query /* GenTest::Transform::EnableOptimizations */ SET @switch_saved = @@optimizer_switch /* QNO 140 CON_ID 17 */ 17 Query SET SESSION optimizer_switch = REPLACE( @@optimizer_switch, '=off', '=on' ) /* QNO 141 CON_ID 17 */ 17 Query SHOW WARNINGS 17 Query UPDATE t1 SET col2 = 3 LIMIT 2 /* QNO 134 CON_ID 17 */ /* TRANSFORM_OUTCOME_UNORDERED_MATCH */ /* QNO 142 CON_ID 17 */ 17 Query /* GenTest::Transform::EnableOptimizations */ /* TRANSFORM_CLEANUP */ SET SESSION optimizer_switch=@switch_saved /* QNO 143 CON_ID 17 */ 17 Query CREATE OR REPLACE VIEW transforms.view_10968_probe AS UPDATE t1 SET col2 = 3 LIMIT 2 /* QNO 134 CON_ID 17 */ /* QNO 144 CON_ID 17 */ 17 Query COMMIT /* QNO 145 CON_ID 17 */ 17 Query CREATE OR REPLACE VIEW transforms.view_10968_probe AS COMMIT /* QNO 145 CON_ID 17 */ /* QNO 146 CON_ID 17 */ 17 Query DELETE FROM t1 WHERE col1 = 1 OR col1 IS NULL /* QNO 147 CON_ID 17 */ 17 Query COMMIT /* QNO 148 CON_ID 17 */ 17 Query CREATE OR REPLACE VIEW transforms.view_10968_probe AS COMMIT /* QNO 148 CON_ID 17 */ /* QNO 149 CON_ID 17 */ 17 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES ( 2, 2 - 1, 2, REPEAT(CAST(2 AS CHAR(1)),@fill_amount)) /* QNO 150 CON_ID 17 */ 17 Query ROLLBACK /* QNO 151 CON_ID 17 */ 17 Query CREATE OR REPLACE VIEW transforms.view_10968_probe AS ROLLBACK /* QNO 151 CON_ID 17 */ /* QNO 152 CON_ID 17 */ 17 Query DELETE FROM t1 WHERE MATCH(col4) AGAINST (TRIM(' 2 ') IN BOOLEAN MODE) OR col2 IS NULL /* QNO 153 CON_ID 17 */ 17 Query COMMIT /* QNO 154 CON_ID 17 */ 17 Query CREATE OR REPLACE VIEW transforms.view_10968_probe AS COMMIT /* QNO 154 CON_ID 17 */ /* QNO 155 CON_ID 17 */ 17 Query ALTER TABLE t1 DROP KEY ftidx, DROP KEY uidx /* QNO 156 CON_ID 17 */ 171012 18:12:35 21 Query CREATE OR REPLACE VIEW transforms.view_4616_probe AS ALTER TABLE t1 ADD COLUMN extra INT /* QNO 87 CON_ID 21 */ /* QNO 88 CON_ID 21 */ 16 Query ALTER TABLE t1 ADD COLUMN extra INT /* QNO 209 CON_ID 16 */ 21 Query UPDATE t1 SET extra = col3 /* QNO 89 CON_ID 21 */ 18 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES ( 4, 4 - 1, 4, REPEAT(CAST(4 AS CHAR(1)),@fill_amount)) /* QNO 137 CON_ID 18 */ 21 Query ALTER TABLE t1 DROP COLUMN col3 /* QNO 90 CON_ID 21 */ 19 Query ALTER TABLE t1 DROP PRIMARY KEY /* QNO 99 CON_ID 19 */ 16 Query UPDATE t1 SET extra = col3 /* QNO 210 CON_ID 16 */ 21 Query ALTER TABLE t1 CHANGE COLUMN extra col3 INT /* QNO 91 CON_ID 21 */ 16 Query ALTER TABLE t1 DROP COLUMN col3 /* QNO 211 CON_ID 16 */ 18 Query ROLLBACK /* QNO 138 CON_ID 18 */ 17 Query ALTER TABLE t1 DROP PRIMARY KEY /* QNO 157 CON_ID 17 */ 18 Query CREATE OR REPLACE VIEW transforms.view_3564_probe AS ROLLBACK /* QNO 138 CON_ID 18 */ /* QNO 139 CON_ID 18 */ 19 Query DELETE FROM t1 WHERE MATCH(col4) AGAINST (TRIM(' 2 ') IN BOOLEAN MODE) OR col1 IS NULL /* QNO 100 CON_ID 19 */ 18 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES ( NULL, NULL, NULL, REPEAT(CAST(NULL - 1 AS CHAR(1)),@fill_amount)) /* QNO 140 CON_ID 18 */ 18 Query ROLLBACK /* QNO 141 CON_ID 18 */ 19 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES /* NULL */ (NULL,NULL,NULL,REPEAT(CAST(NULL AS CHAR(1)),@fill_amount)), (NULL,NULL,NULL,REPEAT(CAST(NULL AS CHAR(1)),@fill_amount)) /* QNO 101 CON_ID 19 */ 21 Query CREATE OR REPLACE VIEW transforms.view_4616_probe AS ALTER TABLE t1 CHANGE COLUMN extra col3 INT /* QNO 91 CON_ID 21 */ /* QNO 92 CON_ID 21 */ 19 Query ROLLBACK /* QNO 102 CON_ID 19 */ 18 Query CREATE OR REPLACE VIEW transforms.view_3564_probe AS ROLLBACK /* QNO 141 CON_ID 18 */ /* QNO 142 CON_ID 18 */ 19 Query CREATE OR REPLACE VIEW transforms.view_8236_probe AS ROLLBACK /* QNO 102 CON_ID 19 */ /* QNO 103 CON_ID 19 */ 18 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES ( NULL, NULL, NULL, REPEAT(CAST(NULL AS CHAR(1)),@fill_amount)) /* QNO 143 CON_ID 18 */ 19 Query DELETE FROM t1 WHERE MATCH(col4) AGAINST (TRIM(' 4 ') IN BOOLEAN MODE) OR col3 IS NULL /* QNO 104 CON_ID 19 */ 21 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES ( NULL, NULL, NULL, REPEAT(CAST(NULL - 1 AS CHAR(1)),@fill_amount)) /* QNO 93 CON_ID 21 */ 18 Query COMMIT /* QNO 144 CON_ID 18 */ 18 Query CREATE OR REPLACE VIEW transforms.view_3564_probe AS COMMIT /* QNO 144 CON_ID 18 */ /* QNO 145 CON_ID 18 */ 19 Query COMMIT /* QNO 105 CON_ID 19 */ 19 Query CREATE OR REPLACE VIEW transforms.view_8236_probe AS COMMIT /* QNO 105 CON_ID 19 */ /* QNO 106 CON_ID 19 */ 18 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES ( NULL, NULL, NULL, REPEAT(CAST(NULL AS CHAR(1)),@fill_amount)) /* QNO 146 CON_ID 18 */ 18 Query COMMIT /* QNO 147 CON_ID 18 */ 19 Query ALTER TABLE t1 ADD PRIMARY KEY ( col4(10), col3 ), ADD KEY idx ( col3 ) /* QNO 107 CON_ID 19 */ 18 Query CREATE OR REPLACE VIEW transforms.view_3564_probe AS COMMIT /* QNO 147 CON_ID 18 */ /* QNO 148 CON_ID 18 */ 18 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES ( 3, 3 - 1, 3, REPEAT(CAST(3 AS CHAR(1)),@fill_amount)) /* QNO 149 CON_ID 18 */ 18 Query COMMIT /* QNO 150 CON_ID 18 */ 18 Query CREATE OR REPLACE VIEW transforms.view_3564_probe AS COMMIT /* QNO 150 CON_ID 18 */ /* QNO 151 CON_ID 18 */ 21 Query COMMIT /* QNO 94 CON_ID 21 */ 21 Query CREATE OR REPLACE VIEW transforms.view_4616_probe AS COMMIT /* QNO 94 CON_ID 21 */ /* QNO 95 CON_ID 21 */ 18 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES ( 1, 1, 1, REPEAT(CAST(1 - 1 AS CHAR(1)),@fill_amount)) /* QNO 152 CON_ID 18 */ 21 Query ALTER TABLE t1 DROP KEY uidx /* QNO 96 CON_ID 21 */ 18 Query COMMIT /* QNO 153 CON_ID 18 */ 18 Query CREATE OR REPLACE VIEW transforms.view_3564_probe AS COMMIT /* QNO 153 CON_ID 18 */ /* QNO 154 CON_ID 18 */ 18 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES ( 4, 4 - 1, 4, REPEAT(CAST(4 AS CHAR(1)),@fill_amount)) /* QNO 155 CON_ID 18 */ 18 Query COMMIT /* QNO 156 CON_ID 18 */ 18 Query CREATE OR REPLACE VIEW transforms.view_3564_probe AS COMMIT /* QNO 156 CON_ID 18 */ /* QNO 157 CON_ID 18 */ 18 Query UPDATE t1 SET col2 = NULL LIMIT 2 /* QNO 158 CON_ID 18 */ 18 Query /* GenTest::Transform::DisableOptimizations */ SET @switch_saved = @@optimizer_switch /* QNO 159 CON_ID 18 */ 18 Query SET SESSION optimizer_switch = REPLACE( @@optimizer_switch, '=on', '=off' ) /* QNO 160 CON_ID 18 */ 18 Query SET SESSION optimizer_switch = 'in_to_exists=on' /* QNO 161 CON_ID 18 */ 18 Query UPDATE t1 SET col2 = NULL LIMIT 2 /* QNO 158 CON_ID 18 */ /* TRANSFORM_OUTCOME_UNORDERED_MATCH */ /* QNO 162 CON_ID 18 */ 18 Query /* GenTest::Transform::DisableOptimizations */ /* TRANSFORM_CLEANUP */ SET SESSION optimizer_switch=@switch_saved /* QNO 163 CON_ID 18 */ 18 Query /* GenTest::Transform::EnableOptimizations */ SET @switch_saved = @@optimizer_switch /* QNO 164 CON_ID 18 */ 18 Query SET SESSION optimizer_switch = REPLACE( @@optimizer_switch, '=off', '=on' ) /* QNO 165 CON_ID 18 */ 18 Query SHOW WARNINGS 18 Query UPDATE t1 SET col2 = NULL LIMIT 2 /* QNO 158 CON_ID 18 */ /* TRANSFORM_OUTCOME_UNORDERED_MATCH */ /* QNO 166 CON_ID 18 */ 18 Query /* GenTest::Transform::EnableOptimizations */ /* TRANSFORM_CLEANUP */ SET SESSION optimizer_switch=@switch_saved /* QNO 167 CON_ID 18 */ 18 Query CREATE OR REPLACE VIEW transforms.view_3564_probe AS UPDATE t1 SET col2 = NULL LIMIT 2 /* QNO 158 CON_ID 18 */ /* QNO 168 CON_ID 18 */ 18 Query COMMIT /* QNO 169 CON_ID 18 */ 18 Query CREATE OR REPLACE VIEW transforms.view_3564_probe AS COMMIT /* QNO 169 CON_ID 18 */ /* QNO 170 CON_ID 18 */ 18 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES ( 1, 1, 1, REPEAT(CAST(1 AS CHAR(1)),@fill_amount)) /* QNO 171 CON_ID 18 */ 18 Query COMMIT /* QNO 172 CON_ID 18 */ 18 Query CREATE OR REPLACE VIEW transforms.view_3564_probe AS COMMIT /* QNO 172 CON_ID 18 */ /* QNO 173 CON_ID 18 */ 18 Query UPDATE t1 SET col2 = NULL LIMIT 2 /* QNO 174 CON_ID 18 */ 18 Query /* GenTest::Transform::DisableOptimizations */ SET @switch_saved = @@optimizer_switch /* QNO 175 CON_ID 18 */ 18 Query SET SESSION optimizer_switch = REPLACE( @@optimizer_switch, '=on', '=off' ) /* QNO 176 CON_ID 18 */ 18 Query SET SESSION optimizer_switch = 'in_to_exists=on' /* QNO 177 CON_ID 18 */ 18 Query UPDATE t1 SET col2 = NULL LIMIT 2 /* QNO 174 CON_ID 18 */ /* TRANSFORM_OUTCOME_UNORDERED_MATCH */ /* QNO 178 CON_ID 18 */ 18 Query /* GenTest::Transform::DisableOptimizations */ /* TRANSFORM_CLEANUP */ SET SESSION optimizer_switch=@switch_saved /* QNO 179 CON_ID 18 */ 18 Query /* GenTest::Transform::EnableOptimizations */ SET @switch_saved = @@optimizer_switch /* QNO 180 CON_ID 18 */ 18 Query SET SESSION optimizer_switch = REPLACE( @@optimizer_switch, '=off', '=on' ) /* QNO 181 CON_ID 18 */ 18 Query SHOW WARNINGS 18 Query UPDATE t1 SET col2 = NULL LIMIT 2 /* QNO 174 CON_ID 18 */ /* TRANSFORM_OUTCOME_UNORDERED_MATCH */ /* QNO 182 CON_ID 18 */ 18 Query /* GenTest::Transform::EnableOptimizations */ /* TRANSFORM_CLEANUP */ SET SESSION optimizer_switch=@switch_saved /* QNO 183 CON_ID 18 */ 18 Query CREATE OR REPLACE VIEW transforms.view_3564_probe AS UPDATE t1 SET col2 = NULL LIMIT 2 /* QNO 174 CON_ID 18 */ /* QNO 184 CON_ID 18 */ 18 Query ROLLBACK /* QNO 185 CON_ID 18 */ 18 Query CREATE OR REPLACE VIEW transforms.view_3564_probe AS ROLLBACK /* QNO 185 CON_ID 18 */ /* QNO 186 CON_ID 18 */ 18 Query ALTER TABLE t1 ADD COLUMN extra INT /* QNO 187 CON_ID 18 */ 171012 18:12:36 16 Query CREATE OR REPLACE VIEW transforms.view_12936_probe AS ALTER TABLE t1 DROP COLUMN col3 /* QNO 211 CON_ID 16 */ /* QNO 212 CON_ID 16 */ 17 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES ( 2, 2, 2 - 1, REPEAT(CAST(2 AS CHAR(1)),@fill_amount)) /* QNO 158 CON_ID 17 */ 16 Query ALTER TABLE t1 CHANGE COLUMN extra col3 INT /* QNO 213 CON_ID 16 */ 19 Query UPDATE t1 SET col3 = NULL LIMIT 2 /* QNO 108 CON_ID 19 */ 21 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES ( 3, 3, 3, REPEAT(CAST(3 AS CHAR(1)),@fill_amount)) /* QNO 97 CON_ID 21 */ 21 Query ROLLBACK /* QNO 98 CON_ID 21 */ 21 Query CREATE OR REPLACE VIEW transforms.view_4616_probe AS ROLLBACK /* QNO 98 CON_ID 21 */ /* QNO 99 CON_ID 21 */ 18 Query CREATE OR REPLACE VIEW transforms.view_3564_probe AS ALTER TABLE t1 ADD COLUMN extra INT /* QNO 187 CON_ID 18 */ /* QNO 188 CON_ID 18 */ 21 Query ALTER TABLE t1 DROP KEY idx /* QNO 100 CON_ID 21 */ 18 Query UPDATE t1 SET extra = col2 /* QNO 189 CON_ID 18 */ 19 Query COMMIT /* QNO 109 CON_ID 19 */ 17 Query COMMIT /* QNO 159 CON_ID 17 */ 17 Query CREATE OR REPLACE VIEW transforms.view_10968_probe AS COMMIT /* QNO 159 CON_ID 17 */ /* QNO 160 CON_ID 17 */ 19 Query CREATE OR REPLACE VIEW transforms.view_8236_probe AS COMMIT /* QNO 109 CON_ID 19 */ /* QNO 110 CON_ID 19 */ 17 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES ( 3, 3, 3, REPEAT(CAST(3 - 1 AS CHAR(1)),@fill_amount)) /* QNO 161 CON_ID 17 */ 19 Query ALTER TABLE t1 DROP KEY ftidx, ADD KEY idx ( col2 ) /* QNO 111 CON_ID 19 */ 18 Query /* GenTest::Transform::DisableOptimizations */ SET @switch_saved = @@optimizer_switch /* QNO 190 CON_ID 18 */ 18 Query SET SESSION optimizer_switch = REPLACE( @@optimizer_switch, '=on', '=off' ) /* QNO 191 CON_ID 18 */ 18 Query SET SESSION optimizer_switch = 'in_to_exists=on' /* QNO 192 CON_ID 18 */ 18 Query UPDATE t1 SET extra = col2 /* QNO 189 CON_ID 18 */ /* TRANSFORM_OUTCOME_UNORDERED_MATCH */ /* QNO 193 CON_ID 18 */ 18 Query /* GenTest::Transform::DisableOptimizations */ /* TRANSFORM_CLEANUP */ SET SESSION optimizer_switch=@switch_saved /* QNO 194 CON_ID 18 */ 18 Query /* GenTest::Transform::EnableOptimizations */ SET @switch_saved = @@optimizer_switch /* QNO 195 CON_ID 18 */ 18 Query SET SESSION optimizer_switch = REPLACE( @@optimizer_switch, '=off', '=on' ) /* QNO 196 CON_ID 18 */ 18 Query SHOW WARNINGS 18 Query UPDATE t1 SET extra = col2 /* QNO 189 CON_ID 18 */ /* TRANSFORM_OUTCOME_UNORDERED_MATCH */ /* QNO 197 CON_ID 18 */ 18 Query /* GenTest::Transform::EnableOptimizations */ /* TRANSFORM_CLEANUP */ SET SESSION optimizer_switch=@switch_saved /* QNO 198 CON_ID 18 */ 18 Query CREATE OR REPLACE VIEW transforms.view_3564_probe AS UPDATE t1 SET extra = col2 /* QNO 189 CON_ID 18 */ /* QNO 199 CON_ID 18 */ 18 Query ALTER TABLE t1 DROP COLUMN col2 /* QNO 200 CON_ID 18 */ 17 Query ROLLBACK /* QNO 162 CON_ID 17 */ 16 Query CREATE OR REPLACE VIEW transforms.view_12936_probe AS ALTER TABLE t1 CHANGE COLUMN extra col3 INT /* QNO 213 CON_ID 16 */ /* QNO 214 CON_ID 16 */ 17 Query CREATE OR REPLACE VIEW transforms.view_10968_probe AS ROLLBACK /* QNO 162 CON_ID 17 */ /* QNO 163 CON_ID 17 */ 19 Query ALTER TABLE t1 ADD COLUMN extra INT /* QNO 112 CON_ID 19 */ 21 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES ( 1, 1, 1, REPEAT(CAST(1 - 1 AS CHAR(1)),@fill_amount)) /* QNO 101 CON_ID 21 */ 17 Query ALTER TABLE t1 ADD FULLTEXT KEY ftidx ( col4 ) /* QNO 164 CON_ID 17 */ 16 Query ALTER TABLE t1 DROP KEY uidx, DROP KEY ftidx /* QNO 215 CON_ID 16 */ 21 Query COMMIT /* QNO 102 CON_ID 21 */ 21 Query CREATE OR REPLACE VIEW transforms.view_4616_probe AS COMMIT /* QNO 102 CON_ID 21 */ /* QNO 103 CON_ID 21 */ 21 Query ALTER TABLE t1 ADD COLUMN extra INT /* QNO 104 CON_ID 21 */ 18 Query CREATE OR REPLACE VIEW transforms.view_3564_probe AS ALTER TABLE t1 DROP COLUMN col2 /* QNO 200 CON_ID 18 */ /* QNO 201 CON_ID 18 */ 18 Query ALTER TABLE t1 CHANGE COLUMN extra col2 INT /* QNO 202 CON_ID 18 */ 19 Query CREATE OR REPLACE VIEW transforms.view_8236_probe AS ALTER TABLE t1 ADD COLUMN extra INT /* QNO 112 CON_ID 19 */ /* QNO 113 CON_ID 19 */ 19 Query UPDATE t1 SET extra = col1 /* QNO 114 CON_ID 19 */ 171012 18:12:37 19 Query ALTER TABLE t1 DROP COLUMN col1 /* QNO 115 CON_ID 19 */ 16 Query DELETE FROM t1 WHERE MATCH(col4) AGAINST (TRIM(' 4 ') IN BOOLEAN MODE) OR col3 IS NULL /* QNO 216 CON_ID 16 */ 16 Query /* GenTest::Transform::DisableOptimizations */ SET @switch_saved = @@optimizer_switch /* QNO 217 CON_ID 16 */ 17 Query SHOW WARNINGS 16 Query SET SESSION optimizer_switch = REPLACE( @@optimizer_switch, '=on', '=off' ) /* QNO 218 CON_ID 16 */ 16 Query SET SESSION optimizer_switch = 'in_to_exists=on' /* QNO 219 CON_ID 16 */ 16 Query DELETE FROM t1 WHERE MATCH(col4) AGAINST (TRIM(' 4 ') IN BOOLEAN MODE) OR col3 IS NULL /* QNO 216 CON_ID 16 */ /* TRANSFORM_OUTCOME_UNORDERED_MATCH */ /* QNO 220 CON_ID 16 */ 21 Query UPDATE t1 SET extra = col3 /* QNO 105 CON_ID 21 */ 16 Query /* GenTest::Transform::DisableOptimizations */ /* TRANSFORM_CLEANUP */ SET SESSION optimizer_switch=@switch_saved /* QNO 221 CON_ID 16 */ 17 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES ( 1, 1, 1 - 1, REPEAT(CAST(1 AS CHAR(1)),@fill_amount)) /* QNO 165 CON_ID 17 */ 16 Query /* GenTest::Transform::EnableOptimizations */ SET @switch_saved = @@optimizer_switch /* QNO 222 CON_ID 16 */ 16 Query SET SESSION optimizer_switch = REPLACE( @@optimizer_switch, '=off', '=on' ) /* QNO 223 CON_ID 16 */ 16 Query SHOW WARNINGS 16 Query DELETE FROM t1 WHERE MATCH(col4) AGAINST (TRIM(' 4 ') IN BOOLEAN MODE) OR col3 IS NULL /* QNO 216 CON_ID 16 */ /* TRANSFORM_OUTCOME_UNORDERED_MATCH */ /* QNO 224 CON_ID 16 */ 16 Query /* GenTest::Transform::EnableOptimizations */ /* TRANSFORM_CLEANUP */ SET SESSION optimizer_switch=@switch_saved /* QNO 225 CON_ID 16 */ 16 Query CREATE OR REPLACE VIEW transforms.view_12936_probe AS DELETE FROM t1 WHERE MATCH(col4) AGAINST (TRIM(' 4 ') IN BOOLEAN MODE) OR col3 IS NULL /* QNO 216 CON_ID 16 */ /* QNO 226 CON_ID 16 */ 16 Query COMMIT /* QNO 227 CON_ID 16 */ 16 Query CREATE OR REPLACE VIEW transforms.view_12936_probe AS COMMIT /* QNO 227 CON_ID 16 */ /* QNO 228 CON_ID 16 */ 17 Query ROLLBACK /* QNO 166 CON_ID 17 */ 17 Query CREATE OR REPLACE VIEW transforms.view_10968_probe AS ROLLBACK /* QNO 166 CON_ID 17 */ /* QNO 167 CON_ID 17 */ 16 Query UPDATE t1 SET col2 = NULL LIMIT 2 /* QNO 229 CON_ID 16 */ 21 Query /* GenTest::Transform::DisableOptimizations */ SET @switch_saved = @@optimizer_switch /* QNO 106 CON_ID 21 */ 17 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES ( 1, 1, 1, REPEAT(CAST(1 - 1 AS CHAR(1)),@fill_amount)) /* QNO 168 CON_ID 17 */ 21 Query SET SESSION optimizer_switch = REPLACE( @@optimizer_switch, '=on', '=off' ) /* QNO 107 CON_ID 21 */ 21 Query SET SESSION optimizer_switch = 'in_to_exists=on' /* QNO 108 CON_ID 21 */ 21 Query UPDATE t1 SET extra = col3 /* QNO 105 CON_ID 21 */ /* TRANSFORM_OUTCOME_UNORDERED_MATCH */ /* QNO 109 CON_ID 21 */ 21 Query /* GenTest::Transform::DisableOptimizations */ /* TRANSFORM_CLEANUP */ SET SESSION optimizer_switch=@switch_saved /* QNO 110 CON_ID 21 */ 21 Query /* GenTest::Transform::EnableOptimizations */ SET @switch_saved = @@optimizer_switch /* QNO 111 CON_ID 21 */ 21 Query SET SESSION optimizer_switch = REPLACE( @@optimizer_switch, '=off', '=on' ) /* QNO 112 CON_ID 21 */ 21 Query SHOW WARNINGS 21 Query UPDATE t1 SET extra = col3 /* QNO 105 CON_ID 21 */ /* TRANSFORM_OUTCOME_UNORDERED_MATCH */ /* QNO 113 CON_ID 21 */ 21 Query /* GenTest::Transform::EnableOptimizations */ /* TRANSFORM_CLEANUP */ SET SESSION optimizer_switch=@switch_saved /* QNO 114 CON_ID 21 */ 21 Query CREATE OR REPLACE VIEW transforms.view_4616_probe AS UPDATE t1 SET extra = col3 /* QNO 105 CON_ID 21 */ /* QNO 115 CON_ID 21 */ 21 Query ALTER TABLE t1 DROP COLUMN col3 /* QNO 116 CON_ID 21 */ 18 Query CREATE OR REPLACE VIEW transforms.view_3564_probe AS ALTER TABLE t1 CHANGE COLUMN extra col2 INT /* QNO 202 CON_ID 18 */ /* QNO 203 CON_ID 18 */ 16 Query /* GenTest::Transform::DisableOptimizations */ SET @switch_saved = @@optimizer_switch /* QNO 230 CON_ID 16 */ 18 Query ALTER TABLE t1 ADD UNIQUE KEY uidx ( col2 ) /* QNO 204 CON_ID 18 */ 17 Query ROLLBACK /* QNO 169 CON_ID 17 */ 19 Query ALTER TABLE t1 CHANGE COLUMN extra col1 INT /* QNO 116 CON_ID 19 */ 16 Query SET SESSION optimizer_switch = REPLACE( @@optimizer_switch, '=on', '=off' ) /* QNO 231 CON_ID 16 */ 16 Query SET SESSION optimizer_switch = 'in_to_exists=on' /* QNO 232 CON_ID 16 */ 17 Query CREATE OR REPLACE VIEW transforms.view_10968_probe AS ROLLBACK /* QNO 169 CON_ID 17 */ /* QNO 170 CON_ID 17 */ 16 Query UPDATE t1 SET col2 = NULL LIMIT 2 /* QNO 229 CON_ID 16 */ /* TRANSFORM_OUTCOME_UNORDERED_MATCH */ /* QNO 233 CON_ID 16 */ 17 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES ( NULL, NULL, NULL - 1, REPEAT(CAST(NULL AS CHAR(1)),@fill_amount)) /* QNO 171 CON_ID 17 */ 16 Query /* GenTest::Transform::DisableOptimizations */ /* TRANSFORM_CLEANUP */ SET SESSION optimizer_switch=@switch_saved /* QNO 234 CON_ID 16 */ 16 Query /* GenTest::Transform::EnableOptimizations */ SET @switch_saved = @@optimizer_switch /* QNO 235 CON_ID 16 */ 16 Query SET SESSION optimizer_switch = REPLACE( @@optimizer_switch, '=off', '=on' ) /* QNO 236 CON_ID 16 */ 16 Query SHOW WARNINGS 16 Query UPDATE t1 SET col2 = NULL LIMIT 2 /* QNO 229 CON_ID 16 */ /* TRANSFORM_OUTCOME_UNORDERED_MATCH */ /* QNO 237 CON_ID 16 */ 16 Query /* GenTest::Transform::EnableOptimizations */ /* TRANSFORM_CLEANUP */ SET SESSION optimizer_switch=@switch_saved /* QNO 238 CON_ID 16 */ 16 Query CREATE OR REPLACE VIEW transforms.view_12936_probe AS UPDATE t1 SET col2 = NULL LIMIT 2 /* QNO 229 CON_ID 16 */ /* QNO 239 CON_ID 16 */ 16 Query COMMIT /* QNO 240 CON_ID 16 */ 16 Query CREATE OR REPLACE VIEW transforms.view_12936_probe AS COMMIT /* QNO 240 CON_ID 16 */ /* QNO 241 CON_ID 16 */ 16 Query UPDATE t1 SET col3 = 1 LIMIT 2 /* QNO 242 CON_ID 16 */ 171012 18:12:38 21 Query CREATE OR REPLACE VIEW transforms.view_4616_probe AS ALTER TABLE t1 DROP COLUMN col3 /* QNO 116 CON_ID 21 */ /* QNO 117 CON_ID 21 */ 21 Query ALTER TABLE t1 CHANGE COLUMN extra col3 INT /* QNO 118 CON_ID 21 */ 17 Query ROLLBACK /* QNO 172 CON_ID 17 */ 17 Query CREATE OR REPLACE VIEW transforms.view_10968_probe AS ROLLBACK /* QNO 172 CON_ID 17 */ /* QNO 173 CON_ID 17 */ 17 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES ( NULL, NULL - 1, NULL, REPEAT(CAST(NULL AS CHAR(1)),@fill_amount)) /* QNO 174 CON_ID 17 */ 16 Query ROLLBACK /* QNO 243 CON_ID 16 */ 16 Query CREATE OR REPLACE VIEW transforms.view_12936_probe AS ROLLBACK /* QNO 243 CON_ID 16 */ /* QNO 244 CON_ID 16 */ 16 Query ALTER TABLE t1 DROP KEY ftidx, DROP PRIMARY KEY /* QNO 245 CON_ID 16 */ 17 Query COMMIT /* QNO 175 CON_ID 17 */ 17 Query CREATE OR REPLACE VIEW transforms.view_10968_probe AS COMMIT /* QNO 175 CON_ID 17 */ /* QNO 176 CON_ID 17 */ 17 Query ALTER TABLE t1 DROP KEY ftidx /* QNO 177 CON_ID 17 */ 18 Query CREATE OR REPLACE VIEW transforms.view_3564_probe AS ALTER TABLE t1 ADD UNIQUE KEY uidx ( col2 ) /* QNO 204 CON_ID 18 */ /* QNO 205 CON_ID 18 */ 16 Query DELETE FROM t1 WHERE MATCH(col4) AGAINST (TRIM(' 4 ') IN BOOLEAN MODE) OR col2 IS NULL /* QNO 246 CON_ID 16 */ 19 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES ( 3, 3 - 1, 3, REPEAT(CAST(3 AS CHAR(1)),@fill_amount)) /* QNO 117 CON_ID 19 */ 18 Query ALTER TABLE t1 DROP KEY ftidx, DROP KEY ftidx /* QNO 206 CON_ID 18 */ 16 Query /* GenTest::Transform::DisableOptimizations */ SET @switch_saved = @@optimizer_switch /* QNO 247 CON_ID 16 */ 21 Query ALTER TABLE t1 DROP KEY uidx /* QNO 119 CON_ID 21 */ 19 Query ROLLBACK /* QNO 118 CON_ID 19 */ 16 Query SET SESSION optimizer_switch = REPLACE( @@optimizer_switch, '=on', '=off' ) /* QNO 248 CON_ID 16 */ 16 Query SET SESSION optimizer_switch = 'in_to_exists=on' /* QNO 249 CON_ID 16 */ 16 Query DELETE FROM t1 WHERE MATCH(col4) AGAINST (TRIM(' 4 ') IN BOOLEAN MODE) OR col2 IS NULL /* QNO 246 CON_ID 16 */ /* TRANSFORM_OUTCOME_UNORDERED_MATCH */ /* QNO 250 CON_ID 16 */ 19 Query CREATE OR REPLACE VIEW transforms.view_8236_probe AS ROLLBACK /* QNO 118 CON_ID 19 */ /* QNO 119 CON_ID 19 */ 16 Query /* GenTest::Transform::DisableOptimizations */ /* TRANSFORM_CLEANUP */ SET SESSION optimizer_switch=@switch_saved /* QNO 251 CON_ID 16 */ 16 Query /* GenTest::Transform::EnableOptimizations */ SET @switch_saved = @@optimizer_switch /* QNO 252 CON_ID 16 */ 16 Query SET SESSION optimizer_switch = REPLACE( @@optimizer_switch, '=off', '=on' ) /* QNO 253 CON_ID 16 */ 19 Query DELETE FROM t1 WHERE col1 = 2 OR col1 IS NULL /* QNO 120 CON_ID 19 */ 16 Query SHOW WARNINGS 16 Query DELETE FROM t1 WHERE MATCH(col4) AGAINST (TRIM(' 4 ') IN BOOLEAN MODE) OR col2 IS NULL /* QNO 246 CON_ID 16 */ /* TRANSFORM_OUTCOME_UNORDERED_MATCH */ /* QNO 254 CON_ID 16 */ 16 Query /* GenTest::Transform::EnableOptimizations */ /* TRANSFORM_CLEANUP */ SET SESSION optimizer_switch=@switch_saved /* QNO 255 CON_ID 16 */ 16 Query CREATE OR REPLACE VIEW transforms.view_12936_probe AS DELETE FROM t1 WHERE MATCH(col4) AGAINST (TRIM(' 4 ') IN BOOLEAN MODE) OR col2 IS NULL /* QNO 246 CON_ID 16 */ /* QNO 256 CON_ID 16 */ 16 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES /* 4 */ (4,4,4,REPEAT(CAST(4 AS CHAR(1)),@fill_amount)), (4,4,4,REPEAT(CAST(4 AS CHAR(1)),@fill_amount)) /* QNO 257 CON_ID 16 */ 16 Query COMMIT /* QNO 258 CON_ID 16 */ 19 Query COMMIT /* QNO 121 CON_ID 19 */ 19 Query CREATE OR REPLACE VIEW transforms.view_8236_probe AS COMMIT /* QNO 121 CON_ID 19 */ /* QNO 122 CON_ID 19 */ 16 Query CREATE OR REPLACE VIEW transforms.view_12936_probe AS COMMIT /* QNO 258 CON_ID 16 */ /* QNO 259 CON_ID 16 */ 19 Query DELETE FROM t1 WHERE MATCH(col4) AGAINST (TRIM(' NULL ') IN BOOLEAN MODE) OR col1 IS NULL /* QNO 123 CON_ID 19 */ 16 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES ( NULL, NULL, NULL, REPEAT(CAST(NULL - 1 AS CHAR(1)),@fill_amount)) /* QNO 260 CON_ID 16 */ 171012 18:12:39 17 Query CREATE OR REPLACE VIEW transforms.view_10968_probe AS ALTER TABLE t1 DROP KEY ftidx /* QNO 177 CON_ID 17 */ /* QNO 178 CON_ID 17 */ 18 Query UPDATE t1 SET col1 = NULL LIMIT 2 /* QNO 207 CON_ID 18 */ 19 Query COMMIT /* QNO 124 CON_ID 19 */ 17 Query UPDATE t1 SET col2 = 1 LIMIT 2 /* QNO 179 CON_ID 17 */ 19 Query CREATE OR REPLACE VIEW transforms.view_8236_probe AS COMMIT /* QNO 124 CON_ID 19 */ /* QNO 125 CON_ID 19 */ 16 Query COMMIT /* QNO 261 CON_ID 16 */ 16 Query CREATE OR REPLACE VIEW transforms.view_12936_probe AS COMMIT /* QNO 261 CON_ID 16 */ /* QNO 262 CON_ID 16 */ 19 Query ALTER TABLE t1 ADD COLUMN extra INT /* QNO 126 CON_ID 19 */ 16 Query ALTER TABLE t1 DROP PRIMARY KEY, ADD FULLTEXT KEY ftidx ( col4 ) /* QNO 263 CON_ID 16 */ 18 Query COMMIT /* QNO 208 CON_ID 18 */ 18 Query CREATE OR REPLACE VIEW transforms.view_3564_probe AS COMMIT /* QNO 208 CON_ID 18 */ /* QNO 209 CON_ID 18 */ 18 Query DELETE FROM t1 WHERE MATCH(col4) AGAINST (TRIM(' 1 ') IN BOOLEAN MODE) OR col3 IS NULL /* QNO 210 CON_ID 18 */ 17 Query /* GenTest::Transform::DisableOptimizations */ SET @switch_saved = @@optimizer_switch /* QNO 180 CON_ID 17 */ 17 Query SET SESSION optimizer_switch = REPLACE( @@optimizer_switch, '=on', '=off' ) /* QNO 181 CON_ID 17 */ 17 Query SET SESSION optimizer_switch = 'in_to_exists=on' /* QNO 182 CON_ID 17 */ 17 Query UPDATE t1 SET col2 = 1 LIMIT 2 /* QNO 179 CON_ID 17 */ /* TRANSFORM_OUTCOME_UNORDERED_MATCH */ /* QNO 183 CON_ID 17 */ 17 Query /* GenTest::Transform::DisableOptimizations */ /* TRANSFORM_CLEANUP */ SET SESSION optimizer_switch=@switch_saved /* QNO 184 CON_ID 17 */ 17 Query /* GenTest::Transform::EnableOptimizations */ SET @switch_saved = @@optimizer_switch /* QNO 185 CON_ID 17 */ 17 Query SET SESSION optimizer_switch = REPLACE( @@optimizer_switch, '=off', '=on' ) /* QNO 186 CON_ID 17 */ 17 Query SHOW WARNINGS 17 Query UPDATE t1 SET col2 = 1 LIMIT 2 /* QNO 179 CON_ID 17 */ /* TRANSFORM_OUTCOME_UNORDERED_MATCH */ /* QNO 187 CON_ID 17 */ 17 Query /* GenTest::Transform::EnableOptimizations */ /* TRANSFORM_CLEANUP */ SET SESSION optimizer_switch=@switch_saved /* QNO 188 CON_ID 17 */ 17 Query CREATE OR REPLACE VIEW transforms.view_10968_probe AS UPDATE t1 SET col2 = 1 LIMIT 2 /* QNO 179 CON_ID 17 */ /* QNO 189 CON_ID 17 */ 17 Query COMMIT /* QNO 190 CON_ID 17 */ 17 Query CREATE OR REPLACE VIEW transforms.view_10968_probe AS COMMIT /* QNO 190 CON_ID 17 */ /* QNO 191 CON_ID 17 */ 17 Query UPDATE t1 SET col1 = 1 LIMIT 2 /* QNO 192 CON_ID 17 */ 21 Query CREATE OR REPLACE VIEW transforms.view_4616_probe AS ALTER TABLE t1 DROP KEY uidx /* QNO 119 CON_ID 21 */ /* QNO 120 CON_ID 21 */ 18 Query COMMIT /* QNO 211 CON_ID 18 */ 17 Query COMMIT /* QNO 193 CON_ID 17 */ 18 Query CREATE OR REPLACE VIEW transforms.view_3564_probe AS COMMIT /* QNO 211 CON_ID 18 */ /* QNO 212 CON_ID 18 */ 17 Query CREATE OR REPLACE VIEW transforms.view_10968_probe AS COMMIT /* QNO 193 CON_ID 17 */ /* QNO 194 CON_ID 17 */ 21 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES ( 3, 3, 3, REPEAT(CAST(3 - 1 AS CHAR(1)),@fill_amount)) /* QNO 121 CON_ID 21 */ 17 Query ALTER TABLE t1 DROP PRIMARY KEY /* QNO 195 CON_ID 17 */ 18 Query ALTER TABLE t1 DROP KEY idx /* QNO 213 CON_ID 18 */ 21 Query ROLLBACK /* QNO 122 CON_ID 21 */ 21 Query CREATE OR REPLACE VIEW transforms.view_4616_probe AS ROLLBACK /* QNO 122 CON_ID 21 */ /* QNO 123 CON_ID 21 */ 21 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES ( 2, 2, 2, REPEAT(CAST(2 - 1 AS CHAR(1)),@fill_amount)) /* QNO 124 CON_ID 21 */ 21 Query COMMIT /* QNO 125 CON_ID 21 */ 21 Query CREATE OR REPLACE VIEW transforms.view_4616_probe AS COMMIT /* QNO 125 CON_ID 21 */ /* QNO 126 CON_ID 21 */ 21 Query UPDATE t1 SET col2 = 2 LIMIT 2 /* QNO 127 CON_ID 21 */ 21 Query /* GenTest::Transform::DisableOptimizations */ SET @switch_saved = @@optimizer_switch /* QNO 128 CON_ID 21 */ 21 Query SET SESSION optimizer_switch = REPLACE( @@optimizer_switch, '=on', '=off' ) /* QNO 129 CON_ID 21 */ 21 Query SET SESSION optimizer_switch = 'in_to_exists=on' /* QNO 130 CON_ID 21 */ 21 Query UPDATE t1 SET col2 = 2 LIMIT 2 /* QNO 127 CON_ID 21 */ /* TRANSFORM_OUTCOME_UNORDERED_MATCH */ /* QNO 131 CON_ID 21 */ 21 Query /* GenTest::Transform::DisableOptimizations */ /* TRANSFORM_CLEANUP */ SET SESSION optimizer_switch=@switch_saved /* QNO 132 CON_ID 21 */ 21 Query /* GenTest::Transform::EnableOptimizations */ SET @switch_saved = @@optimizer_switch /* QNO 133 CON_ID 21 */ 21 Query SET SESSION optimizer_switch = REPLACE( @@optimizer_switch, '=off', '=on' ) /* QNO 134 CON_ID 21 */ 21 Query SHOW WARNINGS 21 Query UPDATE t1 SET col2 = 2 LIMIT 2 /* QNO 127 CON_ID 21 */ /* TRANSFORM_OUTCOME_UNORDERED_MATCH */ /* QNO 135 CON_ID 21 */ 21 Query /* GenTest::Transform::EnableOptimizations */ /* TRANSFORM_CLEANUP */ SET SESSION optimizer_switch=@switch_saved /* QNO 136 CON_ID 21 */ 21 Query CREATE OR REPLACE VIEW transforms.view_4616_probe AS UPDATE t1 SET col2 = 2 LIMIT 2 /* QNO 127 CON_ID 21 */ /* QNO 137 CON_ID 21 */ 21 Query COMMIT /* QNO 138 CON_ID 21 */ 21 Query CREATE OR REPLACE VIEW transforms.view_4616_probe AS COMMIT /* QNO 138 CON_ID 21 */ /* QNO 139 CON_ID 21 */ 21 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES ( NULL, NULL, NULL, REPEAT(CAST(NULL AS CHAR(1)),@fill_amount)) /* QNO 140 CON_ID 21 */ 21 Query ROLLBACK /* QNO 141 CON_ID 21 */ 21 Query CREATE OR REPLACE VIEW transforms.view_4616_probe AS ROLLBACK /* QNO 141 CON_ID 21 */ /* QNO 142 CON_ID 21 */ 21 Query ALTER TABLE t1 ADD COLUMN extra INT /* QNO 143 CON_ID 21 */ 17 Query ALTER TABLE t1 DROP KEY idx /* QNO 196 CON_ID 17 */ 16 Query ALTER TABLE t1 ADD PRIMARY KEY ( col2 ) /* QNO 264 CON_ID 16 */ 19 Query CREATE OR REPLACE VIEW transforms.view_8236_probe AS ALTER TABLE t1 ADD COLUMN extra INT /* QNO 126 CON_ID 19 */ /* QNO 127 CON_ID 19 */ 21 Query UPDATE t1 SET extra = col2 /* QNO 144 CON_ID 21 */ 18 Query ALTER TABLE t1 ADD KEY idx ( col3 ) /* QNO 214 CON_ID 18 */ 19 Query UPDATE t1 SET extra = col3 /* QNO 128 CON_ID 19 */ 17 Query UPDATE t1 SET col2 = 4 LIMIT 2 /* QNO 197 CON_ID 17 */ 171012 18:12:40 16 Query CREATE OR REPLACE VIEW transforms.view_12936_probe AS ALTER TABLE t1 ADD PRIMARY KEY ( col2 ) /* QNO 264 CON_ID 16 */ /* QNO 265 CON_ID 16 */ 17 Query /* GenTest::Transform::DisableOptimizations */ SET @switch_saved = @@optimizer_switch /* QNO 198 CON_ID 17 */ 17 Query SET SESSION optimizer_switch = REPLACE( @@optimizer_switch, '=on', '=off' ) /* QNO 199 CON_ID 17 */ 17 Query SET SESSION optimizer_switch = 'in_to_exists=on' /* QNO 200 CON_ID 17 */ 16 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES ( 3, 3, 3 - 1, REPEAT(CAST(3 AS CHAR(1)),@fill_amount)) /* QNO 266 CON_ID 16 */ 17 Query UPDATE t1 SET col2 = 4 LIMIT 2 /* QNO 197 CON_ID 17 */ /* TRANSFORM_OUTCOME_UNORDERED_MATCH */ /* QNO 201 CON_ID 17 */ 18 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES ( 2, 2, 2, REPEAT(CAST(2 AS CHAR(1)),@fill_amount)) /* QNO 215 CON_ID 18 */ 16 Query ROLLBACK /* QNO 267 CON_ID 16 */ 18 Query ROLLBACK /* QNO 216 CON_ID 18 */ 17 Query /* GenTest::Transform::DisableOptimizations */ /* TRANSFORM_CLEANUP */ SET SESSION optimizer_switch=@switch_saved /* QNO 202 CON_ID 17 */ 18 Query CREATE OR REPLACE VIEW transforms.view_3564_probe AS ROLLBACK /* QNO 216 CON_ID 18 */ /* QNO 217 CON_ID 18 */ 16 Query CREATE OR REPLACE VIEW transforms.view_12936_probe AS ROLLBACK /* QNO 267 CON_ID 16 */ /* QNO 268 CON_ID 16 */ 17 Query /* GenTest::Transform::EnableOptimizations */ SET @switch_saved = @@optimizer_switch /* QNO 203 CON_ID 17 */ 16 Query UPDATE t1 SET col2 = NULL LIMIT 2 /* QNO 269 CON_ID 16 */ 19 Query ALTER TABLE t1 DROP COLUMN col3 /* QNO 129 CON_ID 19 */ 17 Query SET SESSION optimizer_switch = REPLACE( @@optimizer_switch, '=off', '=on' ) /* QNO 204 CON_ID 17 */ 17 Query SHOW WARNINGS 18 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES ( NULL, NULL - 1, NULL, REPEAT(CAST(NULL AS CHAR(1)),@fill_amount)) /* QNO 218 CON_ID 18 */ 17 Query UPDATE t1 SET col2 = 4 LIMIT 2 /* QNO 197 CON_ID 17 */ /* TRANSFORM_OUTCOME_UNORDERED_MATCH */ /* QNO 205 CON_ID 17 */ 19 Query ALTER TABLE t1 CHANGE COLUMN extra col3 INT /* QNO 130 CON_ID 19 */ 17 Query /* GenTest::Transform::EnableOptimizations */ /* TRANSFORM_CLEANUP */ SET SESSION optimizer_switch=@switch_saved /* QNO 206 CON_ID 17 */ 17 Query CREATE OR REPLACE VIEW transforms.view_10968_probe AS UPDATE t1 SET col2 = 4 LIMIT 2 /* QNO 197 CON_ID 17 */ /* QNO 207 CON_ID 17 */ 17 Query COMMIT /* QNO 208 CON_ID 17 */ 21 Query /* GenTest::Transform::DisableOptimizations */ SET @switch_saved = @@optimizer_switch /* QNO 145 CON_ID 21 */ 21 Query SET SESSION optimizer_switch = REPLACE( @@optimizer_switch, '=on', '=off' ) /* QNO 146 CON_ID 21 */ 21 Query SET SESSION optimizer_switch = 'in_to_exists=on' /* QNO 147 CON_ID 21 */ 21 Query UPDATE t1 SET extra = col2 /* QNO 144 CON_ID 21 */ /* TRANSFORM_OUTCOME_UNORDERED_MATCH */ /* QNO 148 CON_ID 21 */ 21 Query /* GenTest::Transform::DisableOptimizations */ /* TRANSFORM_CLEANUP */ SET SESSION optimizer_switch=@switch_saved /* QNO 149 CON_ID 21 */ 21 Query /* GenTest::Transform::EnableOptimizations */ SET @switch_saved = @@optimizer_switch /* QNO 150 CON_ID 21 */ 21 Query SET SESSION optimizer_switch = REPLACE( @@optimizer_switch, '=off', '=on' ) /* QNO 151 CON_ID 21 */ 21 Query SHOW WARNINGS 21 Query UPDATE t1 SET extra = col2 /* QNO 144 CON_ID 21 */ /* TRANSFORM_OUTCOME_UNORDERED_MATCH */ /* QNO 152 CON_ID 21 */ 21 Query /* GenTest::Transform::EnableOptimizations */ /* TRANSFORM_CLEANUP */ SET SESSION optimizer_switch=@switch_saved /* QNO 153 CON_ID 21 */ 21 Query CREATE OR REPLACE VIEW transforms.view_4616_probe AS UPDATE t1 SET extra = col2 /* QNO 144 CON_ID 21 */ /* QNO 154 CON_ID 21 */ 21 Query ALTER TABLE t1 DROP COLUMN col2 /* QNO 155 CON_ID 21 */ 16 Query SHOW WARNINGS 16 Query COMMIT /* QNO 270 CON_ID 16 */ 17 Query CREATE OR REPLACE VIEW transforms.view_10968_probe AS COMMIT /* QNO 208 CON_ID 17 */ /* QNO 209 CON_ID 17 */ 17 Query DELETE FROM t1 WHERE MATCH(col4) AGAINST (TRIM(' 4 ') IN BOOLEAN MODE) OR col3 IS NULL /* QNO 210 CON_ID 17 */ 16 Query CREATE OR REPLACE VIEW transforms.view_12936_probe AS COMMIT /* QNO 270 CON_ID 16 */ /* QNO 271 CON_ID 16 */ 16 Query ALTER TABLE t1 DROP PRIMARY KEY /* QNO 272 CON_ID 16 */ 17 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES /* 1 */ (1,1,1,REPEAT(CAST(1 AS CHAR(1)),@fill_amount)), (1,1,1,REPEAT(CAST(1 AS CHAR(1)),@fill_amount)) /* QNO 211 CON_ID 17 */ 18 Query ROLLBACK /* QNO 219 CON_ID 18 */ 17 Query COMMIT /* QNO 212 CON_ID 17 */ 17 Query CREATE OR REPLACE VIEW transforms.view_10968_probe AS COMMIT /* QNO 212 CON_ID 17 */ /* QNO 213 CON_ID 17 */ 18 Query CREATE OR REPLACE VIEW transforms.view_3564_probe AS ROLLBACK /* QNO 219 CON_ID 18 */ /* QNO 220 CON_ID 18 */ 17 Query ALTER TABLE t1 ADD UNIQUE KEY uidx ( col3 ), ADD UNIQUE KEY uidx ( col3 ) /* QNO 214 CON_ID 17 */ 18 Query ALTER TABLE t1 DROP PRIMARY KEY, DROP PRIMARY KEY /* QNO 221 CON_ID 18 */ 19 Query CREATE OR REPLACE VIEW transforms.view_8236_probe AS ALTER TABLE t1 CHANGE COLUMN extra col3 INT /* QNO 130 CON_ID 19 */ /* QNO 131 CON_ID 19 */ 19 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES ( NULL, NULL, NULL - 1, REPEAT(CAST(NULL AS CHAR(1)),@fill_amount)) /* QNO 132 CON_ID 19 */ 21 Query CREATE OR REPLACE VIEW transforms.view_4616_probe AS ALTER TABLE t1 DROP COLUMN col2 /* QNO 155 CON_ID 21 */ /* QNO 156 CON_ID 21 */ 17 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES ( NULL, NULL, NULL - 1, REPEAT(CAST(NULL AS CHAR(1)),@fill_amount)) /* QNO 215 CON_ID 17 */ 19 Query COMMIT /* QNO 133 CON_ID 19 */ 16 Query DELETE FROM t1 WHERE col2 = 3 OR col2 IS NULL /* QNO 273 CON_ID 16 */ 17 Query COMMIT /* QNO 216 CON_ID 17 */ 16 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES /* NULL */ (NULL,NULL,NULL,REPEAT(CAST(NULL AS CHAR(1)),@fill_amount)), (NULL,NULL,NULL,REPEAT(CAST(NULL AS CHAR(1)),@fill_amount)) /* QNO 274 CON_ID 16 */ 17 Query CREATE OR REPLACE VIEW transforms.view_10968_probe AS COMMIT /* QNO 216 CON_ID 17 */ /* QNO 217 CON_ID 17 */ 16 Query COMMIT /* QNO 275 CON_ID 16 */ 21 Query ALTER TABLE t1 CHANGE COLUMN extra col2 INT /* QNO 157 CON_ID 21 */ 21 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES ( 4, 4, 4, REPEAT(CAST(4 AS CHAR(1)),@fill_amount)) /* QNO 158 CON_ID 21 */ 17 Query ALTER TABLE t1 ADD KEY idx ( col3 ), ADD PRIMARY KEY ( col3 ) /* QNO 218 CON_ID 17 */ 16 Query CREATE OR REPLACE VIEW transforms.view_12936_probe AS COMMIT /* QNO 275 CON_ID 16 */ /* QNO 276 CON_ID 16 */ 19 Query CREATE OR REPLACE VIEW transforms.view_8236_probe AS COMMIT /* QNO 133 CON_ID 19 */ /* QNO 134 CON_ID 19 */ 18 Query ALTER TABLE t1 ADD FULLTEXT KEY ftidx ( col4 ) /* QNO 222 CON_ID 18 */ 21 Query ROLLBACK /* QNO 159 CON_ID 21 */ 19 Query ALTER TABLE t1 DROP KEY uidx, ADD UNIQUE KEY uidx ( col2 ) /* QNO 135 CON_ID 19 */ 16 Query DELETE FROM t1 WHERE MATCH(col4) AGAINST (TRIM(' 1 ') IN BOOLEAN MODE) OR col3 IS NULL /* QNO 277 CON_ID 16 */ 21 Query CREATE OR REPLACE VIEW transforms.view_4616_probe AS ROLLBACK /* QNO 159 CON_ID 21 */ /* QNO 160 CON_ID 21 */ 21 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES ( 1, 1, 1, REPEAT(CAST(1 - 1 AS CHAR(1)),@fill_amount)) /* QNO 161 CON_ID 21 */ 17 Query CREATE OR REPLACE VIEW transforms.view_10968_probe AS ALTER TABLE t1 ADD KEY idx ( col3 ), ADD PRIMARY KEY ( col3 ) /* QNO 218 CON_ID 17 */ /* QNO 219 CON_ID 17 */ 21 Query ROLLBACK /* QNO 162 CON_ID 21 */ 21 Query CREATE OR REPLACE VIEW transforms.view_4616_probe AS ROLLBACK /* QNO 162 CON_ID 21 */ /* QNO 163 CON_ID 21 */ 17 Query ALTER TABLE t1 DROP KEY uidx, ADD KEY idx ( col3 ) /* QNO 220 CON_ID 17 */ 16 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES /* 1 */ (1,1,1,REPEAT(CAST(1 AS CHAR(1)),@fill_amount)), (1,1,1,REPEAT(CAST(1 AS CHAR(1)),@fill_amount)) /* QNO 278 CON_ID 16 */ 21 Query ALTER TABLE t1 DROP KEY idx /* QNO 164 CON_ID 21 */ 16 Query COMMIT /* QNO 279 CON_ID 16 */ 16 Query CREATE OR REPLACE VIEW transforms.view_12936_probe AS COMMIT /* QNO 279 CON_ID 16 */ /* QNO 280 CON_ID 16 */ 16 Query ALTER TABLE t1 DROP KEY idx /* QNO 281 CON_ID 16 */ 171012 18:12:41 18 Query SHOW WARNINGS 19 Query DELETE FROM t1 WHERE col1 = NULL OR col1 IS NULL /* QNO 136 CON_ID 19 */ 18 Query CHECK TABLE t1 /* QNO 223 CON_ID 18 */ 17 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES ( 4, 4, 4, REPEAT(CAST(4 - 1 AS CHAR(1)),@fill_amount)) /* QNO 221 CON_ID 17 */ 17 Query COMMIT /* QNO 222 CON_ID 17 */ 19 Query COMMIT /* QNO 137 CON_ID 19 */ 19 Query CREATE OR REPLACE VIEW transforms.view_8236_probe AS COMMIT /* QNO 137 CON_ID 19 */ /* QNO 138 CON_ID 19 */ 17 Query CREATE OR REPLACE VIEW transforms.view_10968_probe AS COMMIT /* QNO 222 CON_ID 17 */ /* QNO 223 CON_ID 17 */ 19 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES ( NULL, NULL, NULL - 1, REPEAT(CAST(NULL AS CHAR(1)),@fill_amount)) /* QNO 139 CON_ID 19 */ 19 Query COMMIT /* QNO 140 CON_ID 19 */ 17 Query DELETE FROM t1 WHERE col3 = 4 OR col3 IS NULL /* QNO 224 CON_ID 17 */ 19 Query CREATE OR REPLACE VIEW transforms.view_8236_probe AS COMMIT /* QNO 140 CON_ID 19 */ /* QNO 141 CON_ID 19 */ 17 Query /* GenTest::Transform::DisableOptimizations */ SET @switch_saved = @@optimizer_switch /* QNO 225 CON_ID 17 */ 19 Query ALTER TABLE t1 DROP KEY uidx, DROP KEY uidx /* QNO 142 CON_ID 19 */ 17 Query SET SESSION optimizer_switch = REPLACE( @@optimizer_switch, '=on', '=off' ) /* QNO 226 CON_ID 17 */ 17 Query SET SESSION optimizer_switch = 'in_to_exists=on' /* QNO 227 CON_ID 17 */ 17 Query DELETE FROM t1 WHERE col3 = 4 OR col3 IS NULL /* QNO 224 CON_ID 17 */ /* TRANSFORM_OUTCOME_UNORDERED_MATCH */ /* QNO 228 CON_ID 17 */ 17 Query /* GenTest::Transform::DisableOptimizations */ /* TRANSFORM_CLEANUP */ SET SESSION optimizer_switch=@switch_saved /* QNO 229 CON_ID 17 */ 17 Query /* GenTest::Transform::EnableOptimizations */ SET @switch_saved = @@optimizer_switch /* QNO 230 CON_ID 17 */ 17 Query SET SESSION optimizer_switch = REPLACE( @@optimizer_switch, '=off', '=on' ) /* QNO 231 CON_ID 17 */ 17 Query SHOW WARNINGS 17 Query DELETE FROM t1 WHERE col3 = 4 OR col3 IS NULL /* QNO 224 CON_ID 17 */ /* TRANSFORM_OUTCOME_UNORDERED_MATCH */ /* QNO 232 CON_ID 17 */ 17 Query /* GenTest::Transform::EnableOptimizations */ /* TRANSFORM_CLEANUP */ SET SESSION optimizer_switch=@switch_saved /* QNO 233 CON_ID 17 */ 17 Query CREATE OR REPLACE VIEW transforms.view_10968_probe AS DELETE FROM t1 WHERE col3 = 4 OR col3 IS NULL /* QNO 224 CON_ID 17 */ /* QNO 234 CON_ID 17 */ 17 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES /* 3 */ (3,3,3,REPEAT(CAST(3 AS CHAR(1)),@fill_amount)), (3,3,3,REPEAT(CAST(3 AS CHAR(1)),@fill_amount)) /* QNO 235 CON_ID 17 */ 17 Query COMMIT /* QNO 236 CON_ID 17 */ 18 Query CREATE OR REPLACE VIEW transforms.view_3564_probe AS CHECK TABLE t1 /* QNO 223 CON_ID 18 */ /* QNO 224 CON_ID 18 */ 18 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES ( 2, 2, 2, REPEAT(CAST(2 - 1 AS CHAR(1)),@fill_amount)) /* QNO 225 CON_ID 18 */ 17 Query CREATE OR REPLACE VIEW transforms.view_10968_probe AS COMMIT /* QNO 236 CON_ID 17 */ /* QNO 237 CON_ID 17 */ 18 Query COMMIT /* QNO 226 CON_ID 18 */ 18 Query CREATE OR REPLACE VIEW transforms.view_3564_probe AS COMMIT /* QNO 226 CON_ID 18 */ /* QNO 227 CON_ID 18 */ 17 Query ALTER TABLE t1 DROP KEY idx, DROP PRIMARY KEY /* QNO 238 CON_ID 17 */ 18 Query ALTER TABLE t1 DROP PRIMARY KEY, DROP KEY idx /* QNO 228 CON_ID 18 */ 17 Query UPDATE t1 SET col2 = 2 LIMIT 2 /* QNO 239 CON_ID 17 */ 21 Query CREATE OR REPLACE VIEW transforms.view_4616_probe AS ALTER TABLE t1 DROP KEY idx /* QNO 164 CON_ID 21 */ /* QNO 165 CON_ID 21 */ 16 Query DELETE FROM t1 WHERE MATCH(col4) AGAINST (TRIM(' 3 ') IN BOOLEAN MODE) OR col3 IS NULL /* QNO 282 CON_ID 16 */ 17 Query ROLLBACK /* QNO 240 CON_ID 17 */ 19 Query UPDATE t1 SET col3 = 2 LIMIT 2 /* QNO 143 CON_ID 19 */ 21 Query ALTER TABLE t1 ADD KEY idx ( col1 ) /* QNO 166 CON_ID 21 */ 16 Query /* GenTest::Transform::DisableOptimizations */ SET @switch_saved = @@optimizer_switch /* QNO 283 CON_ID 16 */ 18 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES ( 4, 4, 4 - 1, REPEAT(CAST(4 AS CHAR(1)),@fill_amount)) /* QNO 229 CON_ID 18 */ 17 Query CREATE OR REPLACE VIEW transforms.view_10968_probe AS ROLLBACK /* QNO 240 CON_ID 17 */ /* QNO 241 CON_ID 17 */ 19 Query /* GenTest::Transform::DisableOptimizations */ SET @switch_saved = @@optimizer_switch /* QNO 144 CON_ID 19 */ 17 Query ALTER TABLE t1 DROP KEY idx /* QNO 242 CON_ID 17 */ 19 Query SET SESSION optimizer_switch = REPLACE( @@optimizer_switch, '=on', '=off' ) /* QNO 145 CON_ID 19 */ 21 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES ( 3, 3, 3, REPEAT(CAST(3 - 1 AS CHAR(1)),@fill_amount)) /* QNO 167 CON_ID 21 */ 16 Query SET SESSION optimizer_switch = REPLACE( @@optimizer_switch, '=on', '=off' ) /* QNO 284 CON_ID 16 */ 18 Query ROLLBACK /* QNO 230 CON_ID 18 */ 17 Query ALTER TABLE t1 DROP PRIMARY KEY, DROP PRIMARY KEY /* QNO 243 CON_ID 17 */ 19 Query SET SESSION optimizer_switch = 'in_to_exists=on' /* QNO 146 CON_ID 19 */ 18 Query CREATE OR REPLACE VIEW transforms.view_3564_probe AS ROLLBACK /* QNO 230 CON_ID 18 */ /* QNO 231 CON_ID 18 */ 17 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES ( NULL, NULL, NULL - 1, REPEAT(CAST(NULL AS CHAR(1)),@fill_amount)) /* QNO 244 CON_ID 17 */ 19 Query UPDATE t1 SET col3 = 2 LIMIT 2 /* QNO 143 CON_ID 19 */ /* TRANSFORM_OUTCOME_UNORDERED_MATCH */ /* QNO 147 CON_ID 19 */ 18 Query ALTER TABLE t1 ADD KEY idx ( col3 ) /* QNO 232 CON_ID 18 */ 16 Query SET SESSION optimizer_switch = 'in_to_exists=on' /* QNO 285 CON_ID 16 */ 19 Query /* GenTest::Transform::DisableOptimizations */ /* TRANSFORM_CLEANUP */ SET SESSION optimizer_switch=@switch_saved /* QNO 148 CON_ID 19 */ 16 Query DELETE FROM t1 WHERE MATCH(col4) AGAINST (TRIM(' 3 ') IN BOOLEAN MODE) OR col3 IS NULL /* QNO 282 CON_ID 16 */ /* TRANSFORM_OUTCOME_UNORDERED_MATCH */ /* QNO 286 CON_ID 16 */ 17 Query ROLLBACK /* QNO 245 CON_ID 17 */ 17 Query CREATE OR REPLACE VIEW transforms.view_10968_probe AS ROLLBACK /* QNO 245 CON_ID 17 */ /* QNO 246 CON_ID 17 */ 16 Query /* GenTest::Transform::DisableOptimizations */ /* TRANSFORM_CLEANUP */ SET SESSION optimizer_switch=@switch_saved /* QNO 287 CON_ID 16 */ 19 Query /* GenTest::Transform::EnableOptimizations */ SET @switch_saved = @@optimizer_switch /* QNO 149 CON_ID 19 */ 17 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES ( 3, 3, 3, REPEAT(CAST(3 - 1 AS CHAR(1)),@fill_amount)) /* QNO 247 CON_ID 17 */ 19 Query SET SESSION optimizer_switch = REPLACE( @@optimizer_switch, '=off', '=on' ) /* QNO 150 CON_ID 19 */ 16 Query /* GenTest::Transform::EnableOptimizations */ SET @switch_saved = @@optimizer_switch /* QNO 288 CON_ID 16 */ 21 Query COMMIT /* QNO 168 CON_ID 21 */ 21 Query CREATE OR REPLACE VIEW transforms.view_4616_probe AS COMMIT /* QNO 168 CON_ID 21 */ /* QNO 169 CON_ID 21 */ 19 Query SHOW WARNINGS 19 Query UPDATE t1 SET col3 = 2 LIMIT 2 /* QNO 143 CON_ID 19 */ /* TRANSFORM_OUTCOME_UNORDERED_MATCH */ /* QNO 151 CON_ID 19 */ 16 Query SET SESSION optimizer_switch = REPLACE( @@optimizer_switch, '=off', '=on' ) /* QNO 289 CON_ID 16 */ 16 Query SHOW WARNINGS 19 Query /* GenTest::Transform::EnableOptimizations */ /* TRANSFORM_CLEANUP */ SET SESSION optimizer_switch=@switch_saved /* QNO 152 CON_ID 19 */ 16 Query DELETE FROM t1 WHERE MATCH(col4) AGAINST (TRIM(' 3 ') IN BOOLEAN MODE) OR col3 IS NULL /* QNO 282 CON_ID 16 */ /* TRANSFORM_OUTCOME_UNORDERED_MATCH */ /* QNO 290 CON_ID 16 */ 16 Query /* GenTest::Transform::EnableOptimizations */ /* TRANSFORM_CLEANUP */ SET SESSION optimizer_switch=@switch_saved /* QNO 291 CON_ID 16 */ 16 Query CREATE OR REPLACE VIEW transforms.view_12936_probe AS DELETE FROM t1 WHERE MATCH(col4) AGAINST (TRIM(' 3 ') IN BOOLEAN MODE) OR col3 IS NULL /* QNO 282 CON_ID 16 */ /* QNO 292 CON_ID 16 */ 19 Query CREATE OR REPLACE VIEW transforms.view_8236_probe AS UPDATE t1 SET col3 = 2 LIMIT 2 /* QNO 143 CON_ID 19 */ /* QNO 153 CON_ID 19 */ 16 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES /* NULL */ (NULL,NULL,NULL,REPEAT(CAST(NULL AS CHAR(1)),@fill_amount)), (NULL,NULL,NULL,REPEAT(CAST(NULL AS CHAR(1)),@fill_amount)) /* QNO 293 CON_ID 16 */ 21 Query ALTER TABLE t1 ADD PRIMARY KEY ( col1 ) /* QNO 170 CON_ID 21 */ 16 Query ROLLBACK /* QNO 294 CON_ID 16 */ 19 Query ROLLBACK /* QNO 154 CON_ID 19 */ 19 Query CREATE OR REPLACE VIEW transforms.view_8236_probe AS ROLLBACK /* QNO 154 CON_ID 19 */ /* QNO 155 CON_ID 19 */ 16 Query CREATE OR REPLACE VIEW transforms.view_12936_probe AS ROLLBACK /* QNO 294 CON_ID 16 */ /* QNO 295 CON_ID 16 */ 16 Query ALTER TABLE t1 DROP PRIMARY KEY /* QNO 296 CON_ID 16 */ 19 Query ALTER TABLE t1 DROP KEY uidx, DROP KEY ftidx /* QNO 156 CON_ID 19 */ 17 Query ROLLBACK /* QNO 248 CON_ID 17 */ 17 Query CREATE OR REPLACE VIEW transforms.view_10968_probe AS ROLLBACK /* QNO 248 CON_ID 17 */ /* QNO 249 CON_ID 17 */ 17 Query ALTER TABLE t1 ADD UNIQUE KEY uidx ( col4(10), col2 ) /* QNO 250 CON_ID 17 */ 18 Query CREATE OR REPLACE VIEW transforms.view_3564_probe AS ALTER TABLE t1 ADD KEY idx ( col3 ) /* QNO 232 CON_ID 18 */ /* QNO 233 CON_ID 18 */ 21 Query ALTER TABLE t1 DROP KEY ftidx, ADD KEY idx ( col4(10) ) /* QNO 171 CON_ID 21 */ 18 Query ALTER TABLE t1 DROP KEY uidx, ADD KEY idx ( col3 ) /* QNO 234 CON_ID 18 */ 171012 18:12:42 16 Query CREATE OR REPLACE VIEW transforms.view_12936_probe AS ALTER TABLE t1 DROP PRIMARY KEY /* QNO 296 CON_ID 16 */ /* QNO 297 CON_ID 16 */ 19 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES ( NULL, NULL - 1, NULL, REPEAT(CAST(NULL AS CHAR(1)),@fill_amount)) /* QNO 157 CON_ID 19 */ 18 Query DELETE FROM t1 WHERE MATCH(col4) AGAINST (TRIM(' 2 ') IN BOOLEAN MODE) OR col3 IS NULL /* QNO 235 CON_ID 18 */ 19 Query ROLLBACK /* QNO 158 CON_ID 19 */ 19 Query CREATE OR REPLACE VIEW transforms.view_8236_probe AS ROLLBACK /* QNO 158 CON_ID 19 */ /* QNO 159 CON_ID 19 */ 18 Query /* GenTest::Transform::DisableOptimizations */ SET @switch_saved = @@optimizer_switch /* QNO 236 CON_ID 18 */ 18 Query SET SESSION optimizer_switch = REPLACE( @@optimizer_switch, '=on', '=off' ) /* QNO 237 CON_ID 18 */ 18 Query SET SESSION optimizer_switch = 'in_to_exists=on' /* QNO 238 CON_ID 18 */ 19 Query ALTER TABLE t1 ADD FULLTEXT KEY ftidx ( col4 ) /* QNO 160 CON_ID 19 */ 17 Query ALTER TABLE t1 ADD PRIMARY KEY ( col1 ) /* QNO 251 CON_ID 17 */ 16 Query DELETE FROM t1 WHERE col3 = 2 OR col3 IS NULL /* QNO 298 CON_ID 16 */ 18 Query DELETE FROM t1 WHERE MATCH(col4) AGAINST (TRIM(' 2 ') IN BOOLEAN MODE) OR col3 IS NULL /* QNO 235 CON_ID 18 */ /* TRANSFORM_OUTCOME_UNORDERED_MATCH */ /* QNO 239 CON_ID 18 */ 17 Query DELETE FROM t1 WHERE col2 = 3 OR col2 IS NULL /* QNO 252 CON_ID 17 */ 16 Query /* GenTest::Transform::DisableOptimizations */ SET @switch_saved = @@optimizer_switch /* QNO 299 CON_ID 16 */ 18 Query /* GenTest::Transform::DisableOptimizations */ /* TRANSFORM_CLEANUP */ SET SESSION optimizer_switch=@switch_saved /* QNO 240 CON_ID 18 */ 17 Query COMMIT /* QNO 253 CON_ID 17 */ 21 Query ALTER TABLE t1 DROP KEY ftidx /* QNO 172 CON_ID 21 */ 19 Query DELETE FROM t1 WHERE col1 = 4 OR col1 IS NULL /* QNO 161 CON_ID 19 */ 17 Query CREATE OR REPLACE VIEW transforms.view_10968_probe AS COMMIT /* QNO 253 CON_ID 17 */ /* QNO 254 CON_ID 17 */ 18 Query /* GenTest::Transform::EnableOptimizations */ SET @switch_saved = @@optimizer_switch /* QNO 241 CON_ID 18 */ 16 Query SET SESSION optimizer_switch = REPLACE( @@optimizer_switch, '=on', '=off' ) /* QNO 300 CON_ID 16 */ 18 Query SET SESSION optimizer_switch = REPLACE( @@optimizer_switch, '=off', '=on' ) /* QNO 242 CON_ID 18 */ 17 Query ALTER TABLE t1 DROP KEY uidx /* QNO 255 CON_ID 17 */ 16 Query SET SESSION optimizer_switch = 'in_to_exists=on' /* QNO 301 CON_ID 16 */ 18 Query SHOW WARNINGS 18 Query DELETE FROM t1 WHERE MATCH(col4) AGAINST (TRIM(' 2 ') IN BOOLEAN MODE) OR col3 IS NULL /* QNO 235 CON_ID 18 */ /* TRANSFORM_OUTCOME_UNORDERED_MATCH */ /* QNO 243 CON_ID 18 */ 16 Query DELETE FROM t1 WHERE col3 = 2 OR col3 IS NULL /* QNO 298 CON_ID 16 */ /* TRANSFORM_OUTCOME_UNORDERED_MATCH */ /* QNO 302 CON_ID 16 */ 16 Query /* GenTest::Transform::DisableOptimizations */ /* TRANSFORM_CLEANUP */ SET SESSION optimizer_switch=@switch_saved /* QNO 303 CON_ID 16 */ 16 Query /* GenTest::Transform::EnableOptimizations */ SET @switch_saved = @@optimizer_switch /* QNO 304 CON_ID 16 */ 16 Query SET SESSION optimizer_switch = REPLACE( @@optimizer_switch, '=off', '=on' ) /* QNO 305 CON_ID 16 */ 18 Query /* GenTest::Transform::EnableOptimizations */ /* TRANSFORM_CLEANUP */ SET SESSION optimizer_switch=@switch_saved /* QNO 244 CON_ID 18 */ 18 Query CREATE OR REPLACE VIEW transforms.view_3564_probe AS DELETE FROM t1 WHERE MATCH(col4) AGAINST (TRIM(' 2 ') IN BOOLEAN MODE) OR col3 IS NULL /* QNO 235 CON_ID 18 */ /* QNO 245 CON_ID 18 */ 16 Query SHOW WARNINGS 16 Query DELETE FROM t1 WHERE col3 = 2 OR col3 IS NULL /* QNO 298 CON_ID 16 */ /* TRANSFORM_OUTCOME_UNORDERED_MATCH */ /* QNO 306 CON_ID 16 */ 18 Query COMMIT /* QNO 246 CON_ID 18 */ 16 Query /* GenTest::Transform::EnableOptimizations */ /* TRANSFORM_CLEANUP */ SET SESSION optimizer_switch=@switch_saved /* QNO 307 CON_ID 16 */ 18 Query CREATE OR REPLACE VIEW transforms.view_3564_probe AS COMMIT /* QNO 246 CON_ID 18 */ /* QNO 247 CON_ID 18 */ 16 Query CREATE OR REPLACE VIEW transforms.view_12936_probe AS DELETE FROM t1 WHERE col3 = 2 OR col3 IS NULL /* QNO 298 CON_ID 16 */ /* QNO 308 CON_ID 16 */ 16 Query COMMIT /* QNO 309 CON_ID 16 */ 18 Query ALTER TABLE t1 DROP KEY uidx /* QNO 248 CON_ID 18 */ 16 Query CREATE OR REPLACE VIEW transforms.view_12936_probe AS COMMIT /* QNO 309 CON_ID 16 */ /* QNO 310 CON_ID 16 */ 19 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES /* NULL */ (NULL,NULL,NULL,REPEAT(CAST(NULL AS CHAR(1)),@fill_amount)), (NULL,NULL,NULL,REPEAT(CAST(NULL AS CHAR(1)),@fill_amount)) /* QNO 162 CON_ID 19 */ 16 Query ALTER TABLE t1 ADD FULLTEXT KEY ftidx ( col4 ) /* QNO 311 CON_ID 16 */ 19 Query COMMIT /* QNO 163 CON_ID 19 */ 19 Query CREATE OR REPLACE VIEW transforms.view_8236_probe AS COMMIT /* QNO 163 CON_ID 19 */ /* QNO 164 CON_ID 19 */ 19 Query UPDATE t1 SET col2 = NULL LIMIT 2 /* QNO 165 CON_ID 19 */ 21 Query CREATE OR REPLACE VIEW transforms.view_4616_probe AS ALTER TABLE t1 DROP KEY ftidx /* QNO 172 CON_ID 21 */ /* QNO 173 CON_ID 21 */ 18 Query UPDATE t1 SET col3 = 2 LIMIT 2 /* QNO 249 CON_ID 18 */ 19 Query ROLLBACK /* QNO 166 CON_ID 19 */ 17 Query UPDATE t1 SET col1 = 2 LIMIT 2 /* QNO 256 CON_ID 17 */ 21 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES ( 2, 2 - 1, 2, REPEAT(CAST(2 AS CHAR(1)),@fill_amount)) /* QNO 174 CON_ID 21 */ 19 Query CREATE OR REPLACE VIEW transforms.view_8236_probe AS ROLLBACK /* QNO 166 CON_ID 19 */ /* QNO 167 CON_ID 19 */ 17 Query COMMIT /* QNO 257 CON_ID 17 */ 19 Query ALTER TABLE t1 DROP PRIMARY KEY /* QNO 168 CON_ID 19 */ 18 Query /* GenTest::Transform::DisableOptimizations */ SET @switch_saved = @@optimizer_switch /* QNO 250 CON_ID 18 */ 17 Query CREATE OR REPLACE VIEW transforms.view_10968_probe AS COMMIT /* QNO 257 CON_ID 17 */ /* QNO 258 CON_ID 17 */ 18 Query SET SESSION optimizer_switch = REPLACE( @@optimizer_switch, '=on', '=off' ) /* QNO 251 CON_ID 18 */ 21 Query ROLLBACK /* QNO 175 CON_ID 21 */ 18 Query SET SESSION optimizer_switch = 'in_to_exists=on' /* QNO 252 CON_ID 18 */ 18 Query UPDATE t1 SET col3 = 2 LIMIT 2 /* QNO 249 CON_ID 18 */ /* TRANSFORM_OUTCOME_UNORDERED_MATCH */ /* QNO 253 CON_ID 18 */ 17 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES ( 1, 1 - 1, 1, REPEAT(CAST(1 AS CHAR(1)),@fill_amount)) /* QNO 259 CON_ID 17 */ 18 Query /* GenTest::Transform::DisableOptimizations */ /* TRANSFORM_CLEANUP */ SET SESSION optimizer_switch=@switch_saved /* QNO 254 CON_ID 18 */ 18 Query /* GenTest::Transform::EnableOptimizations */ SET @switch_saved = @@optimizer_switch /* QNO 255 CON_ID 18 */ 21 Query CREATE OR REPLACE VIEW transforms.view_4616_probe AS ROLLBACK /* QNO 175 CON_ID 21 */ /* QNO 176 CON_ID 21 */ 18 Query SET SESSION optimizer_switch = REPLACE( @@optimizer_switch, '=off', '=on' ) /* QNO 256 CON_ID 18 */ 18 Query SHOW WARNINGS 21 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES ( NULL, NULL, NULL, REPEAT(CAST(NULL AS CHAR(1)),@fill_amount)) /* QNO 177 CON_ID 21 */ 18 Query UPDATE t1 SET col3 = 2 LIMIT 2 /* QNO 249 CON_ID 18 */ /* TRANSFORM_OUTCOME_UNORDERED_MATCH */ /* QNO 257 CON_ID 18 */ 18 Query /* GenTest::Transform::EnableOptimizations */ /* TRANSFORM_CLEANUP */ SET SESSION optimizer_switch=@switch_saved /* QNO 258 CON_ID 18 */ 18 Query CREATE OR REPLACE VIEW transforms.view_3564_probe AS UPDATE t1 SET col3 = 2 LIMIT 2 /* QNO 249 CON_ID 18 */ /* QNO 259 CON_ID 18 */ 18 Query ROLLBACK /* QNO 260 CON_ID 18 */ 18 Query CREATE OR REPLACE VIEW transforms.view_3564_probe AS ROLLBACK /* QNO 260 CON_ID 18 */ /* QNO 261 CON_ID 18 */ 18 Query ALTER TABLE t1 ADD PRIMARY KEY ( col4(10) ) /* QNO 262 CON_ID 18 */ 171012 18:12:43 16 Query CREATE OR REPLACE VIEW transforms.view_12936_probe AS ALTER TABLE t1 ADD FULLTEXT KEY ftidx ( col4 ) /* QNO 311 CON_ID 16 */ /* QNO 312 CON_ID 16 */ 21 Query COMMIT /* QNO 178 CON_ID 21 */ 16 Query UPDATE t1 SET col1 = 3 LIMIT 2 /* QNO 313 CON_ID 16 */ 21 Query CREATE OR REPLACE VIEW transforms.view_4616_probe AS COMMIT /* QNO 178 CON_ID 21 */ /* QNO 179 CON_ID 21 */ 16 Query ROLLBACK /* QNO 314 CON_ID 16 */ 21 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES ( 4, 4, 4, REPEAT(CAST(4 AS CHAR(1)),@fill_amount)) /* QNO 180 CON_ID 21 */ 16 Query CREATE OR REPLACE VIEW transforms.view_12936_probe AS ROLLBACK /* QNO 314 CON_ID 16 */ /* QNO 315 CON_ID 16 */ 16 Query ALTER TABLE `table0_int` DROP KEY rkr_index_11 /* QNO 316 CON_ID 16 */ 16 Query CHECK TABLE t1 /* QNO 317 CON_ID 16 */ 21 Query COMMIT /* QNO 181 CON_ID 21 */ 21 Query CREATE OR REPLACE VIEW transforms.view_4616_probe AS COMMIT /* QNO 181 CON_ID 21 */ /* QNO 182 CON_ID 21 */ 21 Query ALTER TABLE t1 ADD UNIQUE KEY uidx ( col4(10) ) /* QNO 183 CON_ID 21 */ 17 Query ROLLBACK /* QNO 260 CON_ID 17 */ 19 Query DELETE FROM t1 WHERE col2 = 1 OR col2 IS NULL /* QNO 169 CON_ID 19 */ 19 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES /* 1 */ (1,1,1,REPEAT(CAST(1 AS CHAR(1)),@fill_amount)), (1,1,1,REPEAT(CAST(1 AS CHAR(1)),@fill_amount)) /* QNO 170 CON_ID 19 */ 17 Query CREATE OR REPLACE VIEW transforms.view_10968_probe AS ROLLBACK /* QNO 260 CON_ID 17 */ /* QNO 261 CON_ID 17 */ 17 Query ALTER TABLE t1 DROP KEY idx /* QNO 262 CON_ID 17 */ 19 Query ROLLBACK /* QNO 171 CON_ID 19 */ 19 Query CREATE OR REPLACE VIEW transforms.view_8236_probe AS ROLLBACK /* QNO 171 CON_ID 19 */ /* QNO 172 CON_ID 19 */ 19 Query ALTER TABLE t1 DROP KEY ftidx /* QNO 173 CON_ID 19 */ 16 Query CREATE OR REPLACE VIEW transforms.view_12936_probe AS CHECK TABLE t1 /* QNO 317 CON_ID 16 */ /* QNO 318 CON_ID 16 */ 16 Query ALTER TABLE t1 ADD FULLTEXT KEY ftidx ( col4 ), ADD KEY idx ( col4(10) ) /* QNO 319 CON_ID 16 */ 18 Query CREATE OR REPLACE VIEW transforms.view_3564_probe AS ALTER TABLE t1 ADD PRIMARY KEY ( col4(10) ) /* QNO 262 CON_ID 18 */ /* QNO 263 CON_ID 18 */ 18 Query ALTER TABLE t1 DROP KEY idx /* QNO 264 CON_ID 18 */ 171012 18:12:44 21 Query CREATE OR REPLACE VIEW transforms.view_4616_probe AS ALTER TABLE t1 ADD UNIQUE KEY uidx ( col4(10) ) /* QNO 183 CON_ID 21 */ /* QNO 184 CON_ID 21 */ 21 Query ALTER TABLE t1 ADD UNIQUE KEY uidx ( col4(10) ) /* QNO 185 CON_ID 21 */ 17 Query CREATE OR REPLACE VIEW transforms.view_10968_probe AS ALTER TABLE t1 DROP KEY idx /* QNO 262 CON_ID 17 */ /* QNO 263 CON_ID 17 */ 17 Query ALTER TABLE t1 DROP KEY ftidx /* QNO 264 CON_ID 17 */ 19 Query CREATE OR REPLACE VIEW transforms.view_8236_probe AS ALTER TABLE t1 DROP KEY ftidx /* QNO 173 CON_ID 19 */ /* QNO 174 CON_ID 19 */ 19 Query DELETE FROM t1 WHERE MATCH(col4) AGAINST (TRIM(' 3 ') IN BOOLEAN MODE) OR col3 IS NULL /* QNO 175 CON_ID 19 */ 16 Query CREATE OR REPLACE VIEW transforms.view_12936_probe AS ALTER TABLE t1 ADD FULLTEXT KEY ftidx ( col4 ), ADD KEY idx ( col4(10) ) /* QNO 319 CON_ID 16 */ /* QNO 320 CON_ID 16 */ 19 Query /* GenTest::Transform::DisableOptimizations */ SET @switch_saved = @@optimizer_switch /* QNO 176 CON_ID 19 */ 19 Query SET SESSION optimizer_switch = REPLACE( @@optimizer_switch, '=on', '=off' ) /* QNO 177 CON_ID 19 */ 19 Query SET SESSION optimizer_switch = 'in_to_exists=on' /* QNO 178 CON_ID 19 */ 19 Query DELETE FROM t1 WHERE MATCH(col4) AGAINST (TRIM(' 3 ') IN BOOLEAN MODE) OR col3 IS NULL /* QNO 175 CON_ID 19 */ /* TRANSFORM_OUTCOME_UNORDERED_MATCH */ /* QNO 179 CON_ID 19 */ 19 Query /* GenTest::Transform::DisableOptimizations */ /* TRANSFORM_CLEANUP */ SET SESSION optimizer_switch=@switch_saved /* QNO 180 CON_ID 19 */ 19 Query /* GenTest::Transform::EnableOptimizations */ SET @switch_saved = @@optimizer_switch /* QNO 181 CON_ID 19 */ 19 Query SET SESSION optimizer_switch = REPLACE( @@optimizer_switch, '=off', '=on' ) /* QNO 182 CON_ID 19 */ 19 Query SHOW WARNINGS 19 Query DELETE FROM t1 WHERE MATCH(col4) AGAINST (TRIM(' 3 ') IN BOOLEAN MODE) OR col3 IS NULL /* QNO 175 CON_ID 19 */ /* TRANSFORM_OUTCOME_UNORDERED_MATCH */ /* QNO 183 CON_ID 19 */ 19 Query /* GenTest::Transform::EnableOptimizations */ /* TRANSFORM_CLEANUP */ SET SESSION optimizer_switch=@switch_saved /* QNO 184 CON_ID 19 */ 19 Query CREATE OR REPLACE VIEW transforms.view_8236_probe AS DELETE FROM t1 WHERE MATCH(col4) AGAINST (TRIM(' 3 ') IN BOOLEAN MODE) OR col3 IS NULL /* QNO 175 CON_ID 19 */ /* QNO 185 CON_ID 19 */ 19 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES /* 3 */ (3,3,3,REPEAT(CAST(3 AS CHAR(1)),@fill_amount)), (3,3,3,REPEAT(CAST(3 AS CHAR(1)),@fill_amount)) /* QNO 186 CON_ID 19 */ 19 Query COMMIT /* QNO 187 CON_ID 19 */ 19 Query CREATE OR REPLACE VIEW transforms.view_8236_probe AS COMMIT /* QNO 187 CON_ID 19 */ /* QNO 188 CON_ID 19 */ 19 Query DELETE FROM t1 WHERE col2 = 1 OR col2 IS NULL /* QNO 189 CON_ID 19 */ 16 Query ALTER TABLE t1 ADD PRIMARY KEY ( col2 ), ADD PRIMARY KEY ( col1 ) /* QNO 321 CON_ID 16 */ 19 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES /* 3 */ (3,3,3,REPEAT(CAST(3 AS CHAR(1)),@fill_amount)), (3,3,3,REPEAT(CAST(3 AS CHAR(1)),@fill_amount)) /* QNO 190 CON_ID 19 */ 19 Query COMMIT /* QNO 191 CON_ID 19 */ 19 Query CREATE OR REPLACE VIEW transforms.view_8236_probe AS COMMIT /* QNO 191 CON_ID 19 */ /* QNO 192 CON_ID 19 */ 19 Query DELETE FROM t1 WHERE MATCH(col4) AGAINST (TRIM(' 4 ') IN BOOLEAN MODE) OR col3 IS NULL /* QNO 193 CON_ID 19 */ 18 Query CREATE OR REPLACE VIEW transforms.view_3564_probe AS ALTER TABLE t1 DROP KEY idx /* QNO 264 CON_ID 18 */ /* QNO 265 CON_ID 18 */ 21 Query ALTER TABLE t1 DROP KEY idx, ADD KEY idx ( col1 ) /* QNO 186 CON_ID 21 */ 19 Query /* GenTest::Transform::DisableOptimizations */ SET @switch_saved = @@optimizer_switch /* QNO 194 CON_ID 19 */ 19 Query SET SESSION optimizer_switch = REPLACE( @@optimizer_switch, '=on', '=off' ) /* QNO 195 CON_ID 19 */ 19 Query SET SESSION optimizer_switch = 'in_to_exists=on' /* QNO 196 CON_ID 19 */ 19 Query DELETE FROM t1 WHERE MATCH(col4) AGAINST (TRIM(' 4 ') IN BOOLEAN MODE) OR col3 IS NULL /* QNO 193 CON_ID 19 */ /* TRANSFORM_OUTCOME_UNORDERED_MATCH */ /* QNO 197 CON_ID 19 */ 19 Query /* GenTest::Transform::DisableOptimizations */ /* TRANSFORM_CLEANUP */ SET SESSION optimizer_switch=@switch_saved /* QNO 198 CON_ID 19 */ 19 Query /* GenTest::Transform::EnableOptimizations */ SET @switch_saved = @@optimizer_switch /* QNO 199 CON_ID 19 */ 19 Query SET SESSION optimizer_switch = REPLACE( @@optimizer_switch, '=off', '=on' ) /* QNO 200 CON_ID 19 */ 19 Query SHOW WARNINGS 19 Query DELETE FROM t1 WHERE MATCH(col4) AGAINST (TRIM(' 4 ') IN BOOLEAN MODE) OR col3 IS NULL /* QNO 193 CON_ID 19 */ /* TRANSFORM_OUTCOME_UNORDERED_MATCH */ /* QNO 201 CON_ID 19 */ 19 Query /* GenTest::Transform::EnableOptimizations */ /* TRANSFORM_CLEANUP */ SET SESSION optimizer_switch=@switch_saved /* QNO 202 CON_ID 19 */ 19 Query CREATE OR REPLACE VIEW transforms.view_8236_probe AS DELETE FROM t1 WHERE MATCH(col4) AGAINST (TRIM(' 4 ') IN BOOLEAN MODE) OR col3 IS NULL /* QNO 193 CON_ID 19 */ /* QNO 203 CON_ID 19 */ 18 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES ( 1, 1, 1, REPEAT(CAST(1 - 1 AS CHAR(1)),@fill_amount)) /* QNO 266 CON_ID 18 */ 19 Query COMMIT /* QNO 204 CON_ID 19 */ 19 Query CREATE OR REPLACE VIEW transforms.view_8236_probe AS COMMIT /* QNO 204 CON_ID 19 */ /* QNO 205 CON_ID 19 */ 18 Query COMMIT /* QNO 267 CON_ID 18 */ 18 Query CREATE OR REPLACE VIEW transforms.view_3564_probe AS COMMIT /* QNO 267 CON_ID 18 */ /* QNO 268 CON_ID 18 */ 19 Query ALTER TABLE t1 ADD PRIMARY KEY ( col1 ) /* QNO 206 CON_ID 19 */ 18 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES ( 2, 2, 2 - 1, REPEAT(CAST(2 AS CHAR(1)),@fill_amount)) /* QNO 269 CON_ID 18 */ 18 Query ROLLBACK /* QNO 270 CON_ID 18 */ 21 Query ALTER TABLE t1 ADD KEY idx ( col4(10) ) /* QNO 187 CON_ID 21 */ 18 Query CREATE OR REPLACE VIEW transforms.view_3564_probe AS ROLLBACK /* QNO 270 CON_ID 18 */ /* QNO 271 CON_ID 18 */ 16 Query ALTER TABLE t1 ADD FULLTEXT KEY ftidx ( col4 ) /* QNO 322 CON_ID 16 */ 17 Query CREATE OR REPLACE VIEW transforms.view_10968_probe AS ALTER TABLE t1 DROP KEY ftidx /* QNO 264 CON_ID 17 */ /* QNO 265 CON_ID 17 */ 19 Query UPDATE t1 SET col2 = NULL LIMIT 2 /* QNO 207 CON_ID 19 */ 17 Query UPDATE t1 SET col1 = NULL LIMIT 2 /* QNO 266 CON_ID 17 */ 18 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES ( 2, 2 - 1, 2, REPEAT(CAST(2 AS CHAR(1)),@fill_amount)) /* QNO 272 CON_ID 18 */ 171012 18:12:45 17 Query ROLLBACK /* QNO 267 CON_ID 17 */ 17 Query CREATE OR REPLACE VIEW transforms.view_10968_probe AS ROLLBACK /* QNO 267 CON_ID 17 */ /* QNO 268 CON_ID 17 */ 18 Query COMMIT /* QNO 273 CON_ID 18 */ 18 Query CREATE OR REPLACE VIEW transforms.view_3564_probe AS COMMIT /* QNO 273 CON_ID 18 */ /* QNO 274 CON_ID 18 */ 19 Query ROLLBACK /* QNO 208 CON_ID 19 */ 17 Query ALTER TABLE t1 ADD FULLTEXT KEY ftidx ( col4 ) /* QNO 269 CON_ID 17 */ 19 Query CREATE OR REPLACE VIEW transforms.view_8236_probe AS ROLLBACK /* QNO 208 CON_ID 19 */ /* QNO 209 CON_ID 19 */ 18 Query DELETE FROM t1 WHERE col1 = 2 OR col1 IS NULL /* QNO 275 CON_ID 18 */ 19 Query ALTER TABLE t1 ADD UNIQUE KEY uidx ( col1 ), ADD FULLTEXT KEY ftidx ( col4 ) /* QNO 210 CON_ID 19 */ 21 Query CREATE OR REPLACE VIEW transforms.view_4616_probe AS ALTER TABLE t1 ADD KEY idx ( col4(10) ) /* QNO 187 CON_ID 21 */ /* QNO 188 CON_ID 21 */ 18 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES /* 1 */ (1,1,1,REPEAT(CAST(1 AS CHAR(1)),@fill_amount)), (1,1,1,REPEAT(CAST(1 AS CHAR(1)),@fill_amount)) /* QNO 276 CON_ID 18 */ 21 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES ( NULL, NULL, NULL - 1, REPEAT(CAST(NULL AS CHAR(1)),@fill_amount)) /* QNO 189 CON_ID 21 */ 18 Query ROLLBACK /* QNO 277 CON_ID 18 */ 18 Query CREATE OR REPLACE VIEW transforms.view_3564_probe AS ROLLBACK /* QNO 277 CON_ID 18 */ /* QNO 278 CON_ID 18 */ 18 Query DELETE FROM t1 WHERE MATCH(col4) AGAINST (TRIM(' NULL ') IN BOOLEAN MODE) OR col3 IS NULL /* QNO 279 CON_ID 18 */ 25 Connect root@127.0.0.1 as anonymous on test 25 Query SHOW FULL PROCESSLIST 25 Quit 171012 18:12:46 16 Query CREATE OR REPLACE VIEW transforms.view_12936_probe AS ALTER TABLE t1 ADD FULLTEXT KEY ftidx ( col4 ) /* QNO 322 CON_ID 16 */ /* QNO 323 CON_ID 16 */ 21 Query COMMIT /* QNO 190 CON_ID 21 */ 18 Query /* GenTest::Transform::DisableOptimizations */ SET @switch_saved = @@optimizer_switch /* QNO 280 CON_ID 18 */ 18 Query SET SESSION optimizer_switch = REPLACE( @@optimizer_switch, '=on', '=off' ) /* QNO 281 CON_ID 18 */ 17 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES ( 3, 3, 3, REPEAT(CAST(3 AS CHAR(1)),@fill_amount)) /* QNO 270 CON_ID 17 */ 16 Query ALTER TABLE t1 DROP KEY uidx /* QNO 324 CON_ID 16 */ 19 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES ( 4, 4, 4 - 1, REPEAT(CAST(4 AS CHAR(1)),@fill_amount)) /* QNO 211 CON_ID 19 */ 18 Query SET SESSION optimizer_switch = 'in_to_exists=on' /* QNO 282 CON_ID 18 */ 21 Query CREATE OR REPLACE VIEW transforms.view_4616_probe AS COMMIT /* QNO 190 CON_ID 21 */ /* QNO 191 CON_ID 21 */ 17 Query COMMIT /* QNO 271 CON_ID 17 */ 18 Query DELETE FROM t1 WHERE MATCH(col4) AGAINST (TRIM(' NULL ') IN BOOLEAN MODE) OR col3 IS NULL /* QNO 279 CON_ID 18 */ /* TRANSFORM_OUTCOME_UNORDERED_MATCH */ /* QNO 283 CON_ID 18 */ 18 Query /* GenTest::Transform::DisableOptimizations */ /* TRANSFORM_CLEANUP */ SET SESSION optimizer_switch=@switch_saved /* QNO 284 CON_ID 18 */ 17 Query CREATE OR REPLACE VIEW transforms.view_10968_probe AS COMMIT /* QNO 271 CON_ID 17 */ /* QNO 272 CON_ID 17 */ 21 Query ALTER TABLE t1 ADD COLUMN extra INT /* QNO 192 CON_ID 21 */ 18 Query /* GenTest::Transform::EnableOptimizations */ SET @switch_saved = @@optimizer_switch /* QNO 285 CON_ID 18 */ 17 Query ALTER TABLE t1 ADD KEY idx ( col4(10) ) /* QNO 273 CON_ID 17 */ 18 Query SET SESSION optimizer_switch = REPLACE( @@optimizer_switch, '=off', '=on' ) /* QNO 286 CON_ID 18 */ 18 Query SHOW WARNINGS 18 Query DELETE FROM t1 WHERE MATCH(col4) AGAINST (TRIM(' NULL ') IN BOOLEAN MODE) OR col3 IS NULL /* QNO 279 CON_ID 18 */ /* TRANSFORM_OUTCOME_UNORDERED_MATCH */ /* QNO 287 CON_ID 18 */ 18 Query /* GenTest::Transform::EnableOptimizations */ /* TRANSFORM_CLEANUP */ SET SESSION optimizer_switch=@switch_saved /* QNO 288 CON_ID 18 */ 18 Query CREATE OR REPLACE VIEW transforms.view_3564_probe AS DELETE FROM t1 WHERE MATCH(col4) AGAINST (TRIM(' NULL ') IN BOOLEAN MODE) OR col3 IS NULL /* QNO 279 CON_ID 18 */ /* QNO 289 CON_ID 18 */ 18 Query COMMIT /* QNO 290 CON_ID 18 */ 18 Query CREATE OR REPLACE VIEW transforms.view_3564_probe AS COMMIT /* QNO 290 CON_ID 18 */ /* QNO 291 CON_ID 18 */ 18 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES ( NULL, NULL, NULL, REPEAT(CAST(NULL - 1 AS CHAR(1)),@fill_amount)) /* QNO 292 CON_ID 18 */ 19 Query COMMIT /* QNO 212 CON_ID 19 */ 19 Query CREATE OR REPLACE VIEW transforms.view_8236_probe AS COMMIT /* QNO 212 CON_ID 19 */ /* QNO 213 CON_ID 19 */ 19 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES ( 3, 3 - 1, 3, REPEAT(CAST(3 AS CHAR(1)),@fill_amount)) /* QNO 214 CON_ID 19 */ 26 Connect root@127.0.0.1 as anonymous on test 26 Query SHOW FULL PROCESSLIST 26 Quit 19 Query COMMIT /* QNO 215 CON_ID 19 */ 19 Query CREATE OR REPLACE VIEW transforms.view_8236_probe AS COMMIT /* QNO 215 CON_ID 19 */ /* QNO 216 CON_ID 19 */ 18 Query ROLLBACK /* QNO 293 CON_ID 18 */ 19 Query ALTER TABLE t1 DROP KEY idx, ADD PRIMARY KEY ( col3 ) /* QNO 217 CON_ID 19 */ 16 Query CREATE OR REPLACE VIEW transforms.view_12936_probe AS ALTER TABLE t1 DROP KEY uidx /* QNO 324 CON_ID 16 */ /* QNO 325 CON_ID 16 */ 18 Query CREATE OR REPLACE VIEW transforms.view_3564_probe AS ROLLBACK /* QNO 293 CON_ID 18 */ /* QNO 294 CON_ID 18 */ 18 Query ALTER TABLE t1 DROP PRIMARY KEY /* QNO 295 CON_ID 18 */ 16 Query CHECK TABLE t1 /* QNO 326 CON_ID 16 */ 16 Query CREATE OR REPLACE VIEW transforms.view_12936_probe AS CHECK TABLE t1 /* QNO 326 CON_ID 16 */ /* QNO 327 CON_ID 16 */ 16 Query ALTER TABLE t1 ADD FULLTEXT KEY ftidx ( col4 ) /* QNO 328 CON_ID 16 */ 171012 18:12:47 21 Query CREATE OR REPLACE VIEW transforms.view_4616_probe AS ALTER TABLE t1 ADD COLUMN extra INT /* QNO 192 CON_ID 21 */ /* QNO 193 CON_ID 21 */ 21 Query UPDATE t1 SET extra = col3 /* QNO 194 CON_ID 21 */ 19 Query ALTER TABLE t1 DROP PRIMARY KEY /* QNO 218 CON_ID 19 */ 21 Query /* GenTest::Transform::DisableOptimizations */ SET @switch_saved = @@optimizer_switch /* QNO 195 CON_ID 21 */ 21 Query SET SESSION optimizer_switch = REPLACE( @@optimizer_switch, '=on', '=off' ) /* QNO 196 CON_ID 21 */ 17 Query ALTER TABLE t1 ADD COLUMN extra INT /* QNO 274 CON_ID 17 */ 21 Query SET SESSION optimizer_switch = 'in_to_exists=on' /* QNO 197 CON_ID 21 */ 21 Query UPDATE t1 SET extra = col3 /* QNO 194 CON_ID 21 */ /* TRANSFORM_OUTCOME_UNORDERED_MATCH */ /* QNO 198 CON_ID 21 */ 21 Query /* GenTest::Transform::DisableOptimizations */ /* TRANSFORM_CLEANUP */ SET SESSION optimizer_switch=@switch_saved /* QNO 199 CON_ID 21 */ 21 Query /* GenTest::Transform::EnableOptimizations */ SET @switch_saved = @@optimizer_switch /* QNO 200 CON_ID 21 */ 21 Query SET SESSION optimizer_switch = REPLACE( @@optimizer_switch, '=off', '=on' ) /* QNO 201 CON_ID 21 */ 21 Query SHOW WARNINGS 21 Query UPDATE t1 SET extra = col3 /* QNO 194 CON_ID 21 */ /* TRANSFORM_OUTCOME_UNORDERED_MATCH */ /* QNO 202 CON_ID 21 */ 21 Query /* GenTest::Transform::EnableOptimizations */ /* TRANSFORM_CLEANUP */ SET SESSION optimizer_switch=@switch_saved /* QNO 203 CON_ID 21 */ 21 Query CREATE OR REPLACE VIEW transforms.view_4616_probe AS UPDATE t1 SET extra = col3 /* QNO 194 CON_ID 21 */ /* QNO 204 CON_ID 21 */ 21 Query ALTER TABLE t1 DROP COLUMN col3 /* QNO 205 CON_ID 21 */ 171012 18:12:48 18 Query CREATE OR REPLACE VIEW transforms.view_3564_probe AS ALTER TABLE t1 DROP PRIMARY KEY /* QNO 295 CON_ID 18 */ /* QNO 296 CON_ID 18 */ 19 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES ( 2, 2, 2, REPEAT(CAST(2 - 1 AS CHAR(1)),@fill_amount)) /* QNO 219 CON_ID 19 */ 17 Query UPDATE t1 SET extra = col1 /* QNO 275 CON_ID 17 */ 18 Query CHECK TABLE t1 /* QNO 297 CON_ID 18 */ 16 Query ALTER TABLE t1 DROP KEY idx, DROP KEY ftidx /* QNO 329 CON_ID 16 */ 19 Query ROLLBACK /* QNO 220 CON_ID 19 */ 19 Query CREATE OR REPLACE VIEW transforms.view_8236_probe AS ROLLBACK /* QNO 220 CON_ID 19 */ /* QNO 221 CON_ID 19 */ 19 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES ( 2, 2, 2, REPEAT(CAST(2 - 1 AS CHAR(1)),@fill_amount)) /* QNO 222 CON_ID 19 */ 18 Query CREATE OR REPLACE VIEW transforms.view_3564_probe AS CHECK TABLE t1 /* QNO 297 CON_ID 18 */ /* QNO 298 CON_ID 18 */ 18 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES ( 4, 4, 4, REPEAT(CAST(4 AS CHAR(1)),@fill_amount)) /* QNO 299 CON_ID 18 */ 171012 18:12:49 21 Query CREATE OR REPLACE VIEW transforms.view_4616_probe AS ALTER TABLE t1 DROP COLUMN col3 /* QNO 205 CON_ID 21 */ /* QNO 206 CON_ID 21 */ 19 Query ROLLBACK /* QNO 223 CON_ID 19 */ 21 Query ALTER TABLE t1 CHANGE COLUMN extra col3 INT /* QNO 207 CON_ID 21 */ 19 Query CREATE OR REPLACE VIEW transforms.view_8236_probe AS ROLLBACK /* QNO 223 CON_ID 19 */ /* QNO 224 CON_ID 19 */ 19 Query ALTER TABLE t1 DROP KEY idx /* QNO 225 CON_ID 19 */ 18 Query COMMIT /* QNO 300 CON_ID 18 */ 18 Query CREATE OR REPLACE VIEW transforms.view_3564_probe AS COMMIT /* QNO 300 CON_ID 18 */ /* QNO 301 CON_ID 18 */ 18 Query ALTER TABLE t1 ADD COLUMN extra INT /* QNO 302 CON_ID 18 */ 17 Query ALTER TABLE t1 DROP COLUMN col1 /* QNO 276 CON_ID 17 */ 16 Query CREATE OR REPLACE VIEW transforms.view_12936_probe AS ALTER TABLE t1 DROP KEY idx, DROP KEY ftidx /* QNO 329 CON_ID 16 */ /* QNO 330 CON_ID 16 */ 16 Query ALTER TABLE t1 DROP PRIMARY KEY /* QNO 331 CON_ID 16 */ 21 Query CREATE OR REPLACE VIEW transforms.view_4616_probe AS ALTER TABLE t1 CHANGE COLUMN extra col3 INT /* QNO 207 CON_ID 21 */ /* QNO 208 CON_ID 21 */ 21 Query UPDATE t1 SET col3 = 1 LIMIT 2 /* QNO 209 CON_ID 21 */ 19 Query ALTER TABLE t1 DROP KEY uidx /* QNO 226 CON_ID 19 */ 21 Query /* GenTest::Transform::DisableOptimizations */ SET @switch_saved = @@optimizer_switch /* QNO 210 CON_ID 21 */ 21 Query SET SESSION optimizer_switch = REPLACE( @@optimizer_switch, '=on', '=off' ) /* QNO 211 CON_ID 21 */ 21 Query SET SESSION optimizer_switch = 'in_to_exists=on' /* QNO 212 CON_ID 21 */ 21 Query UPDATE t1 SET col3 = 1 LIMIT 2 /* QNO 209 CON_ID 21 */ /* TRANSFORM_OUTCOME_UNORDERED_MATCH */ /* QNO 213 CON_ID 21 */ 21 Query /* GenTest::Transform::DisableOptimizations */ /* TRANSFORM_CLEANUP */ SET SESSION optimizer_switch=@switch_saved /* QNO 214 CON_ID 21 */ 21 Query /* GenTest::Transform::EnableOptimizations */ SET @switch_saved = @@optimizer_switch /* QNO 215 CON_ID 21 */ 21 Query SET SESSION optimizer_switch = REPLACE( @@optimizer_switch, '=off', '=on' ) /* QNO 216 CON_ID 21 */ 21 Query SHOW WARNINGS 21 Query UPDATE t1 SET col3 = 1 LIMIT 2 /* QNO 209 CON_ID 21 */ /* TRANSFORM_OUTCOME_UNORDERED_MATCH */ /* QNO 217 CON_ID 21 */ 21 Query /* GenTest::Transform::EnableOptimizations */ /* TRANSFORM_CLEANUP */ SET SESSION optimizer_switch=@switch_saved /* QNO 218 CON_ID 21 */ 21 Query CREATE OR REPLACE VIEW transforms.view_4616_probe AS UPDATE t1 SET col3 = 1 LIMIT 2 /* QNO 209 CON_ID 21 */ /* QNO 219 CON_ID 21 */ 21 Query COMMIT /* QNO 220 CON_ID 21 */ 21 Query CREATE OR REPLACE VIEW transforms.view_4616_probe AS COMMIT /* QNO 220 CON_ID 21 */ /* QNO 221 CON_ID 21 */ 21 Query UPDATE t1 SET col3 = 2 LIMIT 2 /* QNO 222 CON_ID 21 */ 18 Query CREATE OR REPLACE VIEW transforms.view_3564_probe AS ALTER TABLE t1 ADD COLUMN extra INT /* QNO 302 CON_ID 18 */ /* QNO 303 CON_ID 18 */ 17 Query ALTER TABLE t1 CHANGE COLUMN extra col1 INT /* QNO 277 CON_ID 17 */ 16 Query DELETE FROM t1 WHERE MATCH(col4) AGAINST (TRIM(' 3 ') IN BOOLEAN MODE) OR col1 IS NULL /* QNO 332 CON_ID 16 */ 19 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES ( 4, 4, 4, REPEAT(CAST(4 AS CHAR(1)),@fill_amount)) /* QNO 227 CON_ID 19 */ 21 Query /* GenTest::Transform::DisableOptimizations */ SET @switch_saved = @@optimizer_switch /* QNO 223 CON_ID 21 */ 16 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES /* NULL */ (NULL,NULL,NULL,REPEAT(CAST(NULL AS CHAR(1)),@fill_amount)), (NULL,NULL,NULL,REPEAT(CAST(NULL AS CHAR(1)),@fill_amount)) /* QNO 333 CON_ID 16 */ 18 Query UPDATE t1 SET extra = col3 /* QNO 304 CON_ID 18 */ 21 Query SET SESSION optimizer_switch = REPLACE( @@optimizer_switch, '=on', '=off' ) /* QNO 224 CON_ID 21 */ 16 Query ROLLBACK /* QNO 334 CON_ID 16 */ 21 Query SET SESSION optimizer_switch = 'in_to_exists=on' /* QNO 225 CON_ID 21 */ 16 Query CREATE OR REPLACE VIEW transforms.view_12936_probe AS ROLLBACK /* QNO 334 CON_ID 16 */ /* QNO 335 CON_ID 16 */ 21 Query UPDATE t1 SET col3 = 2 LIMIT 2 /* QNO 222 CON_ID 21 */ /* TRANSFORM_OUTCOME_UNORDERED_MATCH */ /* QNO 226 CON_ID 21 */ 16 Query ALTER TABLE `table0_int` DROP KEY rkr_index_12 /* QNO 336 CON_ID 16 */ 21 Query /* GenTest::Transform::DisableOptimizations */ /* TRANSFORM_CLEANUP */ SET SESSION optimizer_switch=@switch_saved /* QNO 227 CON_ID 21 */ 21 Query /* GenTest::Transform::EnableOptimizations */ SET @switch_saved = @@optimizer_switch /* QNO 228 CON_ID 21 */ 21 Query SET SESSION optimizer_switch = REPLACE( @@optimizer_switch, '=off', '=on' ) /* QNO 229 CON_ID 21 */ 21 Query SHOW WARNINGS 21 Query UPDATE t1 SET col3 = 2 LIMIT 2 /* QNO 222 CON_ID 21 */ /* TRANSFORM_OUTCOME_UNORDERED_MATCH */ /* QNO 230 CON_ID 21 */ 21 Query /* GenTest::Transform::EnableOptimizations */ /* TRANSFORM_CLEANUP */ SET SESSION optimizer_switch=@switch_saved /* QNO 231 CON_ID 21 */ 21 Query CREATE OR REPLACE VIEW transforms.view_4616_probe AS UPDATE t1 SET col3 = 2 LIMIT 2 /* QNO 222 CON_ID 21 */ /* QNO 232 CON_ID 21 */ 21 Query COMMIT /* QNO 233 CON_ID 21 */ 21 Query CREATE OR REPLACE VIEW transforms.view_4616_probe AS COMMIT /* QNO 233 CON_ID 21 */ /* QNO 234 CON_ID 21 */ 21 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES ( 2, 2 - 1, 2, REPEAT(CAST(2 AS CHAR(1)),@fill_amount)) /* QNO 235 CON_ID 21 */ 18 Query /* GenTest::Transform::DisableOptimizations */ SET @switch_saved = @@optimizer_switch /* QNO 305 CON_ID 18 */ 18 Query SET SESSION optimizer_switch = REPLACE( @@optimizer_switch, '=on', '=off' ) /* QNO 306 CON_ID 18 */ 18 Query SET SESSION optimizer_switch = 'in_to_exists=on' /* QNO 307 CON_ID 18 */ 18 Query UPDATE t1 SET extra = col3 /* QNO 304 CON_ID 18 */ /* TRANSFORM_OUTCOME_UNORDERED_MATCH */ /* QNO 308 CON_ID 18 */ 19 Query ROLLBACK /* QNO 228 CON_ID 19 */ 21 Query COMMIT /* QNO 236 CON_ID 21 */ 19 Query CREATE OR REPLACE VIEW transforms.view_8236_probe AS ROLLBACK /* QNO 228 CON_ID 19 */ /* QNO 229 CON_ID 19 */ 18 Query /* GenTest::Transform::DisableOptimizations */ /* TRANSFORM_CLEANUP */ SET SESSION optimizer_switch=@switch_saved /* QNO 309 CON_ID 18 */ 21 Query CREATE OR REPLACE VIEW transforms.view_4616_probe AS COMMIT /* QNO 236 CON_ID 21 */ /* QNO 237 CON_ID 21 */ 18 Query /* GenTest::Transform::EnableOptimizations */ SET @switch_saved = @@optimizer_switch /* QNO 310 CON_ID 18 */ 21 Query UPDATE t1 SET col3 = 4 LIMIT 2 /* QNO 238 CON_ID 21 */ 18 Query SET SESSION optimizer_switch = REPLACE( @@optimizer_switch, '=off', '=on' ) /* QNO 311 CON_ID 18 */ 18 Query SHOW WARNINGS 18 Query UPDATE t1 SET extra = col3 /* QNO 304 CON_ID 18 */ /* TRANSFORM_OUTCOME_UNORDERED_MATCH */ /* QNO 312 CON_ID 18 */ 18 Query /* GenTest::Transform::EnableOptimizations */ /* TRANSFORM_CLEANUP */ SET SESSION optimizer_switch=@switch_saved /* QNO 313 CON_ID 18 */ 18 Query CREATE OR REPLACE VIEW transforms.view_3564_probe AS UPDATE t1 SET extra = col3 /* QNO 304 CON_ID 18 */ /* QNO 314 CON_ID 18 */ 18 Query ALTER TABLE t1 DROP COLUMN col3 /* QNO 315 CON_ID 18 */ 19 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES ( 3, 3, 3, REPEAT(CAST(3 AS CHAR(1)),@fill_amount)) /* QNO 230 CON_ID 19 */ 16 Query CREATE OR REPLACE VIEW transforms.view_12936_probe AS ALTER TABLE `table0_int` DROP KEY rkr_index_12 /* QNO 336 CON_ID 16 */ /* QNO 337 CON_ID 16 */ 16 Query UPDATE t1 SET col3 = NULL LIMIT 2 /* QNO 338 CON_ID 16 */ 21 Query /* GenTest::Transform::DisableOptimizations */ SET @switch_saved = @@optimizer_switch /* QNO 239 CON_ID 21 */ 17 Query CREATE OR REPLACE VIEW transforms.view_10968_probe AS ALTER TABLE t1 CHANGE COLUMN extra col1 INT /* QNO 277 CON_ID 17 */ /* QNO 278 CON_ID 17 */ 19 Query COMMIT /* QNO 231 CON_ID 19 */ 16 Query /* GenTest::Transform::DisableOptimizations */ SET @switch_saved = @@optimizer_switch /* QNO 339 CON_ID 16 */ 19 Query CREATE OR REPLACE VIEW transforms.view_8236_probe AS COMMIT /* QNO 231 CON_ID 19 */ /* QNO 232 CON_ID 19 */ 21 Query SET SESSION optimizer_switch = REPLACE( @@optimizer_switch, '=on', '=off' ) /* QNO 240 CON_ID 21 */ 17 Query ALTER TABLE t1 DROP KEY ftidx /* QNO 279 CON_ID 17 */ 19 Query DELETE FROM t1 WHERE col2 = 4 OR col2 IS NULL /* QNO 233 CON_ID 19 */ 21 Query SET SESSION optimizer_switch = 'in_to_exists=on' /* QNO 241 CON_ID 21 */ 16 Query SET SESSION optimizer_switch = REPLACE( @@optimizer_switch, '=on', '=off' ) /* QNO 340 CON_ID 16 */ 21 Query UPDATE t1 SET col3 = 4 LIMIT 2 /* QNO 238 CON_ID 21 */ /* TRANSFORM_OUTCOME_UNORDERED_MATCH */ /* QNO 242 CON_ID 21 */ 16 Query SET SESSION optimizer_switch = 'in_to_exists=on' /* QNO 341 CON_ID 16 */ 21 Query /* GenTest::Transform::DisableOptimizations */ /* TRANSFORM_CLEANUP */ SET SESSION optimizer_switch=@switch_saved /* QNO 243 CON_ID 21 */ 16 Query UPDATE t1 SET col3 = NULL LIMIT 2 /* QNO 338 CON_ID 16 */ /* TRANSFORM_OUTCOME_UNORDERED_MATCH */ /* QNO 342 CON_ID 16 */ 21 Query /* GenTest::Transform::EnableOptimizations */ SET @switch_saved = @@optimizer_switch /* QNO 244 CON_ID 21 */ 16 Query /* GenTest::Transform::DisableOptimizations */ /* TRANSFORM_CLEANUP */ SET SESSION optimizer_switch=@switch_saved /* QNO 343 CON_ID 16 */ 21 Query SET SESSION optimizer_switch = REPLACE( @@optimizer_switch, '=off', '=on' ) /* QNO 245 CON_ID 21 */ 16 Query /* GenTest::Transform::EnableOptimizations */ SET @switch_saved = @@optimizer_switch /* QNO 344 CON_ID 16 */ 16 Query SET SESSION optimizer_switch = REPLACE( @@optimizer_switch, '=off', '=on' ) /* QNO 345 CON_ID 16 */ 21 Query SHOW WARNINGS 16 Query SHOW WARNINGS 21 Query UPDATE t1 SET col3 = 4 LIMIT 2 /* QNO 238 CON_ID 21 */ /* TRANSFORM_OUTCOME_UNORDERED_MATCH */ /* QNO 246 CON_ID 21 */ 16 Query UPDATE t1 SET col3 = NULL LIMIT 2 /* QNO 338 CON_ID 16 */ /* TRANSFORM_OUTCOME_UNORDERED_MATCH */ /* QNO 346 CON_ID 16 */ 21 Query /* GenTest::Transform::EnableOptimizations */ /* TRANSFORM_CLEANUP */ SET SESSION optimizer_switch=@switch_saved /* QNO 247 CON_ID 21 */ 16 Query /* GenTest::Transform::EnableOptimizations */ /* TRANSFORM_CLEANUP */ SET SESSION optimizer_switch=@switch_saved /* QNO 347 CON_ID 16 */ 21 Query CREATE OR REPLACE VIEW transforms.view_4616_probe AS UPDATE t1 SET col3 = 4 LIMIT 2 /* QNO 238 CON_ID 21 */ /* QNO 248 CON_ID 21 */ 16 Query CREATE OR REPLACE VIEW transforms.view_12936_probe AS UPDATE t1 SET col3 = NULL LIMIT 2 /* QNO 338 CON_ID 16 */ /* QNO 348 CON_ID 16 */ 21 Query ROLLBACK /* QNO 249 CON_ID 21 */ 16 Query ROLLBACK /* QNO 349 CON_ID 16 */ 21 Query CREATE OR REPLACE VIEW transforms.view_4616_probe AS ROLLBACK /* QNO 249 CON_ID 21 */ /* QNO 250 CON_ID 21 */ 16 Query CREATE OR REPLACE VIEW transforms.view_12936_probe AS ROLLBACK /* QNO 349 CON_ID 16 */ /* QNO 350 CON_ID 16 */ 21 Query CHECK TABLE t1 /* QNO 251 CON_ID 21 */ 16 Query UPDATE t1 SET col3 = 3 LIMIT 2 /* QNO 351 CON_ID 16 */ 16 Query /* GenTest::Transform::DisableOptimizations */ SET @switch_saved = @@optimizer_switch /* QNO 352 CON_ID 16 */ 19 Query COMMIT /* QNO 234 CON_ID 19 */ 16 Query SET SESSION optimizer_switch = REPLACE( @@optimizer_switch, '=on', '=off' ) /* QNO 353 CON_ID 16 */ 19 Query CREATE OR REPLACE VIEW transforms.view_8236_probe AS COMMIT /* QNO 234 CON_ID 19 */ /* QNO 235 CON_ID 19 */ 16 Query SET SESSION optimizer_switch = 'in_to_exists=on' /* QNO 354 CON_ID 16 */ 19 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES ( 4, 4, 4 - 1, REPEAT(CAST(4 AS CHAR(1)),@fill_amount)) /* QNO 236 CON_ID 19 */ 16 Query UPDATE t1 SET col3 = 3 LIMIT 2 /* QNO 351 CON_ID 16 */ /* TRANSFORM_OUTCOME_UNORDERED_MATCH */ /* QNO 355 CON_ID 16 */ 16 Query /* GenTest::Transform::DisableOptimizations */ /* TRANSFORM_CLEANUP */ SET SESSION optimizer_switch=@switch_saved /* QNO 356 CON_ID 16 */ 16 Query /* GenTest::Transform::EnableOptimizations */ SET @switch_saved = @@optimizer_switch /* QNO 357 CON_ID 16 */ 16 Query SET SESSION optimizer_switch = REPLACE( @@optimizer_switch, '=off', '=on' ) /* QNO 358 CON_ID 16 */ 16 Query SHOW WARNINGS 16 Query UPDATE t1 SET col3 = 3 LIMIT 2 /* QNO 351 CON_ID 16 */ /* TRANSFORM_OUTCOME_UNORDERED_MATCH */ /* QNO 359 CON_ID 16 */ 16 Query /* GenTest::Transform::EnableOptimizations */ /* TRANSFORM_CLEANUP */ SET SESSION optimizer_switch=@switch_saved /* QNO 360 CON_ID 16 */ 16 Query CREATE OR REPLACE VIEW transforms.view_12936_probe AS UPDATE t1 SET col3 = 3 LIMIT 2 /* QNO 351 CON_ID 16 */ /* QNO 361 CON_ID 16 */ 16 Query ROLLBACK /* QNO 362 CON_ID 16 */ 16 Query CREATE OR REPLACE VIEW transforms.view_12936_probe AS ROLLBACK /* QNO 362 CON_ID 16 */ /* QNO 363 CON_ID 16 */ 16 Query ALTER TABLE t1 ADD KEY idx ( col4(10) ) /* QNO 364 CON_ID 16 */ 21 Query CREATE OR REPLACE VIEW transforms.view_4616_probe AS CHECK TABLE t1 /* QNO 251 CON_ID 21 */ /* QNO 252 CON_ID 21 */ 21 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES ( NULL, NULL, NULL, REPEAT(CAST(NULL AS CHAR(1)),@fill_amount)) /* QNO 253 CON_ID 21 */ 171012 18:12:50 19 Query ROLLBACK /* QNO 237 CON_ID 19 */ 21 Query ROLLBACK /* QNO 254 CON_ID 21 */ 18 Query CREATE OR REPLACE VIEW transforms.view_3564_probe AS ALTER TABLE t1 DROP COLUMN col3 /* QNO 315 CON_ID 18 */ /* QNO 316 CON_ID 18 */ 17 Query ALTER TABLE t1 DROP KEY idx /* QNO 280 CON_ID 17 */ 21 Query CREATE OR REPLACE VIEW transforms.view_4616_probe AS ROLLBACK /* QNO 254 CON_ID 21 */ /* QNO 255 CON_ID 21 */ 18 Query ALTER TABLE t1 CHANGE COLUMN extra col3 INT /* QNO 317 CON_ID 18 */ 19 Query CREATE OR REPLACE VIEW transforms.view_8236_probe AS ROLLBACK /* QNO 237 CON_ID 19 */ /* QNO 238 CON_ID 19 */ 21 Query UPDATE t1 SET col3 = 2 LIMIT 2 /* QNO 256 CON_ID 21 */ 19 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES ( 2, 2 - 1, 2, REPEAT(CAST(2 AS CHAR(1)),@fill_amount)) /* QNO 239 CON_ID 19 */ 21 Query ROLLBACK /* QNO 257 CON_ID 21 */ 19 Query COMMIT /* QNO 240 CON_ID 19 */ 21 Query CREATE OR REPLACE VIEW transforms.view_4616_probe AS ROLLBACK /* QNO 257 CON_ID 21 */ /* QNO 258 CON_ID 21 */ 21 Query CHECK TABLE t1 /* QNO 259 CON_ID 21 */ 19 Query CREATE OR REPLACE VIEW transforms.view_8236_probe AS COMMIT /* QNO 240 CON_ID 19 */ /* QNO 241 CON_ID 19 */ 19 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES ( NULL, NULL, NULL, REPEAT(CAST(NULL - 1 AS CHAR(1)),@fill_amount)) /* QNO 242 CON_ID 19 */ 19 Query COMMIT /* QNO 243 CON_ID 19 */ 16 Query CREATE OR REPLACE VIEW transforms.view_12936_probe AS ALTER TABLE t1 ADD KEY idx ( col4(10) ) /* QNO 364 CON_ID 16 */ /* QNO 365 CON_ID 16 */ 19 Query CREATE OR REPLACE VIEW transforms.view_8236_probe AS COMMIT /* QNO 243 CON_ID 19 */ /* QNO 244 CON_ID 19 */ 19 Query ALTER TABLE t1 ADD KEY idx ( col3 ), ADD KEY idx ( col2 ) /* QNO 245 CON_ID 19 */ 16 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES ( NULL, NULL, NULL, REPEAT(CAST(NULL AS CHAR(1)),@fill_amount)) /* QNO 366 CON_ID 16 */ 21 Query CREATE OR REPLACE VIEW transforms.view_4616_probe AS CHECK TABLE t1 /* QNO 259 CON_ID 21 */ /* QNO 260 CON_ID 21 */ 21 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES ( NULL, NULL - 1, NULL, REPEAT(CAST(NULL AS CHAR(1)),@fill_amount)) /* QNO 261 CON_ID 21 */ 16 Query ROLLBACK /* QNO 367 CON_ID 16 */ 16 Query CREATE OR REPLACE VIEW transforms.view_12936_probe AS ROLLBACK /* QNO 367 CON_ID 16 */ /* QNO 368 CON_ID 16 */ 16 Query ALTER TABLE t1 DROP KEY uidx /* QNO 369 CON_ID 16 */ 18 Query ALTER TABLE t1 DROP KEY idx /* QNO 318 CON_ID 18 */ 17 Query CREATE OR REPLACE VIEW transforms.view_10968_probe AS ALTER TABLE t1 DROP KEY idx /* QNO 280 CON_ID 17 */ /* QNO 281 CON_ID 17 */ 16 Query ALTER TABLE t1 ADD FULLTEXT KEY ftidx ( col4 ) /* QNO 370 CON_ID 16 */ 21 Query COMMIT /* QNO 262 CON_ID 21 */ 19 Query DELETE FROM t1 WHERE MATCH(col4) AGAINST (TRIM(' 2 ') IN BOOLEAN MODE) OR col3 IS NULL /* QNO 246 CON_ID 19 */ 18 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES ( 1, 1 - 1, 1, REPEAT(CAST(1 AS CHAR(1)),@fill_amount)) /* QNO 319 CON_ID 18 */ 17 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES ( 3, 3, 3, REPEAT(CAST(3 AS CHAR(1)),@fill_amount)) /* QNO 282 CON_ID 17 */ 21 Query CREATE OR REPLACE VIEW transforms.view_4616_probe AS COMMIT /* QNO 262 CON_ID 21 */ /* QNO 263 CON_ID 21 */ 21 Query DELETE FROM t1 WHERE col2 = 2 OR col2 IS NULL /* QNO 264 CON_ID 21 */ 16 Query SHOW WARNINGS 21 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES /* 3 */ (3,3,3,REPEAT(CAST(3 AS CHAR(1)),@fill_amount)), (3,3,3,REPEAT(CAST(3 AS CHAR(1)),@fill_amount)) /* QNO 265 CON_ID 21 */ 17 Query COMMIT /* QNO 283 CON_ID 17 */ 16 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES ( NULL, NULL, NULL, REPEAT(CAST(NULL - 1 AS CHAR(1)),@fill_amount)) /* QNO 371 CON_ID 16 */ 21 Query COMMIT /* QNO 266 CON_ID 21 */ 19 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES /* 3 */ (3,3,3,REPEAT(CAST(3 AS CHAR(1)),@fill_amount)), (3,3,3,REPEAT(CAST(3 AS CHAR(1)),@fill_amount)) /* QNO 247 CON_ID 19 */ 17 Query CREATE OR REPLACE VIEW transforms.view_10968_probe AS COMMIT /* QNO 283 CON_ID 17 */ /* QNO 284 CON_ID 17 */ 19 Query COMMIT /* QNO 248 CON_ID 19 */ 18 Query COMMIT /* QNO 320 CON_ID 18 */ 18 Query CREATE OR REPLACE VIEW transforms.view_3564_probe AS COMMIT /* QNO 320 CON_ID 18 */ /* QNO 321 CON_ID 18 */ 16 Query ROLLBACK /* QNO 372 CON_ID 16 */ 19 Query CREATE OR REPLACE VIEW transforms.view_8236_probe AS COMMIT /* QNO 248 CON_ID 19 */ /* QNO 249 CON_ID 19 */ 16 Query CREATE OR REPLACE VIEW transforms.view_12936_probe AS ROLLBACK /* QNO 372 CON_ID 16 */ /* QNO 373 CON_ID 16 */ 18 Query ALTER TABLE t1 DROP KEY uidx /* QNO 322 CON_ID 18 */ 21 Query CREATE OR REPLACE VIEW transforms.view_4616_probe AS COMMIT /* QNO 266 CON_ID 21 */ /* QNO 267 CON_ID 21 */ 18 Query ALTER TABLE t1 DROP KEY ftidx, ADD PRIMARY KEY ( col2 ) /* QNO 323 CON_ID 18 */ 16 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES ( NULL, NULL, NULL, REPEAT(CAST(NULL AS CHAR(1)),@fill_amount)) /* QNO 374 CON_ID 16 */ 19 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES ( 1, 1, 1, REPEAT(CAST(1 - 1 AS CHAR(1)),@fill_amount)) /* QNO 250 CON_ID 19 */ 18 Query DELETE FROM t1 WHERE col2 = 1 OR col2 IS NULL /* QNO 324 CON_ID 18 */ 21 Query DELETE FROM t1 WHERE col2 = 2 OR col2 IS NULL /* QNO 268 CON_ID 21 */ 16 Query COMMIT /* QNO 375 CON_ID 16 */ 21 Query COMMIT /* QNO 269 CON_ID 21 */ 18 Query COMMIT /* QNO 325 CON_ID 18 */ 16 Query CREATE OR REPLACE VIEW transforms.view_12936_probe AS COMMIT /* QNO 375 CON_ID 16 */ /* QNO 376 CON_ID 16 */ 18 Query CREATE OR REPLACE VIEW transforms.view_3564_probe AS COMMIT /* QNO 325 CON_ID 18 */ /* QNO 326 CON_ID 18 */ 21 Query CREATE OR REPLACE VIEW transforms.view_4616_probe AS COMMIT /* QNO 269 CON_ID 21 */ /* QNO 270 CON_ID 21 */ 18 Query ALTER TABLE t1 ADD FULLTEXT KEY ftidx ( col4 ) /* QNO 327 CON_ID 18 */ 17 Query DELETE FROM t1 WHERE MATCH(col4) AGAINST (TRIM(' 3 ') IN BOOLEAN MODE) OR col2 IS NULL /* QNO 285 CON_ID 17 */ 16 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES ( 2, 2, 2, REPEAT(CAST(2 AS CHAR(1)),@fill_amount)) /* QNO 377 CON_ID 16 */ 17 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES /* 3 */ (3,3,3,REPEAT(CAST(3 AS CHAR(1)),@fill_amount)), (3,3,3,REPEAT(CAST(3 AS CHAR(1)),@fill_amount)) /* QNO 286 CON_ID 17 */ 19 Query ROLLBACK /* QNO 251 CON_ID 19 */ 21 Query ALTER TABLE t1 ADD PRIMARY KEY ( col4(10), col2 ), ADD FULLTEXT KEY ftidx ( col4 ) /* QNO 271 CON_ID 21 */ 18 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES ( 2, 2 - 1, 2, REPEAT(CAST(2 AS CHAR(1)),@fill_amount)) /* QNO 328 CON_ID 18 */ 19 Query CREATE OR REPLACE VIEW transforms.view_8236_probe AS ROLLBACK /* QNO 251 CON_ID 19 */ /* QNO 252 CON_ID 19 */ 16 Query COMMIT /* QNO 378 CON_ID 16 */ 17 Query COMMIT /* QNO 287 CON_ID 17 */ 21 Query ALTER TABLE t1 DROP PRIMARY KEY /* QNO 272 CON_ID 21 */ 18 Query COMMIT /* QNO 329 CON_ID 18 */ 16 Query CREATE OR REPLACE VIEW transforms.view_12936_probe AS COMMIT /* QNO 378 CON_ID 16 */ /* QNO 379 CON_ID 16 */ 17 Query CREATE OR REPLACE VIEW transforms.view_10968_probe AS COMMIT /* QNO 287 CON_ID 17 */ /* QNO 288 CON_ID 17 */ 19 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES ( 2, 2, 2 - 1, REPEAT(CAST(2 AS CHAR(1)),@fill_amount)) /* QNO 253 CON_ID 19 */ 18 Query CREATE OR REPLACE VIEW transforms.view_3564_probe AS COMMIT /* QNO 329 CON_ID 18 */ /* QNO 330 CON_ID 18 */ 21 Query UPDATE t1 SET col1 = 2 LIMIT 2 /* QNO 273 CON_ID 21 */ 17 Query ALTER TABLE t1 DROP PRIMARY KEY /* QNO 289 CON_ID 17 */ 19 Query ROLLBACK /* QNO 254 CON_ID 19 */ 18 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES ( 3, 3, 3, REPEAT(CAST(3 AS CHAR(1)),@fill_amount)) /* QNO 331 CON_ID 18 */ 16 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES ( 1, 1 - 1, 1, REPEAT(CAST(1 AS CHAR(1)),@fill_amount)) /* QNO 380 CON_ID 16 */ 18 Query ROLLBACK /* QNO 332 CON_ID 18 */ 17 Query DELETE FROM t1 WHERE MATCH(col4) AGAINST (TRIM(' 4 ') IN BOOLEAN MODE) OR col2 IS NULL /* QNO 290 CON_ID 17 */ 21 Query /* GenTest::Transform::DisableOptimizations */ SET @switch_saved = @@optimizer_switch /* QNO 274 CON_ID 21 */ 16 Query COMMIT /* QNO 381 CON_ID 16 */ 18 Query CREATE OR REPLACE VIEW transforms.view_3564_probe AS ROLLBACK /* QNO 332 CON_ID 18 */ /* QNO 333 CON_ID 18 */ 16 Query CREATE OR REPLACE VIEW transforms.view_12936_probe AS COMMIT /* QNO 381 CON_ID 16 */ /* QNO 382 CON_ID 16 */ 17 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES /* 2 */ (2,2,2,REPEAT(CAST(2 AS CHAR(1)),@fill_amount)), (2,2,2,REPEAT(CAST(2 AS CHAR(1)),@fill_amount)) /* QNO 291 CON_ID 17 */ 19 Query CREATE OR REPLACE VIEW transforms.view_8236_probe AS ROLLBACK /* QNO 254 CON_ID 19 */ /* QNO 255 CON_ID 19 */ 21 Query SET SESSION optimizer_switch = REPLACE( @@optimizer_switch, '=on', '=off' ) /* QNO 275 CON_ID 21 */ 17 Query ROLLBACK /* QNO 292 CON_ID 17 */ 16 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES ( 4, 4 - 1, 4, REPEAT(CAST(4 AS CHAR(1)),@fill_amount)) /* QNO 383 CON_ID 16 */ 18 Query DELETE FROM t1 WHERE col3 = 4 OR col3 IS NULL /* QNO 334 CON_ID 18 */ 21 Query SET SESSION optimizer_switch = 'in_to_exists=on' /* QNO 276 CON_ID 21 */ 16 Query ROLLBACK /* QNO 384 CON_ID 16 */ 18 Query COMMIT /* QNO 335 CON_ID 18 */ 21 Query UPDATE t1 SET col1 = 2 LIMIT 2 /* QNO 273 CON_ID 21 */ /* TRANSFORM_OUTCOME_UNORDERED_MATCH */ /* QNO 277 CON_ID 21 */ 17 Query CREATE OR REPLACE VIEW transforms.view_10968_probe AS ROLLBACK /* QNO 292 CON_ID 17 */ /* QNO 293 CON_ID 17 */ 19 Query DELETE FROM t1 WHERE MATCH(col4) AGAINST (TRIM(' 1 ') IN BOOLEAN MODE) OR col1 IS NULL /* QNO 256 CON_ID 19 */ 16 Query CREATE OR REPLACE VIEW transforms.view_12936_probe AS ROLLBACK /* QNO 384 CON_ID 16 */ /* QNO 385 CON_ID 16 */ 21 Query /* GenTest::Transform::DisableOptimizations */ /* TRANSFORM_CLEANUP */ SET SESSION optimizer_switch=@switch_saved /* QNO 278 CON_ID 21 */ 18 Query CREATE OR REPLACE VIEW transforms.view_3564_probe AS COMMIT /* QNO 335 CON_ID 18 */ /* QNO 336 CON_ID 18 */ 17 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES ( 4, 4, 4, REPEAT(CAST(4 AS CHAR(1)),@fill_amount)) /* QNO 294 CON_ID 17 */ 19 Query /* GenTest::Transform::DisableOptimizations */ SET @switch_saved = @@optimizer_switch /* QNO 257 CON_ID 19 */ 19 Query SET SESSION optimizer_switch = REPLACE( @@optimizer_switch, '=on', '=off' ) /* QNO 258 CON_ID 19 */ 17 Query ROLLBACK /* QNO 295 CON_ID 17 */ 18 Query ALTER TABLE t1 DROP PRIMARY KEY /* QNO 337 CON_ID 18 */ 19 Query SET SESSION optimizer_switch = 'in_to_exists=on' /* QNO 259 CON_ID 19 */ 16 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES ( 2, 2 - 1, 2, REPEAT(CAST(2 AS CHAR(1)),@fill_amount)) /* QNO 386 CON_ID 16 */ 21 Query /* GenTest::Transform::EnableOptimizations */ SET @switch_saved = @@optimizer_switch /* QNO 279 CON_ID 21 */ 19 Query DELETE FROM t1 WHERE MATCH(col4) AGAINST (TRIM(' 1 ') IN BOOLEAN MODE) OR col1 IS NULL /* QNO 256 CON_ID 19 */ /* TRANSFORM_OUTCOME_UNORDERED_MATCH */ /* QNO 260 CON_ID 19 */ 17 Query CREATE OR REPLACE VIEW transforms.view_10968_probe AS ROLLBACK /* QNO 295 CON_ID 17 */ /* QNO 296 CON_ID 17 */ 18 Query ALTER TABLE t1 DROP PRIMARY KEY, DROP KEY ftidx /* QNO 338 CON_ID 18 */ 16 Query ROLLBACK /* QNO 387 CON_ID 16 */ 21 Query SET SESSION optimizer_switch = REPLACE( @@optimizer_switch, '=off', '=on' ) /* QNO 280 CON_ID 21 */ 16 Query CREATE OR REPLACE VIEW transforms.view_12936_probe AS ROLLBACK /* QNO 387 CON_ID 16 */ /* QNO 388 CON_ID 16 */ 21 Query SHOW WARNINGS 21 Query UPDATE t1 SET col1 = 2 LIMIT 2 /* QNO 273 CON_ID 21 */ /* TRANSFORM_OUTCOME_UNORDERED_MATCH */ /* QNO 281 CON_ID 21 */ 16 Query ALTER TABLE t1 DROP KEY uidx /* QNO 389 CON_ID 16 */ 17 Query DELETE FROM t1 WHERE MATCH(col4) AGAINST (TRIM(' 2 ') IN BOOLEAN MODE) OR col2 IS NULL /* QNO 297 CON_ID 17 */ 19 Query /* GenTest::Transform::DisableOptimizations */ /* TRANSFORM_CLEANUP */ SET SESSION optimizer_switch=@switch_saved /* QNO 261 CON_ID 19 */ 17 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES /* 4 */ (4,4,4,REPEAT(CAST(4 AS CHAR(1)),@fill_amount)), (4,4,4,REPEAT(CAST(4 AS CHAR(1)),@fill_amount)) /* QNO 298 CON_ID 17 */ 19 Query /* GenTest::Transform::EnableOptimizations */ SET @switch_saved = @@optimizer_switch /* QNO 262 CON_ID 19 */ 17 Query COMMIT /* QNO 299 CON_ID 17 */ 19 Query SET SESSION optimizer_switch = REPLACE( @@optimizer_switch, '=off', '=on' ) /* QNO 263 CON_ID 19 */ 17 Query CREATE OR REPLACE VIEW transforms.view_10968_probe AS COMMIT /* QNO 299 CON_ID 17 */ /* QNO 300 CON_ID 17 */ 19 Query SHOW WARNINGS 19 Query DELETE FROM t1 WHERE MATCH(col4) AGAINST (TRIM(' 1 ') IN BOOLEAN MODE) OR col1 IS NULL /* QNO 256 CON_ID 19 */ /* TRANSFORM_OUTCOME_UNORDERED_MATCH */ /* QNO 264 CON_ID 19 */ 17 Query DELETE FROM t1 WHERE col3 = 2 OR col3 IS NULL /* QNO 301 CON_ID 17 */ 19 Query /* GenTest::Transform::EnableOptimizations */ /* TRANSFORM_CLEANUP */ SET SESSION optimizer_switch=@switch_saved /* QNO 265 CON_ID 19 */ 17 Query COMMIT /* QNO 302 CON_ID 17 */ 19 Query CREATE OR REPLACE VIEW transforms.view_8236_probe AS DELETE FROM t1 WHERE MATCH(col4) AGAINST (TRIM(' 1 ') IN BOOLEAN MODE) OR col1 IS NULL /* QNO 256 CON_ID 19 */ /* QNO 266 CON_ID 19 */ 17 Query CREATE OR REPLACE VIEW transforms.view_10968_probe AS COMMIT /* QNO 302 CON_ID 17 */ /* QNO 303 CON_ID 17 */ 19 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES /* 1 */ (1,1,1,REPEAT(CAST(1 AS CHAR(1)),@fill_amount)), (1,1,1,REPEAT(CAST(1 AS CHAR(1)),@fill_amount)) /* QNO 267 CON_ID 19 */ 17 Query ALTER TABLE t1 ADD COLUMN extra INT /* QNO 304 CON_ID 17 */ 19 Query ROLLBACK /* QNO 268 CON_ID 19 */ 19 Query CREATE OR REPLACE VIEW transforms.view_8236_probe AS ROLLBACK /* QNO 268 CON_ID 19 */ /* QNO 269 CON_ID 19 */ 19 Query DELETE FROM t1 WHERE col1 = 2 OR col1 IS NULL /* QNO 270 CON_ID 19 */ 19 Query /* GenTest::Transform::DisableOptimizations */ SET @switch_saved = @@optimizer_switch /* QNO 271 CON_ID 19 */ 19 Query SET SESSION optimizer_switch = REPLACE( @@optimizer_switch, '=on', '=off' ) /* QNO 272 CON_ID 19 */ 19 Query SET SESSION optimizer_switch = 'in_to_exists=on' /* QNO 273 CON_ID 19 */ 19 Query DELETE FROM t1 WHERE col1 = 2 OR col1 IS NULL /* QNO 270 CON_ID 19 */ /* TRANSFORM_OUTCOME_UNORDERED_MATCH */ /* QNO 274 CON_ID 19 */ 19 Query /* GenTest::Transform::DisableOptimizations */ /* TRANSFORM_CLEANUP */ SET SESSION optimizer_switch=@switch_saved /* QNO 275 CON_ID 19 */ 19 Query /* GenTest::Transform::EnableOptimizations */ SET @switch_saved = @@optimizer_switch /* QNO 276 CON_ID 19 */ 19 Query SET SESSION optimizer_switch = REPLACE( @@optimizer_switch, '=off', '=on' ) /* QNO 277 CON_ID 19 */ 19 Query SHOW WARNINGS 19 Query DELETE FROM t1 WHERE col1 = 2 OR col1 IS NULL /* QNO 270 CON_ID 19 */ /* TRANSFORM_OUTCOME_UNORDERED_MATCH */ /* QNO 278 CON_ID 19 */ 19 Query /* GenTest::Transform::EnableOptimizations */ /* TRANSFORM_CLEANUP */ SET SESSION optimizer_switch=@switch_saved /* QNO 279 CON_ID 19 */ 19 Query CREATE OR REPLACE VIEW transforms.view_8236_probe AS DELETE FROM t1 WHERE col1 = 2 OR col1 IS NULL /* QNO 270 CON_ID 19 */ /* QNO 280 CON_ID 19 */ 21 Query /* GenTest::Transform::EnableOptimizations */ /* TRANSFORM_CLEANUP */ SET SESSION optimizer_switch=@switch_saved /* QNO 282 CON_ID 21 */ 19 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES /* NULL */ (NULL,NULL,NULL,REPEAT(CAST(NULL AS CHAR(1)),@fill_amount)), (NULL,NULL,NULL,REPEAT(CAST(NULL AS CHAR(1)),@fill_amount)) /* QNO 281 CON_ID 19 */ 16 Query DELETE FROM t1 WHERE MATCH(col4) AGAINST (TRIM(' 4 ') IN BOOLEAN MODE) OR col2 IS NULL /* QNO 390 CON_ID 16 */ 19 Query ROLLBACK /* QNO 282 CON_ID 19 */ 21 Query CREATE OR REPLACE VIEW transforms.view_4616_probe AS UPDATE t1 SET col1 = 2 LIMIT 2 /* QNO 273 CON_ID 21 */ /* QNO 283 CON_ID 21 */ 18 Query DELETE FROM t1 WHERE MATCH(col4) AGAINST (TRIM(' NULL ') IN BOOLEAN MODE) OR col2 IS NULL /* QNO 339 CON_ID 18 */ 21 Query ROLLBACK /* QNO 284 CON_ID 21 */ 19 Query CREATE OR REPLACE VIEW transforms.view_8236_probe AS ROLLBACK /* QNO 282 CON_ID 19 */ /* QNO 283 CON_ID 19 */ 21 Query CREATE OR REPLACE VIEW transforms.view_4616_probe AS ROLLBACK /* QNO 284 CON_ID 21 */ /* QNO 285 CON_ID 21 */ 19 Query DELETE FROM t1 WHERE MATCH(col4) AGAINST (TRIM(' 1 ') IN BOOLEAN MODE) OR col3 IS NULL /* QNO 284 CON_ID 19 */ 21 Query DELETE FROM t1 WHERE MATCH(col4) AGAINST (TRIM(' 2 ') IN BOOLEAN MODE) OR col2 IS NULL /* QNO 286 CON_ID 21 */ 171012 18:12:51 17 Query CREATE OR REPLACE VIEW transforms.view_10968_probe AS ALTER TABLE t1 ADD COLUMN extra INT /* QNO 304 CON_ID 17 */ /* QNO 305 CON_ID 17 */ 17 Query UPDATE t1 SET extra = col3 /* QNO 306 CON_ID 17 */ 18 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES /* 2 */ (2,2,2,REPEAT(CAST(2 AS CHAR(1)),@fill_amount)), (2,2,2,REPEAT(CAST(2 AS CHAR(1)),@fill_amount)) /* QNO 340 CON_ID 18 */ 18 Query COMMIT /* QNO 341 CON_ID 18 */ 18 Query CREATE OR REPLACE VIEW transforms.view_3564_probe AS COMMIT /* QNO 341 CON_ID 18 */ /* QNO 342 CON_ID 18 */ 17 Query ALTER TABLE t1 DROP COLUMN col3 /* QNO 307 CON_ID 17 */ 19 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES /* 2 */ (2,2,2,REPEAT(CAST(2 AS CHAR(1)),@fill_amount)), (2,2,2,REPEAT(CAST(2 AS CHAR(1)),@fill_amount)) /* QNO 285 CON_ID 19 */ 18 Query ALTER TABLE t1 ADD KEY idx ( col3 ) /* QNO 343 CON_ID 18 */ 17 Query ALTER TABLE t1 CHANGE COLUMN extra col3 INT /* QNO 308 CON_ID 17 */ 19 Query ROLLBACK /* QNO 286 CON_ID 19 */ 19 Query CREATE OR REPLACE VIEW transforms.view_8236_probe AS ROLLBACK /* QNO 286 CON_ID 19 */ /* QNO 287 CON_ID 19 */ 18 Query ALTER TABLE t1 ADD PRIMARY KEY ( col1 ) /* QNO 344 CON_ID 18 */ 19 Query ALTER TABLE t1 ADD FULLTEXT KEY ftidx ( col4 ) /* QNO 288 CON_ID 19 */ 16 Query COMMIT /* QNO 391 CON_ID 16 */ 16 Query CREATE OR REPLACE VIEW transforms.view_12936_probe AS COMMIT /* QNO 391 CON_ID 16 */ /* QNO 392 CON_ID 16 */ 16 Query ALTER TABLE t1 ADD UNIQUE KEY uidx ( col3 ) /* QNO 393 CON_ID 16 */ 21 Query COMMIT /* QNO 287 CON_ID 21 */ 21 Query CREATE OR REPLACE VIEW transforms.view_4616_probe AS COMMIT /* QNO 287 CON_ID 21 */ /* QNO 288 CON_ID 21 */ 21 Query ALTER TABLE t1 DROP PRIMARY KEY /* QNO 289 CON_ID 21 */ 17 Query CREATE OR REPLACE VIEW transforms.view_10968_probe AS ALTER TABLE t1 CHANGE COLUMN extra col3 INT /* QNO 308 CON_ID 17 */ /* QNO 309 CON_ID 17 */ 17 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES ( NULL, NULL, NULL, REPEAT(CAST(NULL AS CHAR(1)),@fill_amount)) /* QNO 310 CON_ID 17 */ 171012 18:12:52 18 Query CREATE OR REPLACE VIEW transforms.view_3564_probe AS ALTER TABLE t1 ADD PRIMARY KEY ( col1 ) /* QNO 344 CON_ID 18 */ /* QNO 345 CON_ID 18 */ 17 Query COMMIT /* QNO 311 CON_ID 17 */ 18 Query CHECK TABLE t1 /* QNO 346 CON_ID 18 */ 17 Query CREATE OR REPLACE VIEW transforms.view_10968_probe AS COMMIT /* QNO 311 CON_ID 17 */ /* QNO 312 CON_ID 17 */ 17 Query ALTER TABLE t1 ADD FULLTEXT KEY ftidx ( col4 ) /* QNO 313 CON_ID 17 */ 19 Query ALTER TABLE t1 DROP KEY uidx, DROP KEY idx /* QNO 289 CON_ID 19 */ 18 Query CREATE OR REPLACE VIEW transforms.view_3564_probe AS CHECK TABLE t1 /* QNO 346 CON_ID 18 */ /* QNO 347 CON_ID 18 */ 18 Query CHECK TABLE t1 /* QNO 348 CON_ID 18 */ 18 Query CREATE OR REPLACE VIEW transforms.view_3564_probe AS CHECK TABLE t1 /* QNO 348 CON_ID 18 */ /* QNO 349 CON_ID 18 */ 18 Query ALTER TABLE t1 DROP PRIMARY KEY /* QNO 350 CON_ID 18 */ 16 Query CREATE OR REPLACE VIEW transforms.view_12936_probe AS ALTER TABLE t1 ADD UNIQUE KEY uidx ( col3 ) /* QNO 393 CON_ID 16 */ /* QNO 394 CON_ID 16 */ 16 Query ALTER TABLE t1 ADD UNIQUE KEY uidx ( col3 ) /* QNO 395 CON_ID 16 */ 171012 18:12:53 21 Query CREATE OR REPLACE VIEW transforms.view_4616_probe AS ALTER TABLE t1 DROP PRIMARY KEY /* QNO 289 CON_ID 21 */ /* QNO 290 CON_ID 21 */ 19 Query ALTER TABLE t1 DROP KEY ftidx /* QNO 290 CON_ID 19 */ 17 Query ALTER TABLE t1 DROP KEY ftidx /* QNO 314 CON_ID 17 */ 21 Query UPDATE t1 SET col2 = 4 LIMIT 2 /* QNO 291 CON_ID 21 */ 16 Query ALTER TABLE t1 DROP KEY uidx, ADD FULLTEXT KEY ftidx ( col4 ) /* QNO 396 CON_ID 16 */ 18 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES ( 4, 4, 4, REPEAT(CAST(4 AS CHAR(1)),@fill_amount)) /* QNO 351 CON_ID 18 */ 21 Query COMMIT /* QNO 292 CON_ID 21 */ 18 Query ROLLBACK /* QNO 352 CON_ID 18 */ 21 Query CREATE OR REPLACE VIEW transforms.view_4616_probe AS COMMIT /* QNO 292 CON_ID 21 */ /* QNO 293 CON_ID 21 */ 18 Query CREATE OR REPLACE VIEW transforms.view_3564_probe AS ROLLBACK /* QNO 352 CON_ID 18 */ /* QNO 353 CON_ID 18 */ 18 Query CHECK TABLE t1 /* QNO 354 CON_ID 18 */ 21 Query DELETE FROM t1 WHERE col2 = NULL OR col2 IS NULL /* QNO 294 CON_ID 21 */ 171012 18:12:54 19 Query CREATE OR REPLACE VIEW transforms.view_8236_probe AS ALTER TABLE t1 DROP KEY ftidx /* QNO 290 CON_ID 19 */ /* QNO 291 CON_ID 19 */ 21 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES /* 4 */ (4,4,4,REPEAT(CAST(4 AS CHAR(1)),@fill_amount)), (4,4,4,REPEAT(CAST(4 AS CHAR(1)),@fill_amount)) /* QNO 295 CON_ID 21 */ 17 Query DELETE FROM t1 WHERE col1 = 1 OR col1 IS NULL /* QNO 315 CON_ID 17 */ 19 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES ( 4, 4, 4 - 1, REPEAT(CAST(4 AS CHAR(1)),@fill_amount)) /* QNO 292 CON_ID 19 */ 21 Query ROLLBACK /* QNO 296 CON_ID 21 */ 21 Query CREATE OR REPLACE VIEW transforms.view_4616_probe AS ROLLBACK /* QNO 296 CON_ID 21 */ /* QNO 297 CON_ID 21 */ 21 Query ALTER TABLE t1 DROP PRIMARY KEY, DROP KEY idx /* QNO 298 CON_ID 21 */ 18 Query CREATE OR REPLACE VIEW transforms.view_3564_probe AS CHECK TABLE t1 /* QNO 354 CON_ID 18 */ /* QNO 355 CON_ID 18 */ 18 Query DELETE FROM t1 WHERE MATCH(col4) AGAINST (TRIM(' 2 ') IN BOOLEAN MODE) OR col1 IS NULL /* QNO 356 CON_ID 18 */ 16 Query CREATE OR REPLACE VIEW transforms.view_12936_probe AS ALTER TABLE t1 DROP KEY uidx, ADD FULLTEXT KEY ftidx ( col4 ) /* QNO 396 CON_ID 16 */ /* QNO 397 CON_ID 16 */ 19 Query ROLLBACK /* QNO 293 CON_ID 19 */ 17 Query /* GenTest::Transform::DisableOptimizations */ SET @switch_saved = @@optimizer_switch /* QNO 316 CON_ID 17 */ 18 Query /* GenTest::Transform::DisableOptimizations */ SET @switch_saved = @@optimizer_switch /* QNO 357 CON_ID 18 */ 21 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES ( 1, 1, 1, REPEAT(CAST(1 AS CHAR(1)),@fill_amount)) /* QNO 299 CON_ID 21 */ 16 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES ( 4, 4, 4 - 1, REPEAT(CAST(4 AS CHAR(1)),@fill_amount)) /* QNO 398 CON_ID 16 */ 18 Query SET SESSION optimizer_switch = REPLACE( @@optimizer_switch, '=on', '=off' ) /* QNO 358 CON_ID 18 */ 17 Query SET SESSION optimizer_switch = REPLACE( @@optimizer_switch, '=on', '=off' ) /* QNO 317 CON_ID 17 */ 19 Query CREATE OR REPLACE VIEW transforms.view_8236_probe AS ROLLBACK /* QNO 293 CON_ID 19 */ /* QNO 294 CON_ID 19 */ 21 Query COMMIT /* QNO 300 CON_ID 21 */ 16 Query COMMIT /* QNO 399 CON_ID 16 */ 21 Query CREATE OR REPLACE VIEW transforms.view_4616_probe AS COMMIT /* QNO 300 CON_ID 21 */ /* QNO 301 CON_ID 21 */ 18 Query SET SESSION optimizer_switch = 'in_to_exists=on' /* QNO 359 CON_ID 18 */ 17 Query SET SESSION optimizer_switch = 'in_to_exists=on' /* QNO 318 CON_ID 17 */ 19 Query ALTER TABLE t1 DROP KEY ftidx /* QNO 295 CON_ID 19 */ 16 Query CREATE OR REPLACE VIEW transforms.view_12936_probe AS COMMIT /* QNO 399 CON_ID 16 */ /* QNO 400 CON_ID 16 */ 18 Query DELETE FROM t1 WHERE MATCH(col4) AGAINST (TRIM(' 2 ') IN BOOLEAN MODE) OR col1 IS NULL /* QNO 356 CON_ID 18 */ /* TRANSFORM_OUTCOME_UNORDERED_MATCH */ /* QNO 360 CON_ID 18 */ 21 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES ( 1, 1, 1, REPEAT(CAST(1 AS CHAR(1)),@fill_amount)) /* QNO 302 CON_ID 21 */ 17 Query DELETE FROM t1 WHERE col1 = 1 OR col1 IS NULL /* QNO 315 CON_ID 17 */ /* TRANSFORM_OUTCOME_UNORDERED_MATCH */ /* QNO 319 CON_ID 17 */ 16 Query ALTER TABLE t1 ADD UNIQUE KEY uidx ( col4(10), col1 ) /* QNO 401 CON_ID 16 */ 18 Query /* GenTest::Transform::DisableOptimizations */ /* TRANSFORM_CLEANUP */ SET SESSION optimizer_switch=@switch_saved /* QNO 361 CON_ID 18 */ 18 Query /* GenTest::Transform::EnableOptimizations */ SET @switch_saved = @@optimizer_switch /* QNO 362 CON_ID 18 */ 17 Query /* GenTest::Transform::DisableOptimizations */ /* TRANSFORM_CLEANUP */ SET SESSION optimizer_switch=@switch_saved /* QNO 320 CON_ID 17 */ 18 Query SET SESSION optimizer_switch = REPLACE( @@optimizer_switch, '=off', '=on' ) /* QNO 363 CON_ID 18 */ 18 Query SHOW WARNINGS 17 Query /* GenTest::Transform::EnableOptimizations */ SET @switch_saved = @@optimizer_switch /* QNO 321 CON_ID 17 */ 18 Query DELETE FROM t1 WHERE MATCH(col4) AGAINST (TRIM(' 2 ') IN BOOLEAN MODE) OR col1 IS NULL /* QNO 356 CON_ID 18 */ /* TRANSFORM_OUTCOME_UNORDERED_MATCH */ /* QNO 364 CON_ID 18 */ 17 Query SET SESSION optimizer_switch = REPLACE( @@optimizer_switch, '=off', '=on' ) /* QNO 322 CON_ID 17 */ 18 Query /* GenTest::Transform::EnableOptimizations */ /* TRANSFORM_CLEANUP */ SET SESSION optimizer_switch=@switch_saved /* QNO 365 CON_ID 18 */ 17 Query SHOW WARNINGS 17 Query DELETE FROM t1 WHERE col1 = 1 OR col1 IS NULL /* QNO 315 CON_ID 17 */ /* TRANSFORM_OUTCOME_UNORDERED_MATCH */ /* QNO 323 CON_ID 17 */ 17 Query /* GenTest::Transform::EnableOptimizations */ /* TRANSFORM_CLEANUP */ SET SESSION optimizer_switch=@switch_saved /* QNO 324 CON_ID 17 */ 17 Query CREATE OR REPLACE VIEW transforms.view_10968_probe AS DELETE FROM t1 WHERE col1 = 1 OR col1 IS NULL /* QNO 315 CON_ID 17 */ /* QNO 325 CON_ID 17 */ 17 Query COMMIT /* QNO 326 CON_ID 17 */ 18 Query CREATE OR REPLACE VIEW transforms.view_3564_probe AS DELETE FROM t1 WHERE MATCH(col4) AGAINST (TRIM(' 2 ') IN BOOLEAN MODE) OR col1 IS NULL /* QNO 356 CON_ID 18 */ /* QNO 366 CON_ID 18 */ 17 Query CREATE OR REPLACE VIEW transforms.view_10968_probe AS COMMIT /* QNO 326 CON_ID 17 */ /* QNO 327 CON_ID 17 */ 18 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES /* 3 */ (3,3,3,REPEAT(CAST(3 AS CHAR(1)),@fill_amount)), (3,3,3,REPEAT(CAST(3 AS CHAR(1)),@fill_amount)) /* QNO 367 CON_ID 18 */ 18 Query ROLLBACK /* QNO 368 CON_ID 18 */ 17 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES ( NULL, NULL, NULL, REPEAT(CAST(NULL - 1 AS CHAR(1)),@fill_amount)) /* QNO 328 CON_ID 17 */ 18 Query CREATE OR REPLACE VIEW transforms.view_3564_probe AS ROLLBACK /* QNO 368 CON_ID 18 */ /* QNO 369 CON_ID 18 */ 21 Query ROLLBACK /* QNO 303 CON_ID 21 */ 21 Query CREATE OR REPLACE VIEW transforms.view_4616_probe AS ROLLBACK /* QNO 303 CON_ID 21 */ /* QNO 304 CON_ID 21 */ 18 Query DELETE FROM t1 WHERE col1 = 4 OR col1 IS NULL /* QNO 370 CON_ID 18 */ 21 Query DELETE FROM t1 WHERE col3 = 3 OR col3 IS NULL /* QNO 305 CON_ID 21 */ 171012 18:12:55 21 Query /* GenTest::Transform::DisableOptimizations */ SET @switch_saved = @@optimizer_switch /* QNO 306 CON_ID 21 */ 19 Query CREATE OR REPLACE VIEW transforms.view_8236_probe AS ALTER TABLE t1 DROP KEY ftidx /* QNO 295 CON_ID 19 */ /* QNO 296 CON_ID 19 */ 18 Query /* GenTest::Transform::DisableOptimizations */ SET @switch_saved = @@optimizer_switch /* QNO 371 CON_ID 18 */ 17 Query COMMIT /* QNO 329 CON_ID 17 */ 21 Query SET SESSION optimizer_switch = REPLACE( @@optimizer_switch, '=on', '=off' ) /* QNO 307 CON_ID 21 */ 21 Query SET SESSION optimizer_switch = 'in_to_exists=on' /* QNO 308 CON_ID 21 */ 17 Query CREATE OR REPLACE VIEW transforms.view_10968_probe AS COMMIT /* QNO 329 CON_ID 17 */ /* QNO 330 CON_ID 17 */ 21 Query DELETE FROM t1 WHERE col3 = 3 OR col3 IS NULL /* QNO 305 CON_ID 21 */ /* TRANSFORM_OUTCOME_UNORDERED_MATCH */ /* QNO 309 CON_ID 21 */ 19 Query DELETE FROM t1 WHERE MATCH(col4) AGAINST (TRIM(' 2 ') IN BOOLEAN MODE) OR col2 IS NULL /* QNO 297 CON_ID 19 */ 18 Query SET SESSION optimizer_switch = REPLACE( @@optimizer_switch, '=on', '=off' ) /* QNO 372 CON_ID 18 */ 21 Query /* GenTest::Transform::DisableOptimizations */ /* TRANSFORM_CLEANUP */ SET SESSION optimizer_switch=@switch_saved /* QNO 310 CON_ID 21 */ 18 Query SET SESSION optimizer_switch = 'in_to_exists=on' /* QNO 373 CON_ID 18 */ 21 Query /* GenTest::Transform::EnableOptimizations */ SET @switch_saved = @@optimizer_switch /* QNO 311 CON_ID 21 */ 18 Query DELETE FROM t1 WHERE col1 = 4 OR col1 IS NULL /* QNO 370 CON_ID 18 */ /* TRANSFORM_OUTCOME_UNORDERED_MATCH */ /* QNO 374 CON_ID 18 */ 21 Query SET SESSION optimizer_switch = REPLACE( @@optimizer_switch, '=off', '=on' ) /* QNO 312 CON_ID 21 */ 18 Query /* GenTest::Transform::DisableOptimizations */ /* TRANSFORM_CLEANUP */ SET SESSION optimizer_switch=@switch_saved /* QNO 375 CON_ID 18 */ 21 Query SHOW WARNINGS 18 Query /* GenTest::Transform::EnableOptimizations */ SET @switch_saved = @@optimizer_switch /* QNO 376 CON_ID 18 */ 21 Query DELETE FROM t1 WHERE col3 = 3 OR col3 IS NULL /* QNO 305 CON_ID 21 */ /* TRANSFORM_OUTCOME_UNORDERED_MATCH */ /* QNO 313 CON_ID 21 */ 18 Query SET SESSION optimizer_switch = REPLACE( @@optimizer_switch, '=off', '=on' ) /* QNO 377 CON_ID 18 */ 21 Query /* GenTest::Transform::EnableOptimizations */ /* TRANSFORM_CLEANUP */ SET SESSION optimizer_switch=@switch_saved /* QNO 314 CON_ID 21 */ 18 Query SHOW WARNINGS 21 Query CREATE OR REPLACE VIEW transforms.view_4616_probe AS DELETE FROM t1 WHERE col3 = 3 OR col3 IS NULL /* QNO 305 CON_ID 21 */ /* QNO 315 CON_ID 21 */ 18 Query DELETE FROM t1 WHERE col1 = 4 OR col1 IS NULL /* QNO 370 CON_ID 18 */ /* TRANSFORM_OUTCOME_UNORDERED_MATCH */ /* QNO 378 CON_ID 18 */ 17 Query ALTER TABLE t1 DROP KEY uidx, DROP PRIMARY KEY /* QNO 331 CON_ID 17 */ 18 Query /* GenTest::Transform::EnableOptimizations */ /* TRANSFORM_CLEANUP */ SET SESSION optimizer_switch=@switch_saved /* QNO 379 CON_ID 18 */ 18 Query CREATE OR REPLACE VIEW transforms.view_3564_probe AS DELETE FROM t1 WHERE col1 = 4 OR col1 IS NULL /* QNO 370 CON_ID 18 */ /* QNO 380 CON_ID 18 */ 21 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES /* 2 */ (2,2,2,REPEAT(CAST(2 AS CHAR(1)),@fill_amount)), (2,2,2,REPEAT(CAST(2 AS CHAR(1)),@fill_amount)) /* QNO 316 CON_ID 21 */ 18 Query COMMIT /* QNO 381 CON_ID 18 */ 18 Query CREATE OR REPLACE VIEW transforms.view_3564_probe AS COMMIT /* QNO 381 CON_ID 18 */ /* QNO 382 CON_ID 18 */ 21 Query COMMIT /* QNO 317 CON_ID 21 */ 21 Query CREATE OR REPLACE VIEW transforms.view_4616_probe AS COMMIT /* QNO 317 CON_ID 21 */ /* QNO 318 CON_ID 21 */ 18 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES ( 1, 1, 1, REPEAT(CAST(1 AS CHAR(1)),@fill_amount)) /* QNO 383 CON_ID 18 */ 21 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES ( 2, 2 - 1, 2, REPEAT(CAST(2 AS CHAR(1)),@fill_amount)) /* QNO 319 CON_ID 21 */ 19 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES /* 2 */ (2,2,2,REPEAT(CAST(2 AS CHAR(1)),@fill_amount)), (2,2,2,REPEAT(CAST(2 AS CHAR(1)),@fill_amount)) /* QNO 298 CON_ID 19 */ 18 Query ROLLBACK /* QNO 384 CON_ID 18 */ 21 Query ROLLBACK /* QNO 320 CON_ID 21 */ 19 Query ROLLBACK /* QNO 299 CON_ID 19 */ 18 Query CREATE OR REPLACE VIEW transforms.view_3564_probe AS ROLLBACK /* QNO 384 CON_ID 18 */ /* QNO 385 CON_ID 18 */ 21 Query CREATE OR REPLACE VIEW transforms.view_4616_probe AS ROLLBACK /* QNO 320 CON_ID 21 */ /* QNO 321 CON_ID 21 */ 18 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES ( 1, 1, 1, REPEAT(CAST(1 AS CHAR(1)),@fill_amount)) /* QNO 386 CON_ID 18 */ 19 Query CREATE OR REPLACE VIEW transforms.view_8236_probe AS ROLLBACK /* QNO 299 CON_ID 19 */ /* QNO 300 CON_ID 19 */ 21 Query ALTER TABLE t1 ADD COLUMN extra INT /* QNO 322 CON_ID 21 */ 19 Query DELETE FROM t1 WHERE MATCH(col4) AGAINST (TRIM(' 1 ') IN BOOLEAN MODE) OR col3 IS NULL /* QNO 301 CON_ID 19 */ 16 Query CREATE OR REPLACE VIEW transforms.view_12936_probe AS ALTER TABLE t1 ADD UNIQUE KEY uidx ( col4(10), col1 ) /* QNO 401 CON_ID 16 */ /* QNO 402 CON_ID 16 */ 18 Query COMMIT /* QNO 387 CON_ID 18 */ 19 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES /* 1 */ (1,1,1,REPEAT(CAST(1 AS CHAR(1)),@fill_amount)), (1,1,1,REPEAT(CAST(1 AS CHAR(1)),@fill_amount)) /* QNO 302 CON_ID 19 */ 17 Query ALTER TABLE t1 ADD PRIMARY KEY ( col2 ) /* QNO 332 CON_ID 17 */ 18 Query CREATE OR REPLACE VIEW transforms.view_3564_probe AS COMMIT /* QNO 387 CON_ID 18 */ /* QNO 388 CON_ID 18 */ 16 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES ( 3, 3, 3 - 1, REPEAT(CAST(3 AS CHAR(1)),@fill_amount)) /* QNO 403 CON_ID 16 */ 19 Query COMMIT /* QNO 303 CON_ID 19 */ 19 Query CREATE OR REPLACE VIEW transforms.view_8236_probe AS COMMIT /* QNO 303 CON_ID 19 */ /* QNO 304 CON_ID 19 */ 18 Query ALTER TABLE t1 DROP PRIMARY KEY, DROP KEY uidx /* QNO 389 CON_ID 18 */ 19 Query UPDATE t1 SET col3 = 2 LIMIT 2 /* QNO 305 CON_ID 19 */ 16 Query COMMIT /* QNO 404 CON_ID 16 */ 16 Query CREATE OR REPLACE VIEW transforms.view_12936_probe AS COMMIT /* QNO 404 CON_ID 16 */ /* QNO 405 CON_ID 16 */ 19 Query /* GenTest::Transform::DisableOptimizations */ SET @switch_saved = @@optimizer_switch /* QNO 306 CON_ID 19 */ 19 Query SET SESSION optimizer_switch = REPLACE( @@optimizer_switch, '=on', '=off' ) /* QNO 307 CON_ID 19 */ 19 Query SET SESSION optimizer_switch = 'in_to_exists=on' /* QNO 308 CON_ID 19 */ 19 Query UPDATE t1 SET col3 = 2 LIMIT 2 /* QNO 305 CON_ID 19 */ /* TRANSFORM_OUTCOME_UNORDERED_MATCH */ /* QNO 309 CON_ID 19 */ 19 Query /* GenTest::Transform::DisableOptimizations */ /* TRANSFORM_CLEANUP */ SET SESSION optimizer_switch=@switch_saved /* QNO 310 CON_ID 19 */ 19 Query /* GenTest::Transform::EnableOptimizations */ SET @switch_saved = @@optimizer_switch /* QNO 311 CON_ID 19 */ 16 Query UPDATE t1 SET col2 = 3 LIMIT 2 /* QNO 406 CON_ID 16 */ 19 Query SET SESSION optimizer_switch = REPLACE( @@optimizer_switch, '=off', '=on' ) /* QNO 312 CON_ID 19 */ 19 Query SHOW WARNINGS 19 Query UPDATE t1 SET col3 = 2 LIMIT 2 /* QNO 305 CON_ID 19 */ /* TRANSFORM_OUTCOME_UNORDERED_MATCH */ /* QNO 313 CON_ID 19 */ 19 Query /* GenTest::Transform::EnableOptimizations */ /* TRANSFORM_CLEANUP */ SET SESSION optimizer_switch=@switch_saved /* QNO 314 CON_ID 19 */ 19 Query CREATE OR REPLACE VIEW transforms.view_8236_probe AS UPDATE t1 SET col3 = 2 LIMIT 2 /* QNO 305 CON_ID 19 */ /* QNO 315 CON_ID 19 */ 19 Query COMMIT /* QNO 316 CON_ID 19 */ 19 Query CREATE OR REPLACE VIEW transforms.view_8236_probe AS COMMIT /* QNO 316 CON_ID 19 */ /* QNO 317 CON_ID 19 */ 19 Query ALTER TABLE t1 ADD PRIMARY KEY ( col4(10) ) /* QNO 318 CON_ID 19 */ 17 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES ( 3, 3, 3 - 1, REPEAT(CAST(3 AS CHAR(1)),@fill_amount)) /* QNO 333 CON_ID 17 */ 16 Query ROLLBACK /* QNO 407 CON_ID 16 */ 18 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES ( 2, 2, 2, REPEAT(CAST(2 - 1 AS CHAR(1)),@fill_amount)) /* QNO 390 CON_ID 18 */ 21 Query CREATE OR REPLACE VIEW transforms.view_4616_probe AS ALTER TABLE t1 ADD COLUMN extra INT /* QNO 322 CON_ID 21 */ /* QNO 323 CON_ID 21 */ 16 Query CREATE OR REPLACE VIEW transforms.view_12936_probe AS ROLLBACK /* QNO 407 CON_ID 16 */ /* QNO 408 CON_ID 16 */ 21 Query UPDATE t1 SET extra = col2 /* QNO 324 CON_ID 21 */ 17 Query ROLLBACK /* QNO 334 CON_ID 17 */ 16 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES ( 2, 2, 2, REPEAT(CAST(2 - 1 AS CHAR(1)),@fill_amount)) /* QNO 409 CON_ID 16 */ 17 Query CREATE OR REPLACE VIEW transforms.view_10968_probe AS ROLLBACK /* QNO 334 CON_ID 17 */ /* QNO 335 CON_ID 17 */ 17 Query ALTER TABLE t1 DROP KEY ftidx /* QNO 336 CON_ID 17 */ 18 Query ROLLBACK /* QNO 391 CON_ID 18 */ 21 Query ALTER TABLE t1 DROP COLUMN col2 /* QNO 325 CON_ID 21 */ 16 Query ROLLBACK /* QNO 410 CON_ID 16 */ 18 Query CREATE OR REPLACE VIEW transforms.view_3564_probe AS ROLLBACK /* QNO 391 CON_ID 18 */ /* QNO 392 CON_ID 18 */ 18 Query DELETE FROM t1 WHERE col1 = 4 OR col1 IS NULL /* QNO 393 CON_ID 18 */ 16 Query CREATE OR REPLACE VIEW transforms.view_12936_probe AS ROLLBACK /* QNO 410 CON_ID 16 */ /* QNO 411 CON_ID 16 */ 16 Query UPDATE t1 SET col3 = 3 LIMIT 2 /* QNO 412 CON_ID 16 */ 19 Query CREATE OR REPLACE VIEW transforms.view_8236_probe AS ALTER TABLE t1 ADD PRIMARY KEY ( col4(10) ) /* QNO 318 CON_ID 19 */ /* QNO 319 CON_ID 19 */ 16 Query /* GenTest::Transform::DisableOptimizations */ SET @switch_saved = @@optimizer_switch /* QNO 413 CON_ID 16 */ 18 Query /* GenTest::Transform::DisableOptimizations */ SET @switch_saved = @@optimizer_switch /* QNO 394 CON_ID 18 */ 18 Query SET SESSION optimizer_switch = REPLACE( @@optimizer_switch, '=on', '=off' ) /* QNO 395 CON_ID 18 */ 16 Query SET SESSION optimizer_switch = REPLACE( @@optimizer_switch, '=on', '=off' ) /* QNO 414 CON_ID 16 */ 21 Query ALTER TABLE t1 CHANGE COLUMN extra col2 INT /* QNO 326 CON_ID 21 */ 19 Query ALTER TABLE t1 ADD KEY idx ( col4(10), col1 ) /* QNO 320 CON_ID 19 */ 17 Query DELETE FROM t1 WHERE col1 = 1 OR col1 IS NULL /* QNO 337 CON_ID 17 */ 16 Query SET SESSION optimizer_switch = 'in_to_exists=on' /* QNO 415 CON_ID 16 */ 18 Query SET SESSION optimizer_switch = 'in_to_exists=on' /* QNO 396 CON_ID 18 */ 18 Query DELETE FROM t1 WHERE col1 = 4 OR col1 IS NULL /* QNO 393 CON_ID 18 */ /* TRANSFORM_OUTCOME_UNORDERED_MATCH */ /* QNO 397 CON_ID 18 */ 16 Query UPDATE t1 SET col3 = 3 LIMIT 2 /* QNO 412 CON_ID 16 */ /* TRANSFORM_OUTCOME_UNORDERED_MATCH */ /* QNO 416 CON_ID 16 */ 16 Query /* GenTest::Transform::DisableOptimizations */ /* TRANSFORM_CLEANUP */ SET SESSION optimizer_switch=@switch_saved /* QNO 417 CON_ID 16 */ 18 Query /* GenTest::Transform::DisableOptimizations */ /* TRANSFORM_CLEANUP */ SET SESSION optimizer_switch=@switch_saved /* QNO 398 CON_ID 18 */ 16 Query /* GenTest::Transform::EnableOptimizations */ SET @switch_saved = @@optimizer_switch /* QNO 418 CON_ID 16 */ 18 Query /* GenTest::Transform::EnableOptimizations */ SET @switch_saved = @@optimizer_switch /* QNO 399 CON_ID 18 */ 16 Query SET SESSION optimizer_switch = REPLACE( @@optimizer_switch, '=off', '=on' ) /* QNO 419 CON_ID 16 */ 18 Query SET SESSION optimizer_switch = REPLACE( @@optimizer_switch, '=off', '=on' ) /* QNO 400 CON_ID 18 */ 16 Query SHOW WARNINGS 18 Query SHOW WARNINGS 17 Query /* GenTest::Transform::DisableOptimizations */ SET @switch_saved = @@optimizer_switch /* QNO 338 CON_ID 17 */ 18 Query DELETE FROM t1 WHERE col1 = 4 OR col1 IS NULL /* QNO 393 CON_ID 18 */ /* TRANSFORM_OUTCOME_UNORDERED_MATCH */ /* QNO 401 CON_ID 18 */ 17 Query SET SESSION optimizer_switch = REPLACE( @@optimizer_switch, '=on', '=off' ) /* QNO 339 CON_ID 17 */ 16 Query UPDATE t1 SET col3 = 3 LIMIT 2 /* QNO 412 CON_ID 16 */ /* TRANSFORM_OUTCOME_UNORDERED_MATCH */ /* QNO 420 CON_ID 16 */ 17 Query SET SESSION optimizer_switch = 'in_to_exists=on' /* QNO 340 CON_ID 17 */ 17 Query DELETE FROM t1 WHERE col1 = 1 OR col1 IS NULL /* QNO 337 CON_ID 17 */ /* TRANSFORM_OUTCOME_UNORDERED_MATCH */ /* QNO 341 CON_ID 17 */ 18 Query /* GenTest::Transform::EnableOptimizations */ /* TRANSFORM_CLEANUP */ SET SESSION optimizer_switch=@switch_saved /* QNO 402 CON_ID 18 */ 17 Query /* GenTest::Transform::DisableOptimizations */ /* TRANSFORM_CLEANUP */ SET SESSION optimizer_switch=@switch_saved /* QNO 342 CON_ID 17 */ 16 Query /* GenTest::Transform::EnableOptimizations */ /* TRANSFORM_CLEANUP */ SET SESSION optimizer_switch=@switch_saved /* QNO 421 CON_ID 16 */ 18 Query CREATE OR REPLACE VIEW transforms.view_3564_probe AS DELETE FROM t1 WHERE col1 = 4 OR col1 IS NULL /* QNO 393 CON_ID 18 */ /* QNO 403 CON_ID 18 */ 17 Query /* GenTest::Transform::EnableOptimizations */ SET @switch_saved = @@optimizer_switch /* QNO 343 CON_ID 17 */ 16 Query CREATE OR REPLACE VIEW transforms.view_12936_probe AS UPDATE t1 SET col3 = 3 LIMIT 2 /* QNO 412 CON_ID 16 */ /* QNO 422 CON_ID 16 */ 18 Query COMMIT /* QNO 404 CON_ID 18 */ 18 Query CREATE OR REPLACE VIEW transforms.view_3564_probe AS COMMIT /* QNO 404 CON_ID 18 */ /* QNO 405 CON_ID 18 */ 16 Query ROLLBACK /* QNO 423 CON_ID 16 */ 17 Query SET SESSION optimizer_switch = REPLACE( @@optimizer_switch, '=off', '=on' ) /* QNO 344 CON_ID 17 */ 16 Query CREATE OR REPLACE VIEW transforms.view_12936_probe AS ROLLBACK /* QNO 423 CON_ID 16 */ /* QNO 424 CON_ID 16 */ 18 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES ( 1, 1 - 1, 1, REPEAT(CAST(1 AS CHAR(1)),@fill_amount)) /* QNO 406 CON_ID 18 */ 17 Query SHOW WARNINGS 17 Query DELETE FROM t1 WHERE col1 = 1 OR col1 IS NULL /* QNO 337 CON_ID 17 */ /* TRANSFORM_OUTCOME_UNORDERED_MATCH */ /* QNO 345 CON_ID 17 */ 16 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES ( 4, 4 - 1, 4, REPEAT(CAST(4 AS CHAR(1)),@fill_amount)) /* QNO 425 CON_ID 16 */ 17 Query /* GenTest::Transform::EnableOptimizations */ /* TRANSFORM_CLEANUP */ SET SESSION optimizer_switch=@switch_saved /* QNO 346 CON_ID 17 */ 17 Query CREATE OR REPLACE VIEW transforms.view_10968_probe AS DELETE FROM t1 WHERE col1 = 1 OR col1 IS NULL /* QNO 337 CON_ID 17 */ /* QNO 347 CON_ID 17 */ 17 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES /* 1 */ (1,1,1,REPEAT(CAST(1 AS CHAR(1)),@fill_amount)), (1,1,1,REPEAT(CAST(1 AS CHAR(1)),@fill_amount)) /* QNO 348 CON_ID 17 */ 17 Query COMMIT /* QNO 349 CON_ID 17 */ 17 Query CREATE OR REPLACE VIEW transforms.view_10968_probe AS COMMIT /* QNO 349 CON_ID 17 */ /* QNO 350 CON_ID 17 */ 18 Query ROLLBACK /* QNO 407 CON_ID 18 */ 18 Query CREATE OR REPLACE VIEW transforms.view_3564_probe AS ROLLBACK /* QNO 407 CON_ID 18 */ /* QNO 408 CON_ID 18 */ 18 Query ALTER TABLE t1 ADD KEY idx ( col1 ) /* QNO 409 CON_ID 18 */ 17 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES ( 4, 4 - 1, 4, REPEAT(CAST(4 AS CHAR(1)),@fill_amount)) /* QNO 351 CON_ID 17 */ 16 Query COMMIT /* QNO 426 CON_ID 16 */ 16 Query CREATE OR REPLACE VIEW transforms.view_12936_probe AS COMMIT /* QNO 426 CON_ID 16 */ /* QNO 427 CON_ID 16 */ 16 Query ALTER TABLE t1 DROP KEY ftidx /* QNO 428 CON_ID 16 */ 21 Query CREATE OR REPLACE VIEW transforms.view_4616_probe AS ALTER TABLE t1 CHANGE COLUMN extra col2 INT /* QNO 326 CON_ID 21 */ /* QNO 327 CON_ID 21 */ 17 Query CREATE OR REPLACE VIEW transforms.view_10968_probe AS INSERT INTO t1 (col1,col2,col3,col4) VALUES ( 4, 4 - 1, 4, REPEAT(CAST(4 AS CHAR(1)),@fill_amount)) /* QNO 351 CON_ID 17 */ /* QNO 352 CON_ID 17 */ 17 Query ROLLBACK /* QNO 353 CON_ID 17 */ 21 Query UPDATE t1 SET col2 = 4 LIMIT 2 /* QNO 328 CON_ID 21 */ 17 Query CREATE OR REPLACE VIEW transforms.view_10968_probe AS ROLLBACK /* QNO 353 CON_ID 17 */ /* QNO 354 CON_ID 17 */ 17 Query ALTER TABLE t1 ADD KEY idx ( col4(10), col2 ) /* QNO 355 CON_ID 17 */ 21 Query /* GenTest::Transform::DisableOptimizations */ SET @switch_saved = @@optimizer_switch /* QNO 329 CON_ID 21 */ 21 Query SET SESSION optimizer_switch = REPLACE( @@optimizer_switch, '=on', '=off' ) /* QNO 330 CON_ID 21 */ 21 Query SET SESSION optimizer_switch = 'in_to_exists=on' /* QNO 331 CON_ID 21 */ 21 Query UPDATE t1 SET col2 = 4 LIMIT 2 /* QNO 328 CON_ID 21 */ /* TRANSFORM_OUTCOME_UNORDERED_MATCH */ /* QNO 332 CON_ID 21 */ 21 Query /* GenTest::Transform::DisableOptimizations */ /* TRANSFORM_CLEANUP */ SET SESSION optimizer_switch=@switch_saved /* QNO 333 CON_ID 21 */ 21 Query /* GenTest::Transform::EnableOptimizations */ SET @switch_saved = @@optimizer_switch /* QNO 334 CON_ID 21 */ 21 Query SET SESSION optimizer_switch = REPLACE( @@optimizer_switch, '=off', '=on' ) /* QNO 335 CON_ID 21 */ 21 Query SHOW WARNINGS 21 Query UPDATE t1 SET col2 = 4 LIMIT 2 /* QNO 328 CON_ID 21 */ /* TRANSFORM_OUTCOME_UNORDERED_MATCH */ /* QNO 336 CON_ID 21 */ 21 Query /* GenTest::Transform::EnableOptimizations */ /* TRANSFORM_CLEANUP */ SET SESSION optimizer_switch=@switch_saved /* QNO 337 CON_ID 21 */ 21 Query CREATE OR REPLACE VIEW transforms.view_4616_probe AS UPDATE t1 SET col2 = 4 LIMIT 2 /* QNO 328 CON_ID 21 */ /* QNO 338 CON_ID 21 */ 21 Query COMMIT /* QNO 339 CON_ID 21 */ 21 Query CREATE OR REPLACE VIEW transforms.view_4616_probe AS COMMIT /* QNO 339 CON_ID 21 */ /* QNO 340 CON_ID 21 */ 21 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES ( 4, 4, 4 - 1, REPEAT(CAST(4 AS CHAR(1)),@fill_amount)) /* QNO 341 CON_ID 21 */ 18 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES ( 1, 1 - 1, 1, REPEAT(CAST(1 AS CHAR(1)),@fill_amount)) /* QNO 410 CON_ID 18 */ 16 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES ( 1, 1, 1, REPEAT(CAST(1 - 1 AS CHAR(1)),@fill_amount)) /* QNO 429 CON_ID 16 */ 19 Query CREATE OR REPLACE VIEW transforms.view_8236_probe AS ALTER TABLE t1 ADD KEY idx ( col4(10), col1 ) /* QNO 320 CON_ID 19 */ /* QNO 321 CON_ID 19 */ 19 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES ( 4, 4 - 1, 4, REPEAT(CAST(4 AS CHAR(1)),@fill_amount)) /* QNO 322 CON_ID 19 */ 17 Query ALTER TABLE t1 DROP KEY idx, DROP KEY idx /* QNO 356 CON_ID 17 */ 21 Query CREATE OR REPLACE VIEW transforms.view_4616_probe AS INSERT INTO t1 (col1,col2,col3,col4) VALUES ( 4, 4, 4 - 1, REPEAT(CAST(4 AS CHAR(1)),@fill_amount)) /* QNO 341 CON_ID 21 */ /* QNO 342 CON_ID 21 */ 18 Query CREATE OR REPLACE VIEW transforms.view_3564_probe AS INSERT INTO t1 (col1,col2,col3,col4) VALUES ( 1, 1 - 1, 1, REPEAT(CAST(1 AS CHAR(1)),@fill_amount)) /* QNO 410 CON_ID 18 */ /* QNO 411 CON_ID 18 */ 21 Query ROLLBACK /* QNO 343 CON_ID 21 */ 17 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES ( 2, 2, 2, REPEAT(CAST(2 - 1 AS CHAR(1)),@fill_amount)) /* QNO 357 CON_ID 17 */ 18 Query ROLLBACK /* QNO 412 CON_ID 18 */ 16 Query CREATE OR REPLACE VIEW transforms.view_12936_probe AS INSERT INTO t1 (col1,col2,col3,col4) VALUES ( 1, 1, 1, REPEAT(CAST(1 - 1 AS CHAR(1)),@fill_amount)) /* QNO 429 CON_ID 16 */ /* QNO 430 CON_ID 16 */ 16 Query COMMIT /* QNO 431 CON_ID 16 */ 19 Query CREATE OR REPLACE VIEW transforms.view_8236_probe AS INSERT INTO t1 (col1,col2,col3,col4) VALUES ( 4, 4 - 1, 4, REPEAT(CAST(4 AS CHAR(1)),@fill_amount)) /* QNO 322 CON_ID 19 */ /* QNO 323 CON_ID 19 */ 19 Query ROLLBACK /* QNO 324 CON_ID 19 */ 17 Query CREATE OR REPLACE VIEW transforms.view_10968_probe AS INSERT INTO t1 (col1,col2,col3,col4) VALUES ( 2, 2, 2, REPEAT(CAST(2 - 1 AS CHAR(1)),@fill_amount)) /* QNO 357 CON_ID 17 */ /* QNO 358 CON_ID 17 */ 16 Query CREATE OR REPLACE VIEW transforms.view_12936_probe AS COMMIT /* QNO 431 CON_ID 16 */ /* QNO 432 CON_ID 16 */ 17 Query ROLLBACK /* QNO 359 CON_ID 17 */ 16 Query DELETE FROM t1 WHERE MATCH(col4) AGAINST (TRIM(' 3 ') IN BOOLEAN MODE) OR col2 IS NULL /* QNO 433 CON_ID 16 */ 16 Query COMMIT /* QNO 434 CON_ID 16 */ 16 Query CREATE OR REPLACE VIEW transforms.view_12936_probe AS COMMIT /* QNO 434 CON_ID 16 */ /* QNO 435 CON_ID 16 */ 16 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES ( 2, 2 - 1, 2, REPEAT(CAST(2 AS CHAR(1)),@fill_amount)) /* QNO 436 CON_ID 16 */ 16 Query CREATE OR REPLACE VIEW transforms.view_12936_probe AS INSERT INTO t1 (col1,col2,col3,col4) VALUES ( 2, 2 - 1, 2, REPEAT(CAST(2 AS CHAR(1)),@fill_amount)) /* QNO 436 CON_ID 16 */ /* QNO 437 CON_ID 16 */ 18 Query CREATE OR REPLACE VIEW transforms.view_3564_probe AS ROLLBACK /* QNO 412 CON_ID 18 */ /* QNO 413 CON_ID 18 */ 19 Query CREATE OR REPLACE VIEW transforms.view_8236_probe AS ROLLBACK /* QNO 324 CON_ID 19 */ /* QNO 325 CON_ID 19 */ 16 Query ROLLBACK /* QNO 438 CON_ID 16 */ 21 Query CREATE OR REPLACE VIEW transforms.view_4616_probe AS ROLLBACK /* QNO 343 CON_ID 21 */ /* QNO 344 CON_ID 21 */ 18 Query ALTER TABLE t1 ADD PRIMARY KEY ( col2 ) /* QNO 414 CON_ID 18 */ 19 Query ALTER TABLE t1 ADD COLUMN extra INT /* QNO 326 CON_ID 19 */ 18 Query UPDATE t1 SET col1 = 4 LIMIT 2 /* QNO 415 CON_ID 18 */ 21 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES ( 1, 1, 1, REPEAT(CAST(1 AS CHAR(1)),@fill_amount)) /* QNO 345 CON_ID 21 */ 17 Query CREATE OR REPLACE VIEW transforms.view_10968_probe AS ROLLBACK /* QNO 359 CON_ID 17 */ /* QNO 360 CON_ID 17 */ 17 Query ALTER TABLE t1 ADD KEY idx ( col1 ) /* QNO 361 CON_ID 17 */ 16 Query CREATE OR REPLACE VIEW transforms.view_12936_probe AS ROLLBACK /* QNO 438 CON_ID 16 */ /* QNO 439 CON_ID 16 */ 16 Query CHECK TABLE t1 /* QNO 440 CON_ID 16 */ 171012 18:12:56 18 Query /* GenTest::Transform::DisableOptimizations */ SET @switch_saved = @@optimizer_switch /* QNO 416 CON_ID 18 */ 18 Query SET SESSION optimizer_switch = REPLACE( @@optimizer_switch, '=on', '=off' ) /* QNO 417 CON_ID 18 */ 18 Query SET SESSION optimizer_switch = 'in_to_exists=on' /* QNO 418 CON_ID 18 */ 18 Query UPDATE t1 SET col1 = 4 LIMIT 2 /* QNO 415 CON_ID 18 */ /* TRANSFORM_OUTCOME_UNORDERED_MATCH */ /* QNO 419 CON_ID 18 */ 18 Query /* GenTest::Transform::DisableOptimizations */ /* TRANSFORM_CLEANUP */ SET SESSION optimizer_switch=@switch_saved /* QNO 420 CON_ID 18 */ 18 Query /* GenTest::Transform::EnableOptimizations */ SET @switch_saved = @@optimizer_switch /* QNO 421 CON_ID 18 */ 18 Query SET SESSION optimizer_switch = REPLACE( @@optimizer_switch, '=off', '=on' ) /* QNO 422 CON_ID 18 */ 18 Query SHOW WARNINGS 18 Query UPDATE t1 SET col1 = 4 LIMIT 2 /* QNO 415 CON_ID 18 */ /* TRANSFORM_OUTCOME_UNORDERED_MATCH */ /* QNO 423 CON_ID 18 */ 18 Query /* GenTest::Transform::EnableOptimizations */ /* TRANSFORM_CLEANUP */ SET SESSION optimizer_switch=@switch_saved /* QNO 424 CON_ID 18 */ 18 Query CREATE OR REPLACE VIEW transforms.view_3564_probe AS UPDATE t1 SET col1 = 4 LIMIT 2 /* QNO 415 CON_ID 18 */ /* QNO 425 CON_ID 18 */ 18 Query ROLLBACK /* QNO 426 CON_ID 18 */ 21 Query CREATE OR REPLACE VIEW transforms.view_4616_probe AS INSERT INTO t1 (col1,col2,col3,col4) VALUES ( 1, 1, 1, REPEAT(CAST(1 AS CHAR(1)),@fill_amount)) /* QNO 345 CON_ID 21 */ /* QNO 346 CON_ID 21 */ 21 Query ROLLBACK /* QNO 347 CON_ID 21 */ 18 Query CREATE OR REPLACE VIEW transforms.view_3564_probe AS ROLLBACK /* QNO 426 CON_ID 18 */ /* QNO 427 CON_ID 18 */ 18 Query ALTER TABLE t1 DROP KEY ftidx, DROP PRIMARY KEY /* QNO 428 CON_ID 18 */ 21 Query CREATE OR REPLACE VIEW transforms.view_4616_probe AS ROLLBACK /* QNO 347 CON_ID 21 */ /* QNO 348 CON_ID 21 */ 21 Query ALTER TABLE t1 DROP KEY ftidx, ADD UNIQUE KEY uidx ( col2 ) /* QNO 349 CON_ID 21 */ 17 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES ( 4, 4, 4, REPEAT(CAST(4 AS CHAR(1)),@fill_amount)) /* QNO 362 CON_ID 17 */ 19 Query CREATE OR REPLACE VIEW transforms.view_8236_probe AS ALTER TABLE t1 ADD COLUMN extra INT /* QNO 326 CON_ID 19 */ /* QNO 327 CON_ID 19 */ 18 Query DELETE FROM t1 WHERE col1 = NULL OR col1 IS NULL /* QNO 429 CON_ID 18 */ 18 Query /* GenTest::Transform::DisableOptimizations */ SET @switch_saved = @@optimizer_switch /* QNO 430 CON_ID 18 */ 18 Query SET SESSION optimizer_switch = REPLACE( @@optimizer_switch, '=on', '=off' ) /* QNO 431 CON_ID 18 */ 18 Query SET SESSION optimizer_switch = 'in_to_exists=on' /* QNO 432 CON_ID 18 */ 21 Query DELETE FROM t1 WHERE MATCH(col4) AGAINST (TRIM(' 2 ') IN BOOLEAN MODE) OR col3 IS NULL /* QNO 350 CON_ID 21 */ 19 Query UPDATE t1 SET extra = col3 /* QNO 328 CON_ID 19 */ 21 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES /* 4 */ (4,4,4,REPEAT(CAST(4 AS CHAR(1)),@fill_amount)), (4,4,4,REPEAT(CAST(4 AS CHAR(1)),@fill_amount)) /* QNO 351 CON_ID 21 */ 18 Query DELETE FROM t1 WHERE col1 = NULL OR col1 IS NULL /* QNO 429 CON_ID 18 */ /* TRANSFORM_OUTCOME_UNORDERED_MATCH */ /* QNO 433 CON_ID 18 */ 18 Query /* GenTest::Transform::DisableOptimizations */ /* TRANSFORM_CLEANUP */ SET SESSION optimizer_switch=@switch_saved /* QNO 434 CON_ID 18 */ 18 Query /* GenTest::Transform::EnableOptimizations */ SET @switch_saved = @@optimizer_switch /* QNO 435 CON_ID 18 */ 18 Query SET SESSION optimizer_switch = REPLACE( @@optimizer_switch, '=off', '=on' ) /* QNO 436 CON_ID 18 */ 17 Query CREATE OR REPLACE VIEW transforms.view_10968_probe AS INSERT INTO t1 (col1,col2,col3,col4) VALUES ( 4, 4, 4, REPEAT(CAST(4 AS CHAR(1)),@fill_amount)) /* QNO 362 CON_ID 17 */ /* QNO 363 CON_ID 17 */ 18 Query SHOW WARNINGS 18 Query DELETE FROM t1 WHERE col1 = NULL OR col1 IS NULL /* QNO 429 CON_ID 18 */ /* TRANSFORM_OUTCOME_UNORDERED_MATCH */ /* QNO 437 CON_ID 18 */ 17 Query COMMIT /* QNO 364 CON_ID 17 */ 18 Query /* GenTest::Transform::EnableOptimizations */ /* TRANSFORM_CLEANUP */ SET SESSION optimizer_switch=@switch_saved /* QNO 438 CON_ID 18 */ 18 Query CREATE OR REPLACE VIEW transforms.view_3564_probe AS DELETE FROM t1 WHERE col1 = NULL OR col1 IS NULL /* QNO 429 CON_ID 18 */ /* QNO 439 CON_ID 18 */ 18 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES /* 4 */ (4,4,4,REPEAT(CAST(4 AS CHAR(1)),@fill_amount)), (4,4,4,REPEAT(CAST(4 AS CHAR(1)),@fill_amount)) /* QNO 440 CON_ID 18 */ 19 Query /* GenTest::Transform::DisableOptimizations */ SET @switch_saved = @@optimizer_switch /* QNO 329 CON_ID 19 */ 19 Query SET SESSION optimizer_switch = REPLACE( @@optimizer_switch, '=on', '=off' ) /* QNO 330 CON_ID 19 */ 19 Query SET SESSION optimizer_switch = 'in_to_exists=on' /* QNO 331 CON_ID 19 */ 19 Query UPDATE t1 SET extra = col3 /* QNO 328 CON_ID 19 */ /* TRANSFORM_OUTCOME_UNORDERED_MATCH */ /* QNO 332 CON_ID 19 */ 19 Query /* GenTest::Transform::DisableOptimizations */ /* TRANSFORM_CLEANUP */ SET SESSION optimizer_switch=@switch_saved /* QNO 333 CON_ID 19 */ 19 Query /* GenTest::Transform::EnableOptimizations */ SET @switch_saved = @@optimizer_switch /* QNO 334 CON_ID 19 */ 19 Query SET SESSION optimizer_switch = REPLACE( @@optimizer_switch, '=off', '=on' ) /* QNO 335 CON_ID 19 */ 19 Query SHOW WARNINGS 19 Query UPDATE t1 SET extra = col3 /* QNO 328 CON_ID 19 */ /* TRANSFORM_OUTCOME_UNORDERED_MATCH */ /* QNO 336 CON_ID 19 */ 17 Query CREATE OR REPLACE VIEW transforms.view_10968_probe AS COMMIT /* QNO 364 CON_ID 17 */ /* QNO 365 CON_ID 17 */ 19 Query /* GenTest::Transform::EnableOptimizations */ /* TRANSFORM_CLEANUP */ SET SESSION optimizer_switch=@switch_saved /* QNO 337 CON_ID 19 */ 17 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES ( 4, 4, 4, REPEAT(CAST(4 - 1 AS CHAR(1)),@fill_amount)) /* QNO 366 CON_ID 17 */ 19 Query CREATE OR REPLACE VIEW transforms.view_8236_probe AS UPDATE t1 SET extra = col3 /* QNO 328 CON_ID 19 */ /* QNO 338 CON_ID 19 */ 19 Query ALTER TABLE t1 DROP COLUMN col3 /* QNO 339 CON_ID 19 */ 17 Query CREATE OR REPLACE VIEW transforms.view_10968_probe AS INSERT INTO t1 (col1,col2,col3,col4) VALUES ( 4, 4, 4, REPEAT(CAST(4 - 1 AS CHAR(1)),@fill_amount)) /* QNO 366 CON_ID 17 */ /* QNO 367 CON_ID 17 */ 16 Query CREATE OR REPLACE VIEW transforms.view_12936_probe AS CHECK TABLE t1 /* QNO 440 CON_ID 16 */ /* QNO 441 CON_ID 16 */ 17 Query ROLLBACK /* QNO 368 CON_ID 17 */ 16 Query ALTER TABLE `table0_int` ADD KEY rkr_index_16 ( `col_int`, `pk` ) /* QNO 442 CON_ID 16 */ 21 Query ROLLBACK /* QNO 352 CON_ID 21 */ 21 Query CREATE OR REPLACE VIEW transforms.view_4616_probe AS ROLLBACK /* QNO 352 CON_ID 21 */ /* QNO 353 CON_ID 21 */ 17 Query CREATE OR REPLACE VIEW transforms.view_10968_probe AS ROLLBACK /* QNO 368 CON_ID 17 */ /* QNO 369 CON_ID 17 */ 17 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES ( 3, 3 - 1, 3, REPEAT(CAST(3 AS CHAR(1)),@fill_amount)) /* QNO 370 CON_ID 17 */ 21 Query DELETE FROM t1 WHERE col1 = 3 OR col1 IS NULL /* QNO 354 CON_ID 21 */ 18 Query ROLLBACK /* QNO 441 CON_ID 18 */ 21 Query /* GenTest::Transform::DisableOptimizations */ SET @switch_saved = @@optimizer_switch /* QNO 355 CON_ID 21 */ 21 Query SET SESSION optimizer_switch = REPLACE( @@optimizer_switch, '=on', '=off' ) /* QNO 356 CON_ID 21 */ 21 Query SET SESSION optimizer_switch = 'in_to_exists=on' /* QNO 357 CON_ID 21 */ 21 Query DELETE FROM t1 WHERE col1 = 3 OR col1 IS NULL /* QNO 354 CON_ID 21 */ /* TRANSFORM_OUTCOME_UNORDERED_MATCH */ /* QNO 358 CON_ID 21 */ 21 Query /* GenTest::Transform::DisableOptimizations */ /* TRANSFORM_CLEANUP */ SET SESSION optimizer_switch=@switch_saved /* QNO 359 CON_ID 21 */ 21 Query /* GenTest::Transform::EnableOptimizations */ SET @switch_saved = @@optimizer_switch /* QNO 360 CON_ID 21 */ 21 Query SET SESSION optimizer_switch = REPLACE( @@optimizer_switch, '=off', '=on' ) /* QNO 361 CON_ID 21 */ 21 Query SHOW WARNINGS 21 Query DELETE FROM t1 WHERE col1 = 3 OR col1 IS NULL /* QNO 354 CON_ID 21 */ /* TRANSFORM_OUTCOME_UNORDERED_MATCH */ /* QNO 362 CON_ID 21 */ 21 Query /* GenTest::Transform::EnableOptimizations */ /* TRANSFORM_CLEANUP */ SET SESSION optimizer_switch=@switch_saved /* QNO 363 CON_ID 21 */ 21 Query CREATE OR REPLACE VIEW transforms.view_4616_probe AS DELETE FROM t1 WHERE col1 = 3 OR col1 IS NULL /* QNO 354 CON_ID 21 */ /* QNO 364 CON_ID 21 */ 21 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES /* NULL */ (NULL,NULL,NULL,REPEAT(CAST(NULL AS CHAR(1)),@fill_amount)), (NULL,NULL,NULL,REPEAT(CAST(NULL AS CHAR(1)),@fill_amount)) /* QNO 365 CON_ID 21 */ 18 Query CREATE OR REPLACE VIEW transforms.view_3564_probe AS ROLLBACK /* QNO 441 CON_ID 18 */ /* QNO 442 CON_ID 18 */ 18 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES ( 2, 2, 2, REPEAT(CAST(2 - 1 AS CHAR(1)),@fill_amount)) /* QNO 443 CON_ID 18 */ 16 Query SHOW WARNINGS 16 Query INSERT INTO t1 (col1,col2,col3,col4) VALUES ( NULL, NULL, NULL - 1, REPEAT(CAST(NULL AS CHAR(1)),@fill_amount)) /* QNO 443 CON_ID 16 */ 171012 18:12:57 27 Connect root@127.0.0.1 as anonymous on test 27 Query SHOW FULL PROCESSLIST 27 Quit 28 Connect root@127.0.0.1 as anonymous on test 28 Query SHOW FULL PROCESSLIST 28 Quit