Scratch : Database Test Detail

Test	H2	Postgres	SqlServer	Snowflake	Spanner	Spanner	Redshift	Athena	Databricks
dynaFunctions::abs::testDecimal	✅	✅	✅	🔴	🔴	🔴	🔴	⚫	🔴
dynaFunctions::abs::testNegative	✅	✅	✅	🔴	🔴	🔴	🔴	⚫	🔴
dynaFunctions::abs::testPositive	✅	✅	✅	🔴	🔴	🔴	🔴	⚫	🔴
dynaFunctions::abs::testZero	✅	✅	✅	🔴	🔴	🔴	🔴	⚫	🔴
dynaFunctions::acos::testDecimal	✅	✅	✅	🔴	🔴	🔴	🔴	⚫	🔴
dynaFunctions::acos::testDecimal1	✅	✅	✅	🔴	🔴	🔴	🔴	⚫	🔴
dynaFunctions::adjust::testAdjust	✅	✅	⚫	🔴	🔴	⚫	⚫	⚫	🔴
dynaFunctions::adjust::testAdjustWithMicroseconds	✅	✅	⚫	🔴	🔴	⚫	⚫	⚫	🔴
dynaFunctions::and::testAndwithConditions	✅	✅	✅	🔴	🔴	🔴	🔴	🔴	🔴
dynaFunctions::asin::testDecimal	✅	✅	✅	🔴	🔴	🔴	🔴	⚫	🔴
dynaFunctions::asin::testDecimal1	✅	✅	✅	🔴	🔴	🔴	🔴	⚫	🔴
dynaFunctions::atan2::testDecimal	✅	✅	✅	🔴	🔴	🔴	🔴	⚫	🔴
dynaFunctions::atan2::testDecimal1	✅	✅	✅	🔴	🔴	🔴	🔴	⚫	🔴
dynaFunctions::atan::testDecimal	✅	✅	✅	🔴	🔴	🔴	🔴	⚫	🔴
dynaFunctions::atan::testDecimal1	✅	✅	✅	🔴	🔴	🔴	🔴	⚫	🔴
dynaFunctions::ceiling::testDecimal	✅	✅	✅	🔴	🔴	🔴	🔴	⚫	🔴
dynaFunctions::ceiling::testInt	✅	✅	✅	🔴	🔴	🔴	🔴	⚫	🔴
dynaFunctions::ceiling::testIntAsFloat	✅	✅	✅	🔴	🔴	🔴	🔴	⚫	🔴
dynaFunctions::coalesce::testCoalesce	✅	✅	✅	🔴	🔴	🔴	🔴	⚫	🔴
dynaFunctions::concat::testNoSpace	✅	⚫	✅	🔴	🔴	⚫	🔴	⚫	🔴
dynaFunctions::concat::testSpaceBeforeSecondString	✅	⚫	✅	🔴	🔴	⚫	🔴	⚫	🔴
dynaFunctions::contains::testNoSpace	✅	✅	✅	🔴	🔴	🔴	🔴	⚫	🔴
dynaFunctions::contains::testSpace	✅	✅	✅	🔴	🔴	🔴	🔴	⚫	🔴
dynaFunctions::contains::testSpaceFalse	✅	✅	✅	🔴	🔴	🔴	🔴	⚫	🔴
dynaFunctions::cos::testDecimal	✅	✅	✅	🔴	🔴	🔴	🔴	⚫	🔴
dynaFunctions::cos::testDecimal1	✅	✅	✅	🔴	🔴	🔴	🔴	⚫	🔴
dynaFunctions::dateDiff::testDaysDiff	✅	🔴	⚫	🔴	⚫	⚫	⚫	⚫	🔴
dynaFunctions::dateDiff::testHoursDiff	✅	🔴	⚫	🔴	⚫	⚫	⚫	⚫	🔴
dynaFunctions::dateDiff::testMilliSecondsDiff	✅	🔴	⚫	🔴	⚫	⚫	⚫	⚫	🔴
dynaFunctions::dateDiff::testMinutesDiff	✅	🔴	⚫	🔴	⚫	⚫	⚫	⚫	🔴
dynaFunctions::dateDiff::testMonthsDiff	✅	🔴	⚫	🔴	⚫	⚫	⚫	⚫	🔴
dynaFunctions::dateDiff::testSecondsDiff	✅	🔴	⚫	🔴	⚫	⚫	⚫	⚫	🔴
dynaFunctions::dateDiff::testYearsDiffNegative	✅	🔴	⚫	🔴	⚫	⚫	⚫	⚫	🔴
dynaFunctions::dateDiff::testYearsDiffPositive	✅	🔴	⚫	🔴	⚫	⚫	⚫	⚫	🔴
dynaFunctions::dateDiff::testYearsDiffZero	✅	✅	⚫	🔴	⚫	⚫	⚫	⚫	🔴
dynaFunctions::datePart::testDatePartWithDateTime	✅	✅	✅	🔴	⚫	⚫	⚫	⚫	🔴
dynaFunctions::datePart::testDatePartWithStrictDate	✅	✅	✅	🔴	⚫	⚫	⚫	⚫	🔴
dynaFunctions::dayOfMonth::testDayOfMonth	✅	⚫	⚫	⚫	⚫	⚫	⚫	⚫	🔴
dynaFunctions::dayOfWeekNumber::testDayOfWeekNumber	✅	⚫	✅	🔴	⚫	⚫	⚫	⚫	🔴
dynaFunctions::endsWith::testEndsWith	✅	✅	✅	🔴	🔴	🔴	🔴	⚫	🔴
dynaFunctions::endsWith::testNotEndsWith	✅	✅	✅	🔴	🔴	🔴	🔴	⚫	🔴
dynaFunctions::equal::testNumberEquality	✅	✅	✅	🔴	🔴	🔴	🔴	🔴	🔴
dynaFunctions::exp::testDecimal	✅	✅	✅	🔴	🔴	🔴	🔴	⚫	🔴
dynaFunctions::exp::testDecimal1	✅	✅	✅	🔴	🔴	🔴	🔴	⚫	🔴
dynaFunctions::firstDayOfMonth::testFirstDayOfMonth	✅	⚫	✅	🔴	⚫	⚫	⚫	⚫	🔴
dynaFunctions::firstDayOfQuarter::testFirstDayOfQuarter	✅	⚫	✅	🔴	⚫	⚫	⚫	⚫	🔴
dynaFunctions::firstDayOfThisMonth::testFirstDayOfThisMonth	✅	⚫	✅	🔴	⚫	⚫	⚫	⚫	🔴
dynaFunctions::firstDayOfThisQuarter::testFirstDayOfThisQuarter	✅	⚫	✅	🔴	⚫	⚫	⚫	⚫	🔴
dynaFunctions::firstDayOfThisYear::testFirstDayOfThisYear	✅	⚫	✅	🔴	⚫	⚫	⚫	⚫	🔴
dynaFunctions::firstDayOfWeek::testFirstDayOfWeek	✅	⚫	⚫	🔴	⚫	⚫	⚫	⚫	🔴
dynaFunctions::firstDayOfYear::testFirstDayOfYear	✅	⚫	✅	🔴	⚫	⚫	⚫	⚫	🔴
dynaFunctions::floor::testDecimal	✅	✅	✅	🔴	🔴	🔴	🔴	⚫	🔴
dynaFunctions::floor::testInt	✅	✅	✅	🔴	🔴	🔴	🔴	⚫	🔴
dynaFunctions::floor::testIntAsFloat	✅	✅	✅	🔴	🔴	🔴	🔴	⚫	🔴
dynaFunctions::greaterThan::testNumbers	✅	✅	✅	🔴	🔴	🔴	🔴	🔴	🔴
dynaFunctions::greaterThanEqual::testNumbers	✅	✅	✅	🔴	🔴	🔴	🔴	🔴	🔴
dynaFunctions::hour::testHour	✅	✅	🔴	🔴	🔴	⚫	🔴	⚫	🔴
dynaFunctions::in::testIn	✅	✅	✅	🔴	🔴	🔴	🔴	🔴	🔴
dynaFunctions::indexOf::testChar	✅	⚫	⚫	🔴	⚫	⚫	⚫	⚫	🔴
dynaFunctions::indexOf::testString	✅	⚫	⚫	🔴	⚫	⚫	⚫	⚫	🔴
dynaFunctions::isEmpty::testSqlNull	✅	✅	✅	🔴	🔴	🔴	🔴	🔴	🔴
dynaFunctions::isNotEmpty::testSqlNull	✅	✅	✅	🔴	🔴	⚫	🔴	🔴	🔴
dynaFunctions::isNotNull::testSqlNull	✅	✅	✅	🔴	🔴	🔴	🔴	🔴	🔴
dynaFunctions::isNull::testSqlNull	✅	✅	✅	🔴	🔴	⚫	🔴	🔴	🔴
dynaFunctions::joinStrings::testNoSpace	✅	✅	⚫	🔴	🔴	🔴	🔴	⚫	🔴
dynaFunctions::left::testNoSpace	✅	⚫	✅	🔴	⚫	⚫	⚫	⚫	🔴
dynaFunctions::left::testSpace	✅	⚫	✅	🔴	⚫	⚫	⚫	⚫	🔴
dynaFunctions::length::testWithString	✅	✅	✅	🔴	⚫	🔴	⚫	⚫	🔴
dynaFunctions::lessThan::testNumbers	✅	✅	✅	🔴	🔴	🔴	🔴	🔴	🔴
dynaFunctions::lessThanEqual::testNumbers	✅	✅	✅	🔴	🔴	🔴	🔴	🔴	🔴
dynaFunctions::log::testDecimal	✅	✅	🔴	🔴	🔴	🔴	🔴	⚫	🔴
dynaFunctions::log::testDecimal1	✅	✅	🔴	🔴	🔴	🔴	🔴	⚫	🔴
dynaFunctions::ltrim::testNoSpace	✅	⚫	✅	🔴	⚫	⚫	⚫	⚫	🔴
dynaFunctions::ltrim::testStartingSpace	✅	⚫	✅	🔴	⚫	⚫	⚫	⚫	🔴
dynaFunctions::matches::testMatchesAlphaNumeric	✅	⚫	⚫	🔴	⚫	⚫	⚫	⚫	⚫
dynaFunctions::matches::testMatchesNonAlphaNumeric	✅	⚫	⚫	🔴	⚫	⚫	⚫	⚫	⚫
dynaFunctions::minute::testminute	✅	⚫	🔴	🔴	🔴	⚫	🔴	⚫	🔴
dynaFunctions::mod::testIntDivisible	✅	✅	⚫	🔴	🔴	🔴	🔴	⚫	🔴
dynaFunctions::mod::testIntNonDivisible	✅	✅	⚫	🔴	🔴	🔴	🔴	⚫	🔴
dynaFunctions::month::testMonthAsNumber	✅	⚫	✅	🔴	🔴	⚫	🔴	⚫	🔴
dynaFunctions::monthNumber::testMonthNumber	✅	⚫	✅	🔴	🔴	⚫	🔴	⚫	🔴
dynaFunctions::mostRecentDayOfWeek::testMostRecentDayOfWeekWithDate	✅	⚫	⚫	🔴	⚫	⚫	⚫	⚫	🔴
dynaFunctions::notEqual::testNumberInequality	✅	✅	✅	🔴	🔴	🔴	🔴	🔴	🔴
dynaFunctions::notEqualAnsi::testNumberInequality	✅	✅	✅	🔴	🔴	🔴	🔴	⚫	🔴
dynaFunctions::now::testNow	✅	✅	✅	🔴	🔴	🔴	🔴	⚫	🔴
dynaFunctions::or::testOrWithConditions	✅	✅	✅	🔴	🔴	🔴	🔴	🔴	🔴
dynaFunctions::pow::testDecimal	✅	✅	✅	🔴	🔴	🔴	🔴	⚫	🔴
dynaFunctions::pow::testDecimal1	✅	✅	✅	🔴	🔴	🔴	🔴	⚫	🔴
dynaFunctions::previousDayOfWeek::testPreviousDayOfWeekWithDate	✅	⚫	⚫	🔴	⚫	⚫	⚫	⚫	🔴
dynaFunctions::quarter::testQuarterAsNumber	✅	🔴	🔴	🔴	🔴	⚫	⚫	⚫	🔴
dynaFunctions::quarterNumber::testQuarterNumber	✅	🔴	🔴	🔴	🔴	⚫	⚫	⚫	🔴
dynaFunctions::rem::testIntDivisible	✅	✅	⚫	🔴	🔴	🔴	🔴	⚫	🔴
dynaFunctions::rem::testIntNonDivisible	✅	✅	⚫	🔴	🔴	🔴	🔴	⚫	🔴
dynaFunctions::replace::testCharReplace	✅	✅	✅	🔴	🔴	🔴	🔴	⚫	🔴
dynaFunctions::replace::testStringReplace	✅	✅	✅	🔴	🔴	🔴	🔴	⚫	🔴
dynaFunctions::right::testNoSpace	✅	⚫	✅	🔴	🔴	⚫	🔴	⚫	🔴
dynaFunctions::right::testSpace	✅	⚫	✅	🔴	🔴	⚫	🔴	⚫	🔴
dynaFunctions::round::testDecimalLower	✅	✅	✅	🔴	🔴	🔴	🔴	⚫	🔴
dynaFunctions::round::testDecimalUpper	✅	✅	✅	🔴	🔴	🔴	🔴	⚫	🔴
dynaFunctions::round::testInt	✅	✅	✅	🔴	🔴	🔴	🔴	⚫	🔴
dynaFunctions::rtrim::testNoSpace	✅	⚫	✅	🔴	🔴	⚫	🔴	⚫	🔴
dynaFunctions::rtrim::testTrailingSpace	✅	⚫	✅	🔴	🔴	⚫	🔴	⚫	🔴
dynaFunctions::second::testSecond	✅	🔴	🔴	🔴	🔴	⚫	🔴	⚫	🔴
dynaFunctions::sin::testDecimal	✅	✅	✅	🔴	🔴	🔴	🔴	⚫	🔴
dynaFunctions::sin::testDecimal1	✅	✅	✅	🔴	🔴	🔴	🔴	⚫	🔴
dynaFunctions::sqlFalse::testSqlFalse	✅	✅	🔴	🔴	🔴	🔴	🔴	⚫	🔴
dynaFunctions::sqlNull::testIsNull	✅	✅	✅	🔴	🔴	⚫	🔴	🔴	🔴
dynaFunctions::sqlTrue::testSqlTrue	✅	✅	🔴	🔴	🔴	🔴	🔴	⚫	🔴
dynaFunctions::sqrt::testInt1	✅	✅	✅	🔴	🔴	🔴	🔴	⚫	🔴
dynaFunctions::sqrt::testInt2	✅	✅	✅	🔴	🔴	🔴	🔴	⚫	🔴
dynaFunctions::startsWith::testEndsWithSpace	✅	✅	✅	🔴	🔴	🔴	🔴	⚫	🔴
dynaFunctions::startsWith::testNotStartsWith	✅	✅	✅	🔴	🔴	🔴	🔴	⚫	🔴
dynaFunctions::startsWith::testStartsWith	✅	✅	✅	🔴	🔴	🔴	🔴	⚫	🔴
dynaFunctions::startsWith::testStartsWithSpace	✅	✅	✅	🔴	🔴	🔴	🔴	⚫	🔴
dynaFunctions::substring::testCustomEndIndex	✅	✅	✅	🔴	🔴	🔴	🔴	⚫	🔴
dynaFunctions::substring::testCustomStartIndex	✅	✅	✅	🔴	🔴	🔴	🔴	⚫	🔴
dynaFunctions::substring::testEndIndexExceedingStringLength	✅	✅	✅	🔴	🔴	🔴	🔴	⚫	🔴
dynaFunctions::tan::testDecimal	✅	✅	✅	🔴	🔴	🔴	🔴	⚫	🔴
dynaFunctions::tan::testDecimal1	✅	✅	✅	🔴	🔴	🔴	🔴	⚫	🔴
dynaFunctions::toLower::test1	✅	✅	✅	🔴	🔴	🔴	🔴	⚫	🔴
dynaFunctions::toTimestamp::testToTimestamp	✅	⚫	⚫	🔴	⚫	⚫	⚫	⚫	⚫
dynaFunctions::toUpper::test1	✅	✅	✅	🔴	🔴	🔴	🔴	⚫	🔴
dynaFunctions::today::testToday	✅	✅	✅	🔴	🔴	🔴	🔴	⚫	🔴
dynaFunctions::trim::testNoSpace	✅	✅	✅	🔴	🔴	🔴	🔴	⚫	🔴
dynaFunctions::trim::testSpace	✅	✅	✅	🔴	🔴	🔴	🔴	⚫	🔴
dynaFunctions::weekOfYear::testWeekOfYear	✅	⚫	✅	🔴	🔴	⚫	🔴	⚫	🔴
dynaFunctions::year::testYear	✅	⚫	🔴	🔴	⚫	⚫	🔴	⚫	🔴
literals::string::testApostrophe	✅	✅	✅	🔴	🔴	🔴	🔴	🔴	🔴
literals::varPlaceHolder::testApostropheInParameterValue	✅	✅	✅	🔴	🔴	🔴	🔴	🔴	🔴
meta::relational::tests::dbSpecificTests::sqlQueryTests::dynaFunctions::position	⚫	⚫	⚫	⚫	⚫	⚫	⚫	⚫	⚫
namingTests::setUp	✅	✅	⚫	⚫	⚫	✅	⚫	⚫	⚫
namingTests::testASCiiAliasName	✅	🔴	🔴	🔴	🔴	🔴	🔴	⚫	🔴
namingTests::testASCiiColumnName	✅	🔴	🔴	🔴	🔴	🔴	🔴	⚫	🔴
namingTests::testAsciiColumnNameAndAsciiAliasName	✅	🔴	🔴	🔴	🔴	🔴	🔴	⚫	🔴
namingTests::testColumnNames	✅	🔴	🔴	🔴	🔴	🔴	🔴	⚫	🔴
namingTests::testTableNameInJoinAlias	✅	🔴	🔴	🔴	🔴	🔴	🔴	⚫	🔴
selectSubClauses::aggregationDynaFns::average::testAverage	✅	🔴	🔴	🔴	🔴	🔴	🔴	⚫	🔴
selectSubClauses::aggregationDynaFns::count::testOnAllRows	✅	🔴	🔴	🔴	🔴	🔴	🔴	🔴	🔴
selectSubClauses::aggregationDynaFns::max::testMax	✅	🔴	🔴	🔴	🔴	🔴	🔴	⚫	🔴
selectSubClauses::aggregationDynaFns::min::testMin	✅	🔴	🔴	🔴	🔴	🔴	🔴	⚫	🔴
selectSubClauses::aggregationDynaFns::size::testSize	✅	🔴	🔴	🔴	🔴	🔴	🔴	⚫	🔴
selectSubClauses::aggregationDynaFns::stdDevPopulation::testStdDevPopulation	✅	🔴	🔴	🔴	🔴	⚫	🔴	⚫	🔴
selectSubClauses::aggregationDynaFns::stdDevSample::testStdDevSample	✅	🔴	🔴	🔴	🔴	⚫	🔴	⚫	🔴
selectSubClauses::aggregationDynaFns::sum::testSum	✅	🔴	🔴	🔴	🔴	🔴	🔴	⚫	🔴
selectSubClauses::drop::testDropLimitByVendor	✅	🔴	🔴	🔴	🔴	🔴	🔴	⚫	🔴
selectSubClauses::drop::testSimpleDrop	✅	🔴	🔴	🔴	🔴	🔴	🔴	⚫	🔴
selectSubClauses::filters::testFilterAfterFilter	✅	🔴	🔴	🔴	⚫	🔴	⚫	⚫	🔴
selectSubClauses::filters::testFilterMultipleExpressions	✅	🔴	🔴	🔴	🔴	🔴	🔴	⚫	🔴
selectSubClauses::filters::testFilterOnAssociatedClassAggValueAfterGroupBy	✅	🔴	⚫	🔴	🔴	🔴	🔴	⚫	🔴
selectSubClauses::filters::testGreaterThanEqualString	✅	🔴	🔴	🔴	🔴	🔴	🔴	🔴	🔴
selectSubClauses::filters::testLessThanEqualString	✅	🔴	🔴	🔴	🔴	🔴	🔴	🔴	🔴
selectSubClauses::filters::testSelectEqual	✅	🔴	🔴	🔴	🔴	🔴	🔴	🔴	🔴
selectSubClauses::filters::testSelectNotEqual	✅	🔴	🔴	🔴	🔴	🔴	🔴	🔴	🔴
selectSubClauses::groupBy::simpleGroupByCount	✅	🔴	🔴	🔴	🔴	🔴	🔴	⚫	🔴
selectSubClauses::join::testInnerJoinSimple	✅	🔴	🔴	🔴	🔴	🔴	🔴	🔴	🔴
selectSubClauses::join::testJoinByMultiColumnName	✅	🔴	🔴	🔴	🔴	🔴	🔴	🔴	🔴
selectSubClauses::join::testJoinBySingleColumnName	✅	🔴	🔴	🔴	🔴	🔴	🔴	🔴	🔴
selectSubClauses::join::testLeftOuterJoinSimple	✅	🔴	🔴	🔴	🔴	🔴	🔴	⚫	🔴
selectSubClauses::join::testRightOuterJoinSimple	✅	🔴	🔴	🔴	🔴	🔴	🔴	⚫	🔴
selectSubClauses::join::testSelfJoinInner	✅	🔴	🔴	🔴	🔴	🔴	🔴	🔴	🔴
selectSubClauses::join::testSelfJoinOuter	✅	🔴	🔴	🔴	🔴	🔴	🔴	🔴	🔴
selectSubClauses::limit::testSimpleLimit	✅	🔴	🔴	🔴	🔴	🔴	🔴	⚫	🔴
selectSubClauses::mixtureOfCluases::groupByAfterConcatenate	✅	🔴	🔴	🔴	🔴	⚫	🔴	⚫	🔴
selectSubClauses::mixtureOfCluases::testFilterAfterJoinInner	✅	🔴	🔴	🔴	🔴	🔴	🔴	🔴	🔴
selectSubClauses::mixtureOfCluases::testFilterAfterJoinOuter	✅	🔴	🔴	🔴	🔴	🔴	🔴	🔴	🔴
selectSubClauses::mixtureOfCluases::testGroupByAfterJoinInner	✅	🔴	🔴	🔴	🔴	🔴	🔴	⚫	🔴
selectSubClauses::mixtureOfCluases::testGroupByAfterJoinOuter	✅	🔴	🔴	🔴	🔴	🔴	🔴	⚫	🔴
selectSubClauses::orderBy::testDoubleSortAsc	✅	🔴	🔴	🔴	🔴	🔴	🔴	🔴	🔴
selectSubClauses::orderBy::testDoubleSortAscChain	✅	🔴	🔴	🔴	🔴	🔴	🔴	🔴	🔴
selectSubClauses::orderBy::testDoubleSortDesc	✅	🔴	🔴	🔴	🔴	🔴	🔴	🔴	🔴
selectSubClauses::orderBy::testDoubleSortDescChain	✅	🔴	🔴	🔴	🔴	🔴	🔴	🔴	🔴
selectSubClauses::orderBy::testDoubleSortMixed	✅	🔴	🔴	🔴	🔴	🔴	🔴	🔴	🔴
selectSubClauses::orderBy::testDoubleSortMixedChain	✅	🔴	🔴	🔴	🔴	🔴	🔴	🔴	🔴
selectSubClauses::orderBy::testSimpleSortAsc	✅	🔴	🔴	🔴	🔴	🔴	🔴	🔴	🔴
selectSubClauses::orderBy::testSimpleSortDesc	✅	🔴	🔴	🔴	🔴	🔴	🔴	🔴	🔴
selectSubClauses::setUp	✅	✅	⚫	⚫	⚫	✅	⚫	✅	⚫
selectSubClauses::slice::testSlice	✅	🔴	🔴	🔴	🔴	🔴	🔴	⚫	🔴
selectSubClauses::slice::testSliceWithRestrict	✅	🔴	🔴	🔴	🔴	🔴	🔴	⚫	🔴
selectSubClauses::take::testSimpleTake	✅	🔴	🔴	🔴	🔴	🔴	🔴	⚫	🔴
selectSubClauses::union::testConcatenateWithPostOperation	✅	🔴	🔴	🔴	🔴	🔴	🔴	🔴	🔴
selectSubClauses::union::testConcatenateWithPreOperation	✅	🔴	🔴	🔴	🔴	🔴	🔴	🔴	🔴
selectSubClauses::union::testSimpleConcatenate	✅	🔴	🔴	🔴	🔴	🔴	🔴	🔴	🔴
selectSubClauses::view::testUnionOnViewsMapping	✅	🔴	🔴	🔴	🔴	🔴	🔴	🔴	🔴
selectSubClauses::view::testViewAllOneSimpleProperty	✅	🔴	🔴	🔴	🔴	🔴	🔴	🔴	🔴
selectSubClauses::view::testViewOnView	✅	🔴	🔴	🔴	🔴	🔴	🔴	🔴	🔴
selectSubClauses::windowColumn::testWindowWithSortSingle	✅	⚫	⚫	🔴	🔴	⚫	🔴	⚫	🔴
selectSubClauses::windowColumn::testWindowWithoutSortMultiple	✅	⚫	⚫	🔴	🔴	⚫	🔴	⚫	🔴
selectSubClauses::windowColumn::windowAvg	✅	⚫	⚫	🔴	🔴	⚫	🔴	⚫	🔴
selectSubClauses::windowColumn::windowWithSortMultiple	✅	⚫	⚫	🔴	🔴	⚫	🔴	⚫	🔴