1. 17 Nov, 2007 3 commits
  2. 16 Nov, 2007 4 commits
  3. 15 Nov, 2007 1 commit
  4. 14 Nov, 2007 4 commits
  5. 13 Nov, 2007 6 commits
  6. 12 Nov, 2007 10 commits
  7. 10 Nov, 2007 10 commits
  8. 09 Nov, 2007 2 commits
    • kaa@polly.(none)'s avatar
      Fix for bug #32202: ORDER BY not working with GROUP BY · 8c193678
      kaa@polly.(none) authored
      The bug is a regression introduced by the fix for bug30596. The problem
      was that in cases when groups in GROUP BY correspond to only one row,
      and there is ORDER BY, the GROUP BY was removed and the ORDER BY
      rewritten to ORDER BY <group_by_columns> without checking if the
      columns in GROUP BY and ORDER BY are compatible. This led to
      incorrect ordering of the result set as it was sorted using the
      GROUP BY columns. Additionaly, the code discarded ASC/DESC modifiers
      from ORDER BY even if its columns were compatible with the GROUP BY
      ones.
      
      This patch fixes the regression by checking if ORDER BY columns form a
      prefix of the GROUP BY ones, and rewriting ORDER BY only in that case,
      preserving the ASC/DESC modifiers. That check is sufficient, since the
      GROUP BY columns contain a unique index.
      8c193678
    • kaa@polly.(none)'s avatar
      Merge polly.(none):/home/kaa/src/opt/bug32020/my50-bug31445 · 6320cded
      kaa@polly.(none) authored
      into  polly.(none):/home/kaa/src/opt/mysql-5.0-opt
      6320cded