• Marko Mäkelä's avatar
    Merge from mysql-5.1-innodb: · 8079d0d6
    Marko Mäkelä authored
      ------------------------------------------------------------
      revno: 3459
      revision-id: marko.makela@oracle.com-20100511105308-grp2t3prh3tqivw0
      parent: marko.makela@oracle.com-20100511105012-b2t7wvz6mu6bll74
      parent: marko.makela@oracle.com-20100505123901-xjxu93h1xnbkfkq0
      committer: Marko Mäkelä <marko.makela@oracle.com>
      branch nick: mysql-5.1-innodb
      timestamp: Tue 2010-05-11 13:53:08 +0300
      message:
        Merge a patch from Facebook to fix Bug #53290
    
        commit e759bc64eb5c5eed4f75677ad67246797d486460
        Author: Ryan Mack
        Date:   3 days ago
    
            Bugfix for 53290, fast unique index creation fails on duplicate null values
    
            Summary:
            Bug in the fast index creation code incorrectly considers null
            values to be duplicates during block merging.  Innodb policy is that
            multiple null values are allowed in a unique index.  Null duplicates
            were correctly ignored while sorting individual blocks and with slow
            index creation.
    
            Test Plan:
            mtr, including new test, load dbs using deferred index creation
    
            License:
            Copyright (C) 2009-2010 Facebook, Inc.  All Rights Reserved.
    
            Dual licensed under BSD license and GPLv2.
    
            Redistribution and use in source and binary forms, with or without
            modification, are permitted provided that the following conditions are met:
            1. Redistributions of source code must retain the above copyright notice,
               this list of conditions and the following disclaimer.
            2. Redistributions in binary form must reproduce the above copyright notice,
               this list of conditions and the following disclaimer in the documentation
               and/or other materials provided with the distribution.
    
            THIS SOFTWARE IS PROVIDED BY FACEBOOK, INC. ``AS IS'' AND ANY EXPRESS OR
            IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF
            MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE DISCLAIMED.  IN NO
            EVENT SHALL FACEBOOK, INC. BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL,
            SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO,
            PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS;
            OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY,
            WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR
            OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF
            ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
    
            This program is free software; you can redistribute it and/or modify it
            under the terms of the GNU General Public License as published by the Free
            Software Foundation; version 2 of the License.
    
            This program is distributed in the hope that it will be useful, but WITHOUT
            ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or
            FITNESS FOR A PARTICULAR PURPOSE.  See the GNU General Public License for
            more details.
    
            You should have received a copy of the GNU General Public License along with
            this program; if not, write to the Free Software Foundation, Inc., 59 Temple
            Place, Suite 330, Boston, MA  02111-1307  USA
          ------------------------------------------------------------
          revno: 3453.2.1
          revision-id: marko.makela@oracle.com-20100505123901-xjxu93h1xnbkfkq0
          parent: marko.makela@oracle.com-20100505120555-ukoq1gklpheslrxs
          committer: Marko Mäkelä <marko.makela@oracle.com>
          branch nick: 5.1-innodb
          timestamp: Wed 2010-05-05 15:39:01 +0300
          message:
            Merge a contribution from Ryan Mack at Facebook:
    
            Bugfix for 53290, fast unique index creation fails on duplicate null values
    
                Summary:
                Bug in the fast index creation code incorrectly considers null
                values to be duplicates during block merging.  Innodb policy is that
                multiple null values are allowed in a unique index.  Null duplicates
                were correctly ignored while sorting individual blocks and with slow
                index creation.
    
                Test Plan:
                mtr, including new test, load dbs using deferred index creation
    
                DiffCamp Revision: 110840
                Reviewed By: mcallaghan
                CC: mcallaghan, mysql-devel@lists
                Revert Plan:
                OK
    8079d0d6
innodb_bug53290.test 809 Bytes