avamingli commented on PR #724:
URL: https://github.com/apache/cloudberry/pull/724#issuecomment-2519274062
Hi, with gp_enable_runtime_filter_pushdown = on, execute SQL below will get
a crash:
```sql
gpadmin=# show gp_enable_runtime_filter_pushdown;
gp_enable_runtime_filter_pushdown
-----------------------------------
on
(1 row)
```
```sql
CREATE TABLE test_tablesample (dist int, id int, name text) WITH
(fillfactor=10) DISTRIBUTED BY (dist);
-- use fillfactor so we don't have to load too much data to get multiple
pages
-- Changed the column length in order to match the expected results based on
relation's blocksz
INSERT INTO test_tablesample SELECT 0, i, repeat(i::text, 875) FROM
generate_series(0, 9) s(i) ORDER BY i;
INSERT INTO test_tablesample SELECT 3, i, repeat(i::text, 875) FROM
generate_series(10, 19) s(i) ORDER BY i;
INSERT INTO test_tablesample SELECT 5, i, repeat(i::text, 875) FROM
generate_series(20, 29) s(i) ORDER BY i;
EXPLAIN (COSTS OFF)
SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (50) REPEATABLE (2);
FATAL: Unexpected internal error (assert.c:48)
DETAIL: FailedAssertion("IsA(planstate, SeqScanState)", File: "explain.c",
Line: 4154)
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
The connection to the server was lost. Attempting reset: Succeeded.
psql (14.4, server 14.4)
```
<img width="1779" alt="image"
src="https://github.com/user-attachments/assets/a8882208-1800-4df3-9f2d-7c659e24aaa3";>
--
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]
