analytics/configuration/xqe/parquet.properties

# Licensed Materials - Property of IBM
# IBM Cognos Products: XQE
# (C) Copyright IBM Corp. 2009, 2020
# US Government Users Restricted Rights - Use, duplication or disclosure restricted by GSA ADP Schedule Contract with IBM Corp.

#
# General settings.
#
general.nullsAreSortedHigh=false
general.nullsAreSortedLow=false
general.nullsAreSortedAtStart=false
general.nullsAreSortedAtEnd=false
general.nullsOrdering=false
general.nullsOrderingInWindowSpecification=false

#
# Various features.
#
supports.duplicateColumnsInSelectList=true
supports.columnAliasing=false
supports.tableCorrelationNames=false
supports.expressionsInOrderBy=false
supports.expressionsInOrderByOnGroupedQuery=false
# Determines whether the expression should be built off of the FID
# of the table expression (true), or the expression of the underlying 
# projection that the FID refers to (false)
supports.aliasInOrderByExpression=false
supports.expressionsInINPredicate=false
supports.expressionsInSelectList=false
supports.literalsInSelectList=false
supports.expressionsInLikePattern=false
supports.booleanExpressionsInSelectList=false
supports.fieldsOfComplexTypeInSelectList=false
supports.likeEscapeClause=false
supports.outerJoins=false
supports.fullOuterJoins=false
supports.limitedOuterJoins=false
supports.subqueriesInComparisons=false
supports.subqueriesInExists=false
supports.subqueriesInIns=false
supports.subqueriesInQuantifieds=false
supports.subqueriesInCase=false
supports.subqueriesInAggregate=false
supports.correlatedSubqueries=false
supports.correlatedSubqueriesInSelectList=false
supports.correlatedSubqueriesInIns=false
supports.transactions=false
supports.withClauseInDerivedTable=false
supports.nestedWithClause=false
supports.integerDivision=false
supports.nestedOlap=false
supports.derivedColumnLists=false
supports.orderByAlias=false
supports.orderByName=false
supports.orderByOrdinal=false
supports.blobsInGroupBy=false
supports.blobsInOrderBy=false
supports.scalarSubqueries=false
supports.emptyStringIsNull=false
supports.sqlserverWindowBehaviour=false
supports.mixedCaseIdentifiers=false
supports.mixedCaseQuotedIdentifiers=false
supports.charLiteralRoundTrip=true
supports.expressionsInGroupBy=false
supports.equiJoins=false
supports.thetaJoins=false
supports.stitchJoins=false
supports.crossProducts=false
supports.recursiveWithClause=false
supports.storedProcedureColumnUnique=false
supports.implicitTypeConversion=false
supports.orderByUnrelated=false
supports.groupByUnrelated=false
supports.schemasInDataManipulation=false
#classic stack compatibility
supports.nonStandardDatetimeComparison=false
supports.multipleDistinctAggregates=false
supports.hints=false
supports.rowNumberNoOrderBy=false
supports.parameterMarkers=false
supports.constantsInWindows=false
supports.orderByInDerivedTable=false
supports.callProcedureInDerivedTable=false
#join condition
supports.join.betweenInOnClause=false
supports.join.inPredicateInOnClause=false
supports.join.isNullInOnClause=false
supports.join.likeInOnClause=false
supports.join.notInOnClause=false
supports.join.orInOnClause=false
supports.join.subqueriesInOnClause=false
supports.join.onlyEquiWithAnd=false
supports.join.inner.limitedThetaJoins=false
supports.join.outer.thetaJoins=false
supports.join.full.thetaJoins=false
supports.join.full.distinctJoins=false
#isolation level support
supports.isolationLevelReadUncommitted=false
supports.isolationLevelReadCommitted=false
supports.isolationLevelRepeatableRead=false
supports.isolationLevelSerializable=false
supports.constantsInCount=false
supports.columnFiltersOnly=true
#casting with formatting pattern support
supports.formatters.string_to_date=false
supports.formatters.string_to_time=false
supports.formatters.string_to_time_with_time_zone=false
supports.formatters.string_to_timestamp=false
supports.formatters.string_to_timestamp_with_time_zone=false

#
# Command.
#
commands.Select=
commands.Call=

#
# Tables.
#
tables.derived=false
tables.lateral.derived=false
tables.joined=false

#
# Constructors.
#
constructors.table=false
constructors.row=false
constructors.array=false
constructors.period=false
constructors.map=false

#
# Constructors - context overrides.
#
constructors.row.between=false
constructors.row.comparison=false
constructors.row.in=false
constructors.row.isDistinctFrom=false
constructors.row.simpleCase=false
constructors.row.inListToTable=false

#
# Clauses.
#
clauses.From=
clauses.GroupBy=
clauses.Having=
clauses.With=
clauses.WithRecursive=
clauses.OrderBy=
clauses.Distinct=
clauses.Top=
clauses.At=
clauses.Window=
clauses.TableSampleSystem=
clauses.TableSampleBernoulli=
clauses.ForSystemTimeAsOf=
clauses.ForSystemTimeFrom=
clauses.ForSystemTimeBetween=

#
# Joins.
#
joins.Cross=
joins.Inner=
joins.LeftOuter=
joins.RightOuter=
joins.FullOuter=
joins.RightNested=

#
# Set operators.
#
operators.set.Union=
operators.set.Union.all=
operators.set.Intersect=
operators.set.Intersect.all=
operators.set.Except=
operators.set.Except.all=

#
# Logical operators.
#

#
# Arithmetic operators.
#
operators.arithmetic.Add[any,any]=
operators.arithmetic.Subtract[any,any]=
operators.arithmetic.Multiply[any,any]=
operators.arithmetic.Divide[any,any]=
operators.arithmetic.Negate[any]=
operators.arithmetic.Concat[any,any]=

