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 2022/04/06 08:38:12 UTC
[GitHub] [incubator-doris] qzsee opened a new issue, #8856: [Bug] non-equal out join is not supported
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-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] [incubator-doris] EmmyMiao87 commented on issue #8856: [Bug] non-equal out join is not supported
Posted by GitBox <gi...@apache.org>.
EmmyMiao87 commented on issue #8856:
URL: https://github.com/apache/incubator-doris/issues/8856#issuecomment-1090018800
I remember it was ok before. Can you help fix it if you can?
咦，这不应该呀？之前我记得是肯定ok的。可以的话能帮忙修一下嘛？
--
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] yiguolei closed issue #8856: [Bug] non-equal out join is not supported
Posted by GitBox <gi...@apache.org>.
yiguolei closed issue #8856: [Bug] non-equal out join is not supported
URL: https://github.com/apache/incubator-doris/issues/8856
--
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] qzsee commented on issue #8856: [Bug] non-equal out join is not supported
Posted by GitBox <gi...@apache.org>.
qzsee commented on issue #8856:
URL: https://github.com/apache/incubator-doris/issues/8856#issuecomment-1090016745
> Will there be a problem after the configuration of constant folding is turned off?
>
> 你把常量折叠的配置关闭后看会有问题嘛？
不是 FoldConstantsRule 的问题
是CompoundPredicateWriteRule 重写了 on 谓词
--
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] EmmyMiao87 commented on issue #8856: [Bug] non-equal out join is not supported
Posted by GitBox <gi...@apache.org>.
EmmyMiao87 commented on issue #8856:
URL: https://github.com/apache/incubator-doris/issues/8856#issuecomment-1090006668
Will there be a problem after the configuration of constant folding is turned off?
你把常量折叠的配置关闭后看会有问题嘛？
--
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] qzsee commented on issue #8856: [Bug] non-equal out join is not supported
Posted by GitBox <gi...@apache.org>.
qzsee commented on issue #8856:
URL: https://github.com/apache/incubator-doris/issues/8856#issuecomment-1090024042
> I remember it was ok before. Can you help fix it if you can?
>
> 咦，这不应该呀？之前我记得是肯定ok的。可以的话能帮忙修一下嘛？
刚提pr修了，1=2 应该应用不了FoldConstantsRule，应用了 CompoundPredicateWriteRule
--
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] qzsee commented on issue #8856: [Bug] non-equal out join is not supported
Posted by GitBox <gi...@apache.org>.
qzsee commented on issue #8856:
URL: https://github.com/apache/incubator-doris/issues/8856#issuecomment-1090015957
> constant
不是 FoldConstantsRule
是CompoundPredicateWriteRule
--
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