Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

类型转换的下推错误；聚合函数没有下推 #804

Open
jd-zhang opened this issue Jul 11, 2022 · 3 comments
Open

类型转换的下推错误；聚合函数没有下推 #804

jd-zhang opened this issue Jul 11, 2022 · 3 comments
Labels
defect @high kunlun #trivial

Comments

@jd-zhang
Copy link
Contributor

*Issue migrated from trac ticket # 895 www.kunlunbase.com *

component: computing nodes | priority: major

2022-07-11 17:51:40: smith created the issue

** 复现

-* 问题1

create table t1(a int, b varchar(10));

insert into t1 select 1, ' 01';

select a::text::float =b::float from t1; -- 预期为true

** 问题2

explain select count(distinct a) from t1; -- 预期count(distinct a)
完全下推到存储节点
@jd-zhang
Copy link
Contributor Author

2022-07-11 18:00:47: smith changed status from new to accepted

@jd-zhang
Copy link
Contributor Author

2022-07-11 18:02:33: smith edited the issue description

@jd-zhang
Copy link
Contributor Author

2022-07-11 18:02:33: smith changed title from 类型转换的下推错误 to 类型转换的下推错误；聚合函数没有下推

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
defect @high kunlun #trivial
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@jd-zhang