Bug #14719 Views DEFINER grammar is incorrect
Submitted: 7 Nov 2005 20:31 Modified: 20 Nov 2005 4:31
Reporter: Paul DuBois Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Views Severity:S3 (Non-critical)
Version:5.0.13 and up OS:
Assigned to: Per-Erik Martin CPU Architecture:Any

[7 Nov 2005 20:31] Paul DuBois
Description:
5.0.13 added DEFINER support for views.  However, the grammar
is incorrect.  In sql_yacc.yy, the view_user production lists
three alternatives:

empty
CURRENT_USER[()]
DEFINER = user_name@host_name

The CURRENT_USER() alternative should be DEFINER = CURRENT_USER().

How to repeat:
Examine sql_yacc.yy.
[9 Nov 2005 15:54] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/internals/32111
[20 Nov 2005 4:31] Paul DuBois
Noted in 5.0.17 changelog.