From 188ac29a508c2b7711e2beac911150e1ee4bd925 Mon Sep 17 00:00:00 2001 From: unknown Date: Tue, 14 Jun 2005 22:45:48 +0300 Subject: prohibit opening Query cache for SP cursors (BUG#9715) mysql-test/r/query_cache.result: testing cursors in SP with QC testing suspicious but working using selects in function with QC mysql-test/t/query_cache.test: testing cursors in SP with QC testing suspicious but working using selects in function with QC sql/sp_head.h: method for prohibiting of QC using SP query sql/sp_rcontext.cc: prohibit opening Query cache for SP cursors sql/sp_rcontext.h: constructor moved to .cc file to be able to use methods from lex_keeper --- sql/sp_rcontext.cc | 11 +++++++++++ 1 file changed, 11 insertions(+) (limited to 'sql/sp_rcontext.cc') diff --git a/sql/sp_rcontext.cc b/sql/sp_rcontext.cc index 61cd7a9300f..aacb9254753 100644 --- a/sql/sp_rcontext.cc +++ b/sql/sp_rcontext.cc @@ -169,6 +169,17 @@ sp_rcontext::pop_cursors(uint count) * */ +sp_cursor::sp_cursor(sp_lex_keeper *lex_keeper) + :m_lex_keeper(lex_keeper), m_prot(NULL), m_isopen(0), m_current_row(NULL) +{ + /* + currsor can't be stored in QC, so we should prevent opening QC for + try to write results which are absent. + */ + lex_keeper->disable_query_cache(); +} + + /* pre_open cursor -- cgit v1.2.1