[
https://issues.apache.org/jira/browse/FINERACT-1757?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Adam Saghy updated FINERACT-1757:
---------------------------------
Fix Version/s: 1.9.0
> 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
> Fix For: 1.9.0
>
>
> 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)
