Closed
Description
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
Labels
No labels