-
-
Notifications
You must be signed in to change notification settings - Fork 9.6k
[Messenger] fix compatibility with Doctrine DBAL 4 #52476
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Conversation
xabbuh
commented
Nov 6, 2023
Q | A |
---|---|
Branch? | 5.4 |
Bug fix? | no |
New feature? | no |
Deprecations? | no |
Issues | |
License | MIT |
The idea behind that feature was that Symfony could leverage the query builder for building the "skip locked rows" query. |
97aacef
to
2f059e0
Compare
Thanks for your feedback. I guess it's better now. |
src/Symfony/Component/Messenger/Bridge/Doctrine/Transport/Connection.php
Outdated
Show resolved
Hide resolved
src/Symfony/Component/Messenger/Bridge/Doctrine/Transport/Connection.php
Show resolved
Hide resolved
src/Symfony/Component/Messenger/Bridge/Doctrine/Transport/Connection.php
Outdated
Show resolved
Hide resolved
2f059e0
to
55b000e
Compare
if (preg_match('/FROM (.+) WHERE/', (string) $sql, $matches)) { | ||
|
||
if (method_exists(QueryBuilder::class, 'forUpdate')) { | ||
$query->forUpdate(); |
There was a problem hiding this comment.
Choose a reason for hiding this comment
The reason will be displayed to describe this comment to others. Learn more.
For the case of the oracle platform, this is now applying the lock on the inner query and not the outer one (see the specific code below). Is this expected ?
There was a problem hiding this comment.
Choose a reason for hiding this comment
The reason will be displayed to describe this comment to others. Learn more.
it's probably better not to change the outcome here, updated
55b000e
to
fca96ac
Compare
Thank you @xabbuh. |