• Sergey Vojtovich's avatar
    BUG#46961 - archive engine loses rows during self joining select! · 8a9a633e
    Sergey Vojtovich authored
    SELECT with join (not only self-join) from archive table may
    return incomplete result set, when result set size exceeds
    join buffer size.
    
    The problem was that archive row counter was initialzed too
    early, when ha_archive::info() method was called. Later,
    when optimizer exceeds join buffer, it attempts to reuse
    handler without calling ha_archive::info() again (which is
    correct).
    
    Fixed by moving row counter initialization from
    ha_archive::info() to ha_archive::rnd_init().
    8a9a633e
ha_archive.cc 44.2 KB