[
https://issues.jboss.org/browse/TEIID-4928?page=com.atlassian.jira.plugin...
]
Kylin Soong resolved TEIID-4928.
--------------------------------
Resolution: Done
Set to resolve due to add a document to note name in source are necessary, feel free
re-edit the docs.
Couchbase - NAMEINSOURCE required for all the columns and tables
----------------------------------------------------------------
Key: TEIID-4928
URL:
https://issues.jboss.org/browse/TEIID-4928
Project: Teiid
Issue Type: Bug
Components: Misc. Connectors
Affects Versions: 9.3
Reporter: Juraj DurĂ¡ni
Assignee: Kylin Soong
Option *NAMEINSOURCE* is de facto required for all the columns and tables. If it is not
present then:
# column name in source query is not enclosed in back quotes - e.g. *`$cb_t1`.ShortValue*
instead of *`$cb_t1`.`ShortValue`*
# name of the table is not added to the source query - e.g. *SELECT ... FROM null
`$cb_t1` LET ... WHERE ...* instead of *SELECT ... FROM `smalla` `$cb_t1` LET ... WHERE
...*
This should work OOB without need to add NAMEINSOURCE option. Teiid should automatically
translate column name from e.g. *MyColumn* to *`MyColumn`* if option is not set. Same with
name of the table.
In case of table I think this is more serious as it does not even try name of the table
but supplies *null* to the query
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)