Skip Menu |
 

This queue is for tickets about the DBIx-Class CPAN distribution.

Report information
The Basics
Id: 64590
Status: resolved
Priority: 0/
Queue: DBIx-Class

People
Owner: Nobody in particular
Requestors: littlesavage [...] orionet.ru
Cc:
AdminCc:

Bug Information
Severity: Unimportant
Broken in: (no value)
Fixed in: 0.08127



Subject: {for => "shared"} lock do not work with MySQL
Download (untitled) / with headers
text/plain 681b
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
Download dbix-mysql-patch
application/octet-stream 1k

Message body not shown because it is not plain text.

Download (untitled) / with headers
text/plain 996b
On Fri Jan 07 19:43:32 2011, littlesavage wrote: Show quoted text
> 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 Show quoted text
> > I have attached test case and a proposed patch.
Applied with no changes. Please verify that the name/email is credited correctly in DBIx/Class.pm http://git.shadowcat.co.uk/gitweb/gitweb.cgi?p=dbsrgits/DBIx-Class.git;a=commitdiff;h=a2160fee3f3f89572bfe5d61202f3e72c48787eb Thank you!
From: littlesavage [...] orionet.ru
Download (untitled) / with headers
text/plain 123b
Show quoted text
> Applied with no changes. Please verify that the name/email is credited > correctly in DBIx/Class.pm
All correct. Thanks!


This service is sponsored and maintained by Best Practical Solutions and runs on Perl.org infrastructure.

Please report any issues with rt.cpan.org to rt-cpan-admin@bestpractical.com.