oceanbase / oceanbase/oceanbase

Description

select sum(c1), c2
from 
(
  select * from t1
  union all
  select * from t2
) v group by c2;
=>
select sum(c1), c2
from
(
  select sum(c1) as c1, c2 from t1
  union all
  select sum(c1) as c1, c2 from t2
) v group by c2;

Contributor guide

Open the contributing guide

First steps

1. Read the whole issue, then the project's contributing guide.
2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
3. Fork the repository and make your change on a branch.
4. Open a pull request that references the issue number.

Assessment

This issue has not been assessed yet.