From 9c27f89698d57d3a90028b83c0017dcd76cdc552 Mon Sep 17 00:00:00 2001 From: mjl Date: Sun, 3 Apr 2005 05:06:42 +0000 Subject: 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 --- databases/p5-SQL-Statement/Makefile | 6 +++--- databases/p5-SQL-Statement/distinfo | 8 ++++---- 2 files changed, 7 insertions(+), 7 deletions(-) (limited to 'databases') 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 -- cgit v1.2.3