# Liquibase 3.0.6: change to the handling of Boolean?

**URL:** <https://forum.liquibase.org/t/liquibase-3-0-6-change-to-the-handling-of-boolean/2722>\
**Category:** General Discussion\
**Created:** [October 19, 2013, 6:23am UTC](https://forum.liquibase.org/t/liquibase-3-0-6-change-to-the-handling-of-boolean/2722 "2013-10-19T06:23:00Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![DenisAntonioli](https://avatars.discourse-cdn.com/v4/letter/d/bcef8e/32.png) [@DenisAntonioli](https://forum.liquibase.org/u/DenisAntonioli)\
**Post date:** [October 19, 2013, 6:23am UTC](https://forum.liquibase.org/t/liquibase-3-0-6-change-to-the-handling-of-boolean/2722/1 "2013-10-19T06:23:00Z")

</div>

Hi

I’ve a few change sets that are simple sql inserts/updates to handle my reference data, for example:

INSERT INTO Variable (id, version, core, created\_on, description, name)

&nbsp; VALUES

&nbsp; (‘ce02bb08-ae7d-4f9c-a94b-bc2a7fcd982c’, 0, 1, ‘2013-08-29 14:55:09’, ‘desc 1’, ‘name 1’),

&nbsp; (‘53c50b45-8b3b-4061-9594-b1fe3826080f’, 0, 1, ‘2013-08-29 14:55:09’, ‘desc 2’, ‘name 2’);

where the column 'core has been defined as:

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;

Eg, my sample data set use 0 and 1 for boolean values.

This works w/out problem with liquibase 3.0.5 against Derby 10.10 and mySql 5.5.

This fails with liquibase 3.0.6 against Derby:

Error executing SQL INSERT INTO Variable …: Columns of type ‘BOOLEAN’ cannot hold values of type ‘INTEGER’.&nbsp;

at liquibase.Liquibase.update(Liquibase.java:137)

---

<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:** [October 19, 2013, 6:23am UTC](https://forum.liquibase.org/t/liquibase-3-0-6-change-to-the-handling-of-boolean/2722/2 "2013-10-19T06:23:00Z")

</div>

There was a change to better support the actual BOOLEAN type in derby. It should be able to convert 1 to “true” in that case still, though. I created&nbsp;[https://liquibase.jira.com/browse/CORE-1561](https://liquibase.jira.com/browse/CORE-1561)&nbsp;to track the issue.

Nathan

---

<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:** [October 19, 2013, 6:23am UTC](https://forum.liquibase.org/t/liquibase-3-0-6-change-to-the-handling-of-boolean/2722/3 "2013-10-19T06:23:00Z")

</div>

Since you are using liquibase cannot parse or know that 1 and 0 are going into a boolean column to do any sort of conversion.&nbsp;

You could use changelog parameters like:

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:** [October 19, 2013, 6:23am UTC](https://forum.liquibase.org/t/liquibase-3-0-6-change-to-the-handling-of-boolean/2722/4 "2013-10-19T06:23:00Z")

</div>

That’s an interesting technique, I’ll try that.

We use liquibase to manage some reference and test data and we found it easier, so far, to dump and massage sql…

How effective is the use of the liquibase diff tool for data dumps?