[teiid-issues] [JBoss JIRA] (TEIID-2998) problems with DDL returned for dynamic vdb with google spreadsheet source

[Mark Drilling (JIRA)]

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

Mark Drilling commented on TEIID-2998:
--------------------------------------

Another issue... For the sheet that originally returned the concatenated label, I manually edited the resulting model.  Changed the columns to A,B,C and removed the NIS.  But when I execute a query against that source, I get no data rows. am i doing something wrong? 

> problems with DDL returned for dynamic vdb with google spreadsheet source
> -------------------------------------------------------------------------
>
>                 Key: TEIID-2998
>                 URL: https://issues.jboss.org/browse/TEIID-2998
>             Project: Teiid
>          Issue Type: Bug
>      Security Level: Public(Everyone can see) 
>          Components: AdminApi
>    Affects Versions: 8.7
>            Reporter: Mark Drilling
>            Assignee: Steven Hawkins
>         Attachments: ChromeSheet.png, FirefoxSheet.png, GoogleSpreadsheetJIRA.txt
>
>
> I am seeing inconsistent DDL returned for dynamic VDB with a google spreadsheet source.  In the same google account, I created two spreadsheets.  One was created in firefox browser, one was created in chrome browser (don't know why that matters)
> See the attached document showing a comparison of the dynamic VDBs and the DDL that I got back.  The only difference is that the source was pointing to a different spreadsheet. 
> Notice that the DDL for the "ChromeSheet" returns the concatenated datavalues for the column name.  But it includes a NIS OPTION for the column name.



--
This message was sent by Atlassian JIRA
(v6.2.6#6264)