MySQL Bugs: #17330: edit view refuses t open

Bug #17330	edit view refuses t open
Submitted:	12 Feb 2006 10:01	Modified:	12 Feb 2006 10:41
Reporter:	Ben Mulder	Email Updates:
Status:	Duplicate	Impact on me:	None
Category:	MySQL Query Browser	Severity:	S3 (Non-critical)
Version:	1.1.19	OS:	browse: xp db:redhat
Assigned to:		CPU Architecture:	Any

Description:
in Query browser you get an error on 
Edit View 
when the user has no home:
CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW 
works all the time, but
CREATE ALGORITHM=UNDEFINED DEFINER=`someone`@`%` SQL SECURITY DEFINER VIEW 
gives:
no argument for format '%`'

occurs when a free roaming user creates a view.

How to repeat:
log in as a free roaming user and create a view. 
try the edit view. ->error

work-around:
drag and drop in a scripttab (works fine)
and change definer in:`root`@`localhost`

Suggested fix:
has something to do with escaping the %?

Please do not submit the same bug more than once. An existing
bug report already describes this very problem. Even if you feel
that your issue is somewhat different, the resolution is likely
to be the same. Because of this, we hope you add your comments
to the original bug instead.

Thank you for your interest in MySQL.

Additional info:

Duplicate of bug #16785, already verified.