Start 2010-09-16T12:22:44 ActivePerl-1200 CPAN-1.9402 Going to read '/Users/fly1200/var/cpan/Metadata' Database was generated on Wed, 15 Sep 2010 21:29:13 GMT Running make for A/AD/ADAMK/DBD-SQLite-1.31.tar.gz Fetching with LWP: http://cpan.nas.activestate.com/authors/id/A/AD/ADAMK/DBD-SQLite-1.31.tar.gz Checksum for /Users/fly1200/var/cpan/sources/authors/id/A/AD/ADAMK/DBD-SQLite-1.31.tar.gz ok DBD-SQLite-1.31/ DBD-SQLite-1.31/META.yml DBD-SQLite-1.31/Makefile.PL DBD-SQLite-1.31/MANIFEST.SKIP DBD-SQLite-1.31/util/ DBD-SQLite-1.31/util/getsqlite.pl DBD-SQLite-1.31/SQLite.xs DBD-SQLite-1.31/dbdimp.h DBD-SQLite-1.31/fts3_tokenizer.h DBD-SQLite-1.31/LICENSE DBD-SQLite-1.31/README DBD-SQLite-1.31/sqlite3ext.h DBD-SQLite-1.31/ppport.h DBD-SQLite-1.31/lib/ DBD-SQLite-1.31/lib/DBD/ DBD-SQLite-1.31/lib/DBD/SQLite.pm DBD-SQLite-1.31/lib/DBD/SQLite/ DBD-SQLite-1.31/lib/DBD/SQLite/Cookbook.pod DBD-SQLite-1.31/SQLiteXS.h DBD-SQLite-1.31/sqlite3.c DBD-SQLite-1.31/xt/ DBD-SQLite-1.31/xt/meta.t DBD-SQLite-1.31/xt/pmv.t DBD-SQLite-1.31/xt/pod.t DBD-SQLite-1.31/inc/ DBD-SQLite-1.31/inc/Test/ DBD-SQLite-1.31/inc/Test/NoWarnings/ DBD-SQLite-1.31/inc/Test/NoWarnings/Warning.pm DBD-SQLite-1.31/inc/Test/NoWarnings.pm DBD-SQLite-1.31/dbdimp.c DBD-SQLite-1.31/MANIFEST DBD-SQLite-1.31/Changes DBD-SQLite-1.31/sqlite3.h DBD-SQLite-1.31/t/ DBD-SQLite-1.31/t/07_error.t DBD-SQLite-1.31/t/rt_25924_user_defined_func_unicode.t DBD-SQLite-1.31/t/13_create_collation.t DBD-SQLite-1.31/t/43_fts3.t DBD-SQLite-1.31/t/rt_40594_nullable.t DBD-SQLite-1.31/t/28_schemachange.t DBD-SQLite-1.31/t/21_blobtext.t DBD-SQLite-1.31/t/12_unicode.t DBD-SQLite-1.31/t/rt_31324_full_names.t DBD-SQLite-1.31/t/39_foreign_keys.t DBD-SQLite-1.31/t/rt_52573_manual_exclusive_lock.t DBD-SQLite-1.31/t/32_inactive_error.t DBD-SQLite-1.31/t/rt_27553_prepared_cache_and_analyze.t DBD-SQLite-1.31/t/10_create_aggregate.t DBD-SQLite-1.31/t/rt_29058_group_by.t DBD-SQLite-1.31/t/09_create_function.t DBD-SQLite-1.31/t/rt_36836_duplicate_key.t DBD-SQLite-1.31/t/08_busy.t DBD-SQLite-1.31/t/02_logon.t DBD-SQLite-1.31/t/16_column_info.t DBD-SQLite-1.31/t/33_non_latin_path.t DBD-SQLite-1.31/t/rt_25371_asymmetric_unicode.t DBD-SQLite-1.31/t/17_createdrop.t DBD-SQLite-1.31/t/31_bind_weird_number_param.t DBD-SQLite-1.31/t/rt_29629_sqlite_where_length.t DBD-SQLite-1.31/t/40_multiple_statements.t DBD-SQLite-1.31/t/26_commit.t DBD-SQLite-1.31/t/rt_36838_unique_and_bus_error.t DBD-SQLite-1.31/t/04_insert.t DBD-SQLite-1.31/t/05_select.t DBD-SQLite-1.31/t/24_numrows.t DBD-SQLite-1.31/t/18_insertfetch.t DBD-SQLite-1.31/t/rt_32889_prepare_cached_reexecute.t DBD-SQLite-1.31/t/22_listfields.t DBD-SQLite-1.31/t/19_bindparam.t DBD-SQLite-1.31/t/rt_25460_numeric_aggregate.t DBD-SQLite-1.31/t/14_progress_handler.t DBD-SQLite-1.31/t/rt_53235_icu_compatibility.t DBD-SQLite-1.31/t/30_auto_rollback.t DBD-SQLite-1.31/t/36_hooks.t DBD-SQLite-1.31/t/rt_48393_debug_panic_with_commit.t DBD-SQLite-1.31/t/41_placeholders.t DBD-SQLite-1.31/t/20_blobs.t DBD-SQLite-1.31/t/06_tran.t DBD-SQLite-1.31/t/35_table_info.t DBD-SQLite-1.31/t/lib/ DBD-SQLite-1.31/t/lib/Test.pm DBD-SQLite-1.31/t/03_create_table.t DBD-SQLite-1.31/t/25_chopblanks.t DBD-SQLite-1.31/t/27_metadata.t DBD-SQLite-1.31/t/01_compile.t DBD-SQLite-1.31/t/37_regexp.t DBD-SQLite-1.31/t/rt_50503_fts3.t DBD-SQLite-1.31/t/38_empty_statement.t DBD-SQLite-1.31/t/rt_21406_auto_finish.t DBD-SQLite-1.31/t/29_cppcomments.t DBD-SQLite-1.31/t/rt_15186_prepcached.t DBD-SQLite-1.31/t/42_primary_key_info.t DBD-SQLite-1.31/t/23_nulls.t DBD-SQLite-1.31/t/34_online_backup.t DBD-SQLite-1.31/t/15_ak_dbd.t CPAN.pm: Going to build A/AD/ADAMK/DBD-SQLite-1.31.tar.gz >>> /Users/fly1200/bin/perl Makefile.PL We're using the bundled sqlite library. Checking if your kit is complete... Looks good Multiple copies of Driver.xst found in: /Users/fly1200/var/megalib/auto/DBI/ /Users/fly1200/ap1200-292396/lib/auto/DBI/ at Makefile.PL line 331 Using DBI 1.611 (for perl 5.012000 on darwin-thread-multi-2level) installed in /Users/fly1200/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 /Users/fly1200/bin/perl -p -e "s/~DRIVER~/SQLite/g" /Users/fly1200/var/megalib/auto/DBI/Driver.xst > SQLite.xsi /Users/fly1200/bin/perl /Users/fly1200/var/megalib/ExtUtils/xsubpp -typemap /Users/fly1200/ap1200-292396/lib/ExtUtils/typemap SQLite.xs > SQLite.xsc && mv SQLite.xsc SQLite.c gcc -c -I. -I/Users/fly1200/var/megalib/auto/DBI -fno-common -DPERL_DARWIN -no-cpp-precomp -arch ppc -arch i386 -nostdinc -B/Developer/SDKs/MacOSX10.4u.sdk/usr/include/gcc -B/Developer/SDKs/MacOSX10.4u.sdk/usr/lib/gcc -isystem/Developer/SDKs/MacOSX10.4u.sdk/usr/include -F/Developer/SDKs/MacOSX10.4u.sdk/System/Library/Frameworks -mmacosx-version-min=10.4 -DUSE_SITECUSTOMIZE -fno-merge-constants -fno-strict-aliasing -pipe -O2 -DVERSION=\"1.31\" -DXS_VERSION=\"1.31\" "-I/Users/fly1200/ap1200-292396/lib/CORE" -DSQLITE_ENABLE_FTS3 -DSQLITE_ENABLE_FTS3_PARENTHESIS -DSQLITE_ENABLE_COLUMN_METADATA -DNDEBUG=1 -DHAVE_USLEEP=1 -DSQLITE_ENABLE_LOCKING_STYLE=0 SQLite.c gcc -c -I. -I/Users/fly1200/var/megalib/auto/DBI -fno-common -DPERL_DARWIN -no-cpp-precomp -arch ppc -arch i386 -nostdinc -B/Developer/SDKs/MacOSX10.4u.sdk/usr/include/gcc -B/Developer/SDKs/MacOSX10.4u.sdk/usr/lib/gcc -isystem/Developer/SDKs/MacOSX10.4u.sdk/usr/include -F/Developer/SDKs/MacOSX10.4u.sdk/System/Library/Frameworks -mmacosx-version-min=10.4 -DUSE_SITECUSTOMIZE -fno-merge-constants -fno-strict-aliasing -pipe -O2 -DVERSION=\"1.31\" -DXS_VERSION=\"1.31\" "-I/Users/fly1200/ap1200-292396/lib/CORE" -DSQLITE_ENABLE_FTS3 -DSQLITE_ENABLE_FTS3_PARENTHESIS -DSQLITE_ENABLE_COLUMN_METADATA -DNDEBUG=1 -DHAVE_USLEEP=1 -DSQLITE_ENABLE_LOCKING_STYLE=0 dbdimp.c dbdimp.c: In function 'perl_tokenizer_Next': dbdimp.c: In function 'perl_tokenizer_Next': dbdimp.c:716: warning: pointer targets in passing argument 2 of 'Perl_utf8_hop' differ in signedness dbdimp.c:716: warning: pointer targets in assignment differ in signedness dbdimp.c:719: warning: pointer targets in passing argument 2 of 'Perl_utf8_hop' differ in signedness bdimp.c:716: warning: pointer targets in passing argument 2 of 'Perl_utf8_hop' differ in signedness dbdimp.c:719: warning: pointer targets in assignment differ in signedness dbdimp.c:716: warning: pointer targets in assignment differ in signedness dbdimp.c:719: warning: pointer targets in passing argument 2 of 'Perl_utf8_hop' differ in signedness dbdimp.c:719: warning: pointer targets in assignment differ in signedness gcc -c -I. -I/Users/fly1200/var/megalib/auto/DBI -fno-common -DPERL_DARWIN -no-cpp-precomp -arch ppc -arch i386 -nostdinc -B/Developer/SDKs/MacOSX10.4u.sdk/usr/include/gcc -B/Developer/SDKs/MacOSX10.4u.sdk/usr/lib/gcc -isystem/Developer/SDKs/MacOSX10.4u.sdk/usr/include -F/Developer/SDKs/MacOSX10.4u.sdk/System/Library/Frameworks -mmacosx-version-min=10.4 -DUSE_SITECUSTOMIZE -fno-merge-constants -fno-strict-aliasing -pipe -O2 -DVERSION=\"1.31\" -DXS_VERSION=\"1.31\" "-I/Users/fly1200/ap1200-292396/lib/CORE" -DSQLITE_ENABLE_FTS3 -DSQLITE_ENABLE_FTS3_PARENTHESIS -DSQLITE_ENABLE_COLUMN_METADATA -DNDEBUG=1 -DHAVE_USLEEP=1 -DSQLITE_ENABLE_LOCKING_STYLE=0 sqlite3.c Running Mkbootstrap for DBD::SQLite () chmod 644 SQLite.bs rm -f blib/arch/auto/DBD/SQLite/SQLite.bundle env MACOSX_DEPLOYMENT_TARGET=10.3 cc -bundle -undefined dynamic_lookup -Wl,-search_paths_first -arch ppc -arch i386 -Wl,-syslibroot,/Developer/SDKs/MacOSX10.4u.sdk -mmacosx-version-min=10.4 SQLite.o dbdimp.o sqlite3.o -o blib/arch/auto/DBD/SQLite/SQLite.bundle \ \ chmod 755 blib/arch/auto/DBD/SQLite/SQLite.bundle 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.31.tar.gz make -- OK Running make test >>> make test TEST_VERBOSE=1 PERL_DL_NONLAZY=1 /Users/fly1200/bin/perl "-MExtUtils::Command::MM" "-e" "test_harness(1, 'blib/lib', 'blib/arch')" t/*.t # $DBI::VERSION=1.611 # Compile Options: # ENABLE_COLUMN_METADATA # ENABLE_FTS3 # ENABLE_FTS3_PARENTHESIS # ENABLE_LOCKING_STYLE=0 # TEMP_STORE=1 # THREADSAFE=1 t/01_compile.t ........................... 1..3 ok 1 - use DBI; ok 2 - use DBD::SQLite; ok 3 - use t::lib::Test; ok # sqlite_version=3.7.2 t/02_logon.t ............................. 1..19 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 - The object isa DBI::db ok 11 - ->{sqlite_version} ok ok 12 - AutoCommit is on by default ok 13 - Found initial busy_timeout ok 14 ok 15 - Set busy_timeout to new value ok 16 - The object isa DBI::db ok 17 - Unicode is on ok 18 - The object isa DBI::db ok 19 - 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..14 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 - DBI::db->can('sqlite_last_insert_rowid') ok 12 - last_insert_rowid should be 4 ok 13 ok 14 - 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..23 ok 1 - The object isa DBI::db ok 2 - The object isa DBI::db ok 3 ok 4 ok 5 ok 6 ok 7 # expected insert failure : DBD::SQLite::db do failed: database is locked at t/08_busy.t line 46. ok 8 ok 9 - Ready ok 10 ok 11 ok 12 - The object isa DBI::db ok 13 - The object isa DBI::db ok 14 ok 15 ok 16 ok 17 ok 18 # expected insert failure : DBD::SQLite::db do failed: database is locked at t/08_busy.t line 46, line 1. ok 19 ok 20 - Ready ok 21 ok 22 ok 23 - no warnings ok t/09_create_function.t ................... 1..55 ok 1 - The object isa DBI::db ok 2 ok 3 - Got a result ok 4 ok 5 - SELECT add2(1,3) ok 6 - SELECT add2(a,b) FROM func_test ok 7 ok 8 - SELECT my_sum( '2', 3, 4, '5') ok 9 ok 10 ok 11 ok 12 ok 13 - SELECT void_return( 'I died' ) ok 14 ok 15 - SELECT return_null() ok 16 ok 17 - SELECT return2() ok 18 ok 19 - SELECT my_defined(1) ok 20 - SELECT my_defined('') ok 21 - SELECT my_defined('abc') ok 22 - SELECT my_defined(NULL) ok 23 ok 24 - SELECT noop(NULL) ok 25 - SELECT noop(1) ok 26 - SELECT noop('') ok 27 - SELECT noop(1.0625) ok 28 - The object isa DBI::db ok 29 ok 30 - Got a result ok 31 ok 32 - SELECT add2(1,3) ok 33 - SELECT add2(a,b) FROM func_test ok 34 ok 35 - SELECT my_sum( '2', 3, 4, '5') ok 36 ok 37 ok 38 ok 39 ok 40 - SELECT void_return( 'I died' ) ok 41 ok 42 - SELECT return_null() ok 43 ok 44 - SELECT return2() ok 45 ok 46 - SELECT my_defined(1) ok 47 - SELECT my_defined('') ok 48 - SELECT my_defined('abc') ok 49 - SELECT my_defined(NULL) ok 50 ok 51 - SELECT noop(NULL) ok 52 - SELECT noop(1) ok 53 - SELECT noop('') ok 54 - SELECT noop(1.0625) ok 55 - no warnings ok t/10_create_aggregate.t .................. 1..43 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 ok 17 ok 18 ok 19 ok 20 ok 21 ok 22 - The object isa DBI::db ok 23 ok 24 ok 25 ok 26 ok 27 ok 28 ok 29 ok 30 ok 31 ok 32 ok 33 ok 34 ok 35 ok 36 ok 37 ok 38 ok 39 ok 40 ok 41 ok 42 ok 43 - no warnings ok t/12_unicode.t ........................... 1..26 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 - The object isa DBI::db ok 20 - bytestring upgraded to utf-8 ok 21 - bytestring has utf-8 flag ok 22 - No blob corruption with utf-8 flag on ok 23 - bytestring downgraded to bytes ok 24 - bytestring does not have utf-8 flag ok 25 - No blob corruption with utf-8 flag off ok 26 - no warnings ok t/13_create_collation.t .................. 1..25 ok 1 - can't override builtin perl collation ok 2 - can't delete builtin perl collation ok 3 - can't override registered collation ok 4 - overridden collation ok 5 - The object isa DBI::db ok 6 - collate perl (Bergere, Bergèòe, HAT, HOT, berger, bergèòe, ferme, fèöe, féôu, fêôe, hâôer, héòaut, héôaïòe, héôéòoclite, hêôre, hôôe // Bergere, Bergèòe, HAT, HOT, berger, bergèòe, ferme, fèöe, féôu, fêôe, hâôer, héòaut, héôaïòe, héôéòoclite, hêôre, hôôe) ok 7 - collate perllocale (Bergere, Bergèòe, HAT, HOT, berger, bergèòe, ferme, fèöe, féôu, fêôe, hâôer, héòaut, héôaïòe, héôéòoclite, hêôre, hôôe // Bergere, Bergèòe, HAT, HOT, berger, bergèòe, ferme, fèöe, féôu, fêôe, hâôer, héòaut, héôaïòe, héôéòoclite, hêôre, hôôe) ok 8 - collate no_accents (Bergèòe, bergèòe, berger, Bergere, fêôe, fèöe, féôu, ferme, hâôer, HAT, héôaïòe, héòaut, héôéòoclite, hêôre, hôôe, HOT // Bergèòe, bergèòe, berger, Bergere, fêôe, fèöe, féôu, ferme, hâôer, HAT, héôaïòe, héòaut, héôéòoclite, hêôre, hôôe, HOT) ok 9 - collate by_length (HOT, HAT, hôôe, féôu, fêôe, fèöe, hêôre, hâôer, ferme, berger, héòaut, Bergèòe, bergèòe, Bergere, héôaïòe, héôéòoclite // HOT, HAT, hôôe, féôu, fêôe, fèöe, hêôre, hâôer, ferme, berger, héòaut, Bergèòe, bergèòe, Bergere, héôaïòe, héôéòoclite) ok 10 - The object isa DBI::db ok 11 - collate perl (Bergere, Bergèòe, HAT, HOT, berger, bergèòe, ferme, fèöe, féôu, fêôe, hâôer, héòaut, héôaïòe, héôéòoclite, hêôre, hôôe // Bergere, Bergèòe, HAT, HOT, berger, bergèòe, ferme, fèöe, féôu, fêôe, hâôer, héòaut, héôaïòe, héôéòoclite, hêôre, hôôe) ok 12 - collate perllocale (Bergere, Bergèòe, HAT, HOT, berger, bergèòe, ferme, fèöe, féôu, fêôe, hâôer, héòaut, héôaïòe, héôéòoclite, hêôre, hôôe // Bergere, Bergèòe, HAT, HOT, berger, bergèòe, ferme, fèöe, féôu, fêôe, hâôer, héòaut, héôaïòe, héôéòoclite, hêôre, hôôe) ok 13 - collate no_accents (Bergèòe, bergèòe, berger, Bergere, fêôe, fèöe, féôu, ferme, hâôer, HAT, héôaïòe, héòaut, héôéòoclite, hêôre, hôôe, HOT // Bergèòe, bergèòe, berger, Bergere, fêôe, fèöe, féôu, ferme, hâôer, HAT, héôaïòe, héòaut, héôéòoclite, hêôre, hôôe, HOT) ok 14 - collate by_length (HOT, HAT, hôôe, féôu, fêôe, fèöe, hêôre, hâôer, ferme, berger, héòaut, Bergèòe, bergèòe, Bergere, héôaïòe, héôéòoclite // HOT, HAT, hôôe, féôu, fêôe, fèöe, hêôre, hâôer, ferme, berger, héòaut, Bergèòe, bergèòe, Bergere, héôaïòe, héôéòoclite) ok 15 - The object isa DBI::db ok 16 - collate perl (Bergere, Bergèòe, HAT, HOT, berger, bergèòe, ferme, fèöe, féôu, fêôe, hâôer, héòaut, héôaïòe, héôéòoclite, hêôre, hôôe // Bergere, Bergèòe, HAT, HOT, berger, bergèòe, ferme, fèöe, féôu, fêôe, hâôer, héòaut, héôaïòe, héôéòoclite, hêôre, hôôe) ok 17 - collate perllocale (Bergere, Bergèòe, HAT, HOT, berger, bergèòe, ferme, fèöe, féôu, fêôe, hâôer, héòaut, héôaïòe, héôéòoclite, hêôre, hôôe // Bergere, Bergèòe, HAT, HOT, berger, bergèòe, ferme, fèöe, féôu, fêôe, hâôer, héòaut, héôaïòe, héôéòoclite, hêôre, hôôe) ok 18 - collate no_accents (Bergèòe, bergèòe, berger, Bergere, fêôe, fèöe, féôu, ferme, hâôer, HAT, héôaïòe, héòaut, héôéòoclite, hêôre, hôôe, HOT // Bergèòe, bergèòe, berger, Bergere, fêôe, fèöe, féôu, ferme, hâôer, HAT, héôaïòe, héòaut, héôéòoclite, hêôre, hôôe, HOT) ok 19 - collate by_length (HOT, HAT, hôôe, féôu, fêôe, fèöe, hêôre, hâôer, ferme, berger, héòaut, Bergèòe, bergèòe, Bergere, héôaïòe, héôéòoclite // HOT, HAT, hôôe, féôu, fêôe, fèöe, hêôre, hâôer, ferme, berger, héòaut, Bergèòe, bergèòe, Bergere, héôaïòe, héôéòoclite) ok 20 - The object isa DBI::db ok 21 - collate perl (Bergere, Bergèòe, HAT, HOT, berger, bergèòe, ferme, fèöe, féôu, fêôe, hâôer, héòaut, héôaïòe, héôéòoclite, hêôre, hôôe // Bergere, Bergèòe, HAT, HOT, berger, bergèòe, ferme, fèöe, féôu, fêôe, hâôer, héòaut, héôaïòe, héôéòoclite, hêôre, hôôe) ok 22 - collate perllocale (Bergere, Bergèòe, HAT, HOT, berger, bergèòe, ferme, fèöe, féôu, fêôe, hâôer, héòaut, héôaïòe, héôéòoclite, hêôre, hôôe // Bergere, Bergèòe, HAT, HOT, berger, bergèòe, ferme, fèöe, féôu, fêôe, hâôer, héòaut, héôaïòe, héôéòoclite, hêôre, hôôe) ok 23 - collate no_accents (Bergèòe, bergèòe, berger, Bergere, fêôe, fèöe, féôu, ferme, hâôer, HAT, héôaïòe, héòaut, héôéòoclite, hêôre, hôôe, HOT // Bergèòe, bergèòe, berger, Bergere, fêôe, fèöe, féôu, ferme, hâôer, HAT, héôaïòe, héòaut, héôéòoclite, hêôre, hôôe, HOT) ok 24 - collate by_length (HOT, HAT, hôôe, féôu, fêôe, fèöe, hêôre, hâôer, ferme, berger, héòaut, Bergèòe, bergèòe, Bergere, héôaïòe, héôéòoclite // HOT, HAT, hôôe, féôu, fêôe, fèöe, hêôre, hâôer, ferme, berger, héòaut, Bergèòe, bergèòe, Bergere, héôaïòe, héôéòoclite) ok 25 - no warnings ok t/14_progress_handler.t .................. 1..11 ok 1 - The object isa DBI::db ok 2 ok 3 ok 4 ok 5 ok 6 - The object isa DBI::db ok 7 ok 8 ok 9 ok 10 ok 11 - 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..12 ok 1 - Created test table ok 2 - Created temp test table ok 3 - ATTACH DATABASE ":memory:" AS db3 ok 4 - CREATE TABLE db3.three ok 5 - No error creating the table ok 6 - We can get column information ok 7 - We got information on two columns ok 8 - We got the right info in TYPE_NAME ok 9 - We got the right info in COLUMN_NAME ok 10 - We matched information from multiple databases ok 11 - We got the right info from multiple databases ok 12 - 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..21 ok 1 - The object isa DBI::db ok 2 - Create table meta1 ok 3 - Create table meta2 ok 4 - Create table meta3 ok 5 - Get primary_key_info for meta1 ok 6 - Correct primary_key_info returned for meta1 ok 7 - Get primary_key_info for meta2 ok 8 - Correct primary_key_info returned for meta2 ok 9 - Get primary_key_info for meta3 ok 10 - Correct primary_key_info returned for meta3 ok 11 - Create table meta4 ok 12 - Get primary_key_info for meta4 ok 13 - Primary key contains 2 columns ok 14 - Correct primary_key_info returned for meta4 ok 15 - Get primary_key for meta4 ok 16 - Correct primary_key returned for meta4 ok 17 - $sth->{TYPE} array is same length as $sth->{NAME} array not ok 18 - $sth->{TYPE}[0] doesn't return a string # TODO $sth->{TYPE} should return an array of integers. # Failed (TODO) test '$sth->{TYPE}[0] doesn't return a string' # at t/27_metadata.t line 54. # got: 'VARCHAR(2)' # expected: anything else not ok 19 - $sth->{TYPE}[1] doesn't return a string # TODO $sth->{TYPE} should return an array of integers. # Failed (TODO) test '$sth->{TYPE}[1] doesn't return a string' # at t/27_metadata.t line 55. # got: 'CHAR(1)' # expected: anything else not ok 20 - $sth->{TYPE}[0] returns an integer # TODO $sth->{TYPE} should return an array of integers. # Failed (TODO) test '$sth->{TYPE}[0] returns an integer' # at t/27_metadata.t line 56. # 'VARCHAR(2)' # doesn't match '(?-xism:^-?\d+$)' not ok 21 - $sth->{TYPE}[1] returns an integer # TODO $sth->{TYPE} should return an array of integers. # Failed (TODO) test '$sth->{TYPE}[1] returns an integer' # at t/27_metadata.t line 57. # 'CHAR(1)' # doesn't match '(?-xism:^-?\d+$)' 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..10 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 4 - dbdimp.h has no C++ comments ok 5 - fts3_tokenizer.h has no C++ comments ok 6 - ppport.h is not ours to be tested ok 7 - sqlite3.h has no C++ comments ok 8 - sqlite3ext.h has no C++ comments ok 9 - SQLiteXS.h has no C++ comments ok 10 - SQLite.xs 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..27 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/co9CHViqev/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/co9CHViqev/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/co9CHViqev/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/co9CHViqev/¿¿¿ ¿¿¿¿¿¿.db ok 25 - The object isa DBI::db ok 26 - Could connect to temp database (empty filename) ok 27 - no warnings ok t/34_online_backup.t ..................... 1..13 ok 1 - The object isa DBI::db ok 2 ok 3 - Found our process ID in backed-up table ok 4 ok 5 - The object isa DBI::db ok 6 - Found our process ID in table back on disk ok 7 - The object isa DBI::db ok 8 ok 9 - Found our process ID in backed-up table ok 10 ok 11 - The object isa DBI::db ok 12 - Found our process ID in table back on disk ok 13 - no warnings ok t/35_table_info.t ........................ 1..18 ok 1 - The object isa DBI::db ok 2 - We can get table/schema information ok 3 - Correct table/schema information ok 4 - CREATE TABLE one ok 5 - CREATE TEMP TABLE two ok 6 - ATTACH DATABASE ":memory:" AS db3 ok 7 - CREATE TABLE db3.three ok 8 - Correct table_info for "one" ok 9 - Correct table_info for "main"."one" ok 10 - Correct table_info for "two" ok 11 - Correct table_info for "temp"."two" ok 12 - Correct table_info for "three" ok 13 - Correct table_info for "db3"."three" ok 14 - CREATE TABLE db3.one ok 15 - Correct table_info for both tables named "one" ok 16 - Correct table_info for the system tables ok 17 - Correct table_info for all tables ok 18 - no warnings ok t/36_hooks.t ............................. 1..49 ok 1 - The object isa DBI::db ok 2 - initial commit hook was undef ok 3 - initial rollback hook was undef ok 4 - initial update hook was undef ok 5 - 3 commits ok 6 - 30 updates ok 7 - update hook arg 0: INSERT ok 8 - update hook arg 1: database ok 9 - update hook arg 2: table ok 10 - update hook arg 3: rowid ok 11 - previous commit hook correctly returned ok 12 - previous update hook correctly returned ok 13 - commit hook unregistered ok 14 - update hook unregistered ok 15 - no warnings ok 16 - transaction was rejected: DBD::SQLite::db commit failed: constraint failed at t/36_hooks.t line 152. # ok 17 - 1 rollback ok 18 - previous hook correctly returned ok 19 - rollback hook unregistered ok 20 - no rows added ok 21 - args to authorizer (INSERT) ok 22 - delete was rejected with message DBD::SQLite::db do failed: not authorized at t/36_hooks.t line 124. # ok 23 - args to authorizer (DELETE) ok 24 - delete was accepted ok 25 - The object isa DBI::db ok 26 - initial commit hook was undef ok 27 - initial rollback hook was undef ok 28 - initial update hook was undef ok 29 - 3 commits ok 30 - 30 updates ok 31 - update hook arg 0: INSERT ok 32 - update hook arg 1: database ok 33 - update hook arg 2: table ok 34 - update hook arg 3: rowid ok 35 - previous commit hook correctly returned ok 36 - previous update hook correctly returned ok 37 - commit hook unregistered ok 38 - update hook unregistered ok 39 - no warnings ok 40 - transaction was rejected: DBD::SQLite::db commit failed: constraint failed at t/36_hooks.t line 152. # ok 41 - 1 rollback ok 42 - previous hook correctly returned ok 43 - rollback hook unregistered ok 44 - no rows added ok 45 - args to authorizer (INSERT) ok 46 - delete was rejected with message DBD::SQLite::db do failed: not authorized at t/36_hooks.t line 124. # ok 47 - args to authorizer (DELETE) ok 48 - delete was accepted ok 49 - no warnings ok t/37_regexp.t ............................ 1..21 ok 1 - The object isa DBI::db ok 2 - REGEXP '^b\w+' ok 3 - NOT REGEXP '^b\w+' ok 4 - REGEXP '(?i:^b\w+)' ok 5 - NOT REGEXP '(?i:^b\w+)' ok 6 - The object isa DBI::db ok 7 - REGEXP '^b\w+' ok 8 - NOT REGEXP '^b\w+' ok 9 - REGEXP '(?i:^b\w+)' ok 10 - NOT REGEXP '(?i:^b\w+)' ok 11 - The object isa DBI::db ok 12 - REGEXP '^b\w+' ok 13 - NOT REGEXP '^b\w+' ok 14 - REGEXP '(?i:^b\w+)' ok 15 - NOT REGEXP '(?i:^b\w+)' ok 16 - The object isa DBI::db ok 17 - REGEXP '^b\w+' ok 18 - NOT REGEXP '^b\w+' ok 19 - REGEXP '(?i:^b\w+)' ok 20 - NOT REGEXP '(?i:^b\w+)' ok 21 - no warnings ok t/38_empty_statement.t ................... 1..8 ok 1 - The object isa DBI::db ok 2 - empty statement does not spit a warning ok 3 - empty statement does not spit a warning ok 4 - empty statement does not spit a warning ok 5 - empty statement does not spit a warning ok 6 - empty statement does not spit a warning ok 7 - undef statement does not spit a warning, and does not die anyway ok 8 - no warnings ok t/39_foreign_keys.t ...................... 1..17 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 ok 17 - no warnings ok t/40_multiple_statements.t ............... 1..21 ok 1 - The object isa DBI::db ok 2 - do succeeds anyway ok 3 - but got nothing as the inserts were discarded ok 4 - The object isa DBI::db ok 5 - allows multiple statements ok 6 - do succeeds anyway ok 7 - and got the inserted values ok 8 - The object isa DBI::db ok 9 - allows multiple statements ok 10 - executed multiple statements successfully ok 11 - and got the inserted values ok 12 - The object isa DBI::db ok 13 - allows multiple statements ok 14 - do succeeds anyway ok 15 - and got the inserted values ok 16 - The object isa DBI::db ok 17 - allows multiple statements ok 18 - executed multiple statements successfully ok 19 - executed multiple statements successfully ok 20 - and got the inserted values ok 21 - no warnings ok t/41_placeholders.t ...................... 1..9 ok 1 - The object isa DBI::db ok 2 ok 3 ok 4 ok 5 ok 6 ok 7 ok 8 ok 9 - no warnings ok t/42_primary_key_info.t .................. 1..26 ok 1 - The object isa DBI::db ok 2 ok 3 ok 4 ok 5 ok 6 - The object isa DBI::db ok 7 ok 8 ok 9 ok 10 ok 11 - The object isa DBI::db ok 12 ok 13 ok 14 ok 15 ok 16 - The object isa DBI::db ok 17 ok 18 ok 19 ok 20 ok 21 - The object isa DBI::db ok 22 ok 23 ok 24 ok 25 ok 26 - no warnings ok t/43_fts3.t .............................. 1..19 ok 1 - The object isa DBI::db ok 2 - bergère (unicode is 0) ok 3 - berg* (unicode is 0) ok 4 - foobar (unicode is 0) ok 5 - moutons (unicode is 0) ok 6 - "qui gardait" (unicode is 0) ok 7 - moutons NOT lait (unicode is 0) ok 8 - il était (unicode is 0) ok 9 - (il OR elle) AND un* (unicode is 0) ok 10 - The object isa DBI::db ok 11 - bergère (unicode is 1) ok 12 - berg* (unicode is 1) ok 13 - foobar (unicode is 1) ok 14 - moutons (unicode is 1) ok 15 - "qui gardait" (unicode is 1) ok 16 - moutons NOT lait (unicode is 1) ok 17 - il était (unicode is 1) ok 18 - (il OR elle) AND un* (unicode is 1) ok 19 - no warnings 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..31 ok 1 - The object isa DBI::db ok 2 ok 3 - CREATE TABLE ok 4 - INSERT ok 5 - unicode upcase ok ok 6 - DELETE ok ok 7 - INSERT ok 8 - unicode upcase ok ok 9 - DELETE ok ok 10 - INSERT ok 11 - unicode upcase ok ok 12 - DELETE ok ok 13 - INSERT ok 14 - unicode upcase ok ok 15 - DELETE ok ok 16 - The object isa DBI::db ok 17 ok 18 - CREATE TABLE ok 19 - INSERT ok 20 - unicode upcase ok ok 21 - DELETE ok ok 22 - INSERT ok 23 - unicode upcase ok ok 24 - DELETE ok ok 25 - INSERT ok 26 - unicode upcase ok ok 27 - DELETE ok ok 28 - INSERT ok 29 - unicode upcase ok ok 30 - DELETE ok ok 31 - 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] 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] 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: constraint 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 t/rt_48393_debug_panic_with_commit.t ..... skipped: set $ENV{TEST_DBD_SQLITE_WITH_DEBUGGER} to enable this test t/rt_50503_fts3.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_52573_manual_exclusive_lock.t ....... 1..370 ok 1 - The object isa DBI::db ok 2 - AutoCommit is on ok 3 - BegunWork is off ok 4 - a statement works ok 5 - AutoCommit is still on ok 6 - BegunWork is still off ok 7 - begin_work works ok 8 - AutoCommit is turned off ok 9 - BegunWork is turned on ok 10 - but second begin_work should fail ok 11 - other statement should work ok 12 - rolled back/committed ok 13 - AutoCommit is turned on ok 14 - BegunWork is turned off ok 15 - begin_work works ok 16 - AutoCommit is turned off ok 17 - BegunWork is turned on ok 18 - first BEGIN should be passed through ok 19 - second BEGIN should fail ok 20 - and second begin_work also should fail ok 21 - other statement should work ok 22 - rolled back/committed ok 23 - AutoCommit is turned on now ok 24 - BegunWork is turned off ok 25 - begin_work works ok 26 - AutoCommit is turned off ok 27 - BegunWork is turned on ok 28 - statement should work ok 29 - BEGIN after other statements should fail ok 30 - and second begin_work also should fail ok 31 - other statement should work ok 32 - rolled back/committed ok 33 - AutoCommit is turned on now ok 34 - BegunWork is turned off ok 35 - AutoCommit is on ok 36 - BegunWork is off ok 37 - BEGIN should work ok 38 - AutoCommit is turned off ok 39 - BegunWork is turned on ok 40 - second BEGIN should fail ok 41 - other statement should work ok 42 - rolled back/committed ok 43 - AutoCommit is turned on now ok 44 - BegunWork is turned off ok 45 - AutoCommit is on ok 46 - BegunWork is off ok 47 - BEGIN should work ok 48 - AutoCommit is turned off ok 49 - BegunWork is turned on ok 50 - second BEGIN should fail ok 51 - and second begin_work also should fail ok 52 - other statement should work ok 53 - rolled back/committed ok 54 - AutoCommit is turned on now ok 55 - BegunWork is turned off ok 56 - AutoCommit is on ok 57 - BegunWork is off ok 58 - AutoCommit is turned off ok 59 - BegunWork is still off ok 60 - BEGIN should work ok 61 - AutoCommit is turned off ok 62 - BegunWork is still off ok 63 - second BEGIN should fail ok 64 - and begin_work also should fail ok 65 - other statement should work ok 66 - rolled back/committed ok 67 - AutoCommit is still off ok 68 - BegunWork is still off ok 69 - AutoCommit is on ok 70 - BegunWork is off ok 71 - AutoCommit is turned off ok 72 - BegunWork is still off ok 73 - begin_work should fail ok 74 - AutoCommit is still off ok 75 - BegunWork is still off ok 76 - BEGIN should work ok 77 - AutoCommit is still off ok 78 - BegunWork is still off ok 79 - and second begin_work also should fail ok 80 - other statement should work ok 81 - rolled back/committed ok 82 - AutoCommit is still off ok 83 - BegunWork is still off ok 84 - AutoCommit is on ok 85 - BegunWork is off ok 86 - AutoCommit is turned off ok 87 - BegunWork is still off ok 88 - other statement should work ok 89 - AutoCommit is still off ok 90 - BegunWork is still off ok 91 - rolled back/committed ok 92 - AutoCommit is still off ok 93 - BegunWork is still off ok 94 - AutoCommit is on ok 95 - BegunWork is off ok 96 - a statement works ok 97 - AutoCommit is still on ok 98 - BegunWork is still off ok 99 - begin_work works ok 100 - AutoCommit is turned off ok 101 - BegunWork is turned on ok 102 - but second begin_work should fail ok 103 - other statement should work ok 104 - rolled back/committed ok 105 - AutoCommit is turned on ok 106 - BegunWork is turned off ok 107 - begin_work works ok 108 - AutoCommit is turned off ok 109 - BegunWork is turned on ok 110 - first BEGIN should be passed through ok 111 - second BEGIN should fail ok 112 - and second begin_work also should fail ok 113 - other statement should work ok 114 - rolled back/committed ok 115 - AutoCommit is turned on now ok 116 - BegunWork is turned off ok 117 - begin_work works ok 118 - AutoCommit is turned off ok 119 - BegunWork is turned on ok 120 - statement should work ok 121 - BEGIN after other statements should fail ok 122 - and second begin_work also should fail ok 123 - other statement should work ok 124 - rolled back/committed ok 125 - AutoCommit is turned on now ok 126 - BegunWork is turned off ok 127 - AutoCommit is on ok 128 - BegunWork is off ok 129 - BEGIN should work ok 130 - AutoCommit is turned off ok 131 - BegunWork is turned on ok 132 - second BEGIN should fail ok 133 - other statement should work ok 134 - rolled back/committed ok 135 - AutoCommit is turned on now ok 136 - BegunWork is turned off ok 137 - AutoCommit is on ok 138 - BegunWork is off ok 139 - BEGIN should work ok 140 - AutoCommit is turned off ok 141 - BegunWork is turned on ok 142 - second BEGIN should fail ok 143 - and second begin_work also should fail ok 144 - other statement should work ok 145 - rolled back/committed ok 146 - AutoCommit is turned on now ok 147 - BegunWork is turned off ok 148 - AutoCommit is on ok 149 - BegunWork is off ok 150 - AutoCommit is turned off ok 151 - BegunWork is still off ok 152 - BEGIN should work ok 153 - AutoCommit is turned off ok 154 - BegunWork is still off ok 155 - second BEGIN should fail ok 156 - and begin_work also should fail ok 157 - other statement should work ok 158 - rolled back/committed ok 159 - AutoCommit is still off ok 160 - BegunWork is still off ok 161 - AutoCommit is on ok 162 - BegunWork is off ok 163 - AutoCommit is turned off ok 164 - BegunWork is still off ok 165 - begin_work should fail ok 166 - AutoCommit is still off ok 167 - BegunWork is still off ok 168 - BEGIN should work ok 169 - AutoCommit is still off ok 170 - BegunWork is still off ok 171 - and second begin_work also should fail ok 172 - other statement should work ok 173 - rolled back/committed ok 174 - AutoCommit is still off ok 175 - BegunWork is still off ok 176 - AutoCommit is on ok 177 - BegunWork is off ok 178 - AutoCommit is turned off ok 179 - BegunWork is still off ok 180 - other statement should work ok 181 - AutoCommit is still off ok 182 - BegunWork is still off ok 183 - rolled back/committed ok 184 - AutoCommit is still off ok 185 - BegunWork is still off ok 186 - AutoCommit is on ok 187 - BegunWork is off ok 188 - a statement works ok 189 - AutoCommit is still on ok 190 - BegunWork is still off ok 191 - begin_work works ok 192 - AutoCommit is turned off ok 193 - BegunWork is turned on ok 194 - but second begin_work should fail ok 195 - other statement should work ok 196 - rolled back/committed ok 197 - AutoCommit is turned on ok 198 - BegunWork is turned off ok 199 - begin_work works ok 200 - AutoCommit is turned off ok 201 - BegunWork is turned on ok 202 - first BEGIN should be passed through ok 203 - second BEGIN should fail ok 204 - and second begin_work also should fail ok 205 - other statement should work ok 206 - rolled back/committed ok 207 - AutoCommit is turned on now ok 208 - BegunWork is turned off ok 209 - begin_work works ok 210 - AutoCommit is turned off ok 211 - BegunWork is turned on ok 212 - statement should work ok 213 - BEGIN after other statements should fail ok 214 - and second begin_work also should fail ok 215 - other statement should work ok 216 - rolled back/committed ok 217 - AutoCommit is turned on now ok 218 - BegunWork is turned off ok 219 - AutoCommit is on ok 220 - BegunWork is off ok 221 - BEGIN should work ok 222 - AutoCommit is turned off ok 223 - BegunWork is turned on ok 224 - second BEGIN should fail ok 225 - other statement should work ok 226 - rolled back/committed ok 227 - AutoCommit is turned on now ok 228 - BegunWork is turned off ok 229 - AutoCommit is on ok 230 - BegunWork is off ok 231 - BEGIN should work ok 232 - AutoCommit is turned off ok 233 - BegunWork is turned on ok 234 - second BEGIN should fail ok 235 - and second begin_work also should fail ok 236 - other statement should work ok 237 - rolled back/committed ok 238 - AutoCommit is turned on now ok 239 - BegunWork is turned off ok 240 - AutoCommit is on ok 241 - BegunWork is off ok 242 - AutoCommit is turned off ok 243 - BegunWork is still off ok 244 - BEGIN should work ok 245 - AutoCommit is turned off ok 246 - BegunWork is still off ok 247 - second BEGIN should fail ok 248 - and begin_work also should fail ok 249 - other statement should work ok 250 - rolled back/committed ok 251 - AutoCommit is still off ok 252 - BegunWork is still off ok 253 - AutoCommit is on ok 254 - BegunWork is off ok 255 - AutoCommit is turned off ok 256 - BegunWork is still off ok 257 - begin_work should fail ok 258 - AutoCommit is still off ok 259 - BegunWork is still off ok 260 - BEGIN should work ok 261 - AutoCommit is still off ok 262 - BegunWork is still off ok 263 - and second begin_work also should fail ok 264 - other statement should work ok 265 - rolled back/committed ok 266 - AutoCommit is still off ok 267 - BegunWork is still off ok 268 - AutoCommit is on ok 269 - BegunWork is off ok 270 - AutoCommit is turned off ok 271 - BegunWork is still off ok 272 - other statement should work ok 273 - AutoCommit is still off ok 274 - BegunWork is still off ok 275 - rolled back/committed ok 276 - AutoCommit is still off ok 277 - BegunWork is still off ok 278 - AutoCommit is on ok 279 - BegunWork is off ok 280 - a statement works ok 281 - AutoCommit is still on ok 282 - BegunWork is still off ok 283 - begin_work works ok 284 - AutoCommit is turned off ok 285 - BegunWork is turned on ok 286 - but second begin_work should fail ok 287 - other statement should work ok 288 - rolled back/committed ok 289 - AutoCommit is turned on ok 290 - BegunWork is turned off ok 291 - begin_work works ok 292 - AutoCommit is turned off ok 293 - BegunWork is turned on ok 294 - first BEGIN should be passed through ok 295 - second BEGIN should fail ok 296 - and second begin_work also should fail ok 297 - other statement should work ok 298 - rolled back/committed ok 299 - AutoCommit is turned on now ok 300 - BegunWork is turned off ok 301 - begin_work works ok 302 - AutoCommit is turned off ok 303 - BegunWork is turned on ok 304 - statement should work ok 305 - BEGIN after other statements should fail ok 306 - and second begin_work also should fail ok 307 - other statement should work ok 308 - rolled back/committed ok 309 - AutoCommit is turned on now ok 310 - BegunWork is turned off ok 311 - AutoCommit is on ok 312 - BegunWork is off ok 313 - BEGIN should work ok 314 - AutoCommit is turned off ok 315 - BegunWork is turned on ok 316 - second BEGIN should fail ok 317 - other statement should work ok 318 - rolled back/committed ok 319 - AutoCommit is turned on now ok 320 - BegunWork is turned off ok 321 - AutoCommit is on ok 322 - BegunWork is off ok 323 - BEGIN should work ok 324 - AutoCommit is turned off ok 325 - BegunWork is turned on ok 326 - second BEGIN should fail ok 327 - and second begin_work also should fail ok 328 - other statement should work ok 329 - rolled back/committed ok 330 - AutoCommit is turned on now ok 331 - BegunWork is turned off ok 332 - AutoCommit is on ok 333 - BegunWork is off ok 334 - AutoCommit is turned off ok 335 - BegunWork is still off ok 336 - BEGIN should work ok 337 - AutoCommit is turned off ok 338 - BegunWork is still off ok 339 - second BEGIN should fail ok 340 - and begin_work also should fail ok 341 - other statement should work ok 342 - rolled back/committed ok 343 - AutoCommit is still off ok 344 - BegunWork is still off ok 345 - AutoCommit is on ok 346 - BegunWork is off ok 347 - AutoCommit is turned off ok 348 - BegunWork is still off ok 349 - begin_work should fail ok 350 - AutoCommit is still off ok 351 - BegunWork is still off ok 352 - BEGIN should work ok 353 - AutoCommit is still off ok 354 - BegunWork is still off ok 355 - and second begin_work also should fail ok 356 - other statement should work ok 357 - rolled back/committed ok 358 - AutoCommit is still off ok 359 - BegunWork is still off ok 360 - AutoCommit is on ok 361 - BegunWork is off ok 362 - AutoCommit is turned off ok 363 - BegunWork is still off ok 364 - other statement should work ok 365 - AutoCommit is still off ok 366 - BegunWork is still off ok 367 - rolled back/committed ok 368 - AutoCommit is still off ok 369 - BegunWork is still off ok 370 - no warnings ok t/rt_53235_icu_compatibility.t ........... skipped: requires SQLite ICU plugin to be enabled All tests successful. Files=59, Tests=1308, 22 wallclock secs ( 1.09 usr 1.05 sys + 11.26 cusr 2.90 csys = 16.30 CPU) Result: PASS ADAMK/DBD-SQLite-1.31.tar.gz make test TEST_VERBOSE=1 -- OK Adam Kennedy <adamk@cpan.org> Self Contained SQLite RDBMS in a DBI Driver >>> (cd /Users/fly1200/var/cpan/build/DBD-SQLite-1.31-pKxJO3 && tar cvf - DBD-SQLite-1.31.ppd blib) | gzip -c >/Users/fly1200/var/REPO/A/AD/ADAMK/DBD-SQLite-1.31.tar.gz DBD-SQLite-1.31.ppd blib/ 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.bundle blib/lib/ blib/lib/auto/ blib/lib/auto/share/ blib/lib/auto/share/dist/ blib/lib/auto/share/dist/DBD-SQLite/ blib/lib/auto/share/dist/DBD-SQLite/sqlite3.c blib/lib/auto/share/dist/DBD-SQLite/sqlite3.h blib/lib/DBD/ blib/lib/DBD/SQLite/ blib/lib/DBD/SQLite/Cookbook.pod blib/lib/DBD/SQLite.pm blib/man3/ blib/man3/DBD::SQLite.3 blib/man3/DBD::SQLite::Cookbook.3 >>> mv /Users/fly1200/var/cpan/build/DBD-SQLite-1.31-pKxJO3/DBD-SQLite-1.31.ppd /Users/fly1200/var/REPO/A/AD/ADAMK Finished 2010-09-16T12:24:17