Start 2009-04-24T06:12:39 ActivePerl-1003 CPAN-1.9351 Going to read '/home/cpanfly/var/cpan/Metadata' Database was generated on Fri, 24 Apr 2009 11:27:03 GMT Running make for A/AD/ADAMK/DBD-SQLite-1.25.tar.gz Checksum for /net/nas/data/cpan/authors/id/A/AD/ADAMK/DBD-SQLite-1.25.tar.gz ok DBD-SQLite-1.25/ DBD-SQLite-1.25/META.yml DBD-SQLite-1.25/Makefile.PL DBD-SQLite-1.25/util/ DBD-SQLite-1.25/util/getsqlite.pl DBD-SQLite-1.25/SQLite.xs DBD-SQLite-1.25/dbdimp.h DBD-SQLite-1.25/LICENSE DBD-SQLite-1.25/README DBD-SQLite-1.25/ppport.h DBD-SQLite-1.25/sqlite3ext.h DBD-SQLite-1.25/lib/ DBD-SQLite-1.25/lib/DBD/ DBD-SQLite-1.25/lib/DBD/SQLite.pm DBD-SQLite-1.25/lib/DBD/SQLite/ DBD-SQLite-1.25/lib/DBD/SQLite/Cookbook.pod DBD-SQLite-1.25/SQLiteXS.h DBD-SQLite-1.25/sqlite3.c DBD-SQLite-1.25/inc/ DBD-SQLite-1.25/inc/Test/ DBD-SQLite-1.25/inc/Test/NoWarnings/ DBD-SQLite-1.25/inc/Test/NoWarnings/Warning.pm DBD-SQLite-1.25/inc/Test/NoWarnings.pm DBD-SQLite-1.25/dbdimp.c DBD-SQLite-1.25/MANIFEST DBD-SQLite-1.25/Changes DBD-SQLite-1.25/sqlite3.h DBD-SQLite-1.25/t/ DBD-SQLite-1.25/t/rt_25924_user_defined_func_unicode.t DBD-SQLite-1.25/t/07_error.t DBD-SQLite-1.25/t/13_create_collation.t DBD-SQLite-1.25/t/rt_40594_nullable.t DBD-SQLite-1.25/t/28_schemachange.t DBD-SQLite-1.25/t/21_blobtext.t DBD-SQLite-1.25/t/12_unicode.t DBD-SQLite-1.25/t/rt_31324_full_names.t DBD-SQLite-1.25/t/32_inactive_error.t DBD-SQLite-1.25/t/rt_27553_prepared_cache_and_analyze.t DBD-SQLite-1.25/t/10_create_aggregate.t DBD-SQLite-1.25/t/rt_29058_group_by.t DBD-SQLite-1.25/t/09_create_function.t DBD-SQLite-1.25/t/rt_36836_duplicate_key.t DBD-SQLite-1.25/t/08_busy.t DBD-SQLite-1.25/t/98_pod.t DBD-SQLite-1.25/t/02_logon.t DBD-SQLite-1.25/t/16_column_info.t DBD-SQLite-1.25/t/33_non_latin_path.t DBD-SQLite-1.25/t/rt_25371_asymmetric_unicode.t DBD-SQLite-1.25/t/17_createdrop.t DBD-SQLite-1.25/t/31_bind_weird_number_param.t DBD-SQLite-1.25/t/99_pmv.t DBD-SQLite-1.25/t/rt_29629_sqlite_where_length.t DBD-SQLite-1.25/t/rt_36838_unique_and_bus_error.t DBD-SQLite-1.25/t/26_commit.t DBD-SQLite-1.25/t/04_insert.t DBD-SQLite-1.25/t/05_select.t DBD-SQLite-1.25/t/24_numrows.t DBD-SQLite-1.25/t/18_insertfetch.t DBD-SQLite-1.25/t/rt_32889_prepare_cached_reexecute.t DBD-SQLite-1.25/t/22_listfields.t DBD-SQLite-1.25/t/19_bindparam.t DBD-SQLite-1.25/t/rt_25460_numeric_aggregate.t DBD-SQLite-1.25/t/14_progress_handler.t DBD-SQLite-1.25/t/30_auto_rollback.t DBD-SQLite-1.25/t/20_blobs.t DBD-SQLite-1.25/t/06_tran.t DBD-SQLite-1.25/t/lib/ DBD-SQLite-1.25/t/lib/Test.pm DBD-SQLite-1.25/t/03_create_table.t DBD-SQLite-1.25/t/25_chopblanks.t DBD-SQLite-1.25/t/27_metadata.t DBD-SQLite-1.25/t/97_meta.t DBD-SQLite-1.25/t/01_compile.t DBD-SQLite-1.25/t/rt_21406_auto_finish.t DBD-SQLite-1.25/t/29_cppcomments.t DBD-SQLite-1.25/t/rt_15186_prepcached.t DBD-SQLite-1.25/t/23_nulls.t DBD-SQLite-1.25/t/15_ak_dbd.t CPAN.pm: Going to build A/AD/ADAMK/DBD-SQLite-1.25.tar.gz >>> /home/cpanfly/ap1003/bin/perl-static Makefile.PL We're using the bundled sqlite library. Checking if your kit is complete... Looks good Multiple copies of Driver.xst found in: /home/cpanfly/var/megalib/auto/DBI/ /home/cpanfly/ap1003/lib/auto/DBI/ at Makefile.PL line 275 Using DBI 1.607 (for perl 5.010000 on i686-linux-thread-multi) installed in /home/cpanfly/var/megalib/auto/DBI/ Writing Makefile for DBD::SQLite >>> make cp lib/DBD/SQLite.pm blib/lib/DBD/SQLite.pm cp lib/DBD/SQLite/Cookbook.pod blib/lib/DBD/SQLite/Cookbook.pod /home/cpanfly/ap1003/bin/perl-static -p -e "s/~DRIVER~/SQLite/g" /home/cpanfly/var/megalib/auto/DBI/Driver.xst > SQLite.xsi /home/cpanfly/ap1003/bin/perl-static /home/cpanfly/var/megalib/ExtUtils/xsubpp -typemap /home/cpanfly/ap1003/lib/ExtUtils/typemap SQLite.xs > SQLite.xsc && mv SQLite.xsc SQLite.c gcc -c -I. -I/home/cpanfly/var/megalib/auto/DBI -D_REENTRANT -D_GNU_SOURCE -DTHREADS_HAVE_PIDS -DUSE_SITECUSTOMIZE -DPRIVLIB_LAST_IN_INC -fno-strict-aliasing -pipe -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O2 -DVERSION=\"1.25\" -DXS_VERSION=\"1.25\" -fPIC "-I/home/cpanfly/ap1003/lib/CORE" -DSQLITE_CORE -DSQLITE_ENABLE_FTS3 -DSQLITE_ENABLE_COLUMN_METADATA -DNDEBUG=1 -DSQLITE_PTR_SZ=4 -DHAVE_USLEEP=1 SQLite.c gcc -c -I. -I/home/cpanfly/var/megalib/auto/DBI -D_REENTRANT -D_GNU_SOURCE -DTHREADS_HAVE_PIDS -DUSE_SITECUSTOMIZE -DPRIVLIB_LAST_IN_INC -fno-strict-aliasing -pipe -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O2 -DVERSION=\"1.25\" -DXS_VERSION=\"1.25\" -fPIC "-I/home/cpanfly/ap1003/lib/CORE" -DSQLITE_CORE -DSQLITE_ENABLE_FTS3 -DSQLITE_ENABLE_COLUMN_METADATA -DNDEBUG=1 -DSQLITE_PTR_SZ=4 -DHAVE_USLEEP=1 dbdimp.c gcc -c -I. -I/home/cpanfly/var/megalib/auto/DBI -D_REENTRANT -D_GNU_SOURCE -DTHREADS_HAVE_PIDS -DUSE_SITECUSTOMIZE -DPRIVLIB_LAST_IN_INC -fno-strict-aliasing -pipe -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O2 -DVERSION=\"1.25\" -DXS_VERSION=\"1.25\" -fPIC "-I/home/cpanfly/ap1003/lib/CORE" -DSQLITE_CORE -DSQLITE_ENABLE_FTS3 -DSQLITE_ENABLE_COLUMN_METADATA -DNDEBUG=1 -DSQLITE_PTR_SZ=4 -DHAVE_USLEEP=1 sqlite3.c Running Mkbootstrap for DBD::SQLite () chmod 644 SQLite.bs rm -f blib/arch/auto/DBD/SQLite/SQLite.so gcc -shared -O2 SQLite.o dbdimp.o sqlite3.o -o blib/arch/auto/DBD/SQLite/SQLite.so \ \ chmod 755 blib/arch/auto/DBD/SQLite/SQLite.so cp SQLite.bs blib/arch/auto/DBD/SQLite/SQLite.bs chmod 644 blib/arch/auto/DBD/SQLite/SQLite.bs Manifying blib/man3/DBD::SQLite.3 Manifying blib/man3/DBD::SQLite::Cookbook.3 ADAMK/DBD-SQLite-1.25.tar.gz make -- OK Running make test >>> make test TEST_VERBOSE=1 PERL_DL_NONLAZY=1 /home/cpanfly/ap1003/bin/perl-static "-MExtUtils::Command::MM" "-e" "test_harness(1, 'blib/lib', 'blib/arch')" t/*.t # $DBI::VERSION=1.607 t/01_compile.t ........................... 1..4 ok 1 - Perl version is new enough ok 2 - use DBI; ok 3 - use DBD::SQLite; ok 4 - use t::lib::Test; ok # sqlite_version=3.6.13 t/02_logon.t ............................. 1..10 ok 1 - The object isa DBI::db ok 2 - ->{sqlite_version} ok ok 3 - AutoCommit is on by default ok 4 - Found initial busy_timeout ok 5 ok 6 - Set busy_timeout to new value ok 7 - The object isa DBI::db ok 8 - Unicode is on ok 9 - The object isa DBI::db ok 10 - no warnings ok t/03_create_table.t ...................... 1..7 ok 1 - The object isa DBI::db ok 2 - ->primary_key_info ok ok 3 - The object isa DBI::st ok 4 - ->execute ok ok 5 - Got 4 columns ok 6 - Table prepending is disabled by default ok 7 - no warnings ok t/04_insert.t ............................ 1..12 ok 1 - The object isa DBI::db ok 2 - CREATE TABLE f ok 3 - DELETE FROM f ok 4 - The object isa DBI::st ok 5 - ->execute returns 1 row ok 6 ok 7 ok 8 ok 9 ok 10 - last_insert_rowid should be 4 ok 11 ok 12 - no warnings ok t/05_select.t ............................ 1..22 ok 1 - The object isa DBI::db ok 2 ok 3 ok 4 ok 5 ok 6 ok 7 ok 8 ok 9 ok 10 ok 11 ok 12 ok 13 ok 14 - Check num_rows (1) == 1 ok 15 ok 16 ok 17 ok 18 ok 19 ok 20 ok 21 ok 22 - no warnings ok t/06_tran.t .............................. 1..3 ok 1 - The object isa DBI::db ok 2 - 0E0 ID, TITLE, TOTAL ok 3 - no warnings ok t/07_error.t ............................. 1..8 ok 1 - The object isa DBI::db ok 2 - Statement 1 generated an error ok 3 - $DBI::err ok ok 4 - $DBI::errstr ok ok 5 - Statement 2 generated an error ok 6 - $DBI::err ok ok 7 - $DBI::errstr ok ok 8 - no warnings ok t/08_busy.t .............................. 1..11 ok 1 - The object isa DBI::db ok 2 - The object isa DBI::db ok 3 ok 4 ok 5 ok 6 ok 7 # insert failed : DBD::SQLite::db do failed: database is locked at t/08_busy.t line 34. ok 8 ok 9 - Ready ok 10 ok 11 - no warnings ok t/09_create_function.t ................... 1..19 ok 1 - The object isa DBI::db ok 2 - Got a result ok 3 - SELECT add2(1,3) ok 4 - SELECT add2(a,b) FROM func_test ok 5 - SELECT my_sum( '2', 3, 4, '5') ok 6 ok 7 ok 8 - SELECT void_return( 'I died' ) ok 9 - SELECT return_null() ok 10 - SELECT return2() ok 11 - SELECT my_defined(1) ok 12 - SELECT my_defined('') ok 13 - SELECT my_defined('abc') ok 14 - SELECT my_defined(NULL) ok 15 - SELECT noop(NULL) ok 16 - SELECT noop(1) ok 17 - SELECT noop('') ok 18 - SELECT noop(1.0625) ok 19 - no warnings ok t/10_create_aggregate.t .................. 1..16 ok 1 - The object isa DBI::db ok 2 ok 3 ok 4 ok 5 ok 6 ok 7 ok 8 ok 9 ok 10 ok 11 ok 12 ok 13 ok 14 ok 15 ok 16 - no warnings ok t/12_unicode.t ........................... 1..19 ok 1 - Correct length for $bytestring ok 2 - Correct length for $utfstring ok 3 - $utfstring should be marked as UTF-8 by Perl ok 4 - $bytestring should *NOT* be marked as UTF-8 by Perl ok 5 - The object isa DBI::db ok 6 - Unicode is off ok 7 - CREATE TABLE ok 8 - Reading blob gives binary ok 9 - Reading text gives binary too (for now) ok 10 - No blob corruption ok 11 - Same text, different encoding ok 12 - The object isa DBI::db ok 13 - Unicode is on ok 14 - Reading blob still gives binary ok 15 - Reading text returns UTF-8 ok 16 - Still no blob corruption ok 17 - Same text ok 18 - Database actually understands char set ok 19 - no warnings ok t/13_create_collation.t .................. 1..9 ok 1 - The object isa DBI::db ok 2 - collate perl (Bergere, Bergère, HAT, HOT, berger, bergère, ferme, fève, fétu, fête, hâter, héraut, hétaïre, hétéroclite, hêtre, hôte // Bergere, Bergère, HAT, HOT, berger, bergère, ferme, fève, fétu, fête, hâter, héraut, hétaïre, hétéroclite, hêtre, hôte) ok 3 - collate perllocale (Bergere, Bergère, HAT, HOT, berger, bergère, ferme, fève, fétu, fête, hâter, héraut, hétaïre, hétéroclite, hêtre, hôte // Bergere, Bergère, HAT, HOT, berger, bergère, ferme, fève, fétu, fête, hâter, héraut, hétaïre, hétéroclite, hêtre, hôte) ok 4 - collate no_accents (berger, Bergère, bergère, Bergere, ferme, fête, fétu, fève, HAT, hâter, héraut, hétaïre, hétéroclite, hêtre, HOT, hôte // berger, Bergère, bergère, Bergere, ferme, fête, fétu, fève, HAT, hâter, héraut, hétaïre, hétéroclite, hêtre, HOT, hôte) ok 5 - The object isa DBI::db ok 6 - collate perl (Bergere, Bergère, HAT, HOT, berger, bergère, ferme, fève, fétu, fête, hâter, héraut, hétaïre, hétéroclite, hêtre, hôte // Bergere, Bergère, HAT, HOT, berger, bergère, ferme, fève, fétu, fête, hâter, héraut, hétaïre, hétéroclite, hêtre, hôte) ok 7 - collate perllocale (Bergere, Bergère, HAT, HOT, berger, bergère, ferme, fève, fétu, fête, hâter, héraut, hétaïre, hétéroclite, hêtre, hôte // Bergere, Bergère, HAT, HOT, berger, bergère, ferme, fève, fétu, fête, hâter, héraut, hétaïre, hétéroclite, hêtre, hôte) ok 8 - collate no_accents (berger, Bergère, bergère, Bergere, ferme, fête, fétu, fève, HAT, hâter, héraut, hétaïre, hétéroclite, hêtre, HOT, hôte // berger, Bergère, bergère, Bergere, ferme, fête, fétu, fève, HAT, hâter, héraut, hétaïre, hétéroclite, hêtre, HOT, hôte) ok 9 - no warnings ok t/14_progress_handler.t .................. 1..4 ok 1 - The object isa DBI::db ok 2 ok 3 ok 4 - no warnings ok t/15_ak_dbd.t ............................ 1..37 ok 1 - The object isa DBI::db ok 2 - CREATE TABLE ok 3 - ->quote(test1) ok ok 4 - ->disconnect ok 5 - The object isa DBI::db ok 6 - DROP ok 7 - CREATE TABLE ok 8 - INSERT 1 ok 9 - DELETE 1 ok 10 - The object isa DBI::st ok 11 - ->execute ok 12 - ->fetch returns undef ok 13 - ->finish ok 14 - The object isa DBI::st ok 15 - ->rows is negative ok 16 - ->execute ok ok 17 - ->rows returns 0 ok 18 - ->finish ok 19 - INSERT 2 ok 20 - The object isa DBI::st ok 21 - ->execute ok 22 - NULL returned ok ok 23 - ->finish ok 24 - DELETE ok 25 - INSERT 3 ok 26 - The object isa DBI::st ok 27 - ->execute ok 28 - ->fetchall_arrayref ok 29 - ->finish ok 30 - DELETE ok 31 - The object isa DBI::st ok 32 - Execute ok 33 - Reexecute ok 34 - ->finish ok 35 - INSERT 4 ok 36 - The object isa DBI::st ok 37 - no warnings ok t/16_column_info.t ....................... 1..7 ok 1 - Created test table ok 2 - No error creating the table ok 3 - We can get column information ok 4 - We got information on two columns ok 5 - We got the right info in TYPE_NAME ok 6 - We got the right info in COLUMN_NAME ok 7 - no warnings ok t/17_createdrop.t ........................ 1..4 ok 1 - The object isa DBI::db ok 2 - CREATE TABLE ok 3 - DROP TABLE ok 4 - no warnings ok t/18_insertfetch.t ....................... 1..10 ok 1 - The object isa DBI::db ok 2 - CREATE TABLE ok 3 - INSERT ok 4 - SELECT ok ok 5 - DELETE ok 6 - The object isa DBI::st ok 7 - ->execute ok 8 - fetch select deleted ok 9 - fetch empty statement handler ok 10 - no warnings ok t/19_bindparam.t ......................... 1..33 ok 1 - The object isa DBI::db ok 2 - CREATE TABLE ok 3 - The object isa DBI::st ok 4 - EXECUTE 1 ok 5 - EXECUTE 2 ok 6 - EXECUTE 3 ok 7 - bind 1 ok 8 - bind 2 ok 9 - ->execute ok 10 - bind 3 ok 11 - bind 4 ok 12 - ->execute ok 13 - ->disconnect ok 14 - The object isa DBI::db ok 15 - The object isa DBI::st ok 16 - ->execute ok 17 - ->bind_columns ok 18 - ->fetch ok 19 - id = 1 ok 20 - name = A ok 21 - ->fetch ok 22 - id = 2 ok 23 - name = Tim Bunce ok 24 - ->fetch ok 25 - id = 3 ok 26 - name = Jochen Wiedmann ok 27 - ->fetch ok 28 - id = 4 ok 29 - name = $konig ok 30 - ->fetch ok 31 - id = 5 ok 32 - name = undef ok 33 - no warnings ok t/20_blobs.t ............................. 1..10 ok 1 - The object isa DBI::db ok 2 - CREATE TABLE ok 3 - The object isa DBI::st ok 4 - ->bind_param ok 5 - ->execute ok 6 - The object isa DBI::st ok 7 - ->execute ok 8 - Got the blob back ok ok 9 - ->finish ok 10 - no warnings ok t/21_blobtext.t .......................... 1..27 ok 1 - The object isa DBI::db ok 2 ok 3 ok 4 # showblob length: 32768 # 00000000 000102030405060708090a0b0c0d0e0f101112131415161718191a1b1c1d1e1f # 00000020 202122232425262728292a2b2c2d2e2f303132333435363738393a3b3c3d3e3f # 00000040 404142434445464748494a4b4c4d4e4f505152535455565758595a5b5c5d5e5f # 00000060 606162636465666768696a6b6c6d6e6f707172737475767778797a7b7c7d7e7f # 00000080 808182838485868788898a8b8c8d8e8f909192939495969798999a9b9c9d9e9f # 000000a0 a0a1a2a3a4a5a6a7a8a9aaabacadaeafb0b1b2b3b4b5b6b7b8b9babbbcbdbebf # 000000c0 c0c1c2c3c4c5c6c7c8c9cacbcccdcecfd0d1d2d3d4d5d6d7d8d9dadbdcdddedf # 000000e0 e0e1e2e3e4e5e6e7e8e9eaebecedeeeff0f1f2f3f4f5f6f7f8f9fafbfcfdfeff ok 5 ok 6 ok 7 ok 8 ok 9 ok 10 ok 11 ok 12 # showblob length: 32768 # 00000000 000102030405060708090a0b0c0d0e0f101112131415161718191a1b1c1d1e1f # 00000020 202122232425262728292a2b2c2d2e2f303132333435363738393a3b3c3d3e3f # 00000040 404142434445464748494a4b4c4d4e4f505152535455565758595a5b5c5d5e5f # 00000060 606162636465666768696a6b6c6d6e6f707172737475767778797a7b7c7d7e7f # 00000080 808182838485868788898a8b8c8d8e8f909192939495969798999a9b9c9d9e9f # 000000a0 a0a1a2a3a4a5a6a7a8a9aaabacadaeafb0b1b2b3b4b5b6b7b8b9babbbcbdbebf # 000000c0 c0c1c2c3c4c5c6c7c8c9cacbcccdcecfd0d1d2d3d4d5d6d7d8d9dadbdcdddedf # 000000e0 e0e1e2e3e4e5e6e7e8e9eaebecedeeeff0f1f2f3f4f5f6f7f8f9fafbfcfdfeff ok 13 ok 14 ok 15 # showblob length: 32768 # 00000000 000102030405060708090a0b0c0d0e0f101112131415161718191a1b1c1d1e1f # 00000020 202122232425262728292a2b2c2d2e2f303132333435363738393a3b3c3d3e3f # 00000040 404142434445464748494a4b4c4d4e4f505152535455565758595a5b5c5d5e5f # 00000060 606162636465666768696a6b6c6d6e6f707172737475767778797a7b7c7d7e7f # 00000080 808182838485868788898a8b8c8d8e8f909192939495969798999a9b9c9d9e9f # 000000a0 a0a1a2a3a4a5a6a7a8a9aaabacadaeafb0b1b2b3b4b5b6b7b8b9babbbcbdbebf # 000000c0 c0c1c2c3c4c5c6c7c8c9cacbcccdcecfd0d1d2d3d4d5d6d7d8d9dadbdcdddedf # 000000e0 e0e1e2e3e4e5e6e7e8e9eaebecedeeeff0f1f2f3f4f5f6f7f8f9fafbfcfdfeff ok 16 ok 17 ok 18 # showblob length: 32768 # 00000000 000102030405060708090a0b0c0d0e0f101112131415161718191a1b1c1d1e1f # 00000020 202122232425262728292a2b2c2d2e2f303132333435363738393a3b3c3d3e3f # 00000040 404142434445464748494a4b4c4d4e4f505152535455565758595a5b5c5d5e5f # 00000060 606162636465666768696a6b6c6d6e6f707172737475767778797a7b7c7d7e7f # 00000080 808182838485868788898a8b8c8d8e8f909192939495969798999a9b9c9d9e9f # 000000a0 a0a1a2a3a4a5a6a7a8a9aaabacadaeafb0b1b2b3b4b5b6b7b8b9babbbcbdbebf # 000000c0 c0c1c2c3c4c5c6c7c8c9cacbcccdcecfd0d1d2d3d4d5d6d7d8d9dadbdcdddedf # 000000e0 e0e1e2e3e4e5e6e7e8e9eaebecedeeeff0f1f2f3f4f5f6f7f8f9fafbfcfdfeff ok 19 ok 20 ok 21 # showblob length: 32768 # 00000000 000102030405060708090a0b0c0d0e0f101112131415161718191a1b1c1d1e1f # 00000020 202122232425262728292a2b2c2d2e2f303132333435363738393a3b3c3d3e3f # 00000040 404142434445464748494a4b4c4d4e4f505152535455565758595a5b5c5d5e5f # 00000060 606162636465666768696a6b6c6d6e6f707172737475767778797a7b7c7d7e7f # 00000080 808182838485868788898a8b8c8d8e8f909192939495969798999a9b9c9d9e9f # 000000a0 a0a1a2a3a4a5a6a7a8a9aaabacadaeafb0b1b2b3b4b5b6b7b8b9babbbcbdbebf # 000000c0 c0c1c2c3c4c5c6c7c8c9cacbcccdcecfd0d1d2d3d4d5d6d7d8d9dadbdcdddedf # 000000e0 e0e1e2e3e4e5e6e7e8e9eaebecedeeeff0f1f2f3f4f5f6f7f8f9fafbfcfdfeff ok 22 ok 23 ok 24 # showblob length: 32768 # 00000000 000102030405060708090a0b0c0d0e0f101112131415161718191a1b1c1d1e1f # 00000020 202122232425262728292a2b2c2d2e2f303132333435363738393a3b3c3d3e3f # 00000040 404142434445464748494a4b4c4d4e4f505152535455565758595a5b5c5d5e5f # 00000060 606162636465666768696a6b6c6d6e6f707172737475767778797a7b7c7d7e7f # 00000080 808182838485868788898a8b8c8d8e8f909192939495969798999a9b9c9d9e9f # 000000a0 a0a1a2a3a4a5a6a7a8a9aaabacadaeafb0b1b2b3b4b5b6b7b8b9babbbcbdbebf # 000000c0 c0c1c2c3c4c5c6c7c8c9cacbcccdcecfd0d1d2d3d4d5d6d7d8d9dadbdcdddedf # 000000e0 e0e1e2e3e4e5e6e7e8e9eaebecedeeeff0f1f2f3f4f5f6f7f8f9fafbfcfdfeff ok 25 ok 26 ok 27 - no warnings ok t/22_listfields.t ........................ 1..12 ok 1 - The object isa DBI::db ok 2 - CREATE TABLE ok 3 - The object isa DBI::st ok 4 - ->execute ok 5 - Found 2 fields ok 6 - Names are ok ok 7 - ->finish ok ok 8 - The object isa DBI::st ok 9 - ->execute ok 10 - No fields in statement ok 11 - ->finish ok ok 12 - no warnings ok t/23_nulls.t ............................. 1..9 ok 1 - The object isa DBI::db ok 2 - CREATE TABLE ok 3 - INSERT ok 4 - The object isa DBI::st ok 5 - ->execute ok ok 6 - Two values in the row ok 7 - First column is undef ok 8 - Second column is defined ok 9 - ->finish ok t/24_numrows.t ........................... 1..18 ok 1 - The object isa DBI::db ok 2 - CREATE TABLE ok 3 - INSERT 1 ok 4 - The object isa DBI::st ok 5 - ->execute ok 6 - Got 1 rows ok 7 - ->finish ok 8 - INSERT 2 ok 9 - The object isa DBI::st ok 10 - ->execute ok 11 - Got 2 rows ok 12 - ->finish ok 13 - INSERT 3 ok 14 - The object isa DBI::st ok 15 - ->execute ok 16 - Got 2 rows ok 17 - ->finish ok 18 - no warnings ok t/25_chopblanks.t ........................ 1..14 ok 1 - The object isa DBI::db ok 2 - CREATE TABLE ok 3 - INSERT 1 ok 4 - INSERT 2 ok 5 - INSERT 3 ok 6 - The object isa DBI::st ok 7 - ->execute ok ok 8 - ChopBlanks = 0 ok 9 - ->finish ok 10 - The object isa DBI::st ok 11 - ->execute ok ok 12 - ChopBlanks = 1 ok 13 - ->finish ok 14 - no warnings ok t/26_commit.t ............................ 1..28 ok 1 - The object isa DBI::db ok 2 - CREATE TABLE ok 3 - AutoCommit is off ok 4 - ->err is false ok 5 - ->err is false ok 6 - INSERT 1 ok 7 - Found 1 rows ok 8 - ->rollback ok ok 9 - Found 0 rows ok 10 - DELETE 1 ok 11 - Found 0 rows ok 12 - ->commit ok ok 13 - Found 0 rows ok 14 - INSERT 1 ok 15 - Found 1 rows ok 16 - ->disconnect ok ok 17 - The object isa DBI::db ok 18 - Found 0 rows ok 19 - AutoCommit is on ok 20 - INSERT 1 ok 21 - Found 1 rows ok 22 - ->disconnect ok ok 23 - The object isa DBI::db ok 24 - Found 1 rows ok 25 - INSERT 2 ok 26 - Got one warning ok 27 - INSERT 3 ok 28 - Got one warning ok t/27_metadata.t .......................... 1..27 ok 1 ok 2 ok 3 ok 4 ok 5 ok 6 ok 7 ok 8 ok 9 ok 10 ok 11 ok 12 ok 13 ok 14 ok 15 ok 16 ok 17 ok 18 ok 19 ok 20 ok 21 ok 22 ok 23 # Types: varchar(2) char(1) # Names: f1 f2 ok 24 ok 25 ok 26 ok 27 ok t/28_schemachange.t ...................... 1..9 ok 1 - The object isa DBI::db ok 2 - CREATE TABLE table1 (id INTEGER NOT NULL, name CHAR (64) NOT NULL) ok 3 - CREATE TABLE table2 (id INTEGER NOT NULL, name CHAR (64) NOT NULL) ok 4 - ->disconnect ok ok 5 - The object isa DBI::db ok 6 - waitpid ok 7 - DROP TABLE table1 ok 8 - CREATE TABLE table2 (id INTEGER NOT NULL, name CHAR (64) NOT NULL) ok 9 - ->disconnect ok ok t/29_cppcomments.t ....................... 1..3 ok 1 - dbdimp.c has no C++ comments ok 2 - SQLite.c has no C++ comments ok 3 - sqlite3.c has no C++ comments ok t/30_auto_rollback.t ..................... 1..6 ok 1 - The object isa DBI::db ok 2 - ->{PrintWarn} is false ok 3 - CREATE TABLE ok ok 4 - ->begin_work ok 5 - INSERT ok ok 6 - no warnings ok t/31_bind_weird_number_param.t ........... 1..3 ok 1 - The object isa DBI::db ok 2 - CREATE TABLE f ok 3 - accepts 12300: 12300 ok t/32_inactive_error.t .................... 1..4 ok 1 - The object isa DBI::db ok 2 ok 3 - Got 1 warning ok 4 - Got the expected warning ok t/33_non_latin_path.t .................... 1..25 ok 1 - longascii created ok 2 - The object isa DBI::db ok 3 - Could connect to database in longascii ok 4 - The object isa DBI::db ok 5 - Could connect to database in longascii ok 6 - Could connect to database in /tmp/LIZpnbuM5F/longascii.db ok 7 - adatbázis created ok 8 - The object isa DBI::db ok 9 - Could connect to database in adatbázis ok 10 - The object isa DBI::db ok 11 - Could connect to database in adatbázis ok 12 - Could connect to database in /tmp/LIZpnbuM5F/adatbázis.db ok 13 - name with spaces created ok 14 - The object isa DBI::db ok 15 - Could connect to database in name with spaces ok 16 - The object isa DBI::db ok 17 - Could connect to database in name with spaces ok 18 - Could connect to database in /tmp/LIZpnbuM5F/name with spaces.db ok 19 - ¿¿¿ ¿¿¿¿¿¿ created ok 20 - The object isa DBI::db ok 21 - Could connect to database in ¿¿¿ ¿¿¿¿¿¿ ok 22 - The object isa DBI::db ok 23 - Could connect to database in ¿¿¿ ¿¿¿¿¿¿ ok 24 - Could connect to database in /tmp/LIZpnbuM5F/¿¿¿ ¿¿¿¿¿¿.db ok 25 - no warnings ok t/97_meta.t .............................. 1..2 ok 1 - META.yml contains valid YAML ok 2 - META.yml meets the designated specification ok t/98_pod.t ............................... 1..2 ok 1 - blib/lib/DBD/SQLite.pm ok 2 - blib/lib/DBD/SQLite/Cookbook.pod ok t/99_pmv.t ............................... 1..51 ok 1 - lib/DBD/SQLite.pm ok 2 - t/21_blobtext.t ok 3 - t/99_pmv.t ok 4 - t/26_commit.t ok 5 - t/15_ak_dbd.t ok 6 - t/10_create_aggregate.t ok 7 - t/rt_32889_prepare_cached_reexecute.t ok 8 - t/24_numrows.t ok 9 - t/27_metadata.t ok 10 - t/97_meta.t ok 11 - t/14_progress_handler.t ok 12 - t/28_schemachange.t ok 13 - t/07_error.t ok 14 - t/20_blobs.t ok 15 - t/rt_15186_prepcached.t ok 16 - t/16_column_info.t ok 17 - t/rt_25371_asymmetric_unicode.t ok 18 - t/rt_40594_nullable.t ok 19 - t/rt_31324_full_names.t ok 20 - t/22_listfields.t ok 21 - t/02_logon.t ok 22 - t/rt_21406_auto_finish.t ok 23 - t/05_select.t ok 24 - t/25_chopblanks.t ok 25 - t/12_unicode.t ok 26 - t/30_auto_rollback.t ok 27 - t/08_busy.t ok 28 - t/04_insert.t ok 29 - t/06_tran.t ok 30 - t/18_insertfetch.t ok 31 - t/rt_36838_unique_and_bus_error.t ok 32 - t/33_non_latin_path.t ok 33 - t/rt_25924_user_defined_func_unicode.t ok 34 - t/rt_27553_prepared_cache_and_analyze.t ok 35 - t/rt_36836_duplicate_key.t ok 36 - t/13_create_collation.t ok 37 - t/01_compile.t ok 38 - t/rt_25460_numeric_aggregate.t ok 39 - t/rt_29629_sqlite_where_length.t ok 40 - t/19_bindparam.t ok 41 - t/09_create_function.t ok 42 - t/17_createdrop.t ok 43 - t/23_nulls.t ok 44 - t/98_pod.t ok 45 - t/rt_29058_group_by.t ok 46 - t/03_create_table.t ok 47 - t/32_inactive_error.t ok 48 - t/29_cppcomments.t ok 49 - t/31_bind_weird_number_param.t ok 50 - t/lib/Test.pm ok 51 - Makefile.PL ok t/rt_15186_prepcached.t .................. 1..13 ok 1 - The object isa DBI::db ok 2 - CREATE TABLE ok 3 - INSERT 1 ok 4 - INSERT 1 ok 5 - INSERT 1 ok 6 - The object isa DBI::st ok 7 - Query 1 Row 1 ok 8 - The object isa DBI::st ok 9 - Query 2 Row 1 ok 10 - Query 2 Row 2 ok 11 - The object isa DBI::st ok 12 - Query 2 Row 2 ok 13 - no warnings ok t/rt_21406_auto_finish.t ................. 1..11 ok 1 - The object isa DBI::db ok 2 - The object isa DBI::st ok 3 - ->execute ok ok 4 - Row 1 ok ok 5 - Row 2 ok ok 6 - The object isa DBI::st ok 7 - ->execute ok ok 8 - Row 1 ok ok 9 - Row 2 ok ok 10 - ->finish ok ok 11 - no warnings ok t/rt_25371_asymmetric_unicode.t .......... 1..23 ok 1 - The object isa DBI::db ok 2 - Unicode is on ok 3 - CREATE TABLE ok 4 - INSERT ok 5 - Value round-tripped ok ok 6 ok 7 - DELETE ok ok 8 - INSERT ok 9 - Value round-tripped ok ok 10 ok 11 ok 12 - DELETE ok ok 13 - INSERT ok 14 - Value round-tripped ok ok 15 ok 16 ok 17 - DELETE ok ok 18 - INSERT ok 19 - Value round-tripped ok ok 20 ok 21 ok 22 - DELETE ok ok 23 - no warnings ok t/rt_25460_numeric_aggregate.t ........... 1..14 ok 1 - The object isa DBI::db ok 2 - CREATE TABLE ok 3 ok 4 ok 5 ok 6 ok 7 ok 8 ok 9 ok 10 ok 11 ok 12 ok 13 - group/sum/sort/limit query ok ok 14 - no warnings ok t/rt_25924_user_defined_func_unicode.t ... 1..15 ok 1 - The object isa DBI::db ok 2 - CREATE TABLE ok 3 - INSERT ok 4 - unicode upcase ok ok 5 - DELETE ok ok 6 - INSERT ok 7 - unicode upcase ok ok 8 - DELETE ok ok 9 - INSERT ok 10 - unicode upcase ok ok 11 - DELETE ok ok 12 - INSERT ok 13 - unicode upcase ok ok 14 - DELETE ok ok 15 - no warnings ok t/rt_27553_prepared_cache_and_analyze.t .. 1..6 ok 1 - The object isa DBI::db ok 2 ok 3 ok 4 ok 5 ok 6 - no warnings ok t/rt_29058_group_by.t .................... 1..7 ok 1 - The object isa DBI::db ok 2 ok 3 - Got 2 results ok 4 - Got 2 results ok 5 - Got 2 results not ok 6 - we got 0 items # TODO This test is currently broken again. Wait for a better fix, or use known workarounds shown above # Failed (TODO) test 'we got 0 items' # at t/rt_29058_group_by.t line 62. # got: '0' # expected: '2' ok 7 - no warnings ok t/rt_29629_sqlite_where_length.t ......... 1..17 ok 1 - The object isa DBI::db ok 2 - insert ok 3 - execute, select length ok 4 - select length result ok 5 - execute: select count(*) from artist where length(name) > ? : [2] # TODO This test is currently broken again. Wait for a better fix, or use known workarounds. not ok 6 - result of: select count(*) from artist where length(name) > ? : [2] # TODO This test is currently broken again. Wait for a better fix, or use known workarounds. # Failed (TODO) test 'result of: select count(*) from artist where length(name) > ? : [2]' # at t/rt_29629_sqlite_where_length.t line 39. # got: '0' # expected: '1' ok 7 - execute: select count(*) from artist where length(name) > 2 ok 8 - result of: select count(*) from artist where length(name) > 2 ok 9 - execute: select count(*) from artist where length(name) > 1 ok 10 - result of: select count(*) from artist where length(name) > 1 ok 11 - execute: select count(*) from artist where length(name) > ? : [1] # TODO This test is currently broken again. Wait for a better fix, or use known workarounds. not ok 12 - result of: select count(*) from artist where length(name) > ? [1] # TODO This test is currently broken again. Wait for a better fix, or use known workarounds. # Failed (TODO) test 'result of: select count(*) from artist where length(name) > ? [1]' # at t/rt_29629_sqlite_where_length.t line 65. # got: '0' # expected: '1' ok 13 - execute: select count(*) from artist where length(name) > ? : [2] ok 14 - result of: select count(*) from artist where length(name) > ? : [2] ok 15 - execute: select count(*) from artist where length(name) > ?+0 : [2] ok 16 - result of: select count(*) from artist where length(name) > ?+0 : [2] ok 17 - no warnings ok t/rt_31324_full_names.t .................. 1..8 ok 1 - The object isa DBI::db ok 2 - The object isa DBI::st ok 3 - ->execute ok ok 4 - Shortname row ok ok 5 - The object isa DBI::st ok 6 - ->execute ok ok 7 - Shortname row ok ok 8 - no warnings ok t/rt_32889_prepare_cached_reexecute.t .... 1..32 ok 1 - The object isa DBI::db ok 2 - CREATE TABLE ok 3 - insert 1 ok 4 - insert 2 ok 5 - The object isa DBI::db ok 6 - No warnings ok 7 - The object isa DBI::db ok 8 - No warnings ok 9 - The object isa DBI::db ok 10 - Got row 1 ok 11 - No warnings ok 12 - The object isa DBI::db ok 13 - Got row 1 ok 14 - Got row 1 ok 15 - No warnings ok 16 - The object isa DBI::db ok 17 - Got row 1 ok 18 - Got a warning ok 19 - The object isa DBI::db ok 20 - No warnings ok 21 - The object isa DBI::db ok 22 - Got row 1 ok 23 - No warnings ok 24 - The object isa DBI::db ok 25 - Got row 1 ok 26 - Got row 1 ok 27 - No warnings ok 28 - The object isa DBI::db ok 29 - Got row 1 ok 30 - Got row 1 ok 31 - No warnings ok 32 - no warnings ok t/rt_36836_duplicate_key.t ............... 1..5 ok 1 - The object isa DBI::db ok 2 - create table ok 3 - insert ok 4 - duplicate ok 5 - no warnings ok t/rt_36838_unique_and_bus_error.t ........ 1..4 ok 1 - The object isa DBI::db ok 2 ok 3 - DBD::SQLite::db do failed: column num is not unique at t/rt_36838_unique_and_bus_error.t line 19. # ok 4 - no warnings ok t/rt_40594_nullable.t .................... 1..7 ok 1 - The object isa DBI::db ok 2 ok 3 ok 4 ok 5 ok 6 ok 7 ok All tests successful. Test Summary Report ------------------- t/rt_29629_sqlite_where_length.t (Wstat: 0 Tests: 17 Failed: 0) TODO passed: 5, 11 Files=48, Tests=647, 26 wallclock secs ( 0.01 usr 0.27 sys + 12.25 cusr 1.69 csys = 14.22 CPU) Result: PASS ADAMK/DBD-SQLite-1.25.tar.gz make test TEST_VERBOSE=1 -- OK Adam Kennedy <adamk@cpan.org> Self Contained SQLite RDBMS in a DBI Driver >>> (cd /home/cpanfly/var/cpan/build/DBD-SQLite-1.25-gQnkG0 && tar cvf - DBD-SQLite-1.25.ppd blib) | gzip -c >/home/cpanfly/var/REPO/A/AD/ADAMK/DBD-SQLite-1.25.tar.gz DBD-SQLite-1.25.ppd blib/ blib/lib/ blib/lib/DBD/ blib/lib/DBD/SQLite.pm blib/lib/DBD/SQLite/ blib/lib/DBD/SQLite/Cookbook.pod blib/arch/ blib/arch/auto/ blib/arch/auto/DBD/ blib/arch/auto/DBD/SQLite/ blib/arch/auto/DBD/SQLite/SQLite.bs blib/arch/auto/DBD/SQLite/SQLite.so blib/man3/ blib/man3/DBD::SQLite.3 blib/man3/DBD::SQLite::Cookbook.3 >>> mv /home/cpanfly/var/cpan/build/DBD-SQLite-1.25-gQnkG0/DBD-SQLite-1.25.ppd /home/cpanfly/var/REPO/A/AD/ADAMK Finished 2009-04-24T06:13:21