]
Steven Hawkins resolved TEIID-5035.
-----------------------------------
Fix Version/s: 10.0
8.12.x-6.4
9.3.3
Resolution: Done
The visitor was holding state from the first branch that bled into the second. This was
updated so that each is rendered in isolation.
Couchbase INTERSECT doesn't return any values
---------------------------------------------
Key: TEIID-5035
URL:
https://issues.jboss.org/browse/TEIID-5035
Project: Teiid
Issue Type: Bug
Components: Misc. Connectors
Affects Versions: 8.12.x-6.4
Reporter: Jan Stastny
Assignee: Steven Hawkins
Priority: Critical
Fix For: 10.0, 8.12.x-6.4, 9.3.3
INTERSECT operator pushed to Couchbase returns no rows, even though there is an
intersection in the values.
{code:sql|title=query_smallA}
SELECT IntKey FROM BQT1.SmallA
{code}
|| IntKey ||
|| 0 ||
|| 1 ||
|| 10 ||
|| 11 ||
|| 12 ||
|| 13 ||
|| 14 ||
|| 15 ||
|| 16 ||
|| 17 ||
|| 18 ||
|| 19 ||
|| 2 ||
|| 20 ||
|| 21 ||
|| 22 ||
|| 23 ||
|| 24 ||
|| 25 ||
|| 26 ||
|| 27 ||
|| 28 ||
|| 29 ||
|| 3 ||
|| 30 ||
|| 31 ||
|| 32 ||
|| 33 ||
|| 34 ||
|| 35 ||
|| 36 ||
|| 37 ||
|| 38 ||
|| 39 ||
|| 4 ||
|| 40 ||
|| 41 ||
|| 42 ||
|| 43 ||
|| 44 ||
|| 45 ||
|| 46 ||
|| 47 ||
|| 48 ||
|| 49 ||
|| 5 ||
|| 6 ||
|| 7 ||
|| 8 ||
|| 9 ||
{code:sql|title=query_smallB}
SELECT IntKey FROM BQT1.SmallB
{code}
|| IntKey ||
|| 0 ||
|| 1 ||
|| 10 ||
|| 11 ||
|| 12 ||
|| 13 ||
|| 14 ||
|| 15 ||
|| 16 ||
|| 17 ||
|| 18 ||
|| 19 ||
|| 2 ||
|| 20 ||
|| 21 ||
|| 22 ||
|| 23 ||
|| 24 ||
|| 25 ||
|| 26 ||
|| 27 ||
|| 28 ||
|| 29 ||
|| 3 ||
|| 30 ||
|| 31 ||
|| 32 ||
|| 33 ||
|| 34 ||
|| 35 ||
|| 36 ||
|| 37 ||
|| 38 ||
|| 39 ||
|| 4 ||
|| 40 ||
|| 41 ||
|| 42 ||
|| 43 ||
|| 44 ||
|| 45 ||
|| 46 ||
|| 47 ||
|| 48 ||
|| 49 ||
|| 5 ||
|| 6 ||
|| 7 ||
|| 8 ||
|| 9 ||
{code:sql|title=query_intersect}
SELECT IntKey FROM BQT1.SmallA INTERSECT SELECT IntKey FROM BQT1.SmallB
{code}
|| IntKey ||
{code:title=teiid-command.log}
16:54:04,453 INFO [org.teiid.COMMAND_LOG] (New I/O worker #2) QE2ZpDa/Btt5 START
USER COMMAND: startTime=2017-08-24 16:54:04.453 requestID=QE2ZpDa/Btt5.141
txID=null sessionID=QE2ZpDa/Btt5 applicationName=JDBC
principal=user@teiid-security vdbName=couchbase vdbVersion=1 sql=SELECT IntKey
FROM BQT1.SmallA INTERSECT SELECT IntKey FROM BQT1.SmallB
16:54:04,455 DEBUG [org.teiid.COMMAND_LOG] (Worker45_QueryProcessorQueue420) QE2ZpDa/Btt5
START DATA SRC COMMAND: startTime=2017-08-24 16:54:04.455
requestID=QE2ZpDa/Btt5.141 sourceCommandID=0 executionID=102 txID=null
modelName=Couchbase_small translatorName=couchbase sessionID=QE2ZpDa/Btt5
principal=user@teiid-security sql=SELECT Couchbase_small.SmallA.IntKey AS c_0 FROM
Couchbase_small.SmallA INTERSECT SELECT Couchbase_small.SmallB.IntKey AS c_0 FROM
Couchbase_small.SmallB
16:54:04,455 DEBUG [org.teiid.COMMAND_LOG] (Worker45_QueryProcessorQueue420) QE2ZpDa/Btt5
SOURCE SRC COMMAND: endTime=2017-08-24 16:54:04.455
requestID=QE2ZpDa/Btt5.141 sourceCommandID=0 executionID=102 txID=null
modelName=Couchbase_small translatorName=couchbase sessionID=QE2ZpDa/Btt5
principal=user@teiid-security sourceCommand=[SELECT `$cb_c1_IntKey` FROM `dvqe_small`
`$cb_t1` LET `$cb_c1_IntKey` = `$cb_t1`.`IntKey` WHERE `$cb_t1`.`type` = 'SmallA'
INTERSECT SELECT `$cb_c2_IntKey` FROM `dvqe_small` `$cb_t2` LET `$cb_c1_IntKey` =
`$cb_t2`.`IntKey`, `$cb_c2_IntKey` = `$cb_t2`.`IntKey` WHERE `$cb_t2`.`type` =
'SmallA']
16:54:04,680 DEBUG [org.teiid.COMMAND_LOG] (Worker44_QueryProcessorQueue421) QE2ZpDa/Btt5
END SRC COMMAND: endTime=2017-08-24 16:54:04.68
requestID=QE2ZpDa/Btt5.141 sourceCommandID=0 executionID=102 txID=null
modelName=Couchbase_small translatorName=couchbase sessionID=QE2ZpDa/Btt5
principal=user@teiid-security finalRowCount=0 cpuTime(ns)=953196
16:54:04,687 INFO [org.teiid.COMMAND_LOG] (Worker44_QueryProcessorQueue422) QE2ZpDa/Btt5
END USER COMMAND: endTime=2017-08-24 16:54:04.687
requestID=QE2ZpDa/Btt5.141 txID=null sessionID=QE2ZpDa/Btt5
principal=user@teiid-security vdbName=couchbase vdbVersion=1 finalRowCount=0
{code}