[M] Change in asterixdb[master]: [ASTERIXDB-3577][TEST] Correct single-collection plans in NCServiceIT

2026-10-02 Thread AsterixDB Code Review
>From Ian Maxon :

Attention is currently required from: Ian Maxon.

Ian Maxon has removed a vote from this change. ( 
https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/21983?usp=email )


Change subject: [ASTERIXDB-3577][TEST] Correct single-collection plans in 
NCServiceIT
..


Removed Verified-1 by Jenkins 
--
To view, visit https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/21983?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: I708ec383df2bd490c297d29b1b23a0e28d5328c5
Gerrit-Change-Number: 21983
Gerrit-PatchSet: 1
Gerrit-Owner: Ian Maxon 
Gerrit-Reviewer: Anon. E. Moose #1000171
Gerrit-Reviewer: Jenkins 
Gerrit-Attention: Ian Maxon 


[M] Change in asterixdb[master]: [ASTERIXDB-3577][TEST] Correct single-collection plans in NCServiceIT

2026-10-02 Thread AsterixDB Code Review
>From Ian Maxon :

Ian Maxon has submitted this change. ( 
https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/21983?usp=email )

Change subject: [ASTERIXDB-3577][TEST] Correct single-collection plans in 
NCServiceIT
..

[ASTERIXDB-3577][TEST] Correct single-collection plans in NCServiceIT

Details:
 - Add the delta file folder for SqlppExcutionNCServiceIT, and the
   changed plans for the single-collection-queries in it

Generated-by: Claude Opus 5.5
Change-Id: I708ec383df2bd490c297d29b1b23a0e28d5328c5
Reviewed-on: https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/21983
Tested-by: Ian Maxon 
Reviewed-by: Ian Maxon 
Integration-Tests: Jenkins 
---
M asterixdb/asterix-app/pom.xml
A 
asterixdb/asterix-app/src/test/resources/runtimets/results_ncservice/cardinality-estimation/single-collection-queries/single-collection-queries.10.plan
A 
asterixdb/asterix-app/src/test/resources/runtimets/results_ncservice/cardinality-estimation/single-collection-queries/single-collection-queries.11.plan
A 
asterixdb/asterix-app/src/test/resources/runtimets/results_ncservice/cardinality-estimation/single-collection-queries/single-collection-queries.12.plan
A 
asterixdb/asterix-app/src/test/resources/runtimets/results_ncservice/cardinality-estimation/single-collection-queries/single-collection-queries.13.plan
A 
asterixdb/asterix-app/src/test/resources/runtimets/results_ncservice/cardinality-estimation/single-collection-queries/single-collection-queries.14.plan
A 
asterixdb/asterix-app/src/test/resources/runtimets/results_ncservice/cardinality-estimation/single-collection-queries/single-collection-queries.15.plan
A 
asterixdb/asterix-app/src/test/resources/runtimets/results_ncservice/cardinality-estimation/single-collection-queries/single-collection-queries.17.plan
A 
asterixdb/asterix-app/src/test/resources/runtimets/results_ncservice/cardinality-estimation/single-collection-queries/single-collection-queries.9.plan
M 
asterixdb/asterix-server/src/test/java/org/apache/asterix/test/server/AbstractExecutionIT.java
10 files changed, 154 insertions(+), 1 deletion(-)

Approvals:
  Ian Maxon: Looks good to me, approved; Verified
  Jenkins: Verified

Objections:
  Anon. E. Moose #1000171: Violations found




