Mysql 8 Soft Deleted entities are returned

[On5-Repos]

Hi Everyone, We are looking Cloud SQL (google) for Symfony 7 ... Google only offers MySQL 8.0 as a serverless database. Everything works ok except DeleteAt filter ... When we query a entity ... Doctrine returns DELETE AT entities as well. But if we switch to MariaDB 10 or above which is our DEV Setup everything works as expected. Do we need to setup any FLAGS on mysql 8?I am unable to find anything online about MySql 8 FLAGS (edited)

Environment

Symfony 7.1 Mysql 8.0.35

$ composer show --latest gedmo/doctrine-extensions
name     : gedmo/doctrine-extensions
descrip. : Doctrine behavioral extensions
keywords : Blameable, behaviors, doctrine, extensions, gedmo, loggable, nestedset, odm, orm, sluggable, sortable, timestampable, translatable, tree, uploadable
versions : * v3.16.1
released : 2024-06-25, 1 month ago
latest   : v3.16.1 released 2024-06-25, 1 month ago
type     : library

Doctrine packages

show

``` $ composer show --latest 'doctrine/*' doctrine/cache 2.2.0 2.2.0 PHP Doctrine Cache library is a popular cache implementation that supports many different drivers such as redis, memcache,... doctrine/collections 2.2.2 2.2.2 PHP Doctrine Collections library that adds additional functionality on top of PHP arrays. doctrine/common 3.4.4 3.4.4 PHP Doctrine Common project is a library that provides additional functionality that other Doctrine projects depend on suc... doctrine/data-fixtures 1.7.0 1.7.0 Data Fixtures for all Doctrine Object Managers doctrine/dbal 3.8.6 4.0.4 Powerful PHP database abstraction layer (DBAL) with many features for database schema introspection and management. doctrine/deprecations 1.1.3 1.1.3 A small layer on top of trigger_error(E_USER_DEPRECATED) or PSR-3 logging with options to disable all deprecations or sele... doctrine/event-manager 2.0.1 2.0.1 The Doctrine Event Manager is a simple PHP event system that was built to be used with the various Doctrine projects. doctrine/inflector 2.0.10 2.0.10 PHP Doctrine Inflector is a small library that can perform string manipulations with regard to upper/lowercase and singula... doctrine/instantiator 2.0.0 2.0.0 A small, lightweight utility to instantiate objects in PHP without invoking their constructors doctrine/lexer 3.0.1 3.0.1 PHP Doctrine Lexer parser library that can be used in Top-Down, Recursive Descent Parsers. doctrine/migrations 3.8.0 3.8.0 PHP Doctrine Migrations project offer additional functionality on top of the database abstraction layer (DBAL) for version... doctrine/persistence 3.3.3 3.3.3 The Doctrine Persistence project is a set of shared interfaces and functionality that the different Doctrine object mapper... doctrine/sql-formatter 1.4.0 1.4.0 a PHP SQL highlighting library ```

PHP version

$ php -v
PHP 8.2.21 (cli) (built: Jul  2 2024 12:51:54) (NTS)
Copyright (c) The PHP Group
Zend Engine v4.2.21, Copyright (c) Zend Technologies
    with Xdebug v3.3.2, Copyright (c) 2002-2024, by Derick Rethans
    with Zend OPcache v8.2.21, Copyright (c), by Zend Technologies

[mbabker]

Have you verified the filter is enabled? Have you correctly configured your object to be soft-deleteable? Your composer show output doesn't include any object manager packages (doctrine/mongodb-odm or doctrine/orm), are you using an object manager or using the DBAL directly? The filters work with the object managers, so if the answer to that last one is yes, then this is an unsupported case.

[On5-Repos]

Issue was mismatch of cloud sql timestamp with web server. Once I have same Timezone setup on both then delete filter worked as expected. I was not awake that it's time sensitive... I will go ahead and close the issue