the genereated AS in table alias not supported in Oracle [DATAJDBC-394]

[spring-projects-issues]

Mustapha CHARBOUB opened DATAJDBC-394 and commented

Hello, 

The query generated in the findAll() on the case of the left outer join contain AS TABLE_NAME like this :

LEFT OUTER JOIN T1 AS TYPE

and AS is not supported in Oracle .

 

I think the problem in the method joinTable in SelectBuilder :

 

String.format("%s JOIN %s AS %s", j.outerJoinModifier(), j.table, j.as)

I don't know if I remove the AS will not impact the other implementations.

 

 

---

Affects: 1.0.9 (Lovelace SR9)

Referenced from: pull request #162, and commits 14d7902, 4413a89, a50e59f

[spring-projects-issues]

Jens Schauder commented

Note that Oracle isn't fully supported yet