zclllyybb opened a new issue, #45530: URL: https://github.com/apache/doris/issues/45530
### Search before asking - [X] I had searched in the [issues](https://github.com/apache/doris/issues?q=is%3Aissue) and found no similar issues. ### Description we need implement the functions [compress](https://dev.mysql.com/doc/refman/8.4/en/encryption-functions.html#function_compress) and [uncompress](https://dev.mysql.com/doc/refman/8.4/en/encryption-functions.html#function_uncompress) just like mysql did. ### Solution To support a function, we need: function implementation and registration in BE. the utils `be/src/util/block_compression.cpp#ZlibBlockCompression` may be very useful. we could only support `String->String` singature. so you could encode the `ColumnString` to `Slice` and use the util to compress it. vice versa. function signature and visitor for nereids planner in FE the constant fold implementation in FE, behave just same with it in BE, like functions/executable/NumericArithmetic.java in https://github.com/apache/doris/pull/40744/files another function docs pr in https://github.com/apache/doris-website you can reference pr like https://github.com/apache/doris/pull/33005/files and ATTN! we must have enough testcases, like what https://github.com/apache/doris/pull/40462/files did. ### Are you willing to submit PR? - [ ] Yes I am willing to submit a PR! ### Code of Conduct - [X] I agree to follow this project's [Code of Conduct](https://www.apache.org/foundation/policies/conduct) -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org