Re: [sqlite] Query Crashing SQLite

Zingaro <[EMAIL PROTECTED]> To: General Discussion of SQLite Database <sqlite-users@sqlite.org> Sent: Wednesday, November 26, 2008 12:18:42 PM Subject: [sqlite] Query Crashing SQLite Hi all, The following session crashes SQLite3.exe 3.6.6.2 on Windows XP: sqlite> create table a (b);

Re: [sqlite] Query Crashing SQLite

On Nov 26, 2008, at 3:18 PM, Daniel Zingaro wrote: > Hi all, > > The following session crashes SQLite3.exe 3.6.6.2 on Windows XP: > > sqlite> create table a (b); > sqlite> select max(b) as q from a where q = 1; > > SQLite prevents me from directly using max(b) in the 'where' clause, > but > I

Re: [sqlite] Query Crashing SQLite

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 John Karp wrote: > I can reproduce this on Linux, with version 3.6.5: Also present in 3.6.6.2. Roger -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.9 (GNU/Linux) iEYEARECAAYFAkkttKcACgkQmOOfHg372QQVfACfXxMgixe7jWDNqVk3KcL9fudt

Re: [sqlite] Query Crashing SQLite

I can reproduce this on Linux, with version 3.6.5: sqlite> create table a (b); sqlite> select max(b) as q from a where q = 1; Program received signal SIGSEGV, Segmentation fault. [Switching to Thread -1211238720 (LWP 8893)] 0xb7d4c567 in memcpy () from /lib/tls/libc.so.6 (gdb) bt #0 0xb7d4c567

[sqlite] Query Crashing SQLite

Hi all, The following session crashes SQLite3.exe 3.6.6.2 on Windows XP: sqlite> create table a (b); sqlite> select max(b) as q from a where q = 1; SQLite prevents me from directly using max(b) in the 'where' clause, but I think it gets fooled by the alias. Thanks, Dan