| As i expected the query
Unable to find source-code formatter for language: jpql. Available languages are: actionscript, ada, applescript, bash, c, c#, c++, cpp, css, erlang, go, groovy, haskell, html, java, javascript, js, json, lua, none, nyan, objc, perl, php, python, r, rainbow, ruby, scala, sh, sql, swift, visualbasic, xml, yaml
from Child c where c.parent is null
works perfectly fine and generates the following SQL
select
child0_.id as id1_0_,
child0_.parent_id as parent_i2_0_
from
Child child0_
where
child0_.parent_id is null
This is clearly not an implicit join, therefor
Unable to find source-code formatter for language: jpql. Available languages are: actionscript, ada, applescript, bash, c, c#, c++, cpp, css, erlang, go, groovy, haskell, html, java, javascript, js, json, lua, none, nyan, objc, perl, php, python, r, rainbow, ruby, scala, sh, sql, swift, visualbasic, xml, yaml
from Parent p where p.child is null
should not be an implicit join either and should generate the exact same SQL as the query
Unable to find source-code formatter for language: jpql. Available languages are: actionscript, ada, applescript, bash, c, c#, c++, cpp, css, erlang, go, groovy, haskell, html, java, javascript, js, json, lua, none, nyan, objc, perl, php, python, r, rainbow, ruby, scala, sh, sql, swift, visualbasic, xml, yaml
from Parent p where p.children is empty
would for a one-to-many relation:
select
parent0_.id as id1_1_
from
Parent parent0_
where
not (exists (select
child1_.id
from
Child child1_
where
parent0_.id=child1_.parent_id))
|
