You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@asterixdb.apache.org by mh...@apache.org on 2017/08/22 10:14:59 UTC
[04/32] asterixdb git commit: [ASTERIXDB-2050][SQL] Enforce a
Semicolon After Each SQL++ Statement
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/q03_shipping_priority_nt/q03_shipping_priority_nt.1.ddl.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/q03_shipping_priority_nt/q03_shipping_priority_nt.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/q03_shipping_priority_nt/q03_shipping_priority_nt.1.ddl.sqlpp
index 6cbdf11..ef52df8 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/q03_shipping_priority_nt/q03_shipping_priority_nt.1.ddl.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/q03_shipping_priority_nt/q03_shipping_priority_nt.1.ddl.sqlpp
@@ -41,7 +41,7 @@ create type tpch.LineItemType as
l_shipinstruct : string,
l_shipmode : string,
l_comment : string
-}
+};
create type tpch.OrderType as
closed {
@@ -54,7 +54,7 @@ create type tpch.OrderType as
o_clerk : string,
o_shippriority : bigint,
o_comment : string
-}
+};
create type tpch.CustomerType as
closed {
@@ -66,7 +66,7 @@ create type tpch.CustomerType as
c_acctbal : double,
c_mktsegment : string,
c_comment : string
-}
+};
create type tpch.SupplierType as
closed {
@@ -77,7 +77,7 @@ create type tpch.SupplierType as
s_phone : string,
s_acctbal : double,
s_comment : string
-}
+};
create type tpch.NationType as
closed {
@@ -85,14 +85,14 @@ create type tpch.NationType as
n_name : string,
n_regionkey : bigint,
n_comment : string
-}
+};
create type tpch.RegionType as
closed {
r_regionkey : bigint,
r_name : string,
r_comment : string
-}
+};
create type tpch.PartType as
closed {
@@ -105,7 +105,7 @@ create type tpch.PartType as
p_container : string,
p_retailprice : double,
p_comment : string
-}
+};
create type tpch.PartSuppType as
closed {
@@ -114,7 +114,7 @@ create type tpch.PartSuppType as
ps_availqty : bigint,
ps_supplycost : double,
ps_comment : string
-}
+};
create dataset LineItem(LineItemType) primary key l_orderkey,l_linenumber;
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/q04_order_priority/q04_order_priority.1.ddl.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/q04_order_priority/q04_order_priority.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/q04_order_priority/q04_order_priority.1.ddl.sqlpp
index 6cbdf11..ef52df8 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/q04_order_priority/q04_order_priority.1.ddl.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/q04_order_priority/q04_order_priority.1.ddl.sqlpp
@@ -41,7 +41,7 @@ create type tpch.LineItemType as
l_shipinstruct : string,
l_shipmode : string,
l_comment : string
-}
+};
create type tpch.OrderType as
closed {
@@ -54,7 +54,7 @@ create type tpch.OrderType as
o_clerk : string,
o_shippriority : bigint,
o_comment : string
-}
+};
create type tpch.CustomerType as
closed {
@@ -66,7 +66,7 @@ create type tpch.CustomerType as
c_acctbal : double,
c_mktsegment : string,
c_comment : string
-}
+};
create type tpch.SupplierType as
closed {
@@ -77,7 +77,7 @@ create type tpch.SupplierType as
s_phone : string,
s_acctbal : double,
s_comment : string
-}
+};
create type tpch.NationType as
closed {
@@ -85,14 +85,14 @@ create type tpch.NationType as
n_name : string,
n_regionkey : bigint,
n_comment : string
-}
+};
create type tpch.RegionType as
closed {
r_regionkey : bigint,
r_name : string,
r_comment : string
-}
+};
create type tpch.PartType as
closed {
@@ -105,7 +105,7 @@ create type tpch.PartType as
p_container : string,
p_retailprice : double,
p_comment : string
-}
+};
create type tpch.PartSuppType as
closed {
@@ -114,7 +114,7 @@ create type tpch.PartSuppType as
ps_availqty : bigint,
ps_supplycost : double,
ps_comment : string
-}
+};
create dataset LineItem(LineItemType) primary key l_orderkey,l_linenumber;
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/q05_local_supplier_volume/q05_local_supplier_volume.1.ddl.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/q05_local_supplier_volume/q05_local_supplier_volume.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/q05_local_supplier_volume/q05_local_supplier_volume.1.ddl.sqlpp
index 0db8d36..4ba3bef 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/q05_local_supplier_volume/q05_local_supplier_volume.1.ddl.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/q05_local_supplier_volume/q05_local_supplier_volume.1.ddl.sqlpp
@@ -41,7 +41,7 @@ create type tpch.LineItemType as
l_shipinstruct : string,
l_shipmode : string,
l_comment : string
-}
+};
create type tpch.OrderType as
closed {
@@ -54,7 +54,7 @@ create type tpch.OrderType as
o_clerk : string,
o_shippriority : integer,
o_comment : string
-}
+};
create type tpch.CustomerType as
closed {
@@ -66,7 +66,7 @@ create type tpch.CustomerType as
c_acctbal : double,
c_mktsegment : string,
c_comment : string
-}
+};
create type tpch.SupplierType as
closed {
@@ -77,7 +77,7 @@ create type tpch.SupplierType as
s_phone : string,
s_acctbal : double,
s_comment : string
-}
+};
create type tpch.NationType as
closed {
@@ -85,14 +85,14 @@ create type tpch.NationType as
n_name : string,
n_regionkey : integer,
n_comment : string
-}
+};
create type tpch.RegionType as
closed {
r_regionkey : integer,
r_name : string,
r_comment : string
-}
+};
create type tpch.PartType as
closed {
@@ -105,7 +105,7 @@ create type tpch.PartType as
p_container : string,
p_retailprice : double,
p_comment : string
-}
+};
create type tpch.PartSuppType as
closed {
@@ -114,7 +114,7 @@ create type tpch.PartSuppType as
ps_availqty : integer,
ps_supplycost : double,
ps_comment : string
-}
+};
create dataset LineItem(LineItemType) primary key l_orderkey,l_linenumber;
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/q06_forecast_revenue_change/q06_forecast_revenue_change.1.ddl.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/q06_forecast_revenue_change/q06_forecast_revenue_change.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/q06_forecast_revenue_change/q06_forecast_revenue_change.1.ddl.sqlpp
index 0db8d36..4ba3bef 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/q06_forecast_revenue_change/q06_forecast_revenue_change.1.ddl.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/q06_forecast_revenue_change/q06_forecast_revenue_change.1.ddl.sqlpp
@@ -41,7 +41,7 @@ create type tpch.LineItemType as
l_shipinstruct : string,
l_shipmode : string,
l_comment : string
-}
+};
create type tpch.OrderType as
closed {
@@ -54,7 +54,7 @@ create type tpch.OrderType as
o_clerk : string,
o_shippriority : integer,
o_comment : string
-}
+};
create type tpch.CustomerType as
closed {
@@ -66,7 +66,7 @@ create type tpch.CustomerType as
c_acctbal : double,
c_mktsegment : string,
c_comment : string
-}
+};
create type tpch.SupplierType as
closed {
@@ -77,7 +77,7 @@ create type tpch.SupplierType as
s_phone : string,
s_acctbal : double,
s_comment : string
-}
+};
create type tpch.NationType as
closed {
@@ -85,14 +85,14 @@ create type tpch.NationType as
n_name : string,
n_regionkey : integer,
n_comment : string
-}
+};
create type tpch.RegionType as
closed {
r_regionkey : integer,
r_name : string,
r_comment : string
-}
+};
create type tpch.PartType as
closed {
@@ -105,7 +105,7 @@ create type tpch.PartType as
p_container : string,
p_retailprice : double,
p_comment : string
-}
+};
create type tpch.PartSuppType as
closed {
@@ -114,7 +114,7 @@ create type tpch.PartSuppType as
ps_availqty : integer,
ps_supplycost : double,
ps_comment : string
-}
+};
create dataset LineItem(LineItemType) primary key l_orderkey,l_linenumber;
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/q07_volume_shipping/q07_volume_shipping.1.ddl.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/q07_volume_shipping/q07_volume_shipping.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/q07_volume_shipping/q07_volume_shipping.1.ddl.sqlpp
index 0db8d36..4ba3bef 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/q07_volume_shipping/q07_volume_shipping.1.ddl.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/q07_volume_shipping/q07_volume_shipping.1.ddl.sqlpp
@@ -41,7 +41,7 @@ create type tpch.LineItemType as
l_shipinstruct : string,
l_shipmode : string,
l_comment : string
-}
+};
create type tpch.OrderType as
closed {
@@ -54,7 +54,7 @@ create type tpch.OrderType as
o_clerk : string,
o_shippriority : integer,
o_comment : string
-}
+};
create type tpch.CustomerType as
closed {
@@ -66,7 +66,7 @@ create type tpch.CustomerType as
c_acctbal : double,
c_mktsegment : string,
c_comment : string
-}
+};
create type tpch.SupplierType as
closed {
@@ -77,7 +77,7 @@ create type tpch.SupplierType as
s_phone : string,
s_acctbal : double,
s_comment : string
-}
+};
create type tpch.NationType as
closed {
@@ -85,14 +85,14 @@ create type tpch.NationType as
n_name : string,
n_regionkey : integer,
n_comment : string
-}
+};
create type tpch.RegionType as
closed {
r_regionkey : integer,
r_name : string,
r_comment : string
-}
+};
create type tpch.PartType as
closed {
@@ -105,7 +105,7 @@ create type tpch.PartType as
p_container : string,
p_retailprice : double,
p_comment : string
-}
+};
create type tpch.PartSuppType as
closed {
@@ -114,7 +114,7 @@ create type tpch.PartSuppType as
ps_availqty : integer,
ps_supplycost : double,
ps_comment : string
-}
+};
create dataset LineItem(LineItemType) primary key l_orderkey,l_linenumber;
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/q07_volume_shipping/q07_volume_shipping.3.query.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/q07_volume_shipping/q07_volume_shipping.3.query.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/q07_volume_shipping/q07_volume_shipping.3.query.sqlpp
index 43fd594..46837fa 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/q07_volume_shipping/q07_volume_shipping.3.query.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/q07_volume_shipping/q07_volume_shipping.3.query.sqlpp
@@ -30,7 +30,7 @@ declare function q7_volume_shipping_tmp() {
Nation as n2
where n2.n_name = 'GERMANY' or n1.n_name = 'GERMANY'
)
-}
+};
SELECT supp_nation AS supp_nation,
cust_nation AS cust_nation,
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/q08_national_market_share/q08_national_market_share.1.ddl.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/q08_national_market_share/q08_national_market_share.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/q08_national_market_share/q08_national_market_share.1.ddl.sqlpp
index 0db8d36..4ba3bef 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/q08_national_market_share/q08_national_market_share.1.ddl.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/q08_national_market_share/q08_national_market_share.1.ddl.sqlpp
@@ -41,7 +41,7 @@ create type tpch.LineItemType as
l_shipinstruct : string,
l_shipmode : string,
l_comment : string
-}
+};
create type tpch.OrderType as
closed {
@@ -54,7 +54,7 @@ create type tpch.OrderType as
o_clerk : string,
o_shippriority : integer,
o_comment : string
-}
+};
create type tpch.CustomerType as
closed {
@@ -66,7 +66,7 @@ create type tpch.CustomerType as
c_acctbal : double,
c_mktsegment : string,
c_comment : string
-}
+};
create type tpch.SupplierType as
closed {
@@ -77,7 +77,7 @@ create type tpch.SupplierType as
s_phone : string,
s_acctbal : double,
s_comment : string
-}
+};
create type tpch.NationType as
closed {
@@ -85,14 +85,14 @@ create type tpch.NationType as
n_name : string,
n_regionkey : integer,
n_comment : string
-}
+};
create type tpch.RegionType as
closed {
r_regionkey : integer,
r_name : string,
r_comment : string
-}
+};
create type tpch.PartType as
closed {
@@ -105,7 +105,7 @@ create type tpch.PartType as
p_container : string,
p_retailprice : double,
p_comment : string
-}
+};
create type tpch.PartSuppType as
closed {
@@ -114,7 +114,7 @@ create type tpch.PartSuppType as
ps_availqty : integer,
ps_supplycost : double,
ps_comment : string
-}
+};
create dataset LineItem(LineItemType) primary key l_orderkey,l_linenumber;
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/q09_product_type_profit_nt/q09_product_type_profit_nt.1.ddl.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/q09_product_type_profit_nt/q09_product_type_profit_nt.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/q09_product_type_profit_nt/q09_product_type_profit_nt.1.ddl.sqlpp
index 0db8d36..4ba3bef 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/q09_product_type_profit_nt/q09_product_type_profit_nt.1.ddl.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/q09_product_type_profit_nt/q09_product_type_profit_nt.1.ddl.sqlpp
@@ -41,7 +41,7 @@ create type tpch.LineItemType as
l_shipinstruct : string,
l_shipmode : string,
l_comment : string
-}
+};
create type tpch.OrderType as
closed {
@@ -54,7 +54,7 @@ create type tpch.OrderType as
o_clerk : string,
o_shippriority : integer,
o_comment : string
-}
+};
create type tpch.CustomerType as
closed {
@@ -66,7 +66,7 @@ create type tpch.CustomerType as
c_acctbal : double,
c_mktsegment : string,
c_comment : string
-}
+};
create type tpch.SupplierType as
closed {
@@ -77,7 +77,7 @@ create type tpch.SupplierType as
s_phone : string,
s_acctbal : double,
s_comment : string
-}
+};
create type tpch.NationType as
closed {
@@ -85,14 +85,14 @@ create type tpch.NationType as
n_name : string,
n_regionkey : integer,
n_comment : string
-}
+};
create type tpch.RegionType as
closed {
r_regionkey : integer,
r_name : string,
r_comment : string
-}
+};
create type tpch.PartType as
closed {
@@ -105,7 +105,7 @@ create type tpch.PartType as
p_container : string,
p_retailprice : double,
p_comment : string
-}
+};
create type tpch.PartSuppType as
closed {
@@ -114,7 +114,7 @@ create type tpch.PartSuppType as
ps_availqty : integer,
ps_supplycost : double,
ps_comment : string
-}
+};
create dataset LineItem(LineItemType) primary key l_orderkey,l_linenumber;
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/q10_returned_item/q10_returned_item.1.ddl.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/q10_returned_item/q10_returned_item.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/q10_returned_item/q10_returned_item.1.ddl.sqlpp
index 0db8d36..4ba3bef 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/q10_returned_item/q10_returned_item.1.ddl.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/q10_returned_item/q10_returned_item.1.ddl.sqlpp
@@ -41,7 +41,7 @@ create type tpch.LineItemType as
l_shipinstruct : string,
l_shipmode : string,
l_comment : string
-}
+};
create type tpch.OrderType as
closed {
@@ -54,7 +54,7 @@ create type tpch.OrderType as
o_clerk : string,
o_shippriority : integer,
o_comment : string
-}
+};
create type tpch.CustomerType as
closed {
@@ -66,7 +66,7 @@ create type tpch.CustomerType as
c_acctbal : double,
c_mktsegment : string,
c_comment : string
-}
+};
create type tpch.SupplierType as
closed {
@@ -77,7 +77,7 @@ create type tpch.SupplierType as
s_phone : string,
s_acctbal : double,
s_comment : string
-}
+};
create type tpch.NationType as
closed {
@@ -85,14 +85,14 @@ create type tpch.NationType as
n_name : string,
n_regionkey : integer,
n_comment : string
-}
+};
create type tpch.RegionType as
closed {
r_regionkey : integer,
r_name : string,
r_comment : string
-}
+};
create type tpch.PartType as
closed {
@@ -105,7 +105,7 @@ create type tpch.PartType as
p_container : string,
p_retailprice : double,
p_comment : string
-}
+};
create type tpch.PartSuppType as
closed {
@@ -114,7 +114,7 @@ create type tpch.PartSuppType as
ps_availqty : integer,
ps_supplycost : double,
ps_comment : string
-}
+};
create dataset LineItem(LineItemType) primary key l_orderkey,l_linenumber;
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/q10_returned_item_int64/q10_returned_item_int64.1.ddl.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/q10_returned_item_int64/q10_returned_item_int64.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/q10_returned_item_int64/q10_returned_item_int64.1.ddl.sqlpp
index 6cbdf11..ef52df8 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/q10_returned_item_int64/q10_returned_item_int64.1.ddl.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/q10_returned_item_int64/q10_returned_item_int64.1.ddl.sqlpp
@@ -41,7 +41,7 @@ create type tpch.LineItemType as
l_shipinstruct : string,
l_shipmode : string,
l_comment : string
-}
+};
create type tpch.OrderType as
closed {
@@ -54,7 +54,7 @@ create type tpch.OrderType as
o_clerk : string,
o_shippriority : bigint,
o_comment : string
-}
+};
create type tpch.CustomerType as
closed {
@@ -66,7 +66,7 @@ create type tpch.CustomerType as
c_acctbal : double,
c_mktsegment : string,
c_comment : string
-}
+};
create type tpch.SupplierType as
closed {
@@ -77,7 +77,7 @@ create type tpch.SupplierType as
s_phone : string,
s_acctbal : double,
s_comment : string
-}
+};
create type tpch.NationType as
closed {
@@ -85,14 +85,14 @@ create type tpch.NationType as
n_name : string,
n_regionkey : bigint,
n_comment : string
-}
+};
create type tpch.RegionType as
closed {
r_regionkey : bigint,
r_name : string,
r_comment : string
-}
+};
create type tpch.PartType as
closed {
@@ -105,7 +105,7 @@ create type tpch.PartType as
p_container : string,
p_retailprice : double,
p_comment : string
-}
+};
create type tpch.PartSuppType as
closed {
@@ -114,7 +114,7 @@ create type tpch.PartSuppType as
ps_availqty : bigint,
ps_supplycost : double,
ps_comment : string
-}
+};
create dataset LineItem(LineItemType) primary key l_orderkey,l_linenumber;
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/q11_important_stock/q11_important_stock.1.ddl.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/q11_important_stock/q11_important_stock.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/q11_important_stock/q11_important_stock.1.ddl.sqlpp
index 6cbdf11..ef52df8 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/q11_important_stock/q11_important_stock.1.ddl.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/q11_important_stock/q11_important_stock.1.ddl.sqlpp
@@ -41,7 +41,7 @@ create type tpch.LineItemType as
l_shipinstruct : string,
l_shipmode : string,
l_comment : string
-}
+};
create type tpch.OrderType as
closed {
@@ -54,7 +54,7 @@ create type tpch.OrderType as
o_clerk : string,
o_shippriority : bigint,
o_comment : string
-}
+};
create type tpch.CustomerType as
closed {
@@ -66,7 +66,7 @@ create type tpch.CustomerType as
c_acctbal : double,
c_mktsegment : string,
c_comment : string
-}
+};
create type tpch.SupplierType as
closed {
@@ -77,7 +77,7 @@ create type tpch.SupplierType as
s_phone : string,
s_acctbal : double,
s_comment : string
-}
+};
create type tpch.NationType as
closed {
@@ -85,14 +85,14 @@ create type tpch.NationType as
n_name : string,
n_regionkey : bigint,
n_comment : string
-}
+};
create type tpch.RegionType as
closed {
r_regionkey : bigint,
r_name : string,
r_comment : string
-}
+};
create type tpch.PartType as
closed {
@@ -105,7 +105,7 @@ create type tpch.PartType as
p_container : string,
p_retailprice : double,
p_comment : string
-}
+};
create type tpch.PartSuppType as
closed {
@@ -114,7 +114,7 @@ create type tpch.PartSuppType as
ps_availqty : bigint,
ps_supplycost : double,
ps_comment : string
-}
+};
create dataset LineItem(LineItemType) primary key l_orderkey,l_linenumber;
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/q12_shipping/q12_shipping.1.ddl.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/q12_shipping/q12_shipping.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/q12_shipping/q12_shipping.1.ddl.sqlpp
index 0db8d36..4ba3bef 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/q12_shipping/q12_shipping.1.ddl.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/q12_shipping/q12_shipping.1.ddl.sqlpp
@@ -41,7 +41,7 @@ create type tpch.LineItemType as
l_shipinstruct : string,
l_shipmode : string,
l_comment : string
-}
+};
create type tpch.OrderType as
closed {
@@ -54,7 +54,7 @@ create type tpch.OrderType as
o_clerk : string,
o_shippriority : integer,
o_comment : string
-}
+};
create type tpch.CustomerType as
closed {
@@ -66,7 +66,7 @@ create type tpch.CustomerType as
c_acctbal : double,
c_mktsegment : string,
c_comment : string
-}
+};
create type tpch.SupplierType as
closed {
@@ -77,7 +77,7 @@ create type tpch.SupplierType as
s_phone : string,
s_acctbal : double,
s_comment : string
-}
+};
create type tpch.NationType as
closed {
@@ -85,14 +85,14 @@ create type tpch.NationType as
n_name : string,
n_regionkey : integer,
n_comment : string
-}
+};
create type tpch.RegionType as
closed {
r_regionkey : integer,
r_name : string,
r_comment : string
-}
+};
create type tpch.PartType as
closed {
@@ -105,7 +105,7 @@ create type tpch.PartType as
p_container : string,
p_retailprice : double,
p_comment : string
-}
+};
create type tpch.PartSuppType as
closed {
@@ -114,7 +114,7 @@ create type tpch.PartSuppType as
ps_availqty : integer,
ps_supplycost : double,
ps_comment : string
-}
+};
create dataset LineItem(LineItemType) primary key l_orderkey,l_linenumber;
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/q13_customer_distribution/q13_customer_distribution.1.ddl.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/q13_customer_distribution/q13_customer_distribution.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/q13_customer_distribution/q13_customer_distribution.1.ddl.sqlpp
index 6cbdf11..ef52df8 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/q13_customer_distribution/q13_customer_distribution.1.ddl.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/q13_customer_distribution/q13_customer_distribution.1.ddl.sqlpp
@@ -41,7 +41,7 @@ create type tpch.LineItemType as
l_shipinstruct : string,
l_shipmode : string,
l_comment : string
-}
+};
create type tpch.OrderType as
closed {
@@ -54,7 +54,7 @@ create type tpch.OrderType as
o_clerk : string,
o_shippriority : bigint,
o_comment : string
-}
+};
create type tpch.CustomerType as
closed {
@@ -66,7 +66,7 @@ create type tpch.CustomerType as
c_acctbal : double,
c_mktsegment : string,
c_comment : string
-}
+};
create type tpch.SupplierType as
closed {
@@ -77,7 +77,7 @@ create type tpch.SupplierType as
s_phone : string,
s_acctbal : double,
s_comment : string
-}
+};
create type tpch.NationType as
closed {
@@ -85,14 +85,14 @@ create type tpch.NationType as
n_name : string,
n_regionkey : bigint,
n_comment : string
-}
+};
create type tpch.RegionType as
closed {
r_regionkey : bigint,
r_name : string,
r_comment : string
-}
+};
create type tpch.PartType as
closed {
@@ -105,7 +105,7 @@ create type tpch.PartType as
p_container : string,
p_retailprice : double,
p_comment : string
-}
+};
create type tpch.PartSuppType as
closed {
@@ -114,7 +114,7 @@ create type tpch.PartSuppType as
ps_availqty : bigint,
ps_supplycost : double,
ps_comment : string
-}
+};
create dataset LineItem(LineItemType) primary key l_orderkey,l_linenumber;
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/q14_promotion_effect/q14_promotion_effect.1.ddl.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/q14_promotion_effect/q14_promotion_effect.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/q14_promotion_effect/q14_promotion_effect.1.ddl.sqlpp
index 0db8d36..4ba3bef 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/q14_promotion_effect/q14_promotion_effect.1.ddl.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/q14_promotion_effect/q14_promotion_effect.1.ddl.sqlpp
@@ -41,7 +41,7 @@ create type tpch.LineItemType as
l_shipinstruct : string,
l_shipmode : string,
l_comment : string
-}
+};
create type tpch.OrderType as
closed {
@@ -54,7 +54,7 @@ create type tpch.OrderType as
o_clerk : string,
o_shippriority : integer,
o_comment : string
-}
+};
create type tpch.CustomerType as
closed {
@@ -66,7 +66,7 @@ create type tpch.CustomerType as
c_acctbal : double,
c_mktsegment : string,
c_comment : string
-}
+};
create type tpch.SupplierType as
closed {
@@ -77,7 +77,7 @@ create type tpch.SupplierType as
s_phone : string,
s_acctbal : double,
s_comment : string
-}
+};
create type tpch.NationType as
closed {
@@ -85,14 +85,14 @@ create type tpch.NationType as
n_name : string,
n_regionkey : integer,
n_comment : string
-}
+};
create type tpch.RegionType as
closed {
r_regionkey : integer,
r_name : string,
r_comment : string
-}
+};
create type tpch.PartType as
closed {
@@ -105,7 +105,7 @@ create type tpch.PartType as
p_container : string,
p_retailprice : double,
p_comment : string
-}
+};
create type tpch.PartSuppType as
closed {
@@ -114,7 +114,7 @@ create type tpch.PartSuppType as
ps_availqty : integer,
ps_supplycost : double,
ps_comment : string
-}
+};
create dataset LineItem(LineItemType) primary key l_orderkey,l_linenumber;
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/q15_top_supplier/q15_top_supplier.1.ddl.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/q15_top_supplier/q15_top_supplier.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/q15_top_supplier/q15_top_supplier.1.ddl.sqlpp
index 6cbdf11..ef52df8 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/q15_top_supplier/q15_top_supplier.1.ddl.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/q15_top_supplier/q15_top_supplier.1.ddl.sqlpp
@@ -41,7 +41,7 @@ create type tpch.LineItemType as
l_shipinstruct : string,
l_shipmode : string,
l_comment : string
-}
+};
create type tpch.OrderType as
closed {
@@ -54,7 +54,7 @@ create type tpch.OrderType as
o_clerk : string,
o_shippriority : bigint,
o_comment : string
-}
+};
create type tpch.CustomerType as
closed {
@@ -66,7 +66,7 @@ create type tpch.CustomerType as
c_acctbal : double,
c_mktsegment : string,
c_comment : string
-}
+};
create type tpch.SupplierType as
closed {
@@ -77,7 +77,7 @@ create type tpch.SupplierType as
s_phone : string,
s_acctbal : double,
s_comment : string
-}
+};
create type tpch.NationType as
closed {
@@ -85,14 +85,14 @@ create type tpch.NationType as
n_name : string,
n_regionkey : bigint,
n_comment : string
-}
+};
create type tpch.RegionType as
closed {
r_regionkey : bigint,
r_name : string,
r_comment : string
-}
+};
create type tpch.PartType as
closed {
@@ -105,7 +105,7 @@ create type tpch.PartType as
p_container : string,
p_retailprice : double,
p_comment : string
-}
+};
create type tpch.PartSuppType as
closed {
@@ -114,7 +114,7 @@ create type tpch.PartSuppType as
ps_availqty : bigint,
ps_supplycost : double,
ps_comment : string
-}
+};
create dataset LineItem(LineItemType) primary key l_orderkey,l_linenumber;
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/q16_parts_supplier_relationship/q16_parts_supplier_relationship.1.ddl.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/q16_parts_supplier_relationship/q16_parts_supplier_relationship.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/q16_parts_supplier_relationship/q16_parts_supplier_relationship.1.ddl.sqlpp
index 6cbdf11..ef52df8 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/q16_parts_supplier_relationship/q16_parts_supplier_relationship.1.ddl.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/q16_parts_supplier_relationship/q16_parts_supplier_relationship.1.ddl.sqlpp
@@ -41,7 +41,7 @@ create type tpch.LineItemType as
l_shipinstruct : string,
l_shipmode : string,
l_comment : string
-}
+};
create type tpch.OrderType as
closed {
@@ -54,7 +54,7 @@ create type tpch.OrderType as
o_clerk : string,
o_shippriority : bigint,
o_comment : string
-}
+};
create type tpch.CustomerType as
closed {
@@ -66,7 +66,7 @@ create type tpch.CustomerType as
c_acctbal : double,
c_mktsegment : string,
c_comment : string
-}
+};
create type tpch.SupplierType as
closed {
@@ -77,7 +77,7 @@ create type tpch.SupplierType as
s_phone : string,
s_acctbal : double,
s_comment : string
-}
+};
create type tpch.NationType as
closed {
@@ -85,14 +85,14 @@ create type tpch.NationType as
n_name : string,
n_regionkey : bigint,
n_comment : string
-}
+};
create type tpch.RegionType as
closed {
r_regionkey : bigint,
r_name : string,
r_comment : string
-}
+};
create type tpch.PartType as
closed {
@@ -105,7 +105,7 @@ create type tpch.PartType as
p_container : string,
p_retailprice : double,
p_comment : string
-}
+};
create type tpch.PartSuppType as
closed {
@@ -114,7 +114,7 @@ create type tpch.PartSuppType as
ps_availqty : bigint,
ps_supplycost : double,
ps_comment : string
-}
+};
create dataset LineItem(LineItemType) primary key l_orderkey,l_linenumber;
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/q17_large_gby_variant/q17_large_gby_variant.1.ddl.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/q17_large_gby_variant/q17_large_gby_variant.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/q17_large_gby_variant/q17_large_gby_variant.1.ddl.sqlpp
index 6cbdf11..ef52df8 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/q17_large_gby_variant/q17_large_gby_variant.1.ddl.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/q17_large_gby_variant/q17_large_gby_variant.1.ddl.sqlpp
@@ -41,7 +41,7 @@ create type tpch.LineItemType as
l_shipinstruct : string,
l_shipmode : string,
l_comment : string
-}
+};
create type tpch.OrderType as
closed {
@@ -54,7 +54,7 @@ create type tpch.OrderType as
o_clerk : string,
o_shippriority : bigint,
o_comment : string
-}
+};
create type tpch.CustomerType as
closed {
@@ -66,7 +66,7 @@ create type tpch.CustomerType as
c_acctbal : double,
c_mktsegment : string,
c_comment : string
-}
+};
create type tpch.SupplierType as
closed {
@@ -77,7 +77,7 @@ create type tpch.SupplierType as
s_phone : string,
s_acctbal : double,
s_comment : string
-}
+};
create type tpch.NationType as
closed {
@@ -85,14 +85,14 @@ create type tpch.NationType as
n_name : string,
n_regionkey : bigint,
n_comment : string
-}
+};
create type tpch.RegionType as
closed {
r_regionkey : bigint,
r_name : string,
r_comment : string
-}
+};
create type tpch.PartType as
closed {
@@ -105,7 +105,7 @@ create type tpch.PartType as
p_container : string,
p_retailprice : double,
p_comment : string
-}
+};
create type tpch.PartSuppType as
closed {
@@ -114,7 +114,7 @@ create type tpch.PartSuppType as
ps_availqty : bigint,
ps_supplycost : double,
ps_comment : string
-}
+};
create dataset LineItem(LineItemType) primary key l_orderkey,l_linenumber;
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/q17_small_quantity_order_revenue/q17_small_quantity_order_revenue.1.ddl.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/q17_small_quantity_order_revenue/q17_small_quantity_order_revenue.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/q17_small_quantity_order_revenue/q17_small_quantity_order_revenue.1.ddl.sqlpp
index 0db8d36..4ba3bef 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/q17_small_quantity_order_revenue/q17_small_quantity_order_revenue.1.ddl.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/q17_small_quantity_order_revenue/q17_small_quantity_order_revenue.1.ddl.sqlpp
@@ -41,7 +41,7 @@ create type tpch.LineItemType as
l_shipinstruct : string,
l_shipmode : string,
l_comment : string
-}
+};
create type tpch.OrderType as
closed {
@@ -54,7 +54,7 @@ create type tpch.OrderType as
o_clerk : string,
o_shippriority : integer,
o_comment : string
-}
+};
create type tpch.CustomerType as
closed {
@@ -66,7 +66,7 @@ create type tpch.CustomerType as
c_acctbal : double,
c_mktsegment : string,
c_comment : string
-}
+};
create type tpch.SupplierType as
closed {
@@ -77,7 +77,7 @@ create type tpch.SupplierType as
s_phone : string,
s_acctbal : double,
s_comment : string
-}
+};
create type tpch.NationType as
closed {
@@ -85,14 +85,14 @@ create type tpch.NationType as
n_name : string,
n_regionkey : integer,
n_comment : string
-}
+};
create type tpch.RegionType as
closed {
r_regionkey : integer,
r_name : string,
r_comment : string
-}
+};
create type tpch.PartType as
closed {
@@ -105,7 +105,7 @@ create type tpch.PartType as
p_container : string,
p_retailprice : double,
p_comment : string
-}
+};
create type tpch.PartSuppType as
closed {
@@ -114,7 +114,7 @@ create type tpch.PartSuppType as
ps_availqty : integer,
ps_supplycost : double,
ps_comment : string
-}
+};
create dataset LineItem(LineItemType) primary key l_orderkey,l_linenumber;
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/q18_large_volume_customer/q18_large_volume_customer.1.ddl.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/q18_large_volume_customer/q18_large_volume_customer.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/q18_large_volume_customer/q18_large_volume_customer.1.ddl.sqlpp
index 6cbdf11..ef52df8 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/q18_large_volume_customer/q18_large_volume_customer.1.ddl.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/q18_large_volume_customer/q18_large_volume_customer.1.ddl.sqlpp
@@ -41,7 +41,7 @@ create type tpch.LineItemType as
l_shipinstruct : string,
l_shipmode : string,
l_comment : string
-}
+};
create type tpch.OrderType as
closed {
@@ -54,7 +54,7 @@ create type tpch.OrderType as
o_clerk : string,
o_shippriority : bigint,
o_comment : string
-}
+};
create type tpch.CustomerType as
closed {
@@ -66,7 +66,7 @@ create type tpch.CustomerType as
c_acctbal : double,
c_mktsegment : string,
c_comment : string
-}
+};
create type tpch.SupplierType as
closed {
@@ -77,7 +77,7 @@ create type tpch.SupplierType as
s_phone : string,
s_acctbal : double,
s_comment : string
-}
+};
create type tpch.NationType as
closed {
@@ -85,14 +85,14 @@ create type tpch.NationType as
n_name : string,
n_regionkey : bigint,
n_comment : string
-}
+};
create type tpch.RegionType as
closed {
r_regionkey : bigint,
r_name : string,
r_comment : string
-}
+};
create type tpch.PartType as
closed {
@@ -105,7 +105,7 @@ create type tpch.PartType as
p_container : string,
p_retailprice : double,
p_comment : string
-}
+};
create type tpch.PartSuppType as
closed {
@@ -114,7 +114,7 @@ create type tpch.PartSuppType as
ps_availqty : bigint,
ps_supplycost : double,
ps_comment : string
-}
+};
create dataset LineItem(LineItemType) primary key l_orderkey,l_linenumber;
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/q19_discounted_revenue/q19_discounted_revenue.1.ddl.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/q19_discounted_revenue/q19_discounted_revenue.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/q19_discounted_revenue/q19_discounted_revenue.1.ddl.sqlpp
index 0db8d36..4ba3bef 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/q19_discounted_revenue/q19_discounted_revenue.1.ddl.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/q19_discounted_revenue/q19_discounted_revenue.1.ddl.sqlpp
@@ -41,7 +41,7 @@ create type tpch.LineItemType as
l_shipinstruct : string,
l_shipmode : string,
l_comment : string
-}
+};
create type tpch.OrderType as
closed {
@@ -54,7 +54,7 @@ create type tpch.OrderType as
o_clerk : string,
o_shippriority : integer,
o_comment : string
-}
+};
create type tpch.CustomerType as
closed {
@@ -66,7 +66,7 @@ create type tpch.CustomerType as
c_acctbal : double,
c_mktsegment : string,
c_comment : string
-}
+};
create type tpch.SupplierType as
closed {
@@ -77,7 +77,7 @@ create type tpch.SupplierType as
s_phone : string,
s_acctbal : double,
s_comment : string
-}
+};
create type tpch.NationType as
closed {
@@ -85,14 +85,14 @@ create type tpch.NationType as
n_name : string,
n_regionkey : integer,
n_comment : string
-}
+};
create type tpch.RegionType as
closed {
r_regionkey : integer,
r_name : string,
r_comment : string
-}
+};
create type tpch.PartType as
closed {
@@ -105,7 +105,7 @@ create type tpch.PartType as
p_container : string,
p_retailprice : double,
p_comment : string
-}
+};
create type tpch.PartSuppType as
closed {
@@ -114,7 +114,7 @@ create type tpch.PartSuppType as
ps_availqty : integer,
ps_supplycost : double,
ps_comment : string
-}
+};
create dataset LineItem(LineItemType) primary key l_orderkey,l_linenumber;
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/q20_potential_part_promotion/q20_potential_part_promotion.1.ddl.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/q20_potential_part_promotion/q20_potential_part_promotion.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/q20_potential_part_promotion/q20_potential_part_promotion.1.ddl.sqlpp
index 0db8d36..4ba3bef 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/q20_potential_part_promotion/q20_potential_part_promotion.1.ddl.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/q20_potential_part_promotion/q20_potential_part_promotion.1.ddl.sqlpp
@@ -41,7 +41,7 @@ create type tpch.LineItemType as
l_shipinstruct : string,
l_shipmode : string,
l_comment : string
-}
+};
create type tpch.OrderType as
closed {
@@ -54,7 +54,7 @@ create type tpch.OrderType as
o_clerk : string,
o_shippriority : integer,
o_comment : string
-}
+};
create type tpch.CustomerType as
closed {
@@ -66,7 +66,7 @@ create type tpch.CustomerType as
c_acctbal : double,
c_mktsegment : string,
c_comment : string
-}
+};
create type tpch.SupplierType as
closed {
@@ -77,7 +77,7 @@ create type tpch.SupplierType as
s_phone : string,
s_acctbal : double,
s_comment : string
-}
+};
create type tpch.NationType as
closed {
@@ -85,14 +85,14 @@ create type tpch.NationType as
n_name : string,
n_regionkey : integer,
n_comment : string
-}
+};
create type tpch.RegionType as
closed {
r_regionkey : integer,
r_name : string,
r_comment : string
-}
+};
create type tpch.PartType as
closed {
@@ -105,7 +105,7 @@ create type tpch.PartType as
p_container : string,
p_retailprice : double,
p_comment : string
-}
+};
create type tpch.PartSuppType as
closed {
@@ -114,7 +114,7 @@ create type tpch.PartSuppType as
ps_availqty : integer,
ps_supplycost : double,
ps_comment : string
-}
+};
create dataset LineItem(LineItemType) primary key l_orderkey,l_linenumber;
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/q21_suppliers_who_kept_orders_waiting/q21_suppliers_who_kept_orders_waiting.1.ddl.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/q21_suppliers_who_kept_orders_waiting/q21_suppliers_who_kept_orders_waiting.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/q21_suppliers_who_kept_orders_waiting/q21_suppliers_who_kept_orders_waiting.1.ddl.sqlpp
index 6cbdf11..ef52df8 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/q21_suppliers_who_kept_orders_waiting/q21_suppliers_who_kept_orders_waiting.1.ddl.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/q21_suppliers_who_kept_orders_waiting/q21_suppliers_who_kept_orders_waiting.1.ddl.sqlpp
@@ -41,7 +41,7 @@ create type tpch.LineItemType as
l_shipinstruct : string,
l_shipmode : string,
l_comment : string
-}
+};
create type tpch.OrderType as
closed {
@@ -54,7 +54,7 @@ create type tpch.OrderType as
o_clerk : string,
o_shippriority : bigint,
o_comment : string
-}
+};
create type tpch.CustomerType as
closed {
@@ -66,7 +66,7 @@ create type tpch.CustomerType as
c_acctbal : double,
c_mktsegment : string,
c_comment : string
-}
+};
create type tpch.SupplierType as
closed {
@@ -77,7 +77,7 @@ create type tpch.SupplierType as
s_phone : string,
s_acctbal : double,
s_comment : string
-}
+};
create type tpch.NationType as
closed {
@@ -85,14 +85,14 @@ create type tpch.NationType as
n_name : string,
n_regionkey : bigint,
n_comment : string
-}
+};
create type tpch.RegionType as
closed {
r_regionkey : bigint,
r_name : string,
r_comment : string
-}
+};
create type tpch.PartType as
closed {
@@ -105,7 +105,7 @@ create type tpch.PartType as
p_container : string,
p_retailprice : double,
p_comment : string
-}
+};
create type tpch.PartSuppType as
closed {
@@ -114,7 +114,7 @@ create type tpch.PartSuppType as
ps_availqty : bigint,
ps_supplycost : double,
ps_comment : string
-}
+};
create dataset LineItem(LineItemType) primary key l_orderkey,l_linenumber;
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/q22_global_sales_opportunity/q22_global_sales_opportunity.1.ddl.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/q22_global_sales_opportunity/q22_global_sales_opportunity.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/q22_global_sales_opportunity/q22_global_sales_opportunity.1.ddl.sqlpp
index 0db8d36..4ba3bef 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/q22_global_sales_opportunity/q22_global_sales_opportunity.1.ddl.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/q22_global_sales_opportunity/q22_global_sales_opportunity.1.ddl.sqlpp
@@ -41,7 +41,7 @@ create type tpch.LineItemType as
l_shipinstruct : string,
l_shipmode : string,
l_comment : string
-}
+};
create type tpch.OrderType as
closed {
@@ -54,7 +54,7 @@ create type tpch.OrderType as
o_clerk : string,
o_shippriority : integer,
o_comment : string
-}
+};
create type tpch.CustomerType as
closed {
@@ -66,7 +66,7 @@ create type tpch.CustomerType as
c_acctbal : double,
c_mktsegment : string,
c_comment : string
-}
+};
create type tpch.SupplierType as
closed {
@@ -77,7 +77,7 @@ create type tpch.SupplierType as
s_phone : string,
s_acctbal : double,
s_comment : string
-}
+};
create type tpch.NationType as
closed {
@@ -85,14 +85,14 @@ create type tpch.NationType as
n_name : string,
n_regionkey : integer,
n_comment : string
-}
+};
create type tpch.RegionType as
closed {
r_regionkey : integer,
r_name : string,
r_comment : string
-}
+};
create type tpch.PartType as
closed {
@@ -105,7 +105,7 @@ create type tpch.PartType as
p_container : string,
p_retailprice : double,
p_comment : string
-}
+};
create type tpch.PartSuppType as
closed {
@@ -114,7 +114,7 @@ create type tpch.PartSuppType as
ps_availqty : integer,
ps_supplycost : double,
ps_comment : string
-}
+};
create dataset LineItem(LineItemType) primary key l_orderkey,l_linenumber;
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/query-issue562/query-issue562.1.ddl.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/query-issue562/query-issue562.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/query-issue562/query-issue562.1.ddl.sqlpp
index 98ee9a2..7ea7980 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/query-issue562/query-issue562.1.ddl.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/query-issue562/query-issue562.1.ddl.sqlpp
@@ -47,7 +47,7 @@ create type tpch.LineItemType as
l_shipinstruct : string,
l_shipmode : string,
l_comment : string
-}
+};
create type tpch.OrderType as
closed {
@@ -60,7 +60,7 @@ create type tpch.OrderType as
o_clerk : string,
o_shippriority : integer,
o_comment : string
-}
+};
create type tpch.CustomerType as
closed {
@@ -72,7 +72,7 @@ create type tpch.CustomerType as
c_acctbal : double,
c_mktsegment : string,
c_comment : string
-}
+};
create type tpch.SupplierType as
closed {
@@ -83,7 +83,7 @@ create type tpch.SupplierType as
s_phone : string,
s_acctbal : double,
s_comment : string
-}
+};
create type tpch.NationType as
closed {
@@ -91,14 +91,14 @@ create type tpch.NationType as
n_name : string,
n_regionkey : integer,
n_comment : string
-}
+};
create type tpch.RegionType as
closed {
r_regionkey : integer,
r_name : string,
r_comment : string
-}
+};
create type tpch.PartType as
closed {
@@ -111,7 +111,7 @@ create type tpch.PartType as
p_container : string,
p_retailprice : double,
p_comment : string
-}
+};
create type tpch.PartSuppType as
closed {
@@ -120,7 +120,7 @@ create type tpch.PartSuppType as
ps_availqty : integer,
ps_supplycost : double,
ps_comment : string
-}
+};
create dataset LineItem(LineItemType) primary key l_orderkey,l_linenumber;
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/query-issue601/query-issue601.1.ddl.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/query-issue601/query-issue601.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/query-issue601/query-issue601.1.ddl.sqlpp
index b4d7fb4..758e645 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/query-issue601/query-issue601.1.ddl.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/query-issue601/query-issue601.1.ddl.sqlpp
@@ -47,7 +47,7 @@ create type tpch.LineItemType as
l_shipinstruct : string,
l_shipmode : string,
l_comment : string
-}
+};
create dataset LineItem(LineItemType) primary key l_orderkey,l_linenumber;
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/query-issue638/query-issue638.1.ddl.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/query-issue638/query-issue638.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/query-issue638/query-issue638.1.ddl.sqlpp
index 84121b9..9898629 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/query-issue638/query-issue638.1.ddl.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/query-issue638/query-issue638.1.ddl.sqlpp
@@ -47,7 +47,7 @@ create type tpch.LineItemType as
l_shipinstruct : string,
l_shipmode : string,
l_comment : string
-}
+};
create type tpch.OrderType as
closed {
@@ -60,7 +60,7 @@ create type tpch.OrderType as
o_clerk : string,
o_shippriority : integer,
o_comment : string
-}
+};
create type tpch.CustomerType as
closed {
@@ -72,7 +72,7 @@ create type tpch.CustomerType as
c_acctbal : double,
c_mktsegment : string,
c_comment : string
-}
+};
create type tpch.SupplierType as
closed {
@@ -83,7 +83,7 @@ create type tpch.SupplierType as
s_phone : string,
s_acctbal : double,
s_comment : string
-}
+};
create type tpch.NationType as
closed {
@@ -91,14 +91,14 @@ create type tpch.NationType as
n_name : string,
n_regionkey : integer,
n_comment : string
-}
+};
create type tpch.RegionType as
closed {
r_regionkey : integer,
r_name : string,
r_comment : string
-}
+};
create type tpch.PartType as
closed {
@@ -111,7 +111,7 @@ create type tpch.PartType as
p_container : string,
p_retailprice : double,
p_comment : string
-}
+};
create type tpch.PartSuppType as
closed {
@@ -120,7 +120,7 @@ create type tpch.PartSuppType as
ps_availqty : integer,
ps_supplycost : double,
ps_comment : string
-}
+};
create external dataset LineItem(LineItemType) using `localfs`((`path`=`asterix_nc1://data/tpch0.001/lineitem.tbl`),(`format`=`delimited-text`),(`delimiter`=`|`));
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/query-issue785-2/query-issue785-2.1.ddl.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/query-issue785-2/query-issue785-2.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/query-issue785-2/query-issue785-2.1.ddl.sqlpp
index 65152ef..73a2341 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/query-issue785-2/query-issue785-2.1.ddl.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/query-issue785-2/query-issue785-2.1.ddl.sqlpp
@@ -40,7 +40,7 @@ create type tpch.OrderType as
o_clerk : string,
o_shippriority : bigint,
o_comment : string
-}
+};
create type tpch.CustomerType as
closed {
@@ -52,7 +52,7 @@ create type tpch.CustomerType as
c_acctbal : double,
c_mktsegment : string,
c_comment : string
-}
+};
create type tpch.SupplierType as
closed {
@@ -63,7 +63,7 @@ create type tpch.SupplierType as
s_phone : string,
s_acctbal : double,
s_comment : string
-}
+};
create type tpch.NationType as
closed {
@@ -71,14 +71,14 @@ create type tpch.NationType as
n_name : string,
n_regionkey : bigint,
n_comment : string
-}
+};
create type tpch.RegionType as
closed {
r_regionkey : bigint,
r_name : string,
r_comment : string
-}
+};
create dataset Orders(OrderType) primary key o_orderkey;
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/query-issue785/query-issue785.1.ddl.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/query-issue785/query-issue785.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/query-issue785/query-issue785.1.ddl.sqlpp
index 65152ef..73a2341 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/query-issue785/query-issue785.1.ddl.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/query-issue785/query-issue785.1.ddl.sqlpp
@@ -40,7 +40,7 @@ create type tpch.OrderType as
o_clerk : string,
o_shippriority : bigint,
o_comment : string
-}
+};
create type tpch.CustomerType as
closed {
@@ -52,7 +52,7 @@ create type tpch.CustomerType as
c_acctbal : double,
c_mktsegment : string,
c_comment : string
-}
+};
create type tpch.SupplierType as
closed {
@@ -63,7 +63,7 @@ create type tpch.SupplierType as
s_phone : string,
s_acctbal : double,
s_comment : string
-}
+};
create type tpch.NationType as
closed {
@@ -71,14 +71,14 @@ create type tpch.NationType as
n_name : string,
n_regionkey : bigint,
n_comment : string
-}
+};
create type tpch.RegionType as
closed {
r_regionkey : bigint,
r_name : string,
r_comment : string
-}
+};
create dataset Orders(OrderType) primary key o_orderkey;
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/query-issue786/query-issue786.1.ddl.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/query-issue786/query-issue786.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/query-issue786/query-issue786.1.ddl.sqlpp
index 2f927dd..fb751d0 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/query-issue786/query-issue786.1.ddl.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/query-issue786/query-issue786.1.ddl.sqlpp
@@ -40,7 +40,7 @@ create type tpch.OrderType as
o_clerk : string,
o_shippriority : integer,
o_comment : string
-}
+};
create type tpch.CustomerType as
closed {
@@ -52,7 +52,7 @@ create type tpch.CustomerType as
c_acctbal : double,
c_mktsegment : string,
c_comment : string
-}
+};
create type tpch.SupplierType as
closed {
@@ -63,7 +63,7 @@ create type tpch.SupplierType as
s_phone : string,
s_acctbal : double,
s_comment : string
-}
+};
create type tpch.NationType as
closed {
@@ -71,14 +71,14 @@ create type tpch.NationType as
n_name : string,
n_regionkey : integer,
n_comment : string
-}
+};
create type tpch.RegionType as
closed {
r_regionkey : integer,
r_name : string,
r_comment : string
-}
+};
create dataset Orders(OrderType) primary key o_orderkey;
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/query-issue810-2/query-issue810-2.1.ddl.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/query-issue810-2/query-issue810-2.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/query-issue810-2/query-issue810-2.1.ddl.sqlpp
index b2a395f..655b6c7 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/query-issue810-2/query-issue810-2.1.ddl.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/query-issue810-2/query-issue810-2.1.ddl.sqlpp
@@ -47,7 +47,7 @@ create type tpch.LineItemType as
l_shipinstruct : string,
l_shipmode : string,
l_comment : string
-}
+};
create dataset LineItem(LineItemType) primary key l_orderkey,l_linenumber;
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/query-issue810-3/query-issue810-3.1.ddl.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/query-issue810-3/query-issue810-3.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/query-issue810-3/query-issue810-3.1.ddl.sqlpp
index b2a395f..655b6c7 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/query-issue810-3/query-issue810-3.1.ddl.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/query-issue810-3/query-issue810-3.1.ddl.sqlpp
@@ -47,7 +47,7 @@ create type tpch.LineItemType as
l_shipinstruct : string,
l_shipmode : string,
l_comment : string
-}
+};
create dataset LineItem(LineItemType) primary key l_orderkey,l_linenumber;
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/query-issue810/query-issue810.1.ddl.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/query-issue810/query-issue810.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/query-issue810/query-issue810.1.ddl.sqlpp
index b2a395f..655b6c7 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/query-issue810/query-issue810.1.ddl.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql/query-issue810/query-issue810.1.ddl.sqlpp
@@ -47,7 +47,7 @@ create type tpch.LineItemType as
l_shipinstruct : string,
l_shipmode : string,
l_comment : string
-}
+};
create dataset LineItem(LineItemType) primary key l_orderkey,l_linenumber;
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/distinct_by/distinct_by.1.ddl.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/distinct_by/distinct_by.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/distinct_by/distinct_by.1.ddl.sqlpp
index c6c77fb..3539fa6 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/distinct_by/distinct_by.1.ddl.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/distinct_by/distinct_by.1.ddl.sqlpp
@@ -41,7 +41,7 @@ create type tpch.LineItemType as
l_shipinstruct : string,
l_shipmode : string,
l_comment : string
-}
+};
create dataset LineItem(LineItemType) primary key l_orderkey,l_linenumber;
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/nest_aggregate/nest_aggregate.1.ddl.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/nest_aggregate/nest_aggregate.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/nest_aggregate/nest_aggregate.1.ddl.sqlpp
index fb985a5..c29a125 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/nest_aggregate/nest_aggregate.1.ddl.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/nest_aggregate/nest_aggregate.1.ddl.sqlpp
@@ -40,7 +40,7 @@ create type tpch.OrderType as
o_clerk : string,
o_shippriority : bigint,
o_comment : string
-}
+};
create type tpch.CustomerType as
closed {
@@ -52,7 +52,7 @@ create type tpch.CustomerType as
c_acctbal : double,
c_mktsegment : string,
c_comment : string
-}
+};
create type tpch.SupplierType as
closed {
@@ -63,7 +63,7 @@ create type tpch.SupplierType as
s_phone : string,
s_acctbal : double,
s_comment : string
-}
+};
create type tpch.NationType as
closed {
@@ -71,14 +71,14 @@ create type tpch.NationType as
n_name : string,
n_regionkey : bigint,
n_comment : string
-}
+};
create type tpch.RegionType as
closed {
r_regionkey : bigint,
r_name : string,
r_comment : string
-}
+};
create dataset Orders(OrderType) primary key o_orderkey;
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/nest_aggregate2/nest_aggregate2.1.ddl.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/nest_aggregate2/nest_aggregate2.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/nest_aggregate2/nest_aggregate2.1.ddl.sqlpp
index fb985a5..c29a125 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/nest_aggregate2/nest_aggregate2.1.ddl.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/nest_aggregate2/nest_aggregate2.1.ddl.sqlpp
@@ -40,7 +40,7 @@ create type tpch.OrderType as
o_clerk : string,
o_shippriority : bigint,
o_comment : string
-}
+};
create type tpch.CustomerType as
closed {
@@ -52,7 +52,7 @@ create type tpch.CustomerType as
c_acctbal : double,
c_mktsegment : string,
c_comment : string
-}
+};
create type tpch.SupplierType as
closed {
@@ -63,7 +63,7 @@ create type tpch.SupplierType as
s_phone : string,
s_acctbal : double,
s_comment : string
-}
+};
create type tpch.NationType as
closed {
@@ -71,14 +71,14 @@ create type tpch.NationType as
n_name : string,
n_regionkey : bigint,
n_comment : string
-}
+};
create type tpch.RegionType as
closed {
r_regionkey : bigint,
r_name : string,
r_comment : string
-}
+};
create dataset Orders(OrderType) primary key o_orderkey;
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/q01_pricing_summary_report_nt/q01_pricing_summary_report_nt.1.ddl.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/q01_pricing_summary_report_nt/q01_pricing_summary_report_nt.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/q01_pricing_summary_report_nt/q01_pricing_summary_report_nt.1.ddl.sqlpp
index 0f2b8c8..3412f89 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/q01_pricing_summary_report_nt/q01_pricing_summary_report_nt.1.ddl.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/q01_pricing_summary_report_nt/q01_pricing_summary_report_nt.1.ddl.sqlpp
@@ -41,7 +41,7 @@ create type tpch.LineItemType as
l_shipinstruct : string,
l_shipmode : string,
l_comment : string
-}
+};
create dataset LineItem(LineItemType) primary key l_orderkey,l_linenumber;
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/q01_pricing_summary_report_nt/q01_pricing_summary_report_nt.3.query.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/q01_pricing_summary_report_nt/q01_pricing_summary_report_nt.3.query.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/q01_pricing_summary_report_nt/q01_pricing_summary_report_nt.3.query.sqlpp
index e42ce21..f47341a 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/q01_pricing_summary_report_nt/q01_pricing_summary_report_nt.3.query.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/q01_pricing_summary_report_nt/q01_pricing_summary_report_nt.3.query.sqlpp
@@ -19,7 +19,7 @@
use tpch;
-set hash_merge "true"
+set hash_merge "true";
select element {'l_returnflag':l_returnflag,'l_linestatus':l_linestatus,'sum_qty':COLL_SUM((
select element i.l.l_quantity
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/q02_minimum_cost_supplier/q02_minimum_cost_supplier.1.ddl.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/q02_minimum_cost_supplier/q02_minimum_cost_supplier.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/q02_minimum_cost_supplier/q02_minimum_cost_supplier.1.ddl.sqlpp
index a9f2b9b..d4131b4 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/q02_minimum_cost_supplier/q02_minimum_cost_supplier.1.ddl.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/q02_minimum_cost_supplier/q02_minimum_cost_supplier.1.ddl.sqlpp
@@ -41,7 +41,7 @@ create type tpch.LineItemType as
l_shipinstruct : string,
l_shipmode : string,
l_comment : string
-}
+};
create type tpch.OrderType as
closed {
@@ -54,7 +54,7 @@ create type tpch.OrderType as
o_clerk : string,
o_shippriority : bigint,
o_comment : string
-}
+};
create type tpch.CustomerType as
closed {
@@ -66,7 +66,7 @@ create type tpch.CustomerType as
c_acctbal : double,
c_mktsegment : string,
c_comment : string
-}
+};
create type tpch.SupplierType as
closed {
@@ -77,7 +77,7 @@ create type tpch.SupplierType as
s_phone : string,
s_acctbal : double,
s_comment : string
-}
+};
create type tpch.NationType as
closed {
@@ -85,14 +85,14 @@ create type tpch.NationType as
n_name : string,
n_regionkey : bigint,
n_comment : string
-}
+};
create type tpch.RegionType as
closed {
r_regionkey : bigint,
r_name : string,
r_comment : string
-}
+};
create type tpch.PartType as
closed {
@@ -105,7 +105,7 @@ create type tpch.PartType as
p_container : string,
p_retailprice : double,
p_comment : string
-}
+};
create type tpch.PartSuppType as
closed {
@@ -114,7 +114,7 @@ create type tpch.PartSuppType as
ps_availqty : bigint,
ps_supplycost : double,
ps_comment : string
-}
+};
create dataset LineItem(LineItemType) primary key l_orderkey,l_linenumber;
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/q03_shipping_priority_nt/q03_shipping_priority_nt.1.ddl.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/q03_shipping_priority_nt/q03_shipping_priority_nt.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/q03_shipping_priority_nt/q03_shipping_priority_nt.1.ddl.sqlpp
index 56612a4..472c27e 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/q03_shipping_priority_nt/q03_shipping_priority_nt.1.ddl.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/q03_shipping_priority_nt/q03_shipping_priority_nt.1.ddl.sqlpp
@@ -41,7 +41,7 @@ create type tpch.LineItemType as
l_shipinstruct : string,
l_shipmode : string,
l_comment : string
-}
+};
create type tpch.OrderType as
closed {
@@ -54,7 +54,7 @@ create type tpch.OrderType as
o_clerk : string,
o_shippriority : bigint,
o_comment : string
-}
+};
create type tpch.CustomerType as
closed {
@@ -66,7 +66,7 @@ create type tpch.CustomerType as
c_acctbal : double,
c_mktsegment : string,
c_comment : string
-}
+};
create type tpch.SupplierType as
closed {
@@ -77,7 +77,7 @@ create type tpch.SupplierType as
s_phone : string,
s_acctbal : double,
s_comment : string
-}
+};
create type tpch.NationType as
closed {
@@ -85,14 +85,14 @@ create type tpch.NationType as
n_name : string,
n_regionkey : bigint,
n_comment : string
-}
+};
create type tpch.RegionType as
closed {
r_regionkey : bigint,
r_name : string,
r_comment : string
-}
+};
create type tpch.PartType as
closed {
@@ -105,7 +105,7 @@ create type tpch.PartType as
p_container : string,
p_retailprice : double,
p_comment : string
-}
+};
create type tpch.PartSuppType as
closed {
@@ -114,7 +114,7 @@ create type tpch.PartSuppType as
ps_availqty : bigint,
ps_supplycost : double,
ps_comment : string
-}
+};
create dataset LineItem(LineItemType) primary key l_orderkey,l_linenumber;
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/q04_order_priority/q04_order_priority.1.ddl.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/q04_order_priority/q04_order_priority.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/q04_order_priority/q04_order_priority.1.ddl.sqlpp
index 56612a4..472c27e 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/q04_order_priority/q04_order_priority.1.ddl.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/q04_order_priority/q04_order_priority.1.ddl.sqlpp
@@ -41,7 +41,7 @@ create type tpch.LineItemType as
l_shipinstruct : string,
l_shipmode : string,
l_comment : string
-}
+};
create type tpch.OrderType as
closed {
@@ -54,7 +54,7 @@ create type tpch.OrderType as
o_clerk : string,
o_shippriority : bigint,
o_comment : string
-}
+};
create type tpch.CustomerType as
closed {
@@ -66,7 +66,7 @@ create type tpch.CustomerType as
c_acctbal : double,
c_mktsegment : string,
c_comment : string
-}
+};
create type tpch.SupplierType as
closed {
@@ -77,7 +77,7 @@ create type tpch.SupplierType as
s_phone : string,
s_acctbal : double,
s_comment : string
-}
+};
create type tpch.NationType as
closed {
@@ -85,14 +85,14 @@ create type tpch.NationType as
n_name : string,
n_regionkey : bigint,
n_comment : string
-}
+};
create type tpch.RegionType as
closed {
r_regionkey : bigint,
r_name : string,
r_comment : string
-}
+};
create type tpch.PartType as
closed {
@@ -105,7 +105,7 @@ create type tpch.PartType as
p_container : string,
p_retailprice : double,
p_comment : string
-}
+};
create type tpch.PartSuppType as
closed {
@@ -114,7 +114,7 @@ create type tpch.PartSuppType as
ps_availqty : bigint,
ps_supplycost : double,
ps_comment : string
-}
+};
create dataset LineItem(LineItemType) primary key l_orderkey,l_linenumber;
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/q04_order_priority_with_nodegroup/q04_order_priority_with_nodegroup.1.ddl.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/q04_order_priority_with_nodegroup/q04_order_priority_with_nodegroup.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/q04_order_priority_with_nodegroup/q04_order_priority_with_nodegroup.1.ddl.sqlpp
index dc314f7..5fbc67b 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/q04_order_priority_with_nodegroup/q04_order_priority_with_nodegroup.1.ddl.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/q04_order_priority_with_nodegroup/q04_order_priority_with_nodegroup.1.ddl.sqlpp
@@ -41,7 +41,7 @@ create type tpch.LineItemType as
l_shipinstruct : string,
l_shipmode : string,
l_comment : string
-}
+};
create type tpch.OrderType as
closed {
@@ -54,7 +54,7 @@ create type tpch.OrderType as
o_clerk : string,
o_shippriority : bigint,
o_comment : string
-}
+};
create type tpch.CustomerType as
closed {
@@ -66,7 +66,7 @@ create type tpch.CustomerType as
c_acctbal : double,
c_mktsegment : string,
c_comment : string
-}
+};
create type tpch.SupplierType as
closed {
@@ -77,7 +77,7 @@ create type tpch.SupplierType as
s_phone : string,
s_acctbal : double,
s_comment : string
-}
+};
create type tpch.NationType as
closed {
@@ -85,14 +85,14 @@ create type tpch.NationType as
n_name : string,
n_regionkey : bigint,
n_comment : string
-}
+};
create type tpch.RegionType as
closed {
r_regionkey : bigint,
r_name : string,
r_comment : string
-}
+};
create type tpch.PartType as
closed {
@@ -105,7 +105,7 @@ create type tpch.PartType as
p_container : string,
p_retailprice : double,
p_comment : string
-}
+};
create type tpch.PartSuppType as
closed {
@@ -114,7 +114,7 @@ create type tpch.PartSuppType as
ps_availqty : bigint,
ps_supplycost : double,
ps_comment : string
-}
+};
drop nodegroup group_test if exists;
create nodegroup group_test on
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/q04_order_priority_with_nodegroup/q04_order_priority_with_nodegroup.4.ddl.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/q04_order_priority_with_nodegroup/q04_order_priority_with_nodegroup.4.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/q04_order_priority_with_nodegroup/q04_order_priority_with_nodegroup.4.ddl.sqlpp
index cd8adc2..e2215fc 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/q04_order_priority_with_nodegroup/q04_order_priority_with_nodegroup.4.ddl.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/q04_order_priority_with_nodegroup/q04_order_priority_with_nodegroup.4.ddl.sqlpp
@@ -18,4 +18,4 @@
*/
drop dataverse tpch if exists;
-drop nodegroup group_test if exists;
\ No newline at end of file
+drop nodegroup group_test if exists;
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/q05_local_supplier_volume/q05_local_supplier_volume.1.ddl.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/q05_local_supplier_volume/q05_local_supplier_volume.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/q05_local_supplier_volume/q05_local_supplier_volume.1.ddl.sqlpp
index 4e176f4..d3189b8 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/q05_local_supplier_volume/q05_local_supplier_volume.1.ddl.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/q05_local_supplier_volume/q05_local_supplier_volume.1.ddl.sqlpp
@@ -41,7 +41,7 @@ create type tpch.LineItemType as
l_shipinstruct : string,
l_shipmode : string,
l_comment : string
-}
+};
create type tpch.OrderType as
closed {
@@ -54,7 +54,7 @@ create type tpch.OrderType as
o_clerk : string,
o_shippriority : integer,
o_comment : string
-}
+};
create type tpch.CustomerType as
closed {
@@ -66,7 +66,7 @@ create type tpch.CustomerType as
c_acctbal : double,
c_mktsegment : string,
c_comment : string
-}
+};
create type tpch.SupplierType as
closed {
@@ -77,7 +77,7 @@ create type tpch.SupplierType as
s_phone : string,
s_acctbal : double,
s_comment : string
-}
+};
create type tpch.NationType as
closed {
@@ -85,14 +85,14 @@ create type tpch.NationType as
n_name : string,
n_regionkey : integer,
n_comment : string
-}
+};
create type tpch.RegionType as
closed {
r_regionkey : integer,
r_name : string,
r_comment : string
-}
+};
create type tpch.PartType as
closed {
@@ -105,7 +105,7 @@ create type tpch.PartType as
p_container : string,
p_retailprice : double,
p_comment : string
-}
+};
create type tpch.PartSuppType as
closed {
@@ -114,7 +114,7 @@ create type tpch.PartSuppType as
ps_availqty : integer,
ps_supplycost : double,
ps_comment : string
-}
+};
create dataset LineItem(LineItemType) primary key l_orderkey,l_linenumber;
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/q06_forecast_revenue_change/q06_forecast_revenue_change.1.ddl.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/q06_forecast_revenue_change/q06_forecast_revenue_change.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/q06_forecast_revenue_change/q06_forecast_revenue_change.1.ddl.sqlpp
index e2ac428..f84d6a6 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/q06_forecast_revenue_change/q06_forecast_revenue_change.1.ddl.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/q06_forecast_revenue_change/q06_forecast_revenue_change.1.ddl.sqlpp
@@ -41,7 +41,7 @@ create type tpch.LineItemType as
l_shipinstruct : string,
l_shipmode : string,
l_comment : string
-}
+};
create type tpch.OrderType as
closed {
@@ -54,7 +54,7 @@ create type tpch.OrderType as
o_clerk : string,
o_shippriority : integer,
o_comment : string
-}
+};
create type tpch.CustomerType as
closed {
@@ -66,7 +66,7 @@ create type tpch.CustomerType as
c_acctbal : double,
c_mktsegment : string,
c_comment : string
-}
+};
create type tpch.SupplierType as
closed {
@@ -77,7 +77,7 @@ create type tpch.SupplierType as
s_phone : string,
s_acctbal : double,
s_comment : string
-}
+};
create type tpch.NationType as
closed {
@@ -85,14 +85,14 @@ create type tpch.NationType as
n_name : string,
n_regionkey : integer,
n_comment : string
-}
+};
create type tpch.RegionType as
closed {
r_regionkey : integer,
r_name : string,
r_comment : string
-}
+};
create type tpch.PartType as
closed {
@@ -105,7 +105,7 @@ create type tpch.PartType as
p_container : string,
p_retailprice : double,
p_comment : string
-}
+};
create type tpch.PartSuppType as
closed {
@@ -114,7 +114,7 @@ create type tpch.PartSuppType as
ps_availqty : integer,
ps_supplycost : double,
ps_comment : string
-}
+};
create dataset LineItem(LineItemType) primary key l_orderkey,l_linenumber;
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/q07_volume_shipping/q07_volume_shipping.1.ddl.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/q07_volume_shipping/q07_volume_shipping.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/q07_volume_shipping/q07_volume_shipping.1.ddl.sqlpp
index 4e176f4..d3189b8 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/q07_volume_shipping/q07_volume_shipping.1.ddl.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/q07_volume_shipping/q07_volume_shipping.1.ddl.sqlpp
@@ -41,7 +41,7 @@ create type tpch.LineItemType as
l_shipinstruct : string,
l_shipmode : string,
l_comment : string
-}
+};
create type tpch.OrderType as
closed {
@@ -54,7 +54,7 @@ create type tpch.OrderType as
o_clerk : string,
o_shippriority : integer,
o_comment : string
-}
+};
create type tpch.CustomerType as
closed {
@@ -66,7 +66,7 @@ create type tpch.CustomerType as
c_acctbal : double,
c_mktsegment : string,
c_comment : string
-}
+};
create type tpch.SupplierType as
closed {
@@ -77,7 +77,7 @@ create type tpch.SupplierType as
s_phone : string,
s_acctbal : double,
s_comment : string
-}
+};
create type tpch.NationType as
closed {
@@ -85,14 +85,14 @@ create type tpch.NationType as
n_name : string,
n_regionkey : integer,
n_comment : string
-}
+};
create type tpch.RegionType as
closed {
r_regionkey : integer,
r_name : string,
r_comment : string
-}
+};
create type tpch.PartType as
closed {
@@ -105,7 +105,7 @@ create type tpch.PartType as
p_container : string,
p_retailprice : double,
p_comment : string
-}
+};
create type tpch.PartSuppType as
closed {
@@ -114,7 +114,7 @@ create type tpch.PartSuppType as
ps_availqty : integer,
ps_supplycost : double,
ps_comment : string
-}
+};
create dataset LineItem(LineItemType) primary key l_orderkey,l_linenumber;
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/q08_national_market_share/q08_national_market_share.1.ddl.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/q08_national_market_share/q08_national_market_share.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/q08_national_market_share/q08_national_market_share.1.ddl.sqlpp
index 4e176f4..d3189b8 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/q08_national_market_share/q08_national_market_share.1.ddl.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/q08_national_market_share/q08_national_market_share.1.ddl.sqlpp
@@ -41,7 +41,7 @@ create type tpch.LineItemType as
l_shipinstruct : string,
l_shipmode : string,
l_comment : string
-}
+};
create type tpch.OrderType as
closed {
@@ -54,7 +54,7 @@ create type tpch.OrderType as
o_clerk : string,
o_shippriority : integer,
o_comment : string
-}
+};
create type tpch.CustomerType as
closed {
@@ -66,7 +66,7 @@ create type tpch.CustomerType as
c_acctbal : double,
c_mktsegment : string,
c_comment : string
-}
+};
create type tpch.SupplierType as
closed {
@@ -77,7 +77,7 @@ create type tpch.SupplierType as
s_phone : string,
s_acctbal : double,
s_comment : string
-}
+};
create type tpch.NationType as
closed {
@@ -85,14 +85,14 @@ create type tpch.NationType as
n_name : string,
n_regionkey : integer,
n_comment : string
-}
+};
create type tpch.RegionType as
closed {
r_regionkey : integer,
r_name : string,
r_comment : string
-}
+};
create type tpch.PartType as
closed {
@@ -105,7 +105,7 @@ create type tpch.PartType as
p_container : string,
p_retailprice : double,
p_comment : string
-}
+};
create type tpch.PartSuppType as
closed {
@@ -114,7 +114,7 @@ create type tpch.PartSuppType as
ps_availqty : integer,
ps_supplycost : double,
ps_comment : string
-}
+};
create dataset LineItem(LineItemType) primary key l_orderkey,l_linenumber;