[JBoss JIRA] (TEIIDDES-2880) New preview not working with table that calls UDF function
                                
                                
                                
                                    
                                        by Matus Makovy (JIRA)
                                    
                                
                                
                                        Matus Makovy created TEIIDDES-2880:
--------------------------------------
             Summary: New preview not working with table that calls UDF function 
                 Key: TEIIDDES-2880
                 URL: https://issues.jboss.org/browse/TEIIDDES-2880
             Project: Teiid Designer
          Issue Type: Bug
    Affects Versions: 10.0.1
         Environment: MAC
            Reporter: Matus Makovy
         Attachments: view.xmi
I have a view model with UDF function defined as procedure and a table that uses this UDF procedure. Transformation SQL looks like this:
{code:SQL}
SELECT
		udfConcatNull(hsqldbParts.PARTS.PART_NAME, hsqldbParts.PARTS.PART_WEIGHT) AS NAME_WEIGHT
	FROM
		hsqldbParts.PARTS
{code}
When I hit Preview Data on that table, the dynamic VDB that is generated looks like this:
{code:xml}
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<vdb name="PREVIEW-fd6cadf2-4ae3-4d8f-9420-22f4882201e7" version="1">
	<description>Importer VDB</description>
	<property name="UseConnectorMetadata" value="true" />
	<property name="deployment-name" value="PREVIEW-fd6cadf2-4ae3-4d8f-9420-22f4882201e7-vdb.xml" />
	<model name="view" type="VIRTUAL" visible="true">
		<metadata type="DDL"><![CDATA[
CREATE VIEW tab (
	NAME_WEIGHT string
) 
AS
	select udfConcatNull(hsqldbParts.PARTS.PART_NAME,hsqldbParts.PARTS.PART_WEIGHT) as NAME_WEIGHT from hsqldbParts.PARTS;
]]></metadata>
	</model>
	<model name="hsqldbParts" type="PHYSICAL" visible="true">
		<source name="hsqldbParts" translator-name="oracle" connection-jndi-name="null" />
		<metadata type="DDL"><![CDATA[
CREATE FOREIGN TABLE PARTS (
	PART_ID string(4) NOT NULL OPTIONS(NAMEINSOURCE '"PART_ID"', NATIVE_TYPE 'CHAR', FIXED_LENGTH 'TRUE'),
	PART_NAME string(255) OPTIONS(NAMEINSOURCE '"PART_NAME"', NATIVE_TYPE 'VARCHAR2'),
	PART_COLOR string(30) OPTIONS(NAMEINSOURCE '"PART_COLOR"', NATIVE_TYPE 'VARCHAR2'),
	PART_WEIGHT string(255) OPTIONS(NAMEINSOURCE '"PART_WEIGHT"', NATIVE_TYPE 'VARCHAR2'),
	CONSTRAINT PK_PARTS PRIMARY KEY(PART_ID)
) OPTIONS(NAMEINSOURCE '"PARTSSUPPLIER"."PARTS"')
]]></metadata>
	</model>
