JSqlParser

JSqlParser copied to clipboard

v4.5 is very slow compare to v1.4 in some sql

5

I upgrade JsqlParser from v1.4 to v4.5, the performance is very different when parse this sql: `SELECT count(*) AS \"count\" FROM Setting AS m WHERE ((key not in ('mergeBillingRepayment', 'mergeBillingCorRepayment',...

wolfjiang

table name has hyphen/dash "-"

1

In Google BigQuery, a full qualified table name can be like `pro-ject.dataset.table-name`, having "-" in the database and table part. Though this can resolved by wrapping the full name with...

dequn

ParseException due to ARRAY_AGG() and SAFE_CAST()

7

Hi, We recently found this ParseException due to the use of ARRAY_AGG() and SAFE_CAST() from the built-in functions provided by Google BigQuery. However, when I tried to validate the SQL...

Tianqi1006

Sphinx Website

12

### Summary Add a HTML5 Website based on Sphinx: a) scales on devices (from mobile phone to very large screens) b) theme-able (shown is a modified theme based on Read...

manticore-projects

Insert ON CONFLICT parsed failed when composite primary multi columns

1

Ref: #1630 Failed when composite primary keys (id_1+id_2) --> "ON CONFLICT (id_1, id_2)" ```sql INSERT into test_data (id_1, id_2, my_string_1, my_string_2) VALUES ('id_1_A', 'id_2_A', 'my_string_1-new', 'my_string_2-new') ON CONFLICT (id_1, id_2)...

leotu

Encountered unexpected token: "member"

4

代码如下 `String sql= "SELECT \n" + " id,cxr_employee_id,cxr_post_id,cxr_site_id,cxr_region_id,in_charge_start_time,in_charge_end_time,charge_status,create_by,create_time,update_by,update_time,revision,create_by_name,create_by_type,update_by_name,update_by_type,delete_by,delete_by_name,delete_by_type,delete_time,delete_status,sort_num,remark,sys_dept_id,spare_id \n" + " FROM cxr_employee_post \n" + " WHERE ( '106' member of (cxr_post_id->'$.value') )"; Select stmt = (Select) CCJSqlParserUtil.parse(sql);` 报错如下： Exception...

lovlyhao

Cannot parse druid sql

1

Cannot parse druid sql: https://druid.apache.org/docs/latest/querying/sql.html `String sql = "SELECT count(machineId), FLOOR(__time TO HOUR) FROM xaxd_brokerloadindexv1 WHERE __time BETWEEN '2010-02-12 00:00:00' AND '2019-02-23 00:00:00' GROUP BY FLOOR(__time TO HOUR)"; Select select...

shuitai

Oracle Partition by Parse Error

14

SELECT * FROM SUB_DATA_CUST1 A LEFT JOIN SELECT * FROM SUB_DATA_CUST2 A WHERE A.STD_YM BETWEEN TO_CHAR (ADD_MONTHS (SYSDATE,-15), 'YYYYMM') AND TO_CHAR (SYSDATE,'yyyymm') ) B PARTITION BY ( B.COMP_CD, B.CUST_CD, B.STD_YM,...

leedonet

解析时候异常（ QL parsing problem）

1


qq1461607240

support clickhouse global keyword in join

2

Support GLOBAL keyword for JOIN in ClickHouse.

julianzlzhang