diff --git a/asterixdb/asterix-app/pom.xml b/asterixdb/asterix-app/pom.xml
index 6713eac..d4a18dd 100644
--- a/asterixdb/asterix-app/pom.xml
+++ b/asterixdb/asterix-app/pom.xml
@@ -421,6 +421,7 @@
 src/test/resources/**/results_cbo/**
 src/test/resources/**/results_column/**
 src/test/resources/**/results_cloud/**
+src/test/resources/**/results_ncservice/**
 
src/test/resources/**/results_less_parallelism/**
 
src/test/resources/**/results_full_parallelism/**
 
src/test/resources/fuzzyjoin/pub/fuzzy-join-aql*.dot
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/results_ncservice/cardinality-estimation/single-collection-queries/single-collection-queries.10.plan
 
b/asterixdb/asterix-app/src/test/resources/runtimets/results_ncservice/cardinality-estimation/single-collection-queries/single-collection-queries.10.plan
new file mode 100644
index 000..01e8742
--- /dev/null
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/results_ncservice/cardinality-estimation/single-collection-queries/single-collection-queries.10.plan
@@ -0,0 +1,18 @@
+distribute result [$$19] [cardinality: 1497.18, doc-size: 12.0, op-cost: 0.0, 
total-cost: 749.77]
+-- DISTRIBUTE_RESULT  |PARTITIONED|
+  exchange [cardinality: 1497.18, doc-size: 12.0, op-cost: 0.0, total-cost: 
749.77]
+  -- ONE_TO_ONE_EXCHANGE  |PARTITIONED|
+assign [$$19] <- [{"o_orderdate": $$o.getField(4)}] project: [$$19] 
[cardinality: 1497.18, doc-size: 12.0, op-cost: 0.0, total-cost: 749.77]
+-- ASSIGN  |PARTITIONED|
+  project ([$$o]) [cardinality: 1497.18, doc-size: 12.0, op-cost: 0.0, 
total-cost: 749.77]
+  -- STREAM_PROJECT  |PARTITIONED|
+exchange [cardinality: 1497.18, doc-size: 12.0, op-cost: 0.0, 
total-cost: 749.77]
+-- ONE_TO_ONE_EXCHANGE  |PARTITIONED|
+  unnest-map [$$20, $$o] <- index-search("Orders", 0, "Default", 
"tpch", "Orders", false, false, 1, $$23, 0, false, true, false) [cardinality: 
1497.18, doc-size: 12.0, op-cost: 0.0, total-cost: 749.77]
+  -- BTREE_SEARCH  |PARTITIONED|
+exchange [cardinality: 0.0, doc-size: 0.0, op-cost: 0.0, 
total-cost: 0.0]
+-- ONE_TO_ONE_EXCHANGE  |PARTITIONED|
+  assign [$$23] <- [5] [cardinality: 0.0, doc-size: 0.0, op-cost: 
0.0, total-cost: 0.0]
+  -- ASSIGN  |PARTITIONED|
+empty-tuple-source [cardinality: 0.0, doc-size: 0.0, op-cost: 
0.0, total-cost: 0.0]
+-- EMPTY_TUPLE_SOURCE  |PARTITIONED|
diff --git 

[M] Change in asterixdb[master]: [ASTERIXDB-3577][TEST] Correct single-collection plans in NCServiceIT

2026-10-02 Thread AsterixDB Code Review
>From Ian Maxon :

Ian Maxon has posted comments on this change by Ian Maxon. ( 
https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/21983?usp=email )

Change subject: [ASTERIXDB-3577][TEST] Correct single-collection plans in 
NCServiceIT
..


Patch Set 1: Code-Review+2


--
To view, visit https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/21983?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: I708ec383df2bd490c297d29b1b23a0e28d5328c5
Gerrit-Change-Number: 21983
Gerrit-PatchSet: 1
Gerrit-Owner: Ian Maxon 
Gerrit-Reviewer: Anon. E. Moose #1000171
Gerrit-Reviewer: Ian Maxon 
Gerrit-Reviewer: Jenkins 
Gerrit-Comment-Date: Sat, 03 Oct 2026 06:45:26 +
Gerrit-HasComments: No
Gerrit-Has-Labels: Yes


[M] Change in asterixdb[master]: [ASTERIXDB-3577][TEST] Correct single-collection plans in NCServiceIT

2026-10-02 Thread AsterixDB Code Review
>From Ian Maxon :

Ian Maxon has posted comments on this change by Ian Maxon. ( 
https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/21983?usp=email )

Change subject: [ASTERIXDB-3577][TEST] Correct single-collection plans in 
NCServiceIT
..


Patch Set 1: Verified+1

(1 comment)

Patchset:

PS1:
same iceberg 1.12 flake



--
To view, visit https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/21983?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: I708ec383df2bd490c297d29b1b23a0e28d5328c5
Gerrit-Change-Number: 21983
Gerrit-PatchSet: 1
Gerrit-Owner: Ian Maxon 
Gerrit-Reviewer: Anon. E. Moose #1000171
Gerrit-Reviewer: Ian Maxon 
Gerrit-Reviewer: Jenkins 
Gerrit-Comment-Date: Sat, 03 Oct 2026 06:44:17 +
Gerrit-HasComments: Yes
Gerrit-Has-Labels: Yes


[M] Change in asterixdb[master]: [ASTERIXDB-3577][TEST] Correct single-collection plans in NCServiceIT

2026-10-02 Thread AsterixDB Code Review
>From Jenkins :

Attention is currently required from: Ian Maxon.

Jenkins has posted comments on this change by Ian Maxon. ( 
https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/21983?usp=email )

Change subject: [ASTERIXDB-3577][TEST] Correct single-collection plans in 
NCServiceIT
..


Patch Set 1: Integration-Tests+1

Integration Tests Successful

https://asterix-jenkins.ics.uci.edu/job/asterix-gerrit-trigger/8084/ : SUCCESS


--
To view, visit https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/21983?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: I708ec383df2bd490c297d29b1b23a0e28d5328c5
Gerrit-Change-Number: 21983
Gerrit-PatchSet: 1
Gerrit-Owner: Ian Maxon 
Gerrit-Reviewer: Anon. E. Moose #1000171
Gerrit-Reviewer: Jenkins 
Gerrit-Attention: Ian Maxon 
Gerrit-Comment-Date: Sat, 03 Oct 2026 01:17:43 +
Gerrit-HasComments: No
Gerrit-Has-Labels: Yes


[M] Change in asterixdb[master]: [ASTERIXDB-3577][TEST] Correct single-collection plans in NCServiceIT

2026-10-02 Thread AsterixDB Code Review
Attention is currently required from: Ian Maxon.

Anon. E. Moose #1000171 has posted comments on this change by Ian Maxon. ( 
https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/21983?usp=email )

Change subject: [ASTERIXDB-3577][TEST] Correct single-collection plans in 
NCServiceIT
..


Patch Set 1: Contrib-2

Analytics Compatibility Tests Failed
https://cbjenkins.page.link/LgWgvux6btBcJoog7 : UNSTABLE


--
To view, visit https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/21983?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: I708ec383df2bd490c297d29b1b23a0e28d5328c5
Gerrit-Change-Number: 21983
Gerrit-PatchSet: 1
Gerrit-Owner: Ian Maxon 
Gerrit-Reviewer: Anon. E. Moose #1000171
Gerrit-CC: Jenkins 
Gerrit-Attention: Ian Maxon 
Gerrit-Comment-Date: Sat, 03 Oct 2026 00:41:49 +
Gerrit-HasComments: No
Gerrit-Has-Labels: Yes


[M] Change in asterixdb[master]: [ASTERIXDB-3577][TEST] Correct single-collection plans in NCServiceIT

2026-10-02 Thread AsterixDB Code Review
Anon. E. Moose #1000171 has posted comments on this change by Ian Maxon. ( 
https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/21983?usp=email )

Change subject: [ASTERIXDB-3577][TEST] Correct single-collection plans in 
NCServiceIT
..


Patch Set 1:

Analytics Compatibility Compilation Successful
https://cbjenkins.page.link/cqd3KnMVNbCNSDcBA : SUCCESS


--
To view, visit https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/21983?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: I708ec383df2bd490c297d29b1b23a0e28d5328c5
Gerrit-Change-Number: 21983
Gerrit-PatchSet: 1
Gerrit-Owner: Ian Maxon 
Gerrit-CC: Anon. E. Moose #1000171
Gerrit-Comment-Date: Fri, 02 Oct 2026 22:58:39 +
Gerrit-HasComments: No
Gerrit-Has-Labels: No


[M] Change in asterixdb[master]: [ASTERIXDB-3577][TEST] Correct single-collection plans in NCServiceIT

2026-10-02 Thread AsterixDB Code Review
>From Ian Maxon :

Ian Maxon has uploaded this change for review. ( 
https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/21983?usp=email )


Change subject: [ASTERIXDB-3577][TEST] Correct single-collection plans in 
NCServiceIT
..

[ASTERIXDB-3577][TEST] Correct single-collection plans in NCServiceIT

Details:
 - Add the delta file folder for SqlppExcutionNCServiceIT, and the
   changed plans for the single-collection-queries in it

Generated-by: Claude Opus 5.5
Change-Id: I708ec383df2bd490c297d29b1b23a0e28d5328c5
---
M asterixdb/asterix-app/pom.xml
A 
asterixdb/asterix-app/src/test/resources/runtimets/results_ncservice/cardinality-estimation/single-collection-queries/single-collection-queries.10.plan
A 
asterixdb/asterix-app/src/test/resources/runtimets/results_ncservice/cardinality-estimation/single-collection-queries/single-collection-queries.11.plan
A 
asterixdb/asterix-app/src/test/resources/runtimets/results_ncservice/cardinality-estimation/single-collection-queries/single-collection-queries.12.plan
A 
asterixdb/asterix-app/src/test/resources/runtimets/results_ncservice/cardinality-estimation/single-collection-queries/single-collection-queries.13.plan
A 
asterixdb/asterix-app/src/test/resources/runtimets/results_ncservice/cardinality-estimation/single-collection-queries/single-collection-queries.14.plan
A 
asterixdb/asterix-app/src/test/resources/runtimets/results_ncservice/cardinality-estimation/single-collection-queries/single-collection-queries.15.plan
A 
asterixdb/asterix-app/src/test/resources/runtimets/results_ncservice/cardinality-estimation/single-collection-queries/single-collection-queries.17.plan
A 
asterixdb/asterix-app/src/test/resources/runtimets/results_ncservice/cardinality-estimation/single-collection-queries/single-collection-queries.9.plan
M 
asterixdb/asterix-server/src/test/java/org/apache/asterix/test/server/AbstractExecutionIT.java
10 files changed, 154 insertions(+), 1 deletion(-)



  git pull ssh://asterix-gerrit.ics.uci.edu:29418/asterixdb 
refs/changes/83/21983/1

diff --git a/asterixdb/asterix-app/pom.xml b/asterixdb/asterix-app/pom.xml
index 6713eac..d4a18dd 100644
--- a/asterixdb/asterix-app/pom.xml
+++ b/asterixdb/asterix-app/pom.xml
@@ -421,6 +421,7 @@
 src/test/resources/**/results_cbo/**
 src/test/resources/**/results_column/**
 src/test/resources/**/results_cloud/**
+src/test/resources/**/results_ncservice/**
 
src/test/resources/**/results_less_parallelism/**
 
src/test/resources/**/results_full_parallelism/**
 
src/test/resources/fuzzyjoin/pub/fuzzy-join-aql*.dot
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/results_ncservice/cardinality-estimation/single-collection-queries/single-collection-queries.10.plan
 
b/asterixdb/asterix-app/src/test/resources/runtimets/results_ncservice/cardinality-estimation/single-collection-queries/single-collection-queries.10.plan
new file mode 100644
index 000..01e8742
--- /dev/null
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/results_ncservice/cardinality-estimation/single-collection-queries/single-collection-queries.10.plan
@@ -0,0 +1,18 @@
+distribute result [$$19] [cardinality: 1497.18, doc-size: 12.0, op-cost: 0.0, 
total-cost: 749.77]
+-- DISTRIBUTE_RESULT  |PARTITIONED|
+  exchange [cardinality: 1497.18, doc-size: 12.0, op-cost: 0.0, total-cost: 
749.77]
+  -- ONE_TO_ONE_EXCHANGE  |PARTITIONED|
+assign [$$19] <- [{"o_orderdate": $$o.getField(4)}] project: [$$19] 
[cardinality: 1497.18, doc-size: 12.0, op-cost: 0.0, total-cost: 749.77]
+-- ASSIGN  |PARTITIONED|
+  project ([$$o]) [cardinality: 1497.18, doc-size: 12.0, op-cost: 0.0, 
total-cost: 749.77]
+  -- STREAM_PROJECT  |PARTITIONED|
+exchange [cardinality: 1497.18, doc-size: 12.0, op-cost: 0.0, 
total-cost: 749.77]
+-- ONE_TO_ONE_EXCHANGE  |PARTITIONED|
+  unnest-map [$$20, $$o] <- index-search("Orders", 0, "Default", 
"tpch", "Orders", false, false, 1, $$23, 0, false, true, false) [cardinality: 
1497.18, doc-size: 12.0, op-cost: 0.0, total-cost: 749.77]
+  -- BTREE_SEARCH  |PARTITIONED|
+exchange [cardinality: 0.0, doc-size: 0.0, op-cost: 0.0, 
total-cost: 0.0]
+-- ONE_TO_ONE_EXCHANGE  |PARTITIONED|
+  assign [$$23] <- [5] [cardinality: 0.0, doc-size: 0.0, op-cost: 
0.0, total-cost: 0.0]
+  -- ASSIGN  |PARTITIONED|
+empty-tuple-source [cardinality: 0.0, doc-size: 0.0, op-cost: 
0.0, total-cost: 0.0]
+-- EMPTY_TUPLE_SOURCE  |PARTITIONED|
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/results_ncservice/cardinality-estimation/single-collection-queries/single-collection-queries.11.plan