forked from JSQLParser/JSqlParser
-
Notifications
You must be signed in to change notification settings - Fork 1
/
change.log
149 lines (111 loc) · 3.06 KB
/
change.log
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
0.2
added optional ';' at the end of the statements
LIMIT
fixed "all columns" parsing bug, as in "select table_name.* from table_name"
UNION
0.2.1
DISTINCT ON clause
OFFSET without LIMIT
0.3
added select test cases
Fixed bug in table name (schema was swapped with the name)
Changed tableName field into table (since it is a Table object) in AllTableColumns class
added INNER join
fixed bug in IN,BETWEEN,IS NULL
fixed bug in GROUP BY (comma between list of columns was missing)
HAVING is not tied to GROUP BY anymore
Changed OrderBy in OrderByElement and OrderByClause in OrderBy
added all different syntaxes for REPLACE
Changed Update in order to be more similar to Replace
Added CREATE TABLE, DROP
0.3.1
added SpeedTest
0.3.2
added Truncate
0.3.3
Added de-parsers
Removed OrderBy (it was just a list of collection of ColumnRefences)
Removed GroupBy (it was just a list of collection of GroupByElements)
Removed list in case they are empty (just leave them as null)
0.3.4
table name and schema default to null
0.3.5
added USING in Joins and functions handling
0.3.6
proper numbers management
0.3.7
added date,time and timestamp parsing
fixed double alias in deparser
0.3.8
escaped functions
SQLExpressionList is a list of Expressions, not SimpleExpressions
0.3.9
fixed bug in no-args function deparser
0.3.10
fixed bug in GROUP BY and LIMIT in DeParser
0.3.11
fixed ASC/DESC bug in SelectDeParser
added toString methods
added TOP
0.3.12
toStrings
0.3.13
fixed minor toString bug
0.3.16
escape clause
fixed bug in order of having and order by items
0.4.0
added EXISTS clause
0.4.1
removed bug on Function names
0.4.2
Added ANY, SOME, ALL conditions
0.4.3
Removed bug 1928388
0.4.4
Added NOT to binaryexpressions
Fixed double handling (1e2, e3 etc)
0.4.5
Fixed NOT handling
Fixed not-SQL statement parsing (lots of changes in the parser)
0.5.0
Fixed "case when a > 0 then b + a"
Fixed "from tab1, left join tab2 on ..., tab3" case
0.5.1
Added RIGHT NATURAL FULL joins
0.5.2
Added SubJoin for: select * from foo as f LEFT JOIN
(bar as b RIGHT JOIN baz as z ON f.id=z.id)
ON f.id=b.id
0.6.0
Added WITH clause
0.6.1
fixed tab1, tab2 treated as INNER JOIN
Added UNION ALL or DISTINCT (but works only for first UNION)
0.6.1.a
Docs dir was missing
0.6.2
where expr1 and NOT (expr2) was not working
0.6.2.a
right expression in AND NOT didn't use NOT
0.6.3
better join.toString method
0.6.4
Alias was missing in Join SelectDeParser handling
Added DISINCT
Fixed alias in table for update
0.6.5
Added backtick ` as a quote identifier
Added support for "__" identifiers
0.6.6
Added concat (||) operator
Arithmetic expressions in CASE expression
0.7.0
Added matches (@@) operator
Changed order by and group by to be Expressions
Added bitwise operators (|, ^, &)
0.7.1
Changed project layout to maven project
Added regexp (REGEXP) operator
Added support for SELECT without FROM (e.g. "SELECT 1+2")
Moved parser from using StringBuffer to using StringBuilder