summaryrefslogtreecommitdiff
path: root/databases/p5-SQL-Statement
AgeCommit message (Collapse)AuthorFilesLines
2004-04-27Convert to buildlink3.snj1-2/+2
2003-07-21COMMENT should start with a capital letter.martti1-2/+2
2003-07-17s/netbsd.org/NetBSD.org/grant1-2/+2
2003-06-02Use tech-pkg@ in favor of packages@ as MAINTAINER for orphaned packages.jschauma1-2/+2
Should anybody feel like they could be the maintainer for any of thewe packages, please adjust.
2003-04-21RCS tag.cjep1-0/+1
2003-03-03Update p5-SQL-Statement to 1.005mjl3-20/+18
* 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
2002-10-13Use buildlink2. Use perl5/module.mk.seb1-6/+3
2002-02-14Update p5-SQL-Statement to 1.002mjl3-5/+21
Added backwards compatiblity: both SQL::Statement and SQL::Parser now work in perl version 5.004 and above. Changed defaults for DBD::CSV so it now accepts new SQL without adding extra flags to scripts Added support for SQL comments Fixed bugs in qualified column names (e.g. tableA.*), and in joins using ON or WHERE Fixed bug in UPDATE that caused the new value to be a hash rather than a scalar. New features: Explicit and implicit joins Table name aliases Set functions String functions String concatenation Numeric expressions IN predicate BETWEEN predicate Alphabetic comparison in WHERE clauses Ordering of text that looks like a number Verbose error messages for both Parsing and Execution errors Pure perl, new maintainer.
2001-11-30Update to 0.1021mjl2-5/+5
* Yet another attempt to get rid of those CR/LF line endings. :-(
2001-11-26Buildlinkify, in the sense that only the perl headers are found injlam1-3/+4
${PREFIX} -- everything else is pickup up from ${BUILDLINK_DIR}.
2001-11-01Move pkg/ files into package's toplevel directoryzuntum3-1/+1
2001-10-18SVR4 packages have a limit of 9 chars for a package name.veego1-1/+2
The automatic truncation in gensolpkg doesn't work for packages which have the same package name for the first 5-6 chars. e.g. amanda-server and amanda-client would be named amanda and amanda. Now, we add a SVR4_PKGNAME and use amacl for amanda-client and amase for amanda-server. All svr4 packages also have a vendor tag, so we have to reserve some chars for this tag, which is normaly 3 or 4 chars. Thats why we can only use 6 or 5 chars for SVR4_PKGNAME. I used 5 for all the packages, to give the vendor tag enough room. All p5-* packages and a few other packages have now a SVR4_PKGNAME.
2001-05-26Update to 0.1020. Changes:mjl2-5/+5
* Changed distribution to include files generated by Solaris bison 1.27 * Added LIMIT clause
2001-04-18Move to sha1 digests, and add distfile sizes.agc1-1/+2
2001-04-17+ move the distfile digest/checksum value from files/md5 to distinfoagc1-1/+1
+ move the patch digest/checksum values from files/patch-sum to distinfo + include distfile filesizes in distinfo
2001-03-21Updated to 0.1017mjl2-4/+4
* Makefile.PL: Fixed portability issue with Darwin.
2001-02-16Update to new COMMENT style: COMMENT var in Makefile instead of pkg/COMMENT.wiz2-2/+2
2000-10-23Initial import of p5-SQL-Statement, a small, abstract SQL engine.mjl5-0/+26