[sqlite] system.data.sqlite.dll and Widows 10

2015-03-19 Thread Jeff Steinkamp
I ran this utility and what I discovered is problematic. On my development machine, it is always looking for this dependency in the GAC first and loading it from there. as opposed to the start-up folder where the DLL is located. Why is this looking for the DLL in the GAC first? This is not

[sqlite] Source code for 3.8.7.4

2015-03-19 Thread Saurav Sarkar
Hi Richard, Thanks for the info. I got this link from the site for 3.8.7.4 http://www.sqlite.org/cgi/src/info/f66f7a17b78ba617 Hope this is fine. I want this version because my project is using this release. Best Regards, Saurav On Thu, Mar 19, 2015 at 8:38 PM, Richard Hipp wrote: > On

[sqlite] Source code for 3.8.7.4

2015-03-19 Thread Saurav Sarkar
Hi All, Can anyone please tell me how can i get the source code for 3.8.7.4 ? In the website of SQLite i could get hold of a amalgamation source code of latest release 3.8.8.3 in a zip file. Can i similarly get for 3.8.7.4 ? thanks and Regards, Saurav

[sqlite] What is the right order of the main SQLite functions?

2015-03-19 Thread Igor Tandetnik
On 3/19/2015 7:48 PM, Bart Smissaert wrote: > I know this is basic and should be in the documentation, but it is not > quite clear to me. > Basically I have 3 type of procedures: > > 1. Getting values from a table. For this I have the following steps: > > (Open) > Prepare > > Then in a loop: > >

[sqlite] Why is empty string not equal to empty blob?

