System.Data.SQLite
View Ticket
Not logged in
Ticket UUID: 0550f0326eb5dd9ecd2572770e1bd60bf53ce1b2
Title: Regression: Wrong column sizes when "fixed-length" [3113734605]
Status: Closed Type: Incident
Severity: Important Priority: Blocker
Subsystem: Connection Resolution: Fixed
Last Modified: 2014-02-07 08:59:12
Version Found In: 1.0.89.0
User Comments:
anonymous added on 2014-02-03 06:36:02: (text/x-fossil-plain)
Bug from Ticket 311373460518a9069b8a28f2fbacadd9a48ac203 reappeard in version 1.0.89.0. In the schema information the NumericPrecision attribute has the value of the ColumnSize and the ColumnSize attribute returns 2147483647 for string columns with a defined length

mistachkin added on 2014-02-03 20:55:50: (text/x-fossil-plain)
Do you have an example schema that demonstrates the issue?

mistachkin added on 2014-02-04 21:00:18: (text/x-fossil-plain)
Without further information from the opener, ticket will be closed on Thursday,
February 6th, 2014.

anonymous added on 2014-02-06 10:41:05: (text/x-fossil-plain)
If you create a table like this "CREATE TABLE schema_test (first_column VARCHAR(150), second_column VARCHAR(150))" the problem occurs. With Version 1.0.84.1 the ColumnSize the schema information is 150, which is correct. In 1.0.89.0 the ColumnSize is 2147483647 and the NumericPrecision is 150 instead.

I tested using CHAR(150) instead of VARCHAR(150) and this works correct in both versions.

anonymous added on 2014-02-06 10:44:03: (text/x-fossil-plain)
I meant version 1.0.84.0 and not 1.0.84.1 in my previous comment

mistachkin added on 2014-02-06 19:18:22: (text/x-fossil-plain)
Thanks for the test case.  The issue was schema specific.  Somehow, the AnsiString
DbType was still not getting the correct handling.

mistachkin added on 2014-02-06 19:45:36: (text/x-fossil-plain)
Fixed on trunk via check-in [62a5b57a69].

mistachkin added on 2014-02-07 04:08:34: (text/x-fossil-plain)
Issue introduced by check-in [c7b39f9c3b0df8d1].