Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
Comment: | Honor the pre-existing flags for connections during the Open method. Fix for [964063da16]. |
---|---|
Downloads: | Tarball | ZIP archive | SQL archive |
Timelines: | family | ancestors | descendants | both | trunk |
Files: | files | file ages | folders |
SHA1: |
f7cac7934629e6622abdd1f18ef301d8 |
User & Date: | mistachkin 2015-07-14 19:29:51 |
References
2015-07-14
| ||
19:30 | • Closed ticket [964063da16]: SQLiteConnection.Flags property not properly observed plus 4 other changes artifact: 7d8fffc3dd user: mistachkin | |
Context
2015-07-14
| ||
20:08 | Improvements to the download page. check-in: d354cfb193 user: mistachkin tags: trunk | |
19:29 | Honor the pre-existing flags for connections during the Open method. Fix for [964063da16]. check-in: f7cac79346 user: mistachkin tags: trunk | |
2015-07-13
| ||
22:41 | Add tests for ticket [71bedaca19]. check-in: 1ddef23eb9 user: mistachkin tags: trunk | |
Changes
Changes to Doc/Extra/Provider/version.html.
43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 |
<div id="mainSection"> <div id="mainBody"> <h1 class="heading">Version History</h1> <p><b>1.0.98.0 - August XX, 2015 <font color="red">(release scheduled)</font></b></p> <ul> <li>Updated to <a href="https://www.sqlite.org/draft/releaselog/3_8_11.html">SQLite 3.8.11</a>.</li> <li>Implement the Substring method for LINQ using the "substr" core SQL function. <b>** Potentially Incompatible Change **</b></li> <li>Remove errant semi-colons from the SQL used by LINQ to INSERT and then SELECT rows with composite primary keys. Fix for <a href="https://system.data.sqlite.org/index.html/info/9d353b0bd8">[9d353b0bd8]</a>.</li> <li>Change the base type for the SQLiteConnectionFlags enumeration to long integer. <b>** Potentially Incompatible Change **</b></li> <li>Add extended return codes to the SQLiteErrorCode enumeration. Pursuant to <a href="https://system.data.sqlite.org/index.html/info/71bedaca19">[71bedaca19]</a>. <b>** Potentially Incompatible Change **</b></li> <li>Improve exception handling in all native callbacks implemented in the SQLiteConnection class.</li> <li>Add Progress event and ProgressOps connection string property to enable raising progress events during long-running queries.</li> <li>Add VfsName connection string property to allow a non-default VFS to be used by the SQLite core library.</li> <li>Add BusyTimeout connection string property to set the busy timeout to be used by the SQLite core library.</li> <li>Enable integration with the <a href="http://www.hwaci.com/sw/sqlite/zipvfs.html">ZipVFS</a> extension.</li> </ul> <p><b>1.0.97.0 - May 26, 2015</b></p> <ul> <li>Updated to <a href="https://www.sqlite.org/releaselog/3_8_10_2.html">SQLite 3.8.10.2</a>.</li> |
> > |
43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 |
<div id="mainSection"> <div id="mainBody"> <h1 class="heading">Version History</h1> <p><b>1.0.98.0 - August XX, 2015 <font color="red">(release scheduled)</font></b></p> <ul> <li>Updated to <a href="https://www.sqlite.org/draft/releaselog/3_8_11.html">SQLite 3.8.11</a>.</li> <li>Implement the Substring method for LINQ using the "substr" core SQL function. <b>** Potentially Incompatible Change **</b></li> <li>Honor the pre-existing flags for connections during the Open method. Fix for <a href="https://system.data.sqlite.org/index.html/info/964063da16">[964063da16]</a>. <b>** Potentially Incompatible Change **</b></li> <li>Remove errant semi-colons from the SQL used by LINQ to INSERT and then SELECT rows with composite primary keys. Fix for <a href="https://system.data.sqlite.org/index.html/info/9d353b0bd8">[9d353b0bd8]</a>.</li> <li>Change the base type for the SQLiteConnectionFlags enumeration to long integer. <b>** Potentially Incompatible Change **</b></li> <li>Add extended return codes to the SQLiteErrorCode enumeration. Pursuant to <a href="https://system.data.sqlite.org/index.html/info/71bedaca19">[71bedaca19]</a>. <b>** Potentially Incompatible Change **</b></li> <li>Improve exception handling in all native callbacks implemented in the SQLiteConnection class.</li> <li>Add Progress event and ProgressOps connection string property to enable raising progress events during long-running queries.</li> <li>Add NoDefaultFlags connection string property to prevent the default connection flags from being used. Pursuant to <a href="https://system.data.sqlite.org/index.html/info/964063da16">[964063da16]</a>.</li> <li>Add VfsName connection string property to allow a non-default VFS to be used by the SQLite core library.</li> <li>Add BusyTimeout connection string property to set the busy timeout to be used by the SQLite core library.</li> <li>Enable integration with the <a href="http://www.hwaci.com/sw/sqlite/zipvfs.html">ZipVFS</a> extension.</li> </ul> <p><b>1.0.97.0 - May 26, 2015</b></p> <ul> <li>Updated to <a href="https://www.sqlite.org/releaselog/3_8_10_2.html">SQLite 3.8.10.2</a>.</li> |
Changes to Setup/data/verify.lst.
753 754 755 756 757 758 759 760 761 762 763 764 765 766 |
Tests/tkt-8554170e09.eagle Tests/tkt-85b824b736.eagle Tests/tkt-8b7d179c3c.eagle Tests/tkt-8c3bee31c8.eagle Tests/tkt-8d928c3e88.eagle Tests/tkt-92dbf1229a.eagle Tests/tkt-94252b9059.eagle Tests/tkt-996d13cd87.eagle Tests/tkt-9ba9346f75.eagle Tests/tkt-9d353b0bd8.eagle Tests/tkt-a4d9c7ee94.eagle Tests/tkt-a7d04fb111.eagle Tests/tkt-aba4549801.eagle Tests/tkt-ac47dd230a.eagle |
> |
753 754 755 756 757 758 759 760 761 762 763 764 765 766 767 |
Tests/tkt-8554170e09.eagle
Tests/tkt-85b824b736.eagle
Tests/tkt-8b7d179c3c.eagle
Tests/tkt-8c3bee31c8.eagle
Tests/tkt-8d928c3e88.eagle
Tests/tkt-92dbf1229a.eagle
Tests/tkt-94252b9059.eagle
Tests/tkt-964063da16.eagle
Tests/tkt-996d13cd87.eagle
Tests/tkt-9ba9346f75.eagle
Tests/tkt-9d353b0bd8.eagle
Tests/tkt-a4d9c7ee94.eagle
Tests/tkt-a7d04fb111.eagle
Tests/tkt-aba4549801.eagle
Tests/tkt-ac47dd230a.eagle
|
Changes to System.Data.SQLite/SQLiteConnection.cs.
187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 ... 460 461 462 463 464 465 466 467 468 469 470 471 472 473 ... 794 795 796 797 798 799 800 801 802 803 804 805 806 807 808 .... 2231 2232 2233 2234 2235 2236 2237 2238 2239 2240 2241 2242 2243 2244 .... 2596 2597 2598 2599 2600 2601 2602 2603 2604 2605 2606 2607 2608 2609 2610 2611 |
/// <description> /// This is the default type name to use when one cannot be determined based on the column metadata /// and the configured type mappings. /// </description> /// <description>N</description> /// <description>null</description> /// </item> /// <item> /// <description>NoSharedFlags</description> /// <description> /// <b>True</b> - Do not combine the specified (or default) connection flags with the value of the /// <see cref="SharedFlags" /> property. /// <br/> /// <b>False</b> - Combine the specified (or default) connection flags with the value of the /// <see cref="SharedFlags" /> property. /// </description> /// <description>N</description> /// <description>false</description> /// </item> /// <item> /// <description>VfsName</description> ................................................................................ private const int DefaultVersion = 3; private const int DefaultPageSize = 1024; private const int DefaultMaxPageCount = 0; private const int DefaultCacheSize = 2000; private const int DefaultMaxPoolSize = 100; private const int DefaultConnectionTimeout = 30; private const int DefaultBusyTimeout = 0; private const bool DefaultNoSharedFlags = false; private const bool DefaultFailIfMissing = false; private const bool DefaultReadOnly = false; internal const bool DefaultBinaryGUID = true; private const bool DefaultUseUTF16Encoding = false; private const bool DefaultToFullPath = true; private const bool DefaultPooling = false; // TODO: Maybe promote this to static property? ................................................................................ #endif _cachedSettings = new Dictionary<string, object>( new TypeNameStringComparer()); _typeNames = new SQLiteDbTypeMap(); _parseViaFramework = parseViaFramework; _flags = SQLiteConnectionFlags.Default; _defaultDbType = null; _defaultTypeName = null; _vfsName = null; _connectionState = ConnectionState.Closed; _connectionString = null; if (connectionString != null) ................................................................................ static internal string FindKey(SortedList<string, string> items, string key, string defValue) { string ret; if (String.IsNullOrEmpty(key)) return defValue; if (items.TryGetValue(key, out ret)) return ret; if (items.TryGetValue(key.Replace(" ", String.Empty), out ret)) return ret; return defValue; } /// <summary> /// Attempts to convert the string value to an enumerated value of the specified type. /// </summary> ................................................................................ OnChanged(this, new ConnectionEventArgs( SQLiteConnectionEventType.ConnectionString, null, null, null, null, null, _connectionString, new object[] { opts })); object enumValue; enumValue = TryParseEnum(typeof(SQLiteConnectionFlags), FindKey(opts, "Flags", DefaultFlags.ToString()), true); _flags = (enumValue is SQLiteConnectionFlags) ? (SQLiteConnectionFlags)enumValue : DefaultFlags; bool noSharedFlags = SQLiteConvert.ToBoolean(FindKey(opts, "NoSharedFlags", DefaultNoSharedFlags.ToString())); if (!noSharedFlags) { lock (_syncRoot) { _flags |= _sharedFlags; } } enumValue = TryParseEnum(typeof(DbType), FindKey(opts, "DefaultDbType", null), true); _defaultDbType = (enumValue is DbType) ? (DbType)enumValue : (DbType?)null; |
> > > > > > > > > > > > | | > | > | > > > > > > > > > > > > > > > | > > > |
187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 ... 472 473 474 475 476 477 478 479 480 481 482 483 484 485 486 ... 807 808 809 810 811 812 813 814 815 816 817 818 819 820 821 .... 2244 2245 2246 2247 2248 2249 2250 2251 2252 2253 2254 2255 2256 2257 2258 .... 2610 2611 2612 2613 2614 2615 2616 2617 2618 2619 2620 2621 2622 2623 2624 2625 2626 2627 2628 2629 2630 2631 2632 2633 2634 2635 2636 2637 2638 2639 2640 2641 2642 2643 |
/// <description> /// This is the default type name to use when one cannot be determined based on the column metadata /// and the configured type mappings. /// </description> /// <description>N</description> /// <description>null</description> /// </item> /// <item> /// <description>NoDefaultFlags</description> /// <description> /// <b>True</b> - Do not combine the specified (or existing) connection flags with the value of the /// <see cref="DefaultFlags" /> property. /// <br/> /// <b>False</b> - Combine the specified (or existing) connection flags with the value of the /// <see cref="DefaultFlags" /> property. /// </description> /// <description>N</description> /// <description>false</description> /// </item> /// <item> /// <description>NoSharedFlags</description> /// <description> /// <b>True</b> - Do not combine the specified (or existing) connection flags with the value of the /// <see cref="SharedFlags" /> property. /// <br/> /// <b>False</b> - Combine the specified (or existing) connection flags with the value of the /// <see cref="SharedFlags" /> property. /// </description> /// <description>N</description> /// <description>false</description> /// </item> /// <item> /// <description>VfsName</description> ................................................................................ private const int DefaultVersion = 3; private const int DefaultPageSize = 1024; private const int DefaultMaxPageCount = 0; private const int DefaultCacheSize = 2000; private const int DefaultMaxPoolSize = 100; private const int DefaultConnectionTimeout = 30; private const int DefaultBusyTimeout = 0; private const bool DefaultNoDefaultFlags = false; private const bool DefaultNoSharedFlags = false; private const bool DefaultFailIfMissing = false; private const bool DefaultReadOnly = false; internal const bool DefaultBinaryGUID = true; private const bool DefaultUseUTF16Encoding = false; private const bool DefaultToFullPath = true; private const bool DefaultPooling = false; // TODO: Maybe promote this to static property? ................................................................................ #endif _cachedSettings = new Dictionary<string, object>( new TypeNameStringComparer()); _typeNames = new SQLiteDbTypeMap(); _parseViaFramework = parseViaFramework; _flags = SQLiteConnectionFlags.None; _defaultDbType = null; _defaultTypeName = null; _vfsName = null; _connectionState = ConnectionState.Closed; _connectionString = null; if (connectionString != null) ................................................................................ static internal string FindKey(SortedList<string, string> items, string key, string defValue) { string ret; if (String.IsNullOrEmpty(key)) return defValue; if (items.TryGetValue(key, out ret)) return ret; if (items.TryGetValue(key.Replace(" ", String.Empty), out ret)) return ret; if (items.TryGetValue(key.Replace(" ", "_"), out ret)) return ret; return defValue; } /// <summary> /// Attempts to convert the string value to an enumerated value of the specified type. /// </summary> ................................................................................ OnChanged(this, new ConnectionEventArgs( SQLiteConnectionEventType.ConnectionString, null, null, null, null, null, _connectionString, new object[] { opts })); object enumValue; enumValue = TryParseEnum(typeof(SQLiteConnectionFlags), FindKey(opts, "Flags", null), true); // // BUGFIX: Always preserve the pre-existing instance flags. This is OK // because when the connection object is initially created, they // are "None"; therefore, OR-ing the connection string property // flags with the instance flags would produce exactly the same // result. If the "Flags" connection string property is absent, // OR-ing the the instance flags with the static DefaultFlags is // done instead. This is OK for the same reason as before: when // the connection object is initially created, they are "None" // by default. If they are different now, they must have been // manually set by the application. // bool noDefaultFlags = SQLiteConvert.ToBoolean(FindKey(opts, "NoDefaultFlags", DefaultNoDefaultFlags.ToString())); if (enumValue is SQLiteConnectionFlags) _flags |= (SQLiteConnectionFlags)enumValue; else if (!noDefaultFlags) _flags |= DefaultFlags; bool noSharedFlags = SQLiteConvert.ToBoolean(FindKey(opts, "NoSharedFlags", DefaultNoSharedFlags.ToString())); if (!noSharedFlags) { lock (_syncRoot) { _flags |= _sharedFlags; } } enumValue = TryParseEnum(typeof(DbType), FindKey(opts, "DefaultDbType", null), true); _defaultDbType = (enumValue is DbType) ? (DbType)enumValue : (DbType?)null; |
Changes to System.Data.SQLite/SQLiteConnectionStringBuilder.cs.
846 847 848 849 850 851 852 853 854 855 856 857 858 859 |
return SQLiteConvert.ToBoolean(value); } set { this["tofullpath"] = value; } } /// <summary> /// If enabled, skip using the configured shared connection flags. /// </summary> [DisplayName("No Shared Flags")] [Browsable(true)] [DefaultValue(false)] |
> > > > > > > > > > > > > > > > > > > > |
846 847 848 849 850 851 852 853 854 855 856 857 858 859 860 861 862 863 864 865 866 867 868 869 870 871 872 873 874 875 876 877 878 879 |
return SQLiteConvert.ToBoolean(value); } set { this["tofullpath"] = value; } } /// <summary> /// If enabled, skip using the configured default connection flags. /// </summary> [DisplayName("No Default Flags")] [Browsable(true)] [DefaultValue(false)] public bool NoDefaultFlags { get { object value; TryGetValue("nodefaultflags", out value); return SQLiteConvert.ToBoolean(value); } set { this["nodefaultflags"] = value; } } /// <summary> /// If enabled, skip using the configured shared connection flags. /// </summary> [DisplayName("No Shared Flags")] [Browsable(true)] [DefaultValue(false)] |
Changes to Tests/basic.eagle.
1050
1051
1052
1053
1054
1055
1056
1057
1058
1059
1060
1061
1062
1063
1064
1065
1066
1067
1068
1069
1070
1071
1072
1073
1074
1075
1076
1077
1078
1079
1080
1081
1082
1083
1084
....
1106
1107
1108
1109
1110
1111
1112
1113
1114
1115
1116
1117
1118
1119
1120
|
BinaryGUID "Data Source" Uri FullUri "Default Timeout" \ Enlist FailIfMissing "Legacy Format" "Read Only" \ Password "Page Size" "Max Page Count" "Cache Size" \ DateTimeFormat DateTimeKind DateTimeFormatString \ BaseSchemaName "Journal Mode" "Default IsolationLevel" \ "Foreign Keys" Flags SetDefaults ToFullPath HexPassword \ DefaultDbType DefaultTypeName NoSharedFlags PrepareRetries \ ZipVfsVersion VfsName BusyTimeout ProgressOps] set values [list null 3 Normal True False \ True test.db test.db file:test.db 60 \ False True False True \ secret 4096 1024 8192 \ UnixEpoch Utc yyyy-MM-dd sqlite_schema \ Memory Serializable False \ Default False False 736563726574 String \ TEXT True 20 v2 test 1000 2000] set propertyNames [list null Version SyncMode UseUTF16Encoding Pooling \ BinaryGUID DataSource Uri FullUri DefaultTimeout \ Enlist FailIfMissing LegacyFormat ReadOnly \ Password PageSize MaxPageCount CacheSize \ DateTimeFormat DateTimeKind DateTimeFormatString \ BaseSchemaName JournalMode DefaultIsolationLevel \ ForeignKeys Flags SetDefaults ToFullPath \ HexPassword DefaultDbType DefaultTypeName \ NoSharedFlags PrepareRetries ZipVfsVersion \ VfsName BusyTimeout ProgressOps] foreach key $keys value $values propertyName $propertyNames { set code [catch { object invoke _Dynamic${id}.Test${id} GetConnectionString \ $key $value $propertyName } result] ................................................................................ \{Serializable, Default IsolationLevel=Serializable\} 0 \{False, Foreign\ Keys=False\} 0 \{(?:Default|LogCallbackException),\ Flags=(?:Default|LogCallbackException)\} 0 \{False, SetDefaults=False\} 0\ \{False, ToFullPath=False\} 0 {736563726574, HexPassword=736563726574} 0\ \{String, DefaultDbType=String\} 0 \{TEXT, DefaultTypeName=TEXT\} 0 \{True,\ NoSharedFlags=True\} 0 \{20, PrepareRetries=20\} 0 \{v2, ZipVfsVersion=v2\} 0\ \{test, VfsName=test\} 0 \{1000, BusyTimeout=1000\} 0 \{2000,\ ProgressOps=2000\}$}} ############################################################################### runTest {test data-1.18 {SQLiteConvert ToDateTime (Julian Day)} -body { set dateTime [object invoke -create System.Data.SQLite.SQLiteConvert \ ToDateTime 2455928.0 Utc] |
|
>
|
|
|
|
1050
1051
1052
1053
1054
1055
1056
1057
1058
1059
1060
1061
1062
1063
1064
1065
1066
1067
1068
1069
1070
1071
1072
1073
1074
1075
1076
1077
1078
1079
1080
1081
1082
1083
1084
1085
....
1107
1108
1109
1110
1111
1112
1113
1114
1115
1116
1117
1118
1119
1120
1121
|
BinaryGUID "Data Source" Uri FullUri "Default Timeout" \ Enlist FailIfMissing "Legacy Format" "Read Only" \ Password "Page Size" "Max Page Count" "Cache Size" \ DateTimeFormat DateTimeKind DateTimeFormatString \ BaseSchemaName "Journal Mode" "Default IsolationLevel" \ "Foreign Keys" Flags SetDefaults ToFullPath HexPassword \ DefaultDbType DefaultTypeName NoSharedFlags PrepareRetries \ ZipVfsVersion VfsName BusyTimeout ProgressOps \ NoDefaultFlags] set values [list null 3 Normal True False \ True test.db test.db file:test.db 60 \ False True False True \ secret 4096 1024 8192 \ UnixEpoch Utc yyyy-MM-dd sqlite_schema \ Memory Serializable False \ Default False False 736563726574 String \ TEXT True 20 v2 test 1000 2000 True] set propertyNames [list null Version SyncMode UseUTF16Encoding Pooling \ BinaryGUID DataSource Uri FullUri DefaultTimeout \ Enlist FailIfMissing LegacyFormat ReadOnly \ Password PageSize MaxPageCount CacheSize \ DateTimeFormat DateTimeKind DateTimeFormatString \ BaseSchemaName JournalMode DefaultIsolationLevel \ ForeignKeys Flags SetDefaults ToFullPath \ HexPassword DefaultDbType DefaultTypeName \ NoSharedFlags PrepareRetries ZipVfsVersion \ VfsName BusyTimeout ProgressOps NoDefaultFlags] foreach key $keys value $values propertyName $propertyNames { set code [catch { object invoke _Dynamic${id}.Test${id} GetConnectionString \ $key $value $propertyName } result] ................................................................................ \{Serializable, Default IsolationLevel=Serializable\} 0 \{False, Foreign\ Keys=False\} 0 \{(?:Default|LogCallbackException),\ Flags=(?:Default|LogCallbackException)\} 0 \{False, SetDefaults=False\} 0\ \{False, ToFullPath=False\} 0 {736563726574, HexPassword=736563726574} 0\ \{String, DefaultDbType=String\} 0 \{TEXT, DefaultTypeName=TEXT\} 0 \{True,\ NoSharedFlags=True\} 0 \{20, PrepareRetries=20\} 0 \{v2, ZipVfsVersion=v2\} 0\ \{test, VfsName=test\} 0 \{1000, BusyTimeout=1000\} 0 \{2000,\ ProgressOps=2000\} 0 \{True, NoDefaultFlags=True\}$}} ############################################################################### runTest {test data-1.18 {SQLiteConvert ToDateTime (Julian Day)} -body { set dateTime [object invoke -create System.Data.SQLite.SQLiteConvert \ ToDateTime 2455928.0 Utc] |
Added Tests/tkt-964063da16.eagle.
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 |
############################################################################### # # tkt-964063da16.eagle -- # # Written by Joe Mistachkin. # Released to the public domain, use at your own risk! # ############################################################################### package require Eagle package require Eagle.Library package require Eagle.Test runTestPrologue ############################################################################### package require System.Data.SQLite.Test runSQLiteTestPrologue ############################################################################### runTest {test tkt-964063da16-1.1 {pre-existing connection flags} -body { set connection [object create -alias \ System.Data.SQLite.SQLiteConnection \ "Data Source=:memory:;NoDefaultFlags=False;"] $connection Open $connection Flags } -cleanup { unset -nocomplain connection } -constraints {eagle command.object SQLite System.Data.SQLite} -result \ {Default}} ############################################################################### runTest {test tkt-964063da16-1.2 {pre-existing connection flags} -body { set connection [object create -alias \ System.Data.SQLite.SQLiteConnection \ "Data Source=:memory:;NoDefaultFlags=True;"] $connection Open $connection Flags } -cleanup { unset -nocomplain connection } -constraints {eagle command.object SQLite System.Data.SQLite} -result \ {None}} ############################################################################### runTest {test tkt-964063da16-1.3 {pre-existing connection flags} -body { set connection [object create -alias \ System.Data.SQLite.SQLiteConnection \ "Data Source=:memory:;NoDefaultFlags=False;"] $connection Flags NoExtensionFunctions; $connection Open $connection Flags } -cleanup { unset -nocomplain connection } -constraints {eagle command.object SQLite System.Data.SQLite} -result \ {NoExtensionFunctions, Default}} ############################################################################### runTest {test tkt-964063da16-1.4 {pre-existing connection flags} -body { set connection [object create -alias \ System.Data.SQLite.SQLiteConnection \ "Data Source=:memory:;NoDefaultFlags=True;"] $connection Flags NoExtensionFunctions; $connection Open $connection Flags } -cleanup { unset -nocomplain connection } -constraints {eagle command.object SQLite System.Data.SQLite} -result \ {NoExtensionFunctions}} ############################################################################### runTest {test tkt-964063da16-1.5 {pre-existing connection flags} -body { set connection [object create -alias \ System.Data.SQLite.SQLiteConnection \ "Data Source=:memory:;NoDefaultFlags=False;Flags=GetAllAsText;"] $connection Open $connection Flags } -cleanup { unset -nocomplain connection } -constraints {eagle command.object SQLite System.Data.SQLite} -result \ {GetAllAsText}} ############################################################################### runTest {test tkt-964063da16-1.6 {pre-existing connection flags} -body { set connection [object create -alias \ System.Data.SQLite.SQLiteConnection \ "Data Source=:memory:;NoDefaultFlags=True;Flags=GetAllAsText;"] $connection Open $connection Flags } -cleanup { unset -nocomplain connection } -constraints {eagle command.object SQLite System.Data.SQLite} -result \ {GetAllAsText}} ############################################################################### runTest {test tkt-964063da16-1.7 {pre-existing connection flags} -body { set connection [object create -alias \ System.Data.SQLite.SQLiteConnection \ "Data Source=:memory:;NoDefaultFlags=False;Flags=GetAllAsText;"] $connection Flags NoExtensionFunctions; $connection Open $connection Flags } -cleanup { unset -nocomplain connection } -constraints {eagle command.object SQLite System.Data.SQLite} -result \ {NoExtensionFunctions, GetAllAsText}} ############################################################################### runTest {test tkt-964063da16-1.8 {pre-existing connection flags} -body { set connection [object create -alias \ System.Data.SQLite.SQLiteConnection \ "Data Source=:memory:;NoDefaultFlags=True;Flags=GetAllAsText;"] $connection Flags NoExtensionFunctions; $connection Open $connection Flags } -cleanup { unset -nocomplain connection } -constraints {eagle command.object SQLite System.Data.SQLite} -result \ {NoExtensionFunctions, GetAllAsText}} ############################################################################### runSQLiteTestEpilogue runTestEpilogue |
Changes to readme.htm.
210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 |
<p> <b>1.0.98.0 - August XX, 2015 <font color="red">(release scheduled)</font></b> </p> <ul> <li>Updated to <a href="https://www.sqlite.org/draft/releaselog/3_8_11.html">SQLite 3.8.11</a>.</li> <li>Implement the Substring method for LINQ using the "substr" core SQL function. <b>** Potentially Incompatible Change **</b></li> <li>Remove errant semi-colons from the SQL used by LINQ to INSERT and then SELECT rows with composite primary keys. Fix for [9d353b0bd8].</li> <li>Change the base type for the SQLiteConnectionFlags enumeration to long integer. <b>** Potentially Incompatible Change **</b></li> <li>Add extended return codes to the SQLiteErrorCode enumeration. Pursuant to [71bedaca19]. <b>** Potentially Incompatible Change **</b></li> <li>Improve exception handling in all native callbacks implemented in the SQLiteConnection class.</li> <li>Add Progress event and ProgressOps connection string property to enable raising progress events during long-running queries.</li> <li>Add VfsName connection string property to allow a non-default VFS to be used by the SQLite core library.</li> <li>Add BusyTimeout connection string property to set the busy timeout to be used by the SQLite core library.</li> <li>Enable integration with the <a href="http://www.hwaci.com/sw/sqlite/zipvfs.html">ZipVFS</a> extension.</li> </ul> <p> <b>1.0.97.0 - May 26, 2015</b> </p> |
> > |
210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 |
<p> <b>1.0.98.0 - August XX, 2015 <font color="red">(release scheduled)</font></b> </p> <ul> <li>Updated to <a href="https://www.sqlite.org/draft/releaselog/3_8_11.html">SQLite 3.8.11</a>.</li> <li>Implement the Substring method for LINQ using the "substr" core SQL function. <b>** Potentially Incompatible Change **</b></li> <li>Honor the pre-existing flags for connections during the Open method. Fix for [964063da16]. <b>** Potentially Incompatible Change **</b></li> <li>Remove errant semi-colons from the SQL used by LINQ to INSERT and then SELECT rows with composite primary keys. Fix for [9d353b0bd8].</li> <li>Change the base type for the SQLiteConnectionFlags enumeration to long integer. <b>** Potentially Incompatible Change **</b></li> <li>Add extended return codes to the SQLiteErrorCode enumeration. Pursuant to [71bedaca19]. <b>** Potentially Incompatible Change **</b></li> <li>Improve exception handling in all native callbacks implemented in the SQLiteConnection class.</li> <li>Add Progress event and ProgressOps connection string property to enable raising progress events during long-running queries.</li> <li>Add NoDefaultFlags connection string property to prevent the default connection flags from being used. Pursuant to [964063da16].</li> <li>Add VfsName connection string property to allow a non-default VFS to be used by the SQLite core library.</li> <li>Add BusyTimeout connection string property to set the busy timeout to be used by the SQLite core library.</li> <li>Enable integration with the <a href="http://www.hwaci.com/sw/sqlite/zipvfs.html">ZipVFS</a> extension.</li> </ul> <p> <b>1.0.97.0 - May 26, 2015</b> </p> |
Changes to www/news.wiki.
4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 |
<p> <b>1.0.98.0 - August XX, 2015 <font color="red">(release scheduled)</font></b> </p> <ul> <li>Updated to [https://www.sqlite.org/draft/releaselog/3_8_11.html|SQLite 3.8.11].</li> <li>Implement the Substring method for LINQ using the "substr" core SQL function. <b>** Potentially Incompatible Change **</b></li> <li>Remove errant semi-colons from the SQL used by LINQ to INSERT and then SELECT rows with composite primary keys. Fix for [9d353b0bd8].</li> <li>Change the base type for the SQLiteConnectionFlags enumeration to long integer. <b>** Potentially Incompatible Change **</b></li> <li>Add extended return codes to the SQLiteErrorCode enumeration. Pursuant to [71bedaca19]. <b>** Potentially Incompatible Change **</b></li> <li>Improve exception handling in all native callbacks implemented in the SQLiteConnection class.</li> <li>Add Progress event and ProgressOps connection string property to enable raising progress events during long-running queries.</li> <li>Add VfsName connection string property to allow a non-default VFS to be used by the SQLite core library.</li> <li>Add BusyTimeout connection string property to set the busy timeout to be used by the SQLite core library.</li> <li>Enable integration with the [http://www.hwaci.com/sw/sqlite/zipvfs.html|ZipVFS] extension.</li> </ul> <p> <b>1.0.97.0 - May 26, 2015</b> </p> |
> > |
4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 |
<p> <b>1.0.98.0 - August XX, 2015 <font color="red">(release scheduled)</font></b> </p> <ul> <li>Updated to [https://www.sqlite.org/draft/releaselog/3_8_11.html|SQLite 3.8.11].</li> <li>Implement the Substring method for LINQ using the "substr" core SQL function. <b>** Potentially Incompatible Change **</b></li> <li>Honor the pre-existing flags for connections during the Open method. Fix for [964063da16]. <b>** Potentially Incompatible Change **</b></li> <li>Remove errant semi-colons from the SQL used by LINQ to INSERT and then SELECT rows with composite primary keys. Fix for [9d353b0bd8].</li> <li>Change the base type for the SQLiteConnectionFlags enumeration to long integer. <b>** Potentially Incompatible Change **</b></li> <li>Add extended return codes to the SQLiteErrorCode enumeration. Pursuant to [71bedaca19]. <b>** Potentially Incompatible Change **</b></li> <li>Improve exception handling in all native callbacks implemented in the SQLiteConnection class.</li> <li>Add Progress event and ProgressOps connection string property to enable raising progress events during long-running queries.</li> <li>Add NoDefaultFlags connection string property to prevent the default connection flags from being used. Pursuant to [964063da16].</li> <li>Add VfsName connection string property to allow a non-default VFS to be used by the SQLite core library.</li> <li>Add BusyTimeout connection string property to set the busy timeout to be used by the SQLite core library.</li> <li>Enable integration with the [http://www.hwaci.com/sw/sqlite/zipvfs.html|ZipVFS] extension.</li> </ul> <p> <b>1.0.97.0 - May 26, 2015</b> </p> |