sourceTable: unsupported list item type: *ast.JoinExpr

[carpenter-ryan]

UPDATE group_calc_totals gct SET npn = nem.npn FROM producer_group_attribute ga JOIN npn_external_map nem ON ga.npn_external_map_id = nem.id WHERE gct.group_id = ga.group_id;

This produces the error, sourceTable: unsupported list item type: *ast.JoinExpr.

The SQL is valid Postgres and executes as expected. I'm using version 1.8 of sqlc.

[kyleconroy]

CREATE TABLE group_calc_totals (
  npn  text,
  group_id text
);

CREATE TABLE producer_group_attribute (
  npn_external_map_id text,
  group_id text
);

CREATE TABLE npn_external_map (
  id   text
);

-- name: Percentile :exec
UPDATE group_calc_totals gct 
SET npn = nem.npn 
FROM producer_group_attribute ga 
JOIN npn_external_map nem ON ga.npn_external_map_id = nem.id 
WHERE gct.group_id = ga.group_id;

https://play.sqlc.dev/p/125fcccc7ba6707e40dbabc2d698313f7ec6ea9695672d49e37bd75ffb3352e2

[DarkHeros09]

any update on this issue?

[akhmadnurmuhammad]

any update on this issue?

[ahobsonsayers]

Hate to add to unnecessary notifications, but is there any update on this?

[ghandic]

Any news?

[BuilderHarrison]

Hello, any update on this?

[kyleconroy]

No update yet, but adding this to my list to look for 1.23

[kyleconroy]

Fixed in #2841 and will be released in v1.23

[kyleconroy]

This is fixed in v1.23.0 by enabling the database-backed query analyzer. We added a test case for this issue so it won’t break in the future.

You can play around with the working example on the playground