InternetEntityRepository#findUnauthorizedByUser and InternetEntityRepository#findIsAuthorizedByUser give unexpected query result

[c910335]

Their @Query should be something like these.

-- InternetEntityRepository#findUnauthorizedByUser
SELECT internet_entity.*, FALSE as authorized FROM internet_entity
LEFT JOIN entity_authorization on internet_entity.id = entity_authorization.entity_id AND entity_authorization.authorizee_id = :user_id
WHERE entity_authorization.authorizee_id IS NULL;
-- InternetEntityRepository#findIsAuthorizedByUser
SELECT internet_entity.*, entity_authorization.authorizee_id IS NOT NULL as authorized FROM internet_entity
LEFT JOIN entity_authorization on internet_entity.id = entity_authorization.entity_id AND entity_authorization.authorizee_id = :user_id;

However, I have no idea how to program with Spring flavored SQL(JPA?).