exasol_odbc.ini

[Datasource]
Name = exasol_odbc
LogicalQueryFormat = TESTV1
CommandLineOverride = -DConnectPluginsPath=..\src
MaxThread = 1

# Data type tests
[CalcDataTest]
Name = calc_data.
TDS = cast_calcs.*.tds
Type = expression
TestPath = exprtests/standard/setup.calcs_data.txt

[StaplesDataTest]

# All tests
[StandardTests]
# string.split: This function is not supported in Exasol. See https://github.com/exasol/tableau-connector/issues/24
#   Unknown function SPLIT called.
# calcs_data.time: Exasol does not support data type TIME
#   [EXASOL][EXASolution driver]data exception - invalid character value for cast; Value: '19:36:22' Format: 'YYYY-MM-DD HH24:MI:SS.FF6'
# string.startswith.empty: Exasol does not distinguish between NULL and empty strings
# string.endswith.empty: Exasol does not distinguish between NULL and empty strings
# string.find.empty: Exasol does not distinguish between NULL and empty strings
# string.space.empty: Exasol does not distinguish between NULL and empty strings
ExpressionExclusions_Standard = string.split,calcs_data.time,string.endswith.empty,string.startswith.empty,string.find.empty,string.space.empty

[LODTests]

[MedianTests]

[PercentileTests]

[UnionTest]

[ConnectionTests]
CastCalcsTestEnabled = True
StaplesTestEnabled = True

[TestRegexp]
Type = expression
Name = TestRegexp.
TDS = cast_calcs.exasol_odbc.tds
TestPath = exprtests/regexcalcs
# Tests fail because of different regular expression behavior.
Exclusions = string.regex.icu_fallback,string.regexp.match.extended,string.regexp.extract_nth.extended,string.regexp.replace.extended,string.regexp.extract.extended

[TestDateParse]
Type = expression
Name = TestDateParse.
TDS = cast_calcs.exasol_jdbc.tds
TestPath = exprtests/dateparse
# Excluding tests for hour, weekday:
# Exasol expects 'MI' as pattern for minutes instead of 'mm'
# Queries fail with error "data exception - Format appears twice"
# Excluding tests for year and month: Exasol expects pattern 'yyyy' or 'yy' instead of 'y' for year, 'mm' instead of 'm' for month and 'dd' instead of 'd' for day.
Exclusions = date.dateparse.hour, date.dateparse.weekday, date.dateparse.year, date.dateparse.month