taozhi8833998/node-sql-parser

MISSING KEYWORD ILIKE in postgre SQL

Closed this issue · 1 comments

Describe the bug
Missing keyword ILIKE

Database Engine
PostgreSQL.

To Reproduce
when I query: select state_code from aws_ec2_instance where state_code ILIKE '123'
it throws an exception

Expected behavior
A clear and concise description of what you expected to happen.

Screenshots
If applicable, add screenshots to help explain your problem.
image

@hdlinh1808 If you are using PostgreSQL, please specify the database options, otherwise will be MySQL by default.