System.Data.SQLite

View Ticket
Login
Attach Edit New Ticket Plaintext
2020-05-24
23:07
Update the expected results for the [71bedaca19] ticket test case. Closed-Leaf check-in: 5ae8a13833 user: mistachkin tags: core-3.32.0
2015-07-13
22:41
Add tests for ticket [71bedaca19]. check-in: 1ddef23eb9 user: mistachkin tags: trunk
19:51 • Closed ticket [71bedaca19]: Add enumeration for extended return codes plus 4 other changes artifact: 3fef8b81ec user: mistachkin
19:51
Add extended return codes to the SQLiteErrorCode enumeration. Pursuant to [71bedaca19]. check-in: 42798551ca user: mistachkin tags: trunk
17:19 • Ticket [71bedaca19] Add enumeration for extended return codes status still Open with 3 other changes artifact: 66b76b63f3 user: mistachkin
11:33 • Ticket [71bedaca19]: 3 changes artifact: 6ae7c2c197 user: anonymous
2015-06-03
16:35 • Open ticket [71bedaca19]. artifact: 1a6b119f5b user: mistachkin
2015-06-02
07:37 • New ticket [71bedaca19]. artifact: a0d81bde40 user: anonymous
Ticket Hash: 71bedaca19d94cb6b6c6c2f3deb293b71a2b3133
Title: Add enumeration for extended return codes
Status: Closed Type: Feature_Request
Severity: Minor Priority: Medium
Subsystem: Convert Resolution: Fixed
Last Modified: 2015-07-13 19:51:41
Version Found In: 1.0.98.0
User Comments:
anonymous added on 2015-06-02 07:37:38:

I think there should be an enum SQLiteExtendedResultCode mapping to those described here.

It's rather cumbersome to be able to write
SQLiteErrorCode errorCode = myConnection.ExtendedResultCode();
if (errorCode == SQLiteErrorCode.Constraint)
doSomething();
but then having to write
if ((int)errorCode == 1555 /* SQLiteExtendedResultCode.ConstraintPrimaryKey */)
doSomething();

It would also be nice to have SQLiteException.ErrorCode being an SQLiteErrorCode instead of an int.

anonymous added on 2015-07-13 11:33:19:

Moreover: even after setting myConnection.SetExtendedResultCodes(true) I would have expected myConnection.ResultCode() to still deliver one of the 31 Primary Result Codes - why else should there be a method myConnection.ExtendedResultCode()? The documentation here is by the way erroneous because it says for all three methods "Enables or disabled extended result codes returned by SQLite".
Regards, Bernd

mistachkin added on 2015-07-13 19:51:41: 
Fixed on trunk via check-in [42798551ca].  Instead of creating a new enumeration,
the existing one was updated to include the extended return codes.