#
# Group By Operators
#
operators.groupBy.Rollup=
operators.groupBy.Cube=
operators.groupBy.GroupingSets=

#
# Comparison predicates.
#
predicates.comparison.In[any]=
predicates.comparison.Overlaps[any,any,any,any]=

#
# Various predicates.
#
predicates.Between[any,any,any]=
predicates.In[any,any]=
predicates.Overlaps[any,any,any,any]=
predicates.IsNull=
predicates.IsNotNull=
predicates.Like=
predicates.Like.escape=
predicates.LikeRegex=
predicates.LikeRegex.flag=
predicates.Similar=
predicates.Similar.escape=
predicates.Exists=
predicates.All=
predicates.Any=
predicates.Some=
predicates.IsDistinctFrom[any,any]=
predicates.IsNotDistinctFrom[any,any]=

#
# Period predicates.
#
predicates.PeriodOverlaps[any,any]=
predicates.PeriodEquals[any,any]=
predicates.PeriodContains[any,any]=
predicates.PeriodPrecedes[any,any]=
predicates.PeriodSucceeds[any,any]=
predicates.PeriodImmediatelyPrecedes[any,any]=
predicates.PeriodImmediatelySucceeds[any,any]=

#
# Expressions.
#
expressions.SearchedCase=
expressions.SimpleCase=
# NULLIF(%1$s, %2$s) is equivalent to CASE WHEN %1$s = %2$s THEN NULL ELSE %1$s END
expressions.NullIf=
expressions.Coalesce=

