Fails to detect difference in a database value

[GoogleCodeExporter]

I tried to track changes in my Joomla database, and noticed phpmydiff didn't 
notice a change of tinyint in one table.

Stripping the contents to a single table and leaving only the changed row 
didn't affect the results - the change still wasn't noticed.

When I stripped the db structure to just the changing tinyint, the change was 
noticed correctly.

I'll attach the related sql files:

** DIFFERENCE NOT NOTICED BY phpmydiff: **
s1.sql - source with full table structure, single row
d1.sql - same as s1, with value of "enabled"-field changed

** SIMILAR DIFFERENCE NOTICED CORRECTLY BY phpmydiff: **
s2.sql - source with only single field
d2.sql - same as s2, with value of "enabled"-field changed

Steps to reproduce:
1. Dump s1.sql to first database
2. Dump d1.sql to second database
3. Run phpmydiff comparing the databases

phpmydiff should notify me that the database value for field "enabled" is 
different. Instead it doesn't notice any changes.

Using PhpMyDiff v0.0.3

Original issue reported on code.google.com by ilari.kajaste on 28 Oct 2011 at 5:24

Attachments:

• s1.sql
• d1.sql
• s2.sql
• d2.sql