> SQLite version 3.5.6
> Enter ".help" for instructions
> sqlite> create table 'foo' (bar 'text');
> sqlite> insert into 'foo' values ('a');
> sqlite> .headers on
> sqlite> select * from foo;
> bar
> a
> sqlite> select "bar" from foo;
> bar
> a
> sqlite> select `bar` from foo;
> bar
> a
> sqlite> select `bar`,count(`bar`) as total from foo group by(`bar`);
> `bar`|total
> a|1The presence of backticks in the column header name is causing the ORB library I'm working with to think that the name of the column is "`bar`" instead of "bar". See: http://groups.google.com/group/sequel-talk/browse_frm/thread/915c6f807f6d61c1 May this properly be considered a bug in SQLite? _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
