[GitHub] [incubator-doris] qzsee opened a new issue, #8856: [Bug] non-equal out join is not supported

[GitBox]

qzsee opened a new issue, #8856:
URL: https://github.com/apache/incubator-doris/issues/8856

   ### Search before asking
   
   - [X] I had searched in the 
[issues](https://github.com/apache/incubator-doris/issues?q=is%3Aissue) and 
found no similar issues.
   
   
   ### Version
   
   master
   
   ### What's Wrong?
   
   ```sql
   create table student
   (
       sid int,
       name varchar(20),
       sex varchar(4),
       phone bigint,
       address varchar(100)
   )
   DISTRIBUTED BY HASH(sid) BUCKETS 10
   PROPERTIES("replication_num" = "1");
   
   insert into student values(1,'张三','男',13000000001,'北京市');
   insert into student values(2,'李四','女',13000000002,'上海市');
   insert into student values(3,'王五','男',13000000003,'天津市');
   insert into student values(4,'赵六','女',13000000004,'重庆市');
   insert into student values(5,'李七','男',13000000005,'广州市');
   
   
   
   create table course
   (
       cid int,
       cname varchar(100)    
   )
   DISTRIBUTED BY HASH(cid) BUCKETS 10
   PROPERTIES("replication_num" = "1");
   
   insert into course values(1,'语文');
   insert into course values(2,'数学');
   insert into course values(3,'英语');
   insert into course values(4,'生物');
   insert into course values(5,'物理');
   
   
   create table grade
   (
       sid int,
       cid int,
       score double
       
   )
   DISTRIBUTED BY HASH(sid,cid) BUCKETS 10
   PROPERTIES("replication_num" = "1");
   
   insert into grade values(1,1,85);
   insert into grade values(1,2,75);
   insert into grade values(1,3,94);
   insert into grade values(1,4,62);
   insert into grade values(1,5,91);
   
   insert into grade values(2,1,93);
   insert into grade values(2,2,84);
   insert into grade values(2,3,74);
   insert into grade values(2,4,99);
   insert into grade values(2,5,100);
   
   insert into grade values(3,1,99);
   insert into grade values(3,2,80);
   insert into grade values(3,3,65);
   insert into grade values(3,4,87);
   insert into grade values(3,5,83);
   
   insert into grade values(4,1,91);
   insert into grade values(4,2,87);
   insert into grade values(4,3,89);
   insert into grade values(4,4,99);
   insert into grade values(4,5,100);
   
   insert into grade values(5,1,100);
   insert into grade values(5,2,92);
   insert into grade values(5,3,87);
   insert into grade values(5,4,93);
   insert into grade values(5,5,64);
   
   
   select * from student left join grade on student.sid = grade.sid and 1=2;
   
   non-equal LEFT OUTER JOIN is not supported
   
   
   ```
   
   ### What You Expected?
   
   every thing is ok
   
   ### How to Reproduce?
   
   _No response_
   
   ### Anything Else?
   
   _No response_
   
   ### Are you willing to submit PR?
   
   - [X] 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-unsubscr...@doris.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org


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