On Mon, Apr 21, 2014 at 4:36 AM, Assen Totin <assen.to...@gmail.com> wrote:
> Hi, everybody, > > Found something which seems rather inconsistent and may be a bug, hence > reporting it here. > > Running a query to rename a table succeeds, but the name of the renamed > table is surrounded by double quotes. > > sqlite> .schema > CREATE TABLE version (version INT); > sqlite> ALTER TABLE version RENAME TO version2 > sqlite> .schema > CREATE TABLE "version2" (version INT); > That is correct behavior. Any identifier in SQL can be enclosed in double-quotes. -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
