• unknown's avatar
    Fix bug #13855 select distinct with group by caused server crash · 0390de86
    unknown authored
    DISTINCT wasn't optimized away and caused creation of tmp table in wrong
    case. This result in integer overrun and running out of memory.
    
    Fix backported from 4.1. Now if optimizer founds that in result be only 1
    row it removes distinct.
    
    
    sql/sql_select.cc:
      Fix bug #13855 select distinct with group by caused server crash
    mysql-test/r/select.result:
      Test case for bug#13855 select distinct with group by caused server crash
    mysql-test/t/select.test:
       Test case for bug#13855 select distinct with group by caused server crash
    0390de86
sql_select.cc 218 KB