Yingyi Bu has submitted this change and it was merged. Change subject: ASTERIXDB-1388: fix typos in test queries ......................................................................
ASTERIXDB-1388: fix typos in test queries Change-Id: Id60d7a6a383010e4930b491a7fb066efbea6e985 Reviewed-on: https://asterix-gerrit.ics.uci.edu/788 Reviewed-by: Till Westmann <[email protected]> Tested-by: Jenkins <[email protected]> --- M asterix-app/src/test/resources/runtimets/queries_sqlpp/global-aggregate/q01/q01.3.query.sqlpp M asterix-app/src/test/resources/runtimets/queries_sqlpp/global-aggregate/q02/q02.3.query.sqlpp M asterix-app/src/test/resources/runtimets/queries_sqlpp/global-aggregate/q05_error/q05_error.3.query.sqlpp M asterix-app/src/test/resources/runtimets/queries_sqlpp/global-aggregate/q08/q08.3.query.sqlpp M asterix-app/src/test/resources/runtimets/results/global-aggregate/q08/q08.1.adm 5 files changed, 16 insertions(+), 15 deletions(-) Approvals: Till Westmann: Looks good to me, approved Jenkins: Verified diff --git a/asterix-app/src/test/resources/runtimets/queries_sqlpp/global-aggregate/q01/q01.3.query.sqlpp b/asterix-app/src/test/resources/runtimets/queries_sqlpp/global-aggregate/q01/q01.3.query.sqlpp index abf6092..6664c91 100644 --- a/asterix-app/src/test/resources/runtimets/queries_sqlpp/global-aggregate/q01/q01.3.query.sqlpp +++ b/asterix-app/src/test/resources/runtimets/queries_sqlpp/global-aggregate/q01/q01.3.query.sqlpp @@ -19,5 +19,5 @@ USE TinySocial; -SELECT count(u.friend_ids) count +SELECT count(u."friend-ids") count FROM FacebookUsers u; diff --git a/asterix-app/src/test/resources/runtimets/queries_sqlpp/global-aggregate/q02/q02.3.query.sqlpp b/asterix-app/src/test/resources/runtimets/queries_sqlpp/global-aggregate/q02/q02.3.query.sqlpp index 9c00dac..1204809 100644 --- a/asterix-app/src/test/resources/runtimets/queries_sqlpp/global-aggregate/q02/q02.3.query.sqlpp +++ b/asterix-app/src/test/resources/runtimets/queries_sqlpp/global-aggregate/q02/q02.3.query.sqlpp @@ -19,5 +19,5 @@ USE TinySocial; -SELECT 1 foo, COUNT(u.friend_ids) count +SELECT 1 foo, COUNT(u."friend-ids") count FROM FacebookUsers u; diff --git a/asterix-app/src/test/resources/runtimets/queries_sqlpp/global-aggregate/q05_error/q05_error.3.query.sqlpp b/asterix-app/src/test/resources/runtimets/queries_sqlpp/global-aggregate/q05_error/q05_error.3.query.sqlpp index 2cb755a..7922734 100644 --- a/asterix-app/src/test/resources/runtimets/queries_sqlpp/global-aggregate/q05_error/q05_error.3.query.sqlpp +++ b/asterix-app/src/test/resources/runtimets/queries_sqlpp/global-aggregate/q05_error/q05_error.3.query.sqlpp @@ -19,5 +19,5 @@ USE TinySocial; -SELECT u.name name, COUNT(u.friend_ids) count +SELECT u.name name, COUNT(u."friend-ids") count FROM FacebookUsers u; diff --git a/asterix-app/src/test/resources/runtimets/queries_sqlpp/global-aggregate/q08/q08.3.query.sqlpp b/asterix-app/src/test/resources/runtimets/queries_sqlpp/global-aggregate/q08/q08.3.query.sqlpp index d333752..9ff9b65 100644 --- a/asterix-app/src/test/resources/runtimets/queries_sqlpp/global-aggregate/q08/q08.3.query.sqlpp +++ b/asterix-app/src/test/resources/runtimets/queries_sqlpp/global-aggregate/q08/q08.3.query.sqlpp @@ -19,5 +19,6 @@ USE TinySocial; -SELECT COLL_COUNT(u.friend_ids) count -FROM FacebookUsers u; +SELECT COLL_COUNT(u."friend-ids") count +FROM FacebookUsers u +ORDER BY u.id; diff --git a/asterix-app/src/test/resources/runtimets/results/global-aggregate/q08/q08.1.adm b/asterix-app/src/test/resources/runtimets/results/global-aggregate/q08/q08.1.adm index c61d241..e45bb55 100644 --- a/asterix-app/src/test/resources/runtimets/results/global-aggregate/q08/q08.1.adm +++ b/asterix-app/src/test/resources/runtimets/results/global-aggregate/q08/q08.1.adm @@ -1,10 +1,10 @@ -{ "count": 0 } -{ "count": 0 } -{ "count": 0 } -{ "count": 0 } -{ "count": 0 } -{ "count": 0 } -{ "count": 0 } -{ "count": 0 } -{ "count": 0 } -{ "count": 0 } +{ "count": 4 } +{ "count": 2 } +{ "count": 4 } +{ "count": 1 } +{ "count": 3 } +{ "count": 3 } +{ "count": 1 } +{ "count": 1 } +{ "count": 2 } +{ "count": 3 } -- To view, visit https://asterix-gerrit.ics.uci.edu/788 To unsubscribe, visit https://asterix-gerrit.ics.uci.edu/settings Gerrit-MessageType: merged Gerrit-Change-Id: Id60d7a6a383010e4930b491a7fb066efbea6e985 Gerrit-PatchSet: 2 Gerrit-Project: asterixdb Gerrit-Branch: master Gerrit-Owner: Yingyi Bu <[email protected]> Gerrit-Reviewer: Jenkins <[email protected]> Gerrit-Reviewer: Till Westmann <[email protected]> Gerrit-Reviewer: Yingyi Bu <[email protected]>
