|Title:||Regression: Wrong column sizes when "fixed-length" |
|Last Modified:||2014-02-07 08:59:12|
|Version Found In:||220.127.116.11|
anonymous added on 2014-02-03 06:36:02:
Bug from Ticket 311373460518a9069b8a28f2fbacadd9a48ac203 reappeard in version 18.104.22.168. 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 22.214.171.124 the ColumnSize the schema information is 150, which is correct. In 126.96.36.199 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 188.8.131.52 and not 184.108.40.206 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].