# changeSet runOnChange="true" not detected in RC7

**URL:** https://forum.liquibase.org/t/changeset-runonchange-true-not-detected-in-rc7/913
**Category:** General Discussion
**Created:** [November 10, 2010, 4:35am UTC](https://forum.liquibase.org/t/changeset-runonchange-true-not-detected-in-rc7/913 "2010-11-10T04:35:00Z")
**Posts on this page:** 8
**Page:** 1

<div class="post-metadata">

### Author: ![hyperlink\_lb](https://avatars.discourse-cdn.com/v4/letter/h/839c29/32.png) [@hyperlink\_lb](https://forum.liquibase.org/u/hyperlink_lb)
#### Post date: [November 10, 2010, 4:35am UTC](https://forum.liquibase.org/t/changeset-runonchange-true-not-detected-in-rc7/913/1 "2010-11-10T04:35:00Z")

</div>

Hi,

&nbsp; I tested this in RC7 and RC6 and it’s an RC7 issue and works as it should in RC6.&nbsp; I have a changeset with runOnChange=“true” and I have changed the stored procedures between revisions and RC7 does not update the stored procedure and does not error out.

&nbsp; The file that is being loaded in version A has one change set with the original changes.&nbsp; Version B changes the stored procedure and adds another changeset with a different id.&nbsp; On both versions, the new changeset gets committed with RC6 only updating the original changeset via runOnChange=“true”.&nbsp; If I am not clear in explaining this, please let me know.&nbsp; Thanks and I look forward to your reply!

---

<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: [November 10, 2010, 4:35am UTC](https://forum.liquibase.org/t/changeset-runonchange-true-not-detected-in-rc7/913/2 "2010-11-10T04:35:00Z")

</div>

If you make a new change to the changeSet and then re-update does runOnChange work correctly?

I made a change to how checksums are computed between RC6 and RC7, which unfortunately means that liquibase cannot tell if something changed or not.&nbsp; I went back and forth on whether we should run runOnChange changesets in that case or not, and decided that not running them would be the safest option.&nbsp;

The goal is to never change the checksum version, but it does have to be done to solve bugs from time to time, especially before 2.0 final.&nbsp;

Nathan

---

<div class="post-metadata">

### Author: ![hyperlink\_lb](https://avatars.discourse-cdn.com/v4/letter/h/839c29/32.png) [@hyperlink\_lb](https://forum.liquibase.org/u/hyperlink_lb)
#### Post date: [November 10, 2010, 4:35am UTC](https://forum.liquibase.org/t/changeset-runonchange-true-not-detected-in-rc7/913/3 "2010-11-10T04:35:00Z")

</div>

So to if I wanted to use 2.0 for production use I should re-sync a database using RC7 correct?

---

<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: [November 10, 2010, 4:35am UTC](https://forum.liquibase.org/t/changeset-runonchange-true-not-detected-in-rc7/913/4 "2010-11-10T04:35:00Z")

</div>

Yes, you will need at least one database update or sync with RC7 so it updates the checksums.&nbsp; Other changesets will run with an update, just not run-on-change changeSets.

Nathan

---

<div class="post-metadata">

### Author: ![hyperlink\_lb](https://avatars.discourse-cdn.com/v4/letter/h/839c29/32.png) [@hyperlink\_lb](https://forum.liquibase.org/u/hyperlink_lb)
#### Post date: [November 10, 2010, 4:35am UTC](https://forum.liquibase.org/t/changeset-runonchange-true-not-detected-in-rc7/913/5 "2010-11-10T04:35:00Z")

</div>

Nathan,

&nbsp; Ok I’ve re-tested this as well.&nbsp; I’ve synced a new database with RC7 and then apply a new changeset to it.&nbsp; All of the changes apply except for 2 stored procedures that have runOnChange=“true”.&nbsp; I don’t get a warning in the console when running it from ant, but my unit tests fail for the stored procedures and I check the database and the stored procedure has not been changed.&nbsp; As always, I look forward to your reply.

---

<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: [November 10, 2010, 4:35am UTC](https://forum.liquibase.org/t/changeset-runonchange-true-not-detected-in-rc7/913/6 "2010-11-10T04:35:00Z")

</div>

Is the stored proc in a separate file? Or inline in the changelog?&nbsp;

Could you post the debug output from the updated jar I pointed you to in the other thread?

Nathan

---

<div class="post-metadata">

### Author: ![hyperlink\_lb](https://avatars.discourse-cdn.com/v4/letter/h/839c29/32.png) [@hyperlink\_lb](https://forum.liquibase.org/u/hyperlink_lb)
#### Post date: [November 10, 2010, 4:35am UTC](https://forum.liquibase.org/t/changeset-runonchange-true-not-detected-in-rc7/913/7 "2010-11-10T04:35:00Z")

</div>

Nathan,

&nbsp; Did you change something in the RC8?&nbsp; I’ve synced a new database and then applied some new changes and it works fine.&nbsp; Each stored proc is in it’s own file with it’s own changelog and if there is duplicate names (method overloading), it’s placed in the same file under a new changelog so they can each be updated independently.&nbsp; This works in RC8.&nbsp; Thank you so much.

---

<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: [November 10, 2010, 4:35am UTC](https://forum.liquibase.org/t/changeset-runonchange-true-not-detected-in-rc7/913/8 "2010-11-10T04:35:00Z")

</div>

I have made changes in RC8, glad something in there fixed it for you.

Let me know if you have other issue

Nathan
