Base table moved to subtable when changing name. Resulting in future database change failures

Wappler Version: 5.4.0
Operating System: Windows 11
Server Model: node.js
Database Type: Postgres
Hosting Type: local docker

Expected behavior

Renaming a table should work without errors in Database Manager, and not cause failures for future changes related to the renamed table.

Actual behavior

The renamed base table (user) was moved under the Account table when its name was changed to “AccountUser”. Future changes, like changing the id field to AccountUserId results in an alter table error.

I can see the change and the migration file looks good. I also tried to refresh schema at Table level, DB level, and using the Refresh icon in Database Manager. I also quite Wappler, shutdown all Docker instances, and restarted.

image1187×560 27.9 KB

How to reproduce

Rename a table. Then try to make changes that could affect “relations” like updating the primary key name.

Example:

1. Have an Account table and a User table. Each with an id field as UUID type.
2. Rename User table to AccountUser.
3. Then try to change the primary key name.