docete commented on a change in pull request #9002: [FLINK-13105][table][doc]
Add documentation for blink planner's built-in functions
URL: https://github.com/apache/flink/pull/9002#discussion_r316963527
##########
File path: docs/dev/table/functions.md
##########
@@ -2689,6 +2701,177 @@ TO_BASE64(string)
<p>E.g., <code>TO_BASE64('hello world')</code> returns
"aGVsbG8gd29ybGQ=".</p>
</td>
</tr>
+
+ <tr>
+ <td>
+ {% highlight text %}
+ASCII(string)
+{% endhighlight %}
+ </td>
+ <td>
+ <p>Returns the numeric value of the first character of <i>string</i>.
Returns NULL if <i>string</i> is NULL.</p>
+ <p>Only supported in blink planner. Only supported in SQL api.</p>
+ <p>E.g., <code>ascii('abc')</code> returns 97, and
<code>ascii(CAST(NULL AS VARCHAR))</code> returns NULL.</p>
+ </td>
+ </tr>
+
+ <tr>
+ <td>
+ {% highlight text %}
+CHR(integer)
+{% endhighlight %}
+ </td>
+ <td>
+ <p>Returns the ASCII character having the binary equivalent to
<i>integer</i>. If <i>integer</i> is larger than 255 the result is equivalent
to chr(bitand(integer,256). Returns NULL if <i>integer</i> is NULL.</p>
Review comment:
Make sense, will fix it soon.
----------------------------------------------------------------
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.
For queries about this service, please contact Infrastructure at:
[email protected]
With regards,
Apache Git Services
