• unknown's avatar
    Move handling of suffix_length from strnxfrm_bin() to filesort to ensure... · 55a21a33
    unknown authored
    Move handling of suffix_length from strnxfrm_bin() to filesort to ensure proper sorting of all kind of binary objects
    field::sort_key() now adds length last for varbinary/blob
    VARBINARY/BLOB is now sorted by filesort so that shorter strings comes before longer ones
    Fixed issues in test cases from last merge
    
    
    
    mysql-test/r/select.result:
      Change column name in test to get GROUP BY to use the alias
    mysql-test/r/type_blob.result:
      Test BLOB and VARCHAR sorting
    mysql-test/t/select.test:
      Change column name in test to get GROUP BY to use the alias
      Drop used tables at start of test
      Don't use table names 'a', 'b' or 'c'
    mysql-test/t/type_blob.test:
      Test BLOB and VARCHAR sorting
    sql/field.cc:
      Store length last in VARBINARY() and BLOB() columns to get shorter strings sorted before longer onces
    sql/field.h:
      Added method 'sort_length()' to allow one to have length bytes last for VARBINARY/BLOB to get these to sort properly
    sql/filesort.cc:
      Use 'sort_length()' instead of 'pack_length()' to get length o...
    55a21a33
sql_class.h 64.2 KB