[teiid-issues] [JBoss JIRA] (TEIID-4729) Multisource SOURCE_NAME field pushes to source

[Steven Hawkins (JIRA)]

     [ https://issues.jboss.org/browse/TEIID-4729?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Steven Hawkins updated TEIID-4729:
----------------------------------
    Component/s: Query Engine


> Multisource SOURCE_NAME field pushes to source
> ----------------------------------------------
>
>                 Key: TEIID-4729
>                 URL: https://issues.jboss.org/browse/TEIID-4729
>             Project: Teiid
>          Issue Type: Bug
>          Components: Query Engine
>    Affects Versions: 8.12.6.6_3
>            Reporter: Debbie Steigner
>            Assignee: Steven Hawkins
>
> If a view transformation contains a union of a multi-source model and a non multisource model, because of https://issues.jboss.org/browse/TEIID-4728 the SOURCE_NAME column has to be created on the View and hence on the non-multisource model and if you don't mark that source model as multisource the SOURCE_NAME column is pushed to the source.
> <?xml version="1.0" encoding="UTF-8" standalone="no"?>
> <vdb name="multi_emp" version="1">
> <description/>
> <property name="validationDateTime" value="Mon Oct 31 08:01:36 CDT 2016"/>
> <property name="validationVersion" value="8.12.6"/>
> <model name="multi" type="PHYSICAL" visible="true">
> <property name="multisource" value="true"/>
>         <!-- optional properties -->
>         <property name="multisource.columnName" value="SOURCE_NAME"/>
>         <property name="multisource.addColumn" value="true"/> 
>         
>         <source connection-jndi-name="java:/deb" name="deb" translator-name="postgresql"/>
>         <source connection-jndi-name="java:/dv63" name="dv63" translator-name="postgresql"/>
> <metadata type="DDL"><![CDATA[
> CREATE FOREIGN TABLE emp (
> 	id integer NOT NULL OPTIONS(NAMEINSOURCE '"id"', NATIVE_TYPE 'int4', CASE_SENSITIVE 'FALSE', FIXED_LENGTH 'TRUE', SEARCHABLE 'ALL_EXCEPT_LIKE'),
> 	name string(2147483647) OPTIONS(NAMEINSOURCE '"name"', NATIVE_TYPE 'text'),
>         SOURCE_NAME string(50),
> 	CONSTRAINT pk_emp PRIMARY KEY(id)
> ) OPTIONS(UPDATABLE 'true',NAMEINSOURCE '"public"."emp"')
> ]]></metadata>
> </model>
> <model name="Debbiedb" type="PHYSICAL" visible="true">
> <!--  Have to add this to make it work <property name="multisource" value="true"/> -->
> <source connection-jndi-name="java:/debbiedb" name="debbiedb" translator-name="postgresql"/>
> <metadata type="DDL"><![CDATA[
> CREATE FOREIGN TABLE mytable (
> 	id integer NOT NULL OPTIONS(NAMEINSOURCE '"id"', NATIVE_TYPE 'int4', CASE_SENSITIVE 'FALSE', FIXED_LENGTH 'TRUE', SEARCHABLE 'ALL_EXCEPT_LIKE'),
> 	name string(2147483647) OPTIONS(NAMEINSOURCE '"name"', NATIVE_TYPE 'text'),
> 	age integer OPTIONS(NAMEINSOURCE '"age"', NATIVE_TYPE 'int4', CASE_SENSITIVE 'FALSE', FIXED_LENGTH 'TRUE', SEARCHABLE 'ALL_EXCEPT_LIKE'),
> 	address string(2147483647) OPTIONS(NAMEINSOURCE '"address"', NATIVE_TYPE 'text'),
>         SOURCE_NAME string(50),
> 	CONSTRAINT pk_id PRIMARY KEY(id)
> ) OPTIONS(UPDATABLE 'true',NAMEINSOURCE '"public"."mytable"')
> ]]></metadata>
> </model>
> <model name="Debbiev" type="VIRTUAL" visible="true">
> <property name="imports" value="Debbiedb"/>
> <property name="imports" value="multi"/>
> <metadata type="DDL"><![CDATA[
> CREATE VIEW comboview (
> 	id integer,
> 	name string(100),
>         SOURCE_NAME string(50)
> ) 
> AS
> 	SELECT id,name,SOURCE_NAME FROM multi.emp UNION ALL SELECT id, name, SOURCE_NAME FROM Debbiedb.mytable
> ]]></metadata>
> </model>
> </vdb>



--
This message was sent by Atlassian JIRA
(v7.2.3#72005)