Repository navigation
[BUG] JSQLParser Version 4.6: Informix: parser select into temp table error #1833
Description
Failing SQL Feature:
can not parse select into temp table
SQL Example:
```sql
select age, name, gender
from user_info
into temp user_temp with no log;
```
Software Information:
- JSqlParser version 4.6
- Informix
error info:
net.sf.jsqlparser.JSQLParserException: net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: "into" "INTO"
at line 23, column 32.
Was expecting one of:
"&"
"::"
";"
"<<"
">>"
"COLLATE"
"CONNECT"
"EMIT"
"GROUP"
"HAVING"
"START"
"["
"^"
"|"
<EOF>
Activity
manticore-projects commentedon Jul 23, 2023
Greetings.
with no logshould cause the problem.If you need support for Informix specific syntax, you will need to provide or sponsor an implementation.