Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Sign up
Appearance settings

[BUG] JSQLParser 5.3 Encountered unexpected token K_DO "DO". #2358

Open
Labels
@Chester-Cheetah

Description

http://jsqlformatter.manticore-projects.com/jsqlformatter/demo.html?args=-c%20JYOwzgpgTgLgBKGB7OBjJIBmA6MBXABwIBsBPAfVExQApgATAGjnogENjKm4oIClY5emxgRmUJMQjl0rAJQAoSFNTw8eBuQDmEENBHSAbgBYacxgt4FsrDlwtXsVgTCEGHfJ5OmyICzBIAtmgYOM6wYDx8CgBWSKAhWNgCrFCRKBhR1gxwALxwSE58LlwKmehYxMCqLCggSDAAFqBaQA

insert into conf.supply_info (id, deal_id, report_date, role_code)
select uuid_generate_v4(),
rep.deal_id,
rep.report_date,
rep.role_code
from conf.reports rep
join conf.orders o on rep.id = o.report_id
on conflict do nothing;

Unexpected K_DO "DO"
Expected one of these: "ON", "RETURN", "RETURNING", "ST_SEMICOLON".

But there is correct syntax for PostgreSQL

Metadata

Metadata

Labels

Type

Projects

No projects

Milestone

No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions

      AltStyle によって変換されたページ (->オリジナル) /