~drizzle-trunk/drizzle/development

390.1.2 by Monty Taylor
Fixed copyright headers in drizzled/
1
/* -*- mode: c++; c-basic-offset: 2; indent-tabs-mode: nil; -*-
2
 *  vim:expandtab:shiftwidth=2:tabstop=2:smarttab:
3
 *
4
 *  Copyright (C) 2008 Sun Microsystems
5
 *
6
 *  This program is free software; you can redistribute it and/or modify
7
 *  it under the terms of the GNU General Public License as published by
8
 *  the Free Software Foundation; version 2 of the License.
9
 *
10
 *  This program is distributed in the hope that it will be useful,
11
 *  but WITHOUT ANY WARRANTY; without even the implied warranty of
12
 *  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
13
 *  GNU General Public License for more details.
14
 *
15
 *  You should have received a copy of the GNU General Public License
16
 *  along with this program; if not, write to the Free Software
17
 *  Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA  02110-1301  USA
18
 */
1 by brian
clean slate
19
520.6.4 by Monty Taylor
Moved thr_lock.h out of common_includes.
20
#ifndef DRIZZLED_HANDLER_H
21
#define DRIZZLED_HANDLER_H
1 by brian
clean slate
22
520.4.31 by Monty Taylor
Removed server_id from common_includes.
23
#include <drizzled/xid.h>
24
1 by brian
clean slate
25
/* Definitions for parameters to do with handler-routines */
26
212.4.2 by Monty Taylor
Fixed the includes in places to make the myisam header file move work.
27
#include <storage/myisam/keycache.h>
520.6.4 by Monty Taylor
Moved thr_lock.h out of common_includes.
28
#include <mysys/thr_lock.h>
520.8.3 by Monty Taylor
Moved hash back to mysys.
29
#include <mysys/hash.h>
520.8.5 by Monty Taylor
Removed sql_string and sql_list from common_includes.
30
#include <drizzled/sql_string.h>
31
#include <drizzled/sql_list.h>
575.1.3 by Monty Taylor
Moved some stuff out of handler.h.
32
#include <drizzled/handlerton.h>
33
#include <drizzled/handler_structs.h>
34
#include <drizzled/ha_statistics.h>
520.6.4 by Monty Taylor
Moved thr_lock.h out of common_includes.
35
36
/* Bits to show what an alter table will do */
37
#include <drizzled/sql_bitmap.h>
38
39
#define HA_MAX_ALTER_FLAGS 40
40
typedef Bitmap<HA_MAX_ALTER_FLAGS> HA_ALTER_FLAGS;
1 by brian
clean slate
41
42
520.1.22 by Brian Aker
Second pass of thd cleanup
43
typedef bool (*qc_engine_callback)(Session *session, char *table_key,
482 by Brian Aker
Remove uint.
44
                                      uint32_t key_length,
243.1.1 by Jay Pipes
* Pulled Object_creation_ctx and Default_creation_ctx out of mysql_priv.h
45
                                      uint64_t *engine_data);
