Unable to set pseudo column USER as default value for a column

[hakkika]

Hi,

I’m using Oracle database and Liquibase 2.0.5.

It seems there is no way to set pseudo column USER as default value for a VARCHAR2 type column.
The default value always ends up as string ‘USER’.

I have tried defaultValueDate as some of the previous posts suggests, but that produces
java.lang.ClassCastException.

I managed to get it working by using the following modifySql element:

         


But is that really the only possible way?

Regards,
Kari

[Guest]

Did you find a solution to this?  Still doesn’t work ing 3.0.7.

[nvoxland]

Does it work if you use defaultValueComputed=“USER” ?

Nathan