]
Mark Drilling commented on TEIID-2998:
--------------------------------------
Ok understand. We'd definitely just need the to use the column id in that case. So
if you can add an import property, that should work for us. Thx
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.