DBD::DBM in C:/cpanrun/build/5-10-0/lib is hidden by DBD::DBM in C:/cpanrun/build/5-10-0/site/lib at Makefile.PL line 104 DBD::ExampleP in C:/cpanrun/build/5-10-0/lib is hidden by DBD::ExampleP in C:/cpanrun/build/5-10-0/site/lib at Makefile.PL line 104 DBD::File in C:/cpanrun/build/5-10-0/lib is hidden by DBD::File in C:/cpanrun/build/5-10-0/site/lib at Makefile.PL line 104 DBD::Gofer in C:/cpanrun/build/5-10-0/lib is hidden by DBD::Gofer in C:/cpanrun/build/5-10-0/site/lib at Makefile.PL line 104 DBD::Proxy in C:/cpanrun/build/5-10-0/lib is hidden by DBD::Proxy in C:/cpanrun/build/5-10-0/site/lib at Makefile.PL line 104 DBD::Sponge in C:/cpanrun/build/5-10-0/lib is hidden by DBD::Sponge in C:/cpanrun/build/5-10-0/site/lib at Makefile.PL line 104 Found DBI version 1.602 Found the following DBD drivers: 1.) AnyData 2.) DBM 3.) Gofer 4.) Mimer 5.) Mock 6.) Multiplex 7.) SQLite For running tests it's necessary to have an existing datasource for each DBD driver against which DBIx::Recordset should be tested. For most drivers, DROP DATABASE TEST; CREATE DATABASE TEST is adequate. For SQLite, it is recommended to do the following: cd $DIST; cat > test.db to create an empty database. $DIST is the root directory of the Recordset distribution. Please enter a valid datasource (or accept the default) for each DBD driver or enter a '.' if you do not want to test DBIx::Recordset against this driver 1.) AnyData [dbi:AnyData:test] Username [undef]2.) DBM [dbi:DBM:test] Username [undef]3.) Gofer [dbi:Gofer:test] Username [undef]4.) Mimer [dbi:Mimer:test] Username [undef]5.) Mock [dbi:Mock:test] Username [undef]6.) Multiplex [dbi:Multiplex:test] Username [undef]7.) SQLite [dbi:SQLite:test.db] Username [undef] The tests will performed with the following parameters AnyData -> dbi:AnyData:test DBM -> dbi:DBM:test Gofer -> dbi:Gofer:test Mimer -> dbi:Mimer:test Mock -> dbi:Mock:test Multiplex -> dbi:Multiplex:test SQLite -> dbi:SQLite:test.db In every of the above datasources the tables dbixrs1, dbixrs2, dbixrs3, dbixrs4 will be created and dropped afterwards. Please make sure the datasources exist *before* you run make test. Checking if your kit is complete... Looks good Writing Makefile for DBIx::Recordset Microsoft (R) Program Maintenance Utility Version 6.00.8168.0 Copyright (C) Microsoft Corp 1988-1998. All rights reserved. cp Intrors.pod blib\lib\DBIx\Intrors.pod cp Recordset/FileSeq.pm blib\lib\DBIx\Recordset\FileSeq.pm cp Recordset/DBSeq.pm blib\lib\DBIx\Recordset\DBSeq.pm cp Compat.pm blib\lib\DBIx\Compat.pm cp Database.pm blib\lib\DBIx\Database.pm cp Recordset.pm blib\lib\DBIx\Recordset.pm Microsoft (R) Program Maintenance Utility Version 6.00.8168.0 Copyright (C) Microsoft Corp 1988-1998. All rights reserved. C:\cpanrun\build\5-10-0\bin\perl.exe "-Iblib\lib" "-Iblib\arch" test.pl Loading... ok Using the following parameters for testing: DBD-Driver: AnyData Database: dbi:AnyData:test User: Password: Table: dbixrs1 Table: dbixrs2 Table: dbixrs3 Table: dbixrs4 Table: dbix_rs5 Table: dbix_rs6 Table: dbixseq Table: dbixrsdel DBI-Version: 1.602 DBD-Version: 0.09 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... ok Select multiply fields & values... ok MoreRecords yes... ok Search... ok Search... ok MoreRecords no... ok Search with subexpr... ok Search first two... ok MoreRecords with $max... ok MoreRecords(1) with $max ... ok MoreRecords with $max 2... ok New Search for more... ok MoreRecords(1) with $max no... ok New Search for more 2... ok MoreRecords(1) with $max no 2... ok Search next ones... ok Search prevs one... ok Search last ones... ok Search goto last... ok Select NULL values... ok Select NOT NULL values... ok Select empty values... ERROR in Select empty values Got too many rows (got 6, expected 1) Select 0... ok Select NULL values Ig-1... ok Select empty values Ig-1... ERROR in Select empty values Ig-1 Got too many rows (got 6, expected 1) Select 0 Ig-1... ok Select NULL values Ig-2... ok Select empty values Ig-2... ok Select 0 Ig-2... ok New Search... ok Search cont... ok Search $operator <... ok Search *id *name... ok Search $conj or... ok Search multfield *... ok Search $compconj... ERROR in Search $compconj Got too few rows (got 6, expected 7) Order, Group, Append... ok Search with JOIN... ERROR in Search with JOIN Got too few rows (got 1, expected 2) New Search id_typ... ok !LongNames with !Fields... ok !LongNames without !Fields... ok New Setup... ok SQLInsert... ok New Insert... ok Insert without quoting... ok Update... ok Update without quoting... ok Update to NULL... ok New Update... ok New Delete... ok New Execute Search (default)... ok Execute =search... ok Execute =insert... ok Execute =update... ok Execute =insert... ok Execute =delete... ok DeleteWithLinks... ok - 2 ... ok Array Update/Insert... ok - 2 ... ok - 3 ... ok Array Update/Insert -> Flush... ok Dirty... ok - 2 ... ok Array Update/Insert -> Flush 2... ok Array Insert Hashref... ok Array Add Record... ok Array Add Empty Record (Ndx)... ok Array Add Empty Record (CurrRec)... ok Select id (Hash)... ok Select name (Hash)... ok Iterate over ::Hash... ok - 2 ... ok - 3 ... ok - 4 ... ok - 5 ... ok - 6 ... ok - 7 ... ok Select name (PreFetch Hash)... ok Iterate over ::Hash PreFetch... ok - 2 ... ok - 3 ... ok - 4 ... ok - 5 ... ok - 6 ... ok PreFetch Hash with merge... ok Hash with merge... ok Select id (HashAsRowKey)... ok Select name (Hash) with setup... ok Modify Hash... ok Add To Hash... ok Add Hashref To Hash ... ok Modify PrimKey in Hash... ok Add undef as PrimKey to Hash... ok - 2 ... ok Test Syntax error... ERROR in Test Syntax error: LastError should return error message Test error within setup... ERROR in Test error within setup: LastError should return error message MoreRecords on empty set... ok First on empty set... ok Next on empty set... ok Use First to get first record... ok Use First/Next to get all records... ok Use Next to get all records... ok Use Reset/Next to get all records... ok Update via assigning array ref... ok - 2 ... ok Update via assigning array ref 2... ok - 2 ... ok Select with sub table... ok - 2 ... ok Modify sub table... ok - 2 ... ok Add with sub table... ok - 2 ... ok Select sub table NULL... ok - 2 ... ok Select with linked name mode 1... ERROR in Select with linked name mode 1 Got too few rows (got 0, expected 3) Select with linked name hash access... ok Select with linked names mode 1... ERROR in Select with linked names mode 1 Got too few rows (got 0, expected 3) Select with linked name mode 2... ERROR in Select with linked name mode 2 Got too few rows (got 0, expected 1) - 2 ... ERROR in Select with linked name mode 2 Field ID Is = Should = 4567 Select with linked names mode 2... ERROR in Select with linked names mode 2 Got too few rows (got 0, expected 1) - 2 ... ERROR in Select with linked names mode 2 Field ID Is = Should = Sixth Name in Tab2 6666 Select with linked name mode 3... ERROR in Select with linked name mode 3 Got too few rows (got 0, expected 1) - 2 ... ERROR in Select with linked name mode 3 Field id Is = Should = 4567 Select with linked names mode 3... ERROR in Select with linked names mode 3 Got too few rows (got 0, expected 1) - 2 ... ERROR in Select with linked names mode 3 Field id Is = Should = Sixth Name in Tab2 6666 Delete from hash... ok Clear hash disabled... ok - 2 ... ok Clear hash... ERROR in Clear hash Got too many rows (got 14, expected 0) Assign hash... ERROR in Assign hash Got too many rows (got 27, expected 2) Input Filter... ok Output Filter... ok look for 4455... ok I/O Filter on type... ERROR in I/O Filter on type Got too few rows (got 0, expected 1) DBIx::Database setup... ok DBIx::Database and I/O Filter... ERROR in DBIx::Database and I/O Filter Got too few rows (got 0, expected 1) Attributes... ok - 2 ... ok DBIx::Database !TableFilter... ok DBIx::Recordset::FileSeq... ok DBIx::Recordset::FileSeq 2... ok 20 Errors detected for driver AnyData Using the following parameters for testing: DBD-Driver: DBM Database: dbi:DBM:test User: Password: Table: dbixrs1 Table: dbixrs2 Table: dbixrs3 Table: dbixrs4 Table: dbix_rs5 Table: dbix_rs6 Table: dbixseq Table: dbixrsdel DBI-Version: 1.602 DBD-Version: 0.03 Creating the testtables... ok Setup Object for dbixrs1... ok SQLSelect All... ERROR in SQLSelect All id = 11 The field named addon has value NULL When it should have value it ok? Setup Object for dbixrs2... ok SQLSelect All... ERROR in SQLSelect All id = 4 The field named dbixrs4_id has value NULL When it should have value 4 Setup Object for dbixrs1, dbixrs2... ok SQLSelect All... ERROR in SQLSelect All Got too few rows (got 0, expected 4) Setup Object for dbixrs1, dbixrs3... ok SQLSelect All... ERROR in SQLSelect All Got too few rows (got 0, expected 12) Setup Object for dbixrs1, dbixrs4... ok SQLSelect All... ERROR in SQLSelect All Got too few rows (got 0, expected 8) Setup Object for dbixrs1... ok Select id (where as hash)... ERROR in Select id (where as hash) id = 2 The field named addon has value NULL When it should have value it Select id (where as string)... ERROR in Select id (where as string) id = 4 The field named addon has value NULL When it should have value Or not?? Select name... ERROR in Select name id = 3 The field named addon has value NULL When it should have value it ok? Select dbixrs1.name... ERROR in Select dbixrs1.name id = 4 The field named addon has value NULL When it should have value Or not?? Select dbixrs2.name2 id=id... ERROR in Select dbixrs2.name2 id=id Got too few rows (got 0, expected 1) Select dbixrs2.value2 id=id... ERROR in Select dbixrs2.value2 id=id Got too few rows (got 0, expected 1) Select multiply values... ERROR in Select multiply values id = 1 The field named addon has value NULL When it should have value Is Select multiply values array ref... ERROR in Select multiply values array ref id = 2 The field named addon has value NULL When it should have value it Select multiply values & operators... ERROR in Select multiply values & operators id = 5 The field named addon has value NULL When it should have value Is Select $valuesplit... ERROR in Select $valuesplit Got too few rows (got 0, expected 3) Select multiply fields 1... ERROR in Select multiply fields 1 Got too few rows (got 0, expected 1) Select multiply fields 2... ERROR in Select multiply fields 2 id = 15 The field named value1 has value NULL When it should have value 15 Select multiply fields & values... ERROR in Select multiply fields & values Got too few rows (got 3, expected 4) MoreRecords yes... ERROR in MoreRecords yes: MoreRecords returns false Search... ERROR in Search Got too few rows (got 0, expected 1) Search... ERROR in Search Got too few rows (got 0, expected 1) MoreRecords no... ok Search with subexpr... ERROR in Search with subexpr id = 3 The field named addon has value NULL When it should have value it ok? Search first two... ERROR in Search first two id = 1 The field named addon has value NULL When it should have value Is MoreRecords with $max... ERROR in MoreRecords with $max: MoreRecords returns true MoreRecords(1) with $max ... ok MoreRecords with $max 2... ERROR in MoreRecords with $max 2: MoreRecords returns true New Search for more... ERROR in New Search for more Got too few rows (got 0, expected 2) MoreRecords(1) with $max no... ok New Search for more 2... ERROR in New Search for more 2 Got too few rows (got 0, expected 2) MoreRecords(1) with $max no 2... ok Search next ones... ERROR in Search next ones id = 3 The field named addon has value NULL When it should have value it ok? Search prevs one... ERROR in Search prevs one id = 2 The field named addon has value NULL When it should have value it Search last ones... ERROR in Search last ones id = 11 The field named addon has value NULL When it should have value it ok? Search goto last... ERROR in Search goto last id = 16 The field named value1 has value NULL When it should have value 15 Select NULL values... ERROR in Select NULL values Got too many rows (got 20, expected 1) Select NOT NULL values... ERROR in Select NOT NULL values Got too few rows (got 0, expected 19) Select empty values... ERROR in Select empty values Got too many rows (got 20, expected 1) Select 0... ERROR in Select 0 Got too few rows (got 0, expected 1) Select NULL values Ig-1... ERROR in Select NULL values Ig-1 id = 11 The field named addon has value NULL When it should have value it ok? Select empty values Ig-1... ERROR in Select empty values Ig-1 Got too many rows (got 20, expected 1) Select 0 Ig-1... ERROR in Select 0 Ig-1 Got too few rows (got 0, expected 1) Select NULL values Ig-2... ERROR in Select NULL values Ig-2 id = 11 The field named addon has value NULL When it should have value it ok? Select empty values Ig-2... ERROR in Select empty values Ig-2 id = 11 The field named addon has value NULL When it should have value it ok? Select 0 Ig-2... ERROR in Select 0 Ig-2 Got too few rows (got 0, expected 1) New Search... ERROR in New Search Got too few rows (got 0, expected 2) Search cont... ERROR in Search cont Got too few rows (got 0, expected 1) Search $operator <... ERROR in Search $operator < Got too few rows (got 0, expected 2) Search *id *name... ERROR in Search *id *name Got too few rows (got 0, expected 2) Search $conj or... ERROR in Search $conj or Got too few rows (got 0, expected 2) Search multfield *... ERROR in Search multfield * Got too few rows (got 0, expected 11) Search $compconj... ERROR in Search $compconj Got too few rows (got 0, expected 7) Order, Group, Append... ok Search with JOIN... ERROR in Search with JOIN Got too few rows (got 1, expected 2) New Search id_typ... ERROR in New Search id_typ Got too few rows (got 0, expected 8) !LongNames with !Fields... ok !LongNames without !Fields... ok New Setup... ok SQLInsert... ERROR in SQLInsert id = 1 The field named dbixrs4_id has value NULL When it should have value 1 New Insert... ERROR in New Insert id = 22 The field named value2 has value NULL When it should have value 1022 Insert without quoting... ERROR in Insert without quoting id = 22 The field named value2 has value NULL When it should have value 1022 Update... ERROR in Update id = 22 The field named value2 has value NULL When it should have value 2022 Update without quoting... ERROR in Update without quoting id = 22 The field named value2 has value NULL When it should have value 2022 Update to NULL... ERROR in Update to NULL id = 22 The field named value2 has value NULL When it should have value 2022 New Update... ERROR in New Update id = 22 The field named value2 has value NULL When it should have value 2022 New Delete... ERROR in New Delete id = 22 The field named value2 has value NULL When it should have value 2022 New Execute Search (default)... ERROR in New Execute Search (default) id = 1 The field named dbixrs4_id has value NULL When it should have value 1 Execute =search... ERROR in Execute =search id = 4 The field named addon has value NULL When it should have value Or not?? Execute =insert... ERROR in Execute =insert id = 22 The field named value2 has value NULL When it should have value 2022 Execute =update... ERROR in Execute =update id = 22 The field named value2 has value NULL When it should have value 2022 Execute =insert... ERROR in Execute =insert id = 32 The field named value2 has value NULL When it should have value 3032 Execute =delete... ERROR in Execute =delete id = 22 The field named value2 has value NULL When it should have value 2022 DeleteWithLinks... ok - 2 ... ok Array Update/Insert... ERROR in Array Update/Insert id = 1 The field named addon has value NULL When it should have value Is - 2 ... ERROR in Array Update/Insert id = 4 The field named addon has value NULL When it should have value Or not?? - 3 ... ok Array Update/Insert -> Flush... ok Dirty... ok - 2 ... ok Array Update/Insert -> Flush 2... ok Array Insert Hashref... ok Array Add Record... ok Array Add Empty Record (Ndx)... ok Array Add Empty Record (CurrRec)... ok Select id (Hash)... ERROR in Select id (Hash) id = 2 The field named dbixrs4_id has value NULL When it should have value 2 Select name (Hash)... ERROR in Select name (Hash) id = 3 The field named dbixrs4_id has value NULL When it should have value 3 Iterate over ::Hash... ERROR in Iterate over ::Hash id = 1 The field named dbixrs4_id has value NULL When it should have value 1 - 2 ... ERROR in Iterate over ::Hash id = 2 The field named dbixrs4_id has value NULL When it should have value 2 - 3 ... ERROR in Iterate over ::Hash id = 3 The field named dbixrs4_id has value NULL When it should have value 3 - 4 ... ERROR in Iterate over ::Hash id = 4 The field named dbixrs4_id has value NULL When it should have value 4 - 5 ... ERROR in Iterate over ::Hash id = 22 The field named value2 has value NULL When it should have value 2022 - 6 ... ok - 7 ... ERROR in Iterate over ::Hash id = 31 The field named value2 has value NULL When it should have value 3031 Select name (PreFetch Hash)... ERROR in Select name (PreFetch Hash) id = 2 The field named addon has value NULL When it should have value it Iterate over ::Hash PreFetch... ERROR in Iterate over ::Hash PreFetch id = 6 The field named addon has value NULL When it should have value it - 2 ... ERROR in Iterate over ::Hash PreFetch id = 4 The field named addon has value NULL When it should have value Or not?? - 3 ... ERROR in Iterate over ::Hash PreFetch id = 1 The field named addon has value NULL When it should have value Is - 4 ... ERROR in Iterate over ::Hash PreFetch id = 3 The field named addon has value NULL When it should have value it ok? - 5 ... ERROR in Iterate over ::Hash PreFetch id = 2 The field named addon has value NULL When it should have value it - 6 ... ERROR in Iterate over ::Hash PreFetch id = 5 The field named addon has value NULL When it should have value Is PreFetch Hash with merge... ERROR in PreFetch Hash with merge Field = typ Is = First item Type 3 Should = First item Type 1 , First item Type 2 , First item Type 3 ERROR in PreFetch Hash with merge Field = typ Is = Second item Type 4 Should = Second item Type 1 , Second item Type 2 , Second item Type 3 , Second item Type 4 Hash with merge... ERROR in Hash with merge Field = typ Is = First item Type 3 Should = First item Type 1 , First item Type 2 , First item Type 3 ERROR in Hash with merge Field = typ Is = Second item Type 4 Should = Second item Type 1 , Second item Type 2 , Second item Type 3 , Second item Type 4 Select id (HashAsRowKey)... ERROR in Select id (HashAsRowKey) id = 3 The field named dbixrs4_id has value NULL When it should have value 3 Select name (Hash) with setup... ERROR in Select name (Hash) with setup id = 4 The field named dbixrs4_id has value NULL When it should have value 4 Modify Hash... ERROR in Modify Hash id = 4 The field named dbixrs4_id has value NULL When it should have value 4 Add To Hash... ERROR in Add To Hash id = 5 The field named value2 has value NULL When it should have value 5555 Add Hashref To Hash ... ERROR in Add Hashref To Hash id = 6 The field named value2 has value NULL When it should have value 6666 Modify PrimKey in Hash... ERROR in Modify PrimKey in Hash id = 4 The field named dbixrs4_id has value NULL When it should have value 4 Add undef as PrimKey to Hash... ERROR in Add undef as PrimKey to Hash id = 531 The field named name2 has value When it should have value NULL - 2 ... ERROR in Add undef as PrimKey to Hash id = 6 The field named value2 has value NULL When it should have value 6666 Test Syntax error... ERROR in Test Syntax error: LastError should return error message Test error within setup... ERROR in Test error within setup: LastError should return error message MoreRecords on empty set... ERROR in MoreRecords on empty set: MoreRecords returns true First on empty set... ERROR in First on empty set: First returns true Next on empty set... ERROR in Next on empty set: Next returns true Use First to get first record... ERROR in Use First to get first record id = 2 The field named dbixrs4_id has value NULL When it should have value 2 Use First/Next to get all records... ERROR in Use First/Next to get all records id = 6 The field named value2 has value NULL When it should have value 6666 Use Next to get all records... ERROR in Use Next to get all records id = 6 The field named value2 has value NULL When it should have value 6666 Use Reset/Next to get all records... ERROR in Use Reset/Next to get all records id = 6 The field named value2 has value NULL When it should have value 6666 Update via assigning array ref... ERROR in Update via assigning array ref id = 6 The field named value2 has value NULL When it should have value 6666 - 2 ... ERROR in Update via assigning array ref id = 6 The field named value2 has value NULL When it should have value 6666 Update via assigning array ref 2... ERROR in Update via assigning array ref 2 Got too many rows (got 1, expected 0) - 2 ... ERROR in Update via assigning array ref 2 Got too few rows (got 1, expected 4) Select with sub table... ERROR in Select with sub table id = 2 The field named addon has value NULL When it should have value it - 2 ... ERROR in Select with sub table Got too few rows (got 1, expected 4) Modify sub table... ERROR in Modify sub table id = 2 The field named addon has value NULL When it should have value it - 2 ... ERROR in Modify sub table Got too few rows (got 1, expected 4) Add with sub table... ERROR in Add with sub table id = 9988 The field named name has value When it should have value NULL - 2 ... ERROR in Add with sub table typ = Typ for 9988 The field named id has value NULL When it should have value 9988 Select sub table NULL... ok - 2 ... ok Select with linked name mode 1... ERROR in Select with linked name mode 1 Got too few rows (got 0, expected 3) Select with linked name hash access... ERROR in Select with linked name hash access Select with linked names mode 1... ERROR in Select with linked names mode 1 Got too few rows (got 0, expected 3) Select with linked name mode 2... ERROR in Select with linked name mode 2 Got too few rows (got 0, expected 1) - 2 ... ERROR in Select with linked name mode 2 Field ID Is = Should = 4567 Select with linked names mode 2... ERROR in Select with linked names mode 2 Got too few rows (got 0, expected 1) - 2 ... ERROR in Select with linked names mode 2 Field ID Is = Should = Sixth Name in Tab2 6666 Select with linked name mode 3... ERROR in Select with linked name mode 3 Got too few rows (got 0, expected 1) - 2 ... ERROR in Select with linked name mode 3 Field id Is = Should = 4567 Select with linked names mode 3... ERROR in Select with linked names mode 3 Got too few rows (got 0, expected 1) - 2 ... ERROR in Select with linked names mode 3 Field id Is = Should = Sixth Name in Tab2 6666 Delete from hash... ERROR in Delete from hash Got too few rows (got 14, expected 15) Clear hash disabled... ok - 2 ... ERROR in Clear hash disabled Got too few rows (got 14, expected 15) Clear hash... ERROR in Clear hash Got too many rows (got 7, expected 0) Assign hash... ERROR in Assign hash Got too many rows (got 15, expected 2) Input Filter... ok Output Filter... ok look for 4455... ok I/O Filter on type... ERROR in I/O Filter on type Got too few rows (got 0, expected 1) DBIx::Database setup... ERROR in DBIx::Database setup: table dbixrs1 not found Test terminated with fatal error! Look at test.log NMAKE : fatal error U1077: 'C:\cpanrun\build\5-10-0\bin\perl.exe' : return code '0x2' Stop.