Skip to content

Performance Improvements #1439

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Merged
wumpz merged 30 commits into from
Apr 14, 2022
Merged

Performance Improvements #1439

Show file tree
Hide file tree
Changes from 1 commit
Commits
Show all changes
30 commits
Select commit Hold shift + click to select a range
de805ab
Adjust Gradle to JUnit 5
manticore-projects Nov 22, 2021
d5a6dca
Do not mark SpeedTest for concurrent execution
manticore-projects Nov 24, 2021
a9d0503
Remove unused imports
manticore-projects Nov 28, 2021
6dfa05f
Adjust Gradle to JUnit 5
manticore-projects Nov 22, 2021
8f0bfe6
Do not mark SpeedTest for concurrent execution
manticore-projects Nov 24, 2021
5cd0974
Remove unused imports
manticore-projects Nov 28, 2021
5f11d3f
Merge remote-tracking branch 'origin/master'
manticore-projects Nov 28, 2021
b393e00
Performance Improvements
manticore-projects Dec 10, 2021
cb3c91a
Appease PMD
manticore-projects Dec 10, 2021
cdc56c7
Resolve conflicts
manticore-projects Dec 10, 2021
f14cf33
Update Gradle Plugins to its latest versions
manticore-projects Dec 11, 2021
82ce02b
Revert unintended changes to the Test Resources
manticore-projects Dec 11, 2021
c984ff6
Appease PMD/Codacy
manticore-projects Dec 11, 2021
3ab04b0
Merge https://github.com/JSQLParser/JSqlParser
manticore-projects Dec 21, 2021
c075544
Merge branch 'master' into Issue1438
manticore-projects Dec 21, 2021
79bcbc9
Correct the Gradle "+" dependencies
manticore-projects Dec 21, 2021
4c38284
Bump version to 4.4.-SNAPSHOT
manticore-projects Dec 21, 2021
e25ee10
update build file
manticore-projects Dec 30, 2021
de94651
Merge branch 'JSQLParser:master' into master
manticore-projects Jan 24, 2022
84709a9
Merge branch 'master' of github.com:JSQLParser/JSqlParser
manticore-projects Mar 22, 2022
cba3125
revert unwarranted changes in test files
manticore-projects Mar 29, 2022
3b08fde
Merge remote-tracking branch 'origin/master' into Issue1438
manticore-projects Mar 29, 2022
960aaf2
strip the Exception Class Name from the Message
manticore-projects Mar 29, 2022
592de64
maxDepth = 10 collides with the Parser Timeout = 6 seconds
manticore-projects Mar 29, 2022
31caad9
License Headers
manticore-projects Mar 29, 2022
3c8da30
Merge branch 'master' of github.com:JSQLParser/JSqlParser
manticore-projects Apr 4, 2022
4cef39b
Merge branch 'master' into Issue1438
manticore-projects Apr 4, 2022
55f083f
Merge remote-tracking branch 'origin/master' into Issue1438
manticore-projects Apr 14, 2022
2bd7dee
Bump version to 4.5-SNAPSHOT
manticore-projects Apr 14, 2022
d7d2dbe
Merge remote-tracking branch 'manticore/Issue1438' into Issue1438
manticore-projects Apr 14, 2022
File filter

Filter by extension

Filter by extension
Conversations
Failed to load comments.
Loading
Jump to
Jump to file
Failed to load files.
Loading
Diff view
Diff view
Prev Previous commit
Next Next commit
revert unwarranted changes in test files
  • Loading branch information
@manticore-projects
manticore-projects committed Mar 29, 2022
commit cba31250c1963a9cf7411775b53e3ee36e874194
3 changes: 1 addition & 2 deletions src/test/resources/net/sf/jsqlparser/statement/select/oracle-tests/analytic_query02.sql
View file
Open in desktop
Original file line number Diff line number Diff line change
Expand Up @@ -19,5 +19,4 @@ select time_id, product



