PATH=C:\PlatSDK\Bin\Win64\x86\AMD64;C:\PlatSDK\Bin;C:\PlatSDK\Bin\WinNT;C:\Perl64-5.12\site\bin;C:\Perl64-5.12\bin;C:\cygwin\bin;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\WINDOWS\system32\WindowsPowerShell\v1.0;C:\Program Files (x86)\Perforce;C:\instantclient_11_2;C:\cygwin\bin;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\WINDOWS\system32\WindowsPowerShell\v1.0;C:\Program Files (x86)\Perforce;C:\mysql\bin Start 2012-12-28T22:13:38 ActivePerl-1200 CPAN-1.9402 LIB=C:\PlatSDK\Lib\AMD64;C:\PlatSDK\Lib\AMD64\atlmfc INCLUDE=C:\PlatSDK\Include;C:\PlatSDK\Include\crt;C:\PlatSDK\Include\crt\sys;C:\PlatSDK\Include\mfc;C:\PlatSDK\Include\atl PATH=C:/CPANFL~1.12/var/libs/bin;C:\PlatSDK\Bin\Win64\x86\AMD64;C:\PlatSDK\Bin;C:\PlatSDK\Bin\WinNT;C:\Perl64-5.12\site\bin;C:\Perl64-5.12\bin;C:\cygwin\bin;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\WINDOWS\system32\WINDOW~1\v1.0;C:\PROGRA~2\Perforce;C:\INSTAN~1;C:\cygwin\bin;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\WINDOWS\system32\WINDOW~1\v1.0;C:\PROGRA~2\Perforce;C:\mysql\bin Going to read 'C:\cpanfly-5.12\var\cpan\Metadata' Database was generated on Sat, 29 Dec 2012 04:07:03 GMT Running make for R/RE/REHSACK/SQL-Statement-1.402.tar.gz Checksum for C:\cpanfly-5.12\var\cpan\sources\authors\id\R\RE\REHSACK\SQL-Statement-1.402.tar.gz ok SQL-Statement-1.402/ SQL-Statement-1.402/.aspell.local.pws SQL-Statement-1.402/Changes SQL-Statement-1.402/lib/ SQL-Statement-1.402/Makefile.PL SQL-Statement-1.402/MANIFEST SQL-Statement-1.402/MANIFEST.SKIP SQL-Statement-1.402/META.json SQL-Statement-1.402/META.yml SQL-Statement-1.402/README SQL-Statement-1.402/t/ SQL-Statement-1.402/xt/ SQL-Statement-1.402/xt/pod-cm.t SQL-Statement-1.402/xt/pod.t SQL-Statement-1.402/xt/pod_coverage.t SQL-Statement-1.402/t/00error.t SQL-Statement-1.402/t/01prepare.t SQL-Statement-1.402/t/02execute.t SQL-Statement-1.402/t/03import.t SQL-Statement-1.402/t/04idents.t SQL-Statement-1.402/t/05simple.t SQL-Statement-1.402/t/06virtual.t SQL-Statement-1.402/t/08join.t SQL-Statement-1.402/t/09ops.t SQL-Statement-1.402/t/10limit.t SQL-Statement-1.402/t/12eval.t SQL-Statement-1.402/t/17quoting.t SQL-Statement-1.402/t/23dialects.t SQL-Statement-1.402/t/SQLtest.pm SQL-Statement-1.402/t/TestLib.pm SQL-Statement-1.402/lib/SQL/ SQL-Statement-1.402/lib/SQL/Dialects/ SQL-Statement-1.402/lib/SQL/Eval.pm SQL-Statement-1.402/lib/SQL/Parser.pm SQL-Statement-1.402/lib/SQL/Statement/ SQL-Statement-1.402/lib/SQL/Statement.pm SQL-Statement-1.402/lib/SQL/Statement/Embed.pod SQL-Statement-1.402/lib/SQL/Statement/Function.pm SQL-Statement-1.402/lib/SQL/Statement/Functions.pm SQL-Statement-1.402/lib/SQL/Statement/GetInfo.pm SQL-Statement-1.402/lib/SQL/Statement/Operation.pm SQL-Statement-1.402/lib/SQL/Statement/Placeholder.pm SQL-Statement-1.402/lib/SQL/Statement/RAM.pm SQL-Statement-1.402/lib/SQL/Statement/Roadmap.pod SQL-Statement-1.402/lib/SQL/Statement/Structure.pod SQL-Statement-1.402/lib/SQL/Statement/Syntax.pod SQL-Statement-1.402/lib/SQL/Statement/Term.pm SQL-Statement-1.402/lib/SQL/Statement/TermFactory.pm SQL-Statement-1.402/lib/SQL/Statement/Util.pm SQL-Statement-1.402/lib/SQL/Dialects/ANSI.pm SQL-Statement-1.402/lib/SQL/Dialects/AnyData.pm SQL-Statement-1.402/lib/SQL/Dialects/CSV.pm SQL-Statement-1.402/lib/SQL/Dialects/Role.pm CPAN.pm: Going to build R/RE/REHSACK/SQL-Statement-1.402.tar.gz >>> C:\Perl64-5.12\bin\perl.exe Makefile.PL *** This version of SQL::Statement conflicts with the version of module DBD::AnyData (0.09) you have installed. It's strongly recommended that you update it after installing this version of SQL::Statement. *** *** This version of SQL::Statement conflicts with the version of module DBI (1.609) you have installed. It's strongly recommended that you update it after installing this version of SQL::Statement. *** 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.402.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:\Perl64-5.12\bin\perl.exe "-MExtUtils::Command::MM" "-e" "test_harness(1, 'blib\lib', 'blib\arch')" t/*.t xt/*.t # # Using required: # # SQL::Statement: 1.402 # # Using recommended: # # DBD::CSV: 0.3 t/00error.t ........ # DBI->VERSION() of 1.609 doesn't satisfy requirement of 1.616 # DBD::File->VERSION() of 0.37 doesn't satisfy requirement of 0.4 # DBD::DBM->VERSION() of 0.03 doesn't satisfy requirement of 0.06 # 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 # Running tests for DBD::CSV ok 8 - Parse "Junk" RaiseError=0 (default) ok 9 - Execute function succeeded ok 10 - Execute function no errstr ok 11 - Execute RaiseError=0 ok 12 - Parse "Junk" RaiseError=1 ok 13 - Execute RaiseError=1 ok 14 - Execute "SELECT * FROM nonexistant" has errstr 1..14 ok Can't call method "command" on an undefined value at t/TestLib.pm line 378. # Tests were run but no plan was declared and done_testing() was not seen. t/01prepare.t ...... # DBI->VERSION() of 1.609 doesn't satisfy requirement of 1.616 # DBD::File->VERSION() of 0.37 doesn't satisfy requirement of 0.4 # DBD::DBM->VERSION() of 0.03 doesn't satisfy requirement of 0.06 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(0x3c3e708),SQL::Statement::Table=HASH(0x41e9f38) # 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 ok 280 - parse ' /* DROP TABLE */' using DBD::CSV ok 281 - parse 'DROP TABLE foo' using DBD::CSV ok 282 - parse 'DROP TABLE foo CASCADE' using DBD::CSV ok 283 - parse 'DROP TABLE foo RESTRICT' using DBD::CSV ok 284 - parse ' /* DELETE */' using DBD::CSV ok 285 - parse 'DELETE FROM foo' using DBD::CSV ok 286 - parse 'DELETE FROM foo WHERE id < 7' using DBD::CSV ok 287 - parse ' /* UPDATE */' using DBD::CSV ok 288 - parse 'UPDATE foo SET bar = 7' using DBD::CSV ok 289 - parse 'UPDATE foo SET bar = 7 WHERE id > 7' using DBD::CSV ok 290 - parse ' /* INSERT */' using DBD::CSV ok 291 - parse 'INSERT INTO foo VALUES ( 'baz', 7, NULL )' using DBD::CSV ok 292 - parse 'INSERT INTO foo (col1,col2,col7) VALUES ( 'baz', 7, NULL )' using DBD::CSV ok 293 - parse ' /* CREATE TABLE */' using DBD::CSV ok 294 - parse 'CREATE TABLE foo ( id INT )' using DBD::CSV ok 295 - parse 'CREATE LOCAL TEMPORARY TABLE foo (id INT)' using DBD::CSV ok 296 - parse 'CREATE LOCAL TEMPORARY TABLE foo (id INT) ON COMMIT DELETE ROWS' using DBD::CSV ok 297 - parse 'CREATE LOCAL TEMPORARY TABLE foo (id INT) ON COMMIT PRESERVE ROWS' using DBD::CSV ok 298 - parse 'CREATE GLOBAL TEMPORARY TABLE foo (id INT)' using DBD::CSV ok 299 - parse 'CREATE GLOBAL TEMPORARY TABLE foo (id INT) ON COMMIT DELETE ROWS' using DBD::CSV ok 300 - parse 'CREATE GLOBAL TEMPORARY TABLE foo (id INT) ON COMMIT PRESERVE ROWS' using DBD::CSV ok 301 - parse 'CREATE TABLE foo ( id INTEGER, phrase VARCHAR(40) )' using DBD::CSV ok 302 - parse 'CREATE TABLE foo ( id INTEGER UNIQUE, phrase VARCHAR(40) UNIQUE )' using DBD::CSV ok 303 - parse 'CREATE TABLE foo ( id INTEGER PRIMARY KEY, phrase VARCHAR(40) UNIQUE )' using DBD::CSV ok 304 - parse 'CREATE TABLE foo ( id INTEGER PRIMARY KEY, phrase VARCHAR(40) NOT NULL )' using DBD::CSV ok 305 - parse 'CREATE TABLE foo ( id INTEGER NOT NULL, phrase VARCHAR(40) NOT NULL )' using DBD::CSV ok 306 - parse 'CREATE TABLE foo ( id INTEGER UNIQUE NOT NULL, phrase VARCHAR(40) )' using DBD::CSV ok 307 - parse 'CREATE TABLE foo ( phrase CHARACTER VARYING(255) )' using DBD::CSV ok 308 - parse 'CREATE TABLE foo ( phrase NUMERIC(4,6) )' using DBD::CSV ok 309 - 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 DBD::CSV ok 310 - parse 'CREATE TABLE foo ( id INTEGER, phrase VARCHAR(40), PRIMARY KEY ( "id" ), FOREIGN KEY ("id", "phrase") REFERENCES "bar" ("id2", "phrase2"))' using DBD::CSV ok 311 - 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 DBD::CSV ok 312 - parse ' /* JOINS */' using DBD::CSV ok 313 - parse 'SELECT Lnum,Llet,Ulet FROM zLower NATURAL INNER JOIN zUpper' using DBD::CSV ok 314 - parse 'SELECT Lnum,Llet,Ulet FROM zLower NATURAL LEFT JOIN zUpper' using DBD::CSV ok 315 - parse 'SELECT Lnum,Llet,Ulet FROM zLower NATURAL RIGHT JOIN zUpper' using DBD::CSV ok 316 - parse 'SELECT Lnum,Llet,Ulet FROM zLower NATURAL FULL JOIN zUpper' using DBD::CSV ok 317 - parse 'SELECT Lnum,Llet,Ulet FROM zLower INNER JOIN zUpper ON Lnum = Unum' using DBD::CSV ok 318 - parse 'SELECT Lnum,Llet,Ulet FROM zLower LEFT JOIN zUpper ON Lnum = Unum' using DBD::CSV ok 319 - parse 'SELECT Lnum,Llet,Ulet FROM zLower RIGHT JOIN zUpper ON Lnum = Unum' using DBD::CSV ok 320 - parse 'SELECT Lnum,Llet,Ulet FROM zLower FULL JOIN zUpper ON Lnum = Unum' using DBD::CSV ok 321 - parse 'SELECT Lnum,Llet,Ulet FROM zLower INNER JOIN zUpper USING(num)' using DBD::CSV ok 322 - parse 'SELECT Lnum,Llet,Ulet FROM zLower LEFT JOIN zUpper USING(num)' using DBD::CSV ok 323 - parse 'SELECT Lnum,Llet,Ulet FROM zLower RIGHT JOIN zUpper USING(num)' using DBD::CSV ok 324 - parse 'SELECT Lnum,Llet,Ulet FROM zLower FULL JOIN zUpper USING(num)' using DBD::CSV ok 325 - parse 'SELECT Lnum,Llet,Ulet FROM zLower,zUpper WHERE Lnum = Unum' using DBD::CSV ok 326 - parse 'SELECT * FROM zLower NATURAL INNER JOIN zUpper' using DBD::CSV ok 327 - parse 'SELECT * FROM zLower NATURAL LEFT JOIN zUpper' using DBD::CSV ok 328 - parse 'SELECT * FROM zLower NATURAL RIGHT JOIN zUpper' using DBD::CSV ok 329 - parse 'SELECT * FROM zLower NATURAL FULL JOIN zUpper' using DBD::CSV ok 330 - parse 'SELECT * FROM zLower INNER JOIN zUpper ON Lnum = Unum' using DBD::CSV ok 331 - parse 'SELECT * FROM zLower LEFT JOIN zUpper ON Lnum = Unum' using DBD::CSV ok 332 - parse 'SELECT * FROM zLower RIGHT JOIN zUpper ON Lnum = Unum' using DBD::CSV ok 333 - parse 'SELECT * FROM zLower FULL JOIN zUpper ON Lnum = Unum' using DBD::CSV ok 334 - parse 'SELECT * FROM zLower INNER JOIN zUpper USING(num)' using DBD::CSV ok 335 - parse 'SELECT * FROM zLower LEFT JOIN zUpper USING(num)' using DBD::CSV ok 336 - parse 'SELECT * FROM zLower RIGHT JOIN zUpper USING(num)' using DBD::CSV ok 337 - parse 'SELECT * FROM zLower FULL JOIN zUpper USING(num)' using DBD::CSV ok 338 - parse 'SELECT * FROM zLower,zUpper WHERE Lnum = Unum' using DBD::CSV ok 339 - parse ' /* SELECT COLUMNS */' using DBD::CSV ok 340 - parse 'SELECT id, phrase FROM foo' using DBD::CSV ok 341 - parse 'SELECT * FROM foo' using DBD::CSV ok 342 - parse 'SELECT DISTINCT * FROM foo' using DBD::CSV ok 343 - parse 'SELECT ALL * FROM foo' using DBD::CSV ok 344 - parse 'SELECT A.*,B.* FROM A,B WHERE A.id=B.id' using DBD::CSV ok 345 - parse ' /* SET FUNCTIONS */' using DBD::CSV ok 346 - parse 'SELECT MAX(foo) FROM bar' using DBD::CSV ok 347 - parse 'SELECT MIN(foo) FROM bar' using DBD::CSV ok 348 - parse 'SELECT AVG(foo) FROM bar' using DBD::CSV ok 349 - parse 'SELECT SUM(foo) FROM bar' using DBD::CSV ok 350 - parse 'SELECT COUNT(foo) FROM foo' using DBD::CSV ok 351 - parse 'SELECT COUNT(*) FROM foo' using DBD::CSV ok 352 - parse 'SELECT SUM(DISTINCT foo) FROM bar' using DBD::CSV ok 353 - parse 'SELECT SUM(ALL foo) FROM bar' using DBD::CSV ok 354 - parse ' /* ORDER BY */' using DBD::CSV ok 355 - parse 'SELECT * FROM foo ORDER BY bar' using DBD::CSV ok 356 - parse 'SELECT * FROM foo ORDER BY bar, baz' using DBD::CSV ok 357 - parse 'SELECT * FROM foo ORDER BY bar DESC' using DBD::CSV ok 358 - parse 'SELECT * FROM foo ORDER BY bar ASC' using DBD::CSV ok 359 - parse ' /* LIMIT */' using DBD::CSV ok 360 - parse 'SELECT * FROM foo LIMIT 5' using DBD::CSV ok 361 - parse 'SELECT * FROM foo LIMIT 0, 5' using DBD::CSV ok 362 - parse 'SELECT * FROM foo LIMIT 5, 10' using DBD::CSV ok 363 - parse '/* DATE/TIME FUNCTIONS */' using DBD::CSV ok 364 - parse 'SELECT CURRENT_DATE()' using DBD::CSV ok 365 - parse 'SELECT CURRENT_TIME()' using DBD::CSV ok 366 - parse 'SELECT CURRENT_TIMESTAMP()' using DBD::CSV ok 367 - parse 'SELECT CURDATE()' using DBD::CSV ok 368 - parse 'SELECT CURTIME()' using DBD::CSV ok 369 - parse 'SELECT NOW()' using DBD::CSV ok 370 - parse 'SELECT UNIX_TIMESTAMP() ' using DBD::CSV ok 371 - parse 'SELECT CURRENT_TIME(2)' using DBD::CSV ok 372 - parse 'SELECT CURRENT_TIMESTAMP(2)' using DBD::CSV ok 373 - parse 'SELECT CURTIME(2)' using DBD::CSV ok 374 - parse 'SELECT NOW(2)' using DBD::CSV ok 375 - parse 'SELECT UNIX_TIMESTAMP(2)' using DBD::CSV ok 376 - parse ' /* STRING FUNCTIONS */' using DBD::CSV ok 377 - parse 'SELECT * FROM foo WHERE ASCII(status) = 65' using DBD::CSV ok 378 - parse 'SELECT * FROM foo WHERE CHAR(code) = 'A'' using DBD::CSV ok 379 - parse 'SELECT * FROM foo WHERE CHAR(chr1,chr2,chr3) = 'ABC'' using DBD::CSV ok 380 - parse 'SELECT * FROM foo WHERE BIT_LENGTH(str) = 27' using DBD::CSV ok 381 - parse 'SELECT * FROM foo WHERE CHARACTER_LENGTH(str) = 6' using DBD::CSV ok 382 - parse 'SELECT * FROM foo WHERE CHAR_LENGTH(str) = 6' using DBD::CSV ok 383 - parse 'SELECT * FROM foo WHERE COALESCE(NULL, status) = 'bar'' using DBD::CSV ok 384 - parse 'SELECT * FROM foo WHERE NVL(NULL, status) = 'bar'' using DBD::CSV ok 385 - parse 'SELECT * FROM foo WHERE IFNULL(NULL, status) = 'bar'' using DBD::CSV ok 386 - parse 'SELECT * FROM foo WHERE CONCAT(str1, str2) = 'bar'' using DBD::CSV ok 387 - parse 'SELECT * FROM foo WHERE DECODE(color,'White','W','Red','R','B') = 'W'' using DBD::CSV ok 388 - parse 'SELECT * FROM foo WHERE INSERT(str1, 4, 5, str2) = 'foobarland'' using DBD::CSV ok 389 - parse 'SELECT * FROM foo WHERE LEFT(phrase) = 'bar'' using DBD::CSV ok 390 - parse 'SELECT * FROM foo WHERE RIGHT(phrase) = 'bar'' using DBD::CSV ok 391 - parse 'SELECT * FROM foo WHERE LOCATE(str1, str2) = 2' using DBD::CSV ok 392 - parse 'SELECT * FROM foo WHERE LOCATE(str1, str2, 3) = 5' using DBD::CSV ok 393 - parse 'SELECT * FROM foo WHERE POSITION(str1, str2) = 2' using DBD::CSV ok 394 - parse 'SELECT * FROM foo WHERE POSITION(str1, str2, 3) = 5' using DBD::CSV ok 395 - parse 'SELECT * FROM foo WHERE LOWER(phrase) = 'bar'' using DBD::CSV ok 396 - parse 'SELECT * FROM foo WHERE UPPER(phrase) = 'BAR'' using DBD::CSV ok 397 - parse 'SELECT * FROM foo WHERE LCASE(phrase) = 'BAR'' using DBD::CSV ok 398 - parse 'SELECT * FROM foo WHERE UCASE(phrase) = 'bar'' using DBD::CSV ok 399 - parse 'SELECT * FROM foo WHERE LTRIM(str) = 'bar'' using DBD::CSV ok 400 - parse 'SELECT * FROM foo WHERE RTRIM(str) = 'bar'' using DBD::CSV ok 401 - parse 'SELECT * FROM foo WHERE OCTET_LENGTH(str) = 12' using DBD::CSV ok 402 - parse 'SELECT * FROM foo WHERE REGEX(phrase, '/EF/i') = TRUE' using DBD::CSV ok 403 - parse 'SELECT * FROM foo WHERE REPEAT(status, 3) = 'AAA'' using DBD::CSV ok 404 - parse 'SELECT * FROM foo WHERE REPLACE(phrase, 's/z(.+)ky//i') = 'bar'' using DBD::CSV ok 405 - parse 'SELECT * FROM foo WHERE SUBSTITUTE(phrase, 's/z(.+)ky//i') = 'bar'' using DBD::CSV ok 406 - parse 'SELECT * FROM foo WHERE SOUNDEX(name1, name2) = TRUE' using DBD::CSV ok 407 - parse 'SELECT * FROM foo WHERE SPACE(num) = ' '' using DBD::CSV ok 408 - parse 'SELECT * FROM foo WHERE blat = SUBSTRING(bar FROM 3 FOR 6)' using DBD::CSV ok 409 - parse 'SELECT * FROM foo WHERE blat = SUBSTRING(bar FROM 3)' using DBD::CSV ok 410 - parse 'SELECT * FROM foo WHERE blat = SUBSTR(bar, 3, 6)' using DBD::CSV ok 411 - parse 'SELECT * FROM foo WHERE blat = SUBSTR(bar, 3)' using DBD::CSV ok 412 - parse 'SELECT * FROM foo WHERE blat = TRANSLATE(bar, set1, set2)' using DBD::CSV ok 413 - parse 'SELECT * FROM foo WHERE TRIM( str ) = 'bar'' using DBD::CSV ok 414 - parse 'SELECT * FROM foo WHERE TRIM( LEADING FROM str ) = 'bar'' using DBD::CSV ok 415 - parse 'SELECT * FROM foo WHERE TRIM( TRAILING FROM str ) = 'bar'' using DBD::CSV ok 416 - parse 'SELECT * FROM foo WHERE TRIM( BOTH FROM str ) = 'bar'' using DBD::CSV ok 417 - parse 'SELECT * FROM foo WHERE TRIM( LEADING ';' FROM str ) = 'bar'' using DBD::CSV ok 418 - parse 'SELECT * FROM foo WHERE TRIM( UPPER(phrase) ) = 'bar'' using DBD::CSV ok 419 - parse 'SELECT * FROM foo WHERE TRIM( LOWER(phrase) ) = 'bar'' using DBD::CSV ok 420 - parse 'UPDATE foo SET bar='baz', bop=7, bump=bar+8, blat=SUBSTRING(bar FROM 3 FOR 6)' using DBD::CSV ok 421 - parse ' /* NUMERIC FUNCTIONS */' using DBD::CSV ok 422 - parse 'SELECT * FROM bar WHERE ABS(-4) = 4' using DBD::CSV ok 423 - parse 'SELECT * FROM bar WHERE CEILING(-4.5) = -4' using DBD::CSV ok 424 - parse 'SELECT * FROM bar WHERE CEIL(-4.9) = -4' using DBD::CSV ok 425 - parse 'SELECT * FROM bar WHERE FLOOR(4.999999999999) = 4' using DBD::CSV ok 426 - parse 'SELECT * FROM bar WHERE LOG(6) = LOG10(6)' using DBD::CSV ok 427 - parse 'SELECT * FROM bar WHERE LN(1) = EXP(1)' using DBD::CSV ok 428 - parse 'SELECT * FROM bar WHERE MOD(8, 5) = 3' using DBD::CSV ok 429 - parse 'SELECT * FROM bar WHERE POWER(2, 4) = 16' using DBD::CSV ok 430 - parse 'SELECT * FROM bar WHERE POW(2, 4) = 16' using DBD::CSV ok 431 - parse 'SELECT * FROM bar WHERE RAND(2) = 0' using DBD::CSV ok 432 - parse 'SELECT * FROM bar WHERE RAND(2, UNIX_TIMESTAMP()) = 0' using DBD::CSV ok 433 - parse 'SELECT * FROM bar WHERE ROUND(4.999999999999) = 5' using DBD::CSV ok 434 - parse 'SELECT * FROM bar WHERE ROUND(4.542222222222, 1) = 4.5' using DBD::CSV ok 435 - parse 'SELECT * FROM bar WHERE SIGN(-25.5) = -1' using DBD::CSV ok 436 - parse 'SELECT * FROM bar WHERE SIGN(53645) = 1' using DBD::CSV ok 437 - parse 'SELECT * FROM bar WHERE SIGN(0) = 0' using DBD::CSV ok 438 - parse 'SELECT * FROM bar WHERE SIGN(NULL) = NULL' using DBD::CSV ok 439 - parse 'SELECT * FROM bar WHERE SQRT(64) = 8' using DBD::CSV ok 440 - parse 'SELECT * FROM bar WHERE TRUNCATE(4.999999999999) = 4' using DBD::CSV ok 441 - parse 'SELECT * FROM bar WHERE TRUNC(-4.9) = -4' using DBD::CSV ok 442 - parse 'SELECT * FROM bar WHERE TRUNCATE(4.934, 1) = 4.9' using DBD::CSV ok 443 - parse 'SELECT * FROM bar WHERE TRUNC(-4.99999, 1) = -4.9' using DBD::CSV ok 444 - parse ' /* TRIGONOMETRIC FUNCTIONS */' using DBD::CSV ok 445 - parse 'SELECT * FROM test WHERE ACOS(x)' using DBD::CSV ok 446 - parse 'SELECT * FROM test WHERE ACOSEC(x)' using DBD::CSV ok 447 - parse 'SELECT * FROM test WHERE ACOSECH(x)' using DBD::CSV ok 448 - parse 'SELECT * FROM test WHERE ACOSH(x)' using DBD::CSV ok 449 - parse 'SELECT * FROM test WHERE ACOT(x)' using DBD::CSV ok 450 - parse 'SELECT * FROM test WHERE ACOTAN(x)' using DBD::CSV ok 451 - parse 'SELECT * FROM test WHERE ACOTANH(x)' using DBD::CSV ok 452 - parse 'SELECT * FROM test WHERE ACOTH(x)' using DBD::CSV ok 453 - parse 'SELECT * FROM test WHERE ACSC(x)' using DBD::CSV ok 454 - parse 'SELECT * FROM test WHERE ACSCH(x)' using DBD::CSV ok 455 - parse 'SELECT * FROM test WHERE ASEC(x)' using DBD::CSV ok 456 - parse 'SELECT * FROM test WHERE ASECH(x)' using DBD::CSV ok 457 - parse 'SELECT * FROM test WHERE ASIN(x)' using DBD::CSV ok 458 - parse 'SELECT * FROM test WHERE ASINH(x)' using DBD::CSV ok 459 - parse 'SELECT * FROM test WHERE ATAN(x)' using DBD::CSV ok 460 - parse 'SELECT * FROM test WHERE ATAN2(y, x)' using DBD::CSV ok 461 - parse 'SELECT * FROM test WHERE ATANH(x)' using DBD::CSV ok 462 - parse 'SELECT * FROM test WHERE COS(x)' using DBD::CSV ok 463 - parse 'SELECT * FROM test WHERE COSEC(x)' using DBD::CSV ok 464 - parse 'SELECT * FROM test WHERE COSECH(x)' using DBD::CSV ok 465 - parse 'SELECT * FROM test WHERE COSH(x)' using DBD::CSV ok 466 - parse 'SELECT * FROM test WHERE COT(x)' using DBD::CSV ok 467 - parse 'SELECT * FROM test WHERE COTAN(x)' using DBD::CSV ok 468 - parse 'SELECT * FROM test WHERE COTANH(x)' using DBD::CSV ok 469 - parse 'SELECT * FROM test WHERE COTH(x)' using DBD::CSV ok 470 - parse 'SELECT * FROM test WHERE CSC(x)' using DBD::CSV ok 471 - parse 'SELECT * FROM test WHERE CSCH(x)' using DBD::CSV ok 472 - parse 'SELECT * FROM test WHERE DEG2DEG(deg)' using DBD::CSV ok 473 - parse 'SELECT * FROM test WHERE RAD2RAD(rad)' using DBD::CSV ok 474 - parse 'SELECT * FROM test WHERE GRAD2GRAD(grad)' using DBD::CSV ok 475 - parse 'SELECT * FROM test WHERE DEG2GRAD(deg)' using DBD::CSV ok 476 - parse 'SELECT * FROM test WHERE DEG2RAD(deg)' using DBD::CSV ok 477 - parse 'SELECT * FROM test WHERE GRAD2DEG(grad)' using DBD::CSV ok 478 - parse 'SELECT * FROM test WHERE GRAD2RAD(grad)' using DBD::CSV ok 479 - parse 'SELECT * FROM test WHERE RAD2DEG(rad)' using DBD::CSV ok 480 - parse 'SELECT * FROM test WHERE RAD2GRAD(rad)' using DBD::CSV ok 481 - parse 'SELECT * FROM test WHERE DEGREES(rad)' using DBD::CSV ok 482 - parse 'SELECT * FROM test WHERE RADIANS(deg)' using DBD::CSV ok 483 - parse 'SELECT * FROM test WHERE DEG2DEG(deg, TRUE)' using DBD::CSV ok 484 - parse 'SELECT * FROM test WHERE RAD2RAD(rad, TRUE)' using DBD::CSV ok 485 - parse 'SELECT * FROM test WHERE GRAD2GRAD(grad, TRUE)' using DBD::CSV ok 486 - parse 'SELECT * FROM test WHERE DEG2GRAD(deg, TRUE)' using DBD::CSV ok 487 - parse 'SELECT * FROM test WHERE DEG2RAD(deg, TRUE)' using DBD::CSV ok 488 - parse 'SELECT * FROM test WHERE GRAD2DEG(grad, TRUE)' using DBD::CSV ok 489 - parse 'SELECT * FROM test WHERE GRAD2RAD(grad, TRUE)' using DBD::CSV ok 490 - parse 'SELECT * FROM test WHERE RAD2DEG(rad, TRUE)' using DBD::CSV ok 491 - parse 'SELECT * FROM test WHERE RAD2GRAD(rad, TRUE)' using DBD::CSV ok 492 - parse 'SELECT * FROM test WHERE DEGREES(rad, TRUE)' using DBD::CSV ok 493 - parse 'SELECT * FROM test WHERE RADIANS(deg, TRUE)' using DBD::CSV ok 494 - parse 'SELECT * FROM test WHERE PI()' using DBD::CSV ok 495 - parse 'SELECT * FROM test WHERE SEC(x)' using DBD::CSV ok 496 - parse 'SELECT * FROM test WHERE SECH(x)' using DBD::CSV ok 497 - parse 'SELECT * FROM test WHERE SIN(x)' using DBD::CSV ok 498 - parse 'SELECT * FROM test WHERE SINH(x)' using DBD::CSV ok 499 - parse 'SELECT * FROM test WHERE TAN(x)' using DBD::CSV ok 500 - parse 'SELECT * FROM test WHERE TANH(x)' using DBD::CSV ok 501 - parse ' /* SYSTEM FUNCTIONS */' using DBD::CSV ok 502 - parse 'SELECT * FROM ztable WHERE DBNAME() = foobar' using DBD::CSV ok 503 - parse 'SELECT * FROM ztable WHERE USERNAME() = foobar' using DBD::CSV ok 504 - parse 'SELECT * FROM ztable WHERE USER() = foobar' using DBD::CSV ok 505 - parse ' /* TABLE NAME ALIASES */' using DBD::CSV ok 506 - parse 'SELECT * FROM test as T1' using DBD::CSV ok 507 - parse 'SELECT * FROM test T1' using DBD::CSV ok 508 - parse 'SELECT T1.id, T2.num FROM test as T1 JOIN test2 as T2 USING(id)' using DBD::CSV ok 509 - parse 'SELECT id FROM test as T1 WHERE T1.num < 7' using DBD::CSV ok 510 - parse 'SELECT id FROM test as T1 ORDER BY T1.num' using DBD::CSV ok 511 - parse 'SELECT a.x,b.y FROM foo AS a, bar b WHERE a.baz = b.bop ORDER BY a.blat' using DBD::CSV ok 512 - parse ' /* NUMERIC EXPRESSIONS */' using DBD::CSV ok 513 - parse 'SELECT * FROM foo WHERE 1 = 0 AND baz < (6*foo+11-r)' using DBD::CSV ok 514 - parse ' /* CASE OF IDENTIFIERS */' using DBD::CSV ok 515 - parse 'SELECT ID, phRase FROM tEst AS tE WHERE te.id < 3 ORDER BY TE.phrasE' using DBD::CSV ok 516 - parse ' /* PARENS */' using DBD::CSV ok 517 - parse 'SELECT * FROM ztable WHERE NOT data IN ('one','two')' using DBD::CSV ok 518 - parse 'SELECT * from ztable WHERE (aaa > 'AAA')' using DBD::CSV ok 519 - parse 'SELECT * from ztable WHERE sev = 50 OR sev = 60' using DBD::CSV ok 520 - parse 'SELECT * from ztable WHERE (sev = 50 OR sev = 60)' using DBD::CSV ok 521 - parse 'SELECT * from ztable WHERE sev IN (50,60)' using DBD::CSV ok 522 - parse 'SELECT * from ztable WHERE rc > 200 AND ( sev IN(50,60) )' using DBD::CSV ok 523 - parse 'SELECT * FROM ztable WHERE data NOT IN ('one','two')' using DBD::CSV ok 524 - parse 'SELECT * from ztable WHERE (aaa > 'AAA') AND (zzz < 'ZZZ')' using DBD::CSV ok 525 - parse 'SELECT * from ztable WHERE (sev IN(50,60))' using DBD::CSV ok 526 - parse ' /* NOT */' using DBD::CSV ok 527 - parse 'SELECT * FROM foo WHERE NOT bar = 'baz' AND bop = 7 OR NOT blat = bar' using DBD::CSV ok 528 - parse 'SELECT * FROM foo WHERE NOT bar = 'baz' AND NOT bop = 7 OR NOT blat = bar' using DBD::CSV ok 529 - parse 'SELECT * FROM foo WHERE NOT bar = 'baz' AND NOT bop = 7 OR blat IS NOT NULL' using DBD::CSV ok 530 - parse ' /* IN */' using DBD::CSV ok 531 - parse 'SELECT * FROM bar WHERE foo IN ('aa','ab','ba','bb')' using DBD::CSV ok 532 - parse 'SELECT * FROM bar WHERE foo IN (3.14,2.72,1.41,9.81)' using DBD::CSV ok 533 - parse 'SELECT * FROM bar WHERE foo NOT IN ('aa','ab','ba','bb')' using DBD::CSV ok 534 - parse 'SELECT * FROM bar WHERE foo NOT IN (3.14,2.72,1.41,9.81)' using DBD::CSV ok 535 - parse ' /* BETWEEN */' using DBD::CSV ok 536 - parse 'SELECT * FROM bar WHERE foo BETWEEN ('aa','bb')' using DBD::CSV ok 537 - parse 'SELECT * FROM bar WHERE foo BETWEEN (1.41,9.81)' using DBD::CSV ok 538 - parse 'SELECT * FROM bar WHERE foo NOT BETWEEN ('aa','bb')' using DBD::CSV ok 539 - parse 'SELECT * FROM bar WHERE foo NOT BETWEEN (1.41,9.81)' using DBD::CSV ok 540 - 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 DBD::CSV # TODO Analyze failures ok 541 - parse 'SELECT * FROM bar WHERE EXP(1) = SINH(1)+COSH(1)' using DBD::CSV # TODO Analyze failures ok 542 - parse 'SELECT * FROM bar WHERE LOG(8, 2) = LOG10(8) / LOG10(2)' using DBD::CSV # TODO Analyze failures ok 543 - $sth->new Dubious, test returned 255 (wstat 65280, 0xff00) All 543 subtests passed (3 TODO tests unexpectedly succeeded) Can't call method "command" on an undefined value at t/TestLib.pm line 378. # Tests were run but no plan was declared and done_testing() was not seen. t/02execute.t ...... # DBD::DBM->VERSION() of 0.03 doesn't satisfy requirement of 0.06 # DBD::File->VERSION() of 0.37 doesn't satisfy requirement of 0.4 # DBI->VERSION() of 1.609 doesn't satisfy requirement of 1.616 # # Using required: # # SQL::Statement: 1.402 # # Using recommended: # # DBD::CSV: 0.3 # # 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 # Running tests for DBD::CSV ok 69 - CREATE Tmp ok 70 - placeholder insert with named cols ok 71 - placeholder insert without named cols ok 72 - placeholder delete ok 73 - placeholder update ok 74 - placeholder update ok 75 - multiline insert ok 76 - prepare 'SELECT id,phrase FROM Tmp ORDER BY id' ok 77 - verify table contents ok 78 - DROP TABLE Dubious, test returned 25 (wstat 6400, 0x1900) All 78 subtests passed # Failed test 'SELECT FROM IMPORTED($AoH)' # at t/03import.t line 115. # got: '' # expected: '1 9^2 8^' # Failed test 'SELECT FROM IMPORTED($AoA)' # at t/03import.t line 123. # got: '' # expected: 'Just^Another^Perl^Hacker^' # Failed test 'SELECT FROM "SELECTED(*)" tbl_copy' # at t/03import.t line 131. # got: '' # expected: '1 Hacker^2 Perl^3 Another^4 Just^' # Failed test 'SELECT FROM "SELECTED(*)" tbl_extract' # at t/03import.t line 139. # got: '' # expected: '1 Hacker^' # Failed test 'SELECT FROM IMPORTED ($external_sth)' # at t/03import.t line 190. # got: '' # expected: '1 foo^' # Looks like you failed 5 tests of 26. t/03import.t ....... # DBD::DBM->VERSION() of 0.03 doesn't satisfy requirement of 0.06 # DBD::File->VERSION() of 0.37 doesn't satisfy requirement of 0.4 # DBI->VERSION() of 1.609 doesn't satisfy requirement of 1.616 # # Using required: # # SQL::Statement: 1.402 # # Using recommended: # # DBD::CSV: 0.3 # # DBD::SQLite: 1.29 # # 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 - SELECT IMPORT($external_sth) ok 11 # skip Need DBI statement handle - can't use when executing direct ok 12 # skip Need DBI statement handle - can't use when executing direct # Running tests for DBD::CSV ok 13 - IMPORT($AoA) ok 14 - IMPORT($AoH) ok 15 - CREATE AS IMPORT($aoh) not ok 16 - SELECT FROM IMPORTED($AoH) ok 17 - CREATE AS IMPORT($aoa) not ok 18 - SELECT FROM IMPORTED($AoA) ok 19 - CREATE AS SELECT * not ok 20 - SELECT FROM "SELECTED(*)" tbl_copy ok 21 - CREATE AS SELECT * with quoted restriction not ok 22 - SELECT FROM "SELECTED(*)" tbl_extract ok 23 - IMPORT($internal_sth) ok 24 - SELECT IMPORT($external_sth) ok 25 - CREATE AS IMPORT($sth) not ok 26 - SELECT FROM IMPORTED ($external_sth) 1..26 Dubious, test returned 5 (wstat 1280, 0x500) Failed 5/26 subtests (less 9 skipped subtests: 12 okay) # Failed test 'Raw SQL hidden absent from column name [rt.cpan.org \#34121] (camelcased)' # at t/04idents.t line 133. # Structures begin differing at: # $got = undef # $expected = ARRAY(0x423a288) Can't call method "tables" on an undefined value at t/TestLib.pm line 424. # Tests were run but no plan was declared and done_testing() was not seen. t/04idents.t ....... # DBI->VERSION() of 1.609 doesn't satisfy requirement of 1.616 # DBD::File->VERSION() of 0.37 doesn't satisfy requirement of 0.4 # DBD::DBM->VERSION() of 0.03 doesn't satisfy requirement of 0.06 # # Using required: # # SQL::Statement: 1.402 # # Using recommended: # # DBD::CSV: 0.3 # # DBD::SQLite: 1.29 # 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 Need DBI statement handle - can't use when executing direct # Running tests for DBD::CSV ok 38 - Column Names: select list = * ok 39 - Column Names: select list = named ok 40 - Column Names: select list = aliased ok 41 - Column Names: select list with function ok 42 - Column Names: select list with function = aliased not ok 43 - Raw SQL hidden absent from column name [rt.cpan.org \#34121] (camelcased) Dubious, test returned 2 (wstat 512, 0x200) Failed 1/43 subtests (less 1 skipped subtest: 41 okay) Can't call method "command" on an undefined value at t/TestLib.pm line 378. # Tests were run but no plan was declared and done_testing() was not seen. t/05simple.t ....... # DBD::DBM->VERSION() of 0.03 doesn't satisfy requirement of 0.06 # DBD::File->VERSION() of 0.37 doesn't satisfy requirement of 0.4 # DBI->VERSION() of 1.609 doesn't satisfy requirement of 1.616 # # Using required: # # SQL::Statement: 1.402 # # Using recommended: # # DBD::CSV: 0.3 # # 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 using 'DBD::CSV' ok 162 - prepare using 'DBD::CSV' ok 163 - execute using 'DBD::CSV' ok 164 - execute(DROP TABLE IF EXISTS multi_fruit) == -1 using 'DBD::CSV' ok 165 - prepare using 'DBD::CSV' ok 166 - execute using 'DBD::CSV' ok 167 - execute(CREATE TABLE multi_fruit (dKey INT, dVal VARCHAR(10), qux INT)) == 0E0 using 'DBD::CSV' ok 168 - prepare using 'DBD::CSV' ok 169 - execute using 'DBD::CSV' ok 170 - execute(INSERT INTO multi_fruit VALUES (1,'oranges' , 11 )) == 1 using 'DBD::CSV' ok 171 - prepare using 'DBD::CSV' ok 172 - execute using 'DBD::CSV' ok 173 - execute(INSERT INTO multi_fruit VALUES (2,'to_change', 0 )) == 1 using 'DBD::CSV' ok 174 - prepare using 'DBD::CSV' ok 175 - execute using 'DBD::CSV' ok 176 - execute(INSERT INTO multi_fruit VALUES (3, NULL , 13 )) == 1 using 'DBD::CSV' ok 177 - prepare using 'DBD::CSV' ok 178 - execute using 'DBD::CSV' ok 179 - execute(INSERT INTO multi_fruit VALUES (4,'to_delete', 14 )) == 1 using 'DBD::CSV' ok 180 - execute == 4 using 'DBD::CSV' ok 182 - SELECT results for SELECT * FROM multi_fruit ORDER BY dKey DESC using DBD::CSV ok 183 - execute == 4 using 'DBD::CSV' ok 185 - SELECT results for SELECT * FROM multi_fruit ORDER BY dKey DESC using 'DBD::CSV' 2nd time ok 186 - prepare using 'DBD::CSV' ok 187 - execute using 'DBD::CSV' ok 188 - execute(INSERT INTO multi_fruit VALUES (?,?,?)) == 1 using 'DBD::CSV' ok 189 - execute == 5 using 'DBD::CSV' ok 191 - SELECT results for SELECT * FROM multi_fruit ORDER BY dKey DESC using DBD::CSV ok 192 - execute == 5 using 'DBD::CSV' ok 194 - SELECT results for SELECT * FROM multi_fruit ORDER BY dKey DESC using 'DBD::CSV' 2nd time ok 195 - prepare using 'DBD::CSV' ok 196 - execute using 'DBD::CSV' ok 197 - execute(INSERT INTO multi_fruit VALUES (6,'to_delete', 16 )) == 1 using 'DBD::CSV' ok 198 - prepare using 'DBD::CSV' ok 199 - execute using 'DBD::CSV' ok 200 - execute(INSERT INTO multi_fruit VALUES (7,'to delete', 17 )) == 1 using 'DBD::CSV' ok 201 - prepare using 'DBD::CSV' ok 202 - execute using 'DBD::CSV' ok 203 - execute(INSERT INTO multi_fruit VALUES (8,'to remove', 18 )) == 1 using 'DBD::CSV' ok 204 - prepare using 'DBD::CSV' ok 205 - execute using 'DBD::CSV' ok 206 - execute(UPDATE multi_fruit SET dVal='apples', qux='12' WHERE dKey=2) == 1 using 'DBD::CSV' ok 207 - $sth->execute(UPDATE multi_fruit SET dVal='apples', qux='12' WHERE dKey=2) == $sth->rows using DBD::CSV ok 208 - execute == 8 using 'DBD::CSV' ok 210 - SELECT results for SELECT * FROM multi_fruit ORDER BY dKey DESC using DBD::CSV ok 211 - execute == 8 using 'DBD::CSV' ok 213 - SELECT results for SELECT * FROM multi_fruit ORDER BY dKey DESC using 'DBD::CSV' 2nd time ok 214 - prepare using 'DBD::CSV' ok 215 - execute using 'DBD::CSV' ok 216 - execute(DELETE FROM multi_fruit WHERE dVal='to_delete') == 2 using 'DBD::CSV' ok 217 - $sth->execute(DELETE FROM multi_fruit WHERE dVal='to_delete') == $sth->rows using DBD::CSV ok 218 - prepare using 'DBD::CSV' ok 219 - execute using 'DBD::CSV' ok 220 - execute(DELETE FROM multi_fruit WHERE qux=17) == 1 using 'DBD::CSV' ok 221 - $sth->execute(DELETE FROM multi_fruit WHERE qux=17) == $sth->rows using DBD::CSV ok 222 - prepare using 'DBD::CSV' ok 223 - execute using 'DBD::CSV' ok 224 - execute(DELETE FROM multi_fruit WHERE dKey=8) == 1 using 'DBD::CSV' ok 225 - $sth->execute(DELETE FROM multi_fruit WHERE dKey=8) == $sth->rows using DBD::CSV ok 226 - execute == 4 using 'DBD::CSV' ok 228 - SELECT results for SELECT * FROM multi_fruit ORDER BY dKey DESC using DBD::CSV ok 229 - execute == 4 using 'DBD::CSV' ok 231 - SELECT results for SELECT * FROM multi_fruit ORDER BY dKey DESC using 'DBD::CSV' 2nd time ok 232 - prepare using 'DBD::CSV' ok 233 - execute using 'DBD::CSV' ok 234 - execute(DELETE FROM multi_fruit) == 4 using 'DBD::CSV' ok 235 - $sth->execute(DELETE FROM multi_fruit) == $sth->rows using DBD::CSV ok 236 - prepare using 'DBD::CSV' ok 238 - execute using 'DBD::CSV' 2nd time ok 241 - execute using 'DBD::CSV' ok 248 - prepare using 'DBD::CSV' ok 249 - execute using 'DBD::CSV' ok 250 - execute(DROP TABLE IF EXISTS test_tbl) == -1 using 'DBD::CSV' ok 251 - prepare using 'DBD::CSV' ok 252 - execute using 'DBD::CSV' ok 253 - execute(CREATE TABLE test_tbl (dKey INT, dVal VARCHAR(23))) == 0E0 using 'DBD::CSV' Dubious, test returned 25 (wstat 6400, 0x1900) All 253 subtests passed Can't call method "command" on an undefined value at t/TestLib.pm line 378. # Tests were run but no plan was declared and done_testing() was not seen. t/06virtual.t ...... # DBD::DBM->VERSION() of 0.03 doesn't satisfy requirement of 0.06 # DBD::File->VERSION() of 0.37 doesn't satisfy requirement of 0.4 # DBI->VERSION() of 1.609 doesn't satisfy requirement of 1.616 # # Using required: # # SQL::Statement: 1.402 # # Using recommended: # # DBD::CSV: 0.3 # # MLDBM: 2.04 # Running tests for SQL::Statement ok 1 - prepare CREATE TEMP TABLE biz (sales INTEGER, class CHAR, color CHAR, BUGNULL CHAR) on SQL::Statement ok 2 - execute CREATE TEMP TABLE biz (sales INTEGER, class CHAR, color CHAR, BUGNULL CHAR) on SQL::Statement ok 3 - prepare INSERT INTO biz VALUES (1000, 'Car', 'White', NULL) on SQL::Statement ok 4 - execute INSERT INTO biz VALUES (1000, 'Car', 'White', NULL) on SQL::Statement ok 5 - prepare INSERT INTO biz VALUES ( 500, 'Car', 'Blue', NULL ) on SQL::Statement ok 6 - execute INSERT INTO biz VALUES ( 500, 'Car', 'Blue', NULL ) on SQL::Statement ok 7 - prepare INSERT INTO biz VALUES ( 400, 'Truck', 'White', NULL ) on SQL::Statement ok 8 - execute INSERT INTO biz VALUES ( 400, 'Truck', 'White', NULL ) on SQL::Statement ok 9 - prepare INSERT INTO biz VALUES ( 700, 'Car', 'Red', NULL ) on SQL::Statement ok 10 - execute INSERT INTO biz VALUES ( 700, 'Car', 'Red', NULL ) on SQL::Statement ok 11 - prepare INSERT INTO biz VALUES ( 300, 'Truck', 'White', NULL ) on SQL::Statement ok 12 - execute INSERT INTO biz VALUES ( 300, 'Truck', 'White', NULL ) on SQL::Statement ok 13 - prepare CREATE TEMP TABLE baz (ordered INTEGER, class CHAR, color CHAR) on SQL::Statement ok 14 - execute CREATE TEMP TABLE baz (ordered INTEGER, class CHAR, color CHAR) on SQL::Statement ok 15 - prepare INSERT INTO baz VALUES ( 250, 'Car', 'White' ), ( 100, 'Car', 'Blue' ), ( 150, 'Car', 'Red' ) on SQL::Statement ok 16 - execute INSERT INTO baz VALUES ( 250, 'Car', 'White' ), ( 100, 'Car', 'Blue' ), ( 150, 'Car', 'Red' ) on SQL::Statement ok 17 - prepare INSERT INTO baz VALUES ( 80, 'Truck', 'White' ), ( 60, 'Truck', 'Green' ) -- Yes, we introduce new cars :) on SQL::Statement ok 18 - execute INSERT INTO baz VALUES ( 80, 'Truck', 'White' ), ( 60, 'Truck', 'Green' ) -- Yes, we introduce new cars :) on SQL::Statement ok 19 - prepare CREATE TEMP TABLE numbers (c_foo INTEGER, foo CHAR, bar INTEGER) on SQL::Statement ok 20 - execute CREATE TEMP TABLE numbers (c_foo INTEGER, foo CHAR, bar INTEGER) on SQL::Statement ok 21 - prepare CREATE TEMP TABLE trick (id INTEGER, foo CHAR) on SQL::Statement ok 22 - execute CREATE TEMP TABLE trick (id INTEGER, foo CHAR) on SQL::Statement ok 23 - prepare INSERT INTO trick VALUES (1, '1foo') on SQL::Statement ok 24 - execute INSERT INTO trick VALUES (1, '1foo') on SQL::Statement ok 25 - prepare INSERT INTO trick VALUES (11, 'foo') on SQL::Statement ok 26 - execute INSERT INTO trick VALUES (11, 'foo') on SQL::Statement ok 27 - prepare CREATE TYPE TIMESTAMP on SQL::Statement ok 28 - execute CREATE TYPE TIMESTAMP on SQL::Statement ok 29 - prepare CREATE TEMP TABLE log (id INT, host CHAR, signature CHAR, message CHAR, time_stamp TIMESTAMP) on SQL::Statement ok 30 - execute CREATE TEMP TABLE log (id INT, host CHAR, signature CHAR, message CHAR, time_stamp TIMESTAMP) on SQL::Statement ok 31 - prepare INSERT INTO log VALUES (1, 'bert', '/netbsd', 'Copyright (c) 1996, 1997, 1998, 1999, 2000, 2001, 2002, 2003, 2004, 2005,', 1356761626) on SQL::Statement ok 32 - execute INSERT INTO log VALUES (1, 'bert', '/netbsd', 'Copyright (c) 1996, 1997, 1998, 1999, 2000, 2001, 2002, 2003, 2004, 2005,', 1356761626) on SQL::Statement ok 33 - prepare INSERT INTO log VALUES (2, 'bert', '/netbsd', '2006, 2007, 2008, 2009, 2010', 1356761626) on SQL::Statement ok 34 - execute INSERT INTO log VALUES (2, 'bert', '/netbsd', '2006, 2007, 2008, 2009, 2010', 1356761626) on SQL::Statement ok 35 - prepare INSERT INTO log VALUES (3, 'bert', '/netbsd', 'The NetBSD Foundation, Inc. All rights reserved.', 1356761626) on SQL::Statement ok 36 - execute INSERT INTO log VALUES (3, 'bert', '/netbsd', 'The NetBSD Foundation, Inc. All rights reserved.', 1356761626) on SQL::Statement ok 37 - prepare INSERT INTO log VALUES (4, 'bert', '/netbsd', 'Copyright (c) 1982, 1986, 1989, 1991, 1993', 1356761626) on SQL::Statement ok 38 - execute INSERT INTO log VALUES (4, 'bert', '/netbsd', 'Copyright (c) 1982, 1986, 1989, 1991, 1993', 1356761626) on SQL::Statement ok 39 - prepare INSERT INTO log VALUES (5, 'bert', '/netbsd', 'The Regents of the University of California. All rights reserved.', 1356761626) on SQL::Statement ok 40 - execute INSERT INTO log VALUES (5, 'bert', '/netbsd', 'The Regents of the University of California. All rights reserved.', 1356761626) on SQL::Statement ok 41 - prepare INSERT INTO log VALUES (6, 'bert', '/netbsd', '', 1356761626) on SQL::Statement ok 42 - execute INSERT INTO log VALUES (6, 'bert', '/netbsd', '', 1356761626) on SQL::Statement ok 43 - prepare INSERT INTO log VALUES (7, 'bert', '/netbsd', 'NetBSD 5.99.39 (BERT) \#0: Fri Oct 8 06:23:03 CEST 2010', 1356761626) on SQL::Statement ok 44 - execute INSERT INTO log VALUES (7, 'bert', '/netbsd', 'NetBSD 5.99.39 (BERT) \#0: Fri Oct 8 06:23:03 CEST 2010', 1356761626) on SQL::Statement ok 45 - prepare INSERT INTO log VALUES (8, 'ernie', 'rpc.statd', 'starting', 1356758026) on SQL::Statement ok 46 - execute INSERT INTO log VALUES (8, 'ernie', 'rpc.statd', 'starting', 1356758026) on SQL::Statement ok 47 - prepare INSERT INTO log VALUES (9, 'ernie', 'savecore', 'no core dump', 1356754426) on SQL::Statement ok 48 - execute INSERT INTO log VALUES (9, 'ernie', 'savecore', 'no core dump', 1356754426) on SQL::Statement ok 49 - prepare INSERT INTO log VALUES (10, 'ernie', 'postfix/postfix-script', 'starting the Postfix mail system', 1356750826) on SQL::Statement ok 50 - execute INSERT INTO log VALUES (10, 'ernie', 'postfix/postfix-script', 'starting the Postfix mail system', 1356750826) on SQL::Statement ok 51 - prepare INSERT INTO log VALUES (11, 'ernie', 'rpcbind', 'connect from 127.0.0.1 to dump()', 1356747226) on SQL::Statement ok 52 - execute INSERT INTO log VALUES (11, 'ernie', 'rpcbind', 'connect from 127.0.0.1 to dump()', 1356747226) on SQL::Statement ok 53 - prepare INSERT INTO log VALUES (12, 'ernie', 'sshd', 'last message repeated 2 times', 1356743626) on SQL::Statement ok 54 - execute INSERT INTO log VALUES (12, 'ernie', 'sshd', 'last message repeated 2 times', 1356743626) on SQL::Statement ok 55 - prepare INSERT INTO log VALUES (13, 'ernie', 'shutdown', 'poweroff by root:', 1356740026) on SQL::Statement ok 56 - execute INSERT INTO log VALUES (13, 'ernie', 'shutdown', 'poweroff by root:', 1356740026) on SQL::Statement ok 57 - prepare INSERT INTO log VALUES (14, 'ernie', 'shutdown', 'rebooted by root', 1356736426) on SQL::Statement ok 58 - execute INSERT INTO log VALUES (14, 'ernie', 'shutdown', 'rebooted by root', 1356736426) on SQL::Statement ok 59 - prepare INSERT INTO log VALUES (15, 'ernie', 'sshd', 'Server listening on :: port 22.', 1356732826) on SQL::Statement ok 60 - execute INSERT INTO log VALUES (15, 'ernie', 'sshd', 'Server listening on :: port 22.', 1356732826) on SQL::Statement ok 61 - prepare INSERT INTO log VALUES (16, 'ernie', 'sshd', 'Server listening on 0.0.0.0 port 22.', 1356729226) on SQL::Statement ok 62 - execute INSERT INTO log VALUES (16, 'ernie', 'sshd', 'Server listening on 0.0.0.0 port 22.', 1356729226) on SQL::Statement ok 63 - prepare INSERT INTO log VALUES (17, 'ernie', 'sshd', 'Received SIGHUP; restarting.', 1356725626) on SQL::Statement ok 64 - execute INSERT INTO log VALUES (17, 'ernie', 'sshd', 'Received SIGHUP; restarting.', 1356725626) on SQL::Statement ok 65 - prepare SELECT class,SUM(sales) as foo, MAX(sales) FROM biz GROUP BY class using SQL::Statement ok 66 - execute SELECT class,SUM(sales) as foo, MAX(sales) FROM biz GROUP BY class using SQL::Statement ok 67 - GROUP BY one column ok 68 - prepare SELECT color,class,SUM(sales), MAX(sales) FROM biz GROUP BY color,class using SQL::Statement ok 69 - execute SELECT color,class,SUM(sales), MAX(sales) FROM biz GROUP BY color,class using SQL::Statement ok 70 - GROUP BY several columns ok 71 - prepare SELECT SUM(sales), MAX(sales) FROM biz using SQL::Statement ok 72 - execute SELECT SUM(sales), MAX(sales) FROM biz using SQL::Statement ok 73 - AGGREGATE FUNCTIONS WITHOUT GROUP BY ok 74 - prepare SELECT distinct class, COUNT(distinct color) FROM biz GROUP BY class using SQL::Statement ok 75 - execute SELECT distinct class, COUNT(distinct color) FROM biz GROUP BY class using SQL::Statement ok 76 - COUNT(distinct column) WITH GROUP BY ok 77 - prepare SELECT class, COUNT(*) FROM biz GROUP BY class using SQL::Statement ok 78 - execute SELECT class, COUNT(*) FROM biz GROUP BY class using SQL::Statement ok 79 - COUNT(*) with GROUP BY ok 80 - prepare SELECT DISTINCT biz.class, baz.color AS foo FROM biz, baz WHERE biz.class = baz.class ORDER BY foo using SQL::Statement ok 81 - execute SELECT DISTINCT biz.class, baz.color AS foo FROM biz, baz WHERE biz.class = baz.class ORDER BY foo using SQL::Statement ok 82 - ORDER BY on aliased column ok 83 - prepare SELECT class, COUNT(distinct *) FROM biz GROUP BY class using SQL::Statement fails ok 84 - COUNT(DISTINCT *) fails ok 85 - prepare SELECT class, COUNT(color) FROM biz using SQL::Statement ok 86 - execute SELECT class, COUNT(color) FROM biz using SQL::Statement fails ok 87 - GROUP BY required ok 88 - prepare SELECT SUM(bar) FROM numbers using SQL::Statement ok 89 - execute SELECT SUM(bar) FROM numbers using SQL::Statement ok 90 - SUM(bar) of empty table ok 91 - prepare SELECT COUNT(bar),c_foo FROM numbers GROUP BY c_foo using SQL::Statement ok 92 - execute SELECT COUNT(bar),c_foo FROM numbers GROUP BY c_foo using SQL::Statement ok 93 - COUNT(bar) of empty table with GROUP BY ok 94 - prepare SELECT COUNT(*) FROM numbers using SQL::Statement ok 95 - execute SELECT COUNT(*) FROM numbers using SQL::Statement ok 96 - COUNT(*) of empty table ok 97 - prepare INSERT INTO numbers VALUES (?, ?, ?) using SQL::Statement ok 98 - 1 .. 3999: execute INSERT INTO numbers VALUES (?, ?, ?) using SQL::Statement ok 99 - prepare SELECT foo AS boo, COUNT (*) AS counted FROM numbers GROUP BY boo using SQL::Statement ok 100 - execute SELECT foo AS boo, COUNT (*) AS counted FROM numbers GROUP BY boo using SQL::Statement ok 101 - Columns in Number of rows in aggregated Table ok 102 - Number of rows in aggregated Table ok 103 - SUM(COUNTED) ok 104 - prepare SELECT MIN(c_foo), MAX(c_foo), AVG(c_foo) FROM numbers using SQL::Statement ok 105 - execute SELECT MIN(c_foo), MAX(c_foo), AVG(c_foo) FROM numbers using SQL::Statement ok 106 - Aggregate functions MIN, MAX, AVG ok 107 - prepare SELECT COUNT(*) FROM trick using SQL::Statement ok 108 - execute SELECT COUNT(*) FROM trick using SQL::Statement ok 109 - COUNT(*) internal for nasty table ok 110 - prepare SELECT CURRENT_DATE() using SQL::Statement ok 111 - execute SELECT CURRENT_DATE() using SQL::Statement ok 112 - current_date int ok 113 - prepare SELECT CURRENT_TIME using SQL::Statement ok 114 - execute SELECT CURRENT_TIME using SQL::Statement ok 115 - current_time int ok 116 - prepare SELECT CURRENT_TIMESTAMP() using SQL::Statement ok 117 - execute SELECT CURRENT_TIMESTAMP() using SQL::Statement ok 118 - current_timestamp int ok 119 - prepare SELECT CURDATE using SQL::Statement ok 120 - execute SELECT CURDATE using SQL::Statement ok 121 - curdate int ok 122 - prepare SELECT CURTIME() using SQL::Statement ok 123 - execute SELECT CURTIME() using SQL::Statement ok 124 - curtime int ok 125 - prepare SELECT NOW using SQL::Statement ok 126 - execute SELECT NOW using SQL::Statement ok 127 - now int ok 128 - prepare SELECT UNIX_TIMESTAMP() using SQL::Statement ok 129 - execute SELECT UNIX_TIMESTAMP() using SQL::Statement ok 130 - unix_timestamp int ok 131 - prepare SELECT CURRENT_TIME (1) using SQL::Statement ok 132 - execute SELECT CURRENT_TIME (1) using SQL::Statement ok 133 - current_time precision ok 134 - prepare SELECT CURRENT_TIMESTAMP (2) using SQL::Statement ok 135 - execute SELECT CURRENT_TIMESTAMP (2) using SQL::Statement ok 136 - current_timestamp precision ok 137 - prepare SELECT CURTIME (3) using SQL::Statement ok 138 - execute SELECT CURTIME (3) using SQL::Statement ok 139 - curtime precision ok 140 - prepare SELECT NOW(4) using SQL::Statement ok 141 - execute SELECT NOW(4) using SQL::Statement ok 142 - now precision ok 143 - prepare SELECT UNIX_TIMESTAMP(5) using SQL::Statement ok 144 - execute SELECT UNIX_TIMESTAMP(5) using SQL::Statement ok 145 - unix_timestamp precision ok 146 - prepare SELECT ASCII('A') using SQL::Statement ok 147 - execute SELECT ASCII('A') using SQL::Statement ok 148 - ascii char ok 149 - prepare SELECT ASCII('ABC') using SQL::Statement ok 150 - execute SELECT ASCII('ABC') using SQL::Statement ok 151 - ascii str ok 152 - prepare SELECT CHAR() using SQL::Statement ok 153 - execute SELECT CHAR() using SQL::Statement ok 154 - char blank ok 155 - prepare SELECT CHAR(65) using SQL::Statement ok 156 - execute SELECT CHAR(65) using SQL::Statement ok 157 - char char ok 158 - prepare SELECT CHAR(CONV('263A', 16)) using SQL::Statement ok 159 - execute SELECT CHAR(CONV('263A', 16)) using SQL::Statement ok 160 - char char unicode ok 161 - prepare SELECT CHAR(65,66,67) using SQL::Statement ok 162 - execute SELECT CHAR(65,66,67) using SQL::Statement ok 163 - char str ok 164 - prepare SELECT CHAR(CONV('263A', 16), 9787, CONV('10011000111100', 2)) using SQL::Statement ok 165 - execute SELECT CHAR(CONV('263A', 16), 9787, CONV('10011000111100', 2)) using SQL::Statement ok 166 - char str unicode ok 167 - prepare SELECT BIT_LENGTH(' oo') using SQL::Statement ok 168 - execute SELECT BIT_LENGTH(' oo') using SQL::Statement ok 169 - bit_length 6bit ok 170 - prepare SELECT BIT_LENGTH('foo') using SQL::Statement ok 171 - execute SELECT BIT_LENGTH('foo') using SQL::Statement ok 172 - bit_length 7bit ok 173 - prepare SELECT BIT_LENGTH(CHAR(9786, 9787, 9788)) using SQL::Statement ok 174 - execute SELECT BIT_LENGTH(CHAR(9786, 9787, 9788)) using SQL::Statement ok 175 - bit_length unicode ok 176 - prepare SELECT CHARACTER_LENGTH('foo') using SQL::Statement ok 177 - execute SELECT CHARACTER_LENGTH('foo') using SQL::Statement ok 178 - character_length ok 179 - prepare SELECT CHAR_LENGTH('foo') using SQL::Statement ok 180 - execute SELECT CHAR_LENGTH('foo') using SQL::Statement ok 181 - char_length ok 182 - prepare SELECT CHARACTER_LENGTH(CHAR(9786, 9787, 9788)) using SQL::Statement ok 183 - execute SELECT CHARACTER_LENGTH(CHAR(9786, 9787, 9788)) using SQL::Statement ok 184 - character_length unicode ok 185 - prepare SELECT CHAR_LENGTH(CHAR(9786, 9787, 9788)) using SQL::Statement ok 186 - execute SELECT CHAR_LENGTH(CHAR(9786, 9787, 9788)) using SQL::Statement ok 187 - char_length unicode ok 188 - prepare SELECT COALESCE(NULL,'z') using SQL::Statement ok 189 - execute SELECT COALESCE(NULL,'z') using SQL::Statement ok 190 - coalesce ok 191 - prepare SELECT NVL(NULL,'z') using SQL::Statement ok 192 - execute SELECT NVL(NULL,'z') using SQL::Statement ok 193 - nvl ok 194 - prepare SELECT IFNULL(NULL,'z') using SQL::Statement ok 195 - execute SELECT IFNULL(NULL,'z') using SQL::Statement ok 196 - ifnull ok 197 - prepare SELECT CONCAT('A','B') using SQL::Statement ok 198 - execute SELECT CONCAT('A','B') using SQL::Statement ok 199 - concat good ok 200 - prepare SELECT CONCAT('A',NULL) using SQL::Statement ok 201 - execute SELECT CONCAT('A',NULL) using SQL::Statement ok 202 - concat bad ok 203 - prepare SELECT CONV('101 0100 1111 0111 0110 1011', 2, 92) using SQL::Statement ok 204 - execute SELECT CONV('101 0100 1111 0111 0110 1011', 2, 92) using SQL::Statement ok 205 - conv 2->92 ok 206 - prepare SELECT CONV('101 0100 1111 0111 0110 1011', 2, 64) using SQL::Statement ok 207 - execute SELECT CONV('101 0100 1111 0111 0110 1011', 2, 64) using SQL::Statement ok 208 - conv 2->64 ok 209 - prepare SELECT CONV('101 0100 1111 0111 0110 1011', 2, 36) using SQL::Statement ok 210 - execute SELECT CONV('101 0100 1111 0111 0110 1011', 2, 36) using SQL::Statement ok 211 - conv 2->36 ok 212 - prepare SELECT CONV('101 0100 1111 0111 0110 1011', 2, 16) using SQL::Statement ok 213 - execute SELECT CONV('101 0100 1111 0111 0110 1011', 2, 16) using SQL::Statement ok 214 - conv 2->16 ok 215 - prepare SELECT CONV('101 0100 1111 0111 0110 1011', 2, 10) using SQL::Statement ok 216 - execute SELECT CONV('101 0100 1111 0111 0110 1011', 2, 10) using SQL::Statement ok 217 - conv 2->10 ok 218 - prepare SELECT CONV('101 0100 1111 0111 0110 1011', 2, 8) using SQL::Statement ok 219 - execute SELECT CONV('101 0100 1111 0111 0110 1011', 2, 8) using SQL::Statement ok 220 - conv 2->8 ok 221 - prepare SELECT CONV('101 0100 1111 0111 0110 1011', 2, 2) using SQL::Statement ok 222 - execute SELECT CONV('101 0100 1111 0111 0110 1011', 2, 2) using SQL::Statement ok 223 - conv 2->2 ok 224 - prepare SELECT CONV(-1, 2, 36) using SQL::Statement ok 225 - execute SELECT CONV(-1, 2, 36) using SQL::Statement ok 226 - conv base 36 short-circuit ok 227 - prepare SELECT CONV(-1, 2, 92) using SQL::Statement ok 228 - execute SELECT CONV(-1, 2, 92) using SQL::Statement ok 229 - conv base 92 short-circuit ok 230 - prepare SELECT CONV('-&23ms98*&a ^.21 hjs ', 92, 36) using SQL::Statement ok 231 - execute SELECT CONV('-&23ms98*&a ^.21 hjs ', 92, 36) using SQL::Statement ok 232 - conv 92->36 ok 233 - prepare SELECT CONV('10101001111.011101101011', 2, 92) using SQL::Statement ok 234 - execute SELECT CONV('10101001111.011101101011', 2, 92) using SQL::Statement ok 235 - conv 2->92 fractional ok 236 - prepare SELECT CONV(2517.3553, 8, 64) using SQL::Statement ok 237 - execute SELECT CONV(2517.3553, 8, 64) using SQL::Statement ok 238 - conv 8->64 fractional ok 239 - prepare SELECT CONV('54F . 76B', 16, 32) using SQL::Statement ok 240 - execute SELECT CONV('54F . 76B', 16, 32) using SQL::Statement ok 241 - conv 16->32 fractional ok 242 - prepare SELECT CONV('101 0100 1111.0111 0110 1011', 2, 16) using SQL::Statement ok 243 - execute SELECT CONV('101 0100 1111.0111 0110 1011', 2, 16) using SQL::Statement ok 244 - conv 2->16 fractional ok 245 - prepare SELECT CONV('VP.dr', 64, 10) using SQL::Statement ok 246 - execute SELECT CONV('VP.dr', 64, 10) using SQL::Statement ok 247 - conv 64->10 fractional => near? 1359.463623046875 ~= 1359.46362304688 ok 248 - prepare SELECT CONV(' 1 A F . E Q O ', 32, 8) using SQL::Statement ok 249 - execute SELECT CONV(' 1 A F . E Q O ', 32, 8) using SQL::Statement ok 250 - conv 32->8 fractional ok 251 - prepare SELECT CONV('101 0100 1111.0111 0110 1011', 2, 2) using SQL::Statement ok 252 - execute SELECT CONV('101 0100 1111.0111 0110 1011', 2, 2) using SQL::Statement ok 253 - conv 2->2 fractional ok 254 - prepare SELECT CONV('1AF.EQO0000000000000000000000000000', 32, 8) using SQL::Statement ok 255 - execute SELECT CONV('1AF.EQO0000000000000000000000000000', 32, 8) using SQL::Statement ok 256 - conv 32->8 big_number ok 257 - prepare SELECT DISTINCT DECODE(color,'White','W','Red','R','B') AS cfc FROM biz ORDER BY cfc using SQL::Statement ok 258 - execute SELECT DISTINCT DECODE(color,'White','W','Red','R','B') AS cfc FROM biz ORDER BY cfc using SQL::Statement ok 259 - decode ok 260 - prepare SELECT INSERT('foodieland', 4, 3, 'bar') using SQL::Statement ok 261 - execute SELECT INSERT('foodieland', 4, 3, 'bar') using SQL::Statement ok 262 - insert good 1:1 ok 263 - prepare SELECT INSERT('foodland', 4, 1, 'bar') using SQL::Statement ok 264 - execute SELECT INSERT('foodland', 4, 1, 'bar') using SQL::Statement ok 265 - insert good non-1:1 ok 266 - prepare SELECT INSERT(NULL, 4, 1, 'bar') using SQL::Statement ok 267 - execute SELECT INSERT(NULL, 4, 1, 'bar') using SQL::Statement ok 268 - insert bad 1 ok 269 - prepare SELECT INSERT('foodland', 4, 1, NULL) using SQL::Statement ok 270 - execute SELECT INSERT('foodland', 4, 1, NULL) using SQL::Statement ok 271 - insert bad 2 ok 272 - prepare SELECT LEFT('foodland', 4) using SQL::Statement ok 273 - execute SELECT LEFT('foodland', 4) using SQL::Statement ok 274 - left good ok 275 - prepare SELECT LEFT(NULL, 4) using SQL::Statement ok 276 - execute SELECT LEFT(NULL, 4) using SQL::Statement ok 277 - left bad 1 ok 278 - prepare SELECT LEFT('foodland', NULL) using SQL::Statement ok 279 - execute SELECT LEFT('foodland', NULL) using SQL::Statement ok 280 - left bad 2 ok 281 - prepare SELECT RIGHT('foodland', 4) using SQL::Statement ok 282 - execute SELECT RIGHT('foodland', 4) using SQL::Statement ok 283 - right good ok 284 - prepare SELECT RIGHT(NULL, 4) using SQL::Statement ok 285 - execute SELECT RIGHT(NULL, 4) using SQL::Statement ok 286 - right bad 1 ok 287 - prepare SELECT RIGHT('foodland', NULL) using SQL::Statement ok 288 - execute SELECT RIGHT('foodland', NULL) using SQL::Statement ok 289 - right bad 2 ok 290 - prepare SELECT LOCATE('a','bar') using SQL::Statement ok 291 - execute SELECT LOCATE('a','bar') using SQL::Statement ok 292 - locate 2param ok 293 - prepare SELECT LOCATE('a','barafa',3) using SQL::Statement ok 294 - execute SELECT LOCATE('a','barafa',3) using SQL::Statement ok 295 - locate 3param ok 296 - prepare SELECT POSITION('a','bar') using SQL::Statement ok 297 - execute SELECT POSITION('a','bar') using SQL::Statement ok 298 - position 2param ok 299 - prepare SELECT POSITION('a','barafa',3) using SQL::Statement ok 300 - execute SELECT POSITION('a','barafa',3) using SQL::Statement ok 301 - position 3param ok 302 - prepare SELECT LOWER('A') using SQL::Statement ok 303 - execute SELECT LOWER('A') using SQL::Statement ok 304 - lower ok 305 - prepare SELECT UPPER('a') using SQL::Statement ok 306 - execute SELECT UPPER('a') using SQL::Statement ok 307 - upper ok 308 - prepare SELECT LCASE('A') using SQL::Statement ok 309 - execute SELECT LCASE('A') using SQL::Statement ok 310 - lcase ok 311 - prepare SELECT UCASE('a') using SQL::Statement ok 312 - execute SELECT UCASE('a') using SQL::Statement ok 313 - ucase ok 314 - prepare SELECT LTRIM(' fun ') using SQL::Statement ok 315 - execute SELECT LTRIM(' fun ') using SQL::Statement ok 316 - ltrim ok 317 - prepare SELECT RTRIM(' fun ') using SQL::Statement ok 318 - execute SELECT RTRIM(' fun ') using SQL::Statement ok 319 - rtrim ok 320 - prepare SELECT OCTET_LENGTH('foo') using SQL::Statement ok 321 - execute SELECT OCTET_LENGTH('foo') using SQL::Statement ok 322 - octet_length ok 323 - prepare SELECT OCTET_LENGTH(CHAR(64, 169, 9786, 65572)) using SQL::Statement ok 324 - execute SELECT OCTET_LENGTH(CHAR(64, 169, 9786, 65572)) using SQL::Statement ok 325 - octet_length unicode ok 326 - prepare SELECT REGEX('jeff','/EF/i') using SQL::Statement ok 327 - execute SELECT REGEX('jeff','/EF/i') using SQL::Statement ok 328 - regex match ok 329 - prepare SELECT REGEX('jeff','/zzz/') using SQL::Statement ok 330 - execute SELECT REGEX('jeff','/zzz/') using SQL::Statement ok 331 - regex no match ok 332 - prepare SELECT REPEAT('zfunkY', 3) using SQL::Statement ok 333 - execute SELECT REPEAT('zfunkY', 3) using SQL::Statement ok 334 - repeat ok 335 - prepare SELECT REPLACE('zfunkY','s/z(.+)ky/$1/i') using SQL::Statement ok 336 - execute SELECT REPLACE('zfunkY','s/z(.+)ky/$1/i') using SQL::Statement ok 337 - replace ok 338 - prepare SELECT SUBSTITUTE('zfunkY','s/z(.+)ky/$1/i') using SQL::Statement ok 339 - execute SELECT SUBSTITUTE('zfunkY','s/z(.+)ky/$1/i') using SQL::Statement ok 340 - substitute ok 341 - prepare SELECT SOUNDEX('jeff','jeph') using SQL::Statement ok 342 - execute SELECT SOUNDEX('jeff','jeph') using SQL::Statement ok 343 - soundex match ok 344 - prepare SELECT SOUNDEX('jeff','quartz') using SQL::Statement ok 345 - execute SELECT SOUNDEX('jeff','quartz') using SQL::Statement ok 346 - soundex no match ok 347 - prepare SELECT SPACE(10) using SQL::Statement ok 348 - execute SELECT SPACE(10) using SQL::Statement ok 349 - space ok 350 - prepare SELECT SUBSTR('zfunkY',2,3) using SQL::Statement ok 351 - execute SELECT SUBSTR('zfunkY',2,3) using SQL::Statement ok 352 - substr ok 353 - prepare SELECT DISTINCT color FROM biz WHERE SUBSTRING(class FROM 1 FOR 1)='T' using SQL::Statement ok 354 - execute SELECT DISTINCT color FROM biz WHERE SUBSTRING(class FROM 1 FOR 1)='T' using SQL::Statement ok 355 - substring ok 356 - prepare SELECT TRANSLATE('foobar forever', 'oae', '0@3') using SQL::Statement ok 357 - execute SELECT TRANSLATE('foobar forever', 'oae', '0@3') using SQL::Statement ok 358 - translate ok 359 - prepare SELECT TRIM(' fun ') using SQL::Statement ok 360 - execute SELECT TRIM(' fun ') using SQL::Statement ok 361 - trim simple not ok 362 - prepare SELECT TRIM(LEADING FROM ' fun ') using SQL::Statement # TODO Analyze why this fails; may be thinking FROM keyword is for table specs # Failed (TODO) test 'prepare SELECT TRIM(LEADING FROM ' fun ') using SQL::Statement' # at t/06virtual.t line 1434. # Unbalanced parentheses! not ok 363 - prepare SELECT TRIM(TRAILING FROM ' fun ') using SQL::Statement # TODO Analyze why this fails; may be thinking FROM keyword is for table specs # Failed (TODO) test 'prepare SELECT TRIM(TRAILING FROM ' fun ') using SQL::Statement' # at t/06virtual.t line 1434. # Unbalanced parentheses! not ok 364 - prepare SELECT TRIM(LEADING ';' FROM ';;; fun ') using SQL::Statement # TODO Analyze why this fails; may be thinking FROM keyword is for table specs # Failed (TODO) test 'prepare SELECT TRIM(LEADING ';' FROM ';;; fun ') using SQL::Statement' # at t/06virtual.t line 1434. # Unbalanced parentheses! ok 365 - prepare SELECT UNHEX('414243') using SQL::Statement ok 366 - execute SELECT UNHEX('414243') using SQL::Statement ok 367 - unhex str ok 368 - prepare SELECT UNHEX('263A' || HEX(9787) || CONV('10011000111100', 2, 16), 'UCS-2') using SQL::Statement ok 369 - execute SELECT UNHEX('263A' || HEX(9787) || CONV('10011000111100', 2, 16), 'UCS-2') using SQL::Statement ok 370 - unhex str unicode ok 371 - prepare SELECT ABS(-4) using SQL::Statement ok 372 - execute SELECT ABS(-4) using SQL::Statement ok 373 - abs ok 374 - prepare SELECT CEILING(5) using SQL::Statement ok 375 - execute SELECT CEILING(5) using SQL::Statement ok 376 - ceiling int ok 377 - prepare SELECT CEILING(4.1) using SQL::Statement ok 378 - execute SELECT CEILING(4.1) using SQL::Statement ok 379 - ceiling positive ok 380 - prepare SELECT CEIL(-4.5) using SQL::Statement ok 381 - execute SELECT CEIL(-4.5) using SQL::Statement ok 382 - ceil negative ok 383 - prepare SELECT FLOOR(-5) using SQL::Statement ok 384 - execute SELECT FLOOR(-5) using SQL::Statement ok 385 - floor int ok 386 - prepare SELECT FLOOR(4.999999999999) using SQL::Statement ok 387 - execute SELECT FLOOR(4.999999999999) using SQL::Statement ok 388 - floor positive ok 389 - prepare SELECT FLOOR(-4.1) using SQL::Statement ok 390 - execute SELECT FLOOR(-4.1) using SQL::Statement ok 391 - floor negative ok 392 - prepare SELECT EXP(1) using SQL::Statement ok 393 - execute SELECT EXP(1) using SQL::Statement ok 394 - exp ok 395 - prepare SELECT LOG(6) using SQL::Statement ok 396 - execute SELECT LOG(6) using SQL::Statement ok 397 - log as log10 ok 398 - prepare SELECT LOG(2, 32) using SQL::Statement ok 399 - execute SELECT LOG(2, 32) using SQL::Statement ok 400 - log as log2 ok 401 - prepare SELECT LN(3) using SQL::Statement ok 402 - execute SELECT LN(3) using SQL::Statement ok 403 - ln ok 404 - prepare SELECT MOD(8, 5) using SQL::Statement ok 405 - execute SELECT MOD(8, 5) using SQL::Statement ok 406 - mod ok 407 - prepare SELECT POWER(2, 4) using SQL::Statement ok 408 - execute SELECT POWER(2, 4) using SQL::Statement ok 409 - power ok 410 - prepare SELECT POW(2, 4) using SQL::Statement ok 411 - execute SELECT POW(2, 4) using SQL::Statement ok 412 - pow ok 413 - prepare SELECT FLOOR(RAND(4)) using SQL::Statement ok 414 - execute SELECT FLOOR(RAND(4)) using SQL::Statement ok 415 - rand ok 416 - prepare SELECT FLOOR(RAND(4), UNIX_TIMESTAMP()) using SQL::Statement ok 417 - execute SELECT FLOOR(RAND(4), UNIX_TIMESTAMP()) using SQL::Statement ok 418 - rand with seed ok 419 - prepare SELECT ROUND(4.999999999999) using SQL::Statement ok 420 - execute SELECT ROUND(4.999999999999) using SQL::Statement ok 421 - round int ok 422 - prepare SELECT ROUND(4.542222222222, 1) using SQL::Statement ok 423 - execute SELECT ROUND(4.542222222222, 1) using SQL::Statement ok 424 - round tenth ok 425 - prepare SELECT SIGN(-25.5) using SQL::Statement ok 426 - execute SELECT SIGN(-25.5) using SQL::Statement ok 427 - sign -1 ok 428 - prepare SELECT SIGN(53645) using SQL::Statement ok 429 - execute SELECT SIGN(53645) using SQL::Statement ok 430 - sign 1 ok 431 - prepare SELECT SIGN(0) using SQL::Statement ok 432 - execute SELECT SIGN(0) using SQL::Statement ok 433 - sign 0 ok 434 - prepare SELECT SIGN(NULL) using SQL::Statement ok 435 - execute SELECT SIGN(NULL) using SQL::Statement ok 436 - sign null ok 437 - prepare SELECT SQRT(64) using SQL::Statement ok 438 - execute SELECT SQRT(64) using SQL::Statement ok 439 - sqrt ok 440 - prepare SELECT TRUNCATE(4.999999999999) using SQL::Statement ok 441 - execute SELECT TRUNCATE(4.999999999999) using SQL::Statement ok 442 - truncate int ok 443 - prepare SELECT TRUNC(-4.9) using SQL::Statement ok 444 - execute SELECT TRUNC(-4.9) using SQL::Statement ok 445 - trunc int ok 446 - prepare SELECT TRUNCATE(4.934, 1) using SQL::Statement ok 447 - execute SELECT TRUNCATE(4.934, 1) using SQL::Statement ok 448 - truncate tenth ok 449 - prepare SELECT TRUNC(-4.99999, 1) using SQL::Statement ok 450 - execute SELECT TRUNC(-4.99999, 1) using SQL::Statement ok 451 - trunc int ok 452 - prepare SELECT SIN(1) using SQL::Statement ok 453 - execute SELECT SIN(1) using SQL::Statement ok 454 - sin(1) => near? 0.841470984807897 ~= 0.841470984807897 ok 455 - prepare SELECT COS(1) using SQL::Statement ok 456 - execute SELECT COS(1) using SQL::Statement ok 457 - cos(1) => near? 0.54030230586814 ~= 0.54030230586814 ok 458 - prepare SELECT TAN(1) using SQL::Statement ok 459 - execute SELECT TAN(1) using SQL::Statement ok 460 - tan(1) => near? 1.5574077246549 ~= 1.5574077246549 ok 461 - prepare SELECT SEC(1) using SQL::Statement ok 462 - execute SELECT SEC(1) using SQL::Statement ok 463 - sec(1) => near? 1.85081571768093 ~= 1.85081571768093 ok 464 - prepare SELECT CSC(1) using SQL::Statement ok 465 - execute SELECT CSC(1) using SQL::Statement ok 466 - csc(1) => near? 1.18839510577812 ~= 1.18839510577812 ok 467 - prepare SELECT COSEC(1) using SQL::Statement ok 468 - execute SELECT COSEC(1) using SQL::Statement ok 469 - cosec(1) => near? 1.18839510577812 ~= 1.18839510577812 ok 470 - prepare SELECT COT(1) using SQL::Statement ok 471 - execute SELECT COT(1) using SQL::Statement ok 472 - cot(1) => near? 0.642092615934331 ~= 0.642092615934331 ok 473 - prepare SELECT COTAN(1) using SQL::Statement ok 474 - execute SELECT COTAN(1) using SQL::Statement ok 475 - cotan(1) => near? 0.642092615934331 ~= 0.642092615934331 ok 476 - prepare SELECT ASIN(1) using SQL::Statement ok 477 - execute SELECT ASIN(1) using SQL::Statement ok 478 - asin(1) => near? 1.5707963267949 ~= 1.5707963267949 ok 479 - prepare SELECT ACOS(1) using SQL::Statement ok 480 - execute SELECT ACOS(1) using SQL::Statement ok 481 - acos(1) => near? 0 ~= 0 ok 482 - prepare SELECT ATAN(1) using SQL::Statement ok 483 - execute SELECT ATAN(1) using SQL::Statement ok 484 - atan(1) => near? 0.785398163397448 ~= 0.785398163397448 ok 485 - prepare SELECT ASEC(1) using SQL::Statement ok 486 - execute SELECT ASEC(1) using SQL::Statement ok 487 - asec(1) => near? 0 ~= 0 ok 488 - prepare SELECT ACSC(1) using SQL::Statement ok 489 - execute SELECT ACSC(1) using SQL::Statement ok 490 - acsc(1) => near? 1.5707963267949 ~= 1.5707963267949 ok 491 - prepare SELECT ACOSEC(1) using SQL::Statement ok 492 - execute SELECT ACOSEC(1) using SQL::Statement ok 493 - acosec(1) => near? 1.5707963267949 ~= 1.5707963267949 ok 494 - prepare SELECT ACOT(1) using SQL::Statement ok 495 - execute SELECT ACOT(1) using SQL::Statement ok 496 - acot(1) => near? 0.785398163397448 ~= 0.785398163397448 ok 497 - prepare SELECT ACOTAN(1) using SQL::Statement ok 498 - execute SELECT ACOTAN(1) using SQL::Statement ok 499 - acotan(1) => near? 0.785398163397448 ~= 0.785398163397448 ok 500 - prepare SELECT SINH(1) using SQL::Statement ok 501 - execute SELECT SINH(1) using SQL::Statement ok 502 - sinh(1) => near? 1.1752011936438 ~= 1.1752011936438 ok 503 - prepare SELECT COSH(1) using SQL::Statement ok 504 - execute SELECT COSH(1) using SQL::Statement ok 505 - cosh(1) => near? 1.54308063481524 ~= 1.54308063481524 ok 506 - prepare SELECT TANH(1) using SQL::Statement ok 507 - execute SELECT TANH(1) using SQL::Statement ok 508 - tanh(1) => near? 0.761594155955765 ~= 0.761594155955765 ok 509 - prepare SELECT SECH(1) using SQL::Statement ok 510 - execute SELECT SECH(1) using SQL::Statement ok 511 - sech(1) => near? 0.648054273663885 ~= 0.648054273663885 ok 512 - prepare SELECT CSCH(1) using SQL::Statement ok 513 - execute SELECT CSCH(1) using SQL::Statement ok 514 - csch(1) => near? 0.850918128239322 ~= 0.850918128239322 ok 515 - prepare SELECT COSECH(1) using SQL::Statement ok 516 - execute SELECT COSECH(1) using SQL::Statement ok 517 - cosech(1) => near? 0.850918128239322 ~= 0.850918128239322 ok 518 - prepare SELECT COTH(1) using SQL::Statement ok 519 - execute SELECT COTH(1) using SQL::Statement ok 520 - coth(1) => near? 1.31303528549933 ~= 1.31303528549933 ok 521 - prepare SELECT COTANH(1) using SQL::Statement ok 522 - execute SELECT COTANH(1) using SQL::Statement ok 523 - cotanh(1) => near? 1.31303528549933 ~= 1.31303528549933 ok 524 - prepare SELECT ASINH(1) using SQL::Statement ok 525 - execute SELECT ASINH(1) using SQL::Statement ok 526 - asinh(1) => near? 0.881373587019543 ~= 0.881373587019543 ok 527 - prepare SELECT ACOSH(1) using SQL::Statement ok 528 - execute SELECT ACOSH(1) using SQL::Statement ok 529 - acosh(1) => near? 0 ~= 0 ok 530 - prepare SELECT ATANH(0.9) using SQL::Statement ok 531 - execute SELECT ATANH(0.9) using SQL::Statement ok 532 - atanh(0.9) => near? 1.47221948958322 ~= 1.47221948958322 ok 533 - prepare SELECT ASECH(0.9) using SQL::Statement ok 534 - execute SELECT ASECH(0.9) using SQL::Statement ok 535 - asech(0.9) => near? 0.467145308103262 ~= 0.467145308103262 ok 536 - prepare SELECT ACSCH(2) using SQL::Statement ok 537 - execute SELECT ACSCH(2) using SQL::Statement ok 538 - acsch(2) => near? 0.481211825059603 ~= 0.481211825059603 ok 539 - prepare SELECT ACOSECH(2) using SQL::Statement ok 540 - execute SELECT ACOSECH(2) using SQL::Statement ok 541 - acosech(2) => near? 0.481211825059603 ~= 0.481211825059603 ok 542 - prepare SELECT ACOTH(2) using SQL::Statement ok 543 - execute SELECT ACOTH(2) using SQL::Statement ok 544 - acoth(2) => near? 0.549306144334055 ~= 0.549306144334055 ok 545 - prepare SELECT ACOTANH(2) using SQL::Statement ok 546 - execute SELECT ACOTANH(2) using SQL::Statement ok 547 - acotanh(2) => near? 0.549306144334055 ~= 0.549306144334055 ok 548 - prepare SELECT PI using SQL::Statement ok 549 - execute SELECT PI using SQL::Statement ok 550 - pi => near? 3.14159265358979 ~= 3.14159265358979 ok 551 - prepare SELECT ATAN2(1, 0) using SQL::Statement ok 552 - execute SELECT ATAN2(1, 0) using SQL::Statement ok 553 - atan2(1, 0) => near? 1.5707963267949 ~= 1.5707963267949 ok 554 - prepare SELECT ATAN2(1, 1) using SQL::Statement ok 555 - execute SELECT ATAN2(1, 1) using SQL::Statement ok 556 - atan2(1, 1) => near? 0.785398163397448 ~= 0.785398163397448 ok 557 - prepare SELECT ATAN2(-1, -1) using SQL::Statement ok 558 - execute SELECT ATAN2(-1, -1) using SQL::Statement ok 559 - atan2(-1, -1) to -3pi/4 => near? -2.35619449019234 ~= -2.35619449019234 ok 560 - prepare SELECT TAN(0.9) using SQL::Statement ok 561 - execute SELECT TAN(0.9) using SQL::Statement ok 562 - tan(0.9) as property sin/cos => near? 1.26015821755034 ~= 1.26015821755034 ok 563 - prepare SELECT SINH(2) using SQL::Statement ok 564 - execute SELECT SINH(2) using SQL::Statement ok 565 - sinh(2) => near? 3.62686040784702 ~= 3.62686040784702 ok 566 - prepare SELECT ACSCH(0.1) using SQL::Statement ok 567 - execute SELECT ACSCH(0.1) using SQL::Statement ok 568 - acsch 0.1 => near? 2.99822295029797 ~= 2.99822295029797 ok 569 - prepare SELECT DEG2RAD(90) using SQL::Statement ok 570 - execute SELECT DEG2RAD(90) using SQL::Statement ok 571 - deg2rad(90) => near? 1.5707963267949 ~= 1.5707963267949 ok 572 - prepare SELECT RADIANS(90) using SQL::Statement ok 573 - execute SELECT RADIANS(90) using SQL::Statement ok 574 - radians(90) => near? 1.5707963267949 ~= 1.5707963267949 ok 575 - prepare SELECT RAD2DEG(PI) using SQL::Statement ok 576 - execute SELECT RAD2DEG(PI) using SQL::Statement ok 577 - rad2deg(PI) => near? 180 ~= 180 ok 578 - prepare SELECT DEGREES(PI()) using SQL::Statement ok 579 - execute SELECT DEGREES(PI()) using SQL::Statement ok 580 - degrees(PI) => near? 180 ~= 180 ok 581 - prepare SELECT DEG2GRAD(0.9) using SQL::Statement ok 582 - execute SELECT DEG2GRAD(0.9) using SQL::Statement ok 583 - deg2grad(0.9) => near? 1 ~= 1 ok 584 - prepare SELECT GRAD2DEG(50) using SQL::Statement ok 585 - execute SELECT GRAD2DEG(50) using SQL::Statement ok 586 - grad2deg(50) => near? 45 ~= 45 ok 587 - prepare SELECT RAD2GRAD(PI/2) using SQL::Statement # TODO Known limitation. Parser/Engine can not handle properly ok 588 - execute SELECT RAD2GRAD(PI/2) using SQL::Statement # TODO Known limitation. Parser/Engine can not handle properly ok 589 - rad2grad(pi/2) => near? 99.9999999999999 ~= 100 # TODO Known limitation. Parser/Engine can not handle properly ok 590 - prepare SELECT RAD2GRAD(PI) using SQL::Statement ok 591 - execute SELECT RAD2GRAD(PI) using SQL::Statement ok 592 - rad2grad(pi) => near? 200 ~= 200 ok 593 - prepare SELECT GRAD2RAD(200) using SQL::Statement ok 594 - execute SELECT GRAD2RAD(200) using SQL::Statement ok 595 - grad2rad(200) => near? 3.14159265358979 ~= 3.14159265358979 ok 596 - prepare SELECT DEG2RAD(10000000000) using SQL::Statement ok 597 - execute SELECT DEG2RAD(10000000000) using SQL::Statement ok 598 - lotta radians - deg2rad(10000000000) => near? 4.88692191243172 ~= 4.88692191243172 ok 599 - prepare SELECT RAD2DEG(-10000000000) using SQL::Statement ok 600 - execute SELECT RAD2DEG(-10000000000) using SQL::Statement ok 601 - negative degrees - rad2deg(-10000000000) => near? -330.8232421875 ~= -330.8232421875 ok 602 - prepare SELECT RAD2DEG(10000) using SQL::Statement ok 603 - execute SELECT RAD2DEG(10000) using SQL::Statement ok 604 - positive degrees - rad2deg(10000) => near? 197.795130823273 ~= 197.795130823273 ok 605 - prepare SELECT TANH(100) using SQL::Statement ok 606 - execute SELECT TANH(100) using SQL::Statement ok 607 - tanh 100 => near? 1 ~= 1 ok 608 - prepare SELECT COTH(100) using SQL::Statement ok 609 - execute SELECT COTH(100) using SQL::Statement ok 610 - coth 100 => near? 1 ~= 1 ok 611 - prepare SELECT TANH(-100) using SQL::Statement ok 612 - execute SELECT TANH(-100) using SQL::Statement ok 613 - tanh -100 => near? -1 ~= -1 ok 614 - prepare SELECT COTH(-100) using SQL::Statement ok 615 - execute SELECT COTH(-100) using SQL::Statement ok 616 - coth -100 => near? -1 ~= -1 ok 617 - prepare SELECT SECH(100000) using SQL::Statement ok 618 - execute SELECT SECH(100000) using SQL::Statement ok 619 - sech 1e5 => near? 0 ~= 0 ok 620 - prepare SELECT CSCH(100000) using SQL::Statement ok 621 - execute SELECT CSCH(100000) using SQL::Statement ok 622 - csch 1e5 => near? 0 ~= 0 ok 623 - prepare SELECT TANH(100000) using SQL::Statement ok 624 - execute SELECT TANH(100000) using SQL::Statement ok 625 - tanh 1e5 => near? 1 ~= 1 ok 626 - prepare SELECT COTH(100000) using SQL::Statement ok 627 - execute SELECT COTH(100000) using SQL::Statement ok 628 - coth 1e5 => near? 1 ~= 1 ok 629 - prepare SELECT SECH(-100000) using SQL::Statement ok 630 - execute SELECT SECH(-100000) using SQL::Statement ok 631 - sech -1e5 => near? 0 ~= 0 ok 632 - prepare SELECT CSCH(-100000) using SQL::Statement ok 633 - execute SELECT CSCH(-100000) using SQL::Statement ok 634 - csch -1e5 => near? 0 ~= 0 ok 635 - prepare SELECT TANH(-100000) using SQL::Statement ok 636 - execute SELECT TANH(-100000) using SQL::Statement ok 637 - tanh -1e5 => near? -1 ~= -1 ok 638 - prepare SELECT COTH(-100000) using SQL::Statement ok 639 - execute SELECT COTH(-100000) using SQL::Statement ok 640 - coth -1e5 => near? -1 ~= -1 ok 641 - prepare SELECT DBNAME() using SQL::Statement ok 642 - execute SELECT DBNAME() using SQL::Statement ok 643 - dbname ok 644 - prepare SELECT USERNAME() using SQL::Statement ok 645 - execute SELECT USERNAME() using SQL::Statement ok 646 - username ok 647 - prepare SELECT USER() using SQL::Statement ok 648 - execute SELECT USER() using SQL::Statement ok 649 - user ok 650 - prepare SELECT id,host,signature,message FROM log WHERE time_stamp < (1356761626 - ( 4 * 60 )) using SQL::Statement ok 651 - execute SELECT id,host,signature,message FROM log WHERE time_stamp < (1356761626 - ( 4 * 60 )) using SQL::Statement ok 652 - SELECT with calculation in WHERE CLAUSE ok 653 - prepare SELECT id,host,signature,message FROM log WHERE (time_stamp > (1356761626 - 5)) AND (time_stamp < (1356761626 + 5)) using SQL::Statement ok 654 - execute SELECT id,host,signature,message FROM log WHERE (time_stamp > (1356761626 - 5)) AND (time_stamp < (1356761626 + 5)) using SQL::Statement ok 655 - SELECT with calculation and logical expression in WHERE CLAUSE ok 656 - prepare SELECT id,host,signature,message FROM log WHERE time_stamp BETWEEN ( 1356761626 - 5, 1356761626 + 5) using SQL::Statement ok 657 - execute SELECT id,host,signature,message FROM log WHERE time_stamp BETWEEN ( 1356761626 - 5, 1356761626 + 5) using SQL::Statement ok 658 - SELECT with calculated items in BETWEEN in WHERE CLAUSE ok 659 - prepare SELECT MAX(time_stamp) FROM log WHERE time_stamp IN (1356761626 - (2*3600), 1356761626 - (4*3600)) using SQL::Statement ok 660 - execute SELECT MAX(time_stamp) FROM log WHERE time_stamp IN (1356761626 - (2*3600), 1356761626 - (4*3600)) using SQL::Statement ok 661 - MAX() with calculated WHERE clause ok 662 - prepare SELECT MAX(time_stamp - 3*3600) FROM log using SQL::Statement ok 663 - execute SELECT MAX(time_stamp - 3*3600) FROM log using SQL::Statement ok 664 - calculation in MAX() not ok 665 - prepare SELECT MAX(time_stamp) - 3*3600 FROM log using SQL::Statement # TODO Known limitation. Parser/Engine can not handle properly # Failed (TODO) test 'prepare SELECT MAX(time_stamp) - 3*3600 FROM log using SQL::Statement' # at t/06virtual.t line 1434. # Bad table or column name: 'MAX' is a SQL reserved word! ok 666 - prepare SELECT MAX( CHAR_LENGTH(message) ) FROM log using SQL::Statement ok 667 - execute SELECT MAX( CHAR_LENGTH(message) ) FROM log using SQL::Statement ok 668 - function in MAX() ok 669 - prepare SELECT 1+0 from log using SQL::Statement ok 670 - execute SELECT 1+0 from log using SQL::Statement ok 671 - select simple calculated constant from table ok 672 - prepare SELECT 1+1*2 using SQL::Statement ok 673 - execute SELECT 1+1*2 using SQL::Statement ok 674 - select calculated constant with preceedence rules ok 675 - prepare SELECT 1 using SQL::Statement ok 676 - execute SELECT 1 using SQL::Statement ok 677 - SELECT not calculated constant # Running tests for DBD::CSV ok 678 - prepare CREATE TABLE biz (sales INTEGER, class CHAR, color CHAR, BUGNULL CHAR) on DBD::CSV ok 679 - execute CREATE TABLE biz (sales INTEGER, class CHAR, color CHAR, BUGNULL CHAR) on DBD::CSV ok 680 - prepare INSERT INTO biz VALUES (1000, 'Car', 'White', NULL) on DBD::CSV ok 681 - execute INSERT INTO biz VALUES (1000, 'Car', 'White', NULL) on DBD::CSV ok 682 - prepare INSERT INTO biz VALUES ( 500, 'Car', 'Blue', NULL ) on DBD::CSV ok 683 - execute INSERT INTO biz VALUES ( 500, 'Car', 'Blue', NULL ) on DBD::CSV ok 684 - prepare INSERT INTO biz VALUES ( 400, 'Truck', 'White', NULL ) on DBD::CSV ok 685 - execute INSERT INTO biz VALUES ( 400, 'Truck', 'White', NULL ) on DBD::CSV ok 686 - prepare INSERT INTO biz VALUES ( 700, 'Car', 'Red', NULL ) on DBD::CSV ok 687 - execute INSERT INTO biz VALUES ( 700, 'Car', 'Red', NULL ) on DBD::CSV ok 688 - prepare INSERT INTO biz VALUES ( 300, 'Truck', 'White', NULL ) on DBD::CSV ok 689 - execute INSERT INTO biz VALUES ( 300, 'Truck', 'White', NULL ) on DBD::CSV ok 690 - prepare CREATE TABLE baz (ordered INTEGER, class CHAR, color CHAR) on DBD::CSV ok 691 - execute CREATE TABLE baz (ordered INTEGER, class CHAR, color CHAR) on DBD::CSV ok 692 - prepare INSERT INTO baz VALUES ( 250, 'Car', 'White' ), ( 100, 'Car', 'Blue' ), ( 150, 'Car', 'Red' ) on DBD::CSV ok 693 - execute INSERT INTO baz VALUES ( 250, 'Car', 'White' ), ( 100, 'Car', 'Blue' ), ( 150, 'Car', 'Red' ) on DBD::CSV ok 694 - prepare INSERT INTO baz VALUES ( 80, 'Truck', 'White' ), ( 60, 'Truck', 'Green' ) -- Yes, we introduce new cars :) on DBD::CSV ok 695 - execute INSERT INTO baz VALUES ( 80, 'Truck', 'White' ), ( 60, 'Truck', 'Green' ) -- Yes, we introduce new cars :) on DBD::CSV ok 696 - prepare CREATE TABLE numbers (c_foo INTEGER, foo CHAR, bar INTEGER) on DBD::CSV ok 697 - execute CREATE TABLE numbers (c_foo INTEGER, foo CHAR, bar INTEGER) on DBD::CSV ok 698 - prepare CREATE TABLE trick (id INTEGER, foo CHAR) on DBD::CSV ok 699 - execute CREATE TABLE trick (id INTEGER, foo CHAR) on DBD::CSV ok 700 - prepare INSERT INTO trick VALUES (1, '1foo') on DBD::CSV ok 701 - execute INSERT INTO trick VALUES (1, '1foo') on DBD::CSV ok 702 - prepare INSERT INTO trick VALUES (11, 'foo') on DBD::CSV ok 703 - execute INSERT INTO trick VALUES (11, 'foo') on DBD::CSV ok 704 - prepare CREATE TYPE TIMESTAMP on DBD::CSV ok 705 - execute CREATE TYPE TIMESTAMP on DBD::CSV ok 706 - prepare CREATE TABLE log (id INT, host CHAR, signature CHAR, message CHAR, time_stamp TIMESTAMP) on DBD::CSV ok 707 - execute CREATE TABLE log (id INT, host CHAR, signature CHAR, message CHAR, time_stamp TIMESTAMP) on DBD::CSV ok 708 - prepare INSERT INTO log VALUES (1, 'bert', '/netbsd', 'Copyright (c) 1996, 1997, 1998, 1999, 2000, 2001, 2002, 2003, 2004, 2005,', 1356761629) on DBD::CSV ok 709 - execute INSERT INTO log VALUES (1, 'bert', '/netbsd', 'Copyright (c) 1996, 1997, 1998, 1999, 2000, 2001, 2002, 2003, 2004, 2005,', 1356761629) on DBD::CSV ok 710 - prepare INSERT INTO log VALUES (2, 'bert', '/netbsd', '2006, 2007, 2008, 2009, 2010', 1356761629) on DBD::CSV ok 711 - execute INSERT INTO log VALUES (2, 'bert', '/netbsd', '2006, 2007, 2008, 2009, 2010', 1356761629) on DBD::CSV ok 712 - prepare INSERT INTO log VALUES (3, 'bert', '/netbsd', 'The NetBSD Foundation, Inc. All rights reserved.', 1356761629) on DBD::CSV ok 713 - execute INSERT INTO log VALUES (3, 'bert', '/netbsd', 'The NetBSD Foundation, Inc. All rights reserved.', 1356761629) on DBD::CSV ok 714 - prepare INSERT INTO log VALUES (4, 'bert', '/netbsd', 'Copyright (c) 1982, 1986, 1989, 1991, 1993', 1356761629) on DBD::CSV ok 715 - execute INSERT INTO log VALUES (4, 'bert', '/netbsd', 'Copyright (c) 1982, 1986, 1989, 1991, 1993', 1356761629) on DBD::CSV ok 716 - prepare INSERT INTO log VALUES (5, 'bert', '/netbsd', 'The Regents of the University of California. All rights reserved.', 1356761629) on DBD::CSV ok 717 - execute INSERT INTO log VALUES (5, 'bert', '/netbsd', 'The Regents of the University of California. All rights reserved.', 1356761629) on DBD::CSV ok 718 - prepare INSERT INTO log VALUES (6, 'bert', '/netbsd', '', 1356761629) on DBD::CSV ok 719 - execute INSERT INTO log VALUES (6, 'bert', '/netbsd', '', 1356761629) on DBD::CSV ok 720 - prepare INSERT INTO log VALUES (7, 'bert', '/netbsd', 'NetBSD 5.99.39 (BERT) \#0: Fri Oct 8 06:23:03 CEST 2010', 1356761629) on DBD::CSV ok 721 - execute INSERT INTO log VALUES (7, 'bert', '/netbsd', 'NetBSD 5.99.39 (BERT) \#0: Fri Oct 8 06:23:03 CEST 2010', 1356761629) on DBD::CSV ok 722 - prepare INSERT INTO log VALUES (8, 'ernie', 'rpc.statd', 'starting', 1356758029) on DBD::CSV ok 723 - execute INSERT INTO log VALUES (8, 'ernie', 'rpc.statd', 'starting', 1356758029) on DBD::CSV ok 724 - prepare INSERT INTO log VALUES (9, 'ernie', 'savecore', 'no core dump', 1356754429) on DBD::CSV ok 725 - execute INSERT INTO log VALUES (9, 'ernie', 'savecore', 'no core dump', 1356754429) on DBD::CSV ok 726 - prepare INSERT INTO log VALUES (10, 'ernie', 'postfix/postfix-script', 'starting the Postfix mail system', 1356750829) on DBD::CSV ok 727 - execute INSERT INTO log VALUES (10, 'ernie', 'postfix/postfix-script', 'starting the Postfix mail system', 1356750829) on DBD::CSV ok 728 - prepare INSERT INTO log VALUES (11, 'ernie', 'rpcbind', 'connect from 127.0.0.1 to dump()', 1356747229) on DBD::CSV ok 729 - execute INSERT INTO log VALUES (11, 'ernie', 'rpcbind', 'connect from 127.0.0.1 to dump()', 1356747229) on DBD::CSV ok 730 - prepare INSERT INTO log VALUES (12, 'ernie', 'sshd', 'last message repeated 2 times', 1356743629) on DBD::CSV ok 731 - execute INSERT INTO log VALUES (12, 'ernie', 'sshd', 'last message repeated 2 times', 1356743629) on DBD::CSV ok 732 - prepare INSERT INTO log VALUES (13, 'ernie', 'shutdown', 'poweroff by root:', 1356740029) on DBD::CSV ok 733 - execute INSERT INTO log VALUES (13, 'ernie', 'shutdown', 'poweroff by root:', 1356740029) on DBD::CSV ok 734 - prepare INSERT INTO log VALUES (14, 'ernie', 'shutdown', 'rebooted by root', 1356736429) on DBD::CSV ok 735 - execute INSERT INTO log VALUES (14, 'ernie', 'shutdown', 'rebooted by root', 1356736429) on DBD::CSV ok 736 - prepare INSERT INTO log VALUES (15, 'ernie', 'sshd', 'Server listening on :: port 22.', 1356732829) on DBD::CSV ok 737 - execute INSERT INTO log VALUES (15, 'ernie', 'sshd', 'Server listening on :: port 22.', 1356732829) on DBD::CSV ok 738 - prepare INSERT INTO log VALUES (16, 'ernie', 'sshd', 'Server listening on 0.0.0.0 port 22.', 1356729229) on DBD::CSV ok 739 - execute INSERT INTO log VALUES (16, 'ernie', 'sshd', 'Server listening on 0.0.0.0 port 22.', 1356729229) on DBD::CSV ok 740 - prepare INSERT INTO log VALUES (17, 'ernie', 'sshd', 'Received SIGHUP; restarting.', 1356725629) on DBD::CSV ok 741 - execute INSERT INTO log VALUES (17, 'ernie', 'sshd', 'Received SIGHUP; restarting.', 1356725629) on DBD::CSV ok 742 - prepare SELECT class,SUM(sales) as foo, MAX(sales) FROM biz GROUP BY class using DBD::CSV ok 743 - execute SELECT class,SUM(sales) as foo, MAX(sales) FROM biz GROUP BY class using DBD::CSV Dubious, test returned 255 (wstat 65280, 0xff00) All 743 subtests passed (3 TODO tests unexpectedly succeeded) Can't call method "command" on an undefined value at t/TestLib.pm line 378. # Tests were run but no plan was declared and done_testing() was not seen. t/08join.t ......... # DBD::DBM->VERSION() of 0.03 doesn't satisfy requirement of 0.06 # DBD::File->VERSION() of 0.37 doesn't satisfy requirement of 0.4 # DBI->VERSION() of 1.609 doesn't satisfy requirement of 1.616 # # Using required: # # SQL::Statement: 1.402 # # Using recommended: # # DBD::CSV: 0.3 # # MLDBM: 2.04 # Running tests for SQL::Statement ok 1 - prepare CREATE TEMP TABLE Prof (pname CHAR, pid INT) on SQL::Statement ok 2 - execute CREATE TEMP TABLE Prof (pname CHAR, pid INT) on SQL::Statement ok 3 - prepare INSERT INTO Prof VALUES ('Sue', 1) on SQL::Statement ok 4 - execute INSERT INTO Prof VALUES ('Sue', 1) on SQL::Statement ok 5 - prepare INSERT INTO Prof VALUES ('Bob', 2) on SQL::Statement ok 6 - execute INSERT INTO Prof VALUES ('Bob', 2) on SQL::Statement ok 7 - prepare INSERT INTO Prof VALUES ('Tom', 3) on SQL::Statement ok 8 - execute INSERT INTO Prof VALUES ('Tom', 3) on SQL::Statement ok 9 - prepare CREATE TEMP TABLE Subject (sname CHAR, pid INT) on SQL::Statement ok 10 - execute CREATE TEMP TABLE Subject (sname CHAR, pid INT) on SQL::Statement ok 11 - prepare INSERT INTO Subject VALUES ('Chem', 1) on SQL::Statement ok 12 - execute INSERT INTO Subject VALUES ('Chem', 1) on SQL::Statement ok 13 - prepare INSERT INTO Subject VALUES ('Bio', 2) on SQL::Statement ok 14 - execute INSERT INTO Subject VALUES ('Bio', 2) on SQL::Statement ok 15 - prepare INSERT INTO Subject VALUES ('Math', 2) on SQL::Statement ok 16 - execute INSERT INTO Subject VALUES ('Math', 2) on SQL::Statement ok 17 - prepare INSERT INTO Subject VALUES ('English', 4) on SQL::Statement ok 18 - execute INSERT INTO Subject VALUES ('English', 4) on SQL::Statement ok 19 - prepare CREATE TEMP TABLE Room (rname CHAR, pid INT) on SQL::Statement ok 20 - execute CREATE TEMP TABLE Room (rname CHAR, pid INT) on SQL::Statement ok 21 - prepare INSERT INTO Room VALUES ('1C', 1) on SQL::Statement ok 22 - execute INSERT INTO Room VALUES ('1C', 1) on SQL::Statement ok 23 - prepare INSERT INTO Room VALUES ('2B', 2) on SQL::Statement ok 24 - execute INSERT INTO Room VALUES ('2B', 2) on SQL::Statement ok 25 - prepare CREATE TEMP TABLE author (author_name CHAR, author_id INT) on SQL::Statement ok 26 - execute CREATE TEMP TABLE author (author_name CHAR, author_id INT) on SQL::Statement ok 27 - prepare INSERT INTO author VALUES ('Neal Stephenson',1) on SQL::Statement ok 28 - execute INSERT INTO author VALUES ('Neal Stephenson',1) on SQL::Statement ok 29 - prepare INSERT INTO author VALUES ('Vernor Vinge',2) on SQL::Statement ok 30 - execute INSERT INTO author VALUES ('Vernor Vinge',2) on SQL::Statement ok 31 - prepare CREATE TEMP TABLE book (book_title CHAR, author_id INT) on SQL::Statement ok 32 - execute CREATE TEMP TABLE book (book_title CHAR, author_id INT) on SQL::Statement ok 33 - prepare INSERT INTO book VALUES ('Cryptonomicon',1) on SQL::Statement ok 34 - execute INSERT INTO book VALUES ('Cryptonomicon',1) on SQL::Statement ok 35 - prepare INSERT INTO book VALUES ('Dahlgren',3) on SQL::Statement ok 36 - execute INSERT INTO book VALUES ('Dahlgren',3) on SQL::Statement ok 37 - prepare CREATE TEMP TABLE t1 (num INT, name CHAR) on SQL::Statement ok 38 - execute CREATE TEMP TABLE t1 (num INT, name CHAR) on SQL::Statement ok 39 - prepare INSERT INTO t1 VALUES (1,'a') on SQL::Statement ok 40 - execute INSERT INTO t1 VALUES (1,'a') on SQL::Statement ok 41 - prepare INSERT INTO t1 VALUES (2,'b') on SQL::Statement ok 42 - execute INSERT INTO t1 VALUES (2,'b') on SQL::Statement ok 43 - prepare INSERT INTO t1 VALUES (3,'c') on SQL::Statement ok 44 - execute INSERT INTO t1 VALUES (3,'c') on SQL::Statement ok 45 - prepare CREATE TEMP TABLE t2 (num INT, wert CHAR) on SQL::Statement ok 46 - execute CREATE TEMP TABLE t2 (num INT, wert CHAR) on SQL::Statement ok 47 - prepare INSERT INTO t2 VALUES (1,'xxx') on SQL::Statement ok 48 - execute INSERT INTO t2 VALUES (1,'xxx') on SQL::Statement ok 49 - prepare INSERT INTO t2 VALUES (3,'yyy') on SQL::Statement ok 50 - execute INSERT INTO t2 VALUES (3,'yyy') on SQL::Statement ok 51 - prepare INSERT INTO t2 VALUES (5,'zzz') on SQL::Statement ok 52 - execute INSERT INTO t2 VALUES (5,'zzz') on SQL::Statement ok 53 - prepare CREATE TEMP TABLE APPL (id INT, applname CHAR, appluniq CHAR, version CHAR, appl_type CHAR) on SQL::Statement ok 54 - execute CREATE TEMP TABLE APPL (id INT, applname CHAR, appluniq CHAR, version CHAR, appl_type CHAR) on SQL::Statement ok 55 - prepare INSERT INTO APPL VALUES ( 1, 'ZQF', 'ZFQLIN', '10.2.0.4', 'Oracle DB') on SQL::Statement ok 56 - execute INSERT INTO APPL VALUES ( 1, 'ZQF', 'ZFQLIN', '10.2.0.4', 'Oracle DB') on SQL::Statement ok 57 - prepare INSERT INTO APPL VALUES ( 2, 'YRA', 'YRA-UX', '10.2.0.2', 'Oracle DB') on SQL::Statement ok 58 - execute INSERT INTO APPL VALUES ( 2, 'YRA', 'YRA-UX', '10.2.0.2', 'Oracle DB') on SQL::Statement ok 59 - prepare INSERT INTO APPL VALUES ( 3, 'PRN1', 'PRN1-4.B2', '1.1.22', 'CUPS' ) on SQL::Statement ok 60 - execute INSERT INTO APPL VALUES ( 3, 'PRN1', 'PRN1-4.B2', '1.1.22', 'CUPS' ) on SQL::Statement ok 61 - prepare INSERT INTO APPL VALUES ( 4, 'PRN2', 'PRN2-4.B2', '1.1.22', 'CUPS' ) on SQL::Statement ok 62 - execute INSERT INTO APPL VALUES ( 4, 'PRN2', 'PRN2-4.B2', '1.1.22', 'CUPS' ) on SQL::Statement ok 63 - prepare INSERT INTO APPL VALUES ( 5, 'PRN1', 'PRN1-4.B1', '1.1.22', 'CUPS' ) on SQL::Statement ok 64 - execute INSERT INTO APPL VALUES ( 5, 'PRN1', 'PRN1-4.B1', '1.1.22', 'CUPS' ) on SQL::Statement ok 65 - prepare INSERT INTO APPL VALUES ( 7, 'PRN2', 'PRN2-4.B1', '1.1.22', 'CUPS' ) on SQL::Statement ok 66 - execute INSERT INTO APPL VALUES ( 7, 'PRN2', 'PRN2-4.B1', '1.1.22', 'CUPS' ) on SQL::Statement ok 67 - prepare INSERT INTO APPL VALUES ( 8, 'sql-stmt', 'SQL::Statement', '1.21', 'Project Web-Site') on SQL::Statement ok 68 - execute INSERT INTO APPL VALUES ( 8, 'sql-stmt', 'SQL::Statement', '1.21', 'Project Web-Site') on SQL::Statement ok 69 - prepare INSERT INTO APPL VALUES ( 9, 'cpan.org', 'http://www.cpan.org/', '1.0', 'Web-Site') on SQL::Statement ok 70 - execute INSERT INTO APPL VALUES ( 9, 'cpan.org', 'http://www.cpan.org/', '1.0', 'Web-Site') on SQL::Statement ok 71 - prepare INSERT INTO APPL VALUES (10, 'httpd', 'cpan-apache', '2.2.13', 'Web-Server') on SQL::Statement ok 72 - execute INSERT INTO APPL VALUES (10, 'httpd', 'cpan-apache', '2.2.13', 'Web-Server') on SQL::Statement ok 73 - prepare INSERT INTO APPL VALUES (11, 'cpan-mods', 'cpan-mods', '8.4.1', 'PostgreSQL DB') on SQL::Statement ok 74 - execute INSERT INTO APPL VALUES (11, 'cpan-mods', 'cpan-mods', '8.4.1', 'PostgreSQL DB') on SQL::Statement ok 75 - prepare INSERT INTO APPL VALUES (12, 'cpan-authors', 'cpan-authors', '8.4.1', 'PostgreSQL DB') on SQL::Statement ok 76 - execute INSERT INTO APPL VALUES (12, 'cpan-authors', 'cpan-authors', '8.4.1', 'PostgreSQL DB') on SQL::Statement ok 77 - prepare CREATE TEMP TABLE NODE (id INT, nodename CHAR, os CHAR, version CHAR) on SQL::Statement ok 78 - execute CREATE TEMP TABLE NODE (id INT, nodename CHAR, os CHAR, version CHAR) on SQL::Statement ok 79 - prepare INSERT INTO NODE VALUES ( 1, 'ernie', 'RHEL', '5.2') on SQL::Statement ok 80 - execute INSERT INTO NODE VALUES ( 1, 'ernie', 'RHEL', '5.2') on SQL::Statement ok 81 - prepare INSERT INTO NODE VALUES ( 2, 'bert', 'RHEL', '5.2') on SQL::Statement ok 82 - execute INSERT INTO NODE VALUES ( 2, 'bert', 'RHEL', '5.2') on SQL::Statement ok 83 - prepare INSERT INTO NODE VALUES ( 3, 'statler', 'FreeBSD', '7.2') on SQL::Statement ok 84 - execute INSERT INTO NODE VALUES ( 3, 'statler', 'FreeBSD', '7.2') on SQL::Statement ok 85 - prepare INSERT INTO NODE VALUES ( 4, 'waldorf', 'FreeBSD', '7.2') on SQL::Statement ok 86 - execute INSERT INTO NODE VALUES ( 4, 'waldorf', 'FreeBSD', '7.2') on SQL::Statement ok 87 - prepare INSERT INTO NODE VALUES ( 5, 'piggy', 'NetBSD', '5.0.2') on SQL::Statement ok 88 - execute INSERT INTO NODE VALUES ( 5, 'piggy', 'NetBSD', '5.0.2') on SQL::Statement ok 89 - prepare INSERT INTO NODE VALUES ( 6, 'kermit', 'NetBSD', '5.0.2') on SQL::Statement ok 90 - execute INSERT INTO NODE VALUES ( 6, 'kermit', 'NetBSD', '5.0.2') on SQL::Statement ok 91 - prepare INSERT INTO NODE VALUES ( 7, 'samson', 'NetBSD', '5.0.2') on SQL::Statement ok 92 - execute INSERT INTO NODE VALUES ( 7, 'samson', 'NetBSD', '5.0.2') on SQL::Statement ok 93 - prepare INSERT INTO NODE VALUES ( 8, 'tiffy', 'NetBSD', '5.0.2') on SQL::Statement ok 94 - execute INSERT INTO NODE VALUES ( 8, 'tiffy', 'NetBSD', '5.0.2') on SQL::Statement ok 95 - prepare INSERT INTO NODE VALUES ( 9, 'rowlf', 'Debian Lenny', '5.0') on SQL::Statement ok 96 - execute INSERT INTO NODE VALUES ( 9, 'rowlf', 'Debian Lenny', '5.0') on SQL::Statement ok 97 - prepare INSERT INTO NODE VALUES (10, 'fozzy', 'Debian Lenny', '5.0') on SQL::Statement ok 98 - execute INSERT INTO NODE VALUES (10, 'fozzy', 'Debian Lenny', '5.0') on SQL::Statement ok 99 - prepare CREATE TEMP TABLE PREC (id INT, appl_id INT, node_id INT, precedence INT) on SQL::Statement ok 100 - execute CREATE TEMP TABLE PREC (id INT, appl_id INT, node_id INT, precedence INT) on SQL::Statement ok 101 - prepare INSERT INTO PREC VALUES ( 1, 1, 1, 1) on SQL::Statement ok 102 - execute INSERT INTO PREC VALUES ( 1, 1, 1, 1) on SQL::Statement ok 103 - prepare INSERT INTO PREC VALUES ( 2, 1, 2, 2) on SQL::Statement ok 104 - execute INSERT INTO PREC VALUES ( 2, 1, 2, 2) on SQL::Statement ok 105 - prepare INSERT INTO PREC VALUES ( 3, 2, 2, 1) on SQL::Statement ok 106 - execute INSERT INTO PREC VALUES ( 3, 2, 2, 1) on SQL::Statement ok 107 - prepare INSERT INTO PREC VALUES ( 4, 2, 1, 2) on SQL::Statement ok 108 - execute INSERT INTO PREC VALUES ( 4, 2, 1, 2) on SQL::Statement ok 109 - prepare INSERT INTO PREC VALUES ( 5, 3, 5, 1) on SQL::Statement ok 110 - execute INSERT INTO PREC VALUES ( 5, 3, 5, 1) on SQL::Statement ok 111 - prepare INSERT INTO PREC VALUES ( 6, 3, 7, 2) on SQL::Statement ok 112 - execute INSERT INTO PREC VALUES ( 6, 3, 7, 2) on SQL::Statement ok 113 - prepare INSERT INTO PREC VALUES ( 7, 4, 6, 1) on SQL::Statement ok 114 - execute INSERT INTO PREC VALUES ( 7, 4, 6, 1) on SQL::Statement ok 115 - prepare INSERT INTO PREC VALUES ( 8, 4, 8, 2) on SQL::Statement ok 116 - execute INSERT INTO PREC VALUES ( 8, 4, 8, 2) on SQL::Statement ok 117 - prepare INSERT INTO PREC VALUES ( 9, 5, 7, 1) on SQL::Statement ok 118 - execute INSERT INTO PREC VALUES ( 9, 5, 7, 1) on SQL::Statement ok 119 - prepare INSERT INTO PREC VALUES (10, 5, 5, 2) on SQL::Statement ok 120 - execute INSERT INTO PREC VALUES (10, 5, 5, 2) on SQL::Statement ok 121 - prepare INSERT INTO PREC VALUES (11, 6, 8, 1) on SQL::Statement ok 122 - execute INSERT INTO PREC VALUES (11, 6, 8, 1) on SQL::Statement ok 123 - prepare INSERT INTO PREC VALUES (12, 7, 6, 2) on SQL::Statement ok 124 - execute INSERT INTO PREC VALUES (12, 7, 6, 2) on SQL::Statement ok 125 - prepare INSERT INTO PREC VALUES (13, 10, 9, 1) on SQL::Statement ok 126 - execute INSERT INTO PREC VALUES (13, 10, 9, 1) on SQL::Statement ok 127 - prepare INSERT INTO PREC VALUES (14, 10, 10, 1) on SQL::Statement ok 128 - execute INSERT INTO PREC VALUES (14, 10, 10, 1) on SQL::Statement ok 129 - prepare INSERT INTO PREC VALUES (15, 8, 9, 1) on SQL::Statement ok 130 - execute INSERT INTO PREC VALUES (15, 8, 9, 1) on SQL::Statement ok 131 - prepare INSERT INTO PREC VALUES (16, 8, 10, 1) on SQL::Statement ok 132 - execute INSERT INTO PREC VALUES (16, 8, 10, 1) on SQL::Statement ok 133 - prepare INSERT INTO PREC VALUES (17, 9, 9, 1) on SQL::Statement ok 134 - execute INSERT INTO PREC VALUES (17, 9, 9, 1) on SQL::Statement ok 135 - prepare INSERT INTO PREC VALUES (18, 9, 10, 1) on SQL::Statement ok 136 - execute INSERT INTO PREC VALUES (18, 9, 10, 1) on SQL::Statement ok 137 - prepare INSERT INTO PREC VALUES (19, 11, 3, 1) on SQL::Statement ok 138 - execute INSERT INTO PREC VALUES (19, 11, 3, 1) on SQL::Statement ok 139 - prepare INSERT INTO PREC VALUES (20, 11, 4, 2) on SQL::Statement ok 140 - execute INSERT INTO PREC VALUES (20, 11, 4, 2) on SQL::Statement ok 141 - prepare INSERT INTO PREC VALUES (21, 12, 4, 1) on SQL::Statement ok 142 - execute INSERT INTO PREC VALUES (21, 12, 4, 1) on SQL::Statement ok 143 - prepare INSERT INTO PREC VALUES (22, 12, 3, 2) on SQL::Statement ok 144 - execute INSERT INTO PREC VALUES (22, 12, 3, 2) on SQL::Statement ok 145 - prepare CREATE TEMP TABLE LANDSCAPE (id INT, landscapename CHAR) on SQL::Statement ok 146 - execute CREATE TEMP TABLE LANDSCAPE (id INT, landscapename CHAR) on SQL::Statement ok 147 - prepare INSERT INTO LANDSCAPE VALUES (1, 'Logistic') on SQL::Statement ok 148 - execute INSERT INTO LANDSCAPE VALUES (1, 'Logistic') on SQL::Statement ok 149 - prepare INSERT INTO LANDSCAPE VALUES (2, 'Infrastructure') on SQL::Statement ok 150 - execute INSERT INTO LANDSCAPE VALUES (2, 'Infrastructure') on SQL::Statement ok 151 - prepare INSERT INTO LANDSCAPE VALUES (3, 'CPAN') on SQL::Statement ok 152 - execute INSERT INTO LANDSCAPE VALUES (3, 'CPAN') on SQL::Statement ok 153 - prepare CREATE TEMP TABLE CONTACT (id INT, surname CHAR, familyname CHAR, phone CHAR, userid CHAR, mailaddr CHAR) on SQL::Statement ok 154 - execute CREATE TEMP TABLE CONTACT (id INT, surname CHAR, familyname CHAR, phone CHAR, userid CHAR, mailaddr CHAR) on SQL::Statement ok 155 - prepare INSERT INTO CONTACT VALUES ( 1, 'Hans Peter', 'Mueller', '12345', 'HPMUE', 'hp-mueller@here.com') on SQL::Statement ok 156 - execute INSERT INTO CONTACT VALUES ( 1, 'Hans Peter', 'Mueller', '12345', 'HPMUE', 'hp-mueller@here.com') on SQL::Statement ok 157 - prepare INSERT INTO CONTACT VALUES ( 2, 'Knut', 'Inge', '54321', 'KINGE', 'k-inge@here.com') on SQL::Statement ok 158 - execute INSERT INTO CONTACT VALUES ( 2, 'Knut', 'Inge', '54321', 'KINGE', 'k-inge@here.com') on SQL::Statement ok 159 - prepare INSERT INTO CONTACT VALUES ( 3, 'Lola', 'Nguyen', '+1-123-45678-90', 'LNYUG', 'lola.ngyuen@customer.com') on SQL::Statement ok 160 - execute INSERT INTO CONTACT VALUES ( 3, 'Lola', 'Nguyen', '+1-123-45678-90', 'LNYUG', 'lola.ngyuen@customer.com') on SQL::Statement ok 161 - prepare INSERT INTO CONTACT VALUES ( 4, 'Helge', 'Brunft', '+41-123-45678-09', 'HBRUN', 'helge.brunft@external-dc.at') on SQL::Statement ok 162 - execute INSERT INTO CONTACT VALUES ( 4, 'Helge', 'Brunft', '+41-123-45678-09', 'HBRUN', 'helge.brunft@external-dc.at') on SQL::Statement ok 163 - prepare CREATE TEMP TABLE NM_LANDSCAPE (id INT, ls_id INT, obj_id INT, obj_type INT) on SQL::Statement ok 164 - execute CREATE TEMP TABLE NM_LANDSCAPE (id INT, ls_id INT, obj_id INT, obj_type INT) on SQL::Statement ok 165 - prepare INSERT INTO NM_LANDSCAPE VALUES ( 1, 1, 1, 2) on SQL::Statement ok 166 - execute INSERT INTO NM_LANDSCAPE VALUES ( 1, 1, 1, 2) on SQL::Statement ok 167 - prepare INSERT INTO NM_LANDSCAPE VALUES ( 2, 1, 2, 2) on SQL::Statement ok 168 - execute INSERT INTO NM_LANDSCAPE VALUES ( 2, 1, 2, 2) on SQL::Statement ok 169 - prepare INSERT INTO NM_LANDSCAPE VALUES ( 3, 3, 3, 2) on SQL::Statement ok 170 - execute INSERT INTO NM_LANDSCAPE VALUES ( 3, 3, 3, 2) on SQL::Statement ok 171 - prepare INSERT INTO NM_LANDSCAPE VALUES ( 4, 3, 4, 2) on SQL::Statement ok 172 - execute INSERT INTO NM_LANDSCAPE VALUES ( 4, 3, 4, 2) on SQL::Statement ok 173 - prepare INSERT INTO NM_LANDSCAPE VALUES ( 5, 2, 5, 2) on SQL::Statement ok 174 - execute INSERT INTO NM_LANDSCAPE VALUES ( 5, 2, 5, 2) on SQL::Statement ok 175 - prepare INSERT INTO NM_LANDSCAPE VALUES ( 6, 2, 6, 2) on SQL::Statement ok 176 - execute INSERT INTO NM_LANDSCAPE VALUES ( 6, 2, 6, 2) on SQL::Statement ok 177 - prepare INSERT INTO NM_LANDSCAPE VALUES ( 7, 2, 7, 2) on SQL::Statement ok 178 - execute INSERT INTO NM_LANDSCAPE VALUES ( 7, 2, 7, 2) on SQL::Statement ok 179 - prepare INSERT INTO NM_LANDSCAPE VALUES ( 8, 2, 8, 2) on SQL::Statement ok 180 - execute INSERT INTO NM_LANDSCAPE VALUES ( 8, 2, 8, 2) on SQL::Statement ok 181 - prepare INSERT INTO NM_LANDSCAPE VALUES ( 9, 3, 9, 2) on SQL::Statement ok 182 - execute INSERT INTO NM_LANDSCAPE VALUES ( 9, 3, 9, 2) on SQL::Statement ok 183 - prepare INSERT INTO NM_LANDSCAPE VALUES (10, 3,10, 2) on SQL::Statement ok 184 - execute INSERT INTO NM_LANDSCAPE VALUES (10, 3,10, 2) on SQL::Statement ok 185 - prepare INSERT INTO NM_LANDSCAPE VALUES (11, 1, 1, 1) on SQL::Statement ok 186 - execute INSERT INTO NM_LANDSCAPE VALUES (11, 1, 1, 1) on SQL::Statement ok 187 - prepare INSERT INTO NM_LANDSCAPE VALUES (12, 2, 2, 1) on SQL::Statement ok 188 - execute INSERT INTO NM_LANDSCAPE VALUES (12, 2, 2, 1) on SQL::Statement ok 189 - prepare INSERT INTO NM_LANDSCAPE VALUES (13, 2, 2, 3) on SQL::Statement ok 190 - execute INSERT INTO NM_LANDSCAPE VALUES (13, 2, 2, 3) on SQL::Statement ok 191 - prepare INSERT INTO NM_LANDSCAPE VALUES (14, 3, 1, 3) on SQL::Statement ok 192 - execute INSERT INTO NM_LANDSCAPE VALUES (14, 3, 1, 3) on SQL::Statement ok 193 - prepare CREATE TEMP TABLE APPL_CONTACT (id INT, contact_id INT, appl_id INT, contact_type CHAR) on SQL::Statement ok 194 - execute CREATE TEMP TABLE APPL_CONTACT (id INT, contact_id INT, appl_id INT, contact_type CHAR) on SQL::Statement ok 195 - prepare INSERT INTO APPL_CONTACT VALUES (1, 3, 1, 'OWNER') on SQL::Statement ok 196 - execute INSERT INTO APPL_CONTACT VALUES (1, 3, 1, 'OWNER') on SQL::Statement ok 197 - prepare INSERT INTO APPL_CONTACT VALUES (2, 3, 2, 'OWNER') on SQL::Statement ok 198 - execute INSERT INTO APPL_CONTACT VALUES (2, 3, 2, 'OWNER') on SQL::Statement ok 199 - prepare INSERT INTO APPL_CONTACT VALUES (3, 4, 3, 'ADMIN') on SQL::Statement ok 200 - execute INSERT INTO APPL_CONTACT VALUES (3, 4, 3, 'ADMIN') on SQL::Statement ok 201 - prepare INSERT INTO APPL_CONTACT VALUES (4, 4, 4, 'ADMIN') on SQL::Statement ok 202 - execute INSERT INTO APPL_CONTACT VALUES (4, 4, 4, 'ADMIN') on SQL::Statement ok 203 - prepare INSERT INTO APPL_CONTACT VALUES (5, 4, 5, 'ADMIN') on SQL::Statement ok 204 - execute INSERT INTO APPL_CONTACT VALUES (5, 4, 5, 'ADMIN') on SQL::Statement ok 205 - prepare INSERT INTO APPL_CONTACT VALUES (6, 4, 6, 'ADMIN') on SQL::Statement ok 206 - execute INSERT INTO APPL_CONTACT VALUES (6, 4, 6, 'ADMIN') on SQL::Statement ok 207 - prepare SELECT pname,sname FROM Prof NATURAL JOIN Subject using SQL::Statement ok 208 - execute SELECT pname,sname FROM Prof NATURAL JOIN Subject using SQL::Statement ok 209 - NATURAL JOIN - with named columns in select list ok 210 - prepare SELECT * FROM Prof NATURAL JOIN Subject using SQL::Statement ok 211 - execute SELECT * FROM Prof NATURAL JOIN Subject using SQL::Statement ok 212 - NATURAL JOIN - with select list = * ok 213 - prepare SELECT UPPER(pname) AS P,Prof.pid,pname,sname FROM Prof NATURAL JOIN Subject using SQL::Statement ok 214 - execute SELECT UPPER(pname) AS P,Prof.pid,pname,sname FROM Prof NATURAL JOIN Subject using SQL::Statement ok 215 - NATURAL JOIN - with computed columns ok 216 - prepare SELECT UPPER(pname) AS P,pid,pname,sname FROM Prof NATURAL JOIN Subject using SQL::Statement ok 217 - execute SELECT UPPER(pname) AS P,pid,pname,sname FROM Prof NATURAL JOIN Subject using SQL::Statement ok 218 - NATURAL JOIN - with no specifier on join column ok 219 - prepare SELECT UPPER(pname) AS P,pid,pname,sname FROM Prof JOIN Subject using (pid) using SQL::Statement ok 220 - execute SELECT UPPER(pname) AS P,pid,pname,sname FROM Prof JOIN Subject using (pid) using SQL::Statement ok 221 - INNER JOIN - with no specifier on join column ok 222 - prepare SELECT * FROM Prof LEFT JOIN Subject USING(pid) using SQL::Statement ok 223 - execute SELECT * FROM Prof LEFT JOIN Subject USING(pid) using SQL::Statement ok 224 - LEFT JOIN ok 225 - prepare SELECT pid,pname,sname FROM Prof LEFT JOIN Subject USING(pid) using SQL::Statement ok 226 - execute SELECT pid,pname,sname FROM Prof LEFT JOIN Subject USING(pid) using SQL::Statement ok 227 - LEFT JOIN - enumerated columns ok 228 - prepare SELECT subject.pid,pname,sname FROM Prof LEFT JOIN Subject USING(pid) using SQL::Statement ok 229 - execute SELECT subject.pid,pname,sname FROM Prof LEFT JOIN Subject USING(pid) using SQL::Statement ok 230 - LEFT JOIN - perversely intentionally mis-enumerated columns ok 231 - prepare SELECT subject.pid, pname, sname FROM prof LEFT JOIN subject USING(pid) using SQL::Statement ok 232 - execute SELECT subject.pid, pname, sname FROM prof LEFT JOIN subject USING(pid) using SQL::Statement ok 233 - LEFT JOIN - lower case keywords ok 234 - prepare SELECT * FROM Prof RIGHT JOIN Subject USING(pid) using SQL::Statement ok 235 - execute SELECT * FROM Prof RIGHT JOIN Subject USING(pid) using SQL::Statement ok 236 - RIGHT JOIN ok 237 - prepare SELECT pid,sname,pname FROM Prof RIGHT JOIN Subject USING(pid) using SQL::Statement ok 238 - execute SELECT pid,sname,pname FROM Prof RIGHT JOIN Subject USING(pid) using SQL::Statement ok 239 - RIGHT JOIN - enumerated columns ok 240 - prepare SELECT * FROM Prof FULL JOIN Subject USING(pid) using SQL::Statement ok 241 - execute SELECT * FROM Prof FULL JOIN Subject USING(pid) using SQL::Statement ok 242 - FULL JOIN ok 243 - prepare SELECT * FROM Prof AS P,Subject AS S WHERE P.pid=S.pid using SQL::Statement ok 244 - execute SELECT * FROM Prof AS P,Subject AS S WHERE P.pid=S.pid using SQL::Statement ok 245 - IMPLICIT JOIN - two tables ok 246 - prepare SELECT * # FROM Prof AS P,Subject AS S,Room AS R # WHERE P.pid=S.pid # AND P.pid=R.pid using SQL::Statement ok 247 - execute SELECT * # FROM Prof AS P,Subject AS S,Room AS R # WHERE P.pid=S.pid # AND P.pid=R.pid using SQL::Statement ok 248 - IMPLICIT JOIN - three tables ok 249 - prepare SELECT * FROM author NATURAL JOIN book using SQL::Statement ok 250 - execute SELECT * FROM author NATURAL JOIN book using SQL::Statement ok 251 - Columns in NATURAL JOIN - on unique id's with select list = * ok 252 - NATURAL JOIN - on unique id's with select list = * ok 253 - prepare SELECT * FROM t1 CROSS JOIN t2 using SQL::Statement ok 254 - execute SELECT * FROM t1 CROSS JOIN t2 using SQL::Statement ok 255 - Columns in CROSS JOIN with select list = * ok 256 - CROSS JOIN with select list = * ok 257 - prepare SELECT * FROM t1 INNER JOIN t2 ON t1.num = t2.num using SQL::Statement ok 258 - execute SELECT * FROM t1 INNER JOIN t2 ON t1.num = t2.num using SQL::Statement ok 259 - Columns in INNER JOIN with select list = * ok 260 - INNER JOIN with select list = * ok 261 - prepare SELECT * FROM t1 INNER JOIN t2 USING (num) using SQL::Statement ok 262 - execute SELECT * FROM t1 INNER JOIN t2 USING (num) using SQL::Statement ok 263 - Columns in INNER JOINS (USING) with select list = * ok 264 - INNER JOINS (USING) with select list = * ok 265 - prepare SELECT * FROM t1 NATURAL INNER JOIN t2 using SQL::Statement ok 266 - execute SELECT * FROM t1 NATURAL INNER JOIN t2 using SQL::Statement ok 267 - Columns in INNER JOINS (NATURAL) with select list = * ok 268 - INNER JOINS (NATURAL) with select list = * ok 269 - prepare SELECT * FROM t1 LEFT JOIN t2 ON t1.num = t2.num using SQL::Statement ok 270 - execute SELECT * FROM t1 LEFT JOIN t2 ON t1.num = t2.num using SQL::Statement ok 271 - Columns in LEFT JOINS (using ON condition) with select list = * ok 272 - LEFT JOINS (using ON condition) with select list = * ok 273 - prepare SELECT * FROM t1 LEFT JOIN t2 USING (num) using SQL::Statement ok 274 - execute SELECT * FROM t1 LEFT JOIN t2 USING (num) using SQL::Statement ok 275 - Columns in LEFT JOINS (USING (num) condition) with select list = * ok 276 - LEFT JOINS (USING (num) condition) with select list = * ok 277 - prepare SELECT * FROM t1 RIGHT JOIN t2 ON t1.num = t2.num using SQL::Statement ok 278 - execute SELECT * FROM t1 RIGHT JOIN t2 ON t1.num = t2.num using SQL::Statement ok 279 - Columns in Right Joins (using ON condition) with select list = * ok 280 - Right Joins (using ON condition) with select list = * ok 281 - prepare SELECT * FROM t2 LEFT JOIN t1 ON t1.num = t2.num using SQL::Statement ok 282 - execute SELECT * FROM t2 LEFT JOIN t1 ON t1.num = t2.num using SQL::Statement ok 283 - Columns in Left Joins (reverse former Right Join) with select list = * ok 284 - Left Joins (reverse former Right Join) with select list = * ok 285 - prepare SELECT * FROM t1 FULL JOIN t2 ON t1.num = t2.num using SQL::Statement ok 286 - execute SELECT * FROM t1 FULL JOIN t2 ON t1.num = t2.num using SQL::Statement ok 287 - Columns in Full Joins (using ON condition) with select list = * ok 288 - Full Joins (using ON condition) with select list = * # break here ok 289 - prepare SELECT * FROM t1 LEFT JOIN t2 ON t1.num = t2.num AND t2.wert = 'xxx' using SQL::Statement # TODO Analyze ok 290 - execute SELECT * FROM t1 LEFT JOIN t2 ON t1.num = t2.num AND t2.wert = 'xxx' using SQL::Statement # TODO Analyze ok 291 - Columns in Left Joins (using ON t1.num = t2.num AND t2.wert = "xxx") with select list = * # TODO Analyze not ok 292 - Left Joins (using ON t1.num = t2.num AND t2.wert = "xxx") with select list = * # TODO Analyze # Failed (TODO) test 'Left Joins (using ON t1.num = t2.num AND t2.wert = "xxx") with select list = *' # at t/08join.t line 675. # Structures begin differing at: # $got->[2][2] = '3' # $expected->[2][2] = undef # break here ok 293 - prepare SELECT * FROM t1 LEFT JOIN t2 ON t1.num = t2.num WHERE (t2.wert = 'xxx' OR t2.wert IS NULL) using SQL::Statement # TODO Analyze ok 294 - execute SELECT * FROM t1 LEFT JOIN t2 ON t1.num = t2.num WHERE (t2.wert = 'xxx' OR t2.wert IS NULL) using SQL::Statement # TODO Analyze ok 295 - Columns in Left Joins (using ON t1.num = t2.num WHERE (t2.wert = "xxx" OR t2.wert IS NULL)) with select list = * # TODO Analyze not ok 296 - Left Joins (using ON t1.num = t2.num WHERE (t2.wert = "xxx" OR t2.wert IS NULL)) with select list = * # TODO Analyze # Failed (TODO) test 'Left Joins (using ON t1.num = t2.num WHERE (t2.wert = "xxx" OR t2.wert IS NULL)) with select list = *' # at t/08join.t line 675. # Structures begin differing at: # $got->[2] = Does not exist # $expected->[2] = ARRAY(0x43a3440) ok 297 - prepare SELECT applname, appluniq, version, nodename # FROM APPL, PREC, NODE # WHERE appl_type LIKE '%DB' # AND APPL.id=PREC.appl_id # AND PREC.node_id=NODE.id using SQL::Statement ok 298 - execute SELECT applname, appluniq, version, nodename # FROM APPL, PREC, NODE # WHERE appl_type LIKE '%DB' # AND APPL.id=PREC.appl_id # AND PREC.node_id=NODE.id using SQL::Statement ok 299 - DEFAULT INNER (1) with named columns ok 300 - prepare SELECT applname, appluniq, version, landscapename, nodename # FROM APPL, PREC, NODE, LANDSCAPE, NM_LANDSCAPE # WHERE appl_type LIKE '%DB' # AND APPL.id=PREC.appl_id # AND PREC.node_id=NODE.id # AND NM_LANDSCAPE.obj_id=APPL.id # AND NM_LANDSCAPE.obj_type=1 # AND NM_LANDSCAPE.ls_id=LANDSCAPE.id using SQL::Statement ok 301 - execute SELECT applname, appluniq, version, landscapename, nodename # FROM APPL, PREC, NODE, LANDSCAPE, NM_LANDSCAPE # WHERE appl_type LIKE '%DB' # AND APPL.id=PREC.appl_id # AND PREC.node_id=NODE.id # AND NM_LANDSCAPE.obj_id=APPL.id # AND NM_LANDSCAPE.obj_type=1 # AND NM_LANDSCAPE.ls_id=LANDSCAPE.id using SQL::Statement ok 302 - DEFAULT INNER (2) with named columns ok 303 - prepare SELECT applname, appluniq, version, surname, familyname, phone, nodename # FROM APPL, PREC, NODE, CONTACT, APPL_CONTACT # WHERE appl_type='CUPS' # AND APPL.id=PREC.appl_id # AND PREC.node_id=NODE.id # AND APPL_CONTACT.appl_id=APPL.id # AND APPL_CONTACT.contact_id=CONTACT.id # AND PREC.PRECEDENCE=1 # ORDER BY appluniq DESC, applname ASC using SQL::Statement ok 304 - execute SELECT applname, appluniq, version, surname, familyname, phone, nodename # FROM APPL, PREC, NODE, CONTACT, APPL_CONTACT # WHERE appl_type='CUPS' # AND APPL.id=PREC.appl_id # AND PREC.node_id=NODE.id # AND APPL_CONTACT.appl_id=APPL.id # AND APPL_CONTACT.contact_id=CONTACT.id # AND PREC.PRECEDENCE=1 # ORDER BY appluniq DESC, applname ASC using SQL::Statement ok 305 - DEFAULT INNER (3) with named columns ok 306 - prepare SELECT DISTINCT applname, appluniq, version, surname, familyname, phone, nodename # FROM APPL, PREC, NODE, CONTACT, APPL_CONTACT # WHERE appl_type='CUPS' # AND APPL.id=PREC.appl_id # AND PREC.node_id=NODE.id # AND APPL_CONTACT.appl_id=APPL.id # AND APPL_CONTACT.contact_id=CONTACT.id # ORDER BY applname, appluniq, nodename using SQL::Statement ok 307 - execute SELECT DISTINCT applname, appluniq, version, surname, familyname, phone, nodename # FROM APPL, PREC, NODE, CONTACT, APPL_CONTACT # WHERE appl_type='CUPS' # AND APPL.id=PREC.appl_id # AND PREC.node_id=NODE.id # AND APPL_CONTACT.appl_id=APPL.id # AND APPL_CONTACT.contact_id=CONTACT.id # ORDER BY applname, appluniq, nodename using SQL::Statement ok 308 - DEFAULT INNER (4) with named columns ok 309 - prepare SELECT CONCAT('[% NOW %]') AS "timestamp", applname, appluniq, version, nodename # FROM APPL, PREC, NODE # WHERE appl_type LIKE '%DB' # AND APPL.id=PREC.appl_id # AND PREC.node_id=NODE.id using SQL::Statement ok 310 - execute SELECT CONCAT('[% NOW %]') AS "timestamp", applname, appluniq, version, nodename # FROM APPL, PREC, NODE # WHERE appl_type LIKE '%DB' # AND APPL.id=PREC.appl_id # AND PREC.node_id=NODE.id using SQL::Statement ok 311 - DEFAULT INNER (5) with named columns # break here ok 312 - prepare SELECT pname, sname, rname # FROM Prof p # JOIN Subject s # ON p.pid = s.pid # JOIN Room r # ON p.pid = r.pid # using SQL::Statement # TODO Not supported yet! ok 313 - execute SELECT pname, sname, rname # FROM Prof p # JOIN Subject s # ON p.pid = s.pid # JOIN Room r # ON p.pid = r.pid # using SQL::Statement fails # TODO Not supported yet! ok 314 - Complex INNER JOIN # TODO Not supported yet! # break here ok 315 - prepare SELECT pname, sname, rname # FROM Prof p # JOIN Subject s USING (pid) # JOIN Room r USING (pid) # using SQL::Statement fails # TODO Not supported yet! ok 316 - Complex INNER JOIN (using) # TODO Not supported yet! # break here ok 317 - prepare SELECT pname, sname, rname # FROM Prof NATURAL JOIN Subject NATURAL JOIN Room # using SQL::Statement fails # TODO Not supported yet! ok 318 - Complex NATURAL JOIN # TODO Not supported yet! # break here ok 319 - prepare SELECT pname, sname, rname # FROM Prof p # LEFT JOIN Subject s # ON p.pid = s.pid # LEFT JOIN Room r # ON p.pid = r.pid # using SQL::Statement # TODO Not supported yet! ok 320 - execute SELECT pname, sname, rname # FROM Prof p # LEFT JOIN Subject s # ON p.pid = s.pid # LEFT JOIN Room r # ON p.pid = r.pid # using SQL::Statement fails # TODO Not supported yet! ok 321 - Complex LEFT JOIN # TODO Not supported yet! # Running tests for DBD::CSV ok 322 - prepare CREATE TABLE Prof (pname CHAR, pid INT) on DBD::CSV ok 323 - execute CREATE TABLE Prof (pname CHAR, pid INT) on DBD::CSV ok 324 - prepare INSERT INTO Prof VALUES ('Sue', 1) on DBD::CSV ok 325 - execute INSERT INTO Prof VALUES ('Sue', 1) on DBD::CSV ok 326 - prepare INSERT INTO Prof VALUES ('Bob', 2) on DBD::CSV ok 327 - execute INSERT INTO Prof VALUES ('Bob', 2) on DBD::CSV ok 328 - prepare INSERT INTO Prof VALUES ('Tom', 3) on DBD::CSV ok 329 - execute INSERT INTO Prof VALUES ('Tom', 3) on DBD::CSV ok 330 - prepare CREATE TABLE Subject (sname CHAR, pid INT) on DBD::CSV ok 331 - execute CREATE TABLE Subject (sname CHAR, pid INT) on DBD::CSV ok 332 - prepare INSERT INTO Subject VALUES ('Chem', 1) on DBD::CSV ok 333 - execute INSERT INTO Subject VALUES ('Chem', 1) on DBD::CSV ok 334 - prepare INSERT INTO Subject VALUES ('Bio', 2) on DBD::CSV ok 335 - execute INSERT INTO Subject VALUES ('Bio', 2) on DBD::CSV ok 336 - prepare INSERT INTO Subject VALUES ('Math', 2) on DBD::CSV ok 337 - execute INSERT INTO Subject VALUES ('Math', 2) on DBD::CSV ok 338 - prepare INSERT INTO Subject VALUES ('English', 4) on DBD::CSV ok 339 - execute INSERT INTO Subject VALUES ('English', 4) on DBD::CSV ok 340 - prepare CREATE TABLE Room (rname CHAR, pid INT) on DBD::CSV ok 341 - execute CREATE TABLE Room (rname CHAR, pid INT) on DBD::CSV ok 342 - prepare INSERT INTO Room VALUES ('1C', 1) on DBD::CSV ok 343 - execute INSERT INTO Room VALUES ('1C', 1) on DBD::CSV ok 344 - prepare INSERT INTO Room VALUES ('2B', 2) on DBD::CSV ok 345 - execute INSERT INTO Room VALUES ('2B', 2) on DBD::CSV ok 346 - prepare CREATE TABLE author (author_name CHAR, author_id INT) on DBD::CSV ok 347 - execute CREATE TABLE author (author_name CHAR, author_id INT) on DBD::CSV ok 348 - prepare INSERT INTO author VALUES ('Neal Stephenson',1) on DBD::CSV ok 349 - execute INSERT INTO author VALUES ('Neal Stephenson',1) on DBD::CSV ok 350 - prepare INSERT INTO author VALUES ('Vernor Vinge',2) on DBD::CSV ok 351 - execute INSERT INTO author VALUES ('Vernor Vinge',2) on DBD::CSV ok 352 - prepare CREATE TABLE book (book_title CHAR, author_id INT) on DBD::CSV ok 353 - execute CREATE TABLE book (book_title CHAR, author_id INT) on DBD::CSV ok 354 - prepare INSERT INTO book VALUES ('Cryptonomicon',1) on DBD::CSV ok 355 - execute INSERT INTO book VALUES ('Cryptonomicon',1) on DBD::CSV ok 356 - prepare INSERT INTO book VALUES ('Dahlgren',3) on DBD::CSV ok 357 - execute INSERT INTO book VALUES ('Dahlgren',3) on DBD::CSV ok 358 - prepare CREATE TABLE t1 (num INT, name CHAR) on DBD::CSV ok 359 - execute CREATE TABLE t1 (num INT, name CHAR) on DBD::CSV ok 360 - prepare INSERT INTO t1 VALUES (1,'a') on DBD::CSV ok 361 - execute INSERT INTO t1 VALUES (1,'a') on DBD::CSV ok 362 - prepare INSERT INTO t1 VALUES (2,'b') on DBD::CSV ok 363 - execute INSERT INTO t1 VALUES (2,'b') on DBD::CSV ok 364 - prepare INSERT INTO t1 VALUES (3,'c') on DBD::CSV ok 365 - execute INSERT INTO t1 VALUES (3,'c') on DBD::CSV ok 366 - prepare CREATE TABLE t2 (num INT, wert CHAR) on DBD::CSV ok 367 - execute CREATE TABLE t2 (num INT, wert CHAR) on DBD::CSV ok 368 - prepare INSERT INTO t2 VALUES (1,'xxx') on DBD::CSV ok 369 - execute INSERT INTO t2 VALUES (1,'xxx') on DBD::CSV ok 370 - prepare INSERT INTO t2 VALUES (3,'yyy') on DBD::CSV ok 371 - execute INSERT INTO t2 VALUES (3,'yyy') on DBD::CSV ok 372 - prepare INSERT INTO t2 VALUES (5,'zzz') on DBD::CSV ok 373 - execute INSERT INTO t2 VALUES (5,'zzz') on DBD::CSV ok 374 - prepare CREATE TABLE APPL (id INT, applname CHAR, appluniq CHAR, version CHAR, appl_type CHAR) on DBD::CSV ok 375 - execute CREATE TABLE APPL (id INT, applname CHAR, appluniq CHAR, version CHAR, appl_type CHAR) on DBD::CSV ok 376 - prepare INSERT INTO APPL VALUES ( 1, 'ZQF', 'ZFQLIN', '10.2.0.4', 'Oracle DB') on DBD::CSV ok 377 - execute INSERT INTO APPL VALUES ( 1, 'ZQF', 'ZFQLIN', '10.2.0.4', 'Oracle DB') on DBD::CSV ok 378 - prepare INSERT INTO APPL VALUES ( 2, 'YRA', 'YRA-UX', '10.2.0.2', 'Oracle DB') on DBD::CSV ok 379 - execute INSERT INTO APPL VALUES ( 2, 'YRA', 'YRA-UX', '10.2.0.2', 'Oracle DB') on DBD::CSV ok 380 - prepare INSERT INTO APPL VALUES ( 3, 'PRN1', 'PRN1-4.B2', '1.1.22', 'CUPS' ) on DBD::CSV ok 381 - execute INSERT INTO APPL VALUES ( 3, 'PRN1', 'PRN1-4.B2', '1.1.22', 'CUPS' ) on DBD::CSV ok 382 - prepare INSERT INTO APPL VALUES ( 4, 'PRN2', 'PRN2-4.B2', '1.1.22', 'CUPS' ) on DBD::CSV ok 383 - execute INSERT INTO APPL VALUES ( 4, 'PRN2', 'PRN2-4.B2', '1.1.22', 'CUPS' ) on DBD::CSV ok 384 - prepare INSERT INTO APPL VALUES ( 5, 'PRN1', 'PRN1-4.B1', '1.1.22', 'CUPS' ) on DBD::CSV ok 385 - execute INSERT INTO APPL VALUES ( 5, 'PRN1', 'PRN1-4.B1', '1.1.22', 'CUPS' ) on DBD::CSV ok 386 - prepare INSERT INTO APPL VALUES ( 7, 'PRN2', 'PRN2-4.B1', '1.1.22', 'CUPS' ) on DBD::CSV ok 387 - execute INSERT INTO APPL VALUES ( 7, 'PRN2', 'PRN2-4.B1', '1.1.22', 'CUPS' ) on DBD::CSV ok 388 - prepare INSERT INTO APPL VALUES ( 8, 'sql-stmt', 'SQL::Statement', '1.21', 'Project Web-Site') on DBD::CSV ok 389 - execute INSERT INTO APPL VALUES ( 8, 'sql-stmt', 'SQL::Statement', '1.21', 'Project Web-Site') on DBD::CSV ok 390 - prepare INSERT INTO APPL VALUES ( 9, 'cpan.org', 'http://www.cpan.org/', '1.0', 'Web-Site') on DBD::CSV ok 391 - execute INSERT INTO APPL VALUES ( 9, 'cpan.org', 'http://www.cpan.org/', '1.0', 'Web-Site') on DBD::CSV ok 392 - prepare INSERT INTO APPL VALUES (10, 'httpd', 'cpan-apache', '2.2.13', 'Web-Server') on DBD::CSV ok 393 - execute INSERT INTO APPL VALUES (10, 'httpd', 'cpan-apache', '2.2.13', 'Web-Server') on DBD::CSV ok 394 - prepare INSERT INTO APPL VALUES (11, 'cpan-mods', 'cpan-mods', '8.4.1', 'PostgreSQL DB') on DBD::CSV ok 395 - execute INSERT INTO APPL VALUES (11, 'cpan-mods', 'cpan-mods', '8.4.1', 'PostgreSQL DB') on DBD::CSV ok 396 - prepare INSERT INTO APPL VALUES (12, 'cpan-authors', 'cpan-authors', '8.4.1', 'PostgreSQL DB') on DBD::CSV ok 397 - execute INSERT INTO APPL VALUES (12, 'cpan-authors', 'cpan-authors', '8.4.1', 'PostgreSQL DB') on DBD::CSV ok 398 - prepare CREATE TABLE NODE (id INT, nodename CHAR, os CHAR, version CHAR) on DBD::CSV ok 399 - execute CREATE TABLE NODE (id INT, nodename CHAR, os CHAR, version CHAR) on DBD::CSV ok 400 - prepare INSERT INTO NODE VALUES ( 1, 'ernie', 'RHEL', '5.2') on DBD::CSV ok 401 - execute INSERT INTO NODE VALUES ( 1, 'ernie', 'RHEL', '5.2') on DBD::CSV ok 402 - prepare INSERT INTO NODE VALUES ( 2, 'bert', 'RHEL', '5.2') on DBD::CSV ok 403 - execute INSERT INTO NODE VALUES ( 2, 'bert', 'RHEL', '5.2') on DBD::CSV ok 404 - prepare INSERT INTO NODE VALUES ( 3, 'statler', 'FreeBSD', '7.2') on DBD::CSV ok 405 - execute INSERT INTO NODE VALUES ( 3, 'statler', 'FreeBSD', '7.2') on DBD::CSV ok 406 - prepare INSERT INTO NODE VALUES ( 4, 'waldorf', 'FreeBSD', '7.2') on DBD::CSV ok 407 - execute INSERT INTO NODE VALUES ( 4, 'waldorf', 'FreeBSD', '7.2') on DBD::CSV ok 408 - prepare INSERT INTO NODE VALUES ( 5, 'piggy', 'NetBSD', '5.0.2') on DBD::CSV ok 409 - execute INSERT INTO NODE VALUES ( 5, 'piggy', 'NetBSD', '5.0.2') on DBD::CSV ok 410 - prepare INSERT INTO NODE VALUES ( 6, 'kermit', 'NetBSD', '5.0.2') on DBD::CSV ok 411 - execute INSERT INTO NODE VALUES ( 6, 'kermit', 'NetBSD', '5.0.2') on DBD::CSV ok 412 - prepare INSERT INTO NODE VALUES ( 7, 'samson', 'NetBSD', '5.0.2') on DBD::CSV ok 413 - execute INSERT INTO NODE VALUES ( 7, 'samson', 'NetBSD', '5.0.2') on DBD::CSV ok 414 - prepare INSERT INTO NODE VALUES ( 8, 'tiffy', 'NetBSD', '5.0.2') on DBD::CSV ok 415 - execute INSERT INTO NODE VALUES ( 8, 'tiffy', 'NetBSD', '5.0.2') on DBD::CSV ok 416 - prepare INSERT INTO NODE VALUES ( 9, 'rowlf', 'Debian Lenny', '5.0') on DBD::CSV ok 417 - execute INSERT INTO NODE VALUES ( 9, 'rowlf', 'Debian Lenny', '5.0') on DBD::CSV ok 418 - prepare INSERT INTO NODE VALUES (10, 'fozzy', 'Debian Lenny', '5.0') on DBD::CSV ok 419 - execute INSERT INTO NODE VALUES (10, 'fozzy', 'Debian Lenny', '5.0') on DBD::CSV ok 420 - prepare CREATE TABLE PREC (id INT, appl_id INT, node_id INT, precedence INT) on DBD::CSV ok 421 - execute CREATE TABLE PREC (id INT, appl_id INT, node_id INT, precedence INT) on DBD::CSV ok 422 - prepare INSERT INTO PREC VALUES ( 1, 1, 1, 1) on DBD::CSV ok 423 - execute INSERT INTO PREC VALUES ( 1, 1, 1, 1) on DBD::CSV ok 424 - prepare INSERT INTO PREC VALUES ( 2, 1, 2, 2) on DBD::CSV ok 425 - execute INSERT INTO PREC VALUES ( 2, 1, 2, 2) on DBD::CSV ok 426 - prepare INSERT INTO PREC VALUES ( 3, 2, 2, 1) on DBD::CSV ok 427 - execute INSERT INTO PREC VALUES ( 3, 2, 2, 1) on DBD::CSV ok 428 - prepare INSERT INTO PREC VALUES ( 4, 2, 1, 2) on DBD::CSV ok 429 - execute INSERT INTO PREC VALUES ( 4, 2, 1, 2) on DBD::CSV ok 430 - prepare INSERT INTO PREC VALUES ( 5, 3, 5, 1) on DBD::CSV ok 431 - execute INSERT INTO PREC VALUES ( 5, 3, 5, 1) on DBD::CSV ok 432 - prepare INSERT INTO PREC VALUES ( 6, 3, 7, 2) on DBD::CSV ok 433 - execute INSERT INTO PREC VALUES ( 6, 3, 7, 2) on DBD::CSV ok 434 - prepare INSERT INTO PREC VALUES ( 7, 4, 6, 1) on DBD::CSV ok 435 - execute INSERT INTO PREC VALUES ( 7, 4, 6, 1) on DBD::CSV ok 436 - prepare INSERT INTO PREC VALUES ( 8, 4, 8, 2) on DBD::CSV ok 437 - execute INSERT INTO PREC VALUES ( 8, 4, 8, 2) on DBD::CSV ok 438 - prepare INSERT INTO PREC VALUES ( 9, 5, 7, 1) on DBD::CSV ok 439 - execute INSERT INTO PREC VALUES ( 9, 5, 7, 1) on DBD::CSV ok 440 - prepare INSERT INTO PREC VALUES (10, 5, 5, 2) on DBD::CSV ok 441 - execute INSERT INTO PREC VALUES (10, 5, 5, 2) on DBD::CSV ok 442 - prepare INSERT INTO PREC VALUES (11, 6, 8, 1) on DBD::CSV ok 443 - execute INSERT INTO PREC VALUES (11, 6, 8, 1) on DBD::CSV ok 444 - prepare INSERT INTO PREC VALUES (12, 7, 6, 2) on DBD::CSV ok 445 - execute INSERT INTO PREC VALUES (12, 7, 6, 2) on DBD::CSV ok 446 - prepare INSERT INTO PREC VALUES (13, 10, 9, 1) on DBD::CSV ok 447 - execute INSERT INTO PREC VALUES (13, 10, 9, 1) on DBD::CSV ok 448 - prepare INSERT INTO PREC VALUES (14, 10, 10, 1) on DBD::CSV ok 449 - execute INSERT INTO PREC VALUES (14, 10, 10, 1) on DBD::CSV ok 450 - prepare INSERT INTO PREC VALUES (15, 8, 9, 1) on DBD::CSV ok 451 - execute INSERT INTO PREC VALUES (15, 8, 9, 1) on DBD::CSV ok 452 - prepare INSERT INTO PREC VALUES (16, 8, 10, 1) on DBD::CSV ok 453 - execute INSERT INTO PREC VALUES (16, 8, 10, 1) on DBD::CSV ok 454 - prepare INSERT INTO PREC VALUES (17, 9, 9, 1) on DBD::CSV ok 455 - execute INSERT INTO PREC VALUES (17, 9, 9, 1) on DBD::CSV ok 456 - prepare INSERT INTO PREC VALUES (18, 9, 10, 1) on DBD::CSV ok 457 - execute INSERT INTO PREC VALUES (18, 9, 10, 1) on DBD::CSV ok 458 - prepare INSERT INTO PREC VALUES (19, 11, 3, 1) on DBD::CSV ok 459 - execute INSERT INTO PREC VALUES (19, 11, 3, 1) on DBD::CSV ok 460 - prepare INSERT INTO PREC VALUES (20, 11, 4, 2) on DBD::CSV ok 461 - execute INSERT INTO PREC VALUES (20, 11, 4, 2) on DBD::CSV ok 462 - prepare INSERT INTO PREC VALUES (21, 12, 4, 1) on DBD::CSV ok 463 - execute INSERT INTO PREC VALUES (21, 12, 4, 1) on DBD::CSV ok 464 - prepare INSERT INTO PREC VALUES (22, 12, 3, 2) on DBD::CSV ok 465 - execute INSERT INTO PREC VALUES (22, 12, 3, 2) on DBD::CSV ok 466 - prepare CREATE TABLE LANDSCAPE (id INT, landscapename CHAR) on DBD::CSV ok 467 - execute CREATE TABLE LANDSCAPE (id INT, landscapename CHAR) on DBD::CSV ok 468 - prepare INSERT INTO LANDSCAPE VALUES (1, 'Logistic') on DBD::CSV ok 469 - execute INSERT INTO LANDSCAPE VALUES (1, 'Logistic') on DBD::CSV ok 470 - prepare INSERT INTO LANDSCAPE VALUES (2, 'Infrastructure') on DBD::CSV ok 471 - execute INSERT INTO LANDSCAPE VALUES (2, 'Infrastructure') on DBD::CSV ok 472 - prepare INSERT INTO LANDSCAPE VALUES (3, 'CPAN') on DBD::CSV ok 473 - execute INSERT INTO LANDSCAPE VALUES (3, 'CPAN') on DBD::CSV ok 474 - prepare CREATE TABLE CONTACT (id INT, surname CHAR, familyname CHAR, phone CHAR, userid CHAR, mailaddr CHAR) on DBD::CSV ok 475 - execute CREATE TABLE CONTACT (id INT, surname CHAR, familyname CHAR, phone CHAR, userid CHAR, mailaddr CHAR) on DBD::CSV ok 476 - prepare INSERT INTO CONTACT VALUES ( 1, 'Hans Peter', 'Mueller', '12345', 'HPMUE', 'hp-mueller@here.com') on DBD::CSV ok 477 - execute INSERT INTO CONTACT VALUES ( 1, 'Hans Peter', 'Mueller', '12345', 'HPMUE', 'hp-mueller@here.com') on DBD::CSV ok 478 - prepare INSERT INTO CONTACT VALUES ( 2, 'Knut', 'Inge', '54321', 'KINGE', 'k-inge@here.com') on DBD::CSV ok 479 - execute INSERT INTO CONTACT VALUES ( 2, 'Knut', 'Inge', '54321', 'KINGE', 'k-inge@here.com') on DBD::CSV ok 480 - prepare INSERT INTO CONTACT VALUES ( 3, 'Lola', 'Nguyen', '+1-123-45678-90', 'LNYUG', 'lola.ngyuen@customer.com') on DBD::CSV ok 481 - execute INSERT INTO CONTACT VALUES ( 3, 'Lola', 'Nguyen', '+1-123-45678-90', 'LNYUG', 'lola.ngyuen@customer.com') on DBD::CSV ok 482 - prepare INSERT INTO CONTACT VALUES ( 4, 'Helge', 'Brunft', '+41-123-45678-09', 'HBRUN', 'helge.brunft@external-dc.at') on DBD::CSV ok 483 - execute INSERT INTO CONTACT VALUES ( 4, 'Helge', 'Brunft', '+41-123-45678-09', 'HBRUN', 'helge.brunft@external-dc.at') on DBD::CSV ok 484 - prepare CREATE TABLE NM_LANDSCAPE (id INT, ls_id INT, obj_id INT, obj_type INT) on DBD::CSV ok 485 - execute CREATE TABLE NM_LANDSCAPE (id INT, ls_id INT, obj_id INT, obj_type INT) on DBD::CSV ok 486 - prepare INSERT INTO NM_LANDSCAPE VALUES ( 1, 1, 1, 2) on DBD::CSV ok 487 - execute INSERT INTO NM_LANDSCAPE VALUES ( 1, 1, 1, 2) on DBD::CSV ok 488 - prepare INSERT INTO NM_LANDSCAPE VALUES ( 2, 1, 2, 2) on DBD::CSV ok 489 - execute INSERT INTO NM_LANDSCAPE VALUES ( 2, 1, 2, 2) on DBD::CSV ok 490 - prepare INSERT INTO NM_LANDSCAPE VALUES ( 3, 3, 3, 2) on DBD::CSV ok 491 - execute INSERT INTO NM_LANDSCAPE VALUES ( 3, 3, 3, 2) on DBD::CSV ok 492 - prepare INSERT INTO NM_LANDSCAPE VALUES ( 4, 3, 4, 2) on DBD::CSV ok 493 - execute INSERT INTO NM_LANDSCAPE VALUES ( 4, 3, 4, 2) on DBD::CSV ok 494 - prepare INSERT INTO NM_LANDSCAPE VALUES ( 5, 2, 5, 2) on DBD::CSV ok 495 - execute INSERT INTO NM_LANDSCAPE VALUES ( 5, 2, 5, 2) on DBD::CSV ok 496 - prepare INSERT INTO NM_LANDSCAPE VALUES ( 6, 2, 6, 2) on DBD::CSV ok 497 - execute INSERT INTO NM_LANDSCAPE VALUES ( 6, 2, 6, 2) on DBD::CSV ok 498 - prepare INSERT INTO NM_LANDSCAPE VALUES ( 7, 2, 7, 2) on DBD::CSV ok 499 - execute INSERT INTO NM_LANDSCAPE VALUES ( 7, 2, 7, 2) on DBD::CSV ok 500 - prepare INSERT INTO NM_LANDSCAPE VALUES ( 8, 2, 8, 2) on DBD::CSV ok 501 - execute INSERT INTO NM_LANDSCAPE VALUES ( 8, 2, 8, 2) on DBD::CSV ok 502 - prepare INSERT INTO NM_LANDSCAPE VALUES ( 9, 3, 9, 2) on DBD::CSV ok 503 - execute INSERT INTO NM_LANDSCAPE VALUES ( 9, 3, 9, 2) on DBD::CSV ok 504 - prepare INSERT INTO NM_LANDSCAPE VALUES (10, 3,10, 2) on DBD::CSV ok 505 - execute INSERT INTO NM_LANDSCAPE VALUES (10, 3,10, 2) on DBD::CSV ok 506 - prepare INSERT INTO NM_LANDSCAPE VALUES (11, 1, 1, 1) on DBD::CSV ok 507 - execute INSERT INTO NM_LANDSCAPE VALUES (11, 1, 1, 1) on DBD::CSV ok 508 - prepare INSERT INTO NM_LANDSCAPE VALUES (12, 2, 2, 1) on DBD::CSV ok 509 - execute INSERT INTO NM_LANDSCAPE VALUES (12, 2, 2, 1) on DBD::CSV ok 510 - prepare INSERT INTO NM_LANDSCAPE VALUES (13, 2, 2, 3) on DBD::CSV ok 511 - execute INSERT INTO NM_LANDSCAPE VALUES (13, 2, 2, 3) on DBD::CSV ok 512 - prepare INSERT INTO NM_LANDSCAPE VALUES (14, 3, 1, 3) on DBD::CSV ok 513 - execute INSERT INTO NM_LANDSCAPE VALUES (14, 3, 1, 3) on DBD::CSV ok 514 - prepare CREATE TABLE APPL_CONTACT (id INT, contact_id INT, appl_id INT, contact_type CHAR) on DBD::CSV ok 515 - execute CREATE TABLE APPL_CONTACT (id INT, contact_id INT, appl_id INT, contact_type CHAR) on DBD::CSV ok 516 - prepare INSERT INTO APPL_CONTACT VALUES (1, 3, 1, 'OWNER') on DBD::CSV ok 517 - execute INSERT INTO APPL_CONTACT VALUES (1, 3, 1, 'OWNER') on DBD::CSV ok 518 - prepare INSERT INTO APPL_CONTACT VALUES (2, 3, 2, 'OWNER') on DBD::CSV ok 519 - execute INSERT INTO APPL_CONTACT VALUES (2, 3, 2, 'OWNER') on DBD::CSV ok 520 - prepare INSERT INTO APPL_CONTACT VALUES (3, 4, 3, 'ADMIN') on DBD::CSV ok 521 - execute INSERT INTO APPL_CONTACT VALUES (3, 4, 3, 'ADMIN') on DBD::CSV ok 522 - prepare INSERT INTO APPL_CONTACT VALUES (4, 4, 4, 'ADMIN') on DBD::CSV ok 523 - execute INSERT INTO APPL_CONTACT VALUES (4, 4, 4, 'ADMIN') on DBD::CSV ok 524 - prepare INSERT INTO APPL_CONTACT VALUES (5, 4, 5, 'ADMIN') on DBD::CSV ok 525 - execute INSERT INTO APPL_CONTACT VALUES (5, 4, 5, 'ADMIN') on DBD::CSV ok 526 - prepare INSERT INTO APPL_CONTACT VALUES (6, 4, 6, 'ADMIN') on DBD::CSV ok 527 - execute INSERT INTO APPL_CONTACT VALUES (6, 4, 6, 'ADMIN') on DBD::CSV ok 528 - prepare SELECT pname,sname FROM Prof NATURAL JOIN Subject using DBD::CSV ok 529 - execute SELECT pname,sname FROM Prof NATURAL JOIN Subject using DBD::CSV Dubious, test returned 255 (wstat 65280, 0xff00) All 529 subtests passed (10 TODO tests unexpectedly succeeded) t/09ops.t .......... 1..18 SQL::Statement v.1.402 ok 1 - unknwon type ok 2 - create type ok 3 - user-defined type ok 4 - known type ok 5 - drop type ok 6 - unknown type ok 7 - unknown keyword ok 8 - create keyword ok 9 - user-defined keyword ok 10 - known keyword ok 11 - drop keyword ok 12 - keyword as identifier ok 13 - unknown operator ok 14 - create operator ok 15 - user-defined operator ok 16 - known operator ok 17 - drop operator ok 18 - unkown operator ok t/10limit.t ........ 1..2 SQL::Statement v.1.402 ok 1 - limit with order by ok 2 - limit without order by ok t/12eval.t ......... 1..13 SQL::Statement v.1.402 ok 1 - eval row() ok 2 - eval column() ok 3 - eval params($val) ok 4 - eval params() ok 5 - eval column($tbl,$col) ok 6 - ram seek(bad whence) ok 7 - ram seek(bad index) ok 8 - ram seek(pos=2) ok 9 - $function->type ok 10 - $function->name ok 11 - $column->type ok 12 - function validate - no sub ok 13 - function validate ok t/17quoting.t ...... 1..44 ok 1 - use SQL::Statement; ok 2 - use SQL::Parser; ok 3 - CREATE TEMP TABLE "TBL WITH SPACES" (id INT, "COLUMN WITH SPACES" CHAR, "SET" INT) ok 4 - INSERT INTO "TBL WITH SPACES" VALUES (1, 'foo', 1) ok 5 - INSERT INTO "TBL WITH SPACES" VALUES (2, 'bar', 0) ok 6 - Parsing SELECT "TBL WITH SPACES"."COLUMN WITH SPACES" ...: ok 7 - SELECTED 1 row ok 8 - got 'foo' ok 9 - Parsing SELECT "COLUMN WITH SPACES" ...: ok 10 - SELECTED 1 row ok 11 - got 'foo' ok 12 - Parsing SELECT "COLUMN WITH SPACES" AS CWS ...: ok 13 - SELECTED 1 row ok 14 - got 'foo' ok 15 - CREATE TEMP TABLE T1 (id INT, "COLUMN WITH SPACES" CHAR, "SET" INT) ok 16 - # INSERT INTO T1 VALUES (1, 'foo', 1) ok 17 - # INSERT INTO T1 VALUES (2, 'bar', 0) # ok 18 - Parsing SELECT T1."COLUMN WITH SPACES" ...: ok 19 - SELECTED 1 row ok 20 - got 'foo' ok 21 - Parsing SELECT "COLUMN WITH SPACES" ...: ok 22 - SELECTED 1 row ok 23 - got 'foo' ok 24 - Parsing SELECT "COLUMN WITH SPACES" AS CWS ...: ok 25 - SELECTED 1 row ok 26 - got 'foo' ok 27 - CREATE TEMP TABLE "TBL WITH SPACES" (id INT, CWS CHAR, "SET" INT) ok 28 - # INSERT INTO "TBL WITH SPACES" VALUES (1, 'foo', 1) ok 29 - # INSERT INTO "TBL WITH SPACES" VALUES (2, 'bar', 0) # ok 30 - Parsing SELECT "TBL WITH SPACES".CWS ...: ok 31 - SELECTED 1 row ok 32 - got 'foo' ok 33 - Parsing SELECT CWS ...: ok 34 - SELECTED 1 row ok 35 - got 'foo' ok 36 - CREATE TEMP TABLE T1 (id INT, CWS CHAR, "SET" INT) ok 37 - # INSERT INTO T1 VALUES (1, 'foo', 1) ok 38 - # INSERT INTO T1 VALUES (2, 'bar', 0) # ok 39 - Parsing SELECT CWS ... WHERE "SET"=0: ok 40 - SELECTED 1 row ok 41 - got 'bar' ok 42 - Parsing SELECT "SET" ...: ok 43 - SELECTED 1 row ok 44 - got '0' for "SET" ok t/23dialects.t ..... 1..2 ok 1 ok 2 ok xt/pod-cm.t ........ 1..20 ok 1 - Spelling test for blib\lib\SQL\Eval.pm ok 2 - Spelling test for blib\lib\SQL\Parser.pm ok 3 - Spelling test for blib\lib\SQL\Statement.pm ok 4 - Spelling test for blib\lib\SQL\Dialects\ANSI.pm ok 5 - Spelling test for blib\lib\SQL\Dialects\AnyData.pm ok 6 - Spelling test for blib\lib\SQL\Dialects\CSV.pm ok 7 - Spelling test for blib\lib\SQL\Dialects\Role.pm ok 8 - Spelling test for blib\lib\SQL\Statement\Embed.pod ok 9 - Spelling test for blib\lib\SQL\Statement\Function.pm ok 10 - Spelling test for blib\lib\SQL\Statement\Functions.pm ok 11 - Spelling test for blib\lib\SQL\Statement\GetInfo.pm ok 12 - Spelling test for blib\lib\SQL\Statement\Operation.pm ok 13 - Spelling test for blib\lib\SQL\Statement\Placeholder.pm ok 14 - Spelling test for blib\lib\SQL\Statement\RAM.pm ok 15 - Spelling test for blib\lib\SQL\Statement\Roadmap.pod ok 16 - Spelling test for blib\lib\SQL\Statement\Structure.pod ok 17 - Spelling test for blib\lib\SQL\Statement\Syntax.pod ok 18 - Spelling test for blib\lib\SQL\Statement\Term.pm ok 19 - Spelling test for blib\lib\SQL\Statement\TermFactory.pm ok 20 - Spelling test for blib\lib\SQL\Statement\Util.pm ok xt/pod.t ........... 1..20 ok 1 - POD test for blib\lib\SQL\Eval.pm ok 2 - POD test for blib\lib\SQL\Parser.pm ok 3 - POD test for blib\lib\SQL\Statement.pm ok 4 - POD test for blib\lib\SQL\Dialects\ANSI.pm ok 5 - POD test for blib\lib\SQL\Dialects\AnyData.pm ok 6 - POD test for blib\lib\SQL\Dialects\CSV.pm ok 7 - POD test for blib\lib\SQL\Dialects\Role.pm ok 8 - POD test for blib\lib\SQL\Statement\Embed.pod ok 9 - POD test for blib\lib\SQL\Statement\Function.pm ok 10 - POD test for blib\lib\SQL\Statement\Functions.pm ok 11 - POD test for blib\lib\SQL\Statement\GetInfo.pm ok 12 - POD test for blib\lib\SQL\Statement\Operation.pm ok 13 - POD test for blib\lib\SQL\Statement\Placeholder.pm ok 14 - POD test for blib\lib\SQL\Statement\RAM.pm ok 15 - POD test for blib\lib\SQL\Statement\Roadmap.pod ok 16 - POD test for blib\lib\SQL\Statement\Structure.pod ok 17 - POD test for blib\lib\SQL\Statement\Syntax.pod ok 18 - POD test for blib\lib\SQL\Statement\Term.pm ok 19 - POD test for blib\lib\SQL\Statement\TermFactory.pm ok 20 - POD test for blib\lib\SQL\Statement\Util.pm ok xt/pod_coverage.t .. 1..16 ok 1 - Pod coverage on SQL::Eval ok 2 - Pod coverage on SQL::Parser ok 3 - Pod coverage on SQL::Statement ok 4 - Pod coverage on SQL::Dialects::ANSI ok 5 - Pod coverage on SQL::Dialects::AnyData ok 6 - Pod coverage on SQL::Dialects::CSV ok 7 - Pod coverage on SQL::Dialects::Role ok 8 - Pod coverage on SQL::Statement::Function ok 9 - Pod coverage on SQL::Statement::GetInfo ok 10 - Pod coverage on SQL::Statement::Operation ok 11 - Pod coverage on SQL::Statement::Placeholder ok 12 - Pod coverage on SQL::Statement::RAM ok 13 - Pod coverage on SQL::Statement::Term ok 14 - Pod coverage on SQL::Statement::TermFactory ok 15 - Pod coverage on SQL::Statement::Util ok 16 - Pod coverage on SQL::Statement::Functions ok Test Summary Report ------------------- t/01prepare.t (Wstat: 65280 Tests: 543 Failed: 0) TODO passed: 540-542 Non-zero exit status: 255 Parse errors: No plan found in TAP output t/02execute.t (Wstat: 6400 Tests: 78 Failed: 0) Non-zero exit status: 25 Parse errors: No plan found in TAP output t/03import.t (Wstat: 1280 Tests: 26 Failed: 5) Failed tests: 16, 18, 20, 22, 26 Non-zero exit status: 5 t/04idents.t (Wstat: 512 Tests: 43 Failed: 1) Failed test: 43 Non-zero exit status: 2 Parse errors: No plan found in TAP output t/05simple.t (Wstat: 6400 Tests: 253 Failed: 0) Non-zero exit status: 25 Parse errors: No plan found in TAP output t/06virtual.t (Wstat: 65280 Tests: 743 Failed: 0) TODO passed: 587-589 Non-zero exit status: 255 Parse errors: No plan found in TAP output t/08join.t (Wstat: 65280 Tests: 529 Failed: 0) TODO passed: 289-291, 293-295, 314, 316, 318, 321 Non-zero exit status: 255 Parse errors: No plan found in TAP output Files=16, Tests=2364, 11 wallclock secs ( 0.48 usr + 0.00 sys = 0.48 CPU) Result: FAIL Failed 7/16 test programs. 6/2364 subtests failed. NMAKE : fatal error U1077: 'C:\Perl64-5.12\bin\perl.exe' : return code '0xff' Stop. REHSACK/SQL-Statement-1.402.tar.gz nmake test TEST_VERBOSE=1 -- NOT OK //hint// to see the cpan-testers results for installing this module, try: reports REHSACK/SQL-Statement-1.402.tar.gz Finished 2012-12-28T22:13:53