The SQL statement generated for the "=" operator uses the "%" wildcards commonly used with the "LIKE" operator. While this works well with "LIKE", it breaks the "=" functionality.
Today, the statement generated is something like this:
UPPER( <table>.<field> ) = UPPER( '%<value>%' )
While the correct form is:
UPPER( <table>.<field> ) = UPPER( '<value>' )
The proposed patch fix this issue.
Regards,
FredCK
| Comment | File | Size | Author |
|---|---|---|---|
| #1 | views.module.diff | 419 bytes | FredCK |
Comments
Comment #1
FredCK commentedSorry... I forgot the patch. Here it is.
Comment #2
merlinofchaos commentedComment #3
(not verified) commented