[sqlite] System.Data.SQLite version 1.0.90.0 released

2013-12-23 Thread Joe Mistachkin
System.Data.SQLite version 1.0.90.0 (with SQLite 3.8.2) is now available on the System.Data.SQLite website: http://system.data.sqlite.org/ Further information about this release can be seen at http://system.data.sqlite.org/index.html/doc/trunk/www/news.wiki Please post on the SQLite

Re: [sqlite] Bug in SQLITE regarding HAVING?

2013-12-23 Thread James K. Lowden
On Mon, 23 Dec 2013 23:50:30 +0100 "E.Pasma" wrote: > > . See if you can make the simplest possible SELECT that comes up > > with unexpected results. > > select 0 as depth > from(select 1 as depth) > group by null > having depth < 1 > ; > This returns no rows. Thus

Re: [sqlite] Bug in SQLITE regarding HAVING?

2013-12-23 Thread E.Pasma
Op 23 dec 2013, om 14:32 heeft Simon Slavin het volgende geschreven: General note: when making up a name for a calculation like 'depth', try to make sure it's not the name of any of the columns in the tables mentioned in your SELECT. This avoids ambiguity. . See if you can make the

Re: [sqlite] memcpy usage in SQLITE

2013-12-23 Thread Clemens Ladisch
jitendar kumar wrote: >Actually it has been customized in case of the memcpy() with checks for Src >= NULL and length = 0. and whever at run-time it encounters, alarm is >generated. > >So, we had a concern for future use such that any case where such condition >can occur and also segfault crash

Re: [sqlite] memcpy usage in SQLITE

2013-12-23 Thread jitendar kumar
Dear Mr Richard, DUMA is not a static analysis tool...its an open source library used to check buffer over-runs and under-runs in C and C++ programs. http://duma.sourceforge.net/ http://en.wikipedia.org/wiki/Duma_(software) Actually it has been customized in case of the memcpy() with checks for

[sqlite] Trouble with sqlite3 shell on OSX Mavericks

2013-12-23 Thread Niall O'Reilly
Hello. The demonstration script for a loadable extension I’m working on uses the sqlite3 command-line shell, and works as expected on Ubuntu. I’m at the stage of checking portability by building and demonstrating it on OSX. The shell bundled with OSX 10.9.1 (Mavericks) seems to be a custom

Re: [sqlite] Bug in SQLITE regarding HAVING?

2013-12-23 Thread Simon Slavin
On 22 Dec 2013, at 11:12pm, Tobias Steinmann wrote: > SELECT node.id,node.lft, node.rgt, (COUNT(parent.id) - (sub_tree.depth + 1)) > AS depth FROM target_directory AS node, target_directory AS parent, > target_directory AS sub_parent, (SELECT node.id,

Re: [sqlite] Does not detect invalid column name when subexpression optimized away

2013-12-23 Thread Hick Gunter
> > >-Ursprüngliche Nachricht- >Von: RSmith [mailto:rsm...@rsweb.co.za] >Gesendet: Freitag, 20. Dezember 2013 14:20 >An: General Discussion of SQLite Database >Betreff: Re: [sqlite] Does not detect invalid column name when subexpression >optimized away > > >On 2013/12/20 14:09, Simon