Note: This bug is displayed in read-only format because the product is no longer active in Red Hat Bugzilla.

Bug 147453

Summary:	web_user_personal_info is lacking the email_uc column
Product:	Red Hat Satellite 5	Reporter:	Mike McCune <mmccune>
Component:	Other	Assignee:	Clifford Perry <cperry>
Status:	CLOSED WONTFIX	QA Contact:	Red Hat Satellite QA List <satqe-list>
Severity:	medium	Docs Contact:
Priority:	medium
Version:	unspecified	CC:	chip
Target Milestone:	---
Target Release:	---
Hardware:	All
OS:	Linux
Whiteboard:
Fixed In Version:		Doc Type:	Bug Fix
Doc Text:		Story Points:	---
Clone Of:		Environment:
Last Closed:	2009-03-24 17:55:02 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:	147612, 147613
Bug Blocks:	142205

Description Mike McCune 2005-02-08 03:26:45 UTC

This column exists in the Sat schema but not hosted.  This
inconsistency makes it difficult to write code that will work with
both codebases. 

This column should behave the same as the login_uc column.

Comment 1 James Slagle 2005-02-09 20:00:00 UTC

Plan is to actually remove the email_uc from wupi in satellite.  The required
functionality will be acoomplished by the upper(email) index.

Comment 2 James Slagle 2005-02-21 22:45:59 UTC

Column removed from satellite schema.

Comment 3 James Slagle 2005-09-27 20:25:51 UTC

Column *not* removed from satellite schema.  However, the index has been added
in hosted.  Not sure what's going on with this.

Comment 4 Mike McCune 2005-09-27 20:43:37 UTC

any reason we can't get the column removed from the sat schema?  We still would
like it removed so we can simplify the java code.

Comment 5 James Slagle 2005-09-27 22:16:35 UTC

Well, we went with the index on upper(email) in hosted b/c it was too
impractical to add a column for email_uc (and populate it) on hosted.  However,
to use the index we had to use a hint in the query.

The only issue with hints is that they force the use of Oracle's cost based
optimizer (CBO) as opposed to the rule based optimizer (RBO).  RHN typically
tries to stick with the rule optimizer.  No big deal for hosted really, b/c we
can keep on this query in hosted and if the CBO starts doing something funky we
can mediate those.

For a satellite though, I don't know if we want the embedded db switching
between CBO and RBO.  We would have to see if there were any issues.  So, I
don't know if it's worth the work just to have the Java code simplified,
although it may be.  Might be a good idea to get other folks thoughts on CBO vs.
RBO in a satellite.  Sorry for the brain dump, I had to get my thoughts straight
on what we had already done.

Comment 7 Red Hat Bugzilla 2007-10-26 00:47:40 UTC

User jslagle's account has been closed