Merge branch 'rightlib' into mergelibs-241120-1113

1 files changed, 49 insertions, 0 deletions

diff --git a/yql/essentials/tests/sql/suites/pg-tpch/q02.sql b/yql/essentials/tests/sql/suites/pg-tpch/q02.sql
new file mode 100644
index 0000000000..91349256c7
--- /dev/null
+++ b/yql/essentials/tests/sql/suites/pg-tpch/q02.sql
@@ -0,0 +1,49 @@
+--!syntax_pg
+--ignore runonopt plan diff
+--TPC-H Q2
+
+
+select
+s_acctbal, 
+s_name, 
+n_name, 
+p_partkey, 
+p_mfgr, 
+s_address, 
+s_phone, 
+s_comment
+from 
+plato."part", 
+plato."supplier", 
+plato."partsupp", 
+plato."nation", 
+plato."region"
+where 
+p_partkey = ps_partkey
+and s_suppkey = ps_suppkey
+and p_size = 15
+and p_type like '%BRASS'
+and s_nationkey = n_nationkey
+and n_regionkey = r_regionkey
+and r_name = 'EUROPE'
+and ps_supplycost = (
+select 
+min(ps_supplycost)
+from 
+plato."partsupp",
+plato."supplier", 
+plato."nation",
+plato."region"
+where 
+p_partkey = ps_partkey
+and s_suppkey = ps_suppkey
+and s_nationkey = n_nationkey
+and n_regionkey = r_regionkey
+and r_name = 'EUROPE'
+)
+order by 
+s_acctbal desc, 
+n_name, 
+s_name, 
+p_partkey
+limit 100;