[Dbix-class] SQL::Abstract

Duncan Garland Duncan.Garland at motortrak.com
Tue May 7 17:24:49 GMT 2013


Hi,

Does anybody know what's happening here? (I know the index is switched off.)

This:

@rs = $schema->resultset("LeasingUser")->search( \[ 'UPPER(username) = ?', uc($username) ] );
ok( scalar(@rs), "Did a case insensitive (uc) search for $username." );

Produces:

SELECT me.first_name, me.last_name, me.retailer, me.username, me.user_type, me.expires, me.cookie, me.active, me.last_login FROM USERS me WHERE ( username = ? ) : 'duncan.garland at motortrak.com'
# duncan.garland at motortrak.com
ok 1 - Did a case insensitive (uc) search for duncan.garland at motortrak.com.
DBIx::Class::ResultSet::search(): [SQL::Abstract::_assert_bindval_matches_bindtype] Fatal: bindtype 'columns' selected, you need to pass: [column_name => bind_value] at t/module_EndUserSupportTermsLookup.t line 26
# Tests were run but no plan was declared and done_testing() was not seen.

Thanks
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.scsys.co.uk/pipermail/dbix-class/attachments/20130507/38787e2a/attachment.htm


More information about the DBIx-Class mailing list