The NetBSD Project

CVS log for pkgsrc/databases/p5-SQL-Statement/Makefile

[BACK] Up to [] / pkgsrc / databases / p5-SQL-Statement

Request diff between arbitrary revisions

Default branch: MAIN

Revision 1.59 / (download) - annotate - [select for diffs], Thu Jul 6 09:38:29 2023 UTC (4 months, 3 weeks ago) by wiz
Branch: MAIN
CVS Tags: pkgsrc-2023Q3-base, pkgsrc-2023Q3, HEAD
Changes since 1.58: +2 -2 lines
Diff to previous 1.58 (colored)

*: recursive bump for perl 5.38

Revision 1.58 / (download) - annotate - [select for diffs], Tue Jun 6 12:40:32 2023 UTC (5 months, 3 weeks ago) by riastradh
Branch: MAIN
CVS Tags: pkgsrc-2023Q2-base, pkgsrc-2023Q2
Changes since 1.57: +2 -2 lines
Diff to previous 1.57 (colored)

Mass-change BUILD_DEPENDS to TOOL_DEPENDS outside mk/.

Almost all uses, if not all of them, are wrong, according to the
semantics of BUILD_DEPENDS (packages built for target available for
use _by_ tools at build-time) and TOOL_DEPEPNDS (packages built for
host available for use _as_ tools at build-time).

No change to BUILD_DEPENDS as used correctly inside buildlink3.

As proposed on tech-pkg:

Revision 1.57 / (download) - annotate - [select for diffs], Tue Jun 28 11:31:30 2022 UTC (17 months ago) by wiz
Branch: MAIN
CVS Tags: pkgsrc-2023Q1-base, pkgsrc-2023Q1, pkgsrc-2022Q4-base, pkgsrc-2022Q4, pkgsrc-2022Q3-base, pkgsrc-2022Q3
Changes since 1.56: +2 -2 lines
Diff to previous 1.56 (colored)

*: recursive bump for perl 5.36

Revision 1.56 / (download) - annotate - [select for diffs], Mon May 24 19:49:42 2021 UTC (2 years, 6 months ago) by wiz
Branch: MAIN
CVS Tags: pkgsrc-2022Q2-base, pkgsrc-2022Q2, pkgsrc-2022Q1-base, pkgsrc-2022Q1, pkgsrc-2021Q4-base, pkgsrc-2021Q4, pkgsrc-2021Q3-base, pkgsrc-2021Q3, pkgsrc-2021Q2-base, pkgsrc-2021Q2
Changes since 1.55: +2 -1 lines
Diff to previous 1.55 (colored)

*: recursive bump for perl 5.34

Revision 1.55 / (download) - annotate - [select for diffs], Thu Feb 11 00:25:14 2021 UTC (2 years, 9 months ago) by wen
Branch: MAIN
CVS Tags: pkgsrc-2021Q1-base, pkgsrc-2021Q1
Changes since 1.54: +2 -3 lines
Diff to previous 1.54 (colored)

Update to 1.414

Upstream changes:
1.414   2020-10-21
    * re-release 1.413_001 without further changes

1.413_001       2020-09-28
    * Spell check
    * Be specific in which files to skip from the distribution
    * Author fixes
    * Makefile.PL: port WriteMakefile1 from Hash::Merge
    * .travis.yml: update for Xenial VMs
    * cleanup MANIFEST.SKIP
    * bump copyright year
    * SQL::Parser correctly parse VALUES and SET clauses containing function invocations with several arguments
      patch provided by Edgar J. Holleis

Revision 1.54 / (download) - annotate - [select for diffs], Mon Aug 31 18:07:07 2020 UTC (3 years, 2 months ago) by wiz
Branch: MAIN
CVS Tags: pkgsrc-2020Q4-base, pkgsrc-2020Q4, pkgsrc-2020Q3-base, pkgsrc-2020Q3
Changes since 1.53: +2 -2 lines
Diff to previous 1.53 (colored)

*: bump PKGREVISION for perl-5.32.

Revision 1.53 / (download) - annotate - [select for diffs], Sun Aug 11 13:18:33 2019 UTC (4 years, 3 months ago) by wiz
Branch: MAIN
CVS Tags: pkgsrc-2020Q2-base, pkgsrc-2020Q2, pkgsrc-2020Q1-base, pkgsrc-2020Q1, pkgsrc-2019Q4-base, pkgsrc-2019Q4, pkgsrc-2019Q3-base, pkgsrc-2019Q3
Changes since 1.52: +2 -2 lines
Diff to previous 1.52 (colored)

Bump PKGREVISIONs for perl 5.30.0

Revision 1.52 / (download) - annotate - [select for diffs], Sun Jun 30 20:14:28 2019 UTC (4 years, 5 months ago) by nia
Branch: MAIN
Changes since 1.51: +2 -2 lines
Diff to previous 1.51 (colored)

Update packages using a HOMEPAGE to

The former now redirects to the latter.

This covers the most simple cases where
can be changed to

Reviewed by hand to hopefully make sure no unwanted changes sneak in.

