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:
User Comments:
anonymous added on 2014-02-03 06:36:02: (text/x-fossil-plain)
Bug from Ticket 311373460518a9069b8a28f2fbacadd9a48ac203 reappeard in version 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 the ColumnSize the schema information is 150, which is correct. In 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 and not 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].