I have two tables in PostgreSQL. When I use HQL
DELETE FROM AccessTokenVO at WHERE at.authentication.hash = :hash
for deleting, Hibernate produce:
2016-03-29 13:14:56.514 [http-nio-8200-exec-1] DEBUG org.hibernate.SQL - delete from a_access_token cross join a_authentication authentica1_ where hash=?
2016-03-29 13:14:56.514 [http-nio-8200-exec-1] TRACE o.h.type.descriptor.sql.BasicBinder - binding parameter [1] as [VARCHAR] - [3cb3d8f75e7560cfbfe1013f0a16f975]
which raise syntax exception in PostgreSQL near "cross". Cross joins are not supported on delete operation. |