2015-03-19 Thread R.Smith
On 2015-03-19 05:32 PM, Paul wrote: >>On 19 Mar 2015, at 3:19pm, Paul wrote: >> >>> This may cause very nasty hard-to-find bugs, since SQLite allows to store >>> any content inside BLOB field: >>> >>> sqlite> create table foo(a int, b int, primary key(a, b)); >>> sqlite> insert into foo(a,

[sqlite] Why is empty string not equal to empty blob?

2015-03-19 Thread Paul
> On 19 Mar 2015, at 3:19pm, Paul wrote: > > > This may cause very nasty hard-to-find bugs, since SQLite allows to store > > any content inside BLOB field: > > > > sqlite> create table foo(a int, b int, primary key(a, b)); > > sqlite> insert into foo(a, b) VALUES(1, ''), (1, x''); > >

[sqlite] Why is empty string not equal to empty blob?

2015-03-19 Thread Paul
> On 3/19/15, Paul wrote: > > Maybe this question was already asked and explained. > > Or maybe it is documented somewhere (could not fiund it). > > Sorry, if this is the case, but why does > > > > SELECT '' = x''; > > > > yields 0? > > > > Because it has never before occurred to the

[sqlite] Why is empty string not equal to empty blob?

2015-03-19 Thread Paul
Maybe this question was already asked and explained. Or maybe it is documented somewhere (could not fiund it). Sorry, if this is the case, but why does SELECT '' = x''; yields 0? Suppose I have data in FOO table. By what means can I tell what is inside of my_blob column of FOO, when SELECT

[sqlite] result of sqlite3_finalize zero, but sqlite3_errcode produces (rightly) SQLITE_CONSTRAINT

2015-03-19 Thread Dan Kennedy
On 03/18/2015 02:39 AM, Bart Smissaert wrote: > OK, let me try to explain: > > Simple table with primary integer key, call the field ID > > strSQL = "Insert into table1 values(?)" > > lReturnValue = sqlite3_prepare16_v2(lDBHandle, >StrPtr(strSQL), >

[sqlite] Why is empty string not equal to empty blob?

2015-03-19 Thread Simon Slavin
On 19 Mar 2015, at 3:19pm, Paul wrote: > This may cause very nasty hard-to-find bugs, since SQLite allows to store any > content inside BLOB field: > > sqlite> create table foo(a int, b int, primary key(a, b)); > sqlite> insert into foo(a, b) VALUES(1, ''), (1, x''); > sqlite> select *,

[sqlite] Why is empty string not equal to empty blob?

2015-03-19 Thread Simon Slavin
On 19 Mar 2015, at 2:56pm, Paul wrote: > Maybe this question was already asked and explained. > Or maybe it is documented somewhere (could not fiund it). > Sorry, if this is the case, but why does > > SELECT '' = x''; > > yields 0? One is a string. The other is a BLOB. SQLite doesn't even

[sqlite] Sqlite3 Bug Found

2015-03-19 Thread Simon Davies
On 6 March 2015 at 08:38, Carabas, Costin wrote: > Hello, > > I was working on version 3.8.8.2 of sqlite3 and I found a bug that is trace > related. It can be reproduced in 3 steps: > > 1. ".t log" - opens log for tracing > > 2. ".t" - no argument. Closes the file descriptor that was

[sqlite] It might be nice to have sqlite3_attach() and sqlite3_detach().

2015-03-19 Thread Scott Hess
On Thu, Mar 19, 2015 at 10:30 AM, Richard Hipp wrote: > On 3/18/15, Scott Hess wrote: >> I'm thinking I could use something like: >> >> SQLITE_API int sqlite3_attach(sqlite3* db, const char* zPath, const >> char* dbname); >> SQLITE_API int sqlite3_detach(sqlite3* db, const char* dbname); >> >>

[sqlite] It might be nice to have sqlite3_attach() and sqlite3_detach().

2015-03-19 Thread Richard Hipp
On 3/18/15, Scott Hess wrote: > I'm thinking I could use something like: > > SQLITE_API int sqlite3_attach(sqlite3* db, const char* zPath, const > char* dbname); > SQLITE_API int sqlite3_detach(sqlite3* db, const char* dbname); > > Right now, I have a helper in Chromium which does "ATTACH

[sqlite] Fwd: Building A Windows DLL - missing exports

2015-03-19 Thread Ewald Einwanger
Hallo, I had a little hint for "Building A Windows DLL". Best Regards Ewald Einwanger Weitergeleitete Nachricht Betreff:Building A Windows DLL - missing exports Datum: Thu, 19 Mar 2015 13:24:18 +0100 Von:Ewald Einwanger An: sqlite-users at sqlite.org

[sqlite] Sqlite3 Bug Found

2015-03-19 Thread Carabas, Costin
This bug reproduces to the latest Sqlite release (3.8.8.3). The log from the bug: sqlite> .t file sqlite> .t Usage: .trace FILE|off sqlite> .d PRAGMA foreign_keys=OFF; BEGIN TRANSACTION; Segmentation fault I also found another bug with the same root cause: sqlite> .t file sqlite> .t Usage:

[sqlite] .import command

2015-03-19 Thread Leonardo Alexandre Ferreira Leite
Hi, I would like to continue a discussion started here: https://www.sqlite.org/src/tktview/c25aab7e7ea55c861313 First I assume the sqlite3 shell still has the related problem (I'm using Ubuntu, so not sure if the last version has fixed it). I would like to desagree of a comment posted on the

[sqlite] Why is empty string not equal to empty blob?

2015-03-19 Thread Adam Devita
As a general rule of thumb, if things are different type, they can't be equal. One already knows the column type. To compare apples to apples, one would cast to convert them. sqlite> SELECT '' = x''; 0 sqlite> SELECT cast('' as blob) = x''; 1 Perhaps some confusion comes from how numbers are

[sqlite] Why is empty string not equal to empty blob?

2015-03-19 Thread Richard Hipp
On 3/19/15, Paul wrote: > Maybe this question was already asked and explained. > Or maybe it is documented somewhere (could not fiund it). > Sorry, if this is the case, but why does > > SELECT '' = x''; > > yields 0? > Because it has never before occurred to the developers that somebody would

[sqlite] Source code for 3.8.7.4

2015-03-19 Thread Richard Hipp
On 3/19/15, Saurav Sarkar wrote: > Hi All, > > Can anyone please tell me how can i get the source code for 3.8.7.4 ? > In the website of SQLite i could get hold of a amalgamation source code of > latest release 3.8.8.3 in a zip file. > > Can i similarly get for 3.8.7.4 ? > Over 14,400 different

[sqlite] how to determine the status of last statement in sqlite3 shell ?

2015-03-19 Thread Simon Slavin
On 19 Mar 2015, at 12:29am, Keith Medcalf wrote: > A statement may fail, however that does not affect other statements within > the transaction. You still have to end a transaction with either a commit > (to commit the changes made by statements WHICH DID NOT FAIL) or rollback to > discard

[sqlite] bug in transactions implementation ?

2015-03-19 Thread R.Smith
Pardon the long post everyone, but it seems from the other posts there is a large misconception to address here and I will attempt to do so as briefly as possible (Also, feel free to chime in where I am vague or wrong): On 2015-03-18 11:24 PM, Jason Vas Dias wrote: > OK, I discovered the OR