Microsoft (R) Program Maintenance Utility Version 7.00.8882 Copyright (C) Microsoft Corp 1988-2000. All rights reserved. Skipping C:\cpanrun-5.8\build\5-8-0\site\lib\SQL\Eval.pm (unchanged) Skipping C:\cpanrun-5.8\build\5-8-0\site\lib\SQL\Parser.pm (unchanged) Skipping C:\cpanrun-5.8\build\5-8-0\site\lib\SQL\Statement.pm (unchanged) Skipping C:\cpanrun-5.8\build\5-8-0\site\lib\SQL\Statement\Embed.pod (unchanged) Skipping C:\cpanrun-5.8\build\5-8-0\site\lib\SQL\Statement\Functions.pm (unchanged) Skipping C:\cpanrun-5.8\build\5-8-0\site\lib\SQL\Statement\GetInfo.pm (unchanged) Skipping C:\cpanrun-5.8\build\5-8-0\site\lib\SQL\Statement\RAM.pm (unchanged) Skipping C:\cpanrun-5.8\build\5-8-0\site\lib\SQL\Statement\Structure.pod (unchanged) Skipping C:\cpanrun-5.8\build\5-8-0\site\lib\SQL\Statement\Syntax.pod (unchanged) Skipping C:\cpanrun-5.8\build\5-8-0\site\lib\SQL\Statement\Util.pm (unchanged) Skipping C:\cpanrun-5.8\build\5-8-0\site\lib\SQL\Dialects\ANSI.pm (unchanged) Skipping C:\cpanrun-5.8\build\5-8-0\site\lib\SQL\Dialects\AnyData.pm (unchanged) Skipping C:\cpanrun-5.8\build\5-8-0\site\lib\SQL\Dialects\CSV.pm (unchanged) Writing C:\cpanrun-5.8\build\5-8-0\site\lib\auto\SQL\Statement\.packlist Appending installation info to C:\cpanrun-5.8\build\5-8-0\lib/perllocal.pod k 83 ok 84 ok 85 ok 86 ok 87 ok 88 ok 89 ok 90 ok 91 ok 92 ok 93 ok 94 ok 95 ok 96 ok 97 ok 98 ok 99 ok 100 ok t\02executeDirect....SQL::Statement v.1.15 1..24 ok 1 - $parser->new ok 2 - $stmt->new ok 3 - $stmt->command ok 4 - $stmt->params ok 5 - $stmt->tables ok 6 - $stmt->columns ok 7 - $stmt->column_names ok 8 - $stmt->order ok 9 - $stmt->where->op ok 10 - $stmt->where->neg ok 11 - $stmt->where->arg1 ok 12 - $stmt->where->arg2 ok 13 - $stmt->limit ok 14 - $stmt->offset ok 15 - $stmt->row_values ok 16 - structure ok 17 - command ok 18 - distinct ok 19 - $stmt->execute CREATE ok 20 - $stmt->execute INSERT ok 21 - $stmt->execute INSERT ok 22 - $stmt->execute SELECT ok 23 - $stmt->where_hash ok 24 - $stmt->fetch ok t\03executeDBD.......SQL::Statement v.1.15 1..22 ok 1 - placeholder insert with named cols ok 2 - placeholder insert without named cols ok 3 - placeholder delete ok 4 - placeholder update ok 5 - placeholder update ok 6 - Placeholders ok 7 - CREATE ok 8 - INSERT ok 9 - INSERT ok 10 - INSERT ok 11 - UPDATE ok 12 - DELETE ok 13 - SELECT ok 14 - COUNT * ok 15 - COMPUTED COLUMNS IN SELECT LIST ok 16 - CREATE FUNCTION from script ok 17 - CREATE FUNCTION from module ok 18 - LOAD FUNCTIONS ok 19 - IMPORT($AoA) ok 20 - IMPORT($internal_sth) ok 21 # skip No XBase installed ok 22 - DROP TEMP TABLE ok 1/22 skipped: No XBase installed t\04names............1..2 SQL::Statement v.1.15 ok 1 - Column Names: select list = * ok 2 - Column Names: select list = named ok t\05create...........1..5 SQL::Statement v.1.15 ok 1 - CREATE TABLE AS IMPORT($AoA) ok 2 - CREATE TABLE AS IMPORT($AoH) ok 3 - CREATE TABLE AS IMPORT($internal_sth) ok 4 # skip No XBase installed ok 5 - CREATE TABLE AS SELECT ok 1/5 skipped: No XBase installed t\06group............1..3 SQL::Statement v.1.15 ok 1 - AGGREGATE FUNCTIONS WITHOUT GROUP BY ok 2 - GROUP BY one column ok 3 - GROUP BY several columns ok t\07case.............1..12 SQL::Statement v.1.15 ok 1 - lower/lower ok 2 - lower/upper ok 3 - lower/mixed ok 4 - lower/asterisked ok 5 - upper/lower ok 6 - upper/upper ok 7 - upper/mixed ok 8 - upper/asterisked ok 9 - mixed/lower ok 10 - mixed/upper ok 11 - mixed/mixed ok 12 - mixed/asterisked ok t\08join.............1..8 SQL::Statement v.1.15 ok 1 - NATURAL JOIN - with named columns in select list ok 2 - NATURAL JOIN - with select list = * ok 3 - NATURAL JOIN - with computed columns ok 4 - LEFT JOIN ok 5 - RIGHT JOIN ok 6 - FULL JOIN ok 7 - IMPLICIT JOIN - two tables ok 8 - IMPLICIT JOIN - three tables ok t\09ops..............1..18 SQL::Statement v.1.15 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............1..2 SQL::Statement v.1.15 ok 1 - limit with order by ok 2 - limit without order by ok t\11functions........1..23 SQL::Statement v.1.15 ok 1 - min ok 2 - max ok 3 - sum ok 4 - count ok 5 - avg ok 6 - current_date/time/timestamp ok 7 - char_length ok 8 - position ok 9 - lower ok 10 - upper ok 11 - concat good ok 12 - concat bad ok 13 - coalesce ok 14 - nvl ok 15 - decode ok 16 - replace ok 17 - substitute ok 18 - substr ok 19 - trim ok 20 - soundex match ok 21 - soundex no match ok 22 - regex match ok 23 - regex no match ok t\12eval.............1..15 SQL::Statement v.1.15 ok 1 - eval row($val) ok 2 - eval row() ok 3 - eval column($val) ok 4 - eval column() ok 5 - eval params($val) ok 6 - eval params() ok 7 - eval column($tbl,$col,$val) ok 8 - ram seek(bad whence) ok 9 - ram seek(bad index) ok 10 - ram seek(pos=2) ok 11 - $function->type ok 12 - $function->name ok 13 - $column->type ok 14 - function validate - no sub ok 15 - function validate ok t\13call.............1..2 SQL::Statement v.1.15 ok 1 - call function ok 2 - call function ok t\14allcols..........1..1 SQL::Statement v.1.15 ok 1 - ->{all_cols} structure does not grow beyond control ok All tests successful, 2 subtests skipped. Files=15, Tests=243, 7 wallclock secs ( 0.00 cusr + 0.00 csys = 0.00 CPU)