~drizzle-trunk/drizzle/development : contents of drizzled/enum.h at revision 1119.4.6

~drizzle-trunk/drizzle/development : (revision 1119.4.6)

/* -*- mode: c++; c-basic-offset: 2; indent-tabs-mode: nil; -*-
 *  vim:expandtab:shiftwidth=2:tabstop=2:smarttab:
 *
 *  Copyright (C) 2009 Sun Microsystems
 *
 *  This program is free software; you can redistribute it and/or modify
 *  it under the terms of the GNU General Public License as published by
 *  the Free Software Foundation; either version 2 of the License, or
 *  (at your option) any later version.
 *
 *  This program is distributed in the hope that it will be useful,
 *  but WITHOUT ANY WARRANTY; without even the implied warranty of
 *  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 *  GNU General Public License for more details.
 *
 *  You should have received a copy of the GNU General Public License
 *  along with this program; if not, write to the Free Software
 *  Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA  02110-1301  USA
 */

#ifndef DRIZZLED_ENUM_H
#define DRIZZLED_ENUM_H

/**
  Query type constants.

  QT_ORDINARY -- ordinary SQL query.
  QT_IS -- SQL query to be shown in INFORMATION_SCHEMA (in utf8 and without
  character set introducers).

  @TODO

  Move this out of here once Stew's done with UDF breakout.  The following headers need it:

    sql_lex.h --> included by session.h
    item.h
    table.h
    item_func.h
    item_subselect.h
    item_timefunc.h
    item_sum.h
    item_cmpfunc.h
    item_strfunc.h
*/
enum enum_query_type
{
  QT_ORDINARY,
  QT_IS
};


/**
 * @TODO Move to a separate header?
 *
 * It's needed by item.h and field.h, which are both inter-dependent
 * and contain forward declarations of many structs/classes in the
 * other header file.
 *
 * What is needed is a separate header file that is included
 * by *both* item.h and field.h to resolve inter-dependencies
 *
 * But, probably want to hold off on this until Stew finished the UDF cleanup
 */
enum Derivation
{
  DERIVATION_IGNORABLE= 5,
  DERIVATION_COERCIBLE= 4,
  DERIVATION_SYSCONST= 3,
  DERIVATION_IMPLICIT= 2,
  DERIVATION_NONE= 1,
  DERIVATION_EXPLICIT= 0
};

/**
 * Opening modes for open_temporary_table and open_table_from_share
 *
 * @TODO Put this into an appropriate header. It is only needed in:
 *
 *    table.cc
 *    sql_base.cc
 */
enum open_table_mode
{
  OTM_OPEN= 0,
  OTM_CREATE= 1,
  OTM_ALTER= 2
};

enum enum_parsing_place
{
  NO_MATTER, 
  IN_HAVING, 
  SELECT_LIST, 
  IN_WHERE, 
  IN_ON 
};

enum enum_mysql_completiontype 
{
  ROLLBACK_RELEASE= -2, 
  ROLLBACK= 1, 
  ROLLBACK_AND_CHAIN= 7, 
  COMMIT_RELEASE= -1, 
  COMMIT= 0, 
  COMMIT_AND_CHAIN= 6
};

enum enum_check_fields
{
  CHECK_FIELD_IGNORE, 
  CHECK_FIELD_WARN, 
  CHECK_FIELD_ERROR_FOR_NULL
};

enum enum_var_type
{
  OPT_DEFAULT= 0, 
  OPT_SESSION, 
  OPT_GLOBAL
};

enum row_type 
{ 
  ROW_TYPE_NOT_USED=-1, 
  ROW_TYPE_DEFAULT, 
  ROW_TYPE_FIXED,
  ROW_TYPE_DYNAMIC, 
  ROW_TYPE_COMPRESSED,
  ROW_TYPE_REDUNDANT, 
  ROW_TYPE_COMPACT, 
  ROW_TYPE_PAGE 
};

enum column_format_type 
{
  COLUMN_FORMAT_TYPE_NOT_USED= -1,
  COLUMN_FORMAT_TYPE_DEFAULT= 0,
  COLUMN_FORMAT_TYPE_FIXED= 1,
  COLUMN_FORMAT_TYPE_DYNAMIC= 2 
};


