Add lateral sub select join type "(+)" #1041

evan-choi · 2020-09-08T14:34:29Z

SELECT
    T1.d,
    LV.c
FROM
    T1,
    LATERAL (SELECT T2.C FROM T2 WHERE T1.x = T2.x AND T2.k = 5)(+) LV;

The lateral view in query is merged to yield query. Like this

SELECT
    T1.d,
    T2.c
FROM
    T1,
    T2
WHERE
    T1.x = T2.x(+) AND T2.k(+) = 5;

But, JSqlParser did not support this syntax. So I added.


          Add old oracle join type to lateral sub select

coveralls · 2020-09-08T14:55:43Z

Coverage decreased (-0.09%) to 86.517% when pulling 289f9b1 on evan-choi:oracle-lateral-join into abedce5 on JSQLParser:master.


          Tweak toString()


          Add "(+)" to testLateral1

Add old oracle join type to lateral sub select

Loading status checks…

abc39a5

evan-choi changed the title ~~Add old oracle join type to lateral sub select~~ Add lateral sub select join type "(+)" Sep 8, 2020

evan-choi added 2 commits Sep 8, 2020

Tweak toString()

0f275e6

Add "(+)" to testLateral1

Loading status checks…

289f9b1

JSQLParser / JSqlParser