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 91da9477d12f295af888514f4228152b2d5b2d14 Author: Ian Maxon <[email protected]> AuthorDate: Tue Jan 21 15:05:53 2025 -0800 [ASTERIXDB-3551][TEST]: Kludge OptimizerTest to avoid case-sensitivity - user model changes: no - storage format changes: no - interface changes: no Ext-ref: MB-64953 Change-Id: I9ba2ce7afc54ddd08f5e522627c56e22f51cabac Reviewed-on: https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/19352 Integration-Tests: Jenkins <[email protected]> Tested-by: Ian Maxon <[email protected]> Reviewed-by: Ian Maxon <[email protected]> Reviewed-by: Vijay Sarathy <[email protected]> --- .../queries/index-through-object/index-through-object.1.sqlpp | 8 ++++---- .../queries/index-through-object/index-through-object.10.sqlpp | 8 ++++---- .../queries/index-through-object/index-through-object.11.sqlpp | 10 +++++----- .../queries/index-through-object/index-through-object.2.sqlpp | 8 ++++---- .../queries/index-through-object/index-through-object.3.sqlpp | 8 ++++---- .../queries/index-through-object/index-through-object.4.sqlpp | 8 ++++---- .../queries/index-through-object/index-through-object.5.sqlpp | 8 ++++---- .../queries/index-through-object/index-through-object.6.sqlpp | 8 ++++---- .../queries/index-through-object/index-through-object.7.sqlpp | 8 ++++---- .../queries/index-through-object/index-through-object.8.sqlpp | 8 ++++---- .../queries/index-through-object/index-through-object.9.sqlpp | 8 ++++---- .../results/index-through-object/index-through-object.1.plan | 4 ++-- .../results/index-through-object/index-through-object.10.plan | 4 ++-- .../results/index-through-object/index-through-object.11.plan | 8 ++++---- .../results/index-through-object/index-through-object.2.plan | 4 ++-- .../results/index-through-object/index-through-object.3.plan | 4 ++-- .../results/index-through-object/index-through-object.4.plan | 4 ++-- .../results/index-through-object/index-through-object.5.plan | 2 +- .../results/index-through-object/index-through-object.6.plan | 4 ++-- .../results/index-through-object/index-through-object.7.plan | 2 +- .../results/index-through-object/index-through-object.8.plan | 4 ++-- .../results/index-through-object/index-through-object.9.plan | 8 ++++---- .../index-through-object/index-through-object.1.plan | 2 +- .../index-through-object/index-through-object.2.plan | 2 +- .../index-through-object/index-through-object.3.plan | 2 +- .../index-through-object/index-through-object.4.plan | 2 +- .../index-through-object/index-through-object.8.plan | 2 +- .../index-through-object/index-through-object.9.plan | 4 ++-- 28 files changed, 76 insertions(+), 76 deletions(-) diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/index-through-object/index-through-object.1.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/index-through-object/index-through-object.1.sqlpp index 76f8416f6b..a7a3279e2b 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/index-through-object/index-through-object.1.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/index-through-object/index-through-object.1.sqlpp @@ -22,15 +22,15 @@ * Index "usersNameIdx" should be used. */ -DROP DATAVERSE Test IF EXISTS; -CREATE DATAVERSE Test; -USE Test; +DROP DATAVERSE test IF EXISTS; +CREATE DATAVERSE test; +USE test; CREATE TYPE UsersType AS { user_id: bigint }; CREATE DATASET Users (UsersType) PRIMARY KEY user_id; CREATE INDEX usersNameIdx ON Users ( name : string ); -FROM Test.Users U +FROM test.Users U LET augmentedUser = OBJECT_ADD(U, "favoriteColor", "Green") WHERE augmentedUser.name = "Glenn" SELECT *; \ No newline at end of file diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/index-through-object/index-through-object.10.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/index-through-object/index-through-object.10.sqlpp index 7e018b919d..0eb8772134 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/index-through-object/index-through-object.10.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/index-through-object/index-through-object.10.sqlpp @@ -22,14 +22,14 @@ * Primary index should used w/ INLJ. */ -DROP DATAVERSE Test IF EXISTS; -CREATE DATAVERSE Test; -USE Test; +DROP DATAVERSE test IF EXISTS; +CREATE DATAVERSE test; +USE test; CREATE TYPE UsersType AS { user_id: bigint }; CREATE DATASET Users (UsersType) PRIMARY KEY user_id; -FROM Test.Users U1, Test.Users U2 +FROM test.Users U1, test.Users U2 LET augmentedUser1 = OBJECT_ADD(U1, "favoriteColor", "Green"), augmentedUser2 = OBJECT_ADD(U2, "favoriteFood", "Pizza"), augmentedUser3 = OBJECT_ADD(augmentedUser2, "favoriteColor", "Red"), diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/index-through-object/index-through-object.11.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/index-through-object/index-through-object.11.sqlpp index 782060fdb0..5e7e52391c 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/index-through-object/index-through-object.11.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/index-through-object/index-through-object.11.sqlpp @@ -22,23 +22,23 @@ * Index should be used in both cases. */ -DROP DATAVERSE Test IF EXISTS; -CREATE DATAVERSE Test; -USE Test; +DROP DATAVERSE test IF EXISTS; +CREATE DATAVERSE test; +USE test; CREATE TYPE UsersType AS { user_id: bigint, name: { first: string } }; CREATE DATASET Users (UsersType) PRIMARY KEY user_id; CREATE INDEX firstUsersNameIdx ON Users ( name.first ); CREATE INDEX lastUsersNameIdx ON Users ( name.last: string ); -FROM Test.Users U1 +FROM test.Users U1 LET augmentedUser1 = OBJECT_ADD(U1, "favoriteColor", "Green") WHERE augmentedUser1.name.first = "Glenn" SELECT augmentedUser1.* UNION ALL -FROM Test.Users U2 +FROM test.Users U2 LET augmentedUser2 = OBJECT_ADD(U2, "favoriteFood", "Pizza") WHERE augmentedUser2.name.last = "John" SELECT augmentedUser2.*; diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/index-through-object/index-through-object.2.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/index-through-object/index-through-object.2.sqlpp index 4583e1cc85..8ccd9f4b3e 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/index-through-object/index-through-object.2.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/index-through-object/index-through-object.2.sqlpp @@ -22,15 +22,15 @@ * Index "usersNameIdx" should be used. */ -DROP DATAVERSE Test IF EXISTS; -CREATE DATAVERSE Test; -USE Test; +DROP DATAVERSE test IF EXISTS; +CREATE DATAVERSE test; +USE test; CREATE TYPE UsersType AS { user_id: bigint }; CREATE DATASET Users (UsersType) PRIMARY KEY user_id; CREATE INDEX usersNameIdx ON Users ( name : string ); -FROM Test.Users U +FROM test.Users U LET augmentedUser1 = OBJECT_ADD(U, "favoriteColor", "Green"), augmentedUser2 = OBJECT_ADD(augmentedUser1, "favoriteCity", "Irvine") WHERE augmentedUser2.name = "Glenn" diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/index-through-object/index-through-object.3.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/index-through-object/index-through-object.3.sqlpp index 0d81c0fd86..995431d2aa 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/index-through-object/index-through-object.3.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/index-through-object/index-through-object.3.sqlpp @@ -22,15 +22,15 @@ * Index "usersNameIdx" should be used. */ -DROP DATAVERSE Test IF EXISTS; -CREATE DATAVERSE Test; -USE Test; +DROP DATAVERSE test IF EXISTS; +CREATE DATAVERSE test; +USE test; CREATE TYPE UsersType AS { user_id: bigint }; CREATE DATASET Users (UsersType) PRIMARY KEY user_id; CREATE INDEX usersNameIdx ON Users ( name.first : string ); -FROM Test.Users U +FROM test.Users U LET augmentedUser = OBJECT_ADD(U, "favoriteColor", "Green") WHERE augmentedUser.name.first = "Glenn" SELECT *; \ No newline at end of file diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/index-through-object/index-through-object.4.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/index-through-object/index-through-object.4.sqlpp index 95a60e663c..cd5c3c240d 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/index-through-object/index-through-object.4.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/index-through-object/index-through-object.4.sqlpp @@ -22,15 +22,15 @@ * Index "usersNameIdx" should be used. */ -DROP DATAVERSE Test IF EXISTS; -CREATE DATAVERSE Test; -USE Test; +DROP DATAVERSE test IF EXISTS; +CREATE DATAVERSE test; +USE test; CREATE TYPE UsersType AS { user_id: bigint }; CREATE DATASET Users (UsersType) PRIMARY KEY user_id; CREATE INDEX usersNameIdx ON Users ( name : string ); -FROM Test.Users U +FROM test.Users U LET augmentedUser = OBJECT_REMOVE(U, "favoriteColor") WHERE augmentedUser.name = "Glenn" SELECT *; \ No newline at end of file diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/index-through-object/index-through-object.5.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/index-through-object/index-through-object.5.sqlpp index 41af9221e1..9fff83a10e 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/index-through-object/index-through-object.5.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/index-through-object/index-through-object.5.sqlpp @@ -22,15 +22,15 @@ * Index should NOT used. */ -DROP DATAVERSE Test IF EXISTS; -CREATE DATAVERSE Test; -USE Test; +DROP DATAVERSE test IF EXISTS; +CREATE DATAVERSE test; +USE test; CREATE TYPE UsersType AS { user_id: bigint }; CREATE DATASET Users (UsersType) PRIMARY KEY user_id; CREATE INDEX usersNameIdx ON Users ( name : string ); -FROM Test.Users U +FROM test.Users U LET augmentedUser = OBJECT_PUT(U, "name", "John") WHERE augmentedUser.name = "Glenn" SELECT *; \ No newline at end of file diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/index-through-object/index-through-object.6.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/index-through-object/index-through-object.6.sqlpp index 8b573b5063..cc11286c24 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/index-through-object/index-through-object.6.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/index-through-object/index-through-object.6.sqlpp @@ -22,14 +22,14 @@ * Primary index should used w/ INLJ. */ -DROP DATAVERSE Test IF EXISTS; -CREATE DATAVERSE Test; -USE Test; +DROP DATAVERSE test IF EXISTS; +CREATE DATAVERSE test; +USE test; CREATE TYPE UsersType AS { user_id: bigint }; CREATE DATASET Users (UsersType) PRIMARY KEY user_id; -FROM Test.Users U1, Test.Users U2 +FROM test.Users U1, test.Users U2 LET augmentedUser1 = OBJECT_ADD(U1, "favoriteColor", "Green"), augmentedUser2 = OBJECT_ADD(U2, "favoriteFood", "Pizza") WHERE augmentedUser1.name = "John" AND diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/index-through-object/index-through-object.7.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/index-through-object/index-through-object.7.sqlpp index cb48c1c2e8..bdfc27a334 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/index-through-object/index-through-object.7.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/index-through-object/index-through-object.7.sqlpp @@ -22,15 +22,15 @@ * Index should NOT be used. */ -DROP DATAVERSE Test IF EXISTS; -CREATE DATAVERSE Test; -USE Test; +DROP DATAVERSE test IF EXISTS; +CREATE DATAVERSE test; +USE test; CREATE TYPE UsersType AS { user_id: bigint }; CREATE DATASET Users (UsersType) PRIMARY KEY user_id; CREATE INDEX usersNameIdx ON Users ( name : string ); -FROM Test.Users U +FROM test.Users U LET augmentedUser = OBJECT_ADD(OBJECT_REMOVE(U, "name"), "name", "Glenn") WHERE augmentedUser.firstName = "Glenn" SELECT *; \ No newline at end of file diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/index-through-object/index-through-object.8.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/index-through-object/index-through-object.8.sqlpp index 8d780bf714..778267b615 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/index-through-object/index-through-object.8.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/index-through-object/index-through-object.8.sqlpp @@ -22,15 +22,15 @@ * Index "usersNameIdx" should be used. */ -DROP DATAVERSE Test IF EXISTS; -CREATE DATAVERSE Test; -USE Test; +DROP DATAVERSE test IF EXISTS; +CREATE DATAVERSE test; +USE test; CREATE TYPE UsersType AS { user_id: bigint }; CREATE DATASET Users (UsersType) PRIMARY KEY user_id; CREATE INDEX usersNameIdx ON Users ( name : string ); -FROM Test.Users U +FROM test.Users U LET augmentedUser = OBJECT_CONCAT({"favoriteColor": "Green"}, U, {"birthdate": "10/09/1996"}) WHERE augmentedUser.name = "Glenn" SELECT *; \ No newline at end of file diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/index-through-object/index-through-object.9.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/index-through-object/index-through-object.9.sqlpp index ad827e0552..963b820b37 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/index-through-object/index-through-object.9.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/index-through-object/index-through-object.9.sqlpp @@ -22,15 +22,15 @@ * Index should be used twice (and not used for E1). */ -DROP DATAVERSE Test IF EXISTS; -CREATE DATAVERSE Test; -USE Test; +DROP DATAVERSE test IF EXISTS; +CREATE DATAVERSE test; +USE test; CREATE TYPE UsersType AS { user_id: bigint }; CREATE DATASET Users (UsersType) PRIMARY KEY user_id; CREATE INDEX usersNameIdx ON Users ( name : string ); -FROM Test.Users U1, Test.Users U2, [{"name": "Glenn"}] E1 +FROM test.Users U1, test.Users U2, [{"name": "Glenn"}] E1 LET augmentedUser1 = OBJECT_ADD(U1, "favoriteColor", "Green"), augmentedUser2 = OBJECT_ADD(U2, "favoriteFood", "Pizza"), augmentedUser3 = OBJECT_ADD(E1, "favoriteColor", "Blue") diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/results/index-through-object/index-through-object.1.plan b/asterixdb/asterix-app/src/test/resources/optimizerts/results/index-through-object/index-through-object.1.plan index ff509f4d83..d4d3426ec2 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/results/index-through-object/index-through-object.1.plan +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/results/index-through-object/index-through-object.1.plan @@ -6,13 +6,13 @@ -- ASSIGN |PARTITIONED| -- STREAM_PROJECT |PARTITIONED| -- ONE_TO_ONE_EXCHANGE |PARTITIONED| - -- BTREE_SEARCH (Test.Users.Users) |PARTITIONED| + -- BTREE_SEARCH (test.Users.Users) |PARTITIONED| -- ONE_TO_ONE_EXCHANGE |PARTITIONED| -- STABLE_SORT [$$36(ASC)] |PARTITIONED| -- ONE_TO_ONE_EXCHANGE |PARTITIONED| -- STREAM_PROJECT |PARTITIONED| -- ONE_TO_ONE_EXCHANGE |PARTITIONED| - -- BTREE_SEARCH (Test.Users.usersNameIdx) |PARTITIONED| + -- BTREE_SEARCH (test.Users.usersNameIdx) |PARTITIONED| -- ONE_TO_ONE_EXCHANGE |PARTITIONED| -- ASSIGN |PARTITIONED| -- EMPTY_TUPLE_SOURCE |PARTITIONED| diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/results/index-through-object/index-through-object.10.plan b/asterixdb/asterix-app/src/test/resources/optimizerts/results/index-through-object/index-through-object.10.plan index f5ab2c287b..2f60b2329c 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/results/index-through-object/index-through-object.10.plan +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/results/index-through-object/index-through-object.10.plan @@ -6,7 +6,7 @@ -- ASSIGN |PARTITIONED| -- STREAM_PROJECT |PARTITIONED| -- ONE_TO_ONE_EXCHANGE |PARTITIONED| - -- BTREE_SEARCH (Test.Users.Users) |PARTITIONED| + -- BTREE_SEARCH (test.Users.Users) |PARTITIONED| -- ONE_TO_ONE_EXCHANGE |PARTITIONED| -- STABLE_SORT [$$80(ASC)] |PARTITIONED| -- HASH_PARTITION_EXCHANGE [$$80] |PARTITIONED| @@ -15,6 +15,6 @@ -- ASSIGN |PARTITIONED| -- STREAM_PROJECT |PARTITIONED| -- ONE_TO_ONE_EXCHANGE |PARTITIONED| - -- DATASOURCE_SCAN (Test.Users) |PARTITIONED| + -- DATASOURCE_SCAN (test.Users) |PARTITIONED| -- ONE_TO_ONE_EXCHANGE |PARTITIONED| -- EMPTY_TUPLE_SOURCE |PARTITIONED| diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/results/index-through-object/index-through-object.11.plan b/asterixdb/asterix-app/src/test/resources/optimizerts/results/index-through-object/index-through-object.11.plan index 6971ab466a..b6f037646d 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/results/index-through-object/index-through-object.11.plan +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/results/index-through-object/index-through-object.11.plan @@ -9,13 +9,13 @@ -- ASSIGN |PARTITIONED| -- STREAM_PROJECT |PARTITIONED| -- ONE_TO_ONE_EXCHANGE |PARTITIONED| - -- BTREE_SEARCH (Test.Users.Users) |PARTITIONED| + -- BTREE_SEARCH (test.Users.Users) |PARTITIONED| -- ONE_TO_ONE_EXCHANGE |PARTITIONED| -- STABLE_SORT [$$78(ASC)] |PARTITIONED| -- ONE_TO_ONE_EXCHANGE |PARTITIONED| -- STREAM_PROJECT |PARTITIONED| -- ONE_TO_ONE_EXCHANGE |PARTITIONED| - -- BTREE_SEARCH (Test.Users.firstUsersNameIdx) |PARTITIONED| + -- BTREE_SEARCH (test.Users.firstUsersNameIdx) |PARTITIONED| -- ONE_TO_ONE_EXCHANGE |PARTITIONED| -- ASSIGN |PARTITIONED| -- EMPTY_TUPLE_SOURCE |PARTITIONED| @@ -27,13 +27,13 @@ -- ASSIGN |PARTITIONED| -- STREAM_PROJECT |PARTITIONED| -- ONE_TO_ONE_EXCHANGE |PARTITIONED| - -- BTREE_SEARCH (Test.Users.Users) |PARTITIONED| + -- BTREE_SEARCH (test.Users.Users) |PARTITIONED| -- ONE_TO_ONE_EXCHANGE |PARTITIONED| -- STABLE_SORT [$$82(ASC)] |PARTITIONED| -- ONE_TO_ONE_EXCHANGE |PARTITIONED| -- STREAM_PROJECT |PARTITIONED| -- ONE_TO_ONE_EXCHANGE |PARTITIONED| - -- BTREE_SEARCH (Test.Users.lastUsersNameIdx) |PARTITIONED| + -- BTREE_SEARCH (test.Users.lastUsersNameIdx) |PARTITIONED| -- ONE_TO_ONE_EXCHANGE |PARTITIONED| -- ASSIGN |PARTITIONED| -- EMPTY_TUPLE_SOURCE |PARTITIONED| diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/results/index-through-object/index-through-object.2.plan b/asterixdb/asterix-app/src/test/resources/optimizerts/results/index-through-object/index-through-object.2.plan index 90816ce15a..04c6c36c3a 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/results/index-through-object/index-through-object.2.plan +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/results/index-through-object/index-through-object.2.plan @@ -6,13 +6,13 @@ -- ASSIGN |PARTITIONED| -- STREAM_PROJECT |PARTITIONED| -- ONE_TO_ONE_EXCHANGE |PARTITIONED| - -- BTREE_SEARCH (Test.Users.Users) |PARTITIONED| + -- BTREE_SEARCH (test.Users.Users) |PARTITIONED| -- ONE_TO_ONE_EXCHANGE |PARTITIONED| -- STABLE_SORT [$$48(ASC)] |PARTITIONED| -- ONE_TO_ONE_EXCHANGE |PARTITIONED| -- STREAM_PROJECT |PARTITIONED| -- ONE_TO_ONE_EXCHANGE |PARTITIONED| - -- BTREE_SEARCH (Test.Users.usersNameIdx) |PARTITIONED| + -- BTREE_SEARCH (test.Users.usersNameIdx) |PARTITIONED| -- ONE_TO_ONE_EXCHANGE |PARTITIONED| -- ASSIGN |PARTITIONED| -- EMPTY_TUPLE_SOURCE |PARTITIONED| diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/results/index-through-object/index-through-object.3.plan b/asterixdb/asterix-app/src/test/resources/optimizerts/results/index-through-object/index-through-object.3.plan index 693056009b..d42d3e6e12 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/results/index-through-object/index-through-object.3.plan +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/results/index-through-object/index-through-object.3.plan @@ -6,13 +6,13 @@ -- ASSIGN |PARTITIONED| -- STREAM_PROJECT |PARTITIONED| -- ONE_TO_ONE_EXCHANGE |PARTITIONED| - -- BTREE_SEARCH (Test.Users.Users) |PARTITIONED| + -- BTREE_SEARCH (test.Users.Users) |PARTITIONED| -- ONE_TO_ONE_EXCHANGE |PARTITIONED| -- STABLE_SORT [$$38(ASC)] |PARTITIONED| -- ONE_TO_ONE_EXCHANGE |PARTITIONED| -- STREAM_PROJECT |PARTITIONED| -- ONE_TO_ONE_EXCHANGE |PARTITIONED| - -- BTREE_SEARCH (Test.Users.usersNameIdx) |PARTITIONED| + -- BTREE_SEARCH (test.Users.usersNameIdx) |PARTITIONED| -- ONE_TO_ONE_EXCHANGE |PARTITIONED| -- ASSIGN |PARTITIONED| -- EMPTY_TUPLE_SOURCE |PARTITIONED| diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/results/index-through-object/index-through-object.4.plan b/asterixdb/asterix-app/src/test/resources/optimizerts/results/index-through-object/index-through-object.4.plan index ff509f4d83..d4d3426ec2 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/results/index-through-object/index-through-object.4.plan +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/results/index-through-object/index-through-object.4.plan @@ -6,13 +6,13 @@ -- ASSIGN |PARTITIONED| -- STREAM_PROJECT |PARTITIONED| -- ONE_TO_ONE_EXCHANGE |PARTITIONED| - -- BTREE_SEARCH (Test.Users.Users) |PARTITIONED| + -- BTREE_SEARCH (test.Users.Users) |PARTITIONED| -- ONE_TO_ONE_EXCHANGE |PARTITIONED| -- STABLE_SORT [$$36(ASC)] |PARTITIONED| -- ONE_TO_ONE_EXCHANGE |PARTITIONED| -- STREAM_PROJECT |PARTITIONED| -- ONE_TO_ONE_EXCHANGE |PARTITIONED| - -- BTREE_SEARCH (Test.Users.usersNameIdx) |PARTITIONED| + -- BTREE_SEARCH (test.Users.usersNameIdx) |PARTITIONED| -- ONE_TO_ONE_EXCHANGE |PARTITIONED| -- ASSIGN |PARTITIONED| -- EMPTY_TUPLE_SOURCE |PARTITIONED| diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/results/index-through-object/index-through-object.5.plan b/asterixdb/asterix-app/src/test/resources/optimizerts/results/index-through-object/index-through-object.5.plan index f0f6a0394c..43ec9ad858 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/results/index-through-object/index-through-object.5.plan +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/results/index-through-object/index-through-object.5.plan @@ -6,6 +6,6 @@ -- ASSIGN |PARTITIONED| -- STREAM_PROJECT |PARTITIONED| -- ONE_TO_ONE_EXCHANGE |PARTITIONED| - -- DATASOURCE_SCAN (Test.Users) |PARTITIONED| + -- DATASOURCE_SCAN (test.Users) |PARTITIONED| -- ONE_TO_ONE_EXCHANGE |PARTITIONED| -- EMPTY_TUPLE_SOURCE |PARTITIONED| diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/results/index-through-object/index-through-object.6.plan b/asterixdb/asterix-app/src/test/resources/optimizerts/results/index-through-object/index-through-object.6.plan index b4aee6baab..9653198625 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/results/index-through-object/index-through-object.6.plan +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/results/index-through-object/index-through-object.6.plan @@ -6,7 +6,7 @@ -- ASSIGN |PARTITIONED| -- STREAM_PROJECT |PARTITIONED| -- ONE_TO_ONE_EXCHANGE |PARTITIONED| - -- BTREE_SEARCH (Test.Users.Users) |PARTITIONED| + -- BTREE_SEARCH (test.Users.Users) |PARTITIONED| -- ONE_TO_ONE_EXCHANGE |PARTITIONED| -- STABLE_SORT [$$58(ASC)] |PARTITIONED| -- HASH_PARTITION_EXCHANGE [$$58] |PARTITIONED| @@ -15,6 +15,6 @@ -- ASSIGN |PARTITIONED| -- STREAM_PROJECT |PARTITIONED| -- ONE_TO_ONE_EXCHANGE |PARTITIONED| - -- DATASOURCE_SCAN (Test.Users) |PARTITIONED| + -- DATASOURCE_SCAN (test.Users) |PARTITIONED| -- ONE_TO_ONE_EXCHANGE |PARTITIONED| -- EMPTY_TUPLE_SOURCE |PARTITIONED| diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/results/index-through-object/index-through-object.7.plan b/asterixdb/asterix-app/src/test/resources/optimizerts/results/index-through-object/index-through-object.7.plan index f0f6a0394c..43ec9ad858 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/results/index-through-object/index-through-object.7.plan +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/results/index-through-object/index-through-object.7.plan @@ -6,6 +6,6 @@ -- ASSIGN |PARTITIONED| -- STREAM_PROJECT |PARTITIONED| -- ONE_TO_ONE_EXCHANGE |PARTITIONED| - -- DATASOURCE_SCAN (Test.Users) |PARTITIONED| + -- DATASOURCE_SCAN (test.Users) |PARTITIONED| -- ONE_TO_ONE_EXCHANGE |PARTITIONED| -- EMPTY_TUPLE_SOURCE |PARTITIONED| diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/results/index-through-object/index-through-object.8.plan b/asterixdb/asterix-app/src/test/resources/optimizerts/results/index-through-object/index-through-object.8.plan index 693056009b..d42d3e6e12 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/results/index-through-object/index-through-object.8.plan +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/results/index-through-object/index-through-object.8.plan @@ -6,13 +6,13 @@ -- ASSIGN |PARTITIONED| -- STREAM_PROJECT |PARTITIONED| -- ONE_TO_ONE_EXCHANGE |PARTITIONED| - -- BTREE_SEARCH (Test.Users.Users) |PARTITIONED| + -- BTREE_SEARCH (test.Users.Users) |PARTITIONED| -- ONE_TO_ONE_EXCHANGE |PARTITIONED| -- STABLE_SORT [$$38(ASC)] |PARTITIONED| -- ONE_TO_ONE_EXCHANGE |PARTITIONED| -- STREAM_PROJECT |PARTITIONED| -- ONE_TO_ONE_EXCHANGE |PARTITIONED| - -- BTREE_SEARCH (Test.Users.usersNameIdx) |PARTITIONED| + -- BTREE_SEARCH (test.Users.usersNameIdx) |PARTITIONED| -- ONE_TO_ONE_EXCHANGE |PARTITIONED| -- ASSIGN |PARTITIONED| -- EMPTY_TUPLE_SOURCE |PARTITIONED| diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/results/index-through-object/index-through-object.9.plan b/asterixdb/asterix-app/src/test/resources/optimizerts/results/index-through-object/index-through-object.9.plan index 1d2e55b9cb..55ff0c523c 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/results/index-through-object/index-through-object.9.plan +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/results/index-through-object/index-through-object.9.plan @@ -14,13 +14,13 @@ -- ASSIGN |PARTITIONED| -- STREAM_PROJECT |PARTITIONED| -- ONE_TO_ONE_EXCHANGE |PARTITIONED| - -- BTREE_SEARCH (Test.Users.Users) |PARTITIONED| + -- BTREE_SEARCH (test.Users.Users) |PARTITIONED| -- ONE_TO_ONE_EXCHANGE |PARTITIONED| -- STABLE_SORT [$$106(ASC)] |PARTITIONED| -- ONE_TO_ONE_EXCHANGE |PARTITIONED| -- STREAM_PROJECT |PARTITIONED| -- ONE_TO_ONE_EXCHANGE |PARTITIONED| - -- BTREE_SEARCH (Test.Users.usersNameIdx) |PARTITIONED| + -- BTREE_SEARCH (test.Users.usersNameIdx) |PARTITIONED| -- ONE_TO_ONE_EXCHANGE |PARTITIONED| -- ASSIGN |PARTITIONED| -- EMPTY_TUPLE_SOURCE |PARTITIONED| @@ -30,13 +30,13 @@ -- ASSIGN |PARTITIONED| -- STREAM_PROJECT |PARTITIONED| -- ONE_TO_ONE_EXCHANGE |PARTITIONED| - -- BTREE_SEARCH (Test.Users.Users) |PARTITIONED| + -- BTREE_SEARCH (test.Users.Users) |PARTITIONED| -- ONE_TO_ONE_EXCHANGE |PARTITIONED| -- STABLE_SORT [$$110(ASC)] |PARTITIONED| -- ONE_TO_ONE_EXCHANGE |PARTITIONED| -- STREAM_PROJECT |PARTITIONED| -- ONE_TO_ONE_EXCHANGE |PARTITIONED| - -- BTREE_SEARCH (Test.Users.usersNameIdx) |PARTITIONED| + -- BTREE_SEARCH (test.Users.usersNameIdx) |PARTITIONED| -- ONE_TO_ONE_EXCHANGE |PARTITIONED| -- ASSIGN |PARTITIONED| -- EMPTY_TUPLE_SOURCE |PARTITIONED| diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/results_cbo/index-through-object/index-through-object.1.plan b/asterixdb/asterix-app/src/test/resources/optimizerts/results_cbo/index-through-object/index-through-object.1.plan index f0f6a0394c..43ec9ad858 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/results_cbo/index-through-object/index-through-object.1.plan +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/results_cbo/index-through-object/index-through-object.1.plan @@ -6,6 +6,6 @@ -- ASSIGN |PARTITIONED| -- STREAM_PROJECT |PARTITIONED| -- ONE_TO_ONE_EXCHANGE |PARTITIONED| - -- DATASOURCE_SCAN (Test.Users) |PARTITIONED| + -- DATASOURCE_SCAN (test.Users) |PARTITIONED| -- ONE_TO_ONE_EXCHANGE |PARTITIONED| -- EMPTY_TUPLE_SOURCE |PARTITIONED| diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/results_cbo/index-through-object/index-through-object.2.plan b/asterixdb/asterix-app/src/test/resources/optimizerts/results_cbo/index-through-object/index-through-object.2.plan index f0f6a0394c..43ec9ad858 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/results_cbo/index-through-object/index-through-object.2.plan +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/results_cbo/index-through-object/index-through-object.2.plan @@ -6,6 +6,6 @@ -- ASSIGN |PARTITIONED| -- STREAM_PROJECT |PARTITIONED| -- ONE_TO_ONE_EXCHANGE |PARTITIONED| - -- DATASOURCE_SCAN (Test.Users) |PARTITIONED| + -- DATASOURCE_SCAN (test.Users) |PARTITIONED| -- ONE_TO_ONE_EXCHANGE |PARTITIONED| -- EMPTY_TUPLE_SOURCE |PARTITIONED| diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/results_cbo/index-through-object/index-through-object.3.plan b/asterixdb/asterix-app/src/test/resources/optimizerts/results_cbo/index-through-object/index-through-object.3.plan index f0f6a0394c..43ec9ad858 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/results_cbo/index-through-object/index-through-object.3.plan +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/results_cbo/index-through-object/index-through-object.3.plan @@ -6,6 +6,6 @@ -- ASSIGN |PARTITIONED| -- STREAM_PROJECT |PARTITIONED| -- ONE_TO_ONE_EXCHANGE |PARTITIONED| - -- DATASOURCE_SCAN (Test.Users) |PARTITIONED| + -- DATASOURCE_SCAN (test.Users) |PARTITIONED| -- ONE_TO_ONE_EXCHANGE |PARTITIONED| -- EMPTY_TUPLE_SOURCE |PARTITIONED| diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/results_cbo/index-through-object/index-through-object.4.plan b/asterixdb/asterix-app/src/test/resources/optimizerts/results_cbo/index-through-object/index-through-object.4.plan index f0f6a0394c..43ec9ad858 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/results_cbo/index-through-object/index-through-object.4.plan +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/results_cbo/index-through-object/index-through-object.4.plan @@ -6,6 +6,6 @@ -- ASSIGN |PARTITIONED| -- STREAM_PROJECT |PARTITIONED| -- ONE_TO_ONE_EXCHANGE |PARTITIONED| - -- DATASOURCE_SCAN (Test.Users) |PARTITIONED| + -- DATASOURCE_SCAN (test.Users) |PARTITIONED| -- ONE_TO_ONE_EXCHANGE |PARTITIONED| -- EMPTY_TUPLE_SOURCE |PARTITIONED| diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/results_cbo/index-through-object/index-through-object.8.plan b/asterixdb/asterix-app/src/test/resources/optimizerts/results_cbo/index-through-object/index-through-object.8.plan index f0f6a0394c..43ec9ad858 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/results_cbo/index-through-object/index-through-object.8.plan +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/results_cbo/index-through-object/index-through-object.8.plan @@ -6,6 +6,6 @@ -- ASSIGN |PARTITIONED| -- STREAM_PROJECT |PARTITIONED| -- ONE_TO_ONE_EXCHANGE |PARTITIONED| - -- DATASOURCE_SCAN (Test.Users) |PARTITIONED| + -- DATASOURCE_SCAN (test.Users) |PARTITIONED| -- ONE_TO_ONE_EXCHANGE |PARTITIONED| -- EMPTY_TUPLE_SOURCE |PARTITIONED| diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/results_cbo/index-through-object/index-through-object.9.plan b/asterixdb/asterix-app/src/test/resources/optimizerts/results_cbo/index-through-object/index-through-object.9.plan index 75a50b4f76..1f3c5b41d2 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/results_cbo/index-through-object/index-through-object.9.plan +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/results_cbo/index-through-object/index-through-object.9.plan @@ -19,7 +19,7 @@ -- ONE_TO_ONE_EXCHANGE |PARTITIONED| -- STREAM_PROJECT |PARTITIONED| -- ONE_TO_ONE_EXCHANGE |PARTITIONED| - -- DATASOURCE_SCAN (Test.Users) |PARTITIONED| + -- DATASOURCE_SCAN (test.Users) |PARTITIONED| -- ONE_TO_ONE_EXCHANGE |PARTITIONED| -- EMPTY_TUPLE_SOURCE |PARTITIONED| -- HASH_PARTITION_EXCHANGE [$$89] |PARTITIONED| @@ -31,7 +31,7 @@ -- ONE_TO_ONE_EXCHANGE |PARTITIONED| -- STREAM_PROJECT |PARTITIONED| -- ONE_TO_ONE_EXCHANGE |PARTITIONED| - -- DATASOURCE_SCAN (Test.Users) |PARTITIONED| + -- DATASOURCE_SCAN (test.Users) |PARTITIONED| -- ONE_TO_ONE_EXCHANGE |PARTITIONED| -- EMPTY_TUPLE_SOURCE |PARTITIONED| -- BROADCAST_EXCHANGE |PARTITIONED|
