How to change DEFINER

silvano · Post by **silvano** » Wed 29 Aug 2007 19:13

Hi guys,
I knew MySQL Developer Studio about one hour ago and I was playing with it and there is something that I haven't found: How do I change (or even see) the DEFINER for functions/procedures?

Also, is there any special reason to don't allow the DELIMITER in the SQL window? At least it would allow me to change the routines and set the DEFINER

Thanks in advance

Duke · Post by **Duke** » Tue 04 Sep 2007 11:14

1. We'll enable editing DEFINER in the next version.
2. DELIMITER is not supported by now, but we do allow to create scripts. For more information see "Creating and Executing SQL Statements"->"Creating Scripts" help topic.

silvano · Post by **silvano** » Tue 04 Sep 2007 13:23

Duke wrote:1. We'll enable editing DEFINER in the next version.

I appreciate it! Really do!

Duke wrote:2. DELIMITER is not supported by now, but we do allow to create scripts. For more information see "Creating and Executing SQL Statements"->"Creating Scripts" help topic.

I guess you mean: "Working with SQL Files" -> "Editing Code" -> "Creating Scripts"

You guys have a great software! The debugging is great stuff!
I really believe you guys know it but anyway, the only issue that I think you should keep in mind is to support ANY SQL statement and no matter how people wants to use it as long as it is supported by the DB syntax.
If you force people do what they don't want/have to, they will simply ignore your software and move to another one.

I.e.: Currently I have lots of functions and procedure inside SQL files where I have something like:

DELIMITER $$

CREATE DEFINER='user'@'%' FUNCTION function()
...
END$$

DELIMITER ;

And let me know if I am wrong, but I simply can't use them.
I must remove the DELIMITER lines and replace $$ by ; in all files.
So far this also means replace $ (money) I'd spend on licenses by forum posts

Anyway, it is just a simple example. I don't think there are others similar problems, but as I said, I met this software last week so I don't know.

Keep up the good work! You guys are on the right direction.

Best regards

Duke · Post by **Duke** » Tue 04 Sep 2007 14:22

the only issue that I think you should keep in mind is to support ANY SQL statement

One little remark about DELIMITER command. It is not SQL statement, MySQL server itself does not support it. It is a feature of MySQL console program. Anyway, we plan to support it.

silvano · Post by **silvano** » Tue 04 Sep 2007 14:30

Oops, you are right. Thanks for the education!

Regards