1. 12 Jan, 2007 1 commit
    • holyfoot/hf@mysql.com/deer.(none)'s avatar
      bug #24186 (nested query across partitions returns fewer records) · 3fd278c9
      holyfoot/hf@mysql.com/deer.(none) authored
      Subselect's engine checks table->status field to determine if the
      record was properly found when we use keyread upon the table.
      Partition engine checks all the partitions for given key
      before return. So if matching record was found in the first
      partition and no matching records were found in the second, 
      we have table->status == NOT_FOUND after the function, what
      makes subselects to skip matching records.
      The patch adds table->status= 0 if we actually found something.
      3fd278c9
  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