KNOWLEDGE BASE

Incorrect result returns when decryption function is used in custom query


Published: 06 Apr 2022
Last Modified Date: 08 Jul 2022

Issue

The incorrect result is returned when decryption function is used in custom query.

For example, the following query returns incorrect result.
select des_decrypt(st.amount,'Hela!@12Hela!@12')as amount from sliptransaction st
User-added image
 

Environment

  • Tableau Desktop 2021.4.2
  • Windows
  • MySQL

Cause

Incorrect version of driver is used to connect to MySQL database version 5.5.


 

Additional Information

In order to connect from Tableau Desktop to MySQL database, Tableau recommend to use the latest driver version that most closely matches the database version you need to connect to. For example, if you connect to a 5.x database, use the latest 5.x driver.

MySQL Product Archives
https://downloads.mysql.com/archives/c-odbc/
 
Did this article resolve the issue?