#
# Cast expression.
# turn off ALL combinations and overrides.
#
expressions.Cast[any,any]=
expressions.Cast[binary,binary]=
expressions.Cast[blob,blob]=
expressions.Cast[clob,binary]=
expressions.Cast[clob,clob]=
expressions.Cast[clob,boolean]=
expressions.Cast[clob,date]=
expressions.Cast[clob,time]=
expressions.Cast[clob,time_with_time_zone]=
expressions.Cast[clob,timestamp]=
expressions.Cast[clob,timestamp_with_time_zone]=
expressions.Cast[clob,interval_day]=
expressions.Cast[clob,interval_day_to_hour]=
expressions.Cast[clob,interval_day_to_minute]=
expressions.Cast[clob,interval_day_to_second]=
expressions.Cast[clob,interval_hour]=
expressions.Cast[clob,interval_hour_to_minute]=
expressions.Cast[clob,interval_hour_to_second]=
expressions.Cast[clob,interval_minute]=
expressions.Cast[clob,interval_minute_to_second]=
expressions.Cast[clob,interval_second]=
expressions.Cast[clob,interval_year]=
expressions.Cast[clob,interval_year_to_month]=
expressions.Cast[clob,interval_month]=
expressions.Cast[clob,decimal]=
expressions.Cast[clob,double]=
expressions.Cast[clob,float]=
expressions.Cast[clob,float]=
expressions.Cast[clob,integer]=
expressions.Cast[clob,long]=
expressions.Cast[clob,smallint]=
expressions.Cast[clob,char]=
expressions.Cast[clob,nchar]=
expressions.Cast[clob,nvarchar]=
expressions.Cast[clob,varchar]=
expressions.Cast[clob,xml]=
expressions.Cast[boolean,boolean]=
expressions.Cast[date,clob]=
expressions.Cast[date,date]=
expressions.Cast[date,timestamp]=
expressions.Cast[date,timestamp_with_time_zone]=
expressions.Cast[date,char]=
expressions.Cast[date,nchar]=
expressions.Cast[date,nvarchar]=
expressions.Cast[date,varchar]=
expressions.Cast[time,clob]=
expressions.Cast[time,time]=
expressions.Cast[time,time_with_time_zone]=
expressions.Cast[time,timestamp]=
expressions.Cast[time,timestamp_with_time_zone]=
expressions.Cast[time,char]=
expressions.Cast[time,nchar]=
expressions.Cast[time,nvarchar]=
expressions.Cast[time,varchar]=
expressions.Cast[time_with_time_zone,clob]=
expressions.Cast[time_with_time_zone,time]=
expressions.Cast[time_with_time_zone,time_with_time_zone]=
expressions.Cast[time_with_time_zone,timestamp]=
expressions.Cast[time_with_time_zone,timestamp_with_time_zone]=
expressions.Cast[time_with_time_zone,char]=
expressions.Cast[time_with_time_zone,nchar]=
expressions.Cast[time_with_time_zone,nvarchar]=
expressions.Cast[time_with_time_zone,varchar]=
expressions.Cast[timestamp,clob]=
expressions.Cast[timestamp,date]=
expressions.Cast[timestamp,time]=
expressions.Cast[timestamp,time_with_time_zone]=
expressions.Cast[timestamp,timestamp]=
expressions.Cast[timestamp,timestamp_with_time_zone]=
expressions.Cast[timestamp,char]=
expressions.Cast[timestamp,nchar]=
expressions.Cast[timestamp,nvarchar]=
expressions.Cast[timestamp,varchar]=
expressions.Cast[timestamp_with_time_zone,clob]=
expressions.Cast[timestamp_with_time_zone,date]=
expressions.Cast[timestamp_with_time_zone,time]=
expressions.Cast[timestamp_with_time_zone,time_with_time_zone]=
expressions.Cast[timestamp_with_time_zone,timestamp]=
expressions.Cast[timestamp_with_time_zone,timestamp_with_time_zone]=
expressions.Cast[timestamp_with_time_zone,char]=
expressions.Cast[timestamp_with_time_zone,nchar]=
expressions.Cast[timestamp_with_time_zone,nvarchar]=
expressions.Cast[timestamp_with_time_zone,varchar]=
expressions.Cast[interval_day,clob]=
expressions.Cast[interval_day,interval_day]=
expressions.Cast[interval_day,interval_day_to_hour]=
expressions.Cast[interval_day,interval_day_to_minute]=
expressions.Cast[interval_day,interval_day_to_second]=
expressions.Cast[interval_day,interval_hour]=
expressions.Cast[interval_day,interval_hour_to_minute]=
expressions.Cast[interval_day,interval_hour_to_second]=
expressions.Cast[interval_day,interval_minute]=
expressions.Cast[interval_day,interval_minute_to_second]=
expressions.Cast[interval_day,interval_second]=
expressions.Cast[interval_day,decimal]=
expressions.Cast[interval_day,integer]=
expressions.Cast[interval_day,long]=
expressions.Cast[interval_day,smallint]=
expressions.Cast[interval_day,char]=
expressions.Cast[interval_day,nchar]=
expressions.Cast[interval_day,nvarchar]=
expressions.Cast[interval_day,varchar]=
expressions.Cast[interval_day_to_hour,clob]=
expressions.Cast[interval_day_to_hour,interval_day]=
expressions.Cast[interval_day_to_hour,interval_day_to_hour]=
expressions.Cast[interval_day_to_hour,interval_day_to_minute]=
expressions.Cast[interval_day_to_hour,interval_day_to_second]=
expressions.Cast[interval_day_to_hour,interval_hour]=
expressions.Cast[interval_day_to_hour,interval_hour_to_minute]=
expressions.Cast[interval_day_to_hour,interval_hour_to_second]=
expressions.Cast[interval_day_to_hour,interval_minute]=
expressions.Cast[interval_day_to_hour,interval_minute_to_second]=
expressions.Cast[interval_day_to_hour,interval_second]=
expressions.Cast[interval_day_to_hour,char]=
expressions.Cast[interval_day_to_hour,nchar]=
expressions.Cast[interval_day_to_hour,nvarchar]=
expressions.Cast[interval_day_to_hour,varchar]=
expressions.Cast[interval_day_to_minute,clob]=
expressions.Cast[interval_day_to_minute,interval_day]=
expressions.Cast[interval_day_to_minute,interval_day_to_hour]=
expressions.Cast[interval_day_to_minute,interval_day_to_minute]=
expressions.Cast[interval_day_to_minute,interval_day_to_second]=
expressions.Cast[interval_day_to_minute,interval_hour]=
expressions.Cast[interval_day_to_minute,interval_hour_to_minute]=
expressions.Cast[interval_day_to_minute,interval_hour_to_second]=
expressions.Cast[interval_day_to_minute,interval_minute]=
expressions.Cast[interval_day_to_minute,interval_minute_to_second]=
expressions.Cast[interval_day_to_minute,interval_second]=
expressions.Cast[interval_day_to_minute,char]=
expressions.Cast[interval_day_to_minute,nchar]=
expressions.Cast[interval_day_to_minute,nvarchar]=
expressions.Cast[interval_day_to_minute,varchar]=
expressions.Cast[interval_day_to_second,clob]=
expressions.Cast[interval_day_to_second,interval_day]=
expressions.Cast[interval_day_to_second,interval_day_to_hour]=
expressions.Cast[interval_day_to_second,interval_day_to_minute]=
expressions.Cast[interval_day_to_second,interval_day_to_second]=
expressions.Cast[interval_day_to_second,interval_hour]=
expressions.Cast[interval_day_to_second,interval_hour_to_minute]=
expressions.Cast[interval_day_to_second,interval_hour_to_second]=
expressions.Cast[interval_day_to_second,interval_minute]=
expressions.Cast[interval_day_to_second,interval_minute_to_second]=
expressions.Cast[interval_day_to_second,interval_second]=
expressions.Cast[interval_day_to_second,char]=
expressions.Cast[interval_day_to_second,nchar]=
expressions.Cast[interval_day_to_second,nvarchar]=
expressions.Cast[interval_day_to_second,varchar]=
expressions.Cast[interval_hour,clob]=
expressions.Cast[interval_hour,interval_day]=
expressions.Cast[interval_hour,interval_day_to_hour]=
expressions.Cast[interval_hour,interval_day_to_minute]=
expressions.Cast[interval_hour,interval_day_to_second]=
expressions.Cast[interval_hour,interval_hour]=
expressions.Cast[interval_hour,interval_hour_to_minute]=
expressions.Cast[interval_hour,interval_hour_to_second]=
expressions.Cast[interval_hour,interval_minute]=
expressions.Cast[interval_hour,interval_minute_to_second]=
expressions.Cast[interval_hour,interval_second]=
expressions.Cast[interval_hour,decimal]=
expressions.Cast[interval_hour,integer]=
expressions.Cast[interval_hour,long]=
expressions.Cast[interval_hour,smallint]=
expressions.Cast[interval_hour,char]=
expressions.Cast[interval_hour,nchar]=
expressions.Cast[interval_hour,nvarchar]=
expressions.Cast[interval_hour,varchar]=
expressions.Cast[interval_hour_to_minute,clob]=
expressions.Cast[interval_hour_to_minute,interval_day]=
expressions.Cast[interval_hour_to_minute,interval_day_to_hour]=
expressions.Cast[interval_hour_to_minute,interval_day_to_minute]=
expressions.Cast[interval_hour_to_minute,interval_day_to_second]=
expressions.Cast[interval_hour_to_minute,interval_hour]=
expressions.Cast[interval_hour_to_minute,interval_hour_to_minute]=
expressions.Cast[interval_hour_to_minute,interval_hour_to_second]=
expressions.Cast[interval_hour_to_minute,interval_minute]=
expressions.Cast[interval_hour_to_minute,interval_minute_to_second]=
expressions.Cast[interval_hour_to_minute,interval_second]=
expressions.Cast[interval_hour_to_minute,char]=
expressions.Cast[interval_hour_to_minute,nchar]=
expressions.Cast[interval_hour_to_minute,nvarchar]=
expressions.Cast[interval_hour_to_minute,varchar]=
expressions.Cast[interval_hour_to_second,clob]=
expressions.Cast[interval_hour_to_second,interval_day]=
expressions.Cast[interval_hour_to_second,interval_day_to_hour]=
expressions.Cast[interval_hour_to_second,interval_day_to_minute]=
expressions.Cast[interval_hour_to_second,interval_day_to_second]=
expressions.Cast[interval_hour_to_second,interval_hour]=
expressions.Cast[interval_hour_to_second,interval_hour_to_minute]=
expressions.Cast[interval_hour_to_second,interval_hour_to_second]=
expressions.Cast[interval_hour_to_second,interval_minute]=
expressions.Cast[interval_hour_to_second,interval_minute_to_second]=
expressions.Cast[interval_hour_to_second,interval_second]=
expressions.Cast[interval_hour_to_second,char]=
expressions.Cast[interval_hour_to_second,nchar]=
expressions.Cast[interval_hour_to_second,nvarchar]=
expressions.Cast[interval_hour_to_second,varchar]=
expressions.Cast[interval_minute,clob]=
expressions.Cast[interval_minute,interval_day]=
expressions.Cast[interval_minute,interval_day_to_hour]=
expressions.Cast[interval_minute,interval_day_to_minute]=
expressions.Cast[interval_minute,interval_day_to_second]=
expressions.Cast[interval_minute,interval_hour]=
expressions.Cast[interval_minute,interval_hour_to_minute]=
expressions.Cast[interval_minute,interval_hour_to_second]=
expressions.Cast[interval_minute,interval_minute]=
expressions.Cast[interval_minute,interval_minute_to_second]=
expressions.Cast[interval_minute,interval_second]=
expressions.Cast[interval_minute,decimal]=
expressions.Cast[interval_minute,integer]=
expressions.Cast[interval_minute,long]=
expressions.Cast[interval_minute,smallint]=
expressions.Cast[interval_minute,char]=
expressions.Cast[interval_minute,nchar]=
expressions.Cast[interval_minute,nvarchar]=
expressions.Cast[interval_minute,varchar]=
expressions.Cast[interval_minute_to_second,clob]=
expressions.Cast[interval_minute_to_second,interval_day]=
expressions.Cast[interval_minute_to_second,interval_day_to_hour]=
expressions.Cast[interval_minute_to_second,interval_day_to_minute]=
expressions.Cast[interval_minute_to_second,interval_day_to_second]=
expressions.Cast[interval_minute_to_second,interval_hour]=
expressions.Cast[interval_minute_to_second,interval_hour_to_minute]=
expressions.Cast[interval_minute_to_second,interval_hour_to_second]=
expressions.Cast[interval_minute_to_second,interval_minute]=
expressions.Cast[interval_minute_to_second,interval_minute_to_second]=
expressions.Cast[interval_minute_to_second,interval_second]=
expressions.Cast[interval_minute_to_second,char]=
expressions.Cast[interval_minute_to_second,nchar]=
expressions.Cast[interval_minute_to_second,nvarchar]=
expressions.Cast[interval_minute_to_second,varchar]=
expressions.Cast[interval_second,clob]=
expressions.Cast[interval_second,interval_day]=
expressions.Cast[interval_second,interval_day_to_hour]=
expressions.Cast[interval_second,interval_day_to_minute]=
expressions.Cast[interval_second,interval_day_to_second]=
expressions.Cast[interval_second,interval_hour]=
expressions.Cast[interval_second,interval_hour_to_minute]=
expressions.Cast[interval_second,interval_hour_to_second]=
expressions.Cast[interval_second,interval_minute]=
expressions.Cast[interval_second,interval_minute_to_second]=
expressions.Cast[interval_second,interval_second]=
expressions.Cast[interval_second,decimal]=
expressions.Cast[interval_second,integer]=
expressions.Cast[interval_second,long]=
expressions.Cast[interval_second,smallint]=
expressions.Cast[interval_second,char]=
expressions.Cast[interval_second,nchar]=
expressions.Cast[interval_second,nvarchar]=
expressions.Cast[interval_second,varchar]=
expressions.Cast[interval_year,clob]=
expressions.Cast[interval_year,interval_year]=
expressions.Cast[interval_year,interval_year_to_month]=
expressions.Cast[interval_year,interval_month]=
expressions.Cast[interval_year,decimal]=
expressions.Cast[interval_year,integer]=
expressions.Cast[interval_year,long]=
expressions.Cast[interval_year,smallint]=
expressions.Cast[interval_year,char]=
expressions.Cast[interval_year,nchar]=
expressions.Cast[interval_year,nvarchar]=
expressions.Cast[interval_year,varchar]=
expressions.Cast[interval_year_to_month,clob]=
expressions.Cast[interval_year_to_month,interval_year]=
expressions.Cast[interval_year_to_month,interval_year_to_month]=
expressions.Cast[interval_year_to_month,interval_month]=
expressions.Cast[interval_year_to_month,char]=
expressions.Cast[interval_year_to_month,nchar]=
expressions.Cast[interval_year_to_month,nvarchar]=
expressions.Cast[interval_year_to_month,varchar]=
expressions.Cast[interval_month,clob]=
expressions.Cast[interval_month,interval_year]=
expressions.Cast[interval_month,interval_year_to_month]=
expressions.Cast[interval_month,interval_month]=
expressions.Cast[interval_month,decimal]=
expressions.Cast[interval_month,integer]=
expressions.Cast[interval_month,long]=
expressions.Cast[interval_month,smallint]=
expressions.Cast[interval_month,char]=
expressions.Cast[interval_month,nchar]=
expressions.Cast[interval_month,nvarchar]=
expressions.Cast[interval_month,varchar]=
expressions.Cast[decimal,clob]=
expressions.Cast[decimal,interval_day]=
expressions.Cast[decimal,interval_hour]=
expressions.Cast[decimal,interval_minute]=
expressions.Cast[decimal,interval_second]=
expressions.Cast[decimal,interval_year]=
expressions.Cast[decimal,interval_month]=
expressions.Cast[decimal,decimal]=
expressions.Cast[decimal,double]=
expressions.Cast[decimal,float]=
expressions.Cast[decimal,float]=
expressions.Cast[decimal,integer]=
expressions.Cast[decimal,long]=
expressions.Cast[decimal,smallint]=
expressions.Cast[decimal,char]=
expressions.Cast[decimal,nchar]=
expressions.Cast[decimal,nvarchar]=
expressions.Cast[decimal,varchar]=
expressions.Cast[double,clob]=
expressions.Cast[double,decimal]=
expressions.Cast[double,double]=
expressions.Cast[double,float]=
expressions.Cast[double,float]=
expressions.Cast[double,integer]=
expressions.Cast[double,long]=
expressions.Cast[double,smallint]=
expressions.Cast[double,char]=
expressions.Cast[double,nchar]=
expressions.Cast[double,nvarchar]=
expressions.Cast[double,varchar]=
expressions.Cast[float,clob]=
expressions.Cast[float,decimal]=
expressions.Cast[float,double]=
expressions.Cast[float,float]=
expressions.Cast[float,float]=
expressions.Cast[float,integer]=
expressions.Cast[float,long]=
expressions.Cast[float,smallint]=
expressions.Cast[float,char]=
expressions.Cast[float,nchar]=
expressions.Cast[float,nvarchar]=
expressions.Cast[float,varchar]=
expressions.Cast[integer,clob]=
expressions.Cast[integer,interval_day]=
expressions.Cast[integer,interval_hour]=
expressions.Cast[integer,interval_minute]=
expressions.Cast[integer,interval_second]=
expressions.Cast[integer,interval_year]=
expressions.Cast[integer,interval_month]=
expressions.Cast[integer,decimal]=
expressions.Cast[integer,double]=
expressions.Cast[integer,float]=
expressions.Cast[integer,float]=
expressions.Cast[integer,integer]=
expressions.Cast[integer,long]=
expressions.Cast[integer,smallint]=
expressions.Cast[integer,char]=
expressions.Cast[integer,nchar]=
expressions.Cast[integer,nvarchar]=
expressions.Cast[integer,varchar]=
expressions.Cast[long,clob]=
expressions.Cast[long,interval_day]=
expressions.Cast[long,interval_hour]=
expressions.Cast[long,interval_minute]=
expressions.Cast[long,interval_second]=
expressions.Cast[long,interval_year]=
expressions.Cast[long,interval_month]=
expressions.Cast[long,decimal]=
expressions.Cast[long,double]=
expressions.Cast[long,float]=
expressions.Cast[long,float]=
expressions.Cast[long,integer]=
expressions.Cast[long,long]=
expressions.Cast[long,smallint]=
expressions.Cast[long,char]=
expressions.Cast[long,nchar]=
expressions.Cast[long,nvarchar]=
expressions.Cast[long,varchar]=
expressions.Cast[smallint,clob]=
expressions.Cast[smallint,interval_day]=
expressions.Cast[smallint,interval_hour]=
expressions.Cast[smallint,interval_minute]=
expressions.Cast[smallint,interval_second]=
expressions.Cast[smallint,interval_year]=
expressions.Cast[smallint,interval_month]=
expressions.Cast[smallint,decimal]=
expressions.Cast[smallint,double]=
expressions.Cast[smallint,float]=
expressions.Cast[smallint,float]=
expressions.Cast[smallint,integer]=
expressions.Cast[smallint,long]=
expressions.Cast[smallint,smallint]=
expressions.Cast[smallint,char]=
expressions.Cast[smallint,nchar]=
expressions.Cast[smallint,nvarchar]=
expressions.Cast[smallint,varchar]=
expressions.Cast[char,binary]=
expressions.Cast[char,clob]=
expressions.Cast[char,boolean]=
expressions.Cast[char,date]=
expressions.Cast[char,time]=
expressions.Cast[char,time_with_time_zone]=
expressions.Cast[char,timestamp]=
expressions.Cast[char,timestamp_with_time_zone]=
expressions.Cast[char,interval_day]=
expressions.Cast[char,interval_day_to_hour]=
expressions.Cast[char,interval_day_to_minute]=
expressions.Cast[char,interval_day_to_second]=
expressions.Cast[char,interval_hour]=
expressions.Cast[char,interval_hour_to_minute]=
expressions.Cast[char,interval_hour_to_second]=
expressions.Cast[char,interval_minute]=
expressions.Cast[char,interval_minute_to_second]=
expressions.Cast[char,interval_second]=
expressions.Cast[char,interval_year]=
expressions.Cast[char,interval_year_to_month]=
expressions.Cast[char,interval_month]=
expressions.Cast[char,decimal]=
expressions.Cast[char,double]=
expressions.Cast[char,float]=
expressions.Cast[char,float]=
expressions.Cast[char,integer]=
expressions.Cast[char,long]=
expressions.Cast[char,smallint]=
expressions.Cast[char,char]=
expressions.Cast[char,nchar]=
expressions.Cast[char,nvarchar]=
expressions.Cast[char,varchar]=
expressions.Cast[char,xml]=
expressions.Cast[nchar,binary]=
expressions.Cast[nchar,clob]=
expressions.Cast[nchar,boolean]=
expressions.Cast[nchar,date]=
expressions.Cast[nchar,time]=
expressions.Cast[nchar,time_with_time_zone]=
expressions.Cast[nchar,timestamp]=
expressions.Cast[nchar,timestamp_with_time_zone]=
expressions.Cast[nchar,interval_day]=
expressions.Cast[nchar,interval_day_to_hour]=
expressions.Cast[nchar,interval_day_to_minute]=
expressions.Cast[nchar,interval_day_to_second]=
expressions.Cast[nchar,interval_hour]=
expressions.Cast[nchar,interval_hour_to_minute]=
expressions.Cast[nchar,interval_hour_to_second]=
expressions.Cast[nchar,interval_minute]=
expressions.Cast[nchar,interval_minute_to_second]=
expressions.Cast[nchar,interval_second]=
expressions.Cast[nchar,interval_year]=
expressions.Cast[nchar,interval_year_to_month]=
expressions.Cast[nchar,interval_month]=
expressions.Cast[nchar,decimal]=
expressions.Cast[nchar,double]=
expressions.Cast[nchar,float]=
expressions.Cast[nchar,float]=
expressions.Cast[nchar,integer]=
expressions.Cast[nchar,long]=
expressions.Cast[nchar,smallint]=
expressions.Cast[nchar,char]=
expressions.Cast[nchar,nchar]=
expressions.Cast[nchar,nvarchar]=
expressions.Cast[nchar,varchar]=
expressions.Cast[nchar,xml]=
expressions.Cast[nvarchar,binary]=
expressions.Cast[nvarchar,clob]=
expressions.Cast[nvarchar,boolean]=
expressions.Cast[nvarchar,date]=
expressions.Cast[nvarchar,time]=
expressions.Cast[nvarchar,time_with_time_zone]=
expressions.Cast[nvarchar,timestamp]=
expressions.Cast[nvarchar,timestamp_with_time_zone]=
expressions.Cast[nvarchar,interval_day]=
expressions.Cast[nvarchar,interval_day_to_hour]=
expressions.Cast[nvarchar,interval_day_to_minute]=
expressions.Cast[nvarchar,interval_day_to_second]=
expressions.Cast[nvarchar,interval_hour]=
expressions.Cast[nvarchar,interval_hour_to_minute]=
expressions.Cast[nvarchar,interval_hour_to_second]=
expressions.Cast[nvarchar,interval_minute]=
expressions.Cast[nvarchar,interval_minute_to_second]=
expressions.Cast[nvarchar,interval_second]=
expressions.Cast[nvarchar,interval_year]=
expressions.Cast[nvarchar,interval_year_to_month]=
expressions.Cast[nvarchar,interval_month]=
expressions.Cast[nvarchar,decimal]=
expressions.Cast[nvarchar,double]=
expressions.Cast[nvarchar,float]=
expressions.Cast[nvarchar,float]=
expressions.Cast[nvarchar,integer]=
expressions.Cast[nvarchar,long]=
expressions.Cast[nvarchar,smallint]=
expressions.Cast[nvarchar,char]=
expressions.Cast[nvarchar,nchar]=
expressions.Cast[nvarchar,nvarchar]=
expressions.Cast[nvarchar,varchar]=
expressions.Cast[nvarchar,xml]=
expressions.Cast[varchar,binary]=
expressions.Cast[varchar,clob]=
expressions.Cast[varchar,boolean]=
expressions.Cast[varchar,date]=
expressions.Cast[varchar,time]=
expressions.Cast[varchar,time_with_time_zone]=
expressions.Cast[varchar,timestamp]=
expressions.Cast[varchar,timestamp_with_time_zone]=
expressions.Cast[varchar,interval_day]=
expressions.Cast[varchar,interval_day_to_hour]=
expressions.Cast[varchar,interval_day_to_minute]=
expressions.Cast[varchar,interval_day_to_second]=
expressions.Cast[varchar,interval_hour]=
expressions.Cast[varchar,interval_hour_to_minute]=
expressions.Cast[varchar,interval_hour_to_second]=
expressions.Cast[varchar,interval_minute]=
expressions.Cast[varchar,interval_minute_to_second]=
expressions.Cast[varchar,interval_second]=
expressions.Cast[varchar,interval_year]=
expressions.Cast[varchar,interval_year_to_month]=
expressions.Cast[varchar,interval_month]=
expressions.Cast[varchar,decimal]=
expressions.Cast[varchar,double]=
expressions.Cast[varchar,float]=
expressions.Cast[varchar,float]=
expressions.Cast[varchar,integer]=
expressions.Cast[varchar,long]=
expressions.Cast[varchar,smallint]=
expressions.Cast[varchar,char]=
expressions.Cast[varchar,nchar]=
expressions.Cast[varchar,nvarchar]=
expressions.Cast[varchar,varchar]=
expressions.Cast[varchar,xml]=
expressions.Cast[xml,xml]=

