[sqlite] Why don't I get a syntax error?

Shouldn't this SQL produce a syntax error (notice the lack of a closing quote): SELECT * FROM foo WHERE a='1 SQLite doesn't seem to mind, but it doesn't return any results either. If you type that into the sqlite command line utility then it will require you to type a semicolon to end the

[sqlite] Re: [inbox] [sqlite] Future Features

At 05:41 AM 3/4/2004 -0600, TBrowder wrote: Adding a blob capability (i.e., allowing a byte string as data which is defined by length rather than null termination) I have a C++ interface class that gives you blobs in the current SQLite (2.8.8-2.8.11+) without breaking the optimization

[sqlite] Future Features

Are there any plans for: Adding a blob capability (i.e., allowing a byte string as data which is defined by length rather than null termination) Adding a hash access method (in addiiton to the btree) Adding a capability to bypass the sql layer and provide direct key-value access to