--@FAILURE: Encountered unexpected token: "(" "(" recorded first on Aug 3, 2021, 7:20:07 AM
--@FAILURE: net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: "(" "(" recorded first on 21 Dec 2021, 15:15:16
--@FAILURE: Encountered unexpected token: "(" "(" recorded first on Aug 3, 2021, 7:20:07 AM
3 changes: 1 addition & 2 deletions src/test/resources/net/sf/jsqlparser/statement/select/oracle-tests/analytic_query03.sql
View file
Open in desktop
Original file line number Diff line number Diff line change
Expand Up @@ -16,5 +16,4 @@ select times.time_id, product, quantity from inventory



--@FAILURE: Encountered unexpected token: "by" "BY" recorded first on Aug 3, 2021, 7:20:08 AM
--@FAILURE: net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: "by" "BY" recorded first on 21 Dec 2021, 15:15:16
--@FAILURE: Encountered unexpected token: "by" "BY" recorded first on Aug 3, 2021, 7:20:08 AM
3 changes: 1 addition & 2 deletions src/test/resources/net/sf/jsqlparser/statement/select/oracle-tests/analytic_query04.sql
View file
Open in desktop
Original file line number Diff line number Diff line change
Expand Up @@ -13,5 +13,4 @@ select deptno
, listagg(ename, ',') within group (order by hiredate) over (partition by deptno) as employees
from emp

--@FAILURE: Encountered unexpected token: "by" "BY" recorded first on Aug 3, 2021, 7:20:08 AM
--@FAILURE: net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: "by" "BY" recorded first on 21 Dec 2021, 15:15:16
--@FAILURE: Encountered unexpected token: "by" "BY" recorded first on Aug 3, 2021, 7:20:08 AM
3 changes: 1 addition & 2 deletions src/test/resources/net/sf/jsqlparser/statement/select/oracle-tests/analytic_query05.sql
View file
Open in desktop
Original file line number Diff line number Diff line change
Expand Up @@ -25,5 +25,4 @@
from timegrouped_rawdata d


--@FAILURE: Encountered unexpected token: "by" "BY" recorded first on Aug 3, 2021, 7:20:08 AM
--@FAILURE: net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: "by" "BY" recorded first on 21 Dec 2021, 15:15:16
--@FAILURE: Encountered unexpected token: "by" "BY" recorded first on Aug 3, 2021, 7:20:08 AM
3 changes: 1 addition & 2 deletions src/test/resources/net/sf/jsqlparser/statement/select/oracle-tests/analytic_query07.sql
View file
Open in desktop
Original file line number Diff line number Diff line change
Expand Up @@ -47,5 +47,4 @@
where a.cluster_id = b.id
order by prob desc, cl_id asc, conf desc, attr asc, val asc

--@FAILURE: Encountered unexpected token: "(" "(" recorded first on Aug 3, 2021, 7:20:08 AM
--@FAILURE: net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: "(" "(" recorded first on 21 Dec 2021, 15:15:16
--@FAILURE: Encountered unexpected token: "(" "(" recorded first on Aug 3, 2021, 7:20:08 AM
3 changes: 1 addition & 2 deletions src/test/resources/net/sf/jsqlparser/statement/select/oracle-tests/bindvar03.sql
View file
Open in desktop
Original file line number Diff line number Diff line change
Expand Up @@ -26,5 +26,4 @@ from
)
where scn > :2

--@FAILURE: Encountered unexpected token: "group" "GROUP" recorded first on Aug 3, 2021, 7:20:08 AM
--@FAILURE: net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: "group" "GROUP" recorded first on 21 Dec 2021, 15:15:16
--@FAILURE: Encountered unexpected token: "group" "GROUP" recorded first on Aug 3, 2021, 7:20:08 AM
3 changes: 1 addition & 2 deletions src/test/resources/net/sf/jsqlparser/statement/select/oracle-tests/bindvar04.sql
View file
Open in desktop
Original file line number Diff line number Diff line change
Expand Up @@ -15,5 +15,4 @@ from
where "rm".a-interval:"sys_b_07" day(:"sys_b_08") to second(:"sys_b_09")
)