#
# Extract expression.
#
expressions.Extract.YEAR[any]=
expressions.Extract.MONTH[any]=
expressions.Extract.DAY[any]=
expressions.Extract.HOUR[any]=
expressions.Extract.MINUTE[any]=
expressions.Extract.SECOND[any]=
expressions.Extract.TIMEZONE_HOUR[any]=
expressions.Extract.TIMEZONE_MINUTE[any]=
expressions.Extract.EPOCH[any]=

#
# Trim expression.
#
expressions.Trim.BOTH[text]=
expressions.Trim.LEADING[text]=
expressions.Trim.TRAILING[text]=
expressions.Trim.BOTH[text,text]=
expressions.Trim.LEADING[text,text]=
expressions.Trim.TRAILING[text,text]=

#
# Windowed aggregates (SQL/OLAP).
#
olap.Max[any]=
olap.Min[any]=
olap.Sum[any]=
olap.Avg[any]=
olap.Count[any]=
olap.CountStar[]=
olap.StdDevSamp[any]=
olap.StdDevPop[any]=
olap.VarSamp[any]=
olap.VarPop[any]=
olap.Rank[]=
olap.DenseRank[]=
olap.PercentRank[]=
olap.CumeDist[]=
olap.PercentileCont[any,any]=
olap.PercentileDisc[any,any]=
olap.Median[any]=
olap.RowNumber[]=
olap.FirstValue[any]=
olap.LastValue[any]=
olap.NTile[any]=
olap.Tertile[]=
olap.RatioToReport[any]=
olap.Difference[any]=
olap.Lag[any]=
olap.Lag[any,any]=
olap.Lag[any,any,any]=
olap.Lag[any,any,any,any]=
olap.Lead[any]=
olap.Lead[any,any]=
olap.Lead[any,any,any]=
olap.Lead[any,any,any,any]=
olap.NthValue[any,any]=
olap.NthValue[any,any,any]=
olap.NthValue[any,any,any,any]=
olap.Collect[any]=

