Skip to content

Unpivot failures after Merge PR #1380 #1385

Closed
@manticore-projects

Description

@manticore-projects

The UNPIVOT PR #1380 causes issues:

Warning: Choice conflict in [...] construct at line 2288, column 5.
         Expansion nested within construct and expansion following construct
         have common prefixes, one of which is: "AS"
         Consider using a lookahead of 2 or more for nested expansion.
Oct 21, 2021 12:35:30 PM net.sf.jsqlparser.statement.select.SpecialOracleTest testAllSqlsParseDeparse
SEVERE: UNEXPECTED DE-PARSING FAILURE: pivot04.sql
org.junit.ComparisonFailure: expected:<... in(v1,v2,v3,v4,v5))[])> but was:<... in(v1,v2,v3,v4,v5))[unpivot(value for value_type in(v1,v2,v3,v4,v5))])>
Oct 21, 2021 12:35:31 PM net.sf.jsqlparser.statement.select.SpecialOracleTest testAllSqlsParseDeparse
SEVERE: UNEXPECTED DE-PARSING FAILURE: pivot12.sql
org.junit.ComparisonFailure: expected:<... in(v1,v2,v3,v4,v5))[])> but was:<... in(v1,v2,v3,v4,v5))[unpivot include nulls(value for value_type in(v1,v2,v3,v4,v5))])>
Oct 21, 2021 12:35:31 PM net.sf.jsqlparser.statement.select.SpecialOracleTest testAllSqlsParseDeparse
SEVERE: UNEXPECTED DE-PARSING FAILURE: simple04.sql
org.junit.ComparisonFailure: expected:<...alue_type in(dummy))[])> but was:<...alue_type in(dummy))[unpivot(value for value_type in(dummy))])>
Oct 21, 2021 12:35:31 PM net.sf.jsqlparser.statement.select.SpecialOracleTest testAllSqlsParseDeparse
INFO: tested 273 files. got 187 correct parse results, expected 190

I will fix that, but why did that not come up during the Merge/CI?

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions