PATH=/home/fly2000/bin:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/games:/home/fly2000/var/megalib/bin Start 2014-10-14T14:18:56 ActivePerl-2000 CPAN-2.00 Reading '/home/fly2000/var/cpan/Metadata' Database was generated on Tue, 14 Oct 2014 19:29:02 GMT Running make for T/TU/TURNSTEP/DBD-Pg-3.4.2.tar.gz Fetching with LWP: http://cpan.nas1.activestate.com/authors/id/T/TU/TURNSTEP/DBD-Pg-3.4.2.tar.gz Fetching with LWP: http://cpan.nas1.activestate.com/authors/id/T/TU/TURNSTEP/CHECKSUMS Checksum for /home/fly2000/var/cpan/sources/authors/id/T/TU/TURNSTEP/DBD-Pg-3.4.2.tar.gz ok DBD-Pg-3.4.2/ DBD-Pg-3.4.2/TODO DBD-Pg-3.4.2/MANIFEST.SKIP DBD-Pg-3.4.2/dbdimp.h DBD-Pg-3.4.2/Pg.h DBD-Pg-3.4.2/LICENSES/ DBD-Pg-3.4.2/LICENSES/artistic.txt DBD-Pg-3.4.2/LICENSES/gpl-2.0.txt DBD-Pg-3.4.2/testme.tmp.pl DBD-Pg-3.4.2/quote.h DBD-Pg-3.4.2/dbdimp.c DBD-Pg-3.4.2/win32.mak DBD-Pg-3.4.2/types.c DBD-Pg-3.4.2/.perlcriticrc DBD-Pg-3.4.2/Pg.xs DBD-Pg-3.4.2/Changes DBD-Pg-3.4.2/MANIFEST DBD-Pg-3.4.2/lib/ DBD-Pg-3.4.2/lib/Bundle/ DBD-Pg-3.4.2/lib/Bundle/DBD/ DBD-Pg-3.4.2/lib/Bundle/DBD/Pg.pm DBD-Pg-3.4.2/t/ DBD-Pg-3.4.2/t/00basic.t DBD-Pg-3.4.2/t/03smethod.t DBD-Pg-3.4.2/t/00_signature.t DBD-Pg-3.4.2/t/07copy.t DBD-Pg-3.4.2/t/30unicode.t DBD-Pg-3.4.2/t/08async.t DBD-Pg-3.4.2/t/12placeholders.t DBD-Pg-3.4.2/t/20savepoints.t DBD-Pg-3.4.2/t/lib/ DBD-Pg-3.4.2/t/lib/App/ DBD-Pg-3.4.2/t/lib/App/Info/ DBD-Pg-3.4.2/t/lib/App/Info/Handler.pm DBD-Pg-3.4.2/t/lib/App/Info/RDBMS.pm DBD-Pg-3.4.2/t/lib/App/Info/Request.pm DBD-Pg-3.4.2/t/lib/App/Info/RDBMS/ DBD-Pg-3.4.2/t/lib/App/Info/RDBMS/PostgreSQL.pm DBD-Pg-3.4.2/t/lib/App/Info/Handler/ DBD-Pg-3.4.2/t/lib/App/Info/Handler/Prompt.pm DBD-Pg-3.4.2/t/lib/App/Info/Handler/Print.pm DBD-Pg-3.4.2/t/lib/App/Info/Util.pm DBD-Pg-3.4.2/t/lib/App/Info.pm DBD-Pg-3.4.2/t/01connect.t DBD-Pg-3.4.2/t/04misc.t DBD-Pg-3.4.2/t/06bytea.t DBD-Pg-3.4.2/t/99cleanup.t DBD-Pg-3.4.2/t/03dbmethod.t DBD-Pg-3.4.2/t/09arrays.t DBD-Pg-3.4.2/t/01constants.t DBD-Pg-3.4.2/t/dbdpg_test_setup.pl DBD-Pg-3.4.2/t/02attribs.t DBD-Pg-3.4.2/README DBD-Pg-3.4.2/Makefile.PL DBD-Pg-3.4.2/Pg.pm DBD-Pg-3.4.2/SIGNATURE DBD-Pg-3.4.2/README.dev DBD-Pg-3.4.2/quote.c DBD-Pg-3.4.2/META.yml DBD-Pg-3.4.2/types.h DBD-Pg-3.4.2/dbivport.h DBD-Pg-3.4.2/README.win32 CPAN.pm: Building T/TU/TURNSTEP/DBD-Pg-3.4.2.tar.gz >>> /home/fly2000/ap2000-298540/bin/perl-static Makefile.PL Configuring DBD::Pg 3.4.2 PostgreSQL version: 90104 (default port: 5432) POSTGRES_HOME: (not set) POSTGRES_INCLUDE: /usr/include/postgresql POSTGRES_LIB: /usr/lib OS: linux Checking if your kit is complete... Looks good Using DBI 1.631 (for perl 5.020001 on x86_64-linux-thread-multi) installed in /home/fly2000/ap2000-298540/lib/auto/DBI/ Generating a Unix-style Makefile Writing Makefile for DBD::Pg Writing MYMETA.yml and MYMETA.json >>> make cp Pg.pm blib/lib/DBD/Pg.pm cp lib/Bundle/DBD/Pg.pm blib/lib/Bundle/DBD/Pg.pm Running Mkbootstrap for DBD::Pg () chmod 644 Pg.bs /home/fly2000/ap2000-298540/bin/perl-static -p -e "s/~DRIVER~/Pg/g; s/^do\(/dontdo\(/" /home/fly2000/ap2000-298540/lib/auto/DBI/Driver.xst > Pg.xsi /home/fly2000/ap2000-298540/bin/perl-static /home/fly2000/var/megalib/ExtUtils/xsubpp -typemap /home/fly2000/ap2000-298540/lib/ExtUtils/typemap Pg.xs > Pg.xsc && mv Pg.xsc Pg.c gcc -c -I/usr/include/postgresql -I/home/fly2000/ap2000-298540/lib/auto/DBI -D_REENTRANT -D_GNU_SOURCE -DUSE_SITECUSTOMIZE -DPERL_RELOCATABLE_INCPUSH -fno-merge-constants -fwrapv -fno-strict-aliasing -pipe -fstack-protector -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -DPGLIBVERSION=90104 -DPGDEFPORT=5432 -O2 -DPERL_EXTMALLOC_DEF -Dmalloc=Perl_malloc -Dfree=Perl_mfree -Drealloc=Perl_realloc -Dcalloc=Perl_calloc -DVERSION=\"3.4.2\" -DXS_VERSION=\"3.4.2\" -fPIC "-I/home/fly2000/ap2000-298540/lib/CORE" Pg.c gcc -c -I/usr/include/postgresql -I/home/fly2000/ap2000-298540/lib/auto/DBI -D_REENTRANT -D_GNU_SOURCE -DUSE_SITECUSTOMIZE -DPERL_RELOCATABLE_INCPUSH -fno-merge-constants -fwrapv -fno-strict-aliasing -pipe -fstack-protector -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -DPGLIBVERSION=90104 -DPGDEFPORT=5432 -O2 -DPERL_EXTMALLOC_DEF -Dmalloc=Perl_malloc -Dfree=Perl_mfree -Drealloc=Perl_realloc -Dcalloc=Perl_calloc -DVERSION=\"3.4.2\" -DXS_VERSION=\"3.4.2\" -fPIC "-I/home/fly2000/ap2000-298540/lib/CORE" dbdimp.c gcc -c -I/usr/include/postgresql -I/home/fly2000/ap2000-298540/lib/auto/DBI -D_REENTRANT -D_GNU_SOURCE -DUSE_SITECUSTOMIZE -DPERL_RELOCATABLE_INCPUSH -fno-merge-constants -fwrapv -fno-strict-aliasing -pipe -fstack-protector -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -DPGLIBVERSION=90104 -DPGDEFPORT=5432 -O2 -DPERL_EXTMALLOC_DEF -Dmalloc=Perl_malloc -Dfree=Perl_mfree -Drealloc=Perl_realloc -Dcalloc=Perl_calloc -DVERSION=\"3.4.2\" -DXS_VERSION=\"3.4.2\" -fPIC "-I/home/fly2000/ap2000-298540/lib/CORE" quote.c gcc -c -I/usr/include/postgresql -I/home/fly2000/ap2000-298540/lib/auto/DBI -D_REENTRANT -D_GNU_SOURCE -DUSE_SITECUSTOMIZE -DPERL_RELOCATABLE_INCPUSH -fno-merge-constants -fwrapv -fno-strict-aliasing -pipe -fstack-protector -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -DPGLIBVERSION=90104 -DPGDEFPORT=5432 -O2 -DPERL_EXTMALLOC_DEF -Dmalloc=Perl_malloc -Dfree=Perl_mfree -Drealloc=Perl_realloc -Dcalloc=Perl_calloc -DVERSION=\"3.4.2\" -DXS_VERSION=\"3.4.2\" -fPIC "-I/home/fly2000/ap2000-298540/lib/CORE" types.c rm -f blib/arch/auto/DBD/Pg/Pg.so LD_RUN_PATH="/usr/lib" gcc -shared -O2 -fstack-protector Pg.o dbdimp.o quote.o types.o -o blib/arch/auto/DBD/Pg/Pg.so \ -L/usr/lib -lpq -lm \ chmod 755 blib/arch/auto/DBD/Pg/Pg.so /home/fly2000/ap2000-298540/bin/perl-static -MExtUtils::Command::MM -e 'cp_nonempty' -- Pg.bs blib/arch/auto/DBD/Pg/Pg.bs 644 Manifying blib/man3/DBD::Pg.3 Manifying blib/man3/Bundle::DBD::Pg.3 TURNSTEP/DBD-Pg-3.4.2.tar.gz make -- OK Running make test >>> make test TEST_VERBOSE=1 Running Mkbootstrap for DBD::Pg () chmod 644 Pg.bs PGINITDB="/usr/lib/postgresql/9.1/bin/initdb" PERL_DL_NONLAZY=1 /home/fly2000/ap2000-298540/bin/perl-static "-MExtUtils::Command::MM" "-MTest::Harness" "-e" "undef *Test::Harness::Switches; test_harness(1, 'blib/lib', 'blib/arch')" t/*.t t/00_signature.t .... skipped: Set the environment variable TEST_SIGNATURE to enable this test t/00basic.t ......... 1..3 ok 1 - use DBI; ok 2 - use DBD::Pg; ok 3 - Found DBD::Pg::VERSION as "3.4.2" ok Please wait, creating new database for testing # # DBI Version 1.631 # DBD::Pg Version 3.4.2 # Perl Version 5.20.1 # OS linux # PostgreSQL (compiled) 90104 # PostgreSQL (target) 90104 # PostgreSQL (reported) PostgreSQL 9.1.4 on x86_64-unknown-linux-gnu, compiled by gcc (Ubuntu/Linaro 4.6.3-1ubuntu5) 4.6.3, 64-bit # Default port 5432 # DBI_DSN dbi:Pg:db="postgres";port=5440;host=/dbdpg_test_database/data/socket # DBI_USER postgres # Test schema dbd_pg_testschema # LANG C # array_nulls on # backslash_quote safe_encoding # client_encoding UTF8 # server_encoding UTF8 # standard_conforming_strings on # Adjusted: initdb t/01connect.t ....... 1..15 ok 1 - Established a connection to the database ok 2 - Disconnect from the database ok 3 - Second database connection attempt worked ok 4 - Connected with second database handle ok 5 - Disconnect with first database handle ok 6 - Disconnect with second database handle ok 7 - Disconnect again with second database handle ok 8 - Execute fails on a disconnected statement ok 9 - Connect with invalid option fails ok 10 - Connect using string 'db' works ok 11 - Connect using string 'dbname' works ok 12 - Connect using string 'database' works ok 13 - Connect with forced uppercase 'DBI:' works ok 14 - Connect with mixed case 'DbI:' works ok 15 - Connect using a quoted database argument ok t/01constants.t ..... ok 1 - PG_ABSTIME returns correct value ok 2 - PG_ABSTIMEARRAY returns correct value ok 3 - PG_ACLITEM returns correct value ok 4 - PG_ACLITEMARRAY returns correct value ok 5 - PG_ANY returns correct value ok 6 - PG_ANYARRAY returns correct value ok 7 - PG_ANYELEMENT returns correct value ok 8 - PG_ANYENUM returns correct value ok 9 - PG_ANYNONARRAY returns correct value ok 10 - PG_ANYRANGE returns correct value ok 11 - PG_BIT returns correct value ok 12 - PG_BITARRAY returns correct value ok 13 - PG_BOOL returns correct value ok 14 - PG_BOOLARRAY returns correct value ok 15 - PG_BOX returns correct value ok 16 - PG_BOXARRAY returns correct value ok 17 - PG_BPCHAR returns correct value ok 18 - PG_BPCHARARRAY returns correct value ok 19 - PG_BYTEA returns correct value ok 20 - PG_BYTEAARRAY returns correct value ok 21 - PG_CHAR returns correct value ok 22 - PG_CHARARRAY returns correct value ok 23 - PG_CID returns correct value ok 24 - PG_CIDARRAY returns correct value ok 25 - PG_CIDR returns correct value ok 26 - PG_CIDRARRAY returns correct value ok 27 - PG_CIRCLE returns correct value ok 28 - PG_CIRCLEARRAY returns correct value ok 29 - PG_CSTRING returns correct value ok 30 - PG_CSTRINGARRAY returns correct value ok 31 - PG_DATE returns correct value ok 32 - PG_DATEARRAY returns correct value ok 33 - PG_DATERANGE returns correct value ok 34 - PG_DATERANGEARRAY returns correct value ok 35 - PG_EVENT_TRIGGER returns correct value ok 36 - PG_FDW_HANDLER returns correct value ok 37 - PG_FLOAT4 returns correct value ok 38 - PG_FLOAT4ARRAY returns correct value ok 39 - PG_FLOAT8 returns correct value ok 40 - PG_FLOAT8ARRAY returns correct value ok 41 - PG_GTSVECTOR returns correct value ok 42 - PG_GTSVECTORARRAY returns correct value ok 43 - PG_INET returns correct value ok 44 - PG_INETARRAY returns correct value ok 45 - PG_INT2 returns correct value ok 46 - PG_INT2ARRAY returns correct value ok 47 - PG_INT2VECTOR returns correct value ok 48 - PG_INT2VECTORARRAY returns correct value ok 49 - PG_INT4 returns correct value ok 50 - PG_INT4ARRAY returns correct value ok 51 - PG_INT4RANGE returns correct value ok 52 - PG_INT4RANGEARRAY returns correct value ok 53 - PG_INT8 returns correct value ok 54 - PG_INT8ARRAY returns correct value ok 55 - PG_INT8RANGE returns correct value ok 56 - PG_INT8RANGEARRAY returns correct value ok 57 - PG_INTERNAL returns correct value ok 58 - PG_INTERVAL returns correct value ok 59 - PG_INTERVALARRAY returns correct value ok 60 - PG_JSON returns correct value ok 61 - PG_JSONARRAY returns correct value ok 62 - PG_JSONB returns correct value ok 63 - PG_JSONBARRAY returns correct value ok 64 - PG_LANGUAGE_HANDLER returns correct value ok 65 - PG_LINE returns correct value ok 66 - PG_LINEARRAY returns correct value ok 67 - PG_LSEG returns correct value ok 68 - PG_LSEGARRAY returns correct value ok 69 - PG_MACADDR returns correct value ok 70 - PG_MACADDRARRAY returns correct value ok 71 - PG_MONEY returns correct value ok 72 - PG_MONEYARRAY returns correct value ok 73 - PG_NAME returns correct value ok 74 - PG_NAMEARRAY returns correct value ok 75 - PG_NUMERIC returns correct value ok 76 - PG_NUMERICARRAY returns correct value ok 77 - PG_NUMRANGE returns correct value ok 78 - PG_NUMRANGEARRAY returns correct value ok 79 - PG_OID returns correct value ok 80 - PG_OIDARRAY returns correct value ok 81 - PG_OIDVECTOR returns correct value ok 82 - PG_OIDVECTORARRAY returns correct value ok 83 - PG_OPAQUE returns correct value ok 84 - PG_PATH returns correct value ok 85 - PG_PATHARRAY returns correct value ok 86 - PG_PG_ATTRIBUTE returns correct value ok 87 - PG_PG_CLASS returns correct value ok 88 - PG_PG_LSN returns correct value ok 89 - PG_PG_LSNARRAY returns correct value ok 90 - PG_PG_NODE_TREE returns correct value ok 91 - PG_PG_PROC returns correct value ok 92 - PG_PG_TYPE returns correct value ok 93 - PG_POINT returns correct value ok 94 - PG_POINTARRAY returns correct value ok 95 - PG_POLYGON returns correct value ok 96 - PG_POLYGONARRAY returns correct value ok 97 - PG_RECORD returns correct value ok 98 - PG_RECORDARRAY returns correct value ok 99 - PG_REFCURSOR returns correct value ok 100 - PG_REFCURSORARRAY returns correct value ok 101 - PG_REGCLASS returns correct value ok 102 - PG_REGCLASSARRAY returns correct value ok 103 - PG_REGCONFIG returns correct value ok 104 - PG_REGCONFIGARRAY returns correct value ok 105 - PG_REGDICTIONARY returns correct value ok 106 - PG_REGDICTIONARYARRAY returns correct value ok 107 - PG_REGOPER returns correct value ok 108 - PG_REGOPERARRAY returns correct value ok 109 - PG_REGOPERATOR returns correct value ok 110 - PG_REGOPERATORARRAY returns correct value ok 111 - PG_REGPROC returns correct value ok 112 - PG_REGPROCARRAY returns correct value ok 113 - PG_REGPROCEDURE returns correct value ok 114 - PG_REGPROCEDUREARRAY returns correct value ok 115 - PG_REGTYPE returns correct value ok 116 - PG_REGTYPEARRAY returns correct value ok 117 - PG_RELTIME returns correct value ok 118 - PG_RELTIMEARRAY returns correct value ok 119 - PG_SMGR returns correct value ok 120 - PG_TEXT returns correct value ok 121 - PG_TEXTARRAY returns correct value ok 122 - PG_TID returns correct value ok 123 - PG_TIDARRAY returns correct value ok 124 - PG_TIME returns correct value ok 125 - PG_TIMEARRAY returns correct value ok 126 - PG_TIMESTAMP returns correct value ok 127 - PG_TIMESTAMPARRAY returns correct value ok 128 - PG_TIMESTAMPTZ returns correct value ok 129 - PG_TIMESTAMPTZARRAY returns correct value ok 130 - PG_TIMETZ returns correct value ok 131 - PG_TIMETZARRAY returns correct value ok 132 - PG_TINTERVAL returns correct value ok 133 - PG_TINTERVALARRAY returns correct value ok 134 - PG_TRIGGER returns correct value ok 135 - PG_TSQUERY returns correct value ok 136 - PG_TSQUERYARRAY returns correct value ok 137 - PG_TSRANGE returns correct value ok 138 - PG_TSRANGEARRAY returns correct value ok 139 - PG_TSTZRANGE returns correct value ok 140 - PG_TSTZRANGEARRAY returns correct value ok 141 - PG_TSVECTOR returns correct value ok 142 - PG_TSVECTORARRAY returns correct value ok 143 - PG_TXID_SNAPSHOT returns correct value ok 144 - PG_TXID_SNAPSHOTARRAY returns correct value ok 145 - PG_UNKNOWN returns correct value ok 146 - PG_UUID returns correct value ok 147 - PG_UUIDARRAY returns correct value ok 148 - PG_VARBIT returns correct value ok 149 - PG_VARBITARRAY returns correct value ok 150 - PG_VARCHAR returns correct value ok 151 - PG_VARCHARARRAY returns correct value ok 152 - PG_VOID returns correct value ok 153 - PG_XID returns correct value ok 154 - PG_XIDARRAY returns correct value ok 155 - PG_XML returns correct value ok 156 - PG_XMLARRAY returns correct value 1..156 ok (in cleanup) DBD::Pg::st DESTROY failed: no connection to the server at t/02attribs.t line 1634. t/02attribs.t ....... 1..260 ok 1 - Connect to database for handle attributes testing ok 2 - DB handle attribute "Statement" returns the last prepared query ok 3 - Error or warning when setting an invalid database handle attribute ok 4 - Setting a private attribute on a database handle does not throw an error ok 5 - Error or warning when setting an invalid statement handle attribute ok 6 - Setting a private attribute on a statement handle does not throw an error ok 7 - Commit after deleting all rows from dbd_pg_test ok 8 - Connect to database with second database handle, AutoCommit on ok 9 - Insert a row into the database with first database handle ok 10 - Second database handle cannot see insert from first ok 11 - Insert a row into the database with second database handle ok 12 - First database handle can see insert from second ok 13 - Commit transaction with first database handle ok 14 - Second database handle can see insert from first ok 15 - Disconnect with second database handle ok 16 - $dbh->{Driver}{Name} returns correct value of "Pg" ok 17 - DB handle attribute "Name" returns same value as DBI_DSN ok 18 - DB handle attribute "RowCacheSize" returns undef ok 19 - Setting DB handle attribute "RowCacheSize" has no effect ok 20 - DB handle attribute "Username" returns the same value as DBI_USER ok 21 - DB handle attribute "PrintWarn" defaults to on ok 22 - DB handle attribute "PrintWarn" works when on ok 23 - DB handle attribute "PrintWarn" shows warnings when on ok 24 - DB handle attribute "PrintWarn" works when on ok 25 - DB handle attribute "PrintWarn" shows warnings when on ok 26 - Database handle attribute "pg_INV_WRITE" returns a number ok 27 - Database handle attribute "pg_INV_READ" returns a number ok 28 - Database handle attribute "pg_protocol" returns a number ok 29 - Database handle attribute "pg_errorlevel" returns the default (1) ok 30 - Database handle attribute "pg_errorlevel" defaults to 1 if invalid ok 31 - DB handle method "pg_bool_tf" starts as 0 ok 32 - DB handle method "pg_bool_tf" returns '1' for true when on ok 33 - DB handle method "pg_bool_tf" returns '0' for false when on ok 34 - DB handle method "pg_bool_tf" returns 't' for true when on ok 35 - DB handle method "pg_bool_tf" returns 'f' for true when on ok 36 - DB handle attribute "pg_db" returns at least one character ok 37 - DB handle attribute "pg_db" returns at least one character ok 38 - DB handle attribute "pg_user" returns a value ok 39 - DB handle attribute "pg_pass" returns a value ok 40 - DB handle attribute "pg_port" returns a number ok 41 - DB handle attribute "pg_default_port" returns a number ok 42 - DB handle attribute "pg_options" returns a value ok 43 - DB handle attribute "pg_socket" returns a value ok 44 - DB handle attribute "pg_pid" returns a value ok 45 - DB handle attribute "pg_standard_conforming_strings" returns a valid value ok 46 - DB handle attribute "pg_standard_conforming_strings" returns correct value ok 47 - DB handle attribute "pg_standard_conforming_strings" returns correct value ok 48 - Quote method returns correct utf-8 characters ok 49 - Able to insert unicode character into the database ok 50 - Able to read unicode (utf8) data from the database ok 51 - Unicode (utf8) data returned from database is not corrupted ok 52 - ASCII text returned from database does have utf8 bit set ok 53 - Attribute "Warn" attribute set on by default ok 54 - Statement handle inherits the "Warn" attribute ok 55 - Able to turn off the "Warn" attribute in the database handle ok 56 - Statement handle attribute "NUM_OF_PARAMS" works correctly before execute with no placeholders ok 57 - Statement handle attribute "NUM_OF_PARAMS" works correctly before execute with three placeholders ok 58 - Statement handle attribute "NUM_OF_PARAMS" works correctly before execute with one placeholder ok 59 - Statement handle attribute "NUM_OF_FIELDS" returns undef before execute ok 60 - Statement handle attribute "NAME" returns undef before execute ok 61 - Statement handle attribute "NAME_lc" returns undef before execute ok 62 - Statement handle attribute "NAME_uc" returns undef before execute ok 63 - Statement handle attribute "NAME_hash" returns undef before execute ok 64 - Statement handle attribute "NAME_lc_hash" returns undef before execute ok 65 - Statement handle attribute "NAME_uc_hash" returns undef before execute ok 66 - Statement handle attribute "TYPE" returns undef before execute ok 67 - Statement handle attribute "PRECISION" returns undef before execute ok 68 - Statement handle attribute "SCALE" returns undef before execute ok 69 - Statement handle attribute "NULLABLE" returns undef before execute ok 70 - Statement handle attribute "NUM_OF_PARAMS" works correctly after execute ok 71 - Statement handle attribute "NUM_OF_FIELDS" works correctly for SELECT statements ok 72 - Statement handle attribute "NAME" works correctly for SELECT statements ok 73 - Statement handle attribute "NAME_lc" works correctly for SELECT statements ok 74 - Statement handle attribute "NAME_uc" works correctly for SELECT statements ok 75 - Statement handle attribute "NAME_hash" works correctly for SELECT statements ok 76 - Statement handle attribute "NAME_lc_hash" works correctly for SELECT statements ok 77 - Statement handle attribute "NAME_uc_hash" works correctly for SELECT statements ok 78 - Statement handle attribute "TYPE" works correctly for SELECT statements ok 79 - Statement handle attribute "PRECISION" works correctly ok 80 - Statement handle attribute "SCALE" works correctly ok 81 - Statement handle attribute "NULLABLE" works correctly ok 82 - Statement handle attribute "NUM_OF_PARAMS" works correctly after finish ok 83 - Statement handle attribute "NUM_OF_FIELDS" works correctly after finish ok 84 - Statement handle attribute "NAME" returns undef after finish ok 85 - Statement handle attribute "NAME_lc" returns values after finish ok 86 - Statement handle attribute "NAME_uc" returns values after finish ok 87 - Statement handle attribute "NAME_hash" works correctly after finish ok 88 - Statement handle attribute "NAME_lc_hash" works correctly after finish ok 89 - Statement handle attribute "NAME_uc_hash" works correctly after finish ok 90 - Statement handle attribute "TYPE" returns undef after finish ok 91 - Statement handle attribute "PRECISION" works correctly after finish ok 92 - Statement handle attribute "SCALE" works correctly after finish ok 93 - Statement handle attribute "NULLABLE" works correctly after finish ok 94 - Statement handle attribute "NUM_OF_FIELDS" returns undef for updates ok 95 - Statement handle attribute "NAME" returns empty arrayref for updates ok 96 - Statement handle attribute "TYPE" returns empty arrayref for updates ok 97 - Statement handle attribute "PRECISION" returns empty arrayref for updates ok 98 - Statement handle attribute "SCALE" returns empty arrayref for updates ok 99 - Statement handle attribute "NULLABLE" returns empty arrayref for updates ok 100 - Statement handle attribute "NUM_OF_FIELDS" returns correct value for RETURNING updates ok 101 - Statement handle attribute "NAME" returns correct info for RETURNING updates ok 102 - Statement handle attribute "NAME_lc" returns correct info for RETURNING updates ok 103 - Statement handle attribute "NAME_uc" returns correct info for RETURNING updates ok 104 - Statement handle attribute "NAME_hash" returns correct info for RETURNING updates ok 105 - Statement handle attribute "NAME_lc_hash" returns correct info for RETURNING updates ok 106 - Statement handle attribute "NAME_uc_hash" returns correct info for RETURNING updates ok 107 - Statement handle attribute "TYPE" returns correct info for RETURNING updates ok 108 - Statement handle attribute "PRECISION" returns correct info for RETURNING updates ok 109 - Statement handle attribute "SCALE" returns correct info for RETURNING updates ok 110 - Statement handle attribute "NULLABLE" returns empty arrayref for updates ok 111 - Statement handle attribute "NUM_OF_FIELDS" returns correct value for RETURNING inserts ok 112 - Statement handle attribute "NAME" returns correct info for RETURNING inserts ok 113 - Statement handle attribute "NAME_lc" returns correct info for RETURNING inserts ok 114 - Statement handle attribute "NAME_uc" returns correct info for RETURNING inserts ok 115 - Statement handle attribute "NAME_hash" returns correct info for RETURNING inserts ok 116 - Statement handle attribute "NAME_lc_hash" returns correct info for RETURNING inserts ok 117 - Statement handle attribute "NAME_uc_hash" returns correct info for RETURNING inserts ok 118 - Statement handle attribute "TYPE" returns correct info for RETURNING inserts ok 119 - Statement handle attribute "PRECISION" returns correct info for RETURNING inserts ok 120 - Statement handle attribute "SCALE" returns correct info for RETURNING inserts ok 121 - Statement handle attribute "NULLABLE" returns empty arrayref for inserts ok 122 - Statement handle attribute "NUM_OF_FIELDS" returns correct value for RETURNING updates ok 123 - Statement handle attribute "NAME" returns correct info for RETURNING deletes ok 124 - Statement handle attribute "NAME_lc" returns correct info for RETURNING deletes ok 125 - Statement handle attribute "NAME_uc" returns correct info for RETURNING deletes ok 126 - Statement handle attribute "NAME_hash" returns correct info for RETURNING deletes ok 127 - Statement handle attribute "NAME_lc_hash" returns correct info for RETURNING deletes ok 128 - Statement handle attribute "NAME_uc_hash" returns correct info for RETURNING deletes ok 129 - Statement handle attribute "TYPE" returns correct info for RETURNING deletes ok 130 - Statement handle attribute "PRECISION" returns correct info for RETURNING deletes ok 131 - Statement handle attribute "SCALE" returns correct info for RETURNING deletes ok 132 - Statement handle attribute "NULLABLE" returns empty arrayref for deletes ok 133 - Statement handle attribute "NUM_OF_FIELDS" returns correct value for SHOW commands ok 134 - Statement handle attribute "NAME" returns correct info for SHOW commands ok 135 - Statement handle attribute "NAME_lc" returns correct info for SHOW commands ok 136 - Statement handle attribute "NAME_uc" returns correct info for SHOW commands ok 137 - Statement handle attribute "NAME_hash" returns correct info for SHOW commands ok 138 - Statement handle attribute "NAME_lc_hash" returns correct info for SHOW commands ok 139 - Statement handle attribute "NAME_uc_hash" returns correct info for SHOW commands ok 140 - Statement handle attribute "TYPE" returns correct info for SHOW commands ok 141 - Statement handle attribute "PRECISION" returns correct info for SHOW commands ok 142 - Statement handle attribute "SCALE" returns correct info for SHOW commands ok 143 - Statement handle attribute "NULLABLE" returns "unknown" (2) for SHOW commands ok 144 - Statement handle attribute "CursorName" returns undef ok 145 - Statement handle attribute "Database" matches the database handle ok 146 - Statement handle attribute "ParamValues" works before execute ok 147 - Statement handle attribute "ParamValues" works after execute ok 148 - Statement handle attribute "ParamTypes" works before execute ok 149 - Statement handle attributes "ParamValues" and "ParamTypes" can be pased back to bind_param ok 150 - Statement handle attribute "ParamTypes" works before execute with named placeholders ok 151 - Statement handle attributes "ParamValues" and "ParamTypes" can be passed back to bind_param ok 152 - Statement handle attribute "ParamTypes" works after execute ok 153 - Statement handle attribute "ParamTypes" returns correct values ok 154 - Statement handle attribute "RowsInCache" returns undef ok 155 - Statement handle attribute "pg_size" works ok 156 - Statement handle attribute "pg_type" works ok 157 - Statement handle attribute "pg_oid_status" returned a numeric value after insert ok 158 - Statement handle attribute "pg_cmd_status" works for 'INSERT' ok 159 - Statement handle attribute "pg_cmd_status" works for 'DELETE' ok 160 - Statement handle attribute "pg_cmd_status" works for 'UPDATE' ok 161 - Statement handle attribute "pg_cmd_status" works for 'SELECT' ok 162 - Database handle attribute "Active" is true while connected ok 163 - Statement handle attribute "Active" is false before SELECT ok 164 - Statement handle attribute "Active" is true after SELECT ok 165 - Statement handle attribute "Active" is true when rows remaining ok 166 - Statement handle attribute "Active" is false after finish called ok 167 - Database handle attribute "Executed" begins false ok 168 - Database handle attribute "Executed" stays false after prepare() ok 169 - Statement handle attribute "Executed" begins false ok 170 - Statement handle attribute "Executed" is true after execute() ok 171 - Database handle attribute "Executed" is true after execute() ok 172 - Statement handle attribute "Executed" is true after finish() ok 173 - Database handle attribute "Executed" is true after finish() ok 174 - Database handle attribute "Executed" is false after commit() ok 175 - Statement handle attribute "Executed" is true after commit() ok 176 - Database handle attribute "Executed" is true after do() ok 177 - Database handle attribute "Executed" is false after rollback() ok 178 - Statement handle attribute "Executed" is true after rollback() ok 179 - Database handle attribute "Kids" is set properly ok 180 - Database handle attribute "Kids" works ok 181 - Statement handle attribute "Kids" is zero ok 182 - Database handle attribute "ActiveKids" is set properly ok 183 - Database handle attribute "ActiveKids" works ok 184 - Statement handle attribute "ActiveKids" is zero ok 185 - Database handle attribute "CachedKids" is set properly ok 186 - Database handle attribute "Type" is set properly ok 187 - Statement handle attribute "Type" is set properly ok 188 - Database handle attribute "ChildHandles" is an empty list on startup ok 189 - Statement handle attribute "ChildHandles" is an empty list on creation ok 190 - Database handle attribute "ChildHandles" contains newly created statement handle ok 191 - Database handle attribute "ChildHandles" has undef for destroyed statement handle ok 192 - Database handle attribute "CompatMode" is set properly ok 193 - Database handle attribute "PrintError" is set properly ok 194 - Warning thrown when database handle attribute "PrintError" is on ok 195 - No warning thrown when database handle attribute "PrintError" is off ok 196 - No error produced when database handle attribute "RaiseError" is off ok 197 - Error produced when database handle attribute "RaiseError" is off ok 198 - Database handle attribute "HandleError" is set properly ok 199 - Database handle attribute "HandleError" works ok 200 - Database handle attribute "HandleError" modifies error messages ok 201 - Database handle attribute "HandleSetErr" is set properly ok 202 - Database handle attribute "HandleSetErr" works as expected ok 203 - Database handle attribute "HandleSetErr" works as expected ok 204 - Database handle attribute "HandleSetErr" works as expected ok 205 - Database handle attribute "ErrCount" starts out at 0 ok 206 - Database handle attribute "ErrCount" is incremented with set_err() ok 207 - Database handle attribute "ShowErrorStatemnt" starts out false ok 208 - Database handle attribute "ShowErrorStatement" has no effect if not set ok 209 - Database handle attribute "ShowErrorStatement" adds statement to errors ok 210 - Database handle attribute "ShowErrorStatement" adds statement and placeholders to errors ok 211 - Database handle attribute "ShowErrorStatement" adds statement and placeholders to errors ok 212 - Database handle attribute "TraceLevel" returns a number ok 213 - Database handle attribute "FetchHashKeyName" is set properly ok 214 - Database handle attribute "FetchHashKeyName" works with the default value of NAME ok 215 - Database handle attribute "FetchHashKeyName" can be changed ok 216 - Database handle attribute "FetchHashKeyName" works with a value of NAME_lc ok 217 - Database handle attribute "FetchHashKeyName" works with a value of NAME_uc ok 218 - Database handle attribute "ChopBlanks" is set properly ok 219 - Database handle attribute "ChopBlanks" = 0 returns correct value for fixed-length column ok 220 - Database handle attribute "ChopBlanks" = 0 returns correct value for variable-length column ok 221 - Database handle attribute "ChopBlanks" = 1 returns correct value for fixed-length column ok 222 - Database handle attribute "ChopBlanks" = 1 returns correct value for variable-length column ok 223 - Handle attribute "LongReadLen" has been set properly ok 224 - Handle attribute "LongTruncOk" has been set properly ok 225 - Handle attribute "TaintIn" has been set properly ok 226 - Handle attribute "TaintOut" has been set properly ok 227 - Handle attribute "Taint" has been set properly ok 228 - The value of handle attribute "Taint" can be changed ok 229 - Changing handle attribute "Taint" changes "TaintIn" ok 230 - Changing handle attribute "Taint" changes "TaintOut" ok 231 - Database handle attribute "ReadOnly" starts out undefined ok 232 - Database handle attribute "ReadOnly" allows SELECT queries to work when on ok 233 - Database handle attribute "ReadOnly" prevents INSERT queries from working when on ok 234 - Database handle attribute "ReadOnly" prevents INSERT queries from working when on ok 235 - Database handle attribute "ReadOnly" allows INSERT queries when switched off ok 236 - Database handle attribute "ReadOnly" allows INSERT queries when switched off ok 237 - Database handle attribute "ReadOnly" has no effect if AutoCommit is on ok 238 - Database handle attribute "ReadOnly" has no effect if AutoCommit is on ok 239 - Database handle attribute "InactiveDestroy" is set properly ok 240 - Disconnect from database ok 241 - Database handle attribute "Active" is false after disconnect ok 242 - Parent in fork test is working properly ("AutoInactiveDestroy" = 0) ok 243 - Ping fails after the child has exited ("AutoInactiveDestroy" = 0) ok 244 - Failed ping returns a SQLSTATE code of 08000 ok 245 - pg_ping gives an error code of -2 after the child has exited ("AutoInactiveDestroy" = 0) ok 246 - Disconnect from database ok 247 - Parent in fork test is working properly ("AutoInactiveDestroy" = 1) ok 248 - Ping works after the child has exited ("AutoInactiveDestroy" = 1) ok 249 - Successful ping returns a SQLSTATE code of 00000 (empty string) ok 250 - Statement handle works after forking ok 251 - Disconnect from database ok 252 - Database handle attribute "Active" is false after disconnect ok 253 - Parent in fork test is working properly ("InactiveDestroy" = 0) ok 254 - Ping fails after the child has exited ("InactiveDestroy" = 0) ok 255 - Failed ping returns a SQLSTATE code of 08000 ok 256 - pg_ping gives an error code of -2 after the child has exited ("InactiveDestroy" = 0) ok 257 - Parent in fork test is working properly ("InactiveDestroy" = 1) ok 258 - Ping works after the child has exited ("InactiveDestroy" = 1) ok 259 - Successful ping returns a SQLSTATE code of 00000 (empty string) ok 260 - Statement handle works after forking ok t/03dbmethod.t ...... 1..547 ok 1 - Connect to database for database handle method testing ok 2 - DB handle method "last_insert_id" fails when no arguments are given ok 3 - DB handle method "last_insert_id" fails when given a non-existent sequence ok 4 - DB handle method "last_insert_id" fails when given a non-existent table ok 5 - DB handle method "last_insert_id" fails when given an arrayref as last argument ok 6 - DB handle method "last_insert_id" works when given an empty sequence argument ok 7 - DB handle method "last_insert_id" fails when given a table with no primary key ok 8 - DB handle method "do" returns correct count with CREATE AS SELECT ok 9 - DB handle method "execute" returns correct count with CREATE AS SELECT ok 10 - DB handle method "do" works properly with passed-in array with undefined entries ok 11 - DB handle method "do" works properly with passed-in array with undefined entries ok 12 - DB handle method "last_insert_id" works when given a valid sequence and an invalid table ok 13 - DB handle method "last_insert_id" returns a numeric value ok 14 - DB handle method "last_insert_id" works when given a valid sequence and an invalid table ok 15 - DB handle method "last_insert_id" returns a numeric value ok 16 - DB handle method "last_insert_id" works when given a valid table ok 17 - DB handle method "last_insert_id" works when given an empty attrib ok 18 - DB handle method "last_insert_id" works when called twice (cached) given a valid table ok 19 - DB handle method "last_insert_id" works when called with a schema not in the search path ok 20 - search_path respected when using last_insert_id with no cache (first table) ok 21 - search_path respected when using last_insert_id with no cache (first table) ok 22 - search_path respected when using last_insert_id with no cache (second table) ok 23 - search_path respected when using last_insert_id with no cache (second table) ok 24 - Setting cache on (explicit) returns last result, even if search_path changes ok 25 - Setting cache on (explicit) returns last result, even if search_path changes ok 26 - Setting cache on (implicit) returns last result, even if search_path changes ok 27 - Setting cache on (implicit) returns last result, even if search_path changes ok 28 - DB handle method "last_insert_id" fails when the sequence name is changed and cache is used ok 29 - DB handle method "last_insert_id" works when the sequence name is changed and cache is turned off ok 30 - DB handle method "selectrow_array" works ok 31 - DB handle method "selectrow_arrayref" works ok 32 - DB handle method "selectrow_arrayref" works with a prepared statement handle ok 33 - DB handle method "selectrow_hashref" works ok 34 - DB handle method "selectrow_hashref" works with a prepared statement handle ok 35 - DB handle method "selectall_arrayref" works ok 36 - DB handle method "selectall_arrayref" works with a prepared statement handle ok 37 - DB handle method "selectall_arrayref" works with the MaxRows attribute ok 38 - DB handle method "selectall_arrayref" works with the Slice attribute ok 39 - DB handle method "selectall_hashref" works ok 40 - DB handle method "selectall_hashref" works with a prepared statement handle ok 41 - DB handle method "selectcol_arrayref" works ok 42 - DB handle method "selectcol_arrayref" works with a prepared statement handle ok 43 - DB handle method "selectcol_arrayref" works with the Columns attribute ok 44 - DB handle method "selectcol_arrayref" works with the MaxRows attribute ok 45 - DB handle method "commit" gives no warning when AutoCommit is off ok 46 - DB handle method "rollback" gives no warning when AutoCommit is off ok 47 - DB handle method "commit" returns true ok 48 - DB handle method "rollback" returns true ok 49 - DB handle method "commit" gives a warning when AutoCommit is on ok 50 - DB handle method "rollback" gives a warning when AutoCommit is on ok 51 - DB handle method "begin_work" gives a warning when AutoCommit is on ok 52 - DB handle method "begin_work" gives no warning when AutoCommit is off ok 53 - DB handle method "begin_work" sets AutoCommit to off ok 54 - DB handle method "commit" after "begin_work" sets AutoCommit to on ok 55 - DB handle method "begin_work" gives no warning when AutoCommit is off ok 56 - DB handle method "begin_work" sets AutoCommit to off ok 57 - DB handle method "rollback" after "begin_work" sets AutoCommit to on ok 58 - DB handle method "get_info" with no arguments gives an error ok 59 - DB handle method "get_info" works with a value of "SQL_IDENTIFIER_QUOTE_CHAR" ok 60 - DB handle method "get_info" works with a value of "29" ok 61 - DB handle method "get_info" returned matching values ok 62 - DB handle method "get_info" works with a value of "SQL_DBMS_VERSION" ok 63 - DB handle method "get_info" works with a value of "18" ok 64 - DB handle method "get_info" returned matching values ok 65 - DB handle method "get_info" works with a value of "SQL_CATALOG_NAME_SEPARATOR" ok 66 - DB handle method "get_info" works with a value of "41" ok 67 - DB handle method "get_info" returned matching values ok 68 - DB handle method "get_info" works with a value of "SQL_USER_NAME" ok 69 - DB handle method "get_info" works with a value of "47" ok 70 - DB handle method "get_info" returned matching values ok 71 - DB handle method "get_info" works with a value of "SQL_DBMS_NAME" ok 72 - DB handle method "get_info" works with a value of "17" ok 73 - DB handle method "get_info" returned matching values ok 74 - DB handle method "get_info" works with a value of "SQL_DRIVER_NAME" ok 75 - DB handle method "get_info" works with a value of "6" ok 76 - DB handle method "get_info" returned matching values ok 77 - DB handle method "get_info" works with a value of "SQL_MAX_DRIVER_CONNECTIONS" ok 78 - DB handle method "get_info" works with a value of "0" ok 79 - DB handle method "get_info" returned matching values ok 80 - DB handle method "get_info" returns a valid looking ODBCVERSION string} ok 81 - DB handle method "get_info" returns a number for SQL_MAX_DRIVER_CONNECTIONS ok 82 - DB handle method "get_info" returns correct string for SQL_DATA_SOURCE_READ_ONLY when "on" ok 83 - DB handle method "get_info" returns correct string for SQL_DATA_SOURCE_READ_ONLY when "off" ok 84 - DB handle method "table_info" works when called with empty arguments ok 85 - DB handle method "table_info" works when called with '%' arguments ok 86 - DB handle method "table_info" returns fields required by DBI ok 87 - DB handle method "table_info" returns proper TABLE_CAT ok 88 - DB handle method "table_info" returns proper TABLE_NAME ok 89 - DB handle method "table_info" returns proper TABLE_TYPE ok 90 - DB handle method "table_info" returns correct number of rows when given a 'TABLE,VIEW' type argument ok 91 - DB handle method "table_info" returns correct number of rows when given a 'TABLE,VIEW,SYSTEM TABLE,SYSTEM VIEW' type argument ok 92 - DB handle method "table_info" returns zero rows when given an invalid type argument ok 93 - DB handle method "table_info" returns correct number of rows when given a 'VIEW' type argument ok 94 - DB handle method "table_info" returns correct number of rows when given a 'TABLE' type argument ok 95 - DB handle method "table_info" returns correct number of rows when given a 'LOCAL TEMPORARY' type argument ok 96 - DB handle method "table_info" returns correct number of rows when given a 'LOCAL TEMPORARY' type argument ok 97 - DB handle method "table_info" returns correct number of rows when given a 'MATERIALIZED VIEW' type argument ok 98 # skip Postgres version 9.3 or better required to create materialized views ok 99 - DB handle method "table_info" works when called with a catalog of % ok 100 - DB handle method "table_info" works when called with a schema of % ok 101 - DB handle method "table_info" works when called with a type of % ok 102 - DB handle method "table_info" type list returns all expected types ok 103 - DB handle method "table_info" object list returns no unadvertised types ok 104 - DB handle method "column_info" returns fields required by DBI ok 105 - DB handle method "column info" 'pg_constraint' returns a value for constrained columns ok 106 - DB handle method "column info" 'pg_constraint' returns undef for non-constrained columns ok 107 - DB handle method "column_info" returns good value for 'pg_type' ok 108 - DB handle method "column_info" returns proper TABLE_CAT ok 109 - DB handle method "column_info returns proper TABLE_NAME ok 110 - DB handle method "column_info" returns proper COLUMN_NAME ok 111 - DB handle method "column_info" returns proper DATA_TYPE ok 112 - DB handle method "column_info" returns proper COLUMN_SIZE ok 113 - DB handle method "column_info" returns proper NULLABLE ok 114 - DB handle method "column_info" returns proper REMARKS ok 115 - DB handle method "column_info" returns proper COLUMN_DEF ok 116 - DB handle method "column_info" returns proper IS_NULLABLE ok 117 - DB handle method "column_info" returns proper pg_type ok 118 - DB handle method "column_info" returns proper ORDINAL_POSITION ok 119 - DB handle method "column_info" works with non-lowercased columns ok 120 - DB handle method "column_info" returns proper pg_type ok 121 - DB handle method "column_info" returns proper pg_enum_values ok 122 - DB handle method "primary_key_info" returns required fields ok 123 - DB handle method "primary_key_info" returns proper TABLE_CAT ok 124 - DB handle method "primary_key_info" returns proper TABLE_NAME ok 125 - DB handle method "primary_key_info" returns proper COLUMN_NAME ok 126 - DB handle method "primary_key_info" returns proper PK_NAME ok 127 - DB handle method "primary_key_info" returns proper DATA_TYPE ok 128 - DB handle method "primary_key_info" returns proper KEY_SEQ ok 129 - DB handle method "primary_key" works ok 130 - DB handle method "primary_key" returns empty list for invalid table ok 131 - DB handle method "statistics_info" returns undef: no table ok 132 - DB handle method "statistics_info" returns undef: bad table ok 133 - Correct stats output for dbd_pg_test1 ok 134 - Correct stats output for dbd_pg_test2 ok 135 - Correct stats output for dbd_pg_test3 ok 136 - Correct stats output for dbd_pg_test3 (unique only) ok 137 - Correct stats output for dbd_pg_test1 ok 138 - Correct stats output for dbd_pg_test3 ok 139 - Correct stats output for dbd_pg_test3 ok 140 - Correct stats output for dbd_pg_test3 (unique only) ok 141 - DB handle method "foreign_key_info" returns undef: no pk / no fk ok 142 - DB handle method "foreign_key_info" returns undef: bad pk / no fk ok 143 - DB handle method "foreign_key_info" returns undef: no pk / bad fk ok 144 - DB handle method "foreign_key_info" returns undef: bad fk / bad fk ok 145 - DB handle method "foreign_key_info" returns undef: good pk (but unreferenced) ok 146 - DB handle method "foreign_key_info" returns undef: bad pk / good fk ok 147 - DB handle method "foreign_key_info" returns undef: good pk / good fk / bad pk schema ok 148 - DB handle method "foreign_key_info" returns undef: good pk / good fk / bad fk schema ok 149 - DB handle method "foreign_key_info" returns fields required by DBI ok 150 - Calling foreign_key_info does not change pg_expand_array ok 151 - DB handle method "foreign_key_info" works for good pk ok 152 - DB handle method "foreign_key_info" works for good pk / good fk ok 153 - DB handle method "foreign_key_info" works for good fk ok 154 - DB handle method "foreign_key_info" works for good pk / explicit fk ok 155 - DB handle method "foreign_key_info" works for good pk / implicit fk ok 156 - DB handle method "foreign_key_info" works for multiple fks ok 157 - DB handle method "foreign_key_info" works for good pk / good fk (only) ok 158 - DB handle method "foreign_key_info" works for multi-column keys ok 159 - DB handle method "foreign_key_info" works with FetchHashKeyName NAME_lc ok 160 - DB handle method "foreign_key_info" works with FetchHashKeyName NAME_uc ok 161 - DB handle method "foreign_key_info" works with FetchHashKeyName NAME ok 162 - DB handle method "tables" works ok 163 - DB handle method "tables" works with a "pg_noprefix" attribute ok 164 - DB handle method "tables" works with type='%' ok 165 - DB handle method "type_info_all" returns a valid structure ok 166 - DB handle method "type_info" returns fields required by DBI ok 167 - DB handle method "quote" works with a value of "" ok 168 - DB handle method "quote" works with a value of "0" ok 169 - DB handle method "quote" works with a value of "NULL" ok 170 - DB handle method "quote" works with a value of "Ain't misbehaving " ok 171 - DB handle method "quote" work on timestamp ok 172 - DB handle method "quote" works with an undefined value ok 173 - DB handle method "quote" works with a supplied data type argument ok 174 - Byte value 1 quotes to E'\\001' ok 175 - Byte value 2 quotes to E'\\002' ok 176 - Byte value 3 quotes to E'\\003' ok 177 - Byte value 4 quotes to E'\\004' ok 178 - Byte value 5 quotes to E'\\005' ok 179 - Byte value 6 quotes to E'\\006' ok 180 - Byte value 7 quotes to E'\\007' ok 181 - Byte value 8 quotes to E'\\010' ok 182 - Byte value 9 quotes to E'\\011' ok 183 - Byte value 10 quotes to E'\\012' ok 184 - Byte value 11 quotes to E'\\013' ok 185 - Byte value 12 quotes to E'\\014' ok 186 - Byte value 13 quotes to E'\\015' ok 187 - Byte value 14 quotes to E'\\016' ok 188 - Byte value 15 quotes to E'\\017' ok 189 - Byte value 16 quotes to E'\\020' ok 190 - Byte value 17 quotes to E'\\021' ok 191 - Byte value 18 quotes to E'\\022' ok 192 - Byte value 19 quotes to E'\\023' ok 193 - Byte value 20 quotes to E'\\024' ok 194 - Byte value 21 quotes to E'\\025' ok 195 - Byte value 22 quotes to E'\\026' ok 196 - Byte value 23 quotes to E'\\027' ok 197 - Byte value 24 quotes to E'\\030' ok 198 - Byte value 25 quotes to E'\\031' ok 199 - Byte value 26 quotes to E'\\032' ok 200 - Byte value 27 quotes to E'\\033' ok 201 - Byte value 28 quotes to E'\\034' ok 202 - Byte value 29 quotes to E'\\035' ok 203 - Byte value 30 quotes to E'\\036' ok 204 - Byte value 31 quotes to E'\\037' ok 205 - Byte value 32 quotes to E' ' ok 206 - Byte value 33 quotes to E'!' ok 207 - Byte value 34 quotes to E'"' ok 208 - Byte value 35 quotes to E'\#' ok 209 - Byte value 36 quotes to E'$' ok 210 - Byte value 37 quotes to E'%' ok 211 - Byte value 38 quotes to E'&' ok 212 - Byte value 39 quotes to E'''' ok 213 - Byte value 40 quotes to E'(' ok 214 - Byte value 41 quotes to E')' ok 215 - Byte value 42 quotes to E'*' ok 216 - Byte value 43 quotes to E'+' ok 217 - Byte value 44 quotes to E',' ok 218 - Byte value 45 quotes to E'-' ok 219 - Byte value 46 quotes to E'.' ok 220 - Byte value 47 quotes to E'/' ok 221 - Byte value 48 quotes to E'0' ok 222 - Byte value 49 quotes to E'1' ok 223 - Byte value 50 quotes to E'2' ok 224 - Byte value 51 quotes to E'3' ok 225 - Byte value 52 quotes to E'4' ok 226 - Byte value 53 quotes to E'5' ok 227 - Byte value 54 quotes to E'6' ok 228 - Byte value 55 quotes to E'7' ok 229 - Byte value 56 quotes to E'8' ok 230 - Byte value 57 quotes to E'9' ok 231 - Byte value 58 quotes to E':' ok 232 - Byte value 59 quotes to E';' ok 233 - Byte value 60 quotes to E'<' ok 234 - Byte value 61 quotes to E'=' ok 235 - Byte value 62 quotes to E'>' ok 236 - Byte value 63 quotes to E'?' ok 237 - Byte value 64 quotes to E'@' ok 238 - Byte value 65 quotes to E'A' ok 239 - Byte value 66 quotes to E'B' ok 240 - Byte value 67 quotes to E'C' ok 241 - Byte value 68 quotes to E'D' ok 242 - Byte value 69 quotes to E'E' ok 243 - Byte value 70 quotes to E'F' ok 244 - Byte value 71 quotes to E'G' ok 245 - Byte value 72 quotes to E'H' ok 246 - Byte value 73 quotes to E'I' ok 247 - Byte value 74 quotes to E'J' ok 248 - Byte value 75 quotes to E'K' ok 249 - Byte value 76 quotes to E'L' ok 250 - Byte value 77 quotes to E'M' ok 251 - Byte value 78 quotes to E'N' ok 252 - Byte value 79 quotes to E'O' ok 253 - Byte value 80 quotes to E'P' ok 254 - Byte value 81 quotes to E'Q' ok 255 - Byte value 82 quotes to E'R' ok 256 - Byte value 83 quotes to E'S' ok 257 - Byte value 84 quotes to E'T' ok 258 - Byte value 85 quotes to E'U' ok 259 - Byte value 86 quotes to E'V' ok 260 - Byte value 87 quotes to E'W' ok 261 - Byte value 88 quotes to E'X' ok 262 - Byte value 89 quotes to E'Y' ok 263 - Byte value 90 quotes to E'Z' ok 264 - Byte value 91 quotes to E'[' ok 265 - Byte value 92 quotes to E'\\\\' ok 266 - Byte value 93 quotes to E']' ok 267 - Byte value 94 quotes to E'^' ok 268 - Byte value 95 quotes to E'_' ok 269 - Byte value 96 quotes to E'`' ok 270 - Byte value 97 quotes to E'a' ok 271 - Byte value 98 quotes to E'b' ok 272 - Byte value 99 quotes to E'c' ok 273 - Byte value 100 quotes to E'd' ok 274 - Byte value 101 quotes to E'e' ok 275 - Byte value 102 quotes to E'f' ok 276 - Byte value 103 quotes to E'g' ok 277 - Byte value 104 quotes to E'h' ok 278 - Byte value 105 quotes to E'i' ok 279 - Byte value 106 quotes to E'j' ok 280 - Byte value 107 quotes to E'k' ok 281 - Byte value 108 quotes to E'l' ok 282 - Byte value 109 quotes to E'm' ok 283 - Byte value 110 quotes to E'n' ok 284 - Byte value 111 quotes to E'o' ok 285 - Byte value 112 quotes to E'p' ok 286 - Byte value 113 quotes to E'q' ok 287 - Byte value 114 quotes to E'r' ok 288 - Byte value 115 quotes to E's' ok 289 - Byte value 116 quotes to E't' ok 290 - Byte value 117 quotes to E'u' ok 291 - Byte value 118 quotes to E'v' ok 292 - Byte value 119 quotes to E'w' ok 293 - Byte value 120 quotes to E'x' ok 294 - Byte value 121 quotes to E'y' ok 295 - Byte value 122 quotes to E'z' ok 296 - Byte value 123 quotes to E'{' ok 297 - Byte value 124 quotes to E'|' ok 298 - Byte value 125 quotes to E'}' ok 299 - Byte value 126 quotes to E'~' ok 300 - Byte value 127 quotes to E'\\177' ok 301 - Byte value 128 quotes to E'\\200' ok 302 - Byte value 129 quotes to E'\\201' ok 303 - Byte value 130 quotes to E'\\202' ok 304 - Byte value 131 quotes to E'\\203' ok 305 - Byte value 132 quotes to E'\\204' ok 306 - Byte value 133 quotes to E'\\205' ok 307 - Byte value 134 quotes to E'\\206' ok 308 - Byte value 135 quotes to E'\\207' ok 309 - Byte value 136 quotes to E'\\210' ok 310 - Byte value 137 quotes to E'\\211' ok 311 - Byte value 138 quotes to E'\\212' ok 312 - Byte value 139 quotes to E'\\213' ok 313 - Byte value 140 quotes to E'\\214' ok 314 - Byte value 141 quotes to E'\\215' ok 315 - Byte value 142 quotes to E'\\216' ok 316 - Byte value 143 quotes to E'\\217' ok 317 - Byte value 144 quotes to E'\\220' ok 318 - Byte value 145 quotes to E'\\221' ok 319 - Byte value 146 quotes to E'\\222' ok 320 - Byte value 147 quotes to E'\\223' ok 321 - Byte value 148 quotes to E'\\224' ok 322 - Byte value 149 quotes to E'\\225' ok 323 - Byte value 150 quotes to E'\\226' ok 324 - Byte value 151 quotes to E'\\227' ok 325 - Byte value 152 quotes to E'\\230' ok 326 - Byte value 153 quotes to E'\\231' ok 327 - Byte value 154 quotes to E'\\232' ok 328 - Byte value 155 quotes to E'\\233' ok 329 - Byte value 156 quotes to E'\\234' ok 330 - Byte value 157 quotes to E'\\235' ok 331 - Byte value 158 quotes to E'\\236' ok 332 - Byte value 159 quotes to E'\\237' ok 333 - Byte value 160 quotes to E'\\240' ok 334 - Byte value 161 quotes to E'\\241' ok 335 - Byte value 162 quotes to E'\\242' ok 336 - Byte value 163 quotes to E'\\243' ok 337 - Byte value 164 quotes to E'\\244' ok 338 - Byte value 165 quotes to E'\\245' ok 339 - Byte value 166 quotes to E'\\246' ok 340 - Byte value 167 quotes to E'\\247' ok 341 - Byte value 168 quotes to E'\\250' ok 342 - Byte value 169 quotes to E'\\251' ok 343 - Byte value 170 quotes to E'\\252' ok 344 - Byte value 171 quotes to E'\\253' ok 345 - Byte value 172 quotes to E'\\254' ok 346 - Byte value 173 quotes to E'\\255' ok 347 - Byte value 174 quotes to E'\\256' ok 348 - Byte value 175 quotes to E'\\257' ok 349 - Byte value 176 quotes to E'\\260' ok 350 - Byte value 177 quotes to E'\\261' ok 351 - Byte value 178 quotes to E'\\262' ok 352 - Byte value 179 quotes to E'\\263' ok 353 - Byte value 180 quotes to E'\\264' ok 354 - Byte value 181 quotes to E'\\265' ok 355 - Byte value 182 quotes to E'\\266' ok 356 - Byte value 183 quotes to E'\\267' ok 357 - Byte value 184 quotes to E'\\270' ok 358 - Byte value 185 quotes to E'\\271' ok 359 - Byte value 186 quotes to E'\\272' ok 360 - Byte value 187 quotes to E'\\273' ok 361 - Byte value 188 quotes to E'\\274' ok 362 - Byte value 189 quotes to E'\\275' ok 363 - Byte value 190 quotes to E'\\276' ok 364 - Byte value 191 quotes to E'\\277' ok 365 - Byte value 192 quotes to E'\\300' ok 366 - Byte value 193 quotes to E'\\301' ok 367 - Byte value 194 quotes to E'\\302' ok 368 - Byte value 195 quotes to E'\\303' ok 369 - Byte value 196 quotes to E'\\304' ok 370 - Byte value 197 quotes to E'\\305' ok 371 - Byte value 198 quotes to E'\\306' ok 372 - Byte value 199 quotes to E'\\307' ok 373 - Byte value 200 quotes to E'\\310' ok 374 - Byte value 201 quotes to E'\\311' ok 375 - Byte value 202 quotes to E'\\312' ok 376 - Byte value 203 quotes to E'\\313' ok 377 - Byte value 204 quotes to E'\\314' ok 378 - Byte value 205 quotes to E'\\315' ok 379 - Byte value 206 quotes to E'\\316' ok 380 - Byte value 207 quotes to E'\\317' ok 381 - Byte value 208 quotes to E'\\320' ok 382 - Byte value 209 quotes to E'\\321' ok 383 - Byte value 210 quotes to E'\\322' ok 384 - Byte value 211 quotes to E'\\323' ok 385 - Byte value 212 quotes to E'\\324' ok 386 - Byte value 213 quotes to E'\\325' ok 387 - Byte value 214 quotes to E'\\326' ok 388 - Byte value 215 quotes to E'\\327' ok 389 - Byte value 216 quotes to E'\\330' ok 390 - Byte value 217 quotes to E'\\331' ok 391 - Byte value 218 quotes to E'\\332' ok 392 - Byte value 219 quotes to E'\\333' ok 393 - Byte value 220 quotes to E'\\334' ok 394 - Byte value 221 quotes to E'\\335' ok 395 - Byte value 222 quotes to E'\\336' ok 396 - Byte value 223 quotes to E'\\337' ok 397 - Byte value 224 quotes to E'\\340' ok 398 - Byte value 225 quotes to E'\\341' ok 399 - Byte value 226 quotes to E'\\342' ok 400 - Byte value 227 quotes to E'\\343' ok 401 - Byte value 228 quotes to E'\\344' ok 402 - Byte value 229 quotes to E'\\345' ok 403 - Byte value 230 quotes to E'\\346' ok 404 - Byte value 231 quotes to E'\\347' ok 405 - Byte value 232 quotes to E'\\350' ok 406 - Byte value 233 quotes to E'\\351' ok 407 - Byte value 234 quotes to E'\\352' ok 408 - Byte value 235 quotes to E'\\353' ok 409 - Byte value 236 quotes to E'\\354' ok 410 - Byte value 237 quotes to E'\\355' ok 411 - Byte value 238 quotes to E'\\356' ok 412 - Byte value 239 quotes to E'\\357' ok 413 - Byte value 240 quotes to E'\\360' ok 414 - Byte value 241 quotes to E'\\361' ok 415 - Byte value 242 quotes to E'\\362' ok 416 - Byte value 243 quotes to E'\\363' ok 417 - Byte value 244 quotes to E'\\364' ok 418 - Byte value 245 quotes to E'\\365' ok 419 - Byte value 246 quotes to E'\\366' ok 420 - Byte value 247 quotes to E'\\367' ok 421 - Byte value 248 quotes to E'\\370' ok 422 - Byte value 249 quotes to E'\\371' ok 423 - Byte value 250 quotes to E'\\372' ok 424 - Byte value 251 quotes to E'\\373' ok 425 - Byte value 252 quotes to E'\\374' ok 426 - Byte value 253 quotes to E'\\375' ok 427 - Byte value 254 quotes to E'\\376' ok 428 - Byte value 255 quotes to E'\\377' ok 429 - DB handle method "quote" works properly with backslashes ok 430 - DB handle method "quote" works properly without backslashes ok 431 - DB handle method "quote" works with type PG_POINT ok 432 - DB handle method "quote" returns correct value for type PG_POINT ok 433 - DB handle method "quote" fails with invalid PG_POINT string ok 434 - DB handle method "quote" fails with invalid PG_POINT string ok 435 - DB handle method "quote" works with valid PG_LINE string ok 436 - DB handle method "quote" fails with invalid PG_LINE string ok 437 - DB handle method "quote" fails with invalid PG_LINE string ok 438 - DB handle method "quote" fails with invalid PG_LSEG string ok 439 - DB handle method "quote" fails with invalid PG_LSEG string ok 440 - DB handle method "quote" works with valid PG_BOX string ok 441 - DB handle method "quote" fails with invalid PG_BOX string ok 442 - DB handle method "quote" fails with invalid PG_BOX string ok 443 - DB handle method "quote" works with valid PG_PATH string ok 444 - DB handle method "quote" returns correct value for type PG_PATH ok 445 - DB handle method "quote" fails with invalid PG_PATH string ok 446 - DB handle method "quote" fails with invalid PG_PATH string ok 447 - DB handle method "quote" works with valid PG_POLYGON string ok 448 - DB handle method "quote" fails with invalid PG_POLYGON string ok 449 - DB handle method "quote" fails with invalid PG_POLYGON string ok 450 - DB handle method "quote" works with valid PG_CIRCLE string ok 451 - DB handle method "quote" returns correct value for type PG_CIRCLE ok 452 - DB handle method "quote" fails with invalid PG_CIRCLE string ok 453 - DB handle method "quote" fails with invalid PG_CIRCLE string ok 454 - DB handle method "quote_identifier" works with a value of "Ain't misbehaving " ok 455 - DB handle method "quote_identifier" works with a value of "NULL" ok 456 - DB handle method "quote_identifier" works with a value of "" ok 457 - DB handle method "quote_identifier" works with a value of "0" ok 458 - DB handle method "quote_identifier" works with an undefined value ok 459 - DB handle method "quote_identifier" works with schemas ok 460 - DB handle method "table_attributes" returns the expected fields ok 461 - DB handle method "pg_lo_creat" works with old-school dbh->func() method ok 462 - DB handle method "pg_lo_creat" works with old-school dbh->func() method ok 463 - DB handle method "pg_lo_creat" works with deprecated dbh->func(...lo_creat) method ok 464 - DB handle method "pg_lo_creat" works with deprecated dbh->func(...lo_creat) method ok 465 - DB handle method "pg_lo_creat" returns a valid descriptor for writing ok 466 - DB handle method "pg_lo_creat" returns a valid descriptor for writing ok 467 - DB handle method "pg_lo_open" returns a valid descriptor for writing ok 468 - DB handle method "pg_lo_open" returns a valid descriptor for writing ok 469 - DB handle method "pg_lo_lseek" works when writing ok 470 - DB handle method "pg_lo_lseek" works when writing ok 471 - DB handle method "pg_lo_write" works ok 472 - DB handle method "pg_lo_write" works ok 473 - DB handle method "pg_lo_close" works after write ok 474 - DB handle method "pg_lo_open" returns a valid descriptor for reading ok 475 - DB handle method "pg_lo_open" returns a valid descriptor for reading ok 476 - DB handle method "pg_lo_lseek" works when reading ok 477 - DB handle method "pg_lo_tell" works ok 478 - DB handle method "pg_lo_read" reads back the same data that was written ok 479 # skip pg_lo_truncate is not working yet ok 480 # skip pg_lo_truncate is not working yet ok 481 - DB handle method "pg_lo_close" works after read ok 482 - DB handle method "pg_lo_unlink" works ok 483 - DB handle method "pg_lo_unlink" fails when called second time ok 484 - DB handle method "pg_lo_import" works ok 485 - DB handle method "pg_lo_import" inserts correct data ok 486 # skip Known bug: pg_log_import_with_oid throws an error. See RT #90448 ok 487 # skip Known bug: pg_log_import_with_oid throws an error. See RT #90448 ok 488 # skip Known bug: pg_log_import_with_oid throws an error. See RT #90448 ok 489 - DB handle method "pg_lo_import_with_oid" fails when given already used number ok 490 - DB handle method "pg_lo_import_with_oid" falls back to lo_import when number is 0 ok 491 - DB handle method "pg_lo_open" works after "pg_lo_insert" ok 492 - DB handle method "pg_lo_read" returns correct data after "pg_lo_import" ok 493 - DB handle method "pg_lo_read" returns correct data after "pg_lo_import" ok 494 - DB handle method "pg_lo_export" works ok 495 - DB handle method "pg_lo_export" works ok 496 - DB handle method "pg_lo_export" works ok 497 - DB handle method "pg_lo_creat" fails when AutoCommit on ok 498 - DB handle method "pg_lo_open" fails with AutoCommit on ok 499 - DB handle method "pg_lo_read" fails with AutoCommit on ok 500 - DB handle method "pg_lo_lseek" fails with AutoCommit on ok 501 - DB handle method "pg_lo_write" fails with AutoCommit on ok 502 - DB handle method "pg_lo_close" fails with AutoCommit on ok 503 - DB handle method "pg_lo_tell" fails with AutoCommit on ok 504 - DB handle method "pg_lo_unlink" fails with AutoCommit on ok 505 - DB handle method "pg_lo_import" works (AutoCommit on) ok 506 - DB handle method "pg_lo_import" inserts correct data (AutoCommit on, begin_work not called) ok 507 - DB handle method "pg_lo_import" works (AutoCommit on, begin_work called, no command) ok 508 - DB handle method "pg_lo_import" works (AutoCommit on, begin_work called, no command) ok 509 - DB handle method "pg_lo_import" works (AutoCommit on, begin_work called, no command, rollback) ok 510 - DB handle method "pg_lo_import" works (AutoCommit on, begin_work called, no command, rollback) ok 511 - DB handle method "pg_lo_import" works (AutoCommit on, begin_work called, second command) ok 512 - DB handle method "pg_lo_import" works (AutoCommit on, begin_work called, second command) ok 513 - DB handle method "pg_lo_import" works (AutoCommit on, begin_work called, second command, rollback) ok 514 - DB handle method "pg_lo_import" works (AutoCommit on, begin_work called, second command, rollback) ok 515 - DB handle method "pg_lo_import" works (AutoCommit not on, no command) ok 516 - DB handle method "pg_lo_import" works (AutoCommit not on, no command) ok 517 - DB handle method "pg_lo_import" works (AutoCommit not on, second command) ok 518 - DB handle method "pg_lo_import" works (AutoCommit not on, second command) ok 519 - DB handle method "pg_lo_export" works (AutoCommit on) ok 520 - DB handle method "pg_lo_export" works (AutoCommit on) ok 521 - DB handle method "pg_lo_export" works (AutoCommit on) ok 522 - DB handle method "pg_notifies" does not throw an error ok 523 - DB handle method "pg_notifies" (func) returns the correct values ok 524 - DB handle method "pg_notifies" returns the correct values ok 525 - DB handle method "getfd" returns a number ok 526 - DB handle method "state" returns an empty string on success ok 527 - DB handle method "state" returns a five-character code on error ok 528 - DB handle method "private_attribute_info" returns at least one record ok 529 - DB handle method "private_attribute_info" returns only internal names ok 530 - Database handle method "clone" does not throw an error ok 531 - Database handle method "clone" returns a valid database handle ok 532 - DB handle method "ping" returns 1 on an idle connection ok 533 - DB handle method "ping" returns 3 for a good connection inside a transaction ok 534 - DB handle method "ping" returns 1 on an idle connection ok 535 - DB handle method "ping" returns 2 when in COPY IN state ok 536 - DB handle method "ping" returns 3 for a good connection inside a transaction ok 537 - DB handle method "ping" returns a 4 when inside a failed transaction ok 538 - DB handle method "ping" fails (returns 0) on a disconnected handle ok 539 - Able to reconnect to the database after disconnect ok 540 - DB handle method "pg_ping" returns 1 on an idle connection ok 541 - DB handle method "pg_ping" returns 3 for a good connection inside a transaction ok 542 - DB handle method "pg_ping" returns 1 on an idle connection ok 543 - DB handle method "pg_ping" returns 2 when in COPY IN state ok 544 - DB handle method "pg_ping" returns 2 immediately after COPY IN state ok 545 - DB handle method "pg_ping" returns 3 for a good connection inside a transaction ok 546 - DB handle method "pg_ping" returns a 4 when inside a failed transaction ok 547 - DB handle method "pg_ping" fails (returns 0) on a disconnected handle ok t/03smethod.t ....... 1..122 ok 1 - Connect to database for statement handle method testing ok 2 - Calling prepare() with no arguments gives an error ok 3 - Calling prepare() with an undefined value returns undef ok 4 - Prepare/execute with no flags works ok 5 - Prepare/execute with pg_server_prepare off at database handle works ok 6 - Setting database attribute pg_switch_prepared to 7 works ok 7 - Statement handle inherits pg_switch_prepared setting ok 8 - Setting statement attribute pg_switch_prepared to 6 works ok 9 - Running with statement attribute pg_switch_prepared at 6 works (run 1 of 10) ok 10 - Running with statement attribute pg_switch_prepared at 6 works (run 2 of 10) ok 11 - Running with statement attribute pg_switch_prepared at 6 works (run 3 of 10) ok 12 - Running with statement attribute pg_switch_prepared at 6 works (run 4 of 10) ok 13 - Running with statement attribute pg_switch_prepared at 6 works (run 5 of 10) ok 14 - Running with statement attribute pg_switch_prepared at 6 works (run 6 of 10) ok 15 - Running with statement attribute pg_switch_prepared at 6 works (run 7 of 10) ok 16 - Running with statement attribute pg_switch_prepared at 6 works (run 8 of 10) ok 17 - Running with statement attribute pg_switch_prepared at 6 works (run 9 of 10) ok 18 - Running with statement attribute pg_switch_prepared at 6 works (run 10 of 10) ok 19 - Running with statement attribute pg_switch_prepared at -1 works (run 1 of 4) ok 20 - Running with statement attribute pg_switch_prepared at -1 works (run 2 of 4) ok 21 - Running with statement attribute pg_switch_prepared at -1 works (run 3 of 4) ok 22 - Running with statement attribute pg_switch_prepared at -1 works (run 4 of 4) ok 23 - Running with statement attribute pg_switch_prepared at 0 works (run 1 of 4) ok 24 - Running with statement attribute pg_switch_prepared at 0 works (run 2 of 4) ok 25 - Running with statement attribute pg_switch_prepared at 0 works (run 3 of 4) ok 26 - Running with statement attribute pg_switch_prepared at 0 works (run 4 of 4) ok 27 - Running with statement attribute pg_switch_prepared at 1 works (run 1 of 4) ok 28 - Running with statement attribute pg_switch_prepared at 1 works (run 2 of 4) ok 29 - Running with statement attribute pg_switch_prepared at 1 works (run 3 of 4) ok 30 - Running with statement attribute pg_switch_prepared at 1 works (run 4 of 4) ok 31 - Prepare/execute with pg_server_prepare on at database handle works ok 32 - Prepare failes when sent a non-hashref ok 33 - Prepare/execute with undef converted to NULL ok 34 - Prepare/execute with pg_server_prepare off at statement handle works ok 35 - Prepare/execute with pg_server_prepare on at statement handle works ok 36 - Prepare/execute with pg_prepare_now on at database handle works ok 37 - Prepare/execute with pg_prepare_now off at database handle works ok 38 - Prepare/execute with pg_prepare_now off at statement handle works ok 39 - Prepare/execute with pg_prepare_now on at statement handle works ok 40 - Prepare/execute works with pg_prepare_name ok 41 - Statement handle method "bind_param" works when binding an int column with an int ok 42 - Statement handle method "bind_param" works when rebinding an int column with a string ok 43 - Invalid placeholder fails for bind_param_inout ok 44 - Invalid placeholder fails for bind_param_inout ok 45 - Calling bind_param_inout with a non-scalar reference fails ok 46 - Calling bind_param_inout with a non-scalar reference fails ok 47 - Calling bind_param_inout with a non-scalar reference fails ok 48 - Calling bind_param_inout changes an integer value ok 49 - Calling bind_param_inout changes an integer value ok 50 - Calling bind_param_inout changes a string value ok 51 - Calling bind_param_inout changes a string to a float ok 52 - Calling bind_param_inout works for second placeholder ok 53 - Calling bind_param_inout changes two variables at once ok 54 - Calling bind_param_inout changes two variables at once ok 55 - Statement handle method "bind_param_array" works binding three values to the first placeholder ok 56 - Statement handle method "bind_param_array" works binding one scalar value to the second placeholder ok 57 - Statement handle method "bind_param_array" works binding three values to the second placeholder ok 58 - Statement handle method "bind_param_array" works when binding one value to the second placeholder ok 59 - Statement handle method "bind_param_array" works when binding two values to the second placeholder ok 60 - Statement method handle "execute_array" works ok 61 - Statement method handle "execute_array" returns correct number of rows ok 62 - Statement method handle "execute_array" works with ArrayTupleFetch ok 63 - Statement method handle "execute_array" returns correct number of rows with ArrayTupleFetch ok 64 - Statement handle method "execute_for_fetch" works ok 65 - Statement handle method "execute_for_fetch" returns correct number of rows ok 66 - Statement handle method "fetchrow_arrayref" returns first row correctly ok 67 - Statement handle method "fetchrow_arrayref" returns undef when done ok 68 - Statement handle method alias "fetch" returns first row correctly ok 69 - Statement handle method alias "fetch" returns undef when done ok 70 - Statement handle method "fetchrow_array" returns first row correctly ok 71 - Statement handle method "fetchrow_array" returns an empty list when done ok 72 - Statement handle method "fetchrow_hashref" works with a slice argument ok 73 - Statement handle method "fetchrow_hashref" returns undef when done ok 74 - Statement handle method "fetchall_arrayref" returns first row correctly ok 75 - Statement handle method "fetchall_arrayref" works with an arrayref slice ok 76 - Statement handle method "fetchall_arrayref" works with a hashref slice ok 77 - Statement handle method "fetchall_arrayref" works with an empty hashref slice ok 78 # skip fetchall_arrayref max rows broken in DBI 1.603 ok 79 # skip fetchall_arrayref max rows broken in DBI 1.603 ok 80 - Statement handle method "fetchall_hashref" gives an error when called with no arguments ok 81 - Statement handle method "fetchall_hashref" works with a named key field ok 82 - Statement handle method "fetchall_hashref" works with a numeric key field ok 83 - Statement handle method "fetchall_hashref" returns an empty hash when no rows returned ok 84 - Statement handle method "rows" returns -1 before an execute ok 85 - Statement handle method "rows" returns correct number of rows ok 86 - Statement handle method "bind_col" returns the correct value ok 87 - Statement handle method "bind_col" correctly binds parameters ok 88 - Statement handle method "bind_col" returns the correct value ok 89 - Statement handle method "bind_col" returns the correct value ok 90 - Statement handle method "bind_col" correctly binds parameters ok 91 - Statement handle method "bind_col" correctly binds arrayref ok 92 - Statement handle method "bind_columns" fails when called with wrong number of arguments ok 93 - Statement handle method "bind_columns" returns the correct value ok 94 - Statement handle method "bind_columns" correctly binds parameters ok 95 - Statement handle method "state" returns an empty string on success ok 96 - Statement handle method "state" returns a five-character code on error ok 97 - Statement and database handle method "state" return same code ok 98 - Statement handle method "state" returns expected code ok 99 - Statement handle method "private_attribute_info" returns at least one record ok 100 - Statement handle method "private_attribute_info" returns only internal names ok 101 - Statement handle attribute pg_numbound returns 0 if no placeholders ok 102 - Statement handle attribute pg_numbound returns 0 if no placeholders ok 103 - Statement handle attribute pg_numbound returns 0 if no placeholders bound yet ok 104 - Statement handle attribute pg_numbound returns 1 if one placeholder bound ok 105 - Statement handle attribute pg_numbound returns 2 if two placeholders bound ok 106 - Statement handle attribute pg_numbound returns 1 if one placeholders bound as NULL ok 107 - Statement handle attribute pg_bound returns an empty hash if no placeholders ok 108 - Statement handle attribute pg_bound returns an empty hash if no placeholders ok 109 - Statement handle attribute pg_bound returns correct value if no placeholders bound yet ok 110 - Statement handle attribute pg_bound returns correct value if one placeholder bound ok 111 - Statement handle attribute pg_bound returns correct value if two placeholders bound ok 112 - Statement handle attribute pg_numbound returns 1 if one placeholders bound as NULL ok 113 - Statement handle attribute pg_current_row returns zero until first row fetched ok 114 - Statement handle attribute pg_current_row returns zero until first row fetched ok 115 - Statement handle attribute pg_current_row returns 1 after a fetch ok 116 - Statement handle attribute pg_current_row returns correct value while fetching ok 117 - Statement handle attribute pg_current_row returns correct value while fetching ok 118 - Statement handle attribute pg_current_row returns correct value while fetching ok 119 - Statement handle attribute pg_current_row returns correct value while fetching ok 120 - Statement handle attribute pg_current_row returns 0 when done fetching ok 121 - Statement handle attribute pg_current_row returns 0 after fetchall_arrayref ok 122 - cancel ok NOTICE: RAISE NOTICE FROM dbdpg_test_error_handler WARNING: RAISE WARNING FROM dbdpg_test_error_handler # Checking pg_st_split_statement. This may take a while... t/04misc.t .......... 1..77 ok 1 - Connect to database for miscellaneous tests ok 2 - Method 'server_trace_flag' is available without a database handle ok 3 - Method "server_trace_flag" returns undef on bogus argument ok 4 - Method "server_trace_flag" returns 0x00000100 for DBI value 'SQL' ok 5 - Method "server_trace_flag" returns 0x01000000 for DBD::Pg flag 'pglibpq' ok 6 - Database handle method "server_trace_flag" returns undef on bogus argument ok 7 - Database handle method "server_trace_flag" returns 0x00000100 for DBI value 'SQL' ok 8 - Database handle method 'server_trace_flags' returns 0x01000100 for 'SQL|pglibpq' ok 9 - Database handle method 'server_trace_flags' returns 0x03000100 for 'SQL|pglibpq|pgstart' ok 10 - Database handle method "server_trace_flag" returns 16777216 for flag pglibpq ok 11 - Database handle method 'server_trace_flags' returns 16777216 for flag pglibpq ok 12 - Statement handle method "server_trace_flag" returns 16777216 for flag pglibpq ok 13 - Statement handle method 'server_trace_flags' returns 16777216 for flag pglibpq ok 14 - Database handle method "server_trace_flag" returns 33554432 for flag pgstart ok 15 - Database handle method 'server_trace_flags' returns 33554432 for flag pgstart ok 16 - Statement handle method "server_trace_flag" returns 33554432 for flag pgstart ok 17 - Statement handle method 'server_trace_flags' returns 33554432 for flag pgstart ok 18 - Database handle method "server_trace_flag" returns 67108864 for flag pgend ok 19 - Database handle method 'server_trace_flags' returns 67108864 for flag pgend ok 20 - Statement handle method "server_trace_flag" returns 67108864 for flag pgend ok 21 - Statement handle method 'server_trace_flags' returns 67108864 for flag pgend ok 22 - Database handle method "server_trace_flag" returns 134217728 for flag pgprefix ok 23 - Database handle method 'server_trace_flags' returns 134217728 for flag pgprefix ok 24 - Statement handle method "server_trace_flag" returns 134217728 for flag pgprefix ok 25 - Statement handle method 'server_trace_flags' returns 134217728 for flag pgprefix ok 26 - Database handle method "server_trace_flag" returns 268435456 for flag pglogin ok 27 - Database handle method 'server_trace_flags' returns 268435456 for flag pglogin ok 28 - Statement handle method "server_trace_flag" returns 268435456 for flag pglogin ok 29 - Statement handle method 'server_trace_flags' returns 268435456 for flag pglogin ok 30 - Database handle method "server_trace_flag" returns 536870912 for flag pgquote ok 31 - Database handle method 'server_trace_flags' returns 536870912 for flag pgquote ok 32 - Statement handle method "server_trace_flag" returns 536870912 for flag pgquote ok 33 - Statement handle method 'server_trace_flags' returns 536870912 for flag pgquote ok 34 - Statement attribute 'err' is initially undef not ok 35 - Statement attribute 'err' set to 6 for level notice # TODO Known bug: notice and warnings should set err to 6 # Failed (TODO) test 'Statement attribute 'err' set to 6 for level notice' # at t/04misc.t line 121. # got: undef # expected: '6' not ok 36 - Statement attribute 'err' set to 6 for level warning # TODO Known bug: notice and warnings should set err to 6 # Failed (TODO) test 'Statement attribute 'err' set to 6 for level warning' # at t/04misc.t line 121. # got: undef # expected: '6' ok 37 - Statement attribute 'err' set to 7 for level exception ok 38 - Statement attribute 'err' set to undef when no notices raised ok 39 - Statement attribute 'err' set to undef after statement finishes ok 40 - Trace flag 'SQL' works as expected ok 41 - Trace flag 'pglibpq' works as expected ok 42 - Trace flag 'pgstart' works as expected ok 43 - Trace flag 'pgprefix' works as expected ok 44 - Trace flag 'pgend' works as expected ok 45 - Trace flag 'pglogin' returns undef if no activity ok 46 - Trace flag 'pglogin' works as expected with DBD::Pg->parse_trace_flag() ok 47 - Trace flag 'pglogin' works as expected with DBD::Pg->parse_trace_flag() ok 48 - Trace flag 'pgprefix' and 'pgstart' appended to 'pglogin' work as expected ok 49 - The "data_sources" method did not throw an exception ok 50 - The "data_sources" method returns a template1 listing ok 51 - The "data_sources" method returns undef when fed a bogus second argument ok 52 - The "data_sources" method returns information when fed a valid port as the second arg ok 53 - The "data_sources" method returns information when 'dbi:Pg' is uppercased ok 54 - The "data_sources" method returns information when 'DBI:' is mixed case ok 55 - Using $DBDPG_DEFAULT (DBD::Pg::DefaultValue=HASH(0x23400e0)) works ok 56 - Raw ROLLBACK via do() resets the transaction status correctly ok 57 - Raw ROLLBACK via do() resets the transaction status correctly ok 58 - Using dbh->commit() resets the transaction status correctly ok 59 - Using dbh->commit() resets the transaction status correctly ok 60 - Raw COMMIT via do() resets the transaction status correctly ok 61 - Raw COMMIT via do() resets the transaction status correctly ok 62 - Calling COMMIT via prepare/execute resets the transaction status correctly ok 63 - pg_st_split_statement gave no problems with various lengths ok 64 - prepare/execute works with 2 placeholders ok 65 - prepare/execute works with 4 placeholders ok 66 - prepare/execute works with 8 placeholders ok 67 - prepare/execute works with 16 placeholders ok 68 - prepare/execute works with 32 placeholders ok 69 - prepare/execute works with 64 placeholders ok 70 - prepare/execute works with 128 placeholders ok 71 - prepare/execute works with 256 placeholders ok 72 - prepare/execute works with 512 placeholders ok 73 - prepare/execute works with 1024 placeholders ok 74 - prepare/execute works with 2048 placeholders ok 75 - prepare/execute works with 4096 placeholders ok 76 - prepare/execute works with 8192 placeholders ok 77 - Using bind_param with type 1 yields a correct bpchar value ok t/06bytea.t ......... 1..16 ok 1 - Connect to database for bytea testing ok 2 - bytea insert test with string containing null and backslashes ok 3 - bytea insert test with string containing a single quote ok 4 - bytea (second) insert test with string containing a single quote ok 5 - store binary data in BYTEA column ok 6 - store binary data in BYTEA column ok 7 - Received correct text from BYTEA column with backslashes (hex output) ok 8 - Received correct text from BYTEA column with quote (hex output) ok 9 - Ensure proper handling of high bit characters (hex output) ok 10 - Ensure proper handling of high bit characters (hex output) ok 11 - quote properly handles bytea strings (hex output) ok 12 - Received correct text from BYTEA column with backslashes (escape output) ok 13 - Received correct text from BYTEA column with quote (escape output) ok 14 - Ensure proper handling of high bit characters (escape output) ok 15 - Ensure proper handling of high bit characters (escape output) ok 16 - quote properly handles bytea strings (escape output) ok t/07copy.t .......... 1..57 ok 1 - Connect to database for bytea testing ok 2 - pg_putline fails when issued without a preceding COPY command ok 3 - putline returned a value of 1 for success ok 4 - putline returned a value of 1 for success ok 5 - putline returned a value of 1 for success ok 6 - do() fails while in a COPY IN state ok 7 - pg_getline fails while in a COPY IN state ok 8 - pg_endcopy returned a 1 ok 9 - pg_putline fails when issued after pg_endcopy called ok 10 - putline inserted values correctly ok 11 - pg_endcopy fails when called twice after COPY IN ok 12 - pg_getline fails when issued without a preceding COPY command ok 13 - pg_getline returns a 1 ok 14 - do() fails while in a COPY OUT state ok 15 - pg_putline fails while in a COPY OUT state ok 16 - pg_getline returned a 1 ok 17 - pg_getline returned a 1 ok 18 - pg_getline returns empty on final call ok 19 - getline returned all rows successfuly ok 20 - pg_getline fails when issued after pg_endcopy called ok 21 - pg_endcopy fails when called twice after COPY OUT ok 22 - pg_putcopydata fails if not after a COPY FROM statement ok 23 - pg_getcopydata fails if not after a COPY TO statement ok 24 - pg_getcopydata_async fails if not after a COPY TO statement ok 25 - pg_putcopyend warns but does not die if not after a COPY statement ok 26 - pg_getcopydata does not work if we are using COPY .. TO ok 27 - pg_putcopydata does not work if we are using COPY .. FROM ok 28 - pg_putcopydata works and returns a 1 on success ok 29 - pg_putcopydata works on second call ok 30 - pg_putcopydata fails with invalid data ok 31 - Calling pg_getcopydata gives an error when in the middle of COPY .. TO ok 32 - Calling do() gives an error when in the middle of COPY .. FROM ok 33 - pg_putcopydata works after a rude non-COPY attempt ok 34 - pg_putcopydata works after a rude non-COPY attempt ok 35 - pg_putcopyend works and returns a 1 ok 36 - pg_putcopyend works and returns a 1 ok 37 - pg_putcopydata fails after pg_putcopyend is called ok 38 - Normal queries work after pg_putcopyend is called ok 39 - Data from pg_putcopydata was entered correctly ok 40 - pg_getcopydata fails when argument is not a variable ok 41 - pg_getcopydata works and returns the length of the string ok 42 - pg_getcopydata works and returns the length of the string ok 43 - pg_getcopydata works when argument is a reference ok 44 - pg_getcopydata works when argument is a reference ok 45 - Calling do() gives an error when in the middle of COPY .. TO ok 46 - Calling pg_putcopydata gives an errors when in the middle of COPY .. FROM ok 47 - pg_getcopydata returns 0 when no more data ok 48 - pg_getcopydata returns 0 when no more data ok 49 - pg_getcopydata returns 0 when no more data ok 50 - Normal queries work after pg_getcopydata runs out ok 51 - Async queries work after COPY OUT ok 52 - Async queries work after COPY IN ok 53 - pg_getcopydata works when pulling from an empty table into an empty var ok 54 - commit resets COPY state ok 55 - rollback resets COPY state ok 56 - old-style dbh->func('text', 'putline') still works ok 57 - old-style dbh->func(var, length, 'getline') still works ok t/08async.t ......... 1..67 ok 1 - Connect to database for async testing ok 2 - Method do() works as expected with no args ok 3 - Method do() works as expected with no args ok 4 - Method do() works as expected with an unused attribute ok 5 - Method do() works as expected with an unused attribute ok 6 - Method do() works as expected with an unused attribute and a non-prepared param ok 7 - Method do() works as expected with an unused attribute and a non-prepared param ok 8 - Method do() works as expected with an unused attribute and multiple real bind params ok 9 - Method do() works as expected with an unused attribute and multiple real bind params ok 10 - Cancelling a non-async do() query gives an error ok 11 - Method do() works as expected with an asychronous flag ok 12 - Method do() works as expected with an asychronous flag ok 13 - Database attribute "async_status" returns 1 after async query ok 14 - Cancelling an async do() query works ok 15 - Database method pg_cancel returns a false value when cancellation works but finished ok 16 - Database attribute "async_status" returns -1 after pg_cancel ok 17 - Running do() after a cancelled query works ok 18 - Database attribute "async_status" returns 0 after normal query run ok 19 - Method pg_ready() fails after a non-async query ok 20 - Method pg_ready() works after a non-async query ok 21 - Database method pg_ready() returns 1 after a completed async do() ok 22 - Database method pg_ready() returns true when called a second time ok 23 - Database method pg_ready() returns 1 after a completed async do() ok 24 - Cancelling an async do() query works ok 25 - Database method pg_cancel() returns expected false value for completed value ok 26 - Method do() runs after pg_cancel has cleared the async query ok 27 - Method do() fails when async query has not been cleared ok 28 - Database method pg_result works as expected ok 29 - Database method pg_result() returns correct value ok 30 - Database method pg_result() fails when called twice ok 31 - Database method pg_cancel() fails when called after pg_result() ok 32 - Database method pg_ready() fails when called after pg_result() ok 33 - Database method do() works after pg_result() ok 34 - Calling pg_sleep works as expected ok 35 - Database method do() returns right away when in async mode ok 36 - Method pg_ready() returns false when query is still running ok 37 - Sleeping to allow query to finish ok 38 - Method pg_ready() returns true when query is finished ok 39 - Method do() will not work if async query not yet cleared ok 40 - Database method pg_cancel() works while async query is running ok 41 - Database method pg_cancel returns false when query has already finished ok 42 - Database method pg_result() fails after async query has been cancelled ok 43 - Database method do() cancels the previous async when requested ok 44 - Database method pg_result works when async query is still running ok 45 - Running execute after async do() gives an error ok 46 - Running execute after async do() works when told to cancel ok 47 - Running execute after async do() works when told to wait ok 48 - Method execute() works when prepare has PG_ASYNC flag ok 49 - Database attribute "async_status" returns 1 after prepare async ok 50 - Method do() fails when previous async prepare has been executed ok 51 - Method execute() fails when previous async prepare has been executed ok 52 - Database method pg_cancel works if async query has already finished ok 53 - Statement method pg_cancel() returns a false value when cancellation works but finished ok 54 - Method do() fails when previous execute async has not been cleared ok 55 - Directly after pg_cancel(), pg_async_status is -1 ok 56 - After async execute, pg_async_status is 1 ok 57 - Method pg_result works after a prepare/execute call ok 58 - Method pg_result() returns expected result after prepare/execute select ok 59 - Method fetchall_arrayref works after pg_result ok 60 - Method fetchall_arrayref returns correct result after pg_result ok 61 - Method prepare() works when passed in PG_OLDQUERY_CANCEL ok 62 - Fetch on cancelled statement handle fails ok 63 - Method execute works after async + cancel prepare ok 64 - Statement method pg_result works on async statement handle ok 65 - Statement method pg_result returns correct result after execute ok 66 - Database method pg_result works on async statement handle ok 67 - Database method pg_result returns correct result after execute ok t/09arrays.t ........ 1..200 ok 1 - Connect to database for array testing ok 2 - Array quoting allows direct insertion into statements ok 3 - [bind] Array insert success : Empty array : [''] ok 4 - [bind][!expand] Correct array inserted: Empty array : [''] ok 5 - [bind][expand] Correct array inserted: Empty array : [''] ok 6 - [quote] Array insert success : Empty array : [''] ok 7 - [quote][expand] Correct array inserted: Empty array : [''] ok 8 - [bind] Array insert success : Empty array with two levels : [['']] ok 9 - [bind][!expand] Correct array inserted: Empty array with two levels : [['']] ok 10 - [bind][expand] Correct array inserted: Empty array with two levels : [['']] ok 11 - [quote] Array insert success : Empty array with two levels : [['']] ok 12 - [quote][expand] Correct array inserted: Empty array with two levels : [['']] ok 13 - [bind] Array insert success : Empty array with three levels : [[['']]] ok 14 - [bind][!expand] Correct array inserted: Empty array with three levels : [[['']]] ok 15 - [bind][expand] Correct array inserted: Empty array with three levels : [[['']]] ok 16 - [quote] Array insert success : Empty array with three levels : [[['']]] ok 17 - [quote][expand] Correct array inserted: Empty array with three levels : [[['']]] ok 18 - [bind] Array insert success : Two empty arrays : [[''],['']] ok 19 - [bind][!expand] Correct array inserted: Two empty arrays : [[''],['']] ok 20 - [bind][expand] Correct array inserted: Two empty arrays : [[''],['']] ok 21 - [quote] Array insert success : Two empty arrays : [[''],['']] ok 22 - [quote][expand] Correct array inserted: Two empty arrays : [[''],['']] ok 23 - [bind] Array insert success : Three empty arrays at second level : [[[''],[''],['']]] ok 24 - [bind][!expand] Correct array inserted: Three empty arrays at second level : [[[''],[''],['']]] ok 25 - [bind][expand] Correct array inserted: Three empty arrays at second level : [[[''],[''],['']]] ok 26 - [quote] Array insert success : Three empty arrays at second level : [[[''],[''],['']]] ok 27 - [quote][expand] Correct array inserted: Three empty arrays at second level : [[[''],[''],['']]] ok 28 - [bind] Array insert error : Unbalanced empty arrays : [[],[[]]] ok 29 - [quote] Array insert error : Unbalanced empty arrays : [[],[[]]] ok 30 - [bind] Array insert error : Bare hashref : {} ok 31 - [quote] Array insert error : Bare hashref : {} ok 32 - [bind] Array insert error : Hashref at top level : [{}] ok 33 - [quote] Array insert error : Hashref at top level : [{}] ok 34 - [bind] Array insert error : Hidden hashref : [1,2,{3,4},5] ok 35 - [quote] Array insert error : Hidden hashref : [1,2,{3,4},5] ok 36 - [bind] Array insert error : Unbalanced array : [[1,2],[3]] ok 37 - [quote] Array insert error : Unbalanced array : [[1,2],[3]] ok 38 - [bind] Array insert error : Unbalanced array : [[1,2],[3,4,5]] ok 39 - [quote] Array insert error : Unbalanced array : [[1,2],[3,4,5]] ok 40 - [bind] Array insert error : Unbalanced array : [[1,2],[]] ok 41 - [quote] Array insert error : Unbalanced array : [[1,2],[]] ok 42 - [bind] Array insert error : Unbalanced array : [[],[3]] ok 43 - [quote] Array insert error : Unbalanced array : [[],[3]] ok 44 - [bind] Array insert success : Simple 1-D numeric array : [123] ok 45 - [bind][!expand] Correct array inserted: Simple 1-D numeric array : [123] ok 46 - [bind][expand] Correct array inserted: Simple 1-D numeric array : [123] ok 47 - [quote] Array insert success : Simple 1-D numeric array : [123] ok 48 - [quote][expand] Correct array inserted: Simple 1-D numeric array : [123] ok 49 - [bind] Array insert success : Simple 1-D text array : ['abc'] ok 50 - [bind][!expand] Correct array inserted: Simple 1-D text array : ['abc'] ok 51 - [bind][expand] Correct array inserted: Simple 1-D text array : ['abc'] ok 52 - [quote] Array insert success : Simple 1-D text array : ['abc'] ok 53 - [quote][expand] Correct array inserted: Simple 1-D text array : ['abc'] ok 54 - [bind] Array insert success : Text array with commas and quotes : ['a','b,c'] ok 55 - [bind][!expand] Correct array inserted: Text array with commas and quotes : ['a','b,c'] ok 56 - [bind][expand] Correct array inserted: Text array with commas and quotes : ['a','b,c'] ok 57 - [quote] Array insert success : Text array with commas and quotes : ['a','b,c'] ok 58 - [quote][expand] Correct array inserted: Text array with commas and quotes : ['a','b,c'] ok 59 - [bind] Array insert success : Text array with commas, escaped closing brace : ['a','b,}'] ok 60 - [bind][!expand] Correct array inserted: Text array with commas, escaped closing brace : ['a','b,}'] ok 61 - [bind][expand] Correct array inserted: Text array with commas, escaped closing brace : ['a','b,}'] ok 62 - [quote] Array insert success : Text array with commas, escaped closing brace : ['a','b,}'] ok 63 - [quote][expand] Correct array inserted: Text array with commas, escaped closing brace : ['a','b,}'] ok 64 - [bind] Array insert success : Text array with commas, escaped closing bracket : ['a','b,]'] ok 65 - [bind][!expand] Correct array inserted: Text array with commas, escaped closing bracket : ['a','b,]'] ok 66 - [bind][expand] Correct array inserted: Text array with commas, escaped closing bracket : ['a','b,]'] ok 67 - [quote] Array insert success : Text array with commas, escaped closing bracket : ['a','b,]'] ok 68 - [quote][expand] Correct array inserted: Text array with commas, escaped closing bracket : ['a','b,]'] ok 69 - [bind] Array insert success : Simple 1-D numeric array : [1,2] ok 70 - [bind][!expand] Correct array inserted: Simple 1-D numeric array : [1,2] ok 71 - [bind][expand] Correct array inserted: Simple 1-D numeric array : [1,2] ok 72 - [quote] Array insert success : Simple 1-D numeric array : [1,2] ok 73 - [quote][expand] Correct array inserted: Simple 1-D numeric array : [1,2] ok 74 - [bind] Array insert success : Simple 2-D numeric array : [[1]] ok 75 - [bind][!expand] Correct array inserted: Simple 2-D numeric array : [[1]] ok 76 - [bind][expand] Correct array inserted: Simple 2-D numeric array : [[1]] ok 77 - [quote] Array insert success : Simple 2-D numeric array : [[1]] ok 78 - [quote][expand] Correct array inserted: Simple 2-D numeric array : [[1]] ok 79 - [bind] Array insert success : Simple 2-D numeric array : [[1,2]] ok 80 - [bind][!expand] Correct array inserted: Simple 2-D numeric array : [[1,2]] ok 81 - [bind][expand] Correct array inserted: Simple 2-D numeric array : [[1,2]] ok 82 - [quote] Array insert success : Simple 2-D numeric array : [[1,2]] ok 83 - [quote][expand] Correct array inserted: Simple 2-D numeric array : [[1,2]] ok 84 - [bind] Array insert success : Simple 3-D numeric array : [[[1]]] ok 85 - [bind][!expand] Correct array inserted: Simple 3-D numeric array : [[[1]]] ok 86 - [bind][expand] Correct array inserted: Simple 3-D numeric array : [[[1]]] ok 87 - [quote] Array insert success : Simple 3-D numeric array : [[[1]]] ok 88 - [quote][expand] Correct array inserted: Simple 3-D numeric array : [[[1]]] ok 89 - [bind] Array insert success : 3-D mixed array : [[["alpha",2],[23,"pop"]]] ok 90 - [bind][!expand] Correct array inserted: 3-D mixed array : [[["alpha",2],[23,"pop"]]] ok 91 - [bind][expand] Correct array inserted: 3-D mixed array : [[["alpha",2],[23,"pop"]]] ok 92 - [quote] Array insert success : 3-D mixed array : [[["alpha",2],[23,"pop"]]] ok 93 - [quote][expand] Correct array inserted: 3-D mixed array : [[["alpha",2],[23,"pop"]]] ok 94 - [bind] Array insert success : 3-D mixed array : [[[1,2,3],[4,5,"6"],["seven","8","9"]]] ok 95 - [bind][!expand] Correct array inserted: 3-D mixed array : [[[1,2,3],[4,5,"6"],["seven","8","9"]]] ok 96 - [bind][expand] Correct array inserted: 3-D mixed array : [[[1,2,3],[4,5,"6"],["seven","8","9"]]] ok 97 - [quote] Array insert success : 3-D mixed array : [[[1,2,3],[4,5,"6"],["seven","8","9"]]] ok 98 - [quote][expand] Correct array inserted: 3-D mixed array : [[[1,2,3],[4,5,"6"],["seven","8","9"]]] ok 99 - [bind] Array insert success : Simple single quote : [q{O'RLY?}] ok 100 - [bind][!expand] Correct array inserted: Simple single quote : [q{O'RLY?}] ok 101 - [bind][expand] Correct array inserted: Simple single quote : [q{O'RLY?}] ok 102 - [quote] Array insert success : Simple single quote : [q{O'RLY?}] ok 103 - [quote][expand] Correct array inserted: Simple single quote : [q{O'RLY?}] ok 104 - [bind] Array insert success : Simple double quote : [q{O"RLY?}] ok 105 - [bind][!expand] Correct array inserted: Simple double quote : [q{O"RLY?}] ok 106 - [bind][expand] Correct array inserted: Simple double quote : [q{O"RLY?}] ok 107 - [quote] Array insert success : Simple double quote : [q{O"RLY?}] ok 108 - [quote][expand] Correct array inserted: Simple double quote : [q{O"RLY?}] ok 109 - [bind] Array insert success : Many quotes : [[q{O"RLY?}],[q|'Ya' - "really"|],[123]] ok 110 - [bind][!expand] Correct array inserted: Many quotes : [[q{O"RLY?}],[q|'Ya' - "really"|],[123]] ok 111 - [bind][expand] Correct array inserted: Many quotes : [[q{O"RLY?}],[q|'Ya' - "really"|],[123]] ok 112 - [quote] Array insert success : Many quotes : [[q{O"RLY?}],[q|'Ya' - "really"|],[123]] ok 113 - [quote][expand] Correct array inserted: Many quotes : [[q{O"RLY?}],[q|'Ya' - "really"|],[123]] ok 114 - [bind] Array insert success : Single backslash testing : ["Single\\Backslash"] ok 115 - [bind][!expand] Correct array inserted: Single backslash testing : ["Single\\Backslash"] ok 116 - [bind][expand] Correct array inserted: Single backslash testing : ["Single\\Backslash"] ok 117 - [quote] Array insert success : Single backslash testing : ["Single\\Backslash"] ok 118 - [quote][expand] Correct array inserted: Single backslash testing : ["Single\\Backslash"] ok 119 - [bind] Array insert success : Double backslash testing : ["Double\\\\Backslash"] ok 120 - [bind][!expand] Correct array inserted: Double backslash testing : ["Double\\\\Backslash"] ok 121 - [bind][expand] Correct array inserted: Double backslash testing : ["Double\\\\Backslash"] ok 122 - [quote] Array insert success : Double backslash testing : ["Double\\\\Backslash"] ok 123 - [quote][expand] Correct array inserted: Double backslash testing : ["Double\\\\Backslash"] ok 124 - [bind] Array insert success : Escape party - backslash+newline, two + one : [["Test\\nRun","Quite \"so\""],["back\\\\slashes are a \"pa\\in\"",123] ] ok 125 - [bind][!expand] Correct array inserted: Escape party - backslash+newline, two + one : [["Test\\nRun","Quite \"so\""],["back\\\\slashes are a \"pa\\in\"",123] ] ok 126 - [bind][expand] Correct array inserted: Escape party - backslash+newline, two + one : [["Test\\nRun","Quite \"so\""],["back\\\\slashes are a \"pa\\in\"",123] ] ok 127 - [quote] Array insert success : Escape party - backslash+newline, two + one : [["Test\\nRun","Quite \"so\""],["back\\\\slashes are a \"pa\\in\"",123] ] ok 128 - [quote][expand] Correct array inserted: Escape party - backslash+newline, two + one : [["Test\\nRun","Quite \"so\""],["back\\\\slashes are a \"pa\\in\"",123] ] ok 129 - [bind] Array insert success : Simple undef test : [undef] ok 130 - [bind][!expand] Correct array inserted: Simple undef test : [undef] ok 131 - [bind][expand] Correct array inserted: Simple undef test : [undef] ok 132 - [quote] Array insert success : Simple undef test : [undef] ok 133 - [quote][expand] Correct array inserted: Simple undef test : [undef] ok 134 - [bind] Array insert success : Simple undef test : [[undef]] ok 135 - [bind][!expand] Correct array inserted: Simple undef test : [[undef]] ok 136 - [bind][expand] Correct array inserted: Simple undef test : [[undef]] ok 137 - [quote] Array insert success : Simple undef test : [[undef]] ok 138 - [quote][expand] Correct array inserted: Simple undef test : [[undef]] ok 139 - [bind] Array insert success : Multiple undef test : [[1,2],[undef,3],["four",undef],[undef,undef]] ok 140 - [bind][!expand] Correct array inserted: Multiple undef test : [[1,2],[undef,3],["four",undef],[undef,undef]] ok 141 - [bind][expand] Correct array inserted: Multiple undef test : [[1,2],[undef,3],["four",undef],[undef,undef]] ok 142 - [quote] Array insert success : Multiple undef test : [[1,2],[undef,3],["four",undef],[undef,undef]] ok 143 - [quote][expand] Correct array inserted: Multiple undef test : [[1,2],[undef,3],["four",undef],[undef,undef]] ok 144 - String array with no items returns empty array ok 145 - String array with empty string returns empty string ok 146 - Integer array with no items returns empty array ok 147 - Boolean array with no items returns empty array ok 148 - Boolean array gets created and returned correctly ok 149 - Boolean array gets created and returned correctly ok 150 - Boolean array gets created and returned correctly ok 151 - Boolean array gets created and returned correctly ok 152 - Boolean array gets created and returned correctly ok 153 - Array test Simple test of single array element : 1 ok 154 - Array test Simple test of multiple array elements : 1,2 ok 155 - Array test Simple test of multiple array elements : 1,2,3 ok 156 - Array test Array with text items : 'a','b' ok 157 - Array test Array with numeric items : 0.1,2.4 ok 158 - Array test Array with escaped items : 'My"lrd','b','c' ok 159 - Array test Multi-level integer array : [1] ok 160 - Array test Multi-level integer array : [[1,2]] ok 161 - Array test Multi-level integer array : [[1],[2]] ok 162 - Array test Multi-level integer array : [[1],[2],[3]] ok 163 - Array test Multi-level integer array : [[[1]],[[2]],[[3]]] ok 164 - Array test Array with a null : 'abc',NULL ok 165 - Array test Array with many nulls and a quoted int : ['abc','NULL',NULL,NULL,123::text] ok 166 - Array test Final item is empty : ['abc',''] ok 167 - Array test Last item is NULL : 1,NULL ok 168 - Array test Only item is NULL : NULL ok 169 - Array test Two NULL items only : NULL,NULL ok 170 - Array test Three NULL items only : NULL,NULL,NULL ok 171 - Array test Middle item is NULL : [123,NULL,456] ok 172 - Array test First item is NULL : NULL,'abc' ok 173 - Array test Fake NULL is text : 'a','NULL' ok 174 - Array test Deep nesting : [[[[[1,2,3]]]]] ok 175 - Array test Deep nesting : [[[[[1],[2],[3]]]]] ok 176 - Array test Deep nesting : [[[[[1]]],[[[2]]],[[[3]]]]] ok 177 - Array test Deep nesting : [[[[[1]],[[2]],[[3]]]]] ok 178 - Array test Test of boolean type : 1::bool ok 179 - Array test Test of boolean types : 1::bool,0::bool,'true'::boolean ok 180 - Array test Test of oid type - should not quote : 1::oid ok 181 - Array test Text number should quote : 1::text ok 182 - Array test Unspecified int should not quote : 1,2,3 ok 183 - Array test Integer number should quote : 1::int ok 184 - Array test Type 'box' works : '(1,2),(4,5)'::box,'(5,3),(4,5)' ok 185 - String should be UTF-8 ok 186 - quote() handles utf8 ok 187 - Quoted string should be UTF-8 ok 188 - quote() handles utf8 inside array ok 189 - Quoted array of strings should be UTF-8 ok 190 - Inserting utf-8 into an array via quoted do() works ok 191 - Retreiving an array containing utf-8 works ok 192 - Selected string should be UTF-8 ok 193 - Selected string should be UTF-8 ok 194 - Inserting utf-8 into an array via prepare and arrayref works ok 195 - Retreiving an array containing utf-8 works ok 196 - Selected ASCII string should be UTF-8 ok 197 - Selected string should be UTF-8 ok 198 - Non utf-8 inside an array is not return as utf-8 ok 199 - Empty int array is returned properly ok 200 - Empty text array is returned properly ok t/12placeholders.t .. 1..251 ok 1 - Connect to database for placeholder testing ok 2 - Quoting works properly ok 3 - Quoting works with a function call ok 4 - Quoting works with a function call ok 5 - Quoting works with a function call ok 6 - Quoting works with a function call ok 7 - Fetch returns the correct quoted value ok 8 - Execute with one bind param where none expected fails ok 9 - Execute with ? placeholder works ok 10 - Execute with :1 placeholder works ok 11 - Execute with $1 placeholder works ok 12 - Execute with quoted ? fails with a placeholder ok 13 - Execute with quoted :1 fails with a placeholder ok 14 - Execute with quoted ? fails with a placeholder ok 15 - Execute with named placeholders works ok 16 - Execute with named placeholders works ok 17 - Execute with named placeholders works ok 18 - Execute with repeated named placeholders works ok 19 - Execute with repeated named placeholders works ok 20 - Prepare with large number of parameters works ok 21 - Prepare with backslashes inside quotes works ok 22 - Geometric type test: point datatype integers ok 23 - Geometric type test: point datatype integers ok 24 - Geometric type test: point datatype floating point numbers ok 25 - Geometric type test: point datatype floating point numbers ok 26 - Geometric type test: point datatype exponential numbers ok 27 - Geometric type test: point datatype exponential numbers ok 28 - Geometric type test: point datatype plus and minus signs ok 29 - Geometric type test: point datatype plus and minus signs ok 30 - Geometric type test: point datatype invalid number ok 31 - Geometric type test: point datatype invalid number ok 32 - Geometric type test: point datatype invalid number ok 33 - Geometric type test: point datatype invalid format ok 34 - Geometric type test: point datatype invalid format ok 35 - Geometric type test: point datatype invalid format ok 36 - Geometric type test: point datatype invalid format ok 37 - Geometric type test: point datatype invalid format ok 38 - Geometric type test: point datatype invalid format ok 39 - Geometric type test: point datatype invalid format ok 40 - Geometric type test: point datatype invalid format ok 41 - Geometric type test: point datatype invalid format ok 42 - Geometric type test: point datatype invalid format ok 43 - Geometric type test: point datatype invalid format ok 44 - Geometric type test: point datatype invalid format ok 45 - Geometric type test: line datatype integers ok 46 - Geometric type test: line datatype integers ok 47 - Geometric type test: line datatype integers ok 48 - Geometric type test: line datatype floating point numbers ok 49 - Geometric type test: line datatype floating point numbers ok 50 - Geometric type test: line datatype floating point numbers ok 51 - Geometric type test: line datatype exponential numbers ok 52 - Geometric type test: line datatype exponential numbers ok 53 - Geometric type test: line datatype exponential numbers ok 54 - Geometric type test: line datatype plus and minus signs ok 55 - Geometric type test: line datatype plus and minus signs ok 56 - Geometric type test: line datatype plus and minus signs ok 57 - Geometric type test: line datatype invalid number ok 58 - Geometric type test: line datatype invalid number ok 59 - Geometric type test: line datatype invalid number ok 60 - Geometric type test: lseg datatype invalid format ok 61 - Geometric type test: lseg datatype invalid format ok 62 - Geometric type test: lseg datatype invalid format ok 63 - Geometric type test: lseg datatype integers ok 64 - Geometric type test: lseg datatype integers ok 65 - Geometric type test: lseg datatype floating point and exponential numbers ok 66 - Geometric type test: lseg datatype floating point and exponential numbers ok 67 - Geometric type test: box datatype invalid format ok 68 - Geometric type test: box datatype invalid format ok 69 - Geometric type test: box datatype invalid format ok 70 - Geometric type test: box datatype integers ok 71 - Geometric type test: box datatype integers ok 72 - Geometric type test: box datatype floating point and exponential numbers ok 73 - Geometric type test: box datatype floating point and exponential numbers ok 74 - Geometric type test: path datatype invalid format ok 75 - Geometric type test: path datatype integers ok 76 - Geometric type test: path datatype integers ok 77 - Geometric type test: path datatype floating point and exponential numbers ok 78 - Geometric type test: path datatype floating point and exponential numbers ok 79 - Geometric type test: path datatype alternate bracket format ok 80 - Geometric type test: path datatype alternate bracket format ok 81 - Geometric type test: path datatype many elements ok 82 - Geometric type test: path datatype many elements ok 83 - Geometric type test: path datatype fails with braces ok 84 - Geometric type test: path datatype fails with braces ok 85 - Geometric type test: path datatype fails with braces ok 86 - Geometric type test: polygon datatype invalid format ok 87 - Geometric type test: polygon datatype integers ok 88 - Geometric type test: polygon datatype integers ok 89 - Geometric type test: polygon datatype floating point and exponential numbers ok 90 - Geometric type test: polygon datatype floating point and exponential numbers ok 91 - Geometric type test: polygon datatype many elements ok 92 - Geometric type test: polygon datatype many elements ok 93 - Geometric type test: polygon datatype fails with brackets ok 94 - Geometric type test: polygon datatype fails with brackets ok 95 - Geometric type test: polygon datatype fails with brackets ok 96 - Geometric type test: circle datatype invalid format ok 97 - Geometric type test: circle datatype invalid format ok 98 - Geometric type test: circle datatype invalid format ok 99 - Geometric type test: circle datatype integers ok 100 - Geometric type test: circle datatype integers ok 101 - Geometric type test: circle datatype floating point and exponential numbers ok 102 - Geometric type test: circle datatype floating point and exponential numbers ok 103 - Geometric type test: circle datatype fails with brackets ok 104 - Geometric type test: circle datatype fails with brackets ok 105 - Geometric type test: circle datatype fails with brackets ok 106 - Calling do() with non-DML placeholder works ok 107 - Calling do() with DML placeholder works ok 108 - Calling do() with invalid crowded placeholders fails cleanly ok 109 - Prepare/execute with non-DML placeholder works ok 110 - Prepare/execute does not allow geometric operators ok 111 - Prepare/execute allows geometric operator ?- when dollaronly is set ok 112 - Prepare/execute allows geometric operator ?\# when dollaronly set ok 113 - Value of placeholder_dollaronly can be retrieved ok 114 - Prepare/execute does not allow use of raw ? and :foo forms ok 115 - Prepare/execute allows use of raw ? and :foo forms when dollaronly set ok 116 - Prepare works with pg_placeholder_dollaronly ok 117 - Value of placeholder_nocolons defaults to 0 ok 118 - Simple array slices do not get picked up as placeholders ok 119 - Without placeholder_nocolons, queries with array slices fail ok 120 - Use of statement level placeholder_nocolons allows use of ? placeholders while ignoring : ok 121 - Use of database level placeholder_nocolons allows use of ? placeholders while ignoring : ok 122 - Value of placeholder_nocolons can be retrieved ok 123 - Use of statement level placeholder_nocolons allows use of $ placeholders while ignoring : ok 124 - Use of database level placeholder_nocolons allows use of $ placeholders while ignoring : ok 125 - Prepare works with identical named placeholders ok 126 - Prepare works with placeholders after double slashes ok 127 - Dollar quotes starting with a number are not treated as valid identifiers ok 128 - Dollar quotes with invalid characters are not parsed as identifiers: char=+ ok 129 - Dollar quotes with invalid characters are not parsed as identifiers: char=/ ok 130 - Dollar quotes with invalid characters are not parsed as identifiers: char=: ok 131 - Dollar quotes with invalid characters are not parsed as identifiers: char=@ ok 132 - Dollar quotes with invalid characters are not parsed as identifiers: char=[ ok 133 - Dollar quotes with invalid characters are not parsed as identifiers: char=` ok 134 - Dollar quotes with valid characters are parsed as identifiers ok 135 - Dollar quotes with valid characters are parsed as identifiers ok 136 - Dollar quotes with valid characters are parsed as identifiers ok 137 - Dollar quotes with valid characters are parsed as identifiers ok 138 - Dollar quotes with valid characters are parsed as identifiers ok 139 - Dollar quotes with valid characters are parsed as identifiers ok 140 - Dollar quotes with valid characters are parsed as identifiers ok 141 - Dollar quotes with valid characters are parsed as identifiers ok 142 - Dollar quotes with valid characters are parsed as identifiers ok 143 - Backslash quoting inside double quotes is parsed correctly ok 144 - Backslash quoting inside single quotes is parsed correctly with standard_conforming_strings off ok 145 - Backslash quoting inside single quotes is parsed correctly with standard_conforming_strings on ok 146 - Valid integer works when quoting with SQL_INTEGER ok 147 - Invalid integer fails to pass through when quoting with SQL_INTEGER ok 148 - Invalid integer fails to pass through when quoting with SQL_INTEGER ok 149 - Valid float value works when quoting with SQL_FLOAT (value=123) ok 150 - Valid float value works when quoting with SQL_FLOAT (value=123) ok 151 - Valid float value works when quoting with SQL_FLOAT (value=123) ok 152 - Valid float value works when quoting with SQL_FLOAT (value=123) ok 153 - Valid float value works when quoting with SQL_FLOAT (value=123) ok 154 - Valid float value works when quoting with SQL_FLOAT (value=123) ok 155 - Valid float value works when quoting with SQL_FLOAT (value=0.00) ok 156 - Valid float value works when quoting with SQL_FLOAT (value=0.00) ok 157 - Valid float value works when quoting with SQL_FLOAT (value=0.00) ok 158 - Valid float value works when quoting with SQL_FLOAT (value=0.00) ok 159 - Valid float value works when quoting with SQL_FLOAT (value=0.00) ok 160 - Valid float value works when quoting with SQL_FLOAT (value=0.00) ok 161 - Valid float value works when quoting with SQL_FLOAT (value=0.234) ok 162 - Valid float value works when quoting with SQL_FLOAT (value=0.234) ok 163 - Valid float value works when quoting with SQL_FLOAT (value=0.234) ok 164 - Valid float value works when quoting with SQL_FLOAT (value=0.234) ok 165 - Valid float value works when quoting with SQL_FLOAT (value=0.234) ok 166 - Valid float value works when quoting with SQL_FLOAT (value=0.234) ok 167 - Valid float value works when quoting with SQL_FLOAT (value=23.31562) ok 168 - Valid float value works when quoting with SQL_FLOAT (value=23.31562) ok 169 - Valid float value works when quoting with SQL_FLOAT (value=23.31562) ok 170 - Valid float value works when quoting with SQL_FLOAT (value=23.31562) ok 171 - Valid float value works when quoting with SQL_FLOAT (value=23.31562) ok 172 - Valid float value works when quoting with SQL_FLOAT (value=23.31562) ok 173 - Valid float value works when quoting with SQL_FLOAT (value=1.23e04) ok 174 - Valid float value works when quoting with SQL_FLOAT (value=1.23e04) ok 175 - Valid float value works when quoting with SQL_FLOAT (value=1.23e04) ok 176 - Valid float value works when quoting with SQL_FLOAT (value=1.23e04) ok 177 - Valid float value works when quoting with SQL_FLOAT (value=1.23E04) ok 178 - Valid float value works when quoting with SQL_FLOAT (value=1.23E04) ok 179 - Valid float value works when quoting with SQL_FLOAT (value=6.54e+02) ok 180 - Valid float value works when quoting with SQL_FLOAT (value=6.54e+02) ok 181 - Valid float value works when quoting with SQL_FLOAT (value=6.54e+02) ok 182 - Valid float value works when quoting with SQL_FLOAT (value=6.54e+02) ok 183 - Valid float value works when quoting with SQL_FLOAT (value=6.54E+02) ok 184 - Valid float value works when quoting with SQL_FLOAT (value=6.54E+02) ok 185 - Valid float value works when quoting with SQL_FLOAT (value=4e-3) ok 186 - Valid float value works when quoting with SQL_FLOAT (value=4e-3) ok 187 - Valid float value works when quoting with SQL_FLOAT (value=4e-3) ok 188 - Valid float value works when quoting with SQL_FLOAT (value=4e-3) ok 189 - Valid float value works when quoting with SQL_FLOAT (value=4E-3) ok 190 - Valid float value works when quoting with SQL_FLOAT (value=4E-3) ok 191 - Valid float value works when quoting with SQL_FLOAT (value=NaN) ok 192 - Valid float value works when quoting with SQL_FLOAT (value=NaN) ok 193 - Valid float value works when quoting with SQL_FLOAT (value=nan) ok 194 - Valid float value works when quoting with SQL_FLOAT (value=nan) ok 195 - Valid float value works when quoting with SQL_FLOAT (value=NAN) ok 196 - Valid float value works when quoting with SQL_FLOAT (value=NAN) ok 197 - Valid float value works when quoting with SQL_FLOAT (value=Infinity) ok 198 - Valid float value works when quoting with SQL_FLOAT (value=Infinity) ok 199 - Valid float value works when quoting with SQL_FLOAT (value=infinity) ok 200 - Valid float value works when quoting with SQL_FLOAT (value=infinity) ok 201 - Valid float value works when quoting with SQL_FLOAT (value=INFINITY) ok 202 - Valid float value works when quoting with SQL_FLOAT (value=INFINITY) ok 203 - Valid float value works when quoting with SQL_FLOAT (value=-infinity) ok 204 - Valid float value works when quoting with SQL_FLOAT (value=-infinity) ok 205 - Valid float value works when quoting with SQL_FLOAT (value=-infinity) ok 206 - Valid float value works when quoting with SQL_FLOAT (value=-infinity) ok 207 - Valid float value works when quoting with SQL_FLOAT (value=-INFINITY) ok 208 - Valid float value works when quoting with SQL_FLOAT (value=-INFINITY) ok 209 - Invalid float value fails when quoting with SQL_FLOAT (value=3abc) ok 210 - Invalid float value fails when quoting with SQL_FLOAT (value=3abc) ok 211 - Invalid float value fails when quoting with SQL_FLOAT (value=123abc) ok 212 - Invalid float value fails when quoting with SQL_FLOAT (value=123abc) ok 213 - Invalid float value fails when quoting with SQL_FLOAT (value=) ok 214 - Invalid float value fails when quoting with SQL_FLOAT (value=) ok 215 - Invalid float value fails when quoting with SQL_FLOAT (value=NaNum) ok 216 - Invalid float value fails when quoting with SQL_FLOAT (value=NaNum) ok 217 - Invalid float value fails when quoting with SQL_FLOAT (value=-infinitee) ok 218 - Invalid float value fails when quoting with SQL_FLOAT (value=-infinitee) ok 219 - Invalid integer test 2 ok 220 - The 'name' data type does correct quoting for the word "User" ok 221 - The 'name' data type does correct quoting for the word "user" ok 222 - The 'name' data type does correct quoting for the word "USER" ok 223 - The 'name' data type does correct quoting for the word "trigger" ok 224 - The 'name' data type does correct quoting for the word "Trigger" ok 225 - The 'name' data type does correct quoting for the word "auser" ok 226 - The 'name' data type does correct quoting for the word "userz" ok 227 - The 'name' data type does correct quoting for the word "user-user" ok 228 - Boolean quoting of "F" ok 229 - Boolean quoting of "t" ok 230 - Boolean quoting of " TRUE" ok 231 - Boolean quoting of "f" ok 232 - Boolean quoting of "0" ok 233 - Boolean quoting of "TRUE" ok 234 - Boolean quoting of "true" ok 235 - Boolean quoting of "0E0E0" ok 236 - Boolean quoting of "trueish" ok 237 - Boolean quoting of "0 but true" ok 238 - Boolean quoting of "0 but truez" ok 239 - Boolean quoting of "00" ok 240 - Boolean quoting of "1" ok 241 - Boolean quoting of " false" ok 242 - Boolean quoting of undef ok 243 - Boolean quoting of "01" ok 244 - Boolean quoting of "T" ok 245 - Boolean quoting of "12" ok 246 - Boolean quoting of "false" ok 247 - Boolean quoting of "FALSEY" ok 248 - Boolean quoting of "0e0" ok 249 - Boolean quoting of "FALSE" ok 250 - Boolean quoting of "0E0" ok 251 - Boolean quoting of "0 BUT TRUE" ok t/20savepoints.t .... 1..3 ok 1 - Connect to database for savepoint testing ok 2 - Only row 500 and 502 should be committed ok 3 - Implicit rollback on deallocate should rollback to last savepoint ok t/30unicode.t ....... ok 1 - Connect to database for unicode testing ok 2 - upgraded ascii UTF-8 placeholder text (pg_enable_utf8=1) arg has correct flag ok 3 - upgraded ascii UTF-8 placeholder text (pg_enable_utf8=1) returns proper value ok 4 - upgraded ascii UTF-8 placeholder text (pg_enable_utf8=1) returns string with correct UTF-8 flag ok 5 - upgraded ascii UTF-8 placeholder text (pg_enable_utf8=0) arg has correct flag ok 6 - upgraded ascii UTF-8 placeholder text (pg_enable_utf8=0) returns proper value ok 7 - upgraded ascii UTF-8 placeholder text (pg_enable_utf8=0) returns string with correct UTF-8 flag ok 8 - upgraded ascii UTF-8 placeholder text (pg_enable_utf8=-1) arg has correct flag ok 9 - upgraded ascii UTF-8 placeholder text (pg_enable_utf8=-1) returns proper value ok 10 - upgraded ascii UTF-8 placeholder text (pg_enable_utf8=-1) returns string with correct UTF-8 flag ok 11 - upgraded ascii UTF-8 interpolated text (pg_enable_utf8=1) query has correct flag ok 12 - upgraded ascii UTF-8 interpolated text (pg_enable_utf8=1) returns proper value ok 13 - upgraded ascii UTF-8 interpolated text (pg_enable_utf8=1) returns string with correct UTF-8 flag ok 14 - upgraded ascii UTF-8 interpolated text (pg_enable_utf8=0) query has correct flag ok 15 - upgraded ascii UTF-8 interpolated text (pg_enable_utf8=0) returns proper value ok 16 - upgraded ascii UTF-8 interpolated text (pg_enable_utf8=0) returns string with correct UTF-8 flag ok 17 - upgraded ascii UTF-8 interpolated text (pg_enable_utf8=-1) query has correct flag ok 18 - upgraded ascii UTF-8 interpolated text (pg_enable_utf8=-1) returns proper value ok 19 - upgraded ascii UTF-8 interpolated text (pg_enable_utf8=-1) returns string with correct UTF-8 flag ok 20 - upgraded ascii UTF-8 placeholder length text (pg_enable_utf8=1) arg has correct flag ok 21 - upgraded ascii UTF-8 placeholder length text (pg_enable_utf8=1) returns proper value ok 22 - upgraded ascii UTF-8 placeholder length text (pg_enable_utf8=0) arg has correct flag ok 23 - upgraded ascii UTF-8 placeholder length text (pg_enable_utf8=0) returns proper value ok 24 - upgraded ascii UTF-8 placeholder length text (pg_enable_utf8=-1) arg has correct flag ok 25 - upgraded ascii UTF-8 placeholder length text (pg_enable_utf8=-1) returns proper value ok 26 - upgraded ascii UTF-8 interpolated length text (pg_enable_utf8=1) query has correct flag ok 27 - upgraded ascii UTF-8 interpolated length text (pg_enable_utf8=1) returns proper value ok 28 - upgraded ascii UTF-8 interpolated length text (pg_enable_utf8=0) query has correct flag ok 29 - upgraded ascii UTF-8 interpolated length text (pg_enable_utf8=0) returns proper value ok 30 - upgraded ascii UTF-8 interpolated length text (pg_enable_utf8=-1) query has correct flag ok 31 - upgraded ascii UTF-8 interpolated length text (pg_enable_utf8=-1) returns proper value ok 32 - upgraded ascii UTF-8 placeholder text[] (pg_enable_utf8=1) arg has correct flag ok 33 - upgraded ascii UTF-8 placeholder text[] (pg_enable_utf8=1) returns proper value ok 34 - upgraded ascii UTF-8 placeholder text[] (pg_enable_utf8=1) returns string with correct UTF-8 flag ok 35 - upgraded ascii UTF-8 placeholder text[] (pg_enable_utf8=0) arg has correct flag ok 36 - upgraded ascii UTF-8 placeholder text[] (pg_enable_utf8=0) returns proper value ok 37 - upgraded ascii UTF-8 placeholder text[] (pg_enable_utf8=0) returns string with correct UTF-8 flag ok 38 - upgraded ascii UTF-8 placeholder text[] (pg_enable_utf8=-1) arg has correct flag ok 39 - upgraded ascii UTF-8 placeholder text[] (pg_enable_utf8=-1) returns proper value ok 40 - upgraded ascii UTF-8 placeholder text[] (pg_enable_utf8=-1) returns string with correct UTF-8 flag ok 41 - downgraded ascii UTF-8 placeholder text (pg_enable_utf8=1) arg has correct flag ok 42 - downgraded ascii UTF-8 placeholder text (pg_enable_utf8=1) returns proper value ok 43 - downgraded ascii UTF-8 placeholder text (pg_enable_utf8=1) returns string with correct UTF-8 flag ok 44 - downgraded ascii UTF-8 placeholder text (pg_enable_utf8=0) arg has correct flag ok 45 - downgraded ascii UTF-8 placeholder text (pg_enable_utf8=0) returns proper value ok 46 - downgraded ascii UTF-8 placeholder text (pg_enable_utf8=0) returns string with correct UTF-8 flag ok 47 - downgraded ascii UTF-8 placeholder text (pg_enable_utf8=-1) arg has correct flag ok 48 - downgraded ascii UTF-8 placeholder text (pg_enable_utf8=-1) returns proper value ok 49 - downgraded ascii UTF-8 placeholder text (pg_enable_utf8=-1) returns string with correct UTF-8 flag ok 50 - downgraded ascii UTF-8 interpolated text (pg_enable_utf8=1) query has correct flag ok 51 - downgraded ascii UTF-8 interpolated text (pg_enable_utf8=1) returns proper value ok 52 - downgraded ascii UTF-8 interpolated text (pg_enable_utf8=1) returns string with correct UTF-8 flag ok 53 - downgraded ascii UTF-8 interpolated text (pg_enable_utf8=0) query has correct flag ok 54 - downgraded ascii UTF-8 interpolated text (pg_enable_utf8=0) returns proper value ok 55 - downgraded ascii UTF-8 interpolated text (pg_enable_utf8=0) returns string with correct UTF-8 flag ok 56 - downgraded ascii UTF-8 interpolated text (pg_enable_utf8=-1) query has correct flag ok 57 - downgraded ascii UTF-8 interpolated text (pg_enable_utf8=-1) returns proper value ok 58 - downgraded ascii UTF-8 interpolated text (pg_enable_utf8=-1) returns string with correct UTF-8 flag ok 59 - downgraded ascii UTF-8 placeholder length text (pg_enable_utf8=1) arg has correct flag ok 60 - downgraded ascii UTF-8 placeholder length text (pg_enable_utf8=1) returns proper value ok 61 - downgraded ascii UTF-8 placeholder length text (pg_enable_utf8=0) arg has correct flag ok 62 - downgraded ascii UTF-8 placeholder length text (pg_enable_utf8=0) returns proper value ok 63 - downgraded ascii UTF-8 placeholder length text (pg_enable_utf8=-1) arg has correct flag ok 64 - downgraded ascii UTF-8 placeholder length text (pg_enable_utf8=-1) returns proper value ok 65 - downgraded ascii UTF-8 interpolated length text (pg_enable_utf8=1) query has correct flag ok 66 - downgraded ascii UTF-8 interpolated length text (pg_enable_utf8=1) returns proper value ok 67 - downgraded ascii UTF-8 interpolated length text (pg_enable_utf8=0) query has correct flag ok 68 - downgraded ascii UTF-8 interpolated length text (pg_enable_utf8=0) returns proper value ok 69 - downgraded ascii UTF-8 interpolated length text (pg_enable_utf8=-1) query has correct flag ok 70 - downgraded ascii UTF-8 interpolated length text (pg_enable_utf8=-1) returns proper value ok 71 - downgraded ascii UTF-8 placeholder text[] (pg_enable_utf8=1) arg has correct flag ok 72 - downgraded ascii UTF-8 placeholder text[] (pg_enable_utf8=1) returns proper value ok 73 - downgraded ascii UTF-8 placeholder text[] (pg_enable_utf8=1) returns string with correct UTF-8 flag ok 74 - downgraded ascii UTF-8 placeholder text[] (pg_enable_utf8=0) arg has correct flag ok 75 - downgraded ascii UTF-8 placeholder text[] (pg_enable_utf8=0) returns proper value ok 76 - downgraded ascii UTF-8 placeholder text[] (pg_enable_utf8=0) returns string with correct UTF-8 flag ok 77 - downgraded ascii UTF-8 placeholder text[] (pg_enable_utf8=-1) arg has correct flag ok 78 - downgraded ascii UTF-8 placeholder text[] (pg_enable_utf8=-1) returns proper value ok 79 - downgraded ascii UTF-8 placeholder text[] (pg_enable_utf8=-1) returns string with correct UTF-8 flag ok 80 - mixed ascii UTF-8 placeholder text[] (pg_enable_utf8=1) returns proper value ok 81 - mixed ascii UTF-8 placeholder text[] (pg_enable_utf8=1) returns string with correct UTF-8 flag ok 82 - mixed ascii UTF-8 placeholder text[] (pg_enable_utf8=1) returns string with correct UTF-8 flag ok 83 - mixed ascii UTF-8 placeholder text[] (pg_enable_utf8=0) returns proper value ok 84 - mixed ascii UTF-8 placeholder text[] (pg_enable_utf8=0) returns string with correct UTF-8 flag ok 85 - mixed ascii UTF-8 placeholder text[] (pg_enable_utf8=0) returns string with correct UTF-8 flag ok 86 - mixed ascii UTF-8 placeholder text[] (pg_enable_utf8=-1) returns proper value ok 87 - mixed ascii UTF-8 placeholder text[] (pg_enable_utf8=-1) returns string with correct UTF-8 flag ok 88 - mixed ascii UTF-8 placeholder text[] (pg_enable_utf8=-1) returns string with correct UTF-8 flag ok 89 - upgraded latin 1 range UTF-8 placeholder text (pg_enable_utf8=1) arg has correct flag ok 90 - upgraded latin 1 range UTF-8 placeholder text (pg_enable_utf8=1) returns proper value ok 91 - upgraded latin 1 range UTF-8 placeholder text (pg_enable_utf8=1) returns string with correct UTF-8 flag ok 92 - upgraded latin 1 range UTF-8 placeholder text (pg_enable_utf8=0) arg has correct flag ok 93 - upgraded latin 1 range UTF-8 placeholder text (pg_enable_utf8=0) returns proper value ok 94 - upgraded latin 1 range UTF-8 placeholder text (pg_enable_utf8=0) returns string with correct UTF-8 flag ok 95 - upgraded latin 1 range UTF-8 placeholder text (pg_enable_utf8=-1) arg has correct flag ok 96 - upgraded latin 1 range UTF-8 placeholder text (pg_enable_utf8=-1) returns proper value ok 97 - upgraded latin 1 range UTF-8 placeholder text (pg_enable_utf8=-1) returns string with correct UTF-8 flag ok 98 - upgraded latin 1 range UTF-8 interpolated text (pg_enable_utf8=1) query has correct flag ok 99 - upgraded latin 1 range UTF-8 interpolated text (pg_enable_utf8=1) returns proper value ok 100 - upgraded latin 1 range UTF-8 interpolated text (pg_enable_utf8=1) returns string with correct UTF-8 flag ok 101 - upgraded latin 1 range UTF-8 interpolated text (pg_enable_utf8=0) query has correct flag ok 102 - upgraded latin 1 range UTF-8 interpolated text (pg_enable_utf8=0) returns proper value ok 103 - upgraded latin 1 range UTF-8 interpolated text (pg_enable_utf8=0) returns string with correct UTF-8 flag ok 104 - upgraded latin 1 range UTF-8 interpolated text (pg_enable_utf8=-1) query has correct flag ok 105 - upgraded latin 1 range UTF-8 interpolated text (pg_enable_utf8=-1) returns proper value ok 106 - upgraded latin 1 range UTF-8 interpolated text (pg_enable_utf8=-1) returns string with correct UTF-8 flag ok 107 - upgraded latin 1 range UTF-8 placeholder length text (pg_enable_utf8=1) arg has correct flag ok 108 - upgraded latin 1 range UTF-8 placeholder length text (pg_enable_utf8=1) returns proper value ok 109 - upgraded latin 1 range UTF-8 placeholder length text (pg_enable_utf8=0) arg has correct flag ok 110 - upgraded latin 1 range UTF-8 placeholder length text (pg_enable_utf8=0) returns proper value ok 111 - upgraded latin 1 range UTF-8 placeholder length text (pg_enable_utf8=-1) arg has correct flag ok 112 - upgraded latin 1 range UTF-8 placeholder length text (pg_enable_utf8=-1) returns proper value ok 113 - upgraded latin 1 range UTF-8 interpolated length text (pg_enable_utf8=1) query has correct flag ok 114 - upgraded latin 1 range UTF-8 interpolated length text (pg_enable_utf8=1) returns proper value ok 115 - upgraded latin 1 range UTF-8 interpolated length text (pg_enable_utf8=0) query has correct flag ok 116 - upgraded latin 1 range UTF-8 interpolated length text (pg_enable_utf8=0) returns proper value ok 117 - upgraded latin 1 range UTF-8 interpolated length text (pg_enable_utf8=-1) query has correct flag ok 118 - upgraded latin 1 range UTF-8 interpolated length text (pg_enable_utf8=-1) returns proper value ok 119 - upgraded latin 1 range UTF-8 placeholder text[] (pg_enable_utf8=1) arg has correct flag ok 120 - upgraded latin 1 range UTF-8 placeholder text[] (pg_enable_utf8=1) returns proper value ok 121 - upgraded latin 1 range UTF-8 placeholder text[] (pg_enable_utf8=1) returns string with correct UTF-8 flag ok 122 - upgraded latin 1 range UTF-8 placeholder text[] (pg_enable_utf8=0) arg has correct flag ok 123 - upgraded latin 1 range UTF-8 placeholder text[] (pg_enable_utf8=0) returns proper value ok 124 - upgraded latin 1 range UTF-8 placeholder text[] (pg_enable_utf8=0) returns string with correct UTF-8 flag ok 125 - upgraded latin 1 range UTF-8 placeholder text[] (pg_enable_utf8=-1) arg has correct flag ok 126 - upgraded latin 1 range UTF-8 placeholder text[] (pg_enable_utf8=-1) returns proper value ok 127 - upgraded latin 1 range UTF-8 placeholder text[] (pg_enable_utf8=-1) returns string with correct UTF-8 flag ok 128 - downgraded latin 1 range UTF-8 placeholder text (pg_enable_utf8=1) arg has correct flag ok 129 - downgraded latin 1 range UTF-8 placeholder text (pg_enable_utf8=1) returns proper value ok 130 - downgraded latin 1 range UTF-8 placeholder text (pg_enable_utf8=1) returns string with correct UTF-8 flag ok 131 - downgraded latin 1 range UTF-8 placeholder text (pg_enable_utf8=0) arg has correct flag ok 132 - downgraded latin 1 range UTF-8 placeholder text (pg_enable_utf8=0) returns proper value ok 133 - downgraded latin 1 range UTF-8 placeholder text (pg_enable_utf8=0) returns string with correct UTF-8 flag ok 134 - downgraded latin 1 range UTF-8 placeholder text (pg_enable_utf8=-1) arg has correct flag ok 135 - downgraded latin 1 range UTF-8 placeholder text (pg_enable_utf8=-1) returns proper value ok 136 - downgraded latin 1 range UTF-8 placeholder text (pg_enable_utf8=-1) returns string with correct UTF-8 flag ok 137 - downgraded latin 1 range UTF-8 interpolated text (pg_enable_utf8=1) query has correct flag ok 138 - downgraded latin 1 range UTF-8 interpolated text (pg_enable_utf8=1) returns proper value ok 139 - downgraded latin 1 range UTF-8 interpolated text (pg_enable_utf8=1) returns string with correct UTF-8 flag ok 140 - downgraded latin 1 range UTF-8 interpolated text (pg_enable_utf8=0) query has correct flag ok 141 - downgraded latin 1 range UTF-8 interpolated text (pg_enable_utf8=0) returns proper value ok 142 - downgraded latin 1 range UTF-8 interpolated text (pg_enable_utf8=0) returns string with correct UTF-8 flag ok 143 - downgraded latin 1 range UTF-8 interpolated text (pg_enable_utf8=-1) query has correct flag ok 144 - downgraded latin 1 range UTF-8 interpolated text (pg_enable_utf8=-1) returns proper value ok 145 - downgraded latin 1 range UTF-8 interpolated text (pg_enable_utf8=-1) returns string with correct UTF-8 flag ok 146 - downgraded latin 1 range UTF-8 placeholder length text (pg_enable_utf8=1) arg has correct flag ok 147 - downgraded latin 1 range UTF-8 placeholder length text (pg_enable_utf8=1) returns proper value ok 148 - downgraded latin 1 range UTF-8 placeholder length text (pg_enable_utf8=0) arg has correct flag ok 149 - downgraded latin 1 range UTF-8 placeholder length text (pg_enable_utf8=0) returns proper value ok 150 - downgraded latin 1 range UTF-8 placeholder length text (pg_enable_utf8=-1) arg has correct flag ok 151 - downgraded latin 1 range UTF-8 placeholder length text (pg_enable_utf8=-1) returns proper value ok 152 - downgraded latin 1 range UTF-8 interpolated length text (pg_enable_utf8=1) query has correct flag ok 153 - downgraded latin 1 range UTF-8 interpolated length text (pg_enable_utf8=1) returns proper value ok 154 - downgraded latin 1 range UTF-8 interpolated length text (pg_enable_utf8=0) query has correct flag ok 155 - downgraded latin 1 range UTF-8 interpolated length text (pg_enable_utf8=0) returns proper value ok 156 - downgraded latin 1 range UTF-8 interpolated length text (pg_enable_utf8=-1) query has correct flag ok 157 - downgraded latin 1 range UTF-8 interpolated length text (pg_enable_utf8=-1) returns proper value ok 158 - downgraded latin 1 range UTF-8 placeholder text[] (pg_enable_utf8=1) arg has correct flag ok 159 - downgraded latin 1 range UTF-8 placeholder text[] (pg_enable_utf8=1) returns proper value ok 160 - downgraded latin 1 range UTF-8 placeholder text[] (pg_enable_utf8=1) returns string with correct UTF-8 flag ok 161 - downgraded latin 1 range UTF-8 placeholder text[] (pg_enable_utf8=0) arg has correct flag ok 162 - downgraded latin 1 range UTF-8 placeholder text[] (pg_enable_utf8=0) returns proper value ok 163 - downgraded latin 1 range UTF-8 placeholder text[] (pg_enable_utf8=0) returns string with correct UTF-8 flag ok 164 - downgraded latin 1 range UTF-8 placeholder text[] (pg_enable_utf8=-1) arg has correct flag ok 165 - downgraded latin 1 range UTF-8 placeholder text[] (pg_enable_utf8=-1) returns proper value ok 166 - downgraded latin 1 range UTF-8 placeholder text[] (pg_enable_utf8=-1) returns string with correct UTF-8 flag ok 167 - mixed latin 1 range UTF-8 placeholder text[] (pg_enable_utf8=1) returns proper value ok 168 - mixed latin 1 range UTF-8 placeholder text[] (pg_enable_utf8=1) returns string with correct UTF-8 flag ok 169 - mixed latin 1 range UTF-8 placeholder text[] (pg_enable_utf8=1) returns string with correct UTF-8 flag ok 170 - mixed latin 1 range UTF-8 placeholder text[] (pg_enable_utf8=0) returns proper value ok 171 - mixed latin 1 range UTF-8 placeholder text[] (pg_enable_utf8=0) returns string with correct UTF-8 flag ok 172 - mixed latin 1 range UTF-8 placeholder text[] (pg_enable_utf8=0) returns string with correct UTF-8 flag ok 173 - mixed latin 1 range UTF-8 placeholder text[] (pg_enable_utf8=-1) returns proper value ok 174 - mixed latin 1 range UTF-8 placeholder text[] (pg_enable_utf8=-1) returns string with correct UTF-8 flag ok 175 - mixed latin 1 range UTF-8 placeholder text[] (pg_enable_utf8=-1) returns string with correct UTF-8 flag ok 176 - upgraded base plane UTF-8 placeholder text (pg_enable_utf8=1) arg has correct flag ok 177 - upgraded base plane UTF-8 placeholder text (pg_enable_utf8=1) returns proper value ok 178 - upgraded base plane UTF-8 placeholder text (pg_enable_utf8=1) returns string with correct UTF-8 flag ok 179 - upgraded base plane UTF-8 placeholder text (pg_enable_utf8=0) arg has correct flag ok 180 - upgraded base plane UTF-8 placeholder text (pg_enable_utf8=0) returns proper value ok 181 - upgraded base plane UTF-8 placeholder text (pg_enable_utf8=0) returns string with correct UTF-8 flag ok 182 - upgraded base plane UTF-8 placeholder text (pg_enable_utf8=-1) arg has correct flag ok 183 - upgraded base plane UTF-8 placeholder text (pg_enable_utf8=-1) returns proper value ok 184 - upgraded base plane UTF-8 placeholder text (pg_enable_utf8=-1) returns string with correct UTF-8 flag ok 185 - upgraded base plane UTF-8 interpolated text (pg_enable_utf8=1) query has correct flag ok 186 - upgraded base plane UTF-8 interpolated text (pg_enable_utf8=1) returns proper value ok 187 - upgraded base plane UTF-8 interpolated text (pg_enable_utf8=1) returns string with correct UTF-8 flag ok 188 - upgraded base plane UTF-8 interpolated text (pg_enable_utf8=0) query has correct flag ok 189 - upgraded base plane UTF-8 interpolated text (pg_enable_utf8=0) returns proper value ok 190 - upgraded base plane UTF-8 interpolated text (pg_enable_utf8=0) returns string with correct UTF-8 flag ok 191 - upgraded base plane UTF-8 interpolated text (pg_enable_utf8=-1) query has correct flag ok 192 - upgraded base plane UTF-8 interpolated text (pg_enable_utf8=-1) returns proper value ok 193 - upgraded base plane UTF-8 interpolated text (pg_enable_utf8=-1) returns string with correct UTF-8 flag ok 194 - upgraded base plane UTF-8 placeholder length text (pg_enable_utf8=1) arg has correct flag ok 195 - upgraded base plane UTF-8 placeholder length text (pg_enable_utf8=1) returns proper value ok 196 - upgraded base plane UTF-8 placeholder length text (pg_enable_utf8=0) arg has correct flag ok 197 - upgraded base plane UTF-8 placeholder length text (pg_enable_utf8=0) returns proper value ok 198 - upgraded base plane UTF-8 placeholder length text (pg_enable_utf8=-1) arg has correct flag ok 199 - upgraded base plane UTF-8 placeholder length text (pg_enable_utf8=-1) returns proper value ok 200 - upgraded base plane UTF-8 interpolated length text (pg_enable_utf8=1) query has correct flag ok 201 - upgraded base plane UTF-8 interpolated length text (pg_enable_utf8=1) returns proper value ok 202 - upgraded base plane UTF-8 interpolated length text (pg_enable_utf8=0) query has correct flag ok 203 - upgraded base plane UTF-8 interpolated length text (pg_enable_utf8=0) returns proper value ok 204 - upgraded base plane UTF-8 interpolated length text (pg_enable_utf8=-1) query has correct flag ok 205 - upgraded base plane UTF-8 interpolated length text (pg_enable_utf8=-1) returns proper value ok 206 - upgraded base plane UTF-8 placeholder text[] (pg_enable_utf8=1) arg has correct flag ok 207 - upgraded base plane UTF-8 placeholder text[] (pg_enable_utf8=1) returns proper value ok 208 - upgraded base plane UTF-8 placeholder text[] (pg_enable_utf8=1) returns string with correct UTF-8 flag ok 209 - upgraded base plane UTF-8 placeholder text[] (pg_enable_utf8=0) arg has correct flag ok 210 - upgraded base plane UTF-8 placeholder text[] (pg_enable_utf8=0) returns proper value ok 211 - upgraded base plane UTF-8 placeholder text[] (pg_enable_utf8=0) returns string with correct UTF-8 flag ok 212 - upgraded base plane UTF-8 placeholder text[] (pg_enable_utf8=-1) arg has correct flag ok 213 - upgraded base plane UTF-8 placeholder text[] (pg_enable_utf8=-1) returns proper value ok 214 - upgraded base plane UTF-8 placeholder text[] (pg_enable_utf8=-1) returns string with correct UTF-8 flag ok 215 - upgraded astral plane UTF-8 placeholder text (pg_enable_utf8=1) arg has correct flag ok 216 - upgraded astral plane UTF-8 placeholder text (pg_enable_utf8=1) returns proper value ok 217 - upgraded astral plane UTF-8 placeholder text (pg_enable_utf8=1) returns string with correct UTF-8 flag ok 218 - upgraded astral plane UTF-8 placeholder text (pg_enable_utf8=0) arg has correct flag ok 219 - upgraded astral plane UTF-8 placeholder text (pg_enable_utf8=0) returns proper value ok 220 - upgraded astral plane UTF-8 placeholder text (pg_enable_utf8=0) returns string with correct UTF-8 flag ok 221 - upgraded astral plane UTF-8 placeholder text (pg_enable_utf8=-1) arg has correct flag ok 222 - upgraded astral plane UTF-8 placeholder text (pg_enable_utf8=-1) returns proper value ok 223 - upgraded astral plane UTF-8 placeholder text (pg_enable_utf8=-1) returns string with correct UTF-8 flag ok 224 - upgraded astral plane UTF-8 interpolated text (pg_enable_utf8=1) query has correct flag ok 225 - upgraded astral plane UTF-8 interpolated text (pg_enable_utf8=1) returns proper value ok 226 - upgraded astral plane UTF-8 interpolated text (pg_enable_utf8=1) returns string with correct UTF-8 flag ok 227 - upgraded astral plane UTF-8 interpolated text (pg_enable_utf8=0) query has correct flag ok 228 - upgraded astral plane UTF-8 interpolated text (pg_enable_utf8=0) returns proper value ok 229 - upgraded astral plane UTF-8 interpolated text (pg_enable_utf8=0) returns string with correct UTF-8 flag ok 230 - upgraded astral plane UTF-8 interpolated text (pg_enable_utf8=-1) query has correct flag ok 231 - upgraded astral plane UTF-8 interpolated text (pg_enable_utf8=-1) returns proper value ok 232 - upgraded astral plane UTF-8 interpolated text (pg_enable_utf8=-1) returns string with correct UTF-8 flag ok 233 - upgraded astral plane UTF-8 placeholder length text (pg_enable_utf8=1) arg has correct flag ok 234 - upgraded astral plane UTF-8 placeholder length text (pg_enable_utf8=1) returns proper value ok 235 - upgraded astral plane UTF-8 placeholder length text (pg_enable_utf8=0) arg has correct flag ok 236 - upgraded astral plane UTF-8 placeholder length text (pg_enable_utf8=0) returns proper value ok 237 - upgraded astral plane UTF-8 placeholder length text (pg_enable_utf8=-1) arg has correct flag ok 238 - upgraded astral plane UTF-8 placeholder length text (pg_enable_utf8=-1) returns proper value ok 239 - upgraded astral plane UTF-8 interpolated length text (pg_enable_utf8=1) query has correct flag ok 240 - upgraded astral plane UTF-8 interpolated length text (pg_enable_utf8=1) returns proper value ok 241 - upgraded astral plane UTF-8 interpolated length text (pg_enable_utf8=0) query has correct flag ok 242 - upgraded astral plane UTF-8 interpolated length text (pg_enable_utf8=0) returns proper value ok 243 - upgraded astral plane UTF-8 interpolated length text (pg_enable_utf8=-1) query has correct flag ok 244 - upgraded astral plane UTF-8 interpolated length text (pg_enable_utf8=-1) returns proper value ok 245 - upgraded astral plane UTF-8 placeholder text[] (pg_enable_utf8=1) arg has correct flag ok 246 - upgraded astral plane UTF-8 placeholder text[] (pg_enable_utf8=1) returns proper value ok 247 - upgraded astral plane UTF-8 placeholder text[] (pg_enable_utf8=1) returns string with correct UTF-8 flag ok 248 - upgraded astral plane UTF-8 placeholder text[] (pg_enable_utf8=0) arg has correct flag ok 249 - upgraded astral plane UTF-8 placeholder text[] (pg_enable_utf8=0) returns proper value ok 250 - upgraded astral plane UTF-8 placeholder text[] (pg_enable_utf8=0) returns string with correct UTF-8 flag ok 251 - upgraded astral plane UTF-8 placeholder text[] (pg_enable_utf8=-1) arg has correct flag ok 252 - upgraded astral plane UTF-8 placeholder text[] (pg_enable_utf8=-1) returns proper value ok 253 - upgraded astral plane UTF-8 placeholder text[] (pg_enable_utf8=-1) returns string with correct UTF-8 flag ok 254 - Generated string is not utf8 ok 255 - Fetching ASCII string from the database returns proper string ok 256 - Fetching ASCII string from the database returns string with UTF-8 flag on ok 257 - Fetching ASCII string from the database returns proper string (pg_enable_utf8=0) ok 258 - Fetching ASCII string from the database returns string with UTF-8 flag off (pg_enable_utf8=0) ok 259 - string is the same after round trip ok 260 - string has utf8 flag set ok 261 - Got 1 character for chr(?) for U+004E LATIN CAPITAL LETTER N, $enable_utf8=1 ok 262 - Got correct character for chr(?) for U+004E LATIN CAPITAL LETTER N, $enable_utf8=1 ok 263 - Got valid UTF-8 for chr(?) for U+004E LATIN CAPITAL LETTER N, $enable_utf8=0 ok 264 - Got 1 character for chr(?) for U+004E LATIN CAPITAL LETTER N, $enable_utf8=0 ok 265 - Got correct character for chr(?) for U+004E LATIN CAPITAL LETTER N, $enable_utf8=0 ok 266 - Got 1 character for chr(?) for U+004E LATIN CAPITAL LETTER N, $enable_utf8=-1 ok 267 - Got correct character for chr(?) for U+004E LATIN CAPITAL LETTER N, $enable_utf8=-1 ok 268 - Got 1 character for chr(?) for U+00E9 LATIN SMALL LETTER E WITH ACUTE, $enable_utf8=1 ok 269 - Got correct character for chr(?) for U+00E9 LATIN SMALL LETTER E WITH ACUTE, $enable_utf8=1 ok 270 - Got valid UTF-8 for chr(?) for U+00E9 LATIN SMALL LETTER E WITH ACUTE, $enable_utf8=0 ok 271 - Got 1 character for chr(?) for U+00E9 LATIN SMALL LETTER E WITH ACUTE, $enable_utf8=0 ok 272 - Got correct character for chr(?) for U+00E9 LATIN SMALL LETTER E WITH ACUTE, $enable_utf8=0 ok 273 - Got 1 character for chr(?) for U+00E9 LATIN SMALL LETTER E WITH ACUTE, $enable_utf8=-1 ok 274 - Got correct character for chr(?) for U+00E9 LATIN SMALL LETTER E WITH ACUTE, $enable_utf8=-1 ok 275 - Got 1 character for chr(?) for U+00A4 CURRENCY SIGN, $enable_utf8=1 ok 276 - Got correct character for chr(?) for U+00A4 CURRENCY SIGN, $enable_utf8=1 ok 277 - Got valid UTF-8 for chr(?) for U+00A4 CURRENCY SIGN, $enable_utf8=0 ok 278 - Got 1 character for chr(?) for U+00A4 CURRENCY SIGN, $enable_utf8=0 ok 279 - Got correct character for chr(?) for U+00A4 CURRENCY SIGN, $enable_utf8=0 ok 280 - Got 1 character for chr(?) for U+00A4 CURRENCY SIGN, $enable_utf8=-1 ok 281 - Got correct character for chr(?) for U+00A4 CURRENCY SIGN, $enable_utf8=-1 ok 282 - Got 1 character for chr(?) for U+20AC EURO SIGN, $enable_utf8=1 ok 283 - Got correct character for chr(?) for U+20AC EURO SIGN, $enable_utf8=1 ok 284 - Got valid UTF-8 for chr(?) for U+20AC EURO SIGN, $enable_utf8=0 ok 285 - Got 1 character for chr(?) for U+20AC EURO SIGN, $enable_utf8=0 ok 286 - Got correct character for chr(?) for U+20AC EURO SIGN, $enable_utf8=0 ok 287 - Got 1 character for chr(?) for U+20AC EURO SIGN, $enable_utf8=-1 ok 288 - Got correct character for chr(?) for U+20AC EURO SIGN, $enable_utf8=-1 ok 289 - Got 1 character for chr(?) for U+00A3 POUND SIGN, $enable_utf8=1 ok 290 - Got correct character for chr(?) for U+00A3 POUND SIGN, $enable_utf8=1 ok 291 - Got valid UTF-8 for chr(?) for U+00A3 POUND SIGN, $enable_utf8=0 ok 292 - Got 1 character for chr(?) for U+00A3 POUND SIGN, $enable_utf8=0 ok 293 - Got correct character for chr(?) for U+00A3 POUND SIGN, $enable_utf8=0 ok 294 - Got 1 character for chr(?) for U+00A3 POUND SIGN, $enable_utf8=-1 ok 295 - Got correct character for chr(?) for U+00A3 POUND SIGN, $enable_utf8=-1 ok 296 - Got 1 character for chr(?) for U+00A5 YEN SIGN, $enable_utf8=1 ok 297 - Got correct character for chr(?) for U+00A5 YEN SIGN, $enable_utf8=1 ok 298 - Got valid UTF-8 for chr(?) for U+00A5 YEN SIGN, $enable_utf8=0 ok 299 - Got 1 character for chr(?) for U+00A5 YEN SIGN, $enable_utf8=0 ok 300 - Got correct character for chr(?) for U+00A5 YEN SIGN, $enable_utf8=0 ok 301 - Got 1 character for chr(?) for U+00A5 YEN SIGN, $enable_utf8=-1 ok 302 - Got correct character for chr(?) for U+00A5 YEN SIGN, $enable_utf8=-1 ok 303 - Got 1 character for chr(?) for U+0160 LATIN CAPITAL LETTER S WITH CARON, $enable_utf8=1 ok 304 - Got correct character for chr(?) for U+0160 LATIN CAPITAL LETTER S WITH CARON, $enable_utf8=1 ok 305 - Got valid UTF-8 for chr(?) for U+0160 LATIN CAPITAL LETTER S WITH CARON, $enable_utf8=0 ok 306 - Got 1 character for chr(?) for U+0160 LATIN CAPITAL LETTER S WITH CARON, $enable_utf8=0 ok 307 - Got correct character for chr(?) for U+0160 LATIN CAPITAL LETTER S WITH CARON, $enable_utf8=0 ok 308 - Got 1 character for chr(?) for U+0160 LATIN CAPITAL LETTER S WITH CARON, $enable_utf8=-1 ok 309 - Got correct character for chr(?) for U+0160 LATIN CAPITAL LETTER S WITH CARON, $enable_utf8=-1 ok 310 - Got 1 character for chr(?) for U+2603 SNOWMAN, $enable_utf8=1 ok 311 - Got correct character for chr(?) for U+2603 SNOWMAN, $enable_utf8=1 ok 312 - Got valid UTF-8 for chr(?) for U+2603 SNOWMAN, $enable_utf8=0 ok 313 - Got 1 character for chr(?) for U+2603 SNOWMAN, $enable_utf8=0 ok 314 - Got correct character for chr(?) for U+2603 SNOWMAN, $enable_utf8=0 ok 315 - Got 1 character for chr(?) for U+2603 SNOWMAN, $enable_utf8=-1 ok 316 - Got correct character for chr(?) for U+2603 SNOWMAN, $enable_utf8=-1 ok 317 - Got 1 character for chr(?) for U+1D196 MUSICAL SYMBOL TR, $enable_utf8=1 ok 318 - Got correct character for chr(?) for U+1D196 MUSICAL SYMBOL TR, $enable_utf8=1 ok 319 - Got valid UTF-8 for chr(?) for U+1D196 MUSICAL SYMBOL TR, $enable_utf8=0 ok 320 - Got 1 character for chr(?) for U+1D196 MUSICAL SYMBOL TR, $enable_utf8=0 ok 321 - Got correct character for chr(?) for U+1D196 MUSICAL SYMBOL TR, $enable_utf8=0 ok 322 - Got 1 character for chr(?) for U+1D196 MUSICAL SYMBOL TR, $enable_utf8=-1 ok 323 - Got correct character for chr(?) for U+1D196 MUSICAL SYMBOL TR, $enable_utf8=-1 1..323 ok Removing test database directory t/99cleanup.t ....... 1..1 ok 1 - Connect to database for cleanup ok All tests successful. Files=16, Tests=2098, 55 wallclock secs ( 0.43 usr 0.06 sys + 8.30 cusr 1.59 csys = 10.38 CPU) Result: PASS TURNSTEP/DBD-Pg-3.4.2.tar.gz make test TEST_VERBOSE=1 -- OK Greg Sabino Mullane <greg@turnstep.com> DBI PostgreSQL interface >>> (cd /home/fly2000/var/cpan/build/DBD-Pg-3.4.2-EA9B8z && tar cvf - DBD-Pg-3.4.2.ppd blib) | gzip -c >/home/fly2000/var/REPO/T/TU/TURNSTEP/DBD-Pg-3.4.2.tar.gz DBD-Pg-3.4.2.ppd blib/ blib/arch/ blib/arch/auto/ blib/arch/auto/DBD/ blib/arch/auto/DBD/Pg/ blib/arch/auto/DBD/Pg/Pg.so blib/man3/ blib/man3/Bundle::DBD::Pg.3 blib/man3/DBD::Pg.3 blib/lib/ blib/lib/Bundle/ blib/lib/Bundle/DBD/ blib/lib/Bundle/DBD/Pg.pm blib/lib/DBD/ blib/lib/DBD/Pg.pm >>> mv /home/fly2000/var/cpan/build/DBD-Pg-3.4.2-EA9B8z/DBD-Pg-3.4.2.ppd /home/fly2000/var/REPO/T/TU/TURNSTEP VmSize: 300916 kB Finished 2014-10-14T14:20:04