You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@asterixdb.apache.org by bu...@apache.org on 2016/09/23 03:14:48 UTC

[06/51] [partial] asterixdb git commit: ASTERIXDB-1539: add aliases for several builtin types and builtin functions.

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/binary/index_join/index_join.1.ast
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/binary/index_join/index_join.1.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/binary/index_join/index_join.1.ast
index 96c8ae2..8b091d1 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/binary/index_join/index_join.1.ast
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/binary/index_join/index_join.1.ast
@@ -1,7 +1,7 @@
 DataverseUse test
 TypeDecl UserType [
   closed RecordType {
-    id : int64,
+    id : bigint,
     name : string,
     md5 : binary
   }

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/binary/insert/insert.1.ast
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/binary/insert/insert.1.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/binary/insert/insert.1.ast
index 24e7402..f9b2a47 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/binary/insert/insert.1.ast
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/binary/insert/insert.1.ast
@@ -1,12 +1,12 @@
 DataverseUse test
 TypeDecl UserTypeOpen [
   open RecordType {
-    id : int64
+    id : bigint
   }
 ]
 TypeDecl UserTypeClose [
   closed RecordType {
-    id : int64,
+    id : bigint,
     name : string,
     md5 : binary
   }

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/comparison/datetime_range/datetime_range.1.ast
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/comparison/datetime_range/datetime_range.1.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/comparison/datetime_range/datetime_range.1.ast
index 2559edc..7948e98 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/comparison/datetime_range/datetime_range.1.ast
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/comparison/datetime_range/datetime_range.1.ast
@@ -1,8 +1,8 @@
 DataverseUse test
 TypeDecl Tweet [
   closed RecordType {
-    id : int64,
-    tweetid : int64,
+    id : bigint,
+    tweetid : bigint,
     loc : point,
     time : datetime,
     text : string

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/cross-dataverse/cross-dv01/cross-dv01.1.ast
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/cross-dataverse/cross-dv01/cross-dv01.1.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/cross-dataverse/cross-dv01/cross-dv01.1.ast
index 206f9fe..c3a4877 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/cross-dataverse/cross-dv01/cross-dv01.1.ast
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/cross-dataverse/cross-dv01/cross-dv01.1.ast
@@ -1,18 +1,18 @@
 DataverseUse teacher
 TypeDecl stdType [
   open RecordType {
-    id : int64,
+    id : bigint,
     name : string,
-    age : int64,
+    age : bigint,
     sex : string,
     dept : string
   }
 ]
 TypeDecl tchrType [
   open RecordType {
-    id : int64,
+    id : bigint,
     name : string,
-    age : int64,
+    age : bigint,
     sex : string,
     dept : string
   }

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/cross-dataverse/cross-dv02/cross-dv02.1.ast
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/cross-dataverse/cross-dv02/cross-dv02.1.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/cross-dataverse/cross-dv02/cross-dv02.1.ast
index f18557f..c5b7f5c 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/cross-dataverse/cross-dv02/cross-dv02.1.ast
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/cross-dataverse/cross-dv02/cross-dv02.1.ast
@@ -1,17 +1,17 @@
 TypeDecl stdType [
   open RecordType {
-    id : int32,
+    id : integer,
     name : string,
-    age : int32,
+    age : integer,
     sex : string,
     dept : string
   }
 ]
 TypeDecl tchrType [
   open RecordType {
-    id : int32,
+    id : integer,
     name : string,
-    age : int32,
+    age : integer,
     sex : string,
     dept : string
   }

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/cross-dataverse/cross-dv03/cross-dv03.1.ast
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/cross-dataverse/cross-dv03/cross-dv03.1.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/cross-dataverse/cross-dv03/cross-dv03.1.ast
index 510f8d5..e1608e8 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/cross-dataverse/cross-dv03/cross-dv03.1.ast
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/cross-dataverse/cross-dv03/cross-dv03.1.ast
@@ -1,17 +1,17 @@
 TypeDecl stdType [
   open RecordType {
-    id : int64,
+    id : bigint,
     name : string,
-    age : int64,
+    age : bigint,
     sex : string,
     dept : string
   }
 ]
 TypeDecl tchrType [
   open RecordType {
-    id : int64,
+    id : bigint,
     name : string,
-    age : int64,
+    age : bigint,
     sex : string,
     dept : string
   }

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/cross-dataverse/cross-dv04/cross-dv04.1.ast
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/cross-dataverse/cross-dv04/cross-dv04.1.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/cross-dataverse/cross-dv04/cross-dv04.1.ast
index 1f091a2..4db1638 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/cross-dataverse/cross-dv04/cross-dv04.1.ast
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/cross-dataverse/cross-dv04/cross-dv04.1.ast
@@ -1,17 +1,17 @@
 TypeDecl stdType [
   open RecordType {
-    id : int32,
+    id : integer,
     name : string,
-    age : int32,
+    age : integer,
     sex : string,
     dept : string
   }
 ]
 TypeDecl tchrType [
   open RecordType {
-    id : int32,
+    id : integer,
     name : string,
-    age : int32,
+    age : integer,
     sex : string,
     dept : string
   }

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/cross-dataverse/cross-dv07/cross-dv07.1.ast
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/cross-dataverse/cross-dv07/cross-dv07.1.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/cross-dataverse/cross-dv07/cross-dv07.1.ast
index d6a98f6..d8ba369 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/cross-dataverse/cross-dv07/cross-dv07.1.ast
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/cross-dataverse/cross-dv07/cross-dv07.1.ast
@@ -1,9 +1,9 @@
 TypeDecl Emp [
   closed RecordType {
-    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/results_parser_sqlpp/cross-dataverse/cross-dv19/cross-dv19.1.ast
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/cross-dataverse/cross-dv19/cross-dv19.1.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/cross-dataverse/cross-dv19/cross-dv19.1.ast
index 87091e3..b920c11 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/cross-dataverse/cross-dv19/cross-dv19.1.ast
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/cross-dataverse/cross-dv19/cross-dv19.1.ast
@@ -1,6 +1,6 @@
 TypeDecl testtype [
   open RecordType {
-    id : int32,
+    id : integer,
     name : string,
     loc : point,
     time : datetime
@@ -8,7 +8,7 @@ TypeDecl testtype [
 ]
 TypeDecl testtype [
   open RecordType {
-    id : int32,
+    id : integer,
     name : string?,
     loc : point,
     time : datetime
@@ -16,8 +16,8 @@ TypeDecl testtype [
 ]
 TypeDecl Tweet [
   open RecordType {
-    id : int32,
-    tweetid : int64,
+    id : integer,
+    tweetid : bigint,
     loc : point,
     time : datetime,
     text : string

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/cross-dataverse/cross-dv20/cross-dv20.1.ast
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/cross-dataverse/cross-dv20/cross-dv20.1.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/cross-dataverse/cross-dv20/cross-dv20.1.ast
index 510f8d5..e1608e8 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/cross-dataverse/cross-dv20/cross-dv20.1.ast
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/cross-dataverse/cross-dv20/cross-dv20.1.ast
@@ -1,17 +1,17 @@
 TypeDecl stdType [
   open RecordType {
-    id : int64,
+    id : bigint,
     name : string,
-    age : int64,
+    age : bigint,
     sex : string,
     dept : string
   }
 ]
 TypeDecl tchrType [
   open RecordType {
-    id : int64,
+    id : bigint,
     name : string,
-    age : int64,
+    age : bigint,
     sex : string,
     dept : string
   }

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/cross-dataverse/insert_across_dataverses/insert_across_dataverses.1.ast
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/cross-dataverse/insert_across_dataverses/insert_across_dataverses.1.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/cross-dataverse/insert_across_dataverses/insert_across_dataverses.1.ast
index b0b828b..3f24d32 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/cross-dataverse/insert_across_dataverses/insert_across_dataverses.1.ast
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/cross-dataverse/insert_across_dataverses/insert_across_dataverses.1.ast
@@ -1,19 +1,19 @@
 TypeDecl AddressType [
   open RecordType {
-    number : int64,
+    number : bigint,
     street : string,
     city : string
   }
 ]
 TypeDecl CustomerType [
   closed RecordType {
-    cid : int64,
+    cid : bigint,
     name : string,
-    cashBack : int64,
-    age : int64?,
+    cashBack : bigint,
+    age : bigint?,
     address : AddressType?,
     lastorder :       open RecordType {
-        oid : int64,
+        oid : bigint,
         total : float
       }
 
@@ -21,20 +21,20 @@ TypeDecl CustomerType [
 ]
 TypeDecl AddressType [
   open RecordType {
-    number : int64,
+    number : bigint,
     street : string,
     city : string
   }
 ]
 TypeDecl CustomerType [
   closed RecordType {
-    cid : int64,
+    cid : bigint,
     name : string,
-    cashBack : int64,
-    age : int64?,
+    cashBack : bigint,
+    age : bigint?,
     address : AddressType?,
     lastorder :       open RecordType {
-        oid : int64,
+        oid : bigint,
         total : float
       }
 

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/cross-dataverse/join_across_dataverses/join_across_dataverses.1.ast
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/cross-dataverse/join_across_dataverses/join_across_dataverses.1.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/cross-dataverse/join_across_dataverses/join_across_dataverses.1.ast
index e7b82b6..dffb15d 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/cross-dataverse/join_across_dataverses/join_across_dataverses.1.ast
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/cross-dataverse/join_across_dataverses/join_across_dataverses.1.ast
@@ -1,19 +1,19 @@
 TypeDecl AddressType [
   open RecordType {
-    number : int64,
+    number : bigint,
     street : string,
     city : string
   }
 ]
 TypeDecl CustomerType [
   closed RecordType {
-    cid : int64,
+    cid : bigint,
     name : string,
-    cashBack : int64,
-    age : int64?,
+    cashBack : bigint,
+    age : bigint?,
     address : AddressType?,
     lastorder :       open RecordType {
-        oid : int64,
+        oid : bigint,
         total : float
       }
 
@@ -22,13 +22,13 @@ TypeDecl CustomerType [
 DatasetDecl Customers(CustomerType) partitioned by [[cid]]
 TypeDecl OrderType [
   open RecordType {
-    oid : int64,
-    cid : int64,
+    oid : bigint,
+    cid : bigint,
     orderstatus : string,
     orderpriority : string,
     clerk : string,
     total : float,
-    items : OrderedList [int64]
+    items : OrderedList [bigint]
 
   }
 ]

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/csv/basic-types/basic-types.1.ast
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/csv/basic-types/basic-types.1.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/csv/basic-types/basic-types.1.ast
index 2db3f6b..00b91bb 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/csv/basic-types/basic-types.1.ast
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/csv/basic-types/basic-types.1.ast
@@ -1,15 +1,15 @@
 DataverseUse test
 TypeDecl AllType [
   open RecordType {
-    id : int64,
+    id : bigint,
     string : string,
     float : float,
     double : double,
     boolean : boolean,
-    int8 : int8,
-    int16 : int16,
-    int32 : int32,
-    int64 : int64,
+    int8 : tinyint,
+    int16 : smallint,
+    int32 : integer,
+    int64 : bigint,
     date : date,
     time : time,
     datetime : datetime,

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/custord/customer_q_01/customer_q_01.1.ast
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/custord/customer_q_01/customer_q_01.1.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/custord/customer_q_01/customer_q_01.1.ast
index d1a7252..5bc3978 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/custord/customer_q_01/customer_q_01.1.ast
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/custord/customer_q_01/customer_q_01.1.ast
@@ -1,20 +1,20 @@
 DataverseUse test
 TypeDecl AddressType [
   open RecordType {
-    number : int64,
+    number : bigint,
     street : string,
     city : string
   }
 ]
 TypeDecl CustomerType [
   closed RecordType {
-    cid : int64,
+    cid : bigint,
     name : string,
-    cashBack : int64,
-    age : int64?,
+    cashBack : bigint,
+    age : bigint?,
     address : AddressType?,
     lastorder :       open RecordType {
-        oid : int64,
+        oid : bigint,
         total : float
       }
 

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/custord/customer_q_02/customer_q_02.1.ast
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/custord/customer_q_02/customer_q_02.1.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/custord/customer_q_02/customer_q_02.1.ast
index e279376..5711429 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/custord/customer_q_02/customer_q_02.1.ast
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/custord/customer_q_02/customer_q_02.1.ast
@@ -1,20 +1,20 @@
 DataverseUse test
 TypeDecl AddressType [
   open RecordType {
-    number : int32,
+    number : integer,
     street : string,
     city : string
   }
 ]
 TypeDecl CustomerType [
   closed RecordType {
-    cid : int64,
+    cid : bigint,
     name : string,
-    cashBack : int64,
-    age : int64?,
+    cashBack : bigint,
+    age : bigint?,
     address : AddressType?,
     lastorder :       open RecordType {
-        oid : int64,
+        oid : bigint,
         total : float
       }
 

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/custord/customer_q_03/customer_q_03.1.ast
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/custord/customer_q_03/customer_q_03.1.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/custord/customer_q_03/customer_q_03.1.ast
index e279376..5711429 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/custord/customer_q_03/customer_q_03.1.ast
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/custord/customer_q_03/customer_q_03.1.ast
@@ -1,20 +1,20 @@
 DataverseUse test
 TypeDecl AddressType [
   open RecordType {
-    number : int32,
+    number : integer,
     street : string,
     city : string
   }
 ]
 TypeDecl CustomerType [
   closed RecordType {
-    cid : int64,
+    cid : bigint,
     name : string,
-    cashBack : int64,
-    age : int64?,
+    cashBack : bigint,
+    age : bigint?,
     address : AddressType?,
     lastorder :       open RecordType {
-        oid : int64,
+        oid : bigint,
         total : float
       }
 

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/custord/customer_q_04/customer_q_04.1.ast
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/custord/customer_q_04/customer_q_04.1.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/custord/customer_q_04/customer_q_04.1.ast
index e279376..5711429 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/custord/customer_q_04/customer_q_04.1.ast
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/custord/customer_q_04/customer_q_04.1.ast
@@ -1,20 +1,20 @@
 DataverseUse test
 TypeDecl AddressType [
   open RecordType {
-    number : int32,
+    number : integer,
     street : string,
     city : string
   }
 ]
 TypeDecl CustomerType [
   closed RecordType {
-    cid : int64,
+    cid : bigint,
     name : string,
-    cashBack : int64,
-    age : int64?,
+    cashBack : bigint,
+    age : bigint?,
     address : AddressType?,
     lastorder :       open RecordType {
-        oid : int64,
+        oid : bigint,
         total : float
       }
 

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/custord/customer_q_05/customer_q_05.1.ast
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/custord/customer_q_05/customer_q_05.1.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/custord/customer_q_05/customer_q_05.1.ast
index e279376..5711429 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/custord/customer_q_05/customer_q_05.1.ast
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/custord/customer_q_05/customer_q_05.1.ast
@@ -1,20 +1,20 @@
 DataverseUse test
 TypeDecl AddressType [
   open RecordType {
-    number : int32,
+    number : integer,
     street : string,
     city : string
   }
 ]
 TypeDecl CustomerType [
   closed RecordType {
-    cid : int64,
+    cid : bigint,
     name : string,
-    cashBack : int64,
-    age : int64?,
+    cashBack : bigint,
+    age : bigint?,
     address : AddressType?,
     lastorder :       open RecordType {
-        oid : int64,
+        oid : bigint,
         total : float
       }
 

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/custord/customer_q_06/customer_q_06.1.ast
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/custord/customer_q_06/customer_q_06.1.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/custord/customer_q_06/customer_q_06.1.ast
index d1a7252..5bc3978 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/custord/customer_q_06/customer_q_06.1.ast
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/custord/customer_q_06/customer_q_06.1.ast
@@ -1,20 +1,20 @@
 DataverseUse test
 TypeDecl AddressType [
   open RecordType {
-    number : int64,
+    number : bigint,
     street : string,
     city : string
   }
 ]
 TypeDecl CustomerType [
   closed RecordType {
-    cid : int64,
+    cid : bigint,
     name : string,
-    cashBack : int64,
-    age : int64?,
+    cashBack : bigint,
+    age : bigint?,
     address : AddressType?,
     lastorder :       open RecordType {
-        oid : int64,
+        oid : bigint,
         total : float
       }
 

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/custord/customer_q_07/customer_q_07.1.ast
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/custord/customer_q_07/customer_q_07.1.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/custord/customer_q_07/customer_q_07.1.ast
index d1a7252..5bc3978 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/custord/customer_q_07/customer_q_07.1.ast
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/custord/customer_q_07/customer_q_07.1.ast
@@ -1,20 +1,20 @@
 DataverseUse test
 TypeDecl AddressType [
   open RecordType {
-    number : int64,
+    number : bigint,
     street : string,
     city : string
   }
 ]
 TypeDecl CustomerType [
   closed RecordType {
-    cid : int64,
+    cid : bigint,
     name : string,
-    cashBack : int64,
-    age : int64?,
+    cashBack : bigint,
+    age : bigint?,
     address : AddressType?,
     lastorder :       open RecordType {
-        oid : int64,
+        oid : bigint,
         total : float
       }
 

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/custord/customer_q_08/customer_q_08.1.ast
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/custord/customer_q_08/customer_q_08.1.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/custord/customer_q_08/customer_q_08.1.ast
index d1a7252..5bc3978 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/custord/customer_q_08/customer_q_08.1.ast
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/custord/customer_q_08/customer_q_08.1.ast
@@ -1,20 +1,20 @@
 DataverseUse test
 TypeDecl AddressType [
   open RecordType {
-    number : int64,
+    number : bigint,
     street : string,
     city : string
   }
 ]
 TypeDecl CustomerType [
   closed RecordType {
-    cid : int64,
+    cid : bigint,
     name : string,
-    cashBack : int64,
-    age : int64?,
+    cashBack : bigint,
+    age : bigint?,
     address : AddressType?,
     lastorder :       open RecordType {
-        oid : int64,
+        oid : bigint,
         total : float
       }
 

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/custord/denorm-cust-order_02/denorm-cust-order_02.1.ast
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/custord/denorm-cust-order_02/denorm-cust-order_02.1.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/custord/denorm-cust-order_02/denorm-cust-order_02.1.ast
index ec381af..718ae54 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/custord/denorm-cust-order_02/denorm-cust-order_02.1.ast
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/custord/denorm-cust-order_02/denorm-cust-order_02.1.ast
@@ -1,19 +1,19 @@
 DataverseUse test
 TypeDecl AddressType [
   open RecordType {
-    number : int64,
+    number : bigint,
     street : string,
     city : string
   }
 ]
 TypeDecl CustomerType [
   open RecordType {
-    cid : int64,
+    cid : bigint,
     name : string,
-    age : int64?,
+    age : bigint?,
     address : AddressType?,
     lastorder :       open RecordType {
-        oid : int64,
+        oid : bigint,
         total : float
       }
 
@@ -21,8 +21,8 @@ TypeDecl CustomerType [
 ]
 TypeDecl OrderType [
   open RecordType {
-    oid : int64,
-    cid : int64,
+    oid : bigint,
+    cid : bigint,
     orderstatus : string,
     orderpriority : string,
     clerk : string,
@@ -31,7 +31,7 @@ TypeDecl OrderType [
 ]
 TypeDecl CustomerOrdersType [
   open RecordType {
-    cid : int64,
+    cid : bigint,
     cust : CustomerType,
     orders : OrderedList [OrderType]
 

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/custord/join_q_01/join_q_01.1.ast
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/custord/join_q_01/join_q_01.1.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/custord/join_q_01/join_q_01.1.ast
index 7509a02..104d0a3 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/custord/join_q_01/join_q_01.1.ast
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/custord/join_q_01/join_q_01.1.ast
@@ -1,20 +1,20 @@
 DataverseUse test
 TypeDecl AddressType [
   open RecordType {
-    number : int64,
+    number : bigint,
     street : string,
     city : string
   }
 ]
 TypeDecl CustomerType [
   closed RecordType {
-    cid : int64,
+    cid : bigint,
     name : string,
-    cashBack : int64,
-    age : int64?,
+    cashBack : bigint,
+    age : bigint?,
     address : AddressType?,
     lastorder :       open RecordType {
-        oid : int64,
+        oid : bigint,
         total : float
       }
 
@@ -22,13 +22,13 @@ TypeDecl CustomerType [
 ]
 TypeDecl OrderType [
   open RecordType {
-    oid : int64,
-    cid : int64,
+    oid : bigint,
+    cid : bigint,
     orderstatus : string,
     orderpriority : string,
     clerk : string,
     total : float,
-    items : OrderedList [int64]
+    items : OrderedList [bigint]
 
   }
 ]

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/custord/join_q_02/join_q_02.1.ast
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/custord/join_q_02/join_q_02.1.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/custord/join_q_02/join_q_02.1.ast
index 7509a02..104d0a3 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/custord/join_q_02/join_q_02.1.ast
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/custord/join_q_02/join_q_02.1.ast
@@ -1,20 +1,20 @@
 DataverseUse test
 TypeDecl AddressType [
   open RecordType {
-    number : int64,
+    number : bigint,
     street : string,
     city : string
   }
 ]
 TypeDecl CustomerType [
   closed RecordType {
-    cid : int64,
+    cid : bigint,
     name : string,
-    cashBack : int64,
-    age : int64?,
+    cashBack : bigint,
+    age : bigint?,
     address : AddressType?,
     lastorder :       open RecordType {
-        oid : int64,
+        oid : bigint,
         total : float
       }
 
@@ -22,13 +22,13 @@ TypeDecl CustomerType [
 ]
 TypeDecl OrderType [
   open RecordType {
-    oid : int64,
-    cid : int64,
+    oid : bigint,
+    cid : bigint,
     orderstatus : string,
     orderpriority : string,
     clerk : string,
     total : float,
-    items : OrderedList [int64]
+    items : OrderedList [bigint]
 
   }
 ]

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/custord/join_q_03/join_q_03.1.ast
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/custord/join_q_03/join_q_03.1.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/custord/join_q_03/join_q_03.1.ast
index 7509a02..104d0a3 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/custord/join_q_03/join_q_03.1.ast
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/custord/join_q_03/join_q_03.1.ast
@@ -1,20 +1,20 @@
 DataverseUse test
 TypeDecl AddressType [
   open RecordType {
-    number : int64,
+    number : bigint,
     street : string,
     city : string
   }
 ]
 TypeDecl CustomerType [
   closed RecordType {
-    cid : int64,
+    cid : bigint,
     name : string,
-    cashBack : int64,
-    age : int64?,
+    cashBack : bigint,
+    age : bigint?,
     address : AddressType?,
     lastorder :       open RecordType {
-        oid : int64,
+        oid : bigint,
         total : float
       }
 
@@ -22,13 +22,13 @@ TypeDecl CustomerType [
 ]
 TypeDecl OrderType [
   open RecordType {
-    oid : int64,
-    cid : int64,
+    oid : bigint,
+    cid : bigint,
     orderstatus : string,
     orderpriority : string,
     clerk : string,
     total : float,
-    items : OrderedList [int64]
+    items : OrderedList [bigint]
 
   }
 ]

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/custord/join_q_04/join_q_04.1.ast
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/custord/join_q_04/join_q_04.1.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/custord/join_q_04/join_q_04.1.ast
index 7509a02..104d0a3 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/custord/join_q_04/join_q_04.1.ast
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/custord/join_q_04/join_q_04.1.ast
@@ -1,20 +1,20 @@
 DataverseUse test
 TypeDecl AddressType [
   open RecordType {
-    number : int64,
+    number : bigint,
     street : string,
     city : string
   }
 ]
 TypeDecl CustomerType [
   closed RecordType {
-    cid : int64,
+    cid : bigint,
     name : string,
-    cashBack : int64,
-    age : int64?,
+    cashBack : bigint,
+    age : bigint?,
     address : AddressType?,
     lastorder :       open RecordType {
-        oid : int64,
+        oid : bigint,
         total : float
       }
 
@@ -22,13 +22,13 @@ TypeDecl CustomerType [
 ]
 TypeDecl OrderType [
   open RecordType {
-    oid : int64,
-    cid : int64,
+    oid : bigint,
+    cid : bigint,
     orderstatus : string,
     orderpriority : string,
     clerk : string,
     total : float,
-    items : OrderedList [int64]
+    items : OrderedList [bigint]
 
   }
 ]

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/custord/load-test/load-test.1.ast
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/custord/load-test/load-test.1.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/custord/load-test/load-test.1.ast
index 9132f14..036ada8 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/custord/load-test/load-test.1.ast
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/custord/load-test/load-test.1.ast
@@ -1,19 +1,19 @@
 DataverseUse test
 TypeDecl AddressType [
   open RecordType {
-    number : int64,
+    number : bigint,
     street : string,
     city : string
   }
 ]
 TypeDecl CustomerType [
   open RecordType {
-    cid : int64,
+    cid : bigint,
     name : string,
-    age : int64?,
+    age : bigint?,
     address : AddressType?,
     lastorder :       open RecordType {
-        oid : int64,
+        oid : bigint,
         total : float
       }
 

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/custord/order_q_01/order_q_01.1.ast
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/custord/order_q_01/order_q_01.1.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/custord/order_q_01/order_q_01.1.ast
index 2865318..b115a83 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/custord/order_q_01/order_q_01.1.ast
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/custord/order_q_01/order_q_01.1.ast
@@ -1,13 +1,13 @@
 DataverseUse test
 TypeDecl OrderType [
   open RecordType {
-    oid : int64,
-    cid : int64,
+    oid : bigint,
+    cid : bigint,
     orderstatus : string,
     orderpriority : string,
     clerk : string,
     total : float,
-    items : OrderedList [int64]
+    items : OrderedList [bigint]
 
   }
 ]

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/custord/order_q_02/order_q_02.1.ast
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/custord/order_q_02/order_q_02.1.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/custord/order_q_02/order_q_02.1.ast
index 2865318..b115a83 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/custord/order_q_02/order_q_02.1.ast
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/custord/order_q_02/order_q_02.1.ast
@@ -1,13 +1,13 @@
 DataverseUse test
 TypeDecl OrderType [
   open RecordType {
-    oid : int64,
-    cid : int64,
+    oid : bigint,
+    cid : bigint,
     orderstatus : string,
     orderpriority : string,
     clerk : string,
     total : float,
-    items : OrderedList [int64]
+    items : OrderedList [bigint]
 
   }
 ]

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/custord/order_q_03/order_q_03.1.ast
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/custord/order_q_03/order_q_03.1.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/custord/order_q_03/order_q_03.1.ast
index 2865318..b115a83 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/custord/order_q_03/order_q_03.1.ast
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/custord/order_q_03/order_q_03.1.ast
@@ -1,13 +1,13 @@
 DataverseUse test
 TypeDecl OrderType [
   open RecordType {
-    oid : int64,
-    cid : int64,
+    oid : bigint,
+    cid : bigint,
     orderstatus : string,
     orderpriority : string,
     clerk : string,
     total : float,
-    items : OrderedList [int64]
+    items : OrderedList [bigint]
 
   }
 ]

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/custord/order_q_04/order_q_04.1.ast
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/custord/order_q_04/order_q_04.1.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/custord/order_q_04/order_q_04.1.ast
index 2865318..b115a83 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/custord/order_q_04/order_q_04.1.ast
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/custord/order_q_04/order_q_04.1.ast
@@ -1,13 +1,13 @@
 DataverseUse test
 TypeDecl OrderType [
   open RecordType {
-    oid : int64,
-    cid : int64,
+    oid : bigint,
+    cid : bigint,
     orderstatus : string,
     orderpriority : string,
     clerk : string,
     total : float,
-    items : OrderedList [int64]
+    items : OrderedList [bigint]
 
   }
 ]

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/custord/order_q_05/order_q_05.1.ast
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/custord/order_q_05/order_q_05.1.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/custord/order_q_05/order_q_05.1.ast
index 2865318..b115a83 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/custord/order_q_05/order_q_05.1.ast
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/custord/order_q_05/order_q_05.1.ast
@@ -1,13 +1,13 @@
 DataverseUse test
 TypeDecl OrderType [
   open RecordType {
-    oid : int64,
-    cid : int64,
+    oid : bigint,
+    cid : bigint,
     orderstatus : string,
     orderpriority : string,
     clerk : string,
     total : float,
-    items : OrderedList [int64]
+    items : OrderedList [bigint]
 
   }
 ]

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/custord/order_q_06/order_q_06.1.ast
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/custord/order_q_06/order_q_06.1.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/custord/order_q_06/order_q_06.1.ast
index 2865318..b115a83 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/custord/order_q_06/order_q_06.1.ast
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/custord/order_q_06/order_q_06.1.ast
@@ -1,13 +1,13 @@
 DataverseUse test
 TypeDecl OrderType [
   open RecordType {
-    oid : int64,
-    cid : int64,
+    oid : bigint,
+    cid : bigint,
     orderstatus : string,
     orderpriority : string,
     clerk : string,
     total : float,
-    items : OrderedList [int64]
+    items : OrderedList [bigint]
 
   }
 ]

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/dapd/q1/q1.1.ast
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/dapd/q1/q1.1.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/dapd/q1/q1.1.ast
index ccfb888..834287c 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/dapd/q1/q1.1.ast
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/dapd/q1/q1.1.ast
@@ -15,7 +15,7 @@ TypeDecl UserType [
 ,
     address : AddressType,
     member_of : UnorderedList <          open RecordType {
-            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/results_parser_sqlpp/dapd/q2/q2.1.ast
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/dapd/q2/q2.1.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/dapd/q2/q2.1.ast
index b8ae596..817ffab 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/dapd/q2/q2.1.ast
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/dapd/q2/q2.1.ast
@@ -9,7 +9,7 @@ TypeDecl AddressType [
 ]
 TypeDecl EventType [
   closed RecordType {
-    event_id : int64,
+    event_id : bigint,
     name : string,
     location : AddressType?,
     organizers : UnorderedList <          open RecordType {
@@ -18,7 +18,7 @@ TypeDecl EventType [
 >
 ,
     sponsoring_sigs : OrderedList [          open RecordType {
-            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/results_parser_sqlpp/dml/compact-dataset-and-its-indexes/compact-dataset-and-its-indexes.1.ast
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/dml/compact-dataset-and-its-indexes/compact-dataset-and-its-indexes.1.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/dml/compact-dataset-and-its-indexes/compact-dataset-and-its-indexes.1.ast
index 02109d8..2192c6c 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/dml/compact-dataset-and-its-indexes/compact-dataset-and-its-indexes.1.ast
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/dml/compact-dataset-and-its-indexes/compact-dataset-and-its-indexes.1.ast
@@ -1,11 +1,11 @@
 DataverseUse test
 TypeDecl LineItemType [
   closed RecordType {
-    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/results_parser_sqlpp/dml/create-drop-cltype/create-drop-cltype.1.ast
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/dml/create-drop-cltype/create-drop-cltype.1.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/dml/create-drop-cltype/create-drop-cltype.1.ast
index c3adfcb..b87cba4 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/dml/create-drop-cltype/create-drop-cltype.1.ast
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/dml/create-drop-cltype/create-drop-cltype.1.ast
@@ -1,7 +1,7 @@
 DataverseUse test
 TypeDecl TestType [
   closed RecordType {
-    id : int32,
+    id : integer,
     salary : double?,
     name : string,
     durtn : duration?,
@@ -13,7 +13,7 @@ TypeDecl TestType [
 ]
 TypeDecl TestType [
   closed RecordType {
-    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/results_parser_sqlpp/dml/create-drop-opntype/create-drop-opntype.1.ast
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/dml/create-drop-opntype/create-drop-opntype.1.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/dml/create-drop-opntype/create-drop-opntype.1.ast
index 32a41ac..424a94c 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/dml/create-drop-opntype/create-drop-opntype.1.ast
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/dml/create-drop-opntype/create-drop-opntype.1.ast
@@ -1,7 +1,7 @@
 DataverseUse test
 TypeDecl TestType [
   open RecordType {
-    id : int32,
+    id : integer,
     salary : double?,
     name : string,
     durtn : duration?,
@@ -13,7 +13,7 @@ TypeDecl TestType [
 ]
 TypeDecl TestType [
   open RecordType {
-    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/results_parser_sqlpp/dml/delete-from-loaded-dataset-with-index/delete-from-loaded-dataset-with-index.1.ast
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/dml/delete-from-loaded-dataset-with-index/delete-from-loaded-dataset-with-index.1.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/dml/delete-from-loaded-dataset-with-index/delete-from-loaded-dataset-with-index.1.ast
index 02109d8..2192c6c 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/dml/delete-from-loaded-dataset-with-index/delete-from-loaded-dataset-with-index.1.ast
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/dml/delete-from-loaded-dataset-with-index/delete-from-loaded-dataset-with-index.1.ast
@@ -1,11 +1,11 @@
 DataverseUse test
 TypeDecl LineItemType [
   closed RecordType {
-    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/results_parser_sqlpp/dml/delete-from-loaded-dataset/delete-from-loaded-dataset.1.ast
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/dml/delete-from-loaded-dataset/delete-from-loaded-dataset.1.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/dml/delete-from-loaded-dataset/delete-from-loaded-dataset.1.ast
index 02109d8..2192c6c 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/dml/delete-from-loaded-dataset/delete-from-loaded-dataset.1.ast
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/dml/delete-from-loaded-dataset/delete-from-loaded-dataset.1.ast
@@ -1,11 +1,11 @@
 DataverseUse test
 TypeDecl LineItemType [
   closed RecordType {
-    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/results_parser_sqlpp/dml/delete-multi-statement/delete-multi-statement.1.ast
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/dml/delete-multi-statement/delete-multi-statement.1.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/dml/delete-multi-statement/delete-multi-statement.1.ast
index c3efb40..a3cd98f 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/dml/delete-multi-statement/delete-multi-statement.1.ast
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/dml/delete-multi-statement/delete-multi-statement.1.ast
@@ -1,11 +1,11 @@
 DataverseUse tpch
 TypeDecl LineItemType [
   closed RecordType {
-    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,
@@ -21,23 +21,23 @@ TypeDecl LineItemType [
 ]
 TypeDecl OrderType [
   closed RecordType {
-    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
   }
 ]
 TypeDecl CustomerType [
   closed RecordType {
-    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,
@@ -46,10 +46,10 @@ TypeDecl CustomerType [
 ]
 TypeDecl SupplierType [
   closed RecordType {
-    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
@@ -57,27 +57,27 @@ TypeDecl SupplierType [
 ]
 TypeDecl NationType [
   closed RecordType {
-    n_nationkey : int32,
+    n_nationkey : integer,
     n_name : string,
-    n_regionkey : int32,
+    n_regionkey : integer,
     n_comment : string
   }
 ]
 TypeDecl RegionType [
   closed RecordType {
-    r_regionkey : int32,
+    r_regionkey : integer,
     r_name : string,
     r_comment : string
   }
 ]
 TypeDecl PartType [
   closed RecordType {
-    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
@@ -85,9 +85,9 @@ TypeDecl PartType [
 ]
 TypeDecl PartSuppType [
   closed RecordType {
-    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/results_parser_sqlpp/dml/delete-syntax-change/delete-syntax-change.1.ast
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/dml/delete-syntax-change/delete-syntax-change.1.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/dml/delete-syntax-change/delete-syntax-change.1.ast
index 02109d8..2192c6c 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/dml/delete-syntax-change/delete-syntax-change.1.ast
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/dml/delete-syntax-change/delete-syntax-change.1.ast
@@ -1,11 +1,11 @@
 DataverseUse test
 TypeDecl LineItemType [
   closed RecordType {
-    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/results_parser_sqlpp/dml/drop-empty-secondary-indexes/drop-empty-secondary-indexes.1.ast
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/dml/drop-empty-secondary-indexes/drop-empty-secondary-indexes.1.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/dml/drop-empty-secondary-indexes/drop-empty-secondary-indexes.1.ast
index 2e844ca..27e4cf5 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/dml/drop-empty-secondary-indexes/drop-empty-secondary-indexes.1.ast
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/dml/drop-empty-secondary-indexes/drop-empty-secondary-indexes.1.ast
@@ -12,7 +12,7 @@ TypeDecl Person [
 ]
 TypeDecl TestType [
   open RecordType {
-    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/results_parser_sqlpp/dml/drop-index/drop-index.1.ast
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/dml/drop-index/drop-index.1.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/dml/drop-index/drop-index.1.ast
index bbc2751..13f1f01 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/dml/drop-index/drop-index.1.ast
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/dml/drop-index/drop-index.1.ast
@@ -1,19 +1,19 @@
 DataverseUse test
 TypeDecl Schema [
   closed RecordType {
-    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/results_parser_sqlpp/dml/empty-load-with-index/empty-load-with-index.1.ast
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/dml/empty-load-with-index/empty-load-with-index.1.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/dml/empty-load-with-index/empty-load-with-index.1.ast
index 9f0be39..17dc8b5 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/dml/empty-load-with-index/empty-load-with-index.1.ast
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/dml/empty-load-with-index/empty-load-with-index.1.ast
@@ -1,10 +1,10 @@
 DataverseUse test
 TypeDecl LineItemType [
   closed RecordType {
-    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/results_parser_sqlpp/dml/insert-and-scan-dataset-with-index/insert-and-scan-dataset-with-index.1.ast
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/dml/insert-and-scan-dataset-with-index/insert-and-scan-dataset-with-index.1.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/dml/insert-and-scan-dataset-with-index/insert-and-scan-dataset-with-index.1.ast
index 8181f54..2cbcb0b 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/dml/insert-and-scan-dataset-with-index/insert-and-scan-dataset-with-index.1.ast
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/dml/insert-and-scan-dataset-with-index/insert-and-scan-dataset-with-index.1.ast
@@ -1,10 +1,10 @@
 DataverseUse test
 TypeDecl Emp [
   closed RecordType {
-    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/results_parser_sqlpp/dml/insert-and-scan-dataset/insert-and-scan-dataset.1.ast
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/dml/insert-and-scan-dataset/insert-and-scan-dataset.1.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/dml/insert-and-scan-dataset/insert-and-scan-dataset.1.ast
index 537173f..d546e56 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/dml/insert-and-scan-dataset/insert-and-scan-dataset.1.ast
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/dml/insert-and-scan-dataset/insert-and-scan-dataset.1.ast
@@ -1,7 +1,7 @@
 DataverseUse test
 TypeDecl myDataType [
   open RecordType {
-    id : int64
+    id : bigint
   }
 ]
 DatasetDecl myData(myDataType) partitioned by [[id]]

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/dml/insert-and-scan-joined-datasets/insert-and-scan-joined-datasets.1.ast
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/dml/insert-and-scan-joined-datasets/insert-and-scan-joined-datasets.1.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/dml/insert-and-scan-joined-datasets/insert-and-scan-joined-datasets.1.ast
index 894f97c..c4a48e1 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/dml/insert-and-scan-joined-datasets/insert-and-scan-joined-datasets.1.ast
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/dml/insert-and-scan-joined-datasets/insert-and-scan-joined-datasets.1.ast
@@ -1,7 +1,7 @@
 DataverseUse test
 TypeDecl myDataType [
   open RecordType {
-    id : int64
+    id : bigint
   }
 ]
 DatasetDecl myData(myDataType) partitioned by [[id]]

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/dml/insert-duplicated-keys/insert-duplicated-keys.1.ast
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/dml/insert-duplicated-keys/insert-duplicated-keys.1.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/dml/insert-duplicated-keys/insert-duplicated-keys.1.ast
index 150c083..5c68a45 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/dml/insert-duplicated-keys/insert-duplicated-keys.1.ast
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/dml/insert-duplicated-keys/insert-duplicated-keys.1.ast
@@ -2,7 +2,7 @@ DataverseUse STBench
 TypeDecl SimpleGeoPlaceType [
   closed RecordType {
     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/results_parser_sqlpp/dml/insert-into-empty-dataset-with-index/insert-into-empty-dataset-with-index.1.ast
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/dml/insert-into-empty-dataset-with-index/insert-into-empty-dataset-with-index.1.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/dml/insert-into-empty-dataset-with-index/insert-into-empty-dataset-with-index.1.ast
index c6576b8..b0093c2 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/dml/insert-into-empty-dataset-with-index/insert-into-empty-dataset-with-index.1.ast
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/dml/insert-into-empty-dataset-with-index/insert-into-empty-dataset-with-index.1.ast
@@ -1,9 +1,9 @@
 DataverseUse test
 TypeDecl LineIDType [
   closed RecordType {
-    l_orderkey : int64,
-    l_linenumber : int64,
-    l_suppkey : int64
+    l_orderkey : bigint,
+    l_linenumber : bigint,
+    l_suppkey : bigint
   }
 ]
 DatasetDecl LineID(LineIDType) partitioned by [[l_orderkey], [l_linenumber]]

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/dml/insert-into-empty-dataset/insert-into-empty-dataset.1.ast
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/dml/insert-into-empty-dataset/insert-into-empty-dataset.1.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/dml/insert-into-empty-dataset/insert-into-empty-dataset.1.ast
index c6576b8..b0093c2 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/dml/insert-into-empty-dataset/insert-into-empty-dataset.1.ast
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/dml/insert-into-empty-dataset/insert-into-empty-dataset.1.ast
@@ -1,9 +1,9 @@
 DataverseUse test
 TypeDecl LineIDType [
   closed RecordType {
-    l_orderkey : int64,
-    l_linenumber : int64,
-    l_suppkey : int64
+    l_orderkey : bigint,
+    l_linenumber : bigint,
+    l_suppkey : bigint
   }
 ]
 DatasetDecl LineID(LineIDType) partitioned by [[l_orderkey], [l_linenumber]]

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/dml/insert-into-loaded-dataset-with-index_01/insert-into-loaded-dataset-with-index_01.1.ast
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/dml/insert-into-loaded-dataset-with-index_01/insert-into-loaded-dataset-with-index_01.1.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/dml/insert-into-loaded-dataset-with-index_01/insert-into-loaded-dataset-with-index_01.1.ast
index c6576b8..b0093c2 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/dml/insert-into-loaded-dataset-with-index_01/insert-into-loaded-dataset-with-index_01.1.ast
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/dml/insert-into-loaded-dataset-with-index_01/insert-into-loaded-dataset-with-index_01.1.ast
@@ -1,9 +1,9 @@
 DataverseUse test
 TypeDecl LineIDType [
   closed RecordType {
-    l_orderkey : int64,
-    l_linenumber : int64,
-    l_suppkey : int64
+    l_orderkey : bigint,
+    l_linenumber : bigint,
+    l_suppkey : bigint
   }
 ]
 DatasetDecl LineID(LineIDType) partitioned by [[l_orderkey], [l_linenumber]]

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/dml/insert-into-loaded-dataset-with-index_02/insert-into-loaded-dataset-with-index_02.1.ast
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/dml/insert-into-loaded-dataset-with-index_02/insert-into-loaded-dataset-with-index_02.1.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/dml/insert-into-loaded-dataset-with-index_02/insert-into-loaded-dataset-with-index_02.1.ast
index e0e93c6..c2cc9de 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/dml/insert-into-loaded-dataset-with-index_02/insert-into-loaded-dataset-with-index_02.1.ast
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/dml/insert-into-loaded-dataset-with-index_02/insert-into-loaded-dataset-with-index_02.1.ast
@@ -1,10 +1,10 @@
 DataverseUse test
 TypeDecl LineItemType [
   closed RecordType {
-    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,
@@ -21,9 +21,9 @@ TypeDecl LineItemType [
 ]
 TypeDecl LineIDType [
   closed RecordType {
-    l_orderkey : int64,
-    l_linenumber : int64,
-    l_suppkey : int64
+    l_orderkey : bigint,
+    l_linenumber : bigint,
+    l_suppkey : bigint
   }
 ]
 DatasetDecl LineItem(LineItemType) partitioned by [[l_orderkey], [l_linenumber]]

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/dml/insert-into-loaded-dataset_01/insert-into-loaded-dataset_01.1.ast
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/dml/insert-into-loaded-dataset_01/insert-into-loaded-dataset_01.1.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/dml/insert-into-loaded-dataset_01/insert-into-loaded-dataset_01.1.ast
index c6576b8..b0093c2 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/dml/insert-into-loaded-dataset_01/insert-into-loaded-dataset_01.1.ast
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/dml/insert-into-loaded-dataset_01/insert-into-loaded-dataset_01.1.ast
@@ -1,9 +1,9 @@
 DataverseUse test
 TypeDecl LineIDType [
   closed RecordType {
-    l_orderkey : int64,
-    l_linenumber : int64,
-    l_suppkey : int64
+    l_orderkey : bigint,
+    l_linenumber : bigint,
+    l_suppkey : bigint
   }
 ]
 DatasetDecl LineID(LineIDType) partitioned by [[l_orderkey], [l_linenumber]]

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/dml/insert-into-loaded-dataset_02/insert-into-loaded-dataset_02.1.ast
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/dml/insert-into-loaded-dataset_02/insert-into-loaded-dataset_02.1.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/dml/insert-into-loaded-dataset_02/insert-into-loaded-dataset_02.1.ast
index 2067a51..1ac6845 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/dml/insert-into-loaded-dataset_02/insert-into-loaded-dataset_02.1.ast
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/dml/insert-into-loaded-dataset_02/insert-into-loaded-dataset_02.1.ast
@@ -1,19 +1,19 @@
 DataverseUse test
 TypeDecl Schema [
   closed RecordType {
-    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/results_parser_sqlpp/dml/insert-syntax/insert-syntax.1.ast
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/dml/insert-syntax/insert-syntax.1.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/dml/insert-syntax/insert-syntax.1.ast
index 88a28ec..e8b818c 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/dml/insert-syntax/insert-syntax.1.ast
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/dml/insert-syntax/insert-syntax.1.ast
@@ -1,7 +1,7 @@
 DataverseUse testdv2
 TypeDecl testtype [
   open RecordType {
-    id : int64,
+    id : bigint,
     name : string
   }
 ]

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/dml/insert/insert.1.ast
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/dml/insert/insert.1.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/dml/insert/insert.1.ast
index e0e93c6..c2cc9de 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/dml/insert/insert.1.ast
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/dml/insert/insert.1.ast
@@ -1,10 +1,10 @@
 DataverseUse test
 TypeDecl LineItemType [
   closed RecordType {
-    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,
@@ -21,9 +21,9 @@ TypeDecl LineItemType [
 ]
 TypeDecl LineIDType [
   closed RecordType {
-    l_orderkey : int64,
-    l_linenumber : int64,
-    l_suppkey : int64
+    l_orderkey : bigint,
+    l_linenumber : bigint,
+    l_suppkey : bigint
   }
 ]
 DatasetDecl LineItem(LineItemType) partitioned by [[l_orderkey], [l_linenumber]]

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/dml/insert_less_nc/insert_less_nc.1.ast
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/dml/insert_less_nc/insert_less_nc.1.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/dml/insert_less_nc/insert_less_nc.1.ast
index e0e93c6..c2cc9de 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/dml/insert_less_nc/insert_less_nc.1.ast
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/dml/insert_less_nc/insert_less_nc.1.ast
@@ -1,10 +1,10 @@
 DataverseUse test
 TypeDecl LineItemType [
   closed RecordType {
-    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,
@@ -21,9 +21,9 @@ TypeDecl LineItemType [
 ]
 TypeDecl LineIDType [
   closed RecordType {
-    l_orderkey : int64,
-    l_linenumber : int64,
-    l_suppkey : int64
+    l_orderkey : bigint,
+    l_linenumber : bigint,
+    l_suppkey : bigint
   }
 ]
 DatasetDecl LineItem(LineItemType) partitioned by [[l_orderkey], [l_linenumber]]

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/dml/load-with-index-open/load-with-index-open.1.ast
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/dml/load-with-index-open/load-with-index-open.1.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/dml/load-with-index-open/load-with-index-open.1.ast
index da0f9db..936536b 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/dml/load-with-index-open/load-with-index-open.1.ast
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/dml/load-with-index-open/load-with-index-open.1.ast
@@ -1,10 +1,10 @@
 DataverseUse test
 TypeDecl LineItemType [
   closed RecordType {
-    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,
@@ -21,9 +21,9 @@ TypeDecl LineItemType [
 ]
 TypeDecl LineItemTypeOpen [
   open RecordType {
-    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,

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/dml/load-with-index/load-with-index.1.ast
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/dml/load-with-index/load-with-index.1.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/dml/load-with-index/load-with-index.1.ast
index 9f0be39..17dc8b5 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/dml/load-with-index/load-with-index.1.ast
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/dml/load-with-index/load-with-index.1.ast
@@ -1,10 +1,10 @@
 DataverseUse test
 TypeDecl LineItemType [
   closed RecordType {
-    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/results_parser_sqlpp/dml/load-with-ngram-index-open/load-with-ngram-index-open.1.ast
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/dml/load-with-ngram-index-open/load-with-ngram-index-open.1.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/dml/load-with-ngram-index-open/load-with-ngram-index-open.1.ast
index 598a32c..c9207dd 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/dml/load-with-ngram-index-open/load-with-ngram-index-open.1.ast
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/dml/load-with-ngram-index-open/load-with-ngram-index-open.1.ast
@@ -1,7 +1,7 @@
 DataverseUse test
 TypeDecl DBLPType [
   closed RecordType {
-    id : int64,
+    id : bigint,
     dblpid : string,
     title : string,
     authors : string,
@@ -10,7 +10,7 @@ TypeDecl DBLPType [
 ]
 TypeDecl DBLPTypeOpen [
   open RecordType {
-    id : int64,
+    id : bigint,
     dblpid : string,
     authors : string,
     misc : string

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/dml/load-with-ngram-index/load-with-ngram-index.1.ast
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/dml/load-with-ngram-index/load-with-ngram-index.1.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/dml/load-with-ngram-index/load-with-ngram-index.1.ast
index 3a8b89a..3d3fa52 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/dml/load-with-ngram-index/load-with-ngram-index.1.ast
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/dml/load-with-ngram-index/load-with-ngram-index.1.ast
@@ -1,7 +1,7 @@
 DataverseUse test
 TypeDecl DBLPType [
   closed RecordType {
-    id : int64,
+    id : bigint,
     dblpid : string,
     title : string,
     authors : string,

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/dml/load-with-rtree-index-open/load-with-rtree-index-open.1.ast
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/dml/load-with-rtree-index-open/load-with-rtree-index-open.1.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/dml/load-with-rtree-index-open/load-with-rtree-index-open.1.ast
index cb10b17..b95ae1c 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/dml/load-with-rtree-index-open/load-with-rtree-index-open.1.ast
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/dml/load-with-rtree-index-open/load-with-rtree-index-open.1.ast
@@ -1,7 +1,7 @@
 DataverseUse test
 TypeDecl MyRecord [
   closed RecordType {
-    id : int64,
+    id : bigint,
     point : point,
     kwds : string,
     line1 : line,
@@ -14,7 +14,7 @@ TypeDecl MyRecord [
 ]
 TypeDecl MyRecordOpen [
   open RecordType {
-    id : int64,
+    id : bigint,
     kwds : string,
     line1 : line,
     line2 : line,

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/dml/load-with-rtree-index/load-with-rtree-index.1.ast
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/dml/load-with-rtree-index/load-with-rtree-index.1.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/dml/load-with-rtree-index/load-with-rtree-index.1.ast
index a706d77..9e01d19 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/dml/load-with-rtree-index/load-with-rtree-index.1.ast
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/dml/load-with-rtree-index/load-with-rtree-index.1.ast
@@ -1,7 +1,7 @@
 DataverseUse test
 TypeDecl MyRecord [
   closed RecordType {
-    id : int64,
+    id : bigint,
     point : point,
     kwds : string,
     line1 : line,

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/dml/load-with-word-index-open/load-with-word-index-open.1.ast
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/dml/load-with-word-index-open/load-with-word-index-open.1.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/dml/load-with-word-index-open/load-with-word-index-open.1.ast
index 598a32c..c9207dd 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/dml/load-with-word-index-open/load-with-word-index-open.1.ast
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/dml/load-with-word-index-open/load-with-word-index-open.1.ast
@@ -1,7 +1,7 @@
 DataverseUse test
 TypeDecl DBLPType [
   closed RecordType {
-    id : int64,
+    id : bigint,
     dblpid : string,
     title : string,
     authors : string,
@@ -10,7 +10,7 @@ TypeDecl DBLPType [
 ]
 TypeDecl DBLPTypeOpen [
   open RecordType {
-    id : int64,
+    id : bigint,
     dblpid : string,
     authors : string,
     misc : string

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/dml/load-with-word-index/load-with-word-index.1.ast
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/dml/load-with-word-index/load-with-word-index.1.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/dml/load-with-word-index/load-with-word-index.1.ast
index 3a8b89a..3d3fa52 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/dml/load-with-word-index/load-with-word-index.1.ast
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/dml/load-with-word-index/load-with-word-index.1.ast
@@ -1,7 +1,7 @@
 DataverseUse test
 TypeDecl DBLPType [
   closed RecordType {
-    id : int64,
+    id : bigint,
     dblpid : string,
     title : string,
     authors : string,

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/dml/opentype-c2o-recursive/opentype-c2o-recursive.1.ast
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/dml/opentype-c2o-recursive/opentype-c2o-recursive.1.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/dml/opentype-c2o-recursive/opentype-c2o-recursive.1.ast
index 29b4565..b0c9fad 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/dml/opentype-c2o-recursive/opentype-c2o-recursive.1.ast
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/dml/opentype-c2o-recursive/opentype-c2o-recursive.1.ast
@@ -8,7 +8,7 @@ TypeDecl AddressType [
 TypeDecl Dept [
   open RecordType {
     name : string,
-    id : int64
+    id : bigint
   }
 ]
 TypeDecl testtype [

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/dml/opentype-insert2/opentype-insert2.1.ast
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/dml/opentype-insert2/opentype-insert2.1.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/dml/opentype-insert2/opentype-insert2.1.ast
index cc72abc..55c2adc 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/dml/opentype-insert2/opentype-insert2.1.ast
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/dml/opentype-insert2/opentype-insert2.1.ast
@@ -1,7 +1,7 @@
 DataverseUse test
 TypeDecl TestType [
   open RecordType {
-    id : int64
+    id : bigint
   }
 ]
 DatasetDecl testds(TestType) partitioned by [[id]]

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/dml/opentype-o2c-recursive/opentype-o2c-recursive.1.ast
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/dml/opentype-o2c-recursive/opentype-o2c-recursive.1.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/dml/opentype-o2c-recursive/opentype-o2c-recursive.1.ast
index 4c2827d..e4ec33e 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/dml/opentype-o2c-recursive/opentype-o2c-recursive.1.ast
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/dml/opentype-o2c-recursive/opentype-o2c-recursive.1.ast
@@ -8,7 +8,7 @@ TypeDecl AddressType [
 TypeDecl Dept [
   closed RecordType {
     name : string,
-    id : int64
+    id : bigint
   }
 ]
 TypeDecl testtype [

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/dml/query-issue205/query-issue205.1.ast
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/dml/query-issue205/query-issue205.1.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/dml/query-issue205/query-issue205.1.ast
index e824e26..439a88e 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/dml/query-issue205/query-issue205.1.ast
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/dml/query-issue205/query-issue205.1.ast
@@ -1,15 +1,15 @@
 DataverseUse test
 TypeDecl EmployeeStat [
   open RecordType {
-    age : int64,
-    salary : int64
+    age : bigint,
+    salary : bigint
   }
 ]
 TypeDecl EmployeeType [
   closed RecordType {
     id : string,
     stat : EmployeeStat,
-    deptCode : int64
+    deptCode : bigint
   }
 ]
 DatasetDecl Employees(EmployeeType) partitioned by [[id]]

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/dml/query-issue288/query-issue288.1.ast
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/dml/query-issue288/query-issue288.1.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/dml/query-issue288/query-issue288.1.ast
index a3a6877..8fb2df5 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/dml/query-issue288/query-issue288.1.ast
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/dml/query-issue288/query-issue288.1.ast
@@ -1,9 +1,9 @@
 DataverseUse test
 TypeDecl LineIDType [
   closed RecordType {
-    l_orderkey : int64,
-    l_linenumber : int64,
-    l_suppkey : int64
+    l_orderkey : bigint,
+    l_linenumber : bigint,
+    l_suppkey : bigint
   }
 ]
 DatasetDecl LineID(LineIDType) partitioned by [[l_orderkey], [l_linenumber]]