Re: [sqlite] Bug Report: Quotes added to table name after ALTER TABLE ... RENAME TO

[Richard Hipp]

On Mon, Apr 21, 2014 at 4:36 AM, Assen Totin  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

[sqlite] Bug Report: Quotes added to table name after ALTER TABLE ... RENAME TO

[Assen Totin]

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 
#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