tuhaihe commented on PR #1760:
URL: https://github.com/apache/cloudberry/pull/1760#issuecomment-4543259793
Some tests failed running `make installcheck` under the gpdemo env in Rocky
Linux 8 + 9, FYI:
- OS: Rocky 8 + 9
- Gpdemo
- cmd: `make installcheck`
```
[gpadmin@cdw cloudberry]$ cat src/test/regress/regression.diffs
diff -I HINT: -I CONTEXT: -I GP_IGNORE: -U3
/home/gpadmin/cloudberry/src/test/regress/expected/cte_prune_optimizer.out
/home/gpadmin/cloudberry/src/test/regress/results/cte_prune.out
---
/home/gpadmin/cloudberry/src/test/regress/expected/cte_prune_optimizer.out
2026-05-26 02:23:30.040989482 -0700
+++ /home/gpadmin/cloudberry/src/test/regress/results/cte_prune.out
2026-05-26 02:23:30.124990517 -0700
@@ -2259,7 +2259,7 @@
-> Sequence (cost=0.00..2161.00 rows=1 width=4)
Output: t1.v1
Gather Motion 3:1 (slice1; segments: 3) (cost=0.00..2161.00 rows=1
width=4)
-(55 rows)
+(54 rows)
-- sql 95
explain verbose with ws_wh as
@@ -2312,7 +2312,7 @@
-> Sequence (cost=0.00..1730.00 rows=1 width=12)
Output: t1.v1, t1.v2, t1.v3
Gather Motion 3:1 (slice1; segments: 3) (cost=0.00..1730.00 rows=1
width=12)
-(44 rows)
+(43 rows)
explain verbose with ws_wh as
(select ws1.ws_order_number,ws1.ws_warehouse_sk wh1,ws2.ws_warehouse_sk wh2
@@ -2366,7 +2366,7 @@
-> Sequence (cost=0.00..1730.00 rows=1 width=12)
Output: t1.v1, t1.v2, t1.v3
Gather Motion 3:1 (slice1; segments: 3) (cost=0.00..1730.00 rows=1
width=12)
-(46 rows)
+(45 rows)
GP_IGNORE:-- start_ignore
GP_IGNORE:drop table tpcds_store_sales;
@@ -2488,7 +2488,7 @@
Merge Key: t4_1.c, t4_1.d, (avg(share0_ref3.b) OVER (?)),
(sum(share0_ref2.d) OVER (?))
Output: t4_1.c, t4_1.d, (avg(share0_ref3.b) OVER (?)),
(sum(share0_ref2.d) OVER (?))
Gather Motion 3:1 (slice1; segments: 3) (cost=0.00..1356697001.21
rows=10 width=24)
-(93 rows)
+(92 rows)
WITH t(a,b,d) AS
(
@@ -2783,7 +2783,7 @@
Merge Key: share0_ref2.name, share0_ref3.language
Output: share0_ref3.code, share0_ref3.name, share0_ref3.name_1,
share0_ref3.language, share0_ref3.isofficial, share0_ref3.percentage,
share0_ref2.code, share0_ref2.name, share0_ref2.language,
share0_ref2.isofficial, share0_ref2.percentage
Gather Motion 3:1 (slice1; segments: 3) (cost=0.00..1736.01 rows=1
width=66)
-(74 rows)
+(73 rows)
-- CTE in the main query and subqueries within the main query
explain verbose with bad_headofstates as
@@ -2882,7 +2882,7 @@
-> Shared Scan (share slice:id 0:0) (cost=0.00..437.00 rows=1 width=1)
Output: (avg(country_1.population)), country_1.region,
share0_ref2.headofstate
Sequence (cost=0.00..1748.00 rows=1 width=24)
-(77 rows)
+(76 rows)
GP_IGNORE:-- start_ignore
GP_IGNORE:drop table city;
diff -I HINT: -I CONTEXT: -I GP_IGNORE: -U3
/home/gpadmin/cloudberry/src/test/regress/expected/explain_optimizer.out
/home/gpadmin/cloudberry/src/test/regress/results/explain.out
--- /home/gpadmin/cloudberry/src/test/regress/expected/explain_optimizer.out
2026-05-26 02:23:45.974185626 -0700
+++ /home/gpadmin/cloudberry/src/test/regress/results/explain.out
2026-05-26 02:23:46.010186069 -0700
@@ -465,7 +466,6 @@
"Settings": { +
"jit": "off", +
"Optimizer": "GPORCA", +
- "optimizer": "on", +
"enable_parallel": "off", +
"parallel_setup_cost": "0", +
"parallel_tuple_cost": "0", +
```
If not bugs, please ignore them.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
