Skip to content
  • Steinar H. Gunderson's avatar
    c863b094
    Bug #31397840: Wrong result of SELECT DISTINCT JSON_ARRAYAGG · c863b094
    Steinar H. Gunderson authored
    When doing a filesort for removing duplicates (SELECT DISTINCT),
    we may need to run another sort afterwards to satisfy ORDER BY.
    However, in the instance where we had pushed said ORDER BY down
    into the first table, as opposed to the JOIN as a whole, we would
    not have a Filesort object for it (it would say nullptr), and forget
    to do the final sort.
    
    Change-Id: I5e7e6aa1ffce994efaa98188867cd820c44a4796
    c863b094
    Bug #31397840: Wrong result of SELECT DISTINCT JSON_ARRAYAGG
    Steinar H. Gunderson authored
    When doing a filesort for removing duplicates (SELECT DISTINCT),
    we may need to run another sort afterwards to satisfy ORDER BY.
    However, in the instance where we had pushed said ORDER BY down
    into the first table, as opposed to the JOIN as a whole, we would
    not have a Filesort object for it (it would say nullptr), and forget
    to do the final sort.
    
    Change-Id: I5e7e6aa1ffce994efaa98188867cd820c44a4796
Loading