zhouqingqing / qpmodel

A Relational Optimizer and Executor
MIT License
64 stars 18 forks source link

count(distinct const) is incorrect #216

Open pkommoju opened 3 years ago

pkommoju commented 3 years ago

select sum(1), avg(2), min(3), max(4), count(5), count(distinct 6), stddev_samp(7.38) from a

should return 3,2,3,4,3,1,0

instead the actual result is 3,2,3,4,3,3,0

zhouqingqing commented 3 years ago

We don't support agg(distinct)yet.