--@FAILURE: Encountered unexpected token: "(" "(" recorded first on Aug 3, 2021, 7:20:08 AM
--@FAILURE: net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: "(" "(" recorded first on 21 Dec 2021, 15:15:16
--@FAILURE: Encountered unexpected token: "(" "(" recorded first on Aug 3, 2021, 7:20:08 AM
3 changes: 1 addition & 2 deletions src/test/resources/net/sf/jsqlparser/statement/select/oracle-tests/cast_multiset09.sql
View file
Open in desktop
Original file line number Diff line number Diff line change
Expand Up @@ -10,5 +10,4 @@
update customers_demo
set cust_address_ntab = cust_address_ntab multiset union cust_address_ntab

--@FAILURE: Encountered unexpected token: "multiset" <S_IDENTIFIER> recorded first on Aug 3, 2021, 7:20:08 AM
--@FAILURE: net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: "multiset" <S_IDENTIFIER> recorded first on 21 Dec 2021, 15:15:16
--@FAILURE: Encountered unexpected token: "multiset" <S_IDENTIFIER> recorded first on Aug 3, 2021, 7:20:08 AM
3 changes: 1 addition & 2 deletions src/test/resources/net/sf/jsqlparser/statement/select/oracle-tests/cast_multiset13.sql
View file
Open in desktop
Original file line number Diff line number Diff line change
Expand Up @@ -11,5 +11,4 @@ select customer_id, cust_address_ntab
multiset except distinct cust_address2_ntab multiset_except
from customers_demo

--@FAILURE: Encountered unexpected token: "except" "EXCEPT" recorded first on Aug 3, 2021, 7:20:08 AM
--@FAILURE: net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: "except" "EXCEPT" recorded first on 21 Dec 2021, 15:15:16
--@FAILURE: Encountered unexpected token: "except" "EXCEPT" recorded first on Aug 3, 2021, 7:20:08 AM
3 changes: 1 addition & 2 deletions src/test/resources/net/sf/jsqlparser/statement/select/oracle-tests/cast_multiset14.sql
View file
Open in desktop
Original file line number Diff line number Diff line change
Expand Up @@ -12,5 +12,4 @@ multiset intersect all cust_address2_ntab multiset_intersect
from customers_demo
order by customer_id

--@FAILURE: Encountered unexpected token: "intersect" "INTERSECT" recorded first on Aug 3, 2021, 7:20:08 AM
--@FAILURE: net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: "intersect" "INTERSECT" recorded first on 21 Dec 2021, 15:15:16
--@FAILURE: Encountered unexpected token: "intersect" "INTERSECT" recorded first on Aug 3, 2021, 7:20:08 AM
3 changes: 1 addition & 2 deletions src/test/resources/net/sf/jsqlparser/statement/select/oracle-tests/cast_multiset15.sql
View file
Open in desktop
Original file line number Diff line number Diff line change
Expand Up @@ -12,5 +12,4 @@ multiset union cust_address2_ntab multiset_union
from customers_demo
order by customer_id

--@FAILURE: Encountered unexpected token: "union" "UNION" recorded first on Aug 3, 2021, 7:20:08 AM
--@FAILURE: net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: "union" "UNION" recorded first on 21 Dec 2021, 15:15:16
--@FAILURE: Encountered unexpected token: "union" "UNION" recorded first on Aug 3, 2021, 7:20:08 AM
3 changes: 1 addition & 2 deletions src/test/resources/net/sf/jsqlparser/statement/select/oracle-tests/cast_multiset34.sql
View file
Open in desktop
Original file line number Diff line number Diff line change
Expand Up @@ -16,5 +16,4 @@ select deptno
group by
deptno

--@FAILURE: Encountered unexpected token: "varchar2_ntt" <S_IDENTIFIER> recorded first on Aug 3, 2021, 7:20:08 AM
--@FAILURE: net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: "varchar2_ntt" <S_IDENTIFIER> recorded first on 21 Dec 2021, 15:15:16
--@FAILURE: Encountered unexpected token: "varchar2_ntt" <S_IDENTIFIER> recorded first on Aug 3, 2021, 7:20:08 AM
3 changes: 1 addition & 2 deletions src/test/resources/net/sf/jsqlparser/statement/select/oracle-tests/cast_multiset37.sql
View file
Open in desktop
Original file line number Diff line number Diff line change
Expand Up @@ -18,5 +18,4 @@ select owner
owner
, object_type

