# HG changeset patch
# User Richard Jones <richard@users.sourceforge.net>
# Date 1048481595 0
# Node ID 905f92b97d4ef651b1de0eeb9ee27add8e8a0d26
# Parent  a61ca144d3a4e63506539752d75b2d3891b00428
backport of mail address case problem from HEAD

diff -r a61ca144d3a4 -r 905f92b97d4e CHANGES.txt
--- a/CHANGES.txt	Fri Mar 21 21:43:04 2003 +0000
+++ b/CHANGES.txt	Mon Mar 24 04:53:15 2003 +0000
@@ -8,6 +8,7 @@
 - required String properties not being flagged (thanks Ajit George)
 - only look for CSV files when importing (thanks Dan Grassi)
 - can now unset values in CSV editing (sf bug 704788)
+- fixed rdbms email address lookup (case insensitivity)
 
 
 2003-02-27 0.5.6
diff -r a61ca144d3a4 -r 905f92b97d4e roundup/backends/rdbms_common.py
--- a/roundup/backends/rdbms_common.py	Fri Mar 21 21:43:04 2003 +0000
+++ b/roundup/backends/rdbms_common.py	Mon Mar 24 04:53:15 2003 +0000
@@ -1,4 +1,4 @@
-# $Id: rdbms_common.py,v 1.27.2.7 2003-03-14 02:52:03 richard Exp $
+# $Id: rdbms_common.py,v 1.27.2.8 2003-03-24 04:53:14 richard Exp $
 ''' Relational database (SQL) backend common code.
 
 Basics:
@@ -1666,7 +1666,7 @@
             args.append(requirements[propname].lower())
 
         # generate the where clause
-        s = ' and '.join(['_%s=%s'%(col, self.db.arg) for col in where])
+        s = ' and '.join(['lower(_%s)=%s'%(col, self.db.arg) for col in where])
         sql = 'select id from _%s where %s'%(self.classname, s)
         self.db.sql(sql, tuple(args))
         l = [x[0] for x in self.db.sql_fetchall()]
diff -r a61ca144d3a4 -r 905f92b97d4e test/test_mailgw.py
--- a/test/test_mailgw.py	Fri Mar 21 21:43:04 2003 +0000
+++ b/test/test_mailgw.py	Mon Mar 24 04:53:15 2003 +0000
@@ -8,7 +8,7 @@
 # but WITHOUT ANY WARRANTY; without even the implied warranty of
 # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
 #
-# $Id: test_mailgw.py,v 1.37.2.1 2003-02-06 05:44:49 richard Exp $
+# $Id: test_mailgw.py,v 1.37.2.2 2003-03-24 04:53:15 richard Exp $
 
 import unittest, cStringIO, tempfile, os, shutil, errno, imp, sys, difflib
 
@@ -122,7 +122,7 @@
         self.instance.config.ADD_AUTHOR_TO_NOSY = 'yes'
         message = cStringIO.StringIO('''Content-Type: text/plain;
   charset="iso-8859-1"
-From: Chef <chef@bork.bork.bork>
+From: Chef <Chef@bork.bork.bork>
 To: issue_tracker@your.tracker.email.domain.example
 Cc: richard@test
 Message-Id: <dummy_test_message_id>
@@ -143,7 +143,7 @@
     def testAlternateAddress(self):
         message = cStringIO.StringIO('''Content-Type: text/plain;
   charset="iso-8859-1"
-From: John Doe <john.doe@test>
+From: john doe <John.Doe@test>
 To: issue_tracker@your.tracker.email.domain.example
 Message-Id: <dummy_test_message_id>
 Subject: [issue] Testing...