Return-Path: X-Original-To: archive-asf-public-internal@cust-asf2.ponee.io Delivered-To: archive-asf-public-internal@cust-asf2.ponee.io Received: from cust-asf.ponee.io (cust-asf.ponee.io [163.172.22.183]) by cust-asf2.ponee.io (Postfix) with ESMTP id 4B8E2200B92 for ; Wed, 14 Sep 2016 02:10:00 +0200 (CEST) Received: by cust-asf.ponee.io (Postfix) id 4A117160AD3; Wed, 14 Sep 2016 00:10:00 +0000 (UTC) Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by cust-asf.ponee.io (Postfix) with SMTP id 94CB8160AD2 for ; Wed, 14 Sep 2016 02:09:58 +0200 (CEST) Received: (qmail 11106 invoked by uid 500); 14 Sep 2016 00:09:57 -0000 Mailing-List: contact commits-help@asterixdb.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@asterixdb.apache.org Delivered-To: mailing list commits@asterixdb.apache.org Received: (qmail 11097 invoked by uid 99); 14 Sep 2016 00:09:57 -0000 Received: from git1-us-west.apache.org (HELO git1-us-west.apache.org) (140.211.11.23) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 14 Sep 2016 00:09:57 +0000 Received: by git1-us-west.apache.org (ASF Mail Server at git1-us-west.apache.org, from userid 33) id AC4C9E01BD; Wed, 14 Sep 2016 00:09:57 +0000 (UTC) Content-Type: text/plain; charset="us-ascii" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit From: buyingyi@apache.org To: commits@asterixdb.apache.org Message-Id: <0181a1392d1f4d81b3e2ca1b3e5eaad5@git.apache.org> X-Mailer: ASF-Git Admin Mailer Subject: asterixdb git commit: ASTERIXDB-1334 and ASTERIXDB-1616: Add a regression test. Date: Wed, 14 Sep 2016 00:09:57 +0000 (UTC) archived-at: Wed, 14 Sep 2016 00:10:00 -0000 Repository: asterixdb Updated Branches: refs/heads/master a001e46ce -> 93a67deeb ASTERIXDB-1334 and ASTERIXDB-1616: Add a regression test. Change-Id: I7e88adbfa2721fa589e1d0564bb9e0889b722e2e Reviewed-on: https://asterix-gerrit.ics.uci.edu/1165 Sonar-Qube: Jenkins Tested-by: Jenkins Reviewed-by: Ian Maxon Integration-Tests: Jenkins Project: http://git-wip-us.apache.org/repos/asf/asterixdb/repo Commit: http://git-wip-us.apache.org/repos/asf/asterixdb/commit/93a67dee Tree: http://git-wip-us.apache.org/repos/asf/asterixdb/tree/93a67dee Diff: http://git-wip-us.apache.org/repos/asf/asterixdb/diff/93a67dee Branch: refs/heads/master Commit: 93a67deebf5bcbcb525623cd183b09ac9f0f5e02 Parents: a001e46 Author: Yingyi Bu Authored: Tue Sep 13 15:24:31 2016 -0700 Committer: Yingyi Bu Committed: Tue Sep 13 17:09:34 2016 -0700 ---------------------------------------------------------------------- .../closed-nullable-fields-issue_1616.adm | 2 + .../closed-nullable-fileds_issue1616.1.ddl.aql | 862 +++++++++++++++++++ ...losed-nullable-fileds_issue1616.2.update.aql | 28 + ...closed-nullable-fileds_issue1616.3.query.aql | 29 + .../closed-nullable-fields_issue1616.1.adm | 2 + .../src/test/resources/runtimets/testsuite.xml | 7 + 6 files changed, 930 insertions(+) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/asterixdb/blob/93a67dee/asterixdb/asterix-app/data/twitter/closed-nullable-fields-issue_1616.adm ---------------------------------------------------------------------- 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","entities": {"u ser_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_backgr ound_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","profile_background_image_ur l": "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_reply_to_scr een_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","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,"time_zone": "string","url": "string","utc_offset": 1,"verified": true }} \ No newline at end of file http://git-wip-us.apache.org/repos/asf/asterixdb/blob/93a67dee/asterixdb/asterix-app/src/test/resources/runtimets/queries/records/closed-nullable-fields_issue1616/closed-nullable-fileds_issue1616.1.ddl.aql ---------------------------------------------------------------------- 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 + http://git-wip-us.apache.org/repos/asf/asterixdb/blob/93a67dee/asterixdb/asterix-app/src/test/resources/runtimets/queries/records/closed-nullable-fields_issue1616/closed-nullable-fileds_issue1616.2.update.aql ---------------------------------------------------------------------- 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 http://git-wip-us.apache.org/repos/asf/asterixdb/blob/93a67dee/asterixdb/asterix-app/src/test/resources/runtimets/queries/records/closed-nullable-fields_issue1616/closed-nullable-fileds_issue1616.3.query.aql ---------------------------------------------------------------------- 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 http://git-wip-us.apache.org/repos/asf/asterixdb/blob/93a67dee/asterixdb/asterix-app/src/test/resources/runtimets/results/records/closed-nullable-fields_issue1616/closed-nullable-fields_issue1616.1.adm ---------------------------------------------------------------------- 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": "string", "lan g": "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_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_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_r eply_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_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_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_htt ps": "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" } } http://git-wip-us.apache.org/repos/asf/asterixdb/blob/93a67dee/asterixdb/asterix-app/src/test/resources/runtimets/testsuite.xml ---------------------------------------------------------------------- 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 @@ &RecordsQueries; &DeepEqualQueries; + + + + closed-nullable-fields_issue1616 + + +