Re: [sqlite] Trying to insert a new row in a table that has a column specifically set to the rowid data type will cause an error message like "may not be NULL"

On 03/03/2011, at 11:53 AM, Rami Abughazaleh wrote: > Trying to insert a new row in a table that has a column specifically set to > the rowid data type There is no rowid data type. To alias rowid you need to just type it as integer primary key. > will cause an error message like "value cannot

[sqlite] Trying to insert a new row in a table that has a column specifically set to the rowid data type will cause an error message like "may not be NULL"

Hi. Trying to insert a new row in a table that has a column specifically set to the rowid data type will cause an error message like "value cannot be null". CREATE TABLE [test] ( [Id] ROWID NOT NULL, [Name] nvarchar(50) NOT NULL, [Value] nvarchar(256) NOT NULL ); INSERT INTO test

Re: [sqlite] OSX locking

On 2 Mar 2011, at 9:46pm, Dave Dyer wrote: > If the host is OSX 10.4, it fails. > > I swear it used to work in 10.4 too It's worth noting that 10.4.0 might not work the same as 10.4.1. Please upgrade to the latest version of 10.4 that's available and try it. > Is there any change in sqlite

[sqlite] OSX locking

The configuration I'm interested in has: Database resident on a windows 7 file system sqlite binary based on sqlite 3.7.3 If the host is OSX 10.6, it works. If the host is OSX 10.4, it fails. I swear it used to work in 10.4 too, but lacking a time machine, it's hard to prove. I'm

Re: [sqlite] Source code for system.data.sqlite

What I meant was that the tracker edit is one time only... I can't add additional comments/corrections to any issue after creation. Original Message > Thanks for the feedback. > > We're currently trying to work out a Contributor License Agreement for > System.Data.SQLite -

Re: [sqlite] (How) can I test for an open transaction?

On Wed, Mar 02, 2011 at 12:37:44PM -0500, Pavel Ivanov scratched on the wall: > I believe sqlite3_get_autocommit is what you need: > http://www.sqlite.org/c3ref/get_autocommit.html. Yes. More specifically, if you *are* in auto-commit mode, then by definition you are NOT in an explicit

Re: [sqlite] (How) can I test for an open transaction?

On 2 Mar 2011, at 5:32pm, Philip Graham Willoughby wrote: > I would like to close the database connection if it is safe to do so when my > app is suspended, so that the -wal file can be erased saving the user some > space, and also because I hear that improves the efficiency of subsequent >

Re: [sqlite] (How) can I test for an open transaction?

I believe sqlite3_get_autocommit is what you need: http://www.sqlite.org/c3ref/get_autocommit.html. Pavel On Wed, Mar 2, 2011 at 12:32 PM, Philip Graham Willoughby wrote: > Hi all, > > I use SQLite in an iPhone application, and for my own convenience I have

Re: [sqlite] (How) can I test for an open transaction?

phil, i think the easiest way is more or less like you said. issue the BEGIN, and if you get an ok back, you aren't in a transaction, so you just commit and close the db. otherwise you can wait and check later. there may be a better way do it, but that is all i know of.

[sqlite] (How) can I test for an open transaction?

Hi all, I use SQLite in an iPhone application, and for my own convenience I have wrapped it up in an object-oriented wrapper of my own devising. I would like to close the database connection if it is safe to do so when my app is suspended, so that the -wal file can be erased saving the user

Re: [sqlite] possible bug handling group by and where clauses

On Wed, Mar 02, 2011 at 09:53:51AM +0100, alexis bialot scratched on the wall: > hello, > > this looks to me like a bug but maybe this is just my misunderstanding. You might run an integrity check on the database file and verify any indexes you have are correct and include all rows. If

Re: [sqlite] Bug: rtree2 tests fail due to incorrect format string in rtree.c

