1. 22 Jan, 2007 1 commit
    • gkodinov/kgeorge@macbook.gmz's avatar
      BUG#16590: Optimized does not do right "const" table pre-read · 9ea140d1
      gkodinov/kgeorge@macbook.gmz authored
       st_table::const_key_parts member is used in determining if
       certain key has a prefix that is compared to constant(s) in
       the query predicates.
       If there's such prefix the index can be used to get the data
       from the remaining suffix columns in sorted order.
       However if a field is compared to another field from a "const"
       table the const_key_parts is not amended.
       This makes the optimizer unable to detect that the key can be 
       used for sorting and adds an extra filesort.
       Fixed by updating const_key_parts after reading in the "const"
       table.
      9ea140d1
  2. 10 Jan, 2007 3 commits
  3. 09 Jan, 2007 2 commits
  4. 08 Jan, 2007 2 commits
  5. 06 Jan, 2007 2 commits
  6. 05 Jan, 2007 1 commit
    • gkodinov/kgeorge@macbook.gmz's avatar
      Bug #15881: cast problems · a63df24a
      gkodinov/kgeorge@macbook.gmz authored
        The optimizer removes expressions from GROUP BY/DISTINCT
        if they happen to participate in a <expression> = <const>
        predicates of the WHERE clause (the idea being that if
        it's always equal to a constant it can't have multiple 
        values).
        However for predicates where the expression and the 
        constant item are of different result type this is not
        valid (e.g. a string column compared to 0).
        Fixed by additional check of the result types of the 
        expression and the constant and if they differ the 
        expression don't get removed from the group by list.
      a63df24a
  7. 04 Jan, 2007 4 commits
  8. 03 Jan, 2007 3 commits
  9. 02 Jan, 2007 19 commits
  10. 31 Dec, 2006 3 commits