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

Parser.tables returns wrong value when joined on datetrunc

Open Druags opened this issue 8 months ago • 0 comments

test_sql = '''
SELECT * 
FROM test t
join test_1 t1
    on datetrunc('day', t.test_date) = datetrunc('day', t1.test_date)
'''
def extract_tables_with_sql_metadata(sql):
    try:
        parser = Parser(sql)
        return parser.tables
    except:
        return []

print(extract_tables_with_sql_metadata(test_sql))

Results in ['test', 'test_1', 't.test_date', 't1.test_date']

Druags avatar May 05 '25 15:05 Druags