Add basic PostgreSql Array literal support #5997
Draft
Conversation
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Basic support of Array Literal The array_value_expression must be positioned, in the extension expression rule, after the double_colon expr to allow parser rule to use it inside array literals.
Basic Integration tests for array literals Note: In Postgresql JDBC arrays of date types cannot yet be used with LocalDate. This is an issue with the Postgresql JDBC driver and arrays Update PostgreSqlTest.kt
griffio
commented
Nov 11, 2025
| IntermediateType(REAL).nullableIf(temporalExprType.javaType.isNullable) | ||
| } | ||
| plsqlTriggerVarExpression != null -> IntermediateType(TEXT) | ||
|
|
Collaborator
Author
There was a problem hiding this comment.
Gets the list of array elements as SqlExpr - maybe all same type or different types.
The last type in typeOrdering (numeric) will be used where mixed numeric arrays are resolved. SELECT ARRAY[1.0, 2, 3::LONG] -> numeric[].
IF any elements are NULL the result is nullable type.
griffio
commented
Nov 11, 2025
| } | ||
|
|
||
| extension_expr ::= json_object_agg_stmt | json_agg_stmt | plsql_trigger_var_expression | is_json_expression | overlaps_operator_expression | range_operator_expression | extract_temporal_expression | double_colon_cast_operator_expression | contains_operator_expression | at_time_zone_operator_expression | regex_match_operator_expression | match_operator_expression | json_function_stmt | array_agg_stmt| string_agg_stmt | json_expression | boolean_not_expression | window_function_expr { | ||
| extension_expr ::= json_object_agg_stmt | json_agg_stmt | plsql_trigger_var_expression | is_json_expression | overlaps_operator_expression | range_operator_expression | extract_temporal_expression | double_colon_cast_operator_expression | array_value_expression | contains_operator_expression | at_time_zone_operator_expression | regex_match_operator_expression | match_operator_expression | json_function_stmt | array_agg_stmt| string_agg_stmt | json_expression | boolean_not_expression | window_function_expr { |
Collaborator
Author
There was a problem hiding this comment.
array_value_expression needs to be ordered after double_colon_cast_operator_expression as the rule has higher precedence
griffio
commented
Nov 11, 2025
| double_colon_cast_operator ::= '::' type_name | ||
|
|
||
| double_colon_cast_operator_expression ::= ( {bind_expr} | {literal_expr} | {cast_expr} | {function_expr} | {column_expr} ) double_colon_cast_operator [ double_colon_cast_operator ] * { | ||
| double_colon_cast_operator_expression ::= ( array_value_expression | {bind_expr} | {literal_expr} | {cast_expr} | {function_expr} | {column_expr} ) double_colon_cast_operator [ double_colon_cast_operator ] * { |
Collaborator
Author
There was a problem hiding this comment.
See extension_expr ordering
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
1 participant
Add this suggestion to a batch that can be applied as a single commit.
This suggestion is invalid because no changes were made to the code.
Suggestions cannot be applied while the pull request is closed.
Suggestions cannot be applied while viewing a subset of changes.
Only one suggestion per line can be applied in a batch.
Add this suggestion to a batch that can be applied as a single commit.
Applying suggestions on deleted lines is not supported.
You must change the existing code in this line in order to create a valid suggestion.
Outdated suggestions cannot be applied.
This suggestion has been applied or marked resolved.
Suggestions cannot be applied from pending reviews.
Suggestions cannot be applied on multi-line comments.
Suggestions cannot be applied while the pull request is queued to merge.
Suggestion cannot be applied right now. Please check back later.
🚧 🕳️ 👷 Basic array literal support using
ARRAY.🚨 Note:
SELECT ARRAY[DATE '2020-01-01', DATE '2020-01-02']returnsjava.sql.Date[] as LocalDates are not supported by PostgreSQL arrays and currently fails - see related issue #5591TODO:
More local testing
CHANGELOG.md's "Unreleased" section has been updated, if applicable.