Rename Issue
Posted: Mon 03 Jul 2017 19:21
Running dbFoge 7.2.63 and had some table names that were upper case, like `Makes`, and tried to rename it to the lower case by using the rename option (right click->Refactor->Rename). After typing the lower case `makes` it give the warning beep, and reverts back.
I'm guessing it doesn't think that the name has changed and is assuming the names are case insensitive. If I first change the name to `Makes_1`, save it then change it to just `makes` it works fine.
The db server is a Linux based MySQL instance which does enforce case-SeNsIVity on table names, vs Windows MySQL which does not.
Version of MySQL 5.5.5-10.0.29-MariaDB-0ubuntu0.16.04.1
Sandy
I'm guessing it doesn't think that the name has changed and is assuming the names are case insensitive. If I first change the name to `Makes_1`, save it then change it to just `makes` it works fine.
The db server is a Linux based MySQL instance which does enforce case-SeNsIVity on table names, vs Windows MySQL which does not.
Version of MySQL 5.5.5-10.0.29-MariaDB-0ubuntu0.16.04.1
Sandy