vijirams / csharp-sqlite Goto Github PK
View Code? Open in Web Editor NEWAutomatically exported from code.google.com/p/csharp-sqlite
License: Other
Automatically exported from code.google.com/p/csharp-sqlite
License: Other
================================================================================================= $Header$ ================================================================================================= Project Descriptions -- See the Wiki Projects for details Please read HowToCompile for instruction on settings and compiler options
memsubsys2-1.1 requires implementation of "sqlite3_malloc"
Original issue reported on code.google.com by [email protected]
on 5 Aug 2009 at 1:41
types3-1.6...Expected: [bytearray text] Got: [string text]
types3-2.1...Expected: [bytearray] Got: [string]
types3-2.5...Expected: [] Got: [double]
types3-2.6...Expected: [] Got: [string]
Original issue reported on code.google.com by [email protected]
on 5 Aug 2009 at 1:42
What steps will reproduce the problem?
1. Add Compiler flag SQLITE_OMIT_MEMORYDB to textfixture
2. in ^Testscripts add the lines
do_test SIMPLE_CREATE_TABLE {
execsql {
CREATE TABLE T1 (C1);
}
} {}
start in debugger
What is the expected output? What do you see instead?
ok
Debug.Assert fails in sqlite3PagerCommitPhaseTwo
pPager.state should be PAGER_SYNCED at this point, showing PAGER_RESERVED
instead
Original issue reported on code.google.com by [email protected]
on 10 Aug 2009 at 6:48
[DllImport( "kernel32", SetLastError = true )]
static extern int LockFile(int hFile, int dwFileOffsetLow, int
dwFileOffsetHigh, int nNumberOfBytesToLockLow, int nNumberOfBytesToLockHigh);
[DllImport( "kernel32", SetLastError = true )]
static extern int LockFileEx(int hFile, int dwFlags, int dwReserved,
int nNumberOfBytesToLockLow, int nNumberOfBytesToLockHigh, ref OVERLAPPED
lpOverlapped);
const int LOCKFILE_EXCLUSIVE_LOCK = 0x00000002;
[DllImport( "kernel32", SetLastError = true )]
static extern int UnlockFile( IntPtr hFile, int dwFileOffsetLow, int
dwFileOffsetHigh, int nNumberOfBytesToUnlockLow, int
nNumberOfBytesToUnlockHigh );
in referenced in os_win_c.cs and used by the date/time/file routines
This prevents fulling running under Silverlight
Original issue reported on code.google.com by [email protected]
on 7 Aug 2009 at 4:11
can u supply a svn control source?
and what i want to know is,dose this support .NET CF?
thanks a lot
Original issue reported on code.google.com by [email protected]
on 10 Aug 2009 at 10:06
[DllImport( "kernel32.dll", SetLastError = true )]
static extern int FormatMessageA( int dwFlags, ref object lpSource,
int dwMessageId, int dwLanguageId, string lpBuffer,
int nSize, ref int Arguments );
in referenced in os_win_c.cs and used by getLastErrorMsg
This prevents fulling running under Silverlight
Original issue reported on code.google.com by [email protected]
on 7 Aug 2009 at 4:03
What steps will reproduce the problem?
1. Open testfixture project, set to the DEBUG build
2. In test/^testscripts.txt setup the following test:
source $testdir/rollback.test
3. Start running in DEBUG mode
rollback-1.5... Expected: [SQLITE_ERROR] Got: [SQLITE_ROW]
This is testing 2 connections where one deletes the table out from
underneath the 2nd and then we try to continue with the first SELECT statement
Need to determine the root cause of this error. It may be a non-error and
simply caused by the stored compiled statements in the test harness or a
serious error related to the shared Btree structure not being shared correctly
Original issue reported on code.google.com by [email protected]
on 8 Aug 2009 at 2:49
What steps will reproduce the problem?
1. Open the Textfixture project
2. Set the CPU type to x64
3. run the aggerror.test
aggerror-1.6...
Error: unable to open database file
Tracing indicates that C#-SQLite thinks the file is write protected
Related to FileLocking API under x64
Original issue reported on code.google.com by [email protected]
on 11 Aug 2009 at 10:06
zip file in sources contains a lot of garbage. Please remove it to make
smaller package.
Original issue reported on code.google.com by [email protected]
on 17 Feb 2010 at 4:08
What steps will reproduce the problem?
SQLiteDatabase db;
string databaseName = "Benchmark_cs-SQLite.sqlite";
db = new SQLiteDatabase(databaseName);
DataTable table = db.ExecuteQuery("SELECT strIndex FROM Root");
the table.Rows.Count is 0, actually there are data in the file.
I debugged, the following line:
if ((resultType = csSQLite.sqlite3_step(vm)) == csSQLite.SQLITE_ROW)
it's false, resultType is SQLITE_DONE.
I just downloaded the source code, and I am using windows 2003.
Original issue reported on code.google.com by [email protected]
on 10 Aug 2009 at 8:35
Methods in vdbeapi_c.cs that belongs to SQLite API are not public.
For example:
sqlite3_next_stmt
sqlite3_bind_parameter_index
Original issue reported on code.google.com by [email protected]
on 10 Feb 2010 at 10:10
The FAQ contains the questions about how to compile into a dll.
The answere references the wikipage DllCompilingInstructions, which need to
be written
Original issue reported on code.google.com by [email protected]
on 20 Jan 2010 at 7:24
What steps will reproduce the problem?
1. Add the SQLITE_OMIT_MEMORYDB compilation constant
2. Recompile
What is the expected output? What do you see instead?
I get the following compilation errors:
Error 1 'CS_SQLite3.csSQLite' does not contain a definition for
'sqlite3_prepare' C:\Documents and
Settings\Philippe\csharp-sqlite\shell\src\shell.cs 993 21 csharp-sqlite-shell
Error 2 'CS_SQLite3.csSQLite' does not contain a definition for
'sqlite3_prepare' C:\Documents and
Settings\Philippe\csharp-sqlite\shell\src\shell.cs 1073 23 csharp-sqlite-shell
Error 3 The type name 'dxCallback' does not exist in the type
'CS_SQLite3.csSQLite' C:\Documents and
Settings\Philippe\csharp-sqlite\shell\src\shell.cs 7 40 csharp-sqlite-shell
Error 4 'CS_SQLite3.csSQLite' does not contain a definition for
'sqlite3_open' C:\Documents and
Settings\Philippe\csharp-sqlite\shell\src\shell.cs 1211 18 csharp-sqlite-shell
Error 5 'CS_SQLite3.csSQLite' does not contain a definition for
'sqlite3_errcode' C:\Documents and
Settings\Philippe\csharp-sqlite\shell\src\shell.cs 1213 37 csharp-sqlite-shell
Error 6 The type name 'dxFunc' does not exist in the type
'CS_SQLite3.csSQLite' C:\Documents and
Settings\Philippe\csharp-sqlite\shell\src\shell.cs 1216 21 csharp-sqlite-shell
Error 7 'CS_SQLite3.csSQLite' does not contain a definition for
'sqlite3_errcode' C:\Documents and
Settings\Philippe\csharp-sqlite\shell\src\shell.cs 1218 59 csharp-sqlite-shell
Error 9 'CS_SQLite3.csSQLite' does not contain a definition for
'sqlite3_open' C:\Documents and
Settings\Philippe\csharp-sqlite\shell\src\shell.cs 1370 23 csharp-sqlite-shell
Error 10 The best overloaded method match for
'CS_SQLite3.csSQLite.sqlite3_exec(CS_SQLite3.csSQLite.sqlite3, string, int,
int, int)' has some invalid arguments C:\Documents and
Settings\Philippe\csharp-sqlite\shell\src\shell.cs 1433 15 csharp-sqlite-shell
Error 11 Argument '3': cannot convert from '<null>' to 'int' C:\Documents
and Settings\Philippe\csharp-sqlite\shell\src\shell.cs 1433 73
csharp-sqlite-shell
Error 12 Argument '4': cannot convert from '<null>' to 'int' C:\Documents
and Settings\Philippe\csharp-sqlite\shell\src\shell.cs 1433 79
csharp-sqlite-shell
Error 13 Argument '5': cannot convert from 'ref string' to 'int'
C:\Documents and Settings\Philippe\csharp-sqlite\shell\src\shell.cs 1433
89 csharp-sqlite-shell
Error 14 'CS_SQLite3.csSQLite' does not contain a definition for
'sqlite3_prepare' C:\Documents and
Settings\Philippe\csharp-sqlite\shell\src\shell.cs 1578 41 csharp-sqlite-shell
Error 15 'CS_SQLite3.csSQLite' does not contain a definition for
'sqlite3_prepare' C:\Documents and
Settings\Philippe\csharp-sqlite\shell\src\shell.cs 1603 41 csharp-sqlite-shell
Error 16 The best overloaded method match for
'CS_SQLite3.csSQLite.sqlite3_exec(CS_SQLite3.csSQLite.sqlite3, string, int,
int, int)' has some invalid arguments C:\Documents and
Settings\Philippe\csharp-sqlite\shell\src\shell.cs 1674 27 csharp-sqlite-shell
Error 17 Argument '3': cannot convert from '<null>' to 'int' C:\Documents
and Settings\Philippe\csharp-sqlite\shell\src\shell.cs 1674 76
csharp-sqlite-shell
Error 18 Argument '4': cannot convert from '<null>' to 'int' C:\Documents
and Settings\Philippe\csharp-sqlite\shell\src\shell.cs 1674 82
csharp-sqlite-shell
Error 19 Argument '5': cannot convert from 'ref string' to 'int'
C:\Documents and Settings\Philippe\csharp-sqlite\shell\src\shell.cs 1674
92 csharp-sqlite-shell
Error 20 'CS_SQLite3.csSQLite' does not contain a definition for
'sqlite3_open' C:\Documents and
Settings\Philippe\csharp-sqlite\shell\src\shell.cs 1891 59 csharp-sqlite-shell
Error 21 'CS_SQLite3.csSQLite' does not contain a definition for
'sqlite3_sleep' C:\Documents and
Settings\Philippe\csharp-sqlite\shell\src\shell.cs 1912 58 csharp-sqlite-shell
Error 23 'CS_SQLite3.csSQLite' does not contain a definition for
'sqlite3_complete' C:\Documents and
Settings\Philippe\csharp-sqlite\shell\src\shell.cs 2213 21 csharp-sqlite-shell
Error 24 'CS_SQLite3.csSQLite' does not contain a definition for
'sqlite3_complete' C:\Documents and
Settings\Philippe\csharp-sqlite\shell\src\shell.cs 2306 23 csharp-sqlite-shell
Error 25 Cannot implicitly convert type 'int' to 'string' C:\Documents
and Settings\Philippe\csharp-sqlite\shell\src\shell.cs 2584 20
csharp-sqlite-shell
Error 26 Operator '==' cannot be applied to operands of type 'string' and
'int' C:\Documents and
Settings\Philippe\csharp-sqlite\shell\src\shell.cs 2594 5 csharp-sqlite-shell
What version of the product are you using? On what operating system?
XP
.NET 3.5
VS 2008 Express
Please provide any additional information below.
Looking at the main function it looked like the default is to use an
in-memory database unless the SQLITE_OMIT_MEMORYDB symbol is defined in
which case it should use the database name passed on the command line, then
open the database.
Twitter alias: #techarch
Original issue reported on code.google.com by [email protected]
on 8 Aug 2009 at 9:31
Binary blobs get converted via Encoding.UTF8.GetString to store; This may
cause problems for some sequence of bytes during SELECT statement
Need to revisit storage and retrieval of blobs
Original issue reported on code.google.com by [email protected]
on 29 Jan 2010 at 4:16
What steps will reproduce the problem?
1. Add Benchmark as Project into Visual Studio 2008
2. Compile
What is the expected output? What do you see instead?
I expected it to compile, but I have 19 errors:
Error 1 'CS_SQLite3.csSQLite.SQLITE_INTEGER' is inaccessible due to its
protection level C:\Users\Tim\Documents\Visual Studio 2008\Team
Projects\SimpleSample\Main\Source\csharp-sqlite\Benchmark\src\Benchmark.cs 51
42 Benchmark
Error 2 'CS_SQLite3.csSQLite.SQLITE_TEXT' is inaccessible due to its
protection level C:\Users\Tim\Documents\Visual Studio 2008\Team
Projects\SimpleSample\Main\Source\csharp-sqlite\Benchmark\src\Benchmark.cs 52
42 Benchmark
Error 3 'CS_SQLite3.csSQLite.SQLITE_INTEGER' is inaccessible due to its
protection level C:\Users\Tim\Documents\Visual Studio 2008\Team
Projects\SimpleSample\Main\Source\csharp-sqlite\Benchmark\src\Benchmark.cs 119
42 Benchmark
Error 4 'CS_SQLite3.csSQLite.sqlite3_column_type(CS_SQLite3.csSQLite.Vdbe,
int)' is inaccessible due to its protection level
C:\Users\Tim\Documents\Visual Studio 2008\Team
Projects\SimpleSample\Main\Source\csharp-sqlite\Benchmark\Classes\SQLiteDatabase
.cs
141 37 Benchmark
Error 5 'CS_SQLite3.csSQLite.SQLITE_INTEGER' is inaccessible due to its
protection level C:\Users\Tim\Documents\Visual Studio 2008\Team
Projects\SimpleSample\Main\Source\csharp-sqlite\Benchmark\Classes\SQLiteDatabase
.cs
144 27 Benchmark
Error 6 'CS_SQLite3.csSQLite.sqlite3_column_int(CS_SQLite3.csSQLite.Vdbe,
int)' is inaccessible due to its protection level
C:\Users\Tim\Documents\Visual Studio 2008\Team
Projects\SimpleSample\Main\Source\csharp-sqlite\Benchmark\Classes\SQLiteDatabase
.cs
146 44 Benchmark
Error 7 'CS_SQLite3.csSQLite.SQLITE_FLOAT' is inaccessible due to its
protection level C:\Users\Tim\Documents\Visual Studio 2008\Team
Projects\SimpleSample\Main\Source\csharp-sqlite\Benchmark\Classes\SQLiteDatabase
.cs
149 27 Benchmark
Error 8
'CS_SQLite3.csSQLite.sqlite3_column_double(CS_SQLite3.csSQLite.Vdbe, int)'
is inaccessible due to its protection level C:\Users\Tim\Documents\Visual
Studio 2008\Team
Projects\SimpleSample\Main\Source\csharp-sqlite\Benchmark\Classes\SQLiteDatabase
.cs
151 44 Benchmark
Error 9 'CS_SQLite3.csSQLite.SQLITE_TEXT' is inaccessible due to its
protection level C:\Users\Tim\Documents\Visual Studio 2008\Team
Projects\SimpleSample\Main\Source\csharp-sqlite\Benchmark\Classes\SQLiteDatabase
.cs
154 27 Benchmark
Error 10 'CS_SQLite3.csSQLite.SQLITE_BLOB' is inaccessible due to its
protection level C:\Users\Tim\Documents\Visual Studio 2008\Team
Projects\SimpleSample\Main\Source\csharp-sqlite\Benchmark\Classes\SQLiteDatabase
.cs
159 27 Benchmark
Error 11 'CS_SQLite3.csSQLite.sqlite3_column_blob(CS_SQLite3.csSQLite.Vdbe,
int)' is inaccessible due to its protection level
C:\Users\Tim\Documents\Visual Studio 2008\Team
Projects\SimpleSample\Main\Source\csharp-sqlite\Benchmark\Classes\SQLiteDatabase
.cs
161 44 Benchmark
Error 12 'CS_SQLite3.csSQLite.sqlite3_column_type(CS_SQLite3.csSQLite.Vdbe,
int)' is inaccessible due to its protection level
C:\Users\Tim\Documents\Visual Studio 2008\Team
Projects\SimpleSample\Main\Source\csharp-sqlite\Benchmark\Classes\SQLiteDatabase
.cs
193 33 Benchmark
Error 13 'CS_SQLite3.csSQLite.SQLITE_INTEGER' is inaccessible due to its
protection level C:\Users\Tim\Documents\Visual Studio 2008\Team
Projects\SimpleSample\Main\Source\csharp-sqlite\Benchmark\Classes\SQLiteDatabase
.cs
197 27 Benchmark
Error 14 'CS_SQLite3.csSQLite.SQLITE_FLOAT' is inaccessible due to its
protection level C:\Users\Tim\Documents\Visual Studio 2008\Team
Projects\SimpleSample\Main\Source\csharp-sqlite\Benchmark\Classes\SQLiteDatabase
.cs
203 27 Benchmark
Error 15 'CS_SQLite3.csSQLite.SQLITE_TEXT' is inaccessible due to its
protection level C:\Users\Tim\Documents\Visual Studio 2008\Team
Projects\SimpleSample\Main\Source\csharp-sqlite\Benchmark\Classes\SQLiteDatabase
.cs
208 27 Benchmark
Error 16 'CS_SQLite3.csSQLite.SQLITE_BLOB' is inaccessible due to its
protection level C:\Users\Tim\Documents\Visual Studio 2008\Team
Projects\SimpleSample\Main\Source\csharp-sqlite\Benchmark\Classes\SQLiteDatabase
.cs
213 27 Benchmark
Error 17 'CS_SQLite3.csSQLite.SQLITE_INTEGER' is inaccessible due to its
protection level C:\Users\Tim\Documents\Visual Studio 2008\Team
Projects\SimpleSample\Main\Source\csharp-sqlite\Benchmark\Classes\SQLiteDatabase
.cs
260 23 Benchmark
Error 18 'CS_SQLite3.csSQLite.SQLITE_TEXT' is inaccessible due to its
protection level C:\Users\Tim\Documents\Visual Studio 2008\Team
Projects\SimpleSample\Main\Source\csharp-sqlite\Benchmark\Classes\SQLiteDatabase
.cs
265 23 Benchmark
Error 19 'CS_SQLite3.csSQLite.SQLITE_NULL' is inaccessible due to its
protection level C:\Users\Tim\Documents\Visual Studio 2008\Team
Projects\SimpleSample\Main\Source\csharp-sqlite\Benchmark\Classes\SQLiteDatabase
.cs
270 23 Benchmark
What version of the product are you using? On what operating system?
Please provide any additional information below.
This is probably an easy fix, or some configuration change I am missing.
Original issue reported on code.google.com by [email protected]
on 6 Aug 2009 at 6:37
lock2-1.1 requires that the C# TCL port support pipelines
Original issue reported on code.google.com by [email protected]
on 5 Aug 2009 at 1:40
What steps will reproduce the problem?
1. Open testfixture project, set to the DEBUG build
2. In test/^testscripts.txt setup the following test:
source $testdir/collate3.test
3. Start running in DEBUG mode
collate3-4.11 fails Debug.Assert in sqlite3CheckCollSeq
Debug.Assert( p == pColl );
I feel there is some problem with the shared class and copy vs clone of C#
classes. Both P and pColl are "user_defined" collations, and should point
to the same object, but have different HashCodes, indicating different objects
Need to determine the root cause of this error.
Original issue reported on code.google.com by [email protected]
on 8 Aug 2009 at 2:34
Series of breaks discovered when compiling source using VS 2008 SP1 / .NET
3.5 SP1. Most were around needing to add 'ref' to method calls.
Original issue reported on code.google.com by [email protected]
on 7 Aug 2009 at 5:44
What steps will reproduce the problem?
1. Open testfixture project, set to the DEBUG build
2. In test/^testscripts.txt setup the following test:
source $testdir/tclsqlite.test
3. Start running in DEBUG mode
first error
do_test tcl-2.1 {
execsql "CREATE TABLE t\u0123x(a int, b\u1235 float)"
} {}
tcl-2.1... Error: unrecognized token: "g"
May simply be incorrect processing of Unicode in the TCL port
Need to determine the root cause of this error and determine if we will
ignore or fix
Original issue reported on code.google.com by [email protected]
on 8 Aug 2009 at 2:52
What steps will reproduce the problem?
1. run "C#-SQLite3.exe BookSalesAnalysis.db3 < BookAnalysisLoader.sql"
(files are attached)
What is the expected output? What do you see instead?
Unhandled exception. See attached "StackDump.txt" for details.
Works with SQLite3.exe
What version of the product are you using? On what operating system?
Windows, latest code branch.
Please provide any additional information below.
First issue appears to be an issue with the approach of referencing a
StringBuilder text via [j++] outside of the range of the text. Line 1599
"zSql[j++] = ',';" of shell.cs.
Original issue reported on code.google.com by [email protected]
on 25 Jan 2010 at 3:22
Attachments:
Today we have a set of .cs files that we include in multiple projects
(testfixture, shell, etc.) I'd like to suggest we have one library project
that we include in all other projects rather than linking the source code
files directly in each project. This is "more dotnet like".
Original issue reported on code.google.com by [email protected]
on 12 Aug 2009 at 3:03
3.6.22 pushed with compiler option SQLITE_OMIT_TRIGGER
since recursive triggers are failing
Original issue reported on code.google.com by [email protected]
on 12 Jan 2010 at 8:50
What steps will reproduce the problem?
1. Download the source
2. Compile testfixture.csproj
What is the expected output? What do you see instead?
Build break on missing debuginfo.cs file
What version of the product are you using? On what operating system?
changeset: 14:becb51db8f6d
Please provide any additional information below.
Original issue reported on code.google.com by [email protected]
on 10 Aug 2009 at 3:36
What steps will reproduce the problem?
1. Open testfixture project, set to the DEBUG build
2. In test/^testscripts.txt setup the following test:
source $testdir/eval.test
3. Start running in DEBUG mode
fails with the following error:
eval-3.1...
Expected: [1 {} 102 2 {} 103 3 {} 104 4 {} 105]
Got: [1 {} 2 2 {} 3 3 {} 4 4 {} 5]
This test modifies a row while it is being read. Since it fails, it shows
that the shared pager cache is not working properly. I feel this is
serious and there may be a conceptual problem with the C# port
Need to determine the root cause of this error
Original issue reported on code.google.com by [email protected]
on 8 Aug 2009 at 2:37
Use of DllImport for GetLastError prevents running under Silverlight
[DllImport( "kernel32", SetLastError = true )]
static extern int GetLastError();
in referenced in os_win_c.cs and used by getLastErrorMsg
This prevents fulling running under Silverlight
Original issue reported on code.google.com by [email protected]
on 7 Aug 2009 at 4:05
C#-SQLite project contains two classes csSQLite with the same name, one in
CS_SQLite3 namespace and other in Community.Data.SQLite. Both are public.
It makes a little confusion when adding csSQLite to source code for a first
time.
Also CS_SQLite3.csSQLite is declared in two files(mem0_c.cs and mem1_c.cs),
and mem1_c.cs is not included in project.
Original issue reported on code.google.com by [email protected]
on 10 Feb 2010 at 10:31
What steps will reproduce the problem?
Flip on TRACE
What is the expected output? What do you see instead?
Expected: Source code compiles
Actual: Break in line 61 of pager_c.cs, sqlite3DebugPrintf is not defined
Reason: in printf_c.cs, sqlite3DebugPrintf is ifdef'd out if SQLITE_DEBUG
is not defined
What version of the product are you using? On what operating system?
Rev 16 of source on x64 Win7
Original issue reported on code.google.com by [email protected]
on 12 Aug 2009 at 2:53
What steps will reproduce the problem?
1. Open testfixture project, set to the DEBUG build
2. In test/^testscripts.txt setup the following test:
source $testdir/select7.test
3. Start running in DEBUG mode
Expected:
select7-6.1... Ok
Got:
app crash.
This is because each stack element is larger and the hardcoded limit of
SQLITE_MAX_COMPOUND_SELECT set to 500 is too high.
Suggested fix: set the limit to 250 (I verified that up to 300 the test
passes, while setting to 400 causes a crash).
Original issue reported on code.google.com by [email protected]
on 9 Sep 2009 at 4:37
What steps will reproduce the problem?
1. Open testfixture project, set to the DEBUG build
2. In test/^testscripts.txt setup the following test:
source $testdir/backup.test
3. Start running in DEBUG mode
Test 41: src=test.db dest=test2.db (as db2.temp) rows_dest=0 pgsz_dest=2048
backup-2.41.1... in fails
static int sqlite3OsFileSize( sqlite3_file id, ref int pSize )
{
return id.pMethods.xFileSize( id, ref pSize );
}
because id.pMethods is null. This error should be fairly simple to
resolve. Looks like some attributes are not being cleared before a memory
database is opened
Original issue reported on code.google.com by [email protected]
on 8 Aug 2009 at 2:30
We should consider how we either integrate with the System.Data.SQLite
project or how we reimplement Linq support for this library.
Original issue reported on code.google.com by [email protected]
on 10 Aug 2009 at 3:42
Update to SQLite release 3.6.18
Original issue reported on code.google.com by [email protected]
on 22 Sep 2009 at 12:13
lock4-1.2... fails with
Error: wrong # args: should be "exec ?switches? arg ?arg ...?"
because TCL port cannot fork
# Kick off the second process.
exec [info nameofexec] ./test2-script.tcl &
Original issue reported on code.google.com by [email protected]
on 5 Aug 2009 at 1:43
Upgrade port to latest SQLite release with cascading triggers
Original issue reported on code.google.com by [email protected]
on 17 Dec 2009 at 2:49
What steps will reproduce the problem?
1. Open testfixture project, set to the DEBUG build
2. In test/^testscripts.txt setup the following test:
source $testdir/pcache2.test
3. Start running in DEBUG mode
pcache2-1.2... Expected: [2] Got: [0]
I think that this error is either a problem with the shared cache, or
simply setting/getting counters incorrectly with multiple instances. If it
is in the shared cache, probably related to the eval and trigger errors
Original issue reported on code.google.com by [email protected]
on 8 Aug 2009 at 2:44
autovacuum-9.1... pcache1TruncateUnsafe
What steps will reproduce the problem?
1. Open testfixture project, set to the DEBUG build
2. In test/^testscripts.txt setup the following test:
source $testdir/autovacuum.test
3. Start running in DEBUG mode
autovacuum-9.1 fails Debug.Assert in pcache1TruncateUnsafe
Need to determine the root cause of this error
Original issue reported on code.google.com by [email protected]
on 8 Aug 2009 at 2:26
here's the stack trace:
Unhandled Exception: System.NotImplementedException: The requested feature
is not implemented.
at System.IO.FileStream.get_SafeFileHandle () [0x00000]
at CS_SQLite3.csSQLite.winOpen (CS_SQLite3.sqlite3_vfs pVfs,
System.String zName, CS_SQLite3.sqlite3_file pFile, Int32 flags,
System.Int32& pOutFlags) [0x00000]
at CS_SQLite3.csSQLite.sqlite3OsOpen (CS_SQLite3.sqlite3_vfs pVfs,
System.String zPath, CS_SQLite3.sqlite3_file pFile, Int32 flags,
System.Int32& pFlagsOut) [0x00000]
at CS_SQLite3.csSQLite.sqlite3PagerOpen (CS_SQLite3.sqlite3_vfs pVfs,
CS_SQLite3.Pager& ppPager, System.String zFilename, Int32 nExtra, Int32
flags, Int32 vfsFlags, CS_SQLite3.dxReiniter xReinit) [0x00000]
at CS_SQLite3.csSQLite.sqlite3BtreeOpen (System.String zFilename,
CS_SQLite3.sqlite3 db, CS_SQLite3.Btree& ppBtree, Int32 flags, Int32
vfsFlags) [0x00000]
at CS_SQLite3.csSQLite.sqlite3BtreeFactory (CS_SQLite3.sqlite3 db,
System.String zFilename, Boolean omitJournal, Int32 nCache, Int32 vfsFlags,
CS_SQLite3.Btree& ppBtree) [0x00000]
at CS_SQLite3.csSQLite.openDatabase (System.String zFilename,
CS_SQLite3.sqlite3& ppDb, Int32 flags, System.String zVfs) [0x00000]
at CS_SQLite3.csSQLite.sqlite3_open (System.String zFilename,
CS_SQLite3.sqlite3& ppDb) [0x00000]
at CS_SQLite3.SQLiteDatabase.OpenDatabase (System.String DatabaseName)
[0x00000]
at CS_SQLite3.SQLiteDatabase..ctor (System.String DatabaseName) [0x00000]
im using the Community.Data.SQLite.dll assembly built from the .csproj made
available in the source (my project that uses the dll is actually
boo-based, so putting the src in the project isn't really an option for
me). I built the assembly in windows/ms.net (windows 7.. so 3.5 sp1?). the
above issue doesn't occur on windows...
this is with the release version of mono 2.4.2.3 on ubuntu 9.04 .. I
understand that the error is a failure on mono's part.. but was
csharp-sqlite written with the possibility of being platform portable in
mind? I see the call to a winOpen() method in the stack trace.. is
windows/ms.net the only target platform, currently, or am I reading into
this too much?
so I guess I'm gonna file a bug with the mono team over this, but I wanted
to bring it to your attention. I don't know if you can or even want to code
around this, but if portability is a goal of the project this is something
you will want to keep an eye open for.
thanks
Original issue reported on code.google.com by [email protected]
on 17 Sep 2009 at 4:49
What steps will reproduce the problem?
1. Run the shell project by passing the database name in the first
argument.
What is the expected output? What do you see instead?
When passing as a first argument the database name, the shell should write
on the file system, instead it writes in memory.
What version of the product are you using? On what operating system?
Latest release on Windows 7 RC1.
Please provide any additional information below.
Inside the shell.cs (line 2554) :
for ( i = 1 ; i < argc - 1 ; i++ )
...
if ( i < argc )
{
#if (SQLITE_OS_OS2) && SQLITE_OS_OS2
data.zDbFilename = (string )convertCpPathToUtf8( argv[i++] );
#else
data.zDbFilename = argv[i++];
#endif
}
else
{
#if !SQLITE_OMIT_MEMORYDB
data.zDbFilename = ":memory:";
#else
data.zDbFilename = 0;
#endif
}
A command like "C#-SQLite3.exe mydb.sqlite" will compare 1 < 1 and pass in
the else branch.
Original issue reported on code.google.com by [email protected]
on 9 Aug 2009 at 4:12
tkt-78e04-1.0...
What steps will reproduce the problem?
1. Open testfixture project, set to the DEBUG build
2. In test/^testscripts.txt setup the following test:
source $testdir/tkt-78e04e52ea.test
3. Start running in DEBUG mode
tkt-78e04e52 fails in legacy_c.c at line 189
in the ALWAYS clause
if ( rc != SQLITE_OK && ALWAYS( rc == sqlite3_errcode( db ) ) &&
pzErrMsg != null )
Need to determine the root cause of this error
Original issue reported on code.google.com by [email protected]
on 12 Jan 2010 at 8:54
What steps will reproduce the problem?
1. Open testfixture project, set to the DEBUG build
2. In test/^testscripts.txt setup the following test:
source $testdir/memsubsys1.test
3. Start running in DEBUG mode
1st error in test is
memsubsys1-2.3... Expected: [1] Got: [0]
finally breaks in sqlite3MallocInit; but this break simply is a section of
code I never ported.
I think these are non-errors, having to do with items we don't need to port
to C#, but would appreciate review and evaluation
Original issue reported on code.google.com by [email protected]
on 8 Aug 2009 at 2:41
I just checked out the source using mercurial today.
When I went to compile the Community.Data.SQLite.dll, I got an error saying
that it couldn't find the assembly System.Management. (I disremember the
exact error message)
When I looked at the list of references in Visual Studio's Solution
Explorer, I discovered that, sure enough, System.Management was not listed
as being referenced. After I added it, it compiles just fine.
I use the full version of Visual Studio 2008
Original issue reported on code.google.com by [email protected]
on 2 Oct 2009 at 7:22
Investigate replacing byte[] allocations with a pool of buffers to reduce
garbage collections
Original issue reported on code.google.com by [email protected]
on 17 Dec 2009 at 2:50
I'd like to suggest we consider a root namespace of our code as
"Community.Data.SQLite".
Original issue reported on code.google.com by [email protected]
on 12 Aug 2009 at 3:01
interrupt.test, io.test and ioerr.test require that sqlite3_simulate_device
be implemented.
Original issue reported on code.google.com by [email protected]
on 5 Aug 2009 at 1:37
Use of DllImport for LockFile, LockFileEx & UnlockFile prevents running
under Silverlight
[DllImport( "kernel32", SetLastError = true )]
static extern int LockFile(int hFile, int dwFileOffsetLow, int
dwFileOffsetHigh, int nNumberOfBytesToLockLow, int nNumberOfBytesToLockHigh);
[DllImport( "kernel32", SetLastError = true )]
static extern int LockFileEx(int hFile, int dwFlags, int dwReserved,
int nNumberOfBytesToLockLow, int nNumberOfBytesToLockHigh, ref OVERLAPPED
lpOverlapped);
const int LOCKFILE_EXCLUSIVE_LOCK = 0x00000002;
[DllImport( "kernel32", SetLastError = true )]
static extern int UnlockFile( IntPtr hFile, int dwFileOffsetLow, int
dwFileOffsetHigh, int nNumberOfBytesToUnlockLow, int
nNumberOfBytesToUnlockHigh );
in referenced in os_win_c.cs and used by the locking routines
This prevents fulling running under Silverlight
Original issue reported on code.google.com by [email protected]
on 7 Aug 2009 at 4:08
[DllImport( "kernel32", SetLastError = true )]
static extern int LockFileEx (...)
is referenced in os_win_c.cs and used by the locking routines
This prevents fulling running under Silverlight
Split from issue # 10
Original issue reported on code.google.com by [email protected]
on 24 Aug 2009 at 10:28
Running testfixture, compiled with x64 after latest LockFIleEx checking changes
source $testdir/backup.test
Test 133: src=:memory: dest=test2.db (as db2.main) rows_dest=3 pgsz_dest=512
attempt to write a readonly database
Original issue reported on code.google.com by [email protected]
on 1 Sep 2009 at 10:40
What steps will reproduce the problem?
1. Open testfixture project, set to the DEBUG build
2. In test/^testscripts.txt setup the following test:
source $testdir/trigger2.test
3. Start running in DEBUG mode
trigger2-1.1.2... Expected: [1 100 100 400 300 0 0 2 100 100 300 200 0 0 3
300 200 300 200 0 0 4 300 200 0 0 0 0] Got: [1 100 100 400 300 0 0 2
100 100 300 200 0 0 3 300 200 300 200 0 0 4 300 200 300 200 0 0]
...
trigger 2 results: 7 errors out of 109 tests
This is a pretty complicated test and I'm not sure what is being tested but
clearly most of the code is working.
TASK: Need to determine the root cause of this error
Original issue reported on code.google.com by [email protected]
on 8 Aug 2009 at 2:57
Add changes for current SQLite release 3.6.19; allowing foreign key integrity
Original issue reported on code.google.com by [email protected]
on 16 Oct 2009 at 12:57
tkt2565.test requires implementation of "sqlite3_config_alt_pcache"
Original issue reported on code.google.com by [email protected]
on 5 Aug 2009 at 1:41
What steps will reproduce the problem?
1. Create Table
2. Insert some data
3. Use the ExecuteQuery and check the datatypes
What is the expected output? What do you see instead?
DataTable from ExecuteQuery contains only string datatype.
I have been testing your implemetnation of SQLite. One thing I discovered
is that only the datatype string is rutned in the table returning from
ExecuteQuery. Is this a correct behaviour?
For example if I want to run a cast in the query, cast(col1 as int) the
returning table still renders col1 as string.
Is this behaviour by design?
What version of the product are you using? On what operating system?
3.6.17
Please provide any additional information below.
Original issue reported on code.google.com by [email protected]
on 21 Jan 2010 at 3:15
A declarative, efficient, and flexible JavaScript library for building user interfaces.
๐ Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
The Web framework for perfectionists with deadlines.
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. ๐๐๐
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
We are working to build community through open source technology. NB: members must have two-factor auth.
Open source projects and samples from Microsoft.
Google โค๏ธ Open Source for everyone.
Alibaba Open Source for everyone
Data-Driven Documents codes.
China tencent open source team.