Subject: CVS commit: pkgsrc/databases/p5-SQL-Statement
From: Martin J. Laubach
Date: 2005-04-03 07:06:42
Message id: 20050403050642.999C32DA27@cvs.netbsd.org

Log Message:
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

Files:
RevisionActionfile
1.16modifypkgsrc/databases/p5-SQL-Statement/Makefile
1.8modifypkgsrc/databases/p5-SQL-Statement/distinfo