Description
Symfony version(s) affected: 5.1.2
Description
I added a doctrine transport to an existing application using doctrine://default
. When Messenger tries to create the table I receive the error SQLSTATE[IMSSP]: This function is not implemented by this driver.
SQL Server works fine with Doctrine, Migrations, and Fixtures.
How to reproduce
Using SQL Server 2019 with MS SQL Server Drivers for PHP, add an async transport to messenger with the connection string of doctrine://default
.
Possible Solution
Looking at the error trace, the error is at Symfony\Component\Messenger\Bridge\Doctrine\Transport\DoctrineTransportFactory
line 50.
This is not a solution per-se, but when I comment out the PostgreSQL checks in Symfony\Component\Messenger\Bridge\Doctrine\Transport\DoctrineTransportFactory
(lines 50-52, 53) and only run the connection on line 53, the table was created without a problem.
I don't want to create a pull request removing that code (reverting it back to the original code before #35485) because I don't have enough knowledge of surrounding code :/