Renaming Retool DB query block resets all values

Workflows
1

When I rename Retool Database resource blocks it resets everything in Changeset and Key value pairs, which can be frustrating when there are lots of required columns and/or aggregated values. I've only had it happen with Retool Database query blocks and I can only reproduce it in one workflow (I've tried after creating a new workflow and in other older pre-existing workflows, but for whatever reason this single workflow can reliably reproduce it :man_shrugging:

i'm now hesitant to rename things without duplicating the block first or taking a screenshot if I'm feeling super paranoid

Recording 2024-10-25 100921.mp4

I also noticed if you rename functions anywhere they've been referenced doesn't update (like it does when you rename a block) and since there doesn't seem to be anywhere that mentions all the blocks the function is used in it can be a bit of an easter egg hunt to find em all

2

Hey @bobthebear!

Super weird bug, when you said it was only happening in one app I thought it was gonna be hard to reproduce, but to my surprise it was very easy to :melting_face:

Just filed a bug report with an app attached reproducing the inputs getting reset when the block is renamed for Retool DB workflow blocks.

Will keep you updated on any news I hear from the team, hopefully it will be fixed soon.

On the issue of renaming functions I can also look to repro that and make a FR to add in function renaming mapping as well :saluting_face:

2 Likes
3

I'm really glad it was quick to reproduce. It's hunting down those ridiculous fringe cases that will drive the most patient of people to have a permanent creepy Joker smile. I have no clue how you managed to reproduce it so easily, I tried all sorts of combos on 3 other workflows with getting it to happen only once.... but it happens every time on that 4th workflow like clockwork.

:rofl: so just out of curiosity, what are the secret steps to avoid here?

1 Like
4

Yep hunting down Retool bugs has changed our support team :black_joker:

I was running the most up to date cloud version and made a Retool DB block, as soon as I changed the name everything in the GUI disappeared.

It seems that SQL mode does not get reset but that is super tedious to move that logic as the GUI is so nice.

Hopefully we can get this fixed ASAP as I do not know if any secret steps to keep this from happening in GUI mode with Retool DB :face_exhaling:

I am surprised you have three other workflows there it doesn't happen :skull:

5

:rofl: so an 'inverse edge case' would be a 'corner' right?

1 Like