asterixdb-notifications mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Yingyi Bu (Code Review)" <do-not-re...@asterixdb.incubator.apache.org>
Subject Change in asterixdb[master]: ASTERIXDB-1334 and ASTERIXDB-1616: Add a regression test.
Date Wed, 14 Sep 2016 00:09:36 GMT
Yingyi Bu has submitted this change and it was merged.

Change subject: ASTERIXDB-1334 and ASTERIXDB-1616: Add a regression test.
......................................................................


ASTERIXDB-1334 and ASTERIXDB-1616: Add a regression test.

Change-Id: I7e88adbfa2721fa589e1d0564bb9e0889b722e2e
Reviewed-on: https://asterix-gerrit.ics.uci.edu/1165
Sonar-Qube: Jenkins <jenkins@fulliautomatix.ics.uci.edu>
Tested-by: Jenkins <jenkins@fulliautomatix.ics.uci.edu>
Reviewed-by: Ian Maxon <imaxon@apache.org>
Integration-Tests: Jenkins <jenkins@fulliautomatix.ics.uci.edu>
---
A asterixdb/asterix-app/data/twitter/closed-nullable-fields-issue_1616.adm
A asterixdb/asterix-app/src/test/resources/runtimets/queries/records/closed-nullable-fields_issue1616/closed-nullable-fileds_issue1616.1.ddl.aql
A asterixdb/asterix-app/src/test/resources/runtimets/queries/records/closed-nullable-fields_issue1616/closed-nullable-fileds_issue1616.2.update.aql
A asterixdb/asterix-app/src/test/resources/runtimets/queries/records/closed-nullable-fields_issue1616/closed-nullable-fileds_issue1616.3.query.aql
A asterixdb/asterix-app/src/test/resources/runtimets/results/records/closed-nullable-fields_issue1616/closed-nullable-fields_issue1616.1.adm
M asterixdb/asterix-app/src/test/resources/runtimets/testsuite.xml
6 files changed, 930 insertions(+), 0 deletions(-)

Approvals:
  Ian Maxon: Looks good to me, approved
  Jenkins: Verified; No violations found; Verified



diff --git a/asterixdb/asterix-app/data/twitter/closed-nullable-fields-issue_1616.adm b/asterixdb/asterix-app/data/twitter/closed-nullable-fields-issue_1616.adm
new file mode 100644
index 0000000..5ca0b05
--- /dev/null
+++ b/asterixdb/asterix-app/data/twitter/closed-nullable-fields-issue_1616.adm
@@ -0,0 +1,2 @@
+{  "coordinates": {"coordinates": [1.1],"type": "string"  },  "created_at": "string",  "entities":
{"urls": [{  "display_url": "string",  "expanded_url": "string",  "indices": [1],  "url":
"string"}],"user_mentions": [{  "id": 1,  "id_str": "string",  "indices": [1],  "name": "string",
 "screen_name": "string"}]  },  "favorite_count": 1,  "favorited": true,  "filter_level":
"string",  "geo": {"coordinates": [1.1],"type": "string"  },  "id": "0000000",  "id_str":
"string",  "in_reply_to_screen_name": "string",  "in_reply_to_status_id": 1,  "in_reply_to_status_id_str":
"string",  "in_reply_to_user_id": 1,  "in_reply_to_user_id_str": "string",  "is_quote_status":
true,  "lang": "string",  "place": {"bounding_box": {  "coordinates": [[[1.1]]],  "type":
"string"},"country": "string","country_code": "string","full_name": "string","id": "string","name":
"string","place_type": "string","url": "string"  },  "possibly_sensitive": true,  "quoted_status":
{"created_at": "string","entiti
 es": {"user_mentions": [{  "id": 1,  "id_str": "string",  "indices": [1],  "name": "string",
 "screen_name": "string"}]},"favorite_count": 1,"favorited": true,"filter_level": "string","id":
1,"id_str": "string","in_reply_to_screen_name": "string","in_reply_to_status_id": 1,"in_reply_to_status_id_str":
"string","in_reply_to_user_id": 1,"in_reply_to_user_id_str": "string","is_quote_status": true,"lang":
"string","retweet_count": 1,"retweeted": true,"source": "string","text": "string","truncated":
true,"user": {  "contributors_enabled": true,  "created_at": "string",  "default_profile":
true,  "default_profile_image": true,  "description": "string",  "favourites_count": 1,  "followers_count":
1,  "friends_count": 1,  "geo_enabled": true,  "id": 1,  "id_str": "string",  "is_translator":
true,  "lang": "string",  "listed_count": 1,  "name": "string",  "profile_background_color":
"string",  "profile_background_image_url": "string",  "profile_background_image_url_https":
"string", 
  "profile_background_tile": true,  "profile_banner_url": "string",  "profile_image_url":
"string",  "profile_image_url_https": "string",  "profile_link_color": "string",  "profile_sidebar_border_color":
"string",  "profile_sidebar_fill_color": "string",  "profile_text_color": "string",  "profile_use_background_image":
true,  "protected": true,  "screen_name": "string",  "statuses_count": 1,  "verified": true}
 },  "quoted_status_id": 1,  "quoted_status_id_str": "string",  "retweet_count": 1,  "retweeted":
