Issue with HeavyDB Version 8.5.0 not working on server (Working fine in local with version 8.3.2-20250128-b0a6c1b6de)

[shiji28]

We are encountering an issue with HeavyDB version 8.5.0 on the server, where it is not functioning as expected due to a specific SQL error. In contrast, version 8.3.2-20250128-b0a6c1b6de works fine in our local environment without this issue.

Steps to Reproduce:

Deploy HeavyDB version 8.5.0 on the server.

Attempt to run the application or execute the transformed SQL query generated by the GenerateVEFTAccountG2 class.

Observe that the application fails with the following error:
SQL Error: Query failed : [OmniSci.java:read:49531:TOmniSciException(error_msg:SQL Error: From line 8, column 380 to line 8, column 462: No match found for function signature RIGHT(, ))]

Expected Behavior:

The application and the SQL query should function correctly on HeavyDB 8.5.0, similar to how it works with version 8.3.2-20250128-b0a6c1b6de in the local environment, processing the financial transaction data without errors.

Actual Behavior:

The application does not work as expected in HeavyDB version 8.5.0 on the server, failing with the SQL error mentioned above, indicating that the RIGHT function is not recognized or supported in this context.

Environment:

Local Environment: HeavyDB 8.3.2-20250128-b0a6c1b6de (working fine)
Server Environment: HeavyDB 8.5.0 (not working)