#
# Window clause.
#
olap.Window=
olap.PartitionBy=
olap.OrderBy=

#
# Window specification
# A list of windows specifications that are supported by the DB
# P = PARTITION BY
# O = ORDER BY
# F = FRAME 
#
olap.Window.Specification[POF]=false
olap.Window.Specification[PO]=false
olap.Window.Specification[OF]=false
olap.Window.Specification[PF]=false
olap.Window.Specification[P]=false
olap.Window.Specification[O]=false
olap.Window.Specification[F]=false
olap.Window.Specification[]=false
olap.Window.Frame.Moving=false

#
# Olap (distinct).
#
olap.Max.distinct[any]=
olap.Min.distinct[any]=
olap.Sum.distinct[any]=
olap.Avg.distinct[any]=
olap.Count.distinct[any]=

#
# Aggregates.
#
aggregates.Max[any]=
aggregates.Min[any]=
aggregates.Sum[any]=
aggregates.Avg[any]=
aggregates.Count[any]=
aggregates.CountStar[]=
aggregates.StdDevSamp[any]=
aggregates.StdDevPop[any]=
aggregates.VarSamp[any]=
aggregates.VarPop[any]=
aggregates.Rank[any,any]=
aggregates.DenseRank[any,any]=
aggregates.PercentRank[any,any]=
aggregates.CumeDistH[any,any]=
aggregates.PercentileCont[any,any]=
aggregates.PercentileDisc[any,any]=
aggregates.Median[any]=
aggregates.XMLAgg=
aggregates.Grouping[any]=
aggregates.ArrayAgg[any]=
aggregates.ArrayAgg[any,any]=
aggregates.Collect[any]=
aggregates.ApproxCountDistinct[any]=

