Bug #13387 Stored Procedures : Error 1422 while creating function
Submitted: 21 Sep 2005 18:55 Modified: 21 Dec 2005 14:02
Reporter: musef habra Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:5.0.12 OS:Windows (XP)
Assigned to: Assigned Account CPU Architecture:Any

[21 Sep 2005 18:55] musef habra 
Description:
i have also this problem
why i cant use trascation in stored functions, it was better in old ver
i was beild beffor some functions use this way now i have to chang my functions to stored procedures
and chang all the statments which use this functions....
or still use old ver.

is that true

it was work until 5.0.6
and after that no ver can worked good

How to repeat:
try using any trascation statment in stored function
[21 Sep 2005 20:51] MySQL Verification Team 
This is the current behavior. Further explanation for at:

http://lists.mysql.com/internals/25691
http://bugs.mysql.com/bug.php?id=10015

Thank you for the bug report.
[22 Sep 2005 10:35] musef habra 
"We should not allow explicit or implicit transaction commits inside
  of stored functions or triggers (so in autocommit mode we should not
  do commits after execution of sub-statement).
  Also since we don't support nested statement transactions in 5.0,
  we shouldn't commit or rollback stmt transactions while we are inside
  stored functions or triggers. This should be fixed in later (>=5.1)
  releases."

why!

soory
i cant contented
ther is no big special defrent between functoins and procedures 
mybe triggars but functions is defrint
[22 Sep 2005 14:50] MySQL Verification Team 
Could you please provide a sample commands which shows the behavior
reported.

Thanks in advance.
[22 Oct 2005 23:00] Bugs System 
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".
[23 Oct 2005 0:11] musef habra 
i will send more
[21 Nov 2005 14:02] MySQL Verification Team 
Ok awaiting for your feedback.

Thanks
[22 Dec 2005 0:00] Bugs System 
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".