Incorrect result returns when decryption function is used in custom query

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


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


  • Tableau Desktop 2021.4.2
  • Windows
  • MySQL


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
Did this article resolve the issue?