Re: [sqlite] SQLite crashes due to invalid pointer

2010-12-12 Thread Richard Hipp
On Sun, Dec 12, 2010 at 3:28 AM, Wanadoo Hartwig < hartwig.wiesm...@wanadoo.nl> wrote: > Hi, > > sorry, but I thought that there would have been an automatic conversion to > a float. The comparison is not 1 but a floating point literal like 1.0. > I'm thinking you are making other assumptions as

Re: [sqlite] SQLite crashes due to invalid pointer

2010-12-12 Thread Wanadoo Hartwig
Hi, sorry, but I thought that there would have been an automatic conversion to a float. The comparison is not 1 but a floating point literal like 1.0. Am 12.12.2010 um 03:49 schrieb Richard Hipp: > On Sat, Dec 11, 2010 at 7:07 PM, Wanadoo Hartwig < > hartwig.wiesm...@wanadoo.nl> wrote: > >> Hi

Re: [sqlite] SQLite crashes due to invalid pointer

2010-12-11 Thread Richard Hipp
On Sat, Dec 11, 2010 at 7:07 PM, Wanadoo Hartwig < hartwig.wiesm...@wanadoo.nl> wrote: > Hi, > > take the following SQL statement: > > UPDATE tableA SET column1=(SELECT column2 FROM tableB WHERE > function1(column3) < 1 ORDER BY function1(column3) LIMIT 1); > > Actually, this statement does not ma

[sqlite] SQLite crashes due to invalid pointer

2010-12-11 Thread Wanadoo Hartwig
Hi, take the following SQL statement: UPDATE tableA SET column1=(SELECT column2 FROM tableB WHERE function1(column3) < 1 ORDER BY function1(column3) LIMIT 1); Actually, this statement does not make sense because the ORDER BY expression does not fulfill the requirements of an ORDER BY expressio