Revision 1.51 / (download) - annotate - [select for diffs], Wed Aug 22 09:43:21 2018 UTC (5 years, 3 months ago) by wiz
Branch: MAIN
CVS Tags: pkgsrc-2019Q2-base, pkgsrc-2019Q2, pkgsrc-2019Q1-base, pkgsrc-2019Q1, pkgsrc-2018Q4-base, pkgsrc-2018Q4, pkgsrc-2018Q3-base, pkgsrc-2018Q3
Changes since 1.50: +2 -2 lines
Diff to previous 1.50 (colored)

Recursive bump for perl5-5.28.0

Revision 1.50 / (download) - annotate - [select for diffs], Sun Mar 25 09:36:21 2018 UTC (5 years, 8 months ago) by wiz
Branch: MAIN
CVS Tags: pkgsrc-2018Q2-base, pkgsrc-2018Q2, pkgsrc-2018Q1-base, pkgsrc-2018Q1
Changes since 1.49: +3 -3 lines
Diff to previous 1.49 (colored)

p5-SQL-Statement: update to 1.412nb2.

Add missing dependency.

Revision 1.49 / (download) - annotate - [select for diffs], Mon Jun 5 14:22:31 2017 UTC (6 years, 5 months ago) by ryoon
Branch: MAIN
CVS Tags: pkgsrc-2017Q4-base, pkgsrc-2017Q4, pkgsrc-2017Q3-base, pkgsrc-2017Q3, pkgsrc-2017Q2-base, pkgsrc-2017Q2
Changes since 1.48: +2 -1 lines
Diff to previous 1.48 (colored)

Recursive revbump from lang/perl5 5.26.0

Revision 1.48 / (download) - annotate - [select for diffs], Wed Apr 26 12:10:06 2017 UTC (6 years, 7 months ago) by mef
Branch: MAIN
Changes since 1.47: +2 -3 lines
Diff to previous 1.47 (colored)

Updated databases/p5-SQL-Statement to 1.412
1.412   2017-04-06
    * Release 1.411_001 without further changes as 1.412

