# Problems with addNotNullConstraint in MySQL

**URL:** <https://forum.liquibase.org/t/problems-with-addnotnullconstraint-in-mysql/1116>\
**Category:** General Discussion\
**Created:** [February 10, 2011, 5:27pm UTC](https://forum.liquibase.org/t/problems-with-addnotnullconstraint-in-mysql/1116 "2011-02-10T17:27:00Z")\
**Posts on this page:** 6\
**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:** [February 10, 2011, 5:27pm UTC](https://forum.liquibase.org/t/problems-with-addnotnullconstraint-in-mysql/1116/1 "2011-02-10T17:27:00Z")

</div>

The problem seems to be in JIRA in order to the bug is fixed.

---

<div class="post-metadata">

**Author:** ![mrego\_lb](https://avatars.discourse-cdn.com/v4/letter/m/5e9695/32.png) [@mrego\_lb](https://forum.liquibase.org/u/mrego_lb)\
**Post date:** [February 10, 2011, 5:27pm UTC](https://forum.liquibase.org/t/problems-with-addnotnullconstraint-in-mysql/1116/2 "2011-02-10T17:27:00Z")

</div>

Great, thank you 😉

---

<div class="post-metadata">

**Author:** ![mrego\_lb](https://avatars.discourse-cdn.com/v4/letter/m/5e9695/32.png) [@mrego\_lb](https://forum.liquibase.org/u/mrego_lb)\
**Post date:** [February 10, 2011, 5:27pm UTC](https://forum.liquibase.org/t/problems-with-addnotnullconstraint-in-mysql/1116/3 "2011-02-10T17:27:00Z")

</div>

I’ve the following changeset:

  
[INFO] Error setting up or running Liquibase: Migration failed for change set src/main/resources/db.changelog-1.0.xml::add-new-column-changed\_default\_admin\_password::smontes:  
&nbsp; &nbsp; Reason: liquibase.exception.DatabaseException: Error executing SQL UPDATE `configuration` SET `changed_default_admin_password` = ‘FALSE’ WHERE changed\_default\_admin\_password IS NULL:  
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Caused By: Error executing SQL UPDATE `configuration` SET `changed_default_admin_password` = ‘FALSE’ WHERE changed\_default\_admin\_password IS NULL:  
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Caused By: Incorrect integer value: ‘FALSE’ for column ‘changed\_default\_admin\_password’ at row 1  
  
  
LiquiBase is creating the new column as tinyint(1) and then it doesn’t accept FALSE as value.  
  
This is only happens in MySQL while in PostgreSQL it’s working fine.  
  
Any idea about the possible problem?  
  
Thanks,  
&nbsp; Rego

---

<div class="post-metadata">

**Author:** ![mrego\_lb](https://avatars.discourse-cdn.com/v4/letter/m/5e9695/32.png) [@mrego\_lb](https://forum.liquibase.org/u/mrego_lb)\
**Post date:** [February 10, 2011, 5:27pm UTC](https://forum.liquibase.org/t/problems-with-addnotnullconstraint-in-mysql/1116/4 "2011-02-10T17:27:00Z")

</div>

The problem seems to be in JIRA in order to the bug is fixed.

---

<div class="post-metadata">

**Author:** ![mrego\_lb](https://avatars.discourse-cdn.com/v4/letter/m/5e9695/32.png) [@mrego\_lb](https://forum.liquibase.org/u/mrego_lb)\
**Post date:** [February 10, 2011, 5:27pm UTC](https://forum.liquibase.org/t/problems-with-addnotnullconstraint-in-mysql/1116/5 "2011-02-10T17:27:00Z")

</div>

Proposed patch to fix the problem in JIRA: [http://liquibase.jira.com/browse/CORE-858](http://liquibase.jira.com/browse/CORE-858)

---

<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:** [February 10, 2011, 5:27pm UTC](https://forum.liquibase.org/t/problems-with-addnotnullconstraint-in-mysql/1116/6 "2011-02-10T17:27:00Z")

</div>

Thanks for the patch, I’ll look at getting it applied.

Nathan