#7 SQL operator AND case sensitive

[eric boulet]

When I use a query with logical operator 'AND' in
uppercase, the DB return an error. If I use the same
query with lowercase, the DB return correct response.

I use OS "Windows 2000 Pro".
I use I use java version 1.4.1_01

See the following example.

=======================================
Example :

Ashpool~# SELECT * FROM users WHERE login='toto'
AND pwd='toto';
Error at xsl:apply-templates on line 1 of :
XPath syntax error in ?*/*[login='toto' AND pwd?:
expected "]", found "QName AND"
Error with command:
'SELECT * FROM users WHERE login='toto' AND
pwd='toto''
com.rohanclan.ashpool.core.AshpoolException: Failed to
compile stylesheet. 1 err
or detected.
Ashpool~# SELECT * FROM users WHERE login='toto'
and pwd='toto';
==========================================
======================================

login|pwd|
-------------------------------------------------------
-------------------------

toto|toto|

======================================