The ability to dynamically specify a database (mysql) in select queries works great. However, this functionality is BROKEN in update queries. As per the image below, you can see that the 'override database name' is correctly displaying the desired value (dbName.value is 'mri_id') but then upon runing the query I get the mysql "unknown database 'undefined' error"
Looking at the mysql log I can verify that Retool is connecting without specifying a database name when running the update query.
Hi franco! It looks like you are right, I’m seeing the same result. We’ll start looking into this and keep you updated!
Any estimate on when this will be fixed?
Hi Franco!
We had some delay with the thanksgiving holiday, but I’m hoping we’ll be able to get a fix out in the next 1-2 weeks here as we are catching up