Tracking: mathematical functions - Githubissues

risingwavelabs / risingwave

Best-in-class stream processing, analytics, and management. Perform continuous analytics, or build event-driven applications, real-time ETL pipelines, and feature stores in minutes. Unified streaming and batch. PostgreSQL compatible.

https://go.risingwave.com/slack

Apache License 2.0

6.97k stars 575 forks source link

Tracking: mathematical functions #8806

Open xiangjinwu opened 1 year ago

xiangjinwu commented 1 year ago

https://www.postgresql.org/docs/current/functions-math.html

Make sure to test special values: -inf, inf, nan for decimal / real / double, and -0 for real / double.

proto ExprType 213, 214, 219, 221, 222, 233, 234, 245..=267, 401..=419

Cast

[x] implicit: smallint -> int -> bigint -> decimal -> real -> double
[x] assign: double -> real -> decimal -> bigint -> int -> smallint

Polymorphic

[x] unary + / - for smallint / int / bigint / decimal / real / double
[x] @ / abs for smallint / int / bigint / decimal / real / double
[x] binary + / - / / / * for various combinations
[x] % / mod for smallint / int / bigint / decimal
gcd / lcm for int / bigint / decimal
[x] ~ / & / | / # for smallint / int / bigint
[x] << / >> for lhs smallint / int / bigint

Formatting

to_char / to_number in #8831

For decimal and double

[x] round / trunc / ceil / ceiling / floor
[x] #8900
[x] #8899
[x] #8903
[x] ^ / pow / power #7725
width_bucket(operand, low, high, count)

For decimal

factorial(bigint) -> decimal
div(decimal, decimal) -> decimal
[ ] log(decimal, decimal) -> decimal #13150
[x] round(decimal, int) -> decimal
trunc(decimal, int) -> decimal
[x] min_scale(decimal) -> int
[x] scale(decimal) -> int
[x] trim_scale(decimal) -> decimal

For double

[x] ||/ / cbrt
[x] #8901
[x] pi
[x] Implement sin / cos / tan / cot / asin / acos / atan / atan2
[ ] #9678
[x] https://github.com/risingwavelabs/risingwave/issues/9675

Aggregate Functions

[x] sum
- smallint / int -> bigint
- bigint / decimal -> decimal
- real -> real
- double -> double
[x] avg
- smallint / int / bigint / decimal -> decimal
- real / double -> double
[x] #9281
[x] #7559
[x] #7647
covar_pop / covar_samp
corr
regr_avgx / regr_avgy / regr_count / regr_intercept / regr_r2 / regr_slope / regr_sxx / regr_sxy / regr_syy

Set Returning Functions

[x] generate_series(start, stop [, step]) for int / bigint / numeric #8826

Impure

random / setseed

github-actions[bot] commented 3 months ago

This issue has been open for 60 days with no activity.

If you think it is still relevant today, and needs to be done in the near future, you can comment to update the status, or just manually remove the no-issue-activity label.

You can also confidently close this issue as not planned to keep our backlog clean. Don't worry if you think the issue is still valuable to continue in the future. It's searchable and can be reopened when it's time. 😄