Skip to content

[BUG] JSQLParser 4.0 : DM : Oracle INSERT ALL ... unsupported #2178

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

Open
FelixDxc opened this issue Mar 4, 2025 · 1 comment
Open

[BUG] JSQLParser 4.0 : DM : Oracle INSERT ALL ... unsupported #2178

FelixDxc opened this issue Mar 4, 2025 · 1 comment

Comments

@FelixDxc
Copy link

FelixDxc commented Mar 4, 2025

Always check against the Latest SNAPSHOT of JSQLParser and the Syntax Diagram

Failing SQL Feature:

  • net.sf.jsqlparser.JSQLParserException: Encountered unexpected token: "ALL" "ALL"
    at line 1, column 8. Was expecting one of:

    "ACTION"
    "ANY"
    "BYTE"
    "CASCADE"
    "CAST"
    "CHANGE"
    "CHAR"
    "CHARACTER"
    "COLUMN"
    "COLUMNS"
    "COMMENT"
    "COMMIT"
    "CREATE"
    "CYCLE"
    "DELAYED"
    "DESC"
    "DESCRIBE"
    "DISABLE"
    "DIV"
    "DO"
    "DOUBLE"
    "DUPLICATE"
    "ENABLE"
    "END"
    "EXCLUDE"
    "EXTRACT"
    "FALSE"
    "FIRST"
    "FN"
    "FOLLOWING"
    "FORMAT"
    "GROUP"
    "HIGH_PRIORITY"
    "IF"
    "IGNORE"
    "INDEX"
    "INSERT"
    "INTERVAL"
    "INTO"
    "ISNULL"
    "KEY"
    "LAST"
    "LEFT"
    "LIMIT"
    "LOW_PRIORITY"
    "MATERIALIZED"
    "NEXTVAL"
    "NO"
    "NOLOCK"
    "NULLS"
    "OF"
    "OFFSET"
    "ON"
    "OPEN"
    "OPTIMIZE"
    "ORDER"
    "OVER"
    "PARTITION"
    "PATH"
    "PERCENT"
    "PRECISION"
    "PRIMARY"
    "PRIOR"
    "PROCEDURE"
    "PUBLIC"
    "RANGE"
    "READ"
    "REPLACE"
    "RIGHT"
    "ROW"
    "ROWS"
    "SCHEMA"
    "SEPARATOR"
    "SEQUENCE"
    "SESSION"
    "SET"
    "SIBLINGS"
    "SIZE"
    "START"
    "TABLE"
    "TABLES"
    "TEMP"
    "TEMPORARY"
    "TO"
    "TOP"
    "TRUE"
    "TRUNCATE"
    "TYPE"
    "UNSIGNED"
    "VALIDATE"
    "VALUE"
    "VALUES"
    "VIEW"
    "XML"
    "ZONE"
    <K_DATETIMELITERAL>
    <K_DATE_LITERAL>
    <S_IDENTIFIER>
    <S_QUOTED_IDENTIFIER>

SQL Example:

  • Simplified Query Example, focusing on the failing feature
    -- INSERT ALL into spm_message (xx,xx) VALUES(?, ?) SELECT * FROM dual

Software Information:

  • JSqlParser version 4.0
  • DM

Tips:

Please write in English and avoid Screenshots (as we can't copy and paste content from it).
Try your example online with the latest JSQLParser and share the link in the error report.
Do provide Links or References to the specific Grammar and Syntax you are trying to use.

@FelixDxc FelixDxc changed the title [BUG] JSQLParser 4.0 : DM : failing feature description [BUG] JSQLParser 4.0 : DM : net.sf.jsqlparser.JSQLParserException:遇到意外标记:“ALL”“ALL” Mar 4, 2025
@FelixDxc
Copy link
Author

FelixDxc commented Mar 4, 2025

INSERT ALL

    into spm_message (seq_num, title, email,
    mobile_phone, oper_id, message_content,
    schedule_time, send_chanel, send_display,
    business_id, message_remark, send_date,
    send_mail_status, send_note_status, send_mail_reply,
    send_note_reply, read_status, send_note_count,
    send_mail_count, message_param, unique_id,
    inst_date_time, inst_user, last_upd_date_time,
    last_upd_user, USER_NO,
    BIZ_TYPE, BACKLOG_URL, BACKLOG_STATUS,
    BACKLOG_LEVEL, SEND_BACKLOG_STATUS, SEND_BACKLOG_REPLY,
    SEND_BACKLOG_COUNT, COMPLETE_TIME,RQST_BSNS_PARA,TEMPLATE_ID)
    VALUES(
    ?, ?, ?,
    ?, ?, ?,
    ?, ?, ?,
    ?, ?, ?,
    ?, ?, ?,
    ?, ?, ?,
    ?, ?, ?,
    ?, ?, ?,
    ?, ?,
    ?, ?, ?,
    ?, ?, ?,
    ?, ?
    , ?, ?
    )
 
  SELECT * FROM dual

@manticore-projects manticore-projects changed the title [BUG] JSQLParser 4.0 : DM : net.sf.jsqlparser.JSQLParserException:遇到意外标记:“ALL”“ALL” [BUG] JSQLParser 4.0 : DM : Oracle INSERT ALL ... unsupported Mar 4, 2025
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants