Adam Saghy created FINERACT-1757:
------------------------------------
Summary: Uppercase letters in the datatable name / column name is
failing on postgres
Key: FINERACT-1757
URL: https://issues.apache.org/jira/browse/FINERACT-1757
Project: Apache Fineract
Issue Type: Bug
Affects Versions: 1.8.0
Reporter: Adam Saghy
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!
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
