Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Include DbType.AnsiString in the list of types that need special ColumnSize handling. Fix for [0550f0326e]. |
|---|---|
| Downloads: | Tarball | ZIP archive | SQL archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA1: |
62a5b57a6903700f50b85567db34ef83 |
| User & Date: | mistachkin 2014-02-06 19:45:08 |
References
|
2014-02-06
| ||
| 19:45 | • Ticket [0550f0326e] Regression: Wrong column sizes when "fixed-length" [3113734605] status still Pending with 3 other changes artifact: e57b6089dd user: mistachkin | |
Context
|
2014-02-06
| ||
| 19:58 | Update the new vtab test case to handle optional leading minus signs. check-in: dea86ba7d9 user: mistachkin tags: trunk | |
| 19:45 | Include DbType.AnsiString in the list of types that need special ColumnSize handling. Fix for [0550f0326e]. check-in: 62a5b57a69 user: mistachkin tags: trunk | |
|
2014-02-05
| ||
| 21:05 | Add another test. check-in: 00e7e89139 user: mistachkin tags: trunk | |
Changes
Changes to Doc/Extra/Provider/version.html.
53 54 55 56 57 58 59 60 61 62 63 64 65 66 |
<li>Add SQLiteCompileOptions and InteropCompileOptions properties to the SQLiteConnection class to return the compile-time options for the SQLite core library and interop assembly, respectively.</li>
<li>Add BindInvariantText and ConvertInvariantText connection flags to force the invariant culture to be used when converting parameter values to/from strings.</li>
<li>Add NoConnectionPool and UseConnectionPool connection flags to disable or enable connection pooling by default.</li>
<li>Modify handling of the design-time components installer to run Visual Studio <b>devenv.exe /setup</b> after installing the package. This appears to be necessary in some circumstances for Visual Studio 2013. Pursuant to <a href="http://system.data.sqlite.org/index.html/info/a47eff2c71">[a47eff2c71]</a>.</li>
<li>Modify the native library pre-loader to support reading settings from an XML configuration file and to be capable of checking more than one directory. Persuant to <a href="http://system.data.sqlite.org/index.html/info/f0246d1817">[f0246d1817]</a>.</li>
<li>Support detecting when the native library pre-loader should use the CodeBase property instead of the Location property as the basis for locating the interop assembly.</li>
<li>Change the default behavior for the native library pre-loader so it first searches the executing (i.e. System.Data.SQLite) assembly directory and then the application domain directory. Pursuant to <a href="http://system.data.sqlite.org/index.html/info/f0246d1817">[f0246d1817]</a>. <b>** Potentially Incompatible Change **</b></li>
</ul>
<p><b>1.0.90.0 - December 23, 2013</b></p>
<ul>
<li>Updated to <a href="http://www.sqlite.org/releaselog/3_8_2.html">SQLite 3.8.2</a>.</li>
<li>Add Visual Studio 2013 support to all the applicable solution/project files, their associated supporting files, and the test suite.</li>
<li>Add Visual Studio 2013 support to the redesigned designer support installer.</li>
<li>Add support for Windows Embedded Compact 2013.</li>
|
> |
53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 |
<li>Add SQLiteCompileOptions and InteropCompileOptions properties to the SQLiteConnection class to return the compile-time options for the SQLite core library and interop assembly, respectively.</li>
<li>Add BindInvariantText and ConvertInvariantText connection flags to force the invariant culture to be used when converting parameter values to/from strings.</li>
<li>Add NoConnectionPool and UseConnectionPool connection flags to disable or enable connection pooling by default.</li>
<li>Modify handling of the design-time components installer to run Visual Studio <b>devenv.exe /setup</b> after installing the package. This appears to be necessary in some circumstances for Visual Studio 2013. Pursuant to <a href="http://system.data.sqlite.org/index.html/info/a47eff2c71">[a47eff2c71]</a>.</li>
<li>Modify the native library pre-loader to support reading settings from an XML configuration file and to be capable of checking more than one directory. Persuant to <a href="http://system.data.sqlite.org/index.html/info/f0246d1817">[f0246d1817]</a>.</li>
<li>Support detecting when the native library pre-loader should use the CodeBase property instead of the Location property as the basis for locating the interop assembly.</li>
<li>Change the default behavior for the native library pre-loader so it first searches the executing (i.e. System.Data.SQLite) assembly directory and then the application domain directory. Pursuant to <a href="http://system.data.sqlite.org/index.html/info/f0246d1817">[f0246d1817]</a>. <b>** Potentially Incompatible Change **</b></li>
<li>Include DbType.AnsiString in the list of types that need special ColumnSize handling. Fix for <a href="http://system.data.sqlite.org/index.html/info/0550f0326e">[0550f0326e]</a>.</li>
</ul>
<p><b>1.0.90.0 - December 23, 2013</b></p>
<ul>
<li>Updated to <a href="http://www.sqlite.org/releaselog/3_8_2.html">SQLite 3.8.2</a>.</li>
<li>Add Visual Studio 2013 support to all the applicable solution/project files, their associated supporting files, and the test suite.</li>
<li>Add Visual Studio 2013 support to the redesigned designer support installer.</li>
<li>Add support for Windows Embedded Compact 2013.</li>
|
Changes to System.Data.SQLite/SQLiteDataReader.cs.
957 958 959 960 961 962 963 964 965 966 967 968 969 970 971 972 |
if (arSize.Length > 1)
{
dataType = arSize[0];
arSize = arSize[1].Split(')');
if (arSize.Length > 1)
{
arSize = arSize[0].Split(',', '.');
if (sqlType.Type == DbType.Binary || sqlType.Type == DbType.String ||
sqlType.Type == DbType.AnsiStringFixedLength || sqlType.Type == DbType.StringFixedLength)
{
row[SchemaTableColumn.ColumnSize] = Convert.ToInt32(arSize[0], CultureInfo.InvariantCulture);
}
else
{
row[SchemaTableColumn.NumericPrecision] = Convert.ToInt32(arSize[0], CultureInfo.InvariantCulture);
if (arSize.Length > 1)
|
> | | |
957 958 959 960 961 962 963 964 965 966 967 968 969 970 971 972 973 |
if (arSize.Length > 1)
{
dataType = arSize[0];
arSize = arSize[1].Split(')');
if (arSize.Length > 1)
{
arSize = arSize[0].Split(',', '.');
if (sqlType.Type == DbType.AnsiString || sqlType.Type == DbType.Binary ||
sqlType.Type == DbType.String || sqlType.Type == DbType.AnsiStringFixedLength ||
sqlType.Type == DbType.StringFixedLength)
{
row[SchemaTableColumn.ColumnSize] = Convert.ToInt32(arSize[0], CultureInfo.InvariantCulture);
}
else
{
row[SchemaTableColumn.NumericPrecision] = Convert.ToInt32(arSize[0], CultureInfo.InvariantCulture);
if (arSize.Length > 1)
|
Changes to Tests/tkt-3113734605.eagle.
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
..
51
52
53
54
55
56
57
58
59
60
61
62
63
64
|
runTest {test tkt-3113734605-1.1 {ColumnSize and NumericPrecision} -setup {
setupDb [set fileName tkt-3113734605-1.1.db]
} -body {
set connection [getDbConnection]
set result [list]
sql execute $db "CREATE TABLE t1 (x CHAR(3));"
sql execute $db "CREATE VIEW v1 AS SELECT * FROM t1;"
foreach collectionName [list TABLECOLUMNS VIEWCOLUMNS] {
set dataTable [object invoke -alias $connection GetSchema $collectionName]
if {[string length $dataTable] > 0} then {
set dataRows [$dataTable Rows]
................................................................................
freeDbConnection
unset -nocomplain value dataRow dataRows dataTable collectionName result \
connection db fileName
} -constraints \
{eagle monoBug28 command.sql compile.DATA SQLite System.Data.SQLite} -match \
regexp -result {^t1 x 3 System#DBNull#\d+ v1 x 3 System#DBNull#\d+ t1 x 3\
System#DBNull#\d+$}}
###############################################################################
runSQLiteTestEpilogue
runTestEpilogue
|
|
>
>
>
>
>
|
>
>
>
>
|
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
..
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
|
runTest {test tkt-3113734605-1.1 {ColumnSize and NumericPrecision} -setup {
setupDb [set fileName tkt-3113734605-1.1.db]
} -body {
set connection [getDbConnection]
set result [list]
sql execute $db {
CREATE TABLE t1(
v BINARY(12), w CHAR(23), x NCHAR(34), y VARCHAR(45), z NVARCHAR(56)
);
}
sql execute $db "CREATE VIEW v1 AS SELECT * FROM t1;"
foreach collectionName [list TABLECOLUMNS VIEWCOLUMNS] {
set dataTable [object invoke -alias $connection GetSchema $collectionName]
if {[string length $dataTable] > 0} then {
set dataRows [$dataTable Rows]
................................................................................
freeDbConnection
unset -nocomplain value dataRow dataRows dataTable collectionName result \
connection db fileName
} -constraints \
{eagle monoBug28 command.sql compile.DATA SQLite System.Data.SQLite} -match \
regexp -result {^t1 v 12 System#DBNull#\d+ t1 w 23 System#DBNull#\d+ t1 x 34\
System#DBNull#\d+ t1 y 45 System#DBNull#\d+ t1 z 56 System#DBNull#\d+ v1 v 12\
System#DBNull#\d+ v1 w 23 System#DBNull#\d+ v1 x 34 System#DBNull#\d+ v1 y 45\
System#DBNull#\d+ v1 z 56 System#DBNull#\d+ t1 v 12 System#DBNull#\d+ t1 w 23\
System#DBNull#\d+ t1 x 34 System#DBNull#\d+ t1 y 45 System#DBNull#\d+ t1 z 56\
System#DBNull#\d+$}}
###############################################################################
runSQLiteTestEpilogue
runTestEpilogue
|
Changes to readme.htm.
220 221 222 223 224 225 226 227 228 229 230 231 232 233 |
<li>Add SQLiteCompileOptions and InteropCompileOptions properties to the SQLiteConnection class to return the compile-time options for the SQLite core library and interop assembly, respectively.</li>
<li>Add BindInvariantText and ConvertInvariantText connection flags to force the invariant culture to be used when converting parameter values to/from strings.</li>
<li>Add NoConnectionPool and UseConnectionPool connection flags to disable or enable connection pooling by default.</li>
<li>Modify handling of the design-time components installer to run Visual Studio <b>devenv.exe /setup</b> after installing the package. This appears to be necessary in some circumstances for Visual Studio 2013. Pursuant to [a47eff2c71].</li>
<li>Modify the native library pre-loader to support reading settings from an XML configuration file and to be capable of checking more than one directory. Persuant to [f0246d1817].</li>
<li>Support detecting when the native library pre-loader should use the CodeBase property instead of the Location property as the basis for locating the interop assembly.</li>
<li>Change the default behavior for the native library pre-loader so it first searches the executing (i.e. System.Data.SQLite) assembly directory and then the application domain directory. Pursuant to [f0246d1817]. <b>** Potentially Incompatible Change **</b></li>
</ul>
<p>
<b>1.0.90.0 - December 23, 2013</b>
</p>
<ul>
<li>Updated to <a href="http://www.sqlite.org/releaselog/3_8_2.html">SQLite 3.8.2</a>.</li>
<li>Add Visual Studio 2013 support to all the applicable solution/project files, their associated supporting files, and the test suite.</li>
|
> |
220 221 222 223 224 225 226 227 228 229 230 231 232 233 234 |
<li>Add SQLiteCompileOptions and InteropCompileOptions properties to the SQLiteConnection class to return the compile-time options for the SQLite core library and interop assembly, respectively.</li>
<li>Add BindInvariantText and ConvertInvariantText connection flags to force the invariant culture to be used when converting parameter values to/from strings.</li>
<li>Add NoConnectionPool and UseConnectionPool connection flags to disable or enable connection pooling by default.</li>
<li>Modify handling of the design-time components installer to run Visual Studio <b>devenv.exe /setup</b> after installing the package. This appears to be necessary in some circumstances for Visual Studio 2013. Pursuant to [a47eff2c71].</li>
<li>Modify the native library pre-loader to support reading settings from an XML configuration file and to be capable of checking more than one directory. Persuant to [f0246d1817].</li>
<li>Support detecting when the native library pre-loader should use the CodeBase property instead of the Location property as the basis for locating the interop assembly.</li>
<li>Change the default behavior for the native library pre-loader so it first searches the executing (i.e. System.Data.SQLite) assembly directory and then the application domain directory. Pursuant to [f0246d1817]. <b>** Potentially Incompatible Change **</b></li>
<li>Include DbType.AnsiString in the list of types that need special ColumnSize handling. Fix for [0550f0326e].</li>
</ul>
<p>
<b>1.0.90.0 - December 23, 2013</b>
</p>
<ul>
<li>Updated to <a href="http://www.sqlite.org/releaselog/3_8_2.html">SQLite 3.8.2</a>.</li>
<li>Add Visual Studio 2013 support to all the applicable solution/project files, their associated supporting files, and the test suite.</li>
|
Changes to www/news.wiki.
14 15 16 17 18 19 20 21 22 23 24 25 26 27 |
<li>Add SQLiteCompileOptions and InteropCompileOptions properties to the SQLiteConnection class to return the compile-time options for the SQLite core library and interop assembly, respectively.</li>
<li>Add BindInvariantText and ConvertInvariantText connection flags to force the invariant culture to be used when converting parameter values to/from strings.</li>
<li>Add NoConnectionPool and UseConnectionPool connection flags to disable or enable connection pooling by default.</li>
<li>Modify handling of the design-time components installer to run Visual Studio <b>devenv.exe /setup</b> after installing the package. This appears to be necessary in some circumstances for Visual Studio 2013. Pursuant to [a47eff2c71].</li>
<li>Modify the native library pre-loader to support reading settings from an XML configuration file and to be capable of checking more than one directory. Persuant to [f0246d1817].</li>
<li>Support detecting when the native library pre-loader should use the CodeBase property instead of the Location property as the basis for locating the interop assembly.</li>
<li>Change the default behavior for the native library pre-loader so it first searches the executing (i.e. System.Data.SQLite) assembly directory and then the application domain directory. Pursuant to [f0246d1817]. <b>** Potentially Incompatible Change **</b></li>
</ul>
<p>
<b>1.0.90.0 - December 23, 2013</b>
</p>
<ul>
<li>Updated to [http://www.sqlite.org/releaselog/3_8_2.html|SQLite 3.8.2].</li>
<li>Add Visual Studio 2013 support to all the applicable solution/project files, their associated supporting files, and the test suite.</li>
|
> |
14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 |
<li>Add SQLiteCompileOptions and InteropCompileOptions properties to the SQLiteConnection class to return the compile-time options for the SQLite core library and interop assembly, respectively.</li>
<li>Add BindInvariantText and ConvertInvariantText connection flags to force the invariant culture to be used when converting parameter values to/from strings.</li>
<li>Add NoConnectionPool and UseConnectionPool connection flags to disable or enable connection pooling by default.</li>
<li>Modify handling of the design-time components installer to run Visual Studio <b>devenv.exe /setup</b> after installing the package. This appears to be necessary in some circumstances for Visual Studio 2013. Pursuant to [a47eff2c71].</li>
<li>Modify the native library pre-loader to support reading settings from an XML configuration file and to be capable of checking more than one directory. Persuant to [f0246d1817].</li>
<li>Support detecting when the native library pre-loader should use the CodeBase property instead of the Location property as the basis for locating the interop assembly.</li>
<li>Change the default behavior for the native library pre-loader so it first searches the executing (i.e. System.Data.SQLite) assembly directory and then the application domain directory. Pursuant to [f0246d1817]. <b>** Potentially Incompatible Change **</b></li>
<li>Include DbType.AnsiString in the list of types that need special ColumnSize handling. Fix for [0550f0326e].</li>
</ul>
<p>
<b>1.0.90.0 - December 23, 2013</b>
</p>
<ul>
<li>Updated to [http://www.sqlite.org/releaselog/3_8_2.html|SQLite 3.8.2].</li>
<li>Add Visual Studio 2013 support to all the applicable solution/project files, their associated supporting files, and the test suite.</li>
|