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

Fixed test case isnull(bool0) II-12255 #41

Closed hab6 closed 11 months ago

hab6 commented 11 months ago

Summary

Added dialect function to handle ISNULL test for bool0 (boolean) column.

TDVT Test Case: isnull(bool0)

Dialect Function Generated SQL Actual & Expected Results Match?
(none) SELECT (CASE WHEN NVL2(("bool0" != FALSE),0,1) THEN 1 ELSE 0 END) FROM actian."Calcs" GROUP BY 1 No
(added) SELECT (CASE WHEN (("bool0" != FALSE)) THEN 1 ELSE 0 END) FROM actian."Calcs" GROUP BY 1 Yes

Test Results

(Results CSV files have been truncated to show only ISNULL test cases) test_results_BEFOREFIX.csv test_results_AFTERFIX.csv