• evgen@moonbone.local's avatar
    Bug#28494: Grouping by Item_func_set_user_var produces incorrect result. · 49346467
    evgen@moonbone.local authored
    This is an additional fix.
    Item::val_xxx methods are supposed to use original data source and
    Item::val_xxx_result methods to use the item's result field. But for the
    Item_func_set_user_var class val_xxx_result methods were mapped to val_xxx
    methods. This leads, in particular, to producing bad sort keys and thus
    wrong order of the result set of queries with group by/order by clauses.
    
    The set of val_xxx_result methods is added to the Item_func_set_user_var
    class. It's the same as the val_xxx set of method but uses the result_field
    to return a value.
    49346467
user_var.test 6.61 KB