Issue Details (XML | Word | Printable)

Key: MDL-8372
Type: Bug Bug
Status: Resolved Resolved
Resolution: Duplicate
Priority: Minor Minor
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

Drop all TEXT defaults across Moodle

Created: 01/Feb/07 02:07 AM   Updated: 09/Dec/07 01:18 AM
Return to search
Component/s: Database SQL/XMLDB
Affects Version/s: 1.9
Fix Version/s: 1.9

Environment: PostgreSQL and MySQL
Issue Links:
Duplicate
 

Database: PostgreSQL, MySQL
Participants: Eloy Lafuente (stronk7) and Penny Leach
Security Level: None
Resolved date: 09/Dec/07
Affected Branches: MOODLE_19_STABLE
Fixed Branches: MOODLE_19_STABLE


 Description  « Hide
Starting from Moodle 1.7 we are installing all the TEXT fields without defaults. That's OK.

But some old installations will contain some defaults under such type of columns. The idea is to iterate over all the fields of this type in Moodle, dropping the default clause if present.

Needed for MySQL and PostgreSQL (there weren't other flavours before 1.7)

Ciao :-)

 All   Comments   Change History   Version Control      Sort Order: Ascending order - Click to sort in descending order
Penny Leach added a comment - 07/Dec/07 09:16 AM
Eloy - is there a good programmatical way to find all such fields with XMLDB or does it involve looking through a database/schema ?

Eloy Lafuente (stronk7) added a comment - 08/Dec/07 08:15 AM
I think it's introspecting DB. Something like the:

[Check indexes] or [Check bigints] tests currently in XMLDB editor.


Eloy Lafuente (stronk7) added a comment - 09/Dec/07 01:17 AM
This bug really sounded me a lot, so I've performed some searches in the tracker and have found that it was addressed and fixed in bugs like MDL-6218 and MDL-9530.

So I really think we are free from TEXT columns containing DEFAULTs.