Bug 1117829

Summary:	Postgres Plugin - Case-sensitivity is not honored in table name configuration updates
Product:	[JBoss] JBoss Operations Network	Reporter:	Michael Burman <miburman>
Component:	Plugin -- Other	Assignee:	Michael Burman <miburman>
Status:	CLOSED CURRENTRELEASE	QA Contact:	Mike Foley <mfoley>
Severity:	medium	Docs Contact:
Priority:	unspecified
Version:	JON 3.2.2	CC:	mmahoney, myarboro, tsegismo
Target Milestone:	ER02	Keywords:	Triaged
Target Release:	JON 3.3.0
Hardware:	Unspecified
OS:	Unspecified
Whiteboard:
Fixed In Version:		Doc Type:	Bug Fix
Doc Text:		Story Points:	---
Clone Of:		Environment:
Last Closed:	2014-12-11 14:03:11 UTC	Type:	Bug
Regression:	---	Mount Type:	---
Documentation:	---	CRM:
Verified Versions:		Category:	---
oVirt Team:	---	RHEL 7.3 requirements from Atomic Host:
Cloudforms Team:	---	Target Upstream Version:
Embargoed:

Description Michael Burman 2014-07-09 13:14:32 UTC

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:

Comment 1 Michael Burman 2014-08-12 19:34:59 UTC

This also affects columns, as both should be quoted in the commands if case-sensitivity is to be preserved.

Comment 2 Michael Burman 2014-08-12 19:42:54 UTC

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

Comment 3 Thomas Segismont 2014-08-25 08:55:35 UTC

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>

Comment 4 Simeon Pinder 2014-09-03 20:31:50 UTC

Moving to ON_QA as available for test with the following brew build:
https://brewweb.devel.redhat.com//buildinfo?buildID=381194