noel 2003/05/31 16:37:39
Modified: src/conf Tag: branch_2_1_fcs sqlResources.xml
Log:
MySQL SELECT string comparisions are already case-insensitive. Using lower() in a
WHERE clause effectively negates the index.
Revision Changes Path
No revision
No revision
1.16.4.3 +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.16.4.2
retrieving revision 1.16.4.3
diff -u -r1.16.4.2 -r1.16.4.3
--- sqlResources.xml 10 Jan 2003 20:07:25 -0000 1.16.4.2
+++ sqlResources.xml 31 May 2003 23:37:39 -0000 1.16.4.3
@@ -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]