</vdb>
{code}
If I see correctly, the UDF procedure is not in the dynamic VDB.
I know that the situation about dynamic VDBs and UDF functions in JAR files is complicated and I am not sure right now how this should be resolved. 
But in my opinion the udf procedure should be in the dynamic VDB and there should be a warning that TD won't deploy the JAR to the server and if user wants to make a preview, the JAR should be deployed to the server manually.
View model attached
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
                                
                         
                        
                                
                                9 years, 3 months
                        
                        
                 
         
 
        
            
        
        
        
                
                        
                                
                                
                                        
                                
                         
                        
                                
                                
                                        
                                                
                                        
                                        
                                        [JBoss JIRA] (TEIIDDES-2832) Unable to preview imported SF model
                                
                                
                                
                                    
                                        by Matej Kralik (JIRA)
                                    
                                
                                
                                        
     [ https://issues.jboss.org/browse/TEIIDDES-2832?page=com.atlassian.jira.plu... ]
Matej Kralik closed TEIIDDES-2832.
----------------------------------
> Unable to preview imported SF model
> -----------------------------------
>
>                 Key: TEIIDDES-2832
>                 URL: https://issues.jboss.org/browse/TEIIDDES-2832
>             Project: Teiid Designer
>          Issue Type: Bug
>          Components: Dynamic VDBs
>    Affects Versions: 10.0
>            Reporter: Mark Drilling
>            Assignee: Barry LaFond
>              Labels: verified_jbdsis-9.0.1
>             Fix For: 10.0.1
>
>         Attachments: server.log
>
>
> Import from salesforce using SF importer, then attempt to preview Account table, results in the attached server.log exception.
> The dynamic VDB content:
> <vdb name="PREVIEW-f118338c-1837-4973-ae81-61092ac55eb9" version="1">
> 	<description>Importer VDB</description>
> 	<property name="UseConnectorMetadata" value="true" />
> 	<property name="deployment-name" value="PREVIEW-f118338c-1837-4973-ae81-61092ac55eb9-vdb.xml" />
> 	<model name="SFModel" type="PHYSICAL" visible="true">
> 		<source name="SFModel" translator-name="salesforce" connection-jndi-name="null" />
> 		<metadata type="DDL"><![CDATA[
> CREATE FOREIGN TABLE Account (
> 	Id string(18) NOT NULL OPTIONS(NAMEINSOURCE 'Id', NATIVE_TYPE 'id', "teiid_sf:Defaulted on Create" 'TRUE'),
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
                                
                         
                        
                                
                                9 years, 3 months
                        
                        
                 
         
 
        
            
        
        
        
                
                        
                                
                                
                                        
                                
                         
                        
                                
                                
                                        
                                                
                                        
                                        
                                        [JBoss JIRA] (TEIIDDES-2832) Unable to preview imported SF model
                                
                                
                                
                                    
                                        by Matej Kralik (JIRA)
                                    
                                
                                
                                        
     [ https://issues.jboss.org/browse/TEIIDDES-2832?page=com.atlassian.jira.plu... ]
Matej Kralik updated TEIIDDES-2832:
-----------------------------------
    Labels: verified_jbdsis-9.0.1  (was: )
> Unable to preview imported SF model
> -----------------------------------
>
>                 Key: TEIIDDES-2832
>                 URL: https://issues.jboss.org/browse/TEIIDDES-2832
>             Project: Teiid Designer
>          Issue Type: Bug
>          Components: Dynamic VDBs
>    Affects Versions: 10.0
>            Reporter: Mark Drilling
>            Assignee: Barry LaFond
>              Labels: verified_jbdsis-9.0.1
>             Fix For: 10.0.1
>
>         Attachments: server.log
>
>
> Import from salesforce using SF importer, then attempt to preview Account table, results in the attached server.log exception.
> The dynamic VDB content:
> <vdb name="PREVIEW-f118338c-1837-4973-ae81-61092ac55eb9" version="1">
> 	<description>Importer VDB</description>
> 	<property name="UseConnectorMetadata" value="true" />
> 	<property name="deployment-name" value="PREVIEW-f118338c-1837-4973-ae81-61092ac55eb9-vdb.xml" />
> 	<model name="SFModel" type="PHYSICAL" visible="true">
> 		<source name="SFModel" translator-name="salesforce" connection-jndi-name="null" />
> 		<metadata type="DDL"><![CDATA[
> CREATE FOREIGN TABLE Account (
> 	Id string(18) NOT NULL OPTIONS(NAMEINSOURCE 'Id', NATIVE_TYPE 'id', "teiid_sf:Defaulted on Create" 'TRUE'),
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
                                
                         
                        
                                
                                9 years, 3 months
                        
                        
                 
         
 
        
            
        
        
        
                
                        
                                
                                
                                        
                                
                         
                        
                                
                                
                                        
                                                
                                        
                                        
                                        [JBoss JIRA] (TEIIDDES-2729) Bad export of carriage return in SQL transformation
                                
                                
                                
                                    
                                        by Matej Kralik (JIRA)
                                    
                                
                                
                                        
     [ https://issues.jboss.org/browse/TEIIDDES-2729?page=com.atlassian.jira.plu... ]
Matej Kralik updated TEIIDDES-2729:
-----------------------------------
    Labels: release_notes verified_jbdsis-9.0.1  (was: )
> Bad export of carriage return in SQL transformation
> ---------------------------------------------------
>
>                 Key: TEIIDDES-2729
>                 URL: https://issues.jboss.org/browse/TEIIDDES-2729
>             Project: Teiid Designer
>          Issue Type: Bug
>          Components: Patch Release, Transformations
>    Affects Versions: 9.2
>         Environment: Eclipse 4.4.2
> Teiid Designer 9.2.0.Final-v20151028-1427-B4011
> Windows 7 Enterprise 64-bit
>            Reporter: Jean-Pierre Matsumoto
>            Assignee: Barry LaFond
>              Labels: release_notes, verified_jbdsis-9.0.1
>             Fix For: 10.0
>
>         Attachments: error.png, SimpleOracle.zip, sql.txt, TEIIDDES-2729-fix.patch
>
>
> Carriage returns characters makes errors with export + import SQL.
> Can be related to TEIIDDES-735.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
                                
                         
                        
                                
                                9 years, 3 months
                        
                        
                 
         
 
        
            
        
        
        
                
                        
                                
                                
                                        
                                
                         
                        
                                
                                
                                        
                                                
                                        
                                        
                                        [JBoss JIRA] (TEIIDDES-2729) Bad export of carriage return in SQL transformation
                                
                                
                                
                                    
                                        by Matej Kralik (JIRA)
                                    
                                
                                
                                        
     [ https://issues.jboss.org/browse/TEIIDDES-2729?page=com.atlassian.jira.plu... ]
Matej Kralik closed TEIIDDES-2729.
----------------------------------
When I pasted sql to the transformation editor (step 3.3), the editor still shows "ERROR:Error in parsing of sql - null". [(TEIIDDES-2782)|https://issues.jboss.org/browse/TEIIDDES-2782]. 
Anyway, I exported sql (exported file contains \r) and that imported it back, sql was same as before and the designer didn't show the error. Because of that, I close this bug.
> Bad export of carriage return in SQL transformation
> ---------------------------------------------------
>
>                 Key: TEIIDDES-2729
>                 URL: https://issues.jboss.org/browse/TEIIDDES-2729
>             Project: Teiid Designer
>          Issue Type: Bug
>          Components: Patch Release, Transformations
>    Affects Versions: 9.2
>         Environment: Eclipse 4.4.2
> Teiid Designer 9.2.0.Final-v20151028-1427-B4011
> Windows 7 Enterprise 64-bit
>            Reporter: Jean-Pierre Matsumoto
>            Assignee: Barry LaFond
>              Labels: release_notes, verified_jbdsis-9.0.1
>             Fix For: 10.0
>
>         Attachments: error.png, SimpleOracle.zip, sql.txt, TEIIDDES-2729-fix.patch
>
>
> Carriage returns characters makes errors with export + import SQL.
> Can be related to TEIIDDES-735.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
                                
                         
                        
                                
                                9 years, 3 months
                        
                        
                 
         
 
        
            
        
        
        
                
                        
                                
                                
                                        
                                
                         
                        
                                
                                
                                        
                                                
                                        
                                        
                                        [JBoss JIRA] (TEIIDDES-2782) Copy paste sql to the transformation editor is not parsable
                                
                                
                                
                                    
                                        by Matej Kralik (JIRA)
                                    
                                
                                
                                        
     [ https://issues.jboss.org/browse/TEIIDDES-2782?page=com.atlassian.jira.plu... ]
Matej Kralik updated TEIIDDES-2782:
-----------------------------------
    Priority: Major  (was: Minor)
> Copy paste sql to the transformation editor is not parsable
> -----------------------------------------------------------
>
>                 Key: TEIIDDES-2782
>                 URL: https://issues.jboss.org/browse/TEIIDDES-2782
>             Project: Teiid Designer
>          Issue Type: Bug
>          Components: Editors, Transformations
>    Affects Versions: 10.0.1
>         Environment: Windows 10 Pro N
>            Reporter: Matej Kralik
>         Attachments: XmlStagingProject.zip
>
>
> When I copy a sql query from any source (notepad, web browser ...) and paste it to the transformation editor show me that "The query is not parsable.Error in parsing of sql - null ."
> When I deleted all newlines from sql query or I wrote it myself to the editor, sql query was validated.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
                                
                         
                        
                                
                                9 years, 3 months
                        
                        
                 
         
 
        
            
        
        
        
            
        
        
        
            
        
        
        
                
                        
                                
                                
                                        
                                
                         
                        
                                
                                
                                        
                                                
                                        
                                        
                                        [JBoss JIRA] (TEIIDDES-2664) Add Model Extension support for Procedure RESULTS OPTIONS
                                
                                
                                
                                    
                                        by Matej Kralik (JIRA)
                                    
                                
                                
                                        
     [ https://issues.jboss.org/browse/TEIIDDES-2664?page=com.atlassian.jira.plu... ]
Matej Kralik updated TEIIDDES-2664:
-----------------------------------
    Labels: release_notes verified_jbdsis-9.0.1  (was: )
> Add Model Extension support for Procedure RESULTS OPTIONS
> ---------------------------------------------------------
>
>                 Key: TEIIDDES-2664
>                 URL: https://issues.jboss.org/browse/TEIIDDES-2664
>             Project: Teiid Designer
>          Issue Type: Enhancement
>          Components: ModeShape Integration, Patch Release, Teiid Integration
>            Reporter: Ramesh Reddy
>            Assignee: Barry LaFond
>              Labels: release_notes, verified_jbdsis-9.0.1
>             Fix For: 10.0, 9.2.1
>
>          Time Spent: 2 hours
>  Remaining Estimate: 0 minutes
>
> Teiid DDL now supports options for procedure/functions returns clause parameters:
> ... RETURNS (options ...) type
> ... RETURNS (options ...) TABLE (...)
> This was added to Teiid version 8.12
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
                                
                         
                        
                                
                                9 years, 3 months