Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Fails to detect difference in a database value #7

Open
GoogleCodeExporter opened this issue Jan 26, 2016 · 1 comment
Open

Fails to detect difference in a database value #7

GoogleCodeExporter opened this issue Jan 26, 2016 · 1 comment

Comments

@GoogleCodeExporter
Copy link

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:

@GoogleCodeExporter
Copy link
Author

i have the same problem, but with an ENUM field.

ENUM('Ja', 'Nein')

phpMyDiff doesn't detect changes in this field.

are there any solutions/sugestions/fixes (since last comment is 9 months 
old...)?

i could have a look at the code, but maybe need a hint, which files are the 
culprits...

Original comment by katrin.grunewald on 13 Jul 2012 at 1:37

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

1 participant