Vex · Errors

Join without a foreign key

compile throws invalid_dsl when a table in from has no foreign key relationship to any table before it. Vex joins two tables only on a foreign key between them. Example: shows and members have none; as plain SQL the join would execute and return every show paired with every member.

Query

{
  from: ['shows', 'members'],
  fields: ['shows.title', 'members.name'],
}

Tables

CREATE TABLE shows (night text PRIMARY KEY, title text NOT NULL)
CREATE TABLE members (id text PRIMARY KEY, name text NOT NULL)

Error

invalid_dsl
No foreign key relationship found between any previous entity and "members". Cannot determine join condition.

Output matches the expected value

Runs in this page on the installed package. The input and the expected output are defined by the example.