# SetNullableGenerator using columnDataType in "raw" form?

**URL:** <https://forum.liquibase.org/t/setnullablegenerator-using-columndatatype-in-raw-form/1430>\
**Category:** Liquibase Development\
**Created:** [August 29, 2010, 12:55pm UTC](https://forum.liquibase.org/t/setnullablegenerator-using-columndatatype-in-raw-form/1430 "2010-08-29T12:55:00Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![nseessle](https://avatars.discourse-cdn.com/v4/letter/n/7bcc69/32.png) [@nseessle](https://forum.liquibase.org/u/nseessle)\
**Post date:** [August 29, 2010, 12:55pm UTC](https://forum.liquibase.org/t/setnullablegenerator-using-columndatatype-in-raw-form/1430/1 "2010-08-29T12:55:00Z")

</div>

Hi,

SetNullableGenerator is appending the contents of the columnDataType of an addNotNullConstraint in “raw” form to the sql-statement.

I don’t understand if this is “expected”, or if it’s just missing the calls to the TypeConverter.

Given a createTable with  
  
followed by a

this leads to the following sql running against an mssql-server:

CREATE TABLE […] [SYS\_AUD\_TX\_When] DATETIME, […]  
ALTER TABLE [dbo].[SYS\_AUD\_TX] ALTER COLUMN [SYS\_AUD\_TX\_When] TIMESTAMP NOT NULL

which in turn leads to

&nbsp; &nbsp; Reason: liquibase.exception.DatabaseException: Error executing SQL ALTER TABLE [dbo].[SYS\_AUD\_TX] ALTER COLUMN [SYS\_AUD\_TX\_When] TIMESTAMP NOT NULL:  
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Caused By: Error executing SQL ALTER TABLE [dbo].[SYS\_AUD\_TX] ALTER COLUMN [SYS\_AUD\_TX\_When] TIMESTAMP NOT NULL:  
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Caused By: The SYS\_AUD\_TX\_When-Column can not be changed to the timestamp-Datatype.  
(last message translated by me from german)

---

<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 29, 2010, 12:55pm UTC](https://forum.liquibase.org/t/setnullablegenerator-using-columndatatype-in-raw-form/1430/2 "2010-08-29T12:55:00Z")

</div>

(sorry for the slow response, was on vacation and this post had gotten buried in my list)

It should be doing the type conversion.&nbsp; I committed a fix to trunk for RC6

Nathan