Issue Details (XML | Word | Printable)

Key: MDL-11569
Type: Sub-task Sub-task
Status: Closed Closed
Resolution: Won't Fix
Priority: Major Major
Assignee: Eloy Lafuente (stronk7)
Reporter: Eloy Lafuente (stronk7)
Votes: 0
Watchers: 0
Operations

Add/Edit UI Mockup to this issue
If you were logged in you would be able to see more operations.
Moodle
MDL-19303

Create one index length checker in the XMLDB Editor

Created: 03/Oct/07 03:50 PM   Updated: 31/May/09 07:16 AM
Return to search
Component/s: Database SQL/XMLDB
Affects Version/s: 1.9
Fix Version/s: 2.0

Participants: Eloy Lafuente (stronk7)
Security Level: None
Affected Branches: MOODLE_19_STABLE
Fixed Branches: MOODLE_20_STABLE


 Description  « Hide
MySQL imposes one limit of 1000 bytes (333 utf-8 chars) in indexes. We'll implement such restriction in the XMLDB editor to prevent it (to avoid situations like the described in MDL-11347).

 

 All   Comments   Change History   Version Control      Sort Order: Ascending order - Click to sort in descending order
Eloy Lafuente (stronk7) added a comment - 31/May/09 07:16 AM
We cannot fix this as it's a limit imposed by de MySAM storage engine. Some sites can be using other storages with other limits (for example InnoDB has 3500).

As we don't make difference in XMLDB/DDL for different storages... we cannot do this reliably in the editor.

So won't fix.