datafusion icon indicating copy to clipboard operation
datafusion copied to clipboard

Bug: SQLite unparser does not support date extraction functions

Open peasee opened this issue 1 year ago • 0 comments

Describe the bug

Using an SQLite connection with SqliteDialect, and run a query that uses a date extraction function like extract(year from date_column). The unparser rewrites this to date_part, but SQLite only supports strftime so the query fails.

To Reproduce

No response

Expected behavior

The unparser should re-write the query to strftime to correctly extract the desired date information.

Additional context

No response

peasee avatar Aug 26 '24 00:08 peasee