Skip Menu |

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

Report information
The Basics
Id: 59619
Status: resolved
Priority: 0/
Queue: DBIx-Class
People
Owner: Nobody in particular
Requestors: qalexx [...] gmail.com
Cc:
AdminCc:
Bug Information
Severity: Normal
Broken in: 0.08123
Fixed in: 0.08124

History Show all quoted text
  Thu Jul 22 09:02:02 2010 http://lattenwald.blogspot.com/ - Ticket created
Subject: DBIx::Class::Schema::Versioned _source_exists fails with 'quote_char' => '"' set
A problem is in DBIx::Class::Schema::Versioned Private function _source_exists does not work with postgresql if connect_info includes 'quote_char' => '"'. $rs->search({ 1, 0 })->count at line 728 results in SQL request "SELECT COUNT( * ) FROM "dbix_class_schema_versions" "me" WHERE ( "1" = ? )" with ParamValues: 1='0' and DBD::Pg raises exception DBI Exception: DBD::Pg::st execute failed: ERROR: column "1" does not exist Suggested solution: use something like $rs->search(undef, { where => \"1=0" })->count instead of $rs->search({ 1, 0 })->count
  Sun Aug 08 07:33:40 2010 ribasushi [...] leporine.io - Correspondence added
On Thu Jul 22 09:02:02 2010, http://lattenwald.blogspot.com/ wrote: Show quoted text
> A problem is in DBIx::Class::Schema::Versioned > > Private function _source_exists does not work with postgresql if > connect_info includes 'quote_char' => '"'. > > $rs->search({ 1, 0 })->count > at line 728 results in SQL request > "SELECT COUNT( * ) FROM "dbix_class_schema_versions" "me" WHERE ( "1" > = ? )" with ParamValues: 1='0' > and DBD::Pg raises exception > DBI Exception: DBD::Pg::st execute failed: ERROR: column "1" does not > exist >
Fixed: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?p=dbsrgits/DBIx-Class.git;a=commitdiff;h=a6ef2213326ba49a7735c37f034f406c9780b99d Show quoted text
> Suggested solution: > use something like > $rs->search(undef, { where => \"1=0" })->count > instead of > $rs->search({ 1, 0 })->count
Please note that using where this way is discouraged. Thanks
  Sun Aug 08 07:33:44 2010 The RT System itself - Status changed from 'new' to 'open'
  Sun Aug 08 07:33:44 2010 ribasushi [...] leporine.io - Status changed from 'open' to 'patched'
  Fri Oct 29 04:21:53 2010 ribasushi [...] leporine.io - Status changed from 'patched' to 'resolved'
  Fri Oct 29 04:21:53 2010 ribasushi [...] leporine.io - Fixed in 0.08124 added