# 2011-09-27T03:19:38 Copyright (c) 2008,2011 Oracle and/or its affiliates. All rights reserved. Use is subject to license terms. # 2011-09-27T03:19:38 Please see http://forge.mysql.com/wiki/Category:RandomQueryGenerator for more information on this test framework. # 2011-09-27T03:19:38 Starting: runall.pl --queries=100000000 --debug --seed=time --mysqld1=--debug-assert-if-crashed-table --mysqld1=--innodb_stats_sample_pages=256 --mysqld1=--max_join_size=1000000 --queries=100M --duration=900 --threads=6 --seed=time --mysqld1=--log-output=file --no-mask --views --reporter=QueryTimeout,Backtrace,ErrorLog,Deadlock --basedir1=/home/philips/bzr/maria-5.3 --mysqld1=--optimizer_switch=semijoin=ON,materialization=ON,firstmatch=OFF,loosescan=OFF --validator=Transformer --transformers=DisableChosenPlan,ConvertLiteralsToSubqueries,ExecuteAsInsertSelect,ExecuteAsSelectItem,ExecuteAsUpdateDelete,ExecuteAsWhereSubquery,InlineSubqueries --grammar=conf/optimizer/optimizer_subquery.yy --mtr-build-thread=300 --mask=15288 --vardir1=/tmp/release-workdir-semijoin-materialization-sept26-actual2/current1_1 # 2011-09-27T03:19:38 master_port : 13000 slave_port : 13002 master_ports : 13000 13002 MTR_BUILD_THREAD : 300 # 2011-09-27T03:19:38 /home/philips/bzr/randgen-release-testing Revno: 876 # 2011-09-27T03:19:38 /home/philips/bzr/randgen-release-testing Revision-Id: philips@eve-20110919110505-srbisbgo096pb0c7 # 2011-09-27T03:19:39 /home/philips/bzr/maria-5.3 Revno: 3195 # 2011-09-27T03:19:39 /home/philips/bzr/maria-5.3 Revision-Id: psergey@askmonty.org-20110926101504-ld9i0y4x9ze6br5k # 2011-09-27T03:19:39 Running perl mysql-test-run.pl --start-and-exit --skip-ndb --mysqld=--core-file --mysqld=--loose-new --mysqld=--sql-mode=no_engine_substitution --mysqld=--relay-log=slave-relay-bin --mysqld=--loose-innodb --mysqld=--loose-falcon-debug-mask=2 --mysqld=--secure-file-priv= --mysqld=--max-allowed-packet=16Mb --mysqld=--loose-innodb-status-file=1 --mysqld=--master-retry-count=65535 --mysqld=--loose-debug-assert-if-crashed-table --mysqld=--loose-debug-assert-on-error --vardir=/tmp/release-workdir-semijoin-materialization-sept26-actual2/current1_1 --master_port=13000 --mysqld="--debug-assert-if-crashed-table" --mysqld="--innodb_stats_sample_pages=256" --mysqld="--max_join_size=1000000" --mysqld="--log-output=file" --mysqld="--optimizer_switch=semijoin=ON,materialization=ON,firstmatch=OFF,loosescan=OFF" 1st 2>&1 . ======================================================= WARNING: Using mysql-test-run.pl version 1! ======================================================= Logging: lib/v1/mysql-test-run.pl --start-and-exit --skip-ndb --mysqld=--core-file --mysqld=--loose-new --mysqld=--sql-mode=no_engine_substitution --mysqld=--relay-log=slave-relay-bin --mysqld=--loose-innodb --mysqld=--loose-falcon-debug-mask=2 --mysqld=--secure-file-priv= --mysqld=--max-allowed-packet=16Mb --mysqld=--loose-innodb-status-file=1 --mysqld=--master-retry-count=65535 --mysqld=--loose-debug-assert-if-crashed-table --mysqld=--loose-debug-assert-on-error --vardir=/tmp/release-workdir-semijoin-materialization-sept26-actual2/current1_1 --master_port=13000 --mysqld=--debug-assert-if-crashed-table --mysqld=--innodb_stats_sample_pages=256 --mysqld=--max_join_size=1000000 --mysqld=--log-output=file --mysqld=--optimizer_switch=semijoin=ON,materialization=ON,firstmatch=OFF,loosescan=OFF 1st MySQL Version 5.3.2 Using dynamic switching of binlog format Skipping ndbcluster Setting mysqld to support SSL connections Binaries are debug compiled Using MTR_BUILD_THREAD = 300 Using MASTER_MYPORT = 13000 Using MASTER_MYPORT1 = 13001 Using SLAVE_MYPORT = 13002 Using SLAVE_MYPORT1 = 13003 Using SLAVE_MYPORT2 = 13004 Using IM_PORT = 13007 Using IM_MYSQLD1_PORT = 13008 Using IM_MYSQLD2_PORT = 13009 Killing Possible Leftover Processes Sleep 1 second waiting for processes to die Sleep 1 second waiting for processes to die Sleep 1 second waiting for processes to die Removing Stale Files Creating Directories Installing Master Database ======================================================= TEST RESULT TIME (ms) ------------------------------------------------------- Servers started, exiting # 2011-09-27T03:19:42 Starting: gentest.pl --gendata= --validator=Transformer --reporter=QueryTimeout --reporter=Backtrace --reporter=ErrorLog --reporter=Deadlock --transformer=DisableChosenPlan --transformer=ConvertLiteralsToSubqueries --transformer=ExecuteAsInsertSelect --transformer=ExecuteAsSelectItem --transformer=ExecuteAsUpdateDelete --transformer=ExecuteAsWhereSubquery --transformer=InlineSubqueries --threads=6 --queries=100M --duration=900 --dsn=dbi:mysql:host=127.0.0.1:port=13000:user=root:database=test --grammar=conf/optimizer/optimizer_subquery.yy --seed=time --views --debug # 2011-09-27T03:19:42 Converting --seed=time to --seed=1317082782 # 2011-09-27T03:19:42 ------------------------------- # 2011-09-27T03:19:42 Configuration # 2011-09-27T03:19:42 debug => 1 # 2011-09-27T03:19:42 dsn => ['dbi:mysql:host=127.0.0.1:port=13000:user=root:database=test'] # 2011-09-27T03:19:42 duration => 900 # 2011-09-27T03:19:42 gendata => # 2011-09-27T03:19:42 generator => FromGrammar # 2011-09-27T03:19:42 grammar => conf/optimizer/optimizer_subquery.yy # 2011-09-27T03:19:42 queries => 100M # 2011-09-27T03:19:42 reporters => ['QueryTimeout', 'Backtrace', 'ErrorLog', 'Deadlock'] # 2011-09-27T03:19:42 seed => time # 2011-09-27T03:19:42 threads => 6 # 2011-09-27T03:19:42 transformers => ['DisableChosenPlan', 'ConvertLiteralsToSubqueries', 'ExecuteAsInsertSelect', 'ExecuteAsSelectItem', 'ExecuteAsUpdateDelete', 'ExecuteAsWhereSubquery', 'InlineSubqueries'] # 2011-09-27T03:19:42 validators => ['Transformer'] # 2011-09-27T03:19:42 views => 1 # 2011-09-27T03:19:42 Creating MySQL table A, size 0 rows, engine . # 2011-09-27T03:19:42 Creating MySQL table B, size 1 rows, engine . # 2011-09-27T03:19:42 Creating MySQL table C, size 20 rows, engine . # 2011-09-27T03:19:42 Creating MySQL table D, size 100 rows, engine . # 2011-09-27T03:19:42 Creating MySQL table E, size 1000 rows, engine . # 2011-09-27T03:19:43 Creating MySQL table AA, size 0 rows, engine . # 2011-09-27T03:19:43 Creating MySQL table BB, size 1 rows, engine . # 2011-09-27T03:19:43 Creating MySQL table CC, size 20 rows, engine . # 2011-09-27T03:19:43 Creating MySQL table DD, size 100 rows, engine . # 2011-09-27T03:19:43 Statistics for Executor dbi:mysql:host=127.0.0.1:port=13000:user=root:database=test # 2011-09-27T03:19:43 Rows returned: $VAR1 = undef; # 2011-09-27T03:19:43 Rows affected: $VAR1 = { ' 1' => 3, '>10' => 4, '>100' => 2 }; # 2011-09-27T03:19:43 Explain items: $VAR1 = undef; # 2011-09-27T03:19:43 Errors: $VAR1 = { '(no error)' => 39 }; # 2011-09-27T03:19:43 Rare EXPLAIN items: $VAR1 = undef; # 2011-09-27T03:19:43 Statuses: STATUS_OK: 39 queries # 2011-09-27T03:19:43 Loading Generator GenTest::Generator::FromGrammar. # 2011-09-27T03:19:43 Caching schema metadata for dbi:mysql:host=127.0.0.1:port=13000:user=root:database=test # 2011-09-27T03:19:43 Reporters: QueryTimeout, Backtrace, ErrorLog, Deadlock # 2011-09-27T03:19:43 Validators: Transformer # 2011-09-27T03:19:43 Transformers: DisableChosenPlan, ConvertLiteralsToSubqueries, ExecuteAsInsertSelect, ExecuteAsSelectItem, ExecuteAsUpdateDelete, ExecuteAsWhereSubquery, InlineSubqueries # 2011-09-27T03:19:43 Starting 6 processes, 100M queries each, duration 900 seconds. # 2011-09-27T03:19:43 GenTest::ErrorFilter(15841) started # 2011-09-27T03:19:43 Loading Validator GenTest::Validator::Transformer. # 2011-09-27T03:19:43 Loading Validator GenTest::Validator::Transformer. # 2011-09-27T03:19:43 Loading Validator GenTest::Validator::Transformer. # 2011-09-27T03:19:43 Transformer Validator will use the following Transformers: DisableChosenPlan, ConvertLiteralsToSubqueries, ExecuteAsInsertSelect, ExecuteAsSelectItem, ExecuteAsUpdateDelete, ExecuteAsWhereSubquery, InlineSubqueries # 2011-09-27T03:19:43 Loading Validator GenTest::Validator::Transformer. # 2011-09-27T03:19:43 Transformer Validator will use the following Transformers: DisableChosenPlan, ConvertLiteralsToSubqueries, ExecuteAsInsertSelect, ExecuteAsSelectItem, ExecuteAsUpdateDelete, ExecuteAsWhereSubquery, InlineSubqueries # 2011-09-27T03:19:43 Loading Validator GenTest::Validator::Transformer. # 2011-09-27T03:19:43 Query: SELECT STRAIGHT_JOIN SUM( DISTINCT alias2 . `col_varchar_nokey` ) AS field1 FROM ( C AS alias1 , CC AS alias2 , CC AS alias3 ) WHERE ( alias3 . `col_varchar_nokey` IN ( SELECT DISTINCT SQ1_alias1 . `col_varchar_nokey` AS SQ1_field1 FROM ( CC AS SQ1_alias1 STRAIGHT_JOIN ( CC AS SQ1_alias2 INNER JOIN BB AS SQ1_alias3 ON (SQ1_alias3 . `col_varchar_key` = SQ1_alias2 . `col_varchar_nokey` AND SQ1_alias3 . `col_varchar_nokey` >= ( SELECT DISTINCT MAX( C_SQ1_alias2 . `col_varchar_nokey` ) AS C_SQ1_field1 FROM view_C AS C_SQ1_alias1 ) ) ) ON (SQ1_alias3 . `col_int_key` = SQ1_alias2 . `col_int_nokey` ) ) WHERE SQ1_alias2 . `col_int_nokey` <= alias1 . `col_int_nokey` ) ) OR alias1 . `col_int_key` BETWEEN 66 AND ( 66 + 121 ) AND alias3 . `pk` < ALL ( SELECT 6 UNION SELECT 2 ) HAVING field1 != 8 ORDER BY alias1 . `col_datetime_key` , alias3 .`pk` ASC , CONCAT ( alias3 . `col_varchar_nokey`, alias3 . `col_varchar_nokey` ) , field1 , alias1 . `col_date_key` , alias1 . `col_time_key` , alias1 .`pk` , field1 /* 2 */ failed: 1054 Unknown column '%s' in 'field list'. Further errors of this kind will be suppressed. # 2011-09-27T03:19:43 Loading Validator GenTest::Validator::Transformer. # 2011-09-27T03:19:43 Transformer Validator will use the following Transformers: DisableChosenPlan, ConvertLiteralsToSubqueries, ExecuteAsInsertSelect, ExecuteAsSelectItem, ExecuteAsUpdateDelete, ExecuteAsWhereSubquery, InlineSubqueries # 2011-09-27T03:19:43 Transformer Validator will use the following Transformers: DisableChosenPlan, ConvertLiteralsToSubqueries, ExecuteAsInsertSelect, ExecuteAsSelectItem, ExecuteAsUpdateDelete, ExecuteAsWhereSubquery, InlineSubqueries # 2011-09-27T03:19:43 Started periodic reporting process... # 2011-09-27T03:19:43 QueryTimeout Reporter will use query timeout threshold of 20 seconds # 2011-09-27T03:19:43 Query: SELECT ( SELECT COUNT( SQ1_alias1 . `col_int_nokey` ) AS SQ1_field1 FROM CC AS SQ1_alias1 WHERE SQ1_alias1 . `col_int_nokey` = alias1 . `pk` ) AS field1 , alias1 . `col_varchar_key` AS field2 FROM ( C AS alias1 , C AS alias2 , B AS alias3 ) WHERE ( EXISTS ( ( SELECT SQ2_alias2 . `col_int_key` AS SQ2_field1 FROM ( CC AS SQ2_alias1 STRAIGHT_JOIN ( C AS SQ2_alias2 INNER JOIN CC AS SQ2_alias3 ON (SQ2_alias3 . `col_int_nokey` = SQ2_alias2 . `col_int_key` ) ) ON (SQ2_alias3 . `pk` = SQ2_alias2 . `col_int_nokey` ) ) GROUP BY SQ2_field1 ) ) ) AND ( alias1 . `col_int_key` < alias2 . `col_int_key` AND alias1 . `col_varchar_nokey` IS NULL ) GROUP BY field1, field2 HAVING ( alias3 . `col_varchar_key` IN ( SELECT SQ3_alias2 . `col_varchar_key` AS SQ3_field1 FROM ( CC AS SQ3_alias1 INNER JOIN B AS SQ3_alias2 ON (SQ3_alias2 . `pk` = SQ3_alias1 . `col_int_key` ) ) ) AND ( alias2 . `pk` , alias3 . `col_int_key` ) NOT IN ( SELECT 4 , 209 UNION SELECT 5, 2 )) /* 2 */ failed: 1054 Unknown column '%s' in 'IN/ALL/ANY subquery'. Further errors of this kind will be suppressed. # 2011-09-27T03:19:43 Transformer Validator will use the following Transformers: DisableChosenPlan, ConvertLiteralsToSubqueries, ExecuteAsInsertSelect, ExecuteAsSelectItem, ExecuteAsUpdateDelete, ExecuteAsWhereSubquery, InlineSubqueries # 2011-09-27T03:19:44 Transformer Validator will use the following Transformers: DisableChosenPlan, ConvertLiteralsToSubqueries, ExecuteAsInsertSelect, ExecuteAsSelectItem, ExecuteAsUpdateDelete, ExecuteAsWhereSubquery, InlineSubqueries # 2011-09-27T03:19:44 Query: SELECT COUNT( alias2 . `col_varchar_key` ) AS field1 FROM ( C AS alias1 INNER JOIN ( ( CC AS alias2 INNER JOIN C AS alias3 ON (alias3 . `col_varchar_key` = alias2 . `col_varchar_nokey` ) ) ) ON (alias3 . `col_varchar_nokey` = alias2 . `col_varchar_key` ) ) WHERE ( alias3 . `col_varchar_key` >= ( SELECT SQL_SMALL_RESULT COUNT( SQ1_alias1 . `col_varchar_nokey` ) AS SQ1_field1 FROM C AS SQ1_alias1 ) ) OR alias1 . `col_varchar_key` = 'j' AND alias1 . `col_varchar_nokey` > SOME ( SELECT SQ2_alias1 . `col_varchar_nokey` AS SQ2_field1 FROM CC AS SQ2_alias1 HAVING (SQ2_alias1 . `col_int_nokey` != 3 AND SQ2_alias1 . `col_int_key` > 'd')) /* 5 */ failed: 1054 Unknown column '%s' in 'having clause'. Further errors of this kind will be suppressed. # 2011-09-27T03:19:48 Query: CREATE TABLE transforms.insert_select_15845 SELECT alias1 . `col_varchar_key` AS field1 FROM ( D AS alias1 , CC AS alias2 , C AS alias3 ) WHERE alias3 . `col_varchar_key` >= ( SELECT 'i' FROM DUAL ) GROUP BY field1 /* 2 */ failed: 2013 Lost connection to MySQL server during query # 2011-09-27T03:19:48 Query: CREATE TABLE transforms.insert_select_15843 SELECT DISTINCT CONCAT ( alias2 . `col_varchar_key` , alias1 . `col_varchar_key` ) AS field1 FROM ( CC AS alias1 , C AS alias2 ) WHERE alias1 . `col_varchar_key` < ANY ( SELECT SQ1_alias1 . `col_varchar_key` AS SQ1_field1 FROM ( CC AS SQ1_alias1 INNER JOIN ( D AS SQ1_alias2 STRAIGHT_JOIN CC AS SQ1_alias3 ON (SQ1_alias3 . `col_varchar_nokey` = SQ1_alias2 . `col_varchar_key` ) ) ON (SQ1_alias3 . `col_int_nokey` = SQ1_alias2 . `pk` ) ) WHERE SQ1_alias3 . `col_varchar_key` > alias1 . `col_varchar_nokey` ) GROUP BY field1 HAVING field1 > 'x' /* 1 */ failed: 2013 Lost connection to MySQL server during query # 2011-09-27T03:19:48 Query: SELECT ( SELECT 2 FROM DUAL ) AS field1 , MIN( alias2 . `col_varchar_nokey` ) AS field2 , COUNT( alias2 . `col_int_nokey` ) AS field3 , alias2 . `col_int_key` AS field4 , ( SELECT SUM( SQ2_alias1 . `col_int_key` ) AS SQ2_field1 FROM ( C AS SQ2_alias1 STRAIGHT_JOIN ( B AS SQ2_alias2 RIGHT OUTER JOIN CC AS SQ2_alias3 ON (SQ2_alias3 . `col_varchar_key` = SQ2_alias2 . `col_varchar_key` ) ) ON (SQ2_alias3 . `pk` = SQ2_alias2 . `pk` ) ) WHERE SQ2_alias3 . `col_int_key` >= alias1 . `col_int_key` ) AS field5 FROM ( C AS alias1 , C AS alias2 , B AS alias3 ) WHERE ( alias1 . `col_varchar_nokey` > ( SELECT DISTINCT COUNT( SQ3_alias1 . `col_varchar_nokey` ) AS SQ3_field1 FROM ( C AS SQ3_alias1 STRAIGHT_JOIN ( CC AS SQ3_alias2 STRAIGHT_JOIN CC AS SQ3_alias3 ON (SQ3_alias3 . `col_varchar_key` = SQ3_alias2 . `col_varchar_key` OR SQ3_alias2 . `col_varchar_nokey` IN ( SELECT 7 UNION SELECT 7 ) ) ) ON (SQ3_alias3 . `col_varchar_nokey` = SQ3_alias2 . `col_varchar_key` ) ) ) ) AND ( alias1 . `col_varchar_key` IN ('USA' , 'v' , 'USA') OR alias1 . `col_int_key` BETWEEN 40 AND ( 40 + 81 ) ) GROUP BY field1, field4, field5 HAVING field3 > 'ip' ORDER BY alias1 . `col_time_key` DESC , field1, field2, field3, field4, field5 /* 4 */ /* TRANSFORM_OUTCOME_UNORDERED_MATCH */ ; failed: 2013 Lost connection to MySQL server during query # 2011-09-27T03:19:48 Query: SELECT SUM( alias1 . `col_int_key` ) AS field1 FROM ( BB AS alias1 INNER JOIN ( ( BB AS alias2 STRAIGHT_JOIN C AS alias3 ON (alias3 . `pk` = alias2 . `pk` ) ) ) ON (alias3 . `pk` = alias2 . `col_int_key` ) ) WHERE ( ( 7, 8 ) IN ( SELECT SQ1_alias1 . `pk` AS SQ1_field1 , SQ1_alias1 . `pk` AS SQ1_field2 FROM ( C AS SQ1_alias1 LEFT OUTER JOIN B AS SQ1_alias2 ON (SQ1_alias2 . `col_varchar_key` = SQ1_alias1 . `col_varchar_nokey` ) ) HAVING SQ1_alias1 . `pk` = 'v' ) ) AND ( alias1 . `pk` > 71 AND alias1 . `pk` < ( 71 + 59 ) OR alias1 . `pk` NOT IN (120) ) AND ( alias3 . `col_varchar_key` IN ( SELECT 'j' UNION SELECT 'p' ) AND alias1 . `col_int_key` IS NULL ) /* 5 */ failed: 2013 Lost connection to MySQL server during query # 2011-09-27T03:19:48 Query: SELECT alias1 . `col_time_key` AS field1 , alias2 . `col_varchar_key` AS field2 , MIN( alias1 . `pk` ) AS field3 , SUM( alias1 . `col_varchar_nokey` ) AS field4 , alias1 . `col_varchar_key` AS field5 FROM ( BB AS alias1 STRAIGHT_JOIN B AS alias2 ON (alias2 . `col_int_key` = alias1 . `col_int_key` ) ) WHERE ( EXISTS ( ( SELECT SQ1_alias1 . `pk` AS SQ1_field1 FROM ( CC AS SQ1_alias1 , B AS SQ1_alias2 ) GROUP BY SQ1_field1 ) ) ) AND alias1 . `col_int_key` > 68 AND alias1 . `col_int_key` < ( 68 + 171 ) OR alias1 . `pk` IS NULL GROUP BY field1, field2, field5 HAVING (field4 <> 5 AND field2 <> 7) ORDER BY alias1 . `col_datetime_key` , alias2 .`pk` ASC , CONCAT ( alias1 . `col_varchar_nokey`, alias1 . `col_varchar_nokey` ), field1, field2, field3, field4, field5 /* 3 */ failed: 2013 Lost connection to MySQL server during query # 2011-09-27T03:19:48 Ignoring transform GenTest::Transform::ExecuteAsInsertSelect that failed with the error: Lost connection to MySQL server during query # 2011-09-27T03:19:48 Offending query is: CREATE TABLE transforms.insert_select_15843 SELECT DISTINCT CONCAT ( alias2 . `col_varchar_key` , alias1 . `col_varchar_key` ) AS field1 FROM ( CC AS alias1 , C AS alias2 ) WHERE alias1 . `col_varchar_key` < ANY ( SELECT SQ1_alias1 . `col_varchar_key` AS SQ1_field1 FROM ( CC AS SQ1_alias1 INNER JOIN ( D AS SQ1_alias2 STRAIGHT_JOIN CC AS SQ1_alias3 ON (SQ1_alias3 . `col_varchar_nokey` = SQ1_alias2 . `col_varchar_key` ) ) ON (SQ1_alias3 . `col_int_nokey` = SQ1_alias2 . `pk` ) ) WHERE SQ1_alias3 . `col_varchar_key` > alias1 . `col_varchar_nokey` ) GROUP BY field1 HAVING field1 > 'x' /* 1 */; # 2011-09-27T03:19:48 Ignoring transform GenTest::Transform::ExecuteAsInsertSelect that failed with the error: Lost connection to MySQL server during query # 2011-09-27T03:19:48 Offending query is: CREATE TABLE transforms.insert_select_15845 SELECT alias1 . `col_varchar_key` AS field1 FROM ( D AS alias1 , CC AS alias2 , C AS alias3 ) WHERE alias3 . `col_varchar_key` >= ( SELECT 'i' FROM DUAL ) GROUP BY field1 /* 2 */; # 2011-09-27T03:19:48 Ignoring transform GenTest::Transform::DisableChosenPlan that failed with the error: Lost connection to MySQL server during query # 2011-09-27T03:19:48 Offending query is: SELECT ( SELECT 2 FROM DUAL ) AS field1 , MIN( alias2 . `col_varchar_nokey` ) AS field2 , COUNT( alias2 . `col_int_nokey` ) AS field3 , alias2 . `col_int_key` AS field4 , ( SELECT SUM( SQ2_alias1 . `col_int_key` ) AS SQ2_field1 FROM ( C AS SQ2_alias1 STRAIGHT_JOIN ( B AS SQ2_alias2 RIGHT OUTER JOIN CC AS SQ2_alias3 ON (SQ2_alias3 . `col_varchar_key` = SQ2_alias2 . `col_varchar_key` ) ) ON (SQ2_alias3 . `pk` = SQ2_alias2 . `pk` ) ) WHERE SQ2_alias3 . `col_int_key` >= alias1 . `col_int_key` ) AS field5 FROM ( C AS alias1 , C AS alias2 , B AS alias3 ) WHERE ( alias1 . `col_varchar_nokey` > ( SELECT DISTINCT COUNT( SQ3_alias1 . `col_varchar_nokey` ) AS SQ3_field1 FROM ( C AS SQ3_alias1 STRAIGHT_JOIN ( CC AS SQ3_alias2 STRAIGHT_JOIN CC AS SQ3_alias3 ON (SQ3_alias3 . `col_varchar_key` = SQ3_alias2 . `col_varchar_key` OR SQ3_alias2 . `col_varchar_nokey` IN ( SELECT 7 UNION SELECT 7 ) ) ) ON (SQ3_alias3 . `col_varchar_nokey` = SQ3_alias2 . `col_varchar_key` ) ) ) ) AND ( alias1 . `col_varchar_key` IN ('USA' , 'v' , 'USA') OR alias1 . `col_int_key` BETWEEN 40 AND ( 40 + 81 ) ) GROUP BY field1, field4, field5 HAVING field3 > 'ip' ORDER BY alias1 . `col_time_key` DESC , field1, field2, field3, field4, field5 /* 4 */ /* TRANSFORM_OUTCOME_UNORDERED_MATCH */ ;; # 2011-09-27T03:19:48 Server crash reported at dsn dbi:mysql:host=127.0.0.1:port=13000:user=root:database=test # 2011-09-27T03:19:48 Query: /* GenTest::Transform::DisableChosenPlan */ SET @switch_saved = @@optimizer_switch; failed: 2013 Lost connection to MySQL server during query # 2011-09-27T03:19:48 Server crash reported at dsn dbi:mysql:host=127.0.0.1:port=13000:user=root:database=test # 2011-09-27T03:19:48 Ignoring transform GenTest::Transform::DisableChosenPlan that failed with the error: Lost connection to MySQL server during query # 2011-09-27T03:19:48 Offending query is: /* GenTest::Transform::DisableChosenPlan */ SET @switch_saved = @@optimizer_switch;; # 2011-09-27T03:19:48 Query: /* GenTest::Transform::ConvertLiteralsToSubqueries */ INSERT IGNORE INTO literals.integers VALUES (2); failed: 2006 MySQL server has gone away # 2011-09-27T03:19:48 The following rules produced no STATUS_OK queries: char_single_member_child_subquery (STATUS_SEMANTIC_ERROR), child_subquery_having_item (STATUS_SEMANTIC_ERROR), subquery_having_list (STATUS_SEMANTIC_ERROR), child_subquery_having_list (STATUS_SEMANTIC_ERROR), double_child_subquery_group_by (STATUS_SEMANTIC_ERROR), subquery_having_item (STATUS_SEMANTIC_ERROR) # 2011-09-27T03:19:48 Ignoring transform GenTest::Transform::ConvertLiteralsToSubqueries that failed with the error: MySQL server has gone away # 2011-09-27T03:19:48 Offending query is: /* GenTest::Transform::ConvertLiteralsToSubqueries */ INSERT IGNORE INTO literals.integers VALUES (2);; # 2011-09-27T03:19:48 The following rules produced no STATUS_OK queries: child_subquery_having (STATUS_SEMANTIC_ERROR), subquery_having_list (STATUS_SEMANTIC_ERROR), { "C_SQ".$child_subquery_idx."_field2" } (STATUS_SEMANTIC_ERROR), child_subquery_where_list (STATUS_SEMANTIC_ERROR), int_double_member_child_subquery (STATUS_SEMANTIC_ERROR), int_single_member_child_subquery (STATUS_SEMANTIC_ERROR), subquery_having_item (STATUS_SEMANTIC_ERROR), single_child_subquery_group_by (STATUS_SEMANTIC_ERROR) # GenTest::Transform::InlineSubqueries: queries_processed: 76; queries_transformed: # GenTest::Transform::ExecuteAsWhereSubquery: queries_processed: 76; queries_transformed: 5 # GenTest::Transform::InlineSubqueries: queries_processed: 66; queries_transformed: # GenTest::Transform::ExecuteAsUpdateDelete: queries_processed: 76; queries_transformed: 2 # GenTest::Transform::ExecuteAsWhereSubquery: queries_processed: 66; queries_transformed: 2 # GenTest::Transform::ExecuteAsSelectItem: queries_processed: 76; queries_transformed: # GenTest::Transform::ExecuteAsUpdateDelete: queries_processed: 66; queries_transformed: 2 # GenTest::Transform::ExecuteAsInsertSelect: queries_processed: 76; queries_transformed: 76 # GenTest::Transform::ExecuteAsSelectItem: queries_processed: 66; queries_transformed: # GenTest::Transform::ConvertLiteralsToSubqueries: queries_processed: 76; queries_transformed: 96 # GenTest::Transform::ExecuteAsInsertSelect: queries_processed: 66; queries_transformed: 66 # GenTest::Transform::ConvertLiteralsToSubqueries: queries_processed: 66; queries_transformed: 76 # 2011-09-27T03:19:48 DisableChosenPlan statistics: # 2011-09-27T03:19:48 DisableChosenPlan statistics: $VAR1 = { ' => optimizer_switch=\'in_to_exists=off,materialization=on\'' => 11, ' optimizer_switch=\'materialization=off,in_to_exists=on\'' => 4, 'Start temporary => optimizer_switch=\'semijoin=off\'' => 2, 'materializ => optimizer_switch=\'materialization=off,in_to_exists=on\'' => 4 }; $VAR1 = { ' => optimizer_switch=\'in_to_exists=off,materialization=on\'' => 16, ' optimizer_switch=\'materialization=off,in_to_exists=on\'' => 9, 'Start temporary => optimizer_switch=\'semijoin=off\'' => 4, 'materializ => optimizer_switch=\'materialization=off,in_to_exists=on\'' => 9 }; # 2011-09-27T03:19:48 Query: /* GenTest::Transform::ConvertLiteralsToSubqueries */ INSERT IGNORE INTO literals.integers VALUES (6); failed: 2006 MySQL server has gone away # 2011-09-27T03:19:48 Query: /* GenTest::Transform::ExecuteAsInsertSelect */ DROP TABLE IF EXISTS transforms.insert_select_15849 failed: 2006 MySQL server has gone away # 2011-09-27T03:19:48 Ignoring transform GenTest::Transform::ConvertLiteralsToSubqueries that failed with the error: MySQL server has gone away # 2011-09-27T03:19:48 Offending query is: /* GenTest::Transform::ConvertLiteralsToSubqueries */ INSERT IGNORE INTO literals.integers VALUES (6);; # 2011-09-27T03:19:48 Ignoring transform GenTest::Transform::ExecuteAsInsertSelect that failed with the error: MySQL server has gone away # 2011-09-27T03:19:48 Offending query is: /* GenTest::Transform::ExecuteAsInsertSelect */ DROP TABLE IF EXISTS transforms.insert_select_15849; # 2011-09-27T03:19:48 Query: /* GenTest::Transform::ExecuteAsInsertSelect */ DROP TABLE IF EXISTS transforms.insert_select_15855 failed: 2006 MySQL server has gone away # 2011-09-27T03:19:48 Ignoring transform GenTest::Transform::ExecuteAsInsertSelect that failed with the error: MySQL server has gone away # 2011-09-27T03:19:48 Offending query is: /* GenTest::Transform::ExecuteAsInsertSelect */ DROP TABLE IF EXISTS transforms.insert_select_15855; # 2011-09-27T03:19:48 Query: /* GenTest::Transform::ExecuteAsUpdateDelete */ DROP TABLE IF EXISTS transforms.where_updatedelete_15855 failed: 2006 MySQL server has gone away # 2011-09-27T03:19:48 Ignoring transform GenTest::Transform::ExecuteAsUpdateDelete that failed with the error: MySQL server has gone away # 2011-09-27T03:19:48 Offending query is: /* GenTest::Transform::ExecuteAsUpdateDelete */ DROP TABLE IF EXISTS transforms.where_updatedelete_15855; # 2011-09-27T03:19:48 Query: /* GenTest::Transform::ExecuteAsWhereSubquery */ DROP TABLE IF EXISTS transforms.where_subselect_15855 failed: 2006 MySQL server has gone away # 2011-09-27T03:19:48 Ignoring transform GenTest::Transform::ExecuteAsWhereSubquery that failed with the error: MySQL server has gone away # 2011-09-27T03:19:48 Offending query is: /* GenTest::Transform::ExecuteAsWhereSubquery */ DROP TABLE IF EXISTS transforms.where_subselect_15855; # 2011-09-27T03:19:48 Query: SELECT alias1 . `col_time_key` AS field1 , alias2 . `col_varchar_key` AS field2 , alias2 . `col_date_key` AS field3 , alias1 . `col_varchar_nokey` AS field4 , alias1 . `col_int_key` AS field5 , alias1 . `col_int_key` AS field6 , alias1 . `col_varchar_nokey` AS field7 , alias1 . `col_int_key` AS field8 FROM ( CC AS alias1 , C AS alias2 , BB AS alias3 ) WHERE ( NOT EXISTS ( ( SELECT SQ1_alias1 . `pk` AS SQ1_field1 FROM CC AS SQ1_alias1 ) ) ) AND alias3 . `col_varchar_nokey` <> 's' ORDER BY alias1 . `col_int_key` DESC , alias1 . `col_time_key` , alias3 .`pk` DESC , field8 DESC , alias1 . `col_datetime_key` , alias3 .`pk` ASC /* 1 */ failed: 2006 MySQL server has gone away # 2011-09-27T03:19:48 Server crash reported at dsn dbi:mysql:host=127.0.0.1:port=13000:user=root:database=test # 2011-09-27T03:19:48 The following rules produced no STATUS_OK queries: child_subquery_having_item (STATUS_SEMANTIC_ERROR), child_subquery_having_list (STATUS_SEMANTIC_ERROR), int_single_value_child_subquery (STATUS_SEMANTIC_ERROR), char_double_member_child_subquery (STATUS_SEMANTIC_ERROR) # GenTest::Transform::InlineSubqueries: queries_processed: 54; queries_transformed: # GenTest::Transform::ExecuteAsWhereSubquery: queries_processed: 54; queries_transformed: 3 # GenTest::Transform::ExecuteAsUpdateDelete: queries_processed: 54; queries_transformed: 2 # GenTest::Transform::ExecuteAsSelectItem: queries_processed: 54; queries_transformed: # GenTest::Transform::ExecuteAsInsertSelect: queries_processed: 54; queries_transformed: 53 # GenTest::Transform::ConvertLiteralsToSubqueries: queries_processed: 54; queries_transformed: 65 # 2011-09-27T03:19:48 DisableChosenPlan statistics: $VAR1 = { ' => optimizer_switch=\'in_to_exists=off,materialization=on\'' => 13, ' optimizer_switch=\'materialization=off,in_to_exists=on\'' => 5, 'Start temporary => optimizer_switch=\'semijoin=off\'' => 1, 'materializ => optimizer_switch=\'materialization=off,in_to_exists=on\'' => 5 }; # 2011-09-27T03:19:48 Query: SELECT alias1 . `col_varchar_key` AS field1 , alias1 . `col_datetime_key` AS field2 , alias2 . `col_date_key` AS field3 FROM ( C AS alias1 , C AS alias2 ) WHERE ( SELECT MAX( SQ1_alias1 . `col_varchar_nokey` ) AS SQ1_field1 FROM ( C AS SQ1_alias1 LEFT OUTER JOIN ( CC AS SQ1_alias2 INNER JOIN CC AS SQ1_alias3 ON (SQ1_alias3 . `pk` = SQ1_alias2 . `col_int_nokey` ) ) ON (SQ1_alias3 . `col_varchar_nokey` = SQ1_alias2 . `col_varchar_key` ) ) ) IS NOT NULL ORDER BY alias1 . `col_date_key` DESC , alias1 . `col_datetime_key` , alias2 .`pk` DESC, field1, field2, field3 /* 2 */ failed: 2006 MySQL server has gone away # 2011-09-27T03:19:48 Query: SELECT alias2 . `col_time_key` AS field1 FROM ( view_CC AS alias1 INNER JOIN ( ( C AS alias2 INNER JOIN C AS alias3 ON (alias3 . `col_int_nokey` = alias2 . `col_int_key` ) ) ) ON (alias3 . `col_varchar_key` = alias2 . `col_varchar_key` ) ) WHERE EXISTS ( SELECT SQ1_alias2 . `col_int_key` AS SQ1_field1 FROM C AS SQ1_alias1 WHERE SQ1_alias1 . `col_varchar_key` >= alias3 . `col_varchar_key` ) ORDER BY field1 ASC, field1 LIMIT 1 OFFSET 3 /* 4 */ failed: 2006 MySQL server has gone away # 2011-09-27T03:19:48 Server crash reported at dsn dbi:mysql:host=127.0.0.1:port=13000:user=root:database=test # 2011-09-27T03:19:48 Server crash reported at dsn dbi:mysql:host=127.0.0.1:port=13000:user=root:database=test # 2011-09-27T03:19:48 The following rules produced no STATUS_OK queries: subquery_having_list (STATUS_SEMANTIC_ERROR), subquery_having_item (STATUS_SEMANTIC_ERROR), char_double_member_child_subquery (STATUS_SEMANTIC_ERROR) # GenTest::Transform::InlineSubqueries: queries_processed: 69; queries_transformed: # GenTest::Transform::ExecuteAsWhereSubquery: queries_processed: 69; queries_transformed: 3 # GenTest::Transform::ExecuteAsUpdateDelete: queries_processed: 69; queries_transformed: 1 # GenTest::Transform::ExecuteAsSelectItem: queries_processed: 69; queries_transformed: # GenTest::Transform::ExecuteAsInsertSelect: queries_processed: 69; queries_transformed: 68 # 2011-09-27T03:19:48 The following rules produced no STATUS_OK queries: subquery_having_list (STATUS_SEMANTIC_ERROR), subquery_having_item (STATUS_SEMANTIC_ERROR) # GenTest::Transform::ConvertLiteralsToSubqueries: queries_processed: 69; queries_transformed: 85 # GenTest::Transform::InlineSubqueries: queries_processed: 111; queries_transformed: # 2011-09-27T03:19:48 DisableChosenPlan statistics: # GenTest::Transform::ExecuteAsWhereSubquery: queries_processed: 111; queries_transformed: 12 # GenTest::Transform::ExecuteAsUpdateDelete: queries_processed: 111; queries_transformed: 8 # GenTest::Transform::ExecuteAsSelectItem: queries_processed: 111; queries_transformed: # GenTest::Transform::ExecuteAsInsertSelect: queries_processed: 111; queries_transformed: 110 $VAR1 = { ' => optimizer_switch=\'in_to_exists=off,materialization=on\'' => 18, ' optimizer_switch=\'materialization=off,in_to_exists=on\'' => 9, 'Start temporary => optimizer_switch=\'semijoin=off\'' => 2, 'materializ => optimizer_switch=\'materialization=off,in_to_exists=on\'' => 9 }; # GenTest::Transform::ConvertLiteralsToSubqueries: queries_processed: 111; queries_transformed: 128 # 2011-09-27T03:19:48 DisableChosenPlan statistics: $VAR1 = { ' => optimizer_switch=\'in_to_exists=off,materialization=on\'' => 28, ' optimizer_switch=\'materialization=off,in_to_exists=on\'' => 15, 'Start temporary => optimizer_switch=\'semijoin=off\'' => 2, 'materializ => optimizer_switch=\'materialization=off,in_to_exists=on\'' => 12 }; # 2011-09-27T03:19:48 Killing child process with pid 15849... # 2011-09-27T03:19:48 Killing child process with pid 15847... # 2011-09-27T03:19:48 Killing child process with pid 15845... # 2011-09-27T03:19:48 Killing child process with pid 15855... # 2011-09-27T03:19:48 Killing child process with pid 15843... # 2011-09-27T03:19:48 The following rules produced no STATUS_OK queries: char_single_member_child_subquery (STATUS_SEMANTIC_ERROR), special_child_subquery (STATUS_SEMANTIC_ERROR), subquery_having_list (STATUS_SEMANTIC_ERROR), subquery_having_item (STATUS_SEMANTIC_ERROR) # GenTest::Transform::InlineSubqueries: queries_processed: 81; queries_transformed: # GenTest::Transform::ExecuteAsWhereSubquery: queries_processed: 81; queries_transformed: 5 # GenTest::Transform::ExecuteAsUpdateDelete: queries_processed: 81; queries_transformed: 3 # GenTest::Transform::ExecuteAsSelectItem: queries_processed: 81; queries_transformed: # GenTest::Transform::ExecuteAsInsertSelect: queries_processed: 81; queries_transformed: 80 # GenTest::Transform::ConvertLiteralsToSubqueries: queries_processed: 81; queries_transformed: 90 # 2011-09-27T03:19:48 DisableChosenPlan statistics: $VAR1 = { ' => optimizer_switch=\'in_to_exists=off,materialization=on\'' => 17, ' optimizer_switch=\'materialization=off,in_to_exists=on\'' => 6, 'Start temporary => optimizer_switch=\'semijoin=off\'' => 2, 'materializ => optimizer_switch=\'materialization=off,in_to_exists=on\'' => 7 }; # 2011-09-27T03:19:48 Statistics for Executor dbi:mysql:host=127.0.0.1:port=13000:user=root:database=test # 2011-09-27T03:19:48 Rows returned: $VAR1 = { ' 0' => 342, ' 1' => 53, ' 3' => 10, ' 7' => 5, ' 8' => 7, ' -1' => 15, '>10' => 38, '>100' => 16 }; # 2011-09-27T03:19:48 Rows affected: $VAR1 = { ' 0' => 247, ' 1' => 28, ' 3' => 6, ' 7' => 4, ' 8' => 4, '>10' => 28, '>100' => 12 }; # 2011-09-27T03:19:48 Explain items: $VAR1 = { '<>' => 34, '' => 94, '' => 57, '' => 76, '' => 130, '' => 20, '' => 6, '' => 8, '' => 4, '' => 11, '' => 28, '' => 33, 'extra: (empty)' => 260, 'extra: Distinct' => 6, 'extra: End temporary' => 6, 'extra: Full scan on NULL key' => 1, 'extra: Impossible WHERE' => 10, 'extra: Impossible WHERE noticed after reading const tables' => 70, 'extra: No matching min/max row' => 3, 'extra: No tables used' => 131, 'extra: Select tables optimized away' => 6, 'extra: Start temporary' => 6, 'extra: Using filesort' => 85, 'extra: Using index' => 226, 'extra: Using join buffer (flat, BNL join)' => 169, 'extra: Using sort_union(%s,%s)' => 5, 'extra: Using temporary' => 113, 'extra: Using union(%s,%s)' => 3, 'extra: Using where' => 370, 'extra: const row not found' => 186, 'ref: ' => 1027, 'ref: .SQ1_field1' => 3, 'ref: .SQ1_field2' => 3, 'ref: const' => 106, 'ref: const,const' => 4, 'ref: func' => 4, 'ref: func,func' => 1, 'ref: test.C.pk' => 4, 'ref: test.C_SQ1_alias2.col_varchar_key,test.C_SQ1_alias2.col_int_key' => 2, 'ref: test.SQ1_alias1.col_int_key' => 9, 'ref: test.SQ1_alias1.col_varchar_nokey' => 4, 'ref: test.SQ1_alias1.pk' => 5, 'ref: test.SQ1_alias2.col_int_key' => 5, 'ref: test.SQ1_alias2.col_int_nokey' => 1, 'ref: test.SQ1_alias2.col_varchar_key' => 7, 'ref: test.SQ1_alias2.col_varchar_key,test.SQ1_alias2.col_int_key' => 1, 'ref: test.SQ1_alias2.pk' => 1, 'ref: test.SQ1_alias3.col_int_nokey' => 3, 'ref: test.SQ2_alias1.col_int_key' => 4, 'ref: test.SQ2_alias1.col_int_nokey' => 2, 'ref: test.SQ2_alias1.col_varchar_nokey' => 1, 'ref: test.SQ2_alias1.pk' => 3, 'ref: test.SQ2_alias2.col_int_key' => 2, 'ref: test.SQ2_alias2.col_int_nokey' => 2, 'ref: test.SQ2_alias3.col_int_key' => 5, 'ref: test.alias1.col_int_key' => 7, 'ref: test.alias1.col_int_nokey' => 8, 'ref: test.alias1.col_varchar_key' => 7, 'ref: test.alias1.col_varchar_nokey' => 6, 'ref: test.alias2.col_int_key' => 13, 'ref: test.alias2.col_varchar_key' => 2, 'ref: test.alias2.col_varchar_key,test.alias1.col_int_key' => 3, 'ref: test.alias2.col_varchar_nokey' => 6, 'ref: test.alias2.pk' => 4, 'ref: transforms.where_subselect_15855.field1' => 1, 'ref: transforms.where_subselect_15855.field1,transforms.where_subselect_15855.field2,transforms.where_subselect_15855.field3,transforms.where_subselect_15855.field4' => 1, 'select_type: DEPENDENT SUBQUERY' => 204, 'select_type: DEPENDENT UNION' => 48, 'select_type: PRIMARY' => 448, 'select_type: SIMPLE' => 258, 'select_type: SUBQUERY' => 243, 'select_type: UNION' => 9, 'select_type: UNION RESULT' => 57, 'type: (empty)' => 220, 'type: ALL' => 363, 'type: const' => 74, 'type: eq_ref' => 53, 'type: index' => 129, 'type: index_merge' => 8, 'type: range' => 12, 'type: ref' => 113, 'type: system' => 295 }; # 2011-09-27T03:19:48 Errors: $VAR1 = { '(no error)' => 1328, 'Unknown column \'%s\' in \'IN/ALL/ANY subquery\'' => 5, 'Unknown column \'%s\' in \'field list\'' => 6, 'Unknown column \'%s\' in \'having clause\'' => 4 }; # 2011-09-27T03:19:48 Rare EXPLAIN items: $VAR1 = { '' => [ ' SELECT DISTINCT alias1 . `pk` AS field1 , alias2 . `col_int_key` AS field2 , alias2 . `pk` AS field3 FROM ( view_C AS alias1 STRAIGHT_JOIN C AS alias2 ON (alias2 . `col_int_key` = alias1 . `pk` AND ( \'x\', \'m\' ) IN ( SELECT \'l\' , \'h\' UNION SELECT \'i\' , \'w\' ) ) ) WHERE ( alias1 . `col_varchar_key` >= ALL ( SELECT SQ2_alias1 . `col_varchar_key` AS SQ2_field1 FROM C AS SQ2_alias1 ) ) AND ( alias1 . `col_varchar_key` = \'z\' OR alias1 . `col_varchar_key` NOT IN (\'f\') ) /* 6 */', ' SELECT DISTINCT alias1 . `pk` AS field1 , alias2 . `col_int_key` AS field2 , alias2 . `pk` AS field3 FROM ( view_C AS alias1 STRAIGHT_JOIN C AS alias2 ON (alias2 . `col_int_key` = alias1 . `pk` AND ( \'x\', \'m\' ) IN ( SELECT \'l\' , \'h\' UNION SELECT \'i\' , \'w\' ) ) ) WHERE ( alias1 . `col_varchar_key` >= ALL ( SELECT SQ2_alias1 . `col_varchar_key` AS SQ2_field1 FROM C AS SQ2_alias1 ) ) AND ( alias1 . `col_varchar_key` = \'z\' OR alias1 . `col_varchar_key` NOT IN (\'f\') ) /* 6 */ /* TRANSFORM_OUTCOME_UNORDERED_MATCH */ ;', ' SELECT DISTINCT alias1 . `pk` AS field1 , alias2 . `col_int_key` AS field2 , alias2 . `pk` AS field3 FROM ( view_C AS alias1 STRAIGHT_JOIN C AS alias2 ON (alias2 . `col_int_key` = alias1 . `pk` AND ( \'x\', \'m\' ) IN ( SELECT \'l\' , \'h\' UNION SELECT \'i\' , \'w\' ) ) ) WHERE ( alias1 . `col_varchar_key` >= ALL ( SELECT SQ2_alias1 . `col_varchar_key` AS SQ2_field1 FROM C AS SQ2_alias1 ) ) AND ( alias1 . `col_varchar_key` = \'z\' OR alias1 . `col_varchar_key` NOT IN (\'f\') ) /* (SELECT i1 FROM literals.integers WHERE i1 = 6 ) */ /* TRANSFORM_OUTCOME_UNORDERED_MATCH */', ' SELECT DISTINCT alias1 . `pk` AS field1 , alias2 . `col_int_key` AS field2 , alias2 . `pk` AS field3 FROM ( view_C AS alias1 STRAIGHT_JOIN C AS alias2 ON (alias2 . `col_int_key` = alias1 . `pk` AND ( (SELECT s1 FROM literals.strings WHERE s1 = \'x\' ) , \'m\' ) IN ( SELECT \'l\' , \'h\' UNION SELECT \'i\' , \'w\' ) ) ) WHERE ( alias1 . `col_varchar_key` >= ALL ( SELECT SQ2_alias1 . `col_varchar_key` AS SQ2_field1 FROM C AS SQ2_alias1 ) ) AND ( alias1 . `col_varchar_key` = \'z\' OR alias1 . `col_varchar_key` NOT IN (\'f\') ) /* 6 */ /* TRANSFORM_OUTCOME_UNORDERED_MATCH */' ], 'extra: Full scan on NULL key' => [ ' SELECT STRAIGHT_JOIN SQL_SMALL_RESULT MIN( alias2 . `col_varchar_key` ) AS field1 FROM ( C AS alias1 INNER JOIN A AS alias2 ON (alias2 . `col_varchar_nokey` = alias1 . `col_varchar_key` ) ) WHERE ( ( (SELECT i1 FROM literals.integers WHERE i1 = 5 ) , 1 ) NOT IN ( SELECT SQ1_alias1 . `pk` AS SQ1_field1 , SQ1_alias2 . `pk` AS SQ1_field2 FROM ( C AS SQ1_alias1 INNER JOIN ( CC AS SQ1_alias2 INNER JOIN view_CC AS SQ1_alias3 ON (SQ1_alias3 . `col_varchar_key` = SQ1_alias2 . `col_varchar_key` ) ) ON (SQ1_alias3 . `col_varchar_nokey` = SQ1_alias2 . `col_varchar_key` ) ) ) ) AND alias1 . `col_int_key` = 144 HAVING field1 <> \'USA\' ORDER BY alias1 . `col_date_key` ASC , alias1 . `col_time_key` , alias2 .`pk` /* 6 */ /* TRANSFORM_OUTCOME_UNORDERED_MATCH */' ], 'extra: No matching min/max row' => [ ' SELECT MIN( DISTINCT alias1 . `col_int_key` ) AS field1, SUM( alias1 . `col_varchar_key` ) AS field2 FROM ( CC AS alias1 , C AS alias2 ) WHERE ( alias2 . `col_int_nokey` = ALL ( SELECT 1 FROM DUAL ) ) AND alias1 . `col_int_key` > 129 AND alias1 . `col_int_key` < ( 129 + 104 ) HAVING ((field2 > \'qn\' AND field2 > \'c\') OR field1 <= 5) /* 6 */', ' SELECT MIN( DISTINCT alias1 . `col_int_key` ) AS field1, SUM( alias1 . `col_varchar_key` ) AS field2 FROM ( CC AS alias1 , C AS alias2 ) WHERE ( alias2 . `col_int_nokey` = ALL ( SELECT (SELECT i1 FROM literals.integers WHERE i1 = 1 ) FROM DUAL ) ) AND alias1 . `col_int_key` > 129 AND alias1 . `col_int_key` < ( 129 + 104 ) HAVING ((field2 > \'qn\' AND field2 > \'c\') OR field1 <= 5) /* 6 */ /* TRANSFORM_OUTCOME_UNORDERED_MATCH */', ' SELECT MIN( DISTINCT alias1 . `col_int_key` ) AS field1, SUM( alias1 . `col_varchar_key` ) AS field2 FROM ( CC AS alias1 , C AS alias2 ) WHERE ( alias2 . `col_int_nokey` = ALL ( SELECT 1 FROM DUAL ) ) AND alias1 . `col_int_key` > 129 AND alias1 . `col_int_key` < ( 129 + 104 ) HAVING ((field2 > (SELECT s1 FROM literals.strings WHERE s1 = \'qn\' ) AND field2 > \'c\') OR field1 <= 5) /* 6 */ /* TRANSFORM_OUTCOME_UNORDERED_MATCH */' ], 'extra: Using sort_union(%s,%s)' => [ ' SELECT alias1 . `col_varchar_nokey` AS field1 , ( ( alias1 . `col_int_key` ) * ( alias2 . `col_int_key` ) ) AS field2 , alias1 . `col_varchar_nokey` AS field3 , ( SELECT MAX( SQ1_alias2 . `col_int_key` ) AS SQ1_field1 FROM ( A AS SQ1_alias1 INNER JOIN ( C AS SQ1_alias2 INNER JOIN C AS SQ1_alias3 ON (SQ1_alias3 . `pk` = SQ1_alias2 . `pk` ) ) ON (SQ1_alias3 . `pk` = SQ1_alias2 . `col_int_key` ) ) WHERE ( SQ1_alias1 . `col_varchar_key` <= SQ1_alias1 . `col_varchar_key` OR SQ1_alias1 . `col_int_nokey` >= SQ1_alias3 . `pk` ) ) AS field4 , alias1 . `pk` AS field5 FROM ( C AS alias1 STRAIGHT_JOIN D AS alias2 ON (alias2 . `col_varchar_key` = alias1 . `col_varchar_nokey` ) ) WHERE ( EXISTS ( SELECT SQ2_alias1 . `pk` AS SQ2_field1 FROM ( C AS SQ2_alias1 STRAIGHT_JOIN CC AS SQ2_alias2 ON (SQ2_alias2 . `pk` = SQ2_alias1 . `pk` ) ) WHERE SQ2_alias2 . `col_int_key` <> alias2 . `col_int_key` AND SQ2_alias2 . `col_varchar_key` != SQ2_alias2 . `col_varchar_key` ) ) AND alias1 . `col_int_key` = 21 OR ( alias1 . `col_varchar_key` = \'h\' AND alias2 . `col_varchar_key` <> \'u\' ) GROUP BY field1, field2, field3, field4, field5 HAVING (field1 < 94 AND field4 >= \'s\') /* 6 */', ' SELECT alias1 . `pk` AS field1 , alias1 . `col_varchar_key` AS field2 FROM ( C AS alias1 , CC AS alias2 , CC AS alias3 ) WHERE ( EXISTS ( ( SELECT SQ1_alias1 . `col_int_nokey` AS SQ1_field1 FROM C AS SQ1_alias1 GROUP BY SQ1_field1 ) ) ) AND ( alias1 . `pk` > 107 AND alias1 . `pk` < ( 107 + 56 ) OR alias1 . `col_int_key` BETWEEN 107 AND ( 107 + 245 ) ) GROUP BY field1, field2 ORDER BY CONCAT ( alias2 . `col_varchar_key`, alias1 . `col_varchar_key` ) /* 6 */', ' SELECT SUM( alias2 . `col_varchar_key` ) AS field1 , alias2 . `col_int_key` AS field2 , ( SELECT 5 FROM DUAL ) AS field3 FROM ( C AS alias1 , D AS alias2 ) WHERE ( alias1 . `pk` = ( SELECT 4 FROM DUAL ) ) AND ( alias1 . `pk` NOT BETWEEN 231 AND ( 231 + 133 ) OR alias1 . `pk` IN (237, 68) ) OR ( alias2 . `col_varchar_nokey` <= \'r\' AND alias1 . `col_varchar_key` IS NULL ) GROUP BY field2, field3 /* 6 */', ' SELECT SUM( alias2 . `col_varchar_key` ) AS field1 , alias2 . `col_int_key` AS field2 , ( SELECT (SELECT i1 FROM literals.integers WHERE i1 = 5 ) FROM DUAL ) AS field3 FROM ( C AS alias1 , D AS alias2 ) WHERE ( alias1 . `pk` = ( SELECT 4 FROM DUAL ) ) AND ( alias1 . `pk` NOT BETWEEN 231 AND ( 231 + 133 ) OR alias1 . `pk` IN (237, 68) ) OR ( alias2 . `col_varchar_nokey` <= \'r\' AND alias1 . `col_varchar_key` IS NULL ) GROUP BY field2, field3 /* 6 */ /* TRANSFORM_OUTCOME_UNORDERED_MATCH */', ' SELECT SUM( alias2 . `col_varchar_key` ) AS field1 , alias2 . `col_int_key` AS field2 , ( SELECT 5 FROM DUAL ) AS field3 FROM ( C AS alias1 , D AS alias2 ) WHERE ( alias1 . `pk` = ( SELECT 4 FROM DUAL ) ) AND ( alias1 . `pk` NOT BETWEEN 231 AND ( 231 + 133 ) OR alias1 . `pk` IN (237, 68) ) OR ( alias2 . `col_varchar_nokey` <= (SELECT s1 FROM literals.strings WHERE s1 = \'r\' ) AND alias1 . `col_varchar_key` IS NULL ) GROUP BY field2, field3 /* 6 */ /* TRANSFORM_OUTCOME_UNORDERED_MATCH */' ], 'extra: Using union(%s,%s)' => [ ' SELECT alias1 . `col_date_key` AS field1 , alias2 . `col_time_key` AS field2 , alias1 . `col_time_key` AS field3 FROM ( CC AS alias1 , C AS alias2 ) WHERE ( ( 3, 1 ) NOT IN ( SELECT 4 , 4 UNION SELECT 142, 6 ) ) AND ( alias1 . `col_int_key` = 239 OR alias1 . `pk` = 84 ) ORDER BY alias1 . `col_varchar_key` ASC , field1, field2, field3 /* 6 */', ' SELECT alias1 . `col_date_key` AS field1 , alias2 . `col_time_key` AS field2 , alias1 . `col_time_key` AS field3 FROM ( CC AS alias1 , C AS alias2 ) WHERE ( ( 3, 1 ) NOT IN ( SELECT 4 , 4 UNION SELECT 142, 6 ) ) AND ( alias1 . `col_int_key` = 239 OR alias1 . `pk` = 84 ) ORDER BY alias1 . `col_varchar_key` ASC , field1, field2, field3 /* 6 */ /* TRANSFORM_OUTCOME_UNORDERED_MATCH */ ;', ' SELECT alias1 . `col_date_key` AS field1 , alias2 . `col_time_key` AS field2 , alias1 . `col_time_key` AS field3 FROM ( CC AS alias1 , C AS alias2 ) WHERE ( ( (SELECT i1 FROM literals.integers WHERE i1 = 3 ) , 1 ) NOT IN ( SELECT 4 , 4 UNION SELECT 142, 6 ) ) AND ( alias1 . `col_int_key` = 239 OR alias1 . `pk` = 84 ) ORDER BY alias1 . `col_varchar_key` ASC , field1, field2, field3 /* 6 */ /* TRANSFORM_OUTCOME_UNORDERED_MATCH */' ], 'ref: .SQ1_field1' => [ ' SELECT alias1 . `col_varchar_nokey` AS field1 , alias2 . `col_varchar_key` AS field2 , alias1 . `col_date_key` AS field3 , alias1 . `col_int_nokey` AS field4 , alias1 . `col_int_key` AS field5 FROM ( CC AS alias1 , C AS alias2 ) WHERE ( ( alias1 . `col_varchar_key` , alias2 . `col_varchar_key` ) IN ( SELECT SQ1_alias1 . `col_varchar_nokey` AS SQ1_field1 , MIN( SQ1_alias1 . `col_varchar_nokey` ) AS SQ1_field2 FROM ( BB AS SQ1_alias1 STRAIGHT_JOIN ( C AS SQ1_alias2 INNER JOIN C AS SQ1_alias3 ON (SQ1_alias3 . `col_varchar_key` = SQ1_alias2 . `col_varchar_key` ) ) ON (SQ1_alias3 . `pk` = SQ1_alias2 . `col_int_key` ) ) ) ) AND alias2 . `col_varchar_nokey` = \'p\' GROUP BY field1, field2, field3, field4, field5 ORDER BY alias1 . `col_int_key` ASC , CONCAT ( alias2 . `col_varchar_key`, alias2 . `col_varchar_key` ), field1, field2, field3, field4, field5 /* 6 */', ' SELECT alias1 . `col_varchar_nokey` AS field1 , alias2 . `col_varchar_key` AS field2 , alias1 . `col_date_key` AS field3 , alias1 . `col_int_nokey` AS field4 , alias1 . `col_int_key` AS field5 FROM ( CC AS alias1 , C AS alias2 ) WHERE ( ( alias1 . `col_varchar_key` , alias2 . `col_varchar_key` ) IN ( SELECT SQ1_alias1 . `col_varchar_nokey` AS SQ1_field1 , MIN( SQ1_alias1 . `col_varchar_nokey` ) AS SQ1_field2 FROM ( BB AS SQ1_alias1 STRAIGHT_JOIN ( C AS SQ1_alias2 INNER JOIN C AS SQ1_alias3 ON (SQ1_alias3 . `col_varchar_key` = SQ1_alias2 . `col_varchar_key` ) ) ON (SQ1_alias3 . `pk` = SQ1_alias2 . `col_int_key` ) ) ) ) AND alias2 . `col_varchar_nokey` = \'p\' GROUP BY field1, field2, field3, field4, field5 ORDER BY alias1 . `col_int_key` ASC , CONCAT ( alias2 . `col_varchar_key`, alias2 . `col_varchar_key` ), field1, field2, field3, field4, field5 /* (SELECT i1 FROM literals.integers WHERE i1 = 6 ) */ /* TRANSFORM_OUTCOME_UNORDERED_MATCH */', ' SELECT alias1 . `col_varchar_nokey` AS field1 , alias2 . `col_varchar_key` AS field2 , alias1 . `col_date_key` AS field3 , alias1 . `col_int_nokey` AS field4 , alias1 . `col_int_key` AS field5 FROM ( CC AS alias1 , C AS alias2 ) WHERE ( ( alias1 . `col_varchar_key` , alias2 . `col_varchar_key` ) IN ( SELECT SQ1_alias1 . `col_varchar_nokey` AS SQ1_field1 , MIN( SQ1_alias1 . `col_varchar_nokey` ) AS SQ1_field2 FROM ( BB AS SQ1_alias1 STRAIGHT_JOIN ( C AS SQ1_alias2 INNER JOIN C AS SQ1_alias3 ON (SQ1_alias3 . `col_varchar_key` = SQ1_alias2 . `col_varchar_key` ) ) ON (SQ1_alias3 . `pk` = SQ1_alias2 . `col_int_key` ) ) ) ) AND alias2 . `col_varchar_nokey` = (SELECT s1 FROM literals.strings WHERE s1 = \'p\' ) GROUP BY field1, field2, field3, field4, field5 ORDER BY alias1 . `col_int_key` ASC , CONCAT ( alias2 . `col_varchar_key`, alias2 . `col_varchar_key` ), field1, field2, field3, field4, field5 /* 6 */ /* TRANSFORM_OUTCOME_UNORDERED_MATCH */' ], 'ref: .SQ1_field2' => [ ' SELECT alias1 . `col_varchar_nokey` AS field1 , alias2 . `col_varchar_key` AS field2 , alias1 . `col_date_key` AS field3 , alias1 . `col_int_nokey` AS field4 , alias1 . `col_int_key` AS field5 FROM ( CC AS alias1 , C AS alias2 ) WHERE ( ( alias1 . `col_varchar_key` , alias2 . `col_varchar_key` ) IN ( SELECT SQ1_alias1 . `col_varchar_nokey` AS SQ1_field1 , MIN( SQ1_alias1 . `col_varchar_nokey` ) AS SQ1_field2 FROM ( BB AS SQ1_alias1 STRAIGHT_JOIN ( C AS SQ1_alias2 INNER JOIN C AS SQ1_alias3 ON (SQ1_alias3 . `col_varchar_key` = SQ1_alias2 . `col_varchar_key` ) ) ON (SQ1_alias3 . `pk` = SQ1_alias2 . `col_int_key` ) ) ) ) AND alias2 . `col_varchar_nokey` = \'p\' GROUP BY field1, field2, field3, field4, field5 ORDER BY alias1 . `col_int_key` ASC , CONCAT ( alias2 . `col_varchar_key`, alias2 . `col_varchar_key` ), field1, field2, field3, field4, field5 /* 6 */', ' SELECT alias1 . `col_varchar_nokey` AS field1 , alias2 . `col_varchar_key` AS field2 , alias1 . `col_date_key` AS field3 , alias1 . `col_int_nokey` AS field4 , alias1 . `col_int_key` AS field5 FROM ( CC AS alias1 , C AS alias2 ) WHERE ( ( alias1 . `col_varchar_key` , alias2 . `col_varchar_key` ) IN ( SELECT SQ1_alias1 . `col_varchar_nokey` AS SQ1_field1 , MIN( SQ1_alias1 . `col_varchar_nokey` ) AS SQ1_field2 FROM ( BB AS SQ1_alias1 STRAIGHT_JOIN ( C AS SQ1_alias2 INNER JOIN C AS SQ1_alias3 ON (SQ1_alias3 . `col_varchar_key` = SQ1_alias2 . `col_varchar_key` ) ) ON (SQ1_alias3 . `pk` = SQ1_alias2 . `col_int_key` ) ) ) ) AND alias2 . `col_varchar_nokey` = \'p\' GROUP BY field1, field2, field3, field4, field5 ORDER BY alias1 . `col_int_key` ASC , CONCAT ( alias2 . `col_varchar_key`, alias2 . `col_varchar_key` ), field1, field2, field3, field4, field5 /* (SELECT i1 FROM literals.integers WHERE i1 = 6 ) */ /* TRANSFORM_OUTCOME_UNORDERED_MATCH */', ' SELECT alias1 . `col_varchar_nokey` AS field1 , alias2 . `col_varchar_key` AS field2 , alias1 . `col_date_key` AS field3 , alias1 . `col_int_nokey` AS field4 , alias1 . `col_int_key` AS field5 FROM ( CC AS alias1 , C AS alias2 ) WHERE ( ( alias1 . `col_varchar_key` , alias2 . `col_varchar_key` ) IN ( SELECT SQ1_alias1 . `col_varchar_nokey` AS SQ1_field1 , MIN( SQ1_alias1 . `col_varchar_nokey` ) AS SQ1_field2 FROM ( BB AS SQ1_alias1 STRAIGHT_JOIN ( C AS SQ1_alias2 INNER JOIN C AS SQ1_alias3 ON (SQ1_alias3 . `col_varchar_key` = SQ1_alias2 . `col_varchar_key` ) ) ON (SQ1_alias3 . `pk` = SQ1_alias2 . `col_int_key` ) ) ) ) AND alias2 . `col_varchar_nokey` = (SELECT s1 FROM literals.strings WHERE s1 = \'p\' ) GROUP BY field1, field2, field3, field4, field5 ORDER BY alias1 . `col_int_key` ASC , CONCAT ( alias2 . `col_varchar_key`, alias2 . `col_varchar_key` ), field1, field2, field3, field4, field5 /* 6 */ /* TRANSFORM_OUTCOME_UNORDERED_MATCH */' ], 'ref: const,const' => [ ' SELECT alias1 . `col_varchar_key` AS field1 , alias2 . `col_varchar_nokey` AS field2 , alias1 . `col_time_key` AS field3 , alias1 . `col_int_key` AS field4 , alias1 . `col_varchar_key` AS field5 FROM ( BB AS alias1 STRAIGHT_JOIN ( ( B AS alias2 INNER JOIN C AS alias3 ON (alias3 . `col_varchar_key` = alias2 . `col_varchar_key` ) ) ) ON (alias3 . `col_int_key` = alias2 . `col_int_key` ) ) WHERE ( EXISTS ( SELECT SQ1_alias1 . `col_int_key` AS SQ1_field1 FROM ( C AS SQ1_alias1 INNER JOIN ( C AS SQ1_alias2 INNER JOIN CC AS SQ1_alias3 ON (SQ1_alias3 . `col_int_key` = SQ1_alias2 . `col_int_key` ) ) ON (SQ1_alias3 . `col_int_nokey` = SQ1_alias2 . `pk` ) ) WHERE SQ1_alias2 . `col_int_nokey` != alias1 . `pk` OR SQ1_alias3 . `col_varchar_nokey` <= SQ1_alias2 . `col_varchar_nokey` ) ) AND ( alias1 . `pk` IN (71) OR alias1 . `col_varchar_key` IN (\'v\') ) OR ( alias1 . `col_int_key` IS NULL OR alias1 . `col_varchar_key` >= \'g\' ) ORDER BY alias1 . `col_datetime_key` ASC , field1, field2, field3, field4, field5 /* 6 */', ' SELECT alias1 . `col_varchar_key` AS field1 , alias2 . `col_varchar_nokey` AS field2 , alias1 . `col_time_key` AS field3 , alias1 . `col_int_key` AS field4 , alias1 . `col_varchar_key` AS field5 FROM ( BB AS alias1 STRAIGHT_JOIN ( ( B AS alias2 INNER JOIN C AS alias3 ON (alias3 . `col_varchar_key` = alias2 . `col_varchar_key` ) ) ) ON (alias3 . `col_int_key` = alias2 . `col_int_key` ) ) WHERE ( EXISTS ( SELECT SQ1_alias1 . `col_int_key` AS SQ1_field1 FROM ( C AS SQ1_alias1 INNER JOIN ( C AS SQ1_alias2 INNER JOIN CC AS SQ1_alias3 ON (SQ1_alias3 . `col_int_key` = SQ1_alias2 . `col_int_key` ) ) ON (SQ1_alias3 . `col_int_nokey` = SQ1_alias2 . `pk` ) ) WHERE SQ1_alias2 . `col_int_nokey` != alias1 . `pk` OR SQ1_alias3 . `col_varchar_nokey` <= SQ1_alias2 . `col_varchar_nokey` ) ) AND ( alias1 . `pk` IN (71) OR alias1 . `col_varchar_key` IN (\'v\') ) OR ( alias1 . `col_int_key` IS NULL OR alias1 . `col_varchar_key` >= \'g\' ) ORDER BY alias1 . `col_datetime_key` ASC , field1, field2, field3, field4, field5 /* (SELECT i1 FROM literals.integers WHERE i1 = 6 ) */ /* TRANSFORM_OUTCOME_UNORDERED_MATCH */', ' SELECT alias1 . `col_varchar_key` AS field1 , alias2 . `col_varchar_nokey` AS field2 , alias1 . `col_time_key` AS field3 , alias1 . `col_int_key` AS field4 , alias1 . `col_varchar_key` AS field5 FROM ( BB AS alias1 STRAIGHT_JOIN ( ( B AS alias2 INNER JOIN C AS alias3 ON (alias3 . `col_varchar_key` = alias2 . `col_varchar_key` ) ) ) ON (alias3 . `col_int_key` = alias2 . `col_int_key` ) ) WHERE ( EXISTS ( SELECT SQ1_alias1 . `col_int_key` AS SQ1_field1 FROM ( C AS SQ1_alias1 INNER JOIN ( C AS SQ1_alias2 INNER JOIN CC AS SQ1_alias3 ON (SQ1_alias3 . `col_int_key` = SQ1_alias2 . `col_int_key` ) ) ON (SQ1_alias3 . `col_int_nokey` = SQ1_alias2 . `pk` ) ) WHERE SQ1_alias2 . `col_int_nokey` != alias1 . `pk` OR SQ1_alias3 . `col_varchar_nokey` <= SQ1_alias2 . `col_varchar_nokey` ) ) AND ( alias1 . `pk` IN (71) OR alias1 . `col_varchar_key` IN (\'v\') ) OR ( alias1 . `col_int_key` IS NULL OR alias1 . `col_varchar_key` >= (SELECT s1 FROM literals.strings WHERE s1 = \'g\' ) ) ORDER BY alias1 . `col_datetime_key` ASC , field1, field2, field3, field4, field5 /* 6 */ /* TRANSFORM_OUTCOME_UNORDERED_MATCH */', 'SELECT * FROM transforms.where_subselect_15855 WHERE (field1, field2) IN ( SELECT STRAIGHT_JOIN MIN( alias2 . `col_varchar_nokey` ) AS field1 , ( SELECT \'e\' FROM DUAL ) AS field2 FROM ( CC AS alias1 INNER JOIN ( ( C AS alias2 INNER JOIN CC AS alias3 ON (alias3 . `col_int_nokey` = alias2 . `col_int_key` ) ) ) ON (alias3 . `col_int_key` = alias2 . `col_int_key` ) ) WHERE ( EXISTS ( SELECT SQ2_alias1 . `col_int_key` AS SQ2_field1 FROM ( CC AS SQ2_alias1 RIGHT JOIN ( C AS SQ2_alias2 INNER JOIN CC AS SQ2_alias3 ON (SQ2_alias3 . `col_int_key` = SQ2_alias2 . `col_int_key` ) ) ON (SQ2_alias3 . `col_int_nokey` = SQ2_alias2 . `pk` ) ) WHERE SQ2_alias2 . `col_int_key` <= alias2 . `pk` OR SQ2_alias3 . `col_varchar_nokey` != alias1 . `col_varchar_nokey` ) ) OR alias1 . `pk` > 25 AND alias1 . `pk` < ( 25 + 8 ) OR alias1 . `col_varchar_nokey` IS NULL GROUP BY field2 ORDER BY CONCAT ( alias1 . `col_varchar_key`, alias1 . `col_varchar_key` ) , CONCAT ( alias3 . `col_varchar_nokey`, alias1 . `col_varchar_key` ) /* 6 */ ) /* TRANSFORM_OUTCOME_UNORDERED_MATCH */' ], 'ref: func' => [ ' SELECT alias1 . `col_datetime_key` AS field1 , alias1 . `col_time_key` AS field2 , alias1 . `col_int_key` AS field3 , alias1 . `col_int_key` AS field4 FROM ( BB AS alias1 , CC AS alias2 ) WHERE ( alias2 . `col_varchar_nokey` < ( SELECT MAX( SQ1_alias1 . `col_varchar_key` ) AS SQ1_field1 FROM C AS SQ1_alias1 ) ) AND ( alias2 . `col_varchar_key` IN ( SELECT SQ2_alias2 . `col_varchar_key` AS SQ2_field1 FROM ( C AS SQ2_alias1 , C AS SQ2_alias2 ) ) AND alias1 . `col_int_nokey` = alias1 . `col_int_nokey` ) ORDER BY alias1 . `col_date_key` , field1, field2, field3, field4 /* 6 */', ' SELECT alias1 . `col_datetime_key` AS field1 , alias1 . `col_time_key` AS field2 , alias1 . `col_int_key` AS field3 , alias1 . `col_int_key` AS field4 FROM ( BB AS alias1 , CC AS alias2 ) WHERE ( alias2 . `col_varchar_nokey` < ( SELECT MAX( SQ1_alias1 . `col_varchar_key` ) AS SQ1_field1 FROM C AS SQ1_alias1 ) ) AND ( alias2 . `col_varchar_key` IN ( SELECT SQ2_alias2 . `col_varchar_key` AS SQ2_field1 FROM ( C AS SQ2_alias1 , C AS SQ2_alias2 ) ) AND alias1 . `col_int_nokey` = alias1 . `col_int_nokey` ) ORDER BY alias1 . `col_date_key` , field1, field2, field3, field4 /* (SELECT i1 FROM literals.integers WHERE i1 = 6 ) */ /* TRANSFORM_OUTCOME_UNORDERED_MATCH */', 'SELECT * FROM transforms.where_subselect_15855 WHERE (field1, field2, field3, field4) IN ( SELECT alias1 . `col_datetime_key` AS field1 , alias1 . `col_time_key` AS field2 , alias1 . `col_int_key` AS field3 , alias1 . `col_int_key` AS field4 FROM ( BB AS alias1 , CC AS alias2 ) WHERE ( alias2 . `col_varchar_nokey` < ( SELECT MAX( SQ1_alias1 . `col_varchar_key` ) AS SQ1_field1 FROM C AS SQ1_alias1 ) ) AND ( alias2 . `col_varchar_key` IN ( SELECT SQ2_alias2 . `col_varchar_key` AS SQ2_field1 FROM ( C AS SQ2_alias1 , C AS SQ2_alias2 ) ) AND alias1 . `col_int_nokey` = alias1 . `col_int_nokey` ) ORDER BY alias1 . `col_date_key` , field1, field2, field3, field4 /* 6 */ ) /* TRANSFORM_OUTCOME_UNORDERED_MATCH */', 'SELECT * FROM transforms.where_subselect_15855 WHERE (field1, field2, field3, field4) NOT IN ( SELECT alias1 . `col_datetime_key` AS field1 , alias1 . `col_time_key` AS field2 , alias1 . `col_int_key` AS field3 , alias1 . `col_int_key` AS field4 FROM ( BB AS alias1 , CC AS alias2 ) WHERE ( alias2 . `col_varchar_nokey` < ( SELECT MAX( SQ1_alias1 . `col_varchar_key` ) AS SQ1_field1 FROM C AS SQ1_alias1 ) ) AND ( alias2 . `col_varchar_key` IN ( SELECT SQ2_alias2 . `col_varchar_key` AS SQ2_field1 FROM ( C AS SQ2_alias1 , C AS SQ2_alias2 ) ) AND alias1 . `col_int_nokey` = alias1 . `col_int_nokey` ) ORDER BY alias1 . `col_date_key` , field1, field2, field3, field4 /* 6 */ ) /* TRANSFORM_OUTCOME_EMPTY_RESULT */' ], 'ref: func,func' => [ ' SELECT ( SELECT SUM( SQ1_alias1 . `pk` ) AS SQ1_field1 FROM CC AS SQ1_alias1 WHERE SQ1_alias1 . `col_int_nokey` > SQ1_alias1 . `col_int_key` ) AS field1 , MIN( alias2 . `col_varchar_nokey` ) AS field2 FROM ( C AS alias1 STRAIGHT_JOIN ( ( CC AS alias2 INNER JOIN C AS alias3 ON (alias3 . `col_varchar_key` = alias2 . `col_varchar_key` ) ) ) ON (alias3 . `col_int_key` = alias2 . `pk` ) ) WHERE ( alias3 . `col_int_nokey` > ( SELECT COUNT( SQ2_alias1 . `pk` ) AS SQ2_field1 FROM BB AS SQ2_alias1 WHERE ( (SELECT s1 FROM literals.strings WHERE s1 = \'w\' ) , \'r\' ) IN ( SELECT SQL_SMALL_RESULT C_SQ1_alias1 . `col_varchar_key` AS C_SQ1_field1 , C_SQ1_alias1 . `col_varchar_key` AS C_SQ1_field2 FROM CC AS C_SQ1_alias1 WHERE ( C_SQ1_alias1 . `col_varchar_nokey` >= \'p\' OR C_SQ1_alias1 . `col_varchar_key` = \'w\' ) ) ) ) AND ( alias1 . `col_int_key` = alias2 . `pk` AND alias1 . `col_varchar_key` = \'x\' ) AND alias1 . `col_int_key` > alias1 . `col_int_nokey` GROUP BY field1 ORDER BY alias1 . `col_varchar_key` DESC /* 6 */ /* TRANSFORM_OUTCOME_UNORDERED_MATCH */' ], 'ref: test.C.pk' => [ ' SELECT DISTINCT alias1 . `pk` AS field1 , alias2 . `col_int_key` AS field2 , alias2 . `pk` AS field3 FROM ( view_C AS alias1 STRAIGHT_JOIN C AS alias2 ON (alias2 . `col_int_key` = alias1 . `pk` AND ( \'x\', \'m\' ) IN ( SELECT \'l\' , \'h\' UNION SELECT \'i\' , \'w\' ) ) ) WHERE ( alias1 . `col_varchar_key` >= ALL ( SELECT SQ2_alias1 . `col_varchar_key` AS SQ2_field1 FROM C AS SQ2_alias1 ) ) AND ( alias1 . `col_varchar_key` = \'z\' OR alias1 . `col_varchar_key` NOT IN (\'f\') ) /* 6 */', ' SELECT DISTINCT alias1 . `pk` AS field1 , alias2 . `col_int_key` AS field2 , alias2 . `pk` AS field3 FROM ( view_C AS alias1 STRAIGHT_JOIN C AS alias2 ON (alias2 . `col_int_key` = alias1 . `pk` AND ( \'x\', \'m\' ) IN ( SELECT \'l\' , \'h\' UNION SELECT \'i\' , \'w\' ) ) ) WHERE ( alias1 . `col_varchar_key` >= ALL ( SELECT SQ2_alias1 . `col_varchar_key` AS SQ2_field1 FROM C AS SQ2_alias1 ) ) AND ( alias1 . `col_varchar_key` = \'z\' OR alias1 . `col_varchar_key` NOT IN (\'f\') ) /* 6 */ /* TRANSFORM_OUTCOME_UNORDERED_MATCH */ ;', ' SELECT DISTINCT alias1 . `pk` AS field1 , alias2 . `col_int_key` AS field2 , alias2 . `pk` AS field3 FROM ( view_C AS alias1 STRAIGHT_JOIN C AS alias2 ON (alias2 . `col_int_key` = alias1 . `pk` AND ( \'x\', \'m\' ) IN ( SELECT \'l\' , \'h\' UNION SELECT \'i\' , \'w\' ) ) ) WHERE ( alias1 . `col_varchar_key` >= ALL ( SELECT SQ2_alias1 . `col_varchar_key` AS SQ2_field1 FROM C AS SQ2_alias1 ) ) AND ( alias1 . `col_varchar_key` = \'z\' OR alias1 . `col_varchar_key` NOT IN (\'f\') ) /* (SELECT i1 FROM literals.integers WHERE i1 = 6 ) */ /* TRANSFORM_OUTCOME_UNORDERED_MATCH */', ' SELECT DISTINCT alias1 . `pk` AS field1 , alias2 . `col_int_key` AS field2 , alias2 . `pk` AS field3 FROM ( view_C AS alias1 STRAIGHT_JOIN C AS alias2 ON (alias2 . `col_int_key` = alias1 . `pk` AND ( (SELECT s1 FROM literals.strings WHERE s1 = \'x\' ) , \'m\' ) IN ( SELECT \'l\' , \'h\' UNION SELECT \'i\' , \'w\' ) ) ) WHERE ( alias1 . `col_varchar_key` >= ALL ( SELECT SQ2_alias1 . `col_varchar_key` AS SQ2_field1 FROM C AS SQ2_alias1 ) ) AND ( alias1 . `col_varchar_key` = \'z\' OR alias1 . `col_varchar_key` NOT IN (\'f\') ) /* 6 */ /* TRANSFORM_OUTCOME_UNORDERED_MATCH */' ], 'ref: test.C_SQ1_alias2.col_varchar_key,test.C_SQ1_alias2.col_int_key' => [ ' SELECT SQL_SMALL_RESULT ( SELECT SUM( SQ1_alias2 . `col_varchar_nokey` ) AS SQ1_field1 FROM ( C AS SQ1_alias1 INNER JOIN B AS SQ1_alias2 ON (SQ1_alias2 . `col_int_key` = SQ1_alias1 . `pk` ) ) ) AS field1 FROM ( D AS alias1 , C AS alias2 ) WHERE ( alias2 . `col_int_nokey` IN ( SELECT SQ2_alias1 . `pk` AS SQ2_field1 FROM ( CC AS SQ2_alias1 INNER JOIN A AS SQ2_alias2 ON (SQ2_alias2 . `col_varchar_key` = SQ2_alias1 . `col_varchar_nokey` OR ( 3, 5 ) NOT IN ( SELECT C_SQ1_alias2 . `col_int_nokey` AS C_SQ1_field1 , SUM( C_SQ1_alias1 . `col_int_key` ) AS C_SQ1_field2 FROM ( C AS C_SQ1_alias1 INNER JOIN ( ( CC AS C_SQ1_alias2 INNER JOIN CC AS C_SQ1_alias3 ON (C_SQ1_alias3 . `col_int_key` = C_SQ1_alias2 . `col_int_key` ) ) ) ON (C_SQ1_alias3 . `col_varchar_key` = C_SQ1_alias2 . `col_varchar_key` ) ) WHERE C_SQ1_alias2 . `col_int_key` >= C_SQ1_alias1 . `pk` ) ) ) WHERE SQ2_alias1 . `col_varchar_key` <> alias1 . `col_varchar_key` AND SQ2_alias2 . `col_int_key` <= SQ2_alias1 . `pk` ) ) AND alias1 . `col_int_nokey` IS NOT NULL GROUP BY field1 ORDER BY alias1 . `col_int_key` DESC , alias1 . `col_time_key` ASC /* 6 */', ' SELECT SQL_SMALL_RESULT ( SELECT SUM( SQ1_alias2 . `col_varchar_nokey` ) AS SQ1_field1 FROM ( C AS SQ1_alias1 INNER JOIN B AS SQ1_alias2 ON (SQ1_alias2 . `col_int_key` = SQ1_alias1 . `pk` ) ) ) AS field1 FROM ( D AS alias1 , C AS alias2 ) WHERE ( alias2 . `col_int_nokey` IN ( SELECT SQ2_alias1 . `pk` AS SQ2_field1 FROM ( CC AS SQ2_alias1 INNER JOIN A AS SQ2_alias2 ON (SQ2_alias2 . `col_varchar_key` = SQ2_alias1 . `col_varchar_nokey` OR ( (SELECT i1 FROM literals.integers WHERE i1 = 3 ) , 5 ) NOT IN ( SELECT C_SQ1_alias2 . `col_int_nokey` AS C_SQ1_field1 , SUM( C_SQ1_alias1 . `col_int_key` ) AS C_SQ1_field2 FROM ( C AS C_SQ1_alias1 INNER JOIN ( ( CC AS C_SQ1_alias2 INNER JOIN CC AS C_SQ1_alias3 ON (C_SQ1_alias3 . `col_int_key` = C_SQ1_alias2 . `col_int_key` ) ) ) ON (C_SQ1_alias3 . `col_varchar_key` = C_SQ1_alias2 . `col_varchar_key` ) ) WHERE C_SQ1_alias2 . `col_int_key` >= C_SQ1_alias1 . `pk` ) ) ) WHERE SQ2_alias1 . `col_varchar_key` <> alias1 . `col_varchar_key` AND SQ2_alias2 . `col_int_key` <= SQ2_alias1 . `pk` ) ) AND alias1 . `col_int_nokey` IS NOT NULL GROUP BY field1 ORDER BY alias1 . `col_int_key` DESC , alias1 . `col_time_key` ASC /* 6 */ /* TRANSFORM_OUTCOME_UNORDERED_MATCH */' ], 'ref: test.SQ1_alias1.col_varchar_nokey' => [ ' SELECT STRAIGHT_JOIN MAX( alias1 . `col_varchar_key` ) AS field1 FROM ( C AS alias1 , C AS alias2 ) WHERE ( alias2 . `col_varchar_nokey` IN ( SELECT SQ1_alias2 . `col_varchar_nokey` AS SQ1_field1 FROM ( CC AS SQ1_alias1 STRAIGHT_JOIN CC AS SQ1_alias2 ON (SQ1_alias2 . `col_varchar_key` = SQ1_alias1 . `col_varchar_nokey` ) ) WHERE ( SQ1_alias2 . `col_varchar_nokey` <= \'e\' AND SQ1_alias1 . `col_int_key` >= 5 ) ) ) AND alias1 . `pk` = 39 ORDER BY field1 ASC, field1 /* 6 */', ' SELECT STRAIGHT_JOIN MAX( alias1 . `col_varchar_key` ) AS field1 FROM ( C AS alias1 , C AS alias2 ) WHERE ( alias2 . `col_varchar_nokey` IN ( SELECT SQ1_alias2 . `col_varchar_nokey` AS SQ1_field1 FROM ( CC AS SQ1_alias1 STRAIGHT_JOIN CC AS SQ1_alias2 ON (SQ1_alias2 . `col_varchar_key` = SQ1_alias1 . `col_varchar_nokey` ) ) WHERE ( SQ1_alias2 . `col_varchar_nokey` <= \'e\' AND SQ1_alias1 . `col_int_key` >= 5 ) ) ) AND alias1 . `pk` = 39 ORDER BY field1 ASC, field1 /* 6 */ /* TRANSFORM_OUTCOME_UNORDERED_MATCH */ ;', ' SELECT STRAIGHT_JOIN MAX( alias1 . `col_varchar_key` ) AS field1 FROM ( C AS alias1 , C AS alias2 ) WHERE ( alias2 . `col_varchar_nokey` IN ( SELECT SQ1_alias2 . `col_varchar_nokey` AS SQ1_field1 FROM ( CC AS SQ1_alias1 STRAIGHT_JOIN CC AS SQ1_alias2 ON (SQ1_alias2 . `col_varchar_key` = SQ1_alias1 . `col_varchar_nokey` ) ) WHERE ( SQ1_alias2 . `col_varchar_nokey` <= \'e\' AND SQ1_alias1 . `col_int_key` >= (SELECT i1 FROM literals.integers WHERE i1 = 5 ) ) ) ) AND alias1 . `pk` = 39 ORDER BY field1 ASC, field1 /* 6 */ /* TRANSFORM_OUTCOME_UNORDERED_MATCH */', ' SELECT STRAIGHT_JOIN MAX( alias1 . `col_varchar_key` ) AS field1 FROM ( C AS alias1 , C AS alias2 ) WHERE ( alias2 . `col_varchar_nokey` IN ( SELECT SQ1_alias2 . `col_varchar_nokey` AS SQ1_field1 FROM ( CC AS SQ1_alias1 STRAIGHT_JOIN CC AS SQ1_alias2 ON (SQ1_alias2 . `col_varchar_key` = SQ1_alias1 . `col_varchar_nokey` ) ) WHERE ( SQ1_alias2 . `col_varchar_nokey` <= (SELECT s1 FROM literals.strings WHERE s1 = \'e\' ) AND SQ1_alias1 . `col_int_key` >= 5 ) ) ) AND alias1 . `pk` = 39 ORDER BY field1 ASC, field1 /* 6 */ /* TRANSFORM_OUTCOME_UNORDERED_MATCH */' ], 'ref: test.SQ1_alias1.pk' => [ ' SELECT alias1 . `pk` AS field1 , alias1 . `col_datetime_key` AS field2 FROM ( B AS alias1 STRAIGHT_JOIN BB AS alias2 ON (alias2 . `col_int_key` = alias1 . `pk` ) ) WHERE ( alias2 . `col_int_key` > ( SELECT SQL_SMALL_RESULT SUM( SQ1_alias1 . `col_int_nokey` ) AS SQ1_field1 FROM ( C AS SQ1_alias1 STRAIGHT_JOIN D AS SQ1_alias2 ON (SQ1_alias2 . `pk` = SQ1_alias1 . `pk` ) ) ) ) AND ( alias1 . `col_varchar_key` LIKE CONCAT( \'u\' , \'%\') AND alias1 . `pk` = 74 ) GROUP BY field1, field2 HAVING field1 >= 6 ORDER BY alias1 . `col_int_key` ASC , CONCAT ( alias2 . `col_varchar_nokey`, alias1 . `col_varchar_nokey` ), field1, field2 LIMIT 1 OFFSET 5 /* 6 */', ' SELECT DISTINCT ( SELECT MAX( SQ1_alias2 . `col_varchar_key` ) AS SQ1_field1 FROM ( CC AS SQ1_alias1 STRAIGHT_JOIN CC AS SQ1_alias2 ON (SQ1_alias2 . `pk` = SQ1_alias1 . `pk` ) ) ) AS field1 FROM ( B AS alias1 , CC AS alias2 ) WHERE ( alias1 . `col_int_key` = ALL ( SELECT 5 FROM DUAL ) ) AND alias1 . `col_int_nokey` = alias2 . `col_int_nokey` GROUP BY field1 ORDER BY alias1 . `col_datetime_key` , field1 /* 6 */', ' SELECT DISTINCT ( SELECT MAX( SQ1_alias2 . `col_varchar_key` ) AS SQ1_field1 FROM ( CC AS SQ1_alias1 STRAIGHT_JOIN CC AS SQ1_alias2 ON (SQ1_alias2 . `pk` = SQ1_alias1 . `pk` ) ) ) AS field1 FROM ( B AS alias1 , CC AS alias2 ) WHERE ( alias1 . `col_int_key` = ALL ( SELECT (SELECT i1 FROM literals.integers WHERE i1 = 5 ) FROM DUAL ) ) AND alias1 . `col_int_nokey` = alias2 . `col_int_nokey` GROUP BY field1 ORDER BY alias1 . `col_datetime_key` , field1 /* 6 */ /* TRANSFORM_OUTCOME_UNORDERED_MATCH */', ' SELECT alias1 . `pk` AS field1 , alias1 . `col_date_key` AS field2 , alias2 . `col_varchar_key` AS field3 , alias2 . `col_varchar_nokey` AS field4 , alias2 . `col_int_key` AS field5 , alias1 . `col_varchar_nokey` AS field6 , alias1 . `col_time_key` AS field7 , alias1 . `col_int_key` AS field8 , alias2 . `col_time_key` AS field9 , alias1 . `col_varchar_key` AS field10 , alias2 . `col_datetime_key` AS field11 , alias2 . `col_int_key` AS field12 , alias1 . `col_time_key` AS field13 FROM ( CC AS alias1 LEFT JOIN CC AS alias2 ON (alias2 . `col_varchar_key` = alias1 . `col_varchar_key` AND alias1 . `pk` >= ANY ( SELECT SQ1_alias1 . `col_int_key` AS SQ1_field1 FROM ( C AS SQ1_alias1 STRAIGHT_JOIN CC AS SQ1_alias2 ON (SQ1_alias2 . `col_int_key` = SQ1_alias1 . `pk` ) ) ) ) ) WHERE alias1 . `col_int_key` IN ( SELECT 3 UNION DISTINCT SELECT 6 ) HAVING field1 != \'v\' ORDER BY field10 DESC, field1, field2, field3, field4, field5, field6, field7, field8, field9, field10, field11, field12, field13 LIMIT 1 /* 6 */', ' SELECT alias1 . `pk` AS field1 , alias1 . `col_date_key` AS field2 , alias2 . `col_varchar_key` AS field3 , alias2 . `col_varchar_nokey` AS field4 , alias2 . `col_int_key` AS field5 , alias1 . `col_varchar_nokey` AS field6 , alias1 . `col_time_key` AS field7 , alias1 . `col_int_key` AS field8 , alias2 . `col_time_key` AS field9 , alias1 . `col_varchar_key` AS field10 , alias2 . `col_datetime_key` AS field11 , alias2 . `col_int_key` AS field12 , alias1 . `col_time_key` AS field13 FROM ( CC AS alias1 LEFT JOIN CC AS alias2 ON (alias2 . `col_varchar_key` = alias1 . `col_varchar_key` AND alias1 . `pk` >= ANY ( SELECT SQ1_alias1 . `col_int_key` AS SQ1_field1 FROM ( C AS SQ1_alias1 STRAIGHT_JOIN CC AS SQ1_alias2 ON (SQ1_alias2 . `col_int_key` = SQ1_alias1 . `pk` ) ) ) ) ) WHERE alias1 . `col_int_key` IN ( SELECT 3 UNION DISTINCT SELECT 6 ) HAVING field1 != \'v\' ORDER BY field10 DESC, field1, field2, field3, field4, field5, field6, field7, field8, field9, field10, field11, field12, field13 LIMIT 1 /* 6 */ /* TRANSFORM_OUTCOME_UNORDERED_MATCH */ ;' ], 'ref: test.SQ1_alias2.col_int_key' => [ ' SELECT alias1 . `col_varchar_nokey` AS field1 , alias2 . `col_varchar_key` AS field2 , alias1 . `col_date_key` AS field3 , alias1 . `col_int_nokey` AS field4 , alias1 . `col_int_key` AS field5 FROM ( CC AS alias1 , C AS alias2 ) WHERE ( ( alias1 . `col_varchar_key` , alias2 . `col_varchar_key` ) IN ( SELECT SQ1_alias1 . `col_varchar_nokey` AS SQ1_field1 , MIN( SQ1_alias1 . `col_varchar_nokey` ) AS SQ1_field2 FROM ( BB AS SQ1_alias1 STRAIGHT_JOIN ( C AS SQ1_alias2 INNER JOIN C AS SQ1_alias3 ON (SQ1_alias3 . `col_varchar_key` = SQ1_alias2 . `col_varchar_key` ) ) ON (SQ1_alias3 . `pk` = SQ1_alias2 . `col_int_key` ) ) ) ) AND alias2 . `col_varchar_nokey` = \'p\' GROUP BY field1, field2, field3, field4, field5 ORDER BY alias1 . `col_int_key` ASC , CONCAT ( alias2 . `col_varchar_key`, alias2 . `col_varchar_key` ), field1, field2, field3, field4, field5 /* 6 */', ' SELECT alias1 . `col_varchar_nokey` AS field1 , alias2 . `col_varchar_key` AS field2 , alias1 . `col_date_key` AS field3 , alias1 . `col_int_nokey` AS field4 , alias1 . `col_int_key` AS field5 FROM ( CC AS alias1 , C AS alias2 ) WHERE ( ( alias1 . `col_varchar_key` , alias2 . `col_varchar_key` ) IN ( SELECT SQ1_alias1 . `col_varchar_nokey` AS SQ1_field1 , MIN( SQ1_alias1 . `col_varchar_nokey` ) AS SQ1_field2 FROM ( BB AS SQ1_alias1 STRAIGHT_JOIN ( C AS SQ1_alias2 INNER JOIN C AS SQ1_alias3 ON (SQ1_alias3 . `col_varchar_key` = SQ1_alias2 . `col_varchar_key` ) ) ON (SQ1_alias3 . `pk` = SQ1_alias2 . `col_int_key` ) ) ) ) AND alias2 . `col_varchar_nokey` = \'p\' GROUP BY field1, field2, field3, field4, field5 ORDER BY alias1 . `col_int_key` ASC , CONCAT ( alias2 . `col_varchar_key`, alias2 . `col_varchar_key` ), field1, field2, field3, field4, field5 /* 6 */ /* TRANSFORM_OUTCOME_UNORDERED_MATCH */ ;', ' SELECT alias1 . `col_varchar_nokey` AS field1 , alias2 . `col_varchar_key` AS field2 , alias1 . `col_date_key` AS field3 , alias1 . `col_int_nokey` AS field4 , alias1 . `col_int_key` AS field5 FROM ( CC AS alias1 , C AS alias2 ) WHERE ( ( alias1 . `col_varchar_key` , alias2 . `col_varchar_key` ) IN ( SELECT SQ1_alias1 . `col_varchar_nokey` AS SQ1_field1 , MIN( SQ1_alias1 . `col_varchar_nokey` ) AS SQ1_field2 FROM ( BB AS SQ1_alias1 STRAIGHT_JOIN ( C AS SQ1_alias2 INNER JOIN C AS SQ1_alias3 ON (SQ1_alias3 . `col_varchar_key` = SQ1_alias2 . `col_varchar_key` ) ) ON (SQ1_alias3 . `pk` = SQ1_alias2 . `col_int_key` ) ) ) ) AND alias2 . `col_varchar_nokey` = \'p\' GROUP BY field1, field2, field3, field4, field5 ORDER BY alias1 . `col_int_key` ASC , CONCAT ( alias2 . `col_varchar_key`, alias2 . `col_varchar_key` ), field1, field2, field3, field4, field5 /* 6 */ /* TRANSFORM_OUTCOME_UNORDERED_MATCH */ ;', ' SELECT alias1 . `col_varchar_nokey` AS field1 , alias2 . `col_varchar_key` AS field2 , alias1 . `col_date_key` AS field3 , alias1 . `col_int_nokey` AS field4 , alias1 . `col_int_key` AS field5 FROM ( CC AS alias1 , C AS alias2 ) WHERE ( ( alias1 . `col_varchar_key` , alias2 . `col_varchar_key` ) IN ( SELECT SQ1_alias1 . `col_varchar_nokey` AS SQ1_field1 , MIN( SQ1_alias1 . `col_varchar_nokey` ) AS SQ1_field2 FROM ( BB AS SQ1_alias1 STRAIGHT_JOIN ( C AS SQ1_alias2 INNER JOIN C AS SQ1_alias3 ON (SQ1_alias3 . `col_varchar_key` = SQ1_alias2 . `col_varchar_key` ) ) ON (SQ1_alias3 . `pk` = SQ1_alias2 . `col_int_key` ) ) ) ) AND alias2 . `col_varchar_nokey` = \'p\' GROUP BY field1, field2, field3, field4, field5 ORDER BY alias1 . `col_int_key` ASC , CONCAT ( alias2 . `col_varchar_key`, alias2 . `col_varchar_key` ), field1, field2, field3, field4, field5 /* (SELECT i1 FROM literals.integers WHERE i1 = 6 ) */ /* TRANSFORM_OUTCOME_UNORDERED_MATCH */', ' SELECT alias1 . `col_varchar_nokey` AS field1 , alias2 . `col_varchar_key` AS field2 , alias1 . `col_date_key` AS field3 , alias1 . `col_int_nokey` AS field4 , alias1 . `col_int_key` AS field5 FROM ( CC AS alias1 , C AS alias2 ) WHERE ( ( alias1 . `col_varchar_key` , alias2 . `col_varchar_key` ) IN ( SELECT SQ1_alias1 . `col_varchar_nokey` AS SQ1_field1 , MIN( SQ1_alias1 . `col_varchar_nokey` ) AS SQ1_field2 FROM ( BB AS SQ1_alias1 STRAIGHT_JOIN ( C AS SQ1_alias2 INNER JOIN C AS SQ1_alias3 ON (SQ1_alias3 . `col_varchar_key` = SQ1_alias2 . `col_varchar_key` ) ) ON (SQ1_alias3 . `pk` = SQ1_alias2 . `col_int_key` ) ) ) ) AND alias2 . `col_varchar_nokey` = (SELECT s1 FROM literals.strings WHERE s1 = \'p\' ) GROUP BY field1, field2, field3, field4, field5 ORDER BY alias1 . `col_int_key` ASC , CONCAT ( alias2 . `col_varchar_key`, alias2 . `col_varchar_key` ), field1, field2, field3, field4, field5 /* 6 */ /* TRANSFORM_OUTCOME_UNORDERED_MATCH */' ], 'ref: test.SQ1_alias2.col_int_nokey' => [ ' SELECT SQL_SMALL_RESULT alias1 . `col_int_key` AS field1 FROM ( C AS alias1 LEFT OUTER JOIN ( ( CC AS alias2 INNER JOIN C AS alias3 ON (alias3 . `col_int_key` = alias2 . `col_int_key` ) ) ) ON (alias3 . `pk` = alias2 . `col_int_key` ) ) WHERE ( EXISTS ( ( SELECT DISTINCT SQ1_alias1 . `col_varchar_key` AS SQ1_field1 FROM ( CC AS SQ1_alias1 INNER JOIN CC AS SQ1_alias2 ON (SQ1_alias2 . `col_int_nokey` = SQ1_alias1 . `pk` ) ) ) ) ) AND alias1 . `col_varchar_key` LIKE CONCAT( \'r\' , \'%\') OR alias1 . `col_int_nokey` IS NULL GROUP BY field1 ORDER BY alias1 . `col_datetime_key` , field1 LIMIT 1 OFFSET 5 /* 6 */' ], 'ref: test.SQ1_alias2.col_varchar_key,test.SQ1_alias2.col_int_key' => [ ' SELECT DISTINCT alias1 . `col_time_key` AS field1 FROM ( CC AS alias1 STRAIGHT_JOIN ( ( BB AS alias2 INNER JOIN CC AS alias3 ON (alias3 . `pk` = alias2 . `pk` ) ) ) ON (alias3 . `col_int_key` = alias2 . `col_int_key` ) ) WHERE ( EXISTS ( ( SELECT SQ1_alias1 . `col_int_key` AS SQ1_field1 FROM ( CC AS SQ1_alias1 INNER JOIN ( CC AS SQ1_alias2 INNER JOIN C AS SQ1_alias3 ON (SQ1_alias3 . `col_int_key` = SQ1_alias2 . `col_int_key` ) ) ON (SQ1_alias3 . `col_varchar_key` = SQ1_alias2 . `col_varchar_key` ) ) ) ) ) AND ( alias1 . `col_int_key` > 179 AND alias1 . `col_int_key` < ( 179 + 120 ) OR alias1 . `col_varchar_key` NOT IN (\'b\' , \'USA\') ) HAVING field1 <> 154 ORDER BY alias1 . `col_int_key` DESC , field1 LIMIT 1 /* 6 */' ], 'ref: test.SQ1_alias2.pk' => [ ' SELECT DISTINCT COUNT( alias1 . `col_int_key` ) AS field1 FROM ( C AS alias1 , CC AS alias2 ) WHERE EXISTS ( ( SELECT SQ1_alias1 . `pk` AS SQ1_field1 FROM ( CC AS SQ1_alias1 INNER JOIN ( CC AS SQ1_alias2 INNER JOIN C AS SQ1_alias3 ON (SQ1_alias3 . `col_int_nokey` = SQ1_alias2 . `pk` ) ) ON (SQ1_alias3 . `pk` = SQ1_alias2 . `pk` ) ) WHERE ( SQ1_alias3 . `col_varchar_key` <> \'m\' AND SQ1_alias2 . `col_varchar_nokey` > \'s\' ) ) ) HAVING field1 = \'qy\' /* 6 */' ], 'ref: test.SQ1_alias3.col_int_nokey' => [ ' SELECT alias1 . `col_varchar_key` AS field1 , alias2 . `col_varchar_nokey` AS field2 , alias1 . `col_time_key` AS field3 , alias1 . `col_int_key` AS field4 , alias1 . `col_varchar_key` AS field5 FROM ( BB AS alias1 STRAIGHT_JOIN ( ( B AS alias2 INNER JOIN C AS alias3 ON (alias3 . `col_varchar_key` = alias2 . `col_varchar_key` ) ) ) ON (alias3 . `col_int_key` = alias2 . `col_int_key` ) ) WHERE ( EXISTS ( SELECT SQ1_alias1 . `col_int_key` AS SQ1_field1 FROM ( C AS SQ1_alias1 INNER JOIN ( C AS SQ1_alias2 INNER JOIN CC AS SQ1_alias3 ON (SQ1_alias3 . `col_int_key` = SQ1_alias2 . `col_int_key` ) ) ON (SQ1_alias3 . `col_int_nokey` = SQ1_alias2 . `pk` ) ) WHERE SQ1_alias2 . `col_int_nokey` != alias1 . `pk` OR SQ1_alias3 . `col_varchar_nokey` <= SQ1_alias2 . `col_varchar_nokey` ) ) AND ( alias1 . `pk` IN (71) OR alias1 . `col_varchar_key` IN (\'v\') ) OR ( alias1 . `col_int_key` IS NULL OR alias1 . `col_varchar_key` >= \'g\' ) ORDER BY alias1 . `col_datetime_key` ASC , field1, field2, field3, field4, field5 /* 6 */', ' SELECT alias1 . `col_varchar_key` AS field1 , alias2 . `col_varchar_nokey` AS field2 , alias1 . `col_time_key` AS field3 , alias1 . `col_int_key` AS field4 , alias1 . `col_varchar_key` AS field5 FROM ( BB AS alias1 STRAIGHT_JOIN ( ( B AS alias2 INNER JOIN C AS alias3 ON (alias3 . `col_varchar_key` = alias2 . `col_varchar_key` ) ) ) ON (alias3 . `col_int_key` = alias2 . `col_int_key` ) ) WHERE ( EXISTS ( SELECT SQ1_alias1 . `col_int_key` AS SQ1_field1 FROM ( C AS SQ1_alias1 INNER JOIN ( C AS SQ1_alias2 INNER JOIN CC AS SQ1_alias3 ON (SQ1_alias3 . `col_int_key` = SQ1_alias2 . `col_int_key` ) ) ON (SQ1_alias3 . `col_int_nokey` = SQ1_alias2 . `pk` ) ) WHERE SQ1_alias2 . `col_int_nokey` != alias1 . `pk` OR SQ1_alias3 . `col_varchar_nokey` <= SQ1_alias2 . `col_varchar_nokey` ) ) AND ( alias1 . `pk` IN (71) OR alias1 . `col_varchar_key` IN (\'v\') ) OR ( alias1 . `col_int_key` IS NULL OR alias1 . `col_varchar_key` >= \'g\' ) ORDER BY alias1 . `col_datetime_key` ASC , field1, field2, field3, field4, field5 /* (SELECT i1 FROM literals.integers WHERE i1 = 6 ) */ /* TRANSFORM_OUTCOME_UNORDERED_MATCH */', ' SELECT alias1 . `col_varchar_key` AS field1 , alias2 . `col_varchar_nokey` AS field2 , alias1 . `col_time_key` AS field3 , alias1 . `col_int_key` AS field4 , alias1 . `col_varchar_key` AS field5 FROM ( BB AS alias1 STRAIGHT_JOIN ( ( B AS alias2 INNER JOIN C AS alias3 ON (alias3 . `col_varchar_key` = alias2 . `col_varchar_key` ) ) ) ON (alias3 . `col_int_key` = alias2 . `col_int_key` ) ) WHERE ( EXISTS ( SELECT SQ1_alias1 . `col_int_key` AS SQ1_field1 FROM ( C AS SQ1_alias1 INNER JOIN ( C AS SQ1_alias2 INNER JOIN CC AS SQ1_alias3 ON (SQ1_alias3 . `col_int_key` = SQ1_alias2 . `col_int_key` ) ) ON (SQ1_alias3 . `col_int_nokey` = SQ1_alias2 . `pk` ) ) WHERE SQ1_alias2 . `col_int_nokey` != alias1 . `pk` OR SQ1_alias3 . `col_varchar_nokey` <= SQ1_alias2 . `col_varchar_nokey` ) ) AND ( alias1 . `pk` IN (71) OR alias1 . `col_varchar_key` IN (\'v\') ) OR ( alias1 . `col_int_key` IS NULL OR alias1 . `col_varchar_key` >= (SELECT s1 FROM literals.strings WHERE s1 = \'g\' ) ) ORDER BY alias1 . `col_datetime_key` ASC , field1, field2, field3, field4, field5 /* 6 */ /* TRANSFORM_OUTCOME_UNORDERED_MATCH */' ], 'ref: test.SQ2_alias1.col_int_key' => [ ' SELECT DISTINCT MAX( alias2 . `col_int_nokey` ) AS field1 FROM ( C AS alias1 RIGHT JOIN ( ( CC AS alias2 INNER JOIN CC AS alias3 ON (alias3 . `col_varchar_nokey` = alias2 . `col_varchar_key` AND ( \'w\', \'k\' ) NOT IN ( SELECT \'y\' , \'p\' UNION SELECT \'q\' , \'l\' ) ) ) ) ON (alias3 . `pk` = alias2 . `pk` ) ) WHERE ( alias2 . `col_int_nokey` <> ( SELECT DISTINCT SUM( SQ2_alias1 . `pk` ) AS SQ2_field1 FROM ( CC AS SQ2_alias1 STRAIGHT_JOIN D AS SQ2_alias2 ON (SQ2_alias2 . `col_int_key` = SQ2_alias1 . `col_int_key` ) ) ) ) AND ( alias1 . `pk` NOT IN (122, 159) OR alias1 . `col_int_key` > 169 AND alias1 . `col_int_key` < ( 169 + 204 ) ) HAVING field1 = 140 ORDER BY field1 DESC , alias1 . `col_date_key` ASC, field1 /* 6 */', ' SELECT DISTINCT MAX( alias2 . `col_int_nokey` ) AS field1 FROM ( C AS alias1 RIGHT JOIN ( ( CC AS alias2 INNER JOIN CC AS alias3 ON (alias3 . `col_varchar_nokey` = alias2 . `col_varchar_key` AND ( \'w\', \'k\' ) NOT IN ( SELECT \'y\' , \'p\' UNION SELECT \'q\' , \'l\' ) ) ) ) ON (alias3 . `pk` = alias2 . `pk` ) ) WHERE ( alias2 . `col_int_nokey` <> ( SELECT DISTINCT SUM( SQ2_alias1 . `pk` ) AS SQ2_field1 FROM ( CC AS SQ2_alias1 STRAIGHT_JOIN D AS SQ2_alias2 ON (SQ2_alias2 . `col_int_key` = SQ2_alias1 . `col_int_key` ) ) ) ) AND ( alias1 . `pk` NOT IN (122, 159) OR alias1 . `col_int_key` > 169 AND alias1 . `col_int_key` < ( 169 + 204 ) ) HAVING field1 = 140 ORDER BY field1 DESC , alias1 . `col_date_key` ASC, field1 /* 6 */ /* TRANSFORM_OUTCOME_UNORDERED_MATCH */ ;', ' SELECT DISTINCT MAX( alias2 . `col_int_nokey` ) AS field1 FROM ( C AS alias1 RIGHT JOIN ( ( CC AS alias2 INNER JOIN CC AS alias3 ON (alias3 . `col_varchar_nokey` = alias2 . `col_varchar_key` AND ( \'w\', \'k\' ) NOT IN ( SELECT \'y\' , \'p\' UNION SELECT \'q\' , \'l\' ) ) ) ) ON (alias3 . `pk` = alias2 . `pk` ) ) WHERE ( alias2 . `col_int_nokey` <> ( SELECT DISTINCT SUM( SQ2_alias1 . `pk` ) AS SQ2_field1 FROM ( CC AS SQ2_alias1 STRAIGHT_JOIN D AS SQ2_alias2 ON (SQ2_alias2 . `col_int_key` = SQ2_alias1 . `col_int_key` ) ) ) ) AND ( alias1 . `pk` NOT IN (122, (SELECT i1 FROM literals.integers WHERE i1 = 159 ) ) OR alias1 . `col_int_key` > 169 AND alias1 . `col_int_key` < ( 169 + 204 ) ) HAVING field1 = 140 ORDER BY field1 DESC , alias1 . `col_date_key` ASC, field1 /* 6 */ /* TRANSFORM_OUTCOME_UNORDERED_MATCH */', ' SELECT DISTINCT MAX( alias2 . `col_int_nokey` ) AS field1 FROM ( C AS alias1 RIGHT JOIN ( ( CC AS alias2 INNER JOIN CC AS alias3 ON (alias3 . `col_varchar_nokey` = alias2 . `col_varchar_key` AND ( (SELECT s1 FROM literals.strings WHERE s1 = \'w\' ) , \'k\' ) NOT IN ( SELECT \'y\' , \'p\' UNION SELECT \'q\' , \'l\' ) ) ) ) ON (alias3 . `pk` = alias2 . `pk` ) ) WHERE ( alias2 . `col_int_nokey` <> ( SELECT DISTINCT SUM( SQ2_alias1 . `pk` ) AS SQ2_field1 FROM ( CC AS SQ2_alias1 STRAIGHT_JOIN D AS SQ2_alias2 ON (SQ2_alias2 . `col_int_key` = SQ2_alias1 . `col_int_key` ) ) ) ) AND ( alias1 . `pk` NOT IN (122, 159) OR alias1 . `col_int_key` > 169 AND alias1 . `col_int_key` < ( 169 + 204 ) ) HAVING field1 = 140 ORDER BY field1 DESC , alias1 . `col_date_key` ASC, field1 /* 6 */ /* TRANSFORM_OUTCOME_UNORDERED_MATCH */' ], 'ref: test.SQ2_alias1.col_int_nokey' => [ ' SELECT alias2 . `col_varchar_nokey` AS field1 , alias1 . `col_int_nokey` AS field2 , ( SELECT COUNT( SQ1_alias1 . `col_int_key` ) AS SQ1_field1 FROM view_A AS SQ1_alias1 WHERE SQ1_alias1 . `col_int_nokey` <> alias1 . `col_int_key` AND SQ1_alias1 . `col_varchar_key` = SQ1_alias1 . `col_varchar_nokey` ) AS field3 , MIN( alias2 . `col_varchar_key` ) AS field4 FROM ( B AS alias1 INNER JOIN D AS alias2 ON (alias2 . `col_int_key` = alias1 . `pk` ) ) WHERE EXISTS ( SELECT SQ2_alias1 . `col_int_nokey` AS SQ2_field1 FROM ( C AS SQ2_alias1 INNER JOIN CC AS SQ2_alias2 ON (SQ2_alias2 . `col_int_key` = SQ2_alias1 . `col_int_nokey` ) ) WHERE SQ2_alias2 . `col_varchar_key` < alias1 . `col_varchar_nokey` AND SQ2_alias1 . `col_varchar_nokey` > alias1 . `col_varchar_key` ) GROUP BY field1, field2, field3 ORDER BY alias1 . `col_datetime_key` , alias1 .`pk` ASC /* 6 */', ' SELECT alias2 . `col_varchar_nokey` AS field1 , alias1 . `col_int_nokey` AS field2 , ( SELECT COUNT( SQ1_alias1 . `col_int_key` ) AS SQ1_field1 FROM view_A AS SQ1_alias1 WHERE SQ1_alias1 . `col_int_nokey` <> alias1 . `col_int_key` AND SQ1_alias1 . `col_varchar_key` = SQ1_alias1 . `col_varchar_nokey` ) AS field3 , MIN( alias2 . `col_varchar_key` ) AS field4 FROM ( B AS alias1 INNER JOIN D AS alias2 ON (alias2 . `col_int_key` = alias1 . `pk` ) ) WHERE EXISTS ( SELECT SQ2_alias1 . `col_int_nokey` AS SQ2_field1 FROM ( C AS SQ2_alias1 INNER JOIN CC AS SQ2_alias2 ON (SQ2_alias2 . `col_int_key` = SQ2_alias1 . `col_int_nokey` ) ) WHERE SQ2_alias2 . `col_varchar_key` < alias1 . `col_varchar_nokey` AND SQ2_alias1 . `col_varchar_nokey` > alias1 . `col_varchar_key` ) GROUP BY field1, field2, field3 ORDER BY alias1 . `col_datetime_key` , alias1 .`pk` ASC /* (SELECT i1 FROM literals.integers WHERE i1 = 6 ) */ /* TRANSFORM_OUTCOME_UNORDERED_MATCH */' ], 'ref: test.SQ2_alias1.col_varchar_nokey' => [ ' SELECT SQL_SMALL_RESULT ( ( alias1 . `col_int_key` ) - ( alias2 . `col_int_key` ) ) AS field1 , ( SELECT COUNT( SQ1_alias2 . `pk` ) AS SQ1_field1 FROM ( view_B AS SQ1_alias1 , view_CC AS SQ1_alias2 ) WHERE SQ1_alias1 . `col_int_key` <= alias1 . `pk` AND SQ1_alias1 . `col_int_nokey` > 2 ) AS field2 , alias1 . `col_int_key` AS field3 , alias1 . `col_int_key` AS field4 , CONCAT ( alias1 . `col_varchar_key` , alias2 . `col_varchar_nokey` ) AS field5 , MIN( DISTINCT alias2 . `col_varchar_nokey` ) AS field6 FROM ( C AS alias1 , C AS alias2 ) WHERE alias1 . `col_varchar_nokey` = SOME ( SELECT SQ2_alias1 . `col_varchar_nokey` AS SQ2_field1 FROM ( CC AS SQ2_alias1 INNER JOIN CC AS SQ2_alias2 ON (SQ2_alias2 . `col_varchar_key` = SQ2_alias1 . `col_varchar_nokey` ) ) WHERE SQ2_alias2 . `col_varchar_nokey` <> alias2 . `col_varchar_nokey` OR SQ2_alias1 . `col_varchar_nokey` < SQ2_alias2 . `col_varchar_nokey` ) GROUP BY field1, field2, field3, field4, field5 HAVING field4 < \'l\' ORDER BY field5 , alias1 . `col_int_key` , alias2 .`pk` DESC , CONCAT ( alias2 . `col_varchar_nokey`, alias2 . `col_varchar_nokey` ) , CONCAT ( alias2 . `col_varchar_nokey`, alias1 . `col_varchar_key` ) , alias1 . `col_time_key` DESC , CONCAT ( alias1 . `col_varchar_key`, alias1 . `col_varchar_key` ) , field6 ASC , alias1 . `col_varchar_key` ASC , alias1 . `col_datetime_key` ASC , field6 DESC, field1, field2, field3, field4, field5, field6 /* 6 */ /* TRANSFORM_OUTCOME_UNORDERED_MATCH */ ;' ], 'ref: test.SQ2_alias1.pk' => [ ' SELECT alias1 . `col_varchar_nokey` AS field1 , ( ( alias1 . `col_int_key` ) * ( alias2 . `col_int_key` ) ) AS field2 , alias1 . `col_varchar_nokey` AS field3 , ( SELECT MAX( SQ1_alias2 . `col_int_key` ) AS SQ1_field1 FROM ( A AS SQ1_alias1 INNER JOIN ( C AS SQ1_alias2 INNER JOIN C AS SQ1_alias3 ON (SQ1_alias3 . `pk` = SQ1_alias2 . `pk` ) ) ON (SQ1_alias3 . `pk` = SQ1_alias2 . `col_int_key` ) ) WHERE ( SQ1_alias1 . `col_varchar_key` <= SQ1_alias1 . `col_varchar_key` OR SQ1_alias1 . `col_int_nokey` >= SQ1_alias3 . `pk` ) ) AS field4 , alias1 . `pk` AS field5 FROM ( C AS alias1 STRAIGHT_JOIN D AS alias2 ON (alias2 . `col_varchar_key` = alias1 . `col_varchar_nokey` ) ) WHERE ( EXISTS ( SELECT SQ2_alias1 . `pk` AS SQ2_field1 FROM ( C AS SQ2_alias1 STRAIGHT_JOIN CC AS SQ2_alias2 ON (SQ2_alias2 . `pk` = SQ2_alias1 . `pk` ) ) WHERE SQ2_alias2 . `col_int_key` <> alias2 . `col_int_key` AND SQ2_alias2 . `col_varchar_key` != SQ2_alias2 . `col_varchar_key` ) ) AND alias1 . `col_int_key` = 21 OR ( alias1 . `col_varchar_key` = \'h\' AND alias2 . `col_varchar_key` <> \'u\' ) GROUP BY field1, field2, field3, field4, field5 HAVING (field1 < 94 AND field4 >= \'s\') /* 6 */', ' SELECT alias1 . `col_varchar_nokey` AS field1 , ( ( alias1 . `col_int_key` ) * ( alias2 . `col_int_key` ) ) AS field2 , alias1 . `col_varchar_nokey` AS field3 , ( SELECT MAX( SQ1_alias2 . `col_int_key` ) AS SQ1_field1 FROM ( A AS SQ1_alias1 INNER JOIN ( C AS SQ1_alias2 INNER JOIN C AS SQ1_alias3 ON (SQ1_alias3 . `pk` = SQ1_alias2 . `pk` ) ) ON (SQ1_alias3 . `pk` = SQ1_alias2 . `col_int_key` ) ) WHERE ( SQ1_alias1 . `col_varchar_key` <= SQ1_alias1 . `col_varchar_key` OR SQ1_alias1 . `col_int_nokey` >= SQ1_alias3 . `pk` ) ) AS field4 , alias1 . `pk` AS field5 FROM ( C AS alias1 STRAIGHT_JOIN D AS alias2 ON (alias2 . `col_varchar_key` = alias1 . `col_varchar_nokey` ) ) WHERE ( EXISTS ( SELECT SQ2_alias1 . `pk` AS SQ2_field1 FROM ( C AS SQ2_alias1 STRAIGHT_JOIN CC AS SQ2_alias2 ON (SQ2_alias2 . `pk` = SQ2_alias1 . `pk` ) ) WHERE SQ2_alias2 . `col_int_key` <> alias2 . `col_int_key` AND SQ2_alias2 . `col_varchar_key` != SQ2_alias2 . `col_varchar_key` ) ) AND alias1 . `col_int_key` = (SELECT i1 FROM literals.integers WHERE i1 = 21 ) OR ( alias1 . `col_varchar_key` = \'h\' AND alias2 . `col_varchar_key` <> \'u\' ) GROUP BY field1, field2, field3, field4, field5 HAVING (field1 < 94 AND field4 >= \'s\') /* 6 */ /* TRANSFORM_OUTCOME_UNORDERED_MATCH */', ' SELECT alias1 . `col_varchar_nokey` AS field1 , ( ( alias1 . `col_int_key` ) * ( alias2 . `col_int_key` ) ) AS field2 , alias1 . `col_varchar_nokey` AS field3 , ( SELECT MAX( SQ1_alias2 . `col_int_key` ) AS SQ1_field1 FROM ( A AS SQ1_alias1 INNER JOIN ( C AS SQ1_alias2 INNER JOIN C AS SQ1_alias3 ON (SQ1_alias3 . `pk` = SQ1_alias2 . `pk` ) ) ON (SQ1_alias3 . `pk` = SQ1_alias2 . `col_int_key` ) ) WHERE ( SQ1_alias1 . `col_varchar_key` <= SQ1_alias1 . `col_varchar_key` OR SQ1_alias1 . `col_int_nokey` >= SQ1_alias3 . `pk` ) ) AS field4 , alias1 . `pk` AS field5 FROM ( C AS alias1 STRAIGHT_JOIN D AS alias2 ON (alias2 . `col_varchar_key` = alias1 . `col_varchar_nokey` ) ) WHERE ( EXISTS ( SELECT SQ2_alias1 . `pk` AS SQ2_field1 FROM ( C AS SQ2_alias1 STRAIGHT_JOIN CC AS SQ2_alias2 ON (SQ2_alias2 . `pk` = SQ2_alias1 . `pk` ) ) WHERE SQ2_alias2 . `col_int_key` <> alias2 . `col_int_key` AND SQ2_alias2 . `col_varchar_key` != SQ2_alias2 . `col_varchar_key` ) ) AND alias1 . `col_int_key` = 21 OR ( alias1 . `col_varchar_key` = (SELECT s1 FROM literals.strings WHERE s1 = \'h\' ) AND alias2 . `col_varchar_key` <> \'u\' ) GROUP BY field1, field2, field3, field4, field5 HAVING (field1 < 94 AND field4 >= \'s\') /* 6 */ /* TRANSFORM_OUTCOME_UNORDERED_MATCH */' ], 'ref: test.SQ2_alias2.col_int_key' => [ ' SELECT alias1 . `col_int_nokey` AS field1 , ( SELECT MAX( SQ1_alias1 . `pk` ) AS SQ1_field1 FROM C AS SQ1_alias1 WHERE SQ1_alias1 . `col_varchar_key` <> alias1 . `col_varchar_key` OR SQ1_alias1 . `col_int_key` < alias1 . `col_int_key` ) AS field2 FROM ( C AS alias1 INNER JOIN ( ( CC AS alias2 LEFT OUTER JOIN C AS alias3 ON (alias3 . `col_varchar_nokey` = alias2 . `col_varchar_key` ) ) ) ON (alias3 . `col_varchar_key` = alias2 . `col_varchar_nokey` ) ) WHERE alias3 . `col_int_key` <= ( SELECT DISTINCT SUM( DISTINCT SQ2_alias2 . `pk` ) AS SQ2_field1 FROM ( CC AS SQ2_alias1 INNER JOIN C AS SQ2_alias2 ON (SQ2_alias2 . `col_int_key` = SQ2_alias1 . `col_int_key` ) ) ) GROUP BY field1, field2 /* 6 */', ' SELECT alias1 . `col_int_nokey` AS field1 , ( SELECT MAX( SQ1_alias1 . `pk` ) AS SQ1_field1 FROM C AS SQ1_alias1 WHERE SQ1_alias1 . `col_varchar_key` <> alias1 . `col_varchar_key` OR SQ1_alias1 . `col_int_key` < alias1 . `col_int_key` ) AS field2 FROM ( C AS alias1 INNER JOIN ( ( CC AS alias2 LEFT OUTER JOIN C AS alias3 ON (alias3 . `col_varchar_nokey` = alias2 . `col_varchar_key` ) ) ) ON (alias3 . `col_varchar_key` = alias2 . `col_varchar_nokey` ) ) WHERE alias3 . `col_int_key` <= ( SELECT DISTINCT SUM( DISTINCT SQ2_alias2 . `pk` ) AS SQ2_field1 FROM ( CC AS SQ2_alias1 INNER JOIN C AS SQ2_alias2 ON (SQ2_alias2 . `col_int_key` = SQ2_alias1 . `col_int_key` ) ) ) GROUP BY field1, field2 /* (SELECT i1 FROM literals.integers WHERE i1 = 6 ) */ /* TRANSFORM_OUTCOME_UNORDERED_MATCH */' ], 'ref: test.SQ2_alias2.col_int_nokey' => [ ' SELECT alias1 . `col_varchar_key` AS field1 , CONCAT ( alias2 . `col_varchar_key` , alias2 . `col_varchar_key` ) AS field2 , ( ( alias1 . `col_int_nokey` ) - ( alias1 . `pk` ) ) AS field3 , MAX( alias2 . `col_varchar_nokey` ) AS field4 , ( SELECT MIN( DISTINCT SQ1_alias1 . `col_int_key` ) AS SQ1_field1 FROM ( BB AS SQ1_alias1 , D AS SQ1_alias2 ) ) AS field5 , alias1 . `col_int_key` AS field6 , alias1 . `col_int_key` AS field7 FROM ( C AS alias1 STRAIGHT_JOIN BB AS alias2 ON (alias2 . `col_varchar_key` = alias1 . `col_varchar_key` ) ) WHERE ( EXISTS ( ( SELECT SQ2_alias1 . `col_varchar_key` AS SQ2_field1 FROM ( C AS SQ2_alias1 INNER JOIN ( CC AS SQ2_alias2 LEFT OUTER JOIN CC AS SQ2_alias3 ON (SQ2_alias3 . `col_int_nokey` = SQ2_alias2 . `col_int_key` ) ) ON (SQ2_alias3 . `pk` = SQ2_alias2 . `col_int_nokey` ) ) ) ) ) AND ( alias2 . `col_varchar_key` < alias1 . `col_varchar_key` OR alias1 . `col_int_key` != alias2 . `col_int_nokey` ) GROUP BY field1, field2, field3, field5, field6, field7 ORDER BY field5 ASC /* 6 */', ' SELECT alias1 . `col_varchar_key` AS field1 , CONCAT ( alias2 . `col_varchar_key` , alias2 . `col_varchar_key` ) AS field2 , ( ( alias1 . `col_int_nokey` ) - ( alias1 . `pk` ) ) AS field3 , MAX( alias2 . `col_varchar_nokey` ) AS field4 , ( SELECT MIN( DISTINCT SQ1_alias1 . `col_int_key` ) AS SQ1_field1 FROM ( BB AS SQ1_alias1 , D AS SQ1_alias2 ) ) AS field5 , alias1 . `col_int_key` AS field6 , alias1 . `col_int_key` AS field7 FROM ( C AS alias1 STRAIGHT_JOIN BB AS alias2 ON (alias2 . `col_varchar_key` = alias1 . `col_varchar_key` ) ) WHERE ( EXISTS ( ( SELECT SQ2_alias1 . `col_varchar_key` AS SQ2_field1 FROM ( C AS SQ2_alias1 INNER JOIN ( CC AS SQ2_alias2 LEFT OUTER JOIN CC AS SQ2_alias3 ON (SQ2_alias3 . `col_int_nokey` = SQ2_alias2 . `col_int_key` ) ) ON (SQ2_alias3 . `pk` = SQ2_alias2 . `col_int_nokey` ) ) ) ) ) AND ( alias2 . `col_varchar_key` < alias1 . `col_varchar_key` OR alias1 . `col_int_key` != alias2 . `col_int_nokey` ) GROUP BY field1, field2, field3, field5, field6, field7 ORDER BY field5 ASC /* (SELECT i1 FROM literals.integers WHERE i1 = 6 ) */ /* TRANSFORM_OUTCOME_UNORDERED_MATCH */' ], 'ref: test.SQ2_alias3.col_int_key' => [ ' SELECT STRAIGHT_JOIN MIN( alias2 . `col_varchar_nokey` ) AS field1 , ( SELECT \'e\' FROM DUAL ) AS field2 FROM ( CC AS alias1 INNER JOIN ( ( C AS alias2 INNER JOIN CC AS alias3 ON (alias3 . `col_int_nokey` = alias2 . `col_int_key` ) ) ) ON (alias3 . `col_int_key` = alias2 . `col_int_key` ) ) WHERE ( EXISTS ( SELECT SQ2_alias1 . `col_int_key` AS SQ2_field1 FROM ( CC AS SQ2_alias1 RIGHT JOIN ( C AS SQ2_alias2 INNER JOIN CC AS SQ2_alias3 ON (SQ2_alias3 . `col_int_key` = SQ2_alias2 . `col_int_key` ) ) ON (SQ2_alias3 . `col_int_nokey` = SQ2_alias2 . `pk` ) ) WHERE SQ2_alias2 . `col_int_key` <= alias2 . `pk` OR SQ2_alias3 . `col_varchar_nokey` != alias1 . `col_varchar_nokey` ) ) OR alias1 . `pk` > 25 AND alias1 . `pk` < ( 25 + 8 ) OR alias1 . `col_varchar_nokey` IS NULL GROUP BY field2 ORDER BY CONCAT ( alias1 . `col_varchar_key`, alias1 . `col_varchar_key` ) , CONCAT ( alias3 . `col_varchar_nokey`, alias1 . `col_varchar_key` ) /* 6 */', ' SELECT STRAIGHT_JOIN MIN( alias2 . `col_varchar_nokey` ) AS field1 , ( SELECT \'e\' FROM DUAL ) AS field2 FROM ( CC AS alias1 INNER JOIN ( ( C AS alias2 INNER JOIN CC AS alias3 ON (alias3 . `col_int_nokey` = alias2 . `col_int_key` ) ) ) ON (alias3 . `col_int_key` = alias2 . `col_int_key` ) ) WHERE ( EXISTS ( SELECT SQ2_alias1 . `col_int_key` AS SQ2_field1 FROM ( CC AS SQ2_alias1 RIGHT JOIN ( C AS SQ2_alias2 INNER JOIN CC AS SQ2_alias3 ON (SQ2_alias3 . `col_int_key` = SQ2_alias2 . `col_int_key` ) ) ON (SQ2_alias3 . `col_int_nokey` = SQ2_alias2 . `pk` ) ) WHERE SQ2_alias2 . `col_int_key` <= alias2 . `pk` OR SQ2_alias3 . `col_varchar_nokey` != alias1 . `col_varchar_nokey` ) ) OR alias1 . `pk` > (SELECT i1 FROM literals.integers WHERE i1 = 25 ) AND alias1 . `pk` < ( 25 + 8 ) OR alias1 . `col_varchar_nokey` IS NULL GROUP BY field2 ORDER BY CONCAT ( alias1 . `col_varchar_key`, alias1 . `col_varchar_key` ) , CONCAT ( alias3 . `col_varchar_nokey`, alias1 . `col_varchar_key` ) /* 6 */ /* TRANSFORM_OUTCOME_UNORDERED_MATCH */', ' SELECT STRAIGHT_JOIN MIN( alias2 . `col_varchar_nokey` ) AS field1 , ( SELECT (SELECT s1 FROM literals.strings WHERE s1 = \'e\' ) FROM DUAL ) AS field2 FROM ( CC AS alias1 INNER JOIN ( ( C AS alias2 INNER JOIN CC AS alias3 ON (alias3 . `col_int_nokey` = alias2 . `col_int_key` ) ) ) ON (alias3 . `col_int_key` = alias2 . `col_int_key` ) ) WHERE ( EXISTS ( SELECT SQ2_alias1 . `col_int_key` AS SQ2_field1 FROM ( CC AS SQ2_alias1 RIGHT JOIN ( C AS SQ2_alias2 INNER JOIN CC AS SQ2_alias3 ON (SQ2_alias3 . `col_int_key` = SQ2_alias2 . `col_int_key` ) ) ON (SQ2_alias3 . `col_int_nokey` = SQ2_alias2 . `pk` ) ) WHERE SQ2_alias2 . `col_int_key` <= alias2 . `pk` OR SQ2_alias3 . `col_varchar_nokey` != alias1 . `col_varchar_nokey` ) ) OR alias1 . `pk` > 25 AND alias1 . `pk` < ( 25 + 8 ) OR alias1 . `col_varchar_nokey` IS NULL GROUP BY field2 ORDER BY CONCAT ( alias1 . `col_varchar_key`, alias1 . `col_varchar_key` ) , CONCAT ( alias3 . `col_varchar_nokey`, alias1 . `col_varchar_key` ) /* 6 */ /* TRANSFORM_OUTCOME_UNORDERED_MATCH */', 'SELECT * FROM transforms.where_subselect_15855 WHERE (field1, field2) IN ( SELECT STRAIGHT_JOIN MIN( alias2 . `col_varchar_nokey` ) AS field1 , ( SELECT \'e\' FROM DUAL ) AS field2 FROM ( CC AS alias1 INNER JOIN ( ( C AS alias2 INNER JOIN CC AS alias3 ON (alias3 . `col_int_nokey` = alias2 . `col_int_key` ) ) ) ON (alias3 . `col_int_key` = alias2 . `col_int_key` ) ) WHERE ( EXISTS ( SELECT SQ2_alias1 . `col_int_key` AS SQ2_field1 FROM ( CC AS SQ2_alias1 RIGHT JOIN ( C AS SQ2_alias2 INNER JOIN CC AS SQ2_alias3 ON (SQ2_alias3 . `col_int_key` = SQ2_alias2 . `col_int_key` ) ) ON (SQ2_alias3 . `col_int_nokey` = SQ2_alias2 . `pk` ) ) WHERE SQ2_alias2 . `col_int_key` <= alias2 . `pk` OR SQ2_alias3 . `col_varchar_nokey` != alias1 . `col_varchar_nokey` ) ) OR alias1 . `pk` > 25 AND alias1 . `pk` < ( 25 + 8 ) OR alias1 . `col_varchar_nokey` IS NULL GROUP BY field2 ORDER BY CONCAT ( alias1 . `col_varchar_key`, alias1 . `col_varchar_key` ) , CONCAT ( alias3 . `col_varchar_nokey`, alias1 . `col_varchar_key` ) /* 6 */ ) /* TRANSFORM_OUTCOME_UNORDERED_MATCH */', 'SELECT * FROM transforms.where_subselect_15855 WHERE (field1, field2) NOT IN ( SELECT STRAIGHT_JOIN MIN( alias2 . `col_varchar_nokey` ) AS field1 , ( SELECT \'e\' FROM DUAL ) AS field2 FROM ( CC AS alias1 INNER JOIN ( ( C AS alias2 INNER JOIN CC AS alias3 ON (alias3 . `col_int_nokey` = alias2 . `col_int_key` ) ) ) ON (alias3 . `col_int_key` = alias2 . `col_int_key` ) ) WHERE ( EXISTS ( SELECT SQ2_alias1 . `col_int_key` AS SQ2_field1 FROM ( CC AS SQ2_alias1 RIGHT JOIN ( C AS SQ2_alias2 INNER JOIN CC AS SQ2_alias3 ON (SQ2_alias3 . `col_int_key` = SQ2_alias2 . `col_int_key` ) ) ON (SQ2_alias3 . `col_int_nokey` = SQ2_alias2 . `pk` ) ) WHERE SQ2_alias2 . `col_int_key` <= alias2 . `pk` OR SQ2_alias3 . `col_varchar_nokey` != alias1 . `col_varchar_nokey` ) ) OR alias1 . `pk` > 25 AND alias1 . `pk` < ( 25 + 8 ) OR alias1 . `col_varchar_nokey` IS NULL GROUP BY field2 ORDER BY CONCAT ( alias1 . `col_varchar_key`, alias1 . `col_varchar_key` ) , CONCAT ( alias3 . `col_varchar_nokey`, alias1 . `col_varchar_key` ) /* 6 */ ) /* TRANSFORM_OUTCOME_EMPTY_RESULT */' ], 'ref: test.alias2.col_varchar_key' => [ ' SELECT alias2 . `col_int_key` AS field1 FROM ( C AS alias1 INNER JOIN ( ( C AS alias2 STRAIGHT_JOIN view_C AS alias3 ON (alias3 . `col_varchar_key` = alias2 . `col_varchar_key` ) ) ) ON (alias3 . `col_varchar_nokey` = alias2 . `col_varchar_key` ) ) WHERE ( ( SELECT (SELECT s1 FROM literals.strings WHERE s1 = \'u\' ) FROM DUAL ) IS NULL ) AND alias3 . `col_varchar_nokey` > alias2 . `col_varchar_key` ORDER BY alias1 . `col_int_key` , alias2 .`pk` /* 6 */ /* TRANSFORM_OUTCOME_UNORDERED_MATCH */', ' SELECT alias1 . `col_datetime_key` AS field1 , alias1 . `col_time_key` AS field2 , alias1 . `col_int_key` AS field3 , alias1 . `col_int_key` AS field4 FROM ( BB AS alias1 , CC AS alias2 ) WHERE ( alias2 . `col_varchar_nokey` < ( SELECT MAX( SQ1_alias1 . `col_varchar_key` ) AS SQ1_field1 FROM C AS SQ1_alias1 ) ) AND ( alias2 . `col_varchar_key` IN ( SELECT SQ2_alias2 . `col_varchar_key` AS SQ2_field1 FROM ( C AS SQ2_alias1 , C AS SQ2_alias2 ) ) AND alias1 . `col_int_nokey` = alias1 . `col_int_nokey` ) ORDER BY alias1 . `col_date_key` , field1, field2, field3, field4 /* 6 */ /* TRANSFORM_OUTCOME_UNORDERED_MATCH */ ;' ], 'ref: test.alias2.col_varchar_key,test.alias1.col_int_key' => [ ' SELECT ( SELECT SUM( SQ1_alias1 . `pk` ) AS SQ1_field1 FROM CC AS SQ1_alias1 WHERE SQ1_alias1 . `col_int_nokey` > SQ1_alias1 . `col_int_key` ) AS field1 , MIN( alias2 . `col_varchar_nokey` ) AS field2 FROM ( C AS alias1 STRAIGHT_JOIN ( ( CC AS alias2 INNER JOIN C AS alias3 ON (alias3 . `col_varchar_key` = alias2 . `col_varchar_key` ) ) ) ON (alias3 . `col_int_key` = alias2 . `pk` ) ) WHERE ( alias3 . `col_int_nokey` > ( SELECT COUNT( SQ2_alias1 . `pk` ) AS SQ2_field1 FROM BB AS SQ2_alias1 WHERE ( \'w\', \'r\' ) IN ( SELECT SQL_SMALL_RESULT C_SQ1_alias1 . `col_varchar_key` AS C_SQ1_field1 , C_SQ1_alias1 . `col_varchar_key` AS C_SQ1_field2 FROM CC AS C_SQ1_alias1 WHERE ( C_SQ1_alias1 . `col_varchar_nokey` >= \'p\' OR C_SQ1_alias1 . `col_varchar_key` = \'w\' ) ) ) ) AND ( alias1 . `col_int_key` = alias2 . `pk` AND alias1 . `col_varchar_key` = \'x\' ) AND alias1 . `col_int_key` > alias1 . `col_int_nokey` GROUP BY field1 ORDER BY alias1 . `col_varchar_key` DESC /* 6 */', ' SELECT ( SELECT SUM( SQ1_alias1 . `pk` ) AS SQ1_field1 FROM CC AS SQ1_alias1 WHERE SQ1_alias1 . `col_int_nokey` > SQ1_alias1 . `col_int_key` ) AS field1 , MIN( alias2 . `col_varchar_nokey` ) AS field2 FROM ( C AS alias1 STRAIGHT_JOIN ( ( CC AS alias2 INNER JOIN C AS alias3 ON (alias3 . `col_varchar_key` = alias2 . `col_varchar_key` ) ) ) ON (alias3 . `col_int_key` = alias2 . `pk` ) ) WHERE ( alias3 . `col_int_nokey` > ( SELECT COUNT( SQ2_alias1 . `pk` ) AS SQ2_field1 FROM BB AS SQ2_alias1 WHERE ( \'w\', \'r\' ) IN ( SELECT SQL_SMALL_RESULT C_SQ1_alias1 . `col_varchar_key` AS C_SQ1_field1 , C_SQ1_alias1 . `col_varchar_key` AS C_SQ1_field2 FROM CC AS C_SQ1_alias1 WHERE ( C_SQ1_alias1 . `col_varchar_nokey` >= \'p\' OR C_SQ1_alias1 . `col_varchar_key` = \'w\' ) ) ) ) AND ( alias1 . `col_int_key` = alias2 . `pk` AND alias1 . `col_varchar_key` = \'x\' ) AND alias1 . `col_int_key` > alias1 . `col_int_nokey` GROUP BY field1 ORDER BY alias1 . `col_varchar_key` DESC /* (SELECT i1 FROM literals.integers WHERE i1 = 6 ) */ /* TRANSFORM_OUTCOME_UNORDERED_MATCH */', ' SELECT ( SELECT SUM( SQ1_alias1 . `pk` ) AS SQ1_field1 FROM CC AS SQ1_alias1 WHERE SQ1_alias1 . `col_int_nokey` > SQ1_alias1 . `col_int_key` ) AS field1 , MIN( alias2 . `col_varchar_nokey` ) AS field2 FROM ( C AS alias1 STRAIGHT_JOIN ( ( CC AS alias2 INNER JOIN C AS alias3 ON (alias3 . `col_varchar_key` = alias2 . `col_varchar_key` ) ) ) ON (alias3 . `col_int_key` = alias2 . `pk` ) ) WHERE ( alias3 . `col_int_nokey` > ( SELECT COUNT( SQ2_alias1 . `pk` ) AS SQ2_field1 FROM BB AS SQ2_alias1 WHERE ( (SELECT s1 FROM literals.strings WHERE s1 = \'w\' ) , \'r\' ) IN ( SELECT SQL_SMALL_RESULT C_SQ1_alias1 . `col_varchar_key` AS C_SQ1_field1 , C_SQ1_alias1 . `col_varchar_key` AS C_SQ1_field2 FROM CC AS C_SQ1_alias1 WHERE ( C_SQ1_alias1 . `col_varchar_nokey` >= \'p\' OR C_SQ1_alias1 . `col_varchar_key` = \'w\' ) ) ) ) AND ( alias1 . `col_int_key` = alias2 . `pk` AND alias1 . `col_varchar_key` = \'x\' ) AND alias1 . `col_int_key` > alias1 . `col_int_nokey` GROUP BY field1 ORDER BY alias1 . `col_varchar_key` DESC /* 6 */ /* TRANSFORM_OUTCOME_UNORDERED_MATCH */' ], 'ref: test.alias2.pk' => [ ' SELECT DISTINCT MAX( alias2 . `col_int_nokey` ) AS field1 FROM ( C AS alias1 RIGHT JOIN ( ( CC AS alias2 INNER JOIN CC AS alias3 ON (alias3 . `col_varchar_nokey` = alias2 . `col_varchar_key` AND ( \'w\', \'k\' ) NOT IN ( SELECT \'y\' , \'p\' UNION SELECT \'q\' , \'l\' ) ) ) ) ON (alias3 . `pk` = alias2 . `pk` ) ) WHERE ( alias2 . `col_int_nokey` <> ( SELECT DISTINCT SUM( SQ2_alias1 . `pk` ) AS SQ2_field1 FROM ( CC AS SQ2_alias1 STRAIGHT_JOIN D AS SQ2_alias2 ON (SQ2_alias2 . `col_int_key` = SQ2_alias1 . `col_int_key` ) ) ) ) AND ( alias1 . `pk` NOT IN (122, 159) OR alias1 . `col_int_key` > 169 AND alias1 . `col_int_key` < ( 169 + 204 ) ) HAVING field1 = 140 ORDER BY field1 DESC , alias1 . `col_date_key` ASC, field1 /* 6 */', ' SELECT DISTINCT MAX( alias2 . `col_int_nokey` ) AS field1 FROM ( C AS alias1 RIGHT JOIN ( ( CC AS alias2 INNER JOIN CC AS alias3 ON (alias3 . `col_varchar_nokey` = alias2 . `col_varchar_key` AND ( \'w\', \'k\' ) NOT IN ( SELECT \'y\' , \'p\' UNION SELECT \'q\' , \'l\' ) ) ) ) ON (alias3 . `pk` = alias2 . `pk` ) ) WHERE ( alias2 . `col_int_nokey` <> ( SELECT DISTINCT SUM( SQ2_alias1 . `pk` ) AS SQ2_field1 FROM ( CC AS SQ2_alias1 STRAIGHT_JOIN D AS SQ2_alias2 ON (SQ2_alias2 . `col_int_key` = SQ2_alias1 . `col_int_key` ) ) ) ) AND ( alias1 . `pk` NOT IN (122, 159) OR alias1 . `col_int_key` > 169 AND alias1 . `col_int_key` < ( 169 + 204 ) ) HAVING field1 = 140 ORDER BY field1 DESC , alias1 . `col_date_key` ASC, field1 /* 6 */ /* TRANSFORM_OUTCOME_UNORDERED_MATCH */ ;', ' SELECT DISTINCT MAX( alias2 . `col_int_nokey` ) AS field1 FROM ( C AS alias1 RIGHT JOIN ( ( CC AS alias2 INNER JOIN CC AS alias3 ON (alias3 . `col_varchar_nokey` = alias2 . `col_varchar_key` AND ( \'w\', \'k\' ) NOT IN ( SELECT \'y\' , \'p\' UNION SELECT \'q\' , \'l\' ) ) ) ) ON (alias3 . `pk` = alias2 . `pk` ) ) WHERE ( alias2 . `col_int_nokey` <> ( SELECT DISTINCT SUM( SQ2_alias1 . `pk` ) AS SQ2_field1 FROM ( CC AS SQ2_alias1 STRAIGHT_JOIN D AS SQ2_alias2 ON (SQ2_alias2 . `col_int_key` = SQ2_alias1 . `col_int_key` ) ) ) ) AND ( alias1 . `pk` NOT IN (122, (SELECT i1 FROM literals.integers WHERE i1 = 159 ) ) OR alias1 . `col_int_key` > 169 AND alias1 . `col_int_key` < ( 169 + 204 ) ) HAVING field1 = 140 ORDER BY field1 DESC , alias1 . `col_date_key` ASC, field1 /* 6 */ /* TRANSFORM_OUTCOME_UNORDERED_MATCH */', ' SELECT DISTINCT MAX( alias2 . `col_int_nokey` ) AS field1 FROM ( C AS alias1 RIGHT JOIN ( ( CC AS alias2 INNER JOIN CC AS alias3 ON (alias3 . `col_varchar_nokey` = alias2 . `col_varchar_key` AND ( (SELECT s1 FROM literals.strings WHERE s1 = \'w\' ) , \'k\' ) NOT IN ( SELECT \'y\' , \'p\' UNION SELECT \'q\' , \'l\' ) ) ) ) ON (alias3 . `pk` = alias2 . `pk` ) ) WHERE ( alias2 . `col_int_nokey` <> ( SELECT DISTINCT SUM( SQ2_alias1 . `pk` ) AS SQ2_field1 FROM ( CC AS SQ2_alias1 STRAIGHT_JOIN D AS SQ2_alias2 ON (SQ2_alias2 . `col_int_key` = SQ2_alias1 . `col_int_key` ) ) ) ) AND ( alias1 . `pk` NOT IN (122, 159) OR alias1 . `col_int_key` > 169 AND alias1 . `col_int_key` < ( 169 + 204 ) ) HAVING field1 = 140 ORDER BY field1 DESC , alias1 . `col_date_key` ASC, field1 /* 6 */ /* TRANSFORM_OUTCOME_UNORDERED_MATCH */' ], 'ref: transforms.where_subselect_15855.field1' => [ 'SELECT * FROM transforms.where_subselect_15855 WHERE (field1) IN ( SELECT alias1 . `pk` AS field1 FROM ( view_CC AS alias1 , C AS alias2 , C AS alias3 ) WHERE alias1 . `col_varchar_nokey` IN ( SELECT \'y\' UNION DISTINCT SELECT \'x\' ) GROUP BY field1 ORDER BY alias1 . `col_varchar_key` ASC /* 6 */ ) /* TRANSFORM_OUTCOME_UNORDERED_MATCH */' ], 'ref: transforms.where_subselect_15855.field1,transforms.where_subselect_15855.field2,transforms.where_subselect_15855.field3,transforms.where_subselect_15855.field4' => [ 'SELECT * FROM transforms.where_subselect_15855 WHERE (field1, field2, field3, field4) IN ( SELECT alias1 . `col_datetime_key` AS field1 , alias1 . `col_time_key` AS field2 , alias1 . `col_int_key` AS field3 , alias1 . `col_int_key` AS field4 FROM ( BB AS alias1 , CC AS alias2 ) WHERE ( alias2 . `col_varchar_nokey` < ( SELECT MAX( SQ1_alias1 . `col_varchar_key` ) AS SQ1_field1 FROM C AS SQ1_alias1 ) ) AND ( alias2 . `col_varchar_key` IN ( SELECT SQ2_alias2 . `col_varchar_key` AS SQ2_field1 FROM ( C AS SQ2_alias1 , C AS SQ2_alias2 ) ) AND alias1 . `col_int_nokey` = alias1 . `col_int_nokey` ) ORDER BY alias1 . `col_date_key` , field1, field2, field3, field4 /* 6 */ ) /* TRANSFORM_OUTCOME_UNORDERED_MATCH */' ] }; # 2011-09-27T03:19:48 Statuses: STATUS_SEMANTIC_ERROR: 15 queries, STATUS_OK: 1328 queries, STATUS_SERVER_CRASHED: 5 queries # 2011-09-27T03:19:49 Killing periodic reporting process with pid 15842... DBI connect('host=127.0.0.1:port=13000:user=root:database=test','',...) failed: Can't connect to MySQL server on '127.0.0.1' (111) at lib/GenTest/Reporter/QueryTimeout.pm line 45 DBI connect('host=127.0.0.1:port=13000:user=root:database=test','',...) failed: Lost connection to MySQL server at 'reading initial communication packet', system error: 111 at lib/GenTest/Reporter/Deadlock.pm line 82 # 2011-09-27T03:19:49 Kill GenTest::ErrorFilter(15841) # 2011-09-27T03:19:49 Server crash reported, initiating post-crash analysis... # 2011-09-27T03:19:49 datadir is /tmp/release-workdir-semijoin-materialization-sept26-actual2/current1_1/master-data/ # 2011-09-27T03:19:49 binary is /home/philips/bzr/maria-5.3/mysql-test//../sql/mysqld # 2011-09-27T03:19:49 bindir is /home/philips/bzr/maria-5.3/mysql-test//../sql # 2011-09-27T03:19:49 core is /tmp/release-workdir-semijoin-materialization-sept26-actual2/current1_1/master-data/core.15804 warning: no loadable sections found in added symbol-file system-supplied DSO at 0x7fff03bfc000 # 2011-09-27T03:19:50 [New Thread 15856] # 2011-09-27T03:19:50 [New Thread 15850] # 2011-09-27T03:19:50 [New Thread 15848] # 2011-09-27T03:19:50 [New Thread 15846] # 2011-09-27T03:19:50 [New Thread 15844] # 2011-09-27T03:19:50 [New Thread 15830] # 2011-09-27T03:19:50 [New Thread 15829] # 2011-09-27T03:19:50 [New Thread 15828] # 2011-09-27T03:19:50 [New Thread 15827] # 2011-09-27T03:19:50 [New Thread 15826] # 2011-09-27T03:19:50 [New Thread 15825] # 2011-09-27T03:19:50 [New Thread 15824] # 2011-09-27T03:19:50 [New Thread 15823] # 2011-09-27T03:19:50 [New Thread 15822] # 2011-09-27T03:19:50 [New Thread 15821] # 2011-09-27T03:19:50 [New Thread 15820] # 2011-09-27T03:19:50 [New Thread 15819] # 2011-09-27T03:19:50 [New Thread 15818] # 2011-09-27T03:19:50 [New Thread 15817] # 2011-09-27T03:19:50 [New Thread 15816] # 2011-09-27T03:19:50 [New Thread 15815] # 2011-09-27T03:19:50 [New Thread 15814] # 2011-09-27T03:19:50 [New Thread 15813] # 2011-09-27T03:19:50 [New Thread 15812] # 2011-09-27T03:19:50 [New Thread 15811] # 2011-09-27T03:19:50 [New Thread 15810] # 2011-09-27T03:19:50 [New Thread 15809] # 2011-09-27T03:19:50 [New Thread 15807] # 2011-09-27T03:19:50 [New Thread 15806] # 2011-09-27T03:19:50 [New Thread 15804] # 2011-09-27T03:19:50 Core was generated by `/home/philips/bzr/maria-5.3/sql/mysqld --no-defaults --basedir=/home/philips/bz'. # 2011-09-27T03:19:50 Program terminated with signal 11, Segmentation fault. # 2011-09-27T03:19:50 #0 0x00000033b600bd02 in pthread_kill () from /lib64/libpthread.so.0 # 2011-09-27T03:19:50 #0 0x00000033b600bd02 in pthread_kill () from /lib64/libpthread.so.0 # 2011-09-27T03:19:50 #1 0x0000000000bff81e in my_write_core (sig=11) at stacktrace.c:426 # 2011-09-27T03:19:50 #2 0x0000000000692fc7 in handle_segfault (sig=11) at mysqld.cc:2805 # 2011-09-27T03:19:50 #3 # 2011-09-27T03:19:50 #4 0x00000000006f7795 in mark_as_null_row (table=0x2aaacc181430) # 2011-09-27T03:19:50 at mysql_priv.h:2628 # 2011-09-27T03:19:50 #5 0x000000000075577d in return_zero_rows (join=0x2aaacc179220, result= # 2011-09-27T03:19:50 0x2aaacc1733a8, tables=..., fields=..., send_row=true, # 2011-09-27T03:19:50 select_options=2147796992, # 2011-09-27T03:19:50 info=0xd9a960 "Impossible WHERE noticed after reading const tables", # 2011-09-27T03:19:50 having=0x0) at sql_select.cc:10225 # 2011-09-27T03:19:50 #6 0x00000000007560e0 in JOIN::exec (this=0x2aaacc179220) # 2011-09-27T03:19:50 at sql_select.cc:2131 # 2011-09-27T03:19:50 #7 0x000000000075228e in mysql_select (thd=0x2aaabd1401d8, # 2011-09-27T03:19:50 rref_pointer_array=0x2aaabd142db0, tables=0x69771a0, wild_num=0, # 2011-09-27T03:19:50 fields=..., conds=0x2aaacc1731d0, og_num=0, order=0x0, group=0x0, # 2011-09-27T03:19:50 having=0x0, proc_param=0x0, select_options=2147796992, # 2011-09-27T03:19:50 result=0x2aaacc1733a8, unit=0x2aaabd142678, select_lex=0x2aaabd142b60) # 2011-09-27T03:19:50 at sql_select.cc:2900 # 2011-09-27T03:19:50 #8 0x00000000007586b8 in handle_select (thd=0x2aaabd1401d8, # 2011-09-27T03:19:50 lex=0x2aaabd1425d8, result=0x2aaacc1733a8, setup_tables_done_option=0) # 2011-09-27T03:19:50 at sql_select.cc:283 # 2011-09-27T03:19:50 #9 0x00000000006a464a in execute_sqlcom_select (thd=0x2aaabd1401d8, # 2011-09-27T03:19:50 all_tables=0x69771a0) at sql_parse.cc:5102 # 2011-09-27T03:19:50 #10 0x00000000006a672a in mysql_execute_command (thd=0x2aaabd1401d8) # 2011-09-27T03:19:50 at sql_parse.cc:2247 # 2011-09-27T03:19:50 #11 0x00000000006af4c3 in mysql_parse (thd=0x2aaabd1401d8, # 2011-09-27T03:19:50 rawbuf=0x6976430 "SELECT SUM( alias1 . `col_int_key` ) AS field1 FROM ( BB AS alias1 INNER JOIN ( ( BB AS alias2 STRAIGHT_JOIN C AS alias3 ON (alias3 . `pk` = alias2 . `pk` ) ) ) ON (alias3 . `pk` = alias2 . `col_int_key` ) ) WHERE ( ( 7, 8 ) IN ( SELECT SQ1_alias1 . `pk` AS SQ1_field1 , SQ1_alias1 . `pk` AS SQ1_field2 FROM ( C AS SQ1_alias1 LEFT OUTER JOIN B AS SQ1_alias2 ON (SQ1_alias2 . `col_varchar_key` = SQ1_alias1 . `col_varchar_nokey` ) ) HAVING SQ1_alias1 . `pk` = 'v' ) ) AND ( alias1 . `pk` > 71 AND alias1 . `pk` < ( 71 + 59 ) OR alias1 . `pk` NOT IN (120) ) AND ( alias3 . `col_varchar_key` IN ( SELECT 'j' UNION SELECT 'p' ) AND alias1 . `col_int_key` IS NULL ) /* 5 */", # 2011-09-27T03:19:50 length=688, found_semicolon=0x4f921f08) at sql_parse.cc:6102 # 2011-09-27T03:19:50 #12 0x00000000006b0051 in dispatch_command (command=COM_QUERY, # 2011-09-27T03:19:50 thd=0x2aaabd1401d8, # 2011-09-27T03:19:50 packet=0x2aaabd147819 " SELECT SUM( alias1 . `col_int_key` ) AS field1 FROM ( BB AS alias1 INNER JOIN ( ( BB AS alias2 STRAIGHT_JOIN C AS alias3 ON (alias3 . `pk` = alias2 . `pk` ) ) ) ON (alias3 . `pk` = alias2 . `col_int_key` ) ) WHERE ( ( 7, 8 ) IN ( SELECT SQ1_alias1 . `pk` AS SQ1_field1 , SQ1_alias1 . `pk` AS SQ1_field2 FROM ( C AS SQ1_alias1 LEFT OUTER JOIN B AS SQ1_alias2 ON (SQ1_alias2 . `col_varchar_key` = SQ1_alias1 . `col_varchar_nokey` ) ) HAVING SQ1_alias1 . `pk` = 'v' ) ) AND ( alias1 . `pk` > 71 AND alias1 . `pk` < ( 71 + 59 ) OR alias1 . `pk` NOT IN (120) ) AND ( alias3 . `col_varchar_key` IN ( SELECT 'j' UNION SELECT 'p' ) AND alias1 . `col_int_key` IS NULL ) /* 5 */", packet_length=690) at sql_parse.cc:1221 # 2011-09-27T03:19:50 #13 0x00000000006b168f in do_command (thd=0x2aaabd1401d8) at sql_parse.cc:916 # 2011-09-27T03:19:50 #14 0x000000000069be9f in handle_one_connection (arg=0x2aaabd1401d8) # 2011-09-27T03:19:50 at sql_connect.cc:1187 # 2011-09-27T03:19:50 #15 0x00000033b600673d in start_thread () from /lib64/libpthread.so.0 # 2011-09-27T03:19:50 #16 0x00000033b58d40cd in clone () from /lib64/libc.so.6 # 2011-09-27T03:19:50 #5 0x000000000075577d in return_zero_rows (join=0x2aaacc179220, # 2011-09-27T03:19:50 result=0x2aaacc1733a8, tables=..., fields=..., send_row=true, # 2011-09-27T03:19:50 select_options=2147796992, # 2011-09-27T03:19:50 info=0xd9a960 "Impossible WHERE noticed after reading const tables", # 2011-09-27T03:19:50 having=0x0) at sql_select.cc:10225 # 2011-09-27T03:19:50 10225 mark_as_null_row(table->table); // All fields are NULL # 2011-09-27T03:19:50 10220 if (send_row) # 2011-09-27T03:19:50 10221 { # 2011-09-27T03:19:50 10222 List_iterator ti(tables); # 2011-09-27T03:19:50 10223 TABLE_LIST *table; # 2011-09-27T03:19:50 10224 while ((table= ti++)) # 2011-09-27T03:19:50 10225 mark_as_null_row(table->table); // All fields are NULL # 2011-09-27T03:19:50 10226 if (having && # 2011-09-27T03:19:50 10227 !having->walk(&Item::clear_sum_processor, FALSE, NULL) && # 2011-09-27T03:19:50 10228 having->val_int() == 0) # 2011-09-27T03:19:50 10229 send_row=0; warning: no loadable sections found in added symbol-file system-supplied DSO at 0x7fff03bfc000 # 2011-09-27T03:19:50 [New Thread 15856] # 2011-09-27T03:19:50 [New Thread 15850] # 2011-09-27T03:19:50 [New Thread 15848] # 2011-09-27T03:19:50 [New Thread 15846] # 2011-09-27T03:19:50 [New Thread 15844] # 2011-09-27T03:19:50 [New Thread 15830] # 2011-09-27T03:19:50 [New Thread 15829] # 2011-09-27T03:19:50 [New Thread 15828] # 2011-09-27T03:19:50 [New Thread 15827] # 2011-09-27T03:19:50 [New Thread 15826] # 2011-09-27T03:19:50 [New Thread 15825] # 2011-09-27T03:19:50 [New Thread 15824] # 2011-09-27T03:19:50 [New Thread 15823] # 2011-09-27T03:19:50 [New Thread 15822] # 2011-09-27T03:19:50 [New Thread 15821] # 2011-09-27T03:19:50 [New Thread 15820] # 2011-09-27T03:19:50 [New Thread 15819] # 2011-09-27T03:19:50 [New Thread 15818] # 2011-09-27T03:19:50 [New Thread 15817] # 2011-09-27T03:19:50 [New Thread 15816] # 2011-09-27T03:19:50 [New Thread 15815] # 2011-09-27T03:19:50 [New Thread 15814] # 2011-09-27T03:19:50 [New Thread 15813] # 2011-09-27T03:19:50 [New Thread 15812] # 2011-09-27T03:19:50 [New Thread 15811] # 2011-09-27T03:19:50 [New Thread 15810] # 2011-09-27T03:19:50 [New Thread 15809] # 2011-09-27T03:19:50 [New Thread 15807] # 2011-09-27T03:19:50 [New Thread 15806] # 2011-09-27T03:19:50 [New Thread 15804] # 2011-09-27T03:19:50 Core was generated by `/home/philips/bzr/maria-5.3/sql/mysqld --no-defaults --basedir=/home/philips/bz'. # 2011-09-27T03:19:50 Program terminated with signal 11, Segmentation fault. # 2011-09-27T03:19:50 #0 0x00000033b600bd02 in pthread_kill () from /lib64/libpthread.so.0 # 2011-09-27T03:19:50 # 2011-09-27T03:19:50 Thread 31 (Thread 15804): # 2011-09-27T03:19:50 #0 0x00000033b58cd372 in select () from /lib64/libc.so.6 # 2011-09-27T03:19:50 #1 0x0000000000693b9c in handle_connections_sockets (arg=0x0) # 2011-09-27T03:19:50 at mysqld.cc:5441 # 2011-09-27T03:19:50 #2 0x0000000000697066 in main (argc=52, argv=0x7fff03b7b388) at mysqld.cc:4911 # 2011-09-27T03:19:50 # 2011-09-27T03:19:50 Thread 30 (Thread 15806): # 2011-09-27T03:19:50 #0 0x00000033b600b150 in pthread_cond_timedwait@@GLIBC_2.3.2 () # 2011-09-27T03:19:50 from /lib64/libpthread.so.0 # 2011-09-27T03:19:50 #1 0x0000000000c05923 in safe_cond_timedwait (cond=0x12b4020, mp=0x12b3f80, # 2011-09-27T03:19:50 abstime=0x41c34080, file=0xe0b480 "ma_servicethread.c", line=101) # 2011-09-27T03:19:50 at thr_mutex.c:550 # 2011-09-27T03:19:50 #2 0x0000000000a5afc8 in my_service_thread_sleep (control=0x128cc90, # 2011-09-27T03:19:50 sleep_time=29000000000) at ma_servicethread.c:100 # 2011-09-27T03:19:50 #3 0x00000000009f92c9 in ma_checkpoint_background (arg=0x1e) # 2011-09-27T03:19:50 at ma_checkpoint.c:706 # 2011-09-27T03:19:50 #4 0x00000033b600673d in start_thread () from /lib64/libpthread.so.0 # 2011-09-27T03:19:50 #5 0x00000033b58d40cd in clone () from /lib64/libc.so.6 # 2011-09-27T03:19:50 # 2011-09-27T03:19:50 Thread 29 (Thread 15807): # 2011-09-27T03:19:50 #0 0x00000033b600b150 in pthread_cond_timedwait@@GLIBC_2.3.2 () # 2011-09-27T03:19:50 from /lib64/libpthread.so.0 # 2011-09-27T03:19:50 #1 0x0000000000a9a878 in xt_timed_wait_cond(XTThreadPtr, ._6 *, ._4 *, unsigned long) (self=0x0, cond=0x1abad00, mutex=0x1abacd8, milli_sec=500) # 2011-09-27T03:19:50 at thread_xt.cc:1986 # 2011-09-27T03:19:50 #2 0x0000000000aba475 in tabc_fr_wait_for_cache (self=0x5fdc2e8, msecs=500) # 2011-09-27T03:19:50 at tabcache_xt.cc:873 # 2011-09-27T03:19:50 #3 0x0000000000abb324 in tabc_fr_main (self=0x5fdc2e8) at tabcache_xt.cc:1194 # 2011-09-27T03:19:50 #4 0x0000000000abb4e7 in tabc_fr_run_thread (self=0x5fdc2e8) # 2011-09-27T03:19:50 at tabcache_xt.cc:1213 # 2011-09-27T03:19:50 #5 0x0000000000a9d370 in xt_thread_main (data=0x7fff03b7abf0) # 2011-09-27T03:19:50 at thread_xt.cc:1044 # 2011-09-27T03:19:50 #6 0x00000033b600673d in start_thread () from /lib64/libpthread.so.0 # 2011-09-27T03:19:50 #7 0x00000033b58d40cd in clone () from /lib64/libc.so.6 # 2011-09-27T03:19:50 # 2011-09-27T03:19:50 Thread 28 (Thread 15809): # 2011-09-27T03:19:50 #0 0x00000033b600b150 in pthread_cond_timedwait@@GLIBC_2.3.2 () # 2011-09-27T03:19:50 from /lib64/libpthread.so.0 # 2011-09-27T03:19:50 #1 0x0000000000a9a878 in xt_timed_wait_cond(XTThreadPtr, ._6 *, ._4 *, unsigned long) (self=0x653bc28, cond=0x61a6120, mutex=0x61a60f8, milli_sec=100) # 2011-09-27T03:19:50 at thread_xt.cc:1986 # 2011-09-27T03:19:50 #2 0x0000000000a7a18c in xn_sw_wait_for_xact (self=0x653bc28, db=0x6164028, # 2011-09-27T03:19:50 hsecs=10) at xaction_xt.cc:2849 # 2011-09-27T03:19:50 #3 0x0000000000a7b91b in xn_sw_main (self=0x653bc28) at xaction_xt.cc:2748 # 2011-09-27T03:19:50 #4 0x0000000000a7bb29 in xn_sw_run_thread (self=0x653bc28) # 2011-09-27T03:19:50 at xaction_xt.cc:2793 # 2011-09-27T03:19:50 #5 0x0000000000a9d370 in xt_thread_main (data=0x43033ed0) at thread_xt.cc:1044 # 2011-09-27T03:19:50 #6 0x00000033b600673d in start_thread () from /lib64/libpthread.so.0 # 2011-09-27T03:19:50 #7 0x00000033b58d40cd in clone () from /lib64/libc.so.6 # 2011-09-27T03:19:50 # 2011-09-27T03:19:50 Thread 27 (Thread 15810): # 2011-09-27T03:19:50 #0 0x00000033b600b150 in pthread_cond_timedwait@@GLIBC_2.3.2 () # 2011-09-27T03:19:50 from /lib64/libpthread.so.0 # 2011-09-27T03:19:50 #1 0x0000000000a9a878 in xt_timed_wait_cond(XTThreadPtr, ._6 *, ._4 *, unsigned long) (self=0x65864c8, cond=0x61a6228, mutex=0x61a6200, milli_sec=120000) # 2011-09-27T03:19:50 at thread_xt.cc:1986 # 2011-09-27T03:19:50 #2 0x0000000000aaf19b in dl_co_wait (self=0x65864c8, db=0x6164028, secs=120) # 2011-09-27T03:19:50 at datalog_xt.cc:1714 # 2011-09-27T03:19:50 #3 0x0000000000ab3754 in dl_co_main (self=0x65864c8, once_off=0) # 2011-09-27T03:19:50 at datalog_xt.cc:2013 # 2011-09-27T03:19:50 #4 0x0000000000ab38f8 in dl_run_co_thread (self=0x65864c8) # 2011-09-27T03:19:50 at datalog_xt.cc:2051 # 2011-09-27T03:19:50 #5 0x0000000000a9d370 in xt_thread_main (data=0x43033ed0) at thread_xt.cc:1044 # 2011-09-27T03:19:50 #6 0x00000033b600673d in start_thread () from /lib64/libpthread.so.0 # 2011-09-27T03:19:50 #7 0x00000033b58d40cd in clone () from /lib64/libc.so.6 # 2011-09-27T03:19:50 # 2011-09-27T03:19:50 Thread 26 (Thread 15811): # 2011-09-27T03:19:50 #0 0x00000033b600b150 in pthread_cond_timedwait@@GLIBC_2.3.2 () # 2011-09-27T03:19:50 from /lib64/libpthread.so.0 # 2011-09-27T03:19:50 #1 0x0000000000a9a878 in xt_timed_wait_cond(XTThreadPtr, ._6 *, ._4 *, unsigned long) (self=0x6590d08, cond=0x61a61a8, mutex=0x61a6180, milli_sec=500) # 2011-09-27T03:19:50 at thread_xt.cc:1986 # 2011-09-27T03:19:50 #2 0x0000000000adabb9 in xlog_wr_wait_for_log_flush (self=0x6590d08, # 2011-09-27T03:19:50 db=0x6164028) at xactlog_xt.cc:2425 # 2011-09-27T03:19:50 #3 0x0000000000adb3ee in xlog_wr_main (self=0x6590d08) at xactlog_xt.cc:2622 # 2011-09-27T03:19:50 #4 0x0000000000adb5b6 in xlog_wr_run_thread (self=0x6590d08) # 2011-09-27T03:19:50 at xactlog_xt.cc:2647 # 2011-09-27T03:19:50 #5 0x0000000000a9d370 in xt_thread_main (data=0x43033ed0) at thread_xt.cc:1044 # 2011-09-27T03:19:50 #6 0x00000033b600673d in start_thread () from /lib64/libpthread.so.0 # 2011-09-27T03:19:50 #7 0x00000033b58d40cd in clone () from /lib64/libc.so.6 # 2011-09-27T03:19:50 # 2011-09-27T03:19:50 Thread 25 (Thread 15812): # 2011-09-27T03:19:50 #0 0x00000033b600b150 in pthread_cond_timedwait@@GLIBC_2.3.2 () # 2011-09-27T03:19:50 from /lib64/libpthread.so.0 # 2011-09-27T03:19:50 #1 0x0000000000a9a878 in xt_timed_wait_cond(XTThreadPtr, ._6 *, ._4 *, unsigned long) (self=0x65db568, cond=0x61b9f10, mutex=0x61b9ee8, milli_sec=400) # 2011-09-27T03:19:50 at thread_xt.cc:1986 # 2011-09-27T03:19:50 #2 0x0000000000abe86d in xres_cp_wait_for_log_writer (self=0x65db568, # 2011-09-27T03:19:50 db=0x6164028, milli_secs=400) at restart_xt.cc:2575 # 2011-09-27T03:19:50 #3 0x0000000000ac3f22 in xres_cp_main (self=0x65db568) at restart_xt.cc:2656 # 2011-09-27T03:19:50 #4 0x0000000000ac4107 in xres_cp_run_thread (self=0x65db568) # 2011-09-27T03:19:50 at restart_xt.cc:2684 # 2011-09-27T03:19:50 #5 0x0000000000a9d370 in xt_thread_main (data=0x43033ed0) at thread_xt.cc:1044 # 2011-09-27T03:19:50 #6 0x00000033b600673d in start_thread () from /lib64/libpthread.so.0 # 2011-09-27T03:19:50 #7 0x00000033b58d40cd in clone () from /lib64/libc.so.6 # 2011-09-27T03:19:50 # 2011-09-27T03:19:50 Thread 24 (Thread 15813): # 2011-09-27T03:19:50 #0 0x00000033b600aee9 in pthread_cond_wait@@GLIBC_2.3.2 () # 2011-09-27T03:19:50 from /lib64/libpthread.so.0 # 2011-09-27T03:19:50 #1 0x0000000000c05664 in safe_cond_wait (cond=0x2aaabc9277a0, # 2011-09-27T03:19:50 mp=0x2aaabc9276f0, file=0xe294d8 "os/os0sync.c", line=210) # 2011-09-27T03:19:50 at thr_mutex.c:496 # 2011-09-27T03:19:50 #2 0x0000000000b1a17e in os_cond_wait (cond=0x2aaabc9277a0, # 2011-09-27T03:19:50 mutex=0x2aaabc9276f0) at os/os0sync.c:210 # 2011-09-27T03:19:50 #3 0x0000000000b1a950 in os_event_wait_low (event=0x2aaabc9276f0, # 2011-09-27T03:19:50 reset_sig_count=0) at os/os0sync.c:636 # 2011-09-27T03:19:50 #4 0x0000000000b18d7a in os_aio_simulated_handle (global_segment=0, # 2011-09-27T03:19:50 message1=0x4623b0e0, message2=0x4623b0d8, type=0x4623b0d0, # 2011-09-27T03:19:50 space_id=0x4623b0c8) at os/os0file.c:4238 # 2011-09-27T03:19:50 #5 0x0000000000bb80f9 in fil_aio_wait (segment=0) at fil/fil0fil.c:5110 # 2011-09-27T03:19:50 #6 0x0000000000b55e57 in io_handler_thread (arg=0x1abd2a0) # 2011-09-27T03:19:50 at srv/srv0start.c:474 # 2011-09-27T03:19:50 #7 0x00000033b600673d in start_thread () from /lib64/libpthread.so.0 # 2011-09-27T03:19:50 #8 0x00000033b58d40cd in clone () from /lib64/libc.so.6 # 2011-09-27T03:19:50 # 2011-09-27T03:19:50 Thread 23 (Thread 15814): # 2011-09-27T03:19:50 #0 0x00000033b600aee9 in pthread_cond_wait@@GLIBC_2.3.2 () # 2011-09-27T03:19:50 from /lib64/libpthread.so.0 # 2011-09-27T03:19:50 #1 0x0000000000c05664 in safe_cond_wait (cond=0x2aaabc9278a0, # 2011-09-27T03:19:50 mp=0x2aaabc9277f0, file=0xe294d8 "os/os0sync.c", line=210) # 2011-09-27T03:19:50 at thr_mutex.c:496 # 2011-09-27T03:19:50 #2 0x0000000000b1a17e in os_cond_wait (cond=0x2aaabc9278a0, # 2011-09-27T03:19:50 mutex=0x2aaabc9277f0) at os/os0sync.c:210 # 2011-09-27T03:19:50 #3 0x0000000000b1a950 in os_event_wait_low (event=0x2aaabc9277f0, # 2011-09-27T03:19:50 reset_sig_count=0) at os/os0sync.c:636 # 2011-09-27T03:19:50 #4 0x0000000000b18d7a in os_aio_simulated_handle (global_segment=1, # 2011-09-27T03:19:50 message1=0x46c3c0e0, message2=0x46c3c0d8, type=0x46c3c0d0, # 2011-09-27T03:19:50 space_id=0x46c3c0c8) at os/os0file.c:4238 # 2011-09-27T03:19:50 #5 0x0000000000bb80f9 in fil_aio_wait (segment=1) at fil/fil0fil.c:5110 # 2011-09-27T03:19:50 #6 0x0000000000b55e57 in io_handler_thread (arg=0x1abd2a8) # 2011-09-27T03:19:50 at srv/srv0start.c:474 # 2011-09-27T03:19:50 #7 0x00000033b600673d in start_thread () from /lib64/libpthread.so.0 # 2011-09-27T03:19:50 #8 0x00000033b58d40cd in clone () from /lib64/libc.so.6 # 2011-09-27T03:19:50 # 2011-09-27T03:19:50 Thread 22 (Thread 15815): # 2011-09-27T03:19:50 #0 0x00000033b600aee9 in pthread_cond_wait@@GLIBC_2.3.2 () # 2011-09-27T03:19:50 from /lib64/libpthread.so.0 # 2011-09-27T03:19:50 #1 0x0000000000c05664 in safe_cond_wait (cond=0x2aaabc9279a0, # 2011-09-27T03:19:50 mp=0x2aaabc9278f0, file=0xe294d8 "os/os0sync.c", line=210) # 2011-09-27T03:19:50 at thr_mutex.c:496 # 2011-09-27T03:19:50 #2 0x0000000000b1a17e in os_cond_wait (cond=0x2aaabc9279a0, # 2011-09-27T03:19:50 mutex=0x2aaabc9278f0) at os/os0sync.c:210 # 2011-09-27T03:19:50 #3 0x0000000000b1a950 in os_event_wait_low (event=0x2aaabc9278f0, # 2011-09-27T03:19:50 reset_sig_count=0) at os/os0sync.c:636 # 2011-09-27T03:19:50 #4 0x0000000000b18d7a in os_aio_simulated_handle (global_segment=2, # 2011-09-27T03:19:50 message1=0x4763d0e0, message2=0x4763d0d8, type=0x4763d0d0, # 2011-09-27T03:19:50 space_id=0x4763d0c8) at os/os0file.c:4238 # 2011-09-27T03:19:50 #5 0x0000000000bb80f9 in fil_aio_wait (segment=2) at fil/fil0fil.c:5110 # 2011-09-27T03:19:50 #6 0x0000000000b55e57 in io_handler_thread (arg=0x1abd2b0) # 2011-09-27T03:19:50 at srv/srv0start.c:474 # 2011-09-27T03:19:50 #7 0x00000033b600673d in start_thread () from /lib64/libpthread.so.0 # 2011-09-27T03:19:50 #8 0x00000033b58d40cd in clone () from /lib64/libc.so.6 # 2011-09-27T03:19:50 # 2011-09-27T03:19:50 Thread 21 (Thread 15816): # 2011-09-27T03:19:50 #0 0x00000033b600aee9 in pthread_cond_wait@@GLIBC_2.3.2 () # 2011-09-27T03:19:50 from /lib64/libpthread.so.0 # 2011-09-27T03:19:50 #1 0x0000000000c05664 in safe_cond_wait (cond=0x2aaabc927aa0, # 2011-09-27T03:19:50 mp=0x2aaabc9279f0, file=0xe294d8 "os/os0sync.c", line=210) # 2011-09-27T03:19:50 at thr_mutex.c:496 # 2011-09-27T03:19:50 #2 0x0000000000b1a17e in os_cond_wait (cond=0x2aaabc927aa0, # 2011-09-27T03:19:50 mutex=0x2aaabc9279f0) at os/os0sync.c:210 # 2011-09-27T03:19:50 #3 0x0000000000b1a950 in os_event_wait_low (event=0x2aaabc9279f0, # 2011-09-27T03:19:50 reset_sig_count=0) at os/os0sync.c:636 # 2011-09-27T03:19:50 #4 0x0000000000b18d7a in os_aio_simulated_handle (global_segment=3, # 2011-09-27T03:19:50 message1=0x4803e0e0, message2=0x4803e0d8, type=0x4803e0d0, # 2011-09-27T03:19:50 space_id=0x4803e0c8) at os/os0file.c:4238 # 2011-09-27T03:19:50 #5 0x0000000000bb80f9 in fil_aio_wait (segment=3) at fil/fil0fil.c:5110 # 2011-09-27T03:19:50 #6 0x0000000000b55e57 in io_handler_thread (arg=0x1abd2b8) # 2011-09-27T03:19:50 at srv/srv0start.c:474 # 2011-09-27T03:19:50 #7 0x00000033b600673d in start_thread () from /lib64/libpthread.so.0 # 2011-09-27T03:19:50 #8 0x00000033b58d40cd in clone () from /lib64/libc.so.6 # 2011-09-27T03:19:50 # 2011-09-27T03:19:50 Thread 20 (Thread 15817): # 2011-09-27T03:19:50 #0 0x00000033b600aee9 in pthread_cond_wait@@GLIBC_2.3.2 () # 2011-09-27T03:19:50 from /lib64/libpthread.so.0 # 2011-09-27T03:19:50 #1 0x0000000000c05664 in safe_cond_wait (cond=0x2aaabc927ba0, # 2011-09-27T03:19:50 mp=0x2aaabc927af0, file=0xe294d8 "os/os0sync.c", line=210) # 2011-09-27T03:19:50 at thr_mutex.c:496 # 2011-09-27T03:19:50 #2 0x0000000000b1a17e in os_cond_wait (cond=0x2aaabc927ba0, # 2011-09-27T03:19:50 mutex=0x2aaabc927af0) at os/os0sync.c:210 # 2011-09-27T03:19:50 #3 0x0000000000b1a950 in os_event_wait_low (event=0x2aaabc927af0, # 2011-09-27T03:19:50 reset_sig_count=0) at os/os0sync.c:636 # 2011-09-27T03:19:50 #4 0x0000000000b18d7a in os_aio_simulated_handle (global_segment=4, # 2011-09-27T03:19:50 message1=0x48a3f0e0, message2=0x48a3f0d8, type=0x48a3f0d0, # 2011-09-27T03:19:50 space_id=0x48a3f0c8) at os/os0file.c:4238 # 2011-09-27T03:19:50 #5 0x0000000000bb80f9 in fil_aio_wait (segment=4) at fil/fil0fil.c:5110 # 2011-09-27T03:19:50 #6 0x0000000000b55e57 in io_handler_thread (arg=0x1abd2c0) # 2011-09-27T03:19:50 at srv/srv0start.c:474 # 2011-09-27T03:19:50 #7 0x00000033b600673d in start_thread () from /lib64/libpthread.so.0 # 2011-09-27T03:19:50 #8 0x00000033b58d40cd in clone () from /lib64/libc.so.6 # 2011-09-27T03:19:50 # 2011-09-27T03:19:50 Thread 19 (Thread 15818): # 2011-09-27T03:19:50 #0 0x00000033b600aee9 in pthread_cond_wait@@GLIBC_2.3.2 () # 2011-09-27T03:19:50 from /lib64/libpthread.so.0 # 2011-09-27T03:19:50 #1 0x0000000000c05664 in safe_cond_wait (cond=0x2aaabc927ca0, # 2011-09-27T03:19:50 mp=0x2aaabc927bf0, file=0xe294d8 "os/os0sync.c", line=210) # 2011-09-27T03:19:50 at thr_mutex.c:496 # 2011-09-27T03:19:50 #2 0x0000000000b1a17e in os_cond_wait (cond=0x2aaabc927ca0, # 2011-09-27T03:19:50 mutex=0x2aaabc927bf0) at os/os0sync.c:210 # 2011-09-27T03:19:50 #3 0x0000000000b1a950 in os_event_wait_low (event=0x2aaabc927bf0, # 2011-09-27T03:19:50 reset_sig_count=0) at os/os0sync.c:636 # 2011-09-27T03:19:50 #4 0x0000000000b18d7a in os_aio_simulated_handle (global_segment=5, # 2011-09-27T03:19:50 message1=0x494400e0, message2=0x494400d8, type=0x494400d0, # 2011-09-27T03:19:50 space_id=0x494400c8) at os/os0file.c:4238 # 2011-09-27T03:19:50 #5 0x0000000000bb80f9 in fil_aio_wait (segment=5) at fil/fil0fil.c:5110 # 2011-09-27T03:19:50 #6 0x0000000000b55e57 in io_handler_thread (arg=0x1abd2c8) # 2011-09-27T03:19:50 at srv/srv0start.c:474 # 2011-09-27T03:19:50 #7 0x00000033b600673d in start_thread () from /lib64/libpthread.so.0 # 2011-09-27T03:19:50 #8 0x00000033b58d40cd in clone () from /lib64/libc.so.6 # 2011-09-27T03:19:50 # 2011-09-27T03:19:50 Thread 18 (Thread 15819): # 2011-09-27T03:19:50 #0 0x00000033b600aee9 in pthread_cond_wait@@GLIBC_2.3.2 () # 2011-09-27T03:19:50 from /lib64/libpthread.so.0 # 2011-09-27T03:19:50 #1 0x0000000000c05664 in safe_cond_wait (cond=0x2aaabc927da0, # 2011-09-27T03:19:50 mp=0x2aaabc927cf0, file=0xe294d8 "os/os0sync.c", line=210) # 2011-09-27T03:19:50 at thr_mutex.c:496 # 2011-09-27T03:19:50 #2 0x0000000000b1a17e in os_cond_wait (cond=0x2aaabc927da0, # 2011-09-27T03:19:50 mutex=0x2aaabc927cf0) at os/os0sync.c:210 # 2011-09-27T03:19:50 #3 0x0000000000b1a950 in os_event_wait_low (event=0x2aaabc927cf0, # 2011-09-27T03:19:50 reset_sig_count=0) at os/os0sync.c:636 # 2011-09-27T03:19:50 #4 0x0000000000b18d7a in os_aio_simulated_handle (global_segment=6, # 2011-09-27T03:19:50 message1=0x49e410e0, message2=0x49e410d8, type=0x49e410d0, # 2011-09-27T03:19:50 space_id=0x49e410c8) at os/os0file.c:4238 # 2011-09-27T03:19:50 #5 0x0000000000bb80f9 in fil_aio_wait (segment=6) at fil/fil0fil.c:5110 # 2011-09-27T03:19:50 #6 0x0000000000b55e57 in io_handler_thread (arg=0x1abd2d0) # 2011-09-27T03:19:50 at srv/srv0start.c:474 # 2011-09-27T03:19:50 #7 0x00000033b600673d in start_thread () from /lib64/libpthread.so.0 # 2011-09-27T03:19:50 #8 0x00000033b58d40cd in clone () from /lib64/libc.so.6 # 2011-09-27T03:19:50 # 2011-09-27T03:19:50 Thread 17 (Thread 15820): # 2011-09-27T03:19:50 #0 0x00000033b600aee9 in pthread_cond_wait@@GLIBC_2.3.2 () # 2011-09-27T03:19:50 from /lib64/libpthread.so.0 # 2011-09-27T03:19:50 #1 0x0000000000c05664 in safe_cond_wait (cond=0x2aaabc927ea0, # 2011-09-27T03:19:50 mp=0x2aaabc927df0, file=0xe294d8 "os/os0sync.c", line=210) # 2011-09-27T03:19:50 at thr_mutex.c:496 # 2011-09-27T03:19:50 #2 0x0000000000b1a17e in os_cond_wait (cond=0x2aaabc927ea0, # 2011-09-27T03:19:50 mutex=0x2aaabc927df0) at os/os0sync.c:210 # 2011-09-27T03:19:50 #3 0x0000000000b1a950 in os_event_wait_low (event=0x2aaabc927df0, # 2011-09-27T03:19:50 reset_sig_count=0) at os/os0sync.c:636 # 2011-09-27T03:19:50 #4 0x0000000000b18d7a in os_aio_simulated_handle (global_segment=7, # 2011-09-27T03:19:50 message1=0x4a8420e0, message2=0x4a8420d8, type=0x4a8420d0, # 2011-09-27T03:19:50 space_id=0x4a8420c8) at os/os0file.c:4238 # 2011-09-27T03:19:50 #5 0x0000000000bb80f9 in fil_aio_wait (segment=7) at fil/fil0fil.c:5110 # 2011-09-27T03:19:50 #6 0x0000000000b55e57 in io_handler_thread (arg=0x1abd2d8) # 2011-09-27T03:19:50 at srv/srv0start.c:474 # 2011-09-27T03:19:50 #7 0x00000033b600673d in start_thread () from /lib64/libpthread.so.0 # 2011-09-27T03:19:50 #8 0x00000033b58d40cd in clone () from /lib64/libc.so.6 # 2011-09-27T03:19:50 # 2011-09-27T03:19:50 Thread 16 (Thread 15821): # 2011-09-27T03:19:50 #0 0x00000033b600aee9 in pthread_cond_wait@@GLIBC_2.3.2 () # 2011-09-27T03:19:50 from /lib64/libpthread.so.0 # 2011-09-27T03:19:50 #1 0x0000000000c05664 in safe_cond_wait (cond=0x2aaabc927fa0, # 2011-09-27T03:19:50 mp=0x2aaabc927ef0, file=0xe294d8 "os/os0sync.c", line=210) # 2011-09-27T03:19:50 at thr_mutex.c:496 # 2011-09-27T03:19:50 #2 0x0000000000b1a17e in os_cond_wait (cond=0x2aaabc927fa0, # 2011-09-27T03:19:50 mutex=0x2aaabc927ef0) at os/os0sync.c:210 # 2011-09-27T03:19:50 #3 0x0000000000b1a950 in os_event_wait_low (event=0x2aaabc927ef0, # 2011-09-27T03:19:50 reset_sig_count=0) at os/os0sync.c:636 # 2011-09-27T03:19:50 #4 0x0000000000b18d7a in os_aio_simulated_handle (global_segment=8, # 2011-09-27T03:19:50 message1=0x4b2430e0, message2=0x4b2430d8, type=0x4b2430d0, # 2011-09-27T03:19:50 space_id=0x4b2430c8) at os/os0file.c:4238 # 2011-09-27T03:19:50 #5 0x0000000000bb80f9 in fil_aio_wait (segment=8) at fil/fil0fil.c:5110 # 2011-09-27T03:19:50 #6 0x0000000000b55e57 in io_handler_thread (arg=0x1abd2e0) # 2011-09-27T03:19:50 at srv/srv0start.c:474 # 2011-09-27T03:19:50 #7 0x00000033b600673d in start_thread () from /lib64/libpthread.so.0 # 2011-09-27T03:19:50 #8 0x00000033b58d40cd in clone () from /lib64/libc.so.6 # 2011-09-27T03:19:50 # 2011-09-27T03:19:50 Thread 15 (Thread 15822): # 2011-09-27T03:19:50 #0 0x00000033b600aee9 in pthread_cond_wait@@GLIBC_2.3.2 () # 2011-09-27T03:19:50 from /lib64/libpthread.so.0 # 2011-09-27T03:19:50 #1 0x0000000000c05664 in safe_cond_wait (cond=0x2aaabc9280a0, # 2011-09-27T03:19:50 mp=0x2aaabc927ff0, file=0xe294d8 "os/os0sync.c", line=210) # 2011-09-27T03:19:50 at thr_mutex.c:496 # 2011-09-27T03:19:50 #2 0x0000000000b1a17e in os_cond_wait (cond=0x2aaabc9280a0, # 2011-09-27T03:19:50 mutex=0x2aaabc927ff0) at os/os0sync.c:210 # 2011-09-27T03:19:50 #3 0x0000000000b1a950 in os_event_wait_low (event=0x2aaabc927ff0, # 2011-09-27T03:19:50 reset_sig_count=0) at os/os0sync.c:636 # 2011-09-27T03:19:50 #4 0x0000000000b18d7a in os_aio_simulated_handle (global_segment=9, # 2011-09-27T03:19:50 message1=0x4bc440e0, message2=0x4bc440d8, type=0x4bc440d0, # 2011-09-27T03:19:50 space_id=0x4bc440c8) at os/os0file.c:4238 # 2011-09-27T03:19:50 #5 0x0000000000bb80f9 in fil_aio_wait (segment=9) at fil/fil0fil.c:5110 # 2011-09-27T03:19:50 #6 0x0000000000b55e57 in io_handler_thread (arg=0x1abd2e8) # 2011-09-27T03:19:50 at srv/srv0start.c:474 # 2011-09-27T03:19:50 #7 0x00000033b600673d in start_thread () from /lib64/libpthread.so.0 # 2011-09-27T03:19:50 #8 0x00000033b58d40cd in clone () from /lib64/libc.so.6 # 2011-09-27T03:19:50 # 2011-09-27T03:19:50 Thread 14 (Thread 15823): # 2011-09-27T03:19:50 #0 0x00000033b600b150 in pthread_cond_timedwait@@GLIBC_2.3.2 () # 2011-09-27T03:19:50 from /lib64/libpthread.so.0 # 2011-09-27T03:19:50 #1 0x0000000000c05923 in safe_cond_timedwait (cond=0x2aaabc5386f0, # 2011-09-27T03:19:50 mp=0x2aaabc538640, abstime=0x4c645080, file=0xe294d8 "os/os0sync.c", # 2011-09-27T03:19:50 line=174) at thr_mutex.c:550 # 2011-09-27T03:19:50 #2 0x0000000000b1a077 in os_cond_wait_timed (cond=0x2aaabc5386f0, # 2011-09-27T03:19:50 mutex=0x2aaabc538640, abstime=0x4c645080) at os/os0sync.c:174 # 2011-09-27T03:19:50 #3 0x0000000000b1ab01 in os_event_wait_time_low (event=0x2aaabc538640, # 2011-09-27T03:19:50 time_in_usec=1000000, reset_sig_count=1) at os/os0sync.c:741 # 2011-09-27T03:19:50 #4 0x0000000000b52cda in srv_lock_timeout_thread (arg=0x0) # 2011-09-27T03:19:50 at srv/srv0srv.c:2407 # 2011-09-27T03:19:50 #5 0x00000033b600673d in start_thread () from /lib64/libpthread.so.0 # 2011-09-27T03:19:50 #6 0x00000033b58d40cd in clone () from /lib64/libc.so.6 # 2011-09-27T03:19:50 # 2011-09-27T03:19:50 Thread 13 (Thread 15824): # 2011-09-27T03:19:50 #0 0x00000033b600b150 in pthread_cond_timedwait@@GLIBC_2.3.2 () # 2011-09-27T03:19:50 from /lib64/libpthread.so.0 # 2011-09-27T03:19:50 #1 0x0000000000c05923 in safe_cond_timedwait (cond=0x2aaabc5386f0, # 2011-09-27T03:19:50 mp=0x2aaabc538640, abstime=0x4d0460b0, file=0xe294d8 "os/os0sync.c", # 2011-09-27T03:19:50 line=174) at thr_mutex.c:550 # 2011-09-27T03:19:50 #2 0x0000000000b1a077 in os_cond_wait_timed (cond=0x2aaabc5386f0, # 2011-09-27T03:19:50 mutex=0x2aaabc538640, abstime=0x4d0460b0) at os/os0sync.c:174 # 2011-09-27T03:19:50 #3 0x0000000000b1ab01 in os_event_wait_time_low (event=0x2aaabc538640, # 2011-09-27T03:19:50 time_in_usec=1000000, reset_sig_count=1) at os/os0sync.c:741 # 2011-09-27T03:19:50 #4 0x0000000000b52fd7 in srv_error_monitor_thread (arg=0x0) # 2011-09-27T03:19:50 at srv/srv0srv.c:2572 # 2011-09-27T03:19:50 #5 0x00000033b600673d in start_thread () from /lib64/libpthread.so.0 # 2011-09-27T03:19:50 #6 0x00000033b58d40cd in clone () from /lib64/libc.so.6 # 2011-09-27T03:19:50 # 2011-09-27T03:19:50 Thread 12 (Thread 15825): # 2011-09-27T03:19:50 #0 0x00000033b600b150 in pthread_cond_timedwait@@GLIBC_2.3.2 () # 2011-09-27T03:19:50 from /lib64/libpthread.so.0 # 2011-09-27T03:19:50 #1 0x0000000000c05923 in safe_cond_timedwait (cond=0x2aaabc5386f0, # 2011-09-27T03:19:50 mp=0x2aaabc538640, abstime=0x4da47090, file=0xe294d8 "os/os0sync.c", # 2011-09-27T03:19:50 line=174) at thr_mutex.c:550 # 2011-09-27T03:19:50 #2 0x0000000000b1a077 in os_cond_wait_timed (cond=0x2aaabc5386f0, # 2011-09-27T03:19:50 mutex=0x2aaabc538640, abstime=0x4da47090) at os/os0sync.c:174 # 2011-09-27T03:19:50 #3 0x0000000000b1ab01 in os_event_wait_time_low (event=0x2aaabc538640, # 2011-09-27T03:19:50 time_in_usec=5000000, reset_sig_count=1) at os/os0sync.c:741 # 2011-09-27T03:19:50 #4 0x0000000000b52985 in srv_monitor_thread (arg=0x0) at srv/srv0srv.c:2265 # 2011-09-27T03:19:50 #5 0x00000033b600673d in start_thread () from /lib64/libpthread.so.0 # 2011-09-27T03:19:50 #6 0x00000033b58d40cd in clone () from /lib64/libc.so.6 # 2011-09-27T03:19:50 # 2011-09-27T03:19:50 Thread 11 (Thread 15826): # 2011-09-27T03:19:50 #0 0x00000033b600b150 in pthread_cond_timedwait@@GLIBC_2.3.2 () # 2011-09-27T03:19:50 from /lib64/libpthread.so.0 # 2011-09-27T03:19:50 #1 0x0000000000c05923 in safe_cond_timedwait (cond=0x2aaabc5386f0, # 2011-09-27T03:19:50 mp=0x2aaabc538640, abstime=0x4e4480b0, file=0xe294d8 "os/os0sync.c", # 2011-09-27T03:19:50 line=174) at thr_mutex.c:550 # 2011-09-27T03:19:50 #2 0x0000000000b1a077 in os_cond_wait_timed (cond=0x2aaabc5386f0, # 2011-09-27T03:19:50 mutex=0x2aaabc538640, abstime=0x4e4480b0) at os/os0sync.c:174 # 2011-09-27T03:19:50 #3 0x0000000000b1ab01 in os_event_wait_time_low (event=0x2aaabc538640, # 2011-09-27T03:19:50 time_in_usec=5000000, reset_sig_count=1) at os/os0sync.c:741 # 2011-09-27T03:19:50 #4 0x0000000000b5304a in srv_LRU_dump_restore_thread (arg=0x0) # 2011-09-27T03:19:50 at srv/srv0srv.c:2616 # 2011-09-27T03:19:50 #5 0x00000033b600673d in start_thread () from /lib64/libpthread.so.0 # 2011-09-27T03:19:50 #6 0x00000033b58d40cd in clone () from /lib64/libc.so.6 # 2011-09-27T03:19:50 # 2011-09-27T03:19:50 Thread 10 (Thread 15827): # 2011-09-27T03:19:50 #0 0x00000033b600aee9 in pthread_cond_wait@@GLIBC_2.3.2 () # 2011-09-27T03:19:50 from /lib64/libpthread.so.0 # 2011-09-27T03:19:50 #1 0x0000000000c05664 in safe_cond_wait (cond=0x5fe3620, mp=0x5fe3570, # 2011-09-27T03:19:50 file=0xe294d8 "os/os0sync.c", line=210) at thr_mutex.c:496 # 2011-09-27T03:19:50 #2 0x0000000000b1a17e in os_cond_wait (cond=0x5fe3620, mutex=0x5fe3570) # 2011-09-27T03:19:50 at os/os0sync.c:210 # 2011-09-27T03:19:50 #3 0x0000000000b1a950 in os_event_wait_low (event=0x5fe3570, # 2011-09-27T03:19:50 reset_sig_count=0) at os/os0sync.c:636 # 2011-09-27T03:19:50 #4 0x0000000000b552d4 in srv_master_thread (arg=0x0) at srv/srv0srv.c:3450 # 2011-09-27T03:19:50 #5 0x00000033b600673d in start_thread () from /lib64/libpthread.so.0 # 2011-09-27T03:19:50 #6 0x00000033b58d40cd in clone () from /lib64/libc.so.6 # 2011-09-27T03:19:50 # 2011-09-27T03:19:50 Thread 9 (Thread 15828): # 2011-09-27T03:19:50 #0 0x00000033b600b150 in pthread_cond_timedwait@@GLIBC_2.3.2 () # 2011-09-27T03:19:50 from /lib64/libpthread.so.0 # 2011-09-27T03:19:50 #1 0x0000000000c05923 in safe_cond_timedwait (cond=0x2aaabc5386f0, # 2011-09-27T03:19:50 mp=0x2aaabc538640, abstime=0x4f84a0a0, file=0xe294d8 "os/os0sync.c", # 2011-09-27T03:19:50 line=174) at thr_mutex.c:550 # 2011-09-27T03:19:50 #2 0x0000000000b1a077 in os_cond_wait_timed (cond=0x2aaabc5386f0, # 2011-09-27T03:19:50 mutex=0x2aaabc538640, abstime=0x4f84a0a0) at os/os0sync.c:174 # 2011-09-27T03:19:50 #3 0x0000000000b1ab01 in os_event_wait_time_low (event=0x2aaabc538640, # 2011-09-27T03:19:50 time_in_usec=10000000, reset_sig_count=1) at os/os0sync.c:741 # 2011-09-27T03:19:50 #4 0x0000000000b5540a in srv_purge_thread (arg=0x0) at srv/srv0srv.c:3512 # 2011-09-27T03:19:50 #5 0x00000033b600673d in start_thread () from /lib64/libpthread.so.0 # 2011-09-27T03:19:50 #6 0x00000033b58d40cd in clone () from /lib64/libc.so.6 # 2011-09-27T03:19:50 # 2011-09-27T03:19:50 Thread 8 (Thread 15829): # 2011-09-27T03:19:50 #0 0x00000033b600e838 in do_sigwait () from /lib64/libpthread.so.0 # 2011-09-27T03:19:50 #1 0x00000033b600e8dd in sigwait () from /lib64/libpthread.so.0 # 2011-09-27T03:19:50 #2 0x0000000000692713 in signal_hand (arg=0x0) at mysqld.cc:3005 # 2011-09-27T03:19:50 #3 0x00000033b600673d in start_thread () from /lib64/libpthread.so.0 # 2011-09-27T03:19:50 #4 0x00000033b58d40cd in clone () from /lib64/libc.so.6 # 2011-09-27T03:19:50 # 2011-09-27T03:19:50 Thread 7 (Thread 15830): # 2011-09-27T03:19:50 #0 0x00000033b600d91b in read () from /lib64/libpthread.so.0 # 2011-09-27T03:19:50 #1 0x0000000000bd0267 in vio_read (vio=0x2aaabd11abd8, # 2011-09-27T03:19:50 buf=0x2aaabd11ad08 "\a", size=4) at viosocket.c:44 # 2011-09-27T03:19:50 #2 0x000000000068057d in my_real_read (net=0x2aaabd0e38a8, complen=0x40c98ff8) # 2011-09-27T03:19:50 at net_serv.cc:825 # 2011-09-27T03:19:50 #3 0x0000000000680cfc in my_net_read (net=0x2aaabd0e38a8) at net_serv.cc:1019 # 2011-09-27T03:19:50 #4 0x00000000006b14e8 in do_command (thd=0x2aaabd0e3798) at sql_parse.cc:858 # 2011-09-27T03:19:50 #5 0x000000000069be9f in handle_one_connection (arg=0x2aaabd0e3798) # 2011-09-27T03:19:50 at sql_connect.cc:1187 # 2011-09-27T03:19:50 #6 0x00000033b600673d in start_thread () from /lib64/libpthread.so.0 # 2011-09-27T03:19:50 #7 0x00000033b58d40cd in clone () from /lib64/libc.so.6 # 2011-09-27T03:19:50 # 2011-09-27T03:19:50 Thread 6 (Thread 15844): # 2011-09-27T03:19:50 #0 0x0000000000925106 in _mi_rec_unpack (info=0x2aaacc026a58, # 2011-09-27T03:19:50 to=0x2aaacc004eba "@SE", , # 2011-09-27T03:19:50 from=0x2aaacc0041ac "@SE\316G\021", found_length=48) at mi_dynrec.c:1338 # 2011-09-27T03:19:50 #1 0x0000000000926627 in _mi_read_rnd_dynamic_record (info=0x2aaacc026a58, # 2011-09-27T03:19:50 buf=0x2aaacc004ea0 "", filepos=18446744073709551615, # 2011-09-27T03:19:50 skip_deleted_blocks=0 '\000') at mi_dynrec.c:1894 # 2011-09-27T03:19:50 #2 0x00000000009274a0 in mi_scan (info=0x2aaacc026a58, buf=0x2aaacc004ea0 "") # 2011-09-27T03:19:50 at mi_scan.c:44 # 2011-09-27T03:19:50 #3 0x0000000000910ff2 in ha_myisam::rnd_next (this=0x2aaacc003a90, # 2011-09-27T03:19:50 buf=0x2aaacc004ea0 "") at ha_myisam.cc:1857 # 2011-09-27T03:19:50 #4 0x0000000000585d2a in handler::ha_rnd_next (this=0x2aaacc003a90, # 2011-09-27T03:19:50 buf=0x2aaacc004ea0 "") at sql_class.h:3738 # 2011-09-27T03:19:50 #5 0x000000000081054b in rr_sequential (info=0x2aaabd24b6c0) at records.cc:391 # 2011-09-27T03:19:50 #6 0x0000000000737178 in sub_select (join=0x2aaabd264640, # 2011-09-27T03:19:50 join_tab=0x2aaabd24b610, end_of_records=false) at sql_select.cc:15120 # 2011-09-27T03:19:50 #7 0x00000000006f1e3d in JOIN_CACHE::generate_full_extensions ( # 2011-09-27T03:19:50 this=0x2aaabd24c890, # 2011-09-27T03:19:50 rec_ptr=0x2aaabd2adf94 "\377\376\001j\375\376\001m\375\376\001m\375\376\001o\375\376\001p\375\376\001q\375\376\001r\377\376\001u\375\376\001w\377\376\001x\375\376\001x\375\376\001y") at sql_join_cache.cc:2356 # 2011-09-27T03:19:50 #8 0x00000000006f2448 in JOIN_CACHE::join_matching_records ( # 2011-09-27T03:19:50 this=0x2aaabd24c890, skip_last=false) at sql_join_cache.cc:2248 # 2011-09-27T03:19:50 #9 0x00000000006f25cb in JOIN_CACHE::join_records (this=0x2aaabd24c890, # 2011-09-27T03:19:50 skip_last=false) at sql_join_cache.cc:2045 # 2011-09-27T03:19:50 #10 0x0000000000737362 in sub_select_cache (join=0x2aaabd264640, # 2011-09-27T03:19:50 join_tab=0x2aaabd24b2f0, end_of_records=true) at sql_select.cc:14881 # 2011-09-27T03:19:50 #11 0x0000000000736e2c in sub_select (join=0x2aaabd264640, # 2011-09-27T03:19:50 join_tab=0x2aaabd24afd0, end_of_records=true) at sql_select.cc:15043 # 2011-09-27T03:19:50 #12 0x000000000073830f in do_select (join=0x2aaabd264640, fields=0x68b8d70, # 2011-09-27T03:19:50 table=0x0, procedure=0x0) at sql_select.cc:14765 # 2011-09-27T03:19:50 #13 0x0000000000758386 in JOIN::exec (this=0x2aaabd264640) # 2011-09-27T03:19:50 at sql_select.cc:2679 # 2011-09-27T03:19:50 #14 0x00000000006341af in subselect_single_select_engine::exec ( # 2011-09-27T03:19:50 this=0x2aaabd09ce88) at item_subselect.cc:2968 # 2011-09-27T03:19:50 #15 0x00000000006390ca in Item_subselect::exec (this=0x2aaabd09ccd0) # 2011-09-27T03:19:50 at item_subselect.cc:572 # 2011-09-27T03:19:50 #16 0x0000000000639212 in Item_in_subselect::exec (this=0x2aaabd09ccd0) # 2011-09-27T03:19:50 at item_subselect.cc:725 # 2011-09-27T03:19:50 #17 0x000000000062c7b0 in Item_in_subselect::val_bool (this=0x2aaabd09ccd0) # 2011-09-27T03:19:50 at item_subselect.cc:1438 # 2011-09-27T03:19:50 #18 0x00000000005af8f0 in Item::val_bool_result (this=0x2aaabd09ccd0) # 2011-09-27T03:19:50 at item.h:842 # 2011-09-27T03:19:50 #19 0x00000000005e95b8 in Item_in_optimizer::val_int (this=0x2aaabd09d6d8) # 2011-09-27T03:19:50 at item_cmpfunc.cc:1702 # 2011-09-27T03:19:50 #20 0x00000000005e9704 in Item_func_nop_all::val_int (this=0x2aaabd09cec8) # 2011-09-27T03:19:50 at item_cmpfunc.cc:403 # 2011-09-27T03:19:50 #21 0x000000000072d80b in evaluate_join_record (join=0x2aaabd192900, # 2011-09-27T03:19:50 join_tab=0x2aaabd0bf228, error=0) at sql_select.cc:15195 # 2011-09-27T03:19:50 #22 0x0000000000737246 in sub_select (join=0x2aaabd192900, # 2011-09-27T03:19:50 join_tab=0x2aaabd0bf228, end_of_records=false) at sql_select.cc:15140 # 2011-09-27T03:19:50 #23 0x00000000007382eb in do_select (join=0x2aaabd192900, fields=0x0, # 2011-09-27T03:19:50 table=0x2aaabd24e460, procedure=0x0) at sql_select.cc:14763 # 2011-09-27T03:19:50 #24 0x0000000000756766 in JOIN::exec (this=0x2aaabd192900) # 2011-09-27T03:19:50 at sql_select.cc:2239 # 2011-09-27T03:19:50 #25 0x000000000075228e in mysql_select (thd=0x2aaabd11ffe8, # 2011-09-27T03:19:50 rref_pointer_array=0x2aaabd122bc0, tables=0x68b82f8, wild_num=0, # 2011-09-27T03:19:50 fields=..., conds=0x2aaabd09cec8, og_num=1, order=0x0, # 2011-09-27T03:19:50 group=0x2aaabd09d0a8, having=0x2aaabd09d280, proc_param=0x0, # 2011-09-27T03:19:50 select_options=2416232449, result=0x2aaabd09d420, unit=0x2aaabd122488, # 2011-09-27T03:19:50 select_lex=0x2aaabd122970) at sql_select.cc:2900 # 2011-09-27T03:19:50 #26 0x00000000007586b8 in handle_select (thd=0x2aaabd11ffe8, # 2011-09-27T03:19:50 lex=0x2aaabd1223e8, result=0x2aaabd09d420, setup_tables_done_option=0) # 2011-09-27T03:19:50 at sql_select.cc:283 # 2011-09-27T03:19:50 #27 0x00000000006a7a62 in mysql_execute_command (thd=0x2aaabd11ffe8) # 2011-09-27T03:19:50 at sql_parse.cc:2737 # 2011-09-27T03:19:50 #28 0x00000000006af4c3 in mysql_parse (thd=0x2aaabd11ffe8, # 2011-09-27T03:19:50 rawbuf=0x68b7120 "CREATE TABLE transforms.insert_select_15843 SELECT DISTINCT CONCAT ( alias2 . `col_varchar_key` , alias1 . `col_varchar_key` ) AS field1 FROM ( CC AS alias1 , C AS alias2 ) WHERE alias1 . `col_varchar_key` < ANY ( SELECT SQ1_alias1 . `col_varchar_key` AS SQ1_field1 FROM ( CC AS SQ1_alias1 INNER JOIN ( D AS SQ1_alias2 STRAIGHT_JOIN CC AS SQ1_alias3 ON (SQ1_alias3 . `col_varchar_nokey` = SQ1_alias2 . `col_varchar_key` ) ) ON (SQ1_alias3 . `col_int_nokey` = SQ1_alias2 . `pk` ) ) WHERE SQ1_alias3 . `col_varchar_key` > alias1 . `col_varchar_nokey` ) GROUP BY field1 HAVING field1 > 'x' /* 1 */", # 2011-09-27T03:19:50 length=605, found_semicolon=0x40d53f08) at sql_parse.cc:6102 # 2011-09-27T03:19:50 #29 0x00000000006b0051 in dispatch_command (command=COM_QUERY, # 2011-09-27T03:19:50 thd=0x2aaabd11ffe8, # 2011-09-27T03:19:50 packet=0x2aaabd123f29 "CREATE TABLE transforms.insert_select_15843 SELECT DISTINCT CONCAT ( alias2 . `col_varchar_key` , alias1 . `col_varchar_key` ) AS field1 FROM ( CC AS alias1 , C AS alias2 ) WHERE alias1 . `col_varchar_key` < ANY ( SELECT SQ1_alias1 . `col_varchar_key` AS SQ1_field1 FROM ( CC AS SQ1_alias1 INNER JOIN ( D AS SQ1_alias2 STRAIGHT_JOIN CC AS SQ1_alias3 ON (SQ1_alias3 . `col_varchar_nokey` = SQ1_alias2 . `col_varchar_key` ) ) ON (SQ1_alias3 . `col_int_nokey` = SQ1_alias2 . `pk` ) ) WHERE SQ1_alias3 . `col_varchar_key` > alias1 . `col_varchar_nokey` ) GROUP BY field1 HAVING field1 > 'x' /* 1 */", # 2011-09-27T03:19:50 packet_length=605) at sql_parse.cc:1221 # 2011-09-27T03:19:50 #30 0x00000000006b168f in do_command (thd=0x2aaabd11ffe8) at sql_parse.cc:916 # 2011-09-27T03:19:50 #31 0x000000000069be9f in handle_one_connection (arg=0x2aaabd11ffe8) # 2011-09-27T03:19:50 at sql_connect.cc:1187 # 2011-09-27T03:19:50 #32 0x00000033b600673d in start_thread () from /lib64/libpthread.so.0 # 2011-09-27T03:19:50 #33 0x00000033b58d40cd in clone () from /lib64/libc.so.6 # 2011-09-27T03:19:50 # 2011-09-27T03:19:50 Thread 5 (Thread 15846): # 2011-09-27T03:19:50 #0 hp_rec_hashnr (keydef=0x129e1e0, # 2011-09-27T03:19:50 rec=0x2aaabd165188 ) at hp_hash.c:368 # 2011-09-27T03:19:50 #1 0x0000000000991106 in hp_delete_key (info=0x2aaabd1a58f8, # 2011-09-27T03:19:50 keyinfo=0x2aaabd10ed80, record=0x2aaabd165188 , # 2011-09-27T03:19:50 recpos=0x2aaabd253658 "", flag=0) at hp_delete.c:120 # 2011-09-27T03:19:50 #2 0x000000000098f606 in heap_write (info=0x2aaabd1a58f8, # 2011-09-27T03:19:50 record=0x2aaabd165188 ) at hp_write.c:86 # 2011-09-27T03:19:50 #3 0x000000000098e73b in ha_heap::write_row (this=0x2aaabd1a46e0, # 2011-09-27T03:19:50 buf=0x2aaabd165188 ) at ha_heap.cc:236 # 2011-09-27T03:19:50 #4 0x00000000005c58e0 in handler::ha_write_tmp_row (this=0x2aaabd1a46e0, # 2011-09-27T03:19:50 buf=0x2aaabd165188 ) at sql_class.h:3776 # 2011-09-27T03:19:50 #5 0x000000000072fda4 in end_write (join=0x2aaabd198b20, # 2011-09-27T03:19:50 join_tab=0x2aaabd0d6800, end_of_records=false) at sql_select.cc:16345 # 2011-09-27T03:19:50 #6 0x00000000006f1e3d in JOIN_CACHE::generate_full_extensions ( # 2011-09-27T03:19:50 this=0x2aaabd0d6c40, # 2011-09-27T03:19:50 rec_ptr=0x2aaabd2ce004 "\375\376\001s\375\376\001v\375\376\001v\375\376\001v\375\376\001x\375\376\001y\375\376\001z\375\376\001i\375\376\001j\375\376\001p\375\376\001q\375\376\001r\375\376\001r\375\376\001s\375\376\001v\375\376\001v\375\376\001v\375\376\001x\375\376\001y\375\376\001z\375\376\001i\375\376\001j\375\376\001p\375\376\001q\375\376\001r\375\376\001r\375\376\001s\375\376\001v\375\376\001v\375\376\001v\375\376\001x\375\376\001y\375\376\001z\375\376\001i\375\376\001j\375\376\001p\375\376\001q\375\376\001r\375\376\001r\375\376\001s\375\376\001v\375\376\001v\375\376\001v\375\376\001x\375\376\001y\375\376\001z\375\376\001i\375\376\001j\375\376\001p\375\376\001q\375\376\001r\375\376\001r\375\376\001s\375\376\001v\375\376\001v\375\376\001v\375\376\001x\375\376\001y\375\376\001z\375\376\001i\375\376\001j\375\376\001p\375\376\001q\375\376\001r\375\376\001r\375\376\001s\375\376\001v\375\376\001v\375\376\001v\375\376\001x\375\376\001y\375\376\001z\375\376\001i\375\376\001j\375\376\001p\375\376\001q\375\376\001r\375\376\001r\375\376\001s\375\376\001v\375\376\001v\375\376\001v\375\376\001x\375\376\001y\375\376\001z\375\376\001i\375\376\001j\375\376\001p\375\376\001q\375\376\001r\375\376\001r\375\376\001s\375\376\001v\375\376\001v\375\376\001v\375\376\001x\375\376\001y\375\376\001z\375\376\001i\375\376\001j\375\376\001p\375\376\001q\375\376\001r\375\376\001r\375\376\001s\375\376\001v\375\376\001v\375\376\001v\375\376\001x\375\376\001y\375\376\001z\375\376\001i\375\376\001j\375\376\001p\375\376\001q\375\376\001r\375\376\001r\375\376\001s\375\376\001v\375\376\001v\375\376\001v\375\376\001x\375\376\001y\375\376\001z\375\376\001i\375\376\001j\375\376\001p\375\376\001q\375\376\001r\375\376\001r\375\376\001s\375\376\001v\375\376\001v\375\376\001v\375\376\001x\375\376\001y\375\376\001z\375\376\001i\375\376\001j\375\376\001p\375\376\001q\375\376\001r\375\376\001r\375\376\001s\375\376\001v\375\376\001v\375\376\001v\375\376\001x\375\376\001y\375\376\001z\375\376\001i\375\376\001j\375\376\001p\375\376\001q\375\376\001r\375\376\001r\375\376\001s\375\376\001v\375\376\001v\375\376\001v\375\376\001x\375\376\001y\375\376\001z\375\376\001i\375\376\001j\375\376\001p\375\376\001q\375\376\001r\375\376\001r\375\376\001s\375\376\001v\375\376\001v\375\376\001v\375\376\001x\375\376\001y\375\376\001z\375\376\001i\375\376\001j\375\376\001p\375\376\001q\375\376\001r\375\376\001r\375\376\001s\375\376\001v\375\376\001v\375\376\001v\375\376\001x\375\376\001y\375\376\001z\375\376\001i\375\376\001j\375\376\001p\375\376\001q\375\376\001r\375\376\001r\375\376\001s\375\376\001v\375\376\001v\375\376\001v\375\376\001x\375\376\001y\375\376\001z\375\376\001i\375\376\001j\375\376\001p\375\376\001q\375\376\001r\375\376\001r\375\376\001s\375\376\001v\375\376\001v\375\376\001v\375\376\001x\375\376\001y\375\376\001z\375\376\001i\375\376\001j\375\376\001p\375\376\001q\375\376\001r\375\376\001r\375\376\001s\375\376\001v\375\376\001v\375\376\001v\375\376\001x\375\376\001y\375\376\001z\375\376\001i\375\376\001j\375\376\001p\375\376\001q\375\376\001r\375\376\001r\375\376\001s\375\376\001v\375\376\001v\375\376\001v\375\376\001x\375\376\001y\375\376\001z\371Ep5Y<\022") # 2011-09-27T03:19:50 at sql_join_cache.cc:2356 # 2011-09-27T03:19:50 #7 0x00000000006f2448 in JOIN_CACHE::join_matching_records ( # 2011-09-27T03:19:50 this=0x2aaabd0d6c40, skip_last=false) at sql_join_cache.cc:2248 # 2011-09-27T03:19:50 #8 0x00000000006f25cb in JOIN_CACHE::join_records (this=0x2aaabd0d6c40, # 2011-09-27T03:19:50 skip_last=false) at sql_join_cache.cc:2045 # 2011-09-27T03:19:50 #9 0x0000000000737362 in sub_select_cache (join=0x2aaabd198b20, # 2011-09-27T03:19:50 join_tab=0x2aaabd0d64e0, end_of_records=true) at sql_select.cc:14881 # 2011-09-27T03:19:50 #10 0x0000000000736e2c in sub_select (join=0x2aaabd198b20, # 2011-09-27T03:19:50 join_tab=0x2aaabd0d61c0, end_of_records=true) at sql_select.cc:15043 # 2011-09-27T03:19:50 #11 0x0000000000737385 in sub_select_cache (join=0x2aaabd198b20, # 2011-09-27T03:19:50 join_tab=0x2aaabd0d61c0, end_of_records=true) at sql_select.cc:14883 # 2011-09-27T03:19:50 #12 0x0000000000736e2c in sub_select (join=0x2aaabd198b20, # 2011-09-27T03:19:50 join_tab=0x2aaabd0d5ea0, end_of_records=true) at sql_select.cc:15043 # 2011-09-27T03:19:50 #13 0x000000000073830f in do_select (join=0x2aaabd198b20, fields=0x0, # 2011-09-27T03:19:50 table=0x2aaabd15fc80, procedure=0x0) at sql_select.cc:14765 # 2011-09-27T03:19:50 #14 0x0000000000756766 in JOIN::exec (this=0x2aaabd198b20) # 2011-09-27T03:19:50 at sql_select.cc:2239 # 2011-09-27T03:19:50 #15 0x000000000075228e in mysql_select (thd=0x2aaabd128098, # 2011-09-27T03:19:50 rref_pointer_array=0x2aaabd12ac70, tables=0x698e040, wild_num=0, # 2011-09-27T03:19:50 fields=..., conds=0x2aaabd21aab8, og_num=1, order=0x0, group=0x698f360, # 2011-09-27T03:19:50 having=0x0, proc_param=0x0, select_options=2416232448, # 2011-09-27T03:19:50 result=0x2aaabd21ad28, unit=0x2aaabd12a538, select_lex=0x2aaabd12aa20) # 2011-09-27T03:19:50 at sql_select.cc:2900 # 2011-09-27T03:19:50 #16 0x00000000007586b8 in handle_select (thd=0x2aaabd128098, # 2011-09-27T03:19:50 lex=0x2aaabd12a498, result=0x2aaabd21ad28, setup_tables_done_option=0) # 2011-09-27T03:19:50 at sql_select.cc:283 # 2011-09-27T03:19:50 #17 0x00000000006a7a62 in mysql_execute_command (thd=0x2aaabd128098) # 2011-09-27T03:19:50 at sql_parse.cc:2737 # 2011-09-27T03:19:50 #18 0x00000000006af4c3 in mysql_parse (thd=0x2aaabd128098, # 2011-09-27T03:19:50 rawbuf=0x698d3c0 "CREATE TABLE transforms.insert_select_15845 SELECT alias1 . `col_varchar_key` AS field1 FROM ( D AS alias1 , CC AS alias2 , C AS alias3 ) WHERE alias3 . `col_varchar_key` >= ( SELECT 'i' FROM DUAL ) GROUP BY field1 /* 2 */", length=231, found_semicolon=0x40ec1f08) at sql_parse.cc:6102 # 2011-09-27T03:19:50 #19 0x00000000006b0051 in dispatch_command (command=COM_QUERY, # 2011-09-27T03:19:50 thd=0x2aaabd128098, # 2011-09-27T03:19:50 packet=0x2aaabd12bc19 "CREATE TABLE transforms.insert_select_15845 SELECT alias1 . `col_varchar_key` AS field1 FROM ( D AS alias1 , CC AS alias2 , C AS alias3 ) WHERE alias3 . `col_varchar_key` >= ( SELECT 'i' FROM DUAL ) GROUP BY field1 /* 2 */", packet_length=231) at sql_parse.cc:1221 # 2011-09-27T03:19:50 #20 0x00000000006b168f in do_command (thd=0x2aaabd128098) at sql_parse.cc:916 # 2011-09-27T03:19:50 #21 0x000000000069be9f in handle_one_connection (arg=0x2aaabd128098) # 2011-09-27T03:19:50 at sql_connect.cc:1187 # 2011-09-27T03:19:50 #22 0x00000033b600673d in start_thread () from /lib64/libpthread.so.0 # 2011-09-27T03:19:50 #23 0x00000033b58d40cd in clone () from /lib64/libc.so.6 # 2011-09-27T03:19:50 # 2011-09-27T03:19:50 Thread 4 (Thread 15848): # 2011-09-27T03:19:50 #0 0x00000033b600d91b in read () from /lib64/libpthread.so.0 # 2011-09-27T03:19:50 #1 0x0000000000bd0267 in vio_read (vio=0x2aaabd133918, # 2011-09-27T03:19:50 buf=0x2aaabd133a48 "\001", size=4) at viosocket.c:44 # 2011-09-27T03:19:50 #2 0x000000000068057d in my_real_read (net=0x2aaabd12fe98, complen=0x4f891ff8) # 2011-09-27T03:19:50 at net_serv.cc:825 # 2011-09-27T03:19:50 #3 0x0000000000680cfc in my_net_read (net=0x2aaabd12fe98) at net_serv.cc:1019 # 2011-09-27T03:19:50 #4 0x00000000006b14e8 in do_command (thd=0x2aaabd12fd88) at sql_parse.cc:858 # 2011-09-27T03:19:50 #5 0x000000000069be9f in handle_one_connection (arg=0x2aaabd12fd88) # 2011-09-27T03:19:50 at sql_connect.cc:1187 # 2011-09-27T03:19:50 #6 0x00000033b600673d in start_thread () from /lib64/libpthread.so.0 # 2011-09-27T03:19:50 #7 0x00000033b58d40cd in clone () from /lib64/libc.so.6 # 2011-09-27T03:19:50 # 2011-09-27T03:19:50 Thread 3 (Thread 15850): # 2011-09-27T03:19:50 #0 0x00000000006c5439 in MYSQLparse (yythd=0x2aaabd137bb8) # 2011-09-27T03:19:50 at sql_yacc.cc:16735 # 2011-09-27T03:19:50 #1 0x000000000069d9a2 in parse_sql (thd=0x2aaabd137bb8, # 2011-09-27T03:19:50 parser_state=0x4f8d9820, creation_ctx=0x0) at sql_parse.cc:8053 # 2011-09-27T03:19:50 #2 0x00000000006af33b in mysql_parse (thd=0x2aaabd137bb8, # 2011-09-27T03:19:50 rawbuf=0x692b880 "SELECT ( SELECT 2 FROM DUAL ) AS field1 , MIN( alias2 . `col_varchar_nokey` ) AS field2 , COUNT( alias2 . `col_int_nokey` ) AS field3 , alias2 . `col_int_key` AS field4 , ( SELECT SUM( SQ2_alias1 . `col_int_key` ) AS SQ2_field1 FROM ( C AS SQ2_alias1 STRAIGHT_JOIN ( B AS SQ2_alias2 RIGHT OUTER JOIN CC AS SQ2_alias3 ON (SQ2_alias3 . `col_varchar_key` = SQ2_alias2 . `col_varchar_key` ) ) ON (SQ2_alias3 . `pk` = SQ2_alias2 . `pk` ) ) WHERE SQ2_alias3 . `col_int_key` >= alias1 . `col_int_key` ) AS field5 FROM ( C AS alias1 , C AS alias2 , B AS alias3 ) WHERE ( alias1 . `col_varchar_nokey` > ( SELECT DISTINCT COUNT( SQ3_alias1 . `col_varchar_nokey` ) AS SQ3_field1 FROM ( C AS SQ3_alias1 STRAIGHT_JOIN ( CC AS SQ3_alias2 STRAIGHT_JOIN CC AS SQ3_alias3 ON (SQ3_alias3 . `col_varchar_key` = SQ3_alias2 . `col_varchar_key` OR SQ3_alias2 . `col_varchar_nokey` IN ( SELECT 7 UNION SELECT 7 ) ) ) ON (SQ3_alias3 . `col_varchar_nokey` = SQ3_alias2 . `col_varchar_key` ) ) ) ) AND ( alias1 . `col_varchar_key` IN ('USA' , 'v' , 'USA') OR alias1 . `col_int_key` BETWEEN 40 AND ( 40 + 81 ) ) GROUP BY field1, field4, field5 HAVING field3 > 'ip' ORDER BY alias1 . `col_time_key` DESC , field1, field2, field3, field4, field5 /* 4 */ /* TRANSFORM_OUTCOME_UNORDERED_MATCH */", length=1288, found_semicolon=0x4f8d9f08) # 2011-09-27T03:19:50 at sql_parse.cc:6062 # 2011-09-27T03:19:50 #3 0x00000000006b0051 in dispatch_command (command=COM_QUERY, # 2011-09-27T03:19:50 thd=0x2aaabd137bb8, # 2011-09-27T03:19:50 packet=0x2aaabd13b879 " SELECT ( SELECT 2 FROM DUAL ) AS field1 , MIN( alias2 . `col_varchar_nokey` ) AS field2 , COUNT( alias2 . `col_int_nokey` ) AS field3 , alias2 . `col_int_key` AS field4 , ( SELECT SUM( SQ2_alias1 . `col_int_key` ) AS SQ2_field1 FROM ( C AS SQ2_alias1 STRAIGHT_JOIN ( B AS SQ2_alias2 RIGHT OUTER JOIN CC AS SQ2_alias3 ON (SQ2_alias3 . `col_varchar_key` = SQ2_alias2 . `col_varchar_key` ) ) ON (SQ2_alias3 . `pk` = SQ2_alias2 . `pk` ) ) WHERE SQ2_alias3 . `col_int_key` >= alias1 . `col_int_key` ) AS field5 FROM ( C AS alias1 , C AS alias2 , B AS alias3 ) WHERE ( alias1 . `col_varchar_nokey` > ( SELECT DISTINCT COUNT( SQ3_alias1 . `col_varchar_nokey` ) AS SQ3_field1 FROM ( C AS SQ3_alias1 STRAIGHT_JOIN ( CC AS SQ3_alias2 STRAIGHT_JOIN CC AS SQ3_alias3 ON (SQ3_alias3 . `col_varchar_key` = SQ3_alias2 . `col_varchar_key` OR SQ3_alias2 . `col_varchar_nokey` IN ( SELECT 7 UNION SELECT 7 ) ) ) ON (SQ3_alias3 . `col_varchar_nokey` = SQ3_alias2 . `col_varchar_key` ) ) ) ) AND ( alias1 . `col_varchar_key` IN ('USA' , 'v' , 'USA') OR alias1 . `col_int_key` BETWEEN 40 AND ( 40 + 81 ) ) GROUP BY field1, field4, field5 HAVING field3 > 'ip' ORDER BY alias1 . `col_time_key` DESC , field1, field2, field3, field4, field5 /* 4 */ /* TRANSFORM_OUTCOME_UNORDERED_MATCH */ ;", packet_length=1292) # 2011-09-27T03:19:50 at sql_parse.cc:1221 # 2011-09-27T03:19:50 #4 0x00000000006b168f in do_command (thd=0x2aaabd137bb8) at sql_parse.cc:916 # 2011-09-27T03:19:50 #5 0x000000000069be9f in handle_one_connection (arg=0x2aaabd137bb8) # 2011-09-27T03:19:50 at sql_connect.cc:1187 # 2011-09-27T03:19:50 #6 0x00000033b600673d in start_thread () from /lib64/libpthread.so.0 # 2011-09-27T03:19:50 #7 0x00000033b58d40cd in clone () from /lib64/libc.so.6 # 2011-09-27T03:19:50 # 2011-09-27T03:19:50 Thread 2 (Thread 15856): # 2011-09-27T03:19:50 #0 0x00000033b600d91b in read () from /lib64/libpthread.so.0 # 2011-09-27T03:19:50 #1 0x0000000000bd0267 in vio_read (vio=0x2aaabd14c528, # 2011-09-27T03:19:50 buf=0x2aaabd1554a8 "\001", size=4) at viosocket.c:44 # 2011-09-27T03:19:50 #2 0x000000000068057d in my_real_read (net=0x2aaabd150218, complen=0x4f969ff8) # 2011-09-27T03:19:50 at net_serv.cc:825 # 2011-09-27T03:19:50 #3 0x0000000000680cfc in my_net_read (net=0x2aaabd150218) at net_serv.cc:1019 # 2011-09-27T03:19:50 #4 0x00000000006b14e8 in do_command (thd=0x2aaabd150108) at sql_parse.cc:858 # 2011-09-27T03:19:50 #5 0x000000000069be9f in handle_one_connection (arg=0x2aaabd150108) # 2011-09-27T03:19:50 at sql_connect.cc:1187 # 2011-09-27T03:19:50 #6 0x00000033b600673d in start_thread () from /lib64/libpthread.so.0 # 2011-09-27T03:19:50 #7 0x00000033b58d40cd in clone () from /lib64/libc.so.6 # 2011-09-27T03:19:50 # 2011-09-27T03:19:50 Thread 1 (Thread 15853): # 2011-09-27T03:19:50 #0 0x00000033b600bd02 in pthread_kill () from /lib64/libpthread.so.0 # 2011-09-27T03:19:50 #1 0x0000000000bff81e in my_write_core (sig=11) at stacktrace.c:426 # 2011-09-27T03:19:50 #2 0x0000000000692fc7 in handle_segfault (sig=11) at mysqld.cc:2805 # 2011-09-27T03:19:50 #3 # 2011-09-27T03:19:50 #4 0x00000000006f7795 in mark_as_null_row (table=0x2aaacc181430) # 2011-09-27T03:19:50 at mysql_priv.h:2628 # 2011-09-27T03:19:50 #5 0x000000000075577d in return_zero_rows (join=0x2aaacc179220, # 2011-09-27T03:19:50 result=0x2aaacc1733a8, tables=..., fields=..., send_row=true, # 2011-09-27T03:19:50 select_options=2147796992, # 2011-09-27T03:19:50 info=0xd9a960 "Impossible WHERE noticed after reading const tables", # 2011-09-27T03:19:50 having=0x0) at sql_select.cc:10225 # 2011-09-27T03:19:50 #6 0x00000000007560e0 in JOIN::exec (this=0x2aaacc179220) # 2011-09-27T03:19:50 at sql_select.cc:2131 # 2011-09-27T03:19:50 #7 0x000000000075228e in mysql_select (thd=0x2aaabd1401d8, # 2011-09-27T03:19:50 rref_pointer_array=0x2aaabd142db0, tables=0x69771a0, wild_num=0, # 2011-09-27T03:19:50 fields=..., conds=0x2aaacc1731d0, og_num=0, order=0x0, group=0x0, # 2011-09-27T03:19:50 having=0x0, proc_param=0x0, select_options=2147796992, # 2011-09-27T03:19:50 result=0x2aaacc1733a8, unit=0x2aaabd142678, select_lex=0x2aaabd142b60) # 2011-09-27T03:19:50 at sql_select.cc:2900 # 2011-09-27T03:19:50 #8 0x00000000007586b8 in handle_select (thd=0x2aaabd1401d8, # 2011-09-27T03:19:50 lex=0x2aaabd1425d8, result=0x2aaacc1733a8, setup_tables_done_option=0) # 2011-09-27T03:19:50 at sql_select.cc:283 # 2011-09-27T03:19:50 #9 0x00000000006a464a in execute_sqlcom_select (thd=0x2aaabd1401d8, # 2011-09-27T03:19:50 all_tables=0x69771a0) at sql_parse.cc:5102 # 2011-09-27T03:19:50 #10 0x00000000006a672a in mysql_execute_command (thd=0x2aaabd1401d8) # 2011-09-27T03:19:50 at sql_parse.cc:2247 # 2011-09-27T03:19:50 #11 0x00000000006af4c3 in mysql_parse (thd=0x2aaabd1401d8, # 2011-09-27T03:19:50 rawbuf=0x6976430 "SELECT SUM( alias1 . `col_int_key` ) AS field1 FROM ( BB AS alias1 INNER JOIN ( ( BB AS alias2 STRAIGHT_JOIN C AS alias3 ON (alias3 . `pk` = alias2 . `pk` ) ) ) ON (alias3 . `pk` = alias2 . `col_int_key` ) ) WHERE ( ( 7, 8 ) IN ( SELECT SQ1_alias1 . `pk` AS SQ1_field1 , SQ1_alias1 . `pk` AS SQ1_field2 FROM ( C AS SQ1_alias1 LEFT OUTER JOIN B AS SQ1_alias2 ON (SQ1_alias2 . `col_varchar_key` = SQ1_alias1 . `col_varchar_nokey` ) ) HAVING SQ1_alias1 . `pk` = 'v' ) ) AND ( alias1 . `pk` > 71 AND alias1 . `pk` < ( 71 + 59 ) OR alias1 . `pk` NOT IN (120) ) AND ( alias3 . `col_varchar_key` IN ( SELECT 'j' UNION SELECT 'p' ) AND alias1 . `col_int_key` IS NULL ) /* 5 */", # 2011-09-27T03:19:50 length=688, found_semicolon=0x4f921f08) at sql_parse.cc:6102 # 2011-09-27T03:19:50 #12 0x00000000006b0051 in dispatch_command (command=COM_QUERY, # 2011-09-27T03:19:50 thd=0x2aaabd1401d8, # 2011-09-27T03:19:50 packet=0x2aaabd147819 " SELECT SUM( alias1 . `col_int_key` ) AS field1 FROM ( BB AS alias1 INNER JOIN ( ( BB AS alias2 STRAIGHT_JOIN C AS alias3 ON (alias3 . `pk` = alias2 . `pk` ) ) ) ON (alias3 . `pk` = alias2 . `col_int_key` ) ) WHERE ( ( 7, 8 ) IN ( SELECT SQ1_alias1 . `pk` AS SQ1_field1 , SQ1_alias1 . `pk` AS SQ1_field2 FROM ( C AS SQ1_alias1 LEFT OUTER JOIN B AS SQ1_alias2 ON (SQ1_alias2 . `col_varchar_key` = SQ1_alias1 . `col_varchar_nokey` ) ) HAVING SQ1_alias1 . `pk` = 'v' ) ) AND ( alias1 . `pk` > 71 AND alias1 . `pk` < ( 71 + 59 ) OR alias1 . `pk` NOT IN (120) ) AND ( alias3 . `col_varchar_key` IN ( SELECT 'j' UNION SELECT 'p' ) AND alias1 . `col_int_key` IS NULL ) /* 5 */", packet_length=690) at sql_parse.cc:1221 # 2011-09-27T03:19:50 #13 0x00000000006b168f in do_command (thd=0x2aaabd1401d8) at sql_parse.cc:916 # 2011-09-27T03:19:50 #14 0x000000000069be9f in handle_one_connection (arg=0x2aaabd1401d8) # 2011-09-27T03:19:50 at sql_connect.cc:1187 # 2011-09-27T03:19:50 #15 0x00000033b600673d in start_thread () from /lib64/libpthread.so.0 # 2011-09-27T03:19:50 #16 0x00000033b58d40cd in clone () from /lib64/libc.so.6 # 2011-09-27T03:19:50 The last 100 lines from /tmp/release-workdir-semijoin-materialization-sept26-actual2/current1_1/master-data//../log/master.err : CURRENT_TEST: main.1st 110927 03:19:42 [Note] PrimeBase XT (PBXT) Engine 1.0.11-7 Pre-GA loaded... 110927 03:19:42 [Note] Paul McCullagh, PrimeBase Technologies GmbH, http://www.primebase.org InnoDB: The InnoDB memory heap is disabled InnoDB: Mutexes and rw_locks use GCC atomic builtins InnoDB: Compressed tables use zlib 1.2.3 110927 3:19:42 InnoDB: Initializing buffer pool, size = 128.0M 110927 3:19:42 InnoDB: Completed initialization of buffer pool InnoDB: The first specified data file ./ibdata1 did not exist: InnoDB: a new database to be created! 110927 3:19:42 InnoDB: Setting file ./ibdata1 size to 10 MB InnoDB: Database physically writes the file full: wait... 110927 3:19:42 InnoDB: Log file ./ib_logfile0 did not exist: new to be created InnoDB: Setting log file ./ib_logfile0 size to 5 MB InnoDB: Database physically writes the file full: wait... 110927 3:19:42 InnoDB: Log file ./ib_logfile1 did not exist: new to be created InnoDB: Setting log file ./ib_logfile1 size to 5 MB InnoDB: Database physically writes the file full: wait... InnoDB: Doublewrite buffer not found: creating new InnoDB: Doublewrite buffer created InnoDB: Creating foreign key constraint system tables InnoDB: Foreign key constraint system tables created 110927 3:19:42 Percona XtraDB (http://www.percona.com) 1.0.15-12.7 started; log sequence number 0 110927 3:19:42 [Warning] /home/philips/bzr/maria-5.3/sql/mysqld: unknown option '--loose-skip-ndbcluster' 110927 3:19:42 [Warning] /home/philips/bzr/maria-5.3/sql/mysqld: unknown variable 'loose-falcon-debug-mask=2' 110927 3:19:42 [Note] Event Scheduler: Loaded 0 events 110927 3:19:42 [Note] /home/philips/bzr/maria-5.3/sql/mysqld: ready for connections. Version: '5.3.2-MariaDB-beta-debug-log' socket: '/tmp/JOPNDVYsIn/master.sock' port: 13000 Source distribution 110927 3:19:48 [ERROR] mysqld got signal 11 ; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail. key_buffer_size=0 read_buffer_size=131072 max_used_connections=9 max_threads=153 threads_connected=7 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 60795 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x2aaabd1401d8 Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... stack_bottom = 0x4f9220f8 thread_stack 0x48000 /home/philips/bzr/maria-5.3/sql/mysqld(my_print_stacktrace+0x32) [0xbff772] /home/philips/bzr/maria-5.3/sql/mysqld(handle_segfault+0x376) [0x692d46] /lib64/libpthread.so.0 [0x33b600eb10] /home/philips/bzr/maria-5.3/sql/mysqld(mark_as_null_row(st_table*)+0x37) [0x6f7795] /home/philips/bzr/maria-5.3/sql/mysqld [0x75577d] /home/philips/bzr/maria-5.3/sql/mysqld(JOIN::exec()+0x788) [0x7560e0] /home/philips/bzr/maria-5.3/sql/mysqld(mysql_select(THD*, Item***, TABLE_LIST*, unsigned int, List&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*)+0x3da) [0x75228e] /home/philips/bzr/maria-5.3/sql/mysqld(handle_select(THD*, st_lex*, select_result*, unsigned long)+0x1d6) [0x7586b8] /home/philips/bzr/maria-5.3/sql/mysqld [0x6a464a] /home/philips/bzr/maria-5.3/sql/mysqld(mysql_execute_command(THD*)+0x79a) [0x6a672a] /home/philips/bzr/maria-5.3/sql/mysqld(mysql_parse(THD*, char*, unsigned int, char const**)+0x2c5) [0x6af4c3] /home/philips/bzr/maria-5.3/sql/mysqld(dispatch_command(enum_server_command, THD*, char*, unsigned int)+0x9cb) [0x6b0051] /home/philips/bzr/maria-5.3/sql/mysqld(do_command(THD*)+0x259) [0x6b168f] /home/philips/bzr/maria-5.3/sql/mysqld(handle_one_connection+0x18f) [0x69be9f] /lib64/libpthread.so.0 [0x33b600673d] /lib64/libc.so.6(clone+0x6d) [0x33b58d40cd] Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (0x6976430): SELECT SUM( alias1 . `col_int_key` ) AS field1 FROM ( BB AS alias1 INNER JOIN ( ( BB AS alias2 STRAIGHT_JOIN C AS alias3 ON (alias3 . `pk` = alias2 . `pk` ) ) ) ON (alias3 . `pk` = alias2 . `col_int_key` ) ) WHERE ( ( 7, 8 ) IN ( SELECT SQ1_alias1 . `pk` AS SQ1_field1 , SQ1_alias1 . `pk` AS SQ1_field2 FROM ( C AS SQ1_alias1 LEFT OUTER JOIN B AS SQ1_alias2 ON (SQ1_alias2 . `col_varchar_key` = SQ1_alias1 . `col_varchar_nokey` ) ) HAVING SQ1_alias1 . `pk` = 'v' ) ) AND ( alias1 . `pk` > 71 AND alias1 . `pk` < ( 71 + 59 ) OR alias1 . `pk` NOT IN (120) ) AND ( alias3 . `col_varchar_key` IN ( SELECT 'j' UNION SELECT 'p' ) AND alias1 . `col_int_key` IS NULL ) /* 5 */ Connection ID (thread ID): 13 Status: NOT_KILLED Optimizer switch: semijoin=ON,materialization=ON,firstmatch=OFF,loosescan=OFF The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains information that should help you find out what is causing the crash. Writing a core file # 2011-09-27T03:19:50 Test completed with failure status STATUS_SERVER_CRASHED (101) # 2011-09-27T03:19:50 gentest.pl exited with exit status STATUS_SERVER_CRASHED (101) 2011-09-27T03:19:50 [15770] runall.pl will exit with exit status STATUS_SERVER_CRASHED (101)