Older versions result in an SQL error:
SQLite version 3.3.13
Enter ".help" for instructions
sqlite> create table a (b);
sqlite> select max(b) as q from a where q = 1;
SQL error: misuse of aggregate:
Same on Linux, Solaris, and Win32
- Original Message
From: Daniel Zingaro <[EMAIL PRO
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 t
-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
5r0AoI/IAh8eAAMB1ui
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
4 matches
Mail list logo