#
# Aggregates (distinct).
#
aggregates.Max.distinct[any]=
aggregates.Min.distinct[any]=
aggregates.Sum.distinct[any]=
aggregates.Avg.distinct[any]=
aggregates.Count.distinct[any]=

#
# Linear regression aggregates.
#
aggregates.Corr[any,any]=
aggregates.CovarPop[any,any]=
aggregates.CovarSamp[any,any]=
aggregates.RegrAvgX[any,any]=
aggregates.RegrAvgY[any,any]=
aggregates.RegrCount[any,any]=
aggregates.RegrIntercept[any,any]=
aggregates.RegrR2[any,any]=
aggregates.RegrSlope[any,any]=
aggregates.RegrSXX[any,any]=
aggregates.RegrSXY[any,any]=
aggregates.RegrSYY[any,any]=

#
# JSON aggregates.
#
aggregates.JSONArrayAgg=
aggregates.JSONObjectAgg=

#
# Character scalar functions.
#
functions.CharLength[any]=
functions.OctetLength[any]=
functions.BitLength[any]=
functions.Upper[any]=
functions.Lower[any]=
functions.Substring[any,any]=
functions.Substring[any,any,any]=
functions.Position[any,any]=
functions.Index[any,any]=
functions.Ascii[any]=
functions.Translate[any,any]=
functions.Normalize[any]=
functions.Normalize[any,any]=
functions.Normalize[any,any,any]=

