Hello guys,
in phalcon 1.3.3 is added for update functionality. But I getting this error:
Syntax error, unexpected token IDENTIFIER(FOR), near to ' UPDATE', when parsing: SELECT [InvoicePayment].* FROM [InvoicePayment] WHERE id = :id: AND [invoice_id] = ?0 FOR UPDATE (96)
#0 [internal function]: Phalcon\Mvc\Model\Query->parse()
#1 [internal function]: Phalcon\Mvc\Model\Query->execute(Array, NULL)
...
My code:
$regularPayment = $this->_getInvoice()->getInvoicePayment([
'id = :id:',
'bind' => [
'id' => $key
],
'for_update' => true
]);
Are you tried for_update in Phalcon 1.3.3 ? And how about shared_lock? Is it added too?