CaseInsensitiveComparison BUG with VARCHAR Key

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
YZahringer
Posts: 2
Joined: Tue 21 Aug 2012 08:39

CaseInsensitiveComparison BUG with VARCHAR Key

Post by YZahringer » Tue 28 Jan 2014 08:59

Hello,

When I set CaseInsensitiveComparison="true", EF5 Update queries on the VARCHAR primary key no longer works.

Here is the query executed:
UPDATE PERSONEXTENDEDFIELDTITLE
SET PERSONEXTENDEDFIELDTITLEVALUE = :p0, LPERSONEXTENDEDFIELDTITLEVALUE = :p1, CREATIONDATE = :p2, MODIFICATIONDATE = :p3
WHERE (ToUpper(PERSONEXTENDEDFIELDTITLENAME)) = (ToUpper(:p4))

Here is the error:
ORA-00904: "TOUPPER": invalid identifier

I'm on devart dotConnect for Oracle Pro v8.2.80, .NET 4.5 and Oracle 11.2.0.3.

I think it's a bug...

Best regards,
Yann

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Re: CaseInsensitiveComparison BUG with VARCHAR Key

Post by Shalex » Wed 29 Jan 2014 11:09

The bug with updating/deleting entity, when its primary key column or concurrency check column is of string type and config.QueryOptions.CaseInsensitiveComparison=True, is fixed. We will notify you when the corresponding build of dotConnect for Oracle is available for download.

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Re: CaseInsensitiveComparison BUG with VARCHAR Key

Post by Shalex » Thu 30 Jan 2014 16:18

New build of dotConnect for Oracle 8.2.90 is available for download!
It can be downloaded from http://www.devart.com/dotconnect/oracle/download.html (trial version) or from Registered Users' Area (for users with active subscription only).
For more information, please refer to http://forums.devart.com/viewtopic.php?f=1&t=28830.

Post Reply