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

Add function ISNULL(bool) to ODBC dialect #54

Closed hab6 closed 2 months ago

hab6 commented 2 months ago

Overview

The Actian Tableau ODBC connector dialect is missing a logical function to process ISNULL with a boolean input parameter. This function exists in the dialect for the JDBC connector but not for the ODBC connector.

The problem was found when testing against a backend of Ingres 12.0 when Tableau TDVT test logical.bool isnull([bool0]) failed with the Actian v1.0.6 ODBC connector.

Internal ticket II-14841

Testing

The fix was tested successfully with the following environments.

Client

Tableau Desktop 24.1.2
Tableau Connector SDK version 2.13.7
Actian Tableau JDBC Connector version 1.0.6 (with fix)
Microsoft Windows [Version 10.0.19045.4412]

Server 1

Ingres 11.2.0 (15807)
Microsoft Windows [Version 10.0.19045.4412]

Server 2

Ingres 12.0
Microsoft Windows