diff options
| author | mjl <mjl@pkgsrc.org> | 2003-03-03 11:09:44 +0000 |
|---|---|---|
| committer | mjl <mjl@pkgsrc.org> | 2003-03-03 11:09:44 +0000 |
| commit | beb17b6fef928f911582d4043dd23bf842e5277b (patch) | |
| tree | 7de1a6c5002cbd1f13401f85392001f5ca397dcd | |
| parent | a7abc1596356a4565c3f575879bd4993ea7e24bf (diff) | |
| download | pkgsrc-beb17b6fef928f911582d4043dd23bf842e5277b.tar.gz | |
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
| -rw-r--r-- | databases/p5-SQL-Statement/Makefile | 4 | ||||
| -rw-r--r-- | databases/p5-SQL-Statement/distinfo | 8 | ||||
| -rw-r--r-- | databases/p5-SQL-Statement/patches/patch-aa | 26 |
3 files changed, 18 insertions, 20 deletions
diff --git a/databases/p5-SQL-Statement/Makefile b/databases/p5-SQL-Statement/Makefile index f4d7d73fa02..6b12103eaf9 100644 --- a/databases/p5-SQL-Statement/Makefile +++ b/databases/p5-SQL-Statement/Makefile @@ -1,7 +1,7 @@ -# $NetBSD: Makefile,v 1.9 2002/10/13 22:22:54 seb Exp $ +# $NetBSD: Makefile,v 1.10 2003/03/03 11:09:44 mjl Exp $ # -DISTNAME= SQL-Statement-1.002 +DISTNAME= SQL-Statement-1.005 PKGNAME= p5-${DISTNAME} SVR4_PKGNAME= p5sqs CATEGORIES= databases perl5 diff --git a/databases/p5-SQL-Statement/distinfo b/databases/p5-SQL-Statement/distinfo index 4e88eca17b1..8325ded5975 100644 --- a/databases/p5-SQL-Statement/distinfo +++ b/databases/p5-SQL-Statement/distinfo @@ -1,5 +1,5 @@ -$NetBSD: distinfo,v 1.5 2002/02/14 16:02:51 mjl Exp $ +$NetBSD: distinfo,v 1.6 2003/03/03 11:09:44 mjl Exp $ -SHA1 (SQL-Statement-1.002.tar.gz) = b1784d69d1b48ae2af6d24da79090650471d8a3c -Size (SQL-Statement-1.002.tar.gz) = 43478 bytes -SHA1 (patch-aa) = 18142d097cd213ffe4d377732119254ea3825f87 +SHA1 (SQL-Statement-1.005.tar.gz) = 066b658732f15faea203764996b543eed12f0de9 +Size (SQL-Statement-1.005.tar.gz) = 53841 bytes +SHA1 (patch-aa) = c8ff44669e45201262d042612fbce32bc430efbc diff --git a/databases/p5-SQL-Statement/patches/patch-aa b/databases/p5-SQL-Statement/patches/patch-aa index 4ac30fa474e..afb0f6a0c2f 100644 --- a/databases/p5-SQL-Statement/patches/patch-aa +++ b/databases/p5-SQL-Statement/patches/patch-aa @@ -1,15 +1,13 @@ -$NetBSD: patch-aa,v 1.1 2002/02/14 16:02:51 mjl Exp $ - ---- Makefile.PL.orig Thu Feb 14 16:57:52 2002 -+++ Makefile.PL Thu Feb 14 16:58:16 2002 +--- 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 = <STDIN>; --last if $x; -+#my $x = <STDIN>; -+#last if $x; - } - }; - +
+ END_OF_WARNING
+ print "Press enter to continue ... ";
+-my $x = <STDIN>;
+-last if $x;
++# my $x = <STDIN>;
++# last if $x;
+ }
+ };
+
|