1.411_001 2017-03-30
    [Bug fixes]
    * Fix (NumericEval: fix
      typo on error handling) (thanks to Yanick Champoux, James R. Leu)
    * fix repo url and t/02execute.t (Reini Urban, Mohammad S Anwar)
    * fix test failing with blead-perl (Jens Rehsack)

    * Refactor constraints processing (Ovidiu Gheorghies)
    * Support parsing of complex JOIN clause (containing OR and ()'s) (James R. Leu)
    * handle backtick quoting (Ben Hengst)

Revision 1.47 / (download) - annotate - [select for diffs], Wed Jun 8 19:22:30 2016 UTC (7 years, 5 months ago) by wiz
Branch: MAIN
CVS Tags: pkgsrc-2017Q1-base, pkgsrc-2017Q1, pkgsrc-2016Q4-base, pkgsrc-2016Q4, pkgsrc-2016Q3-base, pkgsrc-2016Q3, pkgsrc-2016Q2-base, pkgsrc-2016Q2
Changes since 1.46: +2 -1 lines
Diff to previous 1.46 (colored)

Bump PKGREVISION for perl-5.24.

Revision 1.46 / (download) - annotate - [select for diffs], Sat Apr 16 13:48:54 2016 UTC (7 years, 7 months ago) by wen
Branch: MAIN
Changes since 1.45: +2 -2 lines
Diff to previous 1.45 (colored)

Update to 1.410

Upstream changes:
1.410 2016-04-11
    [Bug fixes]
    * Fix RT#113625 - Unnecessary x-bits (Kent Fredric)

    * pod2markdown from lib/SQL/

1.409 2016-04-06
    * Release 1.408_001 without further changes as 1.409

1.408_001 2016-03-07
    [Bug fixes]
    * Fix RT#112530 - t/06virtual.t fails with -Duselongdouble (thanks
      Slaven Rezic)
    * Fix RT#105852 - dependency installation isn't triggered properly in
      cpan (thanks Mithaldu)
    * Fix RT#99349 - bind variables are not bound to placeholders in the
      correct order (thanks

    * Update Copyright statements, add where missing (according to records)
    * Add license conditions where missing
    * bundle copy of license conditions to distribution

Revision 1.45 / (download) - annotate - [select for diffs], Thu Aug 6 01:44:40 2015 UTC (8 years, 3 months ago) by wen
Branch: MAIN
CVS Tags: pkgsrc-2016Q1-base, pkgsrc-2016Q1, pkgsrc-2015Q4-base, pkgsrc-2015Q4, pkgsrc-2015Q3-base, pkgsrc-2015Q3
Changes since 1.44: +5 -3 lines
Diff to previous 1.44 (colored)

Update to 1.407
Add missing DEPENDS

Upstream changes:
1.407 2015-05-26
    * Release 1.406_002 without further changes as 1.407

1.406_002 2015-05-22
    [Bug fixes]
    * Fix RT#104579: Redundant argument in sprintf
      submitted by Slaven Rezi
    * Fix RT#104589: t/14parse.t fails if Test::Deep is not installed
      submitted by Slaven Rezi

1.406_001 2015-05-20
    * clean up Makefile.PL, meta-data and requirements

    [Bug fixes]
    * Fix SQL function CONV to use limited number of sane character sets
      for conversion and rely on Math::Base::Convert instead of own code
      (suggested by Tom Wyant in RT#100551, thanks Tom)
    * fix handling of literal identifiers and for every IMPORT rely on
      literal identifiers to avoid parser errors for column names starting
      with numbers or similar
    * fix capability cache: "$class->can(...)" might return undef and
      therefore inexistent capabilities are queried to often
    * Fix COUNT(DISTINCT col) without GROUP BY clause (patch submitted
      by Grant Mathews, thanks Grant)
    * Fix "parse insert with functions" submitted via GitHub PR#6 by
      fecundf and RT#96628
    * Fix RT#93320: SQL-style comment can not begin inside quotes by
      Tom Wyant - thanks Tom

    * reduce blocks and rewrite some inner statements to increase speed
      of sql command processing

Revision 1.44 / (download) - annotate - [select for diffs], Fri Jun 12 10:48:43 2015 UTC (8 years, 5 months ago) by wiz
Branch: MAIN
CVS Tags: pkgsrc-2015Q2-base, pkgsrc-2015Q2
Changes since 1.43: +2 -2 lines
Diff to previous 1.43 (colored)

Recursive PKGREVISION bump for all packages mentioning 'perl',
having a PKGNAME of p5-*, or depending such a package,
for perl-5.22.0.

Revision 1.43 / (download) - annotate - [select for diffs], Thu Oct 9 13:44:36 2014 UTC (9 years, 1 month ago) by wiz
Branch: MAIN
CVS Tags: pkgsrc-2015Q1-base, pkgsrc-2015Q1, pkgsrc-2014Q4-base, pkgsrc-2014Q4
Changes since 1.42: +1 -2 lines
Diff to previous 1.42 (colored)

Remove SVR4_PKGNAME, per discussion on tech-pkg.

Revision 1.42 / (download) - annotate - [select for diffs], Thu May 29 23:35:31 2014 UTC (9 years, 6 months ago) by wiz
Branch: MAIN
CVS Tags: pkgsrc-2014Q3-base, pkgsrc-2014Q3, pkgsrc-2014Q2-base, pkgsrc-2014Q2
Changes since 1.41: +2 -1 lines
Diff to previous 1.41 (colored)

Bump for perl-5.20.0.
Do it for all packages that
* mention perl, or
* have a directory name starting with p5-*, or
* depend on a package starting with p5-
like last time, for 5.18, where this didn't lead to complaints.
Let me know if you have any this time.

Revision 1.41 / (download) - annotate - [select for diffs], Sat Jun 22 09:21:22 2013 UTC (10 years, 5 months ago) by sno
Branch: MAIN
CVS Tags: pkgsrc-2014Q1-base, pkgsrc-2014Q1, pkgsrc-2013Q4-base, pkgsrc-2013Q4, pkgsrc-2013Q3-base, pkgsrc-2013Q3, pkgsrc-2013Q2-base, pkgsrc-2013Q2
Changes since 1.40: +3 -10 lines
Diff to previous 1.40 (colored)

Updating package for CPAN distribution SQL-Statement, providing pure Perl
implementation of an SQL engine.

pkgsrc changes:
- killing DBI build dependency - was an error introduced by the author
  for better test coverage, leads easily to circular dependency, bad stuff
  ==> kicking
- since 5.10.1 a suitable test framework is distributed with Perl5 core
  ==> no reason to mention it explicitely
- Bumping conflict DBI version to 1.622 (with 1.623 DBI::DBD::SqlEngine
  received great improve - and forces a lot of fixes in SQL::Statement
  and vice versa)

Upstream changes since 1.402:
Version 1.405, released June 17, 2013
[Bug fixes]
* INSERT now expands incomplete rows (Thanks to H.Merijn Brand)

Version 1.404, released May 23, 2013
[Bug fixes]
* re-enable cleanup test_output* after test done
* recommend Text::Soundex and do soundex-test only when have it,
  because it's going to be removed from core for Perl 5.19 (thank Merijn)

Version 1.403, released May 22, 2013
[Bug fixes]
* fix documentation (rt#84889 - thanks Xavier Guimard and Florian,
  rt#85257 - thanks Andreas Koenig)

Revision 1.40 / (download) - annotate - [select for diffs], Fri May 31 12:39:54 2013 UTC (10 years, 6 months ago) by wiz
Branch: MAIN
Changes since 1.39: +2 -1 lines
Diff to previous 1.39 (colored)

Bump all packages for perl-5.18, that
a) refer 'perl' in their Makefile, or
b) have a directory name of p5-*, or
c) have any dependency on any p5-* package

Like last time, where this caused no complaints.

Revision 1.39 / (download) - annotate - [select for diffs], Thu Jan 10 15:11:57 2013 UTC (10 years, 10 months ago) by wen
Branch: MAIN
CVS Tags: pkgsrc-2013Q1-base, pkgsrc-2013Q1
Changes since 1.38: +3 -4 lines
Diff to previous 1.38 (colored)

Update to 1.402

Upstream changes:
Version 1.402, released December 19, 2012

