summaryrefslogtreecommitdiff
path: root/databases
diff options
context:
space:
mode:
authormjl <mjl@pkgsrc.org>2005-04-03 05:06:42 +0000
committermjl <mjl@pkgsrc.org>2005-04-03 05:06:42 +0000
commit9c27f89698d57d3a90028b83c0017dcd76cdc552 (patch)
treec5a3557d1d87e8737fc89a41fe1f2c3f6e7f7f5f /databases
parent425981e03b0ab365d3ae8bf66868cc9e934d22b7 (diff)
downloadpkgsrc-9c27f89698d57d3a90028b83c0017dcd76cdc552.tar.gz
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 (limited to 'databases')
-rw-r--r--databases/p5-SQL-Statement/Makefile6
-rw-r--r--databases/p5-SQL-Statement/distinfo8
2 files changed, 7 insertions, 7 deletions
diff --git a/databases/p5-SQL-Statement/Makefile b/databases/p5-SQL-Statement/Makefile
index 0b7ed0f8934..53c56c9fcd8 100644
--- a/databases/p5-SQL-Statement/Makefile
+++ b/databases/p5-SQL-Statement/Makefile
@@ -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 --git a/databases/p5-SQL-Statement/distinfo b/databases/p5-SQL-Statement/distinfo
index 507b7138ea1..435fa57a429 100644
--- a/databases/p5-SQL-Statement/distinfo
+++ b/databases/p5-SQL-Statement/distinfo
@@ -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