This is an automated email from the ASF dual-hosted git repository. mblow pushed a commit to branch master in repository https://gitbox.apache.org/repos/asf/asterixdb.git
commit 3682b97052b8f86ad50035901c10e406631169b2 Author: Ali Alsuliman <[email protected]> AuthorDate: Wed Jun 21 23:02:11 2023 -0700 [ASTERIXDB-3215][FUN] Add test for OBJECT_VALUES() - user model changes: no - storage format changes: no - interface changes: no Add test for OBJECT_VALUES() for open-type record Change-Id: I5a2291c275ff993ec749612a7dc96c86237bd748 Reviewed-on: https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/17611 Reviewed-by: Ali Alsuliman <[email protected]> Reviewed-by: Wail Alkowaileet <[email protected]> Integration-Tests: Jenkins <[email protected]> Tested-by: Jenkins <[email protected]> --- .../queries_sqlpp/objects/object_values/object_values.1.ddl.sqlpp | 8 +++++++- .../objects/object_values/object_values.2.update.sqlpp | 4 +++- .../{object_values.4.ddl.sqlpp => object_values.4.query.sqlpp} | 5 +++-- .../{object_values.4.ddl.sqlpp => object_values.9.ddl.sqlpp} | 0 .../runtimets/results/objects/object_values/object_values.4.adm | 1 + 5 files changed, 14 insertions(+), 4 deletions(-) diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/objects/object_values/object_values.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/objects/object_values/object_values.1.ddl.sqlpp index 22a7e71e60..45c9e04165 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/objects/object_values/object_values.1.ddl.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/objects/object_values/object_values.1.ddl.sqlpp @@ -49,8 +49,14 @@ create type TinySocial.TweetMessageType2 as { user : TwitterUserType? }; +create type TinySocial.openType as { + id: int +}; + create dataset TwitterUsers(TwitterUserType) primary key `screen-name`; create dataset TweetMessages(TweetMessageType) primary key tweetid; -create dataset TweetMessages2(TweetMessageType2) primary key tweetid; \ No newline at end of file +create dataset TweetMessages2(TweetMessageType2) primary key tweetid; + +create dataset ds(openType) primary key id; \ No newline at end of file diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/objects/object_values/object_values.2.update.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/objects/object_values/object_values.2.update.sqlpp index 0c78212625..dce0a5fd53 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/objects/object_values/object_values.2.update.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/objects/object_values/object_values.2.update.sqlpp @@ -28,4 +28,6 @@ load dataset TwitterUsers using localfs ((`path`=`asterix_nc1://data/tinysocial load dataset TweetMessages using localfs ((`path`=`asterix_nc1://data/tinysocial/twm.adm`),(`format`=`adm`)); -load dataset TweetMessages2 using localfs ((`path`=`asterix_nc1://data/tinysocial/twm.adm`),(`format`=`adm`)); \ No newline at end of file +load dataset TweetMessages2 using localfs ((`path`=`asterix_nc1://data/tinysocial/twm.adm`),(`format`=`adm`)); + +upsert into ds {"id": 1, "o": { "a": 2, "b": "t", "obj": {"x": 3, "y": {"y1": 1, "y2": [1,2]}, "z": [1,2]}, "array": [1,2,3]}}; \ No newline at end of file diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/objects/object_values/object_values.4.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/objects/object_values/object_values.4.query.sqlpp similarity index 88% copy from asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/objects/object_values/object_values.4.ddl.sqlpp copy to asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/objects/object_values/object_values.4.query.sqlpp index 158cefab2b..70b05de693 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/objects/object_values/object_values.4.ddl.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/objects/object_values/object_values.4.query.sqlpp @@ -18,8 +18,9 @@ */ /* - * Description : Testing object_values under different queries. + * Description : Testing object_values for an open-type record. * Expected Res : Success */ -drop dataverse TinySocial; \ No newline at end of file +use TinySocial; +select object_values(ds.o) from ds; \ No newline at end of file diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/objects/object_values/object_values.4.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/objects/object_values/object_values.9.ddl.sqlpp similarity index 100% rename from asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/objects/object_values/object_values.4.ddl.sqlpp rename to asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/objects/object_values/object_values.9.ddl.sqlpp diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results/objects/object_values/object_values.4.adm b/asterixdb/asterix-app/src/test/resources/runtimets/results/objects/object_values/object_values.4.adm new file mode 100644 index 0000000000..fbd534c5f3 --- /dev/null +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results/objects/object_values/object_values.4.adm @@ -0,0 +1 @@ +{ "$1": [ 2, "t", { "x": 3, "y": { "y1": 1, "y2": [ 1, 2 ] }, "z": [ 1, 2 ] }, [ 1, 2, 3 ] ] } \ No newline at end of file