/**
  Category of table found in the table share.
*/
enum enum_table_category
{
  /**
    Unknown value.
  */
  TABLE_UNKNOWN_CATEGORY=0,

  /**
    Temporary table.
    The table is visible only in the session.
    Therefore,
    - FLUSH TABLES WITH READ LOCK
    - SET GLOBAL READ_ONLY = ON
    do not apply to this table.
    Note that LOCK Table t FOR READ/WRITE
    can be used on temporary tables.
    Temporary tables are not part of the table cache.
  */
  TABLE_CATEGORY_TEMPORARY=1,

  /**
    User table.
    These tables do honor:
    - LOCK Table t FOR READ/WRITE
    - FLUSH TABLES WITH READ LOCK
    - SET GLOBAL READ_ONLY = ON
    User tables are cached in the table cache.
  */
  TABLE_CATEGORY_USER=2,

  /**
    Information schema tables.
    These tables are an interface provided by the system
    to inspect the system metadata.
    These tables do *not* honor:
    - LOCK Table t FOR READ/WRITE
    - FLUSH TABLES WITH READ LOCK
    - SET GLOBAL READ_ONLY = ON
    as there is no point in locking explicitely
    an INFORMATION_SCHEMA table.
    Nothing is directly written to information schema tables.
    Note that this value is not used currently,
    since information schema tables are not shared,
    but implemented as session specific temporary tables.
  */
  /*
    TODO: Fixing the performance issues of I_S will lead
    to I_S tables in the table cache, which should use
    this table type.
  */
  TABLE_CATEGORY_INFORMATION
};

enum enum_enable_or_disable 
{
  LEAVE_AS_IS, 
  ENABLE, 
  DISABLE 
};


enum enum_mark_columns
{ 
  MARK_COLUMNS_NONE, 
  MARK_COLUMNS_READ, 
  MARK_COLUMNS_WRITE
};

enum enum_filetype 
{ 
  FILETYPE_CSV, 
  FILETYPE_XML 
};

enum find_item_error_report_type 
{
  REPORT_ALL_ERRORS, 
  REPORT_EXCEPT_NOT_FOUND,
  IGNORE_ERRORS, 
  REPORT_EXCEPT_NON_UNIQUE,
  IGNORE_EXCEPT_NON_UNIQUE
};

enum enum_schema_table_state
{
  NOT_PROCESSED= 0,
  PROCESSED_BY_CREATE_SORT_INDEX,
  PROCESSED_BY_JOIN_EXEC
};


enum tmp_table_type
{
  NO_TMP_TABLE, 
  NON_TRANSACTIONAL_TMP_TABLE, 
  TRANSACTIONAL_TMP_TABLE,
  INTERNAL_TMP_TABLE, 
  SYSTEM_TMP_TABLE, 
  TMP_TABLE_FRM_FILE_ONLY
};

/*
  Values in this enum are used to indicate how a tables TIMESTAMP field
  should be treated. It can be set to the current timestamp on insert or
  update or both.
  WARNING: The values are used for bit operations. If you change the
  enum, you must keep the bitwise relation of the values. For example:
  (int) TIMESTAMP_AUTO_SET_ON_BOTH must be equal to
  (int) TIMESTAMP_AUTO_SET_ON_INSERT | (int) TIMESTAMP_AUTO_SET_ON_UPDATE.
  We use an enum here so that the debugger can display the value names.
*/
enum timestamp_auto_set_type
{
  TIMESTAMP_NO_AUTO_SET= 0, 
  TIMESTAMP_AUTO_SET_ON_INSERT= 1,
  TIMESTAMP_AUTO_SET_ON_UPDATE= 2, 
  TIMESTAMP_AUTO_SET_ON_BOTH= 3
};

enum ha_choice 
{ 
  HA_CHOICE_UNDEF,
  HA_CHOICE_NO,
  HA_CHOICE_YES 
};

enum enum_ha_read_modes 
{ 
  RFIRST, 
  RNEXT, 
  RPREV, 
  RLAST, 
  RKEY, 
  RNEXT_SAME 
};

