Hi Darin, thanks for the bug report. I am guessing that the DBD::CSV driver is limited in functionality and cannot parse certain complex SQL queries. I am very busy at the moment. Unless you need DBD::CSV you might want to skip the tests for this driver by typing ".".

I know the test suite works for SQLite, MySQL and Postgres. Anything besides that I don't have access to and therefore cannot test.

I guess I could try DBD::CSV but it is not high on my list of priorities.

It might be better if someone took over Recordset from me as I am rather busy.

Since the readme says:

If you don't get make test to work for you, please send me the file
test.log (Normaly it should be enought to send the part for the test,
that fails) along with the versions of DBI and the DBD driver you are using.

Here's the part that fails:

Select $valuesplit... --------------------
DB: SelectWhere <value1>=<9991 9992 9993> type = v
DB: Single Field value1
DB: Single Field gives value1 = ?
DB: Key value1 gives (value1 = ?) or (value1 = ?) or (value1 = ?) bind_values = <9991 9992 9993> bind_types=<12 12 12>
DB: expr is ( (value1 = ?) or (value1 = ?) or (value1 = ?))
DB: SelectWhere <$operator>=<=> type = $
DB: SelectWhere <$valuesplit>=< |\t> type = $
DB: FLUSH Recordset id = 3 DBIx::Recordset=HASH(0x831ef54) DB: Row::DESTROY
DB: Row::DESTROY
DB: Row::DESTROY
DB: 'SELECT * FROM dbixrs1 WHERE ( (value1 = ?) or (value1 = ?) or (value1 = ?)) ' bind_values=<9991 9992 9993> bind_types=<12 12 12>
WARN: SQL ERROR: Bad predicate: '^1^'!



WARN: SQL ERROR: Couldn't find predicate!



SV = PVIV(0x86d7cc8) at 0x8604d80
REFCNT = 1
FLAGS = (PADBUSY,PADMY,ROK)
IV = 0
RV = 0x831ff14
PV = 0x831ff14 ""
CUR = 0
LEN = 0
WARN: DBD::CSV::st execute failed: dbih_getcom handle DBD::CSV::Statement=HASH(0x831ff14) is not a DBI handle (has no magic) at /share/perl5/lib/site_perl/5.8.3/SQL/Statement.pm line 164.


DB: ERROR dbih_getcom handle DBD::CSV::Statement=HASH(0x831ff14) is not a DBI handle (has no magic) at /share/perl5/lib/site_perl/5.8.3/SQL/Statement.pm line 164.

not ok (dbih_getcom handle DBD::CSV::Statement=HASH(0x831ff14) is not a DBI handle (has no magic) at /share/perl5/lib/site_perl/5.8.3/SQL/Statement.pm line 164.
) at test.pl line 920.
DB: FLUSH Recordset id = 3 DBIx::Recordset=HASH(0x831ef54) DB: ::CurrRow::DESTROY
DB: FLUSH Recordset id = 3 DBIx::Recordset=HASH(0x831ef54) DB: Disconnect (id=3, numOpen = 0)
DB: DESTROY (id=3, numOpen = 0)



DBI version: 1.41 DBD::CSV version: 0.2002 DBD::File version: 0.2001 Perl: 5.8.3 OS: Linux 2.4.21-4.EL i686

I also have DBD::DB2 installed, but did not choose to test against
that.








---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



Reply via email to