You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by GitBox <gi...@apache.org> on 2019/12/03 04:32:43 UTC

[GitHub] [incubator-doris] EmmyMiao87 opened a new pull request #2360: Support subquery with non-scalar result in Binary predicate and Between-and predicate

EmmyMiao87 opened a new pull request #2360: Support subquery with non-scalar result in Binary predicate and Between-and predicate
URL: https://github.com/apache/incubator-doris/pull/2360
 
 
   This commit add a new plan node named AssertNumRowsNode
   which is used to determine whether the number of rows exceeds the limit.
   The subquery in Binary predicate and Between-and predicate should be added a AssertNumRowsNode
   which is used to determine whether the number of rows in subquery is more than 1.
   If the number of rows in subquery is more than 1, the query will be cancelled.
   
   For example:
   There are 4 rows in table t1.
   Query: select c1 from t1 where c1=(select c2 from t1);
   Result: ERROR 1064 (HY000): Expected no more than 1 to be returned by expression select c2 from t1
   
   ISSUE-2270
   TPC-DS 6,54,58

----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
 
For queries about this service, please contact Infrastructure at:
users@infra.apache.org


With regards,
Apache Git Services

---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org