my apprentice drove me crazy last months, because their SQL-Requests didn't fact the expected results.
Today I realized, that HeidiSQL works very, very different from users with admin-rights. (of course the Trainees have limited rights)
We have a very important database, on which i, even as admin, don't do massive inserts/updates without testing. Therefor we have a 1:1-copy for testing.
This copy contains (even as the original) a view, which does a very Long request to the ACTUALLY used db (=test). There are NO !!!!!! references to the original !
This works proper for all admins.
Today i realized, that this view won't work as proper for my Trainees, because it doesn't read from the ACTIVE db (=test), but from the original. (Their views have 'never ever programmed references')
The difference seems to be, that all admins own the view-option "Check Options for Update=None", the Trainees instead "Check Options for Update=Cascade"
Seems, they miss a right ....
Thanks in advance, Keep healthy