PATH=C:\Program Files\Microsoft Platform SDK\Bin;C:\Program Files\Microsoft Platform SDK\Bin\WinNT;C:\Program Files\Microsoft Visual Studio\VC98\Bin;C:\Program Files\Microsoft Visual Studio\Common\MSDev98\Bin;C:\Perl-5.14\site\bin;C:\Perl-5.14\bin;C:\cygwin\bin;C:\Program Files\Perforce;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\WINDOWS\system32\WindowsPowerShell\v1.0;C:\WINDOWS\system32\WindowsPowerShell\v1.0;C:\instantclient_11_2;C:\cygwin\bin;C:\Program Files\Perforce;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\WINDOWS\system32\WindowsPowerShell\v1.0;C:\WINDOWS\system32\WindowsPowerShell\v1.0;C:\mysql\bin Start 2012-08-30T02:25:16 ActivePerl-1400 CPAN-1.9402 LIB=C:\PROGRA~1\MICROS~3\VC98\Lib\PSDK;C:\PROGRA~1\MICROS~2\Lib;C:\PROGRA~1\MICROS~3\VC98\Lib;C:\PROGRA~1\MICROS~3\VC98\MFC\Lib INCLUDE=C:\PROGRA~1\MICROS~2\Include;C:\PROGRA~1\MICROS~3\VC98\ATL\Include;C:\PROGRA~1\MICROS~3\VC98\Include;C:\PROGRA~1\MICROS~3\VC98\MFC\Include PATH=C:/CPANFL~1.14/var/libs/bin;C:\PROGRA~1\MICROS~2\Bin;C:\PROGRA~1\MICROS~2\Bin\WinNT;C:\PROGRA~1\MICROS~3\VC98\Bin;C:\PROGRA~1\MICROS~3\Common\MSDev98\Bin;C:\Perl-5.14\site\bin;C:\Perl-5.14\bin;C:\cygwin\bin;C:\PROGRA~1\Perforce;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\WINDOWS\system32\WINDOW~2\v1.0;C:\WINDOWS\system32\WINDOW~2\v1.0;C:\INSTAN~1;C:\cygwin\bin;C:\PROGRA~1\Perforce;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\WINDOWS\system32\WINDOW~2\v1.0;C:\WINDOWS\system32\WINDOW~2\v1.0;C:\mysql\bin Going to read 'C:\cpanfly-5.14\var\cpan\Metadata' Database was generated on Thu, 30 Aug 2012 08:13:15 GMT ______________________ D i s t r o P r e f s ______________________ DBD-mysql-windows.yml[0] Running make for C/CA/CAPTTOFU/DBD-mysql-4.022.tar.gz Fetching with LWP: http://cpan.nas.activestate.com/authors/id/C/CA/CAPTTOFU/DBD-mysql-4.022.tar.gz Fetching with LWP: http://cpan.nas.activestate.com/authors/id/C/CA/CAPTTOFU/CHECKSUMS Checksum for C:\cpanfly-5.14\var\cpan\sources\authors\id\C\CA\CAPTTOFU\DBD-mysql-4.022.tar.gz ok DBD-mysql-4.022/ DBD-mysql-4.022/lib/ DBD-mysql-4.022/lib/Bundle/ DBD-mysql-4.022/lib/Bundle/DBD/ DBD-mysql-4.022/lib/Bundle/DBD/mysql.pm DBD-mysql-4.022/lib/DBD/ DBD-mysql-4.022/lib/DBD/mysql/ DBD-mysql-4.022/lib/DBD/mysql/GetInfo.pm DBD-mysql-4.022/lib/DBD/mysql/INSTALL.pod DBD-mysql-4.022/lib/DBD/mysql.pm DBD-mysql-4.022/Makefile.PL.embedded DBD-mysql-4.022/mysql.xs DBD-mysql-4.022/README DBD-mysql-4.022/TODO DBD-mysql-4.022/ChangeLog DBD-mysql-4.022/INSTALL.html DBD-mysql-4.022/t/ DBD-mysql-4.022/t/41bindparam.t DBD-mysql-4.022/t/51bind_type_guessing.t DBD-mysql-4.022/t/80procs.t DBD-mysql-4.022/t/25lockunlock.t DBD-mysql-4.022/t/40bindparam.t DBD-mysql-4.022/t/40nulls.t DBD-mysql-4.022/t/55utf8.t DBD-mysql-4.022/t/91errcheck.t DBD-mysql-4.022/t/41blobs_prepare.t DBD-mysql-4.022/t/31insertid.t DBD-mysql-4.022/t/35prepare.t DBD-mysql-4.022/t/50chopblanks.t DBD-mysql-4.022/t/42bindparam.t DBD-mysql-4.022/t/32insert_error.t DBD-mysql-4.022/t/50commit.t DBD-mysql-4.022/t/10connect.t DBD-mysql-4.022/t/86_bug_36972.t DBD-mysql-4.022/t/40bindparam2.t DBD-mysql-4.022/t/20createdrop.t DBD-mysql-4.022/t/40keyinfo.t DBD-mysql-4.022/t/40server_prepare.t DBD-mysql-4.022/t/mysql.mtest DBD-mysql-4.022/t/52comment.t DBD-mysql-4.022/t/65types.t DBD-mysql-4.022/t/30insertfetch.t DBD-mysql-4.022/t/40catalog.t DBD-mysql-4.022/t/70takeimp.t DBD-mysql-4.022/t/40types.t DBD-mysql-4.022/t/75supported_sql.t DBD-mysql-4.022/t/53comment.t DBD-mysql-4.022/t/85init_command.t DBD-mysql-4.022/t/mem_leak.pl DBD-mysql-4.022/t/40numrows.t DBD-mysql-4.022/t/76multi_statement.t DBD-mysql-4.022/t/71impdata.t DBD-mysql-4.022/t/35limit.t DBD-mysql-4.022/t/mysql.dbtest DBD-mysql-4.022/t/00base.t DBD-mysql-4.022/t/40blobs.t DBD-mysql-4.022/t/40nulls_prepare.t DBD-mysql-4.022/t/60leaks.t DBD-mysql-4.022/t/29warnings.t DBD-mysql-4.022/t/40server_prepare_error.t DBD-mysql-4.022/t/40listfields.t DBD-mysql-4.022/t/lib.pl DBD-mysql-4.022/dbdimp.c DBD-mysql-4.022/constants.h DBD-mysql-4.022/eg/ DBD-mysql-4.022/eg/proc_example3.pl DBD-mysql-4.022/eg/proc_example2b.pl DBD-mysql-4.022/eg/issue21946.pl DBD-mysql-4.022/eg/bug30033pg.pl DBD-mysql-4.022/eg/proc_example2.pl DBD-mysql-4.022/eg/decimal_test.pl DBD-mysql-4.022/eg/proc_example1.pl DBD-mysql-4.022/eg/prepare_memory_usage.pl DBD-mysql-4.022/eg/bug21028.pl DBD-mysql-4.022/eg/proc_example2a.pl DBD-mysql-4.022/eg/bug14979.pl DBD-mysql-4.022/eg/proc_example4.pl DBD-mysql-4.022/eg/bug30033.pl DBD-mysql-4.022/myld DBD-mysql-4.022/Makefile.PL DBD-mysql-4.022/MANIFEST.SKIP DBD-mysql-4.022/README.OSX DBD-mysql-4.022/MANIFEST DBD-mysql-4.022/dbdimp.h DBD-mysql-4.022/META.yml Going to apply 3 patches: C:\cpanfly-5.14\etc\distroprefs\DBD-mysql-windows.patch C:\cygwin\bin\patch.exe -N --fuzz=3 -p0 <{'testuser'} and defined $opt->{'testpassword'}) { - $v = qx( sprintf('%s --user=%s --password=%s version', $mysqladmin , $opt->{'testuser'}, $opt->{'testpassword'}) ); - } else { - $v = qx($mysqladmin version); - } + + my $cmd = $mysqladmin; + $cmd .= " --host=$opt->{testhost}" if $opt->{testhost}; + $cmd .= " --port=$opt->{testport}" if $opt->{testport}; + $cmd .= " --user=$opt->{testuser}" if $opt->{testuser}; + $cmd .= " --password=$opt->{testpassword}" if $opt->{testpassword}; + my $v = qx($cmd version); unless ($v) { print STDERR "Problem running $mysqladmin - aborting ...\n"; exit(1); @@ -909,6 +910,11 @@ installhtml: lib/DBD/mysql/INSTALL.pod \tpod2html --infile=lib/DBD/mysql/INSTALL.pod --outfile=INSTALL.html +all :: copy_libmysql + +copy_libmysql : \$(INST_DYNAMIC) c:\\mysql\\lib\\opt\\libmysql.dll +\tcopy c:\\mysql\\lib\\opt\\libmysql.dll \$(INST_ARCHAUTODIR) + POSTAMBLE }; EOT (Stripping trailing CRs from patch.) patching file Makefile.PL Hunk #1 succeeded at 809 (offset 34 lines). Hunk #2 succeeded at 944 (offset 34 lines). C:\cpanfly-5.14\etc\distroprefs\DBD-mysql-windows-dbdimp.c.patch C:\cygwin\bin\patch.exe -N --fuzz=3 -p0 <= 2) PerlIO_printf(DBIc_LOGPIO(imp_xxh), "IGNORING ERROR errno %d\n", errno); - rows = -2; } -#endif return(rows); } @@ -3833,6 +3832,7 @@ default: if (DBIc_TRACE_LEVEL(imp_xxh) >= 2) PerlIO_printf(DBIc_LOGPIO(imp_xxh), "\t\tERROR IN st_fetch_string"); + { STRLEN len= fbh->length; /* ChopBlanks */ if (ChopBlanks) @@ -3849,7 +3849,7 @@ /* END OF ChopBlanks */ sv_setpvn(sv, fbh->data, len); - + } /* UTF8 */ /*HELMUT*/ #if defined(sv_utf8_decode) && MYSQL_VERSION_ID >=SERVER_PREPARE_VERSION @@ -3885,8 +3885,7 @@ { PerlIO_printf(DBIc_LOGPIO(imp_xxh), "\tdbd_st_fetch result set details\n"); PerlIO_printf(DBIc_LOGPIO(imp_xxh), "\timp_sth->result=%08lx\n",(long unsigned int) imp_sth->result); - PerlIO_printf(DBIc_LOGPIO(imp_xxh), "\tmysql_num_fields=%llu\n", - (long long unsigned int) mysql_num_fields(imp_sth->result)); + PerlIO_printf(DBIc_LOGPIO(imp_xxh), "\tmysql_num_fields=%llu\n", mysql_num_fields(imp_sth->result)); PerlIO_printf(DBIc_LOGPIO(imp_xxh), "\tmysql_num_rows=%llu\n", mysql_num_rows(imp_sth->result)); PerlIO_printf(DBIc_LOGPIO(imp_xxh), "\tmysql_affected_rows=%llu\n", EOT (Stripping trailing CRs from patch.) patching file dbdimp.c Hunk #3 succeeded at 3839 (offset 7 lines). Hunk #4 succeeded at 3856 (offset 7 lines). Hunk #5 succeeded at 3892 (offset 7 lines). C:\cpanfly-5.14\etc\distroprefs\DBD-mysql-windows-mysql.xs.patch C:\cygwin\bin\patch.exe -N --fuzz=3 -p0 <pmysql, NULL); - MYSQL_ROW cur; + res = mysql_list_dbs(imp_dbh->pmysql, NULL); if (!res && (!mysql_db_reconnect(dbh) || !(res = mysql_list_dbs(imp_dbh->pmysql, NULL)))) @@ -605,9 +606,10 @@ PPCODE: { D_imp_dbh(dbh); + SV* quoted; ASYNC_CHECK_XS(dbh); - SV* quoted = dbd_db_quote(dbh, str, type); + quoted = dbd_db_quote(dbh, str, type); ST(0) = quoted ? sv_2mortal(quoted) : str; XSRETURN(1); } EOT (Stripping trailing CRs from patch.) patching file mysql.xs Hunk #2 succeeded at 609 (offset 3 lines). CPAN.pm: Going to build C/CA/CAPTTOFU/DBD-mysql-4.022.tar.gz >>> C:\Perl-5.14\bin\perl.exe Makefile.PL --testhost=plow --testport=3308 --testuser=test "--libs=-LC:\mysql\lib\opt -llibmysql" mysql_config.pl, and an associated bat file, has been successfully created under C:\mysql\bin Unknown option: testdb Unknown option: testpassword Unknown option: testsocket Unknown option: nocatchstderr Unknown option: ssl Unknown option: nofoundrows Unknown option: force-embedded Use of uninitialized value in printf at Makefile.PL line 181, line 58. I will use the following settings for compiling and testing: cflags (mysql_config ) = -I"C:\mysql\include" embedded (mysql_config ) = libs (User's choice) = -LC:\mysql\lib\opt -llibmysql mysql_config (guessed ) = mysql_config nocatchstderr (default ) = 0 nofoundrows (default ) = 0 ssl (guessed ) = 0 testdb (default ) = test testhost (User's choice) = plow testpassword (default ) = testport ( ) = 3308 testsocket (default ) = testuser (User's choice) = test To change these settings, see 'perl Makefile.PL --help' and 'perldoc INSTALL'. Checking if your kit is complete... Looks good Multiple copies of Driver.xst found in: C:/cpanfly-5.14/var/megalib/auto/DBI/ C:/Perl-5.14/lib/auto/DBI/ at Makefile.PL line 942. Using DBI 1.622 (for perl 5.014000 on MSWin32-x86-multi-thread) installed in C:/cpanfly-5.14/var/megalib/auto/DBI/ Writing Makefile for DBD::mysql Writing MYMETA.yml and MYMETA.json >>> nmake Microsoft (R) Program Maintenance Utility Version 7.00.8882 Copyright (C) Microsoft Corp 1988-2000. All rights reserved. cl -c -IC:\cpanfly-5.14\var\megalib\auto\DBI -I"C:\mysql\include" -DDBD_MYSQL_INSERT_ID_IS_GOOD -g -nologo -GF -W3 -MD -Zi -DNDEBUG -O1 -DWIN32 -D_CONSOLE -DNO_STRICT -DPERL_TEXTMODE_SCRIPTS -DUSE_SITECUSTOMIZE -DPERL_IMPLICIT_CONTEXT -DPERL_IMPLICIT_SYS -DUSE_PERLIO -D_USE_32BIT_TIME_T -MD -Zi -DNDEBUG -O1 -DVERSION=\"4.022\" -DXS_VERSION=\"4.022\" "-IC:\Perl-5.14\lib\CORE" dbdimp.c Command line warning D4002 : ignoring unknown option '-g' dbdimp.c dbdimp.c(2409) : warning C4244: '=' : conversion from 'unsigned __int64 ' to 'char ', possible loss of data dbdimp.c(4751) : warning C4018: '!=' : signed/unsigned mismatch dbdimp.c(4606) : warning C4700: local variable 'slen' used without having been initialized C:\Perl-5.14\bin\perl.exe -p -e "s/~DRIVER~/mysql/g" C:\cpanfly-5.14\var\megalib\auto\DBI\Driver.xst > mysql.xsi C:\Perl-5.14\bin\perl.exe C:\cpanfly-5.14\var\megalib\ExtUtils\xsubpp -typemap C:\Perl-5.14\lib\ExtUtils\typemap mysql.xs > mysql.xsc && C:\Perl-5.14\bin\perl.exe -MExtUtils::Command -e mv -- mysql.xsc mysql.c Warning: duplicate function definition 'do' detected in mysql.xs, line 243 Warning: duplicate function definition 'rows' detected in mysql.xs, line 754 cl -c -IC:\cpanfly-5.14\var\megalib\auto\DBI -I"C:\mysql\include" -DDBD_MYSQL_INSERT_ID_IS_GOOD -g -nologo -GF -W3 -MD -Zi -DNDEBUG -O1 -DWIN32 -D_CONSOLE -DNO_STRICT -DPERL_TEXTMODE_SCRIPTS -DUSE_SITECUSTOMIZE -DPERL_IMPLICIT_CONTEXT -DPERL_IMPLICIT_SYS -DUSE_PERLIO -D_USE_32BIT_TIME_T -MD -Zi -DNDEBUG -O1 -DVERSION=\"4.022\" -DXS_VERSION=\"4.022\" "-IC:\Perl-5.14\lib\CORE" mysql.c Command line warning D4002 : ignoring unknown option '-g' mysql.c mysql.xs(503) : warning C4244: '=' : conversion from 'unsigned __int64 ' to 'int ', possible loss of data mysql.xs(534) : warning C4244: '=' : conversion from 'unsigned __int64 ' to 'int ', possible loss of data mysql.xs(261) : warning C4101: 'statement_ptr' : unreferenced local variable mysql.xs(691) : warning C4101: 'retval' : unreferenced local variable mysql.xs(265) : warning C4700: local variable 'slen' used without having been initialized Running Mkbootstrap for DBD::mysql () C:\Perl-5.14\bin\perl.exe -MExtUtils::Command -e chmod -- 644 mysql.bs C:\Perl-5.14\bin\perl.exe -MExtUtils::Mksymlists -e "Mksymlists('NAME'=>\"DBD::mysql\", 'DLBASE' => 'mysql', 'DL_FUNCS' => { }, 'FUNCLIST' => [], 'IMPORTS' => { }, 'DL_VARS' => []);" C:\Perl-5.14\bin\perl.exe myld link -out:blib\arch\auto\DBD\mysql\mysql.dll -dll -nologo -nodefaultlib -debug -opt:ref,icf -libpath:"C:\Perl-5.14\lib\CORE" -machine:x86 dbdimp.obj mysql.obj C:\Perl-5.14\lib\CORE\perl514.lib C:\mysql\lib\opt\libmysql.lib C:\PROGRA~1\MICROS~3\VC98\Lib\oldnames.lib C:\PROGRA~1\MICROS~2\Lib\kernel32.lib C:\PROGRA~1\MICROS~2\Lib\user32.lib C:\PROGRA~1\MICROS~2\Lib\gdi32.lib C:\PROGRA~1\MICROS~2\Lib\winspool.lib C:\PROGRA~1\MICROS~2\Lib\comdlg32.lib C:\PROGRA~1\MICROS~2\Lib\advapi32.lib C:\PROGRA~1\MICROS~3\VC98\Lib\PSDK\shell32.lib C:\PROGRA~1\MICROS~2\Lib\ole32.lib C:\PROGRA~1\MICROS~2\Lib\oleaut32.lib C:\PROGRA~1\MICROS~2\Lib\netapi32.lib C:\PROGRA~1\MICROS~3\VC98\Lib\PSDK\uuid.lib C:\PROGRA~1\MICROS~2\Lib\ws2_32.lib C:\PROGRA~1\MICROS~2\Lib\mpr.lib C:\PROGRA~1\MICROS~2\Lib\winmm.lib C:\PROGRA~1\MICROS~2\Lib\version.lib C:\PROGRA~1\MICROS~2\Lib\odbc32.lib C:\PROGRA~1\MICROS~2\Lib\odbccp32.lib C:\PROGRA~1\MICROS~2\Lib\comctl32.lib C:\PROGRA~1\MICROS~3\VC98\Lib\msvcrt.lib -def:mysql.def Creating library blib\arch\auto\DBD\mysql\mysql.lib and object blib\arch\auto\DBD\mysql\mysql.exp if exist blib\arch\auto\DBD\mysql\mysql.dll.manifest mt -nologo -manifest blib\arch\auto\DBD\mysql\mysql.dll.manifest -outputresource:blib\arch\auto\DBD\mysql\mysql.dll;2 if exist blib\arch\auto\DBD\mysql\mysql.dll.manifest del blib\arch\auto\DBD\mysql\mysql.dll.manifest C:\Perl-5.14\bin\perl.exe -MExtUtils::Command -e chmod -- 755 blib\arch\auto\DBD\mysql\mysql.dll copy c:\mysql\lib\opt\libmysql.dll blib\arch\auto\DBD\mysql 1 file(s) copied. cp lib/DBD/mysql.pm blib\lib\DBD\mysql.pm cp lib/DBD/mysql/GetInfo.pm blib\lib\DBD\mysql\GetInfo.pm cp lib/DBD/mysql/INSTALL.pod blib\lib\DBD\mysql\INSTALL.pod cp lib/Bundle/DBD/mysql.pm blib\lib\Bundle\DBD\mysql.pm C:\Perl-5.14\bin\perl.exe -MExtUtils::Command -e cp -- mysql.bs blib\arch\auto\DBD\mysql\mysql.bs C:\Perl-5.14\bin\perl.exe -MExtUtils::Command -e chmod -- 644 blib\arch\auto\DBD\mysql\mysql.bs CAPTTOFU/DBD-mysql-4.022.tar.gz nmake -- OK Running make test >>> nmake test TEST_VERBOSE=1 Microsoft (R) Program Maintenance Utility Version 7.00.8882 Copyright (C) Microsoft Corp 1988-2000. All rights reserved. C:\Perl-5.14\bin\perl.exe "-MExtUtils::Command::MM" "-e" "test_harness(1, 'blib\lib', 'blib\arch')" t/*.t t/00base.t .................. 1..6 ok 1 - use DBI; ok 2 - use DBD::mysql; ok 3 - Internal set ok 4 - Install driver ok 5 - DBI::dr set ok 6 - Version 4.022 Driver version is 4.022 ok t/10connect.t ............... 1..2 ok 1 - Connected to database ok 2 ok t/20createdrop.t ............ 1..4 ok 1 - Connected to database ok 2 - making slate clean ok 3 - creating t1 ok 4 - dropping created t1 ok t/25lockunlock.t ............ 1..13 ok 1 - drop table if exists t1 ok 2 - create table t1 ok 3 - lock table t1 ok 4 - Insert ok 5 - Delete ok 6 - Prepare of select ok 7 - Prepare of select ok 8 - Execute ok 9 - Fetch should have failed ok 10 - Fetch should have failed ok 11 - Unlock tables ok 12 - Drop table t1 ok 13 - Disconnecting ok t/29warnings.t .............. 1..4 ok 1 - Connected to database ok 2 ok 3 ok 4 ok t/30insertfetch.t ........... 1..10 ok 1 - Connected to database ok 2 - making slate clean ok 3 - creating table ok 4 - loading data ok 5 - deleting from table t1 ok 6 ok 7 ok 8 ok 9 ok 10 - Dropping table ok t/31insertid.t .............. 1..18 ok 1 ok 2 - create t1 ok 3 ok 4 ok 5 ok 6 - insert id == 1 ok 7 ok 8 ok 9 ok 10 ok 11 ok 12 ok 13 - sth insert id 2 == max(id) 2 in t1 ok 14 - dbh insert id 2 == max(id) 2 in t1 ok 15 ok 16 ok 17 ok 18 ok t/32insert_error.t .......... 1..9 ok 1 ok 2 ok 3 ok 4 ok 5 - fails with duplicate entry ok 6 ok 7 ok 8 ok 9 ok t/35limit.t ................. 1..111 ok 1 - Connected to database ok 2 - making slate clean ok 3 - creating table ok 4 PERL testing insertion of values from previous prepare of insert statement: ok 5 ok 6 ok 7 ok 8 ok 9 ok 10 ok 11 ok 12 ok 13 ok 14 ok 15 ok 16 ok 17 ok 18 ok 19 ok 20 ok 21 ok 22 ok 23 ok 24 ok 25 ok 26 ok 27 ok 28 ok 29 ok 30 ok 31 ok 32 ok 33 ok 34 ok 35 ok 36 ok 37 ok 38 ok 39 ok 40 ok 41 ok 42 ok 43 ok 44 ok 45 ok 46 ok 47 ok 48 ok 49 ok 50 ok 51 ok 52 ok 53 ok 54 ok 55 ok 56 ok 57 ok 58 ok 59 ok 60 ok 61 ok 62 ok 63 ok 64 ok 65 ok 66 ok 67 ok 68 ok 69 ok 70 ok 71 ok 72 ok 73 ok 74 ok 75 ok 76 ok 77 ok 78 ok 79 ok 80 ok 81 ok 82 ok 83 ok 84 ok 85 ok 86 ok 87 ok 88 ok 89 ok 90 ok 91 ok 92 ok 93 ok 94 ok 95 ok 96 ok 97 ok 98 ok 99 ok 100 ok 101 ok 102 ok 103 ok 104 PERL rows : 1 PERL testing prepare of select statement with LIMIT placeholders: ok 105 PERL testing exec of bind vars for LIMIT ok 106 ok 107 ok 108 ok 109 ok 110 ok 111 ok t/35prepare.t ............... 1..49 ok 1 - Connected to database ok 2 - Making slate clean ok 3 - Creating table ok 4 - Testing prepare show tables ok 5 - Executing 'show tables' ok 6 - Testing if result set and no errors ok 7 - Checking if results equal to 't1' # ok 8 - Finishing up with statement handle ok 9 - Inserting first row ok 10 - Preparing insert of second row ok 11 - Inserting second row ok 12 - One row should have been inserted ok 13 - Finishing up with statement handle ok 14 - Testing prepare of query ok 15 - Testing execute of query ok 16 - Testing fetchall_arrayref of executed query ok 17 - Preparing insert, this time using placeholders ok 18 - Testing insert row ok 19 - Should have inserted one row ok 20 - Testing insert row ok 21 - Should have inserted one row ok 22 - Testing insert row ok 23 - Should have inserted one row ok 24 - Testing insert row ok 25 - Should have inserted one row ok 26 - Testing insert row ok 27 - Should have inserted one row ok 28 - Testing insert row ok 29 - Should have inserted one row ok 30 - Testing insert row ok 31 - Should have inserted one row ok 32 - Testing insert row ok 33 - Should have inserted one row ok 34 - Testing insert row ok 35 - Should have inserted one row ok 36 - Testing insert row ok 37 - Should have inserted one row ok 38 - Testing closing of statement handle ok 39 - Testing prepare of query with placeholders ok 40 - Testing execution with values id = 1 or id = 2 ok 41 - Testing fetchall_arrayref (should be four rows) RETREF 4 ok 42 - $ret_ref should contain four rows in result set ok 43 - Testing prepare of dropping table ok 44 - Executing drop table ok 45 - Prepare - Testing bug \#20153 ok 46 - Execute - Testing bug \#20153 ok 47 - Fetch - Testing bug \#20153 ok 48 - Not Fetch - Testing bug \#20153 ok 49 - Testing disconnect ok t/40bindparam.t ............. 1..41 ok 1 ok 2 ok 3 ok 4 ok 5 ok 6 ok 7 ok 8 ok 9 ok 10 ok 11 ok 12 ok 13 ok 14 ok 15 ok 16 ok 17 ok 18 ok 19 ok 20 ok 21 ok 22 ok 23 - id set to -1 ok 24 - name eq abc ok 25 - id set to 1 ok 26 - $name set to Alligator Descartes ok 27 - id set to 2 ok 28 - $name set to Tim Bunce ok 29 - id set to 3 ok 30 - $name set to Jochen Wiedmann ok 31 - id set to 4 ok 32 - $name set to Andreas Koenig ok 33 - id set to 5 ok 34 - name not defined ok 35 - id set to 6 ok 36 - $name set to '?' ok 37 - $id set to 7 ok 38 - $name set to '?' ok 39 ok 40 ok 41 ok t/40bindparam2.t ............ 1..13 ok 1 - drop table t1 ok 2 - create table t1 ok 3 - insert into t1 (null, 1) ok 4 ok 5 - $rows->[0][1] == 1 ok 6 ok 7 ok 8 ok 9 ok 10 ok 11 ok 12 ok 13 ok t/40blobs.t ................. 1..14 ok 1 - Drop table if exists t1 ok 2 ok 3 ok 4 ok 5 ok 6 ok 7 ok 8 - row returned defined ok 9 - records from t1 returned 2 ok 10 - id set to 1 ok 11 - blob set equal to blob returned 00000000 000102030405060708090a0b0c0d0e0f101112131415161718191a1b1c1d1e1f 00000020 202122232425262728292a2b2c2d2e2f303132333435363738393a3b3c3d3e3f 00000040 404142434445464748494a4b4c4d4e4f505152535455565758595a5b5c5d5e5f 00000060 606162636465666768696a6b6c6d6e6f707172737475767778797a7b7c7d7e7f 00000080 808182838485868788898a8b8c8d8e8f909192939495969798999a9b9c9d9e9f 000000a0 a0a1a2a3a4a5a6a7a8a9aaabacadaeafb0b1b2b3b4b5b6b7b8b9babbbcbdbebf 000000c0 c0c1c2c3c4c5c6c7c8c9cacbcccdcecfd0d1d2d3d4d5d6d7d8d9dadbdcdddedf 000000e0 e0e1e2e3e4e5e6e7e8e9eaebecedeeeff0f1f2f3f4f5f6f7f8f9fafbfcfdfeff 00000000 000102030405060708090a0b0c0d0e0f101112131415161718191a1b1c1d1e1f 00000020 202122232425262728292a2b2c2d2e2f303132333435363738393a3b3c3d3e3f 00000040 404142434445464748494a4b4c4d4e4f505152535455565758595a5b5c5d5e5f 00000060 606162636465666768696a6b6c6d6e6f707172737475767778797a7b7c7d7e7f 00000080 808182838485868788898a8b8c8d8e8f909192939495969798999a9b9c9d9e9f 000000a0 a0a1a2a3a4a5a6a7a8a9aaabacadaeafb0b1b2b3b4b5b6b7b8b9babbbcbdbebf 000000c0 c0c1c2c3c4c5c6c7c8c9cacbcccdcecfd0d1d2d3d4d5d6d7d8d9dadbdcdddedf 000000e0 e0e1e2e3e4e5e6e7e8e9eaebecedeeeff0f1f2f3f4f5f6f7f8f9fafbfcfdfeff ok 12 ok 13 - Drop table t1 ok 14 ok "my" variable $info masks earlier declaration in same scope at t/40catalog.t line 288. t/40catalog.t ............... 1..78 ok 1 - connecting ok 2 - cleaning up ok 3 ok 4 ok 5 ok 6 ok 7 ok 8 ok 9 ok 10 ok 11 ok 12 ok 13 ok 14 ok 15 ok 16 ok 17 - cleaning up ok 18 - No catalogs expected ok 19 - Some schemas expected ok 20 - Some table types expected ok 21 - cleaning up ok 22 ok 23 ok 24 ok 25 ok 26 - one row expected ok 27 ok 28 ok 29 ok 30 ok 31 ok 32 ok 33 - two rows expected ok 34 ok 35 ok 36 ok 37 - only one table expected ok 38 ok 39 ok 40 ok 41 - only one table expected ok 42 ok 43 ok 44 ok 45 - only one table expected ok 46 - five tables expected ok 47 - table with single quote ok 48 - table with back quote ok 49 - two tables expected ok 50 - cleaning up ok 51 ok 52 ok 53 ok 54 ok 55 ok 56 ok 57 - two rows expected ok 58 ok 59 ok 60 - one row expected ok 61 ok 62 ok 63 - one row expected ok 64 ok 65 ok 66 ok 67 ok 68 - two rows expected ok 69 ok 70 - cleaning up ok 71 - creating table ok 72 ok 73 ok 74 ok 75 ok 76 ok 77 ok 78 - cleaning up ok t/40keyinfo.t ............... 1..7 ok 1 - Connected to database for key info tests ok 2 - Dropped table ok 3 - Created table t1 ok 4 - Got primary key info ok 5 - Check primary_key_info results ok 6 - Check primary_key results ok 7 - Dropped table ok t/40listfields.t ............ 1..25 ok 1 - drop table if exists t1 ok 2 - create table t1 ok 3 - table info for t1 ok 4 - column_info for t1 ok 5 - $sth defined ok 6 - not error ok 7 - prepare succeeded ok 8 - execute select ok 9 - 2 defined ok 10 - $res 2 == 2 ok 11 - $sth->{NAME} defined ok 12 - id eq 'id' ok 13 - name eq 'name' ok 14 - nullable ok 15 ok 16 ok 17 - SQL_INTEGER ok 18 - SQL_VARCHAR ok 19 ok 20 ok 21 ok 22 ok 23 - equals '0' ok 24 ok 25 - equals 'abc' ok t/40nulls.t ................. 1..10 ok 1 - DROP TABLE IF EXISTS t1 ok 2 - create table CREATE TABLE t1 ( # id INT(4), # name VARCHAR(64) # ) # ok 3 - inserting nulls ok 4 ok 5 ok 6 ok 7 ok 8 ok 9 ok 10 ok t/40nulls_prepare.t ......... 1..22 ok 1 - Connected to database ok 2 - Making slate clean ok 3 - creating test table for bug 49719 ok 4 - Prepare of insert ok 5 - Prepare of query ok 6 - bind_param(1,42, SQL_WARCHAR) ok 7 - bind_param(2,102,SQL_WARCHAR ok 8 - bind_param(3, undef,SQL_WVARCHAR) ok 9 - bind_param(4, 10004,SQL_WVARCHAR) ok 10 - Executing the first insert ok 11 - bind_param(1,43,SQL_WVARCHAR) ok 12 - bind_param(2,2002,SQL_WVARCHAR) ok 13 - bind_param(3,20003,SQL_WVARCHAR) ok 14 - bind_param(4,200004,SQL_WVARCHAR) ok 15 - Executing the 2nd insert ok 16 - Query for record of id = 42 ok 17 ok 18 - Query for record of id = 43 ok 19 ok 20 ok 21 ok 22 - Testing disconnect ok t/40numrows.t ............... 1..30 ok 1 ok 2 - CREATE TABLE t1 ok 3 - inserting first row ok 4 ok 5 ok 6 - \$sth->rows should be 1 ok 7 ok 8 - Verified rows should be 1 ok 9 ok 10 - inserting second row ok 11 ok 12 ok 13 - \$sth->rows should be 2 ok 14 ok 15 - Verified rows should be 2 ok 16 ok 17 - inserting third row ok 18 ok 19 ok 20 - rows should be 2 ok 21 ok 22 - Verified rows should be 2 ok 23 ok 24 ok 25 ok 26 - rows should be 3 ok 27 ok 28 - Verified rows should be 3 ok 29 - drop table t1 ok 30 ok t/40server_prepare.t ........ 1..27 ok 1 - connecting ok 2 - making slate clean ok 3 - creating table ok 4 - loading data ok 5 ok 6 ok 7 - binding parameter ok 8 - fetching data ok 9 ok 10 ok 11 - cleaning up ok 12 - making slate clean ok 13 - creating test table ok 14 ok 15 - binding int ok 16 - binding smallint ok 17 - binding tinyint ok 18 - binding bigint ok 19 - inserting data ok 20 ok 21 - cleaning up ok 22 - making slate clean ok 23 - creating test table ok 24 ok 25 - insert t3 ok 26 ok 27 - cleaning up ok t/40server_prepare_error.t .. 1..3 ok 1 ok 2 errstr You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'select select' at line 1 ok 3 ok t/40types.t ................. err perl 1..20 ok 1 - Connected to database ok 2 - making slate clean ok 3 - creating table ok 4 - getting table information ok 5 - checking column type ok 6 ok 7 - cleaning up ok 8 - creating table ok 9 - binding parameter ok 10 - inserting data ok 11 ok 12 - binding parameter ok 13 - inserting data ok 14 ok 15 ok 16 - cleaning up ok 17 - creating table ok 18 - loading data ok 19 ok 20 - cleaning up ok t/41bindparam.t ............. 1..11 ok 1 - drop table t1 ok 2 - create table t1 ok 3 ok 4 - bind param 10000 col1 ok 5 - execute ok 6 - bind param 10001 col1 ok 7 - execute ok 8 ok 9 ok 10 ok 11 ok t/41blobs_prepare.t ......... 1..25 ok 1 - drop table if exists t1 ok 2 - create table t1 ok 3 ok 4 ok 5 - inserting $blob1 ok 6 ok 7 ok 8 - select from t1 ok 9 ok 10 - two rows fetched ok 11 - first row id == 1 00000000 353244366e42576a56357061626a7771454c354557634332646d6d7948555550 00000020 446e453239444b7041397952726f3543726a44744d444466705a736438594347 00000040 527a425437347247326d347247595937745876476e7275346e4a4e5773453847 00000060 797a424848417772334a397144384b3346515864435758585a3638544565397a 00000080 4a6a6b4274344d624b676b366b64456a75596d3665444a704e6347375979334c 000000a0 3363716172476771394e6f4159477a4336636a5377324a735738557273505753 000000c0 76656e686a4d5843764b614c7944476b3675324b517a5776574b6a757237436e 000000e0 734a4a626a774a594633726733676378533858373747735933575545714d5834 ok 12 - ok 13 ok 14 ok 15 - inserting $blob2 ok 16 ok 17 ok 18 ok 19 ok 20 - two rows ok 21 - row id == 1 00000000 2222222222222222222222222222222222222222222222222222222222222222 00000020 2222222222222222222222222222222222222222222222222222222222222222 00000040 2222222222222222222222222222222222222222222222222222222222222222 00000060 2222222222222222222222222222222222222222222222222222222222222222 00000080 2222222222222222222222222222222222222222222222222222222222222222 000000a0 2222222222222222222222222222222222222222222222222222222222222222 000000c0 2222222222222222222222222222222222222222222222222222222222222222 000000e0 2222222222222222222222222222222222222222222222222222222222222222 ok 22 - ok 23 ok 24 - drop t1 ok 25 ok t/42bindparam.t ............. 1..12 ok 1 ok 2 ok 3 ok 4 ok 5 ok 6 ok 7 ok 8 ok 9 ok 10 ok 11 ok 12 ok t/50chopblanks.t ............ 1..58 ok 1 - drop table if exists t1 ok 2 - create table t1 ok 3 ok 4 ok 5 - inserting (1, ) into t1 ok 6 - selecting where id = 1 ok 7 ok 8 - $name should not have blanks chopped ok 9 ok 10 ok 11 - should have blanks chopped ok 12 - inserting (2, ) into t1 ok 13 - selecting where id = 2 ok 14 ok 15 - $name should not have blanks chopped ok 16 ok 17 ok 18 - should have blanks chopped ok 19 - inserting (3, a b c ) into t1 ok 20 - selecting where id = 3 ok 21 ok 22 - $name should not have blanks chopped ok 23 ok 24 ok 25 - should have blanks chopped ok 26 ok 27 ok 28 - drop t1 ok 29 ok 30 - drop table if exists t1 ok 31 - create table t1 ok 32 ok 33 ok 34 - inserting (1, ) into t1 ok 35 - selecting where id = 1 ok 36 ok 37 - $name should not have blanks chopped ok 38 ok 39 ok 40 - should have blanks chopped ok 41 - inserting (2, ) into t1 ok 42 - selecting where id = 2 ok 43 ok 44 - $name should not have blanks chopped ok 45 ok 46 ok 47 - should have blanks chopped ok 48 - inserting (3, a b c ) into t1 ok 49 - selecting where id = 3 ok 50 ok 51 - $name should not have blanks chopped ok 52 ok 53 ok 54 - should have blanks chopped ok 55 ok 56 ok 57 - drop t1 ok 58 ok t/50commit.t ................ 1..21 ok 1 - drop table if exists t1 ok 2 - create $table ok 3 - $dbh->{AutoCommit} not defined || ok 4 ok 5 ok 6 ok 7 - insert into t1 (1, 'Jochen') ok 8 ok 9 - rollback ok 10 ok 11 - delete from t1 where id = 1 ok 12 ok 13 - commit ok 14 ok 15 ok 16 ok 17 ok 18 ok 19 - connected ok 20 ok 21 - $dbh->{AutoCommit} 1 ok t/51bind_type_guessing.t .... 1..25 ok 1 - drop table if exists t1 ok 2 - creating table ok 3 ok 4 ok 5 ok 6 ok 7 ok 8 ok 9 ok 10 ok 11 ok 12 ok 13 ok 14 ok 15 ok 16 - drop table if exists t1 ok 17 - creating table w/ varchar ok 18 ok 19 ok 20 ok 21 ok 22 ok 23 ok 24 ok 25 ok t/52comment.t ............... 1..30 ok 1 - drop table if exists t1 ok 2 - creating table ok 3 ok 4 ok 5 ok 6 ok 7 ok 8 ok 9 ok 10 ok 11 ok 12 ok 13 ok 14 ok 15 ok 16 ok 17 ok 18 ok 19 ok 20 ok 21 ok 22 ok 23 ok 24 ok 25 ok 26 ok 27 ok 28 ok 29 - drop table if exists t1 ok 30 ok t/53comment.t ............... 1..29 ok 1 - drop table if exists t1 ok 2 - creating table ok 3 ok 4 ok 5 ok 6 ok 7 ok 8 ok 9 ok 10 ok 11 ok 12 ok 13 ok 14 ok 15 ok 16 ok 17 ok 18 ok 19 ok 20 ok 21 ok 22 ok 23 ok 24 ok 25 ok 26 ok 27 ok 28 - drop table if exists t1 ok 29 ok t/55utf8.t .................. 1..32 ok 1 ok 2 ok 3 - testing quoting of utf 8 string ok 4 - testing quoting of blob ok 5 - INSERT query INSERT INTO t1 (name, bincol, shape, binutf, profile) # VALUES (?, ?, GeomFromText('Point(132865 501937)'), ?, ?) # # ok 6 ok 7 ok 8 ok 9 ok 10 ok 11 - blob was made utf8!. ok 12 - shape was made utf8!. ok 13 - compare Ādam eq Ādam ok 14 ok 15 ok 16 ok 17 ok 18 ok 19 - testing quoting of utf 8 string ok 20 - testing quoting of blob ok 21 - INSERT query INSERT INTO t1 (name, bincol, shape, binutf, profile) # VALUES (?, ?, GeomFromText('Point(132865 501937)'), ?, ?) # # ok 22 ok 23 ok 24 ok 25 ok 26 ok 27 - blob was made utf8!. ok 28 - shape was made utf8!. ok 29 - compare Ādam eq Ādam ok 30 ok 31 ok 32 ok t/60leaks.t ................. skipped: Skip $ENV{SLOW_TESTS} is not set t/65types.t ................. 1..19 ok 1 ok 2 ok 3 - prepare: ok 4 ok 5 ok 6 ok 7 ok 8 ok 9 ok 10 - prepare: ok 11 ok 12 ok 13 ok 14 ok 15 ok 16 ok 17 ok 18 ok 19 ok t/70takeimp.t ............... 1..21 ok 1 - obtained driver handle ok 2 - connected to database ok 3 - Initial connection: 2472 # ok 4 - Driver handle defined # ok 5 - Didn't get imp_data ok 6 - test that our imp_data is greater than or equal to 80, actual 104 ok 7 - our Driver should have 0 Kid(s) after calling take_imp_data ok 8 - ... our Driver should be undefined ok 9 - our TraceLevel should be undefined ok 10 - disconnect should return undef ok 11 - quote should return undefined ok 12 - we should have received 4 warnings here there Overridden connection: 2472 ok 13 - the same connection: 2472 => 2472 # ok 14 - can't get the driver # ok 15 - isa test ok 16 - our Driver should have 1 Kid(s) again: having 1 # ok 17 - our Driver should have 1 ActiveKid again: having 1 # ok 18 ok 19 ok 20 ok 21 ok t/71impdata.t ............... 1..10 ok 1 - Connected to database ok 2 - Obtained driver handle ok 3 - 1 kid ok 4 - 1 active kid ok 5 - no kids ok 6 - no active kids ok 7 - got same session ok 8 - 1 kid ok 9 - 1 active kid ok 10 - Disconnect OK ok t/75supported_sql.t ......... 1..12 ok 1 ok 2 - create t1 ok 3 ok 4 ok 5 ok 6 - $row->[0] eq t1 ok 7 ok 8 - drop t1 ok 9 - creating t1 again with 1 col ok 10 - alter t1 ADD COLUMN ok 11 - drop t1 ok 12 ok # Testing multicall against SQL_DBMS_VER: 5.0.51b t/76multi_statement.t ....... 1..25 ok 1 - Connected to database with multi statement support ok 2 - init connection SQL_MODE non strict ok 3 - clean up ok 4 - create table ok 5 - 2 inserts ok 6 - 2 more inserts ok 7 ok 8 - Execute updates ok 9 - First update affected 1 row ok 10 - First update had no warnings ok 11 - Statement handle is Active ok 12 ok 13 - Second update affected 2 rows ok 14 - Second update had 2 warnings ok 15 ok 16 ok 17 - Execute updates again ok 18 ok 19 - Delete all rows ok 20 - do() reports errors ok 21 ok 22 - Execute updates ok 23 - Err was not set after execute ok 24 ok 25 - Err was set after more_results ok t/80procs.t ................. 1..29 ok 1 ok 2 ok 3 ok 4 ok 5 ok 6 ok 7 ok 8 ok 9 ok 10 ok 11 ok 12 ok 13 ok 14 - num_of_fields == 1 ok 15 ok 16 ok 17 - 1 row in resultset ok 18 ok 19 - NUM_OF_FIELDS == 2 ok 20 ok 21 ok 22 - 2 rows in resultset ok 23 ok 24 - NUM_OF_FIELDS == 3 ok 25 ok 26 ok 27 - 3 Rows in resultset ok 28 ok 29 ok t/85init_command.t .......... 1..5 ok 1 - Connected to database ok 2 ok 3 ok 4 ok 5 - session variable is 7 ok t/86_bug_36972.t ............ 1..11 ok 1 - connecting ok 2 - making slate clean ok 3 - creating test table ok 4 ok 5 - binding int ok 6 - binding smallint ok 7 - binding tinyint ok 8 - binding bigint ok 9 - inserting data ok 10 ok 11 - cleaning up ok t/91errcheck.t .............. 1..1 ok 1 - error string should be set on a bad call ok All tests successful. Files=41, Tests=892, 8 wallclock secs ( 0.28 usr + 0.09 sys = 0.38 CPU) Result: PASS CAPTTOFU/DBD-mysql-4.022.tar.gz nmake test TEST_VERBOSE=1 -- OK Patrick Galbraith <patg@patg.net> A MySQL driver for the Perl5 Database Interface (DBI) >>> (cd C:\cpanfly-5.14\var\cpan\build\DBD-mysql-4.022-GFLLep && tar cvf - DBD-mysql-4.022.ppd blib) | gzip -c >C:/cpanfly-5.14/var/REPO/C/CA/CAPTTOFU/DBD-mysql-4.022.tar.gz DBD-mysql-4.022.ppd blib/ blib/arch/ blib/arch/auto/ blib/arch/auto/DBD/ blib/arch/auto/DBD/mysql/ blib/arch/auto/DBD/mysql/libmysql.dll blib/arch/auto/DBD/mysql/mysql.bs blib/arch/auto/DBD/mysql/mysql.dll blib/arch/auto/DBD/mysql/mysql.exp blib/arch/auto/DBD/mysql/mysql.lib blib/lib/ blib/lib/Bundle/ blib/lib/Bundle/DBD/ blib/lib/Bundle/DBD/mysql.pm blib/lib/DBD/ blib/lib/DBD/mysql/ blib/lib/DBD/mysql/GetInfo.pm blib/lib/DBD/mysql/INSTALL.pod blib/lib/DBD/mysql.pm >>> mv C:\cpanfly-5.14\var\cpan\build\DBD-mysql-4.022-GFLLep/DBD-mysql-4.022.ppd C:/cpanfly-5.14/var/REPO/C/CA/CAPTTOFU Finished 2012-08-30T02:25:44