51
58
#define is_schema_db(X) \
52
59
!my_strcasecmp(system_charset_info, INFORMATION_SCHEMA_NAME.str, (X))
55
#define TMP_TABLE_KEY_EXTRA 8
56
void set_item_name(Item *item,char *pos,uint32_t length);
57
bool add_field_to_list(Session *session, LEX_STRING *field_name, enum enum_field_types type,
58
char *length, char *decimal,
59
uint32_t type_modifier,
60
enum column_format_type column_format,
61
Item *default_value, Item *on_update_value,
63
char *change, List<String> *interval_list,
64
const CHARSET_INFO * const cs,
65
virtual_column_info *vcol_info);
66
Create_field * new_create_field(Session *session, char *field_name, enum_field_types type,
67
char *length, char *decimals,
68
uint32_t type_modifier,
69
Item *default_value, Item *on_update_value,
70
LEX_STRING *comment, char *change,
71
List<String> *interval_list, CHARSET_INFO *cs,
72
virtual_column_info *vcol_info);
73
void store_position_for_column(const char *name);
74
bool add_to_list(Session *session, SQL_LIST &list,Item *group,bool asc);
75
bool push_new_name_resolution_context(Session *session,
78
void add_join_on(TableList *b,Item *expr);
79
void add_join_natural(TableList *a,TableList *b,List<String> *using_fields,
81
bool add_proc_to_list(Session *session, Item *item);
82
void unlink_open_table(Session *session, Table *find, bool unlock);
83
void drop_open_table(Session *session, Table *table, const char *db_name,
84
const char *table_name);
85
void update_non_unique_table_error(TableList *update,
86
const char *operation,
87
TableList *duplicate);
89
SQL_SELECT *make_select(Table *head, table_map const_tables,
90
table_map read_tables, COND *conds,
91
bool allow_null_cond, int *error);
92
extern Item **not_found_item;
95
A set of constants used for checking non aggregated fields and sum
96
functions mixture in the ONLY_FULL_GROUP_BY_MODE.
98
#define NON_AGG_FIELD_USED 1
99
#define SUM_FUNC_USED 2
102
This enumeration type is used only by the function find_item_in_list
103
to return the info on how an item has been resolved against a list
104
of possibly aliased items.
105
The item can be resolved:
106
- against an alias name of the list's element (RESOLVED_AGAINST_ALIAS)
107
- against non-aliased field name of the list (RESOLVED_WITH_NO_ALIAS)
108
- against an aliased field name of the list (RESOLVED_BEHIND_ALIAS)
109
- ignoring the alias name in cases when SQL requires to ignore aliases
110
(e.g. when the resolved field reference contains a table name or
111
when the resolved item is an expression) (RESOLVED_IGNORING_ALIAS)
113
enum enum_resolution_type {
115
RESOLVED_IGNORING_ALIAS,
116
RESOLVED_BEHIND_ALIAS,
117
RESOLVED_WITH_NO_ALIAS,
118
RESOLVED_AGAINST_ALIAS
120
Item ** find_item_in_list(Item *item, List<Item> &items, uint32_t *counter,
121
find_item_error_report_type report_error,
122
enum_resolution_type *resolution);
123
bool get_key_map_from_key_list(key_map *map, Table *table,
124
List<String> *index_list);
125
bool insert_fields(Session *session, Name_resolution_context *context,
126
const char *db_name, const char *table_name,
127
List_iterator<Item> *it, bool any_privileges);
128
bool setup_tables(Session *session, Name_resolution_context *context,
129
List<TableList> *from_clause, TableList *tables,
130
TableList **leaves, bool select_insert);
131
bool setup_tables_and_check_access(Session *session,
132
Name_resolution_context *context,
133
List<TableList> *from_clause,
137
int setup_wild(Session *session, TableList *tables, List<Item> &fields,
138
List<Item> *sum_func_list, uint32_t wild_num);
139
bool setup_fields(Session *session, Item** ref_pointer_array,
140
List<Item> &item, enum_mark_columns mark_used_columns,
141
List<Item> *sum_func_list, bool allow_sum_func);
142
inline bool setup_fields_with_no_wrap(Session *session, Item **ref_pointer_array,
144
enum_mark_columns mark_used_columns,
145
List<Item> *sum_func_list,
149
res= setup_fields(session, ref_pointer_array, item, mark_used_columns, sum_func_list,
153
int setup_conds(Session *session, TableList *tables, TableList *leaves,
155
int setup_ftfuncs(SELECT_LEX* select);
156
int init_ftfuncs(Session *session, SELECT_LEX* select, bool no_order);
157
void wait_for_condition(Session *session, pthread_mutex_t *mutex,
158
pthread_cond_t *cond);
159
int open_tables(Session *session, TableList **tables, uint32_t *counter, uint32_t flags);
160
/* open_and_lock_tables with optional derived handling */
161
int open_and_lock_tables_derived(Session *session, TableList *tables, bool derived);
162
/* simple open_and_lock_tables without derived handling */
163
inline int simple_open_n_lock_tables(Session *session, TableList *tables)
165
return open_and_lock_tables_derived(session, tables, false);
167
/* open_and_lock_tables with derived handling */
168
inline int open_and_lock_tables(Session *session, TableList *tables)
170
return open_and_lock_tables_derived(session, tables, true);
172
/* simple open_and_lock_tables without derived handling for single table */
173
Table *open_n_lock_single_table(Session *session, TableList *table_l,
174
thr_lock_type lock_type);
175
bool open_normal_and_derived_tables(Session *session, TableList *tables, uint32_t flags);
176
int lock_tables(Session *session, TableList *tables, uint32_t counter, bool *need_reopen);
177
int decide_logging_format(Session *session);
178
Table *open_temporary_table(Session *session, const char *path, const char *db,
179
const char *table_name, bool link_in_list,
180
open_table_mode open_mode);
181
bool rm_temporary_table(handlerton *base, char *path, bool frm_only);
182
void free_io_cache(Table *entry);
183
void intern_close_table(Table *entry);
184
bool close_thread_table(Session *session, Table **table_ptr);
185
void close_temporary_tables(Session *session);
186
void close_tables_for_reopen(Session *session, TableList **tables);
187
TableList *find_table_in_list(TableList *table,
188
TableList *TableList::*link,
190
const char *table_name);
191
TableList *unique_table(Session *session, TableList *table, TableList *table_list,
193
Table *find_temporary_table(Session *session, const char *db, const char *table_name);
194
Table *find_temporary_table(Session *session, TableList *table_list);
195
int drop_temporary_table(Session *session, TableList *table_list);
196
void close_temporary_table(Session *session, Table *table, bool free_share,
198
void close_temporary(Table *table, bool free_share, bool delete_table);
199
bool rename_temporary_table(Session* session, Table *table, const char *new_db,
200
const char *table_name);
201
void remove_db_from_cache(const char *db);
203
bool is_equal(const LEX_STRING *a, const LEX_STRING *b);
204
char *make_default_log_name(char *buff,const char* log_ext);
206
/* bits for last argument to remove_table_from_cache() */
207
#define RTFC_NO_FLAG 0x0000
208
#define RTFC_OWNED_BY_Session_FLAG 0x0001
209
#define RTFC_WAIT_OTHER_THREAD_FLAG 0x0002
210
#define RTFC_CHECK_KILLED_FLAG 0x0004
211
bool remove_table_from_cache(Session *session, const char *db, const char *table,
214
#define NORMAL_PART_NAME 0
215
#define TEMP_PART_NAME 1
216
#define RENAMED_PART_NAME 2
218
void mem_alloc_error(size_t size);
220
#define WFRM_WRITE_SHADOW 1
221
#define WFRM_INSTALL_SHADOW 2
222
#define WFRM_PACK_FRM 4
223
#define WFRM_KEEP_SHARE 8
225
bool close_cached_tables(Session *session, TableList *tables, bool have_lock,
226
bool wait_for_refresh, bool wait_for_placeholders);
227
bool close_cached_connection_tables(Session *session, bool wait_for_refresh,
228
LEX_STRING *connect_string,
229
bool have_lock= false);
230
void copy_field_from_tmp_record(Field *field,int offset);
231
bool fill_record(Session * session, List<Item> &fields, List<Item> &values, bool ignore_errors);
232
bool fill_record(Session *session, Field **field, List<Item> &values, bool ignore_errors);
233
OPEN_TableList *list_open_tables(Session *session, const char *db, const char *wild);
235
inline TableList *find_table_in_global_list(TableList *table,
237
const char *table_name)
239
return find_table_in_list(table, &TableList::next_global,
240
db_name, table_name);
243
inline TableList *find_table_in_local_list(TableList *table,
245
const char *table_name)
247
return find_table_in_list(table, &TableList::next_local,
248
db_name, table_name);
253
63
bool eval_const_cond(COND *cond);
256
int mysql_load(Session *session, sql_exchange *ex, TableList *table_list,
257
List<Item> &fields_vars, List<Item> &set_fields,
258
List<Item> &set_values_list,
259
enum enum_duplicates handle_duplicates, bool ignore,
261
int write_record(Session *session, Table *table, COPY_INFO *info);
265
67
void print_where(COND *cond,const char *info, enum_query_type query_type);
266
68
void print_cached_tables(void);
267
void TEST_filesort(SORT_FIELD *sortorder,uint32_t s_length);
268
69
void print_plan(JOIN* join,uint32_t idx, double record_count, double read_time,
269
70
double current_read_time, const char *info);
270
71
void print_keyuse_array(DYNAMIC_ARRAY *keyuse_array);