Re: [sqlite] light weight write barriers

On Fri, Oct 26, 2012 at 8:54 PM, Vladislav Bolkhovitin wrote: > > Theodore Ts'o, on 10/25/2012 01:14 AM wrote: > >> On Tue, Oct 23, 2012 at 03:53:11PM -0400, Vladislav Bolkhovitin wrote: >> >>> Yes, SCSI has full support for ordered/simple commands designed >>> exactly for that

Re: [sqlite] Bug: Inconsistency wrt. indirectly defined columns

On Saturday, 10 November, 2012 13:09 Igor Tandetnik wrote: > > However with SQLite there are queries which yield incoherent results: > Define "incoherent". As far as I can tell, you use this term to mean "results > you personally dislike". The results SQLite produces are in agreement - in >

Re: [sqlite] Bug: Inconsistency wrt. indirectly defined columns

On 10 Nov 2012, at 7:21pm, stahl...@dbs.uni-hannover.de wrote: > Consider these two tables: > > CREATE TABLE tab1 (x INTEGER PRIMARY KEY); > CREATE TABLE tab2 (x PRIMARY KEY REFERENCES tab1); > > Assuming they contain the same rows, I expect any query against 'tab1' to > return the

Re: [sqlite] Bug: Inconsistency wrt. indirectly defined columns

stahl...@dbs.uni-hannover.de wrote: > Consider these two tables: > > CREATE TABLE tab1 (x INTEGER PRIMARY KEY); > CREATE TABLE tab2 (x PRIMARY KEY REFERENCES tab1); > > Assuming they contain the same rows, I expect any query against 'tab1' to > return the same rows as against 'tab2'.

Re: [sqlite] Bug: Inconsistency wrt. indirectly defined columns

Quoting gwenn : If you want, you can verify automatically that all the FK columns have a type matching the referenced columns by using (and tweaking) an old tool whose name is 'genfkey' (see http://www.sqlite.org/faq.html#q22 but the 'readme' link is broken). Thanks for

Re: [sqlite] Bug: Inconsistency wrt. indirectly defined columns

Quoting Simon Slavin : On 8 Nov 2012, at 5:27pm, stahl...@dbs.uni-hannover.de wrote: But inferring the FK's type from the referenced PK would cause applications which rely on the FK's type affinity being 'none' to be broken, no? At this sort of level of

[sqlite] VC++ and SQLite

I know this question is not a SQLite question, but I am hoping that someone here has had a similar experience and/or can point me to the right place to ask this question. After years or using Code::Blocks and Dev-Cpp, I have recently installed Visual Studio 10 Express; it is the first time I

Re: [sqlite] Please test the latest SQLite snapshot

Hello, We've been using SQLite 3.15-with-union-all-optimizations that you linked to previously, to run some of the workflows that we have here without problems. The workflows use madIS, and they involve around 30 OLAP queries using row/aggregate/virtual table functions on ~5 GB of data.