[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=12976172#comment-12976172 ] 

Steven Hawkins edited comment on TEIID-2998 at 6/13/14 2:20 PM:
----------------------------------------------------------------

For example the raw json we are getting back from a similar example I have is:

{code}
google.visualization.Query.setResponse({"version":"0.6","reqId":"0","status":"ok","sig":"1124987261","table":{"cols":[{"id":"A","label":"aa aa1 c","type":"string"},{"id":"B","label":"bb bb1 d","type":"string"},{"id":"C","label":"cc cc1 e","type":"string"}],"rows":[]}});
{code}

If I don't use all string data - for example having just the first row as strings, then things seem to work appropriately.  So I don't think this is something that we should yet attempt to address on our side.


was (Author: shawkins):
For example the raw json we are getting back from a similar example I have is:

google.visualization.Query.setResponse({"version":"0.6","reqId":"0","status":"ok","sig":"1124987261","table":{"cols":[{"id":"A","label":"aa aa1 c","type":"string"},{"id":"B","label":"bb bb1 d","type":"string"},{"id":"C","label":"cc cc1 e","type":"string"}],"rows":[]}});

If I don't use all string data - for example having just the first row as strings, then things seem to work appropriately.  So I don't think this is something that we should yet attempt to address on our side.

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