JSqlParser

JSqlParser copied to clipboard

Fix parsing `ALTER TABLE ... ADD COLUMNS (...)`

1

The current behaviour fails when it encounters `ADD COLUMNS` and merges everything in the `()` into one string with no whitespace. So `ALTER TABLE catalog.table.name ADD COLUMNS (apples int)` becomes...

njaremko

Added support for minus all; except all; intersect all;

5

SunandaS76

### Failing SQL Feature: This is related to [#1164 ](https://github.com/JSQLParser/JSqlParser/issues/1164) and happens when UNIQUE is after FOREIGN KEY ### SQL Example: - Simplified Query Example, focusing on the failing feature...

rasa-app

### Grammar or Syntax Description - The PREWHERE clause in ClickHouse is not currently supported by the parser. - Example: PREWHERE clause is used for filtering rows before the SELECT...

wqq-java

[BUG] 5.0 4.9 4.2 mysql fulltext and concat error

1

Always check against the **Latest SNAPSHOT of JSQLParser** and the [Syntax Diagram](https://jsqlparser.github.io/JSqlParser/syntax_snapshot.html) ### Failing SQL Feature: - mysql fulltext and concat error - match (name) against (concat('*',?,'*') in boolean mode)...

nmf2019

## Issue Description: There is a parsing failure in JSQLParser 5.0 when dealing with MySQL's ALTER INDEX and ADD INDEX ... INVISIBLE statements. These statements, introduced in [MySQL 8.0](https://dev.mysql.com/doc/refman/8.4/en/invisible-indexes.html) ```...

minleejae

How to parse CREATE DATABASE DATABASE_NAME ?

3

package org.example; import net.sf.jsqlparser.parser.CCJSqlParser; import net.sf.jsqlparser.parser.CCJSqlParserUtil; import net.sf.jsqlparser.statement.Statement; import net.sf.jsqlparser.statement.Statements; class Main { public static void main(String[] args) { try { String sqlStr = "CREATE DATABASE USERS; "; Statement statement=CCJSqlParserUtil.parse(sqlStr);...

ganesh-akashh

[BUG] JSQLParser 5.1: PostgreSQL: fail to parse dollar-quoted string constants with tags

19

The parser fails to parse dollar-quoted string constants with tags (see https://www.postgresql.org/docs/current/sql-syntax-lexical.html#SQL-SYNTAX-DOLLAR-QUOTING) SQL example: ```sql select $json$ [ {"some":"json","with":"properties"}, {"other":"json","with":"properties"} ] $json$::jsonb ``` The error I get: ``` net.sf.jsqlparser.parser.ParseException: Encountered...

E1izabeth

Bumps [org.junit.jupiter:junit-jupiter-api](https://github.com/junit-team/junit5) from 5.11.4 to 5.13.1. Release notes Sourced from org.junit.jupiter:junit-jupiter-api's releases. JUnit 5.13.1 = Platform 1.13.1 + Jupiter 5.13.1 + Vintage 5.13.1 See Release Notes. Full Changelog: https://github.com/junit-team/junit5/compare/r5.13.0...r5.13.1 JUnit...

dependabot[bot]

Bumps [org.junit.jupiter:junit-jupiter-params](https://github.com/junit-team/junit5) from 5.11.4 to 5.13.1. Release notes Sourced from org.junit.jupiter:junit-jupiter-params's releases. JUnit 5.13.1 = Platform 1.13.1 + Jupiter 5.13.1 + Vintage 5.13.1 See Release Notes. Full Changelog: https://github.com/junit-team/junit5/compare/r5.13.0...r5.13.1 JUnit...

dependabot[bot]