JSqlParser changelog

Changelog of JSqlParser.

jsqlparser-5.0 (2024-06-30)

Breaking changes

Visitors return Objects and accept parameters (5bd28 Andreas Reichel)
Visitors return Objects (131a9 Andreas Reichel)
Visitors return Objects (c2328 Andreas Reichel)
Visitors return Objects (ec497 Andreas Reichel)
Visitors return Objects (681ca Andreas Reichel)

Features

provide compatibility methods (3f995 Andreas Reichel)
apply the new parametrized Visitor patterns to all entities and provide default implementations (e1692 Andreas Reichel)
syntax sugar (2fce4 Andreas Reichel)
Visitors return Objects and accept parameters (5bd28 Andreas Reichel)
Visitors return Objects (131a9 Andreas Reichel)
Visitors return Objects (c2328 Andreas Reichel)
Visitors return Objects (ec497 Andreas Reichel)
Visitors return Objects (681ca Andreas Reichel)
Allow OUTER keyword as function parameter name (#2021) (fc90c Chris Crabtree)
BigQuery SELECT AS STRUCT ... and SELECT AS VALUE ... (5c360 Andreas Reichel)
add syntax sugar (2ace7 Andreas Reichel)
AllColumns, DuckDB uses EXCLUDE instead of EXCEPT (1ad42 Andreas Reichel)
syntax sugar (ae1ef Andreas Reichel)
syntax sugar (81846 Andreas Reichel)
syntax sugar (2cb3e Andreas Reichel)
syntax sugar (b2eed Andreas Reichel)
Databricks IGNORE/RESPECT NULLS (e9c9a Andreas Reichel)
Databricks IGNORE/RESPECT NULLS (544b1 Andreas Reichel)
Capture expression name part delimiters (#2001) (0368b Chris Crabtree)
syntax sugar (ca5c5 Andreas Reichel)
translate HEX to Unicode String and ByteArray String (df519 Andreas Reichel)
StructType syntax sugar (6e9bf Andreas Reichel)
Values implement FromItem (e426c Andreas Reichel)
add ParenthesedSelect delegate (66d05 Andreas Reichel)
add ParenthesedSelect delegate (f1699 Andreas Reichel)
Simplify traversing the AST bottom to top (bddc4 Andreas Reichel)
AST Node access for FromItem (c1edf Andreas Reichel)
RedShift specific Window function IGNORE | RESPECT NULLS (321c8 Andreas Reichel)
RedShift allows TOP before DISTINCT, see https://docs.aws.amazon.com/redshift/latest/dg/r_SELECT_list.html (13e61 Andreas Reichel)
Redshift APPROXIMATE Aggregate functions (e4ece Andreas Reichel)
add CCJSqlParserUtil.sanitizeSingleSql(String sqlStr) to help MyBatikPlus users to clean their statements (1606e Andreas Reichel)
return any UnsupportedStatement content (063d2 Andreas Reichel)
re-enable UnsupportedStatement (82b45 Andreas Reichel)
better statement error recovery (b3d3a Andreas Reichel)
Syntax Sugar for the parser features (1d943 Andreas Reichel)
allow EXTRACT to be parsed as regular function also (b85dc Andreas Reichel)
syntax sugar (a3858 Andreas Reichel)
syntax sugar (df7c7 Andreas Reichel)
Syntax sugar (67bfa Andreas Reichel)
syntax sugar (b0317 Andreas Reichel)
syntax sugar (57a29 Andreas Reichel)
remove Aliases of ParenthesedSelect, LateralSubSelect and ParenthesedFromItem from the Table Names (46682 Andreas Reichel)
better access to the DataType checks (edeaf Andreas Reichel)
Add Data Type information to task for making it easy to understand the expected return type (31c55 Andreas Reichel)
Implicit Casts SELECT DOUBLE PRECISION '1' (411a3 Andreas Reichel)
Function Column Aliases without an Alias Name func(x) (a, b, c) (b4ef7 Andreas Reichel)
Support BigQuery specific Aggregate clauses (0179c Andreas Reichel)
syntax sugar for Binary Expressions like Conact, Addition, Multiplication (ffdde Andreas Reichel)
Hex to Long conversion (620db Andreas Reichel)
syntax sugar for Expressions (a5693 Andreas Reichel)
Salesforce SOQL INCLUDES and EXCLUDES operators (#1985) (f3f0e lucarota)
Google BigQuery CAST with FORMAT clause (0d813 Andreas Reichel)
DuckDB Lambda Functions (23679 Andreas Reichel)
DuckDB STRUCT with curly brackets and explicit Column Type Cast (1cd57 Andreas Reichel)
RECURSIVE does not need to be a reserved (5cb4c Andreas Reichel)
DuckDB STRUCT with curly brackets (339d6 Andreas Reichel)
BigQuery STRUCT data types and literal (4c187 Andreas Reichel)
TablesNamesFinder can return also references to WITH items (9d645 Andreas Reichel)
allow double-quoted DateTimeLiteral like DATETIME "2005-01-03 12:34:56" (f6790 Andreas Reichel)
support DATETIME literal used for Google BigQuery (a386d Andreas Reichel)
link TOP to AST node (79c42 Andreas Reichel)

Bug Fixes

AllTableColumns, DuckDB specific EXCLUDE (c9ecf Andreas Reichel)
AllColumns Replacement shall be about Columns only (f4b40 Andreas Reichel)
FromItem with Alias without AS keyword (5f580 Andreas Reichel)
set stringValue in DoubleValue.setValue (#2009) (e07f8 Damian)
try working around UnsupportedStatement issue (fbe97 Andreas Reichel)
allow BASE64 keyword (7daf7 Andreas Reichel)
StructType expressions must use Visitor instead of toString() (b95d8 Andreas Reichel)
AnyComparisionItem with extra brackets (4e1a1 Andreas Reichel)
FOR UPDATE clause should come after the select body (cf7fe Andreas Reichel)
initialise the SelectDeparser with an ExpressionDeparser (but not with an empty Adaptor only) (f417c Andreas Reichel)
ALTER ... shall captureRest() only to the next statement terminator (15d14 Andreas Reichel)
correct the wrong Assertion (8461e Andreas Reichel)
don't insert space after certain punctuation (159c2 Andreas Reichel)
treat Array Brackets [..] as syntax characters and surround by space when normalizing for comparison (c9d1e Andreas Reichel)
REGEXP does not need to be reserved (f6524 Andreas Reichel)
REGEXP does not need to be reserved (a9e67 Andreas Reichel)
Array Arguments without ARRAY keyword (0f9a8 Andreas Reichel)
Function with Array Arguments (f782e Andreas Reichel)
parsing SelectItem shall support Xor (c8839 Andreas Reichel)

Other changes

switched to version 5.0-SNAPSHOT

275e0 Tobias Warneke 2024-06-30 20:26:08

corrected license header

5fb9f Tobias Warneke 2024-06-30 20:21:47

corrected license header

456d5 Tobias Warneke 2024-06-30 20:02:41

support custom DeParser (#2013)

74793 Redkale 2024-05-29 06:02:40

Add missing java.sql require (#1999)

Add missing java.sql
Update maven checkstyle
Fix gradle checkstyle
Bump surefire plugin
Skip modules in tests

df48c Ethan McCue 2024-04-30 05:13:54

Add module info (#1998)

Add module info
Trailing newline

761b4 Ethan McCue 2024-04-30 04:36:41

89ac0 Tobias Warneke 2024-03-09 22:12:33

jsqlparser-4.9 (2024-03-09)

Features

add DB2 special register CURRENT TIMEZONE (c412d Andreas Reichel)
add additional CREATE VIEW modifiers (#1964) (67e22 David Goss)
with no log (#1953) (d9c44 mjh)
support keyword "only" for postgresql (#1952) (f1676 猫屎咖啡)
support any number/order of merge operations (#1938) (f1c52 David Goss)

Bug Fixes

chained function calls of SimpleFunction (98055 Andreas Reichel)
issue #1948 Between with expression (b9453 Andreas Reichel)
return NULL when parsing empty Strings (94fb8 Andreas Reichel)
allow Parameters like $1,$2 (17f5f Andreas Reichel)
allow DATA as ColumnType() keyword (72a51 Andreas Reichel)
make analytic expression visitor null-safe (#1944) (768c6 David Goss)
Fixes parsing failing for ALTER MODIFY queries not containing datatype (#1961) (029fd Tanish Grover)
tables not find in parentheses join sql. (#1956) (182f4 hancher)
issue1875 (#1957) (98aa9 mjh)
ExpressionVisitor.visit(AllTableColumns) method isn't being called. (#1942) (bc166 Brian S. O'Neill)

Other changes

2319d Tobias Warneke 2024-03-09 20:49:14

Handle select in ExpressionVisitorAdapter (#1972)

424a8 Kaartic Sivaraam 2024-02-23 23:32:07

Update README.md

Fixes #1968

8dcfb manticore-projects 2024-02-17 12:03:43

Guard Values against null/empty values (#1965)

Guard Values against null/empty values
The classes modified by this commit are `DoubleValue`, `LongValue`, and
`TimeValue`. Both `null` and empty strings provided to their
constructors fail, but they provide very different error messages
(NullPointerException and StringIndexOutOfBoundsException), which is
neither sensible nor helpful in debugging.
This commit adds a guard to throw `IllegalArgumentException` for both
cases in order to improve coherency and usefulness of the error
messages.
fix checkstyle issues

b0032 Heewon Lee 2024-02-14 07:34:40

support oracle alter table truncate partition (#1954)

feat: oracle alter table truncate partition
feat: oracle alter table truncate partition
feat: code format
feat: code format
Co-authored-by: mjh <majh118@chinaunicom.cn>

cc7aa mjh 2024-02-04 07:19:19

Build with Automatic-Module-Name for compatibility with the Java module system. (#1941)

92e02 Brian S. O'Neill 2024-01-06 14:04:45

Create maven_deploy.yml

b4070 Tobias 2023-12-28 22:31:54

corrected hopefully maven snapshot deployment

a70f0 Tobias Warneke 2023-12-28 22:20:08

corrected hopefully maven snapshot deployment

f0d3a Tobias Warneke 2023-12-28 22:17:43

finally done

6c1ca Tobias Warneke 2023-12-28 00:29:26

jsqlparser-4.8 (2023-12-28)

Features

support mysql with rollup (#1923) (77f6f jxnu-liguobin)
Support FOR SHARE (#1922) (815f8 jxnu-liguobin)
[MySQL] Support TABLE STATEMENT (#1921) (313a4 jxnu-liguobin)
Support RENAME INDEX for MySQL, RENAME CONSTRAINT for PostgreSQL (#1920) (989a8 jxnu-liguobin)
Add support comment in create view for MySQL and MariaDb (#1913) (4d47e jxnu-liguobin)
Add support for REFRESH MATERIALIZED VIEW (#1911) (425c7 jxnu-liguobin)
SimpleFunction for faster parsing of simple, but deep nested functions (085d7 Andreas Reichel)
add support for snowflake merge statements (#1887) (36b80 David Goss)
ColDataType supports PUBLIC schema and all non-restricted keywords for type (1088d Andreas Reichel)
T-SQL Join Hints (5f09e Andreas Reichel)
old TSQL Joins *= and =* (0b50d Andreas Reichel)
MS SQL Server Merge Output clause (7bd42 Andreas Reichel)
MS SQL Server UPDATE ... Index Hint (f919e Andreas Reichel)
Postgres Contains and ContainedBy Operators (28a4c Andreas Reichel)
Postgres Contains and ContainedBy Operators (09d6d Andreas Reichel)
Clickhouse GLOBAL IN ... (ced0d Andreas Reichel)
CREATE INDEX IF NOT EXISTS... (da13d Andreas Reichel)
support clickhouse global keyword in IN Expression (a9ed7 hezw)

Bug Fixes

refactor JsonExpression, avoiding expensive semantic lookahead and improving performance (56515 Andreas Reichel)
GO shall terminate statement only, when appearing alone on an empty line (14637 Andreas Reichel)
De-Parse Oracle Hints in UPDATE, INSERT, DELETE and MERGE (aaca0 Andreas Reichel)
UpdateSet shall not have brackets with single element only (15b9a Andreas Reichel)
make GLOBAL a restricted keyword, not usable as an Alias (dd6cf Andreas Reichel)
Postgres NextVal() function (e3afa Andreas Reichel)
optional Expression in FETCH clause (daee3 Andreas Reichel)
allow RAW as CreateParameter (ecd40 Andreas Reichel)

Other changes

problem with old sonatype repo?

66dd0 Tobias Warneke 2023-12-28 00:10:08

problem with old sonatype repo?

19bde Tobias Warneke 2023-12-27 22:50:54

problem with old sonatype repo?

d6b4c Tobias Warneke 2023-12-27 22:43:59

problem with old sonatype repo?

5ff53 Tobias Warneke 2023-12-27 00:54:26

6a327 Tobias Warneke 2023-12-26 23:15:57

npe in memory leak verifier

63955 Tobias Warneke 2023-12-26 23:01:20

allow reinitializing of javacc semanticize

44274 Tobias Warneke 2023-12-26 22:53:28

Allowed to build JSqlParser on slower computers by increasing a fixed timeout. This should take machine power into account.

806d3 Tobias Warneke 2023-12-26 20:31:48

upgraded some plugins

cff03 Tobias Warneke 2023-12-26 12:59:38

upgraded some plugins

256a1 Tobias Warneke 2023-12-25 23:53:18

upgraded some plugins

b2bd0 Tobias Warneke 2023-12-25 23:51:46

corrected license header of some files

23ba3 Tobias Warneke 2023-12-25 23:39:37

Update sphinx.yml

2974f manticore-projects 2023-12-16 07:13:01

Update sphinx.yml

a35fb manticore-projects 2023-12-16 04:42:01

Update build.gradle

546b3 manticore-projects 2023-12-15 09:14:49

Update build.gradle

48b3a manticore-projects 2023-12-15 09:11:51

Closed #1814, mysql and mariadb can use index type before ON (#1918)

b0aff jxnu-liguobin 2023-12-15 04:56:55

Fix conflict (#1915)

2ae1d jxnu-liguobin 2023-12-14 07:22:57

Fix typo in migration.rst (#1888)

Found a typo in the 4.7 migration document. Trivial PR. Please merge.

902e4 Ed Sabol 2023-11-10 03:05:39

Unit tests support multi-os and higher versions of jdk (#1886)

fix: tokenBlockPattern support \r\n or \r
test: remove nashorn ignore annotation to support jdk11+

97e92 human-user 2023-11-08 03:07:04

Support for Nested With Clauses Added

59104 MathewJoseph31 2023-09-12 12:01:59

Support for Array Contains (&>) and ContainedBy (<&) operator added

727c7 MathewJoseph31 2023-09-12 12:01:20

Support for postgres overlap operator && added, natural left/right/full outer joins added

6955c MathewJoseph31 2023-09-12 12:01:15

add support for index hints in Update statement for MySQL

9a67d joeqiao 2022-11-08 01:27:25

added support for T-SQL left and right joins (= and =)

786c8 Nico 2019-01-29 11:11:07

jsqlparser-4.7 (2023-09-02)

Breaking changes

add support for INTERPRET function parsing (#1816) (180ec Matteo Sist)
Remove ItemsList, MultiExpressionList, Replace (14170 Andreas Reichel)
Consolidate the ExpressionList, removing many redundant List alike Classes and Productions (288b1 Andreas Reichel)
remove SelectExpressionItem in favor of SelectItem (b9057 Andreas Reichel)
ClickHouse Select... ``FINAL` modifier (4b7f2 Andreas Reichel)

Features

H2 BYTEA Values X'01' '02' (54828 Andreas Reichel)
BigQuery Except(..) Replace(..) syntax (4b4ae Andreas Reichel)
implement a few missing expressions (04128 Andreas Reichel)
SQL:2016 TABLESAMPLE clause (4d8a5 Andreas Reichel)
add a method checking balanced brackets (52df3 Andreas Reichel)
add support for INTERPRET function parsing (#1816) (180ec Matteo Sist)
MySQL NOT RLIKE, NOT REGEXP expressions (f1325 Andreas Reichel)
Postgres NOTNULL support (386dc manticore-projects)
QUALIFY clause (75e4d Andreas Reichel)
T-SQL FOR ... clause (8027d Andreas Reichel)
Quoted Identifiers can contain double-quotes (PostgreSQL) (73c55 Andreas Reichel)
functions blocks, parenthesed JSON Expressions (5263b Andreas Reichel)
functions blocks, parenthesed JSON Expressions (e19dc Andreas Reichel)
parse CREATE TRIGGER as UnsupportedStatement (64b03 Andreas Reichel)
chaining JSON Expressions (6ef5e Andreas Reichel)
Write API documentation to the WebSite via XMLDoclet (c5366 Andreas Reichel)
MEMBER OF condition as shown at https://dev.mysql.com/doc/refman/8.0/en/json-search-functions.html#operator_member-of (6e7a7 Andreas Reichel)
access Elements of Array Columns (09a70 Andreas Reichel)
JdbcNamedParameter allows "&" (instead of ":") (c07a4 Andreas Reichel)
Consolidate the ExpressionList, removing many redundant List alike Classes and Productions (288b1 Andreas Reichel)
ClickHouse LIMIT ... BY ... clause (4d5e2 Andreas Reichel)
implement SQL:2016 Convert() and Trim() (3a27a Andreas Reichel)
Switch off contradicting JOIN qualifiers, when setting a qualifier (b6ea8 Andreas Reichel)
Test if a JOIN is an INNER JOIN according to the SQL:2016 (6281b Andreas Reichel)
ClickHouse Select... ``FINAL` modifier (4b7f2 Andreas Reichel)
Multi-Part Names for Variables and Parameters (9da7a Andreas Reichel)
Oracle HAVING before GROUP BY (4efb9 Andreas Reichel)
Lateral View (8a1bd Andreas Reichel)
FETCH uses EXPRESSION (0979b Andreas Reichel)
Support more Statement Separators (b0814 Andreas Reichel)
CREATE VIEW ... REFRESH AUTO... (1c8d8 Andreas Reichel)
Oracle Alternative Quoting (c57c4 Andreas Reichel)
make important Classes Serializable (b94b2 Andreas Reichel)

Bug Fixes

ExpressionList of Expressions in Values (994e6 Andreas Reichel)
check for NULL before iterating (beb68 Andreas Reichel)
Backslash escaped single quote '\'' (a2975 Andreas Reichel)
INSERT must use simple Column Names only (420d7 Andreas Reichel)
SPHINX modules and themes (6f277 Andreas Reichel)
expose IntervalExpression attributes and use DeParser (b6fab Andreas Reichel)
throw the specific exception (cb960 Andreas Reichel)
Complex Parsing Approach (4f048 Andreas Reichel)
issue #1789 (32ec5 Andreas Reichel)
issue #1789 (d20c8 Andreas Reichel)
issue #1791 (88d1b Andreas Reichel)
Java Version 8 (7cecd Andreas Reichel)
find the correct position when field belongs to an internal class (21389 Andreas Reichel)
Remove tests for (), since ParenthesedExpressionList will catch those too (905ef Andreas Reichel)
assign Enum case insensitive (fc577 Andreas Reichel)

Other changes

d45f2 Tobias Warneke 2023-09-01 22:07:49

Fixing a problem with an OP_CONCAT in WhenExpression (#1837)

fix: Concatenation in inner ELSE statement (Second level of Case Expression)
fix: broken tests
fix: Delete lookahead(3)

f05cb amigalev 2023-08-20 04:43:30

Update Gradle JavaCC parser to latest version (3.0.0) (#1843)

c59a0 Zbynek Konecny 2023-08-05 22:14:21

Update sql-parser-error.md

41d70 manticore-projects 2023-07-26 00:37:51

Update sql-parser-error.md

812c6 manticore-projects 2023-07-26 00:37:14

Update sql-parser-error.md

b34d3 manticore-projects 2023-07-25 00:09:05

Update sphinx.yml

fix the FURO theme

51cc4 manticore-projects 2023-06-01 02:49:23

Create gradle.yml

be7fc manticore-projects 2023-05-18 10:16:14

Update sphinx.yml

11323 manticore-projects 2023-05-14 13:10:16

0aa8a Tobias Warneke 2023-04-27 21:18:29

Fix #1758: Use long for Feature.timeOut (#1759)

Co-authored-by: Tobias <t.warneke@gmx.net>

3314e Tomasz Zarna 2023-04-27 20:30:31

Ignoring unnecessarily generated jacoco report (#1762)

Ignoring unnecessarily generated jacoco report
Ignoring unnecessarily generated by pmd plugin
Co-authored-by: other <other@ECE-A55006.austin.utexas.edu>
Co-authored-by: Tobias <t.warneke@gmx.net>

1bbb1 optimizing-ci-builds 2023-04-27 19:50:42

Ignoring unnecessarily generated by pmd plugin (#1763)

Co-authored-by: other <other@ECE-A55006.austin.utexas.edu>

52648 optimizing-ci-builds 2023-04-27 19:49:15

Refactor Parenthesed SelectBody and FromItem (#1754)

Fixes #1684: Support CREATE MATERIALIZED VIEW with AUTO REFRESH
Support parsing create view statements in Redshift with AUTO REFRESH
option.
Reduce cyclomatic complexity in CreateView.toString
Extract adding the force option into a dedicated method resulting in the
cyclomatic complexity reduction of the CreateView.toString method.
Enhanced Keywords
Add Keywords and document, which keywords are allowed for what purpose
Fix incorrect tests
Define Reserved Keywords explicitly
Derive All Keywords from Grammar directly
Generate production for Object Names (semi-) automatically
Add parametrized Keyword Tests
Fix test resources
Adjust Gradle to JUnit 5
Parallel Test execution
Gradle Caching
Explicitly request for latest JavaCC 7.0.10
Do not mark SpeedTest for concurrent execution
Remove unused imports
Adjust Gradle to JUnit 5
Parallel Test execution
Gradle Caching
Explicitly request for latest JavaCC 7.0.10
Do not mark SpeedTest for concurrent execution
Remove unused imports
Sphinx Documentation
Update the MANTICORE Sphinx Theme, but ignore it in GIT
Add the content to the Sphinx sites
Add a Gradle function to derive Stable and Snapshot version from GIT Tags
Add a Gradle GIT change task
Add a Gradle sphinx task
Add a special Test case for illustrating the use of JSQLParser
doc: request for `Conventional Commit` messages
feat: make important Classes Serializable
Implement Serializable for persisting via ObjectOutputStream
chore: Make Serializable
doc: Better integration of the RR diagrams
- apply neutral Sphinx theme
- insert the RR diagrams into the sphinx sources
- better documentation on Gradle dependencies
- link GitHub repository
Merge
feat: Oracle Alternative Quoting
- add support for Oracle Alternative Quoting e.g. `q'(...)'`
- fixes #1718
- add a Logo and FavIcon to the Website
- document recent changes on Quoting/Escaping
- add an example on building SQL from Java
- rework the README.md, promote the Website
- add Spotless Formatter, using Google Java Style (with Tab=4 Spaces)
style: Appease PMD/Codacy
doc: fix the issue template
- fix the issue template
- fix the -SNAPSHOT version number
Update issue templates
Update issue templates
feat: Support more Statement Separators
- `GO`
- Slash `/`
- Two empty lines
feat: FETCH uses EXPRESSION
- `FETCH` uses `EXPRESSION` instead of SimpleJDBCParameter only
- Visit/Accept `FETCH` `EXPRESSION` instead of `append` to String
- Visit/Accept `OFFSET` `EXPRESSION` instead of `append` to String
- Gradle: remove obsolete/incompatible `jvmArgs` from Test()
style: apply Spotless
test: commit missing test
fix: JSon Operator can use Simple Function
Supports `Function() ->> Literal` (although `Function()` would not allow Nested Expression Parameters)
fixes #1571
style: Reformat changed files and headers
style: Remove unused variable
feat: Add support for Hangul "\uAC00"-"\uD7A3"
fixes #1747
style: expose `SetStatement` key-value list
fixes #1746
style: Appease PMD/Codacy
feat: `ConflictTarget` allows multiple `IndexColumnNames`
fixes #1749
fixes #1633
fixes #955
doc: fix reference in the Java Doc
build: better Upload Groovy Task
feat: ParenthesedSelectBody and ParenthesedFromItem
- First properly working version
- Work in progress, 13 tests failing
feat: ParenthesedSelectBody and ParenthesedFromItem
- delete unneeded ParenthesedJoin
- rename ParenthesisFromItem into ParenthesedFromItem
feat: ParenthesedSelectBody and ParenthesedFromItem
- fix `NULLS FIRST` and `NULLS LAST`
feat: ParenthesedSelectBody and ParenthesedFromItem
- fix Oracle Hints
feat: ParenthesedSelectBody and ParenthesedFromItem
- parse `SetOperation` only after a (first plain) SelectBody has found, this fixes the performance issue
- one more special Oracle Test succeeds
- 5 remaining test failures
feat: ParenthesedSelectBody and ParenthesedFromItem
- extract `OrderByElements` into `SelectBody`
- one more special Oracle Test succeeds
- all tests succeed
style: Appease PMD/Codacy
style: Appease PMD/Codacy
feat: Refactor SelectBody implementations
- `SelectBody` implements `FromItem`
- get rid of `SubSelect` and `SpecialSubSelect`
- `Merge` can use `FromItem` instead of `SubSelect` or `Table`
- `LateralSubSelect` extends `ParenthesedSelectBody` directly
- Simplify the `Select` statement, although it is still redundant since `SelectBody` also could implement `Statement` directly
- `WithItem` can use `SelectBody` directly, which allows for nested `WithItems`
BREAKING-CHANGE: Lots of redundant methods and intermediate removed
feat: Refactor SelectBody implementations
- `SelectBody` implements `Statement` and so makes `Select` redundant
- get rid of `ValuesList`
- refactor `ValuesStatement` into `Values` which just implements `SelectBody` (and becomes a `Statement` and a `FromItem`), move to `select` package
BREAKING-CHANGE: Lots of redundant methods and intermediate removed
style: Code cleanup
- remove 3 unused/obsolete productions
- appease PMD/Codacy
feat: Merge `SelectBody` into `Select` Statement
- former `SelectBody` implements `Statement` and so becomes `Select`
- this reduces the AST by 1 hierarchy level
style: Remove unused import
test: @Disabled invalid Test
style: Appease PMD/Codacy
test: Add a SubSelect Parsing Test
Co-authored-by: zaza <tzarna@gmail.com>

a312d manticore-projects 2023-04-27 19:38:24

c1c92 Tobias Warneke 2023-04-01 19:54:09

Assorted Fixes #7 (#1745)

Fixes #1684: Support CREATE MATERIALIZED VIEW with AUTO REFRESH
Support parsing create view statements in Redshift with AUTO REFRESH
option.
Reduce cyclomatic complexity in CreateView.toString
Extract adding the force option into a dedicated method resulting in the
cyclomatic complexity reduction of the CreateView.toString method.
Enhanced Keywords
Add Keywords and document, which keywords are allowed for what purpose
Fix incorrect tests
Define Reserved Keywords explicitly
Derive All Keywords from Grammar directly
Generate production for Object Names (semi-) automatically
Add parametrized Keyword Tests
Fix test resources
Adjust Gradle to JUnit 5
Parallel Test execution
Gradle Caching
Explicitly request for latest JavaCC 7.0.10
Do not mark SpeedTest for concurrent execution
Remove unused imports
Adjust Gradle to JUnit 5
Parallel Test execution
Gradle Caching
Explicitly request for latest JavaCC 7.0.10
Do not mark SpeedTest for concurrent execution
Remove unused imports
Sphinx Documentation
Update the MANTICORE Sphinx Theme, but ignore it in GIT
Add the content to the Sphinx sites
Add a Gradle function to derive Stable and Snapshot version from GIT Tags
Add a Gradle GIT change task
Add a Gradle sphinx task
Add a special Test case for illustrating the use of JSQLParser
doc: request for `Conventional Commit` messages
feat: make important Classes Serializable
Implement Serializable for persisting via ObjectOutputStream
chore: Make Serializable
doc: Better integration of the RR diagrams
- apply neutral Sphinx theme
- insert the RR diagrams into the sphinx sources
- better documentation on Gradle dependencies
- link GitHub repository
Merge
feat: Oracle Alternative Quoting
- add support for Oracle Alternative Quoting e.g. `q'(...)'`
- fixes #1718
- add a Logo and FavIcon to the Website
- document recent changes on Quoting/Escaping
- add an example on building SQL from Java
- rework the README.md, promote the Website
- add Spotless Formatter, using Google Java Style (with Tab=4 Spaces)
style: Appease PMD/Codacy
doc: fix the issue template
- fix the issue template
- fix the -SNAPSHOT version number
Update issue templates
Update issue templates
feat: Support more Statement Separators
- `GO`
- Slash `/`
- Two empty lines
feat: FETCH uses EXPRESSION
- `FETCH` uses `EXPRESSION` instead of SimpleJDBCParameter only
- Visit/Accept `FETCH` `EXPRESSION` instead of `append` to String
- Visit/Accept `OFFSET` `EXPRESSION` instead of `append` to String
- Gradle: remove obsolete/incompatible `jvmArgs` from Test()
style: apply Spotless
test: commit missing test
fix: JSon Operator can use Simple Function
Supports `Function() ->> Literal` (although `Function()` would not allow Nested Expression Parameters)
fixes #1571
style: Reformat changed files and headers
style: Remove unused variable
feat: Add support for Hangul "\uAC00"-"\uD7A3"
fixes #1747
style: expose `SetStatement` key-value list
fixes #1746
style: Appease PMD/Codacy
feat: `ConflictTarget` allows multiple `IndexColumnNames`
fixes #1749
fixes #1633
fixes #955
doc: fix reference in the Java Doc
build: better Upload Groovy Task
Co-authored-by: zaza <tzarna@gmail.com>

31ef1 manticore-projects 2023-03-21 22:04:58

disable xml report (#1748)

Co-authored-by: other <other@ECE-A55006.austin.utexas.edu>

476d9 optimizing-ci-builds 2023-03-21 21:58:25

Assorted Fixes #6 (#1740)

Fixes #1684: Support CREATE MATERIALIZED VIEW with AUTO REFRESH
Support parsing create view statements in Redshift with AUTO REFRESH
option.
Reduce cyclomatic complexity in CreateView.toString
Extract adding the force option into a dedicated method resulting in the
cyclomatic complexity reduction of the CreateView.toString method.
Enhanced Keywords
Add Keywords and document, which keywords are allowed for what purpose
Fix incorrect tests
Define Reserved Keywords explicitly
Derive All Keywords from Grammar directly
Generate production for Object Names (semi-) automatically
Add parametrized Keyword Tests
Fix test resources
Adjust Gradle to JUnit 5
Parallel Test execution
Gradle Caching
Explicitly request for latest JavaCC 7.0.10
Do not mark SpeedTest for concurrent execution
Remove unused imports
Adjust Gradle to JUnit 5
Parallel Test execution
Gradle Caching
Explicitly request for latest JavaCC 7.0.10
Do not mark SpeedTest for concurrent execution
Remove unused imports
Sphinx Documentation
Update the MANTICORE Sphinx Theme, but ignore it in GIT
Add the content to the Sphinx sites
Add a Gradle function to derive Stable and Snapshot version from GIT Tags
Add a Gradle GIT change task
Add a Gradle sphinx task
Add a special Test case for illustrating the use of JSQLParser
doc: request for `Conventional Commit` messages
feat: make important Classes Serializable
Implement Serializable for persisting via ObjectOutputStream
chore: Make Serializable
doc: Better integration of the RR diagrams
- apply neutral Sphinx theme
- insert the RR diagrams into the sphinx sources
- better documentation on Gradle dependencies
- link GitHub repository
Merge
feat: Oracle Alternative Quoting
- add support for Oracle Alternative Quoting e.g. `q'(...)'`
- fixes #1718
- add a Logo and FavIcon to the Website
- document recent changes on Quoting/Escaping
- add an example on building SQL from Java
- rework the README.md, promote the Website
- add Spotless Formatter, using Google Java Style (with Tab=4 Spaces)
style: Appease PMD/Codacy
doc: fix the issue template
- fix the issue template
- fix the -SNAPSHOT version number
Update issue templates
Update issue templates
feat: Support more Statement Separators
- `GO`
- Slash `/`
- Two empty lines
feat: FETCH uses EXPRESSION
- `FETCH` uses `EXPRESSION` instead of SimpleJDBCParameter only
- Visit/Accept `FETCH` `EXPRESSION` instead of `append` to String
- Visit/Accept `OFFSET` `EXPRESSION` instead of `append` to String
- Gradle: remove obsolete/incompatible `jvmArgs` from Test()
style: apply Spotless
test: commit missing test
feat: Unicode CJK Unified Ideographs (Unicode block)
fixes #1741
feat: Unicode CJK Unified Ideographs (Unicode block)
fixes #1741
feat: Functions with nested Attributes
Supports `SELECT schemaName.f1(arguments).f2(arguments).f3.f4` and similar constructs
fixes #1742
fixes #1050
Co-authored-by: zaza <tzarna@gmail.com>

adeed manticore-projects 2023-03-09 21:22:40

version 4.7-SNAPSHOT

74570 Tobias Warneke 2023-02-23 21:41:03

Update issue templates

4aeaf manticore-projects 2023-02-01 01:37:53

Update issue templates

46314 manticore-projects 2023-02-01 01:24:35

Sphinx Documentation

Update the MANTICORE Sphinx Theme, but ignore it in GIT
Add the content to the Sphinx sites
Add a Gradle function to derive Stable and Snapshot version from GIT Tags
Add a Gradle GIT change task
Add a Gradle sphinx task
Add a special Test case for illustrating the use of JSQLParser

2ef66 Andreas Reichel 2023-01-21 04:06:00

Define Reserved Keywords explicitly

Derive All Keywords from Grammar directly
Generate production for Object Names (semi-) automatically
Add parametrized Keyword Tests

f49e8 Andreas Reichel 2023-01-21 04:05:51

Adjust Gradle to JUnit 5

Parallel Test execution
Gradle Caching
Explicitly request for latest JavaCC 7.0.10

e960a Andreas Reichel 2023-01-21 04:05:51

Enhanced Keywords

Add Keywords and document, which keywords are allowed for what purpose

b5321 Andreas Reichel 2023-01-21 04:05:51

Remove unused imports

a016b Andreas Reichel 2023-01-21 04:05:51

Fix test resources

86f33 Andreas Reichel 2023-01-21 04:05:51

Do not mark SpeedTest for concurrent execution

67f79 Andreas Reichel 2023-01-21 04:05:51

Fix incorrect tests

5fae2 Andreas Reichel 2023-01-21 04:05:51

Remove unused imports

3ba54 Andreas Reichel 2023-01-21 04:05:51

Adjust Gradle to JUnit 5

Parallel Test execution
Gradle Caching
Explicitly request for latest JavaCC 7.0.10

2d51a Andreas Reichel 2023-01-21 04:05:51

Do not mark SpeedTest for concurrent execution

232af Andreas Reichel 2023-01-21 04:05:51

Reduce cyclomatic complexity in CreateView.toString

Extract adding the force option into a dedicated method resulting in the
cyclomatic complexity reduction of the CreateView.toString method.

ea447 zaza 2023-01-08 20:43:40

Fixes #1684: Support CREATE MATERIALIZED VIEW with AUTO REFRESH

Support parsing create view statements in Redshift with AUTO REFRESH
option.

74715 zaza 2022-12-11 20:03:52

jsqlparser-4.6 (2023-02-23)

Bug Fixes

add missing public Getter (#1632) (d2212 manticore-projects)

Other changes

actualized release plugin

9911a Tobias Warneke 2023-02-23 21:17:52

actualized release plugin

0b2c3 Tobias Warneke 2023-02-23 21:16:43

b07f7 Tobias Warneke 2023-02-23 19:50:39

Update build.gradle

35233 Tobias 2023-02-17 20:20:25

Update README.md

0b092 Tobias 2023-02-17 16:27:41

Oracle Alternative Quoting (#1722)

Fixes #1684: Support CREATE MATERIALIZED VIEW with AUTO REFRESH
Support parsing create view statements in Redshift with AUTO REFRESH
option.
Reduce cyclomatic complexity in CreateView.toString
Extract adding the force option into a dedicated method resulting in the
cyclomatic complexity reduction of the CreateView.toString method.
Enhanced Keywords
Add Keywords and document, which keywords are allowed for what purpose
Fix incorrect tests
Define Reserved Keywords explicitly
Derive All Keywords from Grammar directly
Generate production for Object Names (semi-) automatically
Add parametrized Keyword Tests
Fix test resources
Adjust Gradle to JUnit 5
Parallel Test execution
Gradle Caching
Explicitly request for latest JavaCC 7.0.10
Do not mark SpeedTest for concurrent execution
Remove unused imports
Adjust Gradle to JUnit 5
Parallel Test execution
Gradle Caching
Explicitly request for latest JavaCC 7.0.10
Do not mark SpeedTest for concurrent execution
Remove unused imports
Sphinx Documentation
Update the MANTICORE Sphinx Theme, but ignore it in GIT
Add the content to the Sphinx sites
Add a Gradle function to derive Stable and Snapshot version from GIT Tags
Add a Gradle GIT change task
Add a Gradle sphinx task
Add a special Test case for illustrating the use of JSQLParser
doc: request for `Conventional Commit` messages
feat: make important Classes Serializable
Implement Serializable for persisting via ObjectOutputStream
chore: Make Serializable
doc: Better integration of the RR diagrams
- apply neutral Sphinx theme
- insert the RR diagrams into the sphinx sources
- better documentation on Gradle dependencies
- link GitHub repository
Merge
feat: Oracle Alternative Quoting
- add support for Oracle Alternative Quoting e.g. `q'(...)'`
- fixes #1718
- add a Logo and FavIcon to the Website
- document recent changes on Quoting/Escaping
- add an example on building SQL from Java
- rework the README.md, promote the Website
- add Spotless Formatter, using Google Java Style (with Tab=4 Spaces)
style: Appease PMD/Codacy
doc: fix the issue template
- fix the issue template
- fix the -SNAPSHOT version number
Update issue templates
Update issue templates
feat: Support more Statement Separators
- `GO`
- Slash `/`
- Two empty lines
Co-authored-by: zaza <tzarna@gmail.com>

e71e5 manticore-projects 2023-02-07 20:18:52

Issue1673 case within brackets (#1675)

fix: add missing public Getter
Add public Getter for `updateSets`
Fixes #1630
fix: Case within brackets
fixes #1673

2ced7 manticore-projects 2023-01-31 20:56:01

Added support for SHOW INDEX from table (#1704)

Added support for SHOW INDEX from table
Added * import
fix for javadoc
added <doclint>none</doclint>

a2618 Jayant Kumar Yadav 2023-01-31 20:54:05

d33f6 Tobias Warneke 2023-01-22 15:43:07

Sphinx Website (#1624)

Enhanced Keywords
Add Keywords and document, which keywords are allowed for what purpose
Fix incorrect tests
Define Reserved Keywords explicitly
Derive All Keywords from Grammar directly
Generate production for Object Names (semi-) automatically
Add parametrized Keyword Tests
Fix test resources
Adjust Gradle to JUnit 5
Parallel Test execution
Gradle Caching
Explicitly request for latest JavaCC 7.0.10
Do not mark SpeedTest for concurrent execution
Remove unused imports
Adjust Gradle to JUnit 5
Parallel Test execution
Gradle Caching
Explicitly request for latest JavaCC 7.0.10
Do not mark SpeedTest for concurrent execution
Remove unused imports
Keyword test adopt JUnit5
Update keywords
CheckStyle sanitation of method names
Merge Master
Add Jupiter Parameters dependency again
Automate the `updateKeywords` Step
Update PMD and rules
Rewrite test expected to fail
Appease Codacy
Remove broken rule warning about perfectly fine switch-case statements
Force Changes
Fix Merge Issues
Read Tokens directly from the Grammar File without invoking JTREE
- read Tokens per REGEX Matcher
- move Reserved Keywords from Grammar into ParserKeywordsUtils
- adjust the Tests
Appease PMD/Codacy
Extract the Keywords from the Grammar by using JTRee (instead of Regex)
Add some tests to ensure, that all Keywords or found
Appease Codacy/PMD
Separate UpdateKeywords Task again
Including it into compileJavacc won't work since it depends on compiling the ParserKeywordUtils.java
Single file compilation did not work
Clean-up the imports
Add JavaCC dependency to Maven for building ParserKeywordsUtils
Add JavaCC dependency to Maven for building ParserKeywordsUtils
Merge Upstream
Merge Master
Fixes broken PR #1524 and Commit fb6e950ce0e62ebcd7a44ba9eea679da2b04b2ed
Add AST Visualization
Show the Statement's Java Objects in a tree hierarchy
Sphinx Documentation
Update the MANTICORE Sphinx Theme, but ignore it in GIT
Add the content to the Sphinx sites
Add a Gradle function to derive Stable and Snapshot version from GIT Tags
Add a Gradle GIT change task
Add a Gradle sphinx task
Add a special Test case for illustrating the use of JSQLParser
test: Document an additional Special Oracle test success
doc: ignore the autogenerated changelog.rst in GIT
build: temporarily reduce the Code Coverage requirements
Temporarily reduce the Coverage checks regarding Minimum Coverage and Maximum Missed Lines in order to get the Keywords PR accepted. We should do a major Code cleanup afterwards.
build: Clean-up the Gradle Build
Prefix the Sphinx Prolog Variables with JSQLPARSER in order to allow for build the Main Website for various projects
Remove some redundant version requests for PMD, CheckStyle and friends
Remove JUnit-4 dependency and add HarmCrest
Complete the PUBLISHING task
doc: Explain the ``updateKeywords`` Gradle Task
build: Un-escape the Unicode on the changelog file
build: Un-escape the Unicode on the changelog file
doc: Cleanup
Unescape unicode characters from Git Changelog
Remove obsolete code from Sphinx' conf.py
doc: Properly un-escape the Git Commit message
doc: request for `Conventional Commit` messages
doc: correctly refer to `RelObjectNameWithoutValue()`
build: upload the built files via Excec/SFTP
doc: Add an example on Token White-listing
doc: write the correct Git Repository
doc: pronounce the OVERLAPS example more
feat: make important Classes Serializable
Implement Serializable for persisting via ObjectOutputStream
doc: Add the "How to Use" java code
chore: Make Serializable
fix: Non-serializable field in serializable class
build: various fixes to the Maven build file
add the Keywords Documentation file to the task
exclude the Sphinx files from the license header plugin
fix the JavaDoc plugin options
build: add the Keywords Documentation file to the task
doc: add a page about actually Reserved Keywords
build: avoid PMD/Codacy for Sphinx Documentation
update Changelog
build: Add Sphinx GitHub Action
Add a GitHub Action, which will
- Install Sphinx and Extensions
- Install Gradle Wrapper
- Run Gradle Wrapper Task `sphinx`
- Deploy the generated static HTML site to GH Pages
fix: fix a merge error, brackets
fix: remove JavaCC dependency
Parse Tokens via Regex
Move JavaCC Token Parser into the KeywordsTest
Make JavaCC a Test Dependency only
doc: Fix Maven Artifact Version
style: Avoid throwing raw exception types.
style: Avoid throwing raw exception types.
doc: Better integration of the RR diagrams
- apply neutral Sphinx theme
- insert the RR diagrams into the sphinx sources
- better documentation on Gradle dependencies
- link GitHub repository
build: gradle, execute all Checks after Test
Co-authored-by: Tobias <t.warneke@gmx.net>

be8e7 manticore-projects 2023-01-20 21:45:35

Assorted Fixes #5 (#1715)

refactor: Merge REPLACE into UPSERT
fixes #1706
feat: `DROP TEMPORARY TABLE ...`
fixes #1712
build: PMD compliance
ci: Merge master
feat: Configurable backslash `` escaping
- Enables `` as escape character in String Literals (beside SQL:2016 compliant `'`)
- Default is OFF (since its not SQL:2016 compliant)
- Activate per Parser Feature
- Fixes #1638
- Fixes #1209
- Fixes #1173
- Fixes #1172
- Fixes #832
- Fixes #827
- Fixes #578
BREAKING-CHANGE: Backslash Escaping needs to be activated explicitly or else Backslash won't work as Escape Character.
style: Checkstyle
style: remove dead code
style: PMD compliance
style: Checkstyle, unused import
feat: allow `S_CHAR_LITERAL` to break lines
- fixes #875

a00d7 manticore-projects 2023-01-20 21:32:20

Support DROP MATERIALIZED VIEW statements (#1711)

1af68 Tomasz Zarna 2023-01-12 21:37:42

corrected readme

4dfd2 Tobias Warneke 2023-01-04 21:07:17

Update README.md

lgtm removed

954b8 Tobias 2022-12-27 10:34:18

Fix #1686: add support for creating views with "IF NOT EXISTS" clause (#1690)

0f34f Tomasz Zarna 2022-12-22 21:52:35

Assorted Fixes #4 (#1676)

support clickhouse global keyword in join
fix: add missing public Getter
Add public Getter for `updateSets`
Fixes #1630
feat: Clickhouse GLOBAL JOIN
All credits to @julianzlzhang
fixes #1615
fixes #1535
feat: IF/ELSE statements supports Block
Make `If... Else...` statements work with Blocks
Make `Statement()` production work with `Block()`
Rewrite the `Block()` related Unit Tests
fixes #1682
fix: Revert unintended changes to the Special Oracle Tests
fix: `SET` statement supports `UserVariable`
Make `SetStatement` parse Objects instead of Names only
Add Grammar to accept `UserVariable` (e.g. "set @Flag = 1")
Add Test Case for `UserVariable`
fixes #1682
feat: Google Spanner Support
Replaces PR #1415, all credit goes to @s13o
Re-arranged some recently added Tokens in alphabetical order
Update Keywords
fix: fix JSonExpression, accept Expressions
Make JSonExpression accept Expressions
Add Testcase
Expose Idents() and Operators()
Fixes #1696
test: add Test for Issue #1237
Co-authored-by: Zhang Zhongliang <zhangzhongliang@xiaomi.com>

8d9db manticore-projects 2022-12-22 21:17:55

Fixed download war script in the renderRR task (#1659)

Co-authored-by: Hai Chang <haichang@microsoft.com>

08a92 haha1903 2022-12-10 09:23:53

Assorted fixes (#1666)

fix: add missing public Getter
Add public Getter for `updateSets`
Fixes #1630
feat: LISTAGG() with OVER() clause
fixes issue #1652
fixes 3 more Special Oracle Tests
fix: White-list CURRENT_DATE and CURRENT_TIMESTAMP tokens
allows CURRENT_DATE(3) and CURRENT_TIMESTAMP(3) as regular functions
fixes #1507
fixes #1607
feat: Deparser for Expression Lists
Visit each Expression of a List instead ExpressionList.toString()
fixes #1608
fix: Lookahead needed

bff26 manticore-projects 2022-11-20 10:06:01

Fix parsing statements with multidimensional array PR2 (#1665)

Fix parsing statements with multidimensional array
fix: Whitelist LOCKED keyword
Co-authored-by: Andrei Lisouski <alisousk@akamai.com>

e1865 manticore-projects 2022-11-20 09:59:26

removed disabled from Keyword tests and imports

af6c2 Tobias Warneke 2022-11-02 23:02:38

removed disabled from Keyword tests

89a9a Tobias Warneke 2022-11-02 22:58:19

8a018 Tobias Warneke 2022-10-28 22:30:25

67de4 Tobias Warneke 2022-10-25 23:26:28

Enhanced Keywords (#1382)

Enhanced Keywords
Add Keywords and document, which keywords are allowed for what purpose
Fix incorrect tests
Define Reserved Keywords explicitly
Derive All Keywords from Grammar directly
Generate production for Object Names (semi-) automatically
Add parametrized Keyword Tests
Fix test resources
Adjust Gradle to JUnit 5
Parallel Test execution
Gradle Caching
Explicitly request for latest JavaCC 7.0.10
Do not mark SpeedTest for concurrent execution
Remove unused imports
Adjust Gradle to JUnit 5
Parallel Test execution
Gradle Caching
Explicitly request for latest JavaCC 7.0.10
Do not mark SpeedTest for concurrent execution
Remove unused imports
Keyword test adopt JUnit5
Update keywords
CheckStyle sanitation of method names
Merge Master
Add Jupiter Parameters dependency again
Automate the `updateKeywords` Step
Update PMD and rules
Rewrite test expected to fail
Appease Codacy
Remove broken rule warning about perfectly fine switch-case statements
Force Changes
Fix Merge Issues
Read Tokens directly from the Grammar File without invoking JTREE
- read Tokens per REGEX Matcher
- move Reserved Keywords from Grammar into ParserKeywordsUtils
- adjust the Tests
Appease PMD/Codacy
Extract the Keywords from the Grammar by using JTRee (instead of Regex)
Add some tests to ensure, that all Keywords or found
Appease Codacy/PMD
Separate UpdateKeywords Task again
Including it into compileJavacc won't work since it depends on compiling the ParserKeywordUtils.java
Single file compilation did not work
Clean-up the imports
Add JavaCC dependency to Maven for building ParserKeywordsUtils
Add JavaCC dependency to Maven for building ParserKeywordsUtils
Merge Upstream
Merge Master
Fixes broken PR #1524 and Commit fb6e950ce0e62ebcd7a44ba9eea679da2b04b2ed
Add AST Visualization
Show the Statement's Java Objects in a tree hierarchy
build: temporarily reduce the Code Coverage requirements
Temporarily reduce the Coverage checks regarding Minimum Coverage and Maximum Missed Lines in order to get the Keywords PR accepted. We should do a major Code cleanup afterwards.
build: JSQLParser is a build dependency
chore: Update keywords
feat: add line count to output

4863e manticore-projects 2022-10-25 23:15:32

#1610 Support for SKIP LOCKED tokens on SELECT statements (#1649)

Co-authored-by: Lucas Dillmann <lucas.dillmann@totvs.com.br>

e6d50 Lucas Dillmann 2022-10-25 22:59:09

Assorted fixes (#1646)

fix: add missing public Getter
Add public Getter for `updateSets`
Fixes #1630
fix: Assorted Fixes
SelectExpressionItem with Function and Complex Parameters
Tables with Oracle DB Links
Make Table Name Parts accessible
Fixes #1644
Fixes #1643
fix: Revert correct test case

15ff8 manticore-projects 2022-10-16 20:15:36

actualized multiple dependencies

34502 Tobias Warneke 2022-09-28 20:17:35

Bump h2 from 1.4.200 to 2.1.210 (#1639)

Bumps h2 from 1.4.200 to 2.1.210.
- Release notes
- Commits
updated-dependencies:
- dependency-name: com.h2database:h2
dependency-type: direct:development
...
Signed-off-by: dependabot[bot] <support@github.com>
Signed-off-by: dependabot[bot] <support@github.com>
Co-authored-by: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com>

fc3c4 dependabot[bot] 2022-09-28 19:52:31

Support BigQuery SAFE_CAST (#1622) (#1634)

Co-authored-by: Zhang, Dequn <deqzhang@paypal.com>

d9985 dequn 2022-09-20 18:22:25

Support timestamptz dateliteral (#1621)

support timestamptz as datetime literal
rename test

81a64 Todd Pollak 2022-08-31 20:31:44

fixes #1617

b0aae Tobias Warneke 2022-08-31 20:22:25

fixes #419

427e9 Tobias Warneke 2022-08-31 19:01:57

Closes #1604, added simple OVERLAPS support (#1611)

236a5 Rob Audenaerde 2022-08-16 08:21:03

Fixes PR #1524 support hive alter sql (#1609)

Adjust Gradle to JUnit 5
Parallel Test execution
Gradle Caching
Explicitly request for latest JavaCC 7.0.10
Do not mark SpeedTest for concurrent execution
Remove unused imports
Adjust Gradle to JUnit 5
Parallel Test execution
Gradle Caching
Explicitly request for latest JavaCC 7.0.10
Do not mark SpeedTest for concurrent execution
Remove unused imports
Fixes broken PR #1524 and Commit fb6e950ce0e62ebcd7a44ba9eea679da2b04b2ed

2619c manticore-projects 2022-08-14 16:29:18

#1524 support hive alter sql : ALTER TABLE name ADD COLUMNS (col_spec[, col_spec ...]) (#1605)

Co-authored-by: zhum@aotain.com <zm7705264>

fb6e9 Zhumin-lv-wn 2022-08-03 20:56:44

fixes #1581

732e8 Tobias Warneke 2022-07-25 06:43:39

Using own Feature - constant for "delete with returning" #1597 (#1598)

d3218 gitmotte 2022-07-25 04:55:20

2f491 Tobias Warneke 2022-07-22 23:19:59

jsqlparser-4.5 (2022-07-22)

Other changes

introduced changelog generator

e0f0e Tobias Warneke 2022-07-22 22:47:00

fixes #1596

60d64 Tobias Warneke 2022-07-22 22:31:12

integrated test for #1595

b3927 Tobias Warneke 2022-07-19 22:04:18

09830 Tobias Warneke 2022-07-19 21:44:43

reduced time to parse exception to minimize impact on building time

191b9 Tobias Warneke 2022-07-19 21:40:35

add support for drop column if exists (#1594)

fcfdf rrrship 2022-07-19 21:38:40

PostgreSQL INSERT ... ON CONFLICT Issue #1551 (#1552)

Adjust Gradle to JUnit 5
Parallel Test execution
Gradle Caching
Explicitly request for latest JavaCC 7.0.10
Do not mark SpeedTest for concurrent execution
Remove unused imports
Adjust Gradle to JUnit 5
Parallel Test execution
Gradle Caching
Explicitly request for latest JavaCC 7.0.10
Do not mark SpeedTest for concurrent execution
Remove unused imports
Adjust Gradle to JUnit 5
Parallel Test execution
Gradle Caching
Explicitly request for latest JavaCC 7.0.10
Do not mark SpeedTest for concurrent execution
Remove unused imports
Adjust Gradle to JUnit 5
Parallel Test execution
Gradle Caching
Explicitly request for latest JavaCC 7.0.10
Do not mark SpeedTest for concurrent execution
Remove unused imports
Support Postgres INSERT ... ON CONFLICT
Fixes #1551
Refactor UpdateSet.toString(), which is used by Insert and Update
Allow KEEP keyword
Enables special Oracle Test keywordasidentifier04.sql, now 191 tests succeed
Sanitize before push
Tweak Grammar in order to survive the Maven Build
Ammend the README
Move Plugin configuration files to the CONFIG folder (hoping, that Codacy will find it there)
Update PMD in the Maven configuration
Update PMD in the Maven and Gradle configuration
Appease Codacy
Co-authored-by: Tobias <t.warneke@gmx.net>

5ae09 manticore-projects 2022-07-19 21:18:02

Configurable Parser Timeout via Feature (#1592)

Configurable Parser Timeout via Feature
Fixes #1582
Implement Parser Timeout Feature, e. g. `CCJSqlParserUtil.parse(sqlStr, parser -> parser.withTimeOut(60000));`
Add a special test failing after a long time only, to test TimeOut vs. Parser Exception
Appease Codacy
Appease Codacy
Co-authored-by: Tobias <t.warneke@gmx.net>

74000 manticore-projects 2022-07-19 20:48:49

fixes #1590

cfba6 Tobias Warneke 2022-07-19 20:26:19

fixes #1590

1abaf Tobias Warneke 2022-07-19 20:17:50

extended support Postgres' Extract( field FROM source) where field is a String instead of a Keyword (#1591)

Fixes #1582
Amend the ExtractExpression
Add Test case for issue #1582
Amend the README

2b3ce manticore-projects 2022-07-19 19:25:23

87a37 Tobias Warneke 2022-07-14 19:30:27

26545 Tobias Warneke 2022-07-14 19:23:39

Closes #1579. Added ANALYZE

support. (#1587)

e5c8a Rob Audenaerde 2022-07-14 19:22:47

b4a5c Tobias Warneke 2022-07-14 19:01:29

b08f2 Tobias Warneke 2022-07-14 18:56:19

Closes #1583:: Implement Postgresql optional TABLE in TRUNCATE (#1585)

Closes #1583
Closes #1583, removed unnecessary local variable.
Closes #1583, proper support for deparsing.

26248 Rob Audenaerde 2022-07-14 18:55:44

6b242 Tobias Warneke 2022-07-14 18:53:41

Support table option character set and index options (#1586)

Support table option character set and index options
Signed-off-by: luofei <luoffei@outlook.com>
move test
Signed-off-by: luofei <luoffei@outlook.com>

27cdf luofei 2022-07-14 18:46:14

corrected a last minute bug

afbaf Tobias Warneke 2022-07-09 15:28:17

corrected a last minute bug

f3d2b Tobias Warneke 2022-07-09 15:25:36

corrected a last minute bug

8378e Tobias Warneke 2022-07-09 15:23:50

fixes #1576

48ea0 Tobias Warneke 2022-07-09 14:26:07

added simple test for #1580

5fdab Tobias Warneke 2022-07-07 20:13:12

disabled test for large cnf expansion and stack overflow problem

d3000 Tobias Warneke 2022-07-07 19:30:37

Add test for LikeExpression.setEscape and LikeExpression.getStringExpression (#1568)

Add test for LikeExpression.setEscape and LikeExpression.getStringExpression
like + set escape test for $ as escape character

bcf6f Caro 2022-07-07 19:27:43

a8a05 Tobias Warneke 2022-07-06 20:22:51

add support for postgres drop function statement (#1557)

964fa rrrship 2022-07-06 20:06:09

afbb5 Tobias Warneke 2022-07-06 19:53:35

Add support for Hive dialect GROUPING SETS. (#1539)

Add support for Hive GROUPING SETS dialect `GROUP BY a, b, c GROUPING SETS ((a, b), (a, c))`
Simplify HiveTest::testGroupByGroupingSets.

03c58 chenwl 2022-07-06 19:40:41

fixes #1566

886f0 Tobias Warneke 2022-06-28 20:55:12

Postgres NATURAL LEFT/RIGHT joins (#1560)

Postgres NATURAL LEFT/RIGHT joins
Fixes #1559
Make NATURAL an optional Join Keyword, which can be combined with LEFT, RIGHT, INNER
Add tests
Postgres NATURAL LEFT/RIGHT joins
Amend readme
Revert successful Oracle test

74a0f manticore-projects 2022-06-28 20:15:34

compound statement tests (#1545)

c1c38 Matthew Rathbone 2022-06-08 19:11:08

Allow isolation keywords as column name and aliases (#1534)

fc5a9 Tomer Shay (Shimshi) 2022-05-19 21:01:44

added github action badge

e4ec0 Tobias 2022-05-16 09:31:36

Create maven.yml

started maven build using github actions

b7e5c Tobias 2022-05-16 09:24:24

introduced deparser and toString correction for insert output clause

51105 Tobias Warneke 2022-05-15 22:07:19

revived compilable status after merge

75489 Tobias Warneke 2022-05-15 21:29:21

INSERT with SetOperations (#1531)

INSERT with SetOperations
Simplify the INSERT production
Use SetOperations for Select and Values
Better Bracket handling for WITH ... SELECT ...
Fixes #1491
INSERT with SetOperations
Appease Codazy/PMD
INSERT with SetOperations
Appease Codazy/PMD
Update Readme
List the changes
Minor rephrases
Correct the Maven Artifact Example
Fix the two test cases (missing white space)
Remove unused import

b5672 manticore-projects 2022-05-15 20:29:06

#1516 rename without column keyword (#1533)

Adjust Gradle to JUnit 5
Parallel Test execution
Gradle Caching
Explicitly request for latest JavaCC 7.0.10
Do not mark SpeedTest for concurrent execution
Remove unused imports
Adjust Gradle to JUnit 5
Parallel Test execution
Gradle Caching
Explicitly request for latest JavaCC 7.0.10
Do not mark SpeedTest for concurrent execution
Remove unused imports
`RENAME ... TO ...` without `COLUMN` keyword
Fixes #1516

e8f07 manticore-projects 2022-05-11 20:44:34

Add support for ... ALTER COLUMN ... DROP DEFAULT (#1532)

de0e8 manticore-projects 2022-05-11 20:37:08

81caf Tobias Warneke 2022-05-11 20:15:28

#1527 DELETE ... RETURNING ... (#1528)

#1527 DELETE ... RETURNING ...
Fixes #1527
Add DELETE... RETURNING ... expression
Simplify INSERT ... RETURNING ... expression
Simply UPDATE ... RETURNING ... expression
TSQL Output Clause
According to https://docs.microsoft.com/en-us/sql/t-sql/queries/output-clause-transact-sql?view=sql-server-ver15
Implement Output Clause for INSERT, UPDATE and DELETE
Add Tests according the Microsoft Documentation
Appease Codacy/PMD

4d815 manticore-projects 2022-05-11 20:04:23

fixs #1520 (#1521)

f7f9d chiangcho 2022-05-11 19:51:47

22fef Tobias Warneke 2022-05-11 19:45:25

Unsupported statement (#1519)

Adjust Gradle to JUnit 5
Parallel Test execution
Gradle Caching
Explicitly request for latest JavaCC 7.0.10
Do not mark SpeedTest for concurrent execution
Remove unused imports
Adjust Gradle to JUnit 5
Parallel Test execution
Gradle Caching
Explicitly request for latest JavaCC 7.0.10
Do not mark SpeedTest for concurrent execution
Remove unused imports
Adjust Gradle to JUnit 5
Parallel Test execution
Gradle Caching
Explicitly request for latest JavaCC 7.0.10
Do not mark SpeedTest for concurrent execution
Remove unused imports
Adjust Gradle to JUnit 5
Parallel Test execution
Gradle Caching
Explicitly request for latest JavaCC 7.0.10
Do not mark SpeedTest for concurrent execution
Remove unused imports
Implement UnsupportedStatement
- Add Feature allowUnsupportedStatement, default=false
- Fully implement UnsupportedStatement for the Statement() production
- Partially implement UnsupportedStatement for the Statements() production, works only when UnsupportedStatement comes first
Revert unintended changes of the test resources
Reformat BLOCK production
Disable STATEMENTS() test, which will never fail and add comments to this regard

59bb9 manticore-projects 2022-05-11 19:23:35

fixes #1518

bc113 Tobias Warneke 2022-04-26 21:06:44

Update bug_report.md (#1512)

Focus more on the particular SQL Statement and the JSQLParser Version.
Link to the Online Formatter for testing.

13441 manticore-projects 2022-04-22 22:29:07

changed to allow #1481

0cc2a Tobias Warneke 2022-04-22 21:56:27

Performance Improvements (#1439)

Adjust Gradle to JUnit 5
Parallel Test execution
Gradle Caching
Explicitly request for latest JavaCC 7.0.10
Do not mark SpeedTest for concurrent execution
Remove unused imports
Adjust Gradle to JUnit 5
Parallel Test execution
Gradle Caching
Explicitly request for latest JavaCC 7.0.10
Do not mark SpeedTest for concurrent execution
Remove unused imports
Performance Improvements
Simplify the Primary Expression Production
Try to simple parse without Complex Expressions first, before parsing complex and slow (if supported by max nesting depth)
Add Test cases for issues #1397 and #1438
Update Libraries to its latest version
Remove JUnit 4 from Gradle
Appease PMD
Update Gradle Plugins to its latest versions
Let Parser timeout after 6 seconds and fail gently
Add a special test verifying the clean up after timeout
Revert unintended changes to the Test Resources
Appease PMD/Codacy
Correct the Gradle "+" dependencies
Bump version to 4.4.-SNAPSHOT
update build file
revert unwarranted changes in test files
strip the Exception Class Name from the Message
maxDepth = 10 collides with the Parser Timeout = 6 seconds
License Headers
Unused imports
Bump version to 4.5-SNAPSHOT
Reduce test loops to fit intothe timeout

181a2 manticore-projects 2022-04-14 21:18:18

jsqlparser-4.4 (2022-04-10)

Other changes

00b24 Tobias Warneke 2022-04-09 22:43:11

Json function Improvements (#1506)

Adjust Gradle to JUnit 5
Parallel Test execution
Gradle Caching
Explicitly request for latest JavaCC 7.0.10
Do not mark SpeedTest for concurrent execution
Remove unused imports
Adjust Gradle to JUnit 5
Parallel Test execution
Gradle Caching
Explicitly request for latest JavaCC 7.0.10
Do not mark SpeedTest for concurrent execution
Remove unused imports
Improve JSON Functions
Space around the `:` delimiter of JSON Functions
Improve JSON Functions
Enforce `KEY` as `S_CHAR_LITERAL`
Allow `Column` as `VALUE`
Temporarily disable Postgres Syntax
Improve JSON Functions
Bring back Postgres Syntax
Enable MySQL Syntax JSON_OBJECT(key, value [, key, value, ...])
Fix some more tests, where key was not a String
Appease Codacy
Let JSON_OBJECT accept Expressions as value
set Version = 4.4-SNAPSHOT

e3f53 manticore-projects 2022-04-09 22:37:36

fixes #1505

41c77 Tobias Warneke 2022-04-09 21:16:45

f3fac Tobias Warneke 2022-04-09 20:20:23

fixes #1502

fea85 Tobias Warneke 2022-04-09 20:10:41

Issue1500 - Circular References in AllColumns and AllTableColumns (#1501)

Adjust Gradle to JUnit 5
Parallel Test execution
Gradle Caching
Explicitly request for latest JavaCC 7.0.10
Do not mark SpeedTest for concurrent execution
Remove unused imports
Adjust Gradle to JUnit 5
Parallel Test execution
Gradle Caching
Explicitly request for latest JavaCC 7.0.10
Do not mark SpeedTest for concurrent execution
Remove unused imports
Remove circular reference revealed by issue #1500
Add test for Issue 1500 Circular reference for All Columns Expression
Fix Test case
Add Test for AllTableColumn due to similar circular reference
Remove similar circular reference from AllTableColumn
Update dependencies
Adjust Jacoco Missed Lines count

0949d manticore-projects 2022-04-03 18:51:35

62677 Tobias Warneke 2022-04-02 23:59:19

Optimize assertCanBeParsedAndDeparsed (#1389)

Optimize assertCanBeParsedAndDeparsed
- Avoid redundant calls of buildSqlString()
- Replace String.replaceAll() with Matcher.replaceAll() based on precompiled Regex Patterns
Reset the testcase results

ea316 manticore-projects 2022-04-02 22:40:09

Add geometry distance operator (#1493)

Add support for geometry distance operators in PostGIS.
Fix missing imports.
Co-authored-by: Thomas Powell <tpowell@palantir.com>

98c47 Thomas Powell 2022-04-02 22:31:08

Support WITH TIES option in TOP #1435 (#1479)

Support WITH TIES option in TOP
- Add the support of WITH TIES option in SELECT TOP statement.
add specific test

1756a Olivier Cavadenti 2022-04-02 21:26:54

fixes #1482

7ddb7 Tobias Warneke 2022-03-15 21:51:56

fixes #1482

251cc Tobias Warneke 2022-03-15 21:48:13

Extending CaseExpression, covering #1458 (#1459)

Add unit tests for Case expressions.
More tests for CaseExpression.
Switch expression becomes an Expression instead of a Condition.
It allows complex expressions in the switch, similarly to what is allowed in when clauses.

4df13 Mathieu Goeminne 2022-03-15 20:07:43

fixes #1471

3695e Tobias Warneke 2022-02-18 23:03:24

fixes #1471

e789c Tobias Warneke 2022-02-18 22:32:04

fixes #1470

c7075 Tobias Warneke 2022-02-06 22:21:12

Add support for IS DISTINCT FROM clause (#1457)

Co-authored-by: Tomer Shay <tomer@Tomers-MBP.lan>

31ed3 Tomer Shay (Shimshi) 2022-01-18 07:01:14

fix fetch present in the end of union query (#1456)

6e632 chiangcho 2022-01-18 07:00:14

added SQL_CACHE implementation and changed

cf012 Tobias Warneke 2022-01-09 12:16:39

support for db2 with ru (#1446)

3e976 chiangcho 2021-12-20 22:50:56

13878 Tobias Warneke 2021-12-12 15:37:58

jsqlparser-4.3 (2021-12-12)

Other changes

updated readme.md to show all changes for version 4.3

f0396 Tobias Warneke 2021-12-12 15:20:32

Adjust Gradle to JUnit 5 (#1428)

Adjust Gradle to JUnit 5
Parallel Test execution
Gradle Caching
Explicitly request for latest JavaCC 7.0.10
Do not mark SpeedTest for concurrent execution
Remove unused imports

af7bc manticore-projects 2021-11-28 21:43:10

corrected some maven plugin versions

0acb2 Tobias Warneke 2021-11-28 21:40:56

fixes #1429

bc891 Tobias Warneke 2021-11-23 06:29:25

closes #1427

46424 Tobias Warneke 2021-11-21 19:42:11

CreateTableTest

50ef7 Tobias Warneke 2021-11-21 12:21:21

Support EMIT CHANGES for KSQL (#1426)

- Add the EMIT CHANGES syntax used in KSQL.

f6c17 Olivier Cavadenti 2021-11-21 12:20:56

SelectTest.testMultiPartColumnNameWithDatabaseNameAndSchemaName

d8735 Tobias Warneke 2021-11-21 12:17:29

reformatted test source code

fb455 Tobias Warneke 2021-11-21 12:11:43

organize imports

31921 Tobias Warneke 2021-11-21 12:09:26

replaced all junit 3 and 4 with junit 5 stuff

2c672 Tobias Warneke 2021-11-21 12:03:37

fce5b Tobias Warneke 2021-11-20 00:08:05

Support RESTART without value (#1425)

Since Postgre 8.4, RESTART in ALTER SEQUENCE can be set without value.

98b66 Olivier Cavadenti 2021-11-20 00:00:32

Add support for oracle UnPivot when use multi columns at once. (#1419)

Co-authored-by: LeiJun <02280245@yto.net.cn>

8e8bb LeiJun 2021-11-19 23:22:29

1fe92 Tobias Warneke 2021-11-19 22:36:41

Fix issue in parsing TRY_CAST() function (#1391)

Fix issue in parsing TRY_CAST() function
Fix issue in parsing TRY_CAST() function
Add parser, deparser, validator and vistior implementation for try_cast function
Update toString() method of TryCastExpression class

bfcf0 Prashant Sutar 2021-11-19 22:24:49

fixes #1414

93b8c Tobias Warneke 2021-11-19 22:21:21

Add support for expressions (such as columns) in AT TIME ZONE expressions (#1413)

Co-authored-by: EverSQL <tomer@eversql.com>

ebe17 Tomer Shay (Shimshi) 2021-11-19 22:04:40

Add supported for quoted cast expressions for PostgreSQL (#1411)

Co-authored-by: EverSQL <tomer@eversql.com>

dbbce Tomer Shay (Shimshi) 2021-11-19 21:54:37

added USE SCHEMA and CREATE OR REPLACE

support; things that are allowed in Snowflake SQL (#1409)

Co-authored-by: Richard Kooijman <richard.kooijman@inergy.nl>

f35d2 Richard Kooijman 2021-11-19 21:40:45

Issue #420 Like Expression with Escape Expression (#1406)

Issue #420 Like Expression with Escape Expression
Fixes issue #420
CheckStyle compliance

8eaa4 manticore-projects 2021-11-19 21:38:54

fixes #1405 and some junit.jupiter stuff

9adab Tobias Warneke 2021-11-19 21:32:23

#1401 add junit-jupiter-api (#1403)

80ff5 gitmotte 2021-11-19 21:10:18

Support Postgres Dollar Quotes #1372 (#1395)

0bd4c Olivier Cavadenti 2021-11-19 20:32:26

Add Delete / Update modifiers for MySQL #1254 (#1396)

Add Delete / Update modifiers for MySQL #1254
fix codacy issues + pr return
simplify low_priority

7be5d Olivier Cavadenti 2021-11-19 20:31:00

Fixes #1381 (#1383)

Allow Complex Expressions as SelectItem

cdf0f manticore-projects 2021-11-19 20:27:44

Allows CASE ... ELSE ComplexExpression (#1388)

Fixes #1375
Co-authored-by: Tobias <t.warneke@gmx.net>

60a7d manticore-projects 2021-11-02 20:48:39

IN() with complex expressions (#1384)

IN() with Complex Expressions
Fixes #905
Allow Complex Expressions and multiple SubSelects for the IN() Expression
Tune the Test Coverage
Remove unused import
Reset TEST status

c4232 manticore-projects 2021-11-01 21:23:48

Fixes #1385 and PR#1380 (#1386)

Add another Alias() Keyword related LOOKAHEAD
Fix a Keyword Spelling Error in the Deparser
Remove UNPIVOT from the PARENTHESIS Deparser, as it was an ugly workaround made obsolete by PR #1380

8c1eb manticore-projects 2021-10-22 20:19:15

Fixes #1369 (#1370)

Issue1369
Add test

2335e Ben Grabham 2021-10-20 21:44:06

Fixes #1371 (#1377)

Fixes #1371
Postgres specific JSON_OBJECT syntax supporting:
SELECT json_object('{a, 1, b, 2}');
SELECT json_object('{{a, 1}, {b, 2}}');
SELECT json_object('{a, b}', '{1,2 }');
Improve Test Coverage

cbffe manticore-projects 2021-10-20 21:13:54

LIMIT OFFSET with Expressions (#1378)

Fixes #933

a52db manticore-projects 2021-10-20 21:05:27

Oracle Multi Column Drop (#1379)

Fixes #1363

9ad18 manticore-projects 2021-10-20 21:01:04

Support alias for UnPivot statement (see discussion #1374) (#1380)

- Changed JSqlParserCC.jjt file to add the alias to the UnPivot lexical entity.
- Added Alias to the UnPivot object.
- Improved SelectDeParser to correctly deparse SubSelect's UnPivot component.

0c0c3 fabriziodelfranco 2021-10-20 20:18:13

Issue1352 (#1353)

Fixes #1352
Allow SYSTEM as table- or column- name
Fixes #1352
Allow SYSTEM as tablename
Fixes #1352
Allow SYSTEM as tablename and columnname
Fixes #1352
Allow QUERY as tablename and columnname
Fixes #1352
Allow FULLTEXT as tablename and columnname
Co-authored-by: Tobias <t.warneke@gmx.net>

a8afd manticore-projects 2021-10-09 21:31:45

Enhance ALTER TABLE ... DROP CONSTRAINTS ... (#1351)

Enhance ALTER TABLE ... DROP CONSTRAINTS ...
Add support for DROP PRIMARY KEY, DROP UNIQUE(...)
Add support for DROP FOREIGN KEY(...)
Fixes #1342
Remove one useless PMD rule
Add more tests
Adjust Test Coverage

388b7 manticore-projects 2021-10-08 23:02:46

Function to use AllColumns or AllTableColumns Expression (#1350)

Fix a trivial MERGE error from Commit 4797a8d676625fcc6cf8c9e3b403ca120b6a8141
Function use AllColumns or AllTableColumns
Fixes #1346
Remove one useless PMD rule

b0ada manticore-projects 2021-10-08 21:58:04

Postgres compliant ALTER TABLE ... RENAME TO ... (#1334)

Fix a trivial MERGE error from Commit 4797a8d676625fcc6cf8c9e3b403ca120b6a8141
Fixes #1333
Postgres compliant ALTER TABLE ... RENAME TO ...
Postgres compliant ALTER TABLE IF EXISTS ... RENAME TO ...
Postgres compliant ALTER TABLE IF EXISTS ... RENAME TO ...

f353e manticore-projects 2021-09-18 11:35:17

Postgres compliant ALTER TABLE ... RENAME TO ... (#1334)

Fix a trivial MERGE error from Commit 4797a8d676625fcc6cf8c9e3b403ca120b6a8141
Fixes #1333
Postgres compliant ALTER TABLE ... RENAME TO ...
Postgres compliant ALTER TABLE IF EXISTS ... RENAME TO ...
Postgres compliant ALTER TABLE IF EXISTS ... RENAME TO ...

5e904 manticore-projects 2021-09-18 11:34:50

corrected readme to the new snapshot version

b8867 Tobias Warneke 2021-09-08 09:57:36

jsqlparser-4.2 (2021-09-08)

Other changes

introducing test for issue #1328

56a39 Tobias Warneke 2021-09-07 09:57:20

included some distinct check

1264a Tobias Warneke 2021-09-07 09:49:48

corrected a merge bug

d53f8 Tobias Warneke 2021-09-07 09:28:35

Prepare4.2 (#1329)

Implement caching of the Gradle and Maven files
Provided by @YunLemon via PR #1307
Fix CREATE TABLE AS SELECT ... UNION SELECT ...
Provided by @fanchuo via PR #1309
Fix #1316
Add more specific tests verifying the nature of the UpdateSets
Allow "SELECT *" (without FROM) to parse, its a valid SELECT statement
Add the enhancements since Release 4.1
Adjust the Coverage
Improve Test Coverage
Revert the Special Oracle Tests (accidentally set to FAILURE)
Co-authored-by: Tobias <t.warneke@gmx.net>

4797a manticore-projects 2021-09-07 08:56:12

CREATE TABLE AS (...) UNION (...) fails (#1309)

a7b5c François Sécherre 2021-09-07 08:51:01

Fixes #1325 (#1327)

Removes redundant production Identifier() and uses RelObjectnameWithoutValue() instead for MS SQL Server Hints

cf0d7 manticore-projects 2021-09-06 12:09:01

Implement Joins with multiple trailing ON Expressions (#1303)

Implement Joins with multiple trailing ON Expressions
Fixes #1302
Fixes SpecialOracleTest JOIN17, now 190/273 tests pass
Fixes #1229
Merge MASTER
Refactor the appendTo() method in favour of the traditional toString()
Remove unused imports

d18c5 manticore-projects 2021-09-06 11:34:05

Fix Gradle PMD and Checkstyle (#1318)

Fixes #1306
Nested Cases with Complex Expressions
Reduce coverage for Java 8
GROUP BY with Complex Expressions
Fixes #1308
Update Sets with Complex Expressions
Fixes #1316
Update Sets with Complex Expressions
Fix existing tests
Add tests for the new functionality
Implement PMD/Codacy recommendations
Add Checkstyle Configuration to Gradle
Add Checkstyle Config files
Fix additional exceptions in Test Sources

2e876 manticore-projects 2021-09-01 22:01:40

3f2e7 Tobias Warneke 2021-08-28 20:59:29

Fixes #1306 (#1311)

Fixes #1306
Nested Cases with Complex Expressions
Reduce coverage for Java 8
GROUP BY with Complex Expressions
Fixes #1308

8f632 manticore-projects 2021-08-28 20:28:55

Update sets (#1317)

Fixes #1306
Nested Cases with Complex Expressions
Reduce coverage for Java 8
GROUP BY with Complex Expressions
Fixes #1308
Update Sets with Complex Expressions
Fixes #1316
Update Sets with Complex Expressions
Fix existing tests
Add tests for the new functionality
Implement PMD/Codacy recommendations

21e5e manticore-projects 2021-08-27 21:37:05

50313 Tobias Warneke 2021-08-25 21:12:12

Special oracle tests (#1279)

Allow keywords: LINK, GROUPING()
Deparse ParenthesisFromItem's Pivot and UnPivot correctly
Write Test results to the SQL File
Reduce the noise during the test
Update/correct the list of expected passing files
Get the benchmark from the list of expected passing files
There are no Pivots or UnPivots yet, so we will return NULL.
Record the expected Test Results on each SQL Source
Fail the test when any expected success suddenly fails
Improve Test Coverage
Appease Codacy

346ee manticore-projects 2021-08-09 21:55:00

Implements Hierarchical CONNECT_BY_ROOT Operator (#1282)

Implements Hierarchical CONNECT_BY_ROOT Operator
Fixes Issue #1269
Resolves some Special Oracle Tests
Improve Test Coverage
Co-authored-by: Tobias <t.warneke@gmx.net>

b6014 manticore-projects 2021-08-09 21:53:08

Implement Transact-SQL IF ELSE Statement Control Flows. (#1275)

Implement Transact-SQL IF ELSE Statement Control Flows.
Fixes #1273 except for Blocks.
Improce Test Coverage
Adjust the required Test Coverage for JDK 8

750c3 manticore-projects 2021-08-09 21:43:50

Add some flexibility to the Alter Statement (#1293)

in order to allow:
ALTER TABLE ... MOVE TABLESPACE ...
ALTER TABLE ... COMPRESS NOLOGGING
ALTER TABLE ... ROWFORMAT=DYNAMIC
Fixes #1033

a88e9 manticore-projects 2021-08-02 20:51:19

Implement Oracle's Alter System (#1288)

4ac5a manticore-projects 2021-08-02 20:37:40

Implement Oracle Named Function Parameters Func( param1 => arg1, ...) (#1283)

Fixes #1270

c8a5d manticore-projects 2021-08-02 20:32:41

Implement Gradle Buildsystem (#1271)

Gradle build
implement SpotBugs, PMD and JaCoCo
implement RR diagrams
Move Special Oracle Test resources into the correct package
Implement a basic Gradle/Maven compatibility workaround for the Special Oracle Test
Fix the Gradle Wrapper and add the folder to git

6933d manticore-projects 2021-08-02 20:18:48

fixes #1272

48a11 Tobias Warneke 2021-07-26 21:14:20

Allowes JdbcParameter or JdbcNamedParameter for MySQL FullTextSearch (#1278)

Fixes issue #1223

e6c91 manticore-projects 2021-07-26 21:06:38

Fixes #1267 Cast into RowConstructor (#1274)

Fixes #1267 Cast into RowConstructor
Improve Test Coverage
Improve Test Coverage
Improve Test Coverage
Co-authored-by: Tobias <t.warneke@gmx.net>

c89cf manticore-projects 2021-07-26 21:02:19

fecc9 Tobias Warneke 2021-07-26 20:47:58

Separate MySQL Special String Functions accepting Named Argument Separation as this could collide with ComplexExpressionList when InExpression is involved (#1285)

Fixes #1284
Co-authored-by: Tobias <t.warneke@gmx.net>

c074a manticore-projects 2021-07-26 20:34:06

Implements Oracle RENAME oldTable TO newTable Statement (#1286)

Implements Oracle RENAME oldTable TO newTable Statement
Fixes #1253
Implement MariaDB specific syntax
Remove redundant License Headers
Use LinkedHashMap to preserve the order of the Entries
Increase Test Coverage
Co-authored-by: Tobias <t.warneke@gmx.net>

f7f7b manticore-projects 2021-07-26 20:26:47

Implement Oracle Purge Statement (#1287)

f86bc manticore-projects 2021-07-26 20:18:39

included jacoco to allow code coverage for netbeans

f85b4 Tobias Warneke 2021-07-18 21:15:14

corrected a Lookahead problem

db90e Tobias Warneke 2021-07-16 21:31:17

Json functions (#1263)

Implement Json Aggregate Functions JSON_OBJECTAGG() and JSON_ARRAYAGG()
fix the returned type
Implement JSON_OBJECT and JSON_ARRAY
Solves #1260 and dbeaver/dbeaver/#13141
Better workaround for NULL, NULL NULL ON NULL
Remove the workaround for NULL ON NULL (without expression)
Implement "PMD.MissingBreakInSwitch" in order to appease Codacy
Improve Test Coverage
Improve Test Coverage
KEYs can be SQL Value Expressions
Add another testcase

59bf0 manticore-projects 2021-07-16 21:24:44

fixes #1255

2c732 Tobias Warneke 2021-07-16 21:12:45

Active JJDoc and let it create the Grammar BNF documentation (#1256)

Clean-up the Site generation

1ecff manticore-projects 2021-07-16 20:38:05

Bump commons-io from 2.6 to 2.7 (#1265)

Bumps commons-io from 2.6 to 2.7.
updated-dependencies:
- dependency-name: commons-io:commons-io
dependency-type: direct:development
...
Signed-off-by: dependabot[bot] <support@github.com>
Co-authored-by: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com>

09898 dependabot[bot] 2021-07-14 05:27:57

Update README.md

e6303 Tobias 2021-07-13 05:34:12

Implement DB2 Special Register Date Time CURRENT DATE and CURRENT TIME (#1252)

Implement DB2 Special Register Date Time CURRENT DATE and CURRENT TIME
Fixes issue #1249
(Although there are more Special Registers which are not supported yet.)
Make the spaces mandatory
Add 2 more tests

05157 manticore-projects 2021-07-13 05:32:38

Rename the PMD ruleset configuration file hoping for automatic synchronization with Codacy (#1251)

Solves Issue #1220

930b7 manticore-projects 2021-07-13 05:28:43

corrected .travis.yml

11124 Tobias Warneke 2021-07-05 20:57:22

corrected .travis.yml

5cf7e Tobias Warneke 2021-07-05 20:52:40

3e0e7 Tobias Warneke 2021-07-05 20:39:11

Update README.md

ec16d Tobias 2021-07-05 20:27:41

fixes #1250

9e434 Tobias Warneke 2021-07-01 12:24:36

05d68 Tobias Warneke 2021-06-30 22:12:00

jsqlparser-4.1 (2021-06-30)

Other changes

fixes #1140

1a917 Tobias Warneke 2021-06-30 21:50:28

introduced #1248 halfway

1deea Tobias Warneke 2021-06-30 21:15:56

Savepoint rollback (#1236)

Implement SAVEPOINT and ROLLBACK statements, fixes issue #1235
Activate a test which is supported now.

2cae6 manticore-projects 2021-06-30 19:57:56

Fixes Function Parameter List Brackets issue #1239 (#1240)

750f3 manticore-projects 2021-06-30 19:45:32

0ba44 Tobias Warneke 2021-06-30 19:41:44

corrected javadoc problem

f7ea4 Tobias Warneke 2021-06-27 00:20:35

corrected some lookahead problem

59c2a Tobias Warneke 2021-06-26 23:57:06

RESET statement, SET PostgreSQL compatibility (#1104)

Support
RESET statement (https://www.postgresql.org/docs/current/sql-reset.html)
SET [LOCAL|SESSION] (https://www.postgresql.org/docs/current/sql-set.html)
SET search_path=my_schema, public ( https://www.postgresql.org/docs/current/sql-set.html
value New value of parameter. Values can be specified as string constants, identifiers, numbers, or comma-separated lists of these)
Update ResetStatementTest.java
remove Tim Zone token
Co-authored-by: Tobias <t.warneke@gmx.net>

13503 Роман Зотов 2021-06-26 22:44:33

corrected some lookahead problem

6711f Tobias Warneke 2021-06-26 22:42:24

Implement Oracle Alter Session Statements (#1234)

Implement Oracle Alter Session Statements according to https://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_2012.htm
Implement PMD Rule "SwitchStmtsShouldHaveDefault"
Reorganize Test Case imports

3a46a manticore-projects 2021-06-26 22:38:19

fixes #1230

3082d Tobias Warneke 2021-06-26 22:31:43

Support DELETE FROM T1 USING T2 WHERE ... (#1228)

Co-authored-by: Francois Secherre <secherre.nospam@gmail.com>

96cd4 francois-secherre 2021-06-16 05:27:14

Row access support (#1181)

Row acess support
Remove IN Left Expression List, replaced by RowConstructor Expression
Remove IN Left Expression List, replaced by RowConstructor Expression
Formatting

27e6a Роман Зотов 2021-06-16 05:15:47

corrected lookahead problem of PR #1225

aec76 Tobias Warneke 2021-06-14 05:27:40

Delete queries without from, with a schema identifier fails (#1224)

Delete queries without from, with a schema identifier fails
Better tests
Fix style issue
Deparse should match for DELETE WITHOUT FROM queries
Co-authored-by: François Sécherre <francois.secherre@ouicar.fr>

d70e1 François Sécherre 2021-06-14 05:15:15

Create temporary table t(c1, c2) as select ... (#1225)

Co-authored-by: Francois Secherre <secherre.nospam@gmail.com>

b62f1 francois-secherre 2021-06-14 05:13:13

Nested with items (#1221)

Nested WithItems, fixes issue #1186
Remove redundant Test
Avoid altering the nb-configuration
Mention Nested WITH CTEs in the readme
Eliminate dead/unused MultiExpression Code

8eb3d manticore-projects 2021-06-10 05:50:08

Implement GROUP BY () without columns (#1218)

Implement GROUP BY () without columns
Migrate GroupByElement to ExpressionList
Also solves issue #1210 automatically
Solves issue #1168, add a test for it.

999db manticore-projects 2021-06-03 05:55:35

TSQL Compliant NEXT VALUE FOR sequence_id (but keeping the spurious NEXTVAL FOR expression) (#1216)

Co-authored-by: Tobias <t.warneke@gmx.net>

7c212 manticore-projects 2021-06-02 12:35:03

Pmd clean up (#1215)

Add PMD Annotations in order to avoid useless exceptions for the Deparsers
Add Eclipse Formatter configuration
Fix typo
Replace Comments on empty methods with Class wide PMD Annotation
Do not enforce checkstyle formatting

53764 manticore-projects 2021-06-02 12:19:32

Add support for boolean 'XOR' operator (#1193)

Add support for boolean 'XOR' operator
XorExpression added to the ReflectionModelTest
XorExpression case added to the SelectTest
XorExpression cases added for Validation
Additional tests added for code coverage.
Code style fixed.
Separate test case for XOR added.
Imports explicitly added to avoid namespace pollution.
Additional tests cases for precedence and associativity.
Co-authored-by: Szabó Miklós <miklos.szabo@arh.hu>

c7832 Adaptive Recognition 2021-06-02 12:10:56

Update README.md

1feea Tobias 2021-05-31 08:46:48

Implement WITH for DELETE, UPDATE and MERGE statements (#1217)

63ed1 manticore-projects 2021-05-31 08:44:08

9184c Tobias Warneke 2021-05-26 23:12:05

f83ed Tobias Warneke 2021-05-26 23:09:08

76bff Tobias Warneke 2021-05-26 23:04:41

increases complex scanning range

13b88 Tobias Warneke 2021-05-26 21:38:44

Allow Complex Parsing of Functions (#1200)

Allow Complex Parsing of Functions
Fixes issues #1190 #1103
Apply Complex Parsing to PrimaryExpression()
Fixes issue #1194
Increase Test Timeout to 2 seconds for slow CI Servers.
Appease Codazy

3a5da manticore-projects 2021-05-26 20:35:10

Add support for AT TIME ZONE expressions (#1196)

Add support for AT TIME ZONE expressions
adding tests
Fixing imports

a5204 Tomer Shay (Shimshi) 2021-05-25 23:03:31

fixes #1211

ed089 Tobias Warneke 2021-05-25 21:52:01

fixes #1212

b8ee7 Tobias Warneke 2021-05-25 21:45:01

1c2ac Tobias Warneke 2021-05-25 21:32:45

68695 Tobias Warneke 2021-05-25 19:42:23

Fix Nested CASE WHEN performance, fixes issue #1162 (#1208)

Fix Nested CASE WHEN performance, fixes issue #1162
Apease Codazy
Apease Codazy

42610 manticore-projects 2021-05-25 19:26:30

Add support for casts in json expressions (#1189)

86b61 Tomer Shay (Shimshi) 2021-05-10 20:00:59

fixes #1185

2320b Tobias Warneke 2021-05-04 21:11:12

53745 Tobias Warneke 2021-05-01 20:57:01

002f5 Tobias Warneke 2021-05-01 19:57:10

supporting/fixing unique inside sql function such as count eg - SELECT count(UNIQUE col2) FROM mytable (#1184)

Co-authored-by: Adhikesavan <radhikesavan@paypal.com>

f18e9 RajaSudharsan Adhikesavan 2021-05-01 19:28:05

Oracle compliant ALTER TABLE ADD/MODIFY deparser (#1163)

javadoc-fixes
fix check-style error : assignment to parameter not allowed
import for javadoc reference
javadoc - add description to parameter "fqn" (fix warning)
remove doclint=none, but exclude package with exclude package with
generated sources (javacc/jjtree) from javadoc
Implement Oracle Hints for INSERT, UPDATE, MERGE, DELETE
Correct CreateIndex TailOptions
Add a Test Case for CreateIndex TailOptions
Add WHERE expression to MergeInsert
Add test case for MergeInsert WHERE expression
Fix Issue #1156: ALTER TABLE ADD FOREIGN KEY with schema reference
Add a specific test case
Fix Issue #1157: Oracle does not accept COLUMN keyword in ALTER TABLE ADD/MODIFY
Correct the test cases accepting a non existing COLUMN keyword
Add a specific test cases
Fix Issue #1164 UNIQUE after PRIMARY KEY
Add test case for UNIQUE after PRIMARY KEY
Switch of warnings for un-fixble method namings
Switch of warnings for un-fixble method namings
Activate PMD and define our own ruleset
Execute PMD before building/testing in order to fail early
Fix 63 PMD warnings
Activate rule "PMD.CyclomaticComplexity" in order to simulate the Codazy checks
Apply @SuppressWarnings({"PMD.CyclomaticComplexity"}) where this rule throws an unavoidable warning (especially for toString() and deparse())
Activate rule , "PMD.ExcessiveMethodLength" in order to simulate the Codazy checks
Apply @SuppressWarnings({"PMD.ExcessiveMethodLength"}) where this rule throws an unavoidable warning (especially for toString() and deparse())
Refactor an ENUM name
Refactor an ENUM name and reflect this also in the JavaCC Parser definition file
Co-authored-by: gitmotte <www@synbee.at>

83837 manticore-projects 2021-04-21 07:55:17

Pmd (#1165)

Implement Oracle Hints for INSERT, UPDATE, MERGE, DELETE
Correct CreateIndex TailOptions
Add a Test Case for CreateIndex TailOptions
Add WHERE expression to MergeInsert
Add test case for MergeInsert WHERE expression
Fix Issue #1156: ALTER TABLE ADD FOREIGN KEY with schema reference
Add a specific test case
Fix Issue #1157: Oracle does not accept COLUMN keyword in ALTER TABLE ADD/MODIFY
Correct the test cases accepting a non existing COLUMN keyword
Add a specific test cases
Fix Issue #1164 UNIQUE after PRIMARY KEY
Add test case for UNIQUE after PRIMARY KEY
Switch of warnings for un-fixble method namings
Switch of warnings for un-fixble method namings
Activate PMD and define our own ruleset
Execute PMD before building/testing in order to fail early
Fix 63 PMD warnings
Activate rule "PMD.CyclomaticComplexity" in order to simulate the Codazy checks
Apply @SuppressWarnings({"PMD.CyclomaticComplexity"}) where this rule throws an unavoidable warning (especially for toString() and deparse())
Activate rule , "PMD.ExcessiveMethodLength" in order to simulate the Codazy checks
Apply @SuppressWarnings({"PMD.ExcessiveMethodLength"}) where this rule throws an unavoidable warning (especially for toString() and deparse())
Refactor an ENUM name
Refactor an ENUM name and reflect this also in the JavaCC Parser definition file

08cfd manticore-projects 2021-04-20 08:01:48

function order by support (#1108)

d6ef7 Роман Зотов 2021-04-20 04:16:03

fixes #1159

79e2f Tobias Warneke 2021-04-16 23:51:24

added improvements of pr to readme

0ef4a Tobias Warneke 2021-04-16 23:02:51

Assorted fixes to the Java CC Parser definition (#1153)

Implement Oracle Hints for INSERT, UPDATE, MERGE, DELETE
Correct CreateIndex TailOptions
Add a Test Case for CreateIndex TailOptions
Add WHERE expression to MergeInsert
Add test case for MergeInsert WHERE expression
Fix Issue #1156: ALTER TABLE ADD FOREIGN KEY with schema reference
Add a specific test case

5ee6e manticore-projects 2021-04-16 22:51:27

b880e Tobias Warneke 2021-04-16 22:49:29

fixes #1138

e95f6 Tobias Warneke 2021-04-10 21:36:07

fixes #1138

cb7a0 Tobias Warneke 2021-04-10 21:35:53

fixes #1137

9d676 Tobias Warneke 2021-04-10 21:23:00

fixes #1136

ba9b8 Tobias Warneke 2021-04-10 21:09:19

f0bec Tobias Warneke 2021-03-22 21:21:13

issue #1134 adressed

5d9f4 Tobias Warneke 2021-03-20 21:35:05

Add support for union_with_brackets_and_orderby (#1131)

c3a1a Tomer Shay (Shimshi) 2021-03-14 20:10:33

Add support for union without brackets and with limit (#1132)

add support for union without brackets and with limit
Fixing the last commit.

56c2d Tomer Shay (Shimshi) 2021-03-14 20:09:12

d2f61 Tobias Warneke 2021-03-14 20:04:28

Add support for functions in an interval expression (#1099)

7f8b5 Tomer Shay (Shimshi) 2021-03-14 19:55:40

bcc68 Tobias Warneke 2021-02-06 20:37:50

7deb6 Tobias Warneke 2021-02-05 21:59:11

subArray support arr[1:3] (#1109)

cde50 Роман Зотов 2021-02-05 21:55:29

bug fix (#769)

Co-authored-by: Kunal Jha <kjha@zalando-11116.corp.ad.zalando.net>

7234d Kunal jha 2021-02-05 17:46:15

089fc Tobias Warneke 2021-02-04 19:47:39

Array contructor support (#1105)

Array contructor support array[[1, 2], [id1, id2]]
ARRAYLITERAL->ARRAY_LITERAL
Fix empty array
Support ARRAY as DEFAULT value in CREATE TABLE
JSQLParser#970 (comment)
fix empty Array

43c28 Роман Зотов 2021-02-04 19:28:49

85193 Tobias Warneke 2021-01-31 22:59:20

Partial support construct tuple as simple expression (#1107)

SELECT (1,2)

2065f Роман Зотов 2021-01-31 22:58:08

support create table parameters without columns, parameter values any names (#1106)

CREATE TEMPORARY TABLE t1 WITH (APPENDONLY=true,ORIENTATION=column,COMPRESSTYPE=zlib,OIDS=FALSE) ON COMMIT DROP AS SELECT column FROM t2

f2e74 Роман Зотов 2021-01-31 22:53:09

fixes #995

d7b46 Tobias Warneke 2021-01-13 19:21:40

fixes #1100

ea31a Tobias Warneke 2021-01-13 18:58:16

next correction of parenthesis around unions

5706f Tobias Warneke 2021-01-11 23:15:21

e2ff2 Tobias Warneke 2021-01-10 00:13:16

fixes #992

9fd11 Tobias Warneke 2021-01-07 22:34:40

corrected patch for case as table name

f2638 Tobias Warneke 2021-01-07 21:57:52

Added support for the Case keyword in table names (#1093)

b85a2 Tomer Shay (Shimshi) 2021-01-07 21:43:11

9785b Tobias Warneke 2021-01-04 06:45:18

corrected some javadoc parameter

449b7 Tobias Warneke 2021-01-03 22:16:44

added missing pivot test files

e599b Tobias Warneke 2021-01-03 21:07:06

fixes #282 - first refactoring to allow with clause as a start in insert and update

d4402 Tobias Warneke 2021-01-02 23:57:26

fixes #282 - first refactoring to allow with clause as a start in insert and update

e6d65 Tobias Warneke 2021-01-02 23:56:12

Update README.md

54708 Tobias 2021-01-02 08:58:01

fixes #887

74aab Tobias Warneke 2021-01-02 00:04:43

fixes #1091 - added H2 casewhen function with conditional parameters

085e1 Tobias Warneke 2021-01-01 23:49:30

fixes #1091 - added H2 casewhen function with conditional parameters

e5e7d Tobias Warneke 2021-01-01 23:46:03

1eaa1 Tobias Warneke 2021-01-01 23:18:55

jsqlparser-4.0 (2021-01-01)

Other changes

fixes #961 - allow unsigned as type

7783e Tobias Warneke 2020-12-31 01:49:42

fixes #961 - allow unsigned as type

67a33 Tobias Warneke 2020-12-31 01:46:19

fixes #1006 - included limit / offset test

b5514 Tobias Warneke 2020-12-31 00:59:36

fixes #1013 - refactored fromitem grammar to drastically improve performance

36d0b Tobias Warneke 2020-12-31 00:47:09

05a6f Tobias Warneke 2020-12-30 23:12:55

b2c60 Tobias Warneke 2020-12-30 22:50:48

fixes #1088 - allowed CURRENT as jdbc named parameter name

4f925 Tobias Warneke 2020-12-30 22:12:28

fixes #1089 - just included test case

4183a Tobias Warneke 2020-12-30 21:45:32

f484d Tobias Warneke 2020-12-18 22:15:09

10a69 Tobias Warneke 2020-12-18 22:13:16

fixes #1080

d9282 Tobias Warneke 2020-12-17 20:17:14

Update README.md

624f2 Tobias 2020-12-16 10:08:46

fixes #926

97ab8 Tobias Warneke 2020-12-11 22:13:14

tested

d9da6 Tobias Warneke 2020-12-06 11:53:35

tested

875f7 Tobias Warneke 2020-12-06 11:52:16

upgraded to javacc 7.0.10, this time the lookahead seems to be working

881e4 Tobias Warneke 2020-11-30 06:35:59

upgraded to javacc 7.0.10, this time the lookahead seems to be working

eae2e Tobias Warneke 2020-11-30 06:34:55

fixes #1065

e0b3a Tobias Warneke 2020-11-22 19:39:48

support IN with value (#1065)

Co-authored-by: Jan Monterrubio <Jan.Monterrubio@Cerner.com>
Co-authored-by: Tobias <t.warneke@gmx.net>

8c7ee Jan Monterrubio 2020-11-22 19:29:27

fixes #1074

ece8a Tobias Warneke 2020-11-22 19:14:52

fixes #1075

b74f5 Tobias Warneke 2020-11-22 19:08:39

1008e Tobias Warneke 2020-11-06 22:01:54

Support CreateSynonym statement (#1064)

visual
add synonym support
add tests
exclude keyword
Co-authored-by: Jan Monterrubio <Jan.Monterrubio@Cerner.com>

17e26 Jan Monterrubio 2020-11-06 21:45:14

d5258 Tobias Warneke 2020-11-06 21:34:08

Validation visitor framework (#1045)

- add with prefix for fluent setters.
JSQLParser#1004
add getters
- add with prefix for fluent setters. (revert to chaining setters, do
not break current api)
JSQLParser#1004
- add with prefix for fluent setters. (revert to chaining setters, do
not break current api)
JSQLParser#1004
use new methods within testcases
use new methods within testcases
use new methods within testcases
use new methods within testcases
use new methods within testcases
use new methods within testcases
use new methods within testcases
use new methods within testcases
remove create() methods - they do not add enough value to be justified
- use new methods within testcases
add some constructors
fix and add "with" / "add" methods
- use new methods within testcases
- use new methods within testcases
add some constructors
- renamed constant
use new methods within testcases
use new methods within testcases
use new methods within testcases
use new methods within testcases
- use new methods within testcases
add some with-methods
add getter/setter named after the field without abbrivation
- use new methods within testcases
remove empty implicit constructor
return the deparsed Statement - object
compare object tree
compare object tree
- fix ObjectTreeToStringStyle
compare object tree
remove casts not needed
- use new methods within testcases
add some "set" "with" "add" methods missing
- use new methods within testcases
add empty constructors and override with-/add-methods returning concrete
type
- add ReflectionModelTest
- use new methods within testcases
fix checkstyle errors
license header
remove test-classes from ReflectionModelTest
remove visitoradapter-classes from ReflectionModelTest
- add SelectDeParser(StringBuilder)
remove overriding setters/getters of buffer
#1007
push to synbee-contrib
org.synbee.commons.contrib:jsqlparser:3.2-0.0.6-SNAPSHOT
add ValidationUtil for simple validation of one or more statements
remove overrides of
getCause
printStackTrace variants
why add an additional cause ?
set cause.getMessage() the message within constructor
JSQLParserException(Throwable cause), othewise cause.toString() will be
set as default.
add ValidationVisitor showcase
JSQLParser#1005
add ValidationUtil for simple validation of one or more statements
remove overrides of
getCause
printStackTrace variants
why add an additional cause ?
set cause.getMessage() the message within constructor
JSQLParserException(Throwable cause), othewise cause.toString() will be
set as default.
visit(ShowTablesStatement)
copyright/license
add stubs (use deparsers as template)
Merge branch 'master.validate' of
https://github.com/gitmotte/JSqlParser.git into master.validate
add ValidationVisitor showcase
JSQLParser#1005
add ValidationUtil for simple validation of one or more statements
remove overrides of
getCause
printStackTrace variants
why add an additional cause ?
set cause.getMessage() the message within constructor
JSQLParserException(Throwable cause), othewise cause.toString() will be
set as default.
visit(ShowTablesStatement)
add stubs (use deparsers as template)
Merge branch 'master.validate' of
https://github.com/gitmotte/JSqlParser.git into master.validate
add tests for ValidationUtil
- implements OrderByVisitor
split Expressionvalidator which implements both ItemsListVisitor and
Expressionvisitor into Expressionvalidator and ItemListValidator
Merge branch 'github.validate'
implement upsertvalidator
add copyright
validate through given ValidationCapability's
- switch to new method forced by
ValidationCapability.validate(ValidationContext context,
Consumer<String> errorMessageConsumer);
add AllowedTypesValidation
add FeatureConfiguration
use FeatureConfiguration within parser
repair pom.xml
repair pom.xml
repair pom.xml
repair pom.xml
- make FeatureConfiguration not a singleton any more
CCJSqlParser extends AbstractJSqlParser<CCJSqlParser>
add FeaturesAllowed for testing against features allowed
implement some Validators
basic implementation of DatabaseMetaDataValidation /
JdbcDatabaseMetaDataCapability
moving classes to sub-packages
- moving classes to sub-packages
fixing some bugs
repair pom.xml
add and fix validations
add javadoc
- force definition of ```public String getMessage(Feature feature)```
in FeatureSetValidation
allow all objects as feature-value - this may be needed by the parser,
if a none-boolean configuration is needed
impl.
SelectValidator.visit(PlainSelect)
OrderByValidator
add Version-enums
impl.
InsertValidator
multiple implementations of visit(SubSelect) -> forward to
SelectValidator
add some known features to SqlServerVersion
refactoring enum-name should be upper case
add ansi sql enum
refactoring enum-name should be upper case
implement limitvalidator
- validateOffset
- validateFetch
- validate Pivot, UnPivot, PivotXml
- implement DropValidator
change testcase to image a more probably usecase
- add javadoc and
predefined sets for EXECUTE, ALTER, DROP
allow to combine FeatureSets
- implement executevalidator
implement ExpressionValidator
implement GrantValidator
javadoc and complete SELECT constant
use utility methods from AbstractValidator
more user friendly names
javadoc
add subtypes for ValidationException
ValidationParseException
DatabaseException
UnexpectedValidationException
and change Set<String> errors to Set<ValidationException> for collect.
javadoc & rename exception
rename method
extract parsing task into package - private class for {@link
ValidationUtil} to parse the statements
within it's own {@link ValidationCapability}
add null-check for parsedStatement
bugfix - do not collect duplicates
implement toString() for
ValidationError
ValidationException
add simple caching
- validateOptionalFromItem(s)
- implement GroupByValidator
implement merge-validator
renaming ItemListValidator -> ItemsListValidator
- validateOptionalItemsList
- implement ReplaceValidator
- use validateOptionalColumns, validateOptionalExpression where possible
- remove validateOptionalColumns -> switch to
validateOptionalExpressions
move validateOptionalOrderByElements to AbstractValidator
add validateOptional in AbstractValidator
add validateOptionalList in AbstractValidator
- SetStatementValidator
- ValuesStatementValidator
- UseStatementValidator
- implement UpdateValidator
- implement ShowStatementValidator/ShowColumnsStatementValidator
- implement UpdateValidator
- add Feature.jdbcParameter, Feature.jdbcNamedParameter, to all
featuresets
- Version.getFeaturesClone
add javadoc to Version-enum-constructors
- validateOptionalFeature
- implement DeleteValidator
...
fix typo
small optimization
- move method getFeaturesClone to FeatureSet
implement join - validation
add copy(), add(Collection), remove(*) methods to FeaturesAllowed
- add join - features to sqlserver, h2
implementations
bugfix - merging the errors
copyright
JSQLParser#1022
add more fine granular control for setOperations
fix nullpointerexception
add more fine granular control for comments
add Features supported
- add javadoc
add features to *Version-files
extract methods isNotEmpty
check for isNotEmpty
- add features to *Version-files
always parse net.sf.jsqlparser.statement.Statements and validate the
list of included net.sf.jsqlparser.statement.Statement's
add known mariadb features
new names-set for FeaturesAllowed
new names-set for FeaturesAllowed
new names-set for FeaturesAllowed
add ature.withItem, Feature.withItemRecursive to H2
Feature.setOperation, Feature.setOperationUnion,
Feature.setOperationIntersect, Feature.setOperationExcept,
for MariaDb
add features to SQLServer
Merge branch 'master.orig' into github.validate
@Override() -> @Override
fix typing error "joinStaight" > joinStraight
rename Feature "insertValues" -> "values" and use "insertValues" for
INSERT INTO ... VALUES
add javadoc
add Feature.selectGroupByGroupingSets to PostgresqlVersion
implement basic OracleVersion
add Feature.mySql* - also supported by mariadb
add some more finegraned control over "drop" Feature.
drop,
dropTable,
dropIndex,
dropView,
dropSchema,
dropSequence,
dropIfExists,
complete FeaturesAllowed groups INSERT/UPDATE/DELETE/MERGE/DML
add link to documentation
fix - duplicate use of feature "function" - the use of functions in
statements and "createFunction" as a ddl statement
TODO this feature seams very close to a jsqlparser-user usecase
- implement MySqlVersion
replace feature Feature.dropIfExists by features dropTableIfExists,
dropIndexIfExists, dropViewIfExists, dropSchemaIfExists,
dropSequenceIfExists
add methods FeatureSet.getNotContained FeatureSet.retainAll
remove HSQLDBVersion - do not support this variant
remove HSQLDBVersion - do not support this variant
add unit-test
- add unittests for
UpdateValidator
DeleteValidator
add stubs for all other Validator-classes
- ModifyableFeatureSet
add some utility-methods in ValidationTestAsserts
complete unit-tests for InsertValidator
remote Feature.insertReturningExpressionList for Oracle -
returning_clause requires INTO clause (only PL/SQL)
add some more select validation tests
add DropValidatorTests
add DropValidatorTests
add CreateTableValidatorTests
add CreateTableValidatorTests
add ExpressionValidatorTests
add OrderByValidatorTest
use isNotEmpty
implement GroupByValidatorTest
implement CreateSequenceValidatorTest
remove @Ignore - test is ok
implement CreateIndexValidatorTest
implement CreateViewValidatorTest
enable validation of Feature.commentOnView (#1024 is merged already)
change format of #toString() for better readability
- implement MergeValidatorTest
implement ReplaceValidatorTest
implement StatementValidatorTest
rename
ValidationUtil -> Validation
ValidatorUtil -> ValidationUtil
add testcases for ValidationUtil
add DatabaseMetaDataValidationTest
checkstyle fix
add copyright statement
add unit-tests for show tables, show column, show statements
- add ExecuteValidatorTest
as there is a difference between execute <procedure> and execute
[immediate] <dynamic sql> with USING expr, ... remove support for
execute on MYSQL, MARIADB, ORACLE
- add ExecuteValidatorTest for CALL fnName (mysql, mariadb, postgres)
add upsertvalidatortest
add GrantValidatorTest
add AlterSequenceValidatorTest
add AlterSequenceValidatorTest
add AlterViewValidatorTest
add AlterValidatorTest
replace != null by isNotEmpty on collections
fix formatting
add validate commit
add validate block
add DeclareStatementValidatorTest
let NamesLookup implement UnaryOperator<String>
let NamesLookup implement UnaryOperator<String>
add javadoc
add more DatabaseMetaDataValidationTest's
extract JdbcDatabaseMetaDataCapability.splitAndValidateMinMax
add pivot/unpivot/pivotxml validation testcases
add testcase for Feature.tableFunction
add test for lateral joins and subjoins
add testValidationRowMovementOption
add values validator test
move tests to LimitValidatorTest
move tests to UseStatementValidatorTest
add tests for SET - statements
fix checkstyle error
new serialVersionUID
add validation for NamedObject not existing
need table/view reference to validate column names
fix typo
fix errormessage (Arrays.toString(types))
add trigger, alias
return null, instead of throwing exception, if not found
extract NamesLookup to own file (jdk-bug enum inner classes)
fix name-check AlterOperation.ALTER
fix error message
remove methods not needed (they only delegate to ValidationContext)
add tests - validate metadata
fix compile error
fix columnExists check - depending on the statement the prefix is an
alias, a table/view or it has no prefix (need to lookup within all
related tables/views)
fix javadoc warnings

8c735 gitmotte 2020-11-06 21:12:25

Support Create table LIKE (#1066)

fixes #413
add coverage
Co-authored-by: chyun <chyun_wu@163.com>

ac746 Chyun 2020-11-06 21:05:09

fixes #1068

f1cf0 Tobias Warneke 2020-11-06 20:59:19

Bump junit from 4.12 to 4.13.1 (#1063)

Bumps junit from 4.12 to 4.13.1.
- Release notes
- Changelog
- Commits
Signed-off-by: dependabot[bot] <support@github.com>
Co-authored-by: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com>

f9a11 dependabot[bot] 2020-10-13 12:26:17

fixes #1062

80e28 wumpz 2020-10-11 19:59:03

corrected a test failure

bc0e5 wumpz 2020-10-06 21:07:00

support FILTER not only for window function (#1046)

support FILTER not only for window function
Fixed imports

f32fa Роман Зотов 2020-10-05 19:45:36

fixes #1059

3e84a wumpz 2020-10-04 20:43:42

6b35e wumpz 2020-10-04 20:17:54

fixes #1055 - added simple jdbc parameter to interval expression

68659 wumpz 2020-10-04 20:16:04

Retain original value in TimestampValue (#1057)

Co-authored-by: Enrico Olivelli <enrico.olivelli@diennea.com>

622f9 Enrico Olivelli 2020-10-04 19:51:01

fixes #1053

45aa8 wumpz 2020-10-04 19:42:23

Addons/fixes for Fluent API (#1049)

fix unittests for setter/wither methods with primitive arguments
add missing withAscDescPresent

8165e gitmotte 2020-10-04 19:20:43

fixes #1040

3f516 wumpz 2020-09-27 21:12:11

xmlserialize support patch for optional order by part

3747f wumpz 2020-09-10 21:21:47

xmlserialize support patch for expressions

8c4e0 wumpz 2020-09-08 20:35:36

Make UnPivot.getUnPivotInClause() return List (#1039)

abedc MoonFruit 2020-09-07 11:32:37

xmlserialize support

b580a wumpz 2020-09-05 22:00:43

536fb wumpz 2020-08-30 20:23:52

bugfix issue #1036: supporting DROP SEQUENCE (#1037)

e5cd7 suiwenbo 2020-08-30 20:16:20

modified Condition production to be more performant

3d7f5 wumpz 2020-08-29 22:30:01

bugfix #720 #991: supporting SELECT "conditions" (#1032)

bugfix issue #1020: JSON type in MySQL not supported in v3.2
bugfix issue #720 #991: supporting SELECT "CONDITIONS"

9e26b suiwenbo 2020-08-25 22:29:41

81523 wumpz 2020-08-23 20:33:42

setting version to 4-SNAPSHOT

85286 wumpz 2020-08-23 20:32:33

Fluent builder api #1004 (#1014)

JSQLParser#1004
create(...) methods
chaining - methods returning "this"
overwrite chaining - methods of abstract parents/interfaces for
returning concrete type
add<Name> methods on collection-fields with varargs-parameter
add public T get<Name>(Class<T>) - casting and returning an inner
interface-type
1004 add chaining - methods returning "this"
#1004 add chaining - methods returning "this"
- add<Name> methods on collection-fields with varargs-parameter
add<Name> methods on collection-fields with collection-parameter
JSQLParser#1004
- add chaining - methods returning "this"
add<Name> methods on collection-fields with varargs-parameter
add<Name> methods on collection-fields with collection-parameter
JSQLParser#1004
- add public T get<Name>(Class<T>) - casting and returning the concrete
type
JSQLParser#1004
- add public T get<Name>(Class<T>) - casting and returning the concrete
type (swap Class<? extends E> for Class<E>)
JSQLParser#1004
- overwrite chaining - methods of abstract parents/interfaces for
returning concrete type
JSQLParser#1004
- add with prefix for fluent setters.
JSQLParser#1004
add getters
- add with prefix for fluent setters. (revert to chaining setters, do
not break current api)
JSQLParser#1004
- add with prefix for fluent setters. (revert to chaining setters, do
not break current api)
JSQLParser#1004
use new methods within testcases
use new methods within testcases
use new methods within testcases
use new methods within testcases
use new methods within testcases
use new methods within testcases
use new methods within testcases
use new methods within testcases
remove create() methods - they do not add enough value to be justified
- use new methods within testcases
add some constructors
fix and add "with" / "add" methods
- use new methods within testcases
- use new methods within testcases
add some constructors
- renamed constant
use new methods within testcases
use new methods within testcases
use new methods within testcases
use new methods within testcases
- use new methods within testcases
add some with-methods
add getter/setter named after the field without abbrivation
- use new methods within testcases
remove empty implicit constructor
return the deparsed Statement - object
compare object tree
compare object tree
- fix ObjectTreeToStringStyle
compare object tree
remove casts not needed
- use new methods within testcases
add some "set" "with" "add" methods missing
- use new methods within testcases
add empty constructors and override with-/add-methods returning concrete
type
- add ReflectionModelTest
- use new methods within testcases
fix checkstyle errors
license header
remove test-classes from ReflectionModelTest
remove visitoradapter-classes from ReflectionModelTest
remove duplicate import declaration (checkstyle error)
- fix RandomUtils to support used java.sql.* types
fix RandomUtils to support enums
fix RandomUtils to map objects by its interfaces and super-classes
filter method "setASTNode" - do not test setters (cannot randomly
create a SimpleNode)
add javadoc, stating that this is a marker interface
JSQLParser#1014 (comment)
revert formatting change
JSQLParser#1014 (comment)
change to EXEC_TYPE.EXECUTE just so the assertion didn't change
JSQLParser#1014 (comment)
try to revert format changes
JSQLParser#1014 (comment)
try to revert format changes
JSQLParser#1014 (comment)
remove brackets on @Override() -> @Override
add with-methods to new fields

6cff1 gitmotte 2020-08-23 20:07:53

02d58 wumpz 2020-08-09 21:26:57

574a6 wumpz 2020-08-09 21:22:24

Support Foreign Key ON UPDATE CASCADE (#1025)

JSQLParser#985
add 2 unit-tests for given statements
JSQLParser#985
fix formating (line width)
JSQLParser#985
- fix nullpointerexceptions
add more unittest-assertions
JSQLParser#985
change order to match the same order as in ForeignKeyIndex
byAction should not throw an exception (is used by deprecated
string-setters)
add unit-tests for ReferentialAction within AlterExpression
fix toString (added bug on refactoring)
javadoc
test set from get on null-values too
refactoring: add and use ReferentialAction() to evaluate enum
JSQLParser#985
refactoring: fix parser that order of referential actions does not
matter
JSQLParser#985
add empty constructor

1e88d gitmotte 2020-08-09 21:01:34

bugfix issue #1020: JSON type in MySQL not supported in v3.2 (#1028)

685f6 suiwenbo 2020-08-09 20:59:52

cfe5a wumpz 2020-08-09 20:58:15

Add generated sources to classpath. (#804)

14fb8 Matthieu Vergne 2020-08-09 20:53:38

008d9 wumpz 2020-08-09 20:51:34

COMMENT ON VIEW (#1024)

- implement COMMENT ON VIEW
testcase "testCommentOnView"
JSQLParser#1023
add more asserts

449f5 gitmotte 2020-08-09 20:49:05

fixes #1026

4f888 wumpz 2020-08-09 20:46:07

fixes #1026

4c323 wumpz 2020-08-09 20:39:48

fixes #1027

a923e wumpz 2020-08-09 20:31:26

fixes #1029

db6ac wumpz 2020-08-09 19:55:55

fixes #732

57a7d wumpz 2020-07-15 21:07:09

variable assignment implemented

cdd0f wumpz 2020-07-13 22:03:12

allowed Jdbc named parameters within interval expressions

869a7 wumpz 2020-07-12 21:25:43

allowed Jdbc named parameters within interval expressions

3602c wumpz 2020-07-12 21:25:05

some house keeping

8bcf2 wumpz 2020-07-11 20:39:37

fixes #1009

71d65 wumpz 2020-07-11 20:30:30

Add show tables support (#1015)

visual
implement show tables
Co-authored-by: Jan Monterrubio <Jan.Monterrubio@Cerner.com>

c0373 Jan Monterrubio 2020-07-11 16:43:42

let all deparsers extend AbstractDeParser (#1007)

let all deparsers extend AbstractDeParser
- add SelectDeParser(StringBuilder)
remove overriding setters/getters of buffer
#1007

2b790 gitmotte 2020-07-11 16:40:11

ea88e wumpz 2020-06-28 19:22:52

51e84 wumpz 2020-06-27 23:01:20

jsqlparser-3.2 (2020-06-28)

Other changes

cd742 wumpz 2020-06-27 22:29:23

partial func support (#1000)

9df19 Jan Monterrubio 2020-06-25 05:31:27

7a19a wumpz 2020-06-23 21:56:47

Support options for Explain (#996)

visual
issue-995
support verbose
postgres explain
tests
no text
Co-authored-by: Jan Monterrubio <Jan.Monterrubio@Cerner.com>

13873 Jan Monterrubio 2020-06-23 21:52:42

8c307 wumpz 2020-06-23 20:45:19

Support multiple lists for an IN clause (#997)

visual
wip
cleanup n test
polish
lookahead
Co-authored-by: Jan Monterrubio <Jan.Monterrubio@Cerner.com>

5de4a Jan Monterrubio 2020-06-20 22:10:38

fixes #999

ce8ee wumpz 2020-06-20 22:06:17

fixes #999

325cc wumpz 2020-06-20 21:57:10

Support ALTER SEQUENCE (#980)

support alter sequence
improve coverage

d34c8 Jan Monterrubio 2020-05-23 10:16:07

779a7 wumpz 2020-05-23 10:12:52

fixes #984

38597 wumpz 2020-05-16 21:14:26

fixes #984

60ac1 wumpz 2020-05-16 21:00:28

tests for issue

82894 wumpz 2020-05-14 21:16:52

d6bbc wumpz 2020-05-08 21:12:13

1ee7c wumpz 2020-05-08 20:19:13

fixes #981

d79b4 wumpz 2020-05-08 20:14:21

fixbuild (#978)

08b94 Jan Monterrubio 2020-04-30 04:42:04

Implement row movement clause for table creation (#974)

visual
implement row movement
support row + AS
Co-authored-by: Jan Monterrubio <Jan.Monterrubio@Cerner.com>

79b5f Jan Monterrubio 2020-04-28 07:02:51

Support CREATE SEQUENCE (#977)

wip
wip, some parsing
support sequence
implement feature
delete issue tests
compile it

a6a3c Jan Monterrubio 2020-04-28 07:01:10

ca76f wumpz 2020-04-19 19:50:28

fixes #962

3f918 wumpz 2020-04-18 21:53:14

implement feature (#972)

Co-authored-by: Jan Monterrubio <Jan.Monterrubio@Cerner.com>

aee39 Jan Monterrubio 2020-04-17 21:01:22

test method names changed

2b564 zhumaliev-rv 2020-04-03 05:31:40

added Oracle GRANT statement

fa215 zhumaliev-rv 2020-04-02 12:03:43

fixes #855

f3ecd wumpz 2020-03-25 22:42:33

fixes #915

9ce74 wumpz 2020-03-04 22:04:40

fixes #922

8abd6 wumpz 2020-03-01 00:00:26

65ad8 wumpz 2020-02-29 23:22:26

fixes #864

5783b wumpz 2020-02-15 21:31:55

fixes #701

8d43f wumpz 2020-02-15 20:43:38

fixes #945

ab405 wumpz 2020-02-14 23:19:47

fixes #944

e1ff1 wumpz 2020-02-14 23:02:57

fixes #944

22117 wumpz 2020-02-14 22:58:06

introduces sql server hints

92c74 wumpz 2020-02-14 19:40:15

introduces sql server hints

6a414 wumpz 2020-02-14 19:04:41

introduced view keyword

f12bb wumpz 2020-02-12 23:54:37

fixes #909

9b998 wumpz 2020-02-02 21:51:56

fixes #930

4c4a5 wumpz 2020-02-02 21:09:52

fixes #940

dc93a wumpz 2020-02-02 20:43:09

fixes #941 again :)

782dc wumpz 2020-02-02 20:22:40

fixes #941

ce392 wumpz 2020-02-01 23:49:17

fixes #924

d0cd8 wumpz 2020-02-01 23:21:52

Update README.md

a03d2 Tobias 2020-02-01 00:34:26

updated some maven plugins

3ba29 wumpz 2020-02-01 00:33:17

fixes #936

fixes #938

39e92 wumpz 2020-02-01 00:08:17

fixes #936

abf44 wumpz 2020-01-31 23:47:06

added keyword group to possible object names

430b3 wumpz 2020-01-27 06:42:20

fixes #923

775a0 wumpz 2020-01-25 23:09:35

fixes #923

57d50 wumpz 2020-01-25 23:09:18

started fixing #923

0f78d wumpz 2020-01-23 23:19:41

fixes #932

3490e wumpz 2020-01-23 21:57:59

fixes #918

3b89c wumpz 2020-01-23 21:26:58

fixes #921

f4b10 wumpz 2020-01-21 07:27:10

fixes #921

a23d3 wumpz 2020-01-21 07:26:35

fixes #929

a3c95 wumpz 2020-01-21 07:11:38

fixes #928

0bae6 wumpz 2020-01-21 06:58:58

fixes #927

62648 wumpz 2020-01-21 06:49:23

fixes #917

8de0f wumpz 2020-01-05 22:08:03

rewind #910

9ca4f wumpz 2020-01-03 00:03:35

Adding support for simple expressions in INTERVAL expressions (#910)

ebac9 Tomer Shay (Shimshi) 2019-12-20 06:14:04

removed null check

aba6f wumpz 2019-12-18 14:01:17

Update README.md

6fd3c Tobias 2019-12-02 15:55:47

5be06 wumpz 2019-12-01 22:12:59

82d8f wumpz 2019-12-01 22:12:54

Update README.md

f7ae7 Tobias 2019-11-27 20:26:12

fixes #899

switched to assertj from hamcrest

9707e wumpz 2019-11-23 23:18:56

Adding support for casting to SIGNED (#900)

73b3d Tomer Shay (Shimshi) 2019-11-20 09:39:47

Support parsing SELECT FOR UPDATE NOWAIT - Refer to documents on https://docs.oracle.com/cd/E17952_01/mysql-8.0-en/innodb-locking-reads.html#innodb-locking-reads-nowait-skip-locked (#896)

596e6 Yoon Kyong Sik 2019-11-16 10:07:59

added some doc to CCJSqlParserUtil

5242a wumpz 2019-11-13 08:31:40

Adding support for STRAIGHT_JOIN in the select clause (#861)

Adding support for straight_join in the select clause
Renaming the field name to reflect that this is a MySQL hint

3cdea Tomer Shay (Shimshi) 2019-11-09 20:30:54

Update README.md

a0077 Tobias 2019-11-08 07:53:42

47a94 wumpz 2019-11-06 22:36:04

jsqlparser-3.1 (2019-11-06)

Other changes

fixes #344

43862 wumpz 2019-11-06 22:23:56

fixes #344

782de wumpz 2019-11-06 22:23:06

Adding support for complex expressions in the ORDER BY clause (#890)

678ac Tomer Shay (Shimshi) 2019-10-31 07:19:03

fixes #884

1d8a9 wumpz 2019-10-26 21:38:48

fixes #880

7746b wumpz 2019-10-26 21:25:47

552bf wumpz 2019-10-26 20:41:45

Added support for Oracle UNPIVOT keyword. (#882)

Added support for Oracle UNPIVOT keyword.
Back to original version number.
Updated imports.
Added missing import.

bcc27 Pascal Mulder 2019-10-26 20:35:43

fixes #878

c2836 wumpz 2019-10-26 20:27:03

fixes #869

5b781 wumpz 2019-10-18 23:02:59

fixes #876

144e6 wumpz 2019-10-18 21:19:50

fixes #866

25e1d wumpz 2019-10-16 22:44:27

fixes #862

51c92 wumpz 2019-10-16 21:40:42

tests #874

1ecfc wumpz 2019-10-16 20:46:13

fixes #865

8a965 wumpz 2019-10-14 21:12:05

fixes #867

22229 wumpz 2019-10-09 08:40:11

fixes #867

6ef7e wumpz 2019-10-09 08:38:23

fixes #847

2147a wumpz 2019-10-05 22:41:29

allowing start as keyword for column and tablenames

f9bba wumpz 2019-10-05 22:39:45

allowing start as keyword for column and tablenames

cc6a4 wumpz 2019-10-05 22:37:57

fixes #859

8e61a wumpz 2019-10-01 06:14:39

Update README.md

c6441 Tobias 2019-09-30 23:04:05

Fixes linkage of SubSelect to Node

55783 PGrafkin 2019-09-22 19:02:33

fixes #845

d6b4e wumpz 2019-09-20 15:01:04

56ddc wumpz 2019-09-20 14:41:27

fixes #849

62a03 wumpz 2019-09-20 14:39:58

fixes #848

1d2c2 wumpz 2019-09-20 13:05:40

484ea wumpz 2019-09-20 13:05:14

fixes #850

1cd3c wumpz 2019-09-20 12:26:44

Update README.md

6191a Tobias 2019-08-29 21:32:25

jsqlparser-3.0 (2019-08-29)

Other changes

fixes #842

516ea wumpz 2019-08-26 22:12:59

fixes #750 - duplicate

dd7ed wumpz 2019-08-19 08:07:41

55974 wumpz 2019-08-14 15:23:23

c481c wumpz 2019-08-13 19:44:50

fixes #677

695d5 wumpz 2019-08-13 19:33:14

fixes #378

7a133 wumpz 2019-08-13 19:26:13

fixes #377

9b6c4 wumpz 2019-08-13 19:24:23

fixes #489

27139 wumpz 2019-08-13 19:21:27

fixes #648

fixes #638

74e02 wumpz 2019-08-13 19:19:12

36907 wumpz 2019-08-11 22:25:40

48dbd wumpz 2019-08-11 20:54:19

089e6 wumpz 2019-08-11 20:32:24

ca821 wumpz 2019-08-11 20:31:58

b3cfd wumpz 2019-08-11 08:36:52

d86cb wumpz 2019-08-11 08:08:22

68d01 wumpz 2019-08-11 08:06:16

fixes #838

1d1b6 wumpz 2019-08-09 21:22:53

fixes #826

7567d wumpz 2019-08-09 20:59:36

fixes #826

01296 wumpz 2019-08-09 20:49:18

30619 wumpz 2019-08-09 14:07:15

Delete ISSUE_TEMPLATE.md

9bea1 Tobias 2019-08-09 06:31:24

Update issue templates

1182e Tobias 2019-08-09 06:31:05

fixes #828

5139f wumpz 2019-08-08 21:16:23

fixes #828

8d0de wumpz 2019-08-08 21:11:19

c766e wumpz 2019-08-07 23:24:17

1a732 wumpz 2019-08-07 23:22:23

5c530 wumpz 2019-08-07 18:20:34

Updated test

47457 Tomer S 2019-08-05 20:14:23

Fix issue of missing comma between joins in subjoin

92db2 Tomer S 2019-08-05 19:43:18

Fix issue of missing comma between joins in subjoin

449c4 Tomer S 2019-08-05 19:32:41

e586f t.warneke@gmx.net 2019-08-03 23:27:55

Update latest version(1.4 => 2.1)

5768e yidasanqian 2019-08-02 09:29:48

added linkast to table

9c5f5 wumpz 2019-08-01 06:44:58

The duration part in INTERVAL expressions can contain a column and not only a constant - now supporting that use case

5492f Tomer S 2019-07-26 17:15:25

1314c wumpz 2019-07-22 22:00:36

2b944 wumpz 2019-07-22 21:17:54

86693 wumpz 2019-07-21 21:33:59

proof of correct parsing for #829

12ff2 wumpz 2019-07-21 21:27:36

fixes #830

a416b wumpz 2019-07-21 21:11:51

fixes #830

5fc7c wumpz 2019-07-21 21:08:22

914ee wumpz 2019-07-21 20:42:54

0b404 wumpz 2019-07-21 20:42:38

Update README.md

216bd Tobias 2019-07-19 06:23:59

Update README.md

7077d Tobias 2019-07-18 05:58:47

Update README.md

6148a Tobias 2019-07-18 05:57:14

Update README.md

f28b6 Tobias 2019-07-18 05:56:14

34014 wumpz 2019-07-17 22:46:55

allow jdk 11 build

73be3 wumpz 2019-07-17 22:36:28

allow jdk 11 build

2cf8e wumpz 2019-07-17 22:35:51

fixes limit as name for jdbc named parameters

7034c wumpz 2019-07-17 22:03:55

Update README.md

bf942 Tobias 2019-07-12 20:37:33

Update FUNDING.yml

448da Tobias 2019-07-12 20:33:32

Create FUNDING.yml

73c82 Tobias 2019-07-12 20:32:32

55f20 wumpz 2019-07-10 23:12:27

27552 wumpz 2019-07-10 21:43:51

moved to java 8

bfb8e wumpz 2019-07-09 22:41:18

39c6a wumpz 2019-07-09 22:31:35

6001f wumpz 2019-07-09 21:15:42

cfc3f wumpz 2019-07-09 21:12:01

Support default mode in full text search

ecb54 Tomer S 2019-07-07 18:04:00

0022e wumpz 2019-07-07 12:11:44

694d0 wumpz 2019-07-04 21:51:34

Add support for full text search (MATCH..AGAINST)

6750a Tomer S 2019-07-04 21:23:25

c88f5 wumpz 2019-07-04 20:51:01

Adding support for IS [NOT] TRUE/FALSE expressions

00839 Tomer S 2019-07-02 21:39:16

Adding support for the DIV operator

c8bbc Tomer S 2019-07-02 19:28:47

fixes #200 - was already fixed, introduced test case

4d100 wumpz 2019-07-02 12:43:46

fixes #259 - was already fixed, introduced test case

500ee wumpz 2019-07-02 12:40:33

fixes #262 - was already fixed, introduced test case

dbdfb wumpz 2019-07-02 12:36:31

fixes #113

cd16a wumpz 2019-07-02 12:28:02

424c8 wumpz 2019-06-30 19:55:27

d6949 wumpz 2019-06-30 17:08:23

Add support for STRAIGHT_JOIN

89089 Tomer S 2019-04-04 17:15:48

jsqlparser-2.1 (2019-06-30)

Other changes

fixes #812

38aad wumpz 2019-06-25 23:07:07

Update README.md

4763d Tobias 2019-06-25 12:28:29

Update README.md

334b5 Tobias 2019-06-25 12:27:52

Support KSQL's WINDOW

Add support for KSQL's WINDOW (HOPPING, TUMBLING and SESSION window)

ef911 Suyash Garg 2019-06-21 12:00:06

downgraded javacc version to allow java 7 build

6e7b9 wumpz 2019-06-19 07:33:53

downgraded checkstyle version to allow java 7 build

a9c29 wumpz 2019-06-19 07:29:55

Update README.md

b5915 Tobias 2019-06-16 22:11:11

afcc0 wumpz 2019-06-16 21:49:09

1d203 wumpz 2019-06-16 21:06:13

fixes #789

cdf80 wumpz 2019-06-16 21:02:47

fixes #450

83dba wumpz 2019-06-13 22:11:29

support postgresql create index syntax

9d74c theodore johnson 2019-06-13 22:02:11

fixes #705

9ce65 wumpz 2019-06-13 21:38:14

site update

89f20 wumpz 2019-05-29 13:40:18

fixes #798

dd806 wumpz 2019-05-24 21:09:13

fixes #796

aecc4 wumpz 2019-05-18 21:00:13

fixes #785

f59f2 wumpz 2019-05-04 22:54:28

Fix #786 (#787)

f2aba Ryan J Murphy 2019-04-22 22:28:38

44ff9 wumpz 2019-04-22 22:28:10

fixes #773 added nextval as a valid object name

94a2a wumpz 2019-04-17 08:15:50

85a3e wumpz 2019-04-17 07:05:47

8d4b3 wumpz 2019-04-17 07:00:01

703a7 wumpz 2019-04-17 06:43:37

recreated "old" javadocs (without improving it)

74e2a wumpz 2019-04-17 06:19:27

recreated "old" javadocs (without improving it)

4fed7 wumpz 2019-04-16 07:59:20

JavaDoc for Column#getTable (#782)

4f500 Andrea Arcuri 2019-04-15 12:01:37

e2168 wumpz 2019-04-13 23:57:14

fixes #777

35a1c wumpz 2019-04-12 22:30:00

tests #775

removed some not flags from some classes

8dda4 wumpz 2019-04-08 21:36:40

tests #754

97797 wumpz 2019-03-31 21:22:51

fixes #770

86ea6 wumpz 2019-03-28 22:19:33

f958f wumpz 2019-03-20 22:41:16

b1da6 wumpz 2019-03-20 22:37:59

fixes #766

1bb5c wumpz 2019-03-20 22:05:30

fixes #755 - corrected error introduced due to corrected ExpressionDeParser.

0002c wumpz 2019-03-20 09:57:29

fixes #755

a6905 wumpz 2019-03-20 09:38:36

aff50 wumpz 2019-03-20 06:46:44

7da90 wumpz 2019-03-20 06:45:31

18a3c wumpz 2019-03-20 06:35:17

activated new checkstyle plugin only if used java is at least 1.8

1b4e9 wumpz 2019-03-17 23:00:12

6ceb4 wumpz 2019-03-16 22:56:17

upgraded checkstyle due to security alert

cb172 wumpz 2019-03-16 22:40:36

Fixed typos in README.md (#760)

67dce alterdego 2019-03-14 12:20:26

update README.md (#762)

update latest version(1.4)

13d6a r548 2019-03-14 12:19:58

46323 wumpz 2019-03-12 07:56:12

jsqlparser-2.0 (2019-03-16)

Other changes

526b9 wumpz 2019-03-16 22:16:01

corrected test

4ad79 wumpz 2019-03-04 18:46:57

fixes #17

1ef39 wumpz 2019-03-04 00:26:21

refactored group by expressions into separate class, first step to support grouping sets

82f3d wumpz 2019-03-03 22:25:31

749ad wumpz 2019-02-26 23:09:43

Fixes 649 to add support for HOUR, MINUTE, SECOND date literals and support for identifiers as the interval parameter. (#756)

cbcf0 thebiguno 2019-02-25 22:23:16

c85e7 wumpz 2019-02-24 22:17:37

0f9bb wumpz 2019-02-24 19:59:06

fixes #649

and implemented ! for not and extended not expression

10e8e wumpz 2019-02-23 23:32:38

15297 wumpz 2019-02-20 23:30:16

12c05 wumpz 2019-02-20 23:20:35

14f92 wumpz 2019-02-20 23:05:20

fixes #164

8c057 wumpz 2019-02-20 22:41:50

fixes #169

e1193 wumpz 2019-02-20 21:43:45

fixes #479

0b5f5 wumpz 2019-02-19 22:29:58

fixes #479

b029b wumpz 2019-02-19 22:28:06

Update README.md

fa162 Tobias 2019-02-19 17:31:13

Added support for DROP INDEX, ADD UNIQUE INDEX, ALGORITHM and USING (#752)

Merge recent changes in the master from the master (#1)
changed license header to represent the projects dual license
changed license header to represent the projects dual license
changed license header to represent the projects dual license
changed license header to represent the projects dual license
Added support for comment(s) for column definitions in CREATE TABLE s… (#743)
Added support for comment(s) for column definitions in CREATE TABLE statements
Added support for comment(s) for column definitions in CREATE TABLE statements #2
To increase code coverage
To increase code coverage #2
Added support for 'ALTER TABLE CHANGE COLUMN' (#741)
Added support for 'ALTER TABLE CHANGE COLUMN oldName newName columnDefinition'. Please see https://dev.mysql.com/doc/refman/8.0/en/alter-table.html for reference.
Returned import ordering to avoid conflicts
Improved the tests somewhat
Now also test the getOptionalSpecifier() for both cases (null and not-null)
Expanded tests for ALTER TABLE ... CHANGE
implemented optimize for, fixes #348
implemented optimize for, fixes #348
Support for simple informix outer joins. (#745)
added support for simple informix outer joins
added some test code
added support for simple informix outer joins
added some test code
more testing for better code coverage
added support for simple informix outer joins
added some test code
more testing for better code coverage
fixes #747
fixes #733
fixes #707
Update README.md
Update README.md
Fix handles the following cases: 1) DROP INDEX 2) ADD UNIQUE INDEX 3) ALGORITHM 4) USING <index type>

2830c Prateek Gupta 2019-02-19 00:44:35

fixes #753

3209a wumpz 2019-02-19 00:35:14

Update README.md

4f74f Tobias 2019-02-15 21:12:05

Update README.md

f9609 Tobias 2019-02-15 21:07:41

fixes #707

a1c4f wumpz 2019-02-14 22:50:16

6c413 wumpz 2019-02-11 23:07:46

fixes #733

6da69 wumpz 2019-02-10 23:11:54

fixes #747

d3553 wumpz 2019-02-10 23:00:02

73305 wumpz 2019-02-10 22:55:01

f79f5 wumpz 2019-02-10 22:38:19

154cf wumpz 2019-02-10 21:54:45

80153 wumpz 2019-02-10 21:14:10

04151 wumpz 2019-02-08 07:13:18

Support for simple informix outer joins. (#745)

added support for simple informix outer joins
added some test code
added support for simple informix outer joins
added some test code
more testing for better code coverage
added support for simple informix outer joins
added some test code
more testing for better code coverage

53e24 Kurt Schwitters 2019-02-08 05:52:51

1a3d2 wumpz 2019-02-07 23:30:55

9ec7d wumpz 2019-02-07 23:30:00

63477 wumpz 2019-02-07 23:25:29

implemented optimize for, fixes #348

ff23d wumpz 2019-02-07 23:21:22

implemented optimize for, fixes #348

4b0b5 wumpz 2019-02-07 23:19:46

Added support for 'ALTER TABLE CHANGE COLUMN' (#741)

Added support for 'ALTER TABLE CHANGE COLUMN oldName newName columnDefinition'. Please see https://dev.mysql.com/doc/refman/8.0/en/alter-table.html for reference.
Returned import ordering to avoid conflicts
Improved the tests somewhat
Now also test the getOptionalSpecifier() for both cases (null and not-null)
Expanded tests for ALTER TABLE ... CHANGE

bfb80 Simon 2019-02-07 14:49:28

Added support for comment(s) for column definitions in CREATE TABLE s… (#743)

Added support for comment(s) for column definitions in CREATE TABLE statements
Added support for comment(s) for column definitions in CREATE TABLE statements #2
To increase code coverage
To increase code coverage #2

07b86 Prateek Gupta 2019-02-07 07:09:26

changed license header to represent the projects dual license

b9023 wumpz 2019-02-06 20:53:15

changed license header to represent the projects dual license

2adec wumpz 2019-02-06 20:48:58

changed license header to represent the projects dual license

4ad99 wumpz 2019-02-06 20:47:19

changed license header to represent the projects dual license

373c6 wumpz 2019-02-05 23:04:45

integrated some additional AST - Nodes for InExpression and SimpleExpressionList

cb0e0 wumpz 2019-02-04 01:17:35

4e0a7 wumpz 2019-02-03 23:20:03

case else corrected to allow conditions here as well

4f7a1 wumpz 2019-02-03 22:53:22

refactored outer not from sqlconditions, regularconditions to condition

aae36 wumpz 2019-02-03 21:07:08

refactored outer not from sqlconditions, regularconditions to condition

1956b wumpz 2019-02-03 20:57:41

strange not problem

ba3bf wumpz 2019-02-03 19:57:00

named exec procedure parameters

82b28 wumpz 2019-02-01 23:51:28

finished multi value set

479ee wumpz 2019-01-27 00:37:33

finished multi value set

ba4b0 wumpz 2019-01-27 00:35:17

started multivalue set

d991b wumpz 2019-01-26 00:44:59

corrected typing error. Both licenses could not be applied at the same time.

7cd18 wumpz 2019-01-23 23:22:12

allow top keyword as column / table / alias name

implemented tests

9e81e wumpz 2019-01-23 23:00:12

allow top keyword as column / table / alias name

implemented tests

ed95e wumpz 2019-01-23 22:58:39

implemented _utf8

fe28e wumpz 2019-01-23 21:36:42

implemented explain select

e5c6f wumpz 2019-01-22 23:28:33

implemented explain select

fb45d wumpz 2019-01-22 23:06:34

Add support for casting to signed integer (#734)

5b00a tomershay 2019-01-21 22:58:57

corrected stackoverflow while tables extraction

updated readme

04db1 wumpz 2019-01-20 22:33:51

implemented DescribeStatement, corrected TableNamesFinder, corrected corresponding interfaces and adapters, implemented tests.

1c411 wumpz 2019-01-20 22:24:47

started describe

some cleanup

25fa3 wumpz 2019-01-20 21:48:12

jsqlparser-1.4 (2019-01-09)

Other changes

Support Alter Table Add Unique Constraint (#708)

a54ea Robert Scholte 2018-12-30 23:37:29

corrected some failing tests

included a regression test for oracle files

aa932 wumpz 2018-12-30 23:06:59

Add 'SHOW COLUMNS FROM table' (#728)

f1724 Ohad Shai 2018-12-28 11:45:53

Support Alter Table Drop Constraint If Exists (#709)

Support Alter Table Drop Constraint If Exists
#709 add constraintIfExists flag

08fed Robert Scholte 2018-12-13 07:14:10

Support Alter Table Alter Column Type (#724)

b3263 Robert Scholte 2018-12-13 07:13:12

Support KSQL's WITHIN (#722)

Implements WITHIN for KSQL windowed joins
Clean up
Improve test
Implements WITHIN ( before TimeUnit, after TimeUnit ) for KSQL
Also restricts TimeUnit to units accepted by KSQL
WITHIN should come before ON

ae665 Lionel Montrieux 2018-12-11 21:53:07

Add support for truncate table (#719)

11be7 Bartosz Firyn 2018-12-06 06:41:30

fixes #718

c0801 wumpz 2018-12-04 15:23:42

added test for issue #716

f06b1 wumpz 2018-11-22 21:11:12

REPLACE VIEW as a synonym to ALTER VIEW (#711)

58d39 theodore johnson 2018-11-19 14:50:36

Update README.md

7b6cf Tobias 2018-10-26 19:39:58

Update README.md

78ebf Tobias 2018-10-26 19:38:42

22c04 wumpz 2018-10-26 11:12:37

some cleaning up for pr #702

b7754 wumpz 2018-10-25 12:40:09

support named parameters (#702)

eacb1 theodore johnson 2018-10-25 10:52:41

Added Oracle COMMENT statement (#685)

e79cc hishidama 2018-10-25 10:40:33

fix JSQLParser/JSqlParser #679 (#703)

0e35e softommy 2018-10-25 10:35:19

fixes #694

48544 wumpz 2018-10-18 20:50:58

fixes #675

d95e0 wumpz 2018-10-12 22:04:57

5aa63 wumpz 2018-10-12 21:26:26

295c1 wumpz 2018-10-10 21:02:12

a838f wumpz 2018-10-06 23:43:29

fixes #561

f5982 wumpz 2018-10-05 20:17:59

fixes #561

e170c wumpz 2018-10-05 20:15:58

integrated test for values query

96499 wumpz 2018-10-04 23:19:12

integrated values statement

c0327 wumpz 2018-10-04 22:29:11

fixes some lgtm alerts

de8ad wumpz 2018-10-04 08:14:00

fixes #684 (second)

2742a wumpz 2018-10-03 19:40:47

Update README.md

77026 Tobias 2018-10-02 22:17:03

jsqlparser-1.3 (2018-10-02)

Other changes

fixes #684

a8b3e wumpz 2018-10-02 21:59:16

fixes #682

c2833 wumpz 2018-09-20 05:48:34

Add LGTM.com code quality badges (#680)

3f620 Xavier RENE-CORAIL 2018-09-15 21:17:16

fixes #670

added testcase, corrected deparser

455c5 wumpz 2018-09-10 15:38:54

#670 (#671)

3950b mgierw 2018-09-10 15:21:40

testcase for #670

e6b9a wumpz 2018-09-10 15:13:58

fixes #676

1786e wumpz 2018-09-08 23:44:37

fixes #676

e32c5 wumpz 2018-09-08 22:12:46

26b2c wumpz 2018-09-07 21:59:47

0b03c wumpz 2018-09-07 21:48:03

Update README.md (#667)

Fix a couple typos/grammar issues

a822f Kai Presler-Marshall 2018-08-29 13:11:41

fixes #665

b806e wumpz 2018-08-27 06:51:39

fixes #367

14791 wumpz 2018-08-25 23:12:32

fixes #367

f6abb wumpz 2018-08-25 23:10:45

fixes #367

01bcb wumpz 2018-08-25 23:07:14

1a90b wumpz 2018-08-23 22:11:35

bfbfc wumpz 2018-08-23 20:26:56

make the CreateTable deparser use the accept/visit schema instead of the toString path (#663)

68194 theodore johnson 2018-08-23 04:21:10

fixes #661

44ea8 wumpz 2018-08-17 06:22:30

Parse Cloud Spanner raw string and byte prefixes (#659)

#656 parse cloud spanner raw string and byte literals
#656 fixed raw byte string prefix
#656 fixed test case
fixed reported codacy issue

a57db Knut Olav Løite 2018-08-14 08:12:26

78ff2 wumpz 2018-08-14 08:08:17

1d138 wumpz 2018-07-26 19:58:18

62bfd wumpz 2018-07-26 09:03:10

fixes #643

dc779 wumpz 2018-07-23 14:57:23

add test, fix style

98f87 theodore johnson 2018-07-16 21:35:35

added a test

cfa7e theodore johnson 2018-07-16 20:09:34

support teradata sortcut for Select

53c90 theodore johnson 2018-07-11 18:46:52

fix parsing and rendering of Truncate

f126d theodore johnson 2018-07-11 17:56:14

fixes #273

6cd54 wumpz 2018-07-06 08:44:03

fixes #273

12b4a wumpz 2018-07-06 08:31:55

fixes #573

3a5a6 wumpz 2018-07-06 07:01:12

add support for && operator

b59b4 Tomer S 2018-07-03 14:19:34

Extract "orderBy" and "Partition" classes from AnalyticExpression.

8da6e Assaf 2018-06-20 06:41:56

Update README.md

aff65 Tobias 2018-06-18 06:22:15

fixes #608

d529c wumpz 2018-06-17 09:57:15

fixes #608

3f5e3 wumpz 2018-06-17 09:48:18

fixes #163

6d954 wumpz 2018-06-17 09:39:36

fixes #163

1db3f wumpz 2018-06-17 09:33:54

first try dotted

2fab8 wumpz 2018-06-16 21:07:22

fixes #620

645d0 wumpz 2018-06-08 23:22:16

fixes #612

36ee6 wumpz 2018-06-08 22:51:12

fixes #612

60473 wumpz 2018-06-08 22:50:02

Update README.md

c5a0b Tobias 2018-05-16 06:18:32

Add javadoc badge

9c2c9 Jeremy Lin 2018-05-15 20:32:26

add maven-central badge (#616)

4d67d Benedikt Waldvogel 2018-05-14 09:13:39

fixes #614

32c4d wumpz 2018-05-12 22:51:33

094cc wumpz 2018-05-02 21:16:26

introduced junit annotations

d7c1e wumpz 2018-05-02 21:13:11

fixes #611

35cf1 wumpz 2018-05-02 21:08:22

fixes #610

5a60e wumpz 2018-05-02 20:48:08

fixes #610

c5c26 wumpz 2018-05-02 20:45:56

Update README.md

49b28 Tobias 2018-05-01 21:58:41

Adding support for MySQL's SQL_NO_CACHE flag

403e7 Tomer S 2018-03-25 09:03:23

jsqlparser-1.2 (2018-05-01)

Other changes

fixes #605

6e309 wumpz 2018-04-22 21:49:56

fixes #604

c8913 wumpz 2018-04-20 22:38:48

moved some jjt options from pom.xml to JSqlParserCC.jjt

e9a6c wumpz 2018-04-19 13:29:22

fixes #603

32930 wumpz 2018-04-19 08:35:31

fixes #600

e80ea wumpz 2018-04-13 07:55:00

change standard to jdk 8 with java 1.7 file compliance

c28a5 wumpz 2018-04-13 07:46:19

fixes #593

65276 wumpz 2018-04-08 22:37:28

fixes #597

ac34e wumpz 2018-04-08 21:17:12

4f63b wumpz 2018-04-02 23:42:44

fixes #592

1b5d2 wumpz 2018-04-02 22:37:47

- allow parenthesis around from item

- allow whitespace between bars from concat

2cea3 wumpz 2018-03-29 22:25:48

- allow parenthesis around from item

- allow whitespace between bars from concat

dabb0 wumpz 2018-03-29 22:24:33

7d366 wumpz 2018-03-23 07:26:30

fixes #588

a04cc wumpz 2018-03-17 00:40:36

fixes #588

801cd wumpz 2018-03-17 00:40:06

JSQLPARSER-584: adds support for MySQL (a,b,...)OP(c,d,...) expression (#585)

JSQLPARSER-584: adds support for MySQL (a,b,...)OP(c,d,...) expression
JSQLPARSER-584: adds some tests and rename MySQLValueListExpression to ValueListExpression

2c272 Adrien Lesur 2018-03-05 23:08:55

checked #266

72059 wumpz 2018-02-14 08:43:51

fixes #583

76ed9 wumpz 2018-02-14 08:37:38

fixes #583

3768b wumpz 2018-02-14 08:36:26

tested issue 582

84459 wumpz 2018-02-09 07:18:06

Create ISSUE_TEMPLATE.md

d5ec2 Tobias 2018-02-08 07:12:19

removed unneeded dependencies

445b1 wumpz 2018-02-07 10:46:12

feaea wumpz 2018-02-02 12:46:17

18d01 wumpz 2018-02-02 12:45:51

Fix issue #563: subjoin allows only one inner join, this should be a … (#564)

Fix issue #563: subjoin allows only one inner join, this should be a list
Fix failing Oracle tests because of confusion between subjoin and subselect.

8456a Frits Jalvingh 2018-02-02 10:40:01

fixes #320 (#576)

fixes #320

e6451 Taner Mansur 2018-02-01 14:55:37

21e8b wumpz 2018-02-01 14:54:12

fixes #566,#438,#267

bf951 wumpz 2018-01-30 14:10:17

fixes #566,#438,#267

ccbe9 wumpz 2018-01-30 14:09:12

tests #572

5d609 wumpz 2018-01-29 15:43:04

corrected generics type

ed1a2 wumpz 2018-01-22 07:34:55

fixes #567

0d4ae wumpz 2018-01-12 07:36:54

removed "removed" project bewa

dec98 wumpz 2018-01-08 07:44:24

fixes #338

0e571 wumpz 2018-01-05 23:29:00

fixes #545

ab7e2 wumpz 2018-01-05 23:16:29

fixes #462

83844 wumpz 2017-12-28 00:50:29

fixes #462

bc005 wumpz 2017-12-28 00:47:37

Update README.md

5871c Tobias 2017-12-27 20:04:29

Update README.md

dd6bb Tobias 2017-12-07 10:25:11

fixes #554

4ce98 wumpz 2017-12-07 08:55:52

ee723 wumpz 2017-12-04 08:36:46

fixes #543

bdc20 wumpz 2017-12-04 08:35:07

fixes #551

a25fb wumpz 2017-12-04 08:14:06

made some modifications to rlike fix

f0ffe wumpz 2017-11-16 22:29:53

Added support for RLIKE expressions (#544)

RLIKE is a synonym of REGEXP, therefore should be treated the same.

8a950 sh-tomer 2017-11-16 22:10:51

jdk 1.7

8d4f2 wumpz 2017-11-07 09:43:35

modern template included

9ea8e wumpz 2017-11-07 07:31:58

fixes #540,#526

8bc23 wumpz 2017-11-03 07:21:40

fixes #540,#526

ab868 wumpz 2017-11-03 07:18:39

corrected a lookahead issue

a2f81 wumpz 2017-10-31 22:37:41

Add ability to support "NOT LIKE ..." expressions (#539)

The parser is able to parse expressions such as "a NOT LIKE '%pattern%'", but is not able to parse expressions where the not is before the entire expression. For example: "NOT a LIKE '%pattern%'.
When parsing the latter, the error is:
Caused by: net.sf.jsqlparser.parser.ParseException: Encountered " "LIKE" "LIKE "" at line 1, column 32.
Was expecting one of: ...
The reason this is important is both because these syntaxes are both valid, and also because the deparser uses the second method.
Therefore, if you parse a query with the first type of expression, then deparse it and parse again, you'll get the same error.

daea3 sh-tomer 2017-10-31 20:27:50

452ba wumpz 2017-10-29 23:20:57

14523 wumpz 2017-10-29 23:08:39

7c90a wumpz 2017-10-29 22:59:21

Linking structures to their AST nodes to have access to their positions (#534)

Linking several structures to their AST nodes to have access to their positions
This far there were only 3 types of structures linked to their AST nodes. Now adding some more expressions and literals to their AST node to have access to their token's position in the query.
Added missing parts in JSQqlParserCC.jjt for AST linking to work
Added missing parts in JSQqlParserCC.jjt to make sure all relevant code is created to generate and link AST nodes to the relevant structures.

514f2 sh-tomer 2017-10-29 12:39:56

add debug note (#531)

added a link to the visualize parsing section to have a visible debug mode (so users that create an issue can try to get us better output)

b1abc Jan Monterrubio 2017-10-25 06:21:26

fixes #525 (#530)

fixes #525
Simply unit test.

1a1a1 Linyu Chen 2017-10-24 05:30:39

simplified tests for SQL_CALC_FOUND_ROWS

e23d4 wumpz 2017-10-20 07:32:58

Implements #509 (#504)

Supporting MySql hit SQL_CALC_FOUND_ROWS for selecting row count.
Supporting MySql hit SQL_CALC_FOUND_ROWS for selecting row count. - refactoring
Supporting MySql hit SQL_CALC_FOUND_ROWS for selecting row count. - missing copyright.ˆ
Supporting MySql hit SQL_CALC_FOUND_ROWS for selecting row count. - Modify field type to boolean for prevent memory consumption by creating object and try assertSqlCanBeParsedAndDeparsed on unit test.

3e163 Yoon Kyong Sik 2017-10-20 07:27:48

fixes #522

45ac8 wumpz 2017-10-12 21:27:57

fixes #522

2c69c wumpz 2017-10-12 21:22:26

fixes #510

f64ad wumpz 2017-10-09 23:51:46

1a771 wumpz 2017-10-06 08:58:01

fixes #508 including precedence

8037a wumpz 2017-10-06 08:36:57

fixes #519

fixes #520

27217 wumpz 2017-10-06 08:24:04

transformed primary expression and sign parsing

51fcd wumpz 2017-10-06 07:11:58

corrected token definition order

64ce9 wumpz 2017-10-06 07:01:35

waiting for javacc/javacc#28

704e6 wumpz 2017-10-02 09:14:01

Fix test case

b2bb2 Nathaniel Camomot 2017-09-27 08:10:08

Fix for some cases where TablNamesFinder can't find tables

395c3 Nathaniel Camomot 2017-09-27 06:21:21

removed oraclejdk7 travis build due to travis-ci/travis-ci#7964

812f9 wumpz 2017-09-24 09:55:31

96b5d wumpz 2017-09-24 09:48:35

b847e wumpz 2017-09-23 22:40:30

Create LICENSE_LGPLV21

d2c87 Tobias 2017-09-23 22:29:45

Create LICENSE_APACHEV2

f9c1a Tobias 2017-09-23 22:29:09

fixes #515

c4b36 wumpz 2017-09-23 22:20:51

fixes #515

1afe7 wumpz 2017-09-23 22:18:35

fixes #515

8388f wumpz 2017-09-23 22:17:04

Update README.md

3f734 Tobias 2017-09-23 21:38:51

fixes #514

8a459 wumpz 2017-09-23 21:32:10

fixes #514

3e846 wumpz 2017-09-23 21:29:52

merge of within_group and analytic

26fab wumpz 2017-09-23 21:24:18

c5a47 wumpz 2017-09-22 12:29:44

#fixes 480

10352 wumpz 2017-09-12 21:59:08

#fixes 480

e60fa wumpz 2017-09-12 21:58:39

fixes #512

07a14 wumpz 2017-09-07 22:20:01

fixes #505

ef55f wumpz 2017-08-28 08:13:14

fixes #502

6a440 wumpz 2017-08-26 14:18:07

fixes #502

41ea8 wumpz 2017-08-26 14:14:13

fixes #484

1a6f9 wumpz 2017-08-23 20:41:06

fixes #484

8f9b6 wumpz 2017-08-23 20:40:26

replace support multiple values

93598 wanghai 2017-08-21 09:15:27

fixed #491

147ec wumpz 2017-08-16 15:47:01

fixed #491

24f23 wumpz 2017-08-16 15:45:55

checked issue #482

71692 wumpz 2017-08-07 13:33:12

fixes #485

64bc5 wumpz 2017-08-03 05:57:10

fix issue #424 (INSERT with SET) (#481)

update insert with set language
update insert with set
update insert with set
update insert test
add removed lines

ca653 messfish 2017-07-28 06:23:33

fixes #456

9c2cc wumpz 2017-07-27 11:14:26

introduced partial / nonpartial parse for CCJSqlParserUtil methods

6b452 wumpz 2017-07-27 05:47:13

fixes #473

0aa22 wumpz 2017-07-18 06:24:20

Update README.md

58c42 Tobias 2017-06-29 21:37:30

Update README.md

d235c Tobias 2017-06-29 21:34:47

jsqlparser-1.1 (2017-06-29)

Other changes

fixes #468

6cb45 wumpz 2017-06-28 08:50:50

fb64e wumpz 2017-06-11 21:50:53

Add Upsert Grammer (#460)

Add files via upload
Add files via upload
Add files via upload
Add files via upload
Add files via upload
Add test for de parser
Add files via upload
Add files via upload
Add files via upload
Add files via upload
Add files via upload
Add files via upload
Add files via upload
Add files via upload
Add files via upload

aaeb8 messfish 2017-06-11 18:48:53

introduced linking between Function and ASTNode

3e75c wumpz 2017-06-09 22:34:23

introduced linking between Function and ASTNode

e96f4 wumpz 2017-06-09 22:32:16

fixes #457

2ae5e wumpz 2017-05-26 21:34:35

e4ef6 wumpz 2017-05-23 07:32:52

Fix issue #442 (#451)

Fix issue #442 for delete statements
Fix issue #442 for insert statements
Mock only when necessary
E.g., interfaces, behavior needs to be verified, etc.
Prefer the first style of testing
As discussed in issue #442
Fix issue #442 for replace statements
Improve readability of issue #442 tests
Inject SelectDeParser as well
As discussed in issue #442.
Fix issue #442 for select statements
Fix issue #442 for update statements
Fix issue #442 for execute statements
Fix issue #442 for set statements
Fix PR code review issue
https://www.codacy.com/app/wumpz/JSqlParser/file/6682733346/issues/source?bid=4162857&fileBranchId=4580866#l48
Skip PMD check for asserts in tests using Mockito
As agreed upon in the discussion in PR #451.
Use correct PMD check name

9d680 chrycheng 2017-05-22 07:13:41

fixes #430

585cb wumpz 2017-05-16 22:04:19

Fix issue #446 (#447)

Test current behavior of ExecuteDeParser
Fix issue #446

275fb chrycheng 2017-05-16 20:46:29

fixes #449

fe6da wumpz 2017-05-16 14:12:50

introduced test for 437

3e740 wumpz 2017-05-12 19:43:14

test issue 445

fce59 wumpz 2017-05-11 08:37:49

1fbf6 wumpz 2017-05-08 12:32:25

updated readme

1dabc wumpz 2017-05-07 20:37:31

some minor changes

050b8 wumpz 2017-05-07 20:35:15

conversion to CNF (#434)

Add files via upload
Create foo
All the files needed for the CNF conversion
Delete foo
Create foo
Test cases for the CNF conversion
Delete foo
Add files via upload
Add files via upload
change some public methods to private
Delete CNFConverter.java
Delete CloneHelper.java
Delete MultiAndExpression.java
Delete MultiOrExpression.java
Delete MultipleExpression.java
Create foo
Add files via upload
Delete CNFTest.java
Delete StepLastHelper.java
Create foo
Add files via upload
Delete foo
Delete foo
Add files via upload
Add files via upload
Delete CNFConverter.java
Delete CloneHelper.java
Delete MultiAndExpression.java
Delete MultiOrExpression.java
Delete MultipleExpression.java
Create foo
Add files via upload
Delete foo
Delete CNFTest.java
Create foo
Add files via upload
Delete foo
Add files via upload
Add files via upload

afe10 messfish 2017-05-07 20:21:00

56497 wumpz 2017-05-02 06:06:33

corrected bug within RelObjectNameExt processing

7b2b0 wumpz 2017-05-02 06:00:44

Update README.md

2c0f2 Tobias 2017-04-28 07:37:09

Update README.md

80c98 Tobias 2017-04-28 07:35:42

59310 wumpz 2017-04-24 13:25:21

Introduce support for mysql index hints (fixing issue #374) (#429)

Introduce support for mysql index hints (fixing issue #374)
Fix checkstyle errors
-Converted indent tabs to spaces
-Added missing {} on single-line if statement

6db15 Joey Mart 2017-04-18 06:22:25

#425 ADD CONSTRAINT also support state such as DEFERRABLE, VALIDATE... (#426)

f1113 Christophe Moine 2017-04-17 23:40:45

Addressing #427 (#428)

updating readme with Maven requirements
removing ticks

0fddc AnEmortalKid 2017-04-17 23:39:05

going back to checkstyle 6.x due to java7 incompatibilities

564ac wumpz 2017-04-17 23:27:10

Update README.md

30b09 Tobias 2017-04-17 23:09:06

Update README.md

2b5c8 Tobias 2017-04-17 23:05:07

checkstyle source check included. configuration done

12377 wumpz 2017-04-17 23:01:42

checkstyle source check included. configuration done

1bdf5 wumpz 2017-04-17 22:57:12

improved StatementVistorAdaptor to process all statements.

27119 wumpz 2017-04-11 07:47:22

removed linefeed check, due to multiple git checkout configurations regarding linefeeds

aab56 wumpz 2017-03-31 08:04:24

2f5a1 wumpz 2017-03-29 06:07:20

corrected source files regarding checkstyle errors

0d6fa wumpz 2017-03-28 09:46:55

introduced some more checkstyle rules

c7a86 wumpz 2017-03-28 09:30:00

removed problematic profile "check.sources" activation, excluded generated-sources, included test-sources

e2cc2 wumpz 2017-03-27 11:48:50

removed problematic profile "check.sources" activation, excluded generated-sources, included test-sources

e941f wumpz 2017-03-27 11:45:39

removed problematic profile "check.sources" activation, excluded generated-sources, included test-sources

dd23f wumpz 2017-03-27 11:14:44

removed auto activation due to travis problems, included test sources

759e7 wumpz 2017-03-27 10:53:46

checkstyle

62505 wumpz 2017-03-27 09:16:11

Update README.md

da9ac Tobias 2017-03-25 22:21:59

jsqlparser-1.0 (2017-03-25)

Other changes

32e8f wumpz 2017-03-25 22:00:13

a31b2 wumpz 2017-03-25 21:52:19

f731f wumpz 2017-03-25 21:47:42

reformating hole sourcecode

4146f wumpz 2017-03-22 07:36:17

Fix #407 by enhancing grammar (#410)

Fix #407 by enhancing grammar
Change LF and tabs

5d901 Christophe Moine 2017-03-22 07:36:14

removed dependencies

dd1b3 wumpz 2017-03-20 10:22:55

fixes #406

06619 wumpz 2017-03-17 11:55:11

update to JavaCC 7.0.2

c12f7 wumpz 2017-03-15 10:28:17

Update README.md

6312f Tobias 2017-03-15 08:55:03

update readme

03746 wumpz 2017-03-15 08:45:24

update readme

5bbfe wumpz 2017-03-15 08:44:22

6e72b wumpz 2017-03-14 11:41:26

corrected merge conflict

1211d wumpz 2017-03-14 11:39:30

corrected case when expressions

12cc4 wumpz 2017-03-14 11:12:53

rewrote some lookaheads

2a440 wumpz 2017-03-14 10:33:21

replace some junit pre 4.x artifacts

7dd85 wumpz 2017-03-14 09:55:42

first rewrite of SelectBody

49127 wumpz 2017-03-14 09:43:25

5dcef wumpz 2017-03-10 22:13:02

Support FOR UPDATE WAIT (#405)

Adding FOR UPDATE WAIT support
removing final peppered everywhere
updating formatting, fixing codacy test names
updating asserts to use static import
reverting changes
reverting line feeds
adding tests and deparser code back without formatting

45b39 AnEmortalKid 2017-03-10 22:06:53

add support for LIMIT with only one row count JDBC parameter (#404)

small but powerfull change 👍

42318 zhushaoping 2017-03-03 07:06:08

merged

c3eed wumpz 2017-03-03 07:03:08

fixes #401

1315d wumpz 2017-03-01 08:20:55

fixes #402

6fb15 wumpz 2017-03-01 07:55:25

release 0.9.7

46720 wumpz 2017-02-26 23:13:50

jsqlparser-0.9.7 (2017-02-26)

Other changes

updated readme

e2dc3 wumpz 2017-02-21 08:49:56

commented an issue test

4fe4c wumpz 2017-02-21 08:46:38

set statemet with optional equals

ec6ce wumpz 2017-02-11 23:57:32

fixes #393

320f6 wumpz 2017-02-10 09:34:47

42f32 wumpz 2017-02-08 08:17:40

removed unused imports

c66cc wumpz 2017-02-08 08:15:51

minor code improvements

e3fd2 wumpz 2017-02-08 08:13:58

Update README.md

3d05e Tobias 2017-02-07 18:09:26

fixes #390

546b7 wumpz 2017-02-01 15:27:48

d4396 wumpz 2017-01-27 20:53:20

fixes #389

71c32 wumpz 2017-01-27 20:39:25

included LOOKAHEAD

6776e wumpz 2017-01-20 23:12:17

updated readme

b5f6e wumpz 2017-01-20 22:10:59

updated readme

1abd2 wumpz 2017-01-20 22:00:07

Increase test coverage on AlterExpression.java

getOperation
getFkColumns
getFkSourceTable
getFkSourceColumns
getConstraintName
tried getPkColumns but it does not behave as I expected.
placed TODO in AlterTest.testAlterTablePK for this
getIndex().getColumnNames

5a799 jthomas 2017-01-19 19:43:24

Enhance AlterExpression grammar:

1. optional "COLUMN" keyword in ADD alter operation
1. new alter operation: MODIFY
1. add column specs to alter table column definitions

24177 jthomas 2017-01-19 17:32:21

support to add jdbc name parameter after LIMIT and TOP keywords

e25e2 zhushaoping 2017-01-13 02:55:52

fixes #288

091c5 zhushaoping 2017-01-12 07:09:57

tests for issue 379 included

f7c27 wumpz 2017-01-04 07:22:19

tests for issue 379 included

14a9b wumpz 2017-01-04 06:49:43

updated readme

1899c wumpz 2017-01-02 13:32:56

fixes #375

fixes #371

957f3 wumpz 2017-01-02 13:30:09

fixed NPE in ExpressionVisitorAdapter when SubSelect doesn't has withItemsList

28979 Donghang Lin 2016-12-21 07:14:48

5bc1f wumpz 2016-12-06 22:08:00

fixed #363

66e44 wumpz 2016-12-01 06:52:45

integrated some tests

5937b wumpz 2016-11-14 11:47:43

corrected fix #311 and fix #332, introduced unaliased fqn of column

88804 wumpz 2016-09-26 12:33:24

fixes #341

b3faf wumpz 2016-09-20 21:53:32

Update README.md

98ded Tobias 2016-09-17 14:34:21

corrected some lookaheads

7c157 wumpz 2016-09-16 11:52:08

Updated header and removed unused methods.

2bfc9 Peter Borissow 2016-09-15 15:28:59

Added json parsing tests.

7c740 Peter Borissow 2016-09-15 14:59:01

Added support for PostgreSQL JSON Functions and Operators.

a5504 Peter Borissow 2016-09-14 02:28:01

Add support for more Postgres Create Table options

04c56 Rob Story 2016-09-09 21:02:57

fixes #334

21a0d wumpz 2016-09-01 07:45:04

8e229 wumpz 2016-09-01 06:50:59

e6e7e wumpz 2016-09-01 06:46:49

Support additional Postgres column types for alter table statements

42181 Rob Story 2016-08-30 14:22:55

fixes #330

03a34 wumpz 2016-08-29 07:13:00

fixes #329

3df49 wumpz 2016-08-28 21:06:08

updated readme

2acae wumpz 2016-08-23 20:02:35

jsqlparser-0.9.6 (2016-08-23)

Other changes

#modify net.sf.jsqlparser.statement.insert.Insert Method:toString() if itemsList and useSelectBrackets together not null will error

#modify PlainSelect.getStringList change sql append to StringBuilder

471b9 zheng.liu@baifendian.com 2016-08-15 06:22:23

corrected some lookaheads parsing delete statements

57890 wumpz 2016-08-14 12:59:27

some cleanup

d34eb wumpz 2016-08-13 22:20:27

Update Alter and add AlterExpression class for multiple ADD/DROP expressions in a single ALTER statement

Update .jjt file to break out the AlterExpression into its own class and for Alter to compose multiple AlterExpressions
Update AlterTest for new AlterExpressions and test for multiple ADD/DROP statements in a single ALTER

e8d1c Rob Story 2016-08-11 19:24:41

Support for parse delete from table using join to another table like:

DELETE posts
FROM posts
INNER JOIN projects ON projects.project_id = posts.project_id
WHERE projects.client_id = :client_id
This necessitated some changes to the DeleteTest class,
specifically:
JSqlParserCC.jjt - changes on grammar of Delete statements.
Delete toString and DeleteDeParser.

b6eb5 Lucas Oliveira 2016-08-06 16:28:11

fix bug of TablesNamesFinder when SubSlect has withItemsList, add corresponding test case

276dd Xin Quan 2016-08-04 01:44:08

fixes #309

37f06 wumpz 2016-08-03 22:02:45

fixes #309

acd16 wumpz 2016-08-03 22:02:04

fixes #303

043a5 wumpz 2016-08-03 21:31:11

fixes #303

76982 wumpz 2016-08-03 21:30:04

intruced new test for oracle join syntax

cb8dd wumpz 2016-08-03 21:05:38

fixes #246

822bb wumpz 2016-07-31 20:56:56

fixes #247

42636 wumpz 2016-07-28 20:13:41

test for issue 265

59f7e wumpz 2016-07-24 22:28:08

fixes #292

f0b35 wumpz 2016-07-24 22:13:37

fixes #299

d2ad3 wumpz 2016-07-24 22:05:14

fixes #311

dfd2f wumpz 2016-07-22 07:25:01

84bf0 wumpz 2016-07-21 14:08:19

first try of error recovery for statement and statements

a7247 wumpz 2016-07-21 07:33:49

some refactoring

1e307 wumpz 2016-07-18 16:50:28

The previous pull request broke the build. Besides being a keyword, 'double' is also a function name. Add K_DOUBLE to the RelObjectNameExt() function to pick up this distinction.

8bfc1 Tom Moore 2016-07-11 19:14:06

Add a double precision cast type

60ad1 Tom Moore 2016-07-11 17:59:53

removed one lookahead and improved parenthesis parsing

84a88 wumpz 2016-06-30 18:41:06

removed one lookahead and improved parenthesis parsing

51b39 wumpz 2016-06-30 18:37:23

fixes #296

refactored getTableList method of TableNamesFinder

3ccca wumpz 2016-06-28 12:16:39

fixes #295

b877d wumpz 2016-06-28 08:19:36

fixes #293

c1d0b wumpz 2016-06-28 00:11:15

introduced OSGi metadata

89daf wumpz 2016-06-23 21:58:22

fixes #291

63fa2 wumpz 2016-06-23 21:40:57

fixes #291

da42b wumpz 2016-06-23 21:37:51

fixes #278

12341 wumpz 2016-06-21 23:02:11

fixes #278

faf8c wumpz 2016-06-21 22:58:40

fixes #287

b1bea wumpz 2016-06-21 20:50:02

fixes #270

37c83 wumpz 2016-06-21 20:12:55

d3d66 wumpz 2016-06-20 07:08:58

0d1d1 wumpz 2016-06-19 21:15:55

fixes #284

8e7ba wumpz 2016-06-19 20:09:07

Implemented table check constraint for named constraints.

1. Added named constraint to create table.
1. Added check constraint to alter table statement.
1. Added CheckConstraint type.
Tests:
1. Added create table test.
1. Added alter table test.

401d2 Megan Woods 2016-06-16 14:56:01

04fc3 wumpz 2016-06-15 20:50:52

bddbe wumpz 2016-06-15 20:45:51

Implemented:

1. UPDATE .. RETURNING col, col as Alias
1. UPDATE .. RETURNING *
Tested:
1. UPDATE .. ORDER BY .. LIMIT .. RETURNING
1. UPDATE .. RETURNING
Item 4 represents the PostgreSQL UPDATE .. RETURNING Syntax without ORDER BY and LIMIT.
See: https://www.postgresql.org/docs/9.5/static/sql-update.html

f4526 Megan Woods 2016-06-15 09:12:14

40aba wumpz 2016-06-12 11:12:57

-- added scalar time functions of ANSI SQL

f51df ChrissW-R1 2016-06-08 12:57:26

24c87 wumpz 2016-06-06 21:50:44

updated readme

3bc31 wumpz 2016-05-24 09:45:34

Add a test-case for Hive's LEFT SEMI JOIN

e56fb Vu Nhan 2016-05-19 04:53:22

Add support for Hive's LEFT SEMI JOIN

fd03a Vu Nhan 2016-05-19 04:05:43

fixes #243

bb978 wumpz 2016-05-16 20:49:58

fixes #243

780ba wumpz 2016-05-16 20:47:32

fixes #261

10e68 wumpz 2016-05-16 20:03:07

updated readme

77ba3 wumpz 2016-05-06 06:06:33

57145 wumpz 2016-04-28 22:15:18

Added ability to have operators like '>=' or '<=' separated by a space.

This includes:
Modifying the JJT syntax to support the 'space in the middle' versions
of operators (any quantity of whitespace is supported).
Modifying the various operators to inherit from a new
'ComparisonOperator' class, which handles the (previously NotEqualsTo-
only) logic for capturing the form of the operator.
Giving each of the various operators a constructor that accepts the
syntax used.
Modifying TestUtils to strip comments out before comparing SQL text
(necessary because condition07.sql is now passing, and has a comment).
Updating SpecialOracleTest to indicate 130 tests passing now
(condition7.sql now passes).
Adding a new test specifically for operators into SpecialOracleTest.
NOTE: Because the "! =" form of the 'not equals' operator means something
different in PostgresSQL (factorial of previous argument + equals), we do
NOT include that case.

9886b Dave Lindquist 2016-04-28 13:28:58

Corrected "MERGE INTO" parsing for more complicated statements.

Specifically:
Changed "Condition" to "Expression" for the "ON" clause -- this is
needed to handle "ON" clauses that have "a = y AND b = z" or other
more complicated expressions (basically the same as the "ON" clause
in a SELECT query).
Also changed the "WHERE" and "DELETE WHERE" clauses in the same
fashion ('Condition' becomes 'Expression'), as they too support
multiple conditions.
Corrected the toString on the MergeUpdate clause, which was missing a
comma between the fields.
Added a new, more complicated MERGE INTO statement to the MergeTest
class.

7efd5 Dave Lindquist 2016-04-28 13:19:34

added for update test

d54b8 wumpz 2016-04-27 14:23:55

fixes #253

75be4 wumpz 2016-04-26 06:11:13

fixed #245

01287 wumpz 2016-04-15 22:01:56

fixes #244

2204a wumpz 2016-04-15 20:10:32

Update README.md

ac4a5 Tobias 2016-04-14 19:30:09

fixes #240

fixes #241

7f8b5 wumpz 2016-04-05 06:25:57

small modifications, reduces some semantic lookaheads

7f5b6 wumpz 2016-03-29 11:34:17

fixed #228

3dfae wumpz 2016-03-17 08:40:24

fixed #228

8f9b2 wumpz 2016-03-17 08:38:35

fixed #232 without correction of order of update and insert

7e2e7 wumpz 2016-03-17 08:28:47

fixed some whitespace differences between deparser and toString regarding NOT expression

f4b25 wumpz 2016-03-17 08:16:24

Update README.md

12009 Tobias 2016-03-17 07:51:11

update release info

eccd6 wumpz 2016-03-14 00:27:18

Fixing uncaught exception

4fad4 emopers 2016-01-12 19:30:52

jsqlparser-0.9.5 (2016-03-13)

Other changes

no message

ffcfe wumpz 2016-03-13 23:55:09

3c863 wumpz 2016-03-13 23:35:37

introduced boolean values within conditions

36a62 wumpz 2016-03-10 21:19:22

introduced boolean values within conditions

a8333 wumpz 2016-03-10 21:16:28

introduced boolean values within conditions

68e5b wumpz 2016-03-10 21:11:01

fixes #230

19915 wumpz 2016-03-07 23:17:40

multiple code improvements: squid:S1905, squid:S00122, squid:S1155, squid:S00105

905b2 George Kankava 2016-03-03 11:40:31

fixed #226

67b17 wumpz 2016-02-27 13:54:58

fixes #223

04e5c wumpz 2016-02-11 21:23:51

reduces a bunch of dynamic lookaheads to fixed ones

4c764 wumpz 2016-02-11 20:51:02

integrated changes of #225

eb5d7 wumpz 2016-02-11 20:41:23

Multiple code improvements fix 1: squid:S1199, squid:S1066, squid:S1854, squid:S1165

af5d3 George Kankava 2016-02-10 16:11:10

Update README.md

e455c Tobias 2016-02-10 06:43:04

improved parsing performance

c78aa wumpz 2016-02-09 22:30:20

fixes #221

579f0 wumpz 2016-02-04 22:10:43

fixes #221

4a12d wumpz 2016-02-04 22:07:12

cleaned up some lookaheads

0cc80 wumpz 2016-02-04 08:58:52

36a4a wumpz 2016-02-02 06:45:45

fixes #217

de61c wumpz 2016-02-02 06:21:59

Added reference options foreign keys support (ON UPDATE/DELETE NO ACTION/CASCADE) and Full text indexes (FULLTEXT idx(text1))

c2956 pabloa 2016-02-01 21:57:27

multiple code improvements 1

e6bec George Kankava 2016-02-01 07:35:08

Support of mysql create statements with timestamp column with ON UPDATE. Example: CREATE TABLE test (applied timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP)

9dcaa pabloa98@gmail.com 2016-01-24 08:37:38

fixes #151

f5b51 wumpz 2016-01-06 09:12:54

corrected lookahead for tablefunctions

8036e wumpz 2015-12-09 22:01:02

TableFunction extends FunctionItem

17371 tfedkiv 2015-12-08 08:39:07

added TableFunction alias suppurt

added TableFunction unit tests

88edd tfedkiv 2015-12-07 15:27:02

fixed verion

a5a5f ftaras 2015-12-07 14:25:07

added support of SELECT FROM table function (h2)

0403f tfedkiv 2015-12-07 14:23:39

replaced size() with isEmpty()

1d634 wumpz 2015-12-06 22:03:20

jdk 8 build included into travis

830be wumpz 2015-11-27 22:12:36

increased version of maven-javadoc-plugin

1b842 wumpz 2015-11-26 07:34:47

01d25 wumpz 2015-11-26 07:24:43

Issue 198: add profile to ensure doclint is turned off with Java 8+. Without this, the project won't build on Java 8. (You can run mvn test successfully, but not mvn package.)

bb3ef James Heather 2015-11-25 13:43:57

fixes #193

5d7bd wumpz 2015-11-25 06:37:36

fixes #195

ab1ad wumpz 2015-11-25 06:22:12

Issue 195:

Add support for ORDER BY and LIMIT in UPDATE and DELETE statements (as supported by MySQL).
LimitDeparser and OrderByDeParser have been pulled out into separate classes to avoid code duplication from SelectDeParser.

a3133 James Heather 2015-11-24 14:57:04

corrects parsing error

975cd wumpz 2015-11-20 22:44:01

f1d21 wumpz 2015-11-20 14:27:19

fixes #194

f1c98 wumpz 2015-11-18 21:17:49

support INSERT [LOW_PRIORITY | DELAYED | HIGH_PRIORITY] [IGNORE] ...

00c18 wanghai 2015-11-18 09:10:31

corrected lookahead

a97e9 wumpz 2015-11-17 22:24:57

fixes #192, fixes #191

2fddf wumpz 2015-11-14 23:56:53

replaceDeParser parser itemList

3c605 wanghai 2015-11-13 08:45:21

support insert ... on duplicate key update...

7d7fa wanghai 2015-11-13 08:43:57

fixes #181, added drop deparser

44091 wumpz 2015-11-09 22:33:56

alter table support improved

ad0dd wumpz 2015-10-27 22:37:56

fixes #180

0bb23 wumpz 2015-10-21 06:44:00

#182

a3695 wumpz 2015-10-21 05:56:19

Support for alter table drop column/constraint

Fix for Issue #184

58dd2 schweighart 2015-10-20 21:34:51

updated readme

e570a wumpz 2015-10-19 13:16:54

Improved required coverage

41cbd Rapševičius Valdas 2015-10-14 11:05:36

Refactored Oracle Hint tests, added set selects

7b4fe Rapševičius Valdas 2015-10-13 22:37:29

Added OracleHint class, grammar and model support, tests

f7f8d Rapševičius Valdas 2015-10-13 22:06:16

resolved choice conflict

b6f71 wumpz 2015-10-08 11:11:42

fixes #178, merged upstream

11dbd Gabor Bota 2015-10-08 09:20:15

added restrict and set null for alter statement

36379 wumpz 2015-10-07 21:38:53

fixes #178

cb267 Gabor Bota 2015-10-07 13:00:53

fixes #174

da1e0 wumpz 2015-10-06 21:18:27

fixes #174

8d419 wumpz 2015-10-06 21:15:40

simple merge implementation

bc4bc wumpz 2015-10-01 22:52:36

simple merge implementation

af5a0 wumpz 2015-10-01 22:44:50

fixes #176

c6e93 wumpz 2015-10-01 21:50:13

fixes #176

fb4d4 wumpz 2015-10-01 21:45:44

fixes #177

9999c wumpz 2015-10-01 21:11:43

1fb42 wumpz 2015-10-01 20:24:27

merge impl started

8d8c0 wumpz 2015-09-24 22:23:11

fixes #172

c690f wumpz 2015-09-22 05:33:16

ae2c8 wumpz 2015-09-16 18:55:58

03a4f wumpz 2015-09-16 05:53:18

fixes #167

57f30 wumpz 2015-09-16 05:52:27

fixes #167

71d9f wumpz 2015-09-16 05:49:45

fixes #77

0e51d wumpz 2015-09-16 05:46:49

fixes #170

cf9bf wumpz 2015-09-13 21:26:48

jsqlparser-0.9.4 (2015-09-13)

Other changes

e9024 wumpz 2015-09-07 19:26:26

fixes #165

28101 wumpz 2015-09-03 20:03:48

fixes #165

bf06e wumpz 2015-09-03 20:02:25

fixes #166

c244c wumpz 2015-09-03 14:02:17

fixed #162

46381 wumpz 2015-08-07 20:48:55

fixed #162

e3b73 wumpz 2015-08-07 20:48:00

fixed #160

432c0 wumpz 2015-08-07 20:24:40

no message

e91e0 wumpz 2015-08-05 20:44:25

Add support for variable support to "SELECT SKIP FIRST ..." construct

The grammar for the construct in informix [1] mentions the possibility, that <ROWCOUNT> can be either
an integer or a host variable or local SPL variable storing the value of max. The case for plain integers and
jdbc variables is covered by the first commit While this commit adds support for constructs using SPL
variables. SPL variables must follow identifier rules [2][3].
[1] http://www-01.ibm.com/support/knowledgecenter/SSGU8G_12.1.0/com.ibm.sqls.doc/ids_sqs_0156.htm
[2] http://www-01.ibm.com/support/knowledgecenter/SSGU8G_12.1.0/com.ibm.sqls.doc/ids_sqs_1306.htm?lang=de
[3] http://www-01.ibm.com/support/knowledgecenter/SSGU8G_12.1.0/com.ibm.sqls.doc/ids_sqs_1660.htm%23ids_sqs_1660?lang=de

9e77b Matthias Bläsing 2015-08-02 14:03:23

simplified lookahead

a44ac wumpz 2015-08-01 21:42:46

simplified lookahead

0fc8e wumpz 2015-08-01 21:33:31

Update README.md

b3d76 Tobias 2015-07-31 05:27:21

6f2a1 wumpz 2015-07-30 21:35:13

added another testcase for #154

e889c wumpz 2015-07-29 10:50:10

Implement support for "SELECT SKIP FIRST ..." construct

4a33d Matthias Bläsing 2015-07-25 19:16:23

test for #154 included

001d6 wumpz 2015-07-23 09:49:24

157ee wumpz 2015-07-15 20:55:25

fixes #150

5b3ec wumpz 2015-07-15 20:42:54

fixes #149

d2b07 wumpz 2015-07-15 20:20:14

Fix inline usage of foreign keys in CREATE TABLE statements

23c19 Georg Semmler 2015-07-09 15:41:39

fixes #146

978b6 wumpz 2015-07-03 13:19:54

reincluded Apache 2.0 license

83899 wumpz 2015-07-02 20:54:03

reincluded Apache 2.0 license

7e52d wumpz 2015-07-02 20:52:04

corrected deparser

cc4a5 wumpz 2015-07-01 20:51:03

updated readme

44716 wumpz 2015-07-01 20:04:46

fixes #138 and AnyComparisionExpression

ab2b2 wumpz 2015-07-01 19:55:02

null toString used

e425d wumpz 2015-06-24 21:20:29

completed any and all comparisions

fc076 wumpz 2015-06-24 20:59:45

Exceptions skiped during coverage tests

1849c wumpz 2015-06-10 05:50:43

Update README.md

d561d Tobias 2015-06-09 21:39:04

a17d6 wumpz 2015-06-09 21:29:55

coveralls

5858a wumpz 2015-06-09 21:03:49

1d71c wumpz 2015-06-08 20:14:29

completed ExpressionVisitorAdapter

8ec0b wumpz 2015-06-07 22:37:50

completed ExpressionVisitorAdapter

cf703 wumpz 2015-06-05 22:32:50

completed ExpressionVisitorAdapter

348fd wumpz 2015-06-05 22:29:30

updated some plugin versions

94c63 wumpz 2015-06-05 21:08:48

fixes #143

some refactorings done

4d2a0 wumpz 2015-06-05 20:50:28

fixes #143

some refactorings done

f71c3 wumpz 2015-06-05 20:48:45

fixes #142

3d340 wumpz 2015-06-05 20:28:28

fixes #141

b78ed wumpz 2015-06-05 20:09:32

5123f wumpz 2015-06-05 20:07:12

root nodes established but not linked

71305 wumpz 2015-05-31 20:39:43

root nodes established but not linked

edd0c wumpz 2015-05-31 19:54:52

astnodes for columns and tables

d66a9 wumpz 2015-05-29 22:49:13

simple jjtree start

e594e wumpz 2015-05-27 22:34:35

simple jjtree start

d9f5f wumpz 2015-05-24 21:08:32

fixes #134 - preserve order of query

59470 wumpz 2015-05-24 20:28:51

fixes #136

5adeb tejksat 2015-05-24 10:00:31

fixes #134

d99e6 wumpz 2015-05-21 21:10:44

fixes #72

8b540 wumpz 2015-05-21 20:28:50

fixes #72

3aaf1 wumpz 2015-05-21 20:26:15

group_concat started

adca3 wumpz 2015-05-20 21:48:36

3563c wumpz 2015-05-12 22:32:17

jsqlparser-0.9.3 (2015-05-12)

Other changes

fixes #69

16034 wumpz 2015-05-10 22:11:41

fixes #69

35164 wumpz 2015-05-10 22:02:24

fixes #90

536ba wumpz 2015-05-07 22:53:42

fixes #90

db4a2 wumpz 2015-05-07 22:50:35

55b8e wumpz 2015-05-07 18:41:22

fixes #129

45132 wumpz 2015-04-30 19:07:21

fixes #128

aa291 wumpz 2015-04-27 21:59:00

Update README.md

c4f24 Tobias 2015-04-23 08:56:37

fixes #126 - allows brackets around select

64b22 wumpz 2015-04-22 22:03:21

fixes #125 - added values as a column name

ac785 wumpz 2015-04-16 21:01:18

fixes #110 - first implementation

94195 wumpz 2015-04-11 17:32:48

updated readme

f2d48 wumpz 2015-04-09 21:52:40

solved some oracle test sql parsings

b76ba wumpz 2015-04-09 21:45:16

fixes #122

46f51 wumpz 2015-04-09 21:02:10

fixes #123

68f47 wumpz 2015-04-09 20:23:50

refactoring

26e1c wumpz 2015-04-08 21:20:40

refactoring

a9768 wumpz 2015-04-08 21:17:30

fixes #120

c3995 wumpz 2015-04-08 06:11:06

first try to fix #114

a0d87 wumpz 2015-04-07 00:48:55

73822 wumpz 2015-04-06 20:53:58

Update README.md

ad91b Tobias 2015-04-06 20:34:30

travis

ade82 wumpz 2015-04-06 20:04:47

673e0 wumpz 2015-04-06 19:08:34

fixes #109

a3285 wumpz 2015-04-02 23:08:59

fixes #119

c9b58 wumpz 2015-04-01 20:31:03

fixes #117

a3fc1 wumpz 2015-03-28 20:02:28

fixes #117

b3d91 wumpz 2015-03-28 19:50:20

f194b wumpz 2015-03-04 23:26:13

corrected lookup

8598d wumpz 2015-03-04 22:33:16

updated readme

5472e wumpz 2015-03-04 22:28:45

fixes #115

a3e02 wumpz 2015-03-04 22:18:59

fixes #116

c916f wumpz 2015-03-04 21:55:29

Update README.md

18089 Tobias 2015-02-12 22:54:15

jsqlparser-0.9.2 (2015-02-12)

Other changes

updated readme

13d29 wumpz 2015-02-12 21:43:13

introduced user variables: fixes #107

0c288 wumpz 2015-02-11 21:21:24

maybe not correct alter statement

ab001 wumpz 2015-02-04 22:53:06

fixes #102

d603e wumpz 2015-02-04 21:16:18

Update README.md

66517 Tobias 2015-02-01 20:03:21

fixes #91

495a7 wumpz 2015-02-01 00:07:07

Update README.md

d0ce4 Tobias 2015-01-30 21:30:28

fixes #89

4ac85 wumpz 2015-01-21 20:15:55

pivot function test

3cc5a wumpz 2015-01-16 23:33:19

Update README.md

3bec5 Tobias 2015-01-11 10:37:55

fixes #99

d4bc7 wumpz 2015-01-10 23:10:04

fixes #99

5ac27 wumpz 2015-01-10 23:08:28

small grammar cleanup

e4756 wumpz 2014-12-18 21:24:23

fixes #93

02be9 wumpz 2014-12-10 23:33:19

fixes #92

e902a wumpz 2014-12-10 23:17:40

updated readme

32bf3 wumpz 2014-12-10 21:56:12

add group ba additions to SelectUtils

dd77b wumpz 2014-12-08 22:51:59

adcaf wumpz 2014-12-07 21:54:35

fixes #88

0d5cc wumpz 2014-12-03 23:45:07

oracle colls started

e8a18 wumpz 2014-11-30 20:41:53

options

2e85a wumpz 2014-11-25 00:11:17

updated readme

72340 wumpz 2014-11-24 20:17:52

added create table parameters to deparser

05967 wumpz 2014-11-24 20:10:48

added create parameters to include into deparser

6f89e wumpz 2014-11-23 23:36:35

added commit keyword

f276b wumpz 2014-11-23 23:26:40

fixes #87

2056c wumpz 2014-11-22 00:27:01

simple cleanup

6a98d wumpz 2014-11-20 20:42:39

withitem - deparsing merged and modified

20e0f wumpz 2014-11-03 22:54:58

use accept() instead of toString() on StatementDeParser

67497 reed1 2014-11-02 06:53:07

fixes #84

a5031 wumpz 2014-10-31 22:57:23

for update selects implemented

92efe wumpz 2014-10-30 23:59:42

allow 'key' as object name

32b0a wumpz 2014-10-30 23:19:30

update readme

d9951 wumpz 2014-10-22 22:03:20

little housekeeping

5fb21 wumpz 2014-10-22 21:51:37

Manage OFFSET and FETCH clauses in dedicated classes and rules in

jsqlparsercc.jj
Manage also jdbc parameter in these clauses.

26524 LionelNirva 2014-10-10 14:38:20

added test for wrong top distinct order.

ccefb wumpz 2014-10-09 19:23:52

Add support for new SQL Server 2012 and Oracle 12c versions of LIMIT

(equivalent to MySql and PostgreSQL LIMIT ... OFFSET ... clauses) for
parsing and deparsing.

dc215 LionelNirva 2014-10-08 12:38:04

Unit test for the fix Bug when Deparsing SQL Server request having TOP

and DISTINCT clauses.

c2ad9 LionelNirva 2014-10-07 14:31:43

little housekeeping

fd25a wumpz 2014-10-05 21:44:57

little housekeeping

c3ec6 wumpz 2014-10-05 21:38:24

compile error corrected

8ae4b wumpz 2014-10-05 21:15:34

Fix Bug when Deparsing SQL Server request having TOP and DISTINCT

clauses. SQL Server requires the DISTINCT clause to be the first.

7ac70 LionelNirva 2014-10-03 16:34:49

Update UpdateTest.java

Add an SQL test for Update with Select

aec82 CeeKayGit 2014-10-01 21:34:51

Update UpdateDeParser.java

f2fec CeeKayGit 2014-10-01 21:18:33

Update UpdateDeParser.java

e31ac CeeKayGit 2014-10-01 20:51:26

Update Update.java

Add necessary Select import for Update with Select

8321a CeeKayGit 2014-10-01 20:37:42

Update UpdateDeParser.java

Extend the deparser to support DB2 Updates with Select clause

3a7bf CeeKayGit 2014-10-01 20:12:14

Update JSqlParserCC.jj

For DB2 "$" is also a standard letter, so handle "$" as #LETTER.

a6383 CeeKayGit 2014-09-30 20:56:13

Update Update.java

Add support for DB2 Updates with Select clause

1bdb6 CeeKayGit 2014-09-30 20:52:21

Update JSqlParserCC.jj

Add support for DB2 Updates with Select clause

17e3d CeeKayGit 2014-09-30 20:47:54

Update README.md

23279 Tobias 2014-09-23 20:32:34

jsqlparser-0.9.1 (2014-09-23)

Other changes

Update README.md

267b4 Tobias 2014-09-22 07:25:49

corrected typo

90c93 wumpz 2014-09-07 20:28:38

refactored join processor to be more restrictive

f1544 wumpz 2014-09-06 20:24:16

simple execute clause support

531d6 wumpz 2014-08-14 21:46:11

simple start for execute

d6f01 wumpz 2014-08-13 23:17:08

simple start for execute

406a1 wumpz 2014-08-13 23:08:35

updated readme

1532d wumpz 2014-08-12 14:33:26

correced select into parsing and deparsing

0b7f3 wumpz 2014-08-12 14:29:46

refactored grammar a bit

096e8 wumpz 2014-08-05 20:58:15

improved insert clause

a4de6 wumpz 2014-08-04 22:09:19

corrected a failing test

24dc0 wumpz 2014-07-30 20:47:49

updated readme

fc0ba wumpz 2014-07-30 20:43:23

limit 0 and limit null included

50d3e wumpz 2014-07-30 20:41:40

Add support for LIMIT 0 and LIMIT NULL statements

6db00 Michaël Cervera 2014-07-29 21:58:29

unlogged inlucded in deparser

e9939 wumpz 2014-07-27 21:42:18

Add support for 'UNLOGGED' tables

Support the PostgreSQL 9.1+ ‘UNLOGGED’ table feature

eb05c Michaël Cervera 2014-07-27 20:49:00

create table implemented version 2

98903 wumpz 2014-07-26 19:56:53

recent changes made more oracle tests succeed

bbf36 wumpz 2014-07-24 20:04:01

updated readme

262d4 wumpz 2014-07-24 19:59:25

replaced column list in expression list for partition by of analytic expressions

2ebaa wumpz 2014-07-24 19:53:17

updated readme

55e68 wumpz 2014-07-22 20:49:45

implemented create table .. as select ..

23b93 wumpz 2014-07-22 20:48:00

simple improvements

5b3ea wumpz 2014-07-16 20:27:54

added lookahead for regexp binary

75aed Sarah Komla-Ebri 2014-07-16 15:05:30

Added support for MySQL REGEXP BINARY (for case insensitivity)

ec0dc Sarah Komla-Ebri 2014-07-16 13:50:37

Added support for MySQL REGEXP insensitivity case

4d9e4 Sarah Komla-Ebri 2014-07-16 13:27:25

simple first json syntax

cb674 wumpz 2014-06-24 21:20:58

simple first json syntax

45ce9 wumpz 2014-06-24 21:19:04

returning implemented, column as identifier allowed

0020c wumpz 2014-06-20 23:04:02

returning implemented, column as identifier allowed

733ff wumpz 2014-06-20 22:58:28

Update README.md

e12b8 Tobias 2014-06-04 20:50:35

Update README.md

e8927 Tobias 2014-06-04 20:47:38

Update README.md

fb8ad Tobias 2014-06-04 20:46:03

Update README.md

08c6a Tobias 2014-06-04 20:45:22

fixes #56 : multitable updates

dfda1 wumpz 2014-05-25 20:16:31

fixes #56 : multitable updates

9c183 wumpz 2014-05-25 20:06:04

fixes #57: brackets were not handled properly

00367 wumpz 2014-05-25 19:10:28

readme updated

55634 wumpz 2014-05-22 22:08:32

junit annotations

57154 wumpz 2014-05-22 21:05:22

Unit test

8cc03 shuyangzhou 2014-05-20 21:52:29

TablesNamesFinder.getTableList(Delete) throws NPE when the sql does not have a where clause

6d828 shuyangzhou 2014-05-20 21:52:24

upgrade to JavaCC 6.1.2

c3404 wumpz 2014-05-16 06:49:21

Update README.md

67af4 Tobias 2014-05-08 19:35:00

jsqlparser-0.9 (2014-05-08)

Other changes

support for some keywords as objectnames

60f2b wumpz 2014-05-07 21:19:09

support for some keywords as objectnames

c126e wumpz 2014-05-07 20:57:32

support for named pks included

3aabf wumpz 2014-04-20 23:56:06

support for named pks included

9e683 wumpz 2014-04-20 23:51:10

util for conditional expression parsing included

ffeb7 wumpz 2014-04-07 21:29:42

util for conditional expression parsing included

bc5a6 wumpz 2014-04-07 21:21:58

updated readme

01a82 wumpz 2014-03-23 21:21:41

updated readme

84979 wumpz 2014-03-22 22:43:53

changed configuration

96be5 wumpz 2014-03-22 21:42:11

readme updated

986c8 wumpz 2014-03-18 21:35:28

removed stachtrace printing for problematic sql scripts

7ff12 wumpz 2014-03-18 20:52:15

corrected some sql test scripts to be deparseable

corrected pivot handling in SelectDeParser

8ac25 wumpz 2014-03-12 23:24:47

site descriptor

a6265 wumpz 2014-03-12 19:56:37

pivot test sqls a little tweaked so parseing deparsing will work

dcd97 wumpz 2014-03-08 00:00:29

pivot for subquery corrected

eb480 wumpz 2014-03-07 23:48:52

!= usage corrected

deparser for oracle hierarchical expressions corrected
order by asc/desc corrected

d4f74 wumpz 2014-03-06 22:27:11

ALL processing corrected

68938 wumpz 2014-03-06 20:46:49

lax tests improved

ab578 wumpz 2014-03-05 23:17:40

toString for windowing elements corrected

lax equality test implemented
included oracle test sqls
included @ and # for identifiers

884dc wumpz 2014-03-05 23:01:03

*First version of all Visitor adapters + simple test

cdc42 aalmiray 2014-03-05 20:45:57

character set implemented

90048 wumpz 2014-03-01 00:11:04

character set implemented

e7114 wumpz 2014-03-01 00:05:59

Update README.md

2c22b Tobias 2014-02-20 22:51:32

jsqlparser-0.8.9 (2014-02-20)

Other changes

Update README.md

d6edd Tobias 2014-02-15 22:11:51

readme

f82d8 wumpz 2014-02-14 22:01:31

first statements version

4be27 wumpz 2014-02-14 21:56:27

update readme

ff94a wumpz 2014-02-11 00:13:16

c91d1 wumpz 2014-02-11 00:08:31

update readme

3b219 wumpz 2014-02-11 00:01:11

corrected some styling issues

a3a7f wumpz 2014-02-10 23:44:22

backported analytic expressions from fork

43d97 wumpz 2014-02-10 23:36:24

order by clause improved nulls first last

ce45f wumpz 2014-02-09 23:59:29

added versions to pom

06bbd wumpz 2014-02-08 11:01:56

9b2c2 wumpz 2014-02-07 22:25:13

Updated most of the Maven dependencies;

e6aaf Pap Lőrinc 2014-02-07 07:59:11

Added PERCENT support for the TOP statement;

5e127 Pap Lőrinc 2014-02-07 07:58:51

Update README.md

53aab Tobias 2014-02-06 21:18:20

readme updated

96654 wumpz 2014-02-06 21:14:04

added testcase, little refactoring

4f766 wumpz 2014-02-06 21:08:18

Modified the TOP expression to accept parentheses also;

b5849 Pap Lőrinc 2014-02-06 09:39:31

updated readme

e143a wumpz 2014-02-04 22:57:24

removed Exception logging for false multipart name test

7a94f wumpz 2014-02-04 22:48:24

e1f06 wumpz 2014-02-04 22:14:12

included maven site generation

fc016 wumpz 2014-02-02 23:47:06

extended multipart identifier tests

a3e0f wumpz 2014-02-02 00:04:28

13f3c wumpz 2014-02-01 23:23:43

removed possibility of empty tablename

9a819 wumpz 2014-02-01 23:17:35

removed some changes

7fa4f wumpz 2014-02-01 22:55:57

signed expressions tests improved

a78ab wumpz 2014-02-01 22:18:32

Replaced a leftover StringBuffer with StringBuilder;

9b8d7 Pap Lőrinc 2014-01-28 17:26:00

Corrected Sql Server multi-part table and column names (database.schema.table.column) in the select statement to accept 4 levels with empty inner parts;

ba6c5 Pap Lőrinc 2014-01-28 17:23:37

Renamed getWholeColumnName and getWholeTableName to getFullyQualifiedName;

b4d54 Pap Lőrinc 2014-01-28 17:14:09

Corrected the signed expression behaviors and renamed InverseExpression to SignedExpression;

d1e71 Pap Lőrinc 2014-01-28 08:36:06

Removed the leading and trailing whitespaces in the JavaCC parser file;

Organized the declared imports in order to ease further changes in the file and to remove unused ones;
Renamed the S_INTEGER token to S_LONG to be in sync with the S_DOUBLE token;

5d151 Pap Lőrinc 2014-01-28 08:24:04

fixes #34

144ca wumpz 2014-01-23 22:14:58

Update README.md

7024b Tobias 2014-01-22 23:23:54

jsqlparser-0.8.8 (2014-01-22)

Other changes

problem with git v1.8.5 adressed

9b12d wumpz 2014-01-22 23:05:23

version 0.8.8-SNAPSHOT

810ca wumpz 2014-01-22 22:41:41

version 0.8.8-SNAPSHOT

fdd3a wumpz 2014-01-22 22:29:11

Update README.md

d4083 Tobias 2014-01-21 23:37:41

addJoin introduced

c19f8 wumpz 2014-01-21 23:35:34

readme updated

d3675 wumpz 2014-01-14 22:29:07

started simple utility function for select statement modification

bf454 wumpz 2014-01-14 22:18:43

started simple utility function for select statement modification

6b5e2 wumpz 2014-01-14 22:11:13

update readme

311d6 wumpz 2014-01-14 21:07:21

little housekeeping

1c927 wumpz 2014-01-14 21:01:05

Alias class implemented and integrated

ce339 wumpz 2014-01-14 20:58:03

Added one simple insert SQL to test

2db02 wumpz 2014-01-11 15:05:50

f58ca wumpz 2013-12-08 20:13:04

update readme

068b1 wumpz 2013-12-07 23:59:34

start alter statement

75575 wumpz 2013-12-07 23:57:27

PostgresSQL regular expression match operators

e5e48 wumpz 2013-11-12 21:37:43

Update README.md

259dd Tobias 2013-11-08 23:38:09

PostgresSQL regular expression case sensitive match

db923 wumpz 2013-11-08 23:33:46

PostgresSQL regular expression case sensitive match

88b5a wumpz 2013-11-08 23:27:30

simple modifier cleanup

0528e wumpz 2013-11-06 21:11:27

Update README.md

2a4bb Tobias 2013-10-30 22:37:09

update readme

e3b0e wumpz 2013-10-30 22:31:03

jsqlparser-0.8.6 (2013-10-30)

Other changes

a little cleanup

bdc81 wumpz 2013-10-24 21:46:52

version not needed anymore

7a737 wumpz 2013-10-24 21:34:14

Update README.md

f14e3 Tobias 2013-10-08 22:42:11

Update README.md

22c3e Tobias 2013-10-08 22:37:23

update readme.md

d2dcf wumpz 2013-10-08 22:35:21

merge oracle hierarchical syntax into main

a0b21 wumpz 2013-10-08 22:23:30

merge oracle hierarchical syntax into main

6c300 wumpz 2013-10-08 22:22:19

OracleHierarchicalExpression implemented

b48f2 wumpz 2013-10-08 22:07:03

OracleHierarchicalExpression implemented

afa6e wumpz 2013-10-08 00:15:32

Update README.md

3901b Tobias 2013-10-07 12:09:23

Update README.md

9eb5f Tobias 2013-10-06 14:12:55

parser updated oracle recursives

aff53 wumpz 2013-10-01 19:07:16

begin implementation of oracle recursive queries

a7566 wumpz 2013-09-19 20:33:18

jsqlparser-0.8.5 (2013-10-06)

Other changes

preparing release of 0.8.5

7abce wumpz 2013-10-06 13:23:53

preparing release of 0.8.5

0e13b wumpz 2013-10-06 12:55:48

readme updated

3e68f wumpz 2013-09-19 21:08:23

problems solved with postgresqls data type "character varying"

c84e5 wumpz 2013-09-19 21:05:18

problems solved with postgresqls data type "character varying"

f5af3 wumpz 2013-09-19 21:00:19

corrected version infos

9da72 wumpz 2013-09-17 21:49:19

Update README.md

da809 Tobias 2013-09-17 21:36:47

first snapshot deployed to sonatype

62970 wumpz 2013-09-17 21:27:05

pom modification to publish to public repository

e60bc wumpz 2013-09-17 12:14:43

pom modification to publish to public repository

085d4 wumpz 2013-09-17 09:11:36

CastExpression favours cast keyword instead of ::

68d12 wumpz 2013-09-17 07:17:39

CastExpression favours cast keyword instead of ::

8cf8b wumpz 2013-09-17 07:16:27

removed unused modifiers

b3ee7 wumpz 2013-08-29 20:22:48

improved function test

35608 wumpz 2013-08-29 19:32:20

workaround for mySql truncate function

c3b40 wumpz 2013-08-29 19:22:57

jsqlparser-0.8.4 (2013-08-27)

Other changes

JJDoc output included in site configuration

b2688 wumpz 2013-08-25 19:30:45

Update README.md

891dd Tobias 2013-08-22 20:29:48

update readme

d375a wumpz 2013-08-22 20:20:29

update readme

e25d0 wumpz 2013-08-22 20:13:19

some minor additions to named parameters

8bff2 wumpz 2013-08-22 20:11:19

added ability to parse named parameters

284ec audrium 2013-08-22 13:47:39

added changes to readme

6ab75 wumpz 2013-08-14 21:34:21

added some test cases

00f76 wumpz 2013-08-14 21:25:47

removed PivotForColumn

18904 wumpz 2013-08-11 23:43:07

regexp_like transfered into a general boolean function

410a2 wumpz 2013-08-11 21:26:33

Add support old oracle join syntax to more expressions (simple comparisons and IN)

55f42 Jonathan Burnhams 2013-08-02 07:52:05

Add support for lag and lead with offset and default value parameters

99b46 Jonathan Burnhams 2013-08-01 14:00:15

Added regexp_like support

33f4f Jonathan Burnhams 2013-08-01 13:26:05

Finished adding pivot support

43fe8 Jonathan Burnhams 2013-08-01 08:56:50

Started to add pivot support

a9716 Jonathan Burnhams 2013-07-31 15:15:42

Ignore intellij

51783 Jonathan Burnhams 2013-07-31 13:25:20

Update README.md

3a8ea Tobias 2013-07-18 13:06:09

removed release plugin dryrun

6e45a wumpz 2013-07-05 20:55:50

Update README.md

b53e7 Tobias 2013-07-05 05:58:12

maven release plugin for local git repository

bd05e wumpz 2013-07-04 19:54:39

more sonar issues corrected

7fea9 wumpz 2013-07-04 19:23:29

Update README.md

79f32 Tobias 2013-07-04 19:04:02

create table can now have foreign key definitions

fixes #14

0c41f wumpz 2013-06-24 23:28:29

removed some unused imports

8c37c wumpz 2013-06-20 21:59:24

more sonar identified stuff cleaned

51791 wumpz 2013-06-20 21:12:48

cleanup violations found by sonar

51d0b Ivan Vasyliev 2013-06-14 14:44:01

more sonar identified stuff cleaned

c84ed wumpz 2013-06-13 20:53:57

corrected Method names mentioned by Sonar

16e2d wumpz 2013-06-13 20:46:02

cleaned up more critical points (sonar)

ad96c wumpz 2013-06-13 20:42:40

solved critical "Performance - Method concatenates strings using + in a loop"

9b86e wumpz 2013-06-09 23:40:10

Update README.md

5c36d Tobias 2013-06-08 22:14:15

Update README.md

cdbec Tobias 2013-06-08 21:55:29

fixes #30

22f83 wumpz 2013-05-30 20:11:44

4ebb5 wumpz 2013-05-26 22:47:27

added readme entry

afc0e wumpz 2013-05-26 22:21:36

multi value IN expression introduced (a,b,c) in ...

fixes #30

3c443 wumpz 2013-05-26 22:19:03

introduces Interval expression

fc5e6 wumpz 2013-05-26 20:44:44

new version

f97c5 wumpz 2013-05-23 22:03:06

new version

a470a wumpz 2013-05-22 19:57:51

release

1366c wumpz 2013-05-22 19:57:21

readme

4a620 wumpz 2013-05-22 19:49:11

introduced generic list

8af04 wumpz 2013-05-22 19:38:36

refactored some test utility methods out into a new class

c6bc4 wumpz 2013-05-22 19:33:05

improved test

5e106 wumpz 2013-05-22 19:16:18

- corrected S_DOUBLE parsing

6e3dc wumpz 2013-05-16 22:22:01

- solved critical grammar bug regarding concat expressions and parenthesis parsing

- introduced some tests to cover the above
- corrected ExpressionDeparser to deliver same result as toString for substractions

51365 wumpz 2013-05-16 21:53:04

added simple delete sql check

45fad wumpz 2013-05-03 20:36:31

add simple materialized view parsing without additional parameters

6b339 wumpz 2013-04-24 20:48:16

add simple materialized view parsing without additional parameters

fa5da wumpz 2013-04-24 20:45:22

Update README.md

1d923 Tobias 2013-04-24 06:03:14

a6615 wumpz 2013-04-23 21:14:24

- corrected TableNamesFinder to work properly on update statements

eab74 wumpz 2013-04-23 21:07:32

- Create View corrected in using set operations

97c03 wumpz 2013-04-23 20:42:51

- from clause can now be used in update statements

b24c1 wumpz 2013-04-21 21:34:26

- from clause can now be used in update statements

b5c4c wumpz 2013-04-21 21:31:30

- insertet toString in Update

- modified Update deparser to deliver better results

e2e4d wumpz 2013-04-21 21:18:48

added cross join syntax support

777a0 wumpz 2013-04-18 22:28:32

allow more complex expressions in extract clause

e551a wumpz 2013-04-18 21:49:45

allow more complex expressions in extract clause

ab2ab wumpz 2013-04-18 21:46:29

allow complete type in cast expression

8562d wumpz 2013-04-18 20:47:12

allow complete type in cast expression

905a6 wumpz 2013-04-18 20:40:49

create view .. as (select ..) implemented

1b3c5 wumpz 2013-04-18 20:23:19

corrected comma list to partition by

d82c7 wumpz 2013-04-18 20:01:55

corrected comma list to partition by

eafea wumpz 2013-04-18 19:59:20

corrected comma list to partition by

5d40d wumpz 2013-04-18 19:55:03

added column names list to create view statement

b3a63 wumpz 2013-04-17 22:15:38

added column names list to create view statement

b7e73 wumpz 2013-04-17 22:11:15

added more testcases

eae84 wumpz 2013-04-07 21:08:13

Update README.md

f2765 Tobias 2013-04-05 19:34:33

support listing tables from other operations

1d09b Raymond Auge 2013-04-05 15:39:59

support for create index

dca7d Raymond Auge 2013-04-05 13:54:56

added more tool functions to new tool class CCJSqlParserUtil

83a1e wumpz 2013-03-23 22:31:09

added more tool functions to new tool class CCJSqlParserUtil

90341 wumpz 2013-03-23 22:28:35

added more tool functions to new tool class CCJSqlParserUtil

56fe6 wumpz 2013-03-23 22:27:32

added more tool functions

71daa wumpz 2013-03-23 22:20:20

switch to unicode parsing

886b7 wumpz 2013-03-21 22:58:37

ignoring jedit backup files

da1e3 Tobias Warneke 2013-03-20 20:33:35

Added automatic license header generation. The link to the original project was moved to the poms description.

Format of all sources done.

01f7a wumpz 2013-03-19 21:30:50

automatically create license header

8206d wumpz 2013-03-19 21:05:27

26e3a wumpz 2013-03-19 20:50:59

f37b7 wumpz 2013-03-19 20:38:04

wildcard extension for analytic expression

d36fd wumpz 2013-03-19 20:18:46

readme updated

27be9 wumpz 2013-03-19 00:16:05

analytic expressions updated

9d62c wumpz 2013-03-19 00:12:06

- additional test case for values

- additional test cases for analytical expressions

15fc8 wumpz 2013-03-18 23:59:07

Update README.md

d7f9f Tobias 2013-03-17 00:32:02

additional test case

e7dc8 wumpz 2013-03-17 00:26:21

multi value expression for select included

6b51f wumpz 2013-03-17 00:21:17

Update README.md

15a8d Tobias 2013-03-14 21:43:12

multi value expression for insert included

898f3 wumpz 2013-03-14 21:40:42

multi value expression for insert included

8f21c wumpz 2013-03-14 21:36:44

corrected InsertDeParser to deliver same results like toString

95527 wumpz 2013-03-12 22:15:07

test for lateral and TableNamesFinder

a3ec5 wumpz 2013-03-03 00:46:19

corrected readme

966d8 wumpz 2013-02-27 23:27:02

corrected readme

20275 wumpz 2013-02-27 23:13:22

3d72a wumpz 2013-02-27 23:08:50

implemented lateral keyword

5bc39 wumpz 2013-02-27 23:05:01

add WithItem to visitor interface

10e8f wumpz 2013-02-20 23:06:07

some clean up

00799 wumpz 2013-02-20 22:47:14

35a17 wumpz 2013-02-16 14:01:45

0.8.2-SNAPSHOT

e8ed7 wumpz 2013-02-15 22:42:47

Release 0.8.1 to include in my maven repo

e41b3 wumpz 2013-02-15 22:41:44

- problem with TablesNamesFinder: finds with - alias instead of tablenames

08236 wumpz 2013-02-15 22:41:07

- problem with TablesNamesFinder: finds with - alias instead of tablenames

43699 wumpz 2013-02-15 22:14:13

Update README.md

c438f Tobias 2013-02-14 07:45:00

Update README.md

7beeb Tobias 2013-02-14 00:11:32

deployment to github maven repository

d9fe3 wumpz 2013-02-14 00:04:46

Update README.md

5f306 Tobias 2013-01-04 09:39:02

CreateView merged in

0ba65 wumpz 2013-01-04 09:32:08

CreateView merged in

b2eff wumpz 2013-01-04 09:31:12

Add CREATE VIEW support

101ef Jeffrey Gerard 2012-12-26 17:52:30

some housekeeping: replace string concats

db49b wumpz 2012-11-15 22:38:04

some housekeeping: adding missing braces

5dabd wumpz 2012-11-15 22:33:05

some housekeeping: adding override annotations

5302b wumpz 2012-11-15 22:21:05

changed source encoding to utf8 from win-1252

af7fc wumpz 2012-10-31 23:38:33

additional letters token rule included, to expand range of acceptable identifiers

86423 wumpz 2012-10-31 22:40:42

additional letters token rule included, to expand range of acceptable identifiers

aa8e1 wumpz 2012-10-31 19:16:02

Update README.md

50a56 Tobias 2012-10-27 22:42:10

initial import

be85e wumpz 2012-10-27 22:23:51

initial import

3331f wumpz 2012-10-27 22:21:08

initial import

52ffc wumpz 2012-10-27 22:17:53

- introduced more generics in parser definition

4a89f wumpz 2012-10-26 22:23:16

- introduced more generics in parser definition

b0e4a wumpz 2012-10-26 22:16:59

- introduced more generics in parser definition

07317 wumpz 2012-10-26 22:13:12

- introduced more generics in parser definition

fde24 wumpz 2012-10-12 20:55:17

- clean up merge conflicts

e838d wumpz 2012-10-12 20:13:43

- clean up merge conflicts

bf5d1 wumpz 2012-10-12 20:11:30

Added SELECT parsing and JUnit test

e9766 Christian Bockermann 2012-10-01 09:21:38

- corrected changelog

1047b wumpz 2012-09-16 21:14:25

- difference problem between deparser and tostring for function without parameters resolved

aee0f wumpz 2012-09-16 21:13:08

- difference problem between deparser and tostring for function without parameters resolved

90f48 wumpz 2012-09-16 21:11:10

- ExtractExpression integrated

- Tests ExtractExpression started
- Function problem found

7ea63 wumpz 2012-09-16 21:01:53

- extract syntax integrated into jj file

7a50b wumpz 2012-09-15 21:26:39

- expansion warnings removed by introducing lookaheads

db904 wumpz 2012-09-15 21:04:18

3da19 wumpz 2012-09-11 19:33:24

ab60c wumpz 2012-09-08 20:58:20

- moved tables names finder to utils package of source package. it is a too useful tool to live only in the test packages

57025 wumpz 2012-09-08 19:59:35

- moved tables names finder to utils package of source package. it is a too useful tool to live only in the test packages

4d33d wumpz 2012-09-08 19:57:25

- Tool expression connector included

bb726 wumpz 2012-09-08 19:46:28

- Tool alias adder implemented

2ee7a wumpz 2012-09-03 23:32:15

imports corrected

147e8 wumpz 2012-09-01 22:05:02

Fix some obvious compiler warnings

ea7a1 Ian Bacher 2012-06-13 20:35:48

99b92 wumpz 2012-06-12 21:49:05

quoted columns in create table statement included

CreateTableDeParser corrected (NPE with no indexes, toString delivers now same)
CreateTableTest expanded

69287 wumpz 2012-05-26 19:58:14

complex with tests included

exists formatting included from fork

7e39e wumpz 2012-05-23 19:57:10

changed version number due to visitor incombatibilities

87315 wumpz 2012-05-23 19:08:39

877ea wumpz 2012-05-19 23:04:42

- removed deprecated union class (replaced by SetOperationList)

bce12 wumpz 2012-05-19 22:09:03

set operation handling done

673eb wumpz 2012-05-19 21:42:21

start implementing union intersection etc. set operation handling

e980b wumpz 2012-05-18 21:17:50

37ecf wumpz 2012-05-18 20:11:59

- Added Oracle (+) join Syntax (instead of taba left join tabn on a=b oracle allows taba,tabn where a=b(+) )

31e94 wumpz 2012-05-18 20:10:14

- Analytic functions added: corrected PARTITION BY

4f2cb wumpz 2012-05-17 13:44:50

- Analytic functions added: row_number() over (order by a,c)

b8543 wumpz 2012-05-17 12:46:52

Added support for modulo expression (5 % 4)

ae513 wumpz 2012-05-17 12:19:50

Added support for modulo expression (5 % 4)

4ef84 wumpz 2012-05-16 21:30:14

Include bracket quotation of columns and aliases. For example MSAccess supports this.

e6d5a wumpz 2012-05-16 20:33:44

d6a22 wumpz 2012-05-15 21:50:56

- allowed simple expressions in case else

54d2c wumpz 2012-05-15 21:36:59

- make "select function" pass assertSqlCanBeParsedAndDeparsed

21296 wumpz 2012-05-15 21:00:51

- make "select function" pass assertSqlCanBeParsedAndDeparsed

f769e wumpz 2012-05-15 20:57:07

- make "select function" pass assertSqlCanBeParsedAndDeparsed

e5853 wumpz 2012-05-15 20:55:23

- make "select function" pass assertSqlCanBeParsedAndDeparsed

7a8bb toben 2012-05-13 22:21:38

- CAST - statement included

e22f5 toben 2012-05-13 22:09:34

removed main and junit 3 only artifacts from source code

3f854 toben 2012-05-13 12:39:52

junit upgrade to 4.10

44b0d toben 2012-05-13 12:35:33

Refactoring of SelectTest

e1c80 Florent Bécart 2011-12-02 07:20:18

Removal of tests that are not able to pass

- Functions do not accept conditions as arguments

aa5f0 Florent Bécart 2011-12-02 07:20:18

Code reformat

272bf Florent Bécart 2011-12-02 07:20:18

Modify DeParsers to output the same result as statement.toString();

2a35e Alice Rapunzel 2011-11-21 08:53:24

Changed DeParsers to generic list types.

666ca Christian Bockermann 2011-09-17 07:58:43

Changed all lists to their appropriate generics type.

0dd60 Christian Bockermann 2011-09-17 07:53:14

.gitignore update

dd2a7 Florent Bécart 2011-09-16 22:41:36

Add the sources generated by javacc-maven-plugin to eclipse classpath

66556 Florent Bécart 2011-09-16 22:41:36

Set the version of javacc-maven-plugin in pom.xml as recommended by maven

3f9c4 Florent Bécart 2011-09-16 22:41:36

Project cleanup

0cb63 Florent Bécart 2011-09-16 22:41:36

README update

00b8c Florent Bécart 2011-09-16 22:41:36

Added README

2005d Christian Bockermann 2011-09-16 20:22:29

Removed javcc-5.0 directory (no covered by Maven plugin)

61fb4 Christian Bockermann 2011-09-16 20:13:28

Added support for select without from-list ( SELECT 1 + 2 )

Modified test cases for test resources in src/test/resources

0e5d7 Christian Bockermann 2011-09-16 20:06:07

Moved classes to match Maven directory layout.

a8d70 Christian Bockermann 2011-09-16 19:48:54

Use of StringBuilders instead of StringBuffers

ef03d Florent Bécart 2011-06-23 00:50:08

Files generated by JavaCC should be ignored by Git

b5aff Florent Bécart 2011-06-23 00:49:59

Removal of files generated by JavaCC

767e3 Florent Bécart 2011-06-23 00:05:33

Bug Fix: the column deparser should use the table alias if any

bc8dc Florent Bécart 2011-06-23 00:01:57

Use of generics

- List of expressions in ItemsList
- List of columns in Statement
- List of joins in PlainSelect
- List of withItems in Select
- List of plainSelects in Union
- List of orderByElements in Union
- List of columns in Update
- List of expressions in Update

8b0b8 Florent Bécart 2011-06-22 20:00:44

Insert statements accept both keywords "value" and "values"

1db31 Florent Bécart 2011-06-20 23:14:11

Organize imports

db5e2 Florent Bécart 2011-06-20 22:49:36

Code reformat

fed74 Florent Bécart 2011-06-20 22:48:00

Fixes a compilation error by removing an unused import

b9ce3 Florent Bécart 2011-06-20 22:35:16

Eclipse configuration files

Makes development environment installation easier

b93af Florent Bécart 2011-06-20 22:33:30

Add .gitignore file

Auto-generated files that won't be pushed to the repo are:
- classes: compiled main code
- docs: project javadoc
- *.jar: distribution jar (sources and documentation)
- lib: library jar (.class files)
- testclasses: compiled unit tests

55197 Florent Bécart 2011-06-20 22:08:46

Remove auto-generated folders docs and lib

d2f54 Florent Bécart 2011-06-20 22:06:36

Add junit library (required for ant build)

e0ad5 Florent Bécart 2011-06-20 21:50:19

Add javacc-5.0 folder (required for ant build)

36ddc Florent Bécart 2011-06-20 21:48:21

Initial commit (base version: 0.7.0)

Source: http://sourceforge.net/projects/jsqlparser/files/jsqlparser/jsqlparser-0.7.0.jar/download

67c91 Florent Bécart 2011-06-20 21:44:37

Files

CHANGELOG.md

Latest commit

History

CHANGELOG.md

File metadata and controls

JSqlParser changelog

jsqlparser-5.0 (2024-06-30)

Breaking changes

Features

Bug Fixes

Other changes

jsqlparser-4.9 (2024-03-09)

Features

Bug Fixes

Other changes

jsqlparser-4.8 (2023-12-28)

Features

Bug Fixes

Other changes

jsqlparser-4.7 (2023-09-02)

Breaking changes

Features

Bug Fixes

Other changes

jsqlparser-4.6 (2023-02-23)

Bug Fixes

Other changes

jsqlparser-4.5 (2022-07-22)

Other changes

jsqlparser-4.4 (2022-04-10)

Other changes

jsqlparser-4.3 (2021-12-12)

Other changes

jsqlparser-4.2 (2021-09-08)

Other changes

jsqlparser-4.1 (2021-06-30)

Other changes

jsqlparser-4.0 (2021-01-01)

Other changes

jsqlparser-3.2 (2020-06-28)

Other changes

jsqlparser-3.1 (2019-11-06)

Other changes

jsqlparser-3.0 (2019-08-29)

Other changes

jsqlparser-2.1 (2019-06-30)

Other changes

jsqlparser-2.0 (2019-03-16)

Other changes

jsqlparser-1.4 (2019-01-09)

Other changes

jsqlparser-1.3 (2018-10-02)

Other changes

jsqlparser-1.2 (2018-05-01)

Other changes

jsqlparser-1.1 (2017-06-29)

Other changes

jsqlparser-1.0 (2017-03-25)

Other changes

jsqlparser-0.9.7 (2017-02-26)

Other changes

jsqlparser-0.9.6 (2016-08-23)

Other changes

jsqlparser-0.9.5 (2016-03-13)

Other changes

jsqlparser-0.9.4 (2015-09-13)

Other changes

jsqlparser-0.9.3 (2015-05-12)

Other changes

jsqlparser-0.9.2 (2015-02-12)

Other changes

jsqlparser-0.9.1 (2014-09-23)

Other changes

jsqlparser-0.9 (2014-05-08)

Other changes

jsqlparser-0.8.9 (2014-02-20)

Other changes

jsqlparser-0.8.8 (2014-01-22)

Other changes