true,  "source": "string",  "text": "string",  "timestamp_ms": "string",  "truncated": true,
 "user": {"contributors_enabled": true,"created_at": "string","default_profile": true,"default_profile_image":
true,"description": "string","favourites_count": 1,"followers_count": 1,"friends_count": 1,"geo_enabled":
true,"id": 1,"id_str": "string","is_translator": true,"lang": "string","listed_count": 1,"location":
"string","name": "string","profile_background_color": "string","pro
 file_background_image_url": "string","profile_background_image_url_https": "string","profile_background_tile":
true,"profile_banner_url": "string","profile_image_url": "string","profile_image_url_https":
"string","profile_link_color": "string","profile_sidebar_border_color": "string","profile_sidebar_fill_color":
"string","profile_text_color": "string","profile_use_background_image": true,"protected":
true,"screen_name": "string","statuses_count": 1,"time_zone": "string","url": "string","utc_offset":
1,"verified": true  }}
+{  "coordinates": {"coordinates": [1.1],"type": "string"  },  "created_at": "string",  "favorite_count":
1,  "favorited": true,  "filter_level": "string",  "geo": {"coordinates": [1.1],"type": "string"
 },  "id": "11111111111111111111",  "id_str": "string",  "in_reply_to_screen_name": "string",
 "in_reply_to_status_id": 1,  "in_reply_to_status_id_str": "string",  "in_reply_to_user_id":
1,  "in_reply_to_user_id_str": "string",  "is_quote_status": true,  "lang": "string",  "place":
{"bounding_box": {  "coordinates": [[[1.1]]],  "type": "string"},"country": "string","country_code":
"string","full_name": "string","id": "string","name": "string","place_type": "string","url":
"string"  },  "possibly_sensitive": true,  "quoted_status": {"created_at": "string","entities":
{"user_mentions": [{  "id": 1,  "id_str": "string",  "indices": [1],  "name": "string",  "screen_name":
"string"}]},"favorite_count": 1,"favorited": true,"filter_level": "string","id": 1,"id_str":
"string","in_repl
 y_to_screen_name": "string","in_reply_to_status_id": 1,"in_reply_to_status_id_str": "string","in_reply_to_user_id":
1,"in_reply_to_user_id_str": "string","is_quote_status": true,"lang": "string","retweet_count":
1,"retweeted": true,"source": "string","text": "string","truncated": true,"user": {  "contributors_enabled":
true,  "created_at": "string",  "default_profile": true,  "default_profile_image": true, 
"description": "string",  "favourites_count": 1,  "followers_count": 1,  "friends_count":
1,  "geo_enabled": true,  "id": 1,  "id_str": "string",  "is_translator": true,  "lang": "string",
 "listed_count": 1,  "name": "string",  "profile_background_color": "string",  "profile_background_image_url":
"string",  "profile_background_image_url_https": "string",  "profile_background_tile": true,
 "profile_banner_url": "string",  "profile_image_url": "string",  "profile_image_url_https":
"string",  "profile_link_color": "string",  "profile_sidebar_border_color": "string",  "prof
 ile_sidebar_fill_color": "string",  "profile_text_color": "string",  "profile_use_background_image":
true,  "protected": true,  "screen_name": "string",  "statuses_count": 1,  "verified": true}
 },  "quoted_status_id": 1,  "quoted_status_id_str": "string",  "retweet_count": 1,  "retweeted":
true,  "source": "string",  "text": "string",  "timestamp_ms": "string",  "truncated": true,
 "user": {"contributors_enabled": true,"created_at": "string","default_profile": true,"default_profile_image":
true,"description": "string","favourites_count": 1,"followers_count": 1,"friends_count": 1,"geo_enabled":
true,"id": 1,"id_str": "string","is_translator": true,"lang": "string","listed_count": 1,"location":
"string","name": "string","profile_background_color": "string","profile_background_image_url":
"string","profile_background_image_url_https": "string","profile_background_tile": true,"profile_banner_url":
"string","profile_image_url": "string","profile_image_url_https": "string","profi
 le_link_color": "string","profile_sidebar_border_color": "string","profile_sidebar_fill_color":
"string","profile_text_color": "string","profile_use_background_image": true,"protected":
true,"screen_name": "string","statuses_count": 1,"time_zone": "string","url": "string","utc_offset":
1,"verified": true  }}
\ No newline at end of file
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries/records/closed-nullable-fields_issue1616/closed-nullable-fileds_issue1616.1.ddl.aql
b/asterixdb/asterix-app/src/test/resources/runtimets/queries/records/closed-nullable-fields_issue1616/closed-nullable-fileds_issue1616.1.ddl.aql
new file mode 100644
index 0000000..fc6fdc9
--- /dev/null
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries/records/closed-nullable-fields_issue1616/closed-nullable-fileds_issue1616.1.ddl.aql
@@ -0,0 +1,862 @@
+/*
+ * Licensed to the Apache Software Foundation (ASF) under one
+ * or more contributor license agreements.  See the NOTICE file
+ * distributed with this work for additional information
+ * regarding copyright ownership.  The ASF licenses this file
+ * to you under the Apache License, Version 2.0 (the
+ * "License"); you may not use this file except in compliance
+ * with the License.  You may obtain a copy of the License at
+ *
+ *   http://www.apache.org/licenses/LICENSE-2.0
+ *
+ * Unless required by applicable law or agreed to in writing,
+ * software distributed under the License is distributed on an
+ * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+ * KIND, either express or implied.  See the License for the
+ * specific language governing permissions and limitations
+ * under the License.
+ */
+  /*
+* Description  : Fix ArrayOutOfBound and IndexOutOfBound exception
+* Expected Res : Success
+* Issue        : 1334 and 1616
+* Date         : 12th Sept. 2016
+*/
+
+drop dataverse test if exists;
+create dataverse test;
+use dataverse test;
+
+create type userType1 as open {
+    'utc_offset':int64?,
+    'friends_count':int64?,
+    'profile_image_url_https':string?,
+    'listed_count':int64?,
+    'profile_background_image_url':string?,
+    'default_profile_image':boolean?,
+    'favourites_count':int64?,
+    'description':string?,
+    'created_at':string?,
+    'is_translator':boolean?,
+    'profile_background_image_url_https':string?,
+    'protected':boolean?,
+    'screen_name':string?,
+    'id_str':string?,
+    'profile_link_color':string?,
+    'id':int64?,
+    'geo_enabled':boolean?,
+    'profile_background_color':string?,
+    'lang':string?,
+    'profile_sidebar_border_color':string?,
+    'profile_text_color':string?,
+    'verified':boolean?,
+    'profile_image_url':string?,
+    'time_zone':string?,
+    'contributors_enabled':boolean?,
+    'profile_background_tile':boolean?,
+    'profile_banner_url':string?,
+    'statuses_count':int64?,
+    'followers_count':int64?,
+    'profile_use_background_image':boolean?,
+    'default_profile':boolean?,
+    'name':string?,
+    'location':string?,
+    'profile_sidebar_fill_color':string?,
+    'url':string?
+}
+create type smallType1 as open {
+    'w':int64?,
+    'h':int64?,
+    'resize':string?
+}
+create type largeType1 as open {
+    'w':int64?,
+    'h':int64?,
+    'resize':string?
+}
+create type thumbType1 as open {
+    'w':int64?,
+    'h':int64?,
+    'resize':string?
+}
+create type mediumType1 as open {
+    'w':int64?,
+    'h':int64?,
+    'resize':string?
+}
+create type sizesType1 as open {
+    'small':smallType1?,
+    'large':largeType1?,
+    'thumb':thumbType1?,
+    'medium':mediumType1?
+}
+create type listType2 as open {
+    'content_type':string?,
+    'bitrate':int64?,
+    'url':string?
+}
+create type video_infoType1 as open {
+    'aspect_ratio':[int64]?,
+    'duration_millis':int64?,
+    'variants':[listType2]?
+}
+create type listType1 as open {
+    'display_url':string?,
+    'indices':[int64]?,
+    'sizes':sizesType1?,
+    'id_str':string?,
+    'expanded_url':string?,
+    'media_url_https':string?,
+    'id':int64?,
+    'type':string?,
+    'media_url':string?,
+    'url':string?,
+    'video_info':video_infoType1?,
+    'source_user_id':int64?,
+    'source_status_id':int64?,
+    'source_status_id_str':string?,
+    'source_user_id_str':string?
+}
+create type extended_entitiesType1 as open {
+    'media':[listType1]?
+}
+create type smallType2 as open {
+    'w':int64?,
+    'h':int64?,
+    'resize':string?
+}
+create type largeType2 as open {
+    'w':int64?,
+    'h':int64?,
+    'resize':string?
+}
+create type thumbType2 as open {
+    'w':int64?,
+    'h':int64?,
+    'resize':string?
+}
+create type mediumType2 as open {
+    'w':int64?,
+    'h':int64?,
+    'resize':string?
+}
+create type sizesType2 as open {
+    'small':smallType2?,
+    'large':largeType2?,
+    'thumb':thumbType2?,
+    'medium':mediumType2?
+}
+create type listType3 as open {
+    'display_url':string?,
+    'indices':[int64]?,
+    'sizes':sizesType2?,
+    'id_str':string?,
+    'expanded_url':string?,
+    'media_url_https':string?,
+    'id':int64?,
+    'type':string?,
+    'media_url':string?,
+    'url':string?,
+    'source_user_id':int64?,
+    'source_status_id':int64?,
+    'source_status_id_str':string?,
+    'source_user_id_str':string?
+}
+create type listType4 as open {
+    'display_url':string?,
+    'indices':[int64]?,
+    'expanded_url':string?,
+    'url':string?
+}
+create type listType5 as open {
+    'indices':[int64]?,
+    'text':string?
+}
+create type listType6 as open {
+    'indices':[int64]?,
+    'screen_name':string?,
+    'id_str':string?,
+    'name':string?,
+    'id':int64?
+}
+create type entitiesType1 as open {
+    'media':[listType3]?,
+    'urls':[listType4]?,
+    'hashtags':[listType5]?,
+    'user_mentions':[listType6]?
+}
+create type bounding_boxType1 as open {
+    'coordinates':[[[double]]]?,
+    'type':string?
+}
+create type placeType1 as open {
+    'country_code':string?,
+    'country':string?,
+    'full_name':string?,
+    'bounding_box':bounding_boxType1?,
+    'place_type':string?,
+    'name':string?,
+    'id':string?,
+    'url':string?
+}
+create type userType2 as open {
+    'utc_offset':int64?,
+    'friends_count':int64?,
+    'profile_image_url_https':string?,
+    'listed_count':int64?,
+    'profile_background_image_url':string?,
+    'default_profile_image':boolean?,
+    'favourites_count':int64?,
+    'description':string?,
+    'created_at':string?,
+    'is_translator':boolean?,
+    'profile_background_image_url_https':string?,
+    'protected':boolean?,
+    'screen_name':string?,
+    'id_str':string?,
+    'profile_link_color':string?,
+    'id':int64?,
+    'geo_enabled':boolean?,
+    'profile_background_color':string?,
+    'lang':string?,
+    'profile_sidebar_border_color':string?,
+    'profile_text_color':string?,
+    'verified':boolean?,
+    'profile_image_url':string?,
+    'time_zone':string?,
+    'contributors_enabled':boolean?,
+    'profile_background_tile':boolean?,
+    'profile_banner_url':string?,
+    'statuses_count':int64?,
+    'followers_count':int64?,
+    'profile_use_background_image':boolean?,
+    'default_profile':boolean?,
+    'name':string?,
+    'profile_sidebar_fill_color':string?,
+    'location':string?,
+    'url':string?
+}
+create type listType7 as open {
+    'display_url':string?,
+    'indices':[int64]?,
+    'expanded_url':string?,
+    'url':string?
+}
+create type listType8 as open {
+    'indices':[int64]?,
+    'text':string?
+}
+create type listType9 as open {
+    'indices':[int64]?,
+    'screen_name':string?,
+    'id_str':string?,
+    'name':string?,
+    'id':int64?
+}
+create type smallType3 as open {
+    'w':int64?,
+    'h':int64?,
+    'resize':string?
+}
+create type largeType3 as open {
+    'w':int64?,
+    'h':int64?,
+    'resize':string?
+}
+create type thumbType3 as open {
+    'w':int64?,
+    'h':int64?,
+    'resize':string?
+}
+create type mediumType3 as open {
+    'w':int64?,
+    'h':int64?,
+    'resize':string?
+}
+create type sizesType3 as open {
+    'small':smallType3?,
+    'large':largeType3?,
+    'thumb':thumbType3?,
+    'medium':mediumType3?
+}
+create type listType10 as open {
+    'display_url':string?,
+    'indices':[int64]?,
+    'sizes':sizesType3?,
+    'id_str':string?,
+    'expanded_url':string?,
+    'media_url_https':string?,
+    'id':int64?,
+    'type':string?,
+    'media_url':string?,
+    'url':string?,
+    'source_user_id':int64?,
+    'source_status_id':int64?,
+    'source_status_id_str':string?,
+    'source_user_id_str':string?
+}
+create type entitiesType2 as open {
+    'urls':[listType7]?,
+    'hashtags':[listType8]?,
+    'user_mentions':[listType9]?,
+    'media':[listType10]?
+}
+create type smallType4 as open {
+    'w':int64?,
+    'h':int64?,
+    'resize':string?
+}
+create type largeType4 as open {
+    'w':int64?,
+    'h':int64?,
+    'resize':string?
+}
+create type thumbType4 as open {
+    'w':int64?,
+    'h':int64?,
+    'resize':string?
+}
+create type mediumType4 as open {
+    'w':int64?,
+    'h':int64?,
+    'resize':string?
+}
+create type sizesType4 as open {
+    'small':smallType4?,
+    'large':largeType4?,
+    'thumb':thumbType4?,
+    'medium':mediumType4?
+}
+create type listType12 as open {
+    'content_type':string?,
+    'url':string?,
+    'bitrate':int64?
+}
+create type video_infoType2 as open {
+    'aspect_ratio':[int64]?,
+    'duration_millis':int64?,
+    'variants':[listType12]?
+}
+create type listType11 as open {
+    'display_url':string?,
+    'indices':[int64]?,
+    'sizes':sizesType4?,
+    'id_str':string?,
+    'expanded_url':string?,
+    'media_url_https':string?,
+    'id':int64?,
+    'type':string?,
+    'media_url':string?,
+    'url':string?,
+    'source_user_id':int64?,
+    'source_status_id':int64?,
+    'source_status_id_str':string?,
+    'source_user_id_str':string?,
+    'video_info':video_infoType2?
+}
+create type extended_entitiesType2 as open {
+    'media':[listType11]?
+}
+create type bounding_boxType2 as open {
+    'coordinates':[[[double]]]?,
+    'type':string?
+}
+create type placeType2 as open {
+    'country_code':string?,
+    'country':string?,
+    'full_name':string?,
+    'bounding_box':bounding_boxType2?,
+    'place_type':string?,
+    'name':string?,
+    'id':string?,
+    'url':string?
+}
+create type quoted_statusType1 as open {
+    'created_at':string?,
+    'truncated':boolean?,
+    'source':string?,
+    'retweet_count':int64?,
+    'retweeted':boolean?,
+    'filter_level':string?,
+    'is_quote_status':boolean?,
+    'id_str':string?,
+    'favorite_count':int64?,
+    'id':int64?,
+    'text':string?,
+    'lang':string?,
+    'user':userType2?,
+    'favorited':boolean?,
+    'quoted_status_id':int64?,
+    'possibly_sensitive':boolean?,
+    'entities':entitiesType2?,
+    'quoted_status_id_str':string?,
+    'extended_entities':extended_entitiesType2?,
+    'in_reply_to_status_id_str':string?,
+    'in_reply_to_status_id':int64?,
+    'in_reply_to_user_id_str':string?,
+    'in_reply_to_screen_name':string?,
+    'in_reply_to_user_id':int64?,
+    'place':placeType2?
+}
+create type coordinatesType1 as open {
+    'coordinates':[double]?,
+    'type':string?
+}
+create type geoType1 as open {
+    'coordinates':[double]?,
+    'type':string?
+}
+create type scopesType1 as open {
+    'followers':boolean?
+}
+create type retweeted_statusType1 as open {
+    'created_at':string?,
+    'truncated':boolean?,
+    'source':string?,
+    'retweet_count':int64?,
+    'retweeted':boolean?,
+    'filter_level':string?,
+    'is_quote_status':boolean?,
+    'id_str':string?,
+    'favorite_count':int64?,
+    'id':int64?,
+    'text':string?,
+    'lang':string?,
+    'user':userType1?,
+    'favorited':boolean?,
+    'extended_entities':extended_entitiesType1?,
+    'possibly_sensitive':boolean?,
+    'entities':entitiesType1?,
+    'place':placeType1?,
+    'quoted_status':quoted_statusType1?,
+    'quoted_status_id':int64?,
+    'quoted_status_id_str':string?,
+    'in_reply_to_status_id_str':string?,
+    'in_reply_to_status_id':int64?,
+    'in_reply_to_user_id_str':string?,
+    'in_reply_to_screen_name':string?,
+    'in_reply_to_user_id':int64?,
+    'coordinates':coordinatesType1?,
+    'geo':geoType1?,
+    'scopes':scopesType1?
+}
+create type listType13 as open {
+    'indices':[int64]?,
+    'screen_name':string?,
+    'id_str':string?,
+    'name':string?,
+    'id':int64?
+}
+create type smallType5 as open {
+    'w':int64?,
+    'h':int64?,
+    'resize':string?
+}
+create type largeType5 as open {
+    'w':int64?,
+    'h':int64?,
+    'resize':string?
+}
+create type thumbType5 as open {
+    'w':int64?,
+    'h':int64?,
+    'resize':string?
+}
+create type mediumType5 as open {
+    'w':int64?,
+    'h':int64?,
+    'resize':string?
+}
+create type sizesType5 as open {
+    'small':smallType5?,
+    'large':largeType5?,
+    'thumb':thumbType5?,
+    'medium':mediumType5?
+}
+create type listType14 as open {
+    'display_url':string?,
+    'indices':[int64]?,
+    'sizes':sizesType5?,
+    'id_str':string?,
+    'expanded_url':string?,
+    'media_url_https':string?,
+    'id':int64?,
+    'type':string?,
+    'media_url':string?,
+    'url':string?,
+    'source_user_id':int64?,
+    'source_status_id':int64?,
+    'source_status_id_str':string?,
+    'source_user_id_str':string?
+}
+create type listType15 as open {
+    'display_url':string?,
+    'indices':[int64]?,
+    'expanded_url':string?,
+    'url':string?
+}
+create type listType16 as open {
+    'indices':[int64]?,
+    'text':string?
+}
+create type listType17 as open {
+    'indices':[int64]?,
+    'text':string?
+}
+create type entitiesType3 as open {
+    'user_mentions':[listType13]?,
+    'media':[listType14]?,
+    'urls':[listType15]?,
+    'hashtags':[listType16]?,
+    'symbols':[listType17]?
+}
+create type userType3 as open {
+    'friends_count':int64?,
+    'profile_image_url_https':string?,
+    'listed_count':int64?,
+    'profile_background_image_url':string?,
+    'default_profile_image':boolean?,
+    'favourites_count':int64?,
+    'description':string?,
+    'created_at':string?,
+    'is_translator':boolean?,
+    'profile_background_image_url_https':string?,
+    'protected':boolean?,
+    'screen_name':string?,
+    'id_str':string?,
+    'profile_link_color':string?,
+    'id':int64?,
+    'geo_enabled':boolean?,
+    'profile_background_color':string?,
+    'lang':string?,
+    'profile_sidebar_border_color':string?,
+    'profile_text_color':string?,
+    'verified':boolean?,
+    'profile_image_url':string?,
+    'contributors_enabled':boolean?,
+    'profile_background_tile':boolean?,
+    'profile_banner_url':string?,
+    'statuses_count':int64?,
+    'followers_count':int64?,
+    'profile_use_background_image':boolean?,
+    'default_profile':boolean?,
+    'name':string?,
+    'location':string?,
+    'profile_sidebar_fill_color':string?,
+    'utc_offset':int64?,
+    'time_zone':string?,
+    'url':string?
+}
+create type smallType6 as open {
+    'w':int64?,
+    'h':int64?,
+    'resize':string?
+}
+create type largeType6 as open {
+    'w':int64?,
+    'h':int64?,
+    'resize':string?
+}
+create type thumbType6 as open {
+    'w':int64?,
+    'h':int64?,
+    'resize':string?
+}
+create type mediumType6 as open {
+    'w':int64?,
+    'h':int64?,
+    'resize':string?
+}
+create type sizesType6 as open {
+    'small':smallType6?,
+    'large':largeType6?,
+    'thumb':thumbType6?,
+    'medium':mediumType6?
+}
+create type listType19 as open {
+    'content_type':string?,
+    'bitrate':int64?,
+    'url':string?
+}
+create type video_infoType3 as open {
+    'aspect_ratio':[int64]?,
+    'duration_millis':int64?,
+    'variants':[listType19]?
+}
+create type listType18 as open {
+    'display_url':string?,
+    'indices':[int64]?,
+    'sizes':sizesType6?,
+    'id_str':string?,
+    'expanded_url':string?,
+    'media_url_https':string?,
+    'id':int64?,
+    'type':string?,
+    'media_url':string?,
+    'url':string?,
+    'source_user_id':int64?,
+    'source_status_id':int64?,
+    'source_status_id_str':string?,
+    'source_user_id_str':string?,
+    'video_info':video_infoType3?
+}
+create type extended_entitiesType3 as open {
+    'media':[listType18]?
+}
+create type userType4 as open {
+    'utc_offset':int64?,
+    'friends_count':int64?,
+    'profile_image_url_https':string?,
+    'listed_count':int64?,
+    'profile_background_image_url':string?,
+    'default_profile_image':boolean?,
+    'favourites_count':int64?,
+    'description':string?,
+    'created_at':string?,
+    'is_translator':boolean?,
+    'profile_background_image_url_https':string?,
+    'protected':boolean?,
+    'screen_name':string?,
+    'id_str':string?,
+    'profile_link_color':string?,
+    'id':int64?,
+    'geo_enabled':boolean?,
+    'profile_background_color':string?,
+    'lang':string?,
+    'profile_sidebar_border_color':string?,
+    'profile_text_color':string?,
+    'verified':boolean?,
+    'profile_image_url':string?,
+    'time_zone':string?,
+    'contributors_enabled':boolean?,
+    'profile_background_tile':boolean?,
+    'profile_banner_url':string?,
+    'statuses_count':int64?,
+    'followers_count':int64?,
+    'profile_use_background_image':boolean?,
+    'default_profile':boolean?,
+    'name':string?,
+    'profile_sidebar_fill_color':string?,
+    'location':string?,
+    'url':string?
+}
+create type smallType7 as open {
+    'w':int64?,
+    'h':int64?,
+    'resize':string?
+}
+create type largeType7 as open {
+    'w':int64?,
+    'h':int64?,
+    'resize':string?
+}
+create type thumbType7 as open {
+    'w':int64?,
+    'h':int64?,
+    'resize':string?
+}
+create type mediumType7 as open {
+    'w':int64?,
+    'h':int64?,
+    'resize':string?
+}
+create type sizesType7 as open {
+    'small':smallType7?,
+    'large':largeType7?,
+    'thumb':thumbType7?,
+    'medium':mediumType7?
+}
+create type listType21 as open {
+    'content_type':string?,
+    'bitrate':int64?,
+    'url':string?
+}
+create type video_infoType4 as open {
+    'aspect_ratio':[int64]?,
+    'variants':[listType21]?,
+    'duration_millis':int64?
+}
+create type listType20 as open {
+    'display_url':string?,
+    'source_user_id':int64?,
+    'type':string?,
+    'media_url':string?,
+    'source_status_id':int64?,
+    'url':string?,
+    'indices':[int64]?,
+    'sizes':sizesType7?,
+    'id_str':string?,
+    'expanded_url':string?,
+    'source_status_id_str':string?,
+    'media_url_https':string?,
+    'id':int64?,
+    'source_user_id_str':string?,
+    'video_info':video_infoType4?
+}
+create type extended_entitiesType4 as open {
+    'media':[listType20]?
+}
+create type smallType8 as open {
+    'w':int64?,
+    'h':int64?,
+    'resize':string?
+}
+create type largeType8 as open {
+    'w':int64?,
+    'h':int64?,
+    'resize':string?
+}
+create type thumbType8 as open {
+    'w':int64?,
+    'h':int64?,
+    'resize':string?
+}
+create type mediumType8 as open {
+    'w':int64?,
+    'h':int64?,
+    'resize':string?
+}
+create type sizesType8 as open {
+    'small':smallType8?,
+    'large':largeType8?,
+    'thumb':thumbType8?,
+    'medium':mediumType8?
+}
+create type listType22 as open {
+    'display_url':string?,
+    'source_user_id':int64?,
+    'type':string?,
+    'media_url':string?,
+    'source_status_id':int64?,
+    'url':string?,
+    'indices':[int64]?,
+    'sizes':sizesType8?,
+    'id_str':string?,
+    'expanded_url':string?,
+    'source_status_id_str':string?,
+    'media_url_https':string?,
+    'id':int64?,
+    'source_user_id_str':string?
+}
+create type listType23 as open {
+    'display_url':string?,
+    'indices':[int64]?,
+    'expanded_url':string?,
+    'url':string?
+}
+create type listType24 as open {
+    'indices':[int64]?,
+    'screen_name':string?,
+    'id_str':string?,
+    'name':string?,
+    'id':int64?
+}
+create type listType25 as open {
+    'indices':[int64]?,
+    'text':string?
+}
+create type entitiesType4 as open {
+    'media':[listType22]?,
+    'urls':[listType23]?,
+    'user_mentions':[listType24]?,
+    'hashtags':[listType25]?
+}
+create type bounding_boxType3 as open {
+    'coordinates':[[[double]]]?,
+    'type':string?
+}
+create type placeType3 as open {
+    'country_code':string?,
+    'country':string?,
+    'full_name':string?,
+    'bounding_box':bounding_boxType3?,
+    'place_type':string?,
+    'name':string?,
+    'id':string?,
+    'url':string?
+}
+create type quoted_statusType2 as open {
+    'created_at':string?,
+    'truncated':boolean?,
+    'source':string?,
+    'retweet_count':int64?,
+    'retweeted':boolean?,
+    'filter_level':string?,
+    'is_quote_status':boolean?,
+    'id_str':string?,
+    'favorite_count':int64?,
+    'id':int64?,
+    'text':string?,
+    'lang':string?,
+    'user':userType4?,
+    'favorited':boolean?,
+    'extended_entities':extended_entitiesType4?,
+    'possibly_sensitive':boolean?,
+    'entities':entitiesType4?,
+    'quoted_status_id':int64?,
+    'quoted_status_id_str':string?,
+    'in_reply_to_status_id_str':string?,
+    'in_reply_to_status_id':int64?,
+    'in_reply_to_user_id_str':string?,
+    'in_reply_to_screen_name':string?,
+    'in_reply_to_user_id':int64?,
+    'place':placeType3?
+}
+create type bounding_boxType4 as open {
+    'coordinates':[[[double]]]?,
+    'type':string?
+}
+create type placeType4 as open {
+    'country_code':string?,
+    'country':string?,
+    'full_name':string?,
+    'bounding_box':bounding_boxType4?,
+    'place_type':string?,
+    'name':string?,
+    'id':string?,
+    'url':string?
+}
+create type geoType2 as open {
+    'coordinates':[double]?,
+    'type':string?
+}
+create type coordinatesType2 as open {
+    'coordinates':[double]?,
+    'type':string?
+}
+create type TweetType as open {
+    'id':string,
+    'created_at':string?,
+    'source':string?,
+    'retweeted_status':retweeted_statusType1?,
+    'retweet_count':int64?,
+    'retweeted':boolean?,
+    'filter_level':string?,
+    'is_quote_status':boolean?,
+    'id_str':string?,
+    'favorite_count':int64?,
+    'text':string?,
+    'lang':string?,
+    'favorited':boolean?,
+    'truncated':boolean?,
+    'timestamp_ms':string?,
+    'entities':entitiesType3?,
+    'user':userType3?,
+    'extended_entities':extended_entitiesType3?,
+    'in_reply_to_status_id_str':string?,
+    'in_reply_to_status_id':int64?,
+    'in_reply_to_user_id_str':string?,
+    'in_reply_to_screen_name':string?,
+    'in_reply_to_user_id':int64?,
+    'possibly_sensitive':boolean?,
+    'quoted_status':quoted_statusType2?,
+    'quoted_status_id':int64?,
+    'quoted_status_id_str':string?,
+    'place':placeType4?,
+    'geo':geoType2?,
+    'coordinates':coordinatesType2?
+}
+
+create dataset Tweets(TweetType)
+primary key id
+
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries/records/closed-nullable-fields_issue1616/closed-nullable-fileds_issue1616.2.update.aql
b/asterixdb/asterix-app/src/test/resources/runtimets/queries/records/closed-nullable-fields_issue1616/closed-nullable-fileds_issue1616.2.update.aql
new file mode 100644
index 0000000..1932679
--- /dev/null
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries/records/closed-nullable-fields_issue1616/closed-nullable-fileds_issue1616.2.update.aql
@@ -0,0 +1,28 @@
+/*
+ * Licensed to the Apache Software Foundation (ASF) under one
+ * or more contributor license agreements.  See the NOTICE file
+ * distributed with this work for additional information
+ * regarding copyright ownership.  The ASF licenses this file
+ * to you under the Apache License, Version 2.0 (the
+ * "License"); you may not use this file except in compliance
+ * with the License.  You may obtain a copy of the License at
+ *
+ *   http://www.apache.org/licenses/LICENSE-2.0
+ *
+ * Unless required by applicable law or agreed to in writing,
+ * software distributed under the License is distributed on an
+ * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+ * KIND, either express or implied.  See the License for the
+ * specific language governing permissions and limitations
+ * under the License.
+ */
+ /*
+* Description  : Fix ArrayOutOfBound and IndexOutOfBound exception
+* Expected Res : Success
+* Issue        : 1334 and 1616
+* Date         : 12th Sept. 2016
+*/
+use dataverse test;
+
+load dataset Tweets using localfs
+(("path"="asterix_nc1://data/twitter/closed-nullable-fields-issue_1616.adm"),("format"="adm"));
\ No newline at end of file
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries/records/closed-nullable-fields_issue1616/closed-nullable-fileds_issue1616.3.query.aql
b/asterixdb/asterix-app/src/test/resources/runtimets/queries/records/closed-nullable-fields_issue1616/closed-nullable-fileds_issue1616.3.query.aql
new file mode 100644
index 0000000..cc59c2e
--- /dev/null
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries/records/closed-nullable-fields_issue1616/closed-nullable-fileds_issue1616.3.query.aql
@@ -0,0 +1,29 @@
+/*
+ * Licensed to the Apache Software Foundation (ASF) under one
+ * or more contributor license agreements.  See the NOTICE file
+ * distributed with this work for additional information
+ * regarding copyright ownership.  The ASF licenses this file
+ * to you under the Apache License, Version 2.0 (the
+ * "License"); you may not use this file except in compliance
+ * with the License.  You may obtain a copy of the License at
+ *
+ *   http://www.apache.org/licenses/LICENSE-2.0
+ *
+ * Unless required by applicable law or agreed to in writing,
+ * software distributed under the License is distributed on an
+ * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+ * KIND, either express or implied.  See the License for the
+ * specific language governing permissions and limitations
+ * under the License.
+ */
+ /*
+* Description  : Fix ArrayOutOfBound and IndexOutOfBound exception
+* Expected Res : Success
+* Issue        : 1334 and 1616
+* Date         : 12th Sept. 2016
+*/
+use dataverse test;
+
+for $x in dataset Tweets
+order by $x.id
+return $x
\ No newline at end of file
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results/records/closed-nullable-fields_issue1616/closed-nullable-fields_issue1616.1.adm
b/asterixdb/asterix-app/src/test/resources/runtimets/results/records/closed-nullable-fields_issue1616/closed-nullable-fields_issue1616.1.adm
new file mode 100644
index 0000000..0e46817
--- /dev/null
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/results/records/closed-nullable-fields_issue1616/closed-nullable-fields_issue1616.1.adm
@@ -0,0 +1,2 @@
+{ "id": "0000000", "created_at": "string", "source": "string", "retweet_count": 1, "retweeted":
true, "filter_level": "string", "is_quote_status": true, "id_str": "string", "favorite_count":
1, "text": "string", "lang": "string", "favorited": true, "truncated": true, "timestamp_ms":
"string", "entities": { "user_mentions": [ { "indices": [ 1 ], "screen_name": "string", "id_str":
"string", "name": "string", "id": 1 } ], "urls": [ { "display_url": "string", "indices": [
1 ], "expanded_url": "string", "url": "string" } ] }, "user": { "friends_count": 1, "profile_image_url_https":
"string", "listed_count": 1, "profile_background_image_url": "string", "default_profile_image":
true, "favourites_count": 1, "description": "string", "created_at": "string", "is_translator":
true, "profile_background_image_url_https": "string", "protected": true, "screen_name": "string",
"id_str": "string", "profile_link_color": "string", "id": 1, "geo_enabled": true, "profile_background_color":
"strin
 g", "lang": "string", "profile_sidebar_border_color": "string", "profile_text_color": "string",
"verified": true, "profile_image_url": "string", "contributors_enabled": true, "profile_background_tile":
true, "profile_banner_url": "string", "statuses_count": 1, "followers_count": 1, "profile_use_background_image":
true, "default_profile": true, "name": "string", "location": "string", "profile_sidebar_fill_color":
"string", "utc_offset": 1, "time_zone": "string", "url": "string" }, "in_reply_to_status_id_str":
"string", "in_reply_to_status_id": 1, "in_reply_to_user_id_str": "string", "in_reply_to_screen_name":
"string", "in_reply_to_user_id": 1, "possibly_sensitive": true, "quoted_status": { "created_at":
"string", "truncated": true, "source": "string", "retweet_count": 1, "retweeted": true, "filter_level":
"string", "is_quote_status": true, "id_str": "string", "favorite_count": 1, "id": 1, "text":
"string", "lang": "string", "user": { "friends_count": 1, "profile_image_url_ht
 tps": "string", "listed_count": 1, "profile_background_image_url": "string", "default_profile_image":
true, "favourites_count": 1, "description": "string", "created_at": "string", "is_translator":
true, "profile_background_image_url_https": "string", "protected": true, "screen_name": "string",
"id_str": "string", "profile_link_color": "string", "id": 1, "geo_enabled": true, "profile_background_color":
"string", "lang": "string", "profile_sidebar_border_color": "string", "profile_text_color":
"string", "verified": true, "profile_image_url": "string", "contributors_enabled": true, "profile_background_tile":
true, "profile_banner_url": "string", "statuses_count": 1, "followers_count": 1, "profile_use_background_image":
true, "default_profile": true, "name": "string", "profile_sidebar_fill_color": "string" },
"favorited": true, "entities": { , "user_mentions": [ { "indices": [ 1 ], "screen_name": "string",
"id_str": "string", "name": "string", "id": 1 } ] }, "in_reply_to_status_
 id_str": "string", "in_reply_to_status_id": 1, "in_reply_to_user_id_str": "string", "in_reply_to_screen_name":
"string", "in_reply_to_user_id": 1 }, "quoted_status_id": 1, "quoted_status_id_str": "string",
"place": { "country_code": "string", "country": "string", "full_name": "string", "bounding_box":
{ "coordinates": [ [ [ 1.1 ] ] ], "type": "string" }, "place_type": "string", "name": "string",
"id": "string", "url": "string" }, "geo": { "coordinates": [ 1.1 ], "type": "string" }, "coordinates":
{ "coordinates": [ 1.1 ], "type": "string" } }
+{ "id": "11111111111111111111", "created_at": "string", "source": "string", "retweet_count":
1, "retweeted": true, "filter_level": "string", "is_quote_status": true, "id_str": "string",
"favorite_count": 1, "text": "string", "lang": "string", "favorited": true, "truncated": true,
"timestamp_ms": "string", "user": { "friends_count": 1, "profile_image_url_https": "string",
"listed_count": 1, "profile_background_image_url": "string", "default_profile_image": true,
"favourites_count": 1, "description": "string", "created_at": "string", "is_translator": true,
"profile_background_image_url_https": "string", "protected": true, "screen_name": "string",
"id_str": "string", "profile_link_color": "string", "id": 1, "geo_enabled": true, "profile_background_color":
"string", "lang": "string", "profile_sidebar_border_color": "string", "profile_text_color":
"string", "verified": true, "profile_image_url": "string", "contributors_enabled": true, "profile_background_tile":
true, "profile_ban
 ner_url": "string", "statuses_count": 1, "followers_count": 1, "profile_use_background_image":
true, "default_profile": true, "name": "string", "location": "string", "profile_sidebar_fill_color":
"string", "utc_offset": 1, "time_zone": "string", "url": "string" }, "in_reply_to_status_id_str":
"string", "in_reply_to_status_id": 1, "in_reply_to_user_id_str": "string", "in_reply_to_screen_name":
"string", "in_reply_to_user_id": 1, "possibly_sensitive": true, "quoted_status": { "created_at":
"string", "truncated": true, "source": "string", "retweet_count": 1, "retweeted": true, "filter_level":
"string", "is_quote_status": true, "id_str": "string", "favorite_count": 1, "id": 1, "text":
"string", "lang": "string", "user": { "friends_count": 1, "profile_image_url_https": "string",
"listed_count": 1, "profile_background_image_url": "string", "default_profile_image": true,
"favourites_count": 1, "description": "string", "created_at": "string", "is_translator": true,
"profile_backgrou
 nd_image_url_https": "string", "protected": true, "screen_name": "string", "id_str": "string",
"profile_link_color": "string", "id": 1, "geo_enabled": true, "profile_background_color":
"string", "lang": "string", "profile_sidebar_border_color": "string", "profile_text_color":
"string", "verified": true, "profile_image_url": "string", "contributors_enabled": true, "profile_background_tile":
true, "profile_banner_url": "string", "statuses_count": 1, "followers_count": 1, "profile_use_background_image":
true, "default_profile": true, "name": "string", "profile_sidebar_fill_color": "string" },
"favorited": true, "entities": { , "user_mentions": [ { "indices": [ 1 ], "screen_name": "string",
"id_str": "string", "name": "string", "id": 1 } ] }, "in_reply_to_status_id_str": "string",
"in_reply_to_status_id": 1, "in_reply_to_user_id_str": "string", "in_reply_to_screen_name":
"string", "in_reply_to_user_id": 1 }, "quoted_status_id": 1, "quoted_status_id_str": "string",
"place": { "co
 untry_code": "string", "country": "string", "full_name": "string", "bounding_box": { "coordinates":
[ [ [ 1.1 ] ] ], "type": "string" }, "place_type": "string", "name": "string", "id": "string",
"url": "string" }, "geo": { "coordinates": [ 1.1 ], "type": "string" }, "coordinates": { "coordinates":
[ 1.1 ], "type": "string" } }
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/testsuite.xml b/asterixdb/asterix-app/src/test/resources/runtimets/testsuite.xml
index 88b47f2..86475a2 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/testsuite.xml
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/testsuite.xml
@@ -4817,6 +4817,13 @@
   </test-group>
   &RecordsQueries;
   &DeepEqualQueries;
