default value handling in Teiid

[kchen007]

If in the metadata a column is defined as non-nullable but has a default value, and during insert statement, the end user did not supply the value for it, will Teiid replace it with the default vaue before sending to translator?

It appears right now, it will thorw an exception saying the column is not nullable.

thanks

Kevin

[shawkins]

Yes, we will use the default value.

[kchen007]

thanks Steven.

But with Teiid 8.4, when I test it, the Teiid still pass null to the our translator without replacing it with default value. Where the replacement happen?

thanks

Kevin

[shawkins]

> Where the replacement happen?

It will happen before being sent to the translator.  You should only have a null value if the column is nullable and there is no default.