http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/custord/customer_q_05/customer_q_05.1.ddl.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/custord/customer_q_05/customer_q_05.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/custord/customer_q_05/customer_q_05.1.ddl.sqlpp index b027a9c..3d78d5d 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/custord/customer_q_05/customer_q_05.1.ddl.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/custord/customer_q_05/customer_q_05.1.ddl.sqlpp @@ -25,20 +25,20 @@ use test; create type test.AddressType as { - number : int32, + number : integer, street : string, city : string } create type test.CustomerType as closed { - cid : int64, + cid : bigint, name : string, - cashBack : int64, - age : int64?, + cashBack : bigint, + age : bigint?, address : AddressType?, lastorder : { - oid : int64, + oid : bigint, total : float }
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/custord/customer_q_05/customer_q_05.3.query.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/custord/customer_q_05/customer_q_05.3.query.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/custord/customer_q_05/customer_q_05.3.query.sqlpp index 5b33254..fcadfa0 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/custord/customer_q_05/customer_q_05.3.query.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/custord/customer_q_05/customer_q_05.3.query.sqlpp @@ -23,5 +23,5 @@ use test; select element {'custname':c.name,'age':c.age,'MathAge':rec} from Customers as c with rec as {'age':c.age,'age+5':(c.age + 5),'age-5':(c.age - 5),'age*5':(c.age * 5),'age/5':(c.age / 5),'-age':-c.age} -where (c.cid >= test.int32('3')) +where (c.cid >= test.integer('3')) ; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/custord/customer_q_06/customer_q_06.1.ddl.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/custord/customer_q_06/customer_q_06.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/custord/customer_q_06/customer_q_06.1.ddl.sqlpp index 715f414..ae71544 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/custord/customer_q_06/customer_q_06.1.ddl.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/custord/customer_q_06/customer_q_06.1.ddl.sqlpp @@ -25,20 +25,20 @@ use test; create type test.AddressType as { - number : int64, + number : bigint, street : string, city : string } create type test.CustomerType as closed { - cid : int64, + cid : bigint, name : string, - cashBack : int64, - age : int64?, + cashBack : bigint, + age : bigint?, address : AddressType?, lastorder : { - oid : int64, + oid : bigint, total : float } http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/custord/customer_q_07/customer_q_07.1.ddl.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/custord/customer_q_07/customer_q_07.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/custord/customer_q_07/customer_q_07.1.ddl.sqlpp index 715f414..ae71544 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/custord/customer_q_07/customer_q_07.1.ddl.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/custord/customer_q_07/customer_q_07.1.ddl.sqlpp @@ -25,20 +25,20 @@ use test; create type test.AddressType as { - number : int64, + number : bigint, street : string, city : string } create type test.CustomerType as closed { - cid : int64, + cid : bigint, name : string, - cashBack : int64, - age : int64?, + cashBack : bigint, + age : bigint?, address : AddressType?, lastorder : { - oid : int64, + oid : bigint, total : float } http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/custord/customer_q_08/customer_q_08.1.ddl.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/custord/customer_q_08/customer_q_08.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/custord/customer_q_08/customer_q_08.1.ddl.sqlpp index 715f414..ae71544 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/custord/customer_q_08/customer_q_08.1.ddl.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/custord/customer_q_08/customer_q_08.1.ddl.sqlpp @@ -25,20 +25,20 @@ use test; create type test.AddressType as { - number : int64, + number : bigint, street : string, city : string } create type test.CustomerType as closed { - cid : int64, + cid : bigint, name : string, - cashBack : int64, - age : int64?, + cashBack : bigint, + age : bigint?, address : AddressType?, lastorder : { - oid : int64, + oid : bigint, total : float } http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/custord/denorm-cust-order_01/denorm-cust-order_01.1.ddl.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/custord/denorm-cust-order_01/denorm-cust-order_01.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/custord/denorm-cust-order_01/denorm-cust-order_01.1.ddl.sqlpp index c976192..4b73887 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/custord/denorm-cust-order_01/denorm-cust-order_01.1.ddl.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/custord/denorm-cust-order_01/denorm-cust-order_01.1.ddl.sqlpp @@ -25,19 +25,19 @@ use test; create type test.AddressType as { - number : int64, + number : bigint, street : string, city : string } create type test.CustomerType as { - cid : int64, + cid : bigint, name : string, - age : int64?, + age : bigint?, address : AddressType?, lastorder : { - oid : int64, + oid : bigint, total : float } @@ -45,8 +45,8 @@ create type test.CustomerType as create type test.OrderType as { - oid : int64, - cid : int64, + oid : bigint, + cid : bigint, orderstatus : string, orderpriority : string, clerk : string, @@ -55,7 +55,7 @@ create type test.OrderType as create type test.CustomerOrdersType as { - cid : int64, + cid : bigint, cust : CustomerType, orders : [OrderType] } http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/custord/denorm-cust-order_02/denorm-cust-order_02.1.ddl.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/custord/denorm-cust-order_02/denorm-cust-order_02.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/custord/denorm-cust-order_02/denorm-cust-order_02.1.ddl.sqlpp index 1c2d73a..bdb22e0 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/custord/denorm-cust-order_02/denorm-cust-order_02.1.ddl.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/custord/denorm-cust-order_02/denorm-cust-order_02.1.ddl.sqlpp @@ -25,19 +25,19 @@ use test; create type test.AddressType as { - number : int64, + number : bigint, street : string, city : string } create type test.CustomerType as { - cid : int64, + cid : bigint, name : string, - age : int64?, + age : bigint?, address : AddressType?, lastorder : { - oid : int64, + oid : bigint, total : float } @@ -45,8 +45,8 @@ create type test.CustomerType as create type test.OrderType as { - oid : int64, - cid : int64, + oid : bigint, + cid : bigint, orderstatus : string, orderpriority : string, clerk : string, @@ -55,7 +55,7 @@ create type test.OrderType as create type test.CustomerOrdersType as { - cid : int64, + cid : bigint, cust : CustomerType, orders : [OrderType] } http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/custord/denorm-cust-order_03/denorm-cust-order_03.1.ddl.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/custord/denorm-cust-order_03/denorm-cust-order_03.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/custord/denorm-cust-order_03/denorm-cust-order_03.1.ddl.sqlpp index af63e03..ba188ed 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/custord/denorm-cust-order_03/denorm-cust-order_03.1.ddl.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/custord/denorm-cust-order_03/denorm-cust-order_03.1.ddl.sqlpp @@ -25,19 +25,19 @@ use test; create type test.AddressType as { - number : int64, + number : bigint, street : string, city : string } create type test.CustomerType as { - cid : int64, + cid : bigint, name : string, - age : int64?, + age : bigint?, address : AddressType?, lastorder : { - oid : int64, + oid : bigint, total : float } @@ -45,8 +45,8 @@ create type test.CustomerType as create type test.OrderType as { - oid : int64, - cid : int64, + oid : bigint, + cid : bigint, orderstatus : string, orderpriority : string, clerk : string, @@ -55,7 +55,7 @@ create type test.OrderType as create type test.CustomerOrdersType as { - cid : int64, + cid : bigint, cust : CustomerType, orders : [OrderType] } http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/custord/freq-clerk/freq-clerk.1.ddl.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/custord/freq-clerk/freq-clerk.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/custord/freq-clerk/freq-clerk.1.ddl.sqlpp index 8ea06c4..c24b930 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/custord/freq-clerk/freq-clerk.1.ddl.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/custord/freq-clerk/freq-clerk.1.ddl.sqlpp @@ -25,24 +25,24 @@ use test; create type test.AddressType as { - number : int32, + number : integer, street : string, city : string } create type test.CustomerOrderType as { - cid : int32, + cid : integer, name : string, - age : int32?, + age : integer?, address : AddressType?, orders : [OrderType] } create type test.OrderType as { - oid : int32, - cid : int32, + oid : integer, + cid : integer, orderstatus : string, orderpriority : string, clerk : string, http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/custord/join_q_01/join_q_01.1.ddl.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/custord/join_q_01/join_q_01.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/custord/join_q_01/join_q_01.1.ddl.sqlpp index 2ca38f1..0cc56ed 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/custord/join_q_01/join_q_01.1.ddl.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/custord/join_q_01/join_q_01.1.ddl.sqlpp @@ -25,20 +25,20 @@ use test; create type test.AddressType as { - number : int64, + number : bigint, street : string, city : string } create type test.CustomerType as closed { - cid : int64, + cid : bigint, name : string, - cashBack : int64, - age : int64?, + cashBack : bigint, + age : bigint?, address : AddressType?, lastorder : { - oid : int64, + oid : bigint, total : float } @@ -46,13 +46,13 @@ create type test.CustomerType as create type test.OrderType as { - oid : int64, - cid : int64, + oid : bigint, + cid : bigint, orderstatus : string, orderpriority : string, clerk : string, total : float, - items : [int64] + items : [bigint] } create external dataset Customers(CustomerType) using localfs((`path`=`asterix_nc1://data/nontagged/customerData.json`),(`format`=`adm`)); http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/custord/join_q_02/join_q_02.1.ddl.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/custord/join_q_02/join_q_02.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/custord/join_q_02/join_q_02.1.ddl.sqlpp index 2ca38f1..0cc56ed 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/custord/join_q_02/join_q_02.1.ddl.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/custord/join_q_02/join_q_02.1.ddl.sqlpp @@ -25,20 +25,20 @@ use test; create type test.AddressType as { - number : int64, + number : bigint, street : string, city : string } create type test.CustomerType as closed { - cid : int64, + cid : bigint, name : string, - cashBack : int64, - age : int64?, + cashBack : bigint, + age : bigint?, address : AddressType?, lastorder : { - oid : int64, + oid : bigint, total : float } @@ -46,13 +46,13 @@ create type test.CustomerType as create type test.OrderType as { - oid : int64, - cid : int64, + oid : bigint, + cid : bigint, orderstatus : string, orderpriority : string, clerk : string, total : float, - items : [int64] + items : [bigint] } create external dataset Customers(CustomerType) using localfs((`path`=`asterix_nc1://data/nontagged/customerData.json`),(`format`=`adm`)); http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/custord/join_q_03/join_q_03.1.ddl.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/custord/join_q_03/join_q_03.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/custord/join_q_03/join_q_03.1.ddl.sqlpp index 2ca38f1..0cc56ed 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/custord/join_q_03/join_q_03.1.ddl.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/custord/join_q_03/join_q_03.1.ddl.sqlpp @@ -25,20 +25,20 @@ use test; create type test.AddressType as { - number : int64, + number : bigint, street : string, city : string } create type test.CustomerType as closed { - cid : int64, + cid : bigint, name : string, - cashBack : int64, - age : int64?, + cashBack : bigint, + age : bigint?, address : AddressType?, lastorder : { - oid : int64, + oid : bigint, total : float } @@ -46,13 +46,13 @@ create type test.CustomerType as create type test.OrderType as { - oid : int64, - cid : int64, + oid : bigint, + cid : bigint, orderstatus : string, orderpriority : string, clerk : string, total : float, - items : [int64] + items : [bigint] } create external dataset Customers(CustomerType) using localfs((`path`=`asterix_nc1://data/nontagged/customerData.json`),(`format`=`adm`)); http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/custord/join_q_04/join_q_04.1.ddl.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/custord/join_q_04/join_q_04.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/custord/join_q_04/join_q_04.1.ddl.sqlpp index 80d83e0..43d3ab3 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/custord/join_q_04/join_q_04.1.ddl.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/custord/join_q_04/join_q_04.1.ddl.sqlpp @@ -28,20 +28,20 @@ use test; create type test.AddressType as { - number : int64, + number : bigint, street : string, city : string } create type test.CustomerType as closed { - cid : int64, + cid : bigint, name : string, - cashBack : int64, - age : int64?, + cashBack : bigint, + age : bigint?, address : AddressType?, lastorder : { - oid : int64, + oid : bigint, total : float } @@ -49,13 +49,13 @@ create type test.CustomerType as create type test.OrderType as { - oid : int64, - cid : int64, + oid : bigint, + cid : bigint, orderstatus : string, orderpriority : string, clerk : string, total : float, - items : [int64] + items : [bigint] } create external dataset Customers(CustomerType) using localfs((`path`=`asterix_nc1://data/nontagged/customerData.json`),(`format`=`adm`)); http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/custord/join_q_05/join_q_05.1.ddl.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/custord/join_q_05/join_q_05.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/custord/join_q_05/join_q_05.1.ddl.sqlpp index 88122f6..36e49aa 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/custord/join_q_05/join_q_05.1.ddl.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/custord/join_q_05/join_q_05.1.ddl.sqlpp @@ -25,20 +25,20 @@ use test; create type test.AddressType as { - number : int64, + number : bigint, street : string, city : string } create type test.CustomerType as closed { - cid : int64, + cid : bigint, name : string, - cashBack : int64, - age : int64?, + cashBack : bigint, + age : bigint?, address : AddressType?, lastorder : { - oid : int64, + oid : bigint, total : float } @@ -46,13 +46,13 @@ create type test.CustomerType as create type test.OrderType as { - oid : int64, - cid : int64, + oid : bigint, + cid : bigint, orderstatus : string, orderpriority : string, clerk : string, total : float, - items : [int64] + items : [bigint] } create external dataset Customers(CustomerType) using localfs((`path`=`asterix_nc1://data/nontagged/customerData.json`),(`format`=`adm`)); http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/custord/join_q_06/join_q_06.1.ddl.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/custord/join_q_06/join_q_06.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/custord/join_q_06/join_q_06.1.ddl.sqlpp index 84f65bb..16ea16e 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/custord/join_q_06/join_q_06.1.ddl.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/custord/join_q_06/join_q_06.1.ddl.sqlpp @@ -25,20 +25,20 @@ use test; create type test.AddressType as { - number : int64, + number : bigint, street : string, city : string } create type test.CustomerType as closed { - cid : int64, + cid : bigint, name : string, - cashBack : int64, - age : int64?, + cashBack : bigint, + age : bigint?, address : AddressType?, lastorder : { - oid : int64, + oid : bigint, total : float } http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/custord/join_q_06/join_q_06.3.query.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/custord/join_q_06/join_q_06.3.query.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/custord/join_q_06/join_q_06.3.query.sqlpp index 413ab84..62ec751 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/custord/join_q_06/join_q_06.3.query.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/custord/join_q_06/join_q_06.3.query.sqlpp @@ -24,7 +24,7 @@ WITH customer AS (SELECT ELEMENT c FROM Customers c) SELECT c.name AS cust_name, c.cashBack AS cust_cashBack -FROM customer c JOIN [coll_min((SELECT ELEMENT c.cashBack FROM customer c))] as min_cashBack +FROM customer c JOIN [array_min((SELECT ELEMENT c.cashBack FROM customer c))] as min_cashBack ON c.cashBack = min_cashBack ORDER BY c.cid, c.name ; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/custord/join_q_07/join_q_07.1.ddl.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/custord/join_q_07/join_q_07.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/custord/join_q_07/join_q_07.1.ddl.sqlpp index 84f65bb..16ea16e 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/custord/join_q_07/join_q_07.1.ddl.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/custord/join_q_07/join_q_07.1.ddl.sqlpp @@ -25,20 +25,20 @@ use test; create type test.AddressType as { - number : int64, + number : bigint, street : string, city : string } create type test.CustomerType as closed { - cid : int64, + cid : bigint, name : string, - cashBack : int64, - age : int64?, + cashBack : bigint, + age : bigint?, address : AddressType?, lastorder : { - oid : int64, + oid : bigint, total : float } http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/custord/join_q_07/join_q_07.3.query.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/custord/join_q_07/join_q_07.3.query.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/custord/join_q_07/join_q_07.3.query.sqlpp index 5f4f07f..ab1859e 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/custord/join_q_07/join_q_07.3.query.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/custord/join_q_07/join_q_07.3.query.sqlpp @@ -29,7 +29,7 @@ WITH customer AS (SELECT ELEMENT c FROM Customers c) SELECT c.name AS cust_name, c.cashBack AS cust_cashBack -FROM customer c JOIN [coll_min((SELECT ELEMENT c.cashBack FROM c c))] as min_cashBack +FROM customer c JOIN [array_min((SELECT ELEMENT c.cashBack FROM c c))] as min_cashBack ON c.cashBack = min_cashBack ORDER BY c.cid, c.name ; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/custord/join_q_08/join_q_08.1.ddl.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/custord/join_q_08/join_q_08.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/custord/join_q_08/join_q_08.1.ddl.sqlpp index 88122f6..36e49aa 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/custord/join_q_08/join_q_08.1.ddl.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/custord/join_q_08/join_q_08.1.ddl.sqlpp @@ -25,20 +25,20 @@ use test; create type test.AddressType as { - number : int64, + number : bigint, street : string, city : string } create type test.CustomerType as closed { - cid : int64, + cid : bigint, name : string, - cashBack : int64, - age : int64?, + cashBack : bigint, + age : bigint?, address : AddressType?, lastorder : { - oid : int64, + oid : bigint, total : float } @@ -46,13 +46,13 @@ create type test.CustomerType as create type test.OrderType as { - oid : int64, - cid : int64, + oid : bigint, + cid : bigint, orderstatus : string, orderpriority : string, clerk : string, total : float, - items : [int64] + items : [bigint] } create external dataset Customers(CustomerType) using localfs((`path`=`asterix_nc1://data/nontagged/customerData.json`),(`format`=`adm`)); http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/custord/join_q_09/join_q_09.1.ddl.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/custord/join_q_09/join_q_09.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/custord/join_q_09/join_q_09.1.ddl.sqlpp index 88122f6..36e49aa 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/custord/join_q_09/join_q_09.1.ddl.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/custord/join_q_09/join_q_09.1.ddl.sqlpp @@ -25,20 +25,20 @@ use test; create type test.AddressType as { - number : int64, + number : bigint, street : string, city : string } create type test.CustomerType as closed { - cid : int64, + cid : bigint, name : string, - cashBack : int64, - age : int64?, + cashBack : bigint, + age : bigint?, address : AddressType?, lastorder : { - oid : int64, + oid : bigint, total : float } @@ -46,13 +46,13 @@ create type test.CustomerType as create type test.OrderType as { - oid : int64, - cid : int64, + oid : bigint, + cid : bigint, orderstatus : string, orderpriority : string, clerk : string, total : float, - items : [int64] + items : [bigint] } create external dataset Customers(CustomerType) using localfs((`path`=`asterix_nc1://data/nontagged/customerData.json`),(`format`=`adm`)); http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/custord/load-test/load-test.1.ddl.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/custord/load-test/load-test.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/custord/load-test/load-test.1.ddl.sqlpp index 7fe063b..471ed0c 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/custord/load-test/load-test.1.ddl.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/custord/load-test/load-test.1.ddl.sqlpp @@ -25,19 +25,19 @@ use test; create type test.AddressType as { - number : int64, + number : bigint, street : string, city : string } create type test.CustomerType as { - cid : int64, + cid : bigint, name : string, - age : int64?, + age : bigint?, address : AddressType?, lastorder : { - oid : int64, + oid : bigint, total : float } http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/custord/order_q_01/order_q_01.1.ddl.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/custord/order_q_01/order_q_01.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/custord/order_q_01/order_q_01.1.ddl.sqlpp index 0087cc3..5481e8d 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/custord/order_q_01/order_q_01.1.ddl.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/custord/order_q_01/order_q_01.1.ddl.sqlpp @@ -25,13 +25,13 @@ use test; create type test.OrderType as { - oid : int64, - cid : int64, + oid : bigint, + cid : bigint, orderstatus : string, orderpriority : string, clerk : string, total : float, - items : [int64] + items : [bigint] } create external dataset Orders(OrderType) using localfs((`path`=`asterix_nc1://data/nontagged/orderData.json`),(`format`=`adm`)); http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/custord/order_q_02/order_q_02.1.ddl.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/custord/order_q_02/order_q_02.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/custord/order_q_02/order_q_02.1.ddl.sqlpp index 0087cc3..5481e8d 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/custord/order_q_02/order_q_02.1.ddl.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/custord/order_q_02/order_q_02.1.ddl.sqlpp @@ -25,13 +25,13 @@ use test; create type test.OrderType as { - oid : int64, - cid : int64, + oid : bigint, + cid : bigint, orderstatus : string, orderpriority : string, clerk : string, total : float, - items : [int64] + items : [bigint] } create external dataset Orders(OrderType) using localfs((`path`=`asterix_nc1://data/nontagged/orderData.json`),(`format`=`adm`)); http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/custord/order_q_03/order_q_03.1.ddl.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/custord/order_q_03/order_q_03.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/custord/order_q_03/order_q_03.1.ddl.sqlpp index 0087cc3..5481e8d 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/custord/order_q_03/order_q_03.1.ddl.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/custord/order_q_03/order_q_03.1.ddl.sqlpp @@ -25,13 +25,13 @@ use test; create type test.OrderType as { - oid : int64, - cid : int64, + oid : bigint, + cid : bigint, orderstatus : string, orderpriority : string, clerk : string, total : float, - items : [int64] + items : [bigint] } create external dataset Orders(OrderType) using localfs((`path`=`asterix_nc1://data/nontagged/orderData.json`),(`format`=`adm`)); http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/custord/order_q_04/order_q_04.1.ddl.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/custord/order_q_04/order_q_04.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/custord/order_q_04/order_q_04.1.ddl.sqlpp index 0087cc3..5481e8d 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/custord/order_q_04/order_q_04.1.ddl.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/custord/order_q_04/order_q_04.1.ddl.sqlpp @@ -25,13 +25,13 @@ use test; create type test.OrderType as { - oid : int64, - cid : int64, + oid : bigint, + cid : bigint, orderstatus : string, orderpriority : string, clerk : string, total : float, - items : [int64] + items : [bigint] } create external dataset Orders(OrderType) using localfs((`path`=`asterix_nc1://data/nontagged/orderData.json`),(`format`=`adm`)); http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/custord/order_q_05/order_q_05.1.ddl.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/custord/order_q_05/order_q_05.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/custord/order_q_05/order_q_05.1.ddl.sqlpp index 0087cc3..5481e8d 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/custord/order_q_05/order_q_05.1.ddl.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/custord/order_q_05/order_q_05.1.ddl.sqlpp @@ -25,13 +25,13 @@ use test; create type test.OrderType as { - oid : int64, - cid : int64, + oid : bigint, + cid : bigint, orderstatus : string, orderpriority : string, clerk : string, total : float, - items : [int64] + items : [bigint] } create external dataset Orders(OrderType) using localfs((`path`=`asterix_nc1://data/nontagged/orderData.json`),(`format`=`adm`)); http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/custord/order_q_06/order_q_06.1.ddl.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/custord/order_q_06/order_q_06.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/custord/order_q_06/order_q_06.1.ddl.sqlpp index 0087cc3..5481e8d 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/custord/order_q_06/order_q_06.1.ddl.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/custord/order_q_06/order_q_06.1.ddl.sqlpp @@ -25,13 +25,13 @@ use test; create type test.OrderType as { - oid : int64, - cid : int64, + oid : bigint, + cid : bigint, orderstatus : string, orderpriority : string, clerk : string, total : float, - items : [int64] + items : [bigint] } create external dataset Orders(OrderType) using localfs((`path`=`asterix_nc1://data/nontagged/orderData.json`),(`format`=`adm`)); http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dapd/q1/q1.1.ddl.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dapd/q1/q1.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dapd/q1/q1.1.ddl.sqlpp index 58d0dab..e5762df 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dapd/q1/q1.1.ddl.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dapd/q1/q1.1.ddl.sqlpp @@ -38,7 +38,7 @@ create type test.UserType as interests : {{string}}, address : AddressType, member_of : {{{ - sig_id : int64, + sig_id : bigint, chapter_name : string, member_since : date } http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dapd/q2-10/q2-10.1.ddl.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dapd/q2-10/q2-10.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dapd/q2-10/q2-10.1.ddl.sqlpp index 99eae31..c039637 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dapd/q2-10/q2-10.1.ddl.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dapd/q2-10/q2-10.1.ddl.sqlpp @@ -33,7 +33,7 @@ create type test.AddressType as create type test.EventType as closed { - event_id : int64, + event_id : bigint, name : string, location : AddressType?, organizers : {{{ @@ -41,7 +41,7 @@ create type test.EventType as } }}, sponsoring_sigs : [{ - sig_id : int64, + sig_id : bigint, chapter_name : string } ], http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dapd/q2-11/q2-11.1.ddl.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dapd/q2-11/q2-11.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dapd/q2-11/q2-11.1.ddl.sqlpp index 99eae31..c039637 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dapd/q2-11/q2-11.1.ddl.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dapd/q2-11/q2-11.1.ddl.sqlpp @@ -33,7 +33,7 @@ create type test.AddressType as create type test.EventType as closed { - event_id : int64, + event_id : bigint, name : string, location : AddressType?, organizers : {{{ @@ -41,7 +41,7 @@ create type test.EventType as } }}, sponsoring_sigs : [{ - sig_id : int64, + sig_id : bigint, chapter_name : string } ], http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dapd/q2-12/q2-12.1.ddl.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dapd/q2-12/q2-12.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dapd/q2-12/q2-12.1.ddl.sqlpp index 99eae31..c039637 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dapd/q2-12/q2-12.1.ddl.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dapd/q2-12/q2-12.1.ddl.sqlpp @@ -33,7 +33,7 @@ create type test.AddressType as create type test.EventType as closed { - event_id : int64, + event_id : bigint, name : string, location : AddressType?, organizers : {{{ @@ -41,7 +41,7 @@ create type test.EventType as } }}, sponsoring_sigs : [{ - sig_id : int64, + sig_id : bigint, chapter_name : string } ], http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dapd/q2-2-negative/q2-2-negative.1.ddl.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dapd/q2-2-negative/q2-2-negative.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dapd/q2-2-negative/q2-2-negative.1.ddl.sqlpp index 99eae31..c039637 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dapd/q2-2-negative/q2-2-negative.1.ddl.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dapd/q2-2-negative/q2-2-negative.1.ddl.sqlpp @@ -33,7 +33,7 @@ create type test.AddressType as create type test.EventType as closed { - event_id : int64, + event_id : bigint, name : string, location : AddressType?, organizers : {{{ @@ -41,7 +41,7 @@ create type test.EventType as } }}, sponsoring_sigs : [{ - sig_id : int64, + sig_id : bigint, chapter_name : string } ], http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dapd/q2-2/q2-2.1.ddl.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dapd/q2-2/q2-2.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dapd/q2-2/q2-2.1.ddl.sqlpp index 99eae31..c039637 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dapd/q2-2/q2-2.1.ddl.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dapd/q2-2/q2-2.1.ddl.sqlpp @@ -33,7 +33,7 @@ create type test.AddressType as create type test.EventType as closed { - event_id : int64, + event_id : bigint, name : string, location : AddressType?, organizers : {{{ @@ -41,7 +41,7 @@ create type test.EventType as } }}, sponsoring_sigs : [{ - sig_id : int64, + sig_id : bigint, chapter_name : string } ], http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dapd/q2-3/q2-3.1.ddl.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dapd/q2-3/q2-3.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dapd/q2-3/q2-3.1.ddl.sqlpp index 99eae31..c039637 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dapd/q2-3/q2-3.1.ddl.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dapd/q2-3/q2-3.1.ddl.sqlpp @@ -33,7 +33,7 @@ create type test.AddressType as create type test.EventType as closed { - event_id : int64, + event_id : bigint, name : string, location : AddressType?, organizers : {{{ @@ -41,7 +41,7 @@ create type test.EventType as } }}, sponsoring_sigs : [{ - sig_id : int64, + sig_id : bigint, chapter_name : string } ], http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dapd/q2-4/q2-4.1.ddl.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dapd/q2-4/q2-4.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dapd/q2-4/q2-4.1.ddl.sqlpp index 99eae31..c039637 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dapd/q2-4/q2-4.1.ddl.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dapd/q2-4/q2-4.1.ddl.sqlpp @@ -33,7 +33,7 @@ create type test.AddressType as create type test.EventType as closed { - event_id : int64, + event_id : bigint, name : string, location : AddressType?, organizers : {{{ @@ -41,7 +41,7 @@ create type test.EventType as } }}, sponsoring_sigs : [{ - sig_id : int64, + sig_id : bigint, chapter_name : string } ], http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dapd/q2-5/q2-5.1.ddl.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dapd/q2-5/q2-5.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dapd/q2-5/q2-5.1.ddl.sqlpp index 99eae31..c039637 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dapd/q2-5/q2-5.1.ddl.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dapd/q2-5/q2-5.1.ddl.sqlpp @@ -33,7 +33,7 @@ create type test.AddressType as create type test.EventType as closed { - event_id : int64, + event_id : bigint, name : string, location : AddressType?, organizers : {{{ @@ -41,7 +41,7 @@ create type test.EventType as } }}, sponsoring_sigs : [{ - sig_id : int64, + sig_id : bigint, chapter_name : string } ], http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dapd/q2-6/q2-6.1.ddl.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dapd/q2-6/q2-6.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dapd/q2-6/q2-6.1.ddl.sqlpp index 99eae31..c039637 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dapd/q2-6/q2-6.1.ddl.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dapd/q2-6/q2-6.1.ddl.sqlpp @@ -33,7 +33,7 @@ create type test.AddressType as create type test.EventType as closed { - event_id : int64, + event_id : bigint, name : string, location : AddressType?, organizers : {{{ @@ -41,7 +41,7 @@ create type test.EventType as } }}, sponsoring_sigs : [{ - sig_id : int64, + sig_id : bigint, chapter_name : string } ], http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dapd/q2-7/q2-7.1.ddl.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dapd/q2-7/q2-7.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dapd/q2-7/q2-7.1.ddl.sqlpp index 99eae31..c039637 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dapd/q2-7/q2-7.1.ddl.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dapd/q2-7/q2-7.1.ddl.sqlpp @@ -33,7 +33,7 @@ create type test.AddressType as create type test.EventType as closed { - event_id : int64, + event_id : bigint, name : string, location : AddressType?, organizers : {{{ @@ -41,7 +41,7 @@ create type test.EventType as } }}, sponsoring_sigs : [{ - sig_id : int64, + sig_id : bigint, chapter_name : string } ], http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dapd/q2-8/q2-8.1.ddl.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dapd/q2-8/q2-8.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dapd/q2-8/q2-8.1.ddl.sqlpp index 99eae31..c039637 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dapd/q2-8/q2-8.1.ddl.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dapd/q2-8/q2-8.1.ddl.sqlpp @@ -33,7 +33,7 @@ create type test.AddressType as create type test.EventType as closed { - event_id : int64, + event_id : bigint, name : string, location : AddressType?, organizers : {{{ @@ -41,7 +41,7 @@ create type test.EventType as } }}, sponsoring_sigs : [{ - sig_id : int64, + sig_id : bigint, chapter_name : string } ], http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dapd/q2-9/q2-9.1.ddl.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dapd/q2-9/q2-9.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dapd/q2-9/q2-9.1.ddl.sqlpp index 99eae31..c039637 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dapd/q2-9/q2-9.1.ddl.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dapd/q2-9/q2-9.1.ddl.sqlpp @@ -33,7 +33,7 @@ create type test.AddressType as create type test.EventType as closed { - event_id : int64, + event_id : bigint, name : string, location : AddressType?, organizers : {{{ @@ -41,7 +41,7 @@ create type test.EventType as } }}, sponsoring_sigs : [{ - sig_id : int64, + sig_id : bigint, chapter_name : string } ], http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dapd/q2/q2.1.ddl.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dapd/q2/q2.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dapd/q2/q2.1.ddl.sqlpp index 99eae31..c039637 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dapd/q2/q2.1.ddl.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dapd/q2/q2.1.ddl.sqlpp @@ -33,7 +33,7 @@ create type test.AddressType as create type test.EventType as closed { - event_id : int64, + event_id : bigint, name : string, location : AddressType?, organizers : {{{ @@ -41,7 +41,7 @@ create type test.EventType as } }}, sponsoring_sigs : [{ - sig_id : int64, + sig_id : bigint, chapter_name : string } ], http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dapd/q3/q3.1.ddl.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dapd/q3/q3.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dapd/q3/q3.1.ddl.sqlpp index c889882..8092c50 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dapd/q3/q3.1.ddl.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dapd/q3/q3.1.ddl.sqlpp @@ -37,7 +37,7 @@ create type test.UserType as interests : {{string}}, address : AddressType, member_of : {{{ - sig_id : int64, + sig_id : bigint, chapter_name : string, member_since : date } http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dml/compact-dataset-and-its-indexes/compact-dataset-and-its-indexes.1.ddl.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dml/compact-dataset-and-its-indexes/compact-dataset-and-its-indexes.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dml/compact-dataset-and-its-indexes/compact-dataset-and-its-indexes.1.ddl.sqlpp index 12673a4..2a1438f 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dml/compact-dataset-and-its-indexes/compact-dataset-and-its-indexes.1.ddl.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dml/compact-dataset-and-its-indexes/compact-dataset-and-its-indexes.1.ddl.sqlpp @@ -32,11 +32,11 @@ use test; create type test.LineItemType as closed { - l_orderkey : int64, - l_partkey : int64, - l_suppkey : int64, - l_linenumber : int64, - l_quantity : int64, + l_orderkey : bigint, + l_partkey : bigint, + l_suppkey : bigint, + l_linenumber : bigint, + l_quantity : bigint, l_extendedprice : double, l_discount : double, l_tax : double, http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dml/create-drop-cltype/create-drop-cltype.1.ddl.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dml/create-drop-cltype/create-drop-cltype.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dml/create-drop-cltype/create-drop-cltype.1.ddl.sqlpp index 8a3b21f..5cc49f1 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dml/create-drop-cltype/create-drop-cltype.1.ddl.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dml/create-drop-cltype/create-drop-cltype.1.ddl.sqlpp @@ -31,7 +31,7 @@ use test; create type test.TestType as closed { - id : int32, + id : integer, salary : double?, name : string, durtn : duration?, @@ -44,7 +44,7 @@ create type test.TestType as drop type test.TestType; create type test.TestType as closed { - id : int32, + id : integer, salary : double?, name : string, durtn : duration?, http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dml/create-drop-opntype/create-drop-opntype.1.ddl.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dml/create-drop-opntype/create-drop-opntype.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dml/create-drop-opntype/create-drop-opntype.1.ddl.sqlpp index 1c6ed1f..3ea37d9 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dml/create-drop-opntype/create-drop-opntype.1.ddl.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dml/create-drop-opntype/create-drop-opntype.1.ddl.sqlpp @@ -31,7 +31,7 @@ use test; create type test.TestType as { - id : int32, + id : integer, salary : double?, name : string, durtn : duration?, @@ -44,7 +44,7 @@ create type test.TestType as drop type test.TestType; create type test.TestType as { - id : int32, + id : integer, salary : double?, name : string, durtn : duration?, http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dml/delete-from-loaded-dataset-with-index/delete-from-loaded-dataset-with-index.1.ddl.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dml/delete-from-loaded-dataset-with-index/delete-from-loaded-dataset-with-index.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dml/delete-from-loaded-dataset-with-index/delete-from-loaded-dataset-with-index.1.ddl.sqlpp index d11f487..7025805 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dml/delete-from-loaded-dataset-with-index/delete-from-loaded-dataset-with-index.1.ddl.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dml/delete-from-loaded-dataset-with-index/delete-from-loaded-dataset-with-index.1.ddl.sqlpp @@ -25,11 +25,11 @@ use test; create type test.LineItemType as closed { - l_orderkey : int64, - l_partkey : int64, - l_suppkey : int64, - l_linenumber : int64, - l_quantity : int64, + l_orderkey : bigint, + l_partkey : bigint, + l_suppkey : bigint, + l_linenumber : bigint, + l_quantity : bigint, l_extendedprice : double, l_discount : double, l_tax : double, http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dml/delete-from-loaded-dataset/delete-from-loaded-dataset.1.ddl.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dml/delete-from-loaded-dataset/delete-from-loaded-dataset.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dml/delete-from-loaded-dataset/delete-from-loaded-dataset.1.ddl.sqlpp index d11f487..7025805 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dml/delete-from-loaded-dataset/delete-from-loaded-dataset.1.ddl.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dml/delete-from-loaded-dataset/delete-from-loaded-dataset.1.ddl.sqlpp @@ -25,11 +25,11 @@ use test; create type test.LineItemType as closed { - l_orderkey : int64, - l_partkey : int64, - l_suppkey : int64, - l_linenumber : int64, - l_quantity : int64, + l_orderkey : bigint, + l_partkey : bigint, + l_suppkey : bigint, + l_linenumber : bigint, + l_quantity : bigint, l_extendedprice : double, l_discount : double, l_tax : double, http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dml/delete-multi-statement/delete-multi-statement.1.ddl.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dml/delete-multi-statement/delete-multi-statement.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dml/delete-multi-statement/delete-multi-statement.1.ddl.sqlpp index 1871e19..0db8d36 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dml/delete-multi-statement/delete-multi-statement.1.ddl.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dml/delete-multi-statement/delete-multi-statement.1.ddl.sqlpp @@ -25,11 +25,11 @@ use tpch; create type tpch.LineItemType as closed { - l_orderkey : int32, - l_partkey : int32, - l_suppkey : int32, - l_linenumber : int32, - l_quantity : int32, + l_orderkey : integer, + l_partkey : integer, + l_suppkey : integer, + l_linenumber : integer, + l_quantity : integer, l_extendedprice : double, l_discount : double, l_tax : double, @@ -45,23 +45,23 @@ create type tpch.LineItemType as create type tpch.OrderType as closed { - o_orderkey : int32, - o_custkey : int32, + o_orderkey : integer, + o_custkey : integer, o_orderstatus : string, o_totalprice : double, o_orderdate : string, o_orderpriority : string, o_clerk : string, - o_shippriority : int32, + o_shippriority : integer, o_comment : string } create type tpch.CustomerType as closed { - c_custkey : int32, + c_custkey : integer, c_name : string, c_address : string, - c_nationkey : int32, + c_nationkey : integer, c_phone : string, c_acctbal : double, c_mktsegment : string, @@ -70,10 +70,10 @@ create type tpch.CustomerType as create type tpch.SupplierType as closed { - s_suppkey : int32, + s_suppkey : integer, s_name : string, s_address : string, - s_nationkey : int32, + s_nationkey : integer, s_phone : string, s_acctbal : double, s_comment : string @@ -81,27 +81,27 @@ create type tpch.SupplierType as create type tpch.NationType as closed { - n_nationkey : int32, + n_nationkey : integer, n_name : string, - n_regionkey : int32, + n_regionkey : integer, n_comment : string } create type tpch.RegionType as closed { - r_regionkey : int32, + r_regionkey : integer, r_name : string, r_comment : string } create type tpch.PartType as closed { - p_partkey : int32, + p_partkey : integer, p_name : string, p_mfgr : string, p_brand : string, p_type : string, - p_size : int32, + p_size : integer, p_container : string, p_retailprice : double, p_comment : string @@ -109,9 +109,9 @@ create type tpch.PartType as create type tpch.PartSuppType as closed { - ps_partkey : int32, - ps_suppkey : int32, - ps_availqty : int32, + ps_partkey : integer, + ps_suppkey : integer, + ps_availqty : integer, ps_supplycost : double, ps_comment : string } http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dml/delete-syntax-change.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dml/delete-syntax-change.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dml/delete-syntax-change.sqlpp index 28e28f1..34c2b6f 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dml/delete-syntax-change.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dml/delete-syntax-change.sqlpp @@ -31,11 +31,11 @@ use test; create type test.LineItemType as closed { - l_orderkey : int32, - l_partkey : int32, - l_suppkey : int32, - l_linenumber : int32, - l_quantity : int32, + l_orderkey : integer, + l_partkey : integer, + l_suppkey : integer, + l_linenumber : integer, + l_quantity : integer, l_extendedprice : double, l_discount : double, l_tax : double, http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dml/delete-syntax-change/delete-syntax-change.1.ddl.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dml/delete-syntax-change/delete-syntax-change.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dml/delete-syntax-change/delete-syntax-change.1.ddl.sqlpp index 8165e07..2032e59 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dml/delete-syntax-change/delete-syntax-change.1.ddl.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dml/delete-syntax-change/delete-syntax-change.1.ddl.sqlpp @@ -31,11 +31,11 @@ use test; create type test.LineItemType as closed { - l_orderkey : int64, - l_partkey : int64, - l_suppkey : int64, - l_linenumber : int64, - l_quantity : int64, + l_orderkey : bigint, + l_partkey : bigint, + l_suppkey : bigint, + l_linenumber : bigint, + l_quantity : bigint, l_extendedprice : double, l_discount : double, l_tax : double, http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dml/drop-empty-secondary-indexes/drop-empty-secondary-indexes.1.ddl.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dml/drop-empty-secondary-indexes/drop-empty-secondary-indexes.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dml/drop-empty-secondary-indexes/drop-empty-secondary-indexes.1.ddl.sqlpp index 91830f4..ba3498a 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dml/drop-empty-secondary-indexes/drop-empty-secondary-indexes.1.ddl.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dml/drop-empty-secondary-indexes/drop-empty-secondary-indexes.1.ddl.sqlpp @@ -42,7 +42,7 @@ create type test.Person as create type test.TestType as { - id : int32, + id : integer, name : string, locn : point, zip : string, http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dml/drop-index/drop-index.1.ddl.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dml/drop-index/drop-index.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dml/drop-index/drop-index.1.ddl.sqlpp index fd85d57..93db44a 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dml/drop-index/drop-index.1.ddl.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dml/drop-index/drop-index.1.ddl.sqlpp @@ -31,19 +31,19 @@ use test; create type test.Schema as closed { - unique1 : int64, - unique2 : int64, - two : int64, - four : int64, - ten : int64, - twenty : int64, - onePercent : int64, - tenPercent : int64, - twentyPercent : int64, - fiftyPercent : int64, - unique3 : int64, - evenOnePercent : int64, - oddOnePercent : int64, + unique1 : bigint, + unique2 : bigint, + two : bigint, + four : bigint, + ten : bigint, + twenty : bigint, + onePercent : bigint, + tenPercent : bigint, + twentyPercent : bigint, + fiftyPercent : bigint, + unique3 : bigint, + evenOnePercent : bigint, + oddOnePercent : bigint, stringu1 : string, stringu2 : string, string4 : string http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dml/empty-load-with-index/empty-load-with-index.1.ddl.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dml/empty-load-with-index/empty-load-with-index.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dml/empty-load-with-index/empty-load-with-index.1.ddl.sqlpp index 497cad4..8bf5899 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dml/empty-load-with-index/empty-load-with-index.1.ddl.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dml/empty-load-with-index/empty-load-with-index.1.ddl.sqlpp @@ -31,10 +31,10 @@ use test; create type test.LineItemType as closed { - l_orderkey : int64, - l_partkey : int64, - l_suppkey : int64, - l_linenumber : int64, + l_orderkey : bigint, + l_partkey : bigint, + l_suppkey : bigint, + l_linenumber : bigint, l_quantity : double, l_extendedprice : double, l_discount : double, http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dml/insert-and-scan-dataset-with-index-on-open-field/insert-and-scan-dataset-with-index-on-open-field.1.ddl.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dml/insert-and-scan-dataset-with-index-on-open-field/insert-and-scan-dataset-with-index-on-open-field.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dml/insert-and-scan-dataset-with-index-on-open-field/insert-and-scan-dataset-with-index-on-open-field.1.ddl.sqlpp index 9e911e0..4d0ff03 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dml/insert-and-scan-dataset-with-index-on-open-field/insert-and-scan-dataset-with-index-on-open-field.1.ddl.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dml/insert-and-scan-dataset-with-index-on-open-field/insert-and-scan-dataset-with-index-on-open-field.1.ddl.sqlpp @@ -29,18 +29,18 @@ create dataverse test; create type test.Emp as { - id : int32, + id : integer, lname : string, - age : int32, + age : integer, dept : string } create type test.EmpClosed as closed { - id : int32, + id : integer, fname : string, lname : string, - age : int32, + age : integer, dept : string } http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dml/insert-and-scan-dataset-with-index/insert-and-scan-dataset-with-index.1.ddl.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dml/insert-and-scan-dataset-with-index/insert-and-scan-dataset-with-index.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dml/insert-and-scan-dataset-with-index/insert-and-scan-dataset-with-index.1.ddl.sqlpp index 74ed121..4d7f484 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dml/insert-and-scan-dataset-with-index/insert-and-scan-dataset-with-index.1.ddl.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dml/insert-and-scan-dataset-with-index/insert-and-scan-dataset-with-index.1.ddl.sqlpp @@ -32,10 +32,10 @@ use test; create type test.Emp as closed { - id : int64, + id : bigint, fname : string, lname : string, - age : int64, + age : bigint, dept : string } http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dml/insert-and-scan-dataset/insert-and-scan-dataset.1.ddl.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dml/insert-and-scan-dataset/insert-and-scan-dataset.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dml/insert-and-scan-dataset/insert-and-scan-dataset.1.ddl.sqlpp index c0aff7a..908b2c6 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dml/insert-and-scan-dataset/insert-and-scan-dataset.1.ddl.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dml/insert-and-scan-dataset/insert-and-scan-dataset.1.ddl.sqlpp @@ -32,7 +32,7 @@ use test; create type test.myDataType as { - id : int64 + id : bigint } create dataset myData(myDataType) primary key id; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dml/insert-and-scan-joined-datasets/insert-and-scan-joined-datasets.1.ddl.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dml/insert-and-scan-joined-datasets/insert-and-scan-joined-datasets.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dml/insert-and-scan-joined-datasets/insert-and-scan-joined-datasets.1.ddl.sqlpp index 4426b6a..48fd574 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dml/insert-and-scan-joined-datasets/insert-and-scan-joined-datasets.1.ddl.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dml/insert-and-scan-joined-datasets/insert-and-scan-joined-datasets.1.ddl.sqlpp @@ -33,7 +33,7 @@ use test; create type test.myDataType as { - id : int64 + id : bigint } create dataset myData(myDataType) primary key id; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dml/insert-duplicated-keys/insert-duplicated-keys.1.ddl.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dml/insert-duplicated-keys/insert-duplicated-keys.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dml/insert-duplicated-keys/insert-duplicated-keys.1.ddl.sqlpp index 1c44e05..8ec2d05 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dml/insert-duplicated-keys/insert-duplicated-keys.1.ddl.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dml/insert-duplicated-keys/insert-duplicated-keys.1.ddl.sqlpp @@ -26,7 +26,7 @@ use STBench; create type STBench.SimpleGeoPlaceType as closed { coordinates : point, - id : int64, + id : bigint, name : string, tags : string, categories : string, http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dml/insert-into-empty-dataset-with-index/insert-into-empty-dataset-with-index.1.ddl.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dml/insert-into-empty-dataset-with-index/insert-into-empty-dataset-with-index.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dml/insert-into-empty-dataset-with-index/insert-into-empty-dataset-with-index.1.ddl.sqlpp index 486b5fe..1edf6c7 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dml/insert-into-empty-dataset-with-index/insert-into-empty-dataset-with-index.1.ddl.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dml/insert-into-empty-dataset-with-index/insert-into-empty-dataset-with-index.1.ddl.sqlpp @@ -31,9 +31,9 @@ use test; create type test.LineIDType as closed { - l_orderkey : int64, - l_linenumber : int64, - l_suppkey : int64 + l_orderkey : bigint, + l_linenumber : bigint, + l_suppkey : bigint } create dataset LineID(LineIDType) primary key l_orderkey,l_linenumber; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dml/insert-into-empty-dataset/insert-into-empty-dataset.1.ddl.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dml/insert-into-empty-dataset/insert-into-empty-dataset.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dml/insert-into-empty-dataset/insert-into-empty-dataset.1.ddl.sqlpp index ac54f02..537cc76 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dml/insert-into-empty-dataset/insert-into-empty-dataset.1.ddl.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dml/insert-into-empty-dataset/insert-into-empty-dataset.1.ddl.sqlpp @@ -31,9 +31,9 @@ use test; create type test.LineIDType as closed { - l_orderkey : int64, - l_linenumber : int64, - l_suppkey : int64 + l_orderkey : bigint, + l_linenumber : bigint, + l_suppkey : bigint } create dataset LineID(LineIDType) primary key l_orderkey,l_linenumber; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dml/insert-into-loaded-dataset-with-index_01/insert-into-loaded-dataset-with-index_01.1.ddl.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dml/insert-into-loaded-dataset-with-index_01/insert-into-loaded-dataset-with-index_01.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dml/insert-into-loaded-dataset-with-index_01/insert-into-loaded-dataset-with-index_01.1.ddl.sqlpp index e0625f3..25924b1 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dml/insert-into-loaded-dataset-with-index_01/insert-into-loaded-dataset-with-index_01.1.ddl.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dml/insert-into-loaded-dataset-with-index_01/insert-into-loaded-dataset-with-index_01.1.ddl.sqlpp @@ -25,9 +25,9 @@ use test; create type test.LineIDType as closed { - l_orderkey : int64, - l_linenumber : int64, - l_suppkey : int64 + l_orderkey : bigint, + l_linenumber : bigint, + l_suppkey : bigint } create dataset LineID(LineIDType) primary key l_orderkey,l_linenumber; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dml/insert-into-loaded-dataset-with-index_02/insert-into-loaded-dataset-with-index_02.1.ddl.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dml/insert-into-loaded-dataset-with-index_02/insert-into-loaded-dataset-with-index_02.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dml/insert-into-loaded-dataset-with-index_02/insert-into-loaded-dataset-with-index_02.1.ddl.sqlpp index 776097b..d2dcab1 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dml/insert-into-loaded-dataset-with-index_02/insert-into-loaded-dataset-with-index_02.1.ddl.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dml/insert-into-loaded-dataset-with-index_02/insert-into-loaded-dataset-with-index_02.1.ddl.sqlpp @@ -25,10 +25,10 @@ use test; create type test.LineItemType as closed { - l_orderkey : int64, - l_partkey : int64, - l_suppkey : int64, - l_linenumber : int64, + l_orderkey : bigint, + l_partkey : bigint, + l_suppkey : bigint, + l_linenumber : bigint, l_quantity : double, l_extendedprice : double, l_discount : double, @@ -45,9 +45,9 @@ create type test.LineItemType as create type test.LineIDType as closed { - l_orderkey : int64, - l_linenumber : int64, - l_suppkey : int64 + l_orderkey : bigint, + l_linenumber : bigint, + l_suppkey : bigint } create dataset LineItem(LineItemType) primary key l_orderkey,l_linenumber; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dml/insert-into-loaded-dataset_01/insert-into-loaded-dataset_01.1.ddl.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dml/insert-into-loaded-dataset_01/insert-into-loaded-dataset_01.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dml/insert-into-loaded-dataset_01/insert-into-loaded-dataset_01.1.ddl.sqlpp index e0625f3..25924b1 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dml/insert-into-loaded-dataset_01/insert-into-loaded-dataset_01.1.ddl.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dml/insert-into-loaded-dataset_01/insert-into-loaded-dataset_01.1.ddl.sqlpp @@ -25,9 +25,9 @@ use test; create type test.LineIDType as closed { - l_orderkey : int64, - l_linenumber : int64, - l_suppkey : int64 + l_orderkey : bigint, + l_linenumber : bigint, + l_suppkey : bigint } create dataset LineID(LineIDType) primary key l_orderkey,l_linenumber; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dml/insert-into-loaded-dataset_02/insert-into-loaded-dataset_02.1.ddl.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dml/insert-into-loaded-dataset_02/insert-into-loaded-dataset_02.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dml/insert-into-loaded-dataset_02/insert-into-loaded-dataset_02.1.ddl.sqlpp index 3431605..ec9cc92 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dml/insert-into-loaded-dataset_02/insert-into-loaded-dataset_02.1.ddl.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dml/insert-into-loaded-dataset_02/insert-into-loaded-dataset_02.1.ddl.sqlpp @@ -25,19 +25,19 @@ use test; create type test.Schema as closed { - unique1 : int64, - unique2 : int64, - two : int64, - four : int64, - ten : int64, - twenty : int64, - onePercent : int64, - tenPercent : int64, - twentyPercent : int64, - fiftyPercent : int64, - unique3 : int64, - evenOnePercent : int64, - oddOnePercent : int64, + unique1 : bigint, + unique2 : bigint, + two : bigint, + four : bigint, + ten : bigint, + twenty : bigint, + onePercent : bigint, + tenPercent : bigint, + twentyPercent : bigint, + fiftyPercent : bigint, + unique3 : bigint, + evenOnePercent : bigint, + oddOnePercent : bigint, stringu1 : string, stringu2 : string, string4 : string http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dml/insert-record-function/insert-record-function.1.ddl.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dml/insert-record-function/insert-record-function.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dml/insert-record-function/insert-record-function.1.ddl.sqlpp index 524ea84..ed8fa11 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dml/insert-record-function/insert-record-function.1.ddl.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dml/insert-record-function/insert-record-function.1.ddl.sqlpp @@ -31,9 +31,9 @@ use test; create type test.LineIDType as closed { - l_orderkey : int32, - l_linenumber : int32, - l_suppkey : int32 + l_orderkey : integer, + l_linenumber : integer, + l_suppkey : integer } create dataset LineID(LineIDType) primary key l_orderkey,l_linenumber; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dml/insert-syntax.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dml/insert-syntax.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dml/insert-syntax.sqlpp index 0c44e2c..59edd0e 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dml/insert-syntax.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dml/insert-syntax.sqlpp @@ -31,7 +31,7 @@ use testdv2; create type testdv2.testtype as { - id : int32, + id : integer, name : string } http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dml/insert-syntax/insert-syntax.1.ddl.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dml/insert-syntax/insert-syntax.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dml/insert-syntax/insert-syntax.1.ddl.sqlpp index 0427013..29fc85d 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dml/insert-syntax/insert-syntax.1.ddl.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dml/insert-syntax/insert-syntax.1.ddl.sqlpp @@ -31,7 +31,7 @@ use testdv2; create type testdv2.testtype as { - id : int64, + id : bigint, name : string } http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dml/insert/insert.1.ddl.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dml/insert/insert.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dml/insert/insert.1.ddl.sqlpp index 776097b..d2dcab1 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dml/insert/insert.1.ddl.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dml/insert/insert.1.ddl.sqlpp @@ -25,10 +25,10 @@ use test; create type test.LineItemType as closed { - l_orderkey : int64, - l_partkey : int64, - l_suppkey : int64, - l_linenumber : int64, + l_orderkey : bigint, + l_partkey : bigint, + l_suppkey : bigint, + l_linenumber : bigint, l_quantity : double, l_extendedprice : double, l_discount : double, @@ -45,9 +45,9 @@ create type test.LineItemType as create type test.LineIDType as closed { - l_orderkey : int64, - l_linenumber : int64, - l_suppkey : int64 + l_orderkey : bigint, + l_linenumber : bigint, + l_suppkey : bigint } create dataset LineItem(LineItemType) primary key l_orderkey,l_linenumber; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dml/insert_less_nc/insert_less_nc.1.ddl.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dml/insert_less_nc/insert_less_nc.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dml/insert_less_nc/insert_less_nc.1.ddl.sqlpp index 776097b..d2dcab1 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dml/insert_less_nc/insert_less_nc.1.ddl.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dml/insert_less_nc/insert_less_nc.1.ddl.sqlpp @@ -25,10 +25,10 @@ use test; create type test.LineItemType as closed { - l_orderkey : int64, - l_partkey : int64, - l_suppkey : int64, - l_linenumber : int64, + l_orderkey : bigint, + l_partkey : bigint, + l_suppkey : bigint, + l_linenumber : bigint, l_quantity : double, l_extendedprice : double, l_discount : double, @@ -45,9 +45,9 @@ create type test.LineItemType as create type test.LineIDType as closed { - l_orderkey : int64, - l_linenumber : int64, - l_suppkey : int64 + l_orderkey : bigint, + l_linenumber : bigint, + l_suppkey : bigint } create dataset LineItem(LineItemType) primary key l_orderkey,l_linenumber; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dml/load-from-hdfs/load-from-hdfs.1.ddl.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dml/load-from-hdfs/load-from-hdfs.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dml/load-from-hdfs/load-from-hdfs.1.ddl.sqlpp index 1a72d0d..25e3a2a 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dml/load-from-hdfs/load-from-hdfs.1.ddl.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dml/load-from-hdfs/load-from-hdfs.1.ddl.sqlpp @@ -25,10 +25,10 @@ use test; create type test.LineItemType as closed { - l_orderkey : int32, - l_partkey : int32, - l_suppkey : int32, - l_linenumber : int32, + l_orderkey : integer, + l_partkey : integer, + l_suppkey : integer, + l_linenumber : integer, l_quantity : double, l_extendedprice : double, l_discount : double, http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dml/load-with-index-open/load-with-index-open.1.ddl.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dml/load-with-index-open/load-with-index-open.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dml/load-with-index-open/load-with-index-open.1.ddl.sqlpp index 8df3377..9078b35 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dml/load-with-index-open/load-with-index-open.1.ddl.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dml/load-with-index-open/load-with-index-open.1.ddl.sqlpp @@ -25,10 +25,10 @@ use test; create type test.LineItemType as closed { - l_orderkey : int64, - l_partkey : int64, - l_suppkey : int64, - l_linenumber : int64, + l_orderkey : bigint, + l_partkey : bigint, + l_suppkey : bigint, + l_linenumber : bigint, l_quantity : double, l_extendedprice : double, l_discount : double, @@ -45,9 +45,9 @@ create type test.LineItemType as create type test.LineItemTypeOpen as { - l_orderkey : int64, - l_suppkey : int64, - l_linenumber : int64, + l_orderkey : bigint, + l_suppkey : bigint, + l_linenumber : bigint, l_quantity : double, l_extendedprice : double, l_discount : double, @@ -66,5 +66,5 @@ create dataset LineItemOpen(LineItemTypeOpen) primary key l_orderkey,l_linenumb create dataset LineItem(LineItemType) primary key l_orderkey,l_linenumber; -create index idx_partkey_open on LineItemOpen (l_partkey:int64?) type btree enforced; +create index idx_partkey_open on LineItemOpen (l_partkey:bigint?) type btree enforced; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dml/load-with-index/load-with-index.1.ddl.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dml/load-with-index/load-with-index.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dml/load-with-index/load-with-index.1.ddl.sqlpp index 82cae91..2f106ac 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dml/load-with-index/load-with-index.1.ddl.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/dml/load-with-index/load-with-index.1.ddl.sqlpp @@ -25,10 +25,10 @@ use test; create type test.LineItemType as closed { - l_orderkey : int64, - l_partkey : int64, - l_suppkey : int64, - l_linenumber : int64, + l_orderkey : bigint, + l_partkey : bigint, + l_suppkey : bigint, + l_linenumber : bigint, l_quantity : double, l_extendedprice : double, l_discount : double,