DBIx-Recordset - make test fail with dbi:Pg

Posted on Sun Feb 24 07:46:09 2008 by james243
make test fail with dbi:Pg
Hi, make test keeps failing with the following error msg (test.log is included
at the bottom also):


Select name... ERROR in Select name
Got too few rows (got 0, expected 1)
Select dbixrs1.name... ERROR in Select dbixrs1.name
Got too few rows (got 0, expected 1)


Using Version:
==============
DBI -- 1.602
DBD::Pg -- 2.1.3
PostgreSQL 8.3
DBIx-Recordset 0.26


test.log:
=========
3012 DB: SelectWhere <name>=<Third Name> type = n 3013 DB: Single Field name 3014 DB: Single Field gives name = ? 3015 DB: Key name gives (name = ?) bind_values = <Third Name> bind_types=<1> 3016 DB: expr is ( (name = ?)) 3017 DB: SelectWhere <$operator>=<=> type = $ 3018 DB: FLUSH Recordset id = 6 DBIx::Recordset=HASH(0x86874c4) 3019 DB: Row::DESTROY 3020 DB: 'SELECT * FROM dbixrs1 WHERE ( (name = ?)) ' bind_values=<Third Name> bind_types=< +1> 3021 IDS EXPECTED: 3 3022 DB: FETCH [0] 3023 DB: Call DBI finish (id=6, Last = SELECT * FROM dbixrs1 WHERE ( (name = ?)) ) 3024 DB: FETCH return <undef> 3025 DB: FETCH [0] 3026 DB: FETCH return <undef> 3027 ERROR in Select name 3028 Got too few rows (got 0, expected 1) 3029 Select dbixrs1.name... 3030 -------------------- 3031 DB: SelectWhere <dbixrs1.name>=<Fourth Name> type = d 3032 DB: Single Field dbixrs1.name 3033 DB: Single Field gives dbixrs1.name = ? 3034 DB: Key dbixrs1.name gives (dbixrs1.name = ?) bind_values = <Fourth Name> bind_types=<1> 3035 DB: expr is ( (dbixrs1.name = ?)) 3036 DB: SelectWhere <$operator>=<=> type = $ 3037 DB: FLUSH Recordset id = 6 DBIx::Recordset=HASH(0x86874c4) 3038 DB: 'SELECT * FROM dbixrs1 WHERE ( (dbixrs1.name = ?)) ' bind_values=<Fourth Name> bin +d_types=<1> 3039 IDS EXPECTED: 4 3040 DB: FETCH [0] 3041 DB: Call DBI finish (id=6, Last = SELECT * FROM dbixrs1 WHERE ( (dbixrs1.name = ?)) ) 3042 DB: FETCH return <undef> 3043 DB: FETCH [0] 3044 DB: FETCH return <undef> 3045 ERROR in Select dbixrs1.name 3046 Got too few rows (got 0, expected 1) 3047 Select dbixrs2.name2 id=id... -------------------- 3220 DB: SelectWhere <name>=<Second Name First Name> type = n 3221 DB: Single Field name 3222 DB: Single Field gives name = ? 3223 DB: Key name gives name IN (?,?) bind_values = <Second Name First Name> bind_types=<1 1> 3224 DB: expr is (name IN (?,?)) 3225 DB: SelectWhere <$operator>=<=> type = $ 3226 DB: FLUSH Recordset id = 6 DBIx::Recordset=HASH(0x86874c4) 3227 DB: 'SELECT * FROM dbixrs1 WHERE (name IN (?,?)) ' bind_values=<Second Name First Name> + bind_types=<1 1> 3228 WARN: DBD::Pg::st execute failed: ERROR: IN could not convert type "char" to character 3229 3230 DB: ERROR ERROR: IN could not convert type "char" to character 3231 3232 not ok (ERROR: IN could not convert type "char" to character 3233 ) at test.pl line 884. 3234 DB: FLUSH Recordset id = 6 DBIx::Recordset=HASH(0x86874c4) 3235 DB: ::CurrRow::DESTROY 3236 DB: FLUSH Recordset id = 6 DBIx::Recordset=HASH(0x86874c4) 3237 DB: Disconnect (id=6, numOpen = 0) 3238 DB: DESTROY (id=6, numOpen = 0)


Thanks.
James
Write a response