Bug 793249 (JBEPP-334)

Summary: Creating pages or portal with same name, but uppercase doesn't work with MySQL and MSSQL
Product: [JBoss] JBoss Enterprise Portal Platform 5 Reporter: Michal Vanco <mvanco>
Component: PortalAssignee: Thomas Heute <theute>
Status: CLOSED WONTFIX QA Contact:
Severity: high Docs Contact:
Priority: high    
Version: 5.0.0.GA, 5.0.1.GACC: epp-bugs, mvecera
Target Milestone: ---   
Target Release: 5.1.0.ER03   
Hardware: Unspecified   
OS: Unspecified   
URL: http://jira.jboss.org/jira/browse/JBEPP-334
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
EPP5-GA-SNAPSHOT-100503 DB - mssql 05 or 08 or mysql
Last Closed: 2010-10-19 13:08:31 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:
Attachments:
Description Flags
jcr_mysql_portal_name.patch none

Description Michal Vanco 2010-05-05 12:41:04 UTC 
Date of First Response: 2010-05-05 09:18:30
project_key: JBEPP

I'm trying to create portal or pages with same name, but uppercase and with MSSQL (MySQL) I'm not able to do that.
With other DBs it works properly.

Looks like these dbs do not support distinction between uppercase and lowercase.

You can simply reproduce it when create portal with name test_portal and another one with name TEST_PORTAL.

There is link to hudson with failing test (POR_09_009):
http://hudson.qa.jboss.com/hudson/view/EPP5/job/epp5_ui_selenium_tests_mysql/32/testReport/
Comment 1 Prabhat Jha 2010-05-05 13:18:30 UTC 
IMO, we should not allow two portal/pages with same name but different case.
Comment 2 Matt Wringe 2010-05-10 18:37:20 UTC 
I can create page with names that only vary by case, but not with portals.

The issue it that in the table JCR_SITEM the field NAME is set as a varchar and in mysql varchar is case insensitive. The field doesn't actually store the portal name, its used as a reference to get to the data that does store it. We can still have a portal name that contains upper and lower case letters with out issue.

The easiest way to fix this issue is to not let mysql use VARCHAR to setup the table, we need to use something else which is case sensitive. If we switch from VARCHAR to VARBINARY then it will work.
Comment 3 Matt Wringe 2010-05-10 18:39:47 UTC 
patch to fix this issue for mysql. It just changes the JCR_SITEM NAME to use VARBINARY instead of VARCHAR
Comment 4 Matt Wringe 2010-05-10 18:39:47 UTC 
Attachment: Added: jcr_mysql_portal_name.patch
Comment 5 Matt Wringe 2010-05-10 19:00:10 UTC 
Attachment: Removed: jcr_mysql_portal_name.patch
Comment 6 Matt Wringe 2010-05-10 19:00:37 UTC 
Attachment: Added: jcr_mysql_portal_name.patch