Temp table is not populating in postgreSQL database

[rojo-syndigo]

What happens?

DO $$
BEGIN
SET LOCAL duckdb.force_execution = true;

CREATE TEMP TABLE tmp_tble1 AS
SELECT id FROM mytable WHERE id IN ('ersaiDN2dO4YojZ','ersFI2HutTimVaO');

SET LOCAL duckdb.force_execution = false;
END $$;

When query with both these ids 'ersaiDN2dO4YojZ' and 'ersFI2HutTimVaO' as above, the temp table is not populating. If I give only one value then working fine. Using azure postgreSQL and enabled PG_duckdb extension.

To Reproduce

DO $$
BEGIN
SET LOCAL duckdb.force_execution = true;

CREATE TEMP TABLE tmp_tble1 AS
SELECT id FROM mytable WHERE id IN ('ersaiDN2dO4YojZ','ersFI2HutTimVaO');

SET LOCAL duckdb.force_execution = false;
END $$;

OS:

Azure Database for PostgreSQL flexible server

DuckDB Version:

PG_DUCKDB azure extension

DuckDB Client:

PG_DUCKDB azure extension

Hardware:

No response

Full Name:

Rojo Joseph

Affiliation:

Riversand

Did you include all relevant configuration (e.g., CPU architecture, Linux distribution) to reproduce the issue?

• Yes, I have

Did you include all code required to reproduce the issue?

• Yes, I have

Did you include all relevant data sets for reproducing the issue?

No - Other reason (please specify in the issue body)

[duckdblabs-bot]

Thanks for opening this issue! Based on our automated check, it seems that your post contains some code but it does not use code blocks to format it.

Please double-check your post and revise it if necessary. To employ syntax highlighting, it's recommended to use code blocks with triple backticks, e.g.:

```sql
SELECT ...
```

If this is a false positive, feel free to disregard this comment.