System.Data.SQLite

Login
This project makes use of Eagle, provided by Mistachkin Systems.
Eagle: Secure Software Automation
2018-12-23
05:03 Ticket [e36e05e299] SqliteDataReader getOrdinal does not conform System.Data.Common.DbDataReader status still Closed with 4 other changes artifact: db39dc3c82 user: mistachkin
05:00 Closed ticket [e36e05e299]. artifact: dae01f4545 user: mistachkin
00:01
Add experimental StrictConformance connection flag to force strict compliance to the ADO.NET standard. Pursuant to [e36e05e299]. check-in: 4012cc2587 user: mistachkin tags: trunk
2018-12-22
20:06 Ticket [e36e05e299] SqliteDataReader getOrdinal does not conform System.Data.Common.DbDataReader status still Pending with 4 other changes artifact: 87023307be user: mistachkin
17:51 Pending ticket [e36e05e299]. artifact: c4b615a6cd user: mistachkin
2018-12-21
10:29 New ticket [e36e05e299]. artifact: 1f7bdaa5d9 user: anonymous

Ticket Hash: e36e05e2992afa41e41fc3b989be9281288294a0
Title: SqliteDataReader getOrdinal does not conform System.Data.Common.DbDataReader
Status: Closed Type: Code_Defect
Severity: Important Priority: Blocker
Subsystem: Data_Reader Resolution: Fixed
Last Modified: 2018-12-23 05:03:20
Version Found In: 1.0.109.2
User Comments:
anonymous added on 2018-12-21 10:29:22:
Hi,

We encountered an issue with the method GetOrdinal on the SQLiteDataReader class. We expected an Exception when calling this method with a not existing column, but instead we got -1 as ordinal position.

According to the API description of System.Data.Common.DbDataReader this call should return an IndexOutOfRangeException instead of -1:
https://docs.microsoft.com/en-us/dotnet/api/system.data.common.dbdatareader.getordinal?view=netframework-4.7.2#System_Data_Common_DbDataReader_GetOrdinal_System_String_

Can you please verify and confirm. And is it possible that this can be fixed?

Regards,

Arjen van Efferen

mistachkin added on 2018-12-22 20:06:35:
I'm adding the "StrictConformance" connection flag in order to enable this
behavior.  In the future, this flag will be used to enable other features
needed for strict ADO.NET conformance.

mistachkin added on 2018-12-23 05:00:01:
Fixed on trunk via check-in [4012cc2587fb9149].

Using the new connection flag "StrictConformance" will enable throwing an
exception when the GetOrdinal method cannot find the column name.

mistachkin added on 2018-12-23 05:03:20:
It should be noted here that the new "StrictConformance" flag may be enhanced in
the future to enable other behaviors required for stricter ADO.NET conformance.