NobiGo commented on code in PR #4191: URL: https://github.com/apache/calcite/pull/4191#discussion_r1953644736
########## site/_docs/reference.md: ########## @@ -2915,31 +2920,19 @@ In the following: | b | LOG(numeric1 [, base ]) | Returns the logarithm of *numeric1* to base *base*, or base e if *base* is not present, or error if *numeric1* is 0 or negative | m s h | LOG([, base ], numeric1) | Returns the logarithm of *numeric1* to base *base*, or base e if *base* is not present, or null if *numeric1* is 0 or negative | p | LOG([, base ], numeric1 ) | Returns the logarithm of *numeric1* to base *base*, or base 10 if *numeric1* is not present, or error if *numeric1* is 0 or negative -| m s | LOG2(numeric) | Returns the base 2 logarithm of *numeric* | s | LOG1P(numeric) | Returns the natural logarithm of 1 plus *numeric* +| m s | LOG2(numeric) | Returns the base 2 logarithm of *numeric* | b o p r s h | LPAD(string, length [, pattern ]) | Returns a string or bytes value that consists of *string* prepended to *length* with *pattern* -| b | TO_BASE32(string) | Converts the *string* to base-32 encoded form and returns an encoded string -| b | FROM_BASE32(string) | Returns the decoded result of a base-32 *string* as a string -| m | TO_BASE64(string) | Converts the *string* to base-64 encoded form and returns a encoded string -| b m | FROM_BASE64(string) | Returns the decoded result of a base-64 *string* as a string. If the input argument is an invalid base-64 *string* the function returns `NULL` -| h | BASE64(string) | Converts the *string* to base-64 encoded form and returns a encoded string -| h | UNBASE64(string) | Returns the decoded result of a base-64 *string* as a string. If the input argument is an invalid base-64 *string* the function returns `NULL` -| h s | HEX(string) | Converts *string* into a hexadecimal varchar -| b | TO_HEX(binary) | Converts *binary* into a hexadecimal varchar -| b | FROM_HEX(varchar) | Converts a hexadecimal-encoded *varchar* into bytes -| s h | BIN(BIGINT) | Converts a *bigint* into bytes string | b o p r s h | LTRIM(string) | Returns *string* with all blanks removed from the start | s | MAP() | Returns an empty map | s | MAP(key, value [, key, value]*) | Returns a map with the given *key*/*value* pairs | s | MAP_CONCAT(map [, map]*) | Concatenates one or more maps. If any input argument is `NULL` the function returns `NULL`. Note that calcite is using the LAST_WIN strategy | s | MAP_CONTAINS_KEY(map, key) | Returns whether *map* contains *key* | s | MAP_ENTRIES(map) | Returns the entries of the *map* as an array, the order of the entries is not defined -| s | MAP_KEYS(map) | Returns the keys of the *map* as an array, the order of the entries is not defined -| s | MAP_VALUES(map) | Returns the values of the *map* as an array, the order of the entries is not defined | 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 -| s | SUBSTRING_INDEX(string, delim, count) | Returns the substring from *string* before *count* occurrences of the delimiter *delim*. If *count* is positive, everything to the left of the final delimiter (counting from the left) is returned. If *count* is negative, everything to the right of the final delimiter (counting from the right) is returned. The function substring_index performs a case-sensitive match when searching for *delim*. +| s | MAP_KEYS(map) | Returns the keys of the *map* as an array, the order of the entries is not defined +| s | MAP_VALUES(map) | Returns the values of the *map* as an array, the order of the entries is not defined | b m p r s h | MD5(string) | Calculates an MD5 128-bit checksum of *string* and returns it as a hex string Review Comment: I hope `| b m p r s h |` is in alphabetical order too. -- 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]
