Skip to content

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

@k-sibyl

Description

@k-sibyl

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

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions