Description of problem: When trying to update configuration changes (adding column), case-sensitivity is lost. This makes the update fail. Version-Release number of selected component (if applicable): 3.2.0.GA / RHQ 4.11 How reproducible: Always Steps to Reproduce: 1. Create table with upper-case and lower-case letters (such as testTable) 2. Go to configuration and add column Actual results: Update fails with error message: org.postgresql.util.PSQLException: ERROR: relation "testtable" does not exist Expected results: Configuration would succeed Additional info:
This also affects columns, as both should be quoted in the commands if case-sensitivity is to be preserved.
Fixed in master: commit 47e2f193906fbcc8b49f8040c9eef0bb48a5de63 Author: Michael Burman <miburman> Date: Tue Aug 12 22:41:39 2014 +0300 [BZ 1117829] Add quotes around necessary tableNames and columnNames to force case-sensitivity on PostgreSQL
Cherry-picked over to release/jon3.3.x commit 692c4b2c1958b23ca520edf425d7216ec758b637 Author: Michael Burman <miburman> Date: Tue Aug 12 22:41:39 2014 +0300 [BZ 1117829] Add quotes around necessary tableNames and columnNames to force case-sensitivity on PostgreSQL (cherry picked from commit 47e2f193906fbcc8b49f8040c9eef0bb48a5de63) Signed-off-by: Thomas Segismont <tsegismo>
Moving to ON_QA as available for test with the following brew build: https://brewweb.devel.redhat.com//buildinfo?buildID=381194