You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@beam.apache.org by "Robin Qiu (Jira)" <ji...@apache.org> on 2020/08/21 00:51:00 UTC
[jira] [Work started] (BEAM-10783) ZetaSQL failed on WITH queries
because wrong ref column index calculated in JoinScanWithRefConverter
[ https://issues.apache.org/jira/browse/BEAM-10783?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Work on BEAM-10783 started by Robin Qiu.
----------------------------------------
> ZetaSQL failed on WITH queries because wrong ref column index calculated in JoinScanWithRefConverter
> ----------------------------------------------------------------------------------------------------
>
> Key: BEAM-10783
> URL: https://issues.apache.org/jira/browse/BEAM-10783
> Project: Beam
> Issue Type: Bug
> Components: dsl-sql-zetasql
> Reporter: Robin Qiu
> Assignee: Robin Qiu
> Priority: P2
>
> Some WITH queries, like:
> WITH t1 AS (select 1 AS k), t2 AS (select 1 AS k), t3 AS (select 1 AS k)
> SELECT COUNT\(*\)
> FROM t1 JOIN t3 USING (k)
> failed on ZetaSQL because how column index is calculated in JoinScanWithRefConverter is not correct.
>
> In fact, the other converter responsible for JOINs, JoinScanConverter, has the correct implementation, and that works fine for JOINs that has reference to WITH queries. So I believe we should delete the incorrect JoinScanWithRefConverter class and move to the other one.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)