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

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

/* -*- 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
};

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
};

/*
  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 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	enum enum_parsing_place
75	{
76	NO_MATTER,
77	IN_HAVING,
78	SELECT_LIST,
79	IN_WHERE,
1100.2.3 by Brian Aker Remove final bits on SJ	80	IN_ON
1100.2.3 by Brian Aker Remove final bits on SJ	81	};
1089.1.11 by Brian Aker Cleanup on enum	82
	83	enum enum_mysql_completiontype
	84	{
	85	ROLLBACK_RELEASE= -2,
	86	ROLLBACK= 1,
	87	ROLLBACK_AND_CHAIN= 7,
	88	COMMIT_RELEASE= -1,
	89	COMMIT= 0,
	90	COMMIT_AND_CHAIN= 6
	91	};
	92
	93	enum enum_check_fields
	94	{
	95	CHECK_FIELD_IGNORE,
	96	CHECK_FIELD_WARN,
	97	CHECK_FIELD_ERROR_FOR_NULL
	98	};
	99
	100	enum enum_var_type
	101	{
	102	OPT_DEFAULT= 0,
	103	OPT_SESSION,
	104	OPT_GLOBAL
	105	};
	106
	107	enum row_type
	108	{
	109	ROW_TYPE_NOT_USED=-1,
	110	ROW_TYPE_DEFAULT,
	111	ROW_TYPE_FIXED,
	112	ROW_TYPE_DYNAMIC,
	113	ROW_TYPE_COMPRESSED,
	114	ROW_TYPE_REDUNDANT,
	115	ROW_TYPE_COMPACT,
	116	ROW_TYPE_PAGE
	117	};
	118
	119	enum column_format_type
	120	{
	121	COLUMN_FORMAT_TYPE_NOT_USED= -1,
	122	COLUMN_FORMAT_TYPE_DEFAULT= 0,
	123	COLUMN_FORMAT_TYPE_FIXED= 1,
	124	COLUMN_FORMAT_TYPE_DYNAMIC= 2
	125	};
	126
	127
	128	/**
	129	Category of table found in the table share.
	130	*/
	131	enum enum_table_category
	132	{
	133	/**
	134	Unknown value.
	135	*/
	136	TABLE_UNKNOWN_CATEGORY=0,
	137
	138	/**
	139	Temporary table.
	140	The table is visible only in the session.
	141	Therefore,
	142	- FLUSH TABLES WITH READ LOCK
	143	- SET GLOBAL READ_ONLY = ON
	144	do not apply to this table.
	145	Note that LOCK Table t FOR READ/WRITE
146	can be used on temporary tables.
147	Temporary tables are not part of the table cache.
148	*/
149	TABLE_CATEGORY_TEMPORARY=1,
150
151	/**
152	User table.
153	These tables do honor:
154	- LOCK Table t FOR READ/WRITE
155	- FLUSH TABLES WITH READ LOCK
156	- SET GLOBAL READ_ONLY = ON
157	User tables are cached in the table cache.
158	*/
159	TABLE_CATEGORY_USER=2,
160
161	/**
162	Information schema tables.
163	These tables are an interface provided by the system
164	to inspect the system metadata.
165	These tables do not honor:
166	- LOCK Table t FOR READ/WRITE
167	- FLUSH TABLES WITH READ LOCK
168	- SET GLOBAL READ_ONLY = ON
169	as there is no point in locking explicitely
170	an INFORMATION_SCHEMA table.
171	Nothing is directly written to information schema tables.
172	Note that this value is not used currently,
173	since information schema tables are not shared,
174	but implemented as session specific temporary tables.
175	*/
176	/*
177	TODO: Fixing the performance issues of I_S will lead
178	to I_S tables in the table cache, which should use
179	this table type.
180	*/
181	TABLE_CATEGORY_INFORMATION
182	};
183
184	enum enum_enable_or_disable
185	{
186	LEAVE_AS_IS,
187	ENABLE,
188	DISABLE
189	};
190
191
192	enum enum_mark_columns
193	{
194	MARK_COLUMNS_NONE,
195	MARK_COLUMNS_READ,
196	MARK_COLUMNS_WRITE
197	};
198
199	enum enum_filetype
200	{
201	FILETYPE_CSV,
202	FILETYPE_XML
203	};
204
205	enum find_item_error_report_type
206	{
207	REPORT_ALL_ERRORS,
208	REPORT_EXCEPT_NOT_FOUND,
209	IGNORE_ERRORS,
210	REPORT_EXCEPT_NON_UNIQUE,
211	IGNORE_EXCEPT_NON_UNIQUE
212	};
213
214	enum enum_schema_table_state
215	{
216	NOT_PROCESSED= 0,
217	PROCESSED_BY_CREATE_SORT_INDEX,
218	PROCESSED_BY_JOIN_EXEC
219	};
220
221
222	enum tmp_table_type
223	{
224	NO_TMP_TABLE,
225	NON_TRANSACTIONAL_TMP_TABLE,
226	TRANSACTIONAL_TMP_TABLE,
227	INTERNAL_TMP_TABLE,
1217.1.2 by Brian Aker Remove dead TMP_TABLE_FRM_FILE_ONLY enum type for tmp tables.	228	SYSTEM_TMP_TABLE
1089.1.11 by Brian Aker Cleanup on enum	229	};
	230
	231	/*
	232	Values in this enum are used to indicate how a tables TIMESTAMP field
	233	should be treated. It can be set to the current timestamp on insert or
	234	update or both.
	235	WARNING: The values are used for bit operations. If you change the
	236	enum, you must keep the bitwise relation of the values. For example:
	237	(int) TIMESTAMP_AUTO_SET_ON_BOTH must be equal to
	238	(int) TIMESTAMP_AUTO_SET_ON_INSERT \| (int) TIMESTAMP_AUTO_SET_ON_UPDATE.
	239	We use an enum here so that the debugger can display the value names.
	240	*/
	241	enum timestamp_auto_set_type
	242	{
	243	TIMESTAMP_NO_AUTO_SET= 0,
	244	TIMESTAMP_AUTO_SET_ON_INSERT= 1,
	245	TIMESTAMP_AUTO_SET_ON_UPDATE= 2,
	246	TIMESTAMP_AUTO_SET_ON_BOTH= 3
	247	};
	248
	249	enum enum_ha_read_modes
	250	{
	251	RFIRST,
	252	RNEXT,
	253	RPREV,
	254	RLAST,
	255	RKEY,
	256	RNEXT_SAME
	257	};
	258
	259	enum enum_tx_isolation
	260	{
	261	ISO_READ_UNCOMMITTED,
	262	ISO_READ_COMMITTED,
	263	ISO_REPEATABLE_READ,
	264	ISO_SERIALIZABLE
	265	};
	266
	267
	268	enum SHOW_COMP_OPTION
	269	{
	270	SHOW_OPTION_YES,
	271	SHOW_OPTION_NO,
	272	SHOW_OPTION_DISABLED
	273	};
	274
	275	/*
	276	When a command is added here, be sure it's also added in mysqld.cc
	277	in "struct show_var_st status_vars[]= {" ...
	278
	279	If the command returns a result set or is not allowed in stored
	280	functions or triggers, please also make sure that
	281	sp_get_flags_for_command (sp_head.cc) returns proper flags for the
	282	added SQLCOM_.
	283	*/
	284
	285	enum enum_sql_command {
	286	SQLCOM_SELECT,
	287	SQLCOM_CREATE_TABLE,
	288	SQLCOM_CREATE_INDEX,
	289	SQLCOM_ALTER_TABLE,
	290	SQLCOM_UPDATE,
	291	SQLCOM_INSERT,
	292	SQLCOM_INSERT_SELECT,
293	SQLCOM_DELETE,
294	SQLCOM_TRUNCATE,
295	SQLCOM_DROP_TABLE,
296	SQLCOM_DROP_INDEX,
297	SQLCOM_SHOW_DATABASES,
298	SQLCOM_SHOW_TABLES,
299	SQLCOM_SHOW_FIELDS,
300	SQLCOM_SHOW_KEYS,
301	SQLCOM_SHOW_VARIABLES,
302	SQLCOM_SHOW_STATUS,
303	SQLCOM_SHOW_ENGINE_STATUS,
304	SQLCOM_SHOW_ENGINE_MUTEX,
305	SQLCOM_SHOW_PROCESSLIST,
306	SQLCOM_SHOW_CREATE,
307	SQLCOM_SHOW_CREATE_DB,
308	SQLCOM_SHOW_TABLE_STATUS,
309	SQLCOM_LOAD,
310	SQLCOM_SET_OPTION,
311	SQLCOM_UNLOCK_TABLES,
312	SQLCOM_CHANGE_DB,
313	SQLCOM_CREATE_DB,
314	SQLCOM_DROP_DB,
315	SQLCOM_ALTER_DB,
316	SQLCOM_REPLACE,
317	SQLCOM_REPLACE_SELECT,
318	SQLCOM_OPTIMIZE,
319	SQLCOM_CHECK,
320	SQLCOM_FLUSH,
321	SQLCOM_KILL,
322	SQLCOM_ANALYZE,
323	SQLCOM_ROLLBACK,
324	SQLCOM_ROLLBACK_TO_SAVEPOINT,
325	SQLCOM_COMMIT,
326	SQLCOM_SAVEPOINT,
327	SQLCOM_RELEASE_SAVEPOINT,
328	SQLCOM_BEGIN,
329	SQLCOM_RENAME_TABLE,
330	SQLCOM_SHOW_OPEN_TABLES,
331	SQLCOM_SHOW_WARNS,
332	SQLCOM_EMPTY_QUERY,
333	SQLCOM_SHOW_ERRORS,
334	SQLCOM_CHECKSUM,
335	/*
336	When a command is added here, be sure it's also added in mysqld.cc
337	in "struct show_var_st status_vars[]= {" ...
338	*/
339	/* This should be the last !!! */
340	SQLCOM_END
341	};
342
343	enum enum_duplicates
344	{
345	DUP_ERROR,
346	DUP_REPLACE,
347	DUP_UPDATE
348	};
349
350	#endif /* DRIZZLED_ENUM_H */