Updating databases/p5-SQL-Statement from 1.22 to 1.25

pkgsrc changes:
- Adjust dependencies (mark fullfilled by perl CORE)

Upstream changes:
Version 1.25, release March 15th, 2010
----------------------------------------------
[Bug fixes]
* Keep org_table_names with schema information to allow derived
  table classes to handle as it seems reasonable there
* Separate columns with "\0" in multi-column aggregation to be able to
  difference between ('1','1foo') and ('11','foo')

[Misc]
* More resources added to META.yml

Version 1.24, release March 15th, 2010
----------------------------------------------
[Misc]
* Ignore *.rej in MANIFEST.SKIP (fixes RT #52081 reported by
  Lars Thegler)

[Bug fixes]
* Add missing import of _INSTANCE in SQL::Statement::Function::NumericEval
  fixes RT #52356 - reported by Detlef Pilzecker)
* Fix wrongly discarded DISTINCT clause (RT#53186)

[Improvements]
* Fix parsing errors of plain numbers (RT#16931)
* Fix parsing errors of nested calculation / functions (RT#16931, RT#52356)
* Rewrite result calculation of aggregation functions (simplify code,
  speed up)
* Upgrade Makefile.PL (patch from Alexandr Ciornii) to handle different
  EU::MM versions and abilities properly
* Update documentation to show how 'column_defs' and SQL::Statement::Term
  instances shall be used
* Introduce SQL::Dialect::Role providing ini-style data access to
  SQL::Dialects (patch from Michael Schwern)

[Things that may break your code]
* SQL::Parser now didn't deliver a struct containing 'column_names',
  'computed_columns' and 'set_functions' - it's combined into one member
  'column_defs'.
* Minimum required perl version is now 5.8 - upcoming next version of DBI
  requires perl 5.8, too - and I could simplify some code that's why

Version 1.23, release November 20th, 2009
----------------------------------------------

[Misc]
* Applied patch from Marc Espie which fixes several orthographic
  errors in SQL::Statement::Syntax documentation.
* Added a fixed version of test reported via RT #34121

[Bug fixes]
* Fix an issue in UPDATE command which 'shift's the values from
  the list of parameters which causes there're no more parameters
  left after first row get's updated (Fixes RT #50788)
* Fix aggregate function handling of new code since 1.21_01
* Correct handling of DISTINCT in aggregate functions

[Improvements]
* Add support for tables/columns starting with '_' for CSV and AnyData,
  which is usually forbidden by ANSI SQL
* Add support for inserting multiple lines with one statement
  (fixes RT #31730)
* Handle ANSI 'IS NULL' and CVS/AnyData 'IS NULL' different

[Things that may break your code]
* row_value now expects up to two arguments

3 files changed, 28 insertions, 11 deletions

diff --git a/databases/p5-SQL-Statement/DESCR b/databases/p5-SQL-Statement/DESCR
index bf947832d67..48fceedd113 100644
--- a/databases/p5-SQL-Statement/DESCR
+++ b/databases/p5-SQL-Statement/DESCR
@@ -1,3 +1,18 @@
-The SQL::Statement module implements a small, abstract SQL engine. This
-module is not usefull itself, but as a base class for deriving concrete
-SQL engines.
+The SQL::Statement module implements a pure Perl SQL parsing and execution
+engine. While it by no means implements full ANSI standard, it does support
+many features including column and table aliases, built-in and user-defined
+functions, implicit and explicit joins, complexly nested search conditions,
+and other features.
+
+SQL::Statement is a small embeddable Database Management System (DBMS),
+this means that it provides all of the services of a simple DBMS except that
+instead of a persistant storage mechanism, it has two things:
+1) an in-memory storage mechanism that allows you to prepare, execute, and
+   fetch from SQL statements using temporary tables and
+2) a set of software sockets where any author can plug in any storage
+   mechanism.
+
+There are three main uses for SQL::Statement.
+1) to access and manipulate data in CSV, XML, and other formats
+2) to build a DBD for a new data source
+3) to parse and examine the structure of SQL statements.
diff --git a/databases/p5-SQL-Statement/Makefile b/databases/p5-SQL-Statement/Makefile
index 0f20f586377..e5d53c0c5c6 100644
--- a/databases/p5-SQL-Statement/Makefile
+++ b/databases/p5-SQL-Statement/Makefile
@@ -1,12 +1,11 @@
-# $NetBSD: Makefile,v 1.28 2009/10/17 14:25:04 sno Exp $
+# $NetBSD: Makefile,v 1.29 2010/03/16 17:30:08 sno Exp $
 #
 
-DISTNAME=	SQL-Statement-1.22
+DISTNAME=	SQL-Statement-1.25
 PKGNAME=	p5-${DISTNAME}
 SVR4_PKGNAME=	p5sqs
 CATEGORIES=	databases perl5
 MASTER_SITES=	${MASTER_SITE_PERL_CPAN:=SQL/}
-MASTER_SITES+=	${MASTER_SITE_PERL_CPAN:=../../authors/id/R/RE/REHSACK/}
 
 MAINTAINER=	pkgsrc-users@NetBSD.org
 HOMEPAGE=	http://search.cpan.org/dist/SQL-Statement/
@@ -15,7 +14,7 @@ LICENSE=	${PERL5_LICENSE}
 
 PKG_DESTDIR_SUPPORT=	user-destdir
 
-BUILD_DEPENDS+=	p5-Test-Simple>=0.86:../../devel/p5-Test-Simple
+BUILD_DEPENDS+=	{perl>=5.10.1,p5-Test-Simple>=0.86}:../../devel/p5-Test-Simple
 
 DEPENDS+=	p5-Clone>=0.30:../../devel/p5-Clone
 DEPENDS+=	p5-Params-Util>=1.00:../../devel/p5-Params-Util
@@ -26,6 +25,9 @@ MAKE_ENV+=		SQL_STATEMENT_WARN_UPDATE=sure
 #pre-configure:
 #	cd ${WRKSRC} && find `pwd` -name "*.orig" -type f | xargs rm
 
+post-extract:
+	${FIND} ${WRKSRC} -name "*.pm" -type f -exec ${CHMOD} -x {} \;
+
 .include "../../lang/perl5/module.mk"
 .include "../../databases/p5-DBI/buildlink3.mk"
 BUILDLINK_API_DEPENDS.p5-DBI+=	p5-DBI>=1.609
diff --git a/databases/p5-SQL-Statement/distinfo b/databases/p5-SQL-Statement/distinfo
index edf679ffdbd..decc4183f6b 100644
--- a/databases/p5-SQL-Statement/distinfo
+++ b/databases/p5-SQL-Statement/distinfo
@@ -1,5 +1,5 @@
-$NetBSD: distinfo,v 1.13 2009/10/17 14:25:04 sno Exp $
+$NetBSD: distinfo,v 1.14 2010/03/16 17:30:08 sno Exp $
 
-SHA1 (SQL-Statement-1.22.tar.gz) = fbab6660699617cc0c21102e08e6e88cbe02dae0
-RMD160 (SQL-Statement-1.22.tar.gz) = f29962aca874642581a9c055e46552d6f8f3323c
-Size (SQL-Statement-1.22.tar.gz) = 100115 bytes
+SHA1 (SQL-Statement-1.25.tar.gz) = 0221e6577be83d6375ee81e504cac6d6ecc6e99d
+RMD160 (SQL-Statement-1.25.tar.gz) = 532f63034799055be1b3f7f560978f4c885d1a00
+Size (SQL-Statement-1.25.tar.gz) = 108314 bytes