Shared lock syntax incompatible with MariaDB
tp971 opened this issue · 0 comments
tp971 commented
When selecting with a shared lock, e.g. Entity::find().lock_shared()
, the generated query looks like SELECT ... FROM ... FOR SHARE
, but MariaDB only supports the syntax SELECT ... FROM ... LOCK IN SHARE MODE
(see https://mariadb.com/kb/en/select/). This is basically the old syntax for MySQL, so this issue might also occur with an old MySQL server. The current MySQL version supports both variants.