Bug 536526 (RHQ-867)

Summary:	config props with empty string value (i.e. "") are persisted as NULL by Oracle, so the actual value is lost
Product:	[Other] RHQ Project	Reporter:	Ian Springer <ian.springer>
Component:	Configuration	Assignee:	RHQ Project Maintainer <rhq-maint>
Status:	CLOSED CURRENTRELEASE	QA Contact:
Severity:	medium	Docs Contact:
Priority:	medium
Version:	1.0.1	CC:	asantos, ccrouch, cwelton, jshaughn
Target Milestone:	---	Keywords:	SubBug
Target Release:	---
Hardware:	All
OS:	All
URL:	http://jira.rhq-project.org/browse/RHQ-867
Whiteboard:
Fixed In Version:		Doc Type:	Bug Fix
Doc Text:		Story Points:	---
Clone Of:		Environment:
Last Closed:	2014-05-15 21:16:15 UTC	Type:	---
Regression:	---	Mount Type:	---
Documentation:	---	CRM:
Verified Versions:		Category:	---
oVirt Team:	---	RHEL 7.3 requirements from Atomic Host:
Cloudforms Team:	---	Target Upstream Version:
Embargoed:
Bug Depends On:
Bug Blocks:	565628

Description Ian Springer 2008-09-20 01:41:00 UTC

This is unfortunate, because we jumped through a lot of hoops in the GUI layer to distinguish null (aka unset) values from empty values. This was to allow a user to specify one or the other, depending on if they want the prop to be unset (which tells the plugin to either specify null as the value or to not specify any value), or if they want the property to literally have "" as the value. This distinction is currently thrown away if the Server database is Oracle. The solution is probably to store some sort of special marker value in the DB to represent an empty string (e.g. a TAB character or some other character that's impossible to even enter via the GUI).

Comment 1 Red Hat Bugzilla 2009-11-10 21:18:32 UTC

This bug was previously known as http://jira.rhq-project.org/browse/RHQ-867

Comment 2 wes hayutin 2010-02-16 16:59:23 UTC

Temporarily adding the keyword "SubBug" so we can be sure we have accounted for all the bugs.

keyword:
new = Tracking + FutureFeature + SubBug

Comment 3 wes hayutin 2010-02-16 17:04:30 UTC

making sure we're not missing any bugs in rhq_triage

Comment 4 Corey Welton 2010-10-07 03:47:22 UTC

ips - isn't this a dupe of something?

Comment 5 Ian Springer 2010-10-07 16:59:17 UTC

No, I don't think so.