1. 15 Aug, 2007 3 commits
    • unknown's avatar
      Merge mhansson@bk-internal.mysql.com:/home/bk/mysql-5.1-opt · fae4347f
      unknown authored
      into  dl145s.mysql.com:/data0/mhansson/my51-bug28570
      
      
      sql/handler.cc:
        Auto merged
      fae4347f
    • unknown's avatar
      Merge linux-st28.site:/home/martin/mysql/src/bug28570/my50-bug28570 · eea647b5
      unknown authored
      into  linux-st28.site:/home/martin/mysql/src/bug28570/my51-bug28570
      
      
      sql/opt_range.cc:
        Auto merged
      mysql-test/include/mix1.inc:
        Bug#28570: Hand merged test case
      mysql-test/r/innodb_mysql.result:
        Bug#28570: Hand merged test result
      sql/handler.cc:
        Bug#28570: Hand merged file
      eea647b5
    • unknown's avatar
      bug#28570: handler::index_read() is called with different find_flag when · 01f8130a
      unknown authored
      ORDER BY is used
      
      The range analysis module did not correctly signal to the 
      handler that a range represents a ref (EQ_RANGE flag). This causes 
      non-range queries like 
      SELECT ... FROM ... WHERE keypart_1=const, ..., keypart_n=const 
      ORDER BY ... FOR UPDATE
      to wait for a lock unneccesarily if another running transaction uses
      SELECT ... FOR UPDATE on the same table.
      
      Fixed by setting EQ_RANGE for all range accesses that represent 
      an equality predicate. 
      
      
      mysql-test/r/innodb_mysql.result:
        bug#28570: Test Result
      mysql-test/t/innodb_mysql.test:
        bug#28570: Test Case
      sql/handler.cc:
        bug#28570: Updated comment
      sql/opt_range.cc:
        bug#28570: Removed the criterion that key has to be unique (HA_NOSAME) in 
        order for the EQ_RANGE flag to be set. It is sufficient that the range 
        represent a ref access.
      01f8130a
  2. 14 Aug, 2007 3 commits
  3. 13 Aug, 2007 5 commits
  4. 10 Aug, 2007 4 commits
  5. 08 Aug, 2007 5 commits
  6. 06 Aug, 2007 19 commits
  7. 05 Aug, 2007 1 commit