# Diff ChangeLog Mode does not detect column type differences

**URL:** <https://forum.liquibase.org/t/diff-changelog-mode-does-not-detect-column-type-differences/2398>\
**Category:** General Discussion\
**Created:** [August 30, 2013, 11:04pm UTC](https://forum.liquibase.org/t/diff-changelog-mode-does-not-detect-column-type-differences/2398 "2013-08-30T23:04:00Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![Guest](https://avatars.discourse-cdn.com/v4/letter/g/8dc957/32.png) [@Guest](https://forum.liquibase.org/u/Guest)\
**Post date:** [August 30, 2013, 11:04pm UTC](https://forum.liquibase.org/t/diff-changelog-mode-does-not-detect-column-type-differences/2398/1 "2013-08-30T23:04:00Z")

</div>

Hi Team,  
  
I found, that from version 3.0.0, “diffChangeLog” output xml does not include column type differences. But the normal “diff” detects and writes these differences normally in plain text format (not xml).  
  
I did some debugging and found that this functionality has been removed (commented out) in liquibase.diff.output.changelog.core.ChangedColumnChangeGenerator class.  
  
What is your plan with this issue?  
  
I’m currently using 2.0.5, and can’t upgrade without this.  
  
Thanks,  
Zoltan

---

<div class="post-metadata">

**Author:** ![nvoxland](https://avatars.discourse-cdn.com/v4/letter/n/87869e/32.png) [@nvoxland](https://forum.liquibase.org/u/nvoxland)\
**Post date:** [August 30, 2013, 11:04pm UTC](https://forum.liquibase.org/t/diff-changelog-mode-does-not-detect-column-type-differences/2398/2 "2013-08-30T23:04:00Z")

</div>

I created&nbsp;[https://liquibase.jira.com/browse/CORE-1433](https://liquibase.jira.com/browse/CORE-1433)&nbsp;to track the re-adding of it. It must have been lost in the code changes going from 2.x to 3.x. I’ll try to get it fixed soon.

Nathan

---

<div class="post-metadata">

**Author:** ![Guest](https://avatars.discourse-cdn.com/v4/letter/g/8dc957/32.png) [@Guest](https://forum.liquibase.org/u/Guest)\
**Post date:** [August 30, 2013, 11:04pm UTC](https://forum.liquibase.org/t/diff-changelog-mode-does-not-detect-column-type-differences/2398/3 "2013-08-30T23:04:00Z")

</div>

Hi,  
  
this still seems to be a issue in 3.0.5, even though it is marked “fixed”. As far as I can see, diff still does not create a plain textfile.

---

<div class="post-metadata">

**Author:** ![nvoxland](https://avatars.discourse-cdn.com/v4/letter/n/87869e/32.png) [@nvoxland](https://forum.liquibase.org/u/nvoxland)\
**Post date:** [August 30, 2013, 11:04pm UTC](https://forum.liquibase.org/t/diff-changelog-mode-does-not-detect-column-type-differences/2398/4 "2013-08-30T23:04:00Z")

</div>

I’m not quite sure what you mean. Can you give me more information on what you are calling with 3.0.5 and your expected vs. actual results?  
  
Nathan

---

<div class="post-metadata">

**Author:** ![Guest](https://avatars.discourse-cdn.com/v4/letter/g/8dc957/32.png) [@Guest](https://forum.liquibase.org/u/Guest)\
**Post date:** [August 30, 2013, 11:04pm UTC](https://forum.liquibase.org/t/diff-changelog-mode-does-not-detect-column-type-differences/2398/5 "2013-08-30T23:04:00Z")

</div>

Hi Nathan,  
Thank you for your efforts, now it works again!  
Zoltán

---

<div class="post-metadata">

**Author:** ![Guest](https://avatars.discourse-cdn.com/v4/letter/g/8dc957/32.png) [@Guest](https://forum.liquibase.org/u/Guest)\
**Post date:** [August 30, 2013, 11:04pm UTC](https://forum.liquibase.org/t/diff-changelog-mode-does-not-detect-column-type-differences/2398/6 "2013-08-30T23:04:00Z")

</div>

I’m calling the liquibase.integration.ant.DiffDatabaseTask.   
I expected an output as in 2.0.5 that has the following content:  
Reference Database:   
Target Database:   
Product Name:   
Product Version:   
Missing Tables:  
Unexpected Tables:   
Missing Views:   
Unexpected Views:   
Changed Views:   
…  
  
What I get is a a file with changesets. It is the exact same output as DiffDatabaseToChangeLogTask.

---

<div class="post-metadata">

**Author:** ![nvoxland](https://avatars.discourse-cdn.com/v4/letter/n/87869e/32.png) [@nvoxland](https://forum.liquibase.org/u/nvoxland)\
**Post date:** [August 30, 2013, 11:04pm UTC](https://forum.liquibase.org/t/diff-changelog-mode-does-not-detect-column-type-differences/2398/7 "2013-08-30T23:04:00Z")

</div>

Yes, that isn’t right. I fixed it in the code for 3.0.7. Sorry for the bug.

Nathan

---

<div class="post-metadata">

**Author:** ![Guest](https://avatars.discourse-cdn.com/v4/letter/g/8dc957/32.png) [@Guest](https://forum.liquibase.org/u/Guest)\
**Post date:** [August 30, 2013, 11:04pm UTC](https://forum.liquibase.org/t/diff-changelog-mode-does-not-detect-column-type-differences/2398/8 "2013-08-30T23:04:00Z")

</div>

Just tried 3.0.7 and it works perfectly. Thank you for fixing it!
