[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

Re: [sqlite] DISTINCT clause bug in 3.6.4?

Hi, In case it helps, I've narrowed this down somewhat; it also happens with this far simpler query: sqlite> select b.val, case when b.val = 1 then 'xyz' else b.val end as col1 from b; val|col1 1|xyz 2|2 sqlite> select distinct b.val, case when b.val = 1 then 'xyz' else b.val end as col1 from

[sqlite] Foreign Key Constraints

Hi all, I've just joined this list hoping to learn more about SQLite. I'm using SQLite to teach the SQL portion of a college databases course. The one thing that concerns me a little is the lack of foreign key constraints. (I've been yapping about referential integrity for weeks and really