Bug 1029269

Summary:	Bugzilla validation does not check capitialisation of keywords
Product:	[Community] PressGang CCMS	Reporter:	Matthew Casperson <mcaspers>
Component:	CCMS-Core	Assignee:	Lee Newson <lnewson>
Status:	CLOSED CURRENTRELEASE	QA Contact:
Severity:	unspecified	Docs Contact:
Priority:	unspecified
Version:	1.2	CC:	cbredesen, lnewson
Target Milestone:	---
Target Release:	1.3
Hardware:	Unspecified
OS:	Unspecified
Whiteboard:
Fixed In Version:		Doc Type:	Bug Fix
Doc Text:		Story Points:	---
Clone Of:		Environment:
Last Closed:	2013-12-03 22:16:10 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:

Description Matthew Casperson 2013-11-12 02:52:33 UTC

When saving a spec through the ui, incorrectly capitialised bugzilla keywords are not flagged as being invalid. They are flagged when the book is built using the csprocessor.

For example, the bugzilla keyword "documentation" will not generate a warning even though the keyword should be "Documentation"

Comment 1 Lee Newson 2013-11-12 04:00:40 UTC

Fixed in 1.3-SNAPSHOT build 201311121353

The teiid validator will include the name in the query and then do a comparison after to make sure it matches since the Bugzilla database uses a case insensitive collation. This was done as the normal means of doing via an SQL query (such as using BINARY or COLLATION) don't work with the current version of Teiid used for the VDB.

Note: This version is currently live on the test/development server.

Comment 2 Matthew Casperson 2013-11-24 21:12:59 UTC

I have verified that an incorrectly capitalised BZ keyword is flagged as a warning.