SqlValidator.Config (Apache Calcite core API)

Enclosing interface:

SqlValidator
```
public static interface SqlValidator.Config
```
Interface to define the configuration for a SqlValidator. Provides methods to set each configuration option.

Field Summary

Fields
Modifier and Type Field and Description

static SqlValidator.Config DEFAULT
Default configuration.

Fields
Modifier and Type	Field and Description
`static SqlValidator.Config`	`DEFAULT` Default configuration.

Method Summary

All Methods Instance Methods Abstract Methods
Modifier and Type	Method and Description
`boolean`	`callRewrite()` Returns whether to enable rewrite of "macro-like" calls such as COALESCE.
`boolean`	`columnReferenceExpansion()` Returns whether column reference expansion is enabled.
`NullCollation`	`defaultNullCollation()` Returns how NULL values should be collated if an ORDER BY item does not contain NULLS FIRST or NULLS LAST.
`boolean`	`identifierExpansion()` Returns whether to expand identifiers other than column references.
`boolean`	`lenientOperatorLookup()` Returns whether this validator should be lenient upon encountering an unknown function, default false.
`SqlConformance`	`sqlConformance()` Returns the dialect of SQL (SQL:2003, etc.) this validator recognizes.
`boolean`	`typeCoercionEnabled()` Returns whether the validator supports implicit type coercion.
`TypeCoercionFactory`	`typeCoercionFactory()` Returns the type coercion factory.
`SqlTypeCoercionRule`	`typeCoercionRules()` Returns the type coercion rules for explicit type coercion.
`SqlValidator.Config`	`withCallRewrite(boolean rewrite)` Sets whether to enable rewrite of "macro-like" calls such as COALESCE.
`SqlValidator.Config`	`withColumnReferenceExpansion(boolean expand)` Sets whether to enable expansion of column references.
`SqlValidator.Config`	`withDefaultNullCollation(NullCollation nullCollation)` Sets how NULL values should be collated if an ORDER BY item does not contain NULLS FIRST or NULLS LAST.
`SqlValidator.Config`	`withIdentifierExpansion(boolean expand)` Sets whether to enable expansion of identifiers other than column references.
`SqlValidator.Config`	`withLenientOperatorLookup(boolean lenient)` Sets whether this validator should be lenient upon encountering an unknown function.
`SqlValidator.Config`	`withSqlConformance(SqlConformance conformance)` Sets up the sql conformance of the validator.
`SqlValidator.Config`	`withTypeCoercionEnabled(boolean enabled)` Sets whether to enable implicit type coercion for validation, default true.
`SqlValidator.Config`	`withTypeCoercionFactory(TypeCoercionFactory factory)` Sets a factory to create type coercion instance that overrides the default coercion rules defined in `TypeCoercionImpl`.
`SqlValidator.Config`	`withTypeCoercionRules(SqlTypeCoercionRule rules)` Sets the `SqlTypeCoercionRule` instance which defines the type conversion matrix for the explicit type coercion.

- Field Detail
  - DEFAULT
```
static final SqlValidator.Config DEFAULT
```
    Default configuration.
- Method Detail
  - callRewrite
```
boolean callRewrite()
```
    Returns whether to enable rewrite of "macro-like" calls such as COALESCE.
  - withCallRewrite
```
SqlValidator.Config withCallRewrite(boolean rewrite)
```
    Sets whether to enable rewrite of "macro-like" calls such as COALESCE.
  - defaultNullCollation
```
NullCollation defaultNullCollation()
```
    Returns how NULL values should be collated if an ORDER BY item does not contain NULLS FIRST or NULLS LAST.
  - withDefaultNullCollation
```
SqlValidator.Config withDefaultNullCollation(NullCollation nullCollation)
```
    Sets how NULL values should be collated if an ORDER BY item does not contain NULLS FIRST or NULLS LAST.
  - columnReferenceExpansion
```
boolean columnReferenceExpansion()
```
    Returns whether column reference expansion is enabled.
  - withColumnReferenceExpansion
```
SqlValidator.Config withColumnReferenceExpansion(boolean expand)
```
    Sets whether to enable expansion of column references. (Currently this does not apply to the ORDER BY clause; may be fixed in the future.)
  - identifierExpansion
```
boolean identifierExpansion()
```
    Returns whether to expand identifiers other than column references.
    REVIEW jvs 30-June-2006: subclasses may override shouldExpandIdentifiers in a way that ignores this; we should probably get rid of the protected method and always use this variable (or better, move preferences like this to a separate "parameter" class).
  - withIdentifierExpansion
```
SqlValidator.Config withIdentifierExpansion(boolean expand)
```
    Sets whether to enable expansion of identifiers other than column references.
  - lenientOperatorLookup
```
boolean lenientOperatorLookup()
```
    Returns whether this validator should be lenient upon encountering an unknown function, default false.
    If true, if a statement contains a call to a function that is not present in the operator table, or if the call does not have the required number or types of operands, the validator nevertheless regards the statement as valid. The type of the function call will be UNKNOWN.
    If false (the default behavior), an unknown function call causes a validation error to be thrown.
  - withLenientOperatorLookup
```
SqlValidator.Config withLenientOperatorLookup(boolean lenient)
```
    Sets whether this validator should be lenient upon encountering an unknown function.
    
    Parameters:
    
    lenient - Whether to be lenient when encountering an unknown function
  - typeCoercionEnabled
```
boolean typeCoercionEnabled()
```
    Returns whether the validator supports implicit type coercion.
  - withTypeCoercionEnabled
```
SqlValidator.Config withTypeCoercionEnabled(boolean enabled)
```
    Sets whether to enable implicit type coercion for validation, default true.
    
    See Also:
    
    TypeCoercionImpl
  - typeCoercionFactory
```
TypeCoercionFactory typeCoercionFactory()
```
    Returns the type coercion factory.
  - withTypeCoercionFactory
```
SqlValidator.Config withTypeCoercionFactory(TypeCoercionFactory factory)
```
    Sets a factory to create type coercion instance that overrides the default coercion rules defined in TypeCoercionImpl.
    
    Parameters:
    
    factory - Factory to create TypeCoercion instance
  - typeCoercionRules
```
SqlTypeCoercionRule typeCoercionRules()
```
    Returns the type coercion rules for explicit type coercion.
  - withTypeCoercionRules
```
SqlValidator.Config withTypeCoercionRules(SqlTypeCoercionRule rules)
```
    Sets the SqlTypeCoercionRule instance which defines the type conversion matrix for the explicit type coercion.
    The rules setting should be thread safe. In the default implementation, it is set to a ThreadLocal variable.
    
    Parameters:
    
    rules - The SqlTypeCoercionRule instance, see its documentation for how to customize the rules
  - sqlConformance
```
SqlConformance sqlConformance()
```
    Returns the dialect of SQL (SQL:2003, etc.) this validator recognizes. Default is SqlConformanceEnum.DEFAULT.
  - withSqlConformance
```
SqlValidator.Config withSqlConformance(SqlConformance conformance)
```
    Sets up the sql conformance of the validator.

Interface SqlValidator.Config

Field Summary

Method Summary

Field Detail

DEFAULT

Method Detail

callRewrite

withCallRewrite

defaultNullCollation

withDefaultNullCollation

columnReferenceExpansion

withColumnReferenceExpansion

identifierExpansion

withIdentifierExpansion

lenientOperatorLookup

withLenientOperatorLookup

typeCoercionEnabled

withTypeCoercionEnabled

typeCoercionFactory

withTypeCoercionFactory

typeCoercionRules

withTypeCoercionRules

sqlConformance

withSqlConformance