/home/alice/git/10.2/sql/mysqld, Version: 10.2.24-MariaDB-debug-log (Source distribution). started with: Tcp port: 19300 Unix socket: /home/alice/aliska/mdev19407/mysql.sock Time Id Command Argument 190509 13:49:37 8 Connect rqg@localhost as anonymous on mysql 9 Connect rqg@localhost as anonymous on test 9 Query SHOW VARIABLES 9 Query SHOW SLAVE HOSTS 9 Query SELECT PLUGIN_NAME, PLUGIN_LIBRARY FROM INFORMATION_SCHEMA.PLUGINS WHERE PLUGIN_LIBRARY IS NOT NULL 9 Quit 10 Connect rqg@localhost 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 11 Connect rqg@localhost as anonymous on test 11 Query SELECT VERSION() 11 Query SET optimizer_switch=(SELECT variable_value FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES WHERE VARIABLE_NAME='optimizer_switch') 11 Query SELECT DATABASE() 11 Query SELECT CONNECTION_ID() 11 Query SELECT CURRENT_USER() 11 Query /*!100108 SET @@max_statement_time= 0 */ 11 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 = 'SYSTEM VERSIONED' THEN 'table' WHEN table_type = 'SEQUENCE' 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' 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 'blob' 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) WHERE table_name <> 'DUMMY' 190509 13:49:38 11 Query /*!100108 SET @@max_statement_time= @@global.max_statement_time */ 11 Query SELECT collation_name,character_set_name FROM information_schema.collations 11 Query SHOW VARIABLES LIKE 'datadir' /* QNO 1 CON_ID 11 */ 11 Quit 12 Connect rqg@localhost as anonymous on test 12 Query SELECT VERSION() 12 Query SET optimizer_switch=(SELECT variable_value FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES WHERE VARIABLE_NAME='optimizer_switch') 12 Query SELECT DATABASE() 12 Query SELECT CONNECTION_ID() 12 Query SELECT CURRENT_USER() 12 Query SELECT collation_name,character_set_name FROM information_schema.collations 12 Query create table t1 (pk int) /* QNO 2 CON_ID 12 */ 12 Query OPTIMIZE TABLE t1 /* QNO 3 CON_ID 12 */ 13 Connect rqg@localhost as anonymous on test 13 Query SELECT VERSION() 13 Query SET optimizer_switch=(SELECT variable_value FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES WHERE VARIABLE_NAME='optimizer_switch') 13 Query SELECT DATABASE() 13 Query SELECT CONNECTION_ID() 13 Query SELECT CURRENT_USER() 13 Query SELECT collation_name,character_set_name FROM information_schema.collations 13 Query OPTIMIZE TABLE t1 /* QNO 2 CON_ID 13 */ 12 Query SELECT 1 FROM t1 WHERE pk >2 /* QNO 4 CON_ID 12 */ 12 Query CREATE OR REPLACE TABLE tmp SELECT 1 FROM t1 WHERE pk>2 /* QNO 5 CON_ID 12 */ 12 Query SELECT 1 FROM t1 WHERE pk >2 /* QNO 6 CON_ID 12 */ 12 Query OPTIMIZE TABLE t1 /* QNO 7 CON_ID 12 */ 13 Query CREATE OR REPLACE TABLE tmp SELECT 1 FROM t1 WHERE pk>2 /* QNO 3 CON_ID 13 */ 13 Query SELECT 1 FROM t1 WHERE pk >2 /* QNO 4 CON_ID 13 */ 13 Query SELECT 1 FROM t1 WHERE pk >2 /* QNO 5 CON_ID 13 */ 13 Query CREATE OR REPLACE TABLE tmp SELECT 1 FROM t1 WHERE pk>2 /* QNO 6 CON_ID 13 */ 12 Query OPTIMIZE TABLE t1 /* QNO 8 CON_ID 12 */ 13 Query OPTIMIZE TABLE t1 /* QNO 7 CON_ID 13 */ 190509 13:49:39 12 Query OPTIMIZE TABLE t1 /* QNO 9 CON_ID 12 */ 13 Query CREATE OR REPLACE TABLE tmp SELECT 1 FROM t1 WHERE pk>2 /* QNO 8 CON_ID 13 */ 13 Query SELECT 1 FROM t1 WHERE pk >2 /* QNO 9 CON_ID 13 */ 13 Query SELECT 1 FROM t1 WHERE pk >2 /* QNO 10 CON_ID 13 */ 13 Query SELECT 1 FROM t1 WHERE pk >2 /* QNO 11 CON_ID 13 */ 13 Query CREATE OR REPLACE TABLE tmp SELECT 1 FROM t1 WHERE pk>2 /* QNO 12 CON_ID 13 */ 12 Query OPTIMIZE TABLE t1 /* QNO 10 CON_ID 12 */ 13 Query CREATE OR REPLACE TABLE tmp SELECT 1 FROM t1 WHERE pk>2 /* QNO 13 CON_ID 13 */ 13 Query OPTIMIZE TABLE t1 /* QNO 14 CON_ID 13 */ 12 Query OPTIMIZE TABLE t1 /* QNO 11 CON_ID 12 */ 13 Query OPTIMIZE TABLE t1 /* QNO 15 CON_ID 13 */ 12 Query SELECT 1 FROM t1 WHERE pk >2 /* QNO 12 CON_ID 12 */ 190509 13:49:40 12 Query SELECT 1 FROM t1 WHERE pk >2 /* QNO 13 CON_ID 12 */ 12 Query CREATE OR REPLACE TABLE tmp SELECT 1 FROM t1 WHERE pk>2 /* QNO 14 CON_ID 12 */ 13 Query CREATE OR REPLACE TABLE tmp SELECT 1 FROM t1 WHERE pk>2 /* QNO 16 CON_ID 13 */ 12 Query CREATE OR REPLACE TABLE tmp SELECT 1 FROM t1 WHERE pk>2 /* QNO 15 CON_ID 12 */ 13 Query OPTIMIZE TABLE t1 /* QNO 17 CON_ID 13 */ 12 Query CREATE OR REPLACE TABLE tmp SELECT 1 FROM t1 WHERE pk>2 /* QNO 16 CON_ID 12 */ 12 Query OPTIMIZE TABLE t1 /* QNO 17 CON_ID 12 */ 13 Query CREATE OR REPLACE TABLE tmp SELECT 1 FROM t1 WHERE pk>2 /* QNO 18 CON_ID 13 */ 13 Query SELECT 1 FROM t1 WHERE pk >2 /* QNO 19 CON_ID 13 */ 13 Query OPTIMIZE TABLE t1 /* QNO 20 CON_ID 13 */ 12 Query SELECT 1 FROM t1 WHERE pk >2 /* QNO 18 CON_ID 12 */ 12 Query SELECT 1 FROM t1 WHERE pk >2 /* QNO 19 CON_ID 12 */ 12 Query SELECT 1 FROM t1 WHERE pk >2 /* QNO 20 CON_ID 12 */ 12 Query OPTIMIZE TABLE t1 /* QNO 21 CON_ID 12 */ 13 Query OPTIMIZE TABLE t1 /* QNO 21 CON_ID 13 */ 190509 13:49:41 12 Query OPTIMIZE TABLE t1 /* QNO 22 CON_ID 12 */ 13 Query CREATE OR REPLACE TABLE tmp SELECT 1 FROM t1 WHERE pk>2 /* QNO 22 CON_ID 13 */ 13 Query OPTIMIZE TABLE t1 /* QNO 23 CON_ID 13 */ 12 Query CREATE OR REPLACE TABLE tmp SELECT 1 FROM t1 WHERE pk>2 /* QNO 23 CON_ID 12 */ 13 Query OPTIMIZE TABLE t1 /* QNO 24 CON_ID 13 */ 12 Query SELECT 1 FROM t1 WHERE pk >2 /* QNO 24 CON_ID 12 */ 12 Query OPTIMIZE TABLE t1 /* QNO 25 CON_ID 12 */ 13 Query OPTIMIZE TABLE t1 /* QNO 25 CON_ID 13 */ 12 Query OPTIMIZE TABLE t1 /* QNO 26 CON_ID 12 */ 13 Query SELECT 1 FROM t1 WHERE pk >2 /* QNO 26 CON_ID 13 */ 190509 13:49:42 13 Query OPTIMIZE TABLE t1 /* QNO 27 CON_ID 13 */ 12 Query CREATE OR REPLACE TABLE tmp SELECT 1 FROM t1 WHERE pk>2 /* QNO 27 CON_ID 12 */ 12 Query SELECT 1 FROM t1 WHERE pk >2 /* QNO 28 CON_ID 12 */ 12 Query OPTIMIZE TABLE t1 /* QNO 29 CON_ID 12 */ 13 Query OPTIMIZE TABLE t1 /* QNO 28 CON_ID 13 */ 12 Query SELECT 1 FROM t1 WHERE pk >2 /* QNO 30 CON_ID 12 */ 12 Query SELECT 1 FROM t1 WHERE pk >2 /* QNO 31 CON_ID 12 */ 12 Query OPTIMIZE TABLE t1 /* QNO 32 CON_ID 12 */ 13 Query OPTIMIZE TABLE t1 /* QNO 29 CON_ID 13 */ 12 Query CREATE OR REPLACE TABLE tmp SELECT 1 FROM t1 WHERE pk>2 /* QNO 33 CON_ID 12 */ 13 Query OPTIMIZE TABLE t1 /* QNO 30 CON_ID 13 */ 12 Query SELECT 1 FROM t1 WHERE pk >2 /* QNO 34 CON_ID 12 */ 12 Query OPTIMIZE TABLE t1 /* QNO 35 CON_ID 12 */ 13 Query SELECT 1 FROM t1 WHERE pk >2 /* QNO 31 CON_ID 13 */ 190509 13:49:43 13 Query OPTIMIZE TABLE t1 /* QNO 32 CON_ID 13 */ 12 Query SELECT 1 FROM t1 WHERE pk >2 /* QNO 36 CON_ID 12 */ 12 Query OPTIMIZE TABLE t1 /* QNO 37 CON_ID 12 */ 13 Query CREATE OR REPLACE TABLE tmp SELECT 1 FROM t1 WHERE pk>2 /* QNO 33 CON_ID 13 */ 12 Query SELECT 1 FROM t1 WHERE pk >2 /* QNO 38 CON_ID 12 */ 13 Query SELECT 1 FROM t1 WHERE pk >2 /* QNO 34 CON_ID 13 */ 13 Query OPTIMIZE TABLE t1 /* QNO 35 CON_ID 13 */ 12 Query SELECT 1 FROM t1 WHERE pk >2 /* QNO 39 CON_ID 12 */ 12 Query CREATE OR REPLACE TABLE tmp SELECT 1 FROM t1 WHERE pk>2 /* QNO 40 CON_ID 12 */ 12 Query CREATE OR REPLACE TABLE tmp SELECT 1 FROM t1 WHERE pk>2 /* QNO 41 CON_ID 12 */ 13 Query CREATE OR REPLACE TABLE tmp SELECT 1 FROM t1 WHERE pk>2 /* QNO 36 CON_ID 13 */ 12 Query OPTIMIZE TABLE t1 /* QNO 42 CON_ID 12 */ 13 Query CREATE OR REPLACE TABLE tmp SELECT 1 FROM t1 WHERE pk>2 /* QNO 37 CON_ID 13 */ 13 Query SELECT 1 FROM t1 WHERE pk >2 /* QNO 38 CON_ID 13 */ 13 Query CREATE OR REPLACE TABLE tmp SELECT 1 FROM t1 WHERE pk>2 /* QNO 39 CON_ID 13 */ 190509 13:49:44 12 Query OPTIMIZE TABLE t1 /* QNO 43 CON_ID 12 */ 13 Query OPTIMIZE TABLE t1 /* QNO 40 CON_ID 13 */ 12 Query SELECT 1 FROM t1 WHERE pk >2 /* QNO 44 CON_ID 12 */ 12 Query CREATE OR REPLACE TABLE tmp SELECT 1 FROM t1 WHERE pk>2 /* QNO 45 CON_ID 12 */ 13 Query CREATE OR REPLACE TABLE tmp SELECT 1 FROM t1 WHERE pk>2 /* QNO 41 CON_ID 13 */ 12 Query SELECT 1 FROM t1 WHERE pk >2 /* QNO 46 CON_ID 12 */ 12 Query OPTIMIZE TABLE t1 /* QNO 47 CON_ID 12 */ 13 Query SELECT 1 FROM t1 WHERE pk >2 /* QNO 42 CON_ID 13 */ 13 Query SELECT 1 FROM t1 WHERE pk >2 /* QNO 43 CON_ID 13 */ 13 Query CREATE OR REPLACE TABLE tmp SELECT 1 FROM t1 WHERE pk>2 /* QNO 44 CON_ID 13 */ 12 Query SELECT 1 FROM t1 WHERE pk >2 /* QNO 48 CON_ID 12 */ 13 Query OPTIMIZE TABLE t1 /* QNO 45 CON_ID 13 */ 12 Query OPTIMIZE TABLE t1 /* QNO 49 CON_ID 12 */ 13 Query OPTIMIZE TABLE t1 /* QNO 46 CON_ID 13 */ 12 Query CREATE OR REPLACE TABLE tmp SELECT 1 FROM t1 WHERE pk>2 /* QNO 50 CON_ID 12 */ 190509 13:49:45 12 Query SELECT 1 FROM t1 WHERE pk >2 /* QNO 51 CON_ID 12 */ 12 Query SELECT 1 FROM t1 WHERE pk >2 /* QNO 52 CON_ID 12 */ 12 Query CREATE OR REPLACE TABLE tmp SELECT 1 FROM t1 WHERE pk>2 /* QNO 53 CON_ID 12 */ 13 Query OPTIMIZE TABLE t1 /* QNO 47 CON_ID 13 */ 12 Query SELECT 1 FROM t1 WHERE pk >2 /* QNO 54 CON_ID 12 */ 12 Query CREATE OR REPLACE TABLE tmp SELECT 1 FROM t1 WHERE pk>2 /* QNO 55 CON_ID 12 */ 12 Query CREATE OR REPLACE TABLE tmp SELECT 1 FROM t1 WHERE pk>2 /* QNO 56 CON_ID 12 */ 13 Query SELECT 1 FROM t1 WHERE pk >2 /* QNO 48 CON_ID 13 */ 12 Query OPTIMIZE TABLE t1 /* QNO 57 CON_ID 12 */ 13 Query OPTIMIZE TABLE t1 /* QNO 49 CON_ID 13 */ 12 Query OPTIMIZE TABLE t1 /* QNO 58 CON_ID 12 */ 13 Query CREATE OR REPLACE TABLE tmp SELECT 1 FROM t1 WHERE pk>2 /* QNO 50 CON_ID 13 */ 13 Query OPTIMIZE TABLE t1 /* QNO 51 CON_ID 13 */ 190509 13:49:46 12 Query CREATE OR REPLACE TABLE tmp SELECT 1 FROM t1 WHERE pk>2 /* QNO 59 CON_ID 12 */ 13 Query CREATE OR REPLACE TABLE tmp SELECT 1 FROM t1 WHERE pk>2 /* QNO 52 CON_ID 13 */ 12 Query SELECT 1 FROM t1 WHERE pk >2 /* QNO 60 CON_ID 12 */ 12 Query CREATE OR REPLACE TABLE tmp SELECT 1 FROM t1 WHERE pk>2 /* QNO 61 CON_ID 12 */ 13 Query CREATE OR REPLACE TABLE tmp SELECT 1 FROM t1 WHERE pk>2 /* QNO 53 CON_ID 13 */ 12 Query SELECT 1 FROM t1 WHERE pk >2 /* QNO 62 CON_ID 12 */ 12 Query CREATE OR REPLACE TABLE tmp SELECT 1 FROM t1 WHERE pk>2 /* QNO 63 CON_ID 12 */ 190509 13:49:47 13 Query OPTIMIZE TABLE t1 /* QNO 54 CON_ID 13 */ 12 Query SELECT 1 FROM t1 WHERE pk >2 /* QNO 64 CON_ID 12 */ 12 Query SELECT 1 FROM t1 WHERE pk >2 /* QNO 65 CON_ID 12 */ 12 Query OPTIMIZE TABLE t1 /* QNO 66 CON_ID 12 */ 13 Query CREATE OR REPLACE TABLE tmp SELECT 1 FROM t1 WHERE pk>2 /* QNO 55 CON_ID 13 */ 13 Query SELECT 1 FROM t1 WHERE pk >2 /* QNO 56 CON_ID 13 */ 13 Query SELECT 1 FROM t1 WHERE pk >2 /* QNO 57 CON_ID 13 */ 13 Query OPTIMIZE TABLE t1 /* QNO 58 CON_ID 13 */ 12 Query SELECT 1 FROM t1 WHERE pk >2 /* QNO 67 CON_ID 12 */ 12 Query OPTIMIZE TABLE t1 /* QNO 68 CON_ID 12 */ 13 Query OPTIMIZE TABLE t1 /* QNO 59 CON_ID 13 */ 12 Query CREATE OR REPLACE TABLE tmp SELECT 1 FROM t1 WHERE pk>2 /* QNO 69 CON_ID 12 */ 12 Query OPTIMIZE TABLE t1 /* QNO 70 CON_ID 12 */ 13 Query CREATE OR REPLACE TABLE tmp SELECT 1 FROM t1 WHERE pk>2 /* QNO 60 CON_ID 13 */ 190509 13:49:48 12 Query OPTIMIZE TABLE t1 /* QNO 71 CON_ID 12 */ 13 Query CREATE OR REPLACE TABLE tmp SELECT 1 FROM t1 WHERE pk>2 /* QNO 61 CON_ID 13 */ 13 Query CREATE OR REPLACE TABLE tmp SELECT 1 FROM t1 WHERE pk>2 /* QNO 62 CON_ID 13 */ 13 Query SELECT 1 FROM t1 WHERE pk >2 /* QNO 63 CON_ID 13 */ 12 Query SELECT 1 FROM t1 WHERE pk >2 /* QNO 72 CON_ID 12 */ 13 Query SELECT 1 FROM t1 WHERE pk >2 /* QNO 64 CON_ID 13 */ 12 Query SELECT 1 FROM t1 WHERE pk >2 /* QNO 73 CON_ID 12 */ 13 Query CREATE OR REPLACE TABLE tmp SELECT 1 FROM t1 WHERE pk>2 /* QNO 65 CON_ID 13 */ 12 Query SELECT 1 FROM t1 WHERE pk >2 /* QNO 74 CON_ID 12 */ 12 Query SELECT 1 FROM t1 WHERE pk >2 /* QNO 75 CON_ID 12 */ 12 Query SELECT 1 FROM t1 WHERE pk >2 /* QNO 76 CON_ID 12 */ 12 Query OPTIMIZE TABLE t1 /* QNO 77 CON_ID 12 */ 13 Query CREATE OR REPLACE TABLE tmp SELECT 1 FROM t1 WHERE pk>2 /* QNO 66 CON_ID 13 */ 13 Query SELECT 1 FROM t1 WHERE pk >2 /* QNO 67 CON_ID 13 */ 13 Query OPTIMIZE TABLE t1 /* QNO 68 CON_ID 13 */ 12 Query CREATE OR REPLACE TABLE tmp SELECT 1 FROM t1 WHERE pk>2 /* QNO 78 CON_ID 12 */ 12 Query CREATE OR REPLACE TABLE tmp SELECT 1 FROM t1 WHERE pk>2 /* QNO 79 CON_ID 12 */ 12 Query SELECT 1 FROM t1 WHERE pk >2 /* QNO 80 CON_ID 12 */ 190509 13:49:49 12 Query CREATE OR REPLACE TABLE tmp SELECT 1 FROM t1 WHERE pk>2 /* QNO 81 CON_ID 12 */ 13 Query OPTIMIZE TABLE t1 /* QNO 69 CON_ID 13 */ 12 Query OPTIMIZE TABLE t1 /* QNO 82 CON_ID 12 */ 13 Query CREATE OR REPLACE TABLE tmp SELECT 1 FROM t1 WHERE pk>2 /* QNO 70 CON_ID 13 */ 12 Query OPTIMIZE TABLE t1 /* QNO 83 CON_ID 12 */ 13 Query CREATE OR REPLACE TABLE tmp SELECT 1 FROM t1 WHERE pk>2 /* QNO 71 CON_ID 13 */ 13 Query OPTIMIZE TABLE t1 /* QNO 72 CON_ID 13 */ 12 Query OPTIMIZE TABLE t1 /* QNO 84 CON_ID 12 */ 13 Query OPTIMIZE TABLE t1 /* QNO 73 CON_ID 13 */ 12 Query SELECT 1 FROM t1 WHERE pk >2 /* QNO 85 CON_ID 12 */ 190509 13:49:50 12 Query CREATE OR REPLACE TABLE tmp SELECT 1 FROM t1 WHERE pk>2 /* QNO 86 CON_ID 12 */ 13 Query CREATE OR REPLACE TABLE tmp SELECT 1 FROM t1 WHERE pk>2 /* QNO 74 CON_ID 13 */ 12 Query OPTIMIZE TABLE t1 /* QNO 87 CON_ID 12 */ 13 Query OPTIMIZE TABLE t1 /* QNO 75 CON_ID 13 */ 12 Query CREATE OR REPLACE TABLE tmp SELECT 1 FROM t1 WHERE pk>2 /* QNO 88 CON_ID 12 */ 13 Query OPTIMIZE TABLE t1 /* QNO 76 CON_ID 13 */ 12 Query CREATE OR REPLACE TABLE tmp SELECT 1 FROM t1 WHERE pk>2 /* QNO 89 CON_ID 12 */ 12 Query OPTIMIZE TABLE t1 /* QNO 90 CON_ID 12 */ 13 Query CREATE OR REPLACE TABLE tmp SELECT 1 FROM t1 WHERE pk>2 /* QNO 77 CON_ID 13 */ 12 Query OPTIMIZE TABLE t1 /* QNO 91 CON_ID 12 */ 13 Query OPTIMIZE TABLE t1 /* QNO 78 CON_ID 13 */ 190509 13:49:51 12 Query SELECT 1 FROM t1 WHERE pk >2 /* QNO 92 CON_ID 12 */ 12 Query CREATE OR REPLACE TABLE tmp SELECT 1 FROM t1 WHERE pk>2 /* QNO 93 CON_ID 12 */ 13 Query SELECT 1 FROM t1 WHERE pk >2 /* QNO 79 CON_ID 13 */ 12 Query SELECT 1 FROM t1 WHERE pk >2 /* QNO 94 CON_ID 12 */ 13 Query OPTIMIZE TABLE t1 /* QNO 80 CON_ID 13 */ 12 Query SELECT 1 FROM t1 WHERE pk >2 /* QNO 95 CON_ID 12 */ 12 Query CREATE OR REPLACE TABLE tmp SELECT 1 FROM t1 WHERE pk>2 /* QNO 96 CON_ID 12 */ 12 Query OPTIMIZE TABLE t1 /* QNO 97 CON_ID 12 */ 13 Query SELECT 1 FROM t1 WHERE pk >2 /* QNO 81 CON_ID 13 */ 13 Query CREATE OR REPLACE TABLE tmp SELECT 1 FROM t1 WHERE pk>2 /* QNO 82 CON_ID 13 */ 13 Query CREATE OR REPLACE TABLE tmp SELECT 1 FROM t1 WHERE pk>2 /* QNO 83 CON_ID 13 */ 12 Query OPTIMIZE TABLE t1 /* QNO 98 CON_ID 12 */ 13 Query CREATE OR REPLACE TABLE tmp SELECT 1 FROM t1 WHERE pk>2 /* QNO 84 CON_ID 13 */ 13 Query OPTIMIZE TABLE t1 /* QNO 85 CON_ID 13 */ 12 Query CREATE OR REPLACE TABLE tmp SELECT 1 FROM t1 WHERE pk>2 /* QNO 99 CON_ID 12 */ 190509 13:49:52 13 Query SELECT 1 FROM t1 WHERE pk >2 /* QNO 86 CON_ID 13 */ 12 Query OPTIMIZE TABLE t1 /* QNO 100 CON_ID 12 */ 13 Query CREATE OR REPLACE TABLE tmp SELECT 1 FROM t1 WHERE pk>2 /* QNO 87 CON_ID 13 */ 13 Query CREATE OR REPLACE TABLE tmp SELECT 1 FROM t1 WHERE pk>2 /* QNO 88 CON_ID 13 */ 12 Query SELECT 1 FROM t1 WHERE pk >2 /* QNO 101 CON_ID 12 */ 13 Query OPTIMIZE TABLE t1 /* QNO 89 CON_ID 13 */ 12 Query CREATE OR REPLACE TABLE tmp SELECT 1 FROM t1 WHERE pk>2 /* QNO 102 CON_ID 12 */ 12 Query SELECT 1 FROM t1 WHERE pk >2 /* QNO 103 CON_ID 12 */ 12 Query CREATE OR REPLACE TABLE tmp SELECT 1 FROM t1 WHERE pk>2 /* QNO 104 CON_ID 12 */ 13 Query SELECT 1 FROM t1 WHERE pk >2 /* QNO 90 CON_ID 13 */ 12 Query OPTIMIZE TABLE t1 /* QNO 105 CON_ID 12 */ 13 Query OPTIMIZE TABLE t1 /* QNO 91 CON_ID 13 */ 12 Query OPTIMIZE TABLE t1 /* QNO 106 CON_ID 12 */ 13 Query CREATE OR REPLACE TABLE tmp SELECT 1 FROM t1 WHERE pk>2 /* QNO 92 CON_ID 13 */ 190509 13:49:53 13 Query OPTIMIZE TABLE t1 /* QNO 93 CON_ID 13 */ 12 Query CREATE OR REPLACE TABLE tmp SELECT 1 FROM t1 WHERE pk>2 /* QNO 107 CON_ID 12 */ 13 Query SELECT 1 FROM t1 WHERE pk >2 /* QNO 94 CON_ID 13 */ 12 Query OPTIMIZE TABLE t1 /* QNO 108 CON_ID 12 */ 13 Query SELECT 1 FROM t1 WHERE pk >2 /* QNO 95 CON_ID 13 */ 13 Query SELECT 1 FROM t1 WHERE pk >2 /* QNO 96 CON_ID 13 */ 12 Query CREATE OR REPLACE TABLE tmp SELECT 1 FROM t1 WHERE pk>2 /* QNO 109 CON_ID 12 */ 13 Query OPTIMIZE TABLE t1 /* QNO 97 CON_ID 13 */ 12 Query OPTIMIZE TABLE t1 /* QNO 110 CON_ID 12 */ 13 Query OPTIMIZE TABLE t1 /* QNO 98 CON_ID 13 */ 12 Query SELECT 1 FROM t1 WHERE pk >2 /* QNO 111 CON_ID 12 */ 12 Query CREATE OR REPLACE TABLE tmp SELECT 1 FROM t1 WHERE pk>2 /* QNO 112 CON_ID 12 */ 12 Query CREATE OR REPLACE TABLE tmp SELECT 1 FROM t1 WHERE pk>2 /* QNO 113 CON_ID 12 */ 190509 13:49:54 13 Query OPTIMIZE TABLE t1 /* QNO 99 CON_ID 13 */ 12 Query OPTIMIZE TABLE t1 /* QNO 114 CON_ID 12 */ 13 Query SELECT 1 FROM t1 WHERE pk >2 /* QNO 100 CON_ID 13 */ 13 Query SELECT 1 FROM t1 WHERE pk >2 /* QNO 101 CON_ID 13 */ 13 Query SELECT 1 FROM t1 WHERE pk >2 /* QNO 102 CON_ID 13 */ 13 Query SELECT 1 FROM t1 WHERE pk >2 /* QNO 103 CON_ID 13 */ 13 Query CREATE OR REPLACE TABLE tmp SELECT 1 FROM t1 WHERE pk>2 /* QNO 104 CON_ID 13 */ 12 Query OPTIMIZE TABLE t1 /* QNO 115 CON_ID 12 */ 13 Query SELECT 1 FROM t1 WHERE pk >2 /* QNO 105 CON_ID 13 */ 13 Query OPTIMIZE TABLE t1 /* QNO 106 CON_ID 13 */ 12 Query SELECT 1 FROM t1 WHERE pk >2 /* QNO 116 CON_ID 12 */ 12 Query OPTIMIZE TABLE t1 /* QNO 117 CON_ID 12 */ 13 Query CREATE OR REPLACE TABLE tmp SELECT 1 FROM t1 WHERE pk>2 /* QNO 107 CON_ID 13 */ 13 Query SELECT 1 FROM t1 WHERE pk >2 /* QNO 108 CON_ID 13 */ 13 Query CREATE OR REPLACE TABLE tmp SELECT 1 FROM t1 WHERE pk>2 /* QNO 109 CON_ID 13 */ 12 Query CREATE OR REPLACE TABLE tmp SELECT 1 FROM t1 WHERE pk>2 /* QNO 118 CON_ID 12 */ 13 Query CREATE OR REPLACE TABLE tmp SELECT 1 FROM t1 WHERE pk>2 /* QNO 110 CON_ID 13 */ 190509 13:49:55 12 Query OPTIMIZE TABLE t1 /* QNO 119 CON_ID 12 */ 13 Query OPTIMIZE TABLE t1 /* QNO 111 CON_ID 13 */ 12 Query OPTIMIZE TABLE t1 /* QNO 120 CON_ID 12 */ 13 Query SELECT 1 FROM t1 WHERE pk >2 /* QNO 112 CON_ID 13 */ 13 Query OPTIMIZE TABLE t1 /* QNO 113 CON_ID 13 */ 12 Query OPTIMIZE TABLE t1 /* QNO 121 CON_ID 12 */ 190509 13:49:57 13 Query CREATE OR REPLACE TABLE tmp SELECT 1 FROM t1 WHERE pk>2 /* QNO 114 CON_ID 13 */ 13 Query CREATE OR REPLACE TABLE tmp SELECT 1 FROM t1 WHERE pk>2 /* QNO 115 CON_ID 13 */ 13 Query OPTIMIZE TABLE t1 /* QNO 116 CON_ID 13 */ 190509 13:49:58 12 Query SELECT 1 FROM t1 WHERE pk >2 /* QNO 122 CON_ID 12 */ 12 Query CREATE OR REPLACE TABLE tmp SELECT 1 FROM t1 WHERE pk>2 /* QNO 123 CON_ID 12 */ 12 Query CREATE OR REPLACE TABLE tmp SELECT 1 FROM t1 WHERE pk>2 /* QNO 124 CON_ID 12 */ 13 Query CREATE OR REPLACE TABLE tmp SELECT 1 FROM t1 WHERE pk>2 /* QNO 117 CON_ID 13 */ 12 Query OPTIMIZE TABLE t1 /* QNO 125 CON_ID 12 */ 13 Query SELECT 1 FROM t1 WHERE pk >2 /* QNO 118 CON_ID 13 */ 13 Query CREATE OR REPLACE TABLE tmp SELECT 1 FROM t1 WHERE pk>2 /* QNO 119 CON_ID 13 */ 12 Query OPTIMIZE TABLE t1 /* QNO 126 CON_ID 12 */ 13 Query SELECT 1 FROM t1 WHERE pk >2 /* QNO 120 CON_ID 13 */ 13 Query OPTIMIZE TABLE t1 /* QNO 121 CON_ID 13 */ 12 Query CREATE OR REPLACE TABLE tmp SELECT 1 FROM t1 WHERE pk>2 /* QNO 127 CON_ID 12 */ 190509 13:49:59 13 Query OPTIMIZE TABLE t1 /* QNO 122 CON_ID 13 */ 12 Query OPTIMIZE TABLE t1 /* QNO 128 CON_ID 12 */ 13 Query OPTIMIZE TABLE t1 /* QNO 123 CON_ID 13 */ 12 Query SELECT 1 FROM t1 WHERE pk >2 /* QNO 129 CON_ID 12 */ 12 Query OPTIMIZE TABLE t1 /* QNO 130 CON_ID 12 */ 13 Query OPTIMIZE TABLE t1 /* QNO 124 CON_ID 13 */ 12 Query CREATE OR REPLACE TABLE tmp SELECT 1 FROM t1 WHERE pk>2 /* QNO 131 CON_ID 12 */ 12 Query CREATE OR REPLACE TABLE tmp SELECT 1 FROM t1 WHERE pk>2 /* QNO 132 CON_ID 12 */ 190509 13:50:00 12 Query SELECT 1 FROM t1 WHERE pk >2 /* QNO 133 CON_ID 12 */ 12 Query CREATE OR REPLACE TABLE tmp SELECT 1 FROM t1 WHERE pk>2 /* QNO 134 CON_ID 12 */ 13 Query CREATE OR REPLACE TABLE tmp SELECT 1 FROM t1 WHERE pk>2 /* QNO 125 CON_ID 13 */ 12 Query SELECT 1 FROM t1 WHERE pk >2 /* QNO 135 CON_ID 12 */ 12 Query SELECT 1 FROM t1 WHERE pk >2 /* QNO 136 CON_ID 12 */ 12 Query OPTIMIZE TABLE t1 /* QNO 137 CON_ID 12 */ 13 Query CREATE OR REPLACE TABLE tmp SELECT 1 FROM t1 WHERE pk>2 /* QNO 126 CON_ID 13 */ 13 Query SELECT 1 FROM t1 WHERE pk >2 /* QNO 127 CON_ID 13 */ 13 Query SELECT 1 FROM t1 WHERE pk >2 /* QNO 128 CON_ID 13 */ 13 Query SELECT 1 FROM t1 WHERE pk >2 /* QNO 129 CON_ID 13 */ 13 Query OPTIMIZE TABLE t1 /* QNO 130 CON_ID 13 */ 12 Query SELECT 1 FROM t1 WHERE pk >2 /* QNO 138 CON_ID 12 */ 12 Query CREATE OR REPLACE TABLE tmp SELECT 1 FROM t1 WHERE pk>2 /* QNO 139 CON_ID 12 */ 12 Query OPTIMIZE TABLE t1 /* QNO 140 CON_ID 12 */ 13 Query CREATE OR REPLACE TABLE tmp SELECT 1 FROM t1 WHERE pk>2 /* QNO 131 CON_ID 13 */ 13 Query SELECT 1 FROM t1 WHERE pk >2 /* QNO 132 CON_ID 13 */ 13 Query SELECT 1 FROM t1 WHERE pk >2 /* QNO 133 CON_ID 13 */ 190509 13:50:01 12 Query SELECT 1 FROM t1 WHERE pk >2 /* QNO 141 CON_ID 12 */ 13 Query OPTIMIZE TABLE t1 /* QNO 134 CON_ID 13 */ 12 Query OPTIMIZE TABLE t1 /* QNO 142 CON_ID 12 */ 13 Query CREATE OR REPLACE TABLE tmp SELECT 1 FROM t1 WHERE pk>2 /* QNO 135 CON_ID 13 */ 12 Query CREATE OR REPLACE TABLE tmp SELECT 1 FROM t1 WHERE pk>2 /* QNO 143 CON_ID 12 */ 13 Query OPTIMIZE TABLE t1 /* QNO 136 CON_ID 13 */ 12 Query OPTIMIZE TABLE t1 /* QNO 144 CON_ID 12 */ 13 Query SELECT 1 FROM t1 WHERE pk >2 /* QNO 137 CON_ID 13 */ 13 Query OPTIMIZE TABLE t1 /* QNO 138 CON_ID 13 */ 12 Query OPTIMIZE TABLE t1 /* QNO 145 CON_ID 12 */ 13 Query CREATE OR REPLACE TABLE tmp SELECT 1 FROM t1 WHERE pk>2 /* QNO 139 CON_ID 13 */ 12 Query OPTIMIZE TABLE t1 /* QNO 146 CON_ID 12 */ 190509 13:50:02 13 Query CREATE OR REPLACE TABLE tmp SELECT 1 FROM t1 WHERE pk>2 /* QNO 140 CON_ID 13 */ 13 Query OPTIMIZE TABLE t1 /* QNO 141 CON_ID 13 */ 12 Query SELECT 1 FROM t1 WHERE pk >2 /* QNO 147 CON_ID 12 */ 12 Query SELECT 1 FROM t1 WHERE pk >2 /* QNO 148 CON_ID 12 */ 12 Query CREATE OR REPLACE TABLE tmp SELECT 1 FROM t1 WHERE pk>2 /* QNO 149 CON_ID 12 */ 13 Query SELECT 1 FROM t1 WHERE pk >2 /* QNO 142 CON_ID 13 */ 12 Query SELECT 1 FROM t1 WHERE pk >2 /* QNO 150 CON_ID 12 */ 12 Query SELECT 1 FROM t1 WHERE pk >2 /* QNO 151 CON_ID 12 */ 13 Query SELECT 1 FROM t1 WHERE pk >2 /* QNO 143 CON_ID 13 */ 12 Query CREATE OR REPLACE TABLE tmp SELECT 1 FROM t1 WHERE pk>2 /* QNO 152 CON_ID 12 */ 13 Query CREATE OR REPLACE TABLE tmp SELECT 1 FROM t1 WHERE pk>2 /* QNO 144 CON_ID 13 */ 12 Query SELECT 1 FROM t1 WHERE pk >2 /* QNO 153 CON_ID 12 */ 12 Query SELECT 1 FROM t1 WHERE pk >2 /* QNO 154 CON_ID 12 */ 12 Query CREATE OR REPLACE TABLE tmp SELECT 1 FROM t1 WHERE pk>2 /* QNO 155 CON_ID 12 */ 13 Query CREATE OR REPLACE TABLE tmp SELECT 1 FROM t1 WHERE pk>2 /* QNO 145 CON_ID 13 */ 12 Query OPTIMIZE TABLE t1 /* QNO 156 CON_ID 12 */ 13 Query OPTIMIZE TABLE t1 /* QNO 146 CON_ID 13 */ 12 Query OPTIMIZE TABLE t1 /* QNO 157 CON_ID 12 */ 13 Query CREATE OR REPLACE TABLE tmp SELECT 1 FROM t1 WHERE pk>2 /* QNO 147 CON_ID 13 */ 13 Query SELECT 1 FROM t1 WHERE pk >2 /* QNO 148 CON_ID 13 */ 13 Query OPTIMIZE TABLE t1 /* QNO 149 CON_ID 13 */ 12 Query SELECT 1 FROM t1 WHERE pk >2 /* QNO 158 CON_ID 12 */ 190509 13:50:03 12 Query OPTIMIZE TABLE t1 /* QNO 159 CON_ID 12 */ 13 Query OPTIMIZE TABLE t1 /* QNO 150 CON_ID 13 */ 12 Query OPTIMIZE TABLE t1 /* QNO 160 CON_ID 12 */ 13 Query CREATE OR REPLACE TABLE tmp SELECT 1 FROM t1 WHERE pk>2 /* QNO 151 CON_ID 13 */ 13 Query SELECT 1 FROM t1 WHERE pk >2 /* QNO 152 CON_ID 13 */ 13 Query SELECT 1 FROM t1 WHERE pk >2 /* QNO 153 CON_ID 13 */ 13 Query SELECT 1 FROM t1 WHERE pk >2 /* QNO 154 CON_ID 13 */ 13 Query OPTIMIZE TABLE t1 /* QNO 155 CON_ID 13 */ 12 Query SELECT 1 FROM t1 WHERE pk >2 /* QNO 161 CON_ID 12 */ 12 Query OPTIMIZE TABLE t1 /* QNO 162 CON_ID 12 */ 13 Query OPTIMIZE TABLE t1 /* QNO 156 CON_ID 13 */ 12 Query SELECT 1 FROM t1 WHERE pk >2 /* QNO 163 CON_ID 12 */ 12 Query OPTIMIZE TABLE t1 /* QNO 164 CON_ID 12 */ 13 Query CREATE OR REPLACE TABLE tmp SELECT 1 FROM t1 WHERE pk>2 /* QNO 157 CON_ID 13 */ 190509 13:50:04 12 Query SELECT 1 FROM t1 WHERE pk >2 /* QNO 165 CON_ID 12 */ 13 Query CREATE OR REPLACE TABLE tmp SELECT 1 FROM t1 WHERE pk>2 /* QNO 158 CON_ID 13 */ 12 Query OPTIMIZE TABLE t1 /* QNO 166 CON_ID 12 */