On Tue, Mar 01, 2011 at 03:21:58PM +, David Gilbert scratched on the wall: > for(jj=0; jjsqlite3_snprintf(512-nCell,[nCell]," > %f",(double)cell.aCoord[jj].f); > > That's against 3.7.4 but it looks like it's the same in the trunk. > > With that change the

Re: [sqlite] possible bug handling group by and where clauses

Can you send me the database that demonstrates this problem, via private email, please? On Wed, Mar 2, 2011 at 3:53 AM, alexis bialot wrote: > hello, > > this looks to me like a bug but maybe this is just my misunderstanding. > > the databases shema is the trac database

Re: [sqlite] possible bug handling group by and where clauses

On 2 Mar 2011, at 3:26pm, alexis bialot wrote: > as expected, the lines for iter63 and up disapear : there are no > corresponding lines on the right hand side Okay, what you write appears to be correct, but requires more intimate knowledge of the inner workings of SQLite than I have. I'll

Re: [sqlite] possible bug handling group by and where clauses

hello thanks for your quick reply > On 2 Mar 2011, at 8:53am, alexis bialot wrote: > >> i do not believe it should be possible that a query with a left join >> yields less results >> than the exact same query with an inner join. > Do you have any null fields anywhere in either TABLE ? Nulls make

Re: [sqlite] Source code for system.data.sqlite

Thanks for the feedback. We're currently trying to work out a Contributor License Agreement for System.Data.SQLite - probably something along the lines of http://www.fossil-scm.org/fossil/doc/trunk/www/copyright-release.html used for Fossil. You need to login to the Fossil site, even if only as

Re: [sqlite] Asymmetric keys encryption

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 The approach should be: Create a bunch of symetric keys (keep them in your process memory - anyone with root access or same user might still be able to capture them) save those sym-keys into your db protected by a PubKey (also called a

Re: [sqlite] Query help

On 1 Mar 2011, at 22:01, Jeff Archer wrote: > Hi all, and thanks in advance for you help. > > And this select which I would like to modify to only return lowest X,Y value > for each ImageID. > > select Defects.DefectID > , Defects.ImageID > , Defects.AnalysisID > , Defects.X > , Defects.Y > ,

Re: [sqlite] possible bug handling group by and where clauses

On 2 Mar 2011, at 8:53am, alexis bialot wrote: > i do not believe it should be possible that a query with a left join > yields less results > than the exact same query with an inner join. Do you have any null fields anywhere in either TABLE ? Nulls make analysis of what's happening very

Re: [sqlite] Potential problem with ON CONFLICT REPLACE?

Inline... On Mon, Feb 28, 2011 at 04:37:13PM -0700, Carl Baldwin wrote: > Hello, > > I've used sqlite for a number of years now. I ran in to something over the > week-end like nothing I've experienced before. An application linked > against 3.6.18 corrupted one of my databases. The

[sqlite] possible bug handling group by and where clauses

hello, this looks to me like a bug but maybe this is just my misunderstanding. the databases shema is the trac database schema visible here http://trac.edgewall.org/wiki/TracDev/DatabaseSchema but i do not believe the schema is really relevant to the point the problematic clause is "and

[sqlite] Bug: rtree2 tests fail due to incorrect format string in rtree.c

Hi, I ran the sqlite3 test suite on ARM Linux (Ubuntu) and got a set of failures in the rtree2 set of tests, including the following set: rtree2-rtree_i32.1.3 rtree2-rtree_i32.1.5.0.2 rtree2-rtree_i32.1.5.10.2 rtree2-rtree_i32.1.5.20.2 rtree2-rtree_i32.1.5.30.2 rtree2-rtree_i32.1.5.40.2

Re: [sqlite] EXT :Re: long insert statement failing on iPhone

On 1 mars 2011, at 21:11, Mickey Mestel wrote: > hi all, > > i've just discovered that the bug is there when compiling with the LLVM > compiler 1.6, which comes as a standard compiler with the iOS SDK, and is the > direction that Apple is moving towards. > > the problem is NOT