noel 2003/05/31 17:02:04
Modified: src/conf sqlResources.xml
Log:
MySQL SELECT string comparisions are already case-insensitive. Using lower() in a
WHERE clause effectively negates the index.
Revision Changes Path
1.18 +7 -0 jakarta-james/src/conf/sqlResources.xml
Index: sqlResources.xml
===================================================================
RCS file: /home/cvs/jakarta-james/src/conf/sqlResources.xml,v
retrieving revision 1.17
retrieving revision 1.18
diff -u -r1.17 -r1.18
--- sqlResources.xml 15 Feb 2003 03:07:30 -0000 1.17
+++ sqlResources.xml 1 Jun 2003 00:02:03 -0000 1.18
@@ -56,6 +56,13 @@
WHERE lower(username) = ?
</sql>
+ <sql name="selectByLowercaseName" db="mysql">
+ SELECT username, pwdHash, pwdAlgorithm, useForwarding,
+ forwardDestination, useAlias, alias
+ FROM ${table}
+ WHERE username = ?
+ </sql>
+
<!-- Statements used to insert a user into this repository. -->
<sql name="insert">INSERT INTO ${table}
(username, pwdHash, pwdAlgorithm, useForwarding,
forwardDestination, useAlias, alias)
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
