This is an automated email from the ASF dual-hosted git repository. yiguolei pushed a commit to branch master in repository https://gitbox.apache.org/repos/asf/doris.git
The following commit(s) were added to refs/heads/master by this push: new 672d3b8334 [Document](function) update document of to_base64/from_base64 #14487 672d3b8334 is described below commit 672d3b8334e4631955bea9e89dc0b08c6406628a Author: Pxl <pxl...@qq.com> AuthorDate: Wed Nov 23 14:04:53 2022 +0800 [Document](function) update document of to_base64/from_base64 #14487 --- .../sql-functions/string-functions/from_base64.md | 54 ++++++++++++++++++++++ .../sql-functions/string-functions/to_base64.md | 54 ++++++++++++++++++++++ docs/sidebars.json | 2 + .../sql-functions/string-functions/from_base64.md | 54 ++++++++++++++++++++++ .../sql-functions/string-functions/to_base64.md | 54 ++++++++++++++++++++++ 5 files changed, 218 insertions(+) diff --git a/docs/en/docs/sql-manual/sql-functions/string-functions/from_base64.md b/docs/en/docs/sql-manual/sql-functions/string-functions/from_base64.md new file mode 100644 index 0000000000..0df1a539ac --- /dev/null +++ b/docs/en/docs/sql-manual/sql-functions/string-functions/from_base64.md @@ -0,0 +1,54 @@ +--- +{ + "title": "from_base64", + "language": "en" +} +--- + +<!-- +Licensed to the Apache Software Foundation (ASF) under one +or more contributor license agreements. See the NOTICE file +distributed with this work for additional information +regarding copyright ownership. The ASF licenses this file +to you under the Apache License, Version 2.0 (the +"License"); you may not use this file except in compliance +with the License. You may obtain a copy of the License at + + http://www.apache.org/licenses/LICENSE-2.0 + +Unless required by applicable law or agreed to in writing, +software distributed under the License is distributed on an +"AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY +KIND, either express or implied. See the License for the +specific language governing permissions and limitations +under the License. +--> + +## from_base64 +### description +#### Syntax + +`VARCHAR from_base64(VARCHAR str)` + + +Returns the result of Base64 decoding the input string + +### example + +``` +mysql> select from_base64('MQ=='); ++---------------------+ +| from_base64('MQ==') | ++---------------------+ +| 1 | ++---------------------+ + +mysql> select from_base64('MjM0'); ++---------------------+ +| from_base64('MjM0') | ++---------------------+ +| 234 | ++---------------------+ +``` +### keywords + from_base64 diff --git a/docs/en/docs/sql-manual/sql-functions/string-functions/to_base64.md b/docs/en/docs/sql-manual/sql-functions/string-functions/to_base64.md new file mode 100644 index 0000000000..a9cf4b4c71 --- /dev/null +++ b/docs/en/docs/sql-manual/sql-functions/string-functions/to_base64.md @@ -0,0 +1,54 @@ +--- +{ + "title": "to_base64", + "language": "en" +} +--- + +<!-- +Licensed to the Apache Software Foundation (ASF) under one +or more contributor license agreements. See the NOTICE file +distributed with this work for additional information +regarding copyright ownership. The ASF licenses this file +to you under the Apache License, Version 2.0 (the +"License"); you may not use this file except in compliance +with the License. You may obtain a copy of the License at + + http://www.apache.org/licenses/LICENSE-2.0 + +Unless required by applicable law or agreed to in writing, +software distributed under the License is distributed on an +"AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY +KIND, either express or implied. See the License for the +specific language governing permissions and limitations +under the License. +--> + +## to_base64 +### description +#### Syntax + +`VARCHAR to_base64(VARCHAR str)` + + +Returns the result of Base64 encoding the input string + +### example + +``` +mysql> select to_base64('1'); ++----------------+ +| to_base64('1') | ++----------------+ +| MQ== | ++----------------+ + +mysql> select to_base64('234'); ++------------------+ +| to_base64('234') | ++------------------+ +| MjM0 | ++------------------+ +``` +### keywords + to_base64 diff --git a/docs/sidebars.json b/docs/sidebars.json index d5d4b17ea3..535b5cbc5e 100644 --- a/docs/sidebars.json +++ b/docs/sidebars.json @@ -359,6 +359,8 @@ "type": "category", "label": "String Functions", "items": [ + "sql-manual/sql-functions/string-functions/to_base64", + "sql-manual/sql-functions/string-functions/from_base64", "sql-manual/sql-functions/string-functions/ascii", "sql-manual/sql-functions/string-functions/length", "sql-manual/sql-functions/string-functions/bit_length", diff --git a/docs/zh-CN/docs/sql-manual/sql-functions/string-functions/from_base64.md b/docs/zh-CN/docs/sql-manual/sql-functions/string-functions/from_base64.md new file mode 100644 index 0000000000..4758cdd2c6 --- /dev/null +++ b/docs/zh-CN/docs/sql-manual/sql-functions/string-functions/from_base64.md @@ -0,0 +1,54 @@ +--- +{ + "title": "from_base64", + "language": "zh-CN" +} +--- + +<!-- +Licensed to the Apache Software Foundation (ASF) under one +or more contributor license agreements. See the NOTICE file +distributed with this work for additional information +regarding copyright ownership. The ASF licenses this file +to you under the Apache License, Version 2.0 (the +"License"); you may not use this file except in compliance +with the License. You may obtain a copy of the License at + + http://www.apache.org/licenses/LICENSE-2.0 + +Unless required by applicable law or agreed to in writing, +software distributed under the License is distributed on an +"AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY +KIND, either express or implied. See the License for the +specific language governing permissions and limitations +under the License. +--> + +## from_base64 +### description +#### Syntax + +`VARCHAR from_base64(VARCHAR str)` + + +返回对输入的字符串进行Base64解码后的结果 + +### example + +``` +mysql> select from_base64('MQ=='); ++---------------------+ +| from_base64('MQ==') | ++---------------------+ +| 1 | ++---------------------+ + +mysql> select from_base64('MjM0'); ++---------------------+ +| from_base64('MjM0') | ++---------------------+ +| 234 | ++---------------------+ +``` +### keywords + from_base64 diff --git a/docs/zh-CN/docs/sql-manual/sql-functions/string-functions/to_base64.md b/docs/zh-CN/docs/sql-manual/sql-functions/string-functions/to_base64.md new file mode 100644 index 0000000000..56805ae86a --- /dev/null +++ b/docs/zh-CN/docs/sql-manual/sql-functions/string-functions/to_base64.md @@ -0,0 +1,54 @@ +--- +{ + "title": "to_base64", + "language": "zh-CN" +} +--- + +<!-- +Licensed to the Apache Software Foundation (ASF) under one +or more contributor license agreements. See the NOTICE file +distributed with this work for additional information +regarding copyright ownership. The ASF licenses this file +to you under the Apache License, Version 2.0 (the +"License"); you may not use this file except in compliance +with the License. You may obtain a copy of the License at + + http://www.apache.org/licenses/LICENSE-2.0 + +Unless required by applicable law or agreed to in writing, +software distributed under the License is distributed on an +"AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY +KIND, either express or implied. See the License for the +specific language governing permissions and limitations +under the License. +--> + +## to_base64 +### description +#### Syntax + +`VARCHAR to_base64(VARCHAR str)` + + +返回对输入的字符串进行Base64编码后的结果 + +### example + +``` +mysql> select to_base64('1'); ++----------------+ +| to_base64('1') | ++----------------+ +| MQ== | ++----------------+ + +mysql> select to_base64('234'); ++------------------+ +| to_base64('234') | ++------------------+ +| MjM0 | ++------------------+ +``` +### keywords + to_base64 --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org