[jira] [Created] (CALCITE-2511) Possible bug in parsing implementation of rown_num select

["Piotr Bojko (JIRA)" <ji...@apache.org>]

Piotr Bojko created CALCITE-2511:
------------------------------------

             Summary: Possible bug in parsing implementation of rown_num select
                 Key: CALCITE-2511
                 URL: https://issues.apache.org/jira/browse/CALCITE-2511
             Project: Calcite
          Issue Type: Bug
          Components: core
    Affects Versions: 1.17.0, 1.18.0
            Reporter: Piotr Bojko
            Assignee: Julian Hyde
         Attachments: implementation.java

I've found a possible bug.

With following view:

{code:json}
				{
					"name": "STEPS",
					"type": "view",
					"sql": [
						"WITH ALLROWS AS ( ",
						" SELECT ",
						"   ROW_NUMBER() OVER W AS IDX, I.ID ISSUE, COALESCE(CG.AUTHOR, I.REPORTER) AS AUTHOR, COALESCE(CI.OLDVALUE, I.STATUS) AS STATUS, I.CREATED AS STARTDATE, CG.CREATED AS ENDDATE ",
						" FROM ISSUES AS I ",
						" JOIN INTERNAL.CHANGEGROUP AS CG ON CG.ISSUEID = I.ID ",
						" JOIN INTERNAL.CHANGEITEM AS CI ON CI.GROUPID = CG.ID ",
						" WHERE CI.FIELDTYPE = 'jira' AND CI.FIELD = 'status' ",
						" WINDOW w AS (PARTITION BY i.id ORDER BY CG.CREATED) ",
						") ",
						"SELECT ISSUE, AUTHOR, STATUS, STARTDATE, ENDDATE ",
						"FROM ALLROWS WHERE ALLROWS.IDX <= 1 ",
						"UNION ALL ",
						"SELECT I.ID AS ISSUE, CG.AUTHOR, CI.NEWVALUE AS STATUS, CG.CREATED AS STARTDATE, LEAD(CG.CREATED, 1) OVER W AS ENDDATE ",
						"FROM ISSUES i ",
						"JOIN INTERNAL.CHANGEGROUP AS CG ON CG.ISSUEID = I.ID ",
						"JOIN INTERNAL.CHANGEITEM AS CI ON CI.GROUPID = CG.ID ",
						"WHERE CI.FIELDTYPE = 'jira' AND CI.FIELD = 'status' ",
						"WINDOW W AS (PARTITION BY I.ID ORDER BY CG.CREATED) "
					]
				},
{code}

When performig
{code:sql}
SELECT * FROM STEPS
{code}

The result is

{noformat}
Line 1556, Column 0: Java$AmbiguousName is not allowed as an expression statement. Expressions statements must be one of assignments, method invocations, or object allocations..
{noformat}

As an attachment, I've attached implementation. Clearly the line 1555/1556 is wrong...




--
This message was sent by Atlassian JIRA
(v7.6.3#76005)