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

[Steven Hawkins (JIRA)]

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

Steven Hawkins commented on TEIID-2998:
---------------------------------------

What you are seeing is completely unrelated to the DDL.  Since google is inferring the label as being all of the initial column values, the google api more than likely doesn't think there is any row values.

> 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)