[sqlite] Mistake in threadtest3.c

Hi, I was looking at the diff to threadtest3.c in recent commit at http://www.sqlite.org/src/fdiff?v1=58df1e3c060f534fv2=d6d209190c7110f9, and I think I may have spotted an mistake in the code at the end of the function static void dynamic_triggers(int nMs). The code here runs as follows:

Re: [sqlite] Mistake in threadtest3.c

On Nov 2, 2010, at 5:12 PM, Andy Gibbs wrote: Hi, I was looking at the diff to threadtest3.c in recent commit at http://www.sqlite.org/src/fdiff?v1=58df1e3c060f534fv2=d6d209190c7110f9 , and I think I may have spotted an mistake in the code at the end of the function static void

Re: [sqlite] Mistake in threadtest3.c

On Tuesday, November 02, 2010 11:23 AM, Dan Kennedy wrote: Fair question. But in this case no. The idea was to have one thread modifying the triggers. Then several other reader threads using the database with the reader threads using both shared and unshared caches. Then that's good.

[sqlite] 'no such column' error returned in a CASE statement

The following error 'no such column: A' is returned when i execute the following statement. SELECT 'test' as A,CASE WHEN A = 'test' THEN 'true' ELSE 'false' END as ERRVAL Is this the expected result or should the generated column be available to the case statement. Thanks. -- View this

Re: [sqlite] 'no such column' error returned in a CASE statement

This works: sqlite select a,case when a='test' then 'true' else 'false' end from (sele ct 'test' as a) as errval; test|true sqlite select a,case when a='test' then 'true' else 'false' end from (sele ct 'test2' as a) as errval; test2|false I suppose there's another solution too... Michael D.

[sqlite] R*Tree module and double precision?

Hi everyone, I want to use an R*tree table in sqlite. Unfortunately, it turned out that it saves data always as single precision (32-bit) float, no matter what type is specified. For my application, that is not precise enough. Does anyone know of an r*tree implementation for sqlite that supports

Re: [sqlite] 'no such column' error returned in a CASE statement

This works: sqlite select a,case when a='test' then 'true' else 'false' end from (sele ct 'test' as a) as errval; I guess OP meant it like this: select a,case when a='test' then 'true' else 'false' end as errval from (select 'test' as a); And to answer the question: Is this the expected

Re: [sqlite] R*Tree module and double precision?

I made a patch which seems to do this for you...once in a while it's fun to do a bit of programming like this...I didn't do extensive testing on this so you may want to do some yourself. It's going to just about double the RTREE size of course. SQLite version 3.7.3 Enter .help for

[sqlite] iPhone/iPad Database Disk Image Malformed

Hi All, My application was working fine, but now I get this message consistantly in the iPad simulator and on the device too when I try and run my updated database since iOS 4.0. My database was built on the PC and copied to the Mac and then into my xCode project which I've never had a problem

Re: [sqlite] iPhone/iPad Database Disk Image Malformed

I believe you. The main problem is in the iPad simulator... funny thing is that the same database opens fine on the iPhone device and iPhone simulator. BareFeetWare-2 wrote: Hi Ray, In reply to: My application was working fine, but now I get this message consistantly in the iPad

Re: [sqlite] iPhone/iPad Database Disk Image Malformed

On Tue, Nov 2, 2010 at 7:05 PM, Raeldor ray.pr...@gartner.com wrote: I believe you. The main problem is in the iPad simulator... funny thing is that the same database opens fine on the iPhone device and iPhone simulator. There is a bug in the iPad/iPhone simulator that causes SQLite to

Re: [sqlite] iPhone/iPad Database Disk Image Malformed

Ah, that's great to know... thank you for the link. I was going crazy trying to figure out what setting I'd screwed up. Thanks Ray On Tue, Nov 2, 2010 at 7:05 PM, Raeldor ray.pr...@gartner.com wrote: I believe you. The main problem is in the iPad simulator... funny thing is that the

[sqlite] HELP:The database disk image is malformed

Dear Sir: I am writing to enquire about a bug we found. Now the SQLITE3 database we use is version 3.6.23.1, which running in the red hat compiler and the hardware system is Linux(version 2.6).We have a problem that for select database(SQL),return The database disk image is malformed ,How to

[sqlite] sqlite from fossil

Running fossil update recently on my sqlite sources, and trying to build I get $ ./configure configure: error: configure script is out of date: configure $PACKAGE_VERSION = 3.7.3 top level VERSION file = 3.7.4 please regen with autoconf After running autoconf, I get: If I update it

Re: [sqlite] sqlite from fossil

Benjamin Peterson benja...@... writes: Running fossil update recently on my sqlite sources, and trying to build I get $ ./configure configure: error: configure script is out of date: configure $PACKAGE_VERSION = 3.7.3 top level VERSION file = 3.7.4 please regen with autoconf