/home/philips/bzr/maria-5.3-mwl128/sql/mysqld, Version: 5.3.0-MariaDB-alpha-debug-log (Source distribution). started with:
Tcp port: 19300  Unix socket: /tmp/wl128-vardir101/current/tmp/master.sock
Time                 Id Command    Argument
# Time: 110225 15:52:52
# User@Host: root[root] @ localhost [127.0.0.1]
# Thread_id: 10  Schema: test  QC_hit: No
# Query_time: 24.777067  Lock_time: 0.001840  Rows_sent: 1  Rows_examined: 1267075
use test;
SET timestamp=1298638372;
SELECT MAX( c_custkey ) FROM region JOIN nation ON ( r_regionkey = n_regionkey ) JOIN supplier ON ( s_nationkey = n_nationkey ) JOIN partsupp ON ( s_suppkey = ps_suppkey ) JOIN lineitem ON ( ps_suppkey = l_suppkey ) RIGHT JOIN orders ON ( l_orderkey = o_orderkey ) RIGHT JOIN customer ON ( o_custkey = c_custkey ) WHERE c_acctbal BETWEEN 8 AND 6 + 133 AND l_extendedprice >= o_totalprice OR c_comment IS NOT NULL AND l_extendedprice <> o_totalprice;
# Time: 110225 15:53:14
# User@Host: root[root] @ localhost [127.0.0.1]
# Thread_id: 11  Schema: test  QC_hit: No
# Query_time: 40.965621  Lock_time: 0.001634  Rows_sent: 1  Rows_examined: 421422
SET timestamp=1298638394;
SELECT MIN( l_partkey ) FROM region LEFT JOIN nation ON ( r_regionkey = n_regionkey ) JOIN supplier ON ( s_nationkey = n_nationkey ) LEFT JOIN partsupp ON ( s_suppkey = ps_suppkey ) LEFT JOIN lineitem ON ( ps_suppkey = l_suppkey ) RIGHT JOIN orders ON ( l_orderkey = o_orderkey ) JOIN customer ON ( o_custkey = c_custkey ) WHERE l_commitDATE <= '1997-03-28' AND ps_supplycost > l_extendedprice OR ps_availqty = l_quantity AND r_comment IS NOT NULL;
# Time: 110225 15:53:42
# User@Host: root[root] @ localhost [127.0.0.1]
# Thread_id: 10  Schema: test  QC_hit: No
# Query_time: 23.410453  Lock_time: 0.001823  Rows_sent: 1  Rows_examined: 1267125
SET timestamp=1298638422;
SELECT MAX( c_custkey ) FROM region JOIN nation ON ( r_regionkey = n_regionkey ) JOIN supplier ON ( s_nationkey = n_nationkey ) JOIN partsupp ON ( s_suppkey = ps_suppkey ) JOIN lineitem ON ( ps_suppkey = l_suppkey ) RIGHT JOIN orders ON ( l_orderkey = o_orderkey ) RIGHT JOIN customer ON ( o_custkey = c_custkey ) WHERE c_acctbal BETWEEN 8 AND 6 + 133 AND l_extendedprice >= o_totalprice OR c_comment IS NOT NULL AND l_extendedprice <> o_totalprice /* TRANSFORM_OUTCOME_UNORDERED_MATCH */;
# Time: 110225 15:54:06
# User@Host: root[root] @ localhost [127.0.0.1]
# Thread_id: 11  Schema: test  QC_hit: No
# Query_time: 40.205091  Lock_time: 0.002027  Rows_sent: 1  Rows_examined: 421472
SET timestamp=1298638446;
SELECT MIN( l_partkey ) FROM region LEFT JOIN nation ON ( r_regionkey = n_regionkey ) JOIN supplier ON ( s_nationkey = n_nationkey ) LEFT JOIN partsupp ON ( s_suppkey = ps_suppkey ) LEFT JOIN lineitem ON ( ps_suppkey = l_suppkey ) RIGHT JOIN orders ON ( l_orderkey = o_orderkey ) JOIN customer ON ( o_custkey = c_custkey ) WHERE l_commitDATE <= '1997-03-28' AND ps_supplycost > l_extendedprice OR ps_availqty = l_quantity AND r_comment IS NOT NULL /* TRANSFORM_OUTCOME_UNORDERED_MATCH */;
# Time: 110225 15:54:30
# User@Host: root[root] @ localhost [127.0.0.1]
# Thread_id: 11  Schema: test  QC_hit: No
# Query_time: 12.666476  Lock_time: 0.002291  Rows_sent: 1  Rows_examined: 63695
SET timestamp=1298638470;
SELECT SUM( DISTINCT l_suppkey ) FROM region JOIN nation ON ( r_regionkey = n_regionkey ) JOIN supplier ON ( s_nationkey = n_nationkey ) LEFT JOIN partsupp ON ( s_suppkey = ps_suppkey ) JOIN lineitem ON ( ps_partkey = l_partkey ) RIGHT JOIN orders ON ( l_orderkey = o_orderkey ) LEFT JOIN customer ON ( o_custkey = c_custkey ) WHERE c_comment NOT LIKE CONCAT( 'b' , '%' ) AND ps_partkey BETWEEN 132 AND 61 + 0 AND r_regionkey >= 2 AND c_nationkey = s_nationkey OR c_acctbal BETWEEN 249 AND 179 + 181 AND c_nationkey != s_nationkey /* TRANSFORM_OUTCOME_UNORDERED_MATCH */;
# Time: 110225 15:55:28
# User@Host: root[root] @ localhost [127.0.0.1]
# Thread_id: 10  Schema: test  QC_hit: No
# Query_time: 48.063127  Lock_time: 0.001989  Rows_sent: 0  Rows_examined: 446017
SET timestamp=1298638528;
SELECT MIN( s_nationkey ) FROM part RIGHT JOIN partsupp ON ( p_partkey = ps_partkey ) RIGHT JOIN lineitem ON ( ps_suppkey = l_suppkey ) RIGHT JOIN orders ON ( l_orderkey = o_orderkey ) LEFT JOIN customer ON ( o_custkey = c_custkey ) LEFT JOIN nation ON ( c_nationkey = n_nationkey ) JOIN supplier ON ( s_nationkey = n_nationkey ) LEFT JOIN region ON ( n_regionkey = r_regionkey ) WHERE ps_supplycost BETWEEN 221 AND 146 + 53 OR n_comment BETWEEN 'p' AND 'p' AND ps_comment NOT LIKE CONCAT( 'g' , '%' );
