You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "ChaseHuangxu (via GitHub)" <gi...@apache.org> on 2023/05/13 08:11:56 UTC

[GitHub] [doris] ChaseHuangxu opened a new issue, #19611: [Bug] ERROR occur in nested subqueries with same column name and union

ChaseHuangxu opened a new issue, #19611:
URL: https://github.com/apache/doris/issues/19611

   ### Search before asking
   
   - [X] I had searched in the [issues](https://github.com/apache/doris/issues?q=is%3Aissue) and found no similar issues.
   
   
   ### Version
   
   Apache Doris 1.2.2 RELEASE
   
   ### What's Wrong?
   
   I'm trying to add Apache Doris support to SQLancer, this may be a logic bug found by @[SQLancer](https://github.com/sqlancer/sqlancer).
   
   As shown below: 
       t0 and t1 are two tables, they both have only the column c0,
       An error occurred while executing the SQL statement `select * from (select * from t0, t1 where t1.c0 != 0 union select * from to, t1 where t1.c0 = 0) tmp;`
   ![image](https://github.com/apache/doris/assets/91189188/94f77e79-8d38-4e99-8fbc-f16e2d2e466f)
   
   
   ### What You Expected?
   
   The SQL `select * from (select * from t0, t1 where t1.c0 != 0 union select * from to, t1 where t1.c0 = 0) tmp;` should execute normal and return correct results.
   
   ### How to Reproduce?
   
   _No response_
   
   ### Anything Else?
   
   _No response_
   
   ### Are you willing to submit PR?
   
   - [ ] Yes I am willing to submit a PR!
   
   ### Code of Conduct
   
   - [X] I agree to follow this project's [Code of Conduct](https://www.apache.org/foundation/policies/conduct)
   


-- 
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.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] [doris] morrySnow closed issue #19611: [Bug] ERROR occur in nested subqueries with same column name and union

Posted by "morrySnow (via GitHub)" <gi...@apache.org>.
morrySnow closed issue #19611: [Bug] ERROR occur in nested subqueries with same column name and union
URL: https://github.com/apache/doris/issues/19611


-- 
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] [doris] LiBinfeng-01 commented on issue #19611: [Bug] ERROR occur in nested subqueries with same column name and union

Posted by "LiBinfeng-01 (via GitHub)" <gi...@apache.org>.
LiBinfeng-01 commented on issue #19611:
URL: https://github.com/apache/doris/issues/19611#issuecomment-1571272516

   ![e02679ef-c7bd-48dc-96b8-8da42e93589c](https://github.com/apache/doris/assets/46676950/49264393-9782-4117-a38f-0da0c58abbe1)
   


-- 
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] [doris] LiBinfeng-01 commented on issue #19611: [Bug] ERROR occur in nested subqueries with same column name and union

Posted by "LiBinfeng-01 (via GitHub)" <gi...@apache.org>.
LiBinfeng-01 commented on issue #19611:
URL: https://github.com/apache/doris/issues/19611#issuecomment-1571272204

   the expectation result of mysql 8 and oracle 21c is also complaining of this grammar, so I suggest to write more specific in sql like :select * from (select t0.c0 from t0, t1 where t1.c0 != 0 union select t1.c0 from t0, t1 where t1.c0 = 0) tmp;


-- 
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] [doris] LiBinfeng-01 commented on issue #19611: [Bug] ERROR occur in nested subqueries with same column name and union

Posted by "LiBinfeng-01 (via GitHub)" <gi...@apache.org>.
LiBinfeng-01 commented on issue #19611:
URL: https://github.com/apache/doris/issues/19611#issuecomment-1571272347

   ![be40c7f6-0f1a-4fb5-ade7-9a1f9058b10c](https://github.com/apache/doris/assets/46676950/4c98a276-18de-4462-8ebf-b9135ca17090)
   


-- 
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] [doris] morrySnow commented on issue #19611: [Bug] ERROR occur in nested subqueries with same column name and union

Posted by "morrySnow (via GitHub)" <gi...@apache.org>.
morrySnow commented on issue #19611:
URL: https://github.com/apache/doris/issues/19611#issuecomment-1547279863

   do not use 1.2.x to test nereids


-- 
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] [doris] LiBinfeng-01 commented on issue #19611: [Bug] ERROR occur in nested subqueries with same column name and union

Posted by "LiBinfeng-01 (via GitHub)" <gi...@apache.org>.
LiBinfeng-01 commented on issue #19611:
URL: https://github.com/apache/doris/issues/19611#issuecomment-1571272872

   ![image](https://github.com/apache/doris/assets/46676950/6e6cda02-cb8a-42a4-b62b-3e364ddbeeee)
   


-- 
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