[teiid-issues] [JBoss JIRA] (TEIID-3750) Allow the parsing of an expression

[Jan Stastny (JIRA)]

    [ https://issues.jboss.org/browse/TEIID-3750?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13591430#comment-13591430 ] 

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

> Allow the parsing of an expression
> ----------------------------------
>
>                 Key: TEIID-3750
>                 URL: https://issues.jboss.org/browse/TEIID-3750
>             Project: Teiid
>          Issue Type: Sub-task
>          Components: Query Engine
>            Reporter: Steven Hawkins
>            Assignee: Steven Hawkins
>             Fix For: 9.0, 8.12.14.6_4
>
>
> Now that we have an extension property, we could allow an expression to be used in parsing rather than just a string.



--
This message was sent by Atlassian JIRA
(v7.5.0#75005)