enum enum_tx_isolation 
{
  ISO_READ_UNCOMMITTED, 
  ISO_READ_COMMITTED,
  ISO_REPEATABLE_READ, 
  ISO_SERIALIZABLE
};


enum SHOW_COMP_OPTION 
{ 
  SHOW_OPTION_YES, 
  SHOW_OPTION_NO, 
  SHOW_OPTION_DISABLED
};

/*
  When a command is added here, be sure it's also added in mysqld.cc
  in "struct show_var_st status_vars[]= {" ...

  If the command returns a result set or is not allowed in stored
  functions or triggers, please also make sure that
  sp_get_flags_for_command (sp_head.cc) returns proper flags for the
  added SQLCOM_.
*/

enum enum_sql_command {
  SQLCOM_SELECT, 
  SQLCOM_CREATE_TABLE, 
  SQLCOM_CREATE_INDEX, 
  SQLCOM_ALTER_TABLE,
  SQLCOM_UPDATE, 
  SQLCOM_INSERT, 
  SQLCOM_INSERT_SELECT,
  SQLCOM_DELETE, 
  SQLCOM_TRUNCATE, 
  SQLCOM_DROP_TABLE, 
  SQLCOM_DROP_INDEX,
  SQLCOM_SHOW_DATABASES, 
  SQLCOM_SHOW_TABLES, 
  SQLCOM_SHOW_FIELDS,
  SQLCOM_SHOW_KEYS, 
  SQLCOM_SHOW_VARIABLES, 
  SQLCOM_SHOW_STATUS,
  SQLCOM_SHOW_ENGINE_STATUS, 
  SQLCOM_SHOW_ENGINE_MUTEX,
  SQLCOM_SHOW_PROCESSLIST,
  SQLCOM_SHOW_CREATE,
  SQLCOM_SHOW_CREATE_DB,
  SQLCOM_SHOW_TABLE_STATUS,
  SQLCOM_LOAD,
  SQLCOM_SET_OPTION,
  SQLCOM_UNLOCK_TABLES,
  SQLCOM_CHANGE_DB, 
  SQLCOM_CREATE_DB, 
  SQLCOM_DROP_DB, 
  SQLCOM_ALTER_DB,
  SQLCOM_REPLACE, 
  SQLCOM_REPLACE_SELECT,
  SQLCOM_OPTIMIZE, 
  SQLCOM_CHECK,
  SQLCOM_FLUSH, 
  SQLCOM_KILL, 
  SQLCOM_ANALYZE,
  SQLCOM_ROLLBACK, 
  SQLCOM_ROLLBACK_TO_SAVEPOINT,
  SQLCOM_COMMIT, 
  SQLCOM_SAVEPOINT, 
  SQLCOM_RELEASE_SAVEPOINT,
  SQLCOM_BEGIN,
  SQLCOM_RENAME_TABLE,
  SQLCOM_SHOW_OPEN_TABLES,
  SQLCOM_SHOW_WARNS,
  SQLCOM_EMPTY_QUERY,
  SQLCOM_SHOW_ERRORS,
  SQLCOM_CHECKSUM,
  /*
    When a command is added here, be sure it's also added in mysqld.cc
    in "struct show_var_st status_vars[]= {" ...
  */
  /* This should be the last !!! */
  SQLCOM_END
};

enum enum_duplicates 
{ 
  DUP_ERROR, 
  DUP_REPLACE, 
  DUP_UPDATE 
};


#endif /* DRIZZLED_ENUM_H */

