Hide Forgot
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/
IMO, we should not allow two portal/pages with same name but different case.
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.
patch to fix this issue for mysql. It just changes the JCR_SITEM NAME to use VARBINARY instead of VARCHAR
Attachment: Added: jcr_mysql_portal_name.patch
Attachment: Removed: jcr_mysql_portal_name.patch