[MDL-32650] Renaming a table does not facilitate the renaming of the associated comment. - Moodle Tracker

XML

Word

Printable

Details

Type: Bug
Status: Closed
Priority: Minor
Resolution: Won't Fix
Affects Version/s: 2.2.2
Fix Version/s: None
Component/s: Database SQL/XMLDB
Labels:
- triaged

Affected Branches:
MOODLE_22_STABLE
Testing Instructions:

Hide

Pick any block / module / course format with a 'db' folder, change the table name and comment in the 'install.xml' file and attempt to do the same action in the 'upgrade.php' file.

Observe the table description in your chosen database viewer.

Show
Pick any block / module / course format with a 'db' folder, change the table name and comment in the 'install.xml' file and attempt to do the same action in the 'upgrade.php' file. Observe the table description in your chosen database viewer.

Description

When you are writing update code in a module/block/course format's 'upgrade.php' and wish to rename a table you can call the function 'rename_table' in '/lib/ddl/database_manager.php', however you cannot rename the associated comment on the table that was defined in the 'install.xml' file. So although you can alter the comment in 'install.xml' for new installations, upgrading installations have the wrong comment in their database to explain what the table is for.

I have stated that this is for 2.2.2 but could be elsewhere too.

Attachments

Activity

People

Assignee:: Unassigned

Reporter:: Gareth J Barnard

Participants:: Gareth J Barnard, Michael de Raadt, Petr Skoda

Component watchers:: Andrew Lyons, Huong Nguyen, Jun Pataleta, Michael Hawkins, Shamim Rezaie, Simey Lameze, Stevani Andolo

Votes:: 0 Vote for this issue

Watchers:: 1 Start watching this issue

Dates

Created:: 27/Apr/12 4:02 AM

Updated:: 07/Mar/14 4:24 PM

Resolved:: 07/Mar/14 4:24 PM