Join between two in-memory tables triggers "Program terminated with exit(1)" in JS console

[mskyttner]

The join query below reports an error message "Program terminated with exit(1)" in the JS console.

ATTACH 'https://raw.githubusercontent.com/tobilg/aws-iam-data/main/data/db/iam.duckdb' as aws_iam (READ_ONLY);

create table a as from "aws_iam"."actions";
create table s as from "aws_iam"."services";

from a join s on (a.service_id = s.service_id) 
select a.*, s.*;

I tested this with a pristine firefox, started with this command:

docker run -d \
    --name=firefox \
    --network=host \
    -p 5800:5800 \
    -v $HOME/.docker/firefox:/config:rw \
    --shm-size 2g \
    jlesage/firefox

Same message occurs in chromium, latest version.

The query succeeds using the duckdb CLI.

[mskyttner]

[tobilg]

Seems like a bug with the underlying DuckDB WASM. https://sql-workbench.com/#queries=v0,ATTACH-'https%3A%2F%2Fraw.githubusercontent.com%2Ftobilg%2Faws%20iam%20data%2Fmain%2Fdata%2Fdb%2Fiam.duckdb'-as-aws_iam-(READ_ONLY)~,create-table-a-as-from-aws_iam.actions~,create-table-s-as-from-aws_iam.services~,select-a.*%2C-s.*-from-a-join-s-on-(a.service_id-%3D-s.service_id)~ fails, whereas selecting specific fields from s.* workse:

https://sql-workbench.com/#queries=v0,ATTACH-'https%3A%2F%2Fraw.githubusercontent.com%2Ftobilg%2Faws%20iam%20data%2Fmain%2Fdata%2Fdb%2Fiam.duckdb'-as-aws_iam-(READ_ONLY)~,create-table-a-as-from-aws_iam.actions~,create-table-s-as-from-aws_iam.services~,select-a.*%2C-s.name-from-a-join-s-on-(a.service_id-%3D-s.service_id)~

select a., s. from a join s on (a.service_id = s.service_id); -> DOESN'T WORK
select a.*, s.service_id, s.name, s.prefix, s.reference_url from a join s on (a.service_id = s.service_id); -> WORKS

I suspect that's because there are two service_id columns then.