Index: SQLite.Interop/SQLite.Interop.rc
==================================================================
--- SQLite.Interop/SQLite.Interop.rc
+++ SQLite.Interop/SQLite.Interop.rc
@@ -51,11 +51,11 @@
//
// Version
//
VS_VERSION_INFO VERSIONINFO
- FILEVERSION 1,0,34,0
+ FILEVERSION 1,0,35,0
PRODUCTVERSION 1,0,0,0
FILEFLAGSMASK 0x17L
#ifdef _DEBUG
FILEFLAGS 0x1L
#else
@@ -69,11 +69,11 @@
BEGIN
BLOCK "040904b0"
BEGIN
VALUE "Comments", "http://sqlite.phxsoftware.com"
VALUE "FileDescription", "System.Data.SQLite Interop Library"
- VALUE "FileVersion", "1.0.34.0"
+ VALUE "FileVersion", "1.0.35.0"
VALUE "InternalName", "SQLite.Interop.DLL"
VALUE "LegalCopyright", "Released to the public domain"
VALUE "OriginalFilename", "SQLite3.DLL 3.3.7"
VALUE "ProductName", "System.Data.SQLite"
VALUE "ProductVersion", "1.0"
Index: SQLite.Interop/merge.h
==================================================================
--- SQLite.Interop/merge.h
+++ SQLite.Interop/merge.h
@@ -3,11 +3,11 @@
#include
#pragma data_seg(".clr")
#pragma comment(linker, "/SECTION:.clr,ER")
- char __ph[117132] = {0}; // The number of bytes to reserve
+ char __ph[118024] = {0}; // The number of bytes to reserve
#pragma data_seg()
typedef BOOL (WINAPI *DLLMAIN)(HANDLE, DWORD, LPVOID);
typedef struct EXTRA_STUFF
{
Index: SQLite.Interop/merge_full.h
==================================================================
--- SQLite.Interop/merge_full.h
+++ SQLite.Interop/merge_full.h
@@ -3,11 +3,11 @@
#include
#pragma data_seg(".clr")
#pragma comment(linker, "/SECTION:.clr,ER")
- char __ph[126168] = {0}; // The number of bytes to reserve
+ char __ph[127052] = {0}; // The number of bytes to reserve
#pragma data_seg()
typedef BOOL (WINAPI *DLLMAIN)(HANDLE, DWORD, LPVOID);
typedef struct EXTRA_STUFF
{
Index: System.Data.SQLite/AssemblyInfo.cs
==================================================================
--- System.Data.SQLite/AssemblyInfo.cs
+++ System.Data.SQLite/AssemblyInfo.cs
@@ -46,9 +46,9 @@
// Build Number
// Revision
//
// You can specify all the values or you can default the Revision and Build Numbers
// by using the '*' as shown below:
-[assembly: AssemblyVersion("1.0.34.0")]
+[assembly: AssemblyVersion("1.0.35.0")]
#if !PLATFORM_COMPACTFRAMEWORK
-[assembly: AssemblyFileVersion("1.0.34.0")]
+[assembly: AssemblyFileVersion("1.0.35.0")]
#endif
Index: System.Data.SQLite/SQLiteCommand.cs
==================================================================
--- System.Data.SQLite/SQLiteCommand.cs
+++ System.Data.SQLite/SQLiteCommand.cs
@@ -181,11 +181,11 @@
///
/// Builds an array of prepared statements for each complete SQL statement in the command text
///
internal SQLiteStatement BuildNextCommand()
{
- SQLiteStatement stmt;
+ SQLiteStatement stmt = null;
try
{
if (_statementList == null)
_remainingText = _commandText;
@@ -196,18 +196,26 @@
stmt._command = this;
if (_statementList == null)
_statementList = new List();
_statementList.Add(stmt);
+
_parameterCollection.MapParameters(stmt);
stmt.BindParameters();
}
return stmt;
}
catch (Exception)
{
- ClearCommands();
+ if (stmt != null)
+ {
+ if (_statementList.Contains(stmt))
+ _statementList.Remove(stmt);
+
+ stmt.Dispose();
+ }
+
throw;
}
}
internal SQLiteStatement GetStatement(int index)
Index: bin/CompactFramework/System.Data.SQLite.DLL
==================================================================
--- bin/CompactFramework/System.Data.SQLite.DLL
+++ bin/CompactFramework/System.Data.SQLite.DLL
cannot compute difference between binary files
Index: bin/CompactFramework/testce.exe
==================================================================
--- bin/CompactFramework/testce.exe
+++ bin/CompactFramework/testce.exe
cannot compute difference between binary files
Index: bin/Designer/SQLite.Designer.dll
==================================================================
--- bin/Designer/SQLite.Designer.dll
+++ bin/Designer/SQLite.Designer.dll
cannot compute difference between binary files
Index: bin/Designer/install.exe
==================================================================
--- bin/Designer/install.exe
+++ bin/Designer/install.exe
cannot compute difference between binary files
Index: bin/System.Data.SQLite.XML
==================================================================
--- bin/System.Data.SQLite.XML
+++ bin/System.Data.SQLite.XML
@@ -2215,10 +2215,16 @@
DateTimeFormat
Ticks - Use DateTime.Ticks
ISO8601 - Use ISO8601 DateTime format
N
ISO8601
+ -
+ BinaryGUID
+ True - Store GUID columns in binary form
False - Store GUID columns as text
+ N
+ True
+
-
Cache Size
{size in bytes}
N
2000
@@ -2676,10 +2682,16 @@
DateTimeFormat
Ticks - Use DateTime.Ticks
ISO8601 - Use ISO8601 DateTime format
N
ISO8601
+ -
+ BinaryGUID
+ Yes/On/1 - Store GUID columns in binary form
No/Off/0 - Store GUID columns as text
+ N
+ On
+
-
Cache Size
{size in bytes}
N
2000
Index: bin/System.Data.SQLite.dll
==================================================================
--- bin/System.Data.SQLite.dll
+++ bin/System.Data.SQLite.dll
cannot compute difference between binary files
Index: bin/itanium/System.Data.SQLite.DLL
==================================================================
--- bin/itanium/System.Data.SQLite.DLL
+++ bin/itanium/System.Data.SQLite.DLL
cannot compute difference between binary files
Index: bin/test.exe
==================================================================
--- bin/test.exe
+++ bin/test.exe
cannot compute difference between binary files
Index: bin/x64/System.Data.SQLite.DLL
==================================================================
--- bin/x64/System.Data.SQLite.DLL
+++ bin/x64/System.Data.SQLite.DLL
cannot compute difference between binary files
Index: readme.htm
==================================================================
--- readme.htm
+++ readme.htm
@@ -3,14 +3,15 @@
ADO.NET 2.0 SQLite Data Provider
- Version 1.0.34.0 September 4, 2006
+ Version 1.0.35.0 September 10, 2006
Using SQLite 3.3.7
Written by Robert Simpson (robert@blackcastlesoft.com)
Released to the public domain, use at your own risk!
+ Official provider website: http://sqlite.phxsoftware.com
The latest version can be downloaded
here
@@ -117,10 +118,22 @@
just one minor modification is made to pager.c, that modification is made automatically by the fixsource.vbs file
when the VS2005 solution is compiled.
Version History
+ 1.0.35.0 - September 10, 2006
+
+ - Fixed an infinite loop bug in SQLiteCommand caused when multiple semi-colon separated
+ statements in a single command are executed via datareader and one of the statements
+ contains a syntax error preventing it from being prepared.
- Added the TYPES preparser keyword to be placed before a SELECT statement to
+ aid the wrapper in converting expressions in a subsequent select clause into more
+ robust types. Documentation yet to be integrated, but available on the forums.
+ - Added a new connectionstring parameter "BinaryGUID=true/false" (default is "true").
+ When true, guid types are stored in the database as binary blobs to save space.
+ Binary has been the default format since 1.0.32.0 but this parameter eases backward
+ compatibility.
+
1.0.34.0 - September 4, 2006
- Fixed a bug in SQLiteParameterCollection.RemoveAt(namedparam)
- Fixed a bug in SQLiteDataReader introduced in 1.0.30 that broke DateTimes using the Ticks option in the connection string.
- Fixed a bug in the recent changes to guid behavior wherein using a datareader's
Index: tools/setup/sqlite_setup.vdproj
==================================================================
--- tools/setup/sqlite_setup.vdproj
+++ tools/setup/sqlite_setup.vdproj
@@ -569,11 +569,11 @@
}
"{9F6F8455-1EF1-4B85-886A-4223BCC8E7F7}:_20F33E95A6904A798F8E0CC6138010F1"
{
"AssemblyRegister" = "3:1"
"AssemblyIsInGAC" = "11:FALSE"
- "AssemblyAsmDisplayName" = "8:System.Data.SQLite, Version=1.0.34.0, Culture=neutral, PublicKeyToken=db937bc2d44ff139, processorArchitecture=x86"
+ "AssemblyAsmDisplayName" = "8:System.Data.SQLite, Version=1.0.35.0, Culture=neutral, PublicKeyToken=db937bc2d44ff139, processorArchitecture=x86"
"ScatterAssemblies"
{
"_20F33E95A6904A798F8E0CC6138010F1"
{
"Name" = "8:System.Data.SQLite.DLL"
@@ -764,11 +764,11 @@
}
"{9F6F8455-1EF1-4B85-886A-4223BCC8E7F7}:_40DFF08BA903482D807E715A041CA8B1"
{
"AssemblyRegister" = "3:1"
"AssemblyIsInGAC" = "11:FALSE"
- "AssemblyAsmDisplayName" = "8:install, Version=1.0.0.20106, Culture=neutral, processorArchitecture=x86"
+ "AssemblyAsmDisplayName" = "8:install, Version=1.0.0.22237, Culture=neutral, processorArchitecture=x86"
"ScatterAssemblies"
{
"_40DFF08BA903482D807E715A041CA8B1"
{
"Name" = "8:install.exe"
@@ -928,11 +928,11 @@
}
"{9F6F8455-1EF1-4B85-886A-4223BCC8E7F7}:_A18DBDB7776215EAD9A52C96F8CA1E91"
{
"AssemblyRegister" = "3:1"
"AssemblyIsInGAC" = "11:FALSE"
- "AssemblyAsmDisplayName" = "8:System.Data.SQLite, Version=1.0.34.0, Culture=neutral, PublicKeyToken=1fdb50b1b62b4c84, processorArchitecture=x86"
+ "AssemblyAsmDisplayName" = "8:System.Data.SQLite, Version=1.0.35.0, Culture=neutral, PublicKeyToken=1fdb50b1b62b4c84, processorArchitecture=x86"
"ScatterAssemblies"
{
"_A18DBDB7776215EAD9A52C96F8CA1E91"
{
"Name" = "8:System.Data.SQLite.DLL"
@@ -1174,11 +1174,11 @@
}
"{9F6F8455-1EF1-4B85-886A-4223BCC8E7F7}:_DAEF610AAD7F4FCAB978C1A47E2DA166"
{
"AssemblyRegister" = "3:1"
"AssemblyIsInGAC" = "11:FALSE"
- "AssemblyAsmDisplayName" = "8:System.Data.SQLite, Version=1.0.34.0, Culture=neutral, PublicKeyToken=1fdb50b1b62b4c84, processorArchitecture=x86"
+ "AssemblyAsmDisplayName" = "8:System.Data.SQLite, Version=1.0.35.0, Culture=neutral, PublicKeyToken=1fdb50b1b62b4c84, processorArchitecture=x86"
"ScatterAssemblies"
{
"_DAEF610AAD7F4FCAB978C1A47E2DA166"
{
"Name" = "8:System.Data.SQLite.DLL"
@@ -1236,11 +1236,11 @@
}
"{9F6F8455-1EF1-4B85-886A-4223BCC8E7F7}:_F320FBAE871DA320178BEEA242900CC7"
{
"AssemblyRegister" = "3:1"
"AssemblyIsInGAC" = "11:FALSE"
- "AssemblyAsmDisplayName" = "8:System.Data.SQLite, Version=1.0.34.0, Culture=neutral, PublicKeyToken=db937bc2d44ff139, processorArchitecture=x86"
+ "AssemblyAsmDisplayName" = "8:System.Data.SQLite, Version=1.0.35.0, Culture=neutral, PublicKeyToken=db937bc2d44ff139, processorArchitecture=x86"
"ScatterAssemblies"
{
"_F320FBAE871DA320178BEEA242900CC7"
{
"Name" = "8:System.Data.SQLite.DLL"
@@ -1395,18 +1395,18 @@
}
"Product"
{
"Name" = "8:Microsoft Visual Studio"
"ProductName" = "8:SQLite ADO.NET 2.0 Provider"
- "ProductCode" = "8:{7266FD0D-13B9-4070-99CC-0B208E89F907}"
- "PackageCode" = "8:{8769703C-F419-4C3C-9379-F99A312541B1}"
+ "ProductCode" = "8:{85ED2C8A-EFF0-4458-A12E-2B2E49C6F29D}"
+ "PackageCode" = "8:{5CFE443E-FD12-4F01-90DC-5D729A69FEF6}"
"UpgradeCode" = "8:{78329A82-AFB1-453B-AF00-D46AC911DA89}"
"RestartWWWService" = "11:FALSE"
"RemovePreviousVersions" = "11:TRUE"
"DetectNewerInstalledVersion" = "11:TRUE"
"InstallAllUsers" = "11:TRUE"
- "ProductVersion" = "8:1.34.1"
+ "ProductVersion" = "8:1.35.0"
"Manufacturer" = "8:Phoenix Software Solutions, LLC"
"ARPHELPTELEPHONE" = "8:"
"ARPHELPLINK" = "8:http://sqlite.phxsoftware.com"
"Title" = "8:SQLite ADO.NET 2.0 Provider"
"Subject" = "8:"