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

["Adam Saghy (Jira)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/FINERACT-1757?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Adam Saghy updated FINERACT-1757:
---------------------------------
    Labels: PepperSoup  (was: )

> 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
>            Priority: Major
>              Labels: PepperSoup
>
> 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)