Join GitHub today
GitHub is home to over 50 million developers working together to host and review code, manage projects, and build software together.
Sign up| ★ wanayoo — archive 1999 https://github.com/JSQLParser/JSqlParser/issues/947 | Nouvelle recherche | Portail wanayoo |
GitHub is home to over 50 million developers working together to host and review code, manage projects, and build software together.
Sign up
Describe the bug
net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: "IF" "IF"
To Reproduce
Steps to reproduce the behavior:
Example SQL
`SELECT
count(0)
FROM
(
SELECT
t1., t2., p.project_name projectName,
g.group_name groupName,
t2.zone_id zoneId,
t2.project_id projectId,
t2.group_id groupId,
t2.student_id studentId,
t2.team_id teamId
FROM
(
SELECT
) tmp_count`
Parsing this SQL using JSqlParser with this statements
Statement statement = CCJSqlParserUtil.parse(sql); TablesNamesFinder tablesNamesFinder = new TablesNamesFinder(); List<String> tableList = tablesNamesFinder.getTableList(statement); System.out.println(tableList.toString());Exception
net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: "IF" "IF"
Expected behavior
[result, student_project, student, project,
zone, team, oe_group]System