JSqlParser Versions Save

Extensions Version 0.8.6

• Added first support for Oracle hierarchical queries

SELECT * FROM employees CONNECT BY employee_id = manager_id ORDER BY last_name;
SELECT * FROM employees START WITH employee_id = 100 CONNECT BY PRIOR employee_id = manager_id ORDER SIBLINGS BY last_name;

Extensions Version 0.8.5

• Added support for mysql truncate function
• Changed repository location and groupid of JSqlParsers artifact.

<dependency>
    <groupId>com.github.jsqlparser</groupId>
    <artifactId>jsqlparser</artifactId>
    <version>0.8.5</version>
</dependency>

• Added support for postgresql type character varying.

Extensions Version 0.8.4

• Added support for named JDBC parameters

SELECT * FROM mytable WHERE b = :param

• Added support for pivot expressions
• Added support for boolean functions in where statements

select * from my_table where bool_func(col)

• Added support for Oracles old join syntax for more compare operations

select * from taba, tabb where taba.a<tabb.a(+)

• Added support for foreign keys in create table statements

create table testTable1 (a varchar(10), b varchar(20), foreign key a references testTable2(a))
create table testTable1 (a varchar(10), b varchar(20), constraint fkIdx foreign key a references testTable2(a))

• Added support for simple intervals

select 5 - INTERVAL '45 MINUTE' from mytable

• Added support for multi values IN expression

select * from mytable where (a,b,c) in (select a,b,c from mytable2)