[teiid-issues] [JBoss JIRA] (TEIID-4928) Couchbase - NAMEINSOURCE required for all the columns and tables

[Kylin Soong (JIRA)]

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

Kylin Soong edited comment on TEIID-4928 at 5/26/17 3:19 AM:
-------------------------------------------------------------

> One more note. Keyspace property in resource-adapter. Can you define multiple keyspaces?
Are you means sampleKeyspaces in TEIID-4933?
The Keyspace in resource-adapter are useed to create connection, with couchbase SDK(java client),  
* if a connection created against one Keyspace,  the connection can operate all documents in a namespace across different keyspaces with lower standard of security. The current implements use this way. 
* The connection can create against the Namespaces or higher level abstraction like Datastores, but this need higher standard of security, I think this can be a enhance for future.


was (Author: kylin):
> One more note. Keyspace property in resource-adapter. Can you define multiple keyspaces?
Are you means sampleKeyspaces in TEIID-4933?
The Keyspace in resource-adapter are useed to create connection, with couchbase SDK(java client),  
* if a connection against one Keyspace,  the connection can operate all documents in different Keyspaces under same namespace, with lower standard of security. 
* The connection can create against the Namespaces or higher level abstraction like Datastores, but this need higher standard of security, I think this can be a enhance for future.

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