sqlite madness

throws.sql

/*
 column foo does not exist so query should throw an error
*/

-- proper error if field is not quoted
sqlite> select foo from empty;
Error: no such column: foo

-- proper error if field is escaped using brackets
sqlite> select [foo] from empty;
Error: no such column: foo

-- proper error if field is escaped using fancy quotes
sqlite> select `foo` from empty;
Error: no such column: foo

-- no error if double or single quotes are used
sqlite> select "foo" from empty;
sqlite> select 'foo' from empty;