--@FAILURE: Encountered unexpected token: "varchar2_ntt" <S_IDENTIFIER> recorded first on Aug 3, 2021, 7:20:08 AM
--@FAILURE: net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: "varchar2_ntt" <S_IDENTIFIER> recorded first on 21 Dec 2021, 15:15:16
--@FAILURE: Encountered unexpected token: "varchar2_ntt" <S_IDENTIFIER> recorded first on Aug 3, 2021, 7:20:08 AM
3 changes: 1 addition & 2 deletions src/test/resources/net/sf/jsqlparser/statement/select/oracle-tests/cast_multiset38.sql
View file
Open in desktop
Original file line number Diff line number Diff line change
Expand Up @@ -12,5 +12,4 @@ select *
multiset union distinct
varchar2_ntt('b','c','d') )

--@FAILURE: Encountered unexpected token: "(" "(" recorded first on Aug 3, 2021, 7:20:08 AM
--@FAILURE: net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: "(" "(" recorded first on 21 Dec 2021, 15:15:16
--@FAILURE: Encountered unexpected token: "(" "(" recorded first on Aug 3, 2021, 7:20:08 AM
3 changes: 1 addition & 2 deletions src/test/resources/net/sf/jsqlparser/statement/select/oracle-tests/cast_multiset39.sql
View file
Open in desktop
Original file line number Diff line number Diff line change
Expand Up @@ -12,5 +12,4 @@ select varchar2_ntt('a','b','c')
varchar2_ntt('b','c','d') as multiset_except
from dual

--@FAILURE: Encountered unexpected token: "except" "EXCEPT" recorded first on Aug 3, 2021, 7:20:08 AM
--@FAILURE: net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: "except" "EXCEPT" recorded first on 21 Dec 2021, 15:15:16
--@FAILURE: Encountered unexpected token: "except" "EXCEPT" recorded first on Aug 3, 2021, 7:20:08 AM
3 changes: 1 addition & 2 deletions src/test/resources/net/sf/jsqlparser/statement/select/oracle-tests/cluster_set01.sql
View file
Open in desktop
Original file line number Diff line number Diff line change
Expand Up @@ -42,5 +42,4 @@ select a.probability prob, a.cluster_id cl_id,
where a.cluster_id = b.id
order by prob desc, cl_id asc, conf desc, attr asc, val asc

--@FAILURE: Encountered unexpected token: "(" "(" recorded first on Aug 3, 2021, 7:20:08 AM
--@FAILURE: net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: "(" "(" recorded first on 21 Dec 2021, 15:15:16
--@FAILURE: Encountered unexpected token: "(" "(" recorded first on Aug 3, 2021, 7:20:08 AM
3 changes: 1 addition & 2 deletions src/test/resources/net/sf/jsqlparser/statement/select/oracle-tests/condition06.sql
View file
Open in desktop
Original file line number Diff line number Diff line change
Expand Up @@ -22,5 +22,4 @@ and t1.sid(+)=t2.sid
and ( ( t1.scode like 'mmm' and t2.scode like 'xax' ) )


--@FAILURE: Encountered unexpected token: "(" "(" recorded first on Aug 3, 2021, 7:20:08 AM
--@FAILURE: net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: "(" "(" recorded first on 21 Dec 2021, 15:15:16
--@FAILURE: Encountered unexpected token: "(" "(" recorded first on Aug 3, 2021, 7:20:08 AM
3 changes: 1 addition & 2 deletions src/test/resources/net/sf/jsqlparser/statement/select/oracle-tests/condition11.sql
View file
Open in desktop
Original file line number Diff line number Diff line change
Expand Up @@ -15,5 +15,4 @@ and nvl(X.cid, '^') = nvl(Y.clientid (+), '^')
and 0 = Lib.SKU(X.sid, nvl(Z.cid, '^'))


