diff options
| author | unknown <bell@sanja.is.com.ua> | 2005-06-14 22:45:48 +0300 |
|---|---|---|
| committer | unknown <bell@sanja.is.com.ua> | 2005-06-14 22:45:48 +0300 |
| commit | 188ac29a508c2b7711e2beac911150e1ee4bd925 (patch) | |
| tree | 245f09eed7f3ce616ac752aa5162da8e79937ba0 /sql/sp_rcontext.cc | |
| parent | 3ceb45f13b868924d1a42195b8e3c6f1fdafb7ec (diff) | |
| download | mariadb-git-188ac29a508c2b7711e2beac911150e1ee4bd925.tar.gz | |
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
Diffstat (limited to 'sql/sp_rcontext.cc')
| -rw-r--r-- | sql/sp_rcontext.cc | 11 |
1 files changed, 11 insertions, 0 deletions
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 |