This has caused me a lot of wasted time. I have code that makes changes to a database, sometimes its data, sometimes its structure but constantly it occurs that Heidi starts effectively "lying" to me about what is there and I will spin my wheels trying to figure out why my code is not working correctly when in reality Heidi is just not showing the real information.
Some times I can refresh at the database level and this will usually fix missing structure changes, like new columns being added. However when the problem is missing data I usually end up having to fully restart the program for it to acknowledge the changes.
Please look into this as this has been driving me crazy every time it happens.