TicketRepository.freeFromReservation does not clear up special_price_id_fk column

[syjer]

TicketRepository.freeFromReservation does not clear up special_price_id_fk column.

This is an issue as we cannot reuse a code

See current query

@Query("update ticket set status = 'FREE', tickets_reservation_id = null where status = 'PENDING' "
+ " and tickets_reservation_id in (:reservationIds)")
int freeFromReservation(@Bind("reservationIds") List<String> reservationIds);

Edit: actually I'm not sure that it's the only place that we need to change/check.

What we are seeing is this error (how we were able to create is an open issue)

Caused by: org.postgresql.util.PSQLException: ERROR: duplicate key value violate
unique constraint "unique_special_price"

[syjer]

fixed