[
https://issues.jboss.org/browse/TEIID-2998?page=com.atlassian.jira.plugin...
]
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)