[Dbix-class] search_literal

brett gardner brett at clientcomm.com.au
Thu Sep 20 07:18:51 GMT 2007


I think I have found a bug with search_literal. If you get a resultset 
that came from a search_literal, and try to apply another search_literal 
to it, the bind values are in the wrong order eg.

my $rs = $schema->resultset('Foo')->search_literal('foo = ?', 1);
$rs = $rs->search_literal('bar = ?',2);

Spits out the sql

SELECT foo.field
FROM foo
WHERE ( ( foo.bar = ? AND foo.foo = ? ) )

With a bind values array of "[1,2]". It should be a bind values array of 
"[2,1]".

It seems to be adding the second literal string to the front of the 
where clause, but adding the values to the end of the array.

I'm using 0.08003 but a quick search in the change log doesn't mention 
anything about search_literal

Cheers,
Brett Gardner




More information about the DBIx-Class mailing list