• unknown's avatar
    Fix bug #13855 select distinct with group by caused server crash · df9653ef
    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
    df9653ef
select.result 59.7 KB