summaryrefslogtreecommitdiff
path: root/mysql-test/t/sp-code.test
Commit message (Collapse)AuthorAgeFilesLines
* Bug#19207: Final parenthesis omitted for CREATE INDEX in Stored Procedureunknown2006-07-071-0/+22
| | | | | | | | | | | | | | | | | | Wrong criteria was used to distinguish the case when there was no lookahead performed in the parser. Bug affected only statements ending in one-character token without any optional tail, like CREATE INDEX and CALL. mysql-test/r/sp-code.result: Add result for bug#19207: Final parenthesis omitted for CREATE INDEX in Stored Procedure mysql-test/t/sp-code.test: Add test case for bug#19207: Final parenthesis omitted for CREATE INDEX in Stored Procedure sql/sql_yacc.yy: Use (yychar == YYEMPTY) as the criteria of whether lookahead was not performed.
* Post-review fix for BUG#15737 (corrected typo in sp-code.test comment)unknown2006-01-301-1/+1
| | | | | mysql-test/t/sp-code.test: Corrected typo in comment.
* Fixed BUG#15737: Stored procedure optimizer bug with LEAVEunknown2006-01-251-0/+143
| | | | | | | | | | | | | | | | | | | | | | | | Second version. The problem was that the optimizer didn't work correctly with forwards jumps to "no-op" hpop and cpop instructions. Don't generate "no-op" instructions (hpop 0 and cpop 0), it isn't actually necessary. mysql-test/r/sp-code.result: Updated results for new test case (BUG#15737) mysql-test/t/sp-code.test: New test case (BUG#15737) sql/sp_head.cc: Removed backpatch methods from sp_instr_hpop/cpop, since they're not needed any more. Added more documentation to sp_head::optimize() sql/sp_head.h: Removed backpatch and opt_mark methods from sp_instr_hpop/cpop, since they're not needed any more. Added comments to optimizer methods in sp_instr. sql/sql_yacc.yy: Don't generate "no-op" hpop and cpop instructions for LEAVE, it's not necessary. Just generate them when needed.
* Removed forgotten test line in sp-code.test.unknown2005-11-181-1/+0
| | | | | | | mysql-test/r/sp-code.result: Removed forgotten test line. mysql-test/t/sp-code.test: Removed forgotten test line.
* Post-review fixes, mainly fixing all print() methods for sp_instr* classes.unknown2005-11-181-0/+50
Also added mysql-test files: include/is_debug_build.inc r/is_debug_build.require r/sp-code.result t/sp-code.test sql/sp_head.cc: Review fixes: - Some minor editorial changes - Fixed all print() methods for instructions: - reserve() enough space - check return value from reserve() - use qs_append, with length arg, whenever possible sql/sp_pcontext.cc: Review fixes. Also fixed bug in find_cursor(). sql/sp_pcontext.h: Changed parameter names (review fix). sql/sql_parse.cc: Moved comment. (Review fix) mysql-test/include/is_debug_build.inc: New BitKeeper file ``mysql-test/include/is_debug_build.inc'' mysql-test/r/is_debug_build.require: New BitKeeper file ``mysql-test/r/is_debug_build.require'' mysql-test/r/sp-code.result: New BitKeeper file ``mysql-test/r/sp-code.result'' mysql-test/t/sp-code.test: New BitKeeper file ``mysql-test/t/sp-code.test''