1089.1.11 by Brian Aker Cleanup on enum	1	/* -- mode: c++; c-basic-offset: 2; indent-tabs-mode: nil; --
	2	* vim:expandtab:shiftwidth=2:tabstop=2:smarttab:
	3	*
	4	* Copyright (C) 2009 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; either version 2 of the License, or
	9	* (at your option) any later version.
	10	*
	11	* This program is distributed in the hope that it will be useful,
	12	* but WITHOUT ANY WARRANTY; without even the implied warranty of
	13	* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
	14	* GNU General Public License for more details.
	15	*
	16	* You should have received a copy of the GNU General Public License
	17	* along with this program; if not, write to the Free Software
	18	* Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1301 USA
	19	*/
	20
	21	#ifndef DRIZZLED_ENUM_H
	22	#define DRIZZLED_ENUM_H
	23
	24	/**
	25	Query type constants.
	26
	27	QT_ORDINARY -- ordinary SQL query.
	28	QT_IS -- SQL query to be shown in INFORMATION_SCHEMA (in utf8 and without
	29	character set introducers).
	30
	31	@TODO
	32
	33	Move this out of here once Stew's done with UDF breakout. The following headers need it:
	34
	35	sql_lex.h --> included by session.h
	36	item.h
	37	table.h
	38	item_func.h
	39	item_subselect.h
	40	item_timefunc.h
	41	item_sum.h
	42	item_cmpfunc.h
	43	item_strfunc.h
	44	*/
	45	enum enum_query_type
	46	{
	47	QT_ORDINARY,
	48	QT_IS
	49	};
	50
	51
	52	/**
	53	* @TODO Move to a separate header?
	54	*
	55	* It's needed by item.h and field.h, which are both inter-dependent
	56	* and contain forward declarations of many structs/classes in the
	57	* other header file.
	58	*
	59	* What is needed is a separate header file that is included
	60	* by both item.h and field.h to resolve inter-dependencies
	61	*
	62	* But, probably want to hold off on this until Stew finished the UDF cleanup
	63	*/
	64	enum Derivation
