[teiid-issues] [JBoss JIRA] (TEIID-4973) Couchbase - Teiid returns empty result if source query fails
Steven Hawkins (JIRA)
issues at jboss.org
Fri Jul 7 10:09:01 EDT 2017
[ https://issues.jboss.org/browse/TEIID-4973?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Steven Hawkins resolved TEIID-4973.
-----------------------------------
Resolution: Done
> Couchbase - Teiid returns empty result if source query fails
> ------------------------------------------------------------
>
> Key: TEIID-4973
> URL: https://issues.jboss.org/browse/TEIID-4973
> Project: Teiid
> Issue Type: Bug
> Components: Misc. Connectors
> Reporter: Juraj Duráni
> Assignee: Steven Hawkins
> Priority: Blocker
> Fix For: 10.0, 8.12.x-6.4, 9.3.1
>
>
> Teiid does not provide any information to the user that query actually failed. Only empty result is returned.
> Currently, issuing query like \[1\] produces source-specific query with syntax error \[2\] (result directly from Couchbase \[3\]). But Teiid returns empty result just like query succeeded with no rows.
> {code:sql|title=\[1\] Query}
> SELECT BQT1.SmallA.FloatNum FROM BQT1.SmallA WHERE BQT1.SmallA.FloatNum = 7
> {code}
> {code:plain|title=\[2\] Source-specific query}
> 10:16:09,749 DEBUG [org.teiid.CONNECTOR] (Worker12_QueryProcessorQueue86) TEIID29001 Source-specific Query: SELECT TONUMBER(`$cb_c1_FloatNum`) FROM `dvqe_small` `$cb_t1` LET `$cb_c1_FloatNum` = `$cb_t1`.`FloatNum`TONUMBER() WHERE TONUMBER(`$cb_c1_FloatNum`) = 7.0 AND `$cb_t1`.`type` = 'SmallA'
> {code}
> {code:plain|title=\[3\] Couchbase result}
> [
> {
> "code": 3000,
> "msg": "syntax error - at TONUMBER",
> "query_from_user": "SELECT TONUMBER(`$cb_c1_FloatNum`) FROM `dvqe_small` `$cb_t1` LET `$cb_c1_FloatNum` = `$cb_t1`.`FloatNum`TONUMBER() WHERE TONUMBER(`$cb_c1_FloatNum`) = 7.0 AND `$cb_t1`.`type` = 'SmallA'"
> }
> ]
> {code}
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
More information about the teiid-issues
mailing list