Message Title

Burner created an issue

Issue Type:	Bug
Affects Versions:	6.1.7
Assignee:	Unassigned
Created:	17/Apr/2023 01:50 AM
Environment:	Spring Boot 3.0.4
Priority:	Major
Reporter:	Burner

I want to implement a soft delete for my entities. So I create this annoations:

                              @SQLDelete(sql = "UPDATE ExternalReference SET deleted=true, deletedAt=now() WHERE id=?")
@Where(clause = "deleted = false")
public class ExternalReference {
...
}
                              

Repository:

                              public interface ExternalReferenceRepo extends JpaRepository<ExternalReference, Long> {
	@Modifying
	@Query("DELETE FROM #{#entityName} e WHERE e.id = :iId")
	void delete(@Param("iId") Long id);
}
                              

When I use the method delete. Hibernate create this SQL:

                              DELETE
FROM external_reference_our_object
WHERE external_reference_our_object.external_reference_id in
    (SELECT e1_0.id
     FROM external_reference e1_0
     WHERE e1_0.external_system=?
       AND e1_0.external_class=?
       AND e1_0.external_id=?
       AND (external_reference.deleted = 0))];
                              

And I get this Error Message:

SQL Error: 1054, SQLState: 42S22
(conn=43) Unknown column 'external_reference.deleted' in 'where clause'

Because external_reference.deleted should be e1_0.deleted

Add Comment

Get Jira notifications on your phone! Download the Jira Cloud app for Android or iOS

This message was sent by Atlassian Jira