65	{
66	DERIVATION_IGNORABLE= 5,
67	DERIVATION_COERCIBLE= 4,
68	DERIVATION_SYSCONST= 3,
69	DERIVATION_IMPLICIT= 2,
70	DERIVATION_NONE= 1,
71	DERIVATION_EXPLICIT= 0
72	};
73
74	/**
75	* Opening modes for open_temporary_table and open_table_from_share
76	*
77	* @TODO Put this into an appropriate header. It is only needed in:
78	*
79	* table.cc
80	* sql_base.cc
81	*/
82	enum open_table_mode
83	{
84	OTM_OPEN= 0,
85	OTM_CREATE= 1,
86	OTM_ALTER= 2
87	};
88
89	enum enum_parsing_place
90	{
91	NO_MATTER,
92	IN_HAVING,
93	SELECT_LIST,
94	IN_WHERE,
1100.2.3 by Brian Aker Remove final bits on SJ	95	IN_ON
1100.2.3 by Brian Aker Remove final bits on SJ	96	};
1089.1.11 by Brian Aker Cleanup on enum	97
	98	enum enum_mysql_completiontype
	99	{
	100	ROLLBACK_RELEASE= -2,
	101	ROLLBACK= 1,
	102	ROLLBACK_AND_CHAIN= 7,
	103	COMMIT_RELEASE= -1,
	104	COMMIT= 0,
	105	COMMIT_AND_CHAIN= 6
	106	};
	107
	108	enum enum_check_fields
	109	{
	110	CHECK_FIELD_IGNORE,
	111	CHECK_FIELD_WARN,
	112	CHECK_FIELD_ERROR_FOR_NULL
	113	};
	114
	115	enum enum_var_type
	116	{
	117	OPT_DEFAULT= 0,
	118	OPT_SESSION,
	119	OPT_GLOBAL
	120	};
	121
	122	enum row_type
	123	{
	124	ROW_TYPE_NOT_USED=-1,
	125	ROW_TYPE_DEFAULT,
	126	ROW_TYPE_FIXED,
	127	ROW_TYPE_DYNAMIC,
	128	ROW_TYPE_COMPRESSED,
	129	ROW_TYPE_REDUNDANT,
	130	ROW_TYPE_COMPACT,
	131	ROW_TYPE_PAGE
	132	};
	133
	134	enum column_format_type
	135	{
	136	COLUMN_FORMAT_TYPE_NOT_USED= -1,
	137	COLUMN_FORMAT_TYPE_DEFAULT= 0,
	138	COLUMN_FORMAT_TYPE_FIXED= 1,
	139	COLUMN_FORMAT_TYPE_DYNAMIC= 2
	140	};
	141
	142
	143	/**
	144	Category of table found in the table share.
	145	*/
	146	enum enum_table_category
	147	{
	148	/**
	149	Unknown value.
	150	*/
	151	TABLE_UNKNOWN_CATEGORY=0,
	152
	153	/**
	154	Temporary table.
	155	The table is visible only in the session.
	156	Therefore,
	157	- FLUSH TABLES WITH READ LOCK
	158	- SET GLOBAL READ_ONLY = ON
	159	do not apply to this table.
	160	Note that LOCK Table t FOR READ/WRITE
161	can be used on temporary tables.
162	Temporary tables are not part of the table cache.
163	*/
164	TABLE_CATEGORY_TEMPORARY=1,
165
166	/**
167	User table.
168	These tables do honor:
169	- LOCK Table t FOR READ/WRITE
170	- FLUSH TABLES WITH READ LOCK
171	- SET GLOBAL READ_ONLY = ON
172	User tables are cached in the table cache.
173	*/
174	TABLE_CATEGORY_USER=2,
175
176	/**
177	Information schema tables.
178	These tables are an interface provided by the system
179	to inspect the system metadata.
180	These tables do not honor:
181	- LOCK Table t FOR READ/WRITE
182	- FLUSH TABLES WITH READ LOCK
183	- SET GLOBAL READ_ONLY = ON
184	as there is no point in locking explicitely
185	an INFORMATION_SCHEMA table.
186	Nothing is directly written to information schema tables.
187	Note that this value is not used currently,
188	since information schema tables are not shared,
189	but implemented as session specific temporary tables.
190	*/
191	/*
192	TODO: Fixing the performance issues of I_S will lead
193	to I_S tables in the table cache, which should use
194	this table type.
195	*/
196	TABLE_CATEGORY_INFORMATION
197	};
198
199	enum enum_enable_or_disable
200	{
201	LEAVE_AS_IS,
202	ENABLE,
203	DISABLE
204	};
205
206
207	enum enum_mark_columns
208	{
209	MARK_COLUMNS_NONE,
210	MARK_COLUMNS_READ,
211	MARK_COLUMNS_WRITE
212	};
213
214	enum enum_filetype
215	{
216	FILETYPE_CSV,
217	FILETYPE_XML
218	};
219
220	enum find_item_error_report_type
221	{
222	REPORT_ALL_ERRORS,
223	REPORT_EXCEPT_NOT_FOUND,
224	IGNORE_ERRORS,
225	REPORT_EXCEPT_NON_UNIQUE,
226	IGNORE_EXCEPT_NON_UNIQUE
227	};
228
229	enum enum_schema_table_state
230	{
231	NOT_PROCESSED= 0,
232	PROCESSED_BY_CREATE_SORT_INDEX,
233	PROCESSED_BY_JOIN_EXEC
234	};
235
236
237	enum tmp_table_type
238	{
239	NO_TMP_TABLE,
240	NON_TRANSACTIONAL_TMP_TABLE,
241	TRANSACTIONAL_TMP_TABLE,
242	INTERNAL_TMP_TABLE,
243	SYSTEM_TMP_TABLE,
244	TMP_TABLE_FRM_FILE_ONLY
245	};
246
247	/*
248	Values in this enum are used to indicate how a tables TIMESTAMP field
249	should be treated. It can be set to the current timestamp on insert or
250	update or both.
251	WARNING: The values are used for bit operations. If you change the
252	enum, you must keep the bitwise relation of the values. For example:
253	(int) TIMESTAMP_AUTO_SET_ON_BOTH must be equal to
254	(int) TIMESTAMP_AUTO_SET_ON_INSERT \| (int) TIMESTAMP_AUTO_SET_ON_UPDATE.
255	We use an enum here so that the debugger can display the value names.
256	*/
257	enum timestamp_auto_set_type
258	{
259	TIMESTAMP_NO_AUTO_SET= 0,
260	TIMESTAMP_AUTO_SET_ON_INSERT= 1,
261	TIMESTAMP_AUTO_SET_ON_UPDATE= 2,
262	TIMESTAMP_AUTO_SET_ON_BOTH= 3
263	};
264
265	enum ha_choice
266	{
267	HA_CHOICE_UNDEF,
268	HA_CHOICE_NO,
269	HA_CHOICE_YES
270	};
271
272	enum enum_ha_read_modes
273	{
274	RFIRST,
275	RNEXT,
276	RPREV,
277	RLAST,
278	RKEY,
279	RNEXT_SAME
280	};
281
282	enum enum_tx_isolation
283	{
284	ISO_READ_UNCOMMITTED,
285	ISO_READ_COMMITTED,
286	ISO_REPEATABLE_READ,
287	ISO_SERIALIZABLE
288	};
289
290
291	enum SHOW_COMP_OPTION
292	{
293	SHOW_OPTION_YES,
294	SHOW_OPTION_NO,
295	SHOW_OPTION_DISABLED
296	};
297
298	/*
299	When a command is added here, be sure it's also added in mysqld.cc
300	in "struct show_var_st status_vars[]= {" ...
301
302	If the command returns a result set or is not allowed in stored
303	functions or triggers, please also make sure that
304	sp_get_flags_for_command (sp_head.cc) returns proper flags for the
305	added SQLCOM_.
306	*/
307
308	enum enum_sql_command {
309	SQLCOM_SELECT,
310	SQLCOM_CREATE_TABLE,
311	SQLCOM_CREATE_INDEX,
312	SQLCOM_ALTER_TABLE,
313	SQLCOM_UPDATE,
314	SQLCOM_INSERT,
315	SQLCOM_INSERT_SELECT,
316	SQLCOM_DELETE,
317	SQLCOM_TRUNCATE,
318	SQLCOM_DROP_TABLE,
319	SQLCOM_DROP_INDEX,
320	SQLCOM_SHOW_DATABASES,
321	SQLCOM_SHOW_TABLES,
322	SQLCOM_SHOW_FIELDS,
323	SQLCOM_SHOW_KEYS,
324	SQLCOM_SHOW_VARIABLES,
325	SQLCOM_SHOW_STATUS,
326	SQLCOM_SHOW_ENGINE_STATUS,
327	SQLCOM_SHOW_ENGINE_MUTEX,
328	SQLCOM_SHOW_PROCESSLIST,
329	SQLCOM_SHOW_CREATE,
330	SQLCOM_SHOW_CREATE_DB,
331	SQLCOM_SHOW_TABLE_STATUS,
332	SQLCOM_LOAD,
333	SQLCOM_SET_OPTION,
334	SQLCOM_UNLOCK_TABLES,
335	SQLCOM_CHANGE_DB,
336	SQLCOM_CREATE_DB,
337	SQLCOM_DROP_DB,
338	SQLCOM_ALTER_DB,
339	SQLCOM_REPLACE,
340	SQLCOM_REPLACE_SELECT,
341	SQLCOM_OPTIMIZE,
342	SQLCOM_CHECK,
343	SQLCOM_FLUSH,
344	SQLCOM_KILL,
345	SQLCOM_ANALYZE,
346	SQLCOM_ROLLBACK,
347	SQLCOM_ROLLBACK_TO_SAVEPOINT,
348	SQLCOM_COMMIT,
349	SQLCOM_SAVEPOINT,
350	SQLCOM_RELEASE_SAVEPOINT,
351	SQLCOM_BEGIN,
352	SQLCOM_RENAME_TABLE,
353	SQLCOM_SHOW_OPEN_TABLES,
354	SQLCOM_SHOW_WARNS,
355	SQLCOM_EMPTY_QUERY,
356	SQLCOM_SHOW_ERRORS,
357	SQLCOM_CHECKSUM,
358	/*
359	When a command is added here, be sure it's also added in mysqld.cc
360	in "struct show_var_st status_vars[]= {" ...
361	*/
362	/* This should be the last !!! */
363	SQLCOM_END
364	};
365
366	enum enum_duplicates
367	{
368	DUP_ERROR,
369	DUP_REPLACE,
370	DUP_UPDATE
371	};
372
373
374	#endif /* DRIZZLED_ENUM_H */