Analyzer Error: failed to replan join: field "id" is not on schema

[timsehn]

Schema:

CREATE TABLE instances (
  id int NOT NULL AUTO_INCREMENT,
  extra json NOT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE queries (
  id int NOT NULL AUTO_INCREMENT,
  `sql` text NOT NULL,
  intance_id int,
  data json NOT NULL,
  PRIMARY KEY (id),
  KEY intance_id (intance_id),
  CONSTRAINT f3f96uhj FOREIGN KEY (intance_id) REFERENCES instances (id)
);

CREATE TABLE query_tags (
  id int NOT NULL AUTO_INCREMENT,
  query_id int,
  tag varchar(255) NOT NULL,
  PRIMARY KEY (id),
  KEY query_id (query_id),
  CONSTRAINT alqhvkd2 FOREIGN KEY (query_id) REFERENCES queries (id)
);

Query:

$ dolt sql -q "SELECT instances.id, instances.extra 
FROM instances 
WHERE EXISTS (
SELECT 1 FROM queries WHERE instances.id = queries.intance_id AND (EXISTS (
SELECT 1 FROM query_tags WHERE queries.id = query_tags.query_id AND query_tags.tag = 'gpt-4-suggestion')))"
error on line 1 for query SELECT instances.id, instances.extra FROM instances WHERE EXISTS (SELECT 1 FROM queries WHERE instances.id = queries.intance_id AND (EXISTS (SELECT 1 FROM query_tags WHERE queries.id = query_tags.query_id AND query_tags.tag = 'gpt-4-suggestion'))): failed to replan join: field "id" is not on schema
failed to replan join: field "id" is not on schema

[timsehn]

This is a workaround:

select instances.id, instances.extra
from instances, (
    select DISTINCT intance_id from queries, query_tags
    where queries.id = query_tags.query_id AND query_tags.tag = 'gpt-4-suggestion'
) sq
where instances.id = sq.intance_id;

[timsehn]

This is fixed in 1.2.5.