On 19-4-2019 16:19, Semih Hazar wrote:
Hi,
With 3.28.0 I'm getting an inconsistent behavior if I try to rename a table
if its name starts with "sqlite". It's not "sqlite3_" by the way, which
just gives an error since it's a reserved keyword.
After renaming, .table command shows the new name, but a select from the
table errors out. If I try to rename it again, things seems to be OK.
Please take a look at the output below which works fine with 3.24.0
SQLite version 3.28.0 2019-04-16 19:49:53
Enter ".help" for usage hints.
sqlite> CREATE TABLE "sqlite1234" ("id" integer);
sqlite> ALTER TABLE "sqlite1234" RENAME TO "User";
sqlite> SELECT * FROM "User";
Error: no such table: User
sqlite> .table
User
sqlite> SELECT * FROM sqlite_master;
table|User|User|2|CREATE TABLE "sqlite1234" ("id" integer)
sqlite> ALTER TABLE "sqlite1234" RENAME TO "User";
sqlite> SELECT * FROM "User";
sqlite>
Best Regards,
Semih Hazar
This is the same behavior as in 3.27.2:
D:\TEMP>sqlite3 temp.sqlite
SQLite version 3.27.2 2019-02-25 16:06:06
Enter ".help" for usage hints.
sqlite> CREATE TABLE "sqlite1234" ("id" integer);
sqlite> ALTER TABLE "sqlite1234" RENAME TO "User";
sqlite> SELECT * FROM "User";
Error: no such table: User
sqlite> .table
User
sqlite> SELECT * FROM sqlite_master;
table|User|User|2|CREATE TABLE "sqlite1234" ("id" integer)
sqlite> ALTER TABLE "sqlite1234" RENAME TO "User";
sqlite> SELECT * FROM "User";
sqlite>
sqlite>
sqlite> .table
User
sqlite> .schema
CREATE TABLE IF NOT EXISTS "User" ("id" integer);
sqlite>
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
