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

[Steven Hawkins (JIRA)]

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

Steven Hawkins commented on TEIID-4928:
---------------------------------------

> How is it compatible? If NAMEINSOURCE is not defined for column, generated N1QL is missing back quotes (`) around ShortValue which, from my testing, does not work.

>From the Couchbase documentation it appears that it should be compatible.  Can you provide more details, like the exception, from a failing case?

> In fact, after talking with other QE we would not recommend using NATIVE metadata for Couchbase.

Is the central qualm with the sample size?  Perhaps it would be possible to provide N1QL queries to pull a representative docs in addition to or instead of limit based sampling.

> Do you think how can we do some enhance to make this more clear?

A you saying that we'll need more documentation on how to define the metadata manually?  Or are you suggesting that we should reuse the simba schema tools?


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