Re^2: DBI with SQLite vs DBIX::Class search failing

[poj]

Your code works fine for me but I was able to recreate your fault by creating ddi as a text field in api.db and entering the value with a trailing space '441224900999 '. Maybe check your SQLite file definitions match the Schema file

HTH
poj

[ghenry]

In #dbix-class chat it was pointed out:

<ilmari> the DBIC one ins showing bind_param(1, 441224900999, ...), wh
+ile the plain DBI one shows bind_param(1, 441224900999)
<ilmari> DBIC binds integer columns as SQL_BIGINT

I'm going to switch to Test::Postgresql58 to match our prod Dbs. Thanks all!