JSqlParser

JSqlParser copied to clipboard

like this: create table xuhan3(id int not null AUTO_INCREMENT primary key, name char(40), SimpleDate date, `SimpleDate_dayofweek` tinyint(4) GENERATED ALWAYS AS (dayofweek(SimpleDate)) VIRTUAL, KEY `SimpleDate_dayofweek` (`SimpleDate_dayofweek`)); jsqlparser code: Statements stmts =...

1987bishop

Error while parsing alter table max_rows or min_rows in mysql

3

like this: alter table abc max_rows = 1000; jsqlparser code: String result = SQLUtils.format(sql, dbType); System.out.println(result); Statements stmts = CCJSqlParserUtil.parseStatements("alter table abc max_rows = 1000;"); List stmtList = stmts.getStatements(); System.out.println("size...

1987bishop

Is it feasible to add support in jsqlparser for "table-valued" functions as defined by t-sql?

5

From [t-sql](https://docs.microsoft.com/en-us/sql/t-sql/statements/create-function-transact-sql?view=sql-server-2017#syntax) -- Transact-SQL Multi-Statement Table-Valued Function Syntax CREATE [ OR ALTER ] FUNCTION [ schema_name. ] function_name ( [ { @parameter_name [ AS ] [ type_schema_name. ] parameter_data_type [...

amacgaffey

This is an issue that I noticed adding Teradata's REPLACE VIEW syntax, as I had to decide between putting it in the CreateView or the AlterView objects. CreateView has the...

ted-johnson

Apache Cayenne support

7

Friends, I'm fighting with lots of information in Apache Cayenne format. It has SQL templated. Tried to hack a bit its support. Started with simple ``` #result('field' 'type' 'alias') ```...

neopaf

parse error between with oracle outer join(+)

1

### Actual Behavior Caused by: net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: "BETWEEN" "BETWEEN" at line 1, column 49. Was expecting one of: "." ";" "AND" "CONNECT" "EXCEPT" "FOR" "GROUP" "HAVING" "INTERSECT" "MINUS"...

realizm

### Actual Behavior `create unique null_filtered index foo on bar (baz)` is parsed successfully, but the `unique` parameter is lost. ### Expected Behavior `create unique null_filtered index foo on bar...

olavloite

### Actual Behavior the sql is as follow: `alter table tbl_demo add column demo_url varchar(128) GENERATED ALWAYS AS (JSON_UNQUOTE(detail->'$.myurl'));` ### Expected Behavior parse normally for [GENERATED ALWAYS AS] of MySQL....

tjw8803

### Actual Behavior ### Expected Behavior ### Steps to Reproduce the Problem sql: CREATE TABLE `basic` ( `basic_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '自增长id', `basic_title` varchar(300) CHARACTER SET utf8 COLLATE...

wanjinji

Using APPROXIMATE in redshift queries as defined here: https://docs.aws.amazon.com/redshift/latest/dg/r_APPROXIMATE_PERCENTILE_DISC.html https://docs.aws.amazon.com/redshift/latest/dg/r_COUNT.html caused this exception to be thrown: ``` Caused by: net.sf.jsqlparser.parser.ParseException: Encountered " "(" "( "" at line 1, column 35....

frankfarrell