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

CommentFileSizeAuthor
#1 views.module.diff419 bytesFredCK

Comments

FredCK’s picture

StatusFileSize
new419 bytes

Sorry... I forgot the patch. Here it is.

merlinofchaos’s picture

Status: Needs review » Fixed
Anonymous’s picture

Status: Fixed » Closed (fixed)