* add Math::Complex 1.56 as recommendation (RT#81926, Sam Ferencik)
* add Math::BigInt 1.88 as recommendation (RT#81927, Sam Ferencik)
* clarify Test::Simple 1.90 is required for building (RT#81925, Sam Ferencik)

[Bug fixes]
* fix leaking reference to open tables outside SQL::Statement::execute
  (fixes RT#81523)
* looks_like_number identifies 'nan' as number sometimes (add regex to

Version 1.401, released October 29, 2012

* Switch to 3-digited minor version

[Bug fixes]
* undo literal replaces in subqueries before passing them to the
  child parser
* Fix doc typo RT#76764 (STEFFENW) - thanks Steffen
* Fix typo documented in RT#71914 (reported by Ze'ev Atlas,
  fixed by H.Merijn Brand) - thanks Ze'ev and Merijn
* Fix DROP TABLE behaviour and error detection

* Improve documentation/tests for multiple JOIN's from RT#69573
  (from BBYRD) with modifications
* Filling in the SQL92 gaps for functions (BBYRD) from RT#72638
  with minor modifications - thanks Brendan

Revision 1.38 / (download) - annotate - [select for diffs], Wed Oct 3 21:54:23 2012 UTC (11 years, 1 month ago) by wiz
Branch: MAIN
CVS Tags: pkgsrc-2012Q4-base, pkgsrc-2012Q4
Changes since 1.37: +2 -1 lines
Diff to previous 1.37 (colored)

Bump all packages that use perl, or depend on a p5-* package, or
are called p5-*.

I hope that's all of them.

Revision 1.37 / (download) - annotate - [select for diffs], Tue Oct 2 21:25:35 2012 UTC (11 years, 1 month ago) by asau
Branch: MAIN
Changes since 1.36: +1 -3 lines
Diff to previous 1.36 (colored)

Drop superfluous PKG_DESTDIR_SUPPORT, "user-destdir" is default these days.

Revision 1.36 / (download) - annotate - [select for diffs], Mon Oct 10 09:51:13 2011 UTC (12 years, 1 month ago) by hiramatsu
Branch: MAIN
CVS Tags: pkgsrc-2012Q3-base, pkgsrc-2012Q3, pkgsrc-2012Q2-base, pkgsrc-2012Q2, pkgsrc-2012Q1-base, pkgsrc-2012Q1, pkgsrc-2011Q4-base, pkgsrc-2011Q4
Changes since 1.35: +2 -3 lines
Diff to previous 1.35 (colored)

Update p5-SQL-Statement to 1.33.

Changes from previous:
Version 1.33, released February 05th, 2011

[Bug fixes]
* Move test dependencies to (unreleased) Bundle::Test::SQL::Statement
  to avoid circular dependencies

Version 1.32, released January 19th, 2011

[Bug fixes]
* Fixed invalid check for escaped single quotes
* Fixed unpermitted modification of array source for table creation
  (CREATE TABLE AS IMPORT(?),[[..],[..]])
* Fixing alias used in ORDER BY (RT#61384, thanks jvm)
* Fixing ORDER BY behavior for multiple sort columns
  (slower, but guaranteed correct)

* renamed fetch-method into fetch_row (keep fetch() as alias) and
  add a fetch_rows() to fetch all rows at once
* Different accessors for direction of ORDER BY clause query part
  and it's boolean equivalent "desc" (0 or 1, respectively)
* Add a lot of Pure-Perl DBD's as build dependency for testing
  (skip DBD::AnyData for now, because it seems to be broken - check
  for next release)

* Bump requirement of DBI to 1.616
* switch for fully external DBD tests from DBD::XBase to DBD::SQLite
* Document another limitation (lacking implicit creating temp table
  during processing a query using the same table with different aliases

Revision 1.35 / (download) - annotate - [select for diffs], Sun Aug 14 08:18:11 2011 UTC (12 years, 3 months ago) by obache
Branch: MAIN
CVS Tags: pkgsrc-2011Q3-base, pkgsrc-2011Q3
Changes since 1.34: +2 -2 lines
Diff to previous 1.34 (colored)

Revision bump after updating perl5 to 5.14.1.

Revision 1.34 / (download) - annotate - [select for diffs], Sat Aug 21 16:33:05 2010 UTC (13 years, 3 months ago) by seb
Branch: MAIN
CVS Tags: pkgsrc-2011Q2-base, pkgsrc-2011Q2, pkgsrc-2011Q1-base, pkgsrc-2011Q1, pkgsrc-2010Q4-base, pkgsrc-2010Q4, pkgsrc-2010Q3-base, pkgsrc-2010Q3
Changes since 1.33: +2 -1 lines
Diff to previous 1.33 (colored)

Bump the PKGREVISION for all packages which depend directly on perl,
to trigger/signal a rebuild for the transition 5.10.1 -> 5.12.1.

The list of packages is computed by finding all packages which end
or PERL5_PACKLIST defined in their make setup (tested via
"make show-vars VARNAMES=..."), minus the packages updated after
the perl package update.

sno@ was right after all, obache@ kindly asked and he@ led the
way. Thanks!

Revision 1.33 / (download) - annotate - [select for diffs], Tue Aug 17 06:33:27 2010 UTC (13 years, 3 months ago) by sno
Branch: MAIN
Changes since 1.32: +2 -2 lines
Diff to previous 1.32 (colored)

Updating databases/p5-SQL-Statement from 1.30 to 1.31

Upstream changes:
Version 1.31, released August 16th, 2010

[Bug fixes]
* Fix misbehaviour of DELETE/UPDATE for tables with only basic capabilities
  and no matching where clause (reported by H.Merijn Brand and Drew ...)
* Fix some column identifier splits to respect quoted tables

* Optimized some core routines between 25% and 50%.

Revision 1.32 / (download) - annotate - [select for diffs], Wed Aug 4 15:05:20 2010 UTC (13 years, 3 months ago) by sno
Branch: MAIN
Changes since 1.31: +2 -2 lines
Diff to previous 1.31 (colored)

Updating databases/p5-SQL-Statement from 1.28 to 1.30

Upstream changes:
Version 1.30, released August 1st, 2010

[Bug fixes]
* remove blib directory from distfile

Version 1.29, released August 1st, 2010

[Bug fixes]
* add some getters as documented in SQL::Statement::Structure
  (fixes RT#59834, thanks John Wiersba)
* add missing import of function croak to SQL::Statement::Term::ColumnValue
* fix assignment of parser result (doesn't run with perl-5.13.3)

Revision 1.31 / (download) - annotate - [select for diffs], Sat Jul 17 08:20:52 2010 UTC (13 years, 4 months ago) by sno
Branch: MAIN
Changes since 1.30: +5 -3 lines
Diff to previous 1.30 (colored)

Updating databases/p5-SQL-Statement from 1.27 to 1.28

pkgsrc changes:
- require DBI-1.612 for testing
- add conflict for DBI<=1.612

Upstream changes:
Version 1.28, release July 15th, 2010

* Introduce new "capability" method for SQL::Statement and SQL::Eval::Table
  + Add capability for "insert_new_row" to allow DBD::DBM to fix PK
    constrain on INSERT statements.
* Performance of IMPORT feature improved (thanks to Sven Probst, RT#57322)

[Bug fixes]
* expect every table object being derived from SQL::Eval::Table
* rewrite DELETE and UPDATE command based on table capabilities
* add abstract methods for all methods derived classes must override
  (this means, open_table for SQL::Statement deriveds must be overridden
   and all data access methods of tables - see SQL::Eval::Table for details)
* Tests are fixed to use TEMP TABLES explicitely when required
* check for invalid column names fixed
* Don't let depreciated parser structures stay alive in SQL::Statement when
  reusing the Parser

* Method documentation of SQL::Statement and SQL::Eval::Table are improved
* Add a Roadmap describing future plans for SQL::Statement (in addition to
* POD spelling fixes provided by H.Merijn Brand and Pod::Spell::CommonMistakes
  (thanks Tux)
* POD grammar fixes and reasonable sentences created by Martin Evans

[Things that may break your code]
* SQL::Statement 1.28 is expected not to work proper in combination with
  DBI 1.611 and below
* SQL::Statement::ColumnValue expects now every table being derived from

Revision 1.30 / (download) - annotate - [select for diffs], Fri May 7 15:17:02 2010 UTC (13 years, 6 months ago) by sno
Branch: MAIN
CVS Tags: pkgsrc-2010Q2-base, pkgsrc-2010Q2
Changes since 1.29: +2 -2 lines
Diff to previous 1.29 (colored)

Updating databases/p5-SQL-Statement from 1.26 to 1.27

Upstream changes:
Version 1.27, release May 06th, 2010

[Bug fixes]
* use originally given table name for open_table() on SELECT, too
  (all other command still use the originally given name)
* warn/die -> carp/croak
* fix delete_one_row & update_one_row ability using

* Apply spelling fix patch from Ansgar Burchardt (RT#56475)

Revision 1.29 / (download) - annotate - [select for diffs], Tue Mar 16 17:30:08 2010 UTC (13 years, 8 months ago) by sno
Branch: MAIN
CVS Tags: pkgsrc-2010Q1-base, pkgsrc-2010Q1
Changes since 1.28: +6 -4 lines
Diff to previous 1.28 (colored)

Updating databases/p5-SQL-Statement from 1.22 to 1.25

pkgsrc changes:
- Adjust dependencies (mark fullfilled by perl CORE)

Upstream changes:
Version 1.25, release March 15th, 2010
[Bug fixes]
* Keep org_table_names with schema information to allow derived
  table classes to handle as it seems reasonable there
* Separate columns with "\0" in multi-column aggregation to be able to
  difference between ('1','1foo') and ('11','foo')

* More resources added to META.yml

Version 1.24, release March 15th, 2010
* Ignore *.rej in MANIFEST.SKIP (fixes RT #52081 reported by
  Lars Thegler)

[Bug fixes]
* Add missing import of _INSTANCE in SQL::Statement::Function::NumericEval
  fixes RT #52356 - reported by Detlef Pilzecker)
* Fix wrongly discarded DISTINCT clause (RT#53186)

* Fix parsing errors of plain numbers (RT#16931)
* Fix parsing errors of nested calculation / functions (RT#16931, RT#52356)
* Rewrite result calculation of aggregation functions (simplify code,
  speed up)
* Upgrade Makefile.PL (patch from Alexandr Ciornii) to handle different
  EU::MM versions and abilities properly
* Update documentation to show how 'column_defs' and SQL::Statement::Term
  instances shall be used
* Introduce SQL::Dialect::Role providing ini-style data access to
  SQL::Dialects (patch from Michael Schwern)

[Things that may break your code]
* SQL::Parser now didn't deliver a struct containing 'column_names',
  'computed_columns' and 'set_functions' - it's combined into one member
* Minimum required perl version is now 5.8 - upcoming next version of DBI
  requires perl 5.8, too - and I could simplify some code that's why

Version 1.23, release November 20th, 2009

* Applied patch from Marc Espie which fixes several orthographic
  errors in SQL::Statement::Syntax documentation.
* Added a fixed version of test reported via RT #34121

[Bug fixes]
* Fix an issue in UPDATE command which 'shift's the values from
  the list of parameters which causes there're no more parameters
  left after first row get's updated (Fixes RT #50788)
* Fix aggregate function handling of new code since 1.21_01
* Correct handling of DISTINCT in aggregate functions

* Add support for tables/columns starting with '_' for CSV and AnyData,
  which is usually forbidden by ANSI SQL
* Add support for inserting multiple lines with one statement
  (fixes RT #31730)
* Handle ANSI 'IS NULL' and CVS/AnyData 'IS NULL' different

[Things that may break your code]
* row_value now expects up to two arguments

Revision 1.28 / (download) - annotate - [select for diffs], Sat Oct 17 14:25:04 2009 UTC (14 years, 1 month ago) by sno
Branch: MAIN
CVS Tags: pkgsrc-2009Q4-base, pkgsrc-2009Q4
Changes since 1.27: +14 -6 lines
Diff to previous 1.27 (colored)

Updating databases/p5-SQL-Statement from 1.20 to 1.22

pkgsrc changes:
  - Adding license definition
  - Adjusting dependencies
  - Ensure build
  - remove *.orig removal (may break some SunOS builds)

Upstream changes:
Version 1.22, release October 10th, 2009

* Add missing changelog - no code changes

Version 1.21, release October 10th, 2009

* remove version dependency to check previously installed version
* add DBD::File as "Test" requirement

Version 1.21_8, release October 5th, 2009

[Bug fixes]
* Add additional test for bug-fix in 1.21_7 to t/18bigjoin.t

* Correct some typo's in POD

Version 1.21_7, not public released

[Bug fixes]
* Don't fail for non-existent columns introduced by functions
  in joins

Version 1.21_6, release September 24th, 2009

[Bug fixes]
* Don't abort Makefile.PL when in automated smoke tests

Version 1.21_5, release September 23th, 2009

[Bug fixes]
* table order isn't wrongly used in order of appearance when SQL::Parser
  couldn't determine an order
* Some internal fixes

* Updated dependency to Params::Util to non-leaking 1.00
* Note dependency to Carp and Data::Dumper
* rely on version to compare versions
* Update POD for terms
* Update

Version 1.21_4, release September 21th, 2009

[Bug fixes]
* modify regex to match types to fix problems with Perl 5.6.2
* add DESTROY methods to ensure clean up
* fix lower casing internal table names when joining tables
* replace parameter shifting by assigning @_ to the list of parameters

Version 1.21_3, release September 17th, 2009

[Things that may break your code]
* When someone accesses the where_clause attribute of the SQL::Statement
  instance - be aware that now IN and BETWEEN can be native entries

[Bug fixes]
* convert operation to upper case when surely initialized

* IN and BETWEEN are now native operations - they are not expanded
  to OR'ed equalize operations anymore

Version 1.21_2, release September 15th, 2009

[Things that may break your code]
* modify behavior for unquoted identifiers - they're converted and
  returned lower cased now (instead upper cased as in 1.21_1)
  Fixes bug RT #48502

Version 1.21_1, release July 30th, 2009

[Things that may break your code]
* removed SQL::Statement::Column
* don't instantiate SQL::Statement::Functions objects
* Reworked internal column and function handling to reduce code complexity
* rows and columns aren't setable from outside a table or eval object

[Bug fixes and other changes]
* Fixed bugs:
  + RT #47292: Test failures with recent DBI
  + RT #44512: Patch for CREATE TABLE parsing
  + RT #42676: tests 16 failed

Revision 1.27 / (download) - annotate - [select for diffs], Tue Mar 10 17:38:24 2009 UTC (14 years, 8 months ago) by sno
Branch: MAIN
CVS Tags: pkgsrc-2009Q3-base, pkgsrc-2009Q3, pkgsrc-2009Q2-base, pkgsrc-2009Q2, pkgsrc-2009Q1-base, pkgsrc-2009Q1
Changes since 1.26: +5 -6 lines
Diff to previous 1.26 (colored)

PkgSrc changes:

- 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

Revision 1.26 / (download) - annotate - [select for diffs], Wed Feb 25 21:06:00 2009 UTC (14 years, 9 months ago) by sno
Branch: MAIN
Changes since 1.25: +5 -1 lines
Diff to previous 1.25 (colored)

pkgsrc changes:

- add dependencies as they were noted in META.yml during the upstream changes

Revision 1.25 / (download) - annotate - [select for diffs], Tue Feb 24 20:44:54 2009 UTC (14 years, 9 months ago) by he
Branch: MAIN
Changes since 1.24: +6 -2 lines
Diff to previous 1.24 (colored)

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

Revision 1.24 / (download) - annotate - [select for diffs], Mon Jan 19 22:54:24 2009 UTC (14 years, 10 months ago) by he
Branch: MAIN
Changes since 1.23: +3 -4 lines
Diff to previous 1.23 (colored)

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

Revision 1.23 / (download) - annotate - [select for diffs], Sun Oct 19 19:17:46 2008 UTC (15 years, 1 month ago) by he
Branch: MAIN
CVS Tags: pkgsrc-2008Q4-base, pkgsrc-2008Q4
Changes since 1.22: +2 -1 lines
Diff to previous 1.22 (colored)

Bump the PKGREVISION for all packages which depend directly on perl,
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
or PERL5_PACKLIST defined in their make setup (tested via
"make show-vars VARNAMES=...").

Revision 1.22 / (download) - annotate - [select for diffs], Wed Jul 23 22:57:11 2008 UTC (15 years, 4 months ago) by rhaen
Branch: MAIN
CVS Tags: pkgsrc-2008Q3-base, pkgsrc-2008Q3, cube-native-xorg-base, cube-native-xorg
Changes since 1.21: +3 -4 lines
Diff to previous 1.21 (colored)

updated to 1.15

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, <>

 * fixed problem with all_cols slowing inserts
   thanks for patch and test Cosimo Streppone <>

 * cleaned up case of temp table column names
   thanks for bug report: Dan Wright

 * added a META.YML and extra tests

Revision 1.21 / (download) - annotate - [select for diffs], Thu Jun 12 02:14:18 2008 UTC (15 years, 5 months ago) by joerg
Branch: MAIN
CVS Tags: pkgsrc-2008Q2-base, pkgsrc-2008Q2, cwrapper
Changes since 1.20: +3 -1 lines
Diff to previous 1.20 (colored)

Add DESTDIR support.

Revision 1.20 / (download) - annotate - [select for diffs], Sat Mar 4 21:29:10 2006 UTC (17 years, 9 months ago) by jlam
Branch: MAIN
CVS Tags: pkgsrc-2008Q1-base, pkgsrc-2008Q1, pkgsrc-2007Q4-base, pkgsrc-2007Q4, pkgsrc-2007Q3-base, pkgsrc-2007Q3, pkgsrc-2007Q2-base, pkgsrc-2007Q2, pkgsrc-2007Q1-base, pkgsrc-2007Q1, pkgsrc-2006Q4-base, pkgsrc-2006Q4, pkgsrc-2006Q3-base, pkgsrc-2006Q3, pkgsrc-2006Q2-base, pkgsrc-2006Q2, pkgsrc-2006Q1-base, pkgsrc-2006Q1
Changes since 1.19: +2 -2 lines
Diff to previous 1.19 (colored)

Point MAINTAINER to in the case where no
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

Revision 1.19 / (download) - annotate - [select for diffs], Sat Aug 6 06:19:07 2005 UTC (18 years, 3 months ago) by jlam
Branch: MAIN
CVS Tags: pkgsrc-2005Q4-base, pkgsrc-2005Q4, pkgsrc-2005Q3-base, pkgsrc-2005Q3
Changes since 1.18: +2 -2 lines
Diff to previous 1.18 (colored)

Bump the PKGREVISIONs of all (638) packages that hardcode the locations
of Perl files to deal with the perl-5.8.7 update that moved all
pkgsrc-installed Perl files into the "vendor" directories.

Revision 1.18 / (download) - annotate - [select for diffs], Wed Jul 13 18:01:21 2005 UTC (18 years, 4 months ago) by jlam
Branch: MAIN
Changes since 1.17: +2 -2 lines
Diff to previous 1.17 (colored)

Turn PERL5_PACKLIST into a relative path instead of an absolute path.
These paths are now relative to PERL5_PACKLIST_DIR, which currently
defaults to ${PERL5_SITEARCH}.  There is no change to the binary

Revision 1.17 / (download) - annotate - [select for diffs], Mon Apr 11 21:45:13 2005 UTC (18 years, 7 months ago) by tv
Branch: MAIN
CVS Tags: pkgsrc-2005Q2-base, pkgsrc-2005Q2
Changes since 1.16: +1 -2 lines
Diff to previous 1.16 (colored)

Remove USE_BUILDLINK3 and NO_BUILDLINK; these are no longer used.

Revision 1.16 / (download) - annotate - [select for diffs], Sun Apr 3 05:06:42 2005 UTC (18 years, 8 months ago) by mjl
Branch: MAIN
Changes since 1.15: +3 -3 lines
Diff to previous 1.15 (colored)

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
 * added support for user-defined functions, see
 * 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:
 	- DECODE (same as Oracle DECODE)
 * fixed/adapted SQL::Statement::get_row_value(),
	SQL::Statement::SELECT(), for join'ed
 * 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

Revision 1.15 / (download) - annotate - [select for diffs], Mon Dec 20 11:30:57 2004 UTC (18 years, 11 months ago) by grant
Branch: MAIN
CVS Tags: pkgsrc-2005Q1-base, pkgsrc-2005Q1, pkgsrc-2004Q4-base, pkgsrc-2004Q4
Changes since 1.14: +2 -1 lines
Diff to previous 1.14 (colored)

since perl is now built with threads on most platforms, the perl archlib
module directory has changed (eg. "darwin-2level" vs.

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.

Revision 1.14 / (download) - annotate - [select for diffs], Tue Apr 27 05:44:22 2004 UTC (19 years, 7 months ago) by snj
Branch: MAIN
CVS Tags: pkgsrc-2004Q3-base, pkgsrc-2004Q3, pkgsrc-2004Q2-base, pkgsrc-2004Q2
Changes since 1.13: +2 -2 lines
Diff to previous 1.13 (colored)

Convert to buildlink3.

Revision 1.13 / (download) - annotate - [select for diffs], Mon Jul 21 16:39:11 2003 UTC (20 years, 4 months ago) by martti
Branch: MAIN
CVS Tags: pkgsrc-2004Q1-base, pkgsrc-2004Q1, pkgsrc-2003Q4-base, pkgsrc-2003Q4
Changes since 1.12: +2 -2 lines
Diff to previous 1.12 (colored)

COMMENT should start with a capital letter.

Revision 1.12 / (download) - annotate - [select for diffs], Thu Jul 17 21:28:43 2003 UTC (20 years, 4 months ago) by grant
Branch: MAIN
Changes since 1.11: +2 -2 lines
Diff to previous 1.11 (colored)


Revision 1.11 / (download) - annotate - [select for diffs], Mon Jun 2 01:21:03 2003 UTC (20 years, 6 months ago) by jschauma
Branch: MAIN
Changes since 1.10: +2 -2 lines
Diff to previous 1.10 (colored)

Use tech-pkg@ in favor of packages@ as MAINTAINER for orphaned packages.
Should anybody feel like they could be the maintainer for any of thewe packages,
please adjust.

Revision 1.10 / (download) - annotate - [select for diffs], Mon Mar 3 11:09:44 2003 UTC (20 years, 9 months ago) by mjl
Branch: MAIN
Changes since 1.9: +2 -2 lines
Diff to previous 1.9 (colored)

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 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
 * improved and/or fixed bugs in:
   * placeholder support
   * ORDER BY clause
   * LIKE/CLIKE/RLIKE/IN predicates
   * table name aliases in explicit joins

Revision 1.9 / (download) - annotate - [select for diffs], Sun Oct 13 22:22:54 2002 UTC (21 years, 1 month ago) by seb
Branch: MAIN
CVS Tags: netbsd-1-6-1-base, netbsd-1-6-1
Changes since 1.8: +3 -6 lines
Diff to previous 1.8 (colored)

Use buildlink2. Use perl5/

Revision 1.8 / (download) - annotate - [select for diffs], Thu Feb 14 16:02:50 2002 UTC (21 years, 9 months ago) by mjl
Branch: MAIN
CVS Tags: pkgviews-base, pkgviews, netbsd-1-6-RELEASE-base, netbsd-1-6, netbsd-1-5-PATCH003, buildlink2-base, buildlink2
Changes since 1.7: +2 -2 lines
Diff to previous 1.7 (colored)

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.

Revision 1.7 / (download) - annotate - [select for diffs], Fri Nov 30 14:19:59 2001 UTC (22 years ago) by mjl
Branch: MAIN
Changes since 1.6: +2 -2 lines
Diff to previous 1.6 (colored)

Update to 0.1021

  * Yet another attempt to get rid of those CR/LF line endings. :-(

Revision 1.6 / (download) - annotate - [select for diffs], Mon Nov 26 06:49:42 2001 UTC (22 years ago) by jlam
Branch: MAIN
Changes since 1.5: +4 -3 lines
Diff to previous 1.5 (colored)

Buildlinkify, in the sense that only the perl headers are found in
${PREFIX} -- everything else is pickup up from ${BUILDLINK_DIR}.

Revision 1.5 / (download) - annotate - [select for diffs], Thu Oct 18 15:20:09 2001 UTC (22 years, 1 month ago) by veego
Branch: MAIN
Changes since 1.4: +2 -1 lines
Diff to previous 1.4 (colored)

SVR4 packages have a limit of 9 chars for a package name.
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
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.

Revision 1.4 / (download) - annotate - [select for diffs], Sat May 26 01:49:12 2001 UTC (22 years, 6 months ago) by mjl
Branch: MAIN
Changes since 1.3: +2 -2 lines
Diff to previous 1.3 (colored)

Update to 0.1020. Changes:

        * Changed distribution to include
          files generated by Solaris bison 1.27

        * Added LIMIT clause

Revision 1.3 / (download) - annotate - [select for diffs], Wed Mar 21 17:27:05 2001 UTC (22 years, 8 months ago) by mjl
Branch: MAIN
CVS Tags: netbsd-1-5-PATCH001
Changes since 1.2: +2 -2 lines
Diff to previous 1.2 (colored)

Updated to 0.1017

        * Makefile.PL: Fixed portability issue with Darwin.

Revision 1.2 / (download) - annotate - [select for diffs], Fri Feb 16 14:17:34 2001 UTC (22 years, 9 months ago) by wiz
Branch: MAIN
Changes since 1.1: +2 -1 lines
Diff to previous 1.1 (colored)

Update to new COMMENT style: COMMENT var in Makefile instead of pkg/COMMENT.

Revision / (download) - annotate - [select for diffs] (vendor branch), Mon Oct 23 13:39:52 2000 UTC (23 years, 1 month ago) by mjl
Branch: TNF
CVS Tags: pkgsrc-base
Changes since 1.1: +0 -0 lines
Diff to previous 1.1 (colored)

Initial import of p5-SQL-Statement, a small, abstract SQL engine.

Revision 1.1 / (download) - annotate - [select for diffs], Mon Oct 23 13:39:52 2000 UTC (23 years, 1 month ago) by mjl
Branch: MAIN

Initial revision

This form allows you to request diff's between any two revisions of a file. You may select a symbolic revision name using the selection box or you may type in a numeric name using the type-in text box.

CVSweb <>