Merge pull request #334 from MatthiasKuehneEllerhold/0.12.3-fix-limit1FOR_UPDATE

acrobat · web-flow · commit c452caa6de20 · 2017-11-05T19:32:45.000+01:00
[0.x] DoctrineDriver: Fix "LIMIT 1FOR UPDATE"
diff --git a/src/Bernard/Driver/DoctrineDriver.php b/src/Bernard/Driver/DoctrineDriver.php
@@ -122,7 +122,7 @@ protected function doPopMessage($queueName)
     {
         $query = 'SELECT id, message FROM bernard_messages
                   WHERE queue = :queue AND visible = :visible
-                  ORDER BY sentAt, id LIMIT 1' . $this->connection->getDatabasePlatform()->getForUpdateSql();
+                  ORDER BY sentAt, id LIMIT 1 ' . $this->connection->getDatabasePlatform()->getForUpdateSql();
 
         list($id, $message) = $this->connection->fetchArray($query, array(
             'queue' => $queueName,

Original file line number	Diff line number	Diff line change
`@@ -122,7 +122,7 @@ protected function doPopMessage($queueName)`
`122`	`122`	`{`
`123`	`123`	`$query = 'SELECT id, message FROM bernard_messages`
`124`	`124`	`WHERE queue = :queue AND visible = :visible`
`125`		`- ORDER BY sentAt, id LIMIT 1' . $this->connection->getDatabasePlatform()->getForUpdateSql();`
	`125`	`+ ORDER BY sentAt, id LIMIT 1 ' . $this->connection->getDatabasePlatform()->getForUpdateSql();`
`126`	`126`
`127`	`127`	`list($id, $message) = $this->connection->fetchArray($query, array(`
`128`	`128`	`'queue' => $queueName,`