"2011-02-25 15:52:52","root[root] @ localhost [127.0.0.1]","00:00:24","00:00:00",1,1267075,"test",0,0,1,"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"
"2011-02-25 15:53:14","root[root] @ localhost [127.0.0.1]","00:00:40","00:00:00",1,421422,"test",0,0,1,"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"
"2011-02-25 15:53:42","root[root] @ localhost [127.0.0.1]","00:00:23","00:00:00",1,1267125,"test",0,0,1,"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 */"
"2011-02-25 15:54:06","root[root] @ localhost [127.0.0.1]","00:00:40","00:00:00",1,421472,"test",0,0,1,"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 */"
"2011-02-25 15:54:30","root[root] @ localhost [127.0.0.1]","00:00:12","00:00:00",1,63695,"test",0,0,1,"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 */"
"2011-02-25 15:55:28","root[root] @ localhost [127.0.0.1]","00:00:48","00:00:00",0,446017,"test",0,0,1,"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' , '%' )"
