Rename table not working
Problem description: when trying to change a table name , click on the rename "button" on the database list of tables , a new form will open to insert the new name and upon clicking rename button on this new form, I get directed to an error page sugesting to report a bug
current table name planes , new table name Planes
software context: I am using sqlite3 on raspberry zero
Linux version 4.4.50+ (dc4@dc4-XPS13-9333) (gcc version 4.9.3 (crosstool-NG crosstool-ng-1.22.0-88-g8460611) ) #970 Mon Feb 20 19:12:50 GMT 2017
sqlite3 -version 3.8.7.1 2014-10-29 13:59:56 3b7b72c4685aa5cf5e675c2c47ebec10d9704221
phpliteadmin v1.9.7.1
Comments (4)
-
-
repo owner Yes, table names are case insensitive in SQL and SQlite. However, SQLite stores them case senstive and thus we display them case sensitive. So some people may want to do case sensitive renames. That's why with commit 50313cd it is now possible to to case sensitive renames in phpLiteAdmin. This feature uses our ALTER TABLE workaround that we also use to rename views and SQLite 2 tables (as this is not supported by SQLite).
-
repo owner -
assigned issue to
- changed component to ALTER TABLE
- marked as minor
-
assigned issue to
-
repo owner - changed status to resolved
Issue is solved with commit 50313cd .
- Log in to comment
This can be closes as I just found out that the problem is that table names are not case sensitive, even if they are listed with case sensitive names.