proc check failure on save

BubikolRamios posted 5 years ago in General
set a = foo + 0;

1.in case a is not declared I get error on 'save': undeclared ...
2. in case foo is not declared, save goes without any problem !

MySQL or HSQL thing ?
ansgar posted 5 years ago
If you get no error in one case, then you are suspecting HeidiSQL to supresses a message? It's very clear that the server obviously does not return some error, which makes HeidiSQL run the "Save" process without problems. Why do you suspect HeidiSQL so often for doing such weird things?
BubikolRamios posted 5 years ago
I don't know what is behind 'save', mybe some check before 'save' to db. In old mysql query browser you click execute (the script), to 'save' proc. I gues s'save' term is a bit confusing to me.
BubikolRamios posted 5 years ago
Besides, hmm in a while ago post, we figured that I can't edit proc written in mysql query browser, coz of problematic comments (eaten by mysql query browser with no problems.)

That is why, suspect (-:
kalvaro posted 5 years ago
All these things are very easy to verify. Go to "Tools->Launch command line" and run your SQL from the official command-line tool.

Please login to leave a reply, or register at first.