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: github-unsubscr...@datafusion.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: github-unsubscr...@datafusion.apache.org
For additional commands, e-mail: github-h...@datafusion.apache.org

Reply via email to