Bug #25789 | Script editor for function uses DEFINER when shouldn't | ||
---|---|---|---|
Submitted: | 23 Jan 2007 16:02 | Modified: | 30 Jan 2007 15:56 |
Reporter: | Sebastien Caisse | Email Updates: | |
Status: | Closed | Impact on me: | |
Category: | MySQL Query Browser | Severity: | S3 (Non-critical) |
Version: | 1.0.20 | OS: | Windows (Windows XP Pro, sp2) |
Assigned to: | CPU Architecture: | Any |
[23 Jan 2007 16:02]
Sebastien Caisse
[26 Jan 2007 15:40]
Valeriy Kravchuk
What exact version of MySQL server do you use? Read the manual, http://dev.mysql.com/doc/refman/5.0/en/create-procedure.html, about DEFINER clause. I was added in 5.0.20.
[26 Jan 2007 20:16]
Sebastien Caisse
5.0.27
[30 Jan 2007 10:04]
Sveta Smirnova
Please provide the CREATE FUNCTION statement you see after click "Edit Function". Also indicate user you use to connect via MySQL Query Browser.
[30 Jan 2007 15:55]
Sebastien Caisse
After some fiddling with my files I noticed 1.1.2 was still installed and the Tray monitor was of that version and as such started the old versions of the query browser. I tried it and it works fine in the real r9 (and this explains why I didn't see the r9 in the version where I thought it simply wasn't displayed...)
[30 Jan 2007 15:56]
Sebastien Caisse
Oh and sorry for the trouble :(