Rename table not working

Issue #365 resolved
Former user created an issue

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)

  1. Pedro Albuquerque

    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.

  2. phpLiteAdmin 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).

  3. Log in to comment