MySQL BUG#11748187 - 35410: STORED FUNCTION: CONFUSING 'ORDER CLAUSE' IN ERROR MESSAGE

revno: 3402.31.20

committer: Raghav Kapoor <raghav.kapoor@oracle.com>

branch nick: mysql-trunk-bug-11748187

timestamp: Fri 2011-12-09 12:25:51 +0530

message:

  BUG#11748187 - 35410: STORED FUNCTION: CONFUSING 'ORDER CLAUSE' IN ERROR MESSAGE

  BACKGROUND:

  A stored function is created that refers in the body to an

  identifier that cannot be resolved. The error message produced

  by invoking the function says something about 'order clause'.

  The function has no ORDER BY clause, nor is it invoked within

  a statement that has an ORDER BY clause.

  The error message is confusing.

  FIX:

  This bug has been fixed by explicitly resetting THD::where

  value to its default in sp_head::execute_function in sp_head.cc

  file. Also a test case has been written in sp.test and the

  corresponding result file has also been updated.