Has anyone else run into this problem? I understand why it's happneing (I think), I just can't figure why no-one else has reported it and/or it hasn't already been fixed... maybe I'm missing something obvious; if so please enlighten me.
It looks like pg_atoi trying to parse a string as a number and failing miserably, as it's supposed to, I gather. The question is, how to make the tests work with this new(?) behavior of pg_aoti or DBD::Pg. It worked in the somewhat distant past, I think - or it may have been when I was still on Oracle. Anyway, I've been using the module for over a year now without any real problems, but it's the one module I haven't been able to get a clean test from, and it's bugging me. :) Any help or advice is greatly appreciated. Thanks, Jim make test output (trimmed a bit) ----------------------------------- DBI-Version: 1.35 DBD-Version: 1.21 Creating the testtables... ok Setup Object for dbixrs1... ok SQLSelect All... ok Setup Object for dbixrs2... ok SQLSelect All... ok Setup Object for dbixrs1, dbixrs2... ok SQLSelect All... ok Setup Object for dbixrs1, dbixrs3... ok SQLSelect All... ok Setup Object for dbixrs1, dbixrs4... ok SQLSelect All... ok Setup Object for dbixrs1... ok Select id (where as hash)... ok Select id (where as string)... ok Select name... ok Select dbixrs1.name... ok Select dbixrs2.name2 id=id... ok Select dbixrs2.value2 id=id... ok Select multiply values... ok Select multiply values array ref... ok Select multiply values & operators... ok Select $valuesplit... ok Select multiply fields 1... ok Select multiply fields 2... Test terminated with fatal error! Look at test.log *** Error code 2 make: Fatal error: Command failed for target `test_dynamic' ------------------------------- test.log section with errors ------------------------------- Select multiply fields 2... -------------------- DB: SelectWhere <+name&value1>=<Third Name> type = + DB: Composite Field +name&value1 DB: Composite Field processing name DB: Composite Field get name = ? DB: Composite Field processing value1 DB: Composite Field get name = ? or value1 = ? DB: Key +name&value1 gives ( name = ? or value1 = ?) bind_values = <Third Name Third Name> bind_types=<1 4> DB: expr is ( ( name = ? or value1 = ?)) DB: SelectWhere <$operator>=<=> type = $ DB: FLUSH Recordset id = 6 DBIx::Recordset=HASH(0x537fb0) DB: Row::DESTROY DB: 'SELECT * FROM dbixrs1 WHERE ( ( name = ? or value1 = ?)) ' bind_values=<Third Name Third Name> bind_types=<1 4> WARN: DBD::Pg::st execute failed: ERROR: pg_atoi: error in "Third Name": can't parse "Third Name" at blib/lib/DBIx/Recordset.pm line 1360. DB: ERROR ERROR: pg_atoi: error in "Third Name": can't parse "Third Name" not ok (ERROR: pg_atoi: error in "Third Name": can't parse "Third Name") at test.pl line 924.
