[ 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)