[FINERACT-1757] Uppercase letters in the datatable name / column name is failing on postgres

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.8.0
• Fix Version/s: 1.9.0
• Labels: PepperSoup
• Assignee: Jose Alberto Hernandez Maldonado
• Reporter: Adam Saghy
• Created: 05/Oct/22 10:19
• Updated: 07/Jan/24 10:54
• Resolved: 28/Jul/23 13:26

Description

There is no restriction on the datatables whether they can contain uppercase letters.

It was working just fine with Mysql and Mariadb as it was automatically converted all of them on saving and lookup.

However postgres is working differently. It will fail on the lookup if the provided table names contains uppercase letters. The same applies for column names as well.

Steps to reproduce

• Customer create a new datatable with uppercase letters: e.g. m_client_ASD78

• It will be created and stored in the x_registered_table DB table AS-IS: m_client_ASD78

• DB table will be created, but postgres will create the DB table with lowercase letters: m_client_asd78

• Fetching data from that datatable by the datatable name will failing: SELECT * from m_client_ASD78 query will fail as m_client_ASD78 does not exists on postgres (only m_client_asd78 DB table exists)

Important

• Any fix for this problem must consider backward compatibility! On Mysql it was allowed and okay to create DB tables with uppercase letters!

Issue Links

• is a child of: FINERACT-1874 Release Apache Fineract 1.9.0
• links to: GitHub Pull Request #3122