• gkodinov/kgeorge@macbook.gmz's avatar
    Bug #26672: · d2c977a9
    gkodinov/kgeorge@macbook.gmz authored
     DATE/DATETIME values are out of the currently supported
     4 basic value types (INT,STRING,REAL and DECIMAL).
     So expressions (not fields) of compile type DATE/DATETIME are 
     generally considered as STRING values. This is not so
     when they are compared : then they are compared as 
     INTEGER values.
     But the rule for comparison as INTEGERS must be checked
     explicitly each time when a comparison is to be performed.
     filesort is one such place. However there the check was 
     not done and hence the expressions (not fields) of type 
     DATE/DATETIME were sorted by their string representation.
     Fixed to compare them as INTEGER values for filesort.
    d2c977a9
order_by.test 23.3 KB