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

in reply to Re: DBI with SQLite vs DBIX::Class search failing
in thread DBI with SQLite vs DBIX::Class search failing

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

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

Replies are listed 'Best First'.
Re^3: DBI with SQLite vs DBIX::Class search failing by ghenry (Vicar) on Oct 23, 2019 at 16:13 UTC
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` [download] I'm going to switch to Test::Postgresql58 to match our prod Dbs. Thanks all!	[reply] [d/l]

In Section Seekers of Perl Wisdom