committer: Raghav Kapoor <email@example.com>
branch nick: mysql-trunk-bug-11748187
timestamp: Fri 2011-12-09 12:25:51 +0530
BUG#11748187 - 35410: STORED FUNCTION: CONFUSING 'ORDER CLAUSE' IN ERROR MESSAGE
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.
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.
merge test cases from 5.6