update column with empty string sets a <null> value (trunk)

General Discussion
1

Hi,

We use empty strings in our database and whle searching the forum I found some threads that discussed this topic. So now, we use the current trunk version and the insert statements (and defaultValues) are [correctly] set to empty strings instead of .

But when I use the update tag, still is used and not the empty string.

Example:

    ?xml version="1.0" encoding="UTF-8"?>

    <databaseChangeLog xmlns=“http://www.liquibase.org/xml/ns/dbchangelog” xmlns:xsi=“http://www.w3.org/2001/XMLSchema-instance” xsi:schemaLocation=“http://www.liquibase.org/xml/ns/dbchangelog http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-2.0.xsd”>

     

       
         
       

       
         
       
     

is converted to

    UPDATE mytable SET label = NULL;

    INSERT INTO mytable (label) VALUES (’’);

I’d say those two tags should behave the same, shouldn’t they? Is there any “workaround” or other path that lets me update a column with an empty string?

Thanks in advance

Regards,
Eike

2

Yes, they should work the same.  I fixed update to allow the insertion of empty strings and will just insert null for the string “null”. 

If you do not want to build a new version yourself or wait for the next release, you can use the tag for now.

Nathan

3

Hi Nathan,

thank you very much for the fast reply and fix!

Eike