Moodle

Create one index length checker in the XMLDB Editor

Details

  • Type: Sub-task Sub-task
  • Status: Closed Closed
  • Priority: Major Major
  • Resolution: Won't Fix
  • Affects Version/s: 1.9
  • Fix Version/s: 2.0
  • Component/s: Database SQL/XMLDB
  • Labels:
    None
  • Affected Branches:
    MOODLE_19_STABLE
  • Fixed Branches:
    MOODLE_20_STABLE

Description

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).

Activity

Hide
Permalink
Eloy Lafuente (stronk7) added a comment -

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.

Show
Eloy Lafuente (stronk7) added a comment - 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.

People

Vote (0)
Watch (0)

Dates

  • Created:
    Updated:
    Resolved:
Atlassian JIRA (v4.4.3#663-r165197) | Report a problem
Powered by a free Atlassian JIRA open source license for Moodle. Try JIRA - bug tracking software for your team.