#Substring function to negative START value to parse the input string from its rightmost end. 
#It's not a standard SQL function, so leave the definition empty.
functions.SubstringR[any,any]=
functions.SubstringR[any,any,any]=

#
# Regular expression functions.
#
functions.SubstringRegex[any,any,any,any,any]=
functions.OccurrencesRegex[any,any,any,any]=
functions.PositionRegex[any,any,any,any,any,any]=

#
# Numeric scalar functions.
#
functions.Abs[numeric]=
functions.Ceiling[numeric]=
functions.Exp[numeric]=
functions.Floor[numeric]=
functions.Ln[numeric]=
functions.Log10[numeric]=
functions.Mod[numeric,numeric]=
functions.Power[numeric,numeric]=
functions.Random[]=
functions.Random[any]=
functions.Round[numeric]=
functions.Round[numeric,numeric]=
functions.Round[numeric,numeric,numeric]=
functions.Sign[numeric]=
functions.Sqrt[numeric]=
functions.WidthBucket[numeric,numeric,numeric,numeric]=

#
# Array scalar functions.
#
functions.Cardinality[any]=
functions.TrimArray[any,any]=

#
# Trigonometric functions.
#
functions.Arccos[any]=
functions.Arcsin[any]=
functions.Arctan[any]=
functions.Cos[any]=
functions.Coshyp[any]=
functions.Sin[any]=
functions.Sinhyp[any]=
functions.Tan[any]=
functions.Tanhyp[any]=

