Bug when storing new procedure (v 2.0.48.1)

soaron · Post by **soaron** » Mon 09 Jul 2007 21:02

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

Duke · Post by **Duke** » Tue 10 Jul 2007 07:32

It's restriction of MySQL server. You cannot create stored procedure unless you have specified default database for the connection.

soaron · Post by **soaron** » Tue 10 Jul 2007 09:07

I can create stored procedure in mysql consol and phpmyadmin shell without choosing database. Why it can't be done in MySQL Developer Studio?

Duke · Post by **Duke** » Wed 11 Jul 2007 13:09

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.