[M] Change in asterixdb[master]: [ASTERIXDB-3902][TEST] Fix golden plans of vtree-index-only-join

2026-10-01 Thread AsterixDB Code Review
>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

2026-10-01 Thread AsterixDB Code Review
>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

2026-10-01 Thread AsterixDB Code Review
>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

2026-10-01 Thread AsterixDB Code Review
>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

2026-10-01 Thread AsterixDB Code Review
>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

2026-10-01 Thread AsterixDB Code Review
>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

2026-10-01 Thread AsterixDB Code Review
>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

2026-10-01 Thread AsterixDB Code Review
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

2026-10-01 Thread AsterixDB Code Review
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

2026-10-01 Thread AsterixDB Code Review
>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] <-