**Reported in Launchpad by Sami Ahlroos last update 18-07-2013 15:37:50

When testing upgrade from 5.0.87 to 5.5 we encountered something interesting using pt-upgrade 2.2.1.

Table:
CREATE TABLE `test1` (
`fuu` varchar(10) default NULL,
`id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8

As soon as 'fuu' contains NULL, pt-upgrade 2.2.1 reports tables being different. Any non-NULL value in `fuu`, or using version 2.1 results in "no differences".

PTDEBUG=1 output attached.

$ pt-upgrade h=utest-1.backup.fra1,D=crc h=utest-2.backup.fra1,D=crc test1.txt

#----------------------------------------------------------------------- # Logs
#-----------------------------------------------------------------------
File: test1.txt
Size: 193

#----------------------------------------------------------------------- # Hosts
#-----------------------------------------------------------------------
host1:

DSN: h=utest-1.backup.fra1
hostname: utest-1
MySQL: (Debian) 5.0.87

host2:

DSN: h=utest-2.backup.fra1
hostname: utest-2
MySQL: Percona Server (GPL), Release 30.2 5.5.30

########################################################################

1. Query class 5E449981E650B75A
   ########################################################################

Reporting class because it has diffs, but hasn't been reported yet.

Total queries 1
Unique queries 1
Discarded queries 0

select `test?`.* from `test?` where `test?`.`id` = ? limit ?

##

1.  

   1. Row diffs: 1
      ##

– 1.

@ row 1
< NULL,852800
> NULL,852800

SELECT `test1`.* FROM `test1` WHERE `test1`.`id` = 852800 LIMIT 1

#----------------------------------------------------------------------- # Stats
#-----------------------------------------------------------------------
failed_queries 0
not_select 0
queries_filtered 0
queries_no_diffs 0
queries_read 1
queries_with_diffs 1
queries_with_errors 0