• unknown's avatar
    Bug #20536: md5() with GROUP BY and UCS2 return different results on myisam/innodb · 3212b399
    unknown authored
    Make the encryption functions MD5(), SHA1() and ENCRYPT() return binary results.
        
    Make MAKE_SET() and EXPORT_SET() use the correct character set for their default separator strings.
    
    
    mysql-test/r/ctype_ucs.result:
      Add tests for bug #20536.
    mysql-test/t/ctype_ucs.test:
      Add tests for bug #20536.
      
      Tests showing correct behavior for MD5(), SHA1(), MAKE_SET() and EXPORT_SET().
      
      Also, tests showing incorrect behavior, which will remain "Won't fix", for
      PASSWORD(), OLD_PASSWORD(), ENCRYPT() and QUOTE().
    sql/item_strfunc.cc:
      Make the encryption functions MD5(), SHA1() and ENCRYPT() return binary results.
      
      Make MAKE_SET() and EXPORT_SET() use the correct character set for their default separator strings.
    sql/item_strfunc.h:
      Make the encryption functions MD5(), SHA1() and ENCRYPT() return binary results.
    3212b399
item_strfunc.cc 75.3 KB