[interchange-cvs] interchange - racke modified 2 files

[interchange-cvs at icdevgroup.org]

User:      racke
Date:      2007-01-30 11:29:51 GMT
Modified:  .        WHATSNEW-5.5
Modified:  lib/Vend SQL_Parser.pm
Log:
Vend::SQL_Parser required LIMIT clause to be lowercase when it should be
case-insensitive

Revision  Changes    Path
1.27      +3 -0      interchange/WHATSNEW-5.5


rev 1.27, prev_rev 1.26
Index: WHATSNEW-5.5
===================================================================
RCS file: /var/cvs/interchange/WHATSNEW-5.5,v
retrieving revision 1.26
retrieving revision 1.27
diff -u -r1.26 -r1.27
--- WHATSNEW-5.5	26 Jan 2007 01:50:08 -0000	1.26
+++ WHATSNEW-5.5	30 Jan 2007 11:29:51 -0000	1.27
@@ -56,6 +56,9 @@
 * Fix the [error] tag so it does not attempt to replace format specifiers other
   than %s in the text or std_label attributes.
 
+* Vend::SQL_Parser required LIMIT clause to be lowercase when it should be
+  case-insensitive 
+
 UserDB
 ------
 



2.13      +5 -5      interchange/lib/Vend/SQL_Parser.pm


rev 2.13, prev_rev 2.12
Index: SQL_Parser.pm
===================================================================
RCS file: /var/cvs/interchange/lib/Vend/SQL_Parser.pm,v
retrieving revision 2.12
retrieving revision 2.13
diff -u -r2.12 -r2.13
--- SQL_Parser.pm	8 Nov 2005 18:14:45 -0000	2.12
+++ SQL_Parser.pm	30 Jan 2007 11:29:51 -0000	2.13
@@ -1,8 +1,8 @@
 # Vend::SQL_Parser - Interchange SQL parser class
 #
-# $Id: SQL_Parser.pm,v 2.12 2005/11/08 18:14:45 jon Exp $
+# $Id: SQL_Parser.pm,v 2.13 2007/01/30 11:29:51 racke Exp $
 #
-# Copyright (C) 2003-2005 Interchange Development Group
+# Copyright (C) 2003-2007 Interchange Development Group
 #
 # Based on HTML::Parser
 # Copyright 1996 Gisle Aas. All rights reserved.
@@ -18,7 +18,7 @@
 
 =head1 COPYRIGHT
 
-Copyright 2003-2004 Interchange Development Group
+Copyright 2003-2007 Interchange Development Group
 Original SQL::Statement module copyright 1998 Jochen Wiedman.
 
 This library is free software; you can redistribute it and/or
@@ -38,7 +38,7 @@
 use Text::ParseWords;
 use vars qw($VERSION);
 no warnings qw(uninitialized numeric);
-$VERSION = substr(q$Revision: 2.12 $, 10);
+$VERSION = substr(q$Revision: 2.13 $, 10);
 
 sub new {
 	my $class = shift;
@@ -72,7 +72,7 @@
 		or die ::errmsg("improper SQL statement: %s", $statement);
 	$self->{command} = uc $1;
 
-	if($statement =~ s/\s+limit\s+(\d+(?:\s*,\s*(\d+))?)\s*$//) {
+	if($statement =~ s/\s+limit\s+(\d+(?:\s*,\s*(\d+))?)\s*$//i) {
 		$self->{limit_by} = $1;
 	}