[Feature Request]: sum(bool) under a mysql compatibility flag

### Is there an existing issue for the same feature request?

- [x] I have checked the existing issues.

### Is your feature request related to a problem?

```Markdown
create table t (i int, j int);
insert into t values (0, 0), (1, 1), (2,2);

select sum(i<>0) from t;

Sum(bool) will fail, this is correct behavior. However mysql does not
have bool type and will convert bool to 0/1. So let's support sum(bool)
under mysql compatible flag.
```

### Describe the feature you'd like

See above.

### Describe implementation you've considered

_No response_

### Documentation, Adoption, Use Case, Migration Strategy

```Markdown

```

### Additional information

_No response_