GV

GeezerVison

The World Wide Web, restored to 800 pixels of glory.

Home|About|Gaming cabinet|Archives|How it works|Starter sites

On this site

  • Sign in
  • ActionsCI/CD and automation
  • CodespacesCloud development environments
  • All Features
  • Documentation
  • Training
  • Certifications
  • Build with Copilot
  • Customize Copilot
  • Integrations
  • Trending repos
  • GitHub Sponsors
  • Developer articles
  • Enterprises

This view

  • Original page
  • New address

GeezerVison is showing github.com — [BUG] JSQLParser 4.0 : DM : Oracle `INSERT ALL ...` unsupported · Issue #2178 · JSQLParser/JSqlParser

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

New issue
Copy link
New issue
Copy link
Closed
#2394
Closed
[BUG] JSQLParser 4.0 : DM : Oracle INSERT ALL ... unsupported#2178
#2394
Copy link
Labels
DMLOracleSponsor needed

Description

@FelixDxc
FelixDxc
opened on Mar 4, 2025
Issue body actions

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.

Activity

  1. FelixDxc
    changed the title [-][BUG] JSQLParser 4.0 : DM : failing feature description[/-] [+][BUG] JSQLParser 4.0 : DM : net.sf.jsqlparser.JSQLParserException：遇到意外标记：“ALL”“ALL”[/+] on Mar 4, 2025

  2. FelixDxc commented on Mar 4, 2025

    @FelixDxc
    FelixDxc
    on Mar 4, 2025
    Author
    More actions

    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
  3. manticore-projects
    added
    DML
    Sponsor needed
    Oracle
    on Mar 4, 2025
  4. 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[/+] on Mar 4, 2025
  5. manticore-projects
    closed this as completedin #2394on Mar 3, 2026
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    DMLOracleSponsor needed

    Type

    No type

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions
      You are visitor 01402503 — GeezerVison does not store the pages you look up.
      Best viewed with Netscape Navigator 4.7 or Internet Explorer 6 at 800×600. No cookies required.