Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[BUG] JSQLParser Version 4.6: Informix: parser select into temp table error #1833

Closed
martin7569 opened this issue Jul 23, 2023 · 1 comment · Fixed by #1953
Closed

[BUG] JSQLParser Version 4.6: Informix: parser select into temp table error #1833

martin7569 opened this issue Jul 23, 2023 · 1 comment · Fixed by #1953

Comments

@martin7569
Copy link

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>
@manticore-projects
Copy link
Contributor

Greetings.

with no log should cause the problem.
If you need support for Informix specific syntax, you will need to provide or sponsor an implementation.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

Successfully merging a pull request may close this issue.

2 participants