JSqlParser

JSqlParser copied to clipboard

Snowflake MERGE statement does not require parentheses around the ON statement

3

**Describe the bug** The Snowflake MERGE statement does not require the ON statement to be wrapped in parantheses. **To Reproduce** Steps to reproduce the behavior: 1. Example SQL ``` MERGE...

stewartbryson

SET clause with alias not parsed

1

**Describe the bug** I found this query in the MySQL 8.0 Reference Manual page 2678 **To Reproduce** 1.` INSERT INTO t1 SET a=1,b=2,c=3 AS new(m,n,p) ON DUPLICATE KEY UPDATE c...

rptr

Failed to parse MySQL statement and add common index statement with alter

2

Failed to parse MySQL statement and add common index statement with alter Version： com.github.jsqlparser jsqlparser 4.1 Parsed statement ： ALTER TABLE table_name8 ADD index (column_1) This statement can be executed...

t291436520

WIP: preparing fixes for PR.

4

wheredevel

Failed to parse when creating unique index in creation DDL

3

### Actual Behavior Parsing creation DDL like: CREATE TABLE `test3` ( `NAME` varchar(255) NOT NULL DEFAULT '', `ID` bigint(20) unsigned NOT NULL, PRIMARY KEY (`NAME`), unique index idx(`id`) ) ENGINE=InnoDB...

RewardisGem

Support EXECUTE FUNCTION/PROCEDURE

2

I think there is support for EXECUTE name syntax. Is it possible to add support for EXECUTE PROCEDURE name (...) and EXECUTE FUNCTION name (...) syntax?

morvael

4.1 Parser fails on H2 Ordered Aggregate Functions

2

Just stumpled over this: ```sql -- LISTAGG 3: fails to parse SELECT LISTAGG(ID, ', ') WITHIN GROUP (ORDER BY ID) OVER (ORDER BY ID); -- ARRAY_AGG 2: fails to deparse...

manticore-projects

Support for SNOWFLAKE specific query grammer

3

Can we support the following type of query : select FIRST_VALUE (bc.merch_l1_name [IGNORE NULLS]) over (partition by sku, channel_id order by feed_date desc) as merch_l1_name, FIRST_VALUE (bc.brand [IGNORE NULLS]) over...

ghost

Postgresql insert parser error

5

**Describe the bug** A clear and concise description of what the bug is. **To Reproduce** Steps to reproduce the behavior: 1. Example SQL INSERT INTO tableName (id,xxx0,xxx1,xxx2,is_deleted,create_time,update_time) VALUES (?, ?,...

slieer

StatementVisitor not visisting the whole query

2

**Describe the bug** I want to count the amount of subqueries (i.e., Delete, Select, ...) in a parsed query. However, the visitor seems to only visit the first element which...

simkoc