JSqlParser

JSqlParser copied to clipboard

[BUG] JSQLParser 4.9 fails to parse subsequent statements after parsing FUNCTION statement

3

hi there！ I am using the JSQLParser4.9 tool to parse SQL DDL statements, but I encountered a problem when parsing the following statement: ### SQL Example: - Simplified Query Example,...

kxed

[PERF] JSQLParser Version : parse timeout when calling many nested functions

6

Always check against the **Latest SNAPSHOT of JSQLParser** and the [Syntax Diagram](https://jsqlparser.github.io/JSqlParser/syntax_snapshot.html) ### Failing SQL Feature: - parse timeout，just a common sql , haved set timeout argument to 3 minutes....

young0098

Validation validation = new Validation(Arrays.asList(DatabaseType.SQLSERVER), sql); validation.validate(); Does not support "ALTER FUNCTION" or "ALTER PROCEDURE" both scripts below are compiled on SQL Server. ### Failing SQL Feature: net.sf.jsqlparser.parser.ParseException: Encountered unexpected...

chaseven

### Failing SQL Feature: - JSQLParser fails to parse SQL statements that include the MySQL-specific `_utf8mb4` character set prefix followed by a string literal with a space in between. This...

aarthiganga01

### Failing SQL Feature: - Crash in Postgres Vector when evaluating cosine similarity like (embedding '[3,1,2]') due to enclosing parentheses. `` can't be parsed ### SQL Example: - Using ```sql...

lqh19870820

[BUG] JSQLParser 4.9 : Failed to parse listagg with "on overflow truncate"

2

> String sql = "select LISTAGG(field, ',' on overflow truncate '...') from dual"; > PlainSelect plainSelect = (PlainSelect) CCJSqlParserUtil.parse(sql); fails with > net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: "(" "(" > at...

fourhundredfortyfour

Always check against the **Latest SNAPSHOT of JSQLParser** and the [Syntax Diagram](https://jsqlparser.github.io/JSqlParser/syntax_snapshot.html) ### Failing SQL Feature: net.sf.jsqlparser.JSQLParserException: Encountered unexpected token: "WITH" "WITH" at line 66, column 1. Was expecting one...

HoHnerF

[BUG] JSQLParser Version : RDBMS : failing feature description

1

Always check against the **Latest SNAPSHOT of JSQLParser** and the [Syntax Diagram](https://jsqlparser.github.io/JSqlParser/syntax_snapshot.html) ### Failing SQL Feature: net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: "||" ### SQL Example: - Simplified Query Example, focusing on...

chenshuai741

[BUG] SQLServer Validation fail jsqlparser Version :4.9

1

Some keywords of SQLServer are not recognized SQL demo 1 CREATE TABLE dbo.virtual_production_record( id bigint NOT NULL, machine_group_code nvarchar(255) NOT NULL, machine_code nvarchar(255) NOT NULL, virtual_count int NOT NULL, start_date...

yanceysong

I'm trying to parse some log files where stored procedures are used. So the statement would look like: BEGIN modifyParams( :BP_00000_v, ..., :BP_00012_v ); END; Is there a way to...

jenspopp