ct-badger opened a new issue, #1932:
URL: https://github.com/apache/datafusion-sqlparser-rs/issues/1932
Example Trino SQL:
```sql
SELECT
row_id,
array_agg(
CAST(
ROW(
total_amount
)
AS
ROW(
total_amount Decimal(14,2)
)
)
ORDER BY payment_requested_date DESC
) AS payment_request_details
FROM
iceberg.my_table_name
GROUP BY 1
```
This throws an error when using `GenericDialect`, specifically when it tries
to parse `Decimal(14,2)`: ```ParserError("Expected: type modifiers, found: ( at
Line: 10, Column: 37")```
Stepping through the code it looks like this is because it does not support
deeply nested definitions because `parse_optional_type_modifiers` does not
allow `Token::LParen`.
This may be by design, but it may break parsing when you get to really
complex queries (e.g. deeply nested rows).
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
