• tnurnberg@mysql.com/sin.azundris.com's avatar
    Bug#24660: "enum" field type definition problem · 34122240
    tnurnberg@mysql.com/sin.azundris.com authored
    ENUMs weren't allowed to have character 0xff, a perfectly good character in many locales.
    This was circumvented by mapping 0xff in ENUMs to ',', thereby prevent actual commas from
    being used (because they too would get converted to 0xff on load). Now if 0xff makes an
    appearance, we find a character not used in the enum and use that as a separator. If no
    such character exists, we throw an error.
    
    Any solution would have broken some sort of existing behaviour. This solution should
    serve both fractions (those with 0xff and those with ',' in their enums), but
    WILL REQUIRE A DUMP/RESTORE CYCLE FROM THOSE WITH 0xff IN THEIR ENUMS. :-/
    That is, mysqldump with their current server, and restore when upgrading to one with
    this patch.
    
    (port of the original 4.1 patch. incorporates some suggestions by kaamos.)
    34122240
unireg.cc 29.8 KB