sql-metadata icon indicating copy to clipboard operation
sql-metadata copied to clipboard

For Dateadd function , DD and WK keyword is been considered as column names

Open VinayakaCN opened this issue 2 years ago • 0 comments

its a Great piece of work, but a small bug, for the below query, DD and WK keyword is been returned as columns , which ideally its not. so appreciate your fix.

SQL_parser = Parser(""" select dateadd(dd,30, DateReleased), dateadd(WK,2, DateReleased) from test a """) SQL_parser.columns

Tip : probably adding DD WK YY/YYYY as reserved keywords and ignore from columns list.

VinayakaCN avatar Aug 07 '23 17:08 VinayakaCN