Opened 12 years ago

Last modified 12 years ago

#650 new defect

Sqlite filter should not be case sensitive

Reported by: bscott Owned by: traianstanev
Priority: major Milestone: 3.6.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 12 years ago.

Download all attachments as: .zip

Change History (3)

Changed 12 years ago by bscott

Attachment: FilterNoCase.patch added

comment:1 Changed 12 years ago by bscott

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

comment:2 Changed 12 years ago by bscott

Severity: 5 (Wish List)3
Note: See TracTickets for help on using tickets.