/*
* Copyright 2004-2019 H2 Group. Multiple-Licensed under the MPL 2.0,
* and the EPL 1.0 (http://h2database.com/html/license.html).
* Initial Developer: H2 Group
*/
package org.h2.command.dml;
import java.util.ArrayList;
The list of setting for a SET statement.
/**
* The list of setting for a SET statement.
*/
public class SetTypes {
The type of a SET IGNORECASE statement.
/**
* The type of a SET IGNORECASE statement.
*/
public static final int IGNORECASE = 1;
The type of a SET MAX_LOG_SIZE statement.
/**
* The type of a SET MAX_LOG_SIZE statement.
*/
public static final int MAX_LOG_SIZE = 2;
The type of a SET MODE statement.
/**
* The type of a SET MODE statement.
*/
public static final int MODE = 3;
The type of a SET READONLY statement.
/**
* The type of a SET READONLY statement.
*/
public static final int READONLY = 4;
The type of a SET LOCK_TIMEOUT statement.
/**
* The type of a SET LOCK_TIMEOUT statement.
*/
public static final int LOCK_TIMEOUT = 5;
The type of a SET DEFAULT_LOCK_TIMEOUT statement.
/**
* The type of a SET DEFAULT_LOCK_TIMEOUT statement.
*/
public static final int DEFAULT_LOCK_TIMEOUT = 6;
The type of a SET DEFAULT_TABLE_TYPE statement.
/**
* The type of a SET DEFAULT_TABLE_TYPE statement.
*/
public static final int DEFAULT_TABLE_TYPE = 7;
The type of a SET CACHE_SIZE statement.
/**
* The type of a SET CACHE_SIZE statement.
*/
public static final int CACHE_SIZE = 8;
The type of a SET TRACE_LEVEL_SYSTEM_OUT statement.
/**
* The type of a SET TRACE_LEVEL_SYSTEM_OUT statement.
*/
public static final int TRACE_LEVEL_SYSTEM_OUT = 9;
The type of a SET TRACE_LEVEL_FILE statement.
/**
* The type of a SET TRACE_LEVEL_FILE statement.
*/
public static final int TRACE_LEVEL_FILE = 10;
The type of a SET TRACE_MAX_FILE_SIZE statement.
/**
* The type of a SET TRACE_MAX_FILE_SIZE statement.
*/
public static final int TRACE_MAX_FILE_SIZE = 11;
The type of a SET COLLATION statement.
/**
* The type of a SET COLLATION statement.
*/
public static final int COLLATION = 12;
The type of a SET CLUSTER statement.
/**
* The type of a SET CLUSTER statement.
*/
public static final int CLUSTER = 13;
The type of a SET WRITE_DELAY statement.
/**
* The type of a SET WRITE_DELAY statement.
*/
public static final int WRITE_DELAY = 14;
The type of a SET DATABASE_EVENT_LISTENER statement.
/**
* The type of a SET DATABASE_EVENT_LISTENER statement.
*/
public static final int DATABASE_EVENT_LISTENER = 15;
The type of a SET MAX_MEMORY_ROWS statement.
/**
* The type of a SET MAX_MEMORY_ROWS statement.
*/
public static final int MAX_MEMORY_ROWS = 16;
The type of a SET LOCK_MODE statement.
/**
* The type of a SET LOCK_MODE statement.
*/
public static final int LOCK_MODE = 17;
The type of a SET DB_CLOSE_DELAY statement.
/**
* The type of a SET DB_CLOSE_DELAY statement.
*/
public static final int DB_CLOSE_DELAY = 18;
The type of a SET LOG statement.
/**
* The type of a SET LOG statement.
*/
public static final int LOG = 19;
The type of a SET THROTTLE statement.
/**
* The type of a SET THROTTLE statement.
*/
public static final int THROTTLE = 20;
The type of a SET MAX_MEMORY_UNDO statement.
/**
* The type of a SET MAX_MEMORY_UNDO statement.
*/
public static final int MAX_MEMORY_UNDO = 21;
The type of a SET MAX_LENGTH_INPLACE_LOB statement.
/**
* The type of a SET MAX_LENGTH_INPLACE_LOB statement.
*/
public static final int MAX_LENGTH_INPLACE_LOB = 22;
The type of a SET COMPRESS_LOB statement.
/**
* The type of a SET COMPRESS_LOB statement.
*/
public static final int COMPRESS_LOB = 23;
The type of a SET ALLOW_LITERALS statement.
/**
* The type of a SET ALLOW_LITERALS statement.
*/
public static final int ALLOW_LITERALS = 24;
The type of a SET MULTI_THREADED statement.
/**
* The type of a SET MULTI_THREADED statement.
*/
public static final int MULTI_THREADED = 25;
The type of a SET SCHEMA statement.
/**
* The type of a SET SCHEMA statement.
*/
public static final int SCHEMA = 26;
The type of a SET OPTIMIZE_REUSE_RESULTS statement.
/**
* The type of a SET OPTIMIZE_REUSE_RESULTS statement.
*/
public static final int OPTIMIZE_REUSE_RESULTS = 27;
The type of a SET SCHEMA_SEARCH_PATH statement.
/**
* The type of a SET SCHEMA_SEARCH_PATH statement.
*/
public static final int SCHEMA_SEARCH_PATH = 28;
The type of a SET UNDO_LOG statement.
/**
* The type of a SET UNDO_LOG statement.
*/
public static final int UNDO_LOG = 29;
The type of a SET REFERENTIAL_INTEGRITY statement.
/**
* The type of a SET REFERENTIAL_INTEGRITY statement.
*/
public static final int REFERENTIAL_INTEGRITY = 30;
The type of a SET MAX_OPERATION_MEMORY statement.
/**
* The type of a SET MAX_OPERATION_MEMORY statement.
*/
public static final int MAX_OPERATION_MEMORY = 31;
The type of a SET EXCLUSIVE statement.
/**
* The type of a SET EXCLUSIVE statement.
*/
public static final int EXCLUSIVE = 32;
The type of a SET CREATE_BUILD statement.
/**
* The type of a SET CREATE_BUILD statement.
*/
public static final int CREATE_BUILD = 33;
The type of a SET \@VARIABLE statement.
/**
* The type of a SET \@VARIABLE statement.
*/
public static final int VARIABLE = 34;
The type of a SET QUERY_TIMEOUT statement.
/**
* The type of a SET QUERY_TIMEOUT statement.
*/
public static final int QUERY_TIMEOUT = 35;
The type of a SET REDO_LOG_BINARY statement.
/**
* The type of a SET REDO_LOG_BINARY statement.
*/
public static final int REDO_LOG_BINARY = 36;
The type of a SET BINARY_COLLATION statement.
/**
* The type of a SET BINARY_COLLATION statement.
*/
public static final int BINARY_COLLATION = 37;
The type of a SET JAVA_OBJECT_SERIALIZER statement.
/**
* The type of a SET JAVA_OBJECT_SERIALIZER statement.
*/
public static final int JAVA_OBJECT_SERIALIZER = 38;
The type of a SET RETENTION_TIME statement.
/**
* The type of a SET RETENTION_TIME statement.
*/
public static final int RETENTION_TIME = 39;
The type of a SET QUERY_STATISTICS statement.
/**
* The type of a SET QUERY_STATISTICS statement.
*/
public static final int QUERY_STATISTICS = 40;
The type of a SET QUERY_STATISTICS_MAX_ENTRIES statement.
/**
* The type of a SET QUERY_STATISTICS_MAX_ENTRIES statement.
*/
public static final int QUERY_STATISTICS_MAX_ENTRIES = 41;
The type of a SET ROW_FACTORY statement.
/**
* The type of a SET ROW_FACTORY statement.
*/
public static final int ROW_FACTORY = 42;
The type of SET BATCH_JOINS statement.
/**
* The type of SET BATCH_JOINS statement.
*/
public static final int BATCH_JOINS = 43;
The type of SET FORCE_JOIN_ORDER statement.
/**
* The type of SET FORCE_JOIN_ORDER statement.
*/
public static final int FORCE_JOIN_ORDER = 44;
The type of SET LAZY_QUERY_EXECUTION statement.
/**
* The type of SET LAZY_QUERY_EXECUTION statement.
*/
public static final int LAZY_QUERY_EXECUTION = 45;
The type of SET BUILTIN_ALIAS_OVERRIDE statement.
/**
* The type of SET BUILTIN_ALIAS_OVERRIDE statement.
*/
public static final int BUILTIN_ALIAS_OVERRIDE = 46;
The type of a SET COLUMN_NAME_RULES statement.
/**
* The type of a SET COLUMN_NAME_RULES statement.
*/
public static final int COLUMN_NAME_RULES = 47;
The type of a SET AUTHENTICATOR statement.
/**
* The type of a SET AUTHENTICATOR statement.
*/
public static final int AUTHENTICATOR = 48;
The type of a SET LOCAL_RESULT_FACTORY statement.
/**
* The type of a SET LOCAL_RESULT_FACTORY statement.
*/
public static final int LOCAL_RESULT_FACTORY = 49;
The type of a SET UUID_COLLATION statement.
/**
* The type of a SET UUID_COLLATION statement.
*/
public static final int UUID_COLLATION = 50;
private static final int COUNT = UUID_COLLATION + 1;
private static final ArrayList<String> TYPES;
private SetTypes() {
// utility class
}
static {
ArrayList<String> list = new ArrayList<>(COUNT);
list.add(null);
list.add(IGNORECASE, "IGNORECASE");
list.add(MAX_LOG_SIZE, "MAX_LOG_SIZE");
list.add(MODE, "MODE");
list.add(READONLY, "READONLY");
list.add(LOCK_TIMEOUT, "LOCK_TIMEOUT");
list.add(DEFAULT_LOCK_TIMEOUT, "DEFAULT_LOCK_TIMEOUT");
list.add(DEFAULT_TABLE_TYPE, "DEFAULT_TABLE_TYPE");
list.add(CACHE_SIZE, "CACHE_SIZE");
list.add(TRACE_LEVEL_SYSTEM_OUT, "TRACE_LEVEL_SYSTEM_OUT");
list.add(TRACE_LEVEL_FILE, "TRACE_LEVEL_FILE");
list.add(TRACE_MAX_FILE_SIZE, "TRACE_MAX_FILE_SIZE");
list.add(COLLATION, "COLLATION");
list.add(CLUSTER, "CLUSTER");
list.add(WRITE_DELAY, "WRITE_DELAY");
list.add(DATABASE_EVENT_LISTENER, "DATABASE_EVENT_LISTENER");
list.add(MAX_MEMORY_ROWS, "MAX_MEMORY_ROWS");
list.add(LOCK_MODE, "LOCK_MODE");
list.add(DB_CLOSE_DELAY, "DB_CLOSE_DELAY");
list.add(LOG, "LOG");
list.add(THROTTLE, "THROTTLE");
list.add(MAX_MEMORY_UNDO, "MAX_MEMORY_UNDO");
list.add(MAX_LENGTH_INPLACE_LOB, "MAX_LENGTH_INPLACE_LOB");
list.add(COMPRESS_LOB, "COMPRESS_LOB");
list.add(ALLOW_LITERALS, "ALLOW_LITERALS");
list.add(MULTI_THREADED, "MULTI_THREADED");
list.add(SCHEMA, "SCHEMA");
list.add(OPTIMIZE_REUSE_RESULTS, "OPTIMIZE_REUSE_RESULTS");
list.add(SCHEMA_SEARCH_PATH, "SCHEMA_SEARCH_PATH");
list.add(UNDO_LOG, "UNDO_LOG");
list.add(REFERENTIAL_INTEGRITY, "REFERENTIAL_INTEGRITY");
list.add(MAX_OPERATION_MEMORY, "MAX_OPERATION_MEMORY");
list.add(EXCLUSIVE, "EXCLUSIVE");
list.add(CREATE_BUILD, "CREATE_BUILD");
list.add(VARIABLE, "@");
list.add(QUERY_TIMEOUT, "QUERY_TIMEOUT");
list.add(REDO_LOG_BINARY, "REDO_LOG_BINARY");
list.add(BINARY_COLLATION, "BINARY_COLLATION");
list.add(JAVA_OBJECT_SERIALIZER, "JAVA_OBJECT_SERIALIZER");
list.add(RETENTION_TIME, "RETENTION_TIME");
list.add(QUERY_STATISTICS, "QUERY_STATISTICS");
list.add(QUERY_STATISTICS_MAX_ENTRIES, "QUERY_STATISTICS_MAX_ENTRIES");
list.add(ROW_FACTORY, "ROW_FACTORY");
list.add(BATCH_JOINS, "BATCH_JOINS");
list.add(FORCE_JOIN_ORDER, "FORCE_JOIN_ORDER");
list.add(LAZY_QUERY_EXECUTION, "LAZY_QUERY_EXECUTION");
list.add(BUILTIN_ALIAS_OVERRIDE, "BUILTIN_ALIAS_OVERRIDE");
list.add(COLUMN_NAME_RULES, "COLUMN_NAME_RULES");
list.add(AUTHENTICATOR, "AUTHENTICATOR");
list.add(LOCAL_RESULT_FACTORY, "LOCAL_RESULT_FACTORY");
list.add(UUID_COLLATION, "UUID_COLLATION");
TYPES = list;
}
Get the set type number.
Params: - name – the set type name
Returns: the number
/**
* Get the set type number.
*
* @param name the set type name
* @return the number
*/
public static int getType(String name) {
return TYPES.indexOf(name);
}
public static ArrayList<String> getTypes() {
return TYPES;
}
Get the set type name.
Params: - type – the type number
Returns: the name
/**
* Get the set type name.
*
* @param type the type number
* @return the name
*/
public static String getTypeName(int type) {
return TYPES.get(type);
}
}