[teiid-issues] [JBoss JIRA] (TEIID-3781) Queries are not killed even if the client sends a cancel request

[RH Bugzilla Integration (JIRA)]

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

RH Bugzilla Integration commented on TEIID-3781:
------------------------------------------------

Juraj Duráni <jdurani at redhat.com> changed the Status of [bug 1315378|https://bugzilla.redhat.com/show_bug.cgi?id=1315378] from ON_QA to VERIFIED

> Queries are not killed even if the client sends a cancel request
> ----------------------------------------------------------------
>
>                 Key: TEIID-3781
>                 URL: https://issues.jboss.org/browse/TEIID-3781
>             Project: Teiid
>          Issue Type: Quality Risk
>          Components: Query Engine
>    Affects Versions: 7.0
>            Reporter: Salvatore R
>            Assignee: Steven Hawkins
>             Fix For: 8.12.1, 8.13
>
>
> I have different behaviors when I try to cancel the following queries:
> {code:sql}
> SELECT COUNT(*)
> FROM
> 	(SELECT * FROM my.address) as x1,
> 	(SELECT * FROM my.address) as y1
> {code}
> and
> {code:sql}
> SELECT COUNT(*)
> FROM
> 	(SELECT * FROM my.address limit 10000) as x1,
> 	(SELECT * FROM my.address limit 10000) as y1
> {code}
> where "my.address" is a table with around 20000 rows in MySQL.
> The first query is immediately cancelled but the second one continues to run until the end and it is never killed.
> Looking at the generated plans, the main difference is that the first query is fully pushed down to MySQL while the second one is not.



--
This message was sent by Atlassian JIRA
(v6.4.11#64026)