Don't go too far, check out http://www.sqlite.org/lang.html
:) -Boris -- +1.604.689.0322 DeepCove Labs Ltd. 4th floor 595 Howe Street Vancouver, Canada V6C 2T5 [EMAIL PROTECTED] CONFIDENTIALITY NOTICE This email is intended only for the persons named in the message header. Unless otherwise indicated, it contains information that is private and confidential. If you have received it in error, please notify the sender and delete the entire message including any attachments. Thank you. -----Original Message----- From: Jonathan H N Chin [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 28, 2006 3:30 PM To: [email protected] Subject: Re: [sqlite] select foo,count(foo) -> segmentation fault Kurt Welgehausen <[EMAIL PROTECTED]> wrote: > No, it doesn't work ok. Count(a) (aka b) is zero, so if > the where clause were applied there would be no result. > The problem is that it's not valid sql. Version 3.3.3 > throws an error (misuse of aggregate) instead of segfaulting. Thanks. Sounds like the problem has already been fixed. Guess I'll just have to wait for debian to catch up. In the meantime I'd better look for an SQL reference... -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
smime.p7s
Description: S/MIME cryptographic signature
