Problem in $this->em->createNativeQuery

[aurelienpiquet]

Hello,

Here is the bug i have:

"detail": "An exception occurred while executing 'SELECT * FROM faq WHERE id IN (c06cf73a-e4a8-11ec-b466-0242ac120004, c06caf90-e4a8-11ec-b466-0242ac120004) ORDER BY FIELD(id,c06cf73a-e4a8-11ec-b466-0242ac120004, c06caf90-e4a8-11ec-b466-0242ac120004)':\n\nSQLSTATE[42S22]: Column not found: 1054 Unknown column 'c06cf73a' in 'where clause'",

The SQL query doesn't have '' arround the ids, so it returns this error. If i run this query manualy with the '' arround the ids, it works fine.

It seems to work fine if i change the CollectionFinder.php to :

        for ($i = 0; $i < count($ids); $i++) {
            if ($i === count($ids) -1) {
                $sentence .= "'" . $ids[$i] . "'";
            } else {
                $sentence .= "'" . $ids[$i] . "',";
            }
        }
         $query           = $this->em->createNativeQuery('SELECT * FROM '.$tableName.' WHERE '.$primaryKeyInfos['entityAttribute'].'   IN ('. $sentence . ') ORDER BY FIELD(id,'. $sentence .')', $rsm);

Here is my composer.json : "php": "8.0.", "ext-ctype": "", "ext-gd": "", "ext-iconv": "", "acseo/typesense-bundle": "^0.6.7", "beberlei/doctrineextensions": "^1.3", "doctrine/annotations": "^1.0", "doctrine/dbal": "^2.10", "doctrine/doctrine-bundle": "^2.5", "doctrine/doctrine-migrations-bundle": "^3.2", "doctrine/orm": "^2.11", "phpstan/phpdoc-parser": "^1.2", "phpstan/phpstan-doctrine": "^1.2", "phpstan/phpstan-symfony": "^1.1", "symfony/asset": "5.4.", "symfony/console": "5.4.", "symfony/dotenv": "5.4.", "symfony/expression-language": "5.4.", "symfony/flex": "^1.17|^2", "symfony/form": "5.4.", "symfony/framework-bundle": "5.4.", "symfony/htatp-client": "5.4.", "symfony/intl": "5.4.", "symfony/mailer": "5.4.", "symfony/messenger": "5.4.", "symfony/mime": "5.4.", "symfony/monolog-bundle": "^3.0", "symfony/notifier": "5.4.", "symfony/process": "5.4.", "symfony/property-access": "5.4.", "symfony/property-info": "5.4.", "symfony/proxy-manager-bridge": "5.4.", "symfony/runtime": "5.4.", "symfony/security-bundle": "5.4.", "symfony/sendgrid-mailer": "5.3.", "symfony/serializer": "5.4.", "symfony/string": "5.4.", "symfony/templating": "5.4.", "symfony/translation": "5.4.", "symfony/twig-bundle": "5.4.", "symfony/uid": "5.4.", "symfony/validator": "5.4.", "symfony/web-link": "5.4.", "symfony/webapp-meta": "^1.0", "symfony/webpack-encore-bundle": "^1.12", "symfony/yaml": "5.4.",

Can this parse error comes from my configs?

Regards