summaryrefslogtreecommitdiff
path: root/databases/p5-SQL-Statement
AgeCommit message (Collapse)AuthorFilesLines
2009-03-10PkgSrc changes:sno2-10/+9
- Updating module to 1.20 Upstream changes: Version 1.20, released March 5th, 2009 ------------------------------------------ * Fixed Makefile in MANIFEST (reported by Havard Eidnes in RT #43586) * Fixed invalid label FETCHROW used (reported by Michael in RT #42982) * separated update_one_row and update_specific_row method names for tables to avoid confusion Auto-Oked by rhaen@, because I maintain the CPAN module
2009-02-25pkgsrc changes:sno1-1/+5
- add dependencies as they were noted in META.yml during the upstream changes
2009-02-24Update from version 1.17 to 1.19.he3-26/+10
Pkgsrc changes: o Added new needed dependencies o Removed no-longer-needed patch-aa Upstream changes: Version 1.19, released February 6th, 2009 ------------------------------------------ * Fixed OUTER JOIN behaviour * Added version info to all *.pm files to allow CPAN::Reporter find updates * Correct META-Files * Fixed reported bugs: Version 1.18_02, no public release ----------------------------------- Additional (profiled) optimizations for complicated where clauses Version 1.18_01, released January 12th, 2009 --------------------------------------------- No code changes within SQL::Statement - but deliver and execute additional tests.
2009-01-19Updating from version 1.15nb1 to 1.17.he3-23/+27
Pkgsrc changes: o Update patch to Makefile.PL to avoid reading stdin. Upstream changes: (Nothing marked 1.17 from upstream...) Version 1.16_04, released 4 January, 2009 ------------------------------------------ * added tests to prove valid quoting (most of them fail) * Reformat the source * add some (profiled) tweaks as removing useless regex to speed up SELECT * Fixed Bugs: * 14217 Does not correctly handle SQL statements with comments * 15686 Join syntax is case-sensitive, and common columns in natural joins are "ambiguous" [patch] * 13080 Cannot update a field based on its previous value * 26058 functions on computed columns aliased to the underlying column name are not called Version 1.16_03, released 1 January, 2009 ------------------------------------------ * removed *.orig and *.rej relicts Version 1.16_02, released 1 January, 2009 ------------------------------------------ * Changing join_2_tables to reduce memory usage when joining a lot of tables * Fixed Bugs: * 15688 Columns aliased with double quotes are a fatal error * 16579 Speed optimizations * 30590 Bug in SQL::Statement::is_number() * 41875 Bug in synopsis example Version 1.16_01, released 1 January, 2009 ------------------------------------------ * With this release, I'd like to welcome Jens Rehsack as co-maintainer of the SQL::Statement and SQL::Parser modules. Jens has added in some great improvements. Thanks Jens! -- Jeff * Adding a lot of join tests (once from Jeff, 48 from PostgreSQL official handbook) - no error of them will be corrected in the first run Thanks to Alexander Breibach <alexander.breibach@gmx.de> -- Jens
2008-10-19Bump the PKGREVISION for all packages which depend directly on perl,he1-1/+2
to trigger/signal a rebuild for the transition 5.8.8 -> 5.10.0. The list of packages is computed by finding all packages which end up having either of PERL5_USE_PACKLIST, BUILDLINK_API_DEPENDS.perl, or PERL5_PACKLIST defined in their make setup (tested via "make show-vars VARNAMES=...").
2008-07-23updated to 1.15rhaen2-8/+7
ChangeLog: Changes log for Perl extension SQL::Statement Version 1.15, released 2 February, 2006 ---------------------------------------- * fixed placeholder bug in SQL::Statement::UPDATE thanks for bug report Tanktalus Version 1.14, released 21 April, 2005 ---------------------------------------- * fixed circular dependency in tests (one mistakenly required AnyData) Version 1.13, released 18 April, 2005 ---------------------------------------- * pod fixes Version 1.12, released 18 April, 2005 ---------------------------------------- * added support for GROUP BY (several people sent suggestions for this in the past, please email me so I can credit you, sorry I lost the names) * added support for true LIMIT - if a LIMIT clause is specified and no ORDER BY clause is specified, the SELECT will stop searching when the limit is reached; with an ORDER BY clause it will still search the entire table because we can only ORDER a set; using LIMIT without an ORDER BY will greatly increase speed * added support for CREATE/DROP keyword|operator|type|function * optimized process_predicate to only look up scalars once * completely re-wrote the POD * fixed bug in primary key search optimization thanks for bug report and test scripts: Jim Lambert, <jimlambrtATmac.com> * fixed problem with all_cols slowing inserts thanks for patch and test Cosimo Streppone <cosimoATcpan.org> * cleaned up case of temp table column names thanks for bug report: Dan Wright * added a META.YML and extra tests
2008-06-12Add DESTDIR support.joerg1-1/+3
2007-10-25Remove empty PLISTs from pkgsrc since revision 1.33 of plist/plist.mkjlam1-1/+0
can handle packages having no PLIST files.
2006-03-04Point MAINTAINER to pkgsrc-users@NetBSD.org in the case where nojlam1-2/+2
developer is officially maintaining the package. The rationale for changing this from "tech-pkg" to "pkgsrc-users" is that it implies that any user can try to maintain the package (by submitting patches to the mailing list). Since the folks most likely to care about the package are the folks that want to use it or are already using it, this would leverage the energy of users who aren't developers.
2005-08-06Bump the PKGREVISIONs of all (638) packages that hardcode the locationsjlam1-2/+2
of Perl files to deal with the perl-5.8.7 update that moved all pkgsrc-installed Perl files into the "vendor" directories.
2005-07-13Turn PERL5_PACKLIST into a relative path instead of an absolute path.jlam1-2/+2
These paths are now relative to PERL5_PACKLIST_DIR, which currently defaults to ${PERL5_SITEARCH}. There is no change to the binary packages.
2005-04-11Remove USE_BUILDLINK3 and NO_BUILDLINK; these are no longer used.tv1-2/+1
2005-04-03Update to 0.11mjl2-7/+7
* 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
2005-02-23Add RMD160 digests in addition to SHA1 ones.agc1-1/+2
2004-12-20since perl is now built with threads on most platforms, the perl archlibgrant1-1/+2
module directory has changed (eg. "darwin-2level" vs. "darwin-thread-multi-2level"). binary packages of perl modules need to be distinguishable between being built against threaded perl and unthreaded perl, so bump the PKGREVISION of all perl module packages and introduce BUILDLINK_RECOMMENDED for perl as perl>=5.8.5nb5 so the correct dependencies are registered and the binary packages are distinct. addresses PR pkg/28619 from H. Todd Fujinaka.
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
generated by cgit v1.2.3 (git 2.39.1) at 2025-01-28 01:22:51 +0000