Edgewall Software

Opened 13 years ago

Closed 13 years ago

Last modified 12 years ago

#4363 closed defect (fixed)

in PostgreSQL equality ("X = Y") is case-sensitive

Reported by: wkornewald Owned by: Jonas Borgström
Priority: high Milestone: 0.11
Component: ticket system Version: 0.10.2
Severity: normal Keywords:
Cc: Branch:
Release Notes:
API Changes:
Internal Changes:


In the query dialog, string comparison is case-sensitive, so when you search for summaries containing "postgresql" you won't get results with "PostgreSQL", for example. For PostgreSQL it would be better to use the lower() function when doing exact matches and use case-insensitive altenatives where possible (e.g: ILIKE instead of LIKE).

Attachments (0)

Change History (5)

comment:1 by Jonas Borgström, 13 years ago

Status: newassigned

Yes, it appears like the query module doesn't use the like() and like_escape() methods provided by the db connectin api.

comment:2 by Jonas Borgström, 13 years ago

r4435 fixes one bug where the "contains", "begins with", "ends with" query filters were case-sensitive on postgresql but insensitive on sqlite and mysql.

The "is" and "is not" operations however are still always case-sensitive. Should we change this behavior?

comment:3 by Christian Boos, 13 years ago

I think it's ok like that, as "is" suggests exact match.

comment:4 by Jonas Borgström, 13 years ago

Resolution: fixed
Status: assignedclosed

Ok, then I'll resolve this ticket as fixed.

in reply to:  4 comment:5 by Leandro Conde <leandor AT gmail>, 12 years ago

Replying to jonas:

Ok, then I'll resolve this ticket as fixed.

Could this solution be extended also to the session table sid string?

Modify Ticket

Change Properties
Set your email in Preferences
as closed The owner will remain Jonas Borgström.
The resolution will be deleted. Next status will be 'reopened'.
to The owner will be changed from Jonas Borgström to the specified user.

Add Comment

E-mail address and name can be saved in the Preferences .
Note: See TracTickets for help on using tickets.