[ https://issues.jboss.org/browse/TEIID-3750?page=com.atlassian.jira.plugin... ] Jan Stastny commented on TEIID-3750: ------------------------------------ [~shawkins] What are the expectations here? On 8.12.14.6_4: # Teiid doesn't insert the default scalar value when defined on view or foreign table, but inserts null #* {code:sql}CREATE VIEW v1 ( e1 integer, e2 string NOT NULL DEFAULT 'default' ) OPTIONS (UPDATABLE TRUE) AS SELECT e1, e2 FROM g1;{code} # Teiid doesn't fail VDB deploy, when an expression is defined in DDL metadata when using the property "teiid_rel:default_handling" 'expression' on the column #* {code:sql}SET NAMESPACE 'http://www.teiid.org/ext/relational/2012' AS teiid_rel; CREATE VIRTUAL PROCEDURE get_default() RETURNS (v1 string) AS BEGIN SELECT 'default'; END CREATE FOREIGN TABLE g1( e1 integer, e2 string DEFAULT get_default() OPTIONS ("teiid_rel:default_handling" 'expression'));{code} # Teiid is able to import a default expression, but the property is not set in resulting DDL: #* {code:sql}CREATE FOREIGN TABLE g1 ( e1 integer OPTIONS (NAMEINSOURCE '"e1"', NATIVE_TYPE 'int4'), e2 string(15) NOT NULL DEFAULT 'timeofday()' OPTIONS (NAMEINSOURCE '"e2"', NATIVE_TYPE 'varchar') ) OPTIONS (NAMEINSOURCE '"public"."g1"', UPDATABLE TRUE);{code} # Teiid doesn't insert the value got by evaluation of the default expression, but inserts null -- This message was sent by Atlassian JIRA (v7.5.0#75005)