tobilg / sql-workbench

Public issue-tracking and feature suggestion for sql-workbench.com
https://sql-workbench.com
27 stars 0 forks source link

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

Open mskyttner opened 1 month ago

mskyttner commented 1 month ago

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 commented 1 month ago

image