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.16\site\bin;C:\Perl-5.16\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 2013-05-24T04:31:57 ActivePerl-1600 CPAN-1.9800 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.16/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.16\site\bin;C:\Perl-5.16\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 Reading 'C:\cpanfly-5.16\var\cpan\Metadata' Database was generated on Fri, 24 May 2013 09:07:50 GMT Running make for R/RE/REHSACK/SQL-Statement-1.404.tar.gz Fetching with LWP: http://cpan.nas.activestate.com/authors/id/R/RE/REHSACK/SQL-Statement-1.404.tar.gz Fetching with LWP: http://cpan.nas.activestate.com/authors/id/R/RE/REHSACK/CHECKSUMS Checksum for C:\cpanfly-5.16\var\cpan\sources\authors\id\R\RE\REHSACK\SQL-Statement-1.404.tar.gz ok SQL-Statement-1.404/ SQL-Statement-1.404/.aspell.local.pws SQL-Statement-1.404/Changes SQL-Statement-1.404/lib/ SQL-Statement-1.404/Makefile.PL SQL-Statement-1.404/MANIFEST SQL-Statement-1.404/MANIFEST.SKIP SQL-Statement-1.404/META.json SQL-Statement-1.404/META.yml SQL-Statement-1.404/README SQL-Statement-1.404/README.md SQL-Statement-1.404/t/ SQL-Statement-1.404/xt/ SQL-Statement-1.404/xt/pod-cm.t SQL-Statement-1.404/xt/pod.t SQL-Statement-1.404/xt/pod_coverage.t SQL-Statement-1.404/t/00error.t SQL-Statement-1.404/t/01prepare.t SQL-Statement-1.404/t/02execute.t SQL-Statement-1.404/t/03import.t SQL-Statement-1.404/t/04idents.t SQL-Statement-1.404/t/05simple.t SQL-Statement-1.404/t/06virtual.t SQL-Statement-1.404/t/08join.t SQL-Statement-1.404/t/09ops.t SQL-Statement-1.404/t/10limit.t SQL-Statement-1.404/t/12eval.t SQL-Statement-1.404/t/17quoting.t SQL-Statement-1.404/t/23dialects.t SQL-Statement-1.404/t/SQLtest.pm SQL-Statement-1.404/t/TestLib.pm SQL-Statement-1.404/lib/SQL/ SQL-Statement-1.404/lib/SQL/Dialects/ SQL-Statement-1.404/lib/SQL/Eval.pm SQL-Statement-1.404/lib/SQL/Parser.pm SQL-Statement-1.404/lib/SQL/Statement/ SQL-Statement-1.404/lib/SQL/Statement.pm SQL-Statement-1.404/lib/SQL/Statement/Embed.pod SQL-Statement-1.404/lib/SQL/Statement/Function.pm SQL-Statement-1.404/lib/SQL/Statement/Functions.pm SQL-Statement-1.404/lib/SQL/Statement/GetInfo.pm SQL-Statement-1.404/lib/SQL/Statement/Operation.pm SQL-Statement-1.404/lib/SQL/Statement/Placeholder.pm SQL-Statement-1.404/lib/SQL/Statement/RAM.pm SQL-Statement-1.404/lib/SQL/Statement/Roadmap.pod SQL-Statement-1.404/lib/SQL/Statement/Structure.pod SQL-Statement-1.404/lib/SQL/Statement/Syntax.pod SQL-Statement-1.404/lib/SQL/Statement/Term.pm SQL-Statement-1.404/lib/SQL/Statement/TermFactory.pm SQL-Statement-1.404/lib/SQL/Statement/Util.pm SQL-Statement-1.404/lib/SQL/Dialects/ANSI.pm SQL-Statement-1.404/lib/SQL/Dialects/AnyData.pm SQL-Statement-1.404/lib/SQL/Dialects/CSV.pm SQL-Statement-1.404/lib/SQL/Dialects/Role.pm CPAN.pm: Building R/RE/REHSACK/SQL-Statement-1.404.tar.gz >>> C:\Perl-5.16\bin\perl.exe Makefile.PL Checking if your kit is complete... Looks good Writing Makefile for SQL::Statement 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. cp lib/SQL/Dialects/ANSI.pm blib\lib\SQL\Dialects\ANSI.pm cp lib/SQL/Parser.pm blib\lib\SQL\Parser.pm cp lib/SQL/Statement/TermFactory.pm blib\lib\SQL\Statement\TermFactory.pm cp lib/SQL/Statement/Util.pm blib\lib\SQL\Statement\Util.pm cp lib/SQL/Statement/GetInfo.pm blib\lib\SQL\Statement\GetInfo.pm cp lib/SQL/Statement/Structure.pod blib\lib\SQL\Statement\Structure.pod cp lib/SQL/Statement/Term.pm blib\lib\SQL\Statement\Term.pm cp lib/SQL/Statement/Syntax.pod blib\lib\SQL\Statement\Syntax.pod cp lib/SQL/Dialects/Role.pm blib\lib\SQL\Dialects\Role.pm cp lib/SQL/Dialects/AnyData.pm blib\lib\SQL\Dialects\AnyData.pm cp lib/SQL/Statement/RAM.pm blib\lib\SQL\Statement\RAM.pm cp lib/SQL/Statement/Embed.pod blib\lib\SQL\Statement\Embed.pod cp lib/SQL/Statement/Placeholder.pm blib\lib\SQL\Statement\Placeholder.pm cp lib/SQL/Statement.pm blib\lib\SQL\Statement.pm cp lib/SQL/Dialects/CSV.pm blib\lib\SQL\Dialects\CSV.pm cp lib/SQL/Statement/Roadmap.pod blib\lib\SQL\Statement\Roadmap.pod cp lib/SQL/Statement/Operation.pm blib\lib\SQL\Statement\Operation.pm cp lib/SQL/Eval.pm blib\lib\SQL\Eval.pm cp lib/SQL/Statement/Functions.pm blib\lib\SQL\Statement\Functions.pm cp lib/SQL/Statement/Function.pm blib\lib\SQL\Statement\Function.pm REHSACK/SQL-Statement-1.404.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.16\bin\perl.exe "-MExtUtils::Command::MM" "-e" "test_harness(1, 'blib\lib', 'blib\arch')" t/*.t xt/*.t overload arg '..' is invalid at C:/cpanfly-5.16/var/megalib/Math/BigInt.pm line 153. # # Using required: # # SQL::Statement: 1.404 # # Using recommended: t/00error.t ........ # DBI object version 1.625 does not match $DBI::VERSION 1.627 at C:/Perl-5.16/lib/DynaLoader.pm line 214. # BEGIN failed--compilation aborted at C:/cpanfly-5.16/var/megalib/DBI.pm line 278. # Compilation failed in require at C:/cpanfly-5.16/var/megalib/DBD/File.pm line 27. # BEGIN failed--compilation aborted at C:/cpanfly-5.16/var/megalib/DBD/File.pm line 27. # Compilation failed in require at C:/cpanfly-5.16/var/megalib/DBD/CSV.pm line 15. # Compilation failed in require at t/TestLib.pm line 42. # Attempt to reload DBI.pm aborted. # Compilation failed in require at t/TestLib.pm line 42. # Attempt to reload DBD/File.pm aborted. # Compilation failed in require at t/TestLib.pm line 42. # Attempt to reload DBD/File.pm aborted. # Compilation failed in require at (eval 31) line 2. # ...propagated at C:/cpanfly-5.16/var/megalib/base.pm line 84. # BEGIN failed--compilation aborted at C:/cpanfly-5.16/var/megalib/DBD/DBM.pm line 25. # Compilation failed in require at t/TestLib.pm line 42. # Running tests for SQL::Statement ok 1 - Parse "Junk" RaiseError=0 (default) ok 2 - Execute function succeeded ok 3 - Execute function no errstr ok 4 - Execute RaiseError=0 ok 5 - Parse "Junk" RaiseError=1 ok 6 - Execute RaiseError=1 ok 7 - Execute "SELECT * FROM nonexistant" has errstr 1..7 ok overload arg '..' is invalid at C:/cpanfly-5.16/var/megalib/Math/BigInt.pm line 153. t/01prepare.t ...... # DBI object version 1.625 does not match $DBI::VERSION 1.627 at C:/Perl-5.16/lib/DynaLoader.pm line 214. # BEGIN failed--compilation aborted at C:/cpanfly-5.16/var/megalib/DBI.pm line 278. # Compilation failed in require at C:/cpanfly-5.16/var/megalib/DBD/File.pm line 27. # BEGIN failed--compilation aborted at C:/cpanfly-5.16/var/megalib/DBD/File.pm line 27. # Compilation failed in require at C:/cpanfly-5.16/var/megalib/DBD/CSV.pm line 15. # Compilation failed in require at t/TestLib.pm line 42. # Attempt to reload DBI.pm aborted. # Compilation failed in require at t/TestLib.pm line 42. # Attempt to reload DBD/File.pm aborted. # Compilation failed in require at t/TestLib.pm line 42. # Attempt to reload DBD/File.pm aborted. # Compilation failed in require at (eval 31) line 2. # ...propagated at C:/cpanfly-5.16/var/megalib/base.pm line 84. # BEGIN failed--compilation aborted at C:/cpanfly-5.16/var/megalib/DBD/DBM.pm line 25. # Compilation failed in require at t/TestLib.pm line 42. ok 1 - parse ' /* DROP TABLE */' using SQL::Statement ok 2 - parse 'DROP TABLE foo' using SQL::Statement ok 3 - parse 'DROP TABLE foo CASCADE' using SQL::Statement ok 4 - parse 'DROP TABLE foo RESTRICT' using SQL::Statement ok 5 - parse ' /* DELETE */' using SQL::Statement ok 6 - parse 'DELETE FROM foo' using SQL::Statement ok 7 - parse 'DELETE FROM foo WHERE id < 7' using SQL::Statement ok 8 - parse ' /* UPDATE */' using SQL::Statement ok 9 - parse 'UPDATE foo SET bar = 7' using SQL::Statement ok 10 - parse 'UPDATE foo SET bar = 7 WHERE id > 7' using SQL::Statement ok 11 - parse ' /* INSERT */' using SQL::Statement ok 12 - parse 'INSERT INTO foo VALUES ( 'baz', 7, NULL )' using SQL::Statement ok 13 - parse 'INSERT INTO foo (col1,col2,col7) VALUES ( 'baz', 7, NULL )' using SQL::Statement ok 14 - parse ' /* CREATE TABLE */' using SQL::Statement ok 15 - parse 'CREATE TABLE foo ( id INT )' using SQL::Statement ok 16 - parse 'CREATE LOCAL TEMPORARY TABLE foo (id INT)' using SQL::Statement ok 17 - parse 'CREATE LOCAL TEMPORARY TABLE foo (id INT) ON COMMIT DELETE ROWS' using SQL::Statement ok 18 - parse 'CREATE LOCAL TEMPORARY TABLE foo (id INT) ON COMMIT PRESERVE ROWS' using SQL::Statement ok 19 - parse 'CREATE GLOBAL TEMPORARY TABLE foo (id INT)' using SQL::Statement ok 20 - parse 'CREATE GLOBAL TEMPORARY TABLE foo (id INT) ON COMMIT DELETE ROWS' using SQL::Statement ok 21 - parse 'CREATE GLOBAL TEMPORARY TABLE foo (id INT) ON COMMIT PRESERVE ROWS' using SQL::Statement ok 22 - parse 'CREATE TABLE foo ( id INTEGER, phrase VARCHAR(40) )' using SQL::Statement ok 23 - parse 'CREATE TABLE foo ( id INTEGER UNIQUE, phrase VARCHAR(40) UNIQUE )' using SQL::Statement ok 24 - parse 'CREATE TABLE foo ( id INTEGER PRIMARY KEY, phrase VARCHAR(40) UNIQUE )' using SQL::Statement ok 25 - parse 'CREATE TABLE foo ( id INTEGER PRIMARY KEY, phrase VARCHAR(40) NOT NULL )' using SQL::Statement ok 26 - parse 'CREATE TABLE foo ( id INTEGER NOT NULL, phrase VARCHAR(40) NOT NULL )' using SQL::Statement ok 27 - parse 'CREATE TABLE foo ( id INTEGER UNIQUE NOT NULL, phrase VARCHAR(40) )' using SQL::Statement ok 28 - parse 'CREATE TABLE foo ( phrase CHARACTER VARYING(255) )' using SQL::Statement ok 29 - parse 'CREATE TABLE foo ( phrase NUMERIC(4,6) )' using SQL::Statement ok 30 - parse 'CREATE TABLE foo ( id INTEGER, phrase VARCHAR(40), CONSTRAINT "foo_pkey" PRIMARY KEY ( "id", "phrase" ), CONSTRAINT "foo_fkey" FOREIGN KEY ( "id" ) REFERENCES "bar" ( "bar_id" ))' using SQL::Statement ok 31 - parse 'CREATE TABLE foo ( id INTEGER, phrase VARCHAR(40), PRIMARY KEY ( "id" ), FOREIGN KEY ("id", "phrase") REFERENCES "bar" ("id2", "phrase2"))' using SQL::Statement ok 32 - parse 'CREATE TABLE foo ( id INTEGER, phrase CHAR(255), phrase2 VARCHAR(40), CONSTRAINT "foo_pkey" PRIMARY KEY ( "id", phrase, "phrase2" ), CONSTRAINT "foo_fkey" FOREIGN KEY ("id", "phrase", "phrase2") REFERENCES "bar" ("id2", "phrase2", "phase10"))' using SQL::Statement ok 33 - parse ' /* JOINS */' using SQL::Statement ok 34 - parse 'SELECT Lnum,Llet,Ulet FROM zLower NATURAL INNER JOIN zUpper' using SQL::Statement ok 35 - parse 'SELECT Lnum,Llet,Ulet FROM zLower NATURAL LEFT JOIN zUpper' using SQL::Statement ok 36 - parse 'SELECT Lnum,Llet,Ulet FROM zLower NATURAL RIGHT JOIN zUpper' using SQL::Statement ok 37 - parse 'SELECT Lnum,Llet,Ulet FROM zLower NATURAL FULL JOIN zUpper' using SQL::Statement ok 38 - parse 'SELECT Lnum,Llet,Ulet FROM zLower INNER JOIN zUpper ON Lnum = Unum' using SQL::Statement ok 39 - parse 'SELECT Lnum,Llet,Ulet FROM zLower LEFT JOIN zUpper ON Lnum = Unum' using SQL::Statement ok 40 - parse 'SELECT Lnum,Llet,Ulet FROM zLower RIGHT JOIN zUpper ON Lnum = Unum' using SQL::Statement ok 41 - parse 'SELECT Lnum,Llet,Ulet FROM zLower FULL JOIN zUpper ON Lnum = Unum' using SQL::Statement ok 42 - parse 'SELECT Lnum,Llet,Ulet FROM zLower INNER JOIN zUpper USING(num)' using SQL::Statement ok 43 - parse 'SELECT Lnum,Llet,Ulet FROM zLower LEFT JOIN zUpper USING(num)' using SQL::Statement ok 44 - parse 'SELECT Lnum,Llet,Ulet FROM zLower RIGHT JOIN zUpper USING(num)' using SQL::Statement ok 45 - parse 'SELECT Lnum,Llet,Ulet FROM zLower FULL JOIN zUpper USING(num)' using SQL::Statement ok 46 - parse 'SELECT Lnum,Llet,Ulet FROM zLower,zUpper WHERE Lnum = Unum' using SQL::Statement ok 47 - parse 'SELECT * FROM zLower NATURAL INNER JOIN zUpper' using SQL::Statement ok 48 - parse 'SELECT * FROM zLower NATURAL LEFT JOIN zUpper' using SQL::Statement ok 49 - parse 'SELECT * FROM zLower NATURAL RIGHT JOIN zUpper' using SQL::Statement ok 50 - parse 'SELECT * FROM zLower NATURAL FULL JOIN zUpper' using SQL::Statement ok 51 - parse 'SELECT * FROM zLower INNER JOIN zUpper ON Lnum = Unum' using SQL::Statement ok 52 - parse 'SELECT * FROM zLower LEFT JOIN zUpper ON Lnum = Unum' using SQL::Statement ok 53 - parse 'SELECT * FROM zLower RIGHT JOIN zUpper ON Lnum = Unum' using SQL::Statement ok 54 - parse 'SELECT * FROM zLower FULL JOIN zUpper ON Lnum = Unum' using SQL::Statement ok 55 - parse 'SELECT * FROM zLower INNER JOIN zUpper USING(num)' using SQL::Statement ok 56 - parse 'SELECT * FROM zLower LEFT JOIN zUpper USING(num)' using SQL::Statement ok 57 - parse 'SELECT * FROM zLower RIGHT JOIN zUpper USING(num)' using SQL::Statement ok 58 - parse 'SELECT * FROM zLower FULL JOIN zUpper USING(num)' using SQL::Statement ok 59 - parse 'SELECT * FROM zLower,zUpper WHERE Lnum = Unum' using SQL::Statement ok 60 - parse ' /* SELECT COLUMNS */' using SQL::Statement ok 61 - parse 'SELECT id, phrase FROM foo' using SQL::Statement ok 62 - parse 'SELECT * FROM foo' using SQL::Statement ok 63 - parse 'SELECT DISTINCT * FROM foo' using SQL::Statement ok 64 - parse 'SELECT ALL * FROM foo' using SQL::Statement ok 65 - parse 'SELECT A.*,B.* FROM A,B WHERE A.id=B.id' using SQL::Statement ok 66 - parse ' /* SET FUNCTIONS */' using SQL::Statement ok 67 - parse 'SELECT MAX(foo) FROM bar' using SQL::Statement ok 68 - parse 'SELECT MIN(foo) FROM bar' using SQL::Statement ok 69 - parse 'SELECT AVG(foo) FROM bar' using SQL::Statement ok 70 - parse 'SELECT SUM(foo) FROM bar' using SQL::Statement ok 71 - parse 'SELECT COUNT(foo) FROM foo' using SQL::Statement ok 72 - parse 'SELECT COUNT(*) FROM foo' using SQL::Statement ok 73 - parse 'SELECT SUM(DISTINCT foo) FROM bar' using SQL::Statement ok 74 - parse 'SELECT SUM(ALL foo) FROM bar' using SQL::Statement ok 75 - parse ' /* ORDER BY */' using SQL::Statement ok 76 - parse 'SELECT * FROM foo ORDER BY bar' using SQL::Statement ok 77 - parse 'SELECT * FROM foo ORDER BY bar, baz' using SQL::Statement ok 78 - parse 'SELECT * FROM foo ORDER BY bar DESC' using SQL::Statement ok 79 - parse 'SELECT * FROM foo ORDER BY bar ASC' using SQL::Statement ok 80 - parse ' /* LIMIT */' using SQL::Statement ok 81 - parse 'SELECT * FROM foo LIMIT 5' using SQL::Statement ok 82 - parse 'SELECT * FROM foo LIMIT 0, 5' using SQL::Statement ok 83 - parse 'SELECT * FROM foo LIMIT 5, 10' using SQL::Statement ok 84 - parse '/* DATE/TIME FUNCTIONS */' using SQL::Statement ok 85 - parse 'SELECT CURRENT_DATE()' using SQL::Statement ok 86 - parse 'SELECT CURRENT_TIME()' using SQL::Statement ok 87 - parse 'SELECT CURRENT_TIMESTAMP()' using SQL::Statement ok 88 - parse 'SELECT CURDATE()' using SQL::Statement ok 89 - parse 'SELECT CURTIME()' using SQL::Statement ok 90 - parse 'SELECT NOW()' using SQL::Statement ok 91 - parse 'SELECT UNIX_TIMESTAMP() ' using SQL::Statement ok 92 - parse 'SELECT CURRENT_TIME(2)' using SQL::Statement ok 93 - parse 'SELECT CURRENT_TIMESTAMP(2)' using SQL::Statement ok 94 - parse 'SELECT CURTIME(2)' using SQL::Statement ok 95 - parse 'SELECT NOW(2)' using SQL::Statement ok 96 - parse 'SELECT UNIX_TIMESTAMP(2)' using SQL::Statement ok 97 - parse ' /* STRING FUNCTIONS */' using SQL::Statement ok 98 - parse 'SELECT * FROM foo WHERE ASCII(status) = 65' using SQL::Statement ok 99 - parse 'SELECT * FROM foo WHERE CHAR(code) = 'A'' using SQL::Statement ok 100 - parse 'SELECT * FROM foo WHERE CHAR(chr1,chr2,chr3) = 'ABC'' using SQL::Statement ok 101 - parse 'SELECT * FROM foo WHERE BIT_LENGTH(str) = 27' using SQL::Statement ok 102 - parse 'SELECT * FROM foo WHERE CHARACTER_LENGTH(str) = 6' using SQL::Statement ok 103 - parse 'SELECT * FROM foo WHERE CHAR_LENGTH(str) = 6' using SQL::Statement ok 104 - parse 'SELECT * FROM foo WHERE COALESCE(NULL, status) = 'bar'' using SQL::Statement ok 105 - parse 'SELECT * FROM foo WHERE NVL(NULL, status) = 'bar'' using SQL::Statement ok 106 - parse 'SELECT * FROM foo WHERE IFNULL(NULL, status) = 'bar'' using SQL::Statement ok 107 - parse 'SELECT * FROM foo WHERE CONCAT(str1, str2) = 'bar'' using SQL::Statement ok 108 - parse 'SELECT * FROM foo WHERE DECODE(color,'White','W','Red','R','B') = 'W'' using SQL::Statement ok 109 - parse 'SELECT * FROM foo WHERE INSERT(str1, 4, 5, str2) = 'foobarland'' using SQL::Statement ok 110 - parse 'SELECT * FROM foo WHERE LEFT(phrase) = 'bar'' using SQL::Statement ok 111 - parse 'SELECT * FROM foo WHERE RIGHT(phrase) = 'bar'' using SQL::Statement ok 112 - parse 'SELECT * FROM foo WHERE LOCATE(str1, str2) = 2' using SQL::Statement ok 113 - parse 'SELECT * FROM foo WHERE LOCATE(str1, str2, 3) = 5' using SQL::Statement ok 114 - parse 'SELECT * FROM foo WHERE POSITION(str1, str2) = 2' using SQL::Statement ok 115 - parse 'SELECT * FROM foo WHERE POSITION(str1, str2, 3) = 5' using SQL::Statement ok 116 - parse 'SELECT * FROM foo WHERE LOWER(phrase) = 'bar'' using SQL::Statement ok 117 - parse 'SELECT * FROM foo WHERE UPPER(phrase) = 'BAR'' using SQL::Statement ok 118 - parse 'SELECT * FROM foo WHERE LCASE(phrase) = 'BAR'' using SQL::Statement ok 119 - parse 'SELECT * FROM foo WHERE UCASE(phrase) = 'bar'' using SQL::Statement ok 120 - parse 'SELECT * FROM foo WHERE LTRIM(str) = 'bar'' using SQL::Statement ok 121 - parse 'SELECT * FROM foo WHERE RTRIM(str) = 'bar'' using SQL::Statement ok 122 - parse 'SELECT * FROM foo WHERE OCTET_LENGTH(str) = 12' using SQL::Statement ok 123 - parse 'SELECT * FROM foo WHERE REGEX(phrase, '/EF/i') = TRUE' using SQL::Statement ok 124 - parse 'SELECT * FROM foo WHERE REPEAT(status, 3) = 'AAA'' using SQL::Statement ok 125 - parse 'SELECT * FROM foo WHERE REPLACE(phrase, 's/z(.+)ky//i') = 'bar'' using SQL::Statement ok 126 - parse 'SELECT * FROM foo WHERE SUBSTITUTE(phrase, 's/z(.+)ky//i') = 'bar'' using SQL::Statement ok 127 - parse 'SELECT * FROM foo WHERE SOUNDEX(name1, name2) = TRUE' using SQL::Statement ok 128 - parse 'SELECT * FROM foo WHERE SPACE(num) = ' '' using SQL::Statement ok 129 - parse 'SELECT * FROM foo WHERE blat = SUBSTRING(bar FROM 3 FOR 6)' using SQL::Statement ok 130 - parse 'SELECT * FROM foo WHERE blat = SUBSTRING(bar FROM 3)' using SQL::Statement ok 131 - parse 'SELECT * FROM foo WHERE blat = SUBSTR(bar, 3, 6)' using SQL::Statement ok 132 - parse 'SELECT * FROM foo WHERE blat = SUBSTR(bar, 3)' using SQL::Statement ok 133 - parse 'SELECT * FROM foo WHERE blat = TRANSLATE(bar, set1, set2)' using SQL::Statement ok 134 - parse 'SELECT * FROM foo WHERE TRIM( str ) = 'bar'' using SQL::Statement ok 135 - parse 'SELECT * FROM foo WHERE TRIM( LEADING FROM str ) = 'bar'' using SQL::Statement ok 136 - parse 'SELECT * FROM foo WHERE TRIM( TRAILING FROM str ) = 'bar'' using SQL::Statement ok 137 - parse 'SELECT * FROM foo WHERE TRIM( BOTH FROM str ) = 'bar'' using SQL::Statement ok 138 - parse 'SELECT * FROM foo WHERE TRIM( LEADING ';' FROM str ) = 'bar'' using SQL::Statement ok 139 - parse 'SELECT * FROM foo WHERE TRIM( UPPER(phrase) ) = 'bar'' using SQL::Statement ok 140 - parse 'SELECT * FROM foo WHERE TRIM( LOWER(phrase) ) = 'bar'' using SQL::Statement ok 141 - parse 'UPDATE foo SET bar='baz', bop=7, bump=bar+8, blat=SUBSTRING(bar FROM 3 FOR 6)' using SQL::Statement ok 142 - parse ' /* NUMERIC FUNCTIONS */' using SQL::Statement ok 143 - parse 'SELECT * FROM bar WHERE ABS(-4) = 4' using SQL::Statement ok 144 - parse 'SELECT * FROM bar WHERE CEILING(-4.5) = -4' using SQL::Statement ok 145 - parse 'SELECT * FROM bar WHERE CEIL(-4.9) = -4' using SQL::Statement ok 146 - parse 'SELECT * FROM bar WHERE FLOOR(4.999999999999) = 4' using SQL::Statement ok 147 - parse 'SELECT * FROM bar WHERE LOG(6) = LOG10(6)' using SQL::Statement ok 148 - parse 'SELECT * FROM bar WHERE LN(1) = EXP(1)' using SQL::Statement ok 149 - parse 'SELECT * FROM bar WHERE MOD(8, 5) = 3' using SQL::Statement ok 150 - parse 'SELECT * FROM bar WHERE POWER(2, 4) = 16' using SQL::Statement ok 151 - parse 'SELECT * FROM bar WHERE POW(2, 4) = 16' using SQL::Statement ok 152 - parse 'SELECT * FROM bar WHERE RAND(2) = 0' using SQL::Statement ok 153 - parse 'SELECT * FROM bar WHERE RAND(2, UNIX_TIMESTAMP()) = 0' using SQL::Statement ok 154 - parse 'SELECT * FROM bar WHERE ROUND(4.999999999999) = 5' using SQL::Statement ok 155 - parse 'SELECT * FROM bar WHERE ROUND(4.542222222222, 1) = 4.5' using SQL::Statement ok 156 - parse 'SELECT * FROM bar WHERE SIGN(-25.5) = -1' using SQL::Statement ok 157 - parse 'SELECT * FROM bar WHERE SIGN(53645) = 1' using SQL::Statement ok 158 - parse 'SELECT * FROM bar WHERE SIGN(0) = 0' using SQL::Statement ok 159 - parse 'SELECT * FROM bar WHERE SIGN(NULL) = NULL' using SQL::Statement ok 160 - parse 'SELECT * FROM bar WHERE SQRT(64) = 8' using SQL::Statement ok 161 - parse 'SELECT * FROM bar WHERE TRUNCATE(4.999999999999) = 4' using SQL::Statement ok 162 - parse 'SELECT * FROM bar WHERE TRUNC(-4.9) = -4' using SQL::Statement ok 163 - parse 'SELECT * FROM bar WHERE TRUNCATE(4.934, 1) = 4.9' using SQL::Statement ok 164 - parse 'SELECT * FROM bar WHERE TRUNC(-4.99999, 1) = -4.9' using SQL::Statement ok 165 - parse ' /* TRIGONOMETRIC FUNCTIONS */' using SQL::Statement ok 166 - parse 'SELECT * FROM test WHERE ACOS(x)' using SQL::Statement ok 167 - parse 'SELECT * FROM test WHERE ACOSEC(x)' using SQL::Statement ok 168 - parse 'SELECT * FROM test WHERE ACOSECH(x)' using SQL::Statement ok 169 - parse 'SELECT * FROM test WHERE ACOSH(x)' using SQL::Statement ok 170 - parse 'SELECT * FROM test WHERE ACOT(x)' using SQL::Statement ok 171 - parse 'SELECT * FROM test WHERE ACOTAN(x)' using SQL::Statement ok 172 - parse 'SELECT * FROM test WHERE ACOTANH(x)' using SQL::Statement ok 173 - parse 'SELECT * FROM test WHERE ACOTH(x)' using SQL::Statement ok 174 - parse 'SELECT * FROM test WHERE ACSC(x)' using SQL::Statement ok 175 - parse 'SELECT * FROM test WHERE ACSCH(x)' using SQL::Statement ok 176 - parse 'SELECT * FROM test WHERE ASEC(x)' using SQL::Statement ok 177 - parse 'SELECT * FROM test WHERE ASECH(x)' using SQL::Statement ok 178 - parse 'SELECT * FROM test WHERE ASIN(x)' using SQL::Statement ok 179 - parse 'SELECT * FROM test WHERE ASINH(x)' using SQL::Statement ok 180 - parse 'SELECT * FROM test WHERE ATAN(x)' using SQL::Statement ok 181 - parse 'SELECT * FROM test WHERE ATAN2(y, x)' using SQL::Statement ok 182 - parse 'SELECT * FROM test WHERE ATANH(x)' using SQL::Statement ok 183 - parse 'SELECT * FROM test WHERE COS(x)' using SQL::Statement ok 184 - parse 'SELECT * FROM test WHERE COSEC(x)' using SQL::Statement ok 185 - parse 'SELECT * FROM test WHERE COSECH(x)' using SQL::Statement ok 186 - parse 'SELECT * FROM test WHERE COSH(x)' using SQL::Statement ok 187 - parse 'SELECT * FROM test WHERE COT(x)' using SQL::Statement ok 188 - parse 'SELECT * FROM test WHERE COTAN(x)' using SQL::Statement ok 189 - parse 'SELECT * FROM test WHERE COTANH(x)' using SQL::Statement ok 190 - parse 'SELECT * FROM test WHERE COTH(x)' using SQL::Statement ok 191 - parse 'SELECT * FROM test WHERE CSC(x)' using SQL::Statement ok 192 - parse 'SELECT * FROM test WHERE CSCH(x)' using SQL::Statement ok 193 - parse 'SELECT * FROM test WHERE DEG2DEG(deg)' using SQL::Statement ok 194 - parse 'SELECT * FROM test WHERE RAD2RAD(rad)' using SQL::Statement ok 195 - parse 'SELECT * FROM test WHERE GRAD2GRAD(grad)' using SQL::Statement ok 196 - parse 'SELECT * FROM test WHERE DEG2GRAD(deg)' using SQL::Statement ok 197 - parse 'SELECT * FROM test WHERE DEG2RAD(deg)' using SQL::Statement ok 198 - parse 'SELECT * FROM test WHERE GRAD2DEG(grad)' using SQL::Statement ok 199 - parse 'SELECT * FROM test WHERE GRAD2RAD(grad)' using SQL::Statement ok 200 - parse 'SELECT * FROM test WHERE RAD2DEG(rad)' using SQL::Statement ok 201 - parse 'SELECT * FROM test WHERE RAD2GRAD(rad)' using SQL::Statement ok 202 - parse 'SELECT * FROM test WHERE DEGREES(rad)' using SQL::Statement ok 203 - parse 'SELECT * FROM test WHERE RADIANS(deg)' using SQL::Statement ok 204 - parse 'SELECT * FROM test WHERE DEG2DEG(deg, TRUE)' using SQL::Statement ok 205 - parse 'SELECT * FROM test WHERE RAD2RAD(rad, TRUE)' using SQL::Statement ok 206 - parse 'SELECT * FROM test WHERE GRAD2GRAD(grad, TRUE)' using SQL::Statement ok 207 - parse 'SELECT * FROM test WHERE DEG2GRAD(deg, TRUE)' using SQL::Statement ok 208 - parse 'SELECT * FROM test WHERE DEG2RAD(deg, TRUE)' using SQL::Statement ok 209 - parse 'SELECT * FROM test WHERE GRAD2DEG(grad, TRUE)' using SQL::Statement ok 210 - parse 'SELECT * FROM test WHERE GRAD2RAD(grad, TRUE)' using SQL::Statement ok 211 - parse 'SELECT * FROM test WHERE RAD2DEG(rad, TRUE)' using SQL::Statement ok 212 - parse 'SELECT * FROM test WHERE RAD2GRAD(rad, TRUE)' using SQL::Statement ok 213 - parse 'SELECT * FROM test WHERE DEGREES(rad, TRUE)' using SQL::Statement ok 214 - parse 'SELECT * FROM test WHERE RADIANS(deg, TRUE)' using SQL::Statement ok 215 - parse 'SELECT * FROM test WHERE PI()' using SQL::Statement ok 216 - parse 'SELECT * FROM test WHERE SEC(x)' using SQL::Statement ok 217 - parse 'SELECT * FROM test WHERE SECH(x)' using SQL::Statement ok 218 - parse 'SELECT * FROM test WHERE SIN(x)' using SQL::Statement ok 219 - parse 'SELECT * FROM test WHERE SINH(x)' using SQL::Statement ok 220 - parse 'SELECT * FROM test WHERE TAN(x)' using SQL::Statement ok 221 - parse 'SELECT * FROM test WHERE TANH(x)' using SQL::Statement ok 222 - parse ' /* SYSTEM FUNCTIONS */' using SQL::Statement ok 223 - parse 'SELECT * FROM ztable WHERE DBNAME() = foobar' using SQL::Statement ok 224 - parse 'SELECT * FROM ztable WHERE USERNAME() = foobar' using SQL::Statement ok 225 - parse 'SELECT * FROM ztable WHERE USER() = foobar' using SQL::Statement ok 226 - parse ' /* TABLE NAME ALIASES */' using SQL::Statement ok 227 - parse 'SELECT * FROM test as T1' using SQL::Statement ok 228 - parse 'SELECT * FROM test T1' using SQL::Statement ok 229 - parse 'SELECT T1.id, T2.num FROM test as T1 JOIN test2 as T2 USING(id)' using SQL::Statement ok 230 - parse 'SELECT id FROM test as T1 WHERE T1.num < 7' using SQL::Statement ok 231 - parse 'SELECT id FROM test as T1 ORDER BY T1.num' using SQL::Statement ok 232 - parse 'SELECT a.x,b.y FROM foo AS a, bar b WHERE a.baz = b.bop ORDER BY a.blat' using SQL::Statement ok 233 - parse ' /* NUMERIC EXPRESSIONS */' using SQL::Statement ok 234 - parse 'SELECT * FROM foo WHERE 1 = 0 AND baz < (6*foo+11-r)' using SQL::Statement ok 235 - parse ' /* CASE OF IDENTIFIERS */' using SQL::Statement ok 236 - parse 'SELECT ID, phRase FROM tEst AS tE WHERE te.id < 3 ORDER BY TE.phrasE' using SQL::Statement ok 237 - parse ' /* PARENS */' using SQL::Statement ok 238 - parse 'SELECT * FROM ztable WHERE NOT data IN ('one','two')' using SQL::Statement ok 239 - parse 'SELECT * from ztable WHERE (aaa > 'AAA')' using SQL::Statement ok 240 - parse 'SELECT * from ztable WHERE sev = 50 OR sev = 60' using SQL::Statement ok 241 - parse 'SELECT * from ztable WHERE (sev = 50 OR sev = 60)' using SQL::Statement ok 242 - parse 'SELECT * from ztable WHERE sev IN (50,60)' using SQL::Statement ok 243 - parse 'SELECT * from ztable WHERE rc > 200 AND ( sev IN(50,60) )' using SQL::Statement ok 244 - parse 'SELECT * FROM ztable WHERE data NOT IN ('one','two')' using SQL::Statement ok 245 - parse 'SELECT * from ztable WHERE (aaa > 'AAA') AND (zzz < 'ZZZ')' using SQL::Statement ok 246 - parse 'SELECT * from ztable WHERE (sev IN(50,60))' using SQL::Statement ok 247 - parse ' /* NOT */' using SQL::Statement ok 248 - parse 'SELECT * FROM foo WHERE NOT bar = 'baz' AND bop = 7 OR NOT blat = bar' using SQL::Statement ok 249 - parse 'SELECT * FROM foo WHERE NOT bar = 'baz' AND NOT bop = 7 OR NOT blat = bar' using SQL::Statement ok 250 - parse 'SELECT * FROM foo WHERE NOT bar = 'baz' AND NOT bop = 7 OR blat IS NOT NULL' using SQL::Statement ok 251 - parse ' /* IN */' using SQL::Statement ok 252 - parse 'SELECT * FROM bar WHERE foo IN ('aa','ab','ba','bb')' using SQL::Statement ok 253 - parse 'SELECT * FROM bar WHERE foo IN (3.14,2.72,1.41,9.81)' using SQL::Statement ok 254 - parse 'SELECT * FROM bar WHERE foo NOT IN ('aa','ab','ba','bb')' using SQL::Statement ok 255 - parse 'SELECT * FROM bar WHERE foo NOT IN (3.14,2.72,1.41,9.81)' using SQL::Statement ok 256 - parse ' /* BETWEEN */' using SQL::Statement ok 257 - parse 'SELECT * FROM bar WHERE foo BETWEEN ('aa','bb')' using SQL::Statement ok 258 - parse 'SELECT * FROM bar WHERE foo BETWEEN (1.41,9.81)' using SQL::Statement ok 259 - parse 'SELECT * FROM bar WHERE foo NOT BETWEEN ('aa','bb')' using SQL::Statement ok 260 - parse 'SELECT * FROM bar WHERE foo NOT BETWEEN (1.41,9.81)' using SQL::Statement not ok 261 - parse 'UPDATE foo SET bar=REPEAT(status, BIT_LENGTH(str)), bop=7, bump=bar+POSITION(str1, str2), blat=SUBSTRING(bar FROM ASCII(status) FOR CHAR_LENGTH(str))' using SQL::Statement # TODO Analyze failures # Failed (TODO) test 'parse 'UPDATE foo SET bar=REPEAT(status, BIT_LENGTH(str)), bop=7, bump=bar+POSITION(str1, str2), blat=SUBSTRING(bar FROM ASCII(status) FOR CHAR_LENGTH(str))' using SQL::Statement' # at t/01prepare.t line 309. # Incomplete SET clause! not ok 262 - parse 'SELECT * FROM bar WHERE EXP(1) = SINH(1)+COSH(1)' using SQL::Statement # TODO Analyze failures # Failed (TODO) test 'parse 'SELECT * FROM bar WHERE EXP(1) = SINH(1)+COSH(1)' using SQL::Statement' # at t/01prepare.t line 309. # # Execution ERROR: Unknown predicate '{$VAR1 = {}; # }' called from t/TestLib.pm at 190. # not ok 263 - parse 'SELECT * FROM bar WHERE LOG(8, 2) = LOG10(8) / LOG10(2)' using SQL::Statement # TODO Analyze failures # Failed (TODO) test 'parse 'SELECT * FROM bar WHERE LOG(8, 2) = LOG10(8) / LOG10(2)' using SQL::Statement' # at t/01prepare.t line 309. # # Execution ERROR: Unknown predicate '{$VAR1 = {}; # }' called from t/TestLib.pm at 190. # ok 264 - $sth->new ok 265 - $sth->command ok 266 - $sth->params ok 267 - $sth->tables ok 268 - $sth->where()->op ok 269 - $sth->where()->left ok 270 - $sth->where()->left->left ok 271 - $sth->where()->left->right ok 272 - $sth->limit ok 273 - $sth->offset # Command SELECT # Num Pholders 1 # Columns # Tables SQL::Statement::Table=HASH(0x13bfe44),SQL::Statement::Table=HASH(0x14154f4) # Where op AND # Limit 2 # Offset 5 # Order Cols f,g ok 274 - $stmt->row_values() ok 275 - $stmt->row_values(0) ok 276 - $stmt->row_values(0,1) ok 277 - structure ok 278 - command ok 279 - distinct 1..279 ok overload arg '..' is invalid at C:/cpanfly-5.16/var/megalib/Math/BigInt.pm line 153. t/02execute.t ...... # DBI object version 1.625 does not match $DBI::VERSION 1.627 at C:/Perl-5.16/lib/DynaLoader.pm line 214. # BEGIN failed--compilation aborted at C:/cpanfly-5.16/var/megalib/DBI.pm line 278. # Compilation failed in require at C:/cpanfly-5.16/var/megalib/DBD/File.pm line 27. # BEGIN failed--compilation aborted at C:/cpanfly-5.16/var/megalib/DBD/File.pm line 27. # Compilation failed in require at C:/cpanfly-5.16/var/megalib/DBD/CSV.pm line 15. # Compilation failed in require at t/TestLib.pm line 42. # Attempt to reload DBD/File.pm aborted. # Compilation failed in require at (eval 34) line 2. # ...propagated at C:/cpanfly-5.16/var/megalib/base.pm line 84. # BEGIN failed--compilation aborted at C:/cpanfly-5.16/var/megalib/DBD/DBM.pm line 25. # Compilation failed in require at t/TestLib.pm line 42. # Attempt to reload DBD/File.pm aborted. # Compilation failed in require at t/TestLib.pm line 42. # Attempt to reload DBI.pm aborted. # Compilation failed in require at t/TestLib.pm line 42. # # Using required: # # SQL::Statement: 1.404 # # Using recommended: # # MLDBM: 2.04 # Running tests for SQL::Statement ok 1 - CREATE Tmp ok 2 - placeholder insert with named cols ok 3 - placeholder insert without named cols ok 4 - placeholder delete ok 5 - placeholder update ok 6 - placeholder update ok 7 - multiline insert ok 8 - prepare 'SELECT id,phrase FROM Tmp ORDER BY id' ok 9 - verify table contents ok 10 - DROP TABLE ok 11 - CREATE ok 12 - INSERT ok 13 - INSERT ok 14 - INSERT ok 15 - UPDATE ok 16 - DELETE ok 17 - prepare 'SELECT UPPER('a') AS A,phrase FROM phrase' ok 18 - SELECT ok 19 - COUNT * ok 20 - DROP TEMP TABLE ok 21 - COMPUTED COLUMNS IN SELECT LIST ok 22 - CREATE FUNCTION from script # < CREATE TEMP TABLE a (b INT, c CHAR)> ok 23 - $stmt->execute " CREATE TEMP TABLE a (b INT, c CHAR)" (CREATE) # < INSERT INTO a VALUES(1,'abc')> ok 24 - $stmt->execute " INSERT INTO a VALUES(1,'abc')" (INSERT) # < INSERT INTO a VALUES(2,'efg')> ok 25 - $stmt->execute " INSERT INTO a VALUES(2,'efg')" (INSERT) # < INSERT INTO a VALUES(3,'hij')> ok 26 - $stmt->execute " INSERT INTO a VALUES(3,'hij')" (INSERT) # < INSERT INTO a VALUES(4,'klm')> ok 27 - $stmt->execute " INSERT INTO a VALUES(4,'klm')" (INSERT) # < INSERT INTO a VALUES(5,'nmo')> ok 28 - $stmt->execute " INSERT INTO a VALUES(5,'nmo')" (INSERT) # < INSERT INTO a VALUES(6,'pqr')> ok 29 - $stmt->execute " INSERT INTO a VALUES(6,'pqr')" (INSERT) # < INSERT INTO a VALUES(7,'stu')> ok 30 - $stmt->execute " INSERT INTO a VALUES(7,'stu')" (INSERT) # < INSERT INTO a VALUES(8,'vwx')> ok 31 - $stmt->execute " INSERT INTO a VALUES(8,'vwx')" (INSERT) # < INSERT INTO a VALUES(9,'yz')> ok 32 - $stmt->execute " INSERT INTO a VALUES(9,'yz')" (INSERT) # < SELECT b,c FROM a WHERE c LIKE '%b%' ORDER BY c DESC"> ok 33 - $stmt->execute " SELECT b,c FROM a WHERE c LIKE '%b%' ORDER BY c DESC"" (SELECT) ok 34 - $stmt->where_hash ok 35 - $stmt->columns ok 36 - $stmt->column_names ok 37 - $stmt->order ok 38 - $stmt->fetch ok 39 - $stmt->execute "SELECT b,c FROM a WHERE NOT c IN ('abc','klm','pqr','vwx','yz')" (SELECT) ok 40 - SELECT b,c FROM a WHERE NOT c IN ('abc','klm','pqr','vwx','yz') ok 41 - $stmt->execute "SELECT b,c FROM a WHERE NOT b IN (2,3,5,7)" (SELECT) ok 42 - SELECT b,c FROM a WHERE NOT b IN (2,3,5,7) ok 43 - $stmt->execute "SELECT b,c FROM a WHERE c BETWEEN ('abc','nmo')" (SELECT) ok 44 - SELECT b,c FROM a WHERE c BETWEEN ('abc','nmo') ok 45 - $stmt->execute "SELECT b,c FROM a WHERE c IN ('abc','klm','pqr','vwx','yz')" (SELECT) ok 46 - SELECT b,c FROM a WHERE c IN ('abc','klm','pqr','vwx','yz') ok 47 - $stmt->execute "SELECT b,c FROM a WHERE b NOT BETWEEN (5,7)" (SELECT) ok 48 - SELECT b,c FROM a WHERE b NOT BETWEEN (5,7) ok 49 - $stmt->execute "SELECT b,c FROM a WHERE c NOT BETWEEN ('abc','nmo')" (SELECT) ok 50 - SELECT b,c FROM a WHERE c NOT BETWEEN ('abc','nmo') ok 51 - $stmt->execute "SELECT b,c FROM a WHERE NOT b BETWEEN (5,7)" (SELECT) ok 52 - SELECT b,c FROM a WHERE NOT b BETWEEN (5,7) ok 53 - $stmt->execute "SELECT b,c FROM a WHERE b BETWEEN (5,7)" (SELECT) ok 54 - SELECT b,c FROM a WHERE b BETWEEN (5,7) ok 55 - $stmt->execute "SELECT b,c FROM a WHERE NOT c BETWEEN ('abc','nmo')" (SELECT) ok 56 - SELECT b,c FROM a WHERE NOT c BETWEEN ('abc','nmo') ok 57 - $stmt->execute "SELECT b,c FROM a WHERE b NOT IN (2,3,5,7)" (SELECT) ok 58 - SELECT b,c FROM a WHERE b NOT IN (2,3,5,7) ok 59 - $stmt->execute "SELECT b,c FROM a WHERE c NOT IN ('abc','klm','pqr','vwx','yz')" (SELECT) ok 60 - SELECT b,c FROM a WHERE c NOT IN ('abc','klm','pqr','vwx','yz') ok 61 - $stmt->execute "SELECT b,c FROM a WHERE b IN (2,3,5,7)" (SELECT) ok 62 - SELECT b,c FROM a WHERE b IN (2,3,5,7) ok 63 - CREATE FUNCTION from module ok 64 - CREATE FUNCTION from module with argument ok 65 - LOAD FUNCTIONS ok 66 - CREATE pauli test table ok 67 - UPDATE with placeholders ok 68 - UPDATE with placeholder updates correct 1..68 ok overload arg '..' is invalid at C:/cpanfly-5.16/var/megalib/Math/BigInt.pm line 153. t/03import.t ....... # DBI object version 1.625 does not match $DBI::VERSION 1.627 at C:/Perl-5.16/lib/DynaLoader.pm line 214. # BEGIN failed--compilation aborted at C:/cpanfly-5.16/var/megalib/DBI.pm line 278. # Compilation failed in require at C:/cpanfly-5.16/var/megalib/DBD/File.pm line 27. # BEGIN failed--compilation aborted at C:/cpanfly-5.16/var/megalib/DBD/File.pm line 27. # Compilation failed in require at C:/cpanfly-5.16/var/megalib/DBD/CSV.pm line 15. # Compilation failed in require at t/TestLib.pm line 42. # Attempt to reload DBD/File.pm aborted. # Compilation failed in require at (eval 33) line 2. # ...propagated at C:/cpanfly-5.16/var/megalib/base.pm line 84. # BEGIN failed--compilation aborted at C:/cpanfly-5.16/var/megalib/DBD/DBM.pm line 25. # Compilation failed in require at t/TestLib.pm line 42. # Attempt to reload DBD/File.pm aborted. # Compilation failed in require at t/TestLib.pm line 42. # Attempt to reload DBI.pm aborted. # Compilation failed in require at t/TestLib.pm line 42. # Attempt to reload DBI.pm aborted. # Compilation failed in require at C:/Perl-5.16/lib/DBD/SQLite.pm line 5. # BEGIN failed--compilation aborted at C:/Perl-5.16/lib/DBD/SQLite.pm line 5. # Compilation failed in require at t/TestLib.pm line 42. # # Using required: # # SQL::Statement: 1.404 # # Using recommended: # # MLDBM: 2.04 # Running tests for SQL::Statement ok 1 - IMPORT($AoA) ok 2 - IMPORT($AoH) ok 3 # skip Need DBI statement handle - can't use when executing direct ok 4 # skip Need DBI statement handle - can't use when executing direct ok 5 # skip Need DBI statement handle - can't use when executing direct ok 6 # skip Need DBI statement handle - can't use when executing direct ok 7 # skip Need DBI statement handle - can't use when executing direct ok 8 # skip Need DBI statement handle - can't use when executing direct ok 9 # skip Need DBI statement handle - can't use when executing direct ok 10 # skip No external usable data source installed ok 11 # skip No external usable data source installed 1..11 ok overload arg '..' is invalid at C:/cpanfly-5.16/var/megalib/Math/BigInt.pm line 153. t/04idents.t ....... # DBI object version 1.625 does not match $DBI::VERSION 1.627 at C:/Perl-5.16/lib/DynaLoader.pm line 214. # BEGIN failed--compilation aborted at C:/cpanfly-5.16/var/megalib/DBI.pm line 278. # Compilation failed in require at C:/cpanfly-5.16/var/megalib/DBD/File.pm line 27. # BEGIN failed--compilation aborted at C:/cpanfly-5.16/var/megalib/DBD/File.pm line 27. # Compilation failed in require at C:/cpanfly-5.16/var/megalib/DBD/CSV.pm line 15. # Compilation failed in require at t/TestLib.pm line 42. # Attempt to reload DBI.pm aborted. # Compilation failed in require at t/TestLib.pm line 42. # Attempt to reload DBD/File.pm aborted. # Compilation failed in require at t/TestLib.pm line 42. # Attempt to reload DBD/File.pm aborted. # Compilation failed in require at (eval 31) line 2. # ...propagated at C:/cpanfly-5.16/var/megalib/base.pm line 84. # BEGIN failed--compilation aborted at C:/cpanfly-5.16/var/megalib/DBD/DBM.pm line 25. # Compilation failed in require at t/TestLib.pm line 42. # Attempt to reload DBI.pm aborted. # Compilation failed in require at C:/Perl-5.16/lib/DBD/SQLite.pm line 5. # BEGIN failed--compilation aborted at C:/Perl-5.16/lib/DBD/SQLite.pm line 5. # Compilation failed in require at t/TestLib.pm line 42. # # Using required: # # SQL::Statement: 1.404 # # Using recommended: # Running tests for SQL::Statement ok 1 - Column Names: select list = * ok 2 - Column Names: select list = named ok 3 - Column Names: select list = aliased ok 4 - Column Names: select list with function ok 5 - Column Names: select list with function = aliased ok 6 - Raw SQL hidden absent from column name [rt.cpan.org \#34121] (camelcased) ok 7 - Raw SQL hidden absent from table name [rt.cpan.org \#34121] (camelcased) ok 8 - Raw SQL hidden absent from column name [rt.cpan.org \#34121] (reserved names) ok 9 - Raw SQL hidden absent from table name [rt.cpan.org \#34121] (reserved names) ok 10 - Raw SQL hidden absent from column name [rt.cpan.org \#34121] (not quoted) ok 11 - Raw SQL hidden absent from table name [rt.cpan.org \#34121] (not quoted) ok 12 - ->{all_cols} structure does not grow beyond control ok 13 - execute for 'lower/lower' ok 14 - lower/lower ok 15 - execute for 'lower/upper' ok 16 - lower/upper ok 17 - execute for 'lower/mixed' ok 18 - lower/mixed ok 19 - execute for 'lower/asterisked' ok 20 - lower/asterisked ok 21 - execute for 'upper/lower' ok 22 - upper/lower ok 23 - execute for 'upper/upper' ok 24 - upper/upper ok 25 - execute for 'upper/mixed' ok 26 - upper/mixed ok 27 - execute for 'upper/asterisked' ok 28 - upper/asterisked ok 29 - execute for 'mixed/lower' ok 30 - mixed/lower ok 31 - execute for 'mixed/upper' ok 32 - mixed/upper ok 33 - execute for 'mixed/mixed' ok 34 - mixed/mixed ok 35 - execute for 'mixed/asterisked' ok 36 - mixed/asterisked ok 37 # skip No external usable data source installed 1..37 ok overload arg '..' is invalid at C:/cpanfly-5.16/var/megalib/Math/BigInt.pm line 153. t/05simple.t ....... # DBI object version 1.625 does not match $DBI::VERSION 1.627 at C:/Perl-5.16/lib/DynaLoader.pm line 214. # BEGIN failed--compilation aborted at C:/cpanfly-5.16/var/megalib/DBI.pm line 278. # Compilation failed in require at C:/cpanfly-5.16/var/megalib/DBD/File.pm line 27. # BEGIN failed--compilation aborted at C:/cpanfly-5.16/var/megalib/DBD/File.pm line 27. # Compilation failed in require at C:/cpanfly-5.16/var/megalib/DBD/CSV.pm line 15. # Compilation failed in require at t/TestLib.pm line 42. # Attempt to reload DBD/File.pm aborted. # Compilation failed in require at (eval 33) line 2. # ...propagated at C:/cpanfly-5.16/var/megalib/base.pm line 84. # BEGIN failed--compilation aborted at C:/cpanfly-5.16/var/megalib/DBD/DBM.pm line 25. # Compilation failed in require at t/TestLib.pm line 42. # Attempt to reload DBD/File.pm aborted. # Compilation failed in require at t/TestLib.pm line 42. # Attempt to reload DBI.pm aborted. # Compilation failed in require at t/TestLib.pm line 42. # # Using required: # # SQL::Statement: 1.404 # # Using recommended: # # MLDBM: 2.04 # Running tests for SQL::Statement ok 1 - prepare using 'SQL::Statement' ok 21 - execute using 'SQL::Statement' 2nd time ok 24 - execute using 'SQL::Statement' ok 30 - execute using 'SQL::Statement' 2nd time ok 33 - execute using 'SQL::Statement' ok 49 - execute using 'SQL::Statement' 2nd time ok 52 - execute using 'SQL::Statement' ok 67 - execute using 'SQL::Statement' 2nd time ok 70 - execute using 'SQL::Statement' ok 77 - execute == 1 using 'SQL::Statement' ok 79 - SELECT results for SELECT COUNT(*) FROM multi_fruit using SQL::Statement ok 80 - execute == 1 using 'SQL::Statement' ok 82 - SELECT results for SELECT COUNT(*) FROM multi_fruit using 'SQL::Statement' 2nd time ok 83 - prepare using 'SQL::Statement' ok 84 - execute using 'SQL::Statement' ok 85 - execute(DROP TABLE multi_fruit) == -1 using 'SQL::Statement' ok 86 - prepare using 'SQL::Statement' ok 87 - prepare using 'SQL::Statement' ok 97 - execute using 'SQL::Statement' 2nd time ok 100 - execute using 'SQL::Statement' ok 105 - execute using 'SQL::Statement' 2nd time ok 108 - execute using 'SQL::Statement' ok 113 - execute using 'SQL::Statement' 2nd time ok 116 - execute using 'SQL::Statement' ok 121 - execute using 'SQL::Statement' 2nd time ok 124 - execute using 'SQL::Statement' ok 129 - execute using 'SQL::Statement' 2nd time ok 132 - execute using 'SQL::Statement' ok 137 - execute using 'SQL::Statement' 2nd time ok 140 - execute using 'SQL::Statement' ok 145 - execute using 'SQL::Statement' 2nd time ok 148 - execute using 'SQL::Statement' ok 153 - execute using 'SQL::Statement' 2nd time ok 156 - execute