Page 1 of 1
Bug when storing new procedure (v 2.0.48.1)
Posted: Mon 09 Jul 2007 21:02
by soaron
When I try to store a new procedure I catch this message:
"No database selected."
This trouble can be solved by connecting to MySQL server again and typing 'data base' parametr in connection window
Posted: Tue 10 Jul 2007 07:32
by Duke
It's restriction of MySQL server. You cannot create stored procedure unless you have specified default database for the connection.
Posted: Tue 10 Jul 2007 09:07
by soaron
I can create stored procedure in mysql consol and phpmyadmin shell without choosing database. Why it can't be done in MySQL Developer Studio?
Posted: Wed 11 Jul 2007 13:09
by Duke
It's not "general" problem. You procedure contains table references without database prefix. Earlier versions of MySQL server do not check procedure syntax at creation time, but latter versions do check it.
The problem will disappear if you specify full object names within procedure.