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

[Juraj Duráni (JIRA)]

Juraj Duráni created TEIID-4928:
-----------------------------------

             Summary: 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: Steven Hawkins


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)