sql-tests.testcases.string_functions.checkStringFunctionsRegistered.result Maven / Gradle / Ivy
-- delimiter: |; ignoreOrder: true; ignoreExcessRows: true; trimValues:true
chr | varchar(1) | bigint | scalar | true | convert Unicode code point to a string | false | true | false | |
concat | varchar | varchar | scalar | true | concatenates given strings | true | true | false | |
length | bigint | varchar(x) | scalar | true | count of code points of the given string | false | true | false | |
lower | varchar(x)| varchar(x)| scalar | true | converts the string to lower case | false | true | false | |
ltrim | varchar(x)| varchar(x)| scalar | true | removes whitespace from the beginning of a string | false | true | false | |
replace | varchar(x) | varchar(x), varchar(y) | scalar | true | greedily removes occurrences of a pattern in a string | false | true | false | |
replace | varchar(u) | varchar(x), varchar(y), varchar(z) | scalar | true | greedily replaces occurrences of a pattern with a string | false | true | false | |
reverse | varchar(x) | varchar(x) | scalar | true | reverse all code points in a given string | false | true | false | |
rtrim | varchar(x) | varchar(x) | scalar | true | removes whitespace from the end of a string | false | true | false | |
split | array(varchar(x)) | varchar(x), varchar(y) | scalar | true | | false | true | false | |
split | array(varchar(x)) | varchar(x), varchar(y), bigint | scalar | true | | false | true | false | |
split_part | varchar(x) | varchar(x), varchar(y), bigint | scalar | true | splits a string by a delimiter and returns the specified field (counting from one) | false | true | false | |
strpos | bigint | varchar(x), varchar(y) | scalar | true | returns index of first occurrence of a substring (or 0 if not found) | false | true | false | |
strpos | bigint | varchar(x), varchar(y), bigint | scalar | true | returns index of n-th occurrence of a substring (or 0 if not found) | false | true | false | |
strrpos | bigint | varchar(x), varchar(y) | scalar | true | returns index of last occurrence of a substring (or 0 if not found) | false | true | false | |
strrpos | bigint | varchar(x), varchar(y), bigint | scalar | true | returns index of n-th occurrence of a substring from the end of the string (or 0 if not found) | false | true | false | |
substr | varchar(x) | varchar(x), bigint | scalar | true | suffix starting at given index | false | true | false | |
substr | varchar(x) | varchar(x), bigint, bigint | scalar | true | substring of given length starting at an index | false | true | false | |
trim | varchar(x) | varchar(x) | scalar | true | removes whitespace from the beginning and end of a string | false | true | false | |
upper | varchar(x) | varchar(x) | scalar | true | converts the string to upper case | false | true | false | |