Issues

Select view

Select search mode

 
15 of 15

LEFT JOIN in HQL creates CROSS-JOINS in SQL disabling "WHERE 1=1 OR "-wavebys

Rejected

Description

I have a HQL-Query:

Since I wrote 1=1 I expect to have all rows from VisualColor but I got none.

The constructed query is:

Please help

Details

Assignee

Reporter

Components

Affects versions

Priority

Created November 5, 2022 at 12:01 PM
Updated November 23, 2022 at 2:02 PM
Resolved November 23, 2022 at 2:02 PM

Activity

Show:

Christian Beikov November 23, 2022 at 2:02 PM

Read the JPA specification about how path navigation must be implemented: https://jakarta.ee/specifications/persistence/3.0/jakarta-persistence-spec-3.0.html#path-expressions

What you are seeing here is inner join semantics. If you want left join semantics, add left joins and use the aliases.

Loading...