| Subject: | {for => "shared"} lock do not work with MySQL |
MySQL uses 'LOCK FOR SHARE MODE' syntax for shared mode locks.
Trying to set {for => "shared"} lock generates following error:
# Failed test 'LOCK IN SHARE MODE select works'
# at t/71mysql.t line 96.
# died: DBIx::Class::Exception (DBIx::Class::ResultSet::find(): DBI
Exception: DBD::mysql::st execute failed: You have an error in your SQL
syntax; check the manual that corresponds to your MySQL server version
for the right syntax to use near 'SHARE' at line 1 [for Statement
"SELECT me.artistid, me.name, me.rank, me.charfield FROM artist me WHERE
( me.artistid = ? ) FOR SHARE" with ParamValues: 0=1] at t/71mysql.t line 91
I have attached test case and a proposed patch.
| Subject: | dbix-mysql-patch |
Message body not shown because it is not plain text.