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

Fix for TDVT DATEDIFF failures in II-12235, II-12236, II-12237 #35

Closed hab6 closed 12 months ago

hab6 commented 1 year ago

Summary

This fix remedies failures that occur in several TDVT test cases using the Actian JDBC Connector.

Fixed TDVT Test Cases

JIra Issue Test Name Test Case
II-12235 date.datediff.sow.week DATEDIFF('week', [date3], [date2], 'sunday')
DATEDIFF('week', DATETIME([date2]), [datetime0], 'sunday')
Note: One other test case was not remedied by this fix.
II-12236 date.datediff.week.extended DATEDIFF('week', [date2], #2050-01-01#)
II-12237 date.datediff.week DATEDIFF('week', [date3], [date2])
DATEDIFF('week', DATETIME([date2]), [datetime0])

TDVT Results

Note Passed Failed Total
Before Fix 832 36 868
After Fix 837 31 868

Source of Remedial Formula

The fix was found in the Connector SDK sample postgres dialect at this line.

Test Results

test_results_combined-BEFORE.csv test_results_combined-AFTER.csv