1 /* Copyright (c) 2006, 2011, Oracle and/or its affiliates. All rights reserved.
2 
3    This program is free software; you can redistribute it and/or modify
4    it under the terms of the GNU General Public License as published by
5    the Free Software Foundation; version 2 of the License.
6 
7    This program is distributed in the hope that it will be useful,
8    but WITHOUT ANY WARRANTY; without even the implied warranty of
9    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
10    GNU General Public License for more details.
11 
12    You should have received a copy of the GNU General Public License
13    along with this program; if not, write to the Free Software
14    Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA  02110-1335  USA */
15 
16 #ifndef SQL_PARSE_INCLUDED
17 #define SQL_PARSE_INCLUDED
18 
19 #include "sql_acl.h"                            /* GLOBAL_ACLS */
20 
21 class Comp_creator;
22 class Item;
23 class Object_creation_ctx;
24 class Parser_state;
25 struct TABLE_LIST;
26 class THD;
27 class Table_ident;
28 struct LEX;
29 
30 enum enum_mysql_completiontype {
31   ROLLBACK_RELEASE=-2, ROLLBACK=1,  ROLLBACK_AND_CHAIN=7,
32   COMMIT_RELEASE=-1,   COMMIT=0,    COMMIT_AND_CHAIN=6
33 };
34 
35 extern "C" int path_starts_from_data_home_dir(const char *dir);
36 int test_if_data_home_dir(const char *dir);
37 int error_if_data_home_dir(const char *path, const char *what);
38 my_bool net_allocate_new_packet(NET *net, void *thd, uint my_flags);
39 
40 bool multi_update_precheck(THD *thd, TABLE_LIST *tables);
41 bool multi_delete_precheck(THD *thd, TABLE_LIST *tables);
42 int mysql_multi_update_prepare(THD *thd);
43 int mysql_multi_delete_prepare(THD *thd);
44 bool mysql_insert_select_prepare(THD *thd);
45 bool update_precheck(THD *thd, TABLE_LIST *tables);
46 bool delete_precheck(THD *thd, TABLE_LIST *tables);
47 bool insert_precheck(THD *thd, TABLE_LIST *tables);
48 bool create_table_precheck(THD *thd, TABLE_LIST *tables,
49                            TABLE_LIST *create_table);
50 bool check_fk_parent_table_access(THD *thd,
51                                   HA_CREATE_INFO *create_info,
52                                   Alter_info *alter_info,
53                                   const char* create_db);
54 
55 bool parse_sql(THD *thd, Parser_state *parser_state,
56                Object_creation_ctx *creation_ctx, bool do_pfs_digest=false);
57 
58 void free_items(Item *item);
59 void cleanup_items(Item *item);
60 
61 Comp_creator *comp_eq_creator(bool invert);
62 Comp_creator *comp_ge_creator(bool invert);
63 Comp_creator *comp_gt_creator(bool invert);
64 Comp_creator *comp_le_creator(bool invert);
65 Comp_creator *comp_lt_creator(bool invert);
66 Comp_creator *comp_ne_creator(bool invert);
67 
68 int prepare_schema_table(THD *thd, LEX *lex, Table_ident *table_ident,
69                          enum enum_schema_tables schema_table_idx);
70 void get_default_definer(THD *thd, LEX_USER *definer, bool role);
71 LEX_USER *create_default_definer(THD *thd, bool role);
72 LEX_USER *create_definer(THD *thd, LEX_CSTRING *user_name, LEX_CSTRING *host_name);
73 LEX_USER *get_current_user(THD *thd, LEX_USER *user, bool lock=true);
74 bool sp_process_definer(THD *thd);
75 bool check_string_byte_length(const LEX_CSTRING *str, uint err_msg,
76                               size_t max_byte_length);
77 bool check_string_char_length(const LEX_CSTRING *str, uint err_msg,
78                               size_t max_char_length, CHARSET_INFO *cs,
79                               bool no_error);
80 bool check_ident_length(const LEX_CSTRING *ident);
81 CHARSET_INFO* merge_charset_and_collation(CHARSET_INFO *cs, CHARSET_INFO *cl);
82 CHARSET_INFO *find_bin_collation(CHARSET_INFO *cs);
83 bool check_host_name(LEX_CSTRING *str);
84 bool check_identifier_name(LEX_CSTRING *str, uint max_char_length,
85                            uint err_code, const char *param_for_err_msg);
86 bool mysql_test_parse_for_slave(THD *thd,char *inBuf,uint length);
87 bool sqlcom_can_generate_row_events(const THD *thd);
88 bool stmt_causes_implicit_commit(THD *thd, uint mask);
89 bool is_update_query(enum enum_sql_command command);
90 bool is_log_table_write_query(enum enum_sql_command command);
91 bool alloc_query(THD *thd, const char *packet, size_t packet_length);
92 void mysql_init_select(LEX *lex);
93 void mysql_parse(THD *thd, char *rawbuf, uint length,
94                  Parser_state *parser_state, bool is_com_multi,
95                  bool is_next_command);
96 bool mysql_new_select(LEX *lex, bool move_down, SELECT_LEX *sel);
97 void create_select_for_variable(THD *thd, LEX_CSTRING *var_name);
98 void create_table_set_open_action_and_adjust_tables(LEX *lex);
99 void mysql_init_multi_delete(LEX *lex);
100 bool multi_delete_set_locks_and_link_aux_tables(LEX *lex);
101 void create_table_set_open_action_and_adjust_tables(LEX *lex);
102 int bootstrap(MYSQL_FILE *file);
103 bool run_set_statement_if_requested(THD *thd, LEX *lex);
104 int mysql_execute_command(THD *thd);
105 bool do_command(THD *thd);
106 bool dispatch_command(enum enum_server_command command, THD *thd,
107 		      char* packet, uint packet_length,
108                       bool is_com_multi, bool is_next_command);
109 void log_slow_statement(THD *thd);
110 bool append_file_to_dir(THD *thd, const char **filename_ptr,
111                         const LEX_CSTRING *table_name);
112 void execute_init_command(THD *thd, LEX_STRING *init_command,
113                           mysql_rwlock_t *var_lock);
114 bool add_to_list(THD *thd, SQL_I_List<ORDER> &list, Item *group, bool asc);
115 void add_join_on(THD *thd, TABLE_LIST *b, Item *expr);
116 void add_join_natural(TABLE_LIST *a,TABLE_LIST *b,List<String> *using_fields,
117                       SELECT_LEX *lex);
118 bool add_proc_to_list(THD *thd, Item *item);
119 bool push_new_name_resolution_context(THD *thd,
120                                       TABLE_LIST *left_op,
121                                       TABLE_LIST *right_op);
122 void init_update_queries(void);
123 Item *normalize_cond(THD *thd, Item *cond);
124 Item *negate_expression(THD *thd, Item *expr);
125 bool check_stack_overrun(THD *thd, long margin, uchar *dummy);
126 
127 /* Variables */
128 
129 extern const char* any_db;
130 extern uint sql_command_flags[];
131 extern uint server_command_flags[];
132 extern const LEX_CSTRING command_name[];
133 extern uint server_command_flags[];
134 
135 /* Inline functions */
check_identifier_name(LEX_CSTRING * str,uint err_code)136 inline bool check_identifier_name(LEX_CSTRING *str, uint err_code)
137 {
138   return check_identifier_name(str, NAME_CHAR_LEN, err_code, "");
139 }
140 
check_identifier_name(LEX_CSTRING * str)141 inline bool check_identifier_name(LEX_CSTRING *str)
142 {
143   return check_identifier_name(str, NAME_CHAR_LEN, 0, "");
144 }
145 
146 #ifndef NO_EMBEDDED_ACCESS_CHECKS
147 bool check_one_table_access(THD *thd, ulong privilege, TABLE_LIST *tables);
148 bool check_single_table_access(THD *thd, ulong privilege,
149 			   TABLE_LIST *tables, bool no_errors);
150 bool check_routine_access(THD *thd,ulong want_access,
151                           const LEX_CSTRING *db,
152                           const LEX_CSTRING *name,
153                           const Sp_handler *sph, bool no_errors);
154 bool check_some_access(THD *thd, ulong want_access, TABLE_LIST *table);
155 bool check_some_routine_access(THD *thd, const char *db, const char *name,
156                                const Sp_handler *sph);
157 bool check_table_access(THD *thd, ulong requirements,TABLE_LIST *tables,
158                         bool any_combination_of_privileges_will_do,
159                         uint number,
160                         bool no_errors);
161 #else
check_one_table_access(THD * thd,ulong privilege,TABLE_LIST * tables)162 inline bool check_one_table_access(THD *thd, ulong privilege, TABLE_LIST *tables)
163 { return false; }
check_single_table_access(THD * thd,ulong privilege,TABLE_LIST * tables,bool no_errors)164 inline bool check_single_table_access(THD *thd, ulong privilege,
165 			   TABLE_LIST *tables, bool no_errors)
166 { return false; }
check_routine_access(THD * thd,ulong want_access,const LEX_CSTRING * db,const LEX_CSTRING * name,const Sp_handler * sph,bool no_errors)167 inline bool check_routine_access(THD *thd,ulong want_access,
168                                  const LEX_CSTRING *db,
169                                  const LEX_CSTRING *name,
170                                  const Sp_handler *sph, bool no_errors)
171 { return false; }
check_some_access(THD * thd,ulong want_access,TABLE_LIST * table)172 inline bool check_some_access(THD *thd, ulong want_access, TABLE_LIST *table)
173 {
174   table->grant.privilege= want_access;
175   return false;
176 }
check_some_routine_access(THD * thd,const char * db,const char * name,const Sp_handler * sph)177 inline bool check_some_routine_access(THD *thd, const char *db,
178                                       const char *name,
179                                       const Sp_handler *sph)
180 { return false; }
181 inline bool
check_table_access(THD * thd,ulong requirements,TABLE_LIST * tables,bool any_combination_of_privileges_will_do,uint number,bool no_errors)182 check_table_access(THD *thd, ulong requirements,TABLE_LIST *tables,
183                    bool any_combination_of_privileges_will_do,
184                    uint number,
185                    bool no_errors)
186 { return false; }
187 #endif /*NO_EMBEDDED_ACCESS_CHECKS*/
188 
189 #endif /* SQL_PARSE_INCLUDED */
190