#
# Datetime value functions.
#
functions.CurrentDate[]=
functions.CurrentTime[]=
functions.CurrentTimestamp[]=
functions.LocalTime[]=
functions.LocalTimestamp[]=
functions.CurrentTime[numeric]=
functions.CurrentTimestamp[numeric]=
functions.LocalTime[numeric]=
functions.LocalTimestamp[numeric]=

#
# XML functions.
#
functions.XMLAttributes=
functions.XMLComment=
functions.XMLConcat=
functions.XMLDocument=
functions.XMLElement=
functions.XMLExists=
functions.XMLForest=
functions.XMLParse=
functions.XMLPI=
functions.XMLNamespaces=
functions.XMLQuery=
functions.XMLSerialize=
functions.XMLTable=
functions.XMLText=
functions.XMLTransform=
functions.XMLValidate=
functions.XMLElement.ContentOption.NULL_ON_NULL=false
functions.XMLElement.ContentOption.EMPTY_ON_NULL=false
functions.XMLForest.ContentOption.NULL_ON_NULL=false
functions.XMLForest.ContentOption.EMPTY_ON_NULL=false
functions.XMLParse.DocumentOrContent.DOCUMENT=false
functions.XMLParse.DocumentOrContent.CONTENT=false
functions.XMLParse.WhitespaceOption.STRIP_WHITESPACE=false
functions.XMLParse.WhitespaceOption.PRESERVE_WHITESPACE=false
functions.XMLQuery.EmptyHandlingOption.NULL_ON_EMPTY=false
functions.XMLQuery.EmptyHandlingOption.EMPTY_ON_EMPTY=false
functions.XMLSerialize.DeclarationOption.INCLUDING_XMLDECLARATION=false
functions.XMLSerialize.DeclarationOption.EXCLUDING_XMLDECLARATION=false

#
# JSON functions.
#
functions.JSONArray=
functions.JSONExists=
functions.JSONObject=
functions.JSONQuery=
functions.JSONTable=
functions.JSONValue=

#
# Business date functions.
#
functions.AddHours[any,any]=
functions.AddMinutes[any,any]=
functions.AddSeconds[any,any]=
functions.AddFractionalSeconds[any,any]=
functions.AddDays[any,any]=
functions.AddWeeks[any,any]=
functions.AddMonths[any,any]=
functions.AddQuarters[any,any]=
functions.AddYears[any,any]=
functions.Age[any]=
functions.FractionalSecondsBetween[any,any]=
functions.SecondsBetween[any,any]=
functions.MinutesBetween[any,any]=
functions.HoursBetween[any,any]=
functions.DaysBetween[any,any]=
functions.WeeksBetween[any,any]=
functions.MonthsBetween[any,any]=
functions.QuartersBetween[any,any]=
functions.YearsBetween[any,any]=
functions.DayOfWeek[any,any]=
functions.DayOfYear[any]=
functions.DaysToEndOfMonth[any]=
functions.FirstOfMonth[any]=
functions.LastOfMonth[any]=
functions.MakeTimestamp[any,any,any]=
functions.WeekOfYear[any]=
functions.YMDIntBetween[any,any]=

#
# Table functions.
#
functions.Unnest=

#
# Literals.
# Use data types only, not domains.
#
literals.binary=false
literals.blob=false
literals.clob=false
literals.boolean=false
literals.date=false
literals.time=false
literals.time_with_time_zone=false
literals.timestamp=false
literals.timestamp_with_time_zone=false
literals.interval_day=false
literals.interval_day_to_hour=false
literals.interval_day_to_minute=false
literals.interval_day_to_second=false
literals.interval_hour=false
literals.interval_hour_to_minute=false
literals.interval_hour_to_second=false
literals.interval_minute=false
literals.interval_minute_to_second=false
literals.interval_second=false
literals.interval_year=false
literals.interval_year_to_month=false
literals.interval_month=false
literals.smallint=true
literals.integer=true
literals.long=true
literals.float=true
literals.double=true
literals.decimal=false
literals.char=true
literals.nchar=true
literals.varchar=true
literals.nvarchar=true
literals.xml=false

#
# Literal format specifications.
#

#
# Data types.
#
dataType.binary=true
dataType.blob=false
dataType.clob=false
dataType.boolean=true
dataType.date=true
dataType.time=false
dataType.time_with_time_zone=false
dataType.timestamp=false
dataType.timestamp_with_time_zone=false
dataType.interval_day=false
dataType.interval_day_to_hour=false
dataType.interval_day_to_minute=false
dataType.interval_day_to_second=false
dataType.interval_hour=false
dataType.interval_hour_to_minute=false
dataType.interval_hour_to_second=false
dataType.interval_minute=false
dataType.interval_minute_to_second=false
dataType.interval_second=false
dataType.interval_year=false
dataType.interval_year_to_month=false
dataType.interval_month=false
dataType.smallint=true
dataType.integer=true
dataType.long=true
dataType.float=true
dataType.double=true
dataType.decimal=true
dataType.char=true
dataType.nchar=true
dataType.varchar=true
dataType.nvarchar=true
dataType.xml=true
dataType.period=false
dataType.array=false
dataType.struct=false
dataType.map=false
dataType.json=false
dataType.datalink=false