analytics/configuration/xqe/json.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

#
# Various features.
#
supports.duplicateColumnsInSelectList=true
supports.columnAliasing=false
supports.tableCorrelationNames=false
supports.expressionsInOrderBy=false
supports.expressionsInINPredicate=false
supports.expressionsInSelectList=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.correlatedSubqueries=false
supports.transactions=false
supports.withClauseInDerivedTable=false
supports.integerDivision=false
supports.nestedOlap=false
supports.derivedColumnLists=false
supports.orderByAlias=false
supports.orderByName=false
supports.orderByOrdinal=false
supports.orderByUnrelated=false
supports.blobsInGroupBy=false
supports.blobsInOrderBy=false
supports.scalarSubqueries=false
supports.charLiteralRoundTrip=true
supports.crossProducts=false
supports.implicitTypeConversion=false
supports.orderByUnrelated=false
supports.groupByUnrelated=false
supports.schemasInDataManipulation=true
#classic stack compatibility
supports.nonStandardDatetimeComparison=false
supports.multipleDistinctAggregates=false
supports.hints=false
supports.rowNumberNoOrderBy=false
supports.sqlserverWindowBehaviour=false

supports.join.subqueriesInOnClause=false
# Indicates whether inner joins require at least one equijoin predicate.
# A INNER JOIN B ON A.C1 = B.C1 AND A.C2 > B.C2 is fine, but A INNER JOIN B ON A.C2 > B.C2 is not.
supports.join.inner.limitedThetaJoins=false
#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=SELECT
commands.Call=CALL

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

#
# Constructors.
#
constructors.table=false
constructors.row=false

#
# Clauses.
#
clauses.From=
clauses.Where=
clauses.GroupBy=
clauses.Having=
clauses.With=
clauses.OrderBy=
clauses.Distinct=
clauses.Top=
clauses.At=
clauses.Window=

#
# 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.
#
operators.logical.And=
operators.logical.Or=
operators.logical.Not=

#
# 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.LessThan[any,any]=
predicates.comparison.LessThanOrEquals[any,any]=
predicates.comparison.Equals[any,any]=
predicates.comparison.NotEquals[any,any]=
predicates.comparison.GreaterThan[any,any]=
predicates.comparison.GreaterThanOrEquals[any,any]=
predicates.comparison.In[any]=
predicates.comparison.Overlaps[any,any,any,any]=

#
# Various predicates.
#
predicates.Between[any,any,any]=
predicates.IsNull=
predicates.IsNotNull=
predicates.Like=
predicates.Like.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]=

#
# 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 (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.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[text]=
functions.CharLength[clob]=
functions.OctetLength[text]=
functions.OctetLength[clob]=
functions.BitLength[text]=
functions.Upper[text]=
functions.Upper[clob]=
functions.Lower[text]=
functions.Lower[clob]=
functions.Substring[text,numeric,numeric]=
functions.Substring[clob,numeric,numeric]=
functions.Position[text,text]=
functions.Position[text,clob]=
functions.Concat[text,text]=
functions.Ascii[text]=
functions.Translate[text,text,text]=

#
# 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]=

#
# FDS functions.
#
# Local process does not support FDS functions.

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

#
# Trigonometric functions.
#
functions.Arccos[numeric]=
functions.Arcsin[numeric]=
functions.Arctan[numeric]=
functions.Cos[numeric]=
functions.Coshyp[numeric]=
functions.Sin[numeric]=
functions.Sinhyp[numeric]=
functions.Tan[numeric]=
functions.Tanhyp[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=

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

#
# Business date functions.
#
functions.AddDays[interval_day_time,numeric]=
functions.AddDays[datetime,numeric]=
functions.AddDays[time_with_time_zone,numeric]=
functions.AddDays[timestamp_with_time_zone,numeric]=
functions.AddMonths[interval_year_month,numeric]=
functions.AddMonths[datetime,numeric]=
functions.AddMonths[time_with_time_zone,numeric]=
functions.AddMonths[timestamp_with_time_zone,numeric]=
functions.AddYears[interval_year_month,numeric]=
functions.AddYears[datetime,numeric]=
functions.AddYears[time_with_time_zone,numeric]=
functions.AddYears[timestamp_with_time_zone,numeric]=
functions.DaysToEndOfMonth[datetime]=
functions.DaysBetween[datetime,datetime]=
functions.FirstOfMonth[datetime]=
functions.LastOfMonth[datetime]=
functions.MakeTimestamp[numeric,numeric,numeric]=
functions.DayOfYear[datetime]=
functions.DayOfWeek[datetime,numeric]=

#
# Mappings used for transformation purposes only.
#
functions.AddHours[time,numeric]=
functions.AddHours[timestamp,numeric]=
functions.AddHours[time_with_time_zone,numeric]=
functions.AddHours[timestamp_with_time_zone,numeric]=
functions.AddMinutes[time,numeric]=
functions.AddMinutes[timestamp,numeric]=
functions.AddMinutes[time_with_time_zone,numeric]=
functions.AddMinutes[timestamp_with_time_zone,numeric]=
functions.AddSeconds[time,numeric]=
functions.AddSeconds[timestamp,numeric]=
functions.AddSeconds[time_with_time_zone,numeric]=
functions.AddSeconds[timestamp_with_time_zone,numeric]=
functions.HoursBetween[datetime,datetime]=
functions.MinutesBetween[datetime,datetime]=
functions.SecondsBetween[datetime,datetime]=

#
# 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=false
literals.integer=false
literals.long=false
literals.float=false
literals.double=false
literals.decimal=false
literals.char=true
literals.nchar=false
literals.varchar=false
literals.nvarchar=false
literals.xml=false

#
# Literal format specifications.
#



#
# Data types.
#
dataType.binary=true
dataType.blob=true
dataType.clob=true
dataType.boolean=true
dataType.date=true
dataType.time=true
dataType.time_with_time_zone=true
dataType.timestamp=true
dataType.timestamp_with_time_zone=true
dataType.interval_day=true
dataType.interval_day_to_hour=true
dataType.interval_day_to_minute=true
dataType.interval_day_to_second=true
dataType.interval_hour=true
dataType.interval_hour_to_minute=true
dataType.interval_hour_to_second=true
dataType.interval_minute=true
dataType.interval_minute_to_second=true
dataType.interval_second=true
dataType.interval_year=true
dataType.interval_year_to_month=true
dataType.interval_month=true
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


#
# Arithmetic operators.
#
operators.arithmetic.Subtract[any,datetime]=
operators.arithmetic.Concat[any,any]=(%1$s + %2$s)
operators.arithmetic.Concat[text,clob]=
operators.arithmetic.Concat[clob,text]=