SoftDeleted entities are not filtered/excluded from database results

[Jayfrown]

SoftDeleted entities are not filtered/excluded from database results

[Jayfrown]

Apologies for the spam - I think I've found the issue here.

The Doctrine tab in the Symfony Profiler shows the executed database query to be the following:

SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.created_by AS created_by_5, t0.updated_by AS updated_by_6, t0.deleted_at AS deleted_at_7 FROM test_events t0 WHERE t0.id = ? AND (((t0.deleted_at IS NULL OR t0.deleted_at > CURRENT_TIMESTAMP)))

This appears to filter on deleted_at IS NULL or later than CURRENT_TIMESTAMP, and, yeah, wouldn't you know it:

❯ bin/console dbal:run-sql "SELECT deleted_at FROM test_events WHERE id = 0x1ec875b84ec1690e875cf7d92857e532;"
 --------------------- 
  deleted_at           
 --------------------- 
  2022-02-06 16:00:10  
 --------------------- 

 ❯ bin/console dbal:run-sql "SELECT CURRENT_TIMESTAMP;"                                                        
 --------------------- 
  CURRENT_TIMESTAMP    
 --------------------- 
  2022-02-06 15:40:49  
 --------------------- 

So I suppose this is due to my PHP application working with the Europe/Amsterdam timezone, and my database working with a different timezone, which is an hour behind from Europe/Amsterdam.