![]()  | 
  
    MySQL 8.0.44
    
   Source Code Documentation 
   | 
 
Server_side_cursor – an interface for materialized implementation of cursors. More...
#include <sql_cursor.h>
Public Member Functions | |
| Server_side_cursor (Query_result *result_arg) | |
| virtual bool | is_open () const =0 | 
| virtual bool | open (THD *thd)=0 | 
| virtual bool | fetch (ulong num_rows)=0 | 
| virtual void | close ()=0 | 
| virtual | ~Server_side_cursor () | 
Static Public Member Functions | |
| static void * | operator new (size_t size, MEM_ROOT *mem_root, const std::nothrow_t &=std::nothrow) noexcept | 
| static void | operator delete (void *, size_t) | 
| static void | operator delete (void *, MEM_ROOT *, const std::nothrow_t &) noexcept | 
Public Attributes | |
| MEM_ROOT | mem_root {key_memory_TABLE, 1024} | 
| For allocation of Handler objects for the temporary table.  More... | |
Protected Attributes | |
| Query_arena | m_arena | 
| Query_result * | m_result | 
| Row destination used for fetch.  More... | |
Server_side_cursor – an interface for materialized implementation of cursors.
All cursors are self-contained (created in their own memory root). For that reason they must be deleted only using a pointer to Server_side_cursor, not to its base class.
      
  | 
  inline | 
      
  | 
  inlinevirtual | 
      
  | 
  pure virtual | 
Implemented in Materialized_cursor.
      
  | 
  pure virtual | 
Implemented in Materialized_cursor.
      
  | 
  pure virtual | 
Implemented in Materialized_cursor.
      
  | 
  pure virtual | 
Implemented in Materialized_cursor.
      
  | 
  inlinestaticnoexcept | 
      
  | 
  inlinestatic | 
      
  | 
  inlinestaticnoexcept | 
      
  | 
  protected | 
      
  | 
  protected | 
Row destination used for fetch.
| MEM_ROOT Server_side_cursor::mem_root {key_memory_TABLE, 1024} | 
For allocation of Handler objects for the temporary table.
The prepared statement's mem_root cannot be used, since the handler may be created and deleted several times. The execution mem_root cannot be used since creation of and retrieval from a cursor are in different executions.