search

ActianCorp / actian_tableau_connector

Tableau connector (aka taco) for Actian Avalanche, Vector, and Ingres
https://extensiongallery.tableau.com/products/936
Apache License 2.0
1 stars 4 forks source link

TDVT DATETRUNC WEEK fix with SOW = monday for II-12240 #37

Closed hab6 closed 1 year ago

hab6 commented 1 year ago

Summary

Remedy for failures that occur in TDVT test case datetrunc.sow.week with sow='monday' using the Actian JDBC Connector.

Related Jira Issue: II-12240

TDVT DATETRUNC Test Cases

Test Case Without Fix With Fix
DATETRUNC('week', [date2], 'monday') Fail Pass
DATETRUNC('week', [date2], 'sunday') Pass Pass
DATETRUNC('week', [datetime0], 'monday') Fail Pass
DATETRUNC('week', [datetime0], 'sunday') Pass Pass
DATETRUNC('week', [date2]) Pass Pass
DATETRUNC('week', [datetime0]) Pass Pass
DATETRUNC('week', DATE(null)) Pass Pass
DATETRUNC('week', DATETIME(null)) Pass Pass
DATETRUNC('week', DATETIME(null), 'sunday') Pass Pass
DATETRUNC('week', DATE(null), 'sunday') Pass Pass

TDVT Results

Note Passed Failed Total
Without Fix 839 29 868
With Fix 841 27 868

Test Results

test_results_combined-BeforeTruncFix.csv test_results_combined-AfterTruncFix.csv