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

determine last relevant keyword without considering ifnull() in the on clause

Open k-sibyl opened this issue 1 year ago • 0 comments

When i handled sql like below, 'b.col1' is recognized as a table name in Parser.tables: sql:"from table1 a left join table2 b on ifnull(a.col1, '') = ifnull(b.col1, '')" When I commented out the lines 989 and 990 of code in the picture, the above-mentioned problem was solved.: parser

k-sibyl avatar Dec 03 '24 09:12 k-sibyl