head 1.5; access; symbols pkgsrc-2013Q2:1.5.0.10 pkgsrc-2013Q2-base:1.5 pkgsrc-2012Q4:1.5.0.8 pkgsrc-2012Q4-base:1.5 pkgsrc-2011Q4:1.5.0.6 pkgsrc-2011Q4-base:1.5 pkgsrc-2011Q2:1.5.0.4 pkgsrc-2011Q2-base:1.5 pkgsrc-2009Q4:1.5.0.2 pkgsrc-2009Q4-base:1.5 pkgsrc-2008Q4:1.3.0.46 pkgsrc-2008Q4-base:1.3 pkgsrc-2008Q3:1.3.0.44 pkgsrc-2008Q3-base:1.3 cube-native-xorg:1.3.0.42 cube-native-xorg-base:1.3 pkgsrc-2008Q2:1.3.0.40 pkgsrc-2008Q2-base:1.3 cwrapper:1.3.0.38 pkgsrc-2008Q1:1.3.0.36 pkgsrc-2008Q1-base:1.3 pkgsrc-2007Q4:1.3.0.34 pkgsrc-2007Q4-base:1.3 pkgsrc-2007Q3:1.3.0.32 pkgsrc-2007Q3-base:1.3 pkgsrc-2007Q2:1.3.0.30 pkgsrc-2007Q2-base:1.3 pkgsrc-2007Q1:1.3.0.28 pkgsrc-2007Q1-base:1.3 pkgsrc-2006Q4:1.3.0.26 pkgsrc-2006Q4-base:1.3 pkgsrc-2006Q3:1.3.0.24 pkgsrc-2006Q3-base:1.3 pkgsrc-2006Q2:1.3.0.22 pkgsrc-2006Q2-base:1.3 pkgsrc-2006Q1:1.3.0.20 pkgsrc-2006Q1-base:1.3 pkgsrc-2005Q4:1.3.0.18 pkgsrc-2005Q4-base:1.3 pkgsrc-2005Q3:1.3.0.16 pkgsrc-2005Q3-base:1.3 pkgsrc-2005Q2:1.3.0.14 pkgsrc-2005Q2-base:1.3 pkgsrc-2005Q1:1.3.0.12 pkgsrc-2005Q1-base:1.3 pkgsrc-2004Q4:1.3.0.10 pkgsrc-2004Q4-base:1.3 pkgsrc-2004Q3:1.3.0.8 pkgsrc-2004Q3-base:1.3 pkgsrc-2004Q2:1.3.0.6 pkgsrc-2004Q2-base:1.3 pkgsrc-2004Q1:1.3.0.4 pkgsrc-2004Q1-base:1.3 pkgsrc-2003Q4:1.3.0.2 pkgsrc-2003Q4-base:1.3 netbsd-1-6-1:1.1.0.6 netbsd-1-6-1-base:1.1 netbsd-1-6:1.1.0.8 netbsd-1-6-RELEASE-base:1.1 pkgviews:1.1.0.4 pkgviews-base:1.1 buildlink2:1.1.0.2 buildlink2-base:1.1 netbsd-1-5-PATCH003:1.1; locks; strict; comment @# @; 1.5 date 2009.02.24.20.44.54; author he; state dead; branches; next 1.4; 1.4 date 2009.01.19.22.54.24; author he; state Exp; branches; next 1.3; 1.3 date 2003.04.21.20.24.26; author cjep; state Exp; branches; next 1.2; 1.2 date 2003.03.03.11.09.45; author mjl; state Exp; branches; next 1.1; 1.1 date 2002.02.14.16.02.51; author mjl; state Exp; branches; next ; desc @@ 1.5 log @Update from version 1.17 to 1.19. 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. @ text @$NetBSD: patch-aa,v 1.4 2009/01/19 22:54:24 he Exp $ Avoid Makefile.PL querying stdin, possibly causing a build to stall. --- Makefile.PL.orig 2009-01-18 16:35:38.000000000 +0100 +++ Makefile.PL @@@@ -17,9 +17,9 @@@@ WARNING! You seem to have an older versi See the README for details. END_OF_WARNING -print "Press enter to continue ... "; -my $x = ; -last if $x; +# print "Press enter to continue ... "; +# my $x = ; +# last if $x; } }; @ 1.4 log @Updating from version 1.15nb1 to 1.17. 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 -- Jens @ text @d1 1 a1 1 $NetBSD$ @ 1.3 log @RCS tag. @ text @d2 18 a19 13 --- Makefile.PL.orig 2002-01-23 16:32:58.000000000 +0100 +++ Makefile.PL 2003-03-03 12:06:05.000000000 +0100 @@@@ -18,8 +18,8 @@@@ END_OF_WARNING print "Press enter to continue ... "; -my $x = ; -last if $x; +# my $x = ; +# last if $x; } }; @ 1.2 log @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 @ text @d1 1 @ 1.1 log @Update p5-SQL-Statement to 1.002 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. @ text @d1 2 a2 4 $NetBSD$ --- Makefile.PL.orig Thu Feb 14 16:57:52 2002 +++ Makefile.PL Thu Feb 14 16:58:16 2002 d4 10 a13 10 END_OF_WARNING print "Press enter to continue ... "; -my $x = ; -last if $x; +#my $x = ; +#last if $x; } }; @