Not able to get more than 19 rows with duckdb_fdw?

[dforsber]

Here is a reproduction of the issue. 19 rows are displayed ok, but more than that the query is stuck.

CREATE EXTENSION duckdb_fdw;
CREATE SERVER duckdb_server FOREIGN DATA WRAPPER duckdb_fdw;
SELECT duckdb_execute('duckdb_server','CREATE TABLE s3table (a integer, b integer);');
SELECT duckdb_execute('duckdb_server','INSERT INTO s3table VALUES (1,2);');
SELECT duckdb_execute('duckdb_server','INSERT INTO s3table VALUES (3,222);');
SELECT duckdb_execute('duckdb_server','INSERT INTO s3table VALUES (12,215);');
SELECT duckdb_execute('duckdb_server','INSERT INTO s3table VALUES (122,14);');
SELECT duckdb_execute('duckdb_server','INSERT INTO s3table VALUES (121142,1512);');
SELECT duckdb_execute('duckdb_server','INSERT INTO s3table VALUES (512,1312);');
SELECT duckdb_execute('duckdb_server','INSERT INTO s3table VALUES (1432,1);');
SELECT duckdb_execute('duckdb_server','INSERT INTO s3table VALUES (152,12);');
SELECT duckdb_execute('duckdb_server','INSERT INTO s3table VALUES (312,2);');
SELECT duckdb_execute('duckdb_server','INSERT INTO s3table VALUES (112,11);');
SELECT duckdb_execute('duckdb_server','INSERT INTO s3table VALUES (6512,11442);');
SELECT duckdb_execute('duckdb_server','INSERT INTO s3table VALUES (412,1152);');
SELECT duckdb_execute('duckdb_server','INSERT INTO s3table VALUES (2212,1172);');
SELECT duckdb_execute('duckdb_server','INSERT INTO s3table VALUES (812,112);');
SELECT duckdb_execute('duckdb_server','INSERT INTO s3table VALUES (412,1132);');
SELECT duckdb_execute('duckdb_server','INSERT INTO s3table VALUES (122,1152);');
SELECT duckdb_execute('duckdb_server','INSERT INTO s3table VALUES (1312,54112);');
SELECT duckdb_execute('duckdb_server','INSERT INTO s3table VALUES (912,1152);');
SELECT duckdb_execute('duckdb_server','INSERT INTO s3table VALUES (512,3112);');
SELECT duckdb_execute('duckdb_server','INSERT INTO s3table VALUES (8142,2112);');
SELECT duckdb_execute('duckdb_server','INSERT INTO s3table VALUES (132,12);');
SELECT duckdb_execute('duckdb_server','INSERT INTO s3table VALUES (72,12);');
IMPORT FOREIGN SCHEMA public FROM SERVER duckdb_server INTO public;
SELECT * FROM s3table LIMIT 13;
SELECT * FROM s3table LIMIT 19;
SELECT * FROM s3table LIMIT 20;
SELECT * FROM s3table LIMIT 21;

[alitrack]

no issue

[dforsber]

The answer I wanted! I'm suspecting my env as I compile postgres from source. I've already tried 14.3 and 14.4.

[dforsber]

Yes, it works on shell. I was using script that somehow messed up the output buffer. Closing this.