+  <test-group name="records">
+      <test-case FilePath="records">
+      <compilation-unit name="closed-nullable-fields_issue1616">
+        <output-dir compare="Text">closed-nullable-fields_issue1616</output-dir>
+      </compilation-unit>
+    </test-case>
+  </test-group>
   <test-group name="scan">
     <test-case FilePath="scan">
       <compilation-unit name="10">

-- 
To view, visit https://asterix-gerrit.ics.uci.edu/1165
To unsubscribe, visit https://asterix-gerrit.ics.uci.edu/settings

Gerrit-MessageType: merged
Gerrit-Change-Id: I7e88adbfa2721fa589e1d0564bb9e0889b722e2e
Gerrit-PatchSet: 5
Gerrit-Project: asterixdb
Gerrit-Branch: master
Gerrit-Owner: Wail Alkowaileet <wael.y.k@gmail.com>
Gerrit-Reviewer: Ian Maxon <imaxon@apache.org>
Gerrit-Reviewer: Jenkins <jenkins@fulliautomatix.ics.uci.edu>
Gerrit-Reviewer: Till Westmann <tillw@apache.org>
Gerrit-Reviewer: Wail Alkowaileet <wael.y.k@gmail.com>
Gerrit-Reviewer: Yingyi Bu <buyingyi@gmail.com>


Mime
View raw message