com.gpudb.protocol

Class AlterTableRequest.Options

java.lang.Object

com.gpudb.protocol.AlterTableRequest.Options

Enclosing class:

AlterTableRequest

public static final class AlterTableRequest.Options
extends Object

Optional parameters.

• COLUMN_DEFAULT_VALUE: when adding a column: set a default value, for existing data.
• COLUMN_PROPERTIES: when adding or changing a column: set the column properties (strings, separated by a comma: data, store_only, text_search, char8, int8 etc).
• COLUMN_TYPE: when adding or changing a column: set the column type (strings, separated by a comma: int, double, string, null etc).
• VALIDATE_CHANGE_COLUMN: Validate the type change before applying column_change request. Default is true (if option is missing). If true, then validate all values. A value too large (or too long) for the new type will prevent any change. If false, then when a value is too large or long, it will be truncated. Supported values:
  • TRUE: true
  • FALSE: false
  The default value is TRUE.
• COPY_VALUES_FROM_COLUMN: when adding or changing a column: enter column name - from where to copy values.

A set of string constants for the parameter options.

Field Summary

Fields

Modifier and Type	Field and Description
static String	COLUMN_DEFAULT_VALUE when adding a column: set a default value, for existing data.
static String	COLUMN_PROPERTIES when adding or changing a column: set the column properties (strings, separated by a comma: data, store_only, text_search, char8, int8 etc).
static String	COLUMN_TYPE when adding or changing a column: set the column type (strings, separated by a comma: int, double, string, null etc).
static String	COPY_VALUES_FROM_COLUMN when adding or changing a column: enter column name - from where to copy values.
static String	FALSE false
static String	TRUE true
static String	VALIDATE_CHANGE_COLUMN Validate the type change before applying column_change request.

Method Summary

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Detail

COLUMN_DEFAULT_VALUE

public static final String COLUMN_DEFAULT_VALUE

when adding a column: set a default value, for existing data.

See Also:

Constant Field Values

COLUMN_PROPERTIES

public static final String COLUMN_PROPERTIES

when adding or changing a column: set the column properties (strings, separated by a comma: data, store_only, text_search, char8, int8 etc).

See Also:

Constant Field Values

COLUMN_TYPE

public static final String COLUMN_TYPE

when adding or changing a column: set the column type (strings, separated by a comma: int, double, string, null etc).

See Also:

Constant Field Values

VALIDATE_CHANGE_COLUMN

public static final String VALIDATE_CHANGE_COLUMN

Validate the type change before applying column_change request. Default is true (if option is missing). If true, then validate all values. A value too large (or too long) for the new type will prevent any change. If false, then when a value is too large or long, it will be truncated. Supported values:

• TRUE: true
• FALSE: false

The default value is TRUE.

See Also:

Constant Field Values

TRUE

public static final String TRUE

true

See Also:

Constant Field Values

FALSE

public static final String FALSE

false

See Also:

Constant Field Values

COPY_VALUES_FROM_COLUMN

public static final String COPY_VALUES_FROM_COLUMN

when adding or changing a column: enter column name - from where to copy values.

See Also:

Constant Field Values