Duplicate columns in Retool Database

Hi there!

We seem to have a UI bug since quite some time, where columns suddenly appear twice in our database UI albeit they should really only exist once. When adding a row via UI we see the fields twice and they sync, but saving via UI is impossible because it will say : column "…" specified more than once. It is still possible to use as normal via SQL or AI though…

Would appreciate if someone could look into this, maybe it is a specific issue with our Database?

Thanks!

grafik

Hi @BIGstudio! Thanks for your patience, and sorry to hear you're dealing with this duplicate column issue in RetoolDB.

I noticed from your screenshot that you have named your table text - would it be possible to rename this table to something else?

From a quick repro, I found that there is a doubling of columns whenever the table name of text is used. My best guess is that the table name may be in conflict with the data type text, and this leads to RetoolDB being confused.

Renaming the table to something more specific should resolve this issue, but please let me know if it doesn't work!

I will be filing an internal bug report about this issue and let you know about future updates.

Hope this helps :slight_smile:

-Jen