YiwenWu commented on code in PR #3669: URL: https://github.com/apache/calcite/pull/3669#discussion_r1477186458
########## site/_docs/reference.md: ########## @@ -2800,30 +2805,37 @@ In the following: | s | MAP_FROM_ARRAYS(array1, array2) | Returns a map created from an *array1* and *array2*. Note that the lengths of two arrays should be the same and calcite is using the LAST_WIN strategy | s | MAP_FROM_ENTRIES(arrayOfRows) | Returns a map created from an arrays of row with two fields. Note that the number of fields in a row must be 2. Note that calcite is using the LAST_WIN strategy | s | STR_TO_MAP(string [, stringDelimiter [, keyValueDelimiter]]) | Returns a map after splitting the *string* into key/value pairs using delimiters. Default delimiters are ',' for *stringDelimiter* and ':' for *keyValueDelimiter*. Note that calcite is using the LAST_WIN strategy -| b m p | MD5(string) | Calculates an MD5 128-bit checksum of *string* and returns it as a hex string +| b m p s | MD5(string) | Calculates an MD5 128-bit checksum of +*string* and returns it as a hex string | m | MONTHNAME(date) | Returns the name, in the connection's locale, of the month in *datetime*; for example, it returns '二月' for both DATE '2020-02-10' and TIMESTAMP '2020-02-10 10:10:10' -| o | NVL(value1, value2) | Returns *value1* if *value1* is not null, otherwise *value2* +| o s | NVL(value1, value2) | Returns *value1* if *value1* is not null, +otherwise *value2* | b | OFFSET(index) | When indexing an array, wrapping *index* in `OFFSET` returns the value at the 0-based *index*; throws error if *index* is out of bounds | b | ORDINAL(index) | Similar to `OFFSET` except *index* begins at 1 | b | PARSE_DATE(format, string) | Uses format specified by *format* to convert *string* representation of date to a DATE value | b | PARSE_DATETIME(format, string) | Uses format specified by *format* to convert *string* representation of datetime to a TIMESTAMP value | b | PARSE_TIME(format, string) | Uses format specified by *format* to convert *string* representation of time to a TIME value | b | PARSE_TIMESTAMP(format, string[, timeZone]) | Uses format specified by *format* to convert *string* representation of timestamp to a TIMESTAMP WITH LOCAL TIME ZONE value in *timeZone* | h s | PARSE_URL(urlString, partToExtract [, keyToExtract] ) | Returns the specified *partToExtract* from the *urlString*. Valid values for *partToExtract* include HOST, PATH, QUERY, REF, PROTOCOL, AUTHORITY, FILE, and USERINFO. *keyToExtract* specifies which query to extract -| b | POW(numeric1, numeric2) | Returns *numeric1* raised to the power *numeric2* +| b s | POW(numeric1, numeric2) | Returns *numeric1* raised to the power +*numeric2* Review Comment: done, IDEA automatically wraps lines -- 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: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
