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); It is interesting that the .tables command show the name without the quotes: sqlite> .tables version2 My SQLite is: [root@archimed src]# sqlite3 --version 3.8.4.2 2014-03-26 18:51:19 02ea166372bdb2ef9d8dfbb05e78a97609673a8e The problems seems to be with libsqlite, because the same issue occurs when using libsqlite from a C program (code is simplified for clarity, but in reality raises no error): #include <sqlite3.h> #define DB_FILE_NAME "/tmp/some_db.sqlite"; sqlite3 *sqlite; char *zErrMsg = 0; sqlite3_open(DB_FILE_NAME, &sqlite); sqlite3_exec(sqlite, "ALTER TABLE version RENAME TO version2", some_callback, 0, &zErrMsg); sqlite3_free(zErrMsg); sqlite3_close(sqlite); Similar report abut 2 years old when using sqlite on Android - only worked around and never fixed: http://rfobasic.freeforums.org/sqlite-alter-table-t876.html Any suggestions how to remedy this issue are welcome. WWell, Assen Totin _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users