Opened 15 years ago

Last modified 12 months ago

#650 new defect

Sqlite filter should not be case sensitive

Reported by: bscott Owned by: traianstanev
Priority: major Milestone: 4.2.0
Component: SQLite Provider Version: 3.5.0
Severity: 3 Keywords:
Cc: External ID:

Description

I have a table with all column uppercase If i do

select MYCOLUMN from MYTABLE

it works fine

select mycolumn from MYTABLE

it works fine

select * from MYTABLE where MYCOLUMN = 1

it works fine

select * from MYTABLE where mycolumn = 1

it does not work

I have found where the problem is and attached a patch for it

Attachments (1)

FilterNoCase.patch (1.1 KB ) - added by bscott 15 years ago.

Download all attachments as: .zip

Change History (4)

by bscott, 15 years ago

Attachment: FilterNoCase.patch added

comment:1 by bscott, 15 years ago

Component: FDO APISQLite Provider
Owner: changed from gregboone to traianstanev

comment:2 by bscott, 15 years ago

Severity: 5 (Wish List)3

comment:3 by jng, 12 months ago

Milestone: 3.6.04.2.0
Note: See TracTickets for help on using tickets.