Re: [sqlite] Bug in composite foreign key constraints.

Glad to be of service, and thanks for the quick turn around. On 11-06-10 02:35 PM, Dan Kennedy wrote: > On 06/11/2011 12:08 AM, Max wrote: >> CREATE TABLE TestTable ( >>id integer primary key, >>name varchar, >>source_id integer not null, >>parent_id integer, >>

Re: [sqlite] Bug in composite foreign key constraints.

On 06/11/2011 12:08 AM, Max wrote: > CREATE TABLE TestTable ( > id integer primary key, > name varchar, > source_id integer not null, > parent_id integer, > foreign key(source_id, parent_id) references TestTable(source_id, id) > ); > > CREATE UNIQUE INDEX testindex on

Re: [sqlite] Bug in composite foreign key constraints.

Great. This fixes this particular case. :) I tried a few different permutations. This one throws a very weird error: CREATE TABLE TestTable ( id integer primary key, name varchar, source_id integer not null, parent_id integer, foreign key(source_id, parent_id)

Re: [sqlite] Bug in composite foreign key constraints.

On 06/10/2011 10:33 PM, Max wrote: > I just grabbed a 3.7.6.3 binary from the sqlite page. The second schema > still fails to throw a constraint error. Hopefully fixed here: http://www.sqlite.org/src/info/442d8d8bfe Grab the zip file from the "Zip Archive" link on the above page. Dan.

Re: [sqlite] sqlitebrowser - anyone compiled a recent one?

Paul I too have had a bad experience with this Firefox addon. I found it to be buggy, to generate all sorts of errors, and frequently I had to shutdown the addon between transactions to get it to continue to work. Months ago I switched to SQLite Expert Personal and haven't looked back. Danny

Re: [sqlite] How to register on the wiki

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 06/10/2011 12:12 AM, Cecil Westerhof wrote: > I like to make speed comparisons for sqlite. Comparing SQLite to other databases? Different versions of SQLite? Different configurations of the same version of SQLite? The SQLite source does include

Re: [sqlite] Bug in composite foreign key constraints.

I just grabbed a 3.7.6.3 binary from the sqlite page. The second schema still fails to throw a constraint error. On 11-06-10 11:22 AM, Pavel Ivanov wrote: > IIRC, there was a bug in enforcement compound foreign keys where one > of columns is primary key and it was fixed. So if you take the

Re: [sqlite] Bug in composite foreign key constraints.

IIRC, there was a bug in enforcement compound foreign keys where one of columns is primary key and it was fixed. So if you take the latest SQLite version I guess you won't see this problem. Pavel On Fri, Jun 10, 2011 at 11:12 AM, Max B wrote: > Hello, > > Please consider

[sqlite] Bug in composite foreign key constraints.

Hello, Please consider this (working) schema and this test data, on sqlite 3.7.4: CREATE TABLE TestTable ( id integer primary key, name varchar, source_id integer not null, parent_id integer, foreign key(parent_id) references TestTable(id) ); PRAGMA foreign_keys=1; INSERT

Re: [sqlite] sqlitebrowser - anyone compiled a recent one?

2011/6/9 Christoph P.U. Kukulies : >> If you want something that works on Linux as well as Windows, try >> the Firefox SQLite extension - it's the dog's! > I've heard big caveats about that one - to avoid like the .., no, I > don't want to open another can of worms :) I

Re: [sqlite] How to register on the wiki

On Fri, Jun 10, 2011 at 3:12 AM, Cecil Westerhof wrote: > I like to make speed comparisons for sqlite. Asking on the list for > the used code did not give a result, so I like to try it on the wiki. > But you have to login and I do not see a way to register. > Various

[sqlite] How to re-compile both DLLs with a specific framework

Dear all, Following Pavel's answers to my topic "Cannot load SQLite.Interop.dll but file is in the folder" (cf. below), it seems necessary for me to re-compile both DLLs (System.Data.SQLite.dll and SQLite.Interop.dll) with a specific framework version (my application uses the framework 3.0).

Re: [sqlite] How to register on the wiki

2011/6/10 Jos Groot Lipman : > Cecil, > > I think nobody 'gave' you the code because it does not exists. There is no > simple standard set of statements to execute for a speed comparison. > If it were that simple somebody would have retested it long ago. > > Doing a fair

Re: [sqlite] How to register on the wiki

Cecil, I think nobody 'gave' you the code because it does not exists. There is no simple standard set of statements to execute for a speed comparison. If it were that simple somebody would have retested it long ago. Doing a fair comparion also involves all sort of configuraton comparions. For

Re: [sqlite] Dynamically loaded sqlite (linux)

On Thu, Jun 9, 2011 at 6:21 PM, Pavel Ivanov wrote: > > I know that I should avoid such things, but just curious, is it something > > inside sqlite that probably makes one dynanmically linked and other > > dynamically loaded library share global data and can this be

[sqlite] How to register on the wiki

I like to make speed comparisons for sqlite. Asking on the list for the used code did not give a result, so I like to try it on the wiki. But you have to login and I do not see a way to register. -- Cecil Westerhof ___ sqlite-users mailing list