[M] Change in asterixdb[master]: [ASTERIXDB-3577][TEST] Correct single-collection plans in NCServiceIT
>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
>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
>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
>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
>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
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
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
>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
