History | Log In     View a printable version of the current page.  
Issue Details (XML | Word | Printable)

Key: UP-1801
Type: Bug Bug
Status: Closed Closed
Resolution: Duplicate
Priority: Major Major
Assignee: Unassigned
Reporter: Erik Olsson
Votes: 0
Watchers: 0
Operations

If you were logged in you would be able to see more operations.
uPortal

Lowercase table names do not work with MySQL on Linux

Created: 22/Aug/07 12:54 AM   Updated: 29/Aug/07 05:37 PM
Component/s: Database, Distributed Layout Management (DLM)
Affects Version/s: 2.6.0 GA, 2.6.1 RC1
Fix Version/s: None

Original Estimate: 1 hour Remaining Estimate: 1 hour Time Spent: Unknown
File Attachments: 1. Java Source File RDBMDistributedLayoutStore.java (92 kb)

Environment: Linux (Fedora Core 6)
Issue Links:
Duplicate
 
This issue is duplicated by:
UP-1813 table names in lower case Major Open


 Description  « Hide
org.jasig.portal.layout.dlm.RDBMDistributedLayoutStore.java contains 2 queries with lowercase table names. Because of a MySQL bug, latin1 case-insensitive tables do not actually behave in a case-insensitive way on Linux, thus causing RDBMDistributedLayoutStore to fail when the tables appear in lowercase instead of uppercase inside queries. This appears to be the only file with any lowercase queries.

 All   Comments   Work Log   Change History      Sort Order:
Erik Olsson [22/Aug/07 01:20 AM]
New RDBMDistributedLayoutStore.java file with table names in the correct case.

Eric Dalquist [29/Aug/07 05:18 PM]
This issue was duplicated by UP-1813 which has more information about tables & case.