With Debian-packaged sqlite3-3.2.8-1:
$ sqlite3
SQLite version 3.2.8
Enter ".help" for instructions
sqlite> create table t (a);
sqlite> select * from (select count(a) as b from t) where b > 1;
sqlite> select count(a) as b from t where b > 1;
Segmentation fault
$
Even if what I was attempting to do is ridiculous,
perhaps sqlite should not segfault?
-jonathan
--
Jonathan H N Chin, 2 dan | deputy computer | Newton Institute, Cambridge, UK
<[EMAIL PROTECTED]> | systems mangler | tel/fax: +44 1223 767091/330508
"respondeo etsi mutabor" --Rosenstock-Huessy