PATH=/usr/bin:/bin:/data/fly2200/cpanfly-5.22/var/megalib/bin Start 2016-11-30T02:07:30 ActivePerl-2200 CPAN-2.10 Reading '/data/fly2200/cpanfly-5.22/var/cpan/Metadata' Database was generated on Tue, 29 Nov 2016 06:54:00 GMT ______________________ D i s t r o P r e f s ______________________ DBD-mysql.yml[0] Checksum for /data/fly2200/cpanfly-5.22/var/cpan/sources/authors/id/M/MI/MICHIELB/DBD-mysql-4.041.tar.gz ok DBD-mysql-4.041/ DBD-mysql-4.041/Changes DBD-mysql-4.041/constants.h DBD-mysql-4.041/dbdimp.c DBD-mysql-4.041/dbdimp.h DBD-mysql-4.041/lib/ DBD-mysql-4.041/LICENSE DBD-mysql-4.041/Makefile.PL DBD-mysql-4.041/Makefile.PL.embedded DBD-mysql-4.041/MANIFEST DBD-mysql-4.041/MANIFEST.SKIP DBD-mysql-4.041/META.json DBD-mysql-4.041/META.yml DBD-mysql-4.041/myld DBD-mysql-4.041/mysql.xs DBD-mysql-4.041/README.md DBD-mysql-4.041/t/ DBD-mysql-4.041/t/00base.t DBD-mysql-4.041/t/05dbcreate.t DBD-mysql-4.041/t/10connect.t DBD-mysql-4.041/t/15reconnect.t DBD-mysql-4.041/t/16dbi-get_info.t DBD-mysql-4.041/t/20createdrop.t DBD-mysql-4.041/t/25lockunlock.t DBD-mysql-4.041/t/29warnings.t DBD-mysql-4.041/t/30insertfetch.t DBD-mysql-4.041/t/31insertid.t DBD-mysql-4.041/t/32insert_error.t DBD-mysql-4.041/t/35limit.t DBD-mysql-4.041/t/35prepare.t DBD-mysql-4.041/t/40bindparam.t DBD-mysql-4.041/t/40bindparam2.t DBD-mysql-4.041/t/40bit.t DBD-mysql-4.041/t/40blobs.t DBD-mysql-4.041/t/40catalog.t DBD-mysql-4.041/t/40keyinfo.t DBD-mysql-4.041/t/40listfields.t DBD-mysql-4.041/t/40nulls.t DBD-mysql-4.041/t/40nulls_prepare.t DBD-mysql-4.041/t/40numrows.t DBD-mysql-4.041/t/40server_prepare.t DBD-mysql-4.041/t/40server_prepare_crash.t DBD-mysql-4.041/t/40server_prepare_error.t DBD-mysql-4.041/t/40types.t DBD-mysql-4.041/t/41bindparam.t DBD-mysql-4.041/t/41blobs_prepare.t DBD-mysql-4.041/t/41int_min_max.t DBD-mysql-4.041/t/42bindparam.t DBD-mysql-4.041/t/43count_params.t DBD-mysql-4.041/t/50chopblanks.t DBD-mysql-4.041/t/50commit.t DBD-mysql-4.041/t/51bind_type_guessing.t DBD-mysql-4.041/t/52comment.t DBD-mysql-4.041/t/53comment.t DBD-mysql-4.041/t/55utf8.t DBD-mysql-4.041/t/55utf8mb4.t DBD-mysql-4.041/t/56connattr.t DBD-mysql-4.041/t/60leaks.t DBD-mysql-4.041/t/65segfault.t DBD-mysql-4.041/t/65types.t DBD-mysql-4.041/t/70takeimp.t DBD-mysql-4.041/t/71impdata.t DBD-mysql-4.041/t/75supported_sql.t DBD-mysql-4.041/t/76multi_statement.t DBD-mysql-4.041/t/80procs.t DBD-mysql-4.041/t/81procs.t DBD-mysql-4.041/t/85init_command.t DBD-mysql-4.041/t/86_bug_36972.t DBD-mysql-4.041/t/87async.t DBD-mysql-4.041/t/88async-multi-stmts.t DBD-mysql-4.041/t/89async-method-check.t DBD-mysql-4.041/t/90no-async.t DBD-mysql-4.041/t/91errcheck.t DBD-mysql-4.041/t/99_bug_server_prepare_blob_null.t DBD-mysql-4.041/t/lib.pl DBD-mysql-4.041/t/manifest.t DBD-mysql-4.041/t/mysql.dbtest DBD-mysql-4.041/t/pod.t DBD-mysql-4.041/t/rt25389-bin-case.t DBD-mysql-4.041/t/rt50304-column_info_parentheses.t DBD-mysql-4.041/t/rt61849-bind-param-buffer-overflow.t DBD-mysql-4.041/t/rt75353-innodb-lock-timeout.t DBD-mysql-4.041/t/rt83494-quotes-comments.t DBD-mysql-4.041/t/rt85919-fetch-lost-connection.t DBD-mysql-4.041/t/rt86153-reconnect-fail-memory.t DBD-mysql-4.041/t/rt88006-bit-prepare.t DBD-mysql-4.041/t/rt91715.t DBD-mysql-4.041/t/version.t DBD-mysql-4.041/lib/Bundle/ DBD-mysql-4.041/lib/DBD/ DBD-mysql-4.041/lib/DBD/mysql/ DBD-mysql-4.041/lib/DBD/mysql.pm DBD-mysql-4.041/lib/DBD/mysql/GetInfo.pm DBD-mysql-4.041/lib/DBD/mysql/INSTALL.pod DBD-mysql-4.041/lib/Bundle/DBD/ DBD-mysql-4.041/lib/Bundle/DBD/mysql.pm Configuring M/MI/MICHIELB/DBD-mysql-4.041.tar.gz with Makefile.PL >>> /data/fly2200/ap2200-299134/bin/perl-static Makefile.PL --ssl --testhost=perl-stackato64-precise.activestate.com --testport=3306 --testuser=test I will use the following settings for compiling and testing: cflags (mysql_config ) = -I/data/fly2200/cpanfly-5.22/var/libs/include/mysql -g -DUNIV_LINUX -DUNIV_LINUX embedded (mysql_config ) = ldflags (guessed ) = -rdynamic libs (mysql_config ) = -L/data/fly2200/cpanfly-5.22/var/libs/lib/mysql -lmysqlclient -lz -lcrypt -lnsl -lm mysql_config (guessed ) = mysql_config nocatchstderr (default ) = 0 nofoundrows (default ) = 0 nossl (default ) = 0 testdb (default ) = test testhost (User's choice) = perl-stackato64-precise.activestate.com testpassword (default ) = testport (User's choice) = 3306 testsocket (default ) = testuser (User's choice) = test To change these settings, see 'perl Makefile.PL --help' and 'perldoc DBD::mysql::INSTALL'. Checking if your kit is complete... Looks good Have /data/fly2200/cpanfly-5.22/var/megalib Want /home/fly2200/ap2200-299134/lib Your perl and your Config.pm seem to have different ideas about the architecture they are running on. Perl thinks: [megalib] Config says: [x86_64-linux-thread-multi] This may or may not cause problems. Please check your installation of perl if you have problems building this extension. Using DBI 1.633 (for perl 5.022000 on x86_64-linux-thread-multi) installed in /home/fly2200/ap2200-299134/lib/auto/DBI/ Generating a Unix-style Makefile Writing Makefile for DBD::mysql Writing MYMETA.yml and MYMETA.json MICHIELB/DBD-mysql-4.041.tar.gz /data/fly2200/ap2200-299134/bin/perl-static Makefile.PL --ssl --testhost=perl-stackato64-precise.activestate.com --testport=3306 --testuser=test -- OK Running make for M/MI/MICHIELB/DBD-mysql-4.041.tar.gz >>> make cp lib/Bundle/DBD/mysql.pm blib/lib/Bundle/DBD/mysql.pm cp lib/DBD/mysql/INSTALL.pod blib/lib/DBD/mysql/INSTALL.pod cp lib/DBD/mysql/GetInfo.pm blib/lib/DBD/mysql/GetInfo.pm cp lib/DBD/mysql.pm blib/lib/DBD/mysql.pm Running Mkbootstrap for DBD::mysql () chmod 644 "mysql.bs" gcc -c -I/home/fly2200/ap2200-299134/lib/auto/DBI -I/data/fly2200/cpanfly-5.22/var/libs/include/mysql -g -DUNIV_LINUX -DUNIV_LINUX -DDBD_MYSQL_WITH_SSL -DDBD_MYSQL_INSERT_ID_IS_GOOD -g -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 -O2 -DVERSION=\"4.041\" -DXS_VERSION=\"4.041\" -fPIC "-I/home/fly2200/ap2200-299134/lib/CORE" dbdimp.c "/data/fly2200/ap2200-299134/bin/perl-static" -p -e "s/~DRIVER~/mysql/g" /home/fly2200/ap2200-299134/lib/auto/DBI/Driver.xst > mysql.xsi "/data/fly2200/ap2200-299134/bin/perl-static" "/data/fly2200/cpanfly-5.22/var/megalib/ExtUtils/xsubpp" -typemap "/home/fly2200/ap2200-299134/lib/ExtUtils/typemap" mysql.xs > mysql.xsc && mv mysql.xsc mysql.c Warning: duplicate function definition 'do' detected in mysql.xs, line 249 Warning: duplicate function definition 'rows' detected in mysql.xs, line 673 gcc -c -I/home/fly2200/ap2200-299134/lib/auto/DBI -I/data/fly2200/cpanfly-5.22/var/libs/include/mysql -g -DUNIV_LINUX -DUNIV_LINUX -DDBD_MYSQL_WITH_SSL -DDBD_MYSQL_INSERT_ID_IS_GOOD -g -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 -O2 -DVERSION=\"4.041\" -DXS_VERSION=\"4.041\" -fPIC "-I/home/fly2200/ap2200-299134/lib/CORE" mysql.c rm -f blib/arch/auto/DBD/mysql/mysql.so LD_RUN_PATH="/lib/x86_64-linux-gnu" gcc -shared -O2 -fstack-protector dbdimp.o mysql.o -o blib/arch/auto/DBD/mysql/mysql.so \ -L/data/fly2200/cpanfly-5.22/var/libs/lib/mysql -lmysqlclient -lz -lcrypt -lnsl -lm \ chmod 755 blib/arch/auto/DBD/mysql/mysql.so "/data/fly2200/ap2200-299134/bin/perl-static" -MExtUtils::Command::MM -e 'cp_nonempty' -- mysql.bs blib/arch/auto/DBD/mysql/mysql.bs 644 Manifying 3 pod documents MICHIELB/DBD-mysql-4.041.tar.gz make -- OK Running make test >>> make test TEST_VERBOSE=1 Running Mkbootstrap for DBD::mysql () chmod 644 "mysql.bs" PERL_DL_NONLAZY=1 "/data/fly2200/ap2200-299134/bin/perl-static" "-MExtUtils::Command::MM" "-MTest::Harness" "-e" "undef *Test::Harness::Switches; test_harness(1, 'blib/lib', 'blib/arch')" t/*.t # Driver version is 4.041 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.041 ok # Database 'test' accessible t/05dbcreate.t .......................... 1..2 ok 1 - Connected to database ok 2 ok # mysql_clientinfo is: 5.1.72 # mysql_clientversion is: 50172 # mysql_serverversion is: 50524 # mysql_hostinfo is: perl-stackato64-precise.activestate.com via TCP/IP # mysql_serverinfo is: 5.5.24-0ubuntu0.12.04.1 # mysql_stat is: Uptime: 16292747 Threads: 1 Questions: 62221 Slow queries: 0 Opens: 7820 Flush tables: 1 Open tables: 57 Queries per second avg: 0.003 # mysql_protoinfo is: 10 # SQL_DBMS_VER is 5.5.24-0ubuntu0.12.04.1 # Default storage engine is: InnoDB t/10connect.t ........................... ok 1 - Connected to database ok 2 - Value of 'mysql_clientinfo' ok 3 - Value of 'mysql_clientversion' ok 4 - Value of 'mysql_serverversion' ok 5 - Value of 'mysql_hostinfo' ok 6 - Value of 'mysql_serverinfo' ok 7 - Value of 'mysql_stat' ok 8 - Value of 'mysql_protoinfo' ok 9 - get_info SQL_DBMS_VER ok 10 - get_info SQL_DRIVER_VER like dd.dd.dddd ok 11 - SQL_DRIVER_VER starts with "04." (update for 5.x) ok 12 - Disconnected ok 13 - Username and Password attributes override ok 14 - Username and Password attributes override 1..14 ok t/15reconnect.t ......................... 1..16 ok 1 - Connected to database ok 2 - checking for active handle ok 3 - enabling reconnect ok 4 - enabling autocommit ok 5 - disconnecting active handle ok 6 - checking for inactive handle ok 7 - implicitly reconnecting handle with 'do' ok 8 - checking for reactivated handle ok 9 - Connected to database ok 10 - checking for active handle ok 11 - enabling reconnect ok 12 - enabling autocommit ok 13 - disconnecting active handle ok 14 - checking for inactive handle ok 15 - implicitly reconnecting handle with 'do' ok 16 - checking for reactivated handle ok t/16dbi-get_info.t ...................... ok 1 - SQL_DBMS_NAME ok 2 - SQL_DBMS_VER ok 3 - SQL_CATALOG_NAME_SEPARATOR ok 4 - SQL_IDENTIFIER_QUOTE_CHAR ok 5 - SQL_CATALOG_LOCATION 1..5 ok t/20createdrop.t ........................ 1..4 ok 1 - Connected to database ok 2 - making slate clean ok 3 - creating dbd_mysql_t20createdrop ok 4 - dropping created dbd_mysql_t20createdrop ok t/25lockunlock.t ........................ 1..13 ok 1 - drop table if exists dbd_mysql_t25lockunlock ok 2 - create table dbd_mysql_t25lockunlock ok 3 - lock table dbd_mysql_t25lockunlock 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 dbd_mysql_t25lockunlock ok 13 - Disconnecting ok t/29warnings.t .......................... 1..14 ok 1 - Connected to database ok 2 ok 3 ok 4 - warnings from sth ok 5 ok 6 ok 7 ok 8 - warnings from dbh ok 9 ok 10 ok 11 ok 12 ok 13 ok 14 ok t/30insertfetch.t ....................... ok 1 - Connected to database ok 2 - creating table ok 3 - loading data ok 4 - mysql_info 'Records: 2 Duplicates: 0 Warnings: 0' ok 5 - mysql_info: Records ok 6 - mysql_info: Duplicates ok 7 - mysql_info: Warnings ok 8 - deleting from table dbd_mysql_t30 ok 9 ok 10 ok 11 ok 12 ok 13 1..13 ok t/31insertid.t .......................... 1..19 ok 1 ok 2 ok 3 - create dbd_mysql_t31 ok 4 ok 5 ok 6 ok 7 - insert id == 1 ok 8 - insert id == 1 ok 9 ok 10 ok 11 ok 12 ok 13 ok 14 ok 15 - dbh insert id 2 == max(id) 2 in dbd_mysql_t31 ok 16 - sth insert id 2 == max(id) 2 in dbd_mysql_t31 ok 17 ok 18 ok 19 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 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 ok 105 - testing prepare of select statement with LIMIT placeholders ok 106 - testing exec of bind vars for limit 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 'dbd_mysql_t35prepare' # 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 ok 2 ok 3 - create table dbd_mysql_t40bindparam2 ok 4 - insert into dbd_mysql_t40bindparam2 (null, 1) ok 5 ok 6 - $rows->[0][1] == 1 ok 7 ok 8 ok 9 ok 10 ok 11 ok 12 ok 13 ok t/40bit.t ............................... 1..15 ok 1 - Drop table if exists dbd_mysql_b1 ok 2 ok 3 ok 4 ok 5 ok 6 ok 7 ok 8 ok 9 - result returned defined ok 10 - should be 11111111 ok 11 - should be 1010 ok 12 - should be 101 ok 13 ok 14 - Drop table dbd_mysql_b1 ok 15 ok t/40blobs.t ............................. 1..14 ok 1 - Drop table if exists dbd_mysql_t40blobs ok 2 ok 3 ok 4 ok 5 ok 6 ok 7 ok 8 - row returned defined ok 9 - records from dbd_mysql_t40blobs 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 dbd_mysql_t40blobs ok 14 ok 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 dbd_mysql_keyinfo 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 - create table dbd_mysql_40listfields ok 2 - table info for dbd_mysql_40listfields ok 3 - column_info for dbd_mysql_40listfields ok 4 - $sth defined ok 5 - not error ok 6 - prepare succeeded ok 7 - execute select ok 8 - 2 defined ok 9 - $res 2 == 2 ok 10 - $sth->{NAME} defined ok 11 - id eq 'id' ok 12 - name eq 'name' ok 13 - nullable ok 14 ok 15 ok 16 - SQL_INTEGER ok 17 - SQL_VARCHAR ok 18 ok 19 ok 20 ok 21 ok 22 - equals '0' ok 23 ok 24 - equals 'abc' ok 25 ok t/40nulls.t ............................. 1..10 ok 1 - DROP TABLE IF EXISTS dbd_mysql_t40nulls ok 2 - create table CREATE TABLE dbd_mysql_t40nulls ( # 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 ..................... 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 ok 23 - Testing disconnect 1..23 ok t/40numrows.t ........................... 1..30 ok 1 ok 2 - CREATE TABLE dbd_mysql_t40numrows 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 dbd_mysql_t40numrows ok 30 ok DBD::mysql::st DESTROY failed: MySQL server has gone away. t/40server_prepare.t .................... 1..31 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 - USE is not supported with mysql_server_prepare_disable_fallback=1 ok 28 - USE is supported with mysql_server_prepare_disable_fallback=0 ok 29 ok 30 ok 31 - cleaning up ok t/40server_prepare_crash.t .............. 1..39 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 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 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 ............................. 1..40 ok 1 - Connected to database ok 2 - making slate clean ok 3 - creating table ok 4 - loading data ok 5 ok 6 - scalar is integer ok 7 - scalar is not unsigned intger or double or string ok 8 - cleaning up ok 9 - creating table ok 10 - loading data ok 11 ok 12 - scalar is string ok 13 - scalar is not intger or double ok 14 - cleaning up ok 15 - creating table ok 16 - getting table information ok 17 - checking column type ok 18 ok 19 - cleaning up ok 20 - creating table ok 21 - binding parameter ok 22 - inserting data ok 23 ok 24 - binding parameter ok 25 - inserting data ok 26 ok 27 ok 28 - scalar is double ok 29 - scalar is not integer or string ok 30 - scalar is double ok 31 - scalar is not integer or string ok 32 - cleaning up ok 33 - creating table ok 34 - loading data ok 35 ok 36 - scalar is unsigned integer ok 37 - scalar is not double or string ok 38 - scalar is unsigned integer ok 39 - scalar is not double or string ok 40 - cleaning up ok t/41bindparam.t ......................... 1..11 ok 1 - drop table dbd_mysql_41bindparam ok 2 - create table dbd_mysql_41bindparam 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 dbd_mysql_41blobs_prepare ok 2 - create table dbd_mysql_41blobs_prepare ok 3 ok 4 ok 5 - inserting $blob1 ok 6 ok 7 ok 8 - select from dbd_mysql_41blobs_prepare ok 9 ok 10 - two rows fetched ok 11 - first row id == 1 # 00000000 597241756f75724137503471447776424762426f575a655a4d44724570574472 # 00000020 6d67726178366577717a716b74794655584a63724c3278425872713268505167 # 00000040 596863746f4c75514e6f707964565654485967425154753839674b643248756f # 00000060 61624576635365615665744473546a736a7a4b425a77685a503277664c6b3673 # 00000080 7961376b78423550546d394151385951546778416271596f4a74414651534c53 # 000000a0 3763334e6b61754651724237426e59387a654b716477344e5851774e79636f68 # 000000c0 50504e3852446b734d4c6e7268707871475732546b346a4b33764168616b6761 # 000000e0 43687462737342397835625870444435666f723255796a346550366168785563 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 dbd_mysql_41blobs_prepare ok 25 ok t/41int_min_max.t ....................... 1..584 ok 1 - Enter strict SQL mode. ok 2 - removing dbd_mysql_t41minmax ok 3 - creating minmax table for type tinyint signed ok 4 ok 5 ok 6 - binding minimal tinyint signed, mode=strict ok 7 - inserting min data for type tinyint signed, mode=strict ok 8 ok 9 - retrieved minimal value for tinyint signed, mode=strict ok 10 - binding maximal tinyint signed, mode=strict ok 11 - inserting max data for type tinyint signed, mode=strict ok 12 ok 13 - retrieved maximal value for tinyint signed, mode=strict ok 14 - binding less than minimal tinyint signed, mode=strict ok 15 - Error, you stored -129 into tinyint signed, mode=strict # $VAR1 = [ # [ # 1, # -128 # ], # [ # 2, # 127 # ] # ]; # $VAR1 = [ # [ # 'id', # 'int(11)', # 'NO', # 'PRI', # undef, # 'auto_increment' # ], # [ # 'val', # 'tinyint(4)', # 'YES', # '', # undef, # '' # ] # ]; # ok 16 - binding more than maximal tinyint signed, mode=strict ok 17 - Error, you stored 128 into tinyint signed, mode=strict # $VAR1 = [ # [ # 1, # -128 # ], # [ # 2, # 127 # ] # ]; # $VAR1 = [ # [ # 'id', # 'int(11)', # 'NO', # 'PRI', # undef, # 'auto_increment' # ], # [ # 'val', # 'tinyint(4)', # 'YES', # '', # undef, # '' # ] # ]; # ok 18 - removing dbd_mysql_t41minmax ok 19 - creating minmax table for type tinyint unsigned ok 20 ok 21 ok 22 - binding minimal tinyint unsigned, mode=strict ok 23 - inserting min data for type tinyint unsigned, mode=strict ok 24 ok 25 - retrieved minimal value for tinyint unsigned, mode=strict ok 26 - binding maximal tinyint unsigned, mode=strict ok 27 - inserting max data for type tinyint unsigned, mode=strict ok 28 ok 29 - retrieved maximal value for tinyint unsigned, mode=strict ok 30 - binding less than minimal tinyint unsigned, mode=strict ok 31 - Error, you stored -1 into tinyint unsigned, mode=strict # $VAR1 = [ # [ # 1, # 0 # ], # [ # 2, # 255 # ] # ]; # $VAR1 = [ # [ # 'id', # 'int(11)', # 'NO', # 'PRI', # undef, # 'auto_increment' # ], # [ # 'val', # 'tinyint(3) unsigned', # 'YES', # '', # undef, # '' # ] # ]; # ok 32 - binding more than maximal tinyint unsigned, mode=strict ok 33 - Error, you stored 256 into tinyint unsigned, mode=strict # $VAR1 = [ # [ # 1, # 0 # ], # [ # 2, # 255 # ] # ]; # $VAR1 = [ # [ # 'id', # 'int(11)', # 'NO', # 'PRI', # undef, # 'auto_increment' # ], # [ # 'val', # 'tinyint(3) unsigned', # 'YES', # '', # undef, # '' # ] # ]; # ok 34 - removing dbd_mysql_t41minmax ok 35 - creating minmax table for type smallint signed ok 36 ok 37 ok 38 - binding minimal smallint signed, mode=strict ok 39 - inserting min data for type smallint signed, mode=strict ok 40 ok 41 - retrieved minimal value for smallint signed, mode=strict ok 42 - binding maximal smallint signed, mode=strict ok 43 - inserting max data for type smallint signed, mode=strict ok 44 ok 45 - retrieved maximal value for smallint signed, mode=strict ok 46 - binding less than minimal smallint signed, mode=strict ok 47 - Error, you stored -32769 into smallint signed, mode=strict # $VAR1 = [ # [ # 1, # -32768 # ], # [ # 2, # 32767 # ] # ]; # $VAR1 = [ # [ # 'id', # 'int(11)', # 'NO', # 'PRI', # undef, # 'auto_increment' # ], # [ # 'val', # 'smallint(6)', # 'YES', # '', # undef, # '' # ] # ]; # ok 48 - binding more than maximal smallint signed, mode=strict ok 49 - Error, you stored 32768 into smallint signed, mode=strict # $VAR1 = [ # [ # 1, # -32768 # ], # [ # 2, # 32767 # ] # ]; # $VAR1 = [ # [ # 'id', # 'int(11)', # 'NO', # 'PRI', # undef, # 'auto_increment' # ], # [ # 'val', # 'smallint(6)', # 'YES', # '', # undef, # '' # ] # ]; # ok 50 - removing dbd_mysql_t41minmax ok 51 - creating minmax table for type smallint unsigned ok 52 ok 53 ok 54 - binding minimal smallint unsigned, mode=strict ok 55 - inserting min data for type smallint unsigned, mode=strict ok 56 ok 57 - retrieved minimal value for smallint unsigned, mode=strict ok 58 - binding maximal smallint unsigned, mode=strict ok 59 - inserting max data for type smallint unsigned, mode=strict ok 60 ok 61 - retrieved maximal value for smallint unsigned, mode=strict ok 62 - binding less than minimal smallint unsigned, mode=strict ok 63 - Error, you stored -1 into smallint unsigned, mode=strict # $VAR1 = [ # [ # 1, # 0 # ], # [ # 2, # 65535 # ] # ]; # $VAR1 = [ # [ # 'id', # 'int(11)', # 'NO', # 'PRI', # undef, # 'auto_increment' # ], # [ # 'val', # 'smallint(5) unsigned', # 'YES', # '', # undef, # '' # ] # ]; # ok 64 - binding more than maximal smallint unsigned, mode=strict ok 65 - Error, you stored 65536 into smallint unsigned, mode=strict # $VAR1 = [ # [ # 1, # 0 # ], # [ # 2, # 65535 # ] # ]; # $VAR1 = [ # [ # 'id', # 'int(11)', # 'NO', # 'PRI', # undef, # 'auto_increment' # ], # [ # 'val', # 'smallint(5) unsigned', # 'YES', # '', # undef, # '' # ] # ]; # ok 66 - removing dbd_mysql_t41minmax ok 67 - creating minmax table for type int signed ok 68 ok 69 ok 70 - binding minimal int signed, mode=strict ok 71 - inserting min data for type int signed, mode=strict ok 72 ok 73 - retrieved minimal value for int signed, mode=strict ok 74 - binding maximal int signed, mode=strict ok 75 - inserting max data for type int signed, mode=strict ok 76 ok 77 - retrieved maximal value for int signed, mode=strict ok 78 - binding less than minimal int signed, mode=strict ok 79 - Error, you stored -2147483649 into int signed, mode=strict # $VAR1 = [ # [ # 1, # '-2147483648' # ], # [ # 2, # 2147483647 # ] # ]; # $VAR1 = [ # [ # 'id', # 'int(11)', # 'NO', # 'PRI', # undef, # 'auto_increment' # ], # [ # 'val', # 'int(11)', # 'YES', # '', # undef, # '' # ] # ]; # ok 80 - binding more than maximal int signed, mode=strict ok 81 - Error, you stored 2147483648 into int signed, mode=strict # $VAR1 = [ # [ # 1, # '-2147483648' # ], # [ # 2, # 2147483647 # ] # ]; # $VAR1 = [ # [ # 'id', # 'int(11)', # 'NO', # 'PRI', # undef, # 'auto_increment' # ], # [ # 'val', # 'int(11)', # 'YES', # '', # undef, # '' # ] # ]; # ok 82 - removing dbd_mysql_t41minmax ok 83 - creating minmax table for type int unsigned ok 84 ok 85 ok 86 - binding minimal int unsigned, mode=strict ok 87 - inserting min data for type int unsigned, mode=strict ok 88 ok 89 - retrieved minimal value for int unsigned, mode=strict ok 90 - binding maximal int unsigned, mode=strict ok 91 - inserting max data for type int unsigned, mode=strict ok 92 ok 93 - retrieved maximal value for int unsigned, mode=strict ok 94 - binding less than minimal int unsigned, mode=strict ok 95 - Error, you stored -1 into int unsigned, mode=strict # $VAR1 = [ # [ # 1, # 0 # ], # [ # 2, # 4294967295 # ] # ]; # $VAR1 = [ # [ # 'id', # 'int(11)', # 'NO', # 'PRI', # undef, # 'auto_increment' # ], # [ # 'val', # 'int(10) unsigned', # 'YES', # '', # undef, # '' # ] # ]; # ok 96 - binding more than maximal int unsigned, mode=strict ok 97 - Error, you stored 4294967296 into int unsigned, mode=strict # $VAR1 = [ # [ # 1, # 0 # ], # [ # 2, # 4294967295 # ] # ]; # $VAR1 = [ # [ # 'id', # 'int(11)', # 'NO', # 'PRI', # undef, # 'auto_increment' # ], # [ # 'val', # 'int(10) unsigned', # 'YES', # '', # undef, # '' # ] # ]; # ok 98 - removing dbd_mysql_t41minmax ok 99 - creating minmax table for type bigint signed ok 100 ok 101 ok 102 - binding minimal bigint signed, mode=strict ok 103 - inserting min data for type bigint signed, mode=strict ok 104 ok 105 - retrieved minimal value for bigint signed, mode=strict ok 106 - binding maximal bigint signed, mode=strict ok 107 - inserting max data for type bigint signed, mode=strict ok 108 ok 109 - retrieved maximal value for bigint signed, mode=strict ok 110 - binding less than minimal bigint signed, mode=strict ok 111 - Error, you stored -9223372036854775809 into bigint signed, mode=strict # $VAR1 = [ # [ # 1, # '-9223372036854775808' # ], # [ # 2, # '9223372036854775807' # ] # ]; # $VAR1 = [ # [ # 'id', # 'int(11)', # 'NO', # 'PRI', # undef, # 'auto_increment' # ], # [ # 'val', # 'bigint(20)', # 'YES', # '', # undef, # '' # ] # ]; # ok 112 - binding more than maximal bigint signed, mode=strict ok 113 - Error, you stored 9223372036854775808 into bigint signed, mode=strict # $VAR1 = [ # [ # 1, # '-9223372036854775808' # ], # [ # 2, # '9223372036854775807' # ] # ]; # $VAR1 = [ # [ # 'id', # 'int(11)', # 'NO', # 'PRI', # undef, # 'auto_increment' # ], # [ # 'val', # 'bigint(20)', # 'YES', # '', # undef, # '' # ] # ]; # ok 114 - removing dbd_mysql_t41minmax ok 115 - creating minmax table for type bigint unsigned ok 116 ok 117 ok 118 - binding minimal bigint unsigned, mode=strict ok 119 - inserting min data for type bigint unsigned, mode=strict ok 120 ok 121 - retrieved minimal value for bigint unsigned, mode=strict ok 122 - binding maximal bigint unsigned, mode=strict ok 123 - inserting max data for type bigint unsigned, mode=strict ok 124 ok 125 - retrieved maximal value for bigint unsigned, mode=strict ok 126 - binding less than minimal bigint unsigned, mode=strict ok 127 - Error, you stored -1 into bigint unsigned, mode=strict # $VAR1 = [ # [ # 1, # 0 # ], # [ # 2, # '18446744073709551615' # ] # ]; # $VAR1 = [ # [ # 'id', # 'int(11)', # 'NO', # 'PRI', # undef, # 'auto_increment' # ], # [ # 'val', # 'bigint(20) unsigned', # 'YES', # '', # undef, # '' # ] # ]; # ok 128 - binding more than maximal bigint unsigned, mode=strict ok 129 - Error, you stored 18446744073709551616 into bigint unsigned, mode=strict # $VAR1 = [ # [ # 1, # 0 # ], # [ # 2, # '18446744073709551615' # ] # ]; # $VAR1 = [ # [ # 'id', # 'int(11)', # 'NO', # 'PRI', # undef, # 'auto_increment' # ], # [ # 'val', # 'bigint(20) unsigned', # 'YES', # '', # undef, # '' # ] # ]; # ok 130 - Leave strict SQL mode. ok 131 - removing dbd_mysql_t41minmax ok 132 - creating minmax table for type tinyint signed ok 133 ok 134 ok 135 - binding minimal tinyint signed, mode=nostrict ok 136 - inserting min data for type tinyint signed, mode=nostrict ok 137 ok 138 - retrieved minimal value for tinyint signed, mode=nostrict ok 139 - binding maximal tinyint signed, mode=nostrict ok 140 - inserting max data for type tinyint signed, mode=nostrict ok 141 ok 142 - retrieved maximal value for tinyint signed, mode=nostrict ok 143 - binding less than minimal tinyint signed, mode=nostrict ok 144 ok 145 ok 146 - retrieved minimal value for type tinyint signed, mode=nostrict ok 147 - binding more than maximal tinyint signed, mode=nostrict ok 148 ok 149 ok 150 - retrieved maximal value for type tinyint signed, mode=nostrict ok 151 - removing dbd_mysql_t41minmax ok 152 - creating minmax table for type tinyint unsigned ok 153 ok 154 ok 155 - binding minimal tinyint unsigned, mode=nostrict ok 156 - inserting min data for type tinyint unsigned, mode=nostrict ok 157 ok 158 - retrieved minimal value for tinyint unsigned, mode=nostrict ok 159 - binding maximal tinyint unsigned, mode=nostrict ok 160 - inserting max data for type tinyint unsigned, mode=nostrict ok 161 ok 162 - retrieved maximal value for tinyint unsigned, mode=nostrict ok 163 - binding less than minimal tinyint unsigned, mode=nostrict ok 164 ok 165 ok 166 - retrieved minimal value for type tinyint unsigned, mode=nostrict ok 167 - binding more than maximal tinyint unsigned, mode=nostrict ok 168 ok 169 ok 170 - retrieved maximal value for type tinyint unsigned, mode=nostrict ok 171 - removing dbd_mysql_t41minmax ok 172 - creating minmax table for type smallint signed ok 173 ok 174 ok 175 - binding minimal smallint signed, mode=nostrict ok 176 - inserting min data for type smallint signed, mode=nostrict ok 177 ok 178 - retrieved minimal value for smallint signed, mode=nostrict ok 179 - binding maximal smallint signed, mode=nostrict ok 180 - inserting max data for type smallint signed, mode=nostrict ok 181 ok 182 - retrieved maximal value for smallint signed, mode=nostrict ok 183 - binding less than minimal smallint signed, mode=nostrict ok 184 ok 185 ok 186 - retrieved minimal value for type smallint signed, mode=nostrict ok 187 - binding more than maximal smallint signed, mode=nostrict ok 188 ok 189 ok 190 - retrieved maximal value for type smallint signed, mode=nostrict ok 191 - removing dbd_mysql_t41minmax ok 192 - creating minmax table for type smallint unsigned ok 193 ok 194 ok 195 - binding minimal smallint unsigned, mode=nostrict ok 196 - inserting min data for type smallint unsigned, mode=nostrict ok 197 ok 198 - retrieved minimal value for smallint unsigned, mode=nostrict ok 199 - binding maximal smallint unsigned, mode=nostrict ok 200 - inserting max data for type smallint unsigned, mode=nostrict ok 201 ok 202 - retrieved maximal value for smallint unsigned, mode=nostrict ok 203 - binding less than minimal smallint unsigned, mode=nostrict ok 204 ok 205 ok 206 - retrieved minimal value for type smallint unsigned, mode=nostrict ok 207 - binding more than maximal smallint unsigned, mode=nostrict ok 208 ok 209 ok 210 - retrieved maximal value for type smallint unsigned, mode=nostrict ok 211 - removing dbd_mysql_t41minmax ok 212 - creating minmax table for type int signed ok 213 ok 214 ok 215 - binding minimal int signed, mode=nostrict ok 216 - inserting min data for type int signed, mode=nostrict ok 217 ok 218 - retrieved minimal value for int signed, mode=nostrict ok 219 - binding maximal int signed, mode=nostrict ok 220 - inserting max data for type int signed, mode=nostrict ok 221 ok 222 - retrieved maximal value for int signed, mode=nostrict ok 223 - binding less than minimal int signed, mode=nostrict ok 224 ok 225 ok 226 - retrieved minimal value for type int signed, mode=nostrict ok 227 - binding more than maximal int signed, mode=nostrict ok 228 ok 229 ok 230 - retrieved maximal value for type int signed, mode=nostrict ok 231 - removing dbd_mysql_t41minmax ok 232 - creating minmax table for type int unsigned ok 233 ok 234 ok 235 - binding minimal int unsigned, mode=nostrict ok 236 - inserting min data for type int unsigned, mode=nostrict ok 237 ok 238 - retrieved minimal value for int unsigned, mode=nostrict ok 239 - binding maximal int unsigned, mode=nostrict ok 240 - inserting max data for type int unsigned, mode=nostrict ok 241 ok 242 - retrieved maximal value for int unsigned, mode=nostrict ok 243 - binding less than minimal int unsigned, mode=nostrict ok 244 ok 245 ok 246 - retrieved minimal value for type int unsigned, mode=nostrict ok 247 - binding more than maximal int unsigned, mode=nostrict ok 248 ok 249 ok 250 - retrieved maximal value for type int unsigned, mode=nostrict ok 251 - removing dbd_mysql_t41minmax ok 252 - creating minmax table for type bigint signed ok 253 ok 254 ok 255 - binding minimal bigint signed, mode=nostrict ok 256 - inserting min data for type bigint signed, mode=nostrict ok 257 ok 258 - retrieved minimal value for bigint signed, mode=nostrict ok 259 - binding maximal bigint signed, mode=nostrict ok 260 - inserting max data for type bigint signed, mode=nostrict ok 261 ok 262 - retrieved maximal value for bigint signed, mode=nostrict ok 263 - binding less than minimal bigint signed, mode=nostrict ok 264 ok 265 ok 266 - retrieved minimal value for type bigint signed, mode=nostrict ok 267 - binding more than maximal bigint signed, mode=nostrict ok 268 ok 269 ok 270 - retrieved maximal value for type bigint signed, mode=nostrict ok 271 - removing dbd_mysql_t41minmax ok 272 - creating minmax table for type bigint unsigned ok 273 ok 274 ok 275 - binding minimal bigint unsigned, mode=nostrict ok 276 - inserting min data for type bigint unsigned, mode=nostrict ok 277 ok 278 - retrieved minimal value for bigint unsigned, mode=nostrict ok 279 - binding maximal bigint unsigned, mode=nostrict ok 280 - inserting max data for type bigint unsigned, mode=nostrict ok 281 ok 282 - retrieved maximal value for bigint unsigned, mode=nostrict ok 283 - binding less than minimal bigint unsigned, mode=nostrict ok 284 ok 285 ok 286 - retrieved minimal value for type bigint unsigned, mode=nostrict ok 287 - binding more than maximal bigint unsigned, mode=nostrict ok 288 ok 289 ok 290 - retrieved maximal value for type bigint unsigned, mode=nostrict ok 291 ok 292 ok 293 - Enter strict SQL mode. ok 294 - removing dbd_mysql_t41minmax ok 295 - creating minmax table for type tinyint signed ok 296 ok 297 ok 298 - binding minimal tinyint signed, mode=strict ok 299 - inserting min data for type tinyint signed, mode=strict ok 300 ok 301 - retrieved minimal value for tinyint signed, mode=strict ok 302 - binding maximal tinyint signed, mode=strict ok 303 - inserting max data for type tinyint signed, mode=strict ok 304 ok 305 - retrieved maximal value for tinyint signed, mode=strict ok 306 - binding less than minimal tinyint signed, mode=strict ok 307 - Error, you stored -129 into tinyint signed, mode=strict # $VAR1 = [ # [ # 1, # -128 # ], # [ # 2, # 127 # ] # ]; # $VAR1 = [ # [ # 'id', # 'int(11)', # 'NO', # 'PRI', # undef, # 'auto_increment' # ], # [ # 'val', # 'tinyint(4)', # 'YES', # '', # undef, # '' # ] # ]; # ok 308 - binding more than maximal tinyint signed, mode=strict ok 309 - Error, you stored 128 into tinyint signed, mode=strict # $VAR1 = [ # [ # 1, # -128 # ], # [ # 2, # 127 # ] # ]; # $VAR1 = [ # [ # 'id', # 'int(11)', # 'NO', # 'PRI', # undef, # 'auto_increment' # ], # [ # 'val', # 'tinyint(4)', # 'YES', # '', # undef, # '' # ] # ]; # ok 310 - removing dbd_mysql_t41minmax ok 311 - creating minmax table for type tinyint unsigned ok 312 ok 313 ok 314 - binding minimal tinyint unsigned, mode=strict ok 315 - inserting min data for type tinyint unsigned, mode=strict ok 316 ok 317 - retrieved minimal value for tinyint unsigned, mode=strict ok 318 - binding maximal tinyint unsigned, mode=strict ok 319 - inserting max data for type tinyint unsigned, mode=strict ok 320 ok 321 - retrieved maximal value for tinyint unsigned, mode=strict ok 322 - binding less than minimal tinyint unsigned, mode=strict ok 323 - Error, you stored -1 into tinyint unsigned, mode=strict # $VAR1 = [ # [ # 1, # 0 # ], # [ # 2, # 255 # ] # ]; # $VAR1 = [ # [ # 'id', # 'int(11)', # 'NO', # 'PRI', # undef, # 'auto_increment' # ], # [ # 'val', # 'tinyint(3) unsigned', # 'YES', # '', # undef, # '' # ] # ]; # ok 324 - binding more than maximal tinyint unsigned, mode=strict ok 325 - Error, you stored 256 into tinyint unsigned, mode=strict # $VAR1 = [ # [ # 1, # 0 # ], # [ # 2, # 255 # ] # ]; # $VAR1 = [ # [ # 'id', # 'int(11)', # 'NO', # 'PRI', # undef, # 'auto_increment' # ], # [ # 'val', # 'tinyint(3) unsigned', # 'YES', # '', # undef, # '' # ] # ]; # ok 326 - removing dbd_mysql_t41minmax ok 327 - creating minmax table for type smallint signed ok 328 ok 329 ok 330 - binding minimal smallint signed, mode=strict ok 331 - inserting min data for type smallint signed, mode=strict ok 332 ok 333 - retrieved minimal value for smallint signed, mode=strict ok 334 - binding maximal smallint signed, mode=strict ok 335 - inserting max data for type smallint signed, mode=strict ok 336 ok 337 - retrieved maximal value for smallint signed, mode=strict ok 338 - binding less than minimal smallint signed, mode=strict ok 339 - Error, you stored -32769 into smallint signed, mode=strict # $VAR1 = [ # [ # 1, # -32768 # ], # [ # 2, # 32767 # ] # ]; # $VAR1 = [ # [ # 'id', # 'int(11)', # 'NO', # 'PRI', # undef, # 'auto_increment' # ], # [ # 'val', # 'smallint(6)', # 'YES', # '', # undef, # '' # ] # ]; # ok 340 - binding more than maximal smallint signed, mode=strict ok 341 - Error, you stored 32768 into smallint signed, mode=strict # $VAR1 = [ # [ # 1, # -32768 # ], # [ # 2, # 32767 # ] # ]; # $VAR1 = [ # [ # 'id', # 'int(11)', # 'NO', # 'PRI', # undef, # 'auto_increment' # ], # [ # 'val', # 'smallint(6)', # 'YES', # '', # undef, # '' # ] # ]; # ok 342 - removing dbd_mysql_t41minmax ok 343 - creating minmax table for type smallint unsigned ok 344 ok 345 ok 346 - binding minimal smallint unsigned, mode=strict ok 347 - inserting min data for type smallint unsigned, mode=strict ok 348 ok 349 - retrieved minimal value for smallint unsigned, mode=strict ok 350 - binding maximal smallint unsigned, mode=strict ok 351 - inserting max data for type smallint unsigned, mode=strict ok 352 ok 353 - retrieved maximal value for smallint unsigned, mode=strict ok 354 - binding less than minimal smallint unsigned, mode=strict ok 355 - Error, you stored -1 into smallint unsigned, mode=strict # $VAR1 = [ # [ # 1, # 0 # ], # [ # 2, # 65535 # ] # ]; # $VAR1 = [ # [ # 'id', # 'int(11)', # 'NO', # 'PRI', # undef, # 'auto_increment' # ], # [ # 'val', # 'smallint(5) unsigned', # 'YES', # '', # undef, # '' # ] # ]; # ok 356 - binding more than maximal smallint unsigned, mode=strict ok 357 - Error, you stored 65536 into smallint unsigned, mode=strict # $VAR1 = [ # [ # 1, # 0 # ], # [ # 2, # 65535 # ] # ]; # $VAR1 = [ # [ # 'id', # 'int(11)', # 'NO', # 'PRI', # undef, # 'auto_increment' # ], # [ # 'val', # 'smallint(5) unsigned', # 'YES', # '', # undef, # '' # ] # ]; # ok 358 - removing dbd_mysql_t41minmax ok 359 - creating minmax table for type int signed ok 360 ok 361 ok 362 - binding minimal int signed, mode=strict ok 363 - inserting min data for type int signed, mode=strict ok 364 ok 365 - retrieved minimal value for int signed, mode=strict ok 366 - binding maximal int signed, mode=strict ok 367 - inserting max data for type int signed, mode=strict ok 368 ok 369 - retrieved maximal value for int signed, mode=strict ok 370 - binding less than minimal int signed, mode=strict ok 371 - Error, you stored -2147483649 into int signed, mode=strict # $VAR1 = [ # [ # 1, # '-2147483648' # ], # [ # 2, # 2147483647 # ] # ]; # $VAR1 = [ # [ # 'id', # 'int(11)', # 'NO', # 'PRI', # undef, # 'auto_increment' # ], # [ # 'val', # 'int(11)', # 'YES', # '', # undef, # '' # ] # ]; # ok 372 - binding more than maximal int signed, mode=strict ok 373 - Error, you stored 2147483648 into int signed, mode=strict # $VAR1 = [ # [ # 1, # '-2147483648' # ], # [ # 2, # 2147483647 # ] # ]; # $VAR1 = [ # [ # 'id', # 'int(11)', # 'NO', # 'PRI', # undef, # 'auto_increment' # ], # [ # 'val', # 'int(11)', # 'YES', # '', # undef, # '' # ] # ]; # ok 374 - removing dbd_mysql_t41minmax ok 375 - creating minmax table for type int unsigned ok 376 ok 377 ok 378 - binding minimal int unsigned, mode=strict ok 379 - inserting min data for type int unsigned, mode=strict ok 380 ok 381 - retrieved minimal value for int unsigned, mode=strict ok 382 - binding maximal int unsigned, mode=strict ok 383 - inserting max data for type int unsigned, mode=strict ok 384 ok 385 - retrieved maximal value for int unsigned, mode=strict ok 386 - binding less than minimal int unsigned, mode=strict ok 387 - Error, you stored -1 into int unsigned, mode=strict # $VAR1 = [ # [ # 1, # 0 # ], # [ # 2, # 4294967295 # ] # ]; # $VAR1 = [ # [ # 'id', # 'int(11)', # 'NO', # 'PRI', # undef, # 'auto_increment' # ], # [ # 'val', # 'int(10) unsigned', # 'YES', # '', # undef, # '' # ] # ]; # ok 388 - binding more than maximal int unsigned, mode=strict ok 389 - Error, you stored 4294967296 into int unsigned, mode=strict # $VAR1 = [ # [ # 1, # 0 # ], # [ # 2, # 4294967295 # ] # ]; # $VAR1 = [ # [ # 'id', # 'int(11)', # 'NO', # 'PRI', # undef, # 'auto_increment' # ], # [ # 'val', # 'int(10) unsigned', # 'YES', # '', # undef, # '' # ] # ]; # ok 390 - removing dbd_mysql_t41minmax ok 391 - creating minmax table for type bigint signed ok 392 ok 393 ok 394 - binding minimal bigint signed, mode=strict ok 395 - inserting min data for type bigint signed, mode=strict ok 396 ok 397 - retrieved minimal value for bigint signed, mode=strict ok 398 - binding maximal bigint signed, mode=strict ok 399 - inserting max data for type bigint signed, mode=strict ok 400 ok 401 - retrieved maximal value for bigint signed, mode=strict ok 402 - binding less than minimal bigint signed, mode=strict ok 403 - Error, you stored -9223372036854775809 into bigint signed, mode=strict # $VAR1 = [ # [ # 1, # '-9223372036854775808' # ], # [ # 2, # '9223372036854775807' # ] # ]; # $VAR1 = [ # [ # 'id', # 'int(11)', # 'NO', # 'PRI', # undef, # 'auto_increment' # ], # [ # 'val', # 'bigint(20)', # 'YES', # '', # undef, # '' # ] # ]; # ok 404 - binding more than maximal bigint signed, mode=strict ok 405 - Error, you stored 9223372036854775808 into bigint signed, mode=strict # $VAR1 = [ # [ # 1, # '-9223372036854775808' # ], # [ # 2, # '9223372036854775807' # ] # ]; # $VAR1 = [ # [ # 'id', # 'int(11)', # 'NO', # 'PRI', # undef, # 'auto_increment' # ], # [ # 'val', # 'bigint(20)', # 'YES', # '', # undef, # '' # ] # ]; # ok 406 - removing dbd_mysql_t41minmax ok 407 - creating minmax table for type bigint unsigned ok 408 ok 409 ok 410 - binding minimal bigint unsigned, mode=strict ok 411 - inserting min data for type bigint unsigned, mode=strict ok 412 ok 413 - retrieved minimal value for bigint unsigned, mode=strict ok 414 - binding maximal bigint unsigned, mode=strict ok 415 - inserting max data for type bigint unsigned, mode=strict ok 416 ok 417 - retrieved maximal value for bigint unsigned, mode=strict ok 418 - binding less than minimal bigint unsigned, mode=strict ok 419 - Error, you stored -1 into bigint unsigned, mode=strict # $VAR1 = [ # [ # 1, # 0 # ], # [ # 2, # '18446744073709551615' # ] # ]; # $VAR1 = [ # [ # 'id', # 'int(11)', # 'NO', # 'PRI', # undef, # 'auto_increment' # ], # [ # 'val', # 'bigint(20) unsigned', # 'YES', # '', # undef, # '' # ] # ]; # ok 420 - binding more than maximal bigint unsigned, mode=strict ok 421 - Error, you stored 18446744073709551616 into bigint unsigned, mode=strict # $VAR1 = [ # [ # 1, # 0 # ], # [ # 2, # '18446744073709551615' # ] # ]; # $VAR1 = [ # [ # 'id', # 'int(11)', # 'NO', # 'PRI', # undef, # 'auto_increment' # ], # [ # 'val', # 'bigint(20) unsigned', # 'YES', # '', # undef, # '' # ] # ]; # ok 422 - Leave strict SQL mode. ok 423 - removing dbd_mysql_t41minmax ok 424 - creating minmax table for type tinyint signed ok 425 ok 426 ok 427 - binding minimal tinyint signed, mode=nostrict ok 428 - inserting min data for type tinyint signed, mode=nostrict ok 429 ok 430 - retrieved minimal value for tinyint signed, mode=nostrict ok 431 - binding maximal tinyint signed, mode=nostrict ok 432 - inserting max data for type tinyint signed, mode=nostrict ok 433 ok 434 - retrieved maximal value for tinyint signed, mode=nostrict ok 435 - binding less than minimal tinyint signed, mode=nostrict ok 436 ok 437 ok 438 - retrieved minimal value for type tinyint signed, mode=nostrict ok 439 - binding more than maximal tinyint signed, mode=nostrict ok 440 ok 441 ok 442 - retrieved maximal value for type tinyint signed, mode=nostrict ok 443 - removing dbd_mysql_t41minmax ok 444 - creating minmax table for type tinyint unsigned ok 445 ok 446 ok 447 - binding minimal tinyint unsigned, mode=nostrict ok 448 - inserting min data for type tinyint unsigned, mode=nostrict ok 449 ok 450 - retrieved minimal value for tinyint unsigned, mode=nostrict ok 451 - binding maximal tinyint unsigned, mode=nostrict ok 452 - inserting max data for type tinyint unsigned, mode=nostrict ok 453 ok 454 - retrieved maximal value for tinyint unsigned, mode=nostrict ok 455 - binding less than minimal tinyint unsigned, mode=nostrict ok 456 ok 457 ok 458 - retrieved minimal value for type tinyint unsigned, mode=nostrict ok 459 - binding more than maximal tinyint unsigned, mode=nostrict ok 460 ok 461 ok 462 - retrieved maximal value for type tinyint unsigned, mode=nostrict ok 463 - removing dbd_mysql_t41minmax ok 464 - creating minmax table for type smallint signed ok 465 ok 466 ok 467 - binding minimal smallint signed, mode=nostrict ok 468 - inserting min data for type smallint signed, mode=nostrict ok 469 ok 470 - retrieved minimal value for smallint signed, mode=nostrict ok 471 - binding maximal smallint signed, mode=nostrict ok 472 - inserting max data for type smallint signed, mode=nostrict ok 473 ok 474 - retrieved maximal value for smallint signed, mode=nostrict ok 475 - binding less than minimal smallint signed, mode=nostrict ok 476 ok 477 ok 478 - retrieved minimal value for type smallint signed, mode=nostrict ok 479 - binding more than maximal smallint signed, mode=nostrict ok 480 ok 481 ok 482 - retrieved maximal value for type smallint signed, mode=nostrict ok 483 - removing dbd_mysql_t41minmax ok 484 - creating minmax table for type smallint unsigned ok 485 ok 486 ok 487 - binding minimal smallint unsigned, mode=nostrict ok 488 - inserting min data for type smallint unsigned, mode=nostrict ok 489 ok 490 - retrieved minimal value for smallint unsigned, mode=nostrict ok 491 - binding maximal smallint unsigned, mode=nostrict ok 492 - inserting max data for type smallint unsigned, mode=nostrict ok 493 ok 494 - retrieved maximal value for smallint unsigned, mode=nostrict ok 495 - binding less than minimal smallint unsigned, mode=nostrict ok 496 ok 497 ok 498 - retrieved minimal value for type smallint unsigned, mode=nostrict ok 499 - binding more than maximal smallint unsigned, mode=nostrict ok 500 ok 501 ok 502 - retrieved maximal value for type smallint unsigned, mode=nostrict ok 503 - removing dbd_mysql_t41minmax ok 504 - creating minmax table for type int signed ok 505 ok 506 ok 507 - binding minimal int signed, mode=nostrict ok 508 - inserting min data for type int signed, mode=nostrict ok 509 ok 510 - retrieved minimal value for int signed, mode=nostrict ok 511 - binding maximal int signed, mode=nostrict ok 512 - inserting max data for type int signed, mode=nostrict ok 513 ok 514 - retrieved maximal value for int signed, mode=nostrict ok 515 - binding less than minimal int signed, mode=nostrict ok 516 ok 517 ok 518 - retrieved minimal value for type int signed, mode=nostrict ok 519 - binding more than maximal int signed, mode=nostrict ok 520 ok 521 ok 522 - retrieved maximal value for type int signed, mode=nostrict ok 523 - removing dbd_mysql_t41minmax ok 524 - creating minmax table for type int unsigned ok 525 ok 526 ok 527 - binding minimal int unsigned, mode=nostrict ok 528 - inserting min data for type int unsigned, mode=nostrict ok 529 ok 530 - retrieved minimal value for int unsigned, mode=nostrict ok 531 - binding maximal int unsigned, mode=nostrict ok 532 - inserting max data for type int unsigned, mode=nostrict ok 533 ok 534 - retrieved maximal value for int unsigned, mode=nostrict ok 535 - binding less than minimal int unsigned, mode=nostrict ok 536 ok 537 ok 538 - retrieved minimal value for type int unsigned, mode=nostrict ok 539 - binding more than maximal int unsigned, mode=nostrict ok 540 ok 541 ok 542 - retrieved maximal value for type int unsigned, mode=nostrict ok 543 - removing dbd_mysql_t41minmax ok 544 - creating minmax table for type bigint signed ok 545 ok 546 ok 547 - binding minimal bigint signed, mode=nostrict ok 548 - inserting min data for type bigint signed, mode=nostrict ok 549 ok 550 - retrieved minimal value for bigint signed, mode=nostrict ok 551 - binding maximal bigint signed, mode=nostrict ok 552 - inserting max data for type bigint signed, mode=nostrict ok 553 ok 554 - retrieved maximal value for bigint signed, mode=nostrict ok 555 - binding less than minimal bigint signed, mode=nostrict ok 556 ok 557 ok 558 - retrieved minimal value for type bigint signed, mode=nostrict ok 559 - binding more than maximal bigint signed, mode=nostrict ok 560 ok 561 ok 562 - retrieved maximal value for type bigint signed, mode=nostrict ok 563 - removing dbd_mysql_t41minmax ok 564 - creating minmax table for type bigint unsigned ok 565 ok 566 ok 567 - binding minimal bigint unsigned, mode=nostrict ok 568 - inserting min data for type bigint unsigned, mode=nostrict ok 569 ok 570 - retrieved minimal value for bigint unsigned, mode=nostrict ok 571 - binding maximal bigint unsigned, mode=nostrict ok 572 - inserting max data for type bigint unsigned, mode=nostrict ok 573 ok 574 - retrieved maximal value for bigint unsigned, mode=nostrict ok 575 - binding less than minimal bigint unsigned, mode=nostrict ok 576 ok 577 ok 578 - retrieved minimal value for type bigint unsigned, mode=nostrict ok 579 - binding more than maximal bigint unsigned, mode=nostrict ok 580 ok 581 ok 582 - retrieved maximal value for type bigint unsigned, mode=nostrict ok 583 ok 584 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/43count_params.t ...................... 1..17 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 t/50chopblanks.t ........................ 1..72 ok 1 - drop table if exists dbd_mysql_t50chopblanks ok 2 - create table dbd_mysql_t50chopblanks ok 3 ok 4 ok 5 - insert into dbd_mysql_t50chopblanks values (1, '') ok 6 - select id, name from dbd_mysql_t50chopblanks 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 - insert into dbd_mysql_t50chopblanks values (2, ' ') ok 13 - select id, name from dbd_mysql_t50chopblanks 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 - insert into dbd_mysql_t50chopblanks values (3, ' a b c ') ok 20 - select id, name from dbd_mysql_t50chopblanks 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 - insert into dbd_mysql_t50chopblanks values (4, 'blah') ok 27 - select id, name from dbd_mysql_t50chopblanks where id = 4 ok 28 ok 29 - $name should not have blanks chopped ok 30 ok 31 ok 32 - should have blanks chopped ok 33 ok 34 ok 35 - drop dbd_mysql_t50chopblanks ok 36 ok 37 - drop table if exists dbd_mysql_t50chopblanks ok 38 - create table dbd_mysql_t50chopblanks ok 39 ok 40 ok 41 - insert into dbd_mysql_t50chopblanks values (1, '') ok 42 - select id, name from dbd_mysql_t50chopblanks where id = 1 ok 43 ok 44 - $name should not have blanks chopped ok 45 ok 46 ok 47 - should have blanks chopped ok 48 - insert into dbd_mysql_t50chopblanks values (2, ' ') ok 49 - select id, name from dbd_mysql_t50chopblanks where id = 2 ok 50 ok 51 - $name should not have blanks chopped ok 52 ok 53 ok 54 - should have blanks chopped ok 55 - insert into dbd_mysql_t50chopblanks values (3, ' a b c ') ok 56 - select id, name from dbd_mysql_t50chopblanks where id = 3 ok 57 ok 58 - $name should not have blanks chopped ok 59 ok 60 ok 61 - should have blanks chopped ok 62 - insert into dbd_mysql_t50chopblanks values (4, 'blah') ok 63 - select id, name from dbd_mysql_t50chopblanks where id = 4 ok 64 ok 65 - $name should not have blanks chopped ok 66 ok 67 ok 68 - should have blanks chopped ok 69 ok 70 ok 71 - drop dbd_mysql_t50chopblanks ok 72 ok t/50commit.t ............................ 1..22 ok 1 - drop table if exists dbd_mysql_t50commit ok 2 - create dbd_mysql_t50commit ok 3 - $dbh->{AutoCommit} not defined || ok 4 ok 5 ok 6 ok 7 - insert into dbd_mysql_t50commit (1, 'Jochen') ok 8 ok 9 - rollback ok 10 ok 11 - delete from dbd_mysql_t50commit 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 22 ok t/51bind_type_guessing.t ................ 1..26 ok 1 - drop table if exists dbd_mysql_t51bind_type_guessing 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 dbd_mysql_t51bind_type_guessing ok 17 - creating table w/ varchar ok 18 ok 19 ok 20 ok 21 ok 22 ok 23 ok 24 ok 25 ok 26 ok t/52comment.t ........................... 1..30 ok 1 - drop table if exists dbd_mysql_t52comment 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 dbd_mysql_t52comment ok 30 ok t/53comment.t ........................... ok 1 - creating table 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 ok 24 ok 25 ok 26 ok 27 1..27 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 dbd_mysql_t55utf8 (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 dbd_mysql_t55utf8 (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/55utf8mb4.t ........................... ok 1 ok 2 ok 3 - fetch row ok 4 - close sth ok 5 ok 6 1..6 ok t/56connattr.t .......................... skipped: performance schema not enabled t/60leaks.t ............................. skipped: Skip $ENV{EXTENDED_TESTING} is not set t/65segfault.t .......................... 1..5 ok 1 - Handle 1 Connected to database ok 2 - Handle 2 Connected to database ok 3 ok 4 ok 5 ok 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: 5182 # 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 192 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 # Overridden connection: 5182 ok 13 - the same connection: 5182 => 5182 # 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 - didn't get imp_data 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 dbd_mysql_t75supported ok 3 ok 4 ok 5 ok 6 - $row->[0] eq dbd_mysql_t75supported ok 7 ok 8 - drop dbd_mysql_t75supported ok 9 - creating dbd_mysql_t75supported again with 1 col ok 10 - alter dbd_mysql_t75supported ADD COLUMN ok 11 - drop dbd_mysql_t75supported ok 12 ok t/76multi_statement.t ................... 1..26 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 26 ok t/80procs.t ............................. skipped: Your test user does not have ALTER_ROUTINE privileges. t/81procs.t ............................. skipped: Your test user does not have ALTER_ROUTINE privileges. 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/87async.t ............................. 1..92 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 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 t/88async-multi-stmts.t ................. 1..8 ok 1 ok 2 ok 3 ok 4 ok 5 ok 6 ok 7 ok 8 ok t/89async-method-check.t ................ 1..223 ok 1 - Testing method 'can' on DBD::mysql::db during asynchronous operation ok 2 ok 3 - Testing method 'err' on DBD::mysql::db during asynchronous operation ok 4 ok 5 - Testing method 'errstr' on DBD::mysql::db during asynchronous operation ok 6 ok 7 - Testing method 'parse_trace_flag' on DBD::mysql::db during asynchronous operation ok 8 ok 9 - Testing method 'parse_trace_flags' on DBD::mysql::db during asynchronous operation ok 10 ok 11 - Testing method 'private_attribute_info' on DBD::mysql::db during asynchronous operation ok 12 ok 13 - Testing method 'trace' on DBD::mysql::db during asynchronous operation ok 14 ok 15 - Testing method 'trace_msg' on DBD::mysql::db during asynchronous operation ok 16 ok 17 - Testing method 'visit_child_handles' on DBD::mysql::db during asynchronous operation ok 18 ok 19 - Testing method 'clone' on DBD::mysql::db during asynchronous operation ok 20 ok 21 - Testing method 'mysql_async_ready' on DBD::mysql::db during asynchronous operation ok 22 ok 23 ok 24 - Testing method 'data_sources' on DBD::mysql::db during asynchronous operation ok 25 ok 26 - Testing method 'do' on DBD::mysql::db during asynchronous operation ok 27 ok 28 - Testing method 'last_insert_id' on DBD::mysql::db during asynchronous operation ok 29 ok 30 - Testing method 'selectrow_array' on DBD::mysql::db during asynchronous operation ok 31 ok 32 - Testing method 'selectrow_arrayref' on DBD::mysql::db during asynchronous operation ok 33 ok 34 - Testing method 'selectrow_hashref' on DBD::mysql::db during asynchronous operation ok 35 ok 36 - Testing method 'selectall_arrayref' on DBD::mysql::db during asynchronous operation ok 37 ok 38 - Testing method 'selectall_hashref' on DBD::mysql::db during asynchronous operation ok 39 ok 40 - Testing method 'selectcol_arrayref' on DBD::mysql::db during asynchronous operation ok 41 ok 42 - Testing method 'prepare' on DBD::mysql::db during asynchronous operation ok 43 ok 44 - Testing method 'prepare_cached' on DBD::mysql::db during asynchronous operation ok 45 ok 46 - Testing method 'commit' on DBD::mysql::db during asynchronous operation ok 47 ok 48 - Testing method 'rollback' on DBD::mysql::db during asynchronous operation ok 49 ok 50 - Testing method 'begin_work' on DBD::mysql::db during asynchronous operation ok 51 ok 52 - Testing method 'ping' on DBD::mysql::db during asynchronous operation ok 53 ok 54 - Testing method 'get_info' on DBD::mysql::db during asynchronous operation ok 55 ok 56 - Testing method 'table_info' on DBD::mysql::db during asynchronous operation ok 57 ok 58 - Testing method 'column_info' on DBD::mysql::db during asynchronous operation ok 59 ok 60 - Testing method 'primary_key_info' on DBD::mysql::db during asynchronous operation ok 61 ok 62 - Testing method 'primary_key' on DBD::mysql::db during asynchronous operation ok 63 ok 64 - Testing method 'foreign_key_info' on DBD::mysql::db during asynchronous operation ok 65 ok 66 - Testing method 'statistics_info' on DBD::mysql::db during asynchronous operation ok 67 ok 68 - Testing method 'tables' on DBD::mysql::db during asynchronous operation ok 69 ok 70 - Testing method 'type_info_all' on DBD::mysql::db during asynchronous operation ok 71 ok 72 - Testing method 'type_info' on DBD::mysql::db during asynchronous operation ok 73 ok 74 - Testing method 'quote' on DBD::mysql::db during asynchronous operation ok 75 ok 76 - Testing method 'quote_identifier' on DBD::mysql::db during asynchronous operation ok 77 ok 78 - Testing method 'can' on DBD::mysql::db during asynchronous operation ok 79 ok 80 - Testing method 'err' on DBD::mysql::db during asynchronous operation ok 81 ok 82 - Testing method 'errstr' on DBD::mysql::db during asynchronous operation ok 83 ok 84 - Testing method 'parse_trace_flag' on DBD::mysql::db during asynchronous operation ok 85 ok 86 - Testing method 'parse_trace_flags' on DBD::mysql::db during asynchronous operation ok 87 ok 88 - Testing method 'private_attribute_info' on DBD::mysql::db during asynchronous operation ok 89 ok 90 - Testing method 'trace' on DBD::mysql::db during asynchronous operation ok 91 ok 92 - Testing method 'trace_msg' on DBD::mysql::db during asynchronous operation ok 93 ok 94 - Testing method 'visit_child_handles' on DBD::mysql::db during asynchronous operation ok 95 ok 96 - Testing method 'fetchrow_arrayref' on DBD::mysql::st during asynchronous operation ok 97 - Testing DBD::mysql::st method 'fetchrow_arrayref' clears async state ok 98 ok 99 - Testing method 'fetch' on DBD::mysql::st during asynchronous operation ok 100 - Testing DBD::mysql::st method 'fetch' clears async state ok 101 ok 102 - Testing method 'fetchrow_array' on DBD::mysql::st during asynchronous operation ok 103 - Testing DBD::mysql::st method 'fetchrow_array' clears async state ok 104 ok 105 - Testing method 'fetchrow_hashref' on DBD::mysql::st during asynchronous operation ok 106 - Testing DBD::mysql::st method 'fetchrow_hashref' clears async state ok 107 ok 108 - Testing method 'fetchall_arrayref' on DBD::mysql::st during asynchronous operation ok 109 - Testing DBD::mysql::st method 'fetchall_arrayref' clears async state ok 110 ok 111 - Testing method 'fetchall_hashref' on DBD::mysql::st during asynchronous operation ok 112 - Testing DBD::mysql::st method 'fetchall_hashref' clears async state ok 113 ok 114 - Testing method 'finish' on DBD::mysql::st during asynchronous operation ok 115 - Testing DBD::mysql::st method 'finish' clears async state ok 116 ok 117 - Testing method 'rows' on DBD::mysql::st during asynchronous operation ok 118 - Testing DBD::mysql::st method 'rows' clears async state ok 119 ok 120 ok 121 ok 122 ok 123 ok 124 ok 125 ok 126 ok 127 ok 128 ok 129 ok 130 ok 131 ok 132 ok 133 ok 134 ok 135 ok 136 ok 137 ok 138 ok 139 ok 140 ok 141 ok 142 ok 143 ok 144 ok 145 ok 146 ok 147 ok 148 ok 149 ok 150 ok 151 ok 152 ok 153 ok 154 ok 155 ok 156 ok 157 ok 158 ok 159 ok 160 ok 161 ok 162 ok 163 ok 164 ok 165 ok 166 ok 167 ok 168 ok 169 ok 170 ok 171 ok 172 ok 173 ok 174 ok 175 ok 176 ok 177 ok 178 ok 179 ok 180 ok 181 ok 182 ok 183 ok 184 ok 185 ok 186 ok 187 ok 188 ok 189 ok 190 ok 191 ok 192 ok 193 ok 194 ok 195 ok 196 ok 197 ok 198 ok 199 ok 200 ok 201 ok 202 ok 203 ok 204 ok 205 ok 206 - Testing method 'bind_param' on DBD::mysql::st during asynchronous operation ok 207 ok 208 - Testing method 'bind_param_inout' on DBD::mysql::st during asynchronous operation ok 209 ok 210 - Testing method 'bind_param_array' on DBD::mysql::st during asynchronous operation ok 211 ok 212 - Testing method 'execute' on DBD::mysql::st during asynchronous operation ok 213 ok 214 - Testing method 'execute_array' on DBD::mysql::st during asynchronous operation ok 215 ok 216 - Testing method 'execute_for_fetch' on DBD::mysql::st during asynchronous operation ok 217 ok 218 - Testing method 'bind_col' on DBD::mysql::st during asynchronous operation ok 219 ok 220 - Testing method 'bind_columns' on DBD::mysql::st during asynchronous operation ok 221 ok 222 ok 223 ok t/90no-async.t .......................... skipped: Async support was built into this version of DBD::mysql t/91errcheck.t .......................... 1..1 ok 1 - error string should be set on a bad call ok t/99_bug_server_prepare_blob_null.t ..... 1..11 ok 1 ok 2 ok 3 ok 4 ok 5 ok 6 ok 7 ok 8 ok 9 ok 10 ok 11 ok t/manifest.t ............................ skipped: these tests are for release testing t/pod.t ................................. 1..4 ok 1 - POD test for blib/lib/Bundle/DBD/mysql.pm ok 2 - POD test for blib/lib/DBD/mysql.pm ok 3 - POD test for blib/lib/DBD/mysql/GetInfo.pm (no pod) ok 4 - POD test for blib/lib/DBD/mysql/INSTALL.pod ok t/rt25389-bin-case.t .................... 1..8 ok 1 - select name from `dbd-mysql-latin1-` ok 2 - select name from `dbd-mysql-latin1-` where name = 'AA' OR name = 'Aa' OR name = 'aa' OR name = 'aA' ok 3 - select name from `dbd-mysql-latin1-unique` ok 4 - select name from `dbd-mysql-latin1-unique` where name = 'AA' OR name = 'Aa' OR name = 'aa' OR name = 'aA' ok 5 - select name from `dbd-mysql-utf8-` ok 6 - select name from `dbd-mysql-utf8-` where name = 'AA' OR name = 'Aa' OR name = 'aa' OR name = 'aA' ok 7 - select name from `dbd-mysql-utf8-unique` ok 8 - select name from `dbd-mysql-utf8-unique` where name = 'AA' OR name = 'Aa' OR name = 'aa' OR name = 'aA' ok t/rt50304-column_info_parentheses.t ..... ok 1 - create temporary table dbd_mysql_rt50304_column_info ok 2 - problem_column values ok 3 - problem_column first value ok 4 - problem_column second value ok 5 - regular_column values ok 6 - regular_column first value ok 7 - regular_column second value ok 8 1..8 ok t/rt61849-bind-param-buffer-overflow.t .. 1..2 ok 1 - bind_param failed on incorrect numeric value ok 2 - perl interpretor did not crashed ok t/rt75353-innodb-lock-timeout.t ......... ok 1 - drop table if exists dbd_mysql_rt75353_innodb_lock_timeout ok 2 - create table dbd_mysql_rt75353_innodb_lock_timeout ok 3 - dbh1: acquire a row lock on table dbd_mysql_rt75353_innodb_lock_timeout ok 4 - dbh2: acquiring same lock as dbh1 on table dbd_mysql_rt75353_innodb_lock_timeout failed ok 5 - dbh2: error message for acquiring lock is 'Lock wait timeout exceeded' ok 6 - dbh2: error handler code ref was called ok 7 - drop table dbd_mysql_rt75353_innodb_lock_timeout 1..7 ok t/rt83494-quotes-comments.t ............. ok 1 - created statement hande ok 2 - executing ok 3 - values ok 4 - finish ok 5 - created statement hande ok 6 - executing ok 7 - values ok 8 - finish ok 9 - disconnecting from dbh 1..9 ok t/rt85919-fetch-lost-connection.t ....... # Connecting... ok 1 - set wait_timeout # Sleeping... ok 2 - prepare SQL ok 3 - received error 2006 (CR_SERVER_GONE_ERROR) 1..3 ok t/rt86153-reconnect-fail-memory.t ....... skipped: $ENV{EXTENDED_TESTING} is not set t/rt88006-bit-prepare.t ................. ok 1 - create table for prepare ok 2 ok 3 ok 4 ok 5 ok 6 ok 7 ok 8 ok 9 ok 10 - fetchrow_hashref for prepare ok 11 - id test contents ok 12 - flags has contents ok 13 ok 14 ok 15 ok 16 - fetchrow_hashref for prepare with more then 32 bits ok 17 - id test contents ok 18 - flags has contents ok 19 ok 20 ok 21 ok 22 - fetchrow_hashref for prepare with binary insert ok 23 - id test contents ok 24 - flags has contents ok 25 ok 26 ok 27 ok 28 - fetchrow_hashref for prepare with BIN() ok 29 - id test contents ok 30 - flags has contents ok 31 ok 32 ok 33 - fetchrow_hashref for prepare with BIN() and more then 32 bits ok 34 - id test contents ok 35 - flags has contents ok 36 ok 37 ok 38 - fetchrow_hashref for prepare with BIN() and with binary insert ok 39 - id test contents ok 40 - flags has contents ok 41 ok 42 ok 43 - create table for noprepare ok 44 ok 45 ok 46 ok 47 ok 48 ok 49 ok 50 ok 51 ok 52 - fetchrow_hashref for noprepare ok 53 - id test contents ok 54 - flags has contents ok 55 ok 56 ok 57 ok 58 - fetchrow_hashref for noprepare with more then 32 bits ok 59 - id test contents ok 60 - flags has contents ok 61 ok 62 ok 63 ok 64 - fetchrow_hashref for noprepare with binary insert ok 65 - id test contents ok 66 - flags has contents ok 67 ok 68 ok 69 ok 70 - fetchrow_hashref for noprepare with BIN() ok 71 - id test contents ok 72 - flags has contents ok 73 ok 74 ok 75 - fetchrow_hashref for noprepare with BIN() and more then 32 bits ok 76 - id test contents ok 77 - flags has contents ok 78 ok 79 ok 80 - fetchrow_hashref for noprepare with BIN() and with binary insert ok 81 - id test contents ok 82 - flags has contents ok 83 ok 84 1..84 ok t/rt91715.t ............................. 1..6 ok 1 ok 2 ok 3 - mysql_use_result set to 0 ok 4 ok 5 ok 6 - mysql_use_result set to 1 ok t/version.t ............................. ok 1 - version format ok 2 - version starts with "4." (update for 5.x) ok 3 - VERSION strings should be the same in all .pm files in dist 1..3 ok All tests successful. Files=69, Tests=2086, 40 wallclock secs ( 0.76 usr 0.17 sys + 7.95 cusr 1.42 csys = 10.30 CPU) Result: PASS MICHIELB/DBD-mysql-4.041.tar.gz make test TEST_VERBOSE=1 -- OK Fetching with LWP: http://ppm.activestate.com/CPAN/authors/id/M/MI/MICHIELB/CHECKSUMS Michiel Beijen <michiel.beijen@gmail.com> A MySQL driver for the Perl5 Database Interface (DBI) >>> (cd /data/fly2200/cpanfly-5.22/var/tmp/cpan_build/DBD-mysql-4.041-ainK6v && tar cvf - DBD-mysql-4.041.ppd blib) | gzip -c >/data/fly2200/cpanfly-5.22/var/REPO/M/MI/MICHIELB/DBD-mysql-4.041.tar.gz DBD-mysql-4.041.ppd blib/ blib/man3/ blib/man3/Bundle::DBD::mysql.3 blib/man3/DBD::mysql.3 blib/man3/DBD::mysql::INSTALL.3 blib/arch/ blib/arch/auto/ blib/arch/auto/DBD/ blib/arch/auto/DBD/mysql/ blib/arch/auto/DBD/mysql/mysql.so 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 VmSize: 346956 kB Finished 2016-11-30T02:08:20