diff options
| author | mjl <mjl@pkgsrc.org> | 2005-04-03 05:06:42 +0000 |
|---|---|---|
| committer | mjl <mjl@pkgsrc.org> | 2005-04-03 05:06:42 +0000 |
| commit | ab1c011d02a191a305cf61f323aafc973b1c9534 (patch) | |
| tree | c5a3557d1d87e8737fc89a41fe1f2c3f6e7f7f5f /databases/p5-SQL-Statement | |
| parent | f17aa7e8bbd81cf8a0f964132d0e02f48b002410 (diff) | |
| download | pkgsrc-ab1c011d02a191a305cf61f323aafc973b1c9534.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/p5-SQL-Statement')
| -rw-r--r-- | databases/p5-SQL-Statement/Makefile | 6 | ||||
| -rw-r--r-- | databases/p5-SQL-Statement/distinfo | 8 |
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 |