Module Name:	pkgsrc
Committed By:	mjl
Date:		Mon Mar  3 11:09:45 UTC 2003

Modified Files:
	pkgsrc/databases/p5-SQL-Statement: Makefile distinfo
	pkgsrc/databases/p5-SQL-Statement/patches: patch-aa

Log Message:
Update p5-SQL-Statement to 1.005

 * added support for MySQL-like "DROP TABLE IF EXISTS"
 * fixed bug in dotted column names e.g. tableA.colB
 * fixed bug in MAX and MIN
 * fixed bug in ORDER BY (when col names not in SELECT list)
 * added support for delimited identifiers (inside double quotes);
   these are case sensitive and can contain spaces and other
   special chars
 * added support for two forms of escaping single quotes inside
   quoted values: 'O\'Brien' or  'O''Brien'
 * added support for  both C-Style and SQL-Style double-hypen
   comments,  e.g.  /* comment */ or -- comment
 * added GetInfo.pm for use with $dbh->get_info()
 * fixed bug in update that refers to its own columns
   (e.g. SET num = num + 2)
 * fixed bug in MIN and MAX when used with strings
 * identifiers (names of columns, tables, and table name
   aliases) are now all case insensitive as required by the SQL
   standard. all older versions including the XS versions used
   case sensitive column names
 * added numerous examples to test.pl
 * improved and/or fixed bugs in:
   * placeholder support
   * ORDER BY clause
   * LIKE/CLIKE/RLIKE/IN predicates
   * table name aliases in explicit joins


To generate a diff of this commit:
cvs rdiff -r1.9 -r1.10 pkgsrc/databases/p5-SQL-Statement/Makefile
cvs rdiff -r1.5 -r1.6 pkgsrc/databases/p5-SQL-Statement/distinfo
cvs rdiff -r1.1 -r1.2 pkgsrc/databases/p5-SQL-Statement/patches/patch-aa

Please note that diffs are not public domain; they are subject to the
copyright notices on the relevant files.