Hello Trudy, Konstantin,
Please see my commentary below.
Trudy Pelzer wrote:
> Hi Konstantin, Gleb,
>
> On Tuesday, July 10, 2007 2:17 AM, Konstantin Osipov wrote:
>
>> * gshchepa@stripped <gshchepa@stripped> [07/07/10 04:52]:
>>
>>> ChangeSet@stripped, 2007-07-10 05:26:54+05:00, gshchepa@stripped +7 -0
>>> Fixed bug #29338.
>>> Trivial stored functions that consist of RETURN <constant
> expression>
>>> operator was evaluated ineffectively.
>>> This type of SF may be commonly used as named constants, so
>>> optimizations
>>> is desirable.
>
> <cut>
>
>> Trudy: to me it's clearly a feature request, thus such a high
>> priority is questionable.
>> Even more questionable to push this into 5.0.
>
> I tagged the bug because the bug report says the problem
> is a regression -- although I see now that Gleb agrees
> with you that this is a feature request.
>
> Support asked us to reintroduce the original behaviour,
> since the "regression" is affecting a customer. While
> I don't advocate adding a new feature to 5.0 (or 5.1)
> at this point, I do think we should solve the problem
> the client is experiencing, if at all possible.
>
> Can the specific problem described in the client issue
> be solved fairly easily? See:
> https://support.mysql.com/view.php?id=17609
Trudy: yes, this issue duplicates bugs #29338, #21314 and #14669.
Solution is not trivial as described by Konstantin.
My current solution fix only particular issue (see #29338).
Thank you,
Gleb.
>
> <cut>
>
>
> Regards,
> Trudy
>
> ---
> Trudy Pelzer, Engineering Project Manager
> MySQL AB, www.mysql.com
> Edmonton, AB, Canada
>
> Office: +1-408-213-6600 ext 6604
> Mobile: +1-780-498-6230
> VoIP: 6604 Skype: tpelzer
> (Mountain Time Zone, UTC -7 hours)
>
> Are you MySQL certified? www.mysql.com/certification
>