Zingaro <[EMAIL PROTECTED]>
To: General Discussion of SQLite Database
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);
sqlite> select max(b) as q
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
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
___
5 matches
Mail list logo