Skip to content

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

Closed
@martin7569

Description

@martin7569

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>

Metadata

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions