[pkgsrc/trunk]: pkgsrc/databases/p5-SQL-Statement Update to 0.11

[mjl <mjl%pkgsrc.org@localhost>]

details:   https://anonhg.NetBSD.org/pkgsrc/rev/a6a5248acc3f
branches:  trunk
changeset: 492010:a6a5248acc3f
user:      mjl <mjl%pkgsrc.org@localhost>
date:      Sun Apr 03 05:06:42 2005 +0000

description:
Update to 0.11

 * added support for CREATE TABLE AS SELECT ... and CREATE TABLE AS IMPORT()
 * added support for in-memory tables and heterogeneous operations
 * added many new built-in functions see SQL::Statement::Functions.pm
 * added support for user-defined functions, see SQL::Statement::Functions.pm
 * added support for column name aliases
 * added support for comparison to empty string (e.g. WHERE col1='')
   currently returns the same as WHERE col1 IS NULL
 * clean up a number of bugs in parentheses parsing and in the
   predicates IN and BETWEEN as well as speed things up considerably
 * fixed function detection regex in SQL::Parser::ROW_VALUE
        to accomodate arbitrary spacing
 * support concat operator '||' expressions
 * added following functions to SQL::Statement::Functions:
        - COALESCE/NVL
        - DECODE (same as Oracle DECODE)
        - CONCAT
        - REPLACE/SUBSTITUTE
 * fixed/adapted SQL::Statement::get_row_value(),
        SQL::Statement::SELECT(), for join'ed
        resultsets
 * fixed infinite recursion bug with empty IN() predicate
 * fixed case issues with table aliases in joins
 * column and table name hashes now default to case sensitive
 * where() method now supported as per the docs

diffstat:

 databases/p5-SQL-Statement/Makefile |  6 +++---
 databases/p5-SQL-Statement/distinfo |  8 ++++----
 2 files changed, 7 insertions(+), 7 deletions(-)

diffs (31 lines):

diff -r c5401f68fafb -r a6a5248acc3f databases/p5-SQL-Statement/Makefile
--- a/databases/p5-SQL-Statement/Makefile       Sun Apr 03 04:50:21 2005 +0000
+++ b/databases/p5-SQL-Statement/Makefile       Sun Apr 03 05:06:42 2005 +0000
@@ -1,10 +1,10 @@
-# $NetBSD: Makefile,v 1.15 2004/12/20 11:30:57 grant Exp $
+# $NetBSD: Makefile,v 1.16 2005/04/03 05:06:42 mjl Exp $
 #
 
-DISTNAME=      SQL-Statement-1.005
+DISTNAME=      SQL-Statement-1.11
 PKGNAME=       p5-${DISTNAME}
 SVR4_PKGNAME=  p5sqs
-PKGREVISION=   1
+# PKGREVISION= 1
 CATEGORIES=    databases perl5
 MASTER_SITES=  ${MASTER_SITE_PERL_CPAN:=SQL/}
 
diff -r c5401f68fafb -r a6a5248acc3f databases/p5-SQL-Statement/distinfo
--- a/databases/p5-SQL-Statement/distinfo       Sun Apr 03 04:50:21 2005 +0000
+++ b/databases/p5-SQL-Statement/distinfo       Sun Apr 03 05:06:42 2005 +0000
@@ -1,6 +1,6 @@
-$NetBSD: distinfo,v 1.7 2005/02/23 16:33:08 agc Exp $
+$NetBSD: distinfo,v 1.8 2005/04/03 05:06:42 mjl Exp $
 
-SHA1 (SQL-Statement-1.005.tar.gz) = 066b658732f15faea203764996b543eed12f0de9
-RMD160 (SQL-Statement-1.005.tar.gz) = 283b7f3a080fe86ec5e678579ad9c57e136ca49e
-Size (SQL-Statement-1.005.tar.gz) = 53841 bytes
+SHA1 (SQL-Statement-1.11.tar.gz) = 3dcf34ffd0b481748595c4cefa0a6f9986d55fad
+RMD160 (SQL-Statement-1.11.tar.gz) = e49829d1634ed64f1e54b85e9ac0fb8ea1a6bc3b
+Size (SQL-Statement-1.11.tar.gz) = 77540 bytes
 SHA1 (patch-aa) = c8ff44669e45201262d042612fbce32bc430efbc