Home
last modified time | relevance | path

Searched refs:o_custkey (Results 1 – 25 of 321) sorted by relevance

12345678910>>...13

/dports/databases/pg_citus/citus-10.2.3/src/test/regress/sql/
H A Dmulti_hash_pruning.sql25 o_custkey integer, field
195 WHERE o_orderkey = 1 AND (o_custkey = 11 OR o_custkey = 22);
203 WHERE (o_orderkey = 1 OR o_orderkey = 2) AND (o_custkey = 11 OR o_custkey = 22);
207 …rkey = 1 AND o_custkey = 11) OR (o_orderkey = 1 AND o_custkey = 33) OR (o_orderkey = 2 AND o_custk…
211 WHERE (o_orderkey IN (1,2)) AND (o_custkey = 11 OR o_custkey = 22 OR o_custkey = 33);
235 …WHERE (o_orderkey IN (1,2)) AND (o_custkey = 11 OR o_custkey = 22 OR o_custkey = 33) AND o_totalpr…
239 WHERE (o_orderkey IN (1,2)) AND (o_custkey = 11 OR o_custkey = 33) AND o_custkey = 22;
243 WHERE ((o_orderkey IN (1,2)) AND (o_custkey = 11 OR o_custkey = 22)) OR o_custkey = 33;
247 …WHERE ((o_orderkey IN (1,2)) AND (o_custkey = 11 OR o_custkey = 22)) OR (o_orderkey = 3 AND o_cust…
251 WHERE o_custkey = 11 OR (o_orderkey = 2 AND o_custkey = 22);
[all …]
H A Dmulti_complex_expressions.sql161 SELECT * FROM (SELECT o_custkey FROM orders GROUP BY o_custkey ORDER BY o_custkey OFFSET 20) sq ORD…
172 customer_keys.o_custkey,
178 customer_keys.o_custkey
184 customer_keys.o_custkey,
190 customer_keys.o_custkey
196 customer_keys.o_custkey,
202 customer_keys.o_custkey
216 SELECT o_custkey FROM orders GROUP BY o_custkey LIMIT 10 OFFSET 15; field
220 SELECT o_custkey FROM orders GROUP BY o_custkey ORDER BY o_custkey LIMIT 10 OFFSET 15; field
227 SELECT o_custkey FROM orders ORDER BY o_custkey OFFSET 2980;
[all …]
H A Dmulti_repartition_join_pruning.sql20 o_custkey = c_custkey;
26 o_custkey = c_custkey;
36 o_custkey = c_custkey AND
43 o_custkey = c_custkey AND
54 o_custkey = c_custkey AND
61 o_custkey = c_custkey AND
104 orders INNER JOIN customer_append ON (o_custkey = c_custkey)
111 orders INNER JOIN customer_append ON (o_custkey = c_custkey)
119 orders INNER JOIN customer_append ON (o_custkey = c_custkey)
127 orders INNER JOIN customer_append ON (o_custkey = c_custkey AND false);
[all …]
H A Dmulti_select_distinct.sql424 SELECT DISTINCT ON (o_custkey) o_custkey, l_orderkey
426 WHERE o_custkey < 15
431 SELECT DISTINCT ON (o_custkey) o_custkey, l_orderkey
433 WHERE o_custkey < 15
441 SELECT DISTINCT ON (o_custkey) o_custkey, l_orderkey
443 WHERE o_custkey < 15;
447 SELECT DISTINCT ON (o_custkey, l_orderkey) o_custkey, l_orderkey, l_linenumber, l_partkey
449 WHERE o_custkey < 20
457 WHERE o_custkey < 20;
461 SELECT DISTINCT ON (o_custkey, l_orderkey) o_custkey, l_orderkey, l_linenumber, l_partkey
[all …]
H A Dmulti_join_order_additional.sql44 o_custkey integer not null, field
106 WHERE o_custkey = l_partkey AND o_custkey = c_nationkey;
112 WHERE c_custkey = o_custkey;
118 WHERE c_custkey = o_custkey;
H A Dmulti_mx_explain.sql179 AND o_custkey = c_custkey
186 AND o_custkey = c_custkey
193 AND o_custkey = c_custkey
200 AND o_custkey = c_custkey
207 AND o_custkey = c_custkey
214 AND o_custkey = c_custkey
/dports/databases/pg_citus/citus-10.2.3/src/test/regress/expected/
H A Dmulti_complex_expressions.out349 SELECT * FROM (SELECT o_custkey FROM orders GROUP BY o_custkey ORDER BY o_custkey OFFSET 20) sq ORD…
350 o_custkey
388 customer_keys.o_custkey,
394 customer_keys.o_custkey
419 customer_keys.o_custkey
444 customer_keys.o_custkey
470 SELECT o_custkey FROM orders GROUP BY o_custkey LIMIT 10 OFFSET 15;
473 SELECT o_custkey FROM orders GROUP BY o_custkey ORDER BY o_custkey LIMIT 10 OFFSET 15;
479 SELECT o_custkey FROM orders ORDER BY o_custkey OFFSET 2980;
480 o_custkey
[all …]
/dports/databases/mariadb105-client/mariadb-10.5.15/storage/columnstore/columnstore/mysql-test/columnstore/csinternal/devregression/r/
H A Dmcs7189_regression_bug5820.result2 …o_custkey, o_totalprice, PERCENTILE_CONT(0.4) WITHIN GROUP (ORDER BY o_totalprice DESC) OVER (part…
3 o_orderkey o_custkey o_totalprice percentile_cont
45 …o_custkey, PERCENTILE_CONT(0.4) WITHIN GROUP (ORDER BY o_totalprice DESC) OVER (partition by o_cus…
46 o_orderkey o_custkey percentile_cont
H A Dmcs7563_aggregate_tpch_orders.result5 select count(o_custkey), min(o_custkey), max(o_custkey) , sum(o_custkey), avg(o_custkey) from orde…
6 count(o_custkey) min(o_custkey) max(o_custkey) sum(o_custkey) avg(o_custkey)
H A Dmcs7000_regression_bug1632.result30 select o1.o_orderkey o1order, o2.o_custkey o2order, o1.o_custkey
33 where o1.o_custkey = o2.o_orderkey and
38 o1order o2order o_custkey
H A Dmcs7606_q44.result2 Select o_orderdate, o_custkey from orders,lineitem where o_custkey < 100 and o_orderkey = l_orderke…
3 o_orderdate o_custkey
H A Dmcs7537_q4_4.result2 Select o_orderdate, o_custkey from orders,lineitem where o_custkey < 100 and o_orderkey = l_orderke…
3 o_orderdate o_custkey
H A Dmcs7653_q44.result2 Select o_orderdate, o_custkey from orders,lineitem where o_custkey < 100 and o_orderkey = l_orderke…
3 o_orderdate o_custkey
/dports/databases/mariadb105-server/mariadb-10.5.15/storage/columnstore/columnstore/mysql-test/columnstore/csinternal/devregression/r/
H A Dmcs7189_regression_bug5820.result2 …o_custkey, o_totalprice, PERCENTILE_CONT(0.4) WITHIN GROUP (ORDER BY o_totalprice DESC) OVER (part…
3 o_orderkey o_custkey o_totalprice percentile_cont
45 …o_custkey, PERCENTILE_CONT(0.4) WITHIN GROUP (ORDER BY o_totalprice DESC) OVER (partition by o_cus…
46 o_orderkey o_custkey percentile_cont
H A Dmcs7563_aggregate_tpch_orders.result5 select count(o_custkey), min(o_custkey), max(o_custkey) , sum(o_custkey), avg(o_custkey) from orde…
6 count(o_custkey) min(o_custkey) max(o_custkey) sum(o_custkey) avg(o_custkey)
H A Dmcs7000_regression_bug1632.result30 select o1.o_orderkey o1order, o2.o_custkey o2order, o1.o_custkey
33 where o1.o_custkey = o2.o_orderkey and
38 o1order o2order o_custkey
H A Dmcs7606_q44.result2 Select o_orderdate, o_custkey from orders,lineitem where o_custkey < 100 and o_orderkey = l_orderke…
3 o_orderdate o_custkey
H A Dmcs7653_q44.result2 Select o_orderdate, o_custkey from orders,lineitem where o_custkey < 100 and o_orderkey = l_orderke…
3 o_orderdate o_custkey
H A Dmcs7537_q4_4.result2 Select o_orderdate, o_custkey from orders,lineitem where o_custkey < 100 and o_orderkey = l_orderke…
3 o_orderdate o_custkey
/dports/databases/mariadb105-client/mariadb-10.5.15/storage/columnstore/columnstore/mysql-test/columnstore/csinternal/devregression/t/
H A Dmcs7063_regression_bug3279.test24 select 'q7', count(*) from orders where o_orderkey<o_custkey and o_shippriority < o_custkey;
25 update orders set o_orderkey=o_custkey where o_orderkey<o_custkey and o_shippriority < o_custkey;
26 select 'q8', count(*) from orders where o_orderkey=o_custkey and o_shippriority < o_custkey;
H A Dmcs7189_regression_bug5820.test12 …o_custkey, o_totalprice, PERCENTILE_CONT(0.4) WITHIN GROUP (ORDER BY o_totalprice DESC) OVER (part…
13 …o_custkey, PERCENTILE_CONT(0.4) WITHIN GROUP (ORDER BY o_totalprice DESC) OVER (partition by o_cus…
H A Dmcs7563_aggregate_tpch_orders.test13 select count(o_custkey), min(o_custkey), max(o_custkey) , sum(o_custkey), avg(o_custkey) from orde…
/dports/databases/mariadb105-server/mariadb-10.5.15/storage/columnstore/columnstore/mysql-test/columnstore/csinternal/devregression/t/
H A Dmcs7063_regression_bug3279.test24 select 'q7', count(*) from orders where o_orderkey<o_custkey and o_shippriority < o_custkey;
25 update orders set o_orderkey=o_custkey where o_orderkey<o_custkey and o_shippriority < o_custkey;
26 select 'q8', count(*) from orders where o_orderkey=o_custkey and o_shippriority < o_custkey;
H A Dmcs7189_regression_bug5820.test12 …o_custkey, o_totalprice, PERCENTILE_CONT(0.4) WITHIN GROUP (ORDER BY o_totalprice DESC) OVER (part…
13 …o_custkey, PERCENTILE_CONT(0.4) WITHIN GROUP (ORDER BY o_totalprice DESC) OVER (partition by o_cus…
H A Dmcs7563_aggregate_tpch_orders.test13 select count(o_custkey), min(o_custkey), max(o_custkey) , sum(o_custkey), avg(o_custkey) from orde…

12345678910>>...13