…er#2419) (JSQLParser#2420)

* fix(parser): pass modifier to ExceptOp/MinusOp constructors and reset between iterations

EXCEPT ALL/DISTINCT and MINUS ALL/DISTINCT modifiers were silently
dropped during parsing because the grammar captured the modifier via
SetOperationModifier() but constructed ExceptOp and MinusOp with
their no-arg constructors (defaulting to empty string), unlike
UnionOp and IntersectOp which correctly received the modifier.

Additionally, the modifier variable was not reset between iterations
of the set-operation loop, causing modifiers to leak from one
operator to the next (e.g., UNION ALL ... EXCEPT would incorrectly
make the EXCEPT inherit ALL).

Fixes JSQLParser#2419

Co-Authored-By: Claude Opus 4.6 (1M context) <[email protected]>

* refactor: convert to parameterized tests, run spotlessApply

Co-Authored-By: Claude Opus 4.6 (1M context) <[email protected]>

---------

Co-authored-by: Claude Opus 4.6 (1M context) <[email protected]>

Remove allowComplexParsing gates from ExpressionList and
ParenthesedExpressionList so ComplexExpressionList (full Expression())
is always used. This lets Condition() handle all parenthesized content
including comparison and boolean operators, eliminating the expensive
speculative LOOKAHEAD(Condition()) and XorExpression fallback in
AndExpression.

Replace syntactic LOOKAHEAD(NamedExpressionListExprFirst()) in
SpecialStringFunctionWithNamedParameters with a lightweight
isNamedExprListAhead() token scan.

Fixes parsing of deeply nested `IF()` and `POSITION(... IN (CASE ...))`.

- fixes JSQLParser#2422

Signed-off-by: Andreas Reichel <[email protected]>
Signed-off-by: manticore-projects <[email protected]>

Signed-off-by: Andreas Reichel <[email protected]>
Signed-off-by: manticore-projects <[email protected]>

Signed-off-by: manticore-projects <[email protected]>

Signed-off-by: manticore-projects <[email protected]>

Signed-off-by: manticore-projects <[email protected]>

* [feat] Initial support for JSON_TABLE

* [feat] Additional support for JSON_TABLE

* [chore] Code Review

* [chore] Started to add oracle JSON_TABLE features

* [feat] Fixed onError for Oracle, added onEmptyClause, addedParsingType, formatJson for Body

* [feat] Added EXISTS keyword

* [chore] spotless

* [chore] cleanup

* [bugfix] Fixed token limit again...

* [chore] One more test, code cleanup

- avoid wrapping the returns into NULL checks
- add license headers

Signed-off-by: manticore-projects <[email protected]>

… method limit (JSQLParser#2425)

The generated CCJSqlParserTokenManager class has a clinit method that reaches
64,452 bytes -- dangerously close to the JVM 65,535 byte limit. ASM-based tools
like sbt-assembly add transformation overhead that pushes it over, causing
MethodTooLargeException during fat JAR creation.

Add a splitTokenManagerStaticInit Gradle task that post-processes the generated
Java file after JavaCC code generation, extracting 6 large static array
initializations (stringLiterals, jjstrLiteralImages, jjmatchKinds, jjnewLexState,
jjcompositeState, jjnextStateSet) into separate private static methods. This
reduces clinit from 64,452 bytes to 404 bytes.

Co-authored-by: Claude Opus 4.6 (1M context) <[email protected]>