• malff/marcsql@weblab.(none)'s avatar
    Bug#24562 (ALTER TABLE ... ORDER BY ... with complex expression asserts) · 436e1f59
    malff/marcsql@weblab.(none) authored
    WL#3681 (ALTER TABLE ORDER BY)
    
    Before this fix, the ALTER TABLE statement implemented an ORDER BY option
    with the following characteristics :
    
    1) The order by clause accepts a list of criteria, with optional ASC or
    DESC keywords
    
    2) Each criteria can be a general expression, involving operators,
    native functions, stored functions, user defined functions, subselects ...
    
    With this fix :
    
    1) has been left unchanged, since it's a de-facto existing feature,
    that was already present in the code base and partially covered in the test
    suite. Code coverage for ASC and DESC was missing and has been improved.
    
    2) has been changed to limit the kind of criteria that are permissible:
    now only a column name is valid.
    436e1f59
alter_table.test 14.7 KB