--@FAILURE: Encountered unexpected token: "(" "(" recorded first on Aug 3, 2021, 7:20:08 AM
--@FAILURE: net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: "(" "(" recorded first on 21 Dec 2021, 15:15:16
--@FAILURE: Encountered unexpected token: "(" "(" recorded first on Aug 3, 2021, 7:20:08 AM
3 changes: 1 addition & 2 deletions src/test/resources/net/sf/jsqlparser/statement/select/oracle-tests/condition16.sql
View file
Open in desktop
Original file line number Diff line number Diff line change
Expand Up @@ -11,5 +11,4 @@ select * from persons p
where value(p) is of type(only employee_t)


--@FAILURE: Encountered unexpected token: "is" "IS" recorded first on Aug 3, 2021, 7:20:08 AM
--@FAILURE: net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: "is" "IS" recorded first on 21 Dec 2021, 15:15:16
--@FAILURE: Encountered unexpected token: "is" "IS" recorded first on Aug 3, 2021, 7:20:08 AM
3 changes: 1 addition & 2 deletions src/test/resources/net/sf/jsqlparser/statement/select/oracle-tests/condition17.sql
View file
Open in desktop
Original file line number Diff line number Diff line change
Expand Up @@ -10,5 +10,4 @@
delete from table_name
where current of cursor_name

--@FAILURE: Encountered unexpected token: "of" "OF" recorded first on Aug 3, 2021, 7:20:08 AM
--@FAILURE: net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: "of" "OF" recorded first on 21 Dec 2021, 15:15:16
--@FAILURE: Encountered unexpected token: "of" "OF" recorded first on Aug 3, 2021, 7:20:08 AM
3 changes: 1 addition & 2 deletions src/test/resources/net/sf/jsqlparser/statement/select/oracle-tests/condition18.sql
View file
Open in desktop
Original file line number Diff line number Diff line change
Expand Up @@ -12,5 +12,4 @@ set c1 = 'x'
where current of c_cur1


--@FAILURE: Encountered unexpected token: "of" "OF" recorded first on Aug 3, 2021, 7:20:08 AM
--@FAILURE: net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: "of" "OF" recorded first on 21 Dec 2021, 15:15:16
--@FAILURE: Encountered unexpected token: "of" "OF" recorded first on Aug 3, 2021, 7:20:08 AM
3 changes: 1 addition & 2 deletions src/test/resources/net/sf/jsqlparser/statement/select/oracle-tests/explain01.sql
View file
Open in desktop
Original file line number Diff line number Diff line change
Expand Up @@ -16,5 +16,4 @@ explain plan
(select department_id from departments
where location_id = 1700)

--@FAILURE: Encountered unexpected token: "plan" <S_IDENTIFIER> recorded first on Aug 3, 2021, 7:20:08 AM
--@FAILURE: net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: "plan" <S_IDENTIFIER> recorded first on 21 Dec 2021, 15:15:16
--@FAILURE: Encountered unexpected token: "plan" <S_IDENTIFIER> recorded first on Aug 3, 2021, 7:20:08 AM
3 changes: 1 addition & 2 deletions src/test/resources/net/sf/jsqlparser/statement/select/oracle-tests/flashback01.sql
View file
Open in desktop
Original file line number Diff line number Diff line change
Expand Up @@ -9,5 +9,4 @@
---
select value(p$) from "XDB"."XDB$SCHEMA" as of snapshot(:2) p$ where SYS_NC_OID$ = :1

--@FAILURE: Encountered unexpected token: "snapshot" <S_IDENTIFIER> recorded first on Aug 3, 2021, 7:20:08 AM
--@FAILURE: net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: "snapshot" <S_IDENTIFIER> recorded first on 21 Dec 2021, 15:15:16
--@FAILURE: Encountered unexpected token: "snapshot" <S_IDENTIFIER> recorded first on Aug 3, 2021, 7:20:08 AM
3 changes: 1 addition & 2 deletions src/test/resources/net/sf/jsqlparser/statement/select/oracle-tests/for_update06.sql
View file
Open in desktop
Original file line number Diff line number Diff line change
Expand Up @@ -11,5 +11,4 @@ select employee_id from (select employee_id+1 as employee_id from employees)
for update of employee_id skip locked


--@FAILURE: Encountered unexpected token: "skip" "SKIP" recorded first on Aug 3, 2021, 7:20:08 AM
--@FAILURE: net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: "skip" "SKIP" recorded first on 21 Dec 2021, 15:15:16
--@FAILURE: Encountered unexpected token: "skip" "SKIP" recorded first on Aug 3, 2021, 7:20:08 AM
3 changes: 1 addition & 2 deletions src/test/resources/net/sf/jsqlparser/statement/select/oracle-tests/for_update07.sql
View file
Open in desktop
Original file line number Diff line number Diff line change
Expand Up @@ -11,5 +11,4 @@ select employee_id from (select employee_id+1 as employee_id from employees)
for update of a, b.c, d skip locked


--@FAILURE: Encountered unexpected token: "," "," recorded first on Aug 3, 2021, 7:20:08 AM
--@FAILURE: net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: "," "," recorded first on 21 Dec 2021, 15:15:16
--@FAILURE: Encountered unexpected token: "," "," recorded first on Aug 3, 2021, 7:20:08 AM
3 changes: 1 addition & 2 deletions src/test/resources/net/sf/jsqlparser/statement/select/oracle-tests/function03.sql
View file
Open in desktop
Original file line number Diff line number Diff line change
Expand Up @@ -12,5 +12,4 @@ from dual



--@FAILURE: Encountered unexpected token: "(" "(" recorded first on Aug 3, 2021, 7:20:08 AM
--@FAILURE: net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: "(" "(" recorded first on 21 Dec 2021, 15:15:16
--@FAILURE: Encountered unexpected token: "(" "(" recorded first on Aug 3, 2021, 7:20:08 AM
3 changes: 1 addition & 2 deletions src/test/resources/net/sf/jsqlparser/statement/select/oracle-tests/function06.sql
View file
Open in desktop
Original file line number Diff line number Diff line change
Expand Up @@ -9,5 +9,4 @@
---
call dbms_scheduler.auto_purge ( )

--@FAILURE: Encountered unexpected token: ")" ")" recorded first on Aug 3, 2021, 7:20:08 AM
--@FAILURE: net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: ")" ")" recorded first on 21 Dec 2021, 15:15:16
--@FAILURE: Encountered unexpected token: ")" ")" recorded first on Aug 3, 2021, 7:20:08 AM
3 changes: 1 addition & 2 deletions src/test/resources/net/sf/jsqlparser/statement/select/oracle-tests/function07.sql
View file
Open in desktop
Original file line number Diff line number Diff line change
Expand Up @@ -15,5 +15,4 @@ select cust_gender, count(*) as cnt, round(avg(age)) as avg_age
order by cust_gender


--@FAILURE: Encountered unexpected token: "(" "(" recorded first on Aug 3, 2021, 7:20:08 AM
--@FAILURE: net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: "(" "(" recorded first on 21 Dec 2021, 15:15:16
--@FAILURE: Encountered unexpected token: "(" "(" recorded first on Aug 3, 2021, 7:20:08 AM
3 changes: 1 addition & 2 deletions src/test/resources/net/sf/jsqlparser/statement/select/oracle-tests/groupby07.sql
View file
Open in desktop
Original file line number Diff line number Diff line change
Expand Up @@ -16,5 +16,4 @@ where tt='500'
group by tn, ui, (tt || tc)
order by 1

--@FAILURE: Encountered unexpected token: "group" "GROUP" recorded first on Aug 3, 2021, 7:20:08 AM
--@FAILURE: net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: "group" "GROUP" recorded first on 21 Dec 2021, 15:15:16
--@FAILURE: Encountered unexpected token: "group" "GROUP" recorded first on Aug 3, 2021, 7:20:08 AM
3 changes: 1 addition & 2 deletions src/test/resources/net/sf/jsqlparser/statement/select/oracle-tests/groupby18.sql
View file
Open in desktop
Original file line number Diff line number Diff line change
Expand Up @@ -17,5 +17,4 @@ from dimension_tab
group by grouping sets(fact_1_id, fact_2_id), grouping sets(fact_3_id, fact_4_id)
order by fact_1_id, fact_2_id, fact_3_id, fact_4_id

--@FAILURE: Encountered unexpected token: "," "," recorded first on Aug 3, 2021, 7:20:08 AM
--@FAILURE: net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: "," "," recorded first on 21 Dec 2021, 15:15:16
--@FAILURE: Encountered unexpected token: "," "," recorded first on Aug 3, 2021, 7:20:08 AM
3 changes: 1 addition & 2 deletions src/test/resources/net/sf/jsqlparser/statement/select/oracle-tests/insert01.sql
View file
Open in desktop
Original file line number Diff line number Diff line change
Expand Up @@ -14,5 +14,4 @@ insert
into t2 ( x, y ) values ( s.nextval, created )
select object_id, created from all_objects

--@FAILURE: Encountered unexpected token: "when" "WHEN" recorded first on Aug 3, 2021, 7:20:08 AM
--@FAILURE: net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: "when" "WHEN" recorded first on 21 Dec 2021, 15:15:16
--@FAILURE: Encountered unexpected token: "when" "WHEN" recorded first on Aug 3, 2021, 7:20:08 AM
3 changes: 1 addition & 2 deletions src/test/resources/net/sf/jsqlparser/statement/select/oracle-tests/insert03.sql
View file
Open in desktop
Original file line number Diff line number Diff line change
Expand Up @@ -23,5 +23,4 @@ else
values (empno,ename,job,mgr,sal,deptno)
select * from emp

--@FAILURE: Encountered unexpected token: "when" "WHEN" recorded first on Aug 3, 2021, 7:20:08 AM
--@FAILURE: net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: "when" "WHEN" recorded first on 21 Dec 2021, 15:15:16
--@FAILURE: Encountered unexpected token: "when" "WHEN" recorded first on Aug 3, 2021, 7:20:08 AM
3 changes: 1 addition & 2 deletions src/test/resources/net/sf/jsqlparser/statement/select/oracle-tests/insert04.sql
View file
Open in desktop
Original file line number Diff line number Diff line change
Expand Up @@ -14,5 +14,4 @@ into ap_orders values (order_date, program_id)
select program_id, delivered_date, customer_id, order_date
from airplanes

--@FAILURE: Encountered unexpected token: "into" "INTO" recorded first on Aug 3, 2021, 7:20:08 AM
--@FAILURE: net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: "into" "INTO" recorded first on 21 Dec 2021, 15:15:17
--@FAILURE: Encountered unexpected token: "into" "INTO" recorded first on Aug 3, 2021, 7:20:08 AM
3 changes: 1 addition & 2 deletions src/test/resources/net/sf/jsqlparser/statement/select/oracle-tests/insert05.sql
View file
Open in desktop
Original file line number Diff line number Diff line change
Expand Up @@ -17,5 +17,4 @@ into t (pid, fname, lname)
values (3, 'helen', 'lofstrom')
select * from dual

--@FAILURE: Encountered unexpected token: "into" "INTO" recorded first on Aug 3, 2021, 7:20:08 AM
--@FAILURE: net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: "into" "INTO" recorded first on 21 Dec 2021, 15:15:17
--@FAILURE: Encountered unexpected token: "into" "INTO" recorded first on Aug 3, 2021, 7:20:08 AM
3 changes: 1 addition & 2 deletions src/test/resources/net/sf/jsqlparser/statement/select/oracle-tests/insert06.sql
View file
Open in desktop
Original file line number Diff line number Diff line change
Expand Up @@ -22,5 +22,4 @@ else
values (empno,ename,job,mgr,sal,deptno)
select * from emp

--@FAILURE: Encountered unexpected token: "when" "WHEN" recorded first on Aug 3, 2021, 7:20:08 AM
--@FAILURE: net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: "when" "WHEN" recorded first on 21 Dec 2021, 15:15:16
--@FAILURE: Encountered unexpected token: "when" "WHEN" recorded first on Aug 3, 2021, 7:20:08 AM
3 changes: 1 addition & 2 deletions src/test/resources/net/sf/jsqlparser/statement/select/oracle-tests/insert07.sql
View file
Open in desktop
Original file line number Diff line number Diff line change
Expand Up @@ -20,5 +20,4 @@ when customer_id > 'pzzz' then
select program_id, delivered_date, customer_id, order_date
from airplanes

--@FAILURE: Encountered unexpected token: "when" "WHEN" recorded first on Aug 3, 2021, 7:20:08 AM
--@FAILURE: net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: "when" "WHEN" recorded first on 21 Dec 2021, 15:15:16
--@FAILURE: Encountered unexpected token: "when" "WHEN" recorded first on Aug 3, 2021, 7:20:08 AM
3 changes: 1 addition & 2 deletions src/test/resources/net/sf/jsqlparser/statement/select/oracle-tests/insert08.sql
View file
Open in desktop
Original file line number Diff line number Diff line change
Expand Up @@ -14,5 +14,4 @@ from dept
where deptno < 30)
values (98, 'travel', 'seattle')

--@FAILURE: Encountered unexpected token: "(" "(" recorded first on Aug 3, 2021, 7:20:08 AM
--@FAILURE: net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: "(" "(" recorded first on 21 Dec 2021, 15:15:16
--@FAILURE: Encountered unexpected token: "(" "(" recorded first on Aug 3, 2021, 7:20:08 AM
3 changes: 1 addition & 2 deletions src/test/resources/net/sf/jsqlparser/statement/select/oracle-tests/insert09.sql
View file
Open in desktop
Original file line number Diff line number Diff line change
Expand Up @@ -13,5 +13,4 @@ from dept
where deptno < 30 with check option)
values (99, 'travel', 'seattle')

--@FAILURE: Encountered unexpected token: "(" "(" recorded first on Aug 3, 2021, 7:20:08 AM
--@FAILURE: net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: "(" "(" recorded first on 21 Dec 2021, 15:15:16
--@FAILURE: Encountered unexpected token: "(" "(" recorded first on Aug 3, 2021, 7:20:08 AM
3 changes: 1 addition & 2 deletions src/test/resources/net/sf/jsqlparser/statement/select/oracle-tests/insert10.sql
View file
Open in desktop
Original file line number Diff line number Diff line change
Expand Up @@ -13,5 +13,4 @@ insert into (
values
(1, 'morgan', 'dba', '1', 40)

--@FAILURE: Encountered unexpected token: "(" "(" recorded first on Aug 3, 2021, 7:20:08 AM
--@FAILURE: net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: "(" "(" recorded first on 21 Dec 2021, 15:15:16
--@FAILURE: Encountered unexpected token: "(" "(" recorded first on Aug 3, 2021, 7:20:08 AM
3 changes: 1 addition & 2 deletions src/test/resources/net/sf/jsqlparser/statement/select/oracle-tests/insert11.sql
View file
Open in desktop
Original file line number Diff line number Diff line change
Expand Up @@ -14,5 +14,4 @@
returning empno
into x

--@FAILURE: Encountered unexpected token: "into" "INTO" recorded first on Aug 3, 2021, 7:20:08 AM
--@FAILURE: net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: "into" "INTO" recorded first on 21 Dec 2021, 15:15:17
--@FAILURE: Encountered unexpected token: "into" "INTO" recorded first on Aug 3, 2021, 7:20:08 AM
3 changes: 1 addition & 2 deletions src/test/resources/net/sf/jsqlparser/statement/select/oracle-tests/insert12.sql
View file
Open in desktop
Original file line number Diff line number Diff line change
Expand Up @@ -14,5 +14,4 @@
returning rowid
into r

--@FAILURE: Encountered unexpected token: "into" "INTO" recorded first on Aug 3, 2021, 7:20:08 AM
--@FAILURE: net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: "into" "INTO" recorded first on 21 Dec 2021, 15:15:17
--@FAILURE: Encountered unexpected token: "into" "INTO" recorded first on Aug 3, 2021, 7:20:08 AM
Loading