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 2020/06/17 14:48:26 UTC
[GitHub] [incubator-doris] spaces-X opened a new issue #3897: subquery can not reslove the grandpa column
spaces-X opened a new issue #3897:
URL: https://github.com/apache/incubator-doris/issues/3897
In Analyzer #registerColumnRef
We got warning like this:
```
/*
* Now, we only support the columns in the subquery to associate the outer query columns in parent level.
* If the level of the association exceeds one level, the associated columns in subquery could not be resolved.
* For example:
* Select k1 from table a where k1=(select k1 from table b where k1=(select k1 from table c where a.k1=k1));
* The inner subquery: select k1 from table c where a.k1=k1;
* There is a associated column (a.k1) which belongs to the outer query appears in the inner subquery.
* This column could not be resolved because doris can only resolved the parent column instead of grandpa.
* The exception of this query like that: Unknown column 'k1' in 'a'
*/
```
Does the problem exist in branch 11 ?
----------------------------------------------------------------
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
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
[GitHub] [incubator-doris] xinghuayu007 commented on issue #3897: subquery can not reslove the grandpa column
Posted by GitBox <gi...@apache.org>.
xinghuayu007 commented on issue #3897:
URL: https://github.com/apache/incubator-doris/issues/3897#issuecomment-972461600
Did this problem be solved?
--
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.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
[GitHub] [incubator-doris] spaces-X closed issue #3897: subquery can not reslove the grandpa column
Posted by GitBox <gi...@apache.org>.
spaces-X closed issue #3897:
URL: https://github.com/apache/incubator-doris/issues/3897
----------------------------------------------------------------
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
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org