[M] Change in asterixdb[master]: [ASTERIXDB-3902][TEST] Fix golden plans of vtree-index-only-join
>From Ali Alsuliman :
Ali Alsuliman has submitted this change. (
https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/21958?usp=email )
Change subject: [ASTERIXDB-3902][TEST] Fix golden plans of vtree-index-only-join
..
[ASTERIXDB-3902][TEST] Fix golden plans of vtree-index-only-join
- user model changes: no
- storage format changes: no
- interface changes: no
Details:
Fix the golden plans so vtree-index-only-join passes in
SqlppAnalyzedExecutionTest.
Generated-by: Claude Opus 5.5
Change-Id: I6c59c966377f203abf92dc56adf4f3da70f6e430
Reviewed-on: https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/21958
Reviewed-by: Hongyu Shi
Tested-by: Ali Alsuliman
Reviewed-by: Ali Alsuliman
---
A
asterixdb/asterix-app/src/test/resources/runtimets/results_cbo/vector/vtree-index-only-join/vtree-index-only-join.05.plan
A
asterixdb/asterix-app/src/test/resources/runtimets/results_cbo/vector/vtree-index-only-join/vtree-index-only-join.07.plan
2 files changed, 120 insertions(+), 0 deletions(-)
Approvals:
Ali Alsuliman: Looks good to me, approved; Verified
Hongyu Shi: Looks good to me, but someone else must approve
diff --git
a/asterixdb/asterix-app/src/test/resources/runtimets/results_cbo/vector/vtree-index-only-join/vtree-index-only-join.05.plan
b/asterixdb/asterix-app/src/test/resources/runtimets/results_cbo/vector/vtree-index-only-join/vtree-index-only-join.05.plan
new file mode 100644
index 000..3ee38bd
--- /dev/null
+++
b/asterixdb/asterix-app/src/test/resources/runtimets/results_cbo/vector/vtree-index-only-join/vtree-index-only-join.05.plan
@@ -0,0 +1,54 @@
+distribute result [$$56]
+-- DISTRIBUTE_RESULT |PARTITIONED|
+ exchange
+ -- ONE_TO_ONE_EXCHANGE |PARTITIONED|
+assign [$$56] <- [{"label": $$67, "year": $$76}] project: [$$56]
+-- ASSIGN |PARTITIONED|
+ exchange
+ -- ONE_TO_ONE_EXCHANGE |PARTITIONED|
+order (ASC, $$76)
+-- STABLE_SORT [$$76(ASC)] |PARTITIONED|
+ exchange
+ -- RANGE_PARTITION_EXCHANGE [$$76(ASC)] RANGE_MAP:{SPLIT:3}
|PARTITIONED|
+project ([$$67, $$76])
+-- STREAM_PROJECT |PARTITIONED|
+ exchange
+ -- ONE_TO_ONE_EXCHANGE |PARTITIONED|
+join (eq($$74, $$60))
+-- HYBRID_HASH_JOIN [$$74][$$60] |PARTITIONED|
+ exchange
+ -- HASH_PARTITION_EXCHANGE [$$74] |PARTITIONED|
+limit 3
+-- STREAM_LIMIT |UNPARTITIONED|
+ project ([$$74, $$76])
+ -- STREAM_PROJECT |PARTITIONED|
+exchange
+-- SORT_MERGE_EXCHANGE [$$75(ASC) ] |PARTITIONED|
+ limit 3
+ -- STREAM_LIMIT |PARTITIONED|
+exchange
+-- ONE_TO_ONE_EXCHANGE |PARTITIONED|
+ order (topK: 3) (ASC, $$75)
+ -- STABLE_SORT [topK: 3] [$$75(ASC)]
|PARTITIONED|
+exchange
+-- ONE_TO_ONE_EXCHANGE |PARTITIONED|
+ unnest-map [$$74, $$75, $$76] <-
index-search("idx_emb", 8, "Default", "test", "Docs", false, false, true, 5,
$$69, $$70, $$71, $$72, $$73)
+ -- VECTOR_SEARCH |PARTITIONED|
+exchange
+-- ONE_TO_ONE_EXCHANGE |PARTITIONED|
+ assign [$$69, $$70, $$71, $$72, $$73] <-
[array: [ 0.0, 0.0, 0.0, 0.0 ], 3, "euclidean", 1.0, 1]
+ -- ASSIGN |PARTITIONED|
+empty-tuple-source
+-- EMPTY_TUPLE_SOURCE |PARTITIONED|
+ exchange
+ -- ONE_TO_ONE_EXCHANGE |PARTITIONED|
+assign [$$67] <- [$$l.getField(1)] project: [$$67, $$60]
+-- ASSIGN |PARTITIONED|
+ exchange
+ -- ONE_TO_ONE_EXCHANGE |PARTITIONED|
+data-scan []<-[$$60, $$l] <- test.Labels
+-- DATASOURCE_SCAN |PARTITIONED|
+ exchange
+ -- ONE_TO_ONE_EXCHANGE |PARTITIONED|
+empty-tuple-source
+-- EMPTY_TUPLE_SOURCE |PARTITIONED|
diff --git
a/asterixdb/asterix-app/src/test/resources/runtimets/results_cbo/vector/vtree-index-only-join/vtree-index-only-join.07.plan
b/asterixdb/asterix-app/src/test/resources/runtimets/results_cbo/vector/vtree-index-only-join/vtree-index-only-join.07.plan
new file mode 100644
index 000..6ac24d6
--- /dev/null
+++
[M] Change in asterixdb[master]: [ASTERIXDB-3902][TEST] Fix golden plans of vtree-index-only-join
>From Ali Alsuliman : Attention is currently required from: Ali Alsuliman, Hongyu Shi. Ali Alsuliman has removed a vote from this change. ( https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/21958?usp=email ) Change subject: [ASTERIXDB-3902][TEST] Fix golden plans of vtree-index-only-join .. Removed Integration-Tests-1 by Jenkins -- To view, visit https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/21958?usp=email To unsubscribe, or for help writing mail filters, visit https://asterix-gerrit.ics.uci.edu/settings?usp=email Gerrit-MessageType: deleteVote Gerrit-Project: asterixdb Gerrit-Branch: master Gerrit-Change-Id: I6c59c966377f203abf92dc56adf4f3da70f6e430 Gerrit-Change-Number: 21958 Gerrit-PatchSet: 1 Gerrit-Owner: Hongyu Shi Gerrit-Reviewer: Ali Alsuliman Gerrit-Reviewer: Anon. E. Moose #1000171 Gerrit-Reviewer: Hongyu Shi Gerrit-Reviewer: Jenkins Gerrit-Attention: Ali Alsuliman Gerrit-Attention: Hongyu Shi
[M] Change in asterixdb[master]: [ASTERIXDB-3902][TEST] Fix golden plans of vtree-index-only-join
>From Ali Alsuliman : Attention is currently required from: Hongyu Shi. Ali Alsuliman has posted comments on this change by Hongyu Shi. ( https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/21958?usp=email ) Change subject: [ASTERIXDB-3902][TEST] Fix golden plans of vtree-index-only-join .. Patch Set 1: Code-Review+2 Verified+1 -- To view, visit https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/21958?usp=email To unsubscribe, or for help writing mail filters, visit https://asterix-gerrit.ics.uci.edu/settings?usp=email Gerrit-MessageType: comment Gerrit-Project: asterixdb Gerrit-Branch: master Gerrit-Change-Id: I6c59c966377f203abf92dc56adf4f3da70f6e430 Gerrit-Change-Number: 21958 Gerrit-PatchSet: 1 Gerrit-Owner: Hongyu Shi Gerrit-Reviewer: Ali Alsuliman Gerrit-Reviewer: Anon. E. Moose #1000171 Gerrit-Reviewer: Hongyu Shi Gerrit-Reviewer: Jenkins Gerrit-Attention: Hongyu Shi Gerrit-Comment-Date: Thu, 01 Oct 2026 20:46:07 + Gerrit-HasComments: No Gerrit-Has-Labels: Yes
[M] Change in asterixdb[master]: [ASTERIXDB-3902][TEST] Fix golden plans of vtree-index-only-join
>From Ali Alsuliman : Attention is currently required from: Ali Alsuliman, Hongyu Shi. Ali Alsuliman has removed a vote from this change. ( https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/21958?usp=email ) Change subject: [ASTERIXDB-3902][TEST] Fix golden plans of vtree-index-only-join .. Removed Verified-1 by Jenkins -- To view, visit https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/21958?usp=email To unsubscribe, or for help writing mail filters, visit https://asterix-gerrit.ics.uci.edu/settings?usp=email Gerrit-MessageType: deleteVote Gerrit-Project: asterixdb Gerrit-Branch: master Gerrit-Change-Id: I6c59c966377f203abf92dc56adf4f3da70f6e430 Gerrit-Change-Number: 21958 Gerrit-PatchSet: 1 Gerrit-Owner: Hongyu Shi Gerrit-Reviewer: Ali Alsuliman Gerrit-Reviewer: Anon. E. Moose #1000171 Gerrit-Reviewer: Hongyu Shi Gerrit-Reviewer: Jenkins Gerrit-Attention: Ali Alsuliman Gerrit-Attention: Hongyu Shi
[M] Change in asterixdb[master]: [ASTERIXDB-3902][TEST] Fix golden plans of vtree-index-only-join
>From Jenkins : Attention is currently required from: Ali Alsuliman, Hongyu Shi. Jenkins has posted comments on this change by Hongyu Shi. ( https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/21958?usp=email ) Change subject: [ASTERIXDB-3902][TEST] Fix golden plans of vtree-index-only-join .. Patch Set 1: Integration-Tests-1 Integration Tests Failed https://asterix-jenkins.ics.uci.edu/job/asterix-gerrit-trigger/8020/ : UNSTABLE -- To view, visit https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/21958?usp=email To unsubscribe, or for help writing mail filters, visit https://asterix-gerrit.ics.uci.edu/settings?usp=email Gerrit-MessageType: comment Gerrit-Project: asterixdb Gerrit-Branch: master Gerrit-Change-Id: I6c59c966377f203abf92dc56adf4f3da70f6e430 Gerrit-Change-Number: 21958 Gerrit-PatchSet: 1 Gerrit-Owner: Hongyu Shi Gerrit-Reviewer: Ali Alsuliman Gerrit-Reviewer: Anon. E. Moose #1000171 Gerrit-Reviewer: Hongyu Shi Gerrit-Reviewer: Jenkins Gerrit-Attention: Ali Alsuliman Gerrit-Attention: Hongyu Shi Gerrit-Comment-Date: Thu, 01 Oct 2026 15:58:44 + Gerrit-HasComments: No Gerrit-Has-Labels: Yes
[M] Change in asterixdb[master]: [ASTERIXDB-3902][TEST] Fix golden plans of vtree-index-only-join
>From Michael Blow : Attention is currently required from: Ali Alsuliman. Michael Blow has removed a vote from this change. ( https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/21958?usp=email ) Change subject: [ASTERIXDB-3902][TEST] Fix golden plans of vtree-index-only-join .. Removed Verified-1 by Unrecognized Gerrit Account 1000171 (1000171) -- To view, visit https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/21958?usp=email To unsubscribe, or for help writing mail filters, visit https://asterix-gerrit.ics.uci.edu/settings?usp=email Gerrit-MessageType: deleteVote Gerrit-Project: asterixdb Gerrit-Branch: master Gerrit-Change-Id: I6c59c966377f203abf92dc56adf4f3da70f6e430 Gerrit-Change-Number: 21958 Gerrit-PatchSet: 1 Gerrit-Owner: Hongyu Shi Gerrit-Reviewer: Ali Alsuliman Gerrit-Reviewer: Anon. E. Moose #1000171 Gerrit-Reviewer: Hongyu Shi Gerrit-CC: Jenkins Gerrit-Attention: Ali Alsuliman
[M] Change in asterixdb[master]: [ASTERIXDB-3902][TEST] Fix golden plans of vtree-index-only-join
>From Hongyu Shi : Attention is currently required from: Ali Alsuliman. Hongyu Shi has posted comments on this change by Hongyu Shi. ( https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/21958?usp=email ) Change subject: [ASTERIXDB-3902][TEST] Fix golden plans of vtree-index-only-join .. Patch Set 1: Code-Review+1 -- To view, visit https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/21958?usp=email To unsubscribe, or for help writing mail filters, visit https://asterix-gerrit.ics.uci.edu/settings?usp=email Gerrit-MessageType: comment Gerrit-Project: asterixdb Gerrit-Branch: master Gerrit-Change-Id: I6c59c966377f203abf92dc56adf4f3da70f6e430 Gerrit-Change-Number: 21958 Gerrit-PatchSet: 1 Gerrit-Owner: Hongyu Shi Gerrit-Reviewer: Ali Alsuliman Gerrit-Reviewer: Anon. E. Moose #1000171 Gerrit-Reviewer: Hongyu Shi Gerrit-Attention: Ali Alsuliman Gerrit-Comment-Date: Thu, 01 Oct 2026 08:55:34 + Gerrit-HasComments: No Gerrit-Has-Labels: Yes
[M] Change in asterixdb[master]: [ASTERIXDB-3902][TEST] Fix golden plans of vtree-index-only-join
Attention is currently required from: Ali Alsuliman. Anon. E. Moose #1000171 has posted comments on this change by Hongyu Shi. ( https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/21958?usp=email ) Change subject: [ASTERIXDB-3902][TEST] Fix golden plans of vtree-index-only-join .. Patch Set 1: Analytics Compatibility Compilation Successful https://cbjenkins.page.link/G5oPdH1eKsino5gj6 : SUCCESS -- To view, visit https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/21958?usp=email To unsubscribe, or for help writing mail filters, visit https://asterix-gerrit.ics.uci.edu/settings?usp=email Gerrit-MessageType: comment Gerrit-Project: asterixdb Gerrit-Branch: master Gerrit-Change-Id: I6c59c966377f203abf92dc56adf4f3da70f6e430 Gerrit-Change-Number: 21958 Gerrit-PatchSet: 1 Gerrit-Owner: Hongyu Shi Gerrit-Reviewer: Ali Alsuliman Gerrit-Reviewer: Anon. E. Moose #1000171 Gerrit-Reviewer: Hongyu Shi Gerrit-Attention: Ali Alsuliman Gerrit-Comment-Date: Thu, 01 Oct 2026 09:01:30 + Gerrit-HasComments: No Gerrit-Has-Labels: No
[M] Change in asterixdb[master]: [ASTERIXDB-3902][TEST] Fix golden plans of vtree-index-only-join
Attention is currently required from: Hongyu Shi. Anon. E. Moose #1000171 has posted comments on this change by Hongyu Shi. ( https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/21958?usp=email ) Change subject: [ASTERIXDB-3902][TEST] Fix golden plans of vtree-index-only-join .. Patch Set 1: Verified-1 https://server.jenkins.couchbase.com/job/asterixdb-restricted-branch-check/7327/artifact/restriction/restricted.html : BRANCH RESTRICTED (Please check URL for more information) -- To view, visit https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/21958?usp=email To unsubscribe, or for help writing mail filters, visit https://asterix-gerrit.ics.uci.edu/settings?usp=email Gerrit-MessageType: comment Gerrit-Project: asterixdb Gerrit-Branch: master Gerrit-Change-Id: I6c59c966377f203abf92dc56adf4f3da70f6e430 Gerrit-Change-Number: 21958 Gerrit-PatchSet: 1 Gerrit-Owner: Hongyu Shi Gerrit-Reviewer: Anon. E. Moose #1000171 Gerrit-Attention: Hongyu Shi Gerrit-Comment-Date: Thu, 01 Oct 2026 08:53:49 + Gerrit-HasComments: No Gerrit-Has-Labels: Yes
[M] Change in asterixdb[master]: [ASTERIXDB-3902][TEST] Fix golden plans of vtree-index-only-join
>From Hongyu Shi :
Hongyu Shi has uploaded this change for review. (
https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/21958?usp=email )
Change subject: [ASTERIXDB-3902][TEST] Fix golden plans of vtree-index-only-join
..
[ASTERIXDB-3902][TEST] Fix golden plans of vtree-index-only-join
- user model changes: no
- storage format changes: no
- interface changes: no
Details:
Fix the golden plans so vtree-index-only-join passes in
SqlppAnalyzedExecutionTest.
Generated-by: Claude Opus 5.5
Change-Id: I6c59c966377f203abf92dc56adf4f3da70f6e430
---
A
asterixdb/asterix-app/src/test/resources/runtimets/results_cbo/vector/vtree-index-only-join/vtree-index-only-join.05.plan
A
asterixdb/asterix-app/src/test/resources/runtimets/results_cbo/vector/vtree-index-only-join/vtree-index-only-join.07.plan
2 files changed, 120 insertions(+), 0 deletions(-)
git pull ssh://asterix-gerrit.ics.uci.edu:29418/asterixdb
refs/changes/58/21958/1
diff --git
a/asterixdb/asterix-app/src/test/resources/runtimets/results_cbo/vector/vtree-index-only-join/vtree-index-only-join.05.plan
b/asterixdb/asterix-app/src/test/resources/runtimets/results_cbo/vector/vtree-index-only-join/vtree-index-only-join.05.plan
new file mode 100644
index 000..3ee38bd
--- /dev/null
+++
b/asterixdb/asterix-app/src/test/resources/runtimets/results_cbo/vector/vtree-index-only-join/vtree-index-only-join.05.plan
@@ -0,0 +1,54 @@
+distribute result [$$56]
+-- DISTRIBUTE_RESULT |PARTITIONED|
+ exchange
+ -- ONE_TO_ONE_EXCHANGE |PARTITIONED|
+assign [$$56] <- [{"label": $$67, "year": $$76}] project: [$$56]
+-- ASSIGN |PARTITIONED|
+ exchange
+ -- ONE_TO_ONE_EXCHANGE |PARTITIONED|
+order (ASC, $$76)
+-- STABLE_SORT [$$76(ASC)] |PARTITIONED|
+ exchange
+ -- RANGE_PARTITION_EXCHANGE [$$76(ASC)] RANGE_MAP:{SPLIT:3}
|PARTITIONED|
+project ([$$67, $$76])
+-- STREAM_PROJECT |PARTITIONED|
+ exchange
+ -- ONE_TO_ONE_EXCHANGE |PARTITIONED|
+join (eq($$74, $$60))
+-- HYBRID_HASH_JOIN [$$74][$$60] |PARTITIONED|
+ exchange
+ -- HASH_PARTITION_EXCHANGE [$$74] |PARTITIONED|
+limit 3
+-- STREAM_LIMIT |UNPARTITIONED|
+ project ([$$74, $$76])
+ -- STREAM_PROJECT |PARTITIONED|
+exchange
+-- SORT_MERGE_EXCHANGE [$$75(ASC) ] |PARTITIONED|
+ limit 3
+ -- STREAM_LIMIT |PARTITIONED|
+exchange
+-- ONE_TO_ONE_EXCHANGE |PARTITIONED|
+ order (topK: 3) (ASC, $$75)
+ -- STABLE_SORT [topK: 3] [$$75(ASC)]
|PARTITIONED|
+exchange
+-- ONE_TO_ONE_EXCHANGE |PARTITIONED|
+ unnest-map [$$74, $$75, $$76] <-
index-search("idx_emb", 8, "Default", "test", "Docs", false, false, true, 5,
$$69, $$70, $$71, $$72, $$73)
+ -- VECTOR_SEARCH |PARTITIONED|
+exchange
+-- ONE_TO_ONE_EXCHANGE |PARTITIONED|
+ assign [$$69, $$70, $$71, $$72, $$73] <-
[array: [ 0.0, 0.0, 0.0, 0.0 ], 3, "euclidean", 1.0, 1]
+ -- ASSIGN |PARTITIONED|
+empty-tuple-source
+-- EMPTY_TUPLE_SOURCE |PARTITIONED|
+ exchange
+ -- ONE_TO_ONE_EXCHANGE |PARTITIONED|
+assign [$$67] <- [$$l.getField(1)] project: [$$67, $$60]
+-- ASSIGN |PARTITIONED|
+ exchange
+ -- ONE_TO_ONE_EXCHANGE |PARTITIONED|
+data-scan []<-[$$60, $$l] <- test.Labels
+-- DATASOURCE_SCAN |PARTITIONED|
+ exchange
+ -- ONE_TO_ONE_EXCHANGE |PARTITIONED|
+empty-tuple-source
+-- EMPTY_TUPLE_SOURCE |PARTITIONED|
diff --git
a/asterixdb/asterix-app/src/test/resources/runtimets/results_cbo/vector/vtree-index-only-join/vtree-index-only-join.07.plan
b/asterixdb/asterix-app/src/test/resources/runtimets/results_cbo/vector/vtree-index-only-join/vtree-index-only-join.07.plan
new file mode 100644
index 000..6ac24d6
--- /dev/null
+++
b/asterixdb/asterix-app/src/test/resources/runtimets/results_cbo/vector/vtree-index-only-join/vtree-index-only-join.07.plan
@@ -0,0 +1,66 @@
+distribute result [$$58]
+-- DISTRIBUTE_RESULT |PARTITIONED|
+ exchange
+ -- ONE_TO_ONE_EXCHANGE |PARTITIONED|
+assign [$$58] <-