46
1 by brian
clean slate
47
327.1.5 by Brian Aker
Refactor around classes. TABLE_LIST has been factored out of table.h
48
/* The handler for a table type.  Will be included in the Table structure */
1 by brian
clean slate
49
327.1.1 by Brian Aker
First pass in encapsulating table (it is now an object, no longer a structure).
50
class Table;
561.1.3 by Monty Taylor
Split some more things out of common_includes.h.
51
class TableList;
796 by Brian Aker
Test case fixes + TABLE_CACHE to class (will rename in manner which is NOT
52
class TABLE_SHARE;
1 by brian
clean slate
53
struct st_foreign_key_info;
54
typedef struct st_foreign_key_info FOREIGN_KEY_INFO;
584.1.13 by Monty Taylor
Split out a little more code. Removed table_list.h from common_includes.
55
struct order_st;
1 by brian
clean slate
56
57
class Item;
58
struct st_table_log_memory_entry;
59
575.4.7 by Monty Taylor
More header cleanup.
60
class LEX;
61
typedef class st_select_lex SELECT_LEX;
62
typedef class st_select_lex_unit SELECT_LEX_UNIT;
63
class Alter_info;
64
class select_result;
65
class Create_field;
66
class sys_var_str;
67
class Item_ident;
68
typedef struct st_sort_field SORT_FIELD;
69
70
typedef List<Item> List_item;
71
1 by brian
clean slate
72
typedef struct st_savepoint SAVEPOINT;
61 by Brian Aker
Conversion of handler type.
73
extern uint32_t savepoint_alloc_size;
1 by brian
clean slate
74
extern KEY_CREATE_INFO default_key_create_info;
75
76
/* Forward declaration for condition pushdown to storage engine */
77
typedef class Item COND;
78
79
typedef struct system_status_var SSV;
80
575.1.3 by Monty Taylor
Moved some stuff out of handler.h.
81
class COST_VECT;
82
482 by Brian Aker
Remove uint.
83
uint16_t &mrr_persistent_flag_storage(range_seq_t seq, uint32_t idx);
84
char* &mrr_get_ptr_by_idx(range_seq_t seq, uint32_t idx);
1 by brian
clean slate
85
482 by Brian Aker
Remove uint.
86
uint32_t calculate_key_len(Table *, uint, const unsigned char *, key_part_map);
1 by brian
clean slate
87
/*
88
  bitmap with first N+1 bits set
89
  (keypart_map for a key prefix of [0..N] keyparts)
90
*/
575.1.3 by Monty Taylor
Moved some stuff out of handler.h.
91
template<class T>
92
inline key_part_map make_keypart_map(T a)
93
{
94
  return (((key_part_map)2 << a) - 1);
95
}
96
1 by brian
clean slate
97
/*
98
  bitmap with first N bits set
99
  (keypart_map for a key prefix of [0..N-1] keyparts)
100
*/
575.1.3 by Monty Taylor
Moved some stuff out of handler.h.
101
template<class T>
102
inline key_part_map make_prev_keypart_map(T a)
103
{
104
  return (((key_part_map)1 << a) - 1);
105
}
1 by brian
clean slate
106
107
/**
108
  The handler class is the interface for dynamically loadable
109
  storage engines. Do not add ifdefs and take care when adding or
110
  changing virtual functions to avoid vtable confusion
111
112
  Functions in this class accept and return table columns data. Two data
113
  representation formats are used:
114
  1. TableRecordFormat - Used to pass [partial] table records to/from
115
     storage engine
116
117
  2. KeyTupleFormat - used to pass index search tuples (aka "keys") to
118
     storage engine. See opt_range.cc for description of this format.
119
120
  TableRecordFormat
121
  =================
122
  [Warning: this description is work in progress and may be incomplete]
123
  The table record is stored in a fixed-size buffer:
660.1.3 by Eric Herman
removed trailing whitespace with simple script:
124
1 by brian
clean slate
125
    record: null_bytes, column1_data, column2_data, ...
660.1.3 by Eric Herman
removed trailing whitespace with simple script:
126
127
  The offsets of the parts of the buffer are also fixed: every column has
1 by brian
clean slate
128
  an offset to its column{i}_data, and if it is nullable it also has its own
660.1.3 by Eric Herman
removed trailing whitespace with simple script:
129
  bit in null_bytes.
1 by brian
clean slate
130
131
  The record buffer only includes data about columns that are marked in the
132
  relevant column set (table->read_set and/or table->write_set, depending on
660.1.3 by Eric Herman
removed trailing whitespace with simple script:
133
  the situation).
1 by brian
clean slate
134
  <not-sure>It could be that it is required that null bits of non-present
135
  columns are set to 1</not-sure>
136
137
  VARIOUS EXCEPTIONS AND SPECIAL CASES
138
660.1.3 by Eric Herman
removed trailing whitespace with simple script:
139
  f the table has no nullable columns, then null_bytes is still
140
  present, its length is one byte <not-sure> which must be set to 0xFF
1 by brian
clean slate
141
  at all times. </not-sure>
660.1.3 by Eric Herman
removed trailing whitespace with simple script:
142
1 by brian
clean slate
143
  If the table has columns of type BIT, then certain bits from those columns
144
  may be stored in null_bytes as well. Grep around for Field_bit for
145
  details.
146
660.1.3 by Eric Herman
removed trailing whitespace with simple script:
147
  For blob columns (see Field_blob), the record buffer stores length of the
148
  data, following by memory pointer to the blob data. The pointer is owned
1 by brian
clean slate
149
  by the storage engine and is valid until the next operation.
150
151
  If a blob column has NULL value, then its length and blob data pointer
152
  must be set to 0.
153
*/
154
155
class handler :public Sql_alloc
156
{
157
public:
158
  typedef uint64_t Table_flags;
796 by Brian Aker
Test case fixes + TABLE_CACHE to class (will rename in manner which is NOT
159
1 by brian
clean slate
160
protected:
796 by Brian Aker
Test case fixes + TABLE_CACHE to class (will rename in manner which is NOT
161
  TABLE_SHARE *table_share;   /* The table definition */
327.1.1 by Brian Aker
First pass in encapsulating table (it is now an object, no longer a structure).
162
  Table *table;               /* The current open table */
1 by brian
clean slate
163
  Table_flags cached_table_flags;       /* Set on init() and open() */
164
165
  ha_rows estimation_rows_to_insert;
166
public:
167
  handlerton *ht;                 /* storage engine of this handler */
481 by Brian Aker
Remove all of uchar.
168
  unsigned char *ref;				/* Pointer to current row */
169
  unsigned char *dup_ref;			/* Pointer to duplicate row */
1 by brian
clean slate
170
171
  ha_statistics stats;
172
  /** MultiRangeRead-related members: */
173
  range_seq_t mrr_iter;    /* Interator to traverse the range sequence */
174
  RANGE_SEQ_IF mrr_funcs;  /* Range sequence traversal functions */
175
  HANDLER_BUFFER *multi_range_buffer; /* MRR buffer info */
482 by Brian Aker
Remove uint.
176
  uint32_t ranges_in_seq; /* Total number of ranges in the traversed sequence */
51.1.77 by Jay Pipes
Standardized TRUE/FALSE, removed/replaced DBUG symbols
177
  /* true <=> source MRR ranges and the output are ordered */
1 by brian
clean slate
178
  bool mrr_is_output_sorted;
179
51.1.77 by Jay Pipes
Standardized TRUE/FALSE, removed/replaced DBUG symbols
180
  /** true <=> we're currently traversing a range in mrr_cur_range. */
1 by brian
clean slate
181
  bool mrr_have_range;
182
  /** Current range (the one we're now returning rows from) */
183
  KEY_MULTI_RANGE mrr_cur_range;
184
185
  /** The following are for read_range() */
186
  key_range save_end_range, *end_range;
187
  KEY_PART_INFO *range_key_part;
188
  int key_compare_result_on_equal;
189
  bool eq_range;
660.1.3 by Eric Herman
removed trailing whitespace with simple script:
190
  /*
51.1.77 by Jay Pipes
Standardized TRUE/FALSE, removed/replaced DBUG symbols
191
    true <=> the engine guarantees that returned records are within the range
1 by brian
clean slate
192
    being scanned.
193
  */
194
  bool in_range_check_pushed_down;
195
482 by Brian Aker
Remove uint.
196
  uint32_t errkey;				/* Last dup key */
197
  uint32_t key_used_on_scan;
198
  uint32_t active_index;
1 by brian
clean slate
199
  /** Length of ref (1-8 or the clustered key length) */
482 by Brian Aker
Remove uint.
200
  uint32_t ref_length;
1 by brian
clean slate
201
  enum {NONE=0, INDEX, RND} inited;
202
  bool locked;
203
  bool implicit_emptied;                /* Can be !=0 only if HEAP */
204
  const Item *pushed_cond;
205
206
  Item *pushed_idx_cond;
482 by Brian Aker
Remove uint.
207
  uint32_t pushed_idx_cond_keyno;  /* The index which the above condition is for */
1 by brian
clean slate
208
209
  /**
210
    next_insert_id is the next value which should be inserted into the
211
    auto_increment column: in a inserting-multi-row statement (like INSERT
212
    SELECT), for the first row where the autoinc value is not specified by the
213
    statement, get_auto_increment() called and asked to generate a value,
214
    next_insert_id is set to the next value, then for all other rows
215
    next_insert_id is used (and increased each time) without calling
216
    get_auto_increment().
217
  */
218
  uint64_t next_insert_id;
219
  /**
220
    insert id for the current row (*autogenerated*; if not
221
    autogenerated, it's 0).
222
    At first successful insertion, this variable is stored into
520.1.21 by Brian Aker
THD -> Session rename
223
    Session::first_successful_insert_id_in_cur_stmt.
1 by brian
clean slate
224
  */
225
  uint64_t insert_id_for_cur_row;
226
  /**
227
    Interval returned by get_auto_increment() and being consumed by the
228
    inserter.
229
  */
230
  Discrete_interval auto_inc_interval_for_cur_row;
231
232
  handler(handlerton *ht_arg, TABLE_SHARE *share_arg)
233
    :table_share(share_arg), table(0),
234
    estimation_rows_to_insert(0), ht(ht_arg),
51.1.77 by Jay Pipes
Standardized TRUE/FALSE, removed/replaced DBUG symbols
235
    ref(0), in_range_check_pushed_down(false),
1 by brian
clean slate
236
    key_used_on_scan(MAX_KEY), active_index(MAX_KEY),
237
    ref_length(sizeof(my_off_t)),
137 by Brian Aker
Removed dead FT bits. Small refactoring in sql_plugin.cc
238
    inited(NONE),
51.1.77 by Jay Pipes
Standardized TRUE/FALSE, removed/replaced DBUG symbols
239
    locked(false), implicit_emptied(0),
1 by brian
clean slate
240
    pushed_cond(0), pushed_idx_cond(NULL), pushed_idx_cond_keyno(MAX_KEY),
241
    next_insert_id(0), insert_id_for_cur_row(0)
242
    {}
243
  virtual ~handler(void)
244
  {
51.1.77 by Jay Pipes
Standardized TRUE/FALSE, removed/replaced DBUG symbols
245
    assert(locked == false);
246
    /* TODO: assert(inited == NONE); */
1 by brian
clean slate
247
  }
248
  virtual handler *clone(MEM_ROOT *mem_root);
249
  /** This is called after create to allow us to set up cached variables */
250
  void init()
251
  {
252
    cached_table_flags= table_flags();
253
  }
575.1.4 by Monty Taylor
Moved implementation of some methods into handler.cc from handler.h.
254
1 by brian
clean slate
255
  /* ha_ methods: pubilc wrappers for private virtual API */
256
327.1.5 by Brian Aker
Refactor around classes. TABLE_LIST has been factored out of table.h
257
  int ha_open(Table *table, const char *name, int mode, int test_if_locked);
575.1.4 by Monty Taylor
Moved implementation of some methods into handler.cc from handler.h.
258
  int ha_index_init(uint32_t idx, bool sorted);
259
  int ha_index_end();
260
  int ha_rnd_init(bool scan);
261
  int ha_rnd_end();
1 by brian
clean slate
262
  int ha_reset();
575.1.4 by Monty Taylor
Moved implementation of some methods into handler.cc from handler.h.
263
1 by brian
clean slate
264
  /* this is necessary in many places, e.g. in HANDLER command */
575.1.4 by Monty Taylor
Moved implementation of some methods into handler.cc from handler.h.
265
  int ha_index_or_rnd_end();
266
  Table_flags ha_table_flags() const;
267
1 by brian
clean slate
268
  /**
269
    These functions represent the public interface to *users* of the
270
    handler class, hence they are *not* virtual. For the inheritance
271
    interface, see the (private) functions write_row(), update_row(),
272
    and delete_row() below.
273
  */
520.1.22 by Brian Aker
Second pass of thd cleanup
274
  int ha_external_lock(Session *session, int lock_type);
481 by Brian Aker
Remove all of uchar.
275
  int ha_write_row(unsigned char * buf);
276
  int ha_update_row(const unsigned char * old_data, unsigned char * new_data);
277
  int ha_delete_row(const unsigned char * buf);
1 by brian
clean slate
278
  void ha_release_auto_increment();
279
280
  int ha_check_for_upgrade(HA_CHECK_OPT *check_opt);
281
  /** to be actually called to get 'check()' functionality*/
520.1.22 by Brian Aker
Second pass of thd cleanup
282
  int ha_check(Session *session, HA_CHECK_OPT *check_opt);
283
  int ha_repair(Session* session, HA_CHECK_OPT* check_opt);
575.1.4 by Monty Taylor
Moved implementation of some methods into handler.cc from handler.h.
284
  void ha_start_bulk_insert(ha_rows rows);
285
  int ha_end_bulk_insert();
481 by Brian Aker
Remove all of uchar.
286
  int ha_bulk_update_row(const unsigned char *old_data, unsigned char *new_data,
482 by Brian Aker
Remove uint.
287
                         uint32_t *dup_key_found);
1 by brian
clean slate
288
  int ha_delete_all_rows();
289
  int ha_reset_auto_increment(uint64_t value);
520.1.22 by Brian Aker
Second pass of thd cleanup
290
  int ha_optimize(Session* session, HA_CHECK_OPT* check_opt);
291
  int ha_analyze(Session* session, HA_CHECK_OPT* check_opt);
292
  bool ha_check_and_repair(Session *session);
482 by Brian Aker
Remove uint.
293
  int ha_disable_indexes(uint32_t mode);
294
  int ha_enable_indexes(uint32_t mode);
200 by Brian Aker
my_bool from handler and set_var
295
  int ha_discard_or_import_tablespace(bool discard);
1 by brian
clean slate
296
  void ha_prepare_for_alter();
297
  int ha_rename_table(const char *from, const char *to);
298
  int ha_delete_table(const char *name);
299
  void ha_drop_table(const char *name);
300
327.1.5 by Brian Aker
Refactor around classes. TABLE_LIST has been factored out of table.h
301
  int ha_create(const char *name, Table *form, HA_CREATE_INFO *info);
1 by brian
clean slate
302
303
  int ha_create_handler_files(const char *name, const char *old_name,
304
                              int action_flag, HA_CREATE_INFO *info);
305
306
  void adjust_next_insert_id_after_explicit_value(uint64_t nr);
307
  int update_auto_increment();
482 by Brian Aker
Remove uint.
308
  void print_keydup_error(uint32_t key_nr, const char *msg);
1 by brian
clean slate
309
  virtual void print_error(int error, myf errflag);
310
  virtual bool get_error_message(int error, String *buf);
482 by Brian Aker
Remove uint.
311
  uint32_t get_dup_key(int error);
575.1.4 by Monty Taylor
Moved implementation of some methods into handler.cc from handler.h.
312
  virtual void change_table_ptr(Table *table_arg, TABLE_SHARE *share);
313
1 by brian
clean slate
314
  /* Estimates calculation */
53.2.32 by Monty Taylor
First large swath at getting handler stuff clean.
315
  virtual double scan_time(void)
151 by Brian Aker
Ulonglong to uint64_t
316
  { return uint64_t2double(stats.data_file_length) / IO_SIZE + 2; }
645 by Brian Aker
Cleanup unused attribute
317
  virtual double read_time(uint32_t, uint32_t ranges, ha_rows rows)
1 by brian
clean slate
318
  { return rows2double(ranges+rows); }
319
482 by Brian Aker
Remove uint.
320
  virtual double index_only_read_time(uint32_t keynr, double records);
660.1.3 by Eric Herman
removed trailing whitespace with simple script:
321
482 by Brian Aker
Remove uint.
322
  virtual ha_rows multi_range_read_info_const(uint32_t keyno, RANGE_SEQ_IF *seq,
660.1.3 by Eric Herman
removed trailing whitespace with simple script:
323
                                              void *seq_init_param,
482 by Brian Aker
Remove uint.
324
                                              uint32_t n_ranges, uint32_t *bufsz,
325
                                              uint32_t *flags, COST_VECT *cost);
326
  virtual int multi_range_read_info(uint32_t keyno, uint32_t n_ranges, uint32_t keys,
327
                                    uint32_t *bufsz, uint32_t *flags, COST_VECT *cost);
1 by brian
clean slate
328
  virtual int multi_range_read_init(RANGE_SEQ_IF *seq, void *seq_init_param,
482 by Brian Aker
Remove uint.
329
                                    uint32_t n_ranges, uint32_t mode,
1 by brian
clean slate
330
                                    HANDLER_BUFFER *buf);
331
  virtual int multi_range_read_next(char **range_info);
332
333
575.1.4 by Monty Taylor
Moved implementation of some methods into handler.cc from handler.h.
334
  virtual const key_map *keys_to_use_for_scanning();
335
  bool has_transactions();
482 by Brian Aker
Remove uint.
336
  virtual uint32_t extra_rec_buf_length() const { return 0; }
1 by brian
clean slate
337
338
  /**
339
    This method is used to analyse the error to see whether the error
340
    is ignorable or not, certain handlers can have more error that are
341
    ignorable than others. E.g. the partition handler can get inserts
342
    into a range where there is no partition and this is an ignorable
343
    error.
344
    HA_ERR_FOUND_DUP_UNIQUE is a special case in MyISAM that means the
345
    same thing as HA_ERR_FOUND_DUP_KEY but can in some cases lead to
346
    a slightly different error message.
347
  */
575.1.4 by Monty Taylor
Moved implementation of some methods into handler.cc from handler.h.
348
  virtual bool is_fatal_error(int error, uint32_t flags);
1 by brian
clean slate
349
350
  /**
351
    Number of rows in table. It will only be called if
352
    (table_flags() & (HA_HAS_RECORDS | HA_STATS_RECORDS_IS_EXACT)) != 0
353
  */
575.1.5 by Monty Taylor
Moved stuff to handlerton.cc
354
  virtual ha_rows records();
1 by brian
clean slate
355
  /**
356
    Return upper bound of current number of records in the table
357
    (max. of how many records one will retrieve when doing a full table scan)
358
    If upper bound is not known, HA_POS_ERROR should be returned as a max
359
    possible upper bound.
360
  */
361
  virtual ha_rows estimate_rows_upper_bound()
362
  { return stats.records+EXTRA_RECORDS; }
363
364
  /**
365
    Get the row type from the storage engine.  If this method returns
366
    ROW_TYPE_NOT_USED, the information in HA_CREATE_INFO should be used.
367
  */
368
  virtual enum row_type get_row_type() const { return ROW_TYPE_NOT_USED; }
369
645 by Brian Aker
Cleanup unused attribute
370
  virtual const char *index_type(uint32_t)
51.1.77 by Jay Pipes
Standardized TRUE/FALSE, removed/replaced DBUG symbols
371
  { assert(0); return "";}
1 by brian
clean slate
372
373
374
  /**
375
    Signal that the table->read_set and table->write_set table maps changed
376
    The handler is allowed to set additional bits in the above map in this
377
    call. Normally the handler should ignore all calls until we have done
378
    a ha_rnd_init() or ha_index_init(), write_row(), update_row or delete_row()
379
    as there may be several calls to this routine.
380
  */
381
  virtual void column_bitmaps_signal();
482 by Brian Aker
Remove uint.
382
  uint32_t get_index(void) const { return active_index; }
1 by brian
clean slate
383
  virtual int close(void)=0;
384
385
  /**
386
    @retval  0   Bulk update used by handler
387
    @retval  1   Bulk update not used, normal operation used
388
  */
389
  virtual bool start_bulk_update() { return 1; }
390
  /**
391
    @retval  0   Bulk delete used by handler
392
    @retval  1   Bulk delete not used, normal operation used
393
  */
394
  virtual bool start_bulk_delete() { return 1; }
395
  /**
396
    After this call all outstanding updates must be performed. The number
397
    of duplicate key errors are reported in the duplicate key parameter.
398
    It is allowed to continue to the batched update after this call, the
399
    handler has to wait until end_bulk_update with changing state.
400
401
    @param    dup_key_found       Number of duplicate keys found
402
403
    @retval  0           Success
404
    @retval  >0          Error code
405
  */
645 by Brian Aker
Cleanup unused attribute
406
  virtual int exec_bulk_update(uint32_t *)
1 by brian
clean slate
407
  {
51.1.77 by Jay Pipes
Standardized TRUE/FALSE, removed/replaced DBUG symbols
408
    assert(false);
1 by brian
clean slate
409
    return HA_ERR_WRONG_COMMAND;
410
  }
411
  /**
412
    Perform any needed clean-up, no outstanding updates are there at the
413
    moment.
414
  */
415
  virtual void end_bulk_update() { return; }
416
  /**
417
    Execute all outstanding deletes and close down the bulk delete.
418
419
    @retval 0             Success
420
    @retval >0            Error code
421
  */
422
  virtual int end_bulk_delete()
423
  {
51.1.77 by Jay Pipes
Standardized TRUE/FALSE, removed/replaced DBUG symbols
424
    assert(false);
1 by brian
clean slate
425
    return HA_ERR_WRONG_COMMAND;
426
  }
427
  /**
428
     @brief
429
     Positions an index cursor to the index specified in the handle. Fetches the
430
     row if available. If the key value is null, begin at the first key of the
431
     index.
432
  */
481 by Brian Aker
Remove all of uchar.
433
  virtual int index_read_map(unsigned char * buf, const unsigned char * key,
1 by brian
clean slate
434
                             key_part_map keypart_map,
435
                             enum ha_rkey_function find_flag)
436
  {
482 by Brian Aker
Remove uint.
437
    uint32_t key_len= calculate_key_len(table, active_index, key, keypart_map);
1 by brian
clean slate
438
    return  index_read(buf, key, key_len, find_flag);
439
  }
440
  /**
441
     @brief
442
     Positions an index cursor to the index specified in the handle. Fetches the
443
     row if available. If the key value is null, begin at the first key of the
444
     index.
445
  */
656.1.1 by Monty Taylor
OOOh doggie. Got rid of my_alloca.
446
  virtual int index_read_idx_map(unsigned char * buf, uint32_t index,
447
                                 const unsigned char * key,
1 by brian
clean slate
448
                                 key_part_map keypart_map,
449
                                 enum ha_rkey_function find_flag);
645 by Brian Aker
Cleanup unused attribute
450
  virtual int index_next(unsigned char *)
451
   { return  HA_ERR_WRONG_COMMAND; }
452
  virtual int index_prev(unsigned char *)
453
   { return  HA_ERR_WRONG_COMMAND; }
454
  virtual int index_first(unsigned char *)
455
   { return  HA_ERR_WRONG_COMMAND; }
456
  virtual int index_last(unsigned char *)
457
   { return  HA_ERR_WRONG_COMMAND; }
458
  virtual int index_next_same(unsigned char *, const unsigned char *, uint32_t);
1 by brian
clean slate
459
  /**
460
     @brief
461
     The following functions works like index_read, but it find the last
462
     row with the current key value or prefix.
463
  */
481 by Brian Aker
Remove all of uchar.
464
  virtual int index_read_last_map(unsigned char * buf, const unsigned char * key,
1 by brian
clean slate
465
                                  key_part_map keypart_map)
466
  {
482 by Brian Aker
Remove uint.
467
    uint32_t key_len= calculate_key_len(table, active_index, key, keypart_map);
1 by brian
clean slate
468
    return index_read_last(buf, key, key_len);
469
  }
470
  virtual int read_range_first(const key_range *start_key,
471
                               const key_range *end_key,
472
                               bool eq_range, bool sorted);
473
  virtual int read_range_next();
474
  int compare_key(key_range *range);
475
  int compare_key2(key_range *range);
645 by Brian Aker
Cleanup unused attribute
476
  virtual int rnd_next(unsigned char *)=0;
477
  virtual int rnd_pos(unsigned char *, unsigned char *)=0;
1 by brian
clean slate
478
  /**
479
    One has to use this method when to find
480
    random position by record as the plain
481
    position() call doesn't work for some
482
    handlers for random position.
483
  */
481 by Brian Aker
Remove all of uchar.
484
  virtual int rnd_pos_by_record(unsigned char *record);
482 by Brian Aker
Remove uint.
485
  virtual int read_first_row(unsigned char *buf, uint32_t primary_key);
1 by brian
clean slate
486
  /**
487
    The following function is only needed for tables that may be temporary
488
    tables during joins.
489
  */
645 by Brian Aker
Cleanup unused attribute
490
  virtual int restart_rnd_next(unsigned char *, unsigned char *)
491
    { return HA_ERR_WRONG_COMMAND; }
492
  virtual int rnd_same(unsigned char *, uint32_t)
493
    { return HA_ERR_WRONG_COMMAND; }
494
  virtual ha_rows records_in_range(uint32_t, key_range *, key_range *)
1 by brian
clean slate
495
    { return (ha_rows) 10; }
481 by Brian Aker
Remove all of uchar.
496
  virtual void position(const unsigned char *record)=0;
1 by brian
clean slate
497
  virtual int info(uint)=0; // see my_base.h for full description
645 by Brian Aker
Cleanup unused attribute
498
  virtual uint32_t calculate_key_hash_value(Field **)
51.1.77 by Jay Pipes
Standardized TRUE/FALSE, removed/replaced DBUG symbols
499
  { assert(0); return 0; }
645 by Brian Aker
Cleanup unused attribute
500
  virtual int extra(enum ha_extra_function)
1 by brian
clean slate
501
  { return 0; }
645 by Brian Aker
Cleanup unused attribute
502
  virtual int extra_opt(enum ha_extra_function operation, uint32_t)
1 by brian
clean slate
503
  { return extra(operation); }
504
505
  /**
506
    In an UPDATE or DELETE, if the row under the cursor was locked by another
507
    transaction, and the engine used an optimistic read of the last
508
    committed row value under the cursor, then the engine returns 1 from this
509
    function. MySQL must NOT try to update this optimistic value. If the
510
    optimistic value does not match the WHERE condition, MySQL can decide to
511
    skip over this row. Currently only works for InnoDB. This can be used to
512
    avoid unnecessary lock waits.
513
514
    If this method returns nonzero, it will also signal the storage
515
    engine that the next read will be a locking re-read of the row.
516
  */
517
  virtual bool was_semi_consistent_read() { return 0; }
518
  /**
519
    Tell the engine whether it should avoid unnecessary lock waits.
520
    If yes, in an UPDATE or DELETE, if the row under the cursor was locked
521
    by another transaction, the engine may try an optimistic read of
522
    the last committed row value under the cursor.
523
  */
524
  virtual void try_semi_consistent_read(bool) {}
53.2.32 by Monty Taylor
First large swath at getting handler stuff clean.
525
  virtual void unlock_row(void) {}
645 by Brian Aker
Cleanup unused attribute
526
  virtual int start_stmt(Session *, thr_lock_type)
53.2.32 by Monty Taylor
First large swath at getting handler stuff clean.
527
  {return 0;}
1 by brian
clean slate
528
  virtual void get_auto_increment(uint64_t offset, uint64_t increment,
529
                                  uint64_t nb_desired_values,
530
                                  uint64_t *first_value,
531
                                  uint64_t *nb_reserved_values);
532
  void set_next_insert_id(uint64_t id)
533
  {
534
    next_insert_id= id;
535
  }
536
  void restore_auto_increment(uint64_t prev_insert_id)
537
  {
538
    /*
539
      Insertion of a row failed, re-use the lastly generated auto_increment
540
      id, for the next row. This is achieved by resetting next_insert_id to
541
      what it was before the failed insertion (that old value is provided by
542
      the caller). If that value was 0, it was the first row of the INSERT;
543
      then if insert_id_for_cur_row contains 0 it means no id was generated
544
      for this first row, so no id was generated since the INSERT started, so
545
      we should set next_insert_id to 0; if insert_id_for_cur_row is not 0, it
546
      is the generated id of the first and failed row, so we use it.
547
    */
548
    next_insert_id= (prev_insert_id > 0) ? prev_insert_id :
549
      insert_id_for_cur_row;
550
  }
551
645 by Brian Aker
Cleanup unused attribute
552
  virtual void update_create_info(HA_CREATE_INFO *) {}
53.2.32 by Monty Taylor
First large swath at getting handler stuff clean.
553
  int check_old_types(void);
645 by Brian Aker
Cleanup unused attribute
554
  virtual int assign_to_keycache(Session*, HA_CHECK_OPT *)
1 by brian
clean slate
555
  { return HA_ADMIN_NOT_IMPLEMENTED; }
556
  /* end of the list of admin commands */
557
558
  virtual int indexes_are_disabled(void) {return 0;}
559
  virtual char *update_table_comment(const char * comment)
560
  { return (char*) comment;}
645 by Brian Aker
Cleanup unused attribute
561
  virtual void append_create_info(String *)
53.2.32 by Monty Taylor
First large swath at getting handler stuff clean.
562
  {}
1 by brian
clean slate
563
  /**
564
      If index == MAX_KEY then a check for table is made and if index <
565
      MAX_KEY then a check is made if the table has foreign keys and if
566
      a foreign key uses this index (and thus the index cannot be dropped).
567
568
    @param  index            Index to check if foreign key uses it
569
51.1.77 by Jay Pipes
Standardized TRUE/FALSE, removed/replaced DBUG symbols
570
    @retval   true            Foreign key defined on table or index
571
    @retval   false           No foreign key defined
1 by brian
clean slate
572
  */
645 by Brian Aker
Cleanup unused attribute
573
  virtual bool is_fk_defined_on_table_or_index(uint32_t)
51.1.77 by Jay Pipes
Standardized TRUE/FALSE, removed/replaced DBUG symbols
574
  { return false; }
53.2.32 by Monty Taylor
First large swath at getting handler stuff clean.
575
  virtual char* get_foreign_key_create_info(void)
1 by brian
clean slate
576
  { return(NULL);}  /* gets foreign key create string from InnoDB */
327.1.5 by Brian Aker
Refactor around classes. TABLE_LIST has been factored out of table.h
577
  /** used in ALTER Table; 1 if changing storage engine is allowed */
53.2.32 by Monty Taylor
First large swath at getting handler stuff clean.
578
  virtual bool can_switch_engines(void) { return 1; }
1 by brian
clean slate
579
  /** used in REPLACE; is > 0 if table is referred by a FOREIGN KEY */
645 by Brian Aker
Cleanup unused attribute
580
  virtual int get_foreign_key_list(Session *, List<FOREIGN_KEY_INFO> *)
1 by brian
clean slate
581
  { return 0; }
482 by Brian Aker
Remove uint.
582
  virtual uint32_t referenced_by_foreign_key() { return 0;}
1 by brian
clean slate
583
  virtual void init_table_handle_for_HANDLER()
584
  { return; }       /* prepare InnoDB for HANDLER */
645 by Brian Aker
Cleanup unused attribute
585
  virtual void free_foreign_key_create_info(char *) {}
1 by brian
clean slate
586
  /** The following can be called without an open handler */
587
  virtual const char *table_type() const =0;
588
  /**
589
    If frm_error() is called then we will use this to find out what file
590
    extentions exist for the storage engine. This is also used by the default
591
    rename_table and delete_table method in handler.cc.
592
593
    For engines that have two file name extentions (separate meta/index file
594
    and data file), the order of elements is relevant. First element of engine
595
    file name extentions array should be meta/index file extention. Second
596
    element - data file extention. This order is assumed by
327.1.5 by Brian Aker
Refactor around classes. TABLE_LIST has been factored out of table.h
597
    prepare_for_repair() when REPAIR Table ... USE_FRM is issued.
1 by brian
clean slate
598
  */
599
  virtual const char **bas_ext() const =0;
600
645 by Brian Aker
Cleanup unused attribute
601
  virtual int get_default_no_partitions(HA_CREATE_INFO *) { return 1;}
602
  virtual bool get_no_parts(const char *, uint32_t *no_parts)
1 by brian
clean slate
603
  {
604
    *no_parts= 0;
605
    return 0;
606
  }
607
482 by Brian Aker
Remove uint.
608
  virtual uint32_t index_flags(uint32_t idx, uint32_t part, bool all_parts) const =0;
1 by brian
clean slate
609
645 by Brian Aker
Cleanup unused attribute
610
  virtual int add_index(Table *, KEY *, uint32_t)
611
  { return (HA_ERR_WRONG_COMMAND); }
612
  virtual int prepare_drop_index(Table *, uint32_t *, uint32_t)
613
  { return (HA_ERR_WRONG_COMMAND); }
614
  virtual int final_drop_index(Table *)
1 by brian
clean slate
615
  { return (HA_ERR_WRONG_COMMAND); }
616
482 by Brian Aker
Remove uint.
617
  uint32_t max_record_length() const
398.1.4 by Monty Taylor
Renamed max/min.
618
  { return cmin((unsigned int)HA_MAX_REC_LENGTH, max_supported_record_length()); }
482 by Brian Aker
Remove uint.
619
  uint32_t max_keys() const
398.1.4 by Monty Taylor
Renamed max/min.
620
  { return cmin((unsigned int)MAX_KEY, max_supported_keys()); }
482 by Brian Aker
Remove uint.
621
  uint32_t max_key_parts() const
398.1.4 by Monty Taylor
Renamed max/min.
622
  { return cmin((unsigned int)MAX_REF_PARTS, max_supported_key_parts()); }
482 by Brian Aker
Remove uint.
623
  uint32_t max_key_length() const
398.1.4 by Monty Taylor
Renamed max/min.
624
  { return cmin((unsigned int)MAX_KEY_LENGTH, max_supported_key_length()); }
482 by Brian Aker
Remove uint.
625
  uint32_t max_key_part_length(void) const
398.1.4 by Monty Taylor
Renamed max/min.
626
  { return cmin((unsigned int)MAX_KEY_LENGTH, max_supported_key_part_length()); }
1 by brian
clean slate
627
482 by Brian Aker
Remove uint.
628
  virtual uint32_t max_supported_record_length(void) const
53.2.32 by Monty Taylor
First large swath at getting handler stuff clean.
629
  { return HA_MAX_REC_LENGTH; }
482 by Brian Aker
Remove uint.
630
  virtual uint32_t max_supported_keys(void) const { return 0; }
631
  virtual uint32_t max_supported_key_parts(void) const { return MAX_REF_PARTS; }
632
  virtual uint32_t max_supported_key_length(void) const { return MAX_KEY_LENGTH; }
633
  virtual uint32_t max_supported_key_part_length(void) const { return 255; }
645 by Brian Aker
Cleanup unused attribute
634
  virtual uint32_t min_record_length(uint32_t) const
53.2.32 by Monty Taylor
First large swath at getting handler stuff clean.
635
  { return 1; }
1 by brian
clean slate
636
53.2.32 by Monty Taylor
First large swath at getting handler stuff clean.
637
  virtual bool low_byte_first(void) const { return 1; }
482 by Brian Aker
Remove uint.
638
  virtual uint32_t checksum(void) const { return 0; }
53.2.32 by Monty Taylor
First large swath at getting handler stuff clean.
639
  virtual bool is_crashed(void) const  { return 0; }
640
  virtual bool auto_repair(void) const { return 0; }
1 by brian
clean slate
641
642
643
#define CHF_CREATE_FLAG 0
644
#define CHF_DELETE_FLAG 1
645
#define CHF_RENAME_FLAG 2
646
647
648
  /**
649
    @note lock_count() can return > 1 if the table is MERGE or partitioned.
650
  */
482 by Brian Aker
Remove uint.
651
  virtual uint32_t lock_count(void) const { return 1; }
1 by brian
clean slate
652
  /**
653
    Is not invoked for non-transactional temporary tables.
654
655
    @note store_lock() can return more than one lock if the table is MERGE
656
    or partitioned.
657
658
    @note that one can NOT rely on table->in_use in store_lock().  It may
659
    refer to a different thread if called from mysql_lock_abort_for_thread().
660
661
    @note If the table is MERGE, store_lock() can return less locks
662
    than lock_count() claimed. This can happen when the MERGE children
663
    are not attached when this is called from another thread.
664
  */
520.1.22 by Brian Aker
Second pass of thd cleanup
665
  virtual THR_LOCK_DATA **store_lock(Session *session,
1 by brian
clean slate
666
                                     THR_LOCK_DATA **to,
667
                                     enum thr_lock_type lock_type)=0;
668
669
  /** Type of table for caching query */
206 by Brian Aker
Removed final uint dead types.
670
  virtual uint8_t table_cache_type() { return HA_CACHE_TBL_NONTRANSACT; }
1 by brian
clean slate
671
672
673
  /**
674
    @brief Register a named table with a call back function to the query cache.
675
520.1.22 by Brian Aker
Second pass of thd cleanup
676
    @param session The thread handle
1 by brian
clean slate
677
    @param table_key A pointer to the table name in the table cache
678
    @param key_length The length of the table name
679
    @param[out] engine_callback The pointer to the storage engine call back
680
      function
681
    @param[out] engine_data Storage engine specific data which could be
682
      anything
683
684
    This method offers the storage engine, the possibility to store a reference
660.1.3 by Eric Herman
removed trailing whitespace with simple script:
685
    to a table name which is going to be used with query cache.
1 by brian
clean slate
686
    The method is called each time a statement is written to the cache and can
687
    be used to verify if a specific statement is cachable. It also offers
688
    the possibility to register a generic (but static) call back function which
689
    is called each time a statement is matched against the query cache.
690
691
    @note If engine_data supplied with this function is different from
692
      engine_data supplied with the callback function, and the callback returns
51.1.77 by Jay Pipes
Standardized TRUE/FALSE, removed/replaced DBUG symbols
693
      false, a table invalidation on the current table will occur.
1 by brian
clean slate
694
695
    @return Upon success the engine_callback will point to the storage engine
696
      call back function, if any, and engine_data will point to any storage
697
      engine data used in the specific implementation.
51.1.77 by Jay Pipes
Standardized TRUE/FALSE, removed/replaced DBUG symbols
698
      @retval true Success
699
      @retval false The specified table or current statement should not be
1 by brian
clean slate
700
        cached
701
  */
702
200 by Brian Aker
my_bool from handler and set_var
703
  virtual bool
645 by Brian Aker
Cleanup unused attribute
704
    register_query_cache_table(Session *, char *, uint32_t,
53.2.32 by Monty Taylor
First large swath at getting handler stuff clean.
705
                               qc_engine_callback *engine_callback,
645 by Brian Aker
Cleanup unused attribute
706
                               uint64_t *)
1 by brian
clean slate
707
  {
708
    *engine_callback= 0;
51.1.77 by Jay Pipes
Standardized TRUE/FALSE, removed/replaced DBUG symbols
709
    return true;
1 by brian
clean slate
710
  }
711
712
713
 /*
51.1.77 by Jay Pipes
Standardized TRUE/FALSE, removed/replaced DBUG symbols
714
   @retval true   Primary key (if there is one) is clustered
1 by brian
clean slate
715
                  key covering all fields
51.1.77 by Jay Pipes
Standardized TRUE/FALSE, removed/replaced DBUG symbols
716
   @retval false  otherwise
1 by brian
clean slate
717
 */
51.1.77 by Jay Pipes
Standardized TRUE/FALSE, removed/replaced DBUG symbols
718
 virtual bool primary_key_is_clustered() { return false; }
481 by Brian Aker
Remove all of uchar.
719
 virtual int cmp_ref(const unsigned char *ref1, const unsigned char *ref2)
1 by brian
clean slate
720
 {
721
   return memcmp(ref1, ref2, ref_length);
722
 }
723
724
 /*
725
   Condition pushdown to storage engines
726
 */
727
728
 /**
729
   Push condition down to the table handler.
730
731
   @param  cond   Condition to be pushed. The condition tree must not be
732
                  modified by the by the caller.
733
734
   @return
735
     The 'remainder' condition that caller must use to filter out records.
736
     NULL means the handler will not return rows that do not match the
737
     passed condition.
738
739
   @note
740
   The pushed conditions form a stack (from which one can remove the
741
   last pushed condition using cond_pop).
660.1.3 by Eric Herman
removed trailing whitespace with simple script:
742
   The table handler filters out rows using (pushed_cond1 AND pushed_cond2
1 by brian
clean slate
743
   AND ... AND pushed_condN)
744
   or less restrictive condition, depending on handler's capabilities.
745
746
   handler->ha_reset() call empties the condition stack.
747
   Calls to rnd_init/rnd_end, index_init/index_end etc do not affect the
748
   condition stack.
660.1.3 by Eric Herman
removed trailing whitespace with simple script:
749
 */
1 by brian
clean slate
750
 virtual const COND *cond_push(const COND *cond) { return cond; }
53.2.32 by Monty Taylor
First large swath at getting handler stuff clean.
751
1 by brian
clean slate
752
 /**
753
   Pop the top condition from the condition stack of the handler instance.
754
755
   Pops the top if condition stack, if stack is not empty.
756
 */
53.2.32 by Monty Taylor
First large swath at getting handler stuff clean.
757
 virtual void cond_pop(void) { return; }
1 by brian
clean slate
758
645 by Brian Aker
Cleanup unused attribute
759
 virtual Item *idx_cond_push(uint32_t, Item *idx_cond)
53.2.32 by Monty Taylor
First large swath at getting handler stuff clean.
760
 { return idx_cond; }
1 by brian
clean slate
761
762
 /*
763
    Part of old fast alter table, to be depricated
764
  */
53.2.32 by Monty Taylor
First large swath at getting handler stuff clean.
765
 virtual bool
645 by Brian Aker
Cleanup unused attribute
766
   check_if_incompatible_data(HA_CREATE_INFO *, uint32_t)
1 by brian
clean slate
767
 { return COMPATIBLE_DATA_NO; }
768
327.1.5 by Brian Aker
Refactor around classes. TABLE_LIST has been factored out of table.h
769
 /* On-line ALTER Table interface */
1 by brian
clean slate
770
771
 /**
772
    Check if a storage engine supports a particular alter table on-line
773
774
    @param    altered_table     A temporary table show what table is to
775
                                change to
776
    @param    create_info       Information from the parsing phase about new
777
                                table properties.
778
    @param    alter_flags       Bitmask that shows what will be changed
779
    @param    table_changes     Shows if table layout has changed (for
780
                                backwards compatibility with
781
                                check_if_incompatible_data
782
783
    @retval   HA_ALTER_ERROR                Unexpected error
784
    @retval   HA_ALTER_SUPPORTED_WAIT_LOCK  Supported, but requires DDL lock
785
    @retval   HA_ALTER_SUPPORTED_NO_LOCK    Supported
786
    @retval   HA_ALTER_NOT_SUPPORTED        Not supported
787
788
    @note
789
      The default implementation is implemented to support fast
790
      alter table (storage engines that support some changes by
791
      just changing the frm file) without any change in the handler
53.2.32 by Monty Taylor
First large swath at getting handler stuff clean.
792
      implementation.
1 by brian
clean slate
793
 */
645 by Brian Aker
Cleanup unused attribute
794
 virtual int check_if_supported_alter(Table *, HA_CREATE_INFO *create_info,
795
                                      HA_ALTER_FLAGS * alter_flags, uint32_t table_changes)
1 by brian
clean slate
796
 {
797
   if (this->check_if_incompatible_data(create_info, table_changes)
798
       == COMPATIBLE_DATA_NO)
51.1.77 by Jay Pipes
Standardized TRUE/FALSE, removed/replaced DBUG symbols
799
     return(HA_ALTER_NOT_SUPPORTED);
383.7.1 by Andrey Zhakov
Initial submit of code and tests
800
   else if ((*alter_flags & HA_ALTER_STORED_VCOL).is_set())
801
     return(HA_ALTER_NOT_SUPPORTED);
1 by brian
clean slate
802
   else
51.1.77 by Jay Pipes
Standardized TRUE/FALSE, removed/replaced DBUG symbols
803
     return(HA_ALTER_SUPPORTED_WAIT_LOCK);
1 by brian
clean slate
804
 }
805
 /**
806
   Tell storage engine to prepare for the on-line alter table (pre-alter)
807
520.1.22 by Brian Aker
Second pass of thd cleanup
808
   @param     session               The thread handle
1 by brian
clean slate
809
   @param     altered_table     A temporary table show what table is to
810
                                change to
811
   @param     alter_info        Storage place for data used during phase1
812
                                and phase2
813
   @param     alter_flags       Bitmask that shows what will be changed
814
815
   @retval   0      OK
816
   @retval   error  error code passed from storage engine
817
 */
645 by Brian Aker
Cleanup unused attribute
818
 virtual int alter_table_phase1(Session *, Table *, HA_CREATE_INFO *, HA_ALTER_INFO *,
819
                                HA_ALTER_FLAGS *)
1 by brian
clean slate
820
 {
821
   return HA_ERR_UNSUPPORTED;
822
 }
823
 /**
824
    Tell storage engine to perform the on-line alter table (alter)
825
520.1.22 by Brian Aker
Second pass of thd cleanup
826
    @param    session               The thread handle
1 by brian
clean slate
827
    @param    altered_table     A temporary table show what table is to
828
                                change to
829
    @param    alter_info        Storage place for data used during phase1
830
                                and phase2
831
    @param    alter_flags       Bitmask that shows what will be changed
832
833
    @retval  0      OK
834
    @retval  error  error code passed from storage engine
835
836
    @note
837
      If check_if_supported_alter returns HA_ALTER_SUPPORTED_WAIT_LOCK
838
      this call is to be wrapped with a DDL lock. This is currently NOT
839
      supported.
840
 */
645 by Brian Aker
Cleanup unused attribute
841
 virtual int alter_table_phase2(Session *, Table *, HA_CREATE_INFO *, HA_ALTER_INFO *,
842
                                HA_ALTER_FLAGS *)
1 by brian
clean slate
843
 {
844
   return HA_ERR_UNSUPPORTED;
845
 }
846
 /**
847
    Tell storage engine that changed frm file is now on disk and table
848
    has been re-opened (post-alter)
849
520.1.22 by Brian Aker
Second pass of thd cleanup
850
    @param    session               The thread handle
1 by brian
clean slate
851
    @param    table             The altered table, re-opened
852
 */
645 by Brian Aker
Cleanup unused attribute
853
 virtual int alter_table_phase3(Session *, Table *)
1 by brian
clean slate
854
 {
855
   return HA_ERR_UNSUPPORTED;
856
 }
857
858
  /**
859
    use_hidden_primary_key() is called in case of an update/delete when
860
    (table_flags() and HA_PRIMARY_KEY_REQUIRED_FOR_DELETE) is defined
861
    but we don't have a primary key
862
  */
863
  virtual void use_hidden_primary_key();
864
865
  /**
866
    Lock table.
867
520.1.22 by Brian Aker
Second pass of thd cleanup
868
    @param    session                     Thread handle
1 by brian
clean slate
869
    @param    lock_type               HA_LOCK_IN_SHARE_MODE     (F_RDLCK)
870
                                      HA_LOCK_IN_EXCLUSIVE_MODE (F_WRLCK)
871
    @param    lock_timeout            -1 default timeout
872
                                      0  no wait
873
                                      >0 wait timeout in milliseconds.
874
875
   @note
876
      lock_timeout >0 is not used by MySQL currently. If the storage
877
      engine does not support NOWAIT (lock_timeout == 0) it should
878
      return an error. But if it does not support WAIT X (lock_timeout
879
      >0) it should treat it as lock_timeout == -1 and wait a default
880
      (or even hard-coded) timeout.
881
882
    @retval HA_ERR_WRONG_COMMAND      Storage engine does not support
883
                                      lock_table()
884
    @retval HA_ERR_UNSUPPORTED        Storage engine does not support NOWAIT
885
    @retval HA_ERR_LOCK_WAIT_TIMEOUT  Lock request timed out or
886
                                      lock conflict with NOWAIT option
887
    @retval HA_ERR_LOCK_DEADLOCK      Deadlock detected
888
  */
645 by Brian Aker
Cleanup unused attribute
889
  virtual int lock_table(Session *, int, int)
1 by brian
clean slate
890
  {
891
    return HA_ERR_WRONG_COMMAND;
892
  }
383.7.1 by Andrey Zhakov
Initial submit of code and tests
893
  /*
894
    This procedure defines if the storage engine supports virtual columns.
895
    Default false means "not supported".
896
  */
660.1.3 by Eric Herman
removed trailing whitespace with simple script:
897
  virtual bool check_if_supported_virtual_columns(void)
383.7.1 by Andrey Zhakov
Initial submit of code and tests
898
  { return false; }
1 by brian
clean slate
899
900
protected:
901
  /* Service methods for use by storage engines. */
902
  void ha_statistic_increment(ulong SSV::*offset) const;
520.1.21 by Brian Aker
THD -> Session rename
903
  void **ha_data(Session *) const;
520.1.22 by Brian Aker
Second pass of thd cleanup
904
  Session *ha_session(void) const;
1 by brian
clean slate
905
906
  /**
907
    Default rename_table() and delete_table() rename/delete files with a
908
    given name and extensions from bas_ext().
909
910
    These methods can be overridden, but their default implementation
911
    provide useful functionality.
912
  */
913
  virtual int rename_table(const char *from, const char *to);
914
  /**
915
    Delete a table in the engine. Called for base as well as temporary
916
    tables.
917
  */
918
  virtual int delete_table(const char *name);
919
920
private:
921
  /* Private helpers */
922
  inline void mark_trx_read_write();
923
private:
924
  /*
925
    Low-level primitives for storage engines.  These should be
926
    overridden by the storage engine class. To call these methods, use
927
    the corresponding 'ha_*' method above.
928
  */
929
482 by Brian Aker
Remove uint.
930
  virtual int open(const char *name, int mode, uint32_t test_if_locked)=0;
645 by Brian Aker
Cleanup unused attribute
931
  virtual int index_init(uint32_t idx, bool)
53.2.32 by Monty Taylor
First large swath at getting handler stuff clean.
932
  { active_index= idx; return 0; }
1 by brian
clean slate
933
  virtual int index_end() { active_index= MAX_KEY; return 0; }
934
  /**
935
    rnd_init() can be called two times without rnd_end() in between
936
    (it only makes sense if scan=1).
937
    then the second call should prepare for the new table scan (e.g
938
    if rnd_init allocates the cursor, second call should position it
939
    to the start of the table, no need to deallocate and allocate it again
940
  */
941
  virtual int rnd_init(bool scan)= 0;
942
  virtual int rnd_end() { return 0; }
645 by Brian Aker
Cleanup unused attribute
943
  virtual int write_row(unsigned char *)
944
  {
945
    return HA_ERR_WRONG_COMMAND;
946
  }
947
948
  virtual int update_row(const unsigned char *, unsigned char *)
949
  {
950
    return HA_ERR_WRONG_COMMAND;
951
  }
952
953
  virtual int delete_row(const unsigned char *)
1 by brian
clean slate
954
  {
955
    return HA_ERR_WRONG_COMMAND;
956
  }
957
  /**
958
    Reset state of file to after 'open'.
959
    This function is called after every statement for all tables used
960
    by that statement.
961
  */
962
  virtual int reset() { return 0; }
963
  virtual Table_flags table_flags(void) const= 0;
964
965
  /**
966
    Is not invoked for non-transactional temporary tables.
967
968
    Tells the storage engine that we intend to read or write data
969
    from the table. This call is prefixed with a call to handler::store_lock()
970
    and is invoked only for those handler instances that stored the lock.
971
972
    Calls to rnd_init/index_init are prefixed with this call. When table
973
    IO is complete, we call external_lock(F_UNLCK).
974
    A storage engine writer should expect that each call to
975
    ::external_lock(F_[RD|WR]LOCK is followed by a call to
976
    ::external_lock(F_UNLCK). If it is not, it is a bug in MySQL.
977
978
    The name and signature originate from the first implementation
979
    in MyISAM, which would call fcntl to set/clear an advisory
980
    lock on the data file in this method.
981
982
    @param   lock_type    F_RDLCK, F_WRLCK, F_UNLCK
983
984
    @return  non-0 in case of failure, 0 in case of success.
985
    When lock_type is F_UNLCK, the return value is ignored.
986
  */
645 by Brian Aker
Cleanup unused attribute
987
  virtual int external_lock(Session *, int)
1 by brian
clean slate
988
  {
989
    return 0;
990
  }
53.2.32 by Monty Taylor
First large swath at getting handler stuff clean.
991
  virtual void release_auto_increment(void) { return; };
1 by brian
clean slate
992
  /** admin commands - called from mysql_admin_table */
645 by Brian Aker
Cleanup unused attribute
993
  virtual int check_for_upgrade(HA_CHECK_OPT *)
1 by brian
clean slate
994
  { return 0; }
645 by Brian Aker
Cleanup unused attribute
995
  virtual int check(Session *, HA_CHECK_OPT *)
1 by brian
clean slate
996
  { return HA_ADMIN_NOT_IMPLEMENTED; }
997
998
  /**
999
     In this method check_opt can be modified
1000
     to specify CHECK option to use to call check()
1001
     upon the table.
1002
  */
645 by Brian Aker
Cleanup unused attribute
1003
  virtual int repair(Session *, HA_CHECK_OPT *)
1 by brian
clean slate
1004
  { return HA_ADMIN_NOT_IMPLEMENTED; }
645 by Brian Aker
Cleanup unused attribute
1005
  virtual void start_bulk_insert(ha_rows)
53.2.32 by Monty Taylor
First large swath at getting handler stuff clean.
1006
  {}
1007
  virtual int end_bulk_insert(void) { return 0; }
660.1.3 by Eric Herman
removed trailing whitespace with simple script:
1008
  virtual int index_read(unsigned char *, const unsigned char *,
645 by Brian Aker
Cleanup unused attribute
1009
                         uint32_t, enum ha_rkey_function)
1 by brian
clean slate
1010
   { return  HA_ERR_WRONG_COMMAND; }
645 by Brian Aker
Cleanup unused attribute
1011
  virtual int index_read_last(unsigned char *, const unsigned char *, uint32_t)
1 by brian
clean slate
1012
   { return (my_errno= HA_ERR_WRONG_COMMAND); }
1013
  /**
1014
    This method is similar to update_row, however the handler doesn't need
1015
    to execute the updates at this point in time. The handler can be certain
1016
    that another call to bulk_update_row will occur OR a call to
1017
    exec_bulk_update before the set of updates in this query is concluded.
1018
1019
    @param    old_data       Old record
1020
    @param    new_data       New record
1021
    @param    dup_key_found  Number of duplicate keys found
1022
1023
    @retval  0   Bulk delete used by handler
1024
    @retval  1   Bulk delete not used, normal operation used
1025
  */
645 by Brian Aker
Cleanup unused attribute
1026
  virtual int bulk_update_row(const unsigned char *, unsigned char *, uint32_t *)
1 by brian
clean slate
1027
  {
51.1.77 by Jay Pipes
Standardized TRUE/FALSE, removed/replaced DBUG symbols
1028
    assert(false);
1 by brian
clean slate
1029
    return HA_ERR_WRONG_COMMAND;
1030
  }
1031
  /**
1032
    This is called to delete all rows in a table
1033
    If the handler don't support this, then this function will
1034
    return HA_ERR_WRONG_COMMAND and MySQL will delete the rows one
1035
    by one.
1036
  */
53.2.32 by Monty Taylor
First large swath at getting handler stuff clean.
1037
  virtual int delete_all_rows(void)
1 by brian
clean slate
1038
  { return (my_errno=HA_ERR_WRONG_COMMAND); }
1039
  /**
1040
    Reset the auto-increment counter to the given value, i.e. the next row
1041
    inserted will get the given value. This is called e.g. after TRUNCATE
1042
    is emulated by doing a 'DELETE FROM t'. HA_ERR_WRONG_COMMAND is
1043
    returned by storage engines that don't support this operation.
1044
  */
645 by Brian Aker
Cleanup unused attribute
1045
  virtual int reset_auto_increment(uint64_t)
53.2.32 by Monty Taylor
First large swath at getting handler stuff clean.
1046
  { return HA_ERR_WRONG_COMMAND; }
645 by Brian Aker
Cleanup unused attribute
1047
  virtual int optimize(Session *, HA_CHECK_OPT *)
1048
  { return HA_ADMIN_NOT_IMPLEMENTED; }
1049
  virtual int analyze(Session *, HA_CHECK_OPT *)
1050
  { return HA_ADMIN_NOT_IMPLEMENTED; }
1051
  virtual bool check_and_repair(Session *)
51.1.77 by Jay Pipes
Standardized TRUE/FALSE, removed/replaced DBUG symbols
1052
  { return true; }
645 by Brian Aker
Cleanup unused attribute
1053
  virtual int disable_indexes(uint32_t)
1054
  { return HA_ERR_WRONG_COMMAND; }
1055
  virtual int enable_indexes(uint32_t)
1056
  { return HA_ERR_WRONG_COMMAND; }
1057
  virtual int discard_or_import_tablespace(bool)
1 by brian
clean slate
1058
  { return (my_errno=HA_ERR_WRONG_COMMAND); }
53.2.32 by Monty Taylor
First large swath at getting handler stuff clean.
1059
  virtual void prepare_for_alter(void) { return; }
1 by brian
clean slate
1060
  virtual void drop_table(const char *name);
645 by Brian Aker
Cleanup unused attribute
1061
  virtual int create(const char *, Table *, HA_CREATE_INFO *)=0;
1 by brian
clean slate
1062
645 by Brian Aker
Cleanup unused attribute
1063
  virtual int create_handler_files(const char *, const char *, int, HA_CREATE_INFO *)
51.1.77 by Jay Pipes
Standardized TRUE/FALSE, removed/replaced DBUG symbols
1064
  { return false; }
1 by brian
clean slate
1065
};
1066
1067
1068
1069
/**
1070
  A Disk-Sweep MRR interface implementation
1071
1072
  This implementation makes range (and, in the future, 'ref') scans to read
660.1.3 by Eric Herman
removed trailing whitespace with simple script:
1073
  table rows in disk sweeps.
1074
1 by brian
clean slate
1075
  Currently it is used by MyISAM and InnoDB. Potentially it can be used with
1076
  any table handler that has non-clustered indexes and on-disk rows.
1077
*/
1078
1079
class DsMrr_impl
1080
{
1081
public:
1082
  typedef void (handler::*range_check_toggle_func_t)(bool on);
1083
1084
  DsMrr_impl()
1085
    : h2(NULL) {};
1086
1087
  handler *h; /* The "owner" handler object. It is used for scanning the index */
327.1.5 by Brian Aker
Refactor around classes. TABLE_LIST has been factored out of table.h
1088
  Table *table; /* Always equal to h->table */
1 by brian
clean slate
1089
private:
1090
  /*
1091
    Secondary handler object. It is used to retrieve full table rows by
1092
    calling rnd_pos().
1093
  */
1094
  handler *h2;
1095
1096
  /* Buffer to store rowids, or (rowid, range_id) pairs */
481 by Brian Aker
Remove all of uchar.
1097
  unsigned char *rowids_buf;
1098
  unsigned char *rowids_buf_cur;   /* Current position when reading/writing */
1099
  unsigned char *rowids_buf_last;  /* When reading: end of used buffer space */
1100
  unsigned char *rowids_buf_end;   /* End of the buffer */
1 by brian
clean slate
1101
51.1.77 by Jay Pipes
Standardized TRUE/FALSE, removed/replaced DBUG symbols
1102
  bool dsmrr_eof; /* true <=> We have reached EOF when reading index tuples */
1 by brian
clean slate
1103
51.1.77 by Jay Pipes
Standardized TRUE/FALSE, removed/replaced DBUG symbols
1104
  /* true <=> need range association, buffer holds {rowid, range_id} pairs */
1 by brian
clean slate
1105
  bool is_mrr_assoc;
1106
51.1.77 by Jay Pipes
Standardized TRUE/FALSE, removed/replaced DBUG symbols
1107
  bool use_default_impl; /* true <=> shortcut all calls to default MRR impl */
1 by brian
clean slate
1108
public:
327.1.5 by Brian Aker
Refactor around classes. TABLE_LIST has been factored out of table.h
1109
  void init(handler *h_arg, Table *table_arg)
1 by brian
clean slate
1110
  {
660.1.3 by Eric Herman
removed trailing whitespace with simple script:
1111
    h= h_arg;
1 by brian
clean slate
1112
    table= table_arg;
1113
  }
660.1.3 by Eric Herman
removed trailing whitespace with simple script:
1114
  int dsmrr_init(handler *h, KEY *key, RANGE_SEQ_IF *seq_funcs,
1115
                 void *seq_init_param, uint32_t n_ranges, uint32_t mode,
1 by brian
clean slate
1116
                 HANDLER_BUFFER *buf);
1117
  void dsmrr_close();
1118
  int dsmrr_fill_buffer(handler *h);
1119
  int dsmrr_next(handler *h, char **range_info);
1120
482 by Brian Aker
Remove uint.
1121
  int dsmrr_info(uint32_t keyno, uint32_t n_ranges, uint32_t keys, uint32_t *bufsz,
1122
                 uint32_t *flags, COST_VECT *cost);
1 by brian
clean slate
1123
660.1.3 by Eric Herman
removed trailing whitespace with simple script:
1124
  ha_rows dsmrr_info_const(uint32_t keyno, RANGE_SEQ_IF *seq,
482 by Brian Aker
Remove uint.
1125
                            void *seq_init_param, uint32_t n_ranges, uint32_t *bufsz,
1126
                            uint32_t *flags, COST_VECT *cost);
1 by brian
clean slate
1127
private:
482 by Brian Aker
Remove uint.
1128
  bool key_uses_partial_cols(uint32_t keyno);
660.1.3 by Eric Herman
removed trailing whitespace with simple script:
1129
  bool choose_mrr_impl(uint32_t keyno, ha_rows rows, uint32_t *flags, uint32_t *bufsz,
1 by brian
clean slate
1130
                       COST_VECT *cost);
660.1.3 by Eric Herman
removed trailing whitespace with simple script:
1131
  bool get_disk_sweep_mrr_cost(uint32_t keynr, ha_rows rows, uint32_t flags,
482 by Brian Aker
Remove uint.
1132
                               uint32_t *buffer_size, COST_VECT *cost);
1 by brian
clean slate
1133
};
1134
1135
extern const char *ha_row_type[];
1136
extern const char *tx_isolation_names[];
1137
extern const char *binlog_format_names[];
1138
extern TYPELIB tx_isolation_typelib;
1139
extern TYPELIB myisam_stats_method_typelib;
61 by Brian Aker
Conversion of handler type.
1140
extern uint32_t total_ha, total_ha_2pc;
1 by brian
clean slate
1141
1142
       /* Wrapper functions */
520.1.22 by Brian Aker
Second pass of thd cleanup
1143
#define ha_commit(session) (ha_commit_trans((session), true))
1144
#define ha_rollback(session) (ha_rollback_trans((session), true))
1 by brian
clean slate
1145
1146
/* basic stuff */
1147
int ha_init_errors(void);
1148
int ha_init(void);
1149
int ha_end(void);
1150
int ha_initialize_handlerton(st_plugin_int *plugin);
1151
int ha_finalize_handlerton(st_plugin_int *plugin);
1152
1153
TYPELIB *ha_known_exts(void);
520.1.22 by Brian Aker
Second pass of thd cleanup
1154
void ha_close_connection(Session* session);
1 by brian
clean slate
1155
bool ha_flush_logs(handlerton *db_type);
1156
void ha_drop_database(char* path);
520.1.22 by Brian Aker
Second pass of thd cleanup
1157
int ha_create_table(Session *session, const char *path,
1 by brian
clean slate
1158
                    const char *db, const char *table_name,
1159
                    HA_CREATE_INFO *create_info,
1160
                    bool update_create_info);
590.1.7 by Stewart Smith
remove mysql_frm_type
1161
int ha_delete_table(Session *session, const char *path,
1 by brian
clean slate
1162
                    const char *db, const char *alias, bool generate_warning);
1163
1164
/* statistics and info */
520.1.22 by Brian Aker
Second pass of thd cleanup
1165
bool ha_show_status(Session *session, handlerton *db_type, enum ha_stat_type stat);
1 by brian
clean slate
1166
520.1.22 by Brian Aker
Second pass of thd cleanup
1167
int ha_find_files(Session *session,const char *db,const char *path,
1 by brian
clean slate
1168
                  const char *wild, bool dir, List<LEX_STRING>* files);
673.3.12 by Stewart Smith
fix RENAME TABLE
1169
int ha_table_exists_in_engine(Session* session, const char* db, const char* name, handlerton **hton= NULL);
1 by brian
clean slate
1170
1171
/* key cache */
1172
extern "C" int ha_init_key_cache(const char *name, KEY_CACHE *key_cache);
1173
int ha_resize_key_cache(KEY_CACHE *key_cache);
1174
int ha_change_key_cache_param(KEY_CACHE *key_cache);
1175
int ha_change_key_cache(KEY_CACHE *old_key_cache, KEY_CACHE *new_key_cache);
1176
int ha_end_key_cache(KEY_CACHE *key_cache);
1177
1178
/* report to InnoDB that control passes to the client */
520.1.22 by Brian Aker
Second pass of thd cleanup
1179
int ha_release_temporary_latches(Session *session);
1 by brian
clean slate
1180
1181
/* transactions: interface to handlerton functions */
520.1.22 by Brian Aker
Second pass of thd cleanup
1182
int ha_start_consistent_snapshot(Session *session);
1 by brian
clean slate
1183
int ha_commit_or_rollback_by_xid(XID *xid, bool commit);
520.1.22 by Brian Aker
Second pass of thd cleanup
1184
int ha_commit_one_phase(Session *session, bool all);
1185
int ha_rollback_trans(Session *session, bool all);
1186
int ha_prepare(Session *session);
1 by brian
clean slate
1187
int ha_recover(HASH *commit_list);
1188
1189
/* transactions: these functions never call handlerton functions directly */
520.1.22 by Brian Aker
Second pass of thd cleanup
1190
int ha_commit_trans(Session *session, bool all);
1191
int ha_autocommit_or_rollback(Session *session, int error);
1192
int ha_enable_transaction(Session *session, bool on);
1 by brian
clean slate
1193
1194
/* savepoints */
520.1.22 by Brian Aker
Second pass of thd cleanup
1195
int ha_rollback_to_savepoint(Session *session, SAVEPOINT *sv);
1196
int ha_savepoint(Session *session, SAVEPOINT *sv);
1197
int ha_release_savepoint(Session *session, SAVEPOINT *sv);
1 by brian
clean slate
1198
1199
/* these are called by storage engines */
520.1.22 by Brian Aker
Second pass of thd cleanup
1200
void trans_register_ha(Session *session, bool all, handlerton *ht);
1 by brian
clean slate
1201
520.6.7 by Monty Taylor
Moved a bunch of crap out of common_includes.
1202
void table_case_convert(char * name, uint32_t length);
1203
const char *table_case_name(HA_CREATE_INFO *info, const char *name);
1204
1205
extern char reg_ext[FN_EXTLEN];
1206
extern uint32_t reg_ext_length;
1207
extern ulong specialflag;
1208
extern uint32_t lower_case_table_names;
1209
uint32_t filename_to_tablename(const char *from, char *to, uint32_t to_length);
1210
uint32_t tablename_to_filename(const char *from, char *to, uint32_t to_length);
1211
1212
575.1.3 by Monty Taylor
Moved some stuff out of handler.h.
1213
bool mysql_ha_open(Session *session, TableList *tables, bool reopen);
1214
bool mysql_ha_close(Session *session, TableList *tables);
1215
bool mysql_ha_read(Session *, TableList *,enum enum_ha_read_modes,char *,
1216
                   List<Item> *,enum ha_rkey_function,Item *,ha_rows,ha_rows);
1217
void mysql_ha_flush(Session *session);
1218
void mysql_ha_rm_tables(Session *session, TableList *tables, bool is_locked);
1219
void mysql_ha_cleanup(Session *session);
1220
1 by brian
clean slate
1221
/*
1222
  Storage engine has to assume the transaction will end up with 2pc if
1223
   - there is more than one 2pc-capable storage engine available
1224
   - in the current transaction 2pc was not disabled yet
1225
*/
520.1.22 by Brian Aker
Second pass of thd cleanup
1226
#define trans_need_2pc(session, all)                   ((total_ha_2pc > 1) && \
1227
        !((all ? &session->transaction.all : &session->transaction.stmt)->no_2pc))
520.6.4 by Monty Taylor
Moved thr_lock.h out of common_includes.
1228
575.4.7 by Monty Taylor
More header cleanup.
1229
1230
bool mysql_xa_recover(Session *session);
1231
1232
SORT_FIELD * make_unireg_sortorder(order_st *order, uint32_t *length,
1233
                                   SORT_FIELD *sortorder);
1234
int setup_order(Session *session, Item **ref_pointer_array, TableList *tables,
1235
                List<Item> &fields, List <Item> &all_fields, order_st *order);
1236
int setup_group(Session *session, Item **ref_pointer_array, TableList *tables,
1237
                List<Item> &fields, List<Item> &all_fields, order_st *order,
1238
                bool *hidden_group_fields);
1239
bool fix_inner_refs(Session *session, List<Item> &all_fields, SELECT_LEX *select,
1240
                    Item **ref_pointer_array);
1241
1242
bool handle_select(Session *session, LEX *lex, select_result *result,
1243
                   ulong setup_tables_done_option);
1244
bool mysql_select(Session *session, Item ***rref_pointer_array,
1245
                  TableList *tables, uint32_t wild_num,  List<Item> &list,
1246
                  COND *conds, uint32_t og_num, order_st *order, order_st *group,
1247
                  Item *having, order_st *proc_param, uint64_t select_type,
1248
                  select_result *result, SELECT_LEX_UNIT *unit,
1249
                  SELECT_LEX *select_lex);
1250
void free_underlaid_joins(Session *session, SELECT_LEX *select);
1251
bool mysql_explain_union(Session *session, SELECT_LEX_UNIT *unit,
1252
                         select_result *result);
1253
int mysql_explain_select(Session *session, SELECT_LEX *sl, char const *type,
1254
                         select_result *result);
1255
bool mysql_union(Session *session, LEX *lex, select_result *result,
1256
                 SELECT_LEX_UNIT *unit, ulong setup_tables_done_option);
1257
bool mysql_handle_derived(LEX *lex, bool (*processor)(Session *session,
1258
                                                      LEX *lex,
1259
                                                      TableList *table));
1260
bool mysql_derived_prepare(Session *session, LEX *lex, TableList *t);
1261
bool mysql_derived_filling(Session *session, LEX *lex, TableList *t);
1262
void sp_prepare_create_field(Session *session, Create_field *sql_field);
1263
int prepare_create_field(Create_field *sql_field,
1264
                         uint32_t *blob_columns,
1265
                         int *timestamps, int *timestamps_with_niladic,
1266
                         int64_t table_flags);
1267
bool mysql_create_table(Session *session,const char *db, const char *table_name,
1268
                        HA_CREATE_INFO *create_info,
1269
                        Alter_info *alter_info,
1270
                        bool tmp_table, uint32_t select_field_count);
1271
bool mysql_create_table_no_lock(Session *session, const char *db,
1272
                                const char *table_name,
1273
                                HA_CREATE_INFO *create_info,
1274
                                Alter_info *alter_info,
1275
                                bool tmp_table, uint32_t select_field_count,
1276
                                bool lock_open_lock);
1277
1278
bool mysql_alter_table(Session *session, char *new_db, char *new_name,
1279
                       HA_CREATE_INFO *create_info,
1280
                       TableList *table_list,
1281
                       Alter_info *alter_info,
1282
                       uint32_t order_num, order_st *order, bool ignore);
1283
bool mysql_recreate_table(Session *session, TableList *table_list);
1284
bool mysql_create_like_table(Session *session, TableList *table,
1285
                             TableList *src_table,
1286
                             HA_CREATE_INFO *create_info);
1287
bool mysql_rename_table(handlerton *base, const char *old_db,
1288
                        const char * old_name, const char *new_db,
1289
                        const char * new_name, uint32_t flags);
1290
bool mysql_prepare_update(Session *session, TableList *table_list,
1291
                          Item **conds, uint32_t order_num, order_st *order);
1292
int mysql_update(Session *session,TableList *tables,List<Item> &fields,
1293
                 List<Item> &values,COND *conds,
1294
                 uint32_t order_num, order_st *order, ha_rows limit,
1295
                 enum enum_duplicates handle_duplicates, bool ignore);
1296
bool mysql_multi_update(Session *session, TableList *table_list,
1297
                        List<Item> *fields, List<Item> *values,
1298
                        COND *conds, uint64_t options,
1299
                        enum enum_duplicates handle_duplicates, bool ignore,
1300
                        SELECT_LEX_UNIT *unit, SELECT_LEX *select_lex);
1301
bool mysql_prepare_insert(Session *session, TableList *table_list, Table *table,
1302
                          List<Item> &fields, List_item *values,
1303
                          List<Item> &update_fields,
1304
                          List<Item> &update_values, enum_duplicates duplic,
1305
                          COND **where, bool select_insert,
1306
                          bool check_fields, bool abort_on_warning);
1307
bool mysql_insert(Session *session,TableList *table,List<Item> &fields,
1308
                  List<List_item> &values, List<Item> &update_fields,
1309
                  List<Item> &update_values, enum_duplicates flag,
1310
                  bool ignore);
1311
int check_that_all_fields_are_given_values(Session *session, Table *entry,
1312
                                           TableList *table_list);
1313
void prepare_triggers_for_insert_stmt(Table *table);
1314
int mysql_prepare_delete(Session *session, TableList *table_list, Item **conds);
1315
bool mysql_delete(Session *session, TableList *table_list, COND *conds,
1316
                  SQL_LIST *order, ha_rows rows, uint64_t options,
1317
                  bool reset_auto_increment);
1318
bool mysql_truncate(Session *session, TableList *table_list, bool dont_send_ok);
1319
uint32_t create_table_def_key(Session *session, char *key, TableList *table_list,
1320
                              bool tmp_table);
1321
TABLE_SHARE *get_table_share(Session *session, TableList *table_list, char *key,
1322
                             uint32_t key_length, uint32_t db_flags, int *error);
1323
void release_table_share(TABLE_SHARE *share, enum release_type type);
1324
TABLE_SHARE *get_cached_table_share(const char *db, const char *table_name);
1325
Table *open_ltable(Session *session, TableList *table_list, thr_lock_type update,
1326
                   uint32_t lock_flags);
1327
Table *open_table(Session *session, TableList *table_list, bool *refresh, uint32_t flags);
1328
bool name_lock_locked_table(Session *session, TableList *tables);
1329
bool reopen_name_locked_table(Session* session, TableList* table_list, bool link_in);
1330
Table *table_cache_insert_placeholder(Session *session, const char *key,
1331
                                      uint32_t key_length);
1332
bool lock_table_name_if_not_cached(Session *session, const char *db,
1333
                                   const char *table_name, Table **table);
1334
Table *find_locked_table(Session *session, const char *db,const char *table_name);
1335
void detach_merge_children(Table *table, bool clear_refs);
1336
bool fix_merge_after_open(TableList *old_child_list, TableList **old_last,
1337
                          TableList *new_child_list, TableList **new_last);
1338
bool reopen_table(Table *table);
1339
bool reopen_tables(Session *session,bool get_locks,bool in_refresh);
1340
void close_data_files_and_morph_locks(Session *session, const char *db,
1341
                                      const char *table_name);
1342
void close_handle_and_leave_table_as_lock(Table *table);
1343
bool open_new_frm(Session *session, TABLE_SHARE *share, const char *alias,
1344
                  uint32_t db_stat, uint32_t prgflag,
1345
                  uint32_t ha_open_flags, Table *outparam,
1346
                  TableList *table_desc, MEM_ROOT *mem_root);
1347
bool wait_for_tables(Session *session);
1348
bool table_is_used(Table *table, bool wait_for_name_lock);
1349
Table *drop_locked_tables(Session *session,const char *db, const char *table_name);
1350
void abort_locked_tables(Session *session,const char *db, const char *table_name);
1351
void execute_init_command(Session *session, sys_var_str *init_command_var,
658 by Brian Aker
Part removal of my_pthread.h
1352
                          pthread_rwlock_t *var_mutex);
575.4.7 by Monty Taylor
More header cleanup.
1353
extern Field *not_found_field;
1354
extern Field *view_ref_found;
1355
1356
Field *
1357
find_field_in_tables(Session *session, Item_ident *item,
1358
                     TableList *first_table, TableList *last_table,
1359
                     Item **ref, find_item_error_report_type report_error,
1360
                     bool check_privileges, bool register_tree_change);
1361
Field *
1362
find_field_in_table_ref(Session *session, TableList *table_list,
1363
                        const char *name, uint32_t length,
1364
                        const char *item_name, const char *db_name,
1365
                        const char *table_name, Item **ref,
1366
                        bool check_privileges, bool allow_rowid,
1367
                        uint32_t *cached_field_index_ptr,
1368
                        bool register_tree_change, TableList **actual_table);
1369
Field *
1370
find_field_in_table(Session *session, Table *table, const char *name, uint32_t length,
1371
                    bool allow_rowid, uint32_t *cached_field_index_ptr);
1372
Field *
1373
find_field_in_table_sef(Table *table, const char *name);
1374
int update_virtual_fields_marked_for_write(Table *table,
1375
                                           bool ignore_stored=true);
1376
1377
520.6.4 by Monty Taylor
Moved thr_lock.h out of common_includes.
1378
#endif /* DRIZZLED_HANDLER_H */