• vasil's avatar
    branches/zip: Merge revisions 4481:4710 from branches/5.1: · 8695dd88
    vasil authored
    (resolving conflict in r4574, r4575 and skipping r4699 and r4705 because
    analogous changes to r4699 and r4705 were already made to branches/zip)
    
      ------------------------------------------------------------------------
      r4573 | vasil | 2009-03-30 14:17:13 +0300 (Mon, 30 Mar 2009) | 4 lines
      Changed paths:
         M /branches/5.1/mysql-test/innodb.test
      
      branches/5.1:
      
      Fix email address from dev@innodb.com to innodb_dev_ww@oracle.com
      
      ------------------------------------------------------------------------
      r4574 | vasil | 2009-03-30 14:27:08 +0300 (Mon, 30 Mar 2009) | 38 lines
      Changed paths:
         M /branches/5.1/Makefile.am
         M /branches/5.1/mysql-test/innodb.test
      
      branches/5.1:
      
      Restore the state of INNODB_THREAD_CONCURRENCY to silence this warning:
      
        TEST                                      RESULT   TIME (ms)
        ------------------------------------------------------------
        
        worker[1] Using MTR_BUILD_THREAD 250, with reserved ports 12500..12509
        main.innodb                              [ pass ]   8803
        
        MTR's internal check of the test case 'main.innodb' failed.
        This means that the test case does not preserve the state that existed
        before the test case was executed.  Most likely the test case did not
        do a proper clean-up.
        This is the diff of the states of the servers before and after the
        test case was executed:
        mysqltest: Logging to '/tmp/autotest.sh-20090330_033000-5.1.5Hg8CY/mysql-5.1/mysql-test/var/tmp/check-mysqld_1.log'.
        mysqltest: Results saved in '/tmp/autotest.sh-20090330_033000-5.1.5Hg8CY/mysql-5.1/mysql-test/var/tmp/check-mysqld_1.result'.
        mysqltest: Connecting to server localhost:12500 (socket /tmp/autotest.sh-20090330_033000-5.1.5Hg8CY/mysql-5.1/mysql-test/var/tmp/mysqld.1.sock) as 'root', connection 'default', attempt 0 ...
        mysqltest: ... Connected.
        mysqltest: Start processing test commands from './include/check-testcase.test' ...
        mysqltest: ... Done processing test commands.
        --- /tmp/autotest.sh-20090330_033000-5.1.5Hg8CY/mysql-5.1/mysql-test/var/tmp/check-mysqld_1.result	2009-03-30 14:12:31.000000000 +0300
        +++ /tmp/autotest.sh-20090330_033000-5.1.5Hg8CY/mysql-5.1/mysql-test/var/tmp/check-mysqld_1.reject	2009-03-30 14:12:41.000000000 +0300
        @@ -99,7 +99,7 @@
         INNODB_SUPPORT_XA	ON
         INNODB_SYNC_SPIN_LOOPS	20
         INNODB_TABLE_LOCKS	ON
        -INNODB_THREAD_CONCURRENCY	8
        +INNODB_THREAD_CONCURRENCY	16
         INNODB_THREAD_SLEEP_DELAY	10000
         INSERT_ID	0
         INTERACTIVE_TIMEOUT	28800
        
        mysqltest: Result content mismatch
        
        not ok
      
      ------------------------------------------------------------------------
      r4575 | vasil | 2009-03-30 15:55:31 +0300 (Mon, 30 Mar 2009) | 8 lines
      Changed paths:
         M /branches/5.1/mysql-test/innodb.result
         M /branches/5.1/mysql-test/innodb.test
      
      branches/5.1:
      
      Fix Bug#43309 Test main.innodb can't be run twice
      
      Make the innodb mysql-test more flexible by inspecting how much a
      variable of interest has changed since the start of the test. Do not
      assume the variables have zero values at the start of the test.
      
      ------------------------------------------------------------------------
      r4576 | vasil | 2009-03-30 16:25:10 +0300 (Mon, 30 Mar 2009) | 4 lines
      Changed paths:
         M /branches/5.1/Makefile.am
      
      branches/5.1:
      
      Revert a change to Makefile.am that I committed accidentally in c4574.
      
      ------------------------------------------------------------------------
      r4659 | vasil | 2009-04-06 15:34:51 +0300 (Mon, 06 Apr 2009) | 6 lines
      Changed paths:
         M /branches/5.1/mysql-test/innodb.test
      
      branches/5.1:
      
      Followup to r4575 and the fix of Bug#43309 Test main.innodb can't be run twice:
      
      Add an explanatory comment, as suggested by Patrick Crews in the bug report.
      
      ------------------------------------------------------------------------
      r4699 | vasil | 2009-04-09 14:01:52 +0300 (Thu, 09 Apr 2009) | 15 lines
      Changed paths:
         M /branches/5.1/handler/ha_innodb.cc
         M /branches/5.1/include/srv0srv.h
         M /branches/5.1/page/page0cur.c
         M /branches/5.1/srv/srv0srv.c
      
      branches/5.1:
      
      Fix Bug#43660 SHOW INDEXES/ANALYZE does NOT update cardinality for indexes
      of InnoDB table
      
      by replacing the PRNG that is used to pick random pages with a better
      one.
      
      This is based on r4670 but also adds a new configuration option and
      enables the fix only if this option is changed. Please skip the present
      revision when merging.
      
      Approved by:	Heikki (via email)
      
      
      ------------------------------------------------------------------------
      r4705 | vasil | 2009-04-14 14:30:13 +0300 (Tue, 14 Apr 2009) | 5 lines
      Changed paths:
         M /branches/5.1/page/page0cur.c
      
      branches/5.1:
      
      When using the random function, first take the modulus by the number of pages
      and then typecast to ulint.
      
      ------------------------------------------------------------------------
      r4710 | vasil | 2009-04-15 11:55:18 +0300 (Wed, 15 Apr 2009) | 25 lines
      Changed paths:
         M /branches/5.1/handler/ha_innodb.cc
      
      branches/5.1:
      
      Merge a change from MySQL (looks like this is against 5.0 but they later
      merged it to 5.1):
      
        ------------------------------------------------------------
        revno: 1810.3846.1
        committer: Alexey Botchkov <holyfoot@mysql.com>
        branch nick: 31435
        timestamp: Tue 2008-11-11 14:42:32 +0400
        message:
          Bug#31435 ha_innodb.cc:3983: ulint convert_search_mode_to_innobase(ha_rkey_function): Asse 
              I think we don't need to issue an error statement in the convert_search_mode_to_innobase().
              Returning the PAGE_CUR_UNSUPP value is enough as allows to handle this
              case depending on the requirements.
          
          per-file comments:
            sql/ha_innodb.cc 
          Bug#31435 ha_innodb.cc:3983: ulint convert_search_mode_to_innobase(ha_rkey_function): Asse 
               no error issued in convert_search_mode_to_innobase.
               ha_innobase::records_in_range() returns HA_POS_ERROR if search mode isn't supported.
        modified:
          sql/ha_innodb.cc
      
      
      ------------------------------------------------------------------------
    8695dd88
innodb.test 76.4 KB