• Home
• com.facebook.presto
• presto-product-tests
• 0.169
• source code
• checkStringFunctionsRegistered.result

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

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 |
 concat | varchar | varchar | scalar | true | concatenates given strings |
 length | bigint | varchar(x) | scalar | true | count of code points of the given string |
 lower | varchar(x)| varchar(x)| scalar | true | converts the string to lower case |
 ltrim | varchar(x)| varchar(x)| scalar | true | removes whitespace from the beginning of a string |
 replace | varchar(x) | varchar(x), varchar(y) | scalar | true | greedily removes occurrences of a pattern in a string |
 replace | varchar(u) | varchar(x), varchar(y), varchar(z) | scalar | true | greedily replaces occurrences of a pattern with a string |
 reverse | varchar(x) | varchar(x) | scalar | true | reverse all code points in a given string |
 rtrim | varchar(x) | varchar(x) | scalar | true | removes whitespace from the end of a string |
 split | array(varchar(x)) | varchar(x), varchar(y) | scalar | true | |
 split | array(varchar(x)) | varchar(x), varchar(y), bigint | scalar | true | |
 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) |
 strpos | bigint | varchar(x), varchar(y) | scalar | true | returns index of first occurrence of a substring (or 0 if not found) |
 substr | varchar(x) | varchar(x), bigint | scalar | true | suffix starting at given index |
 substr | varchar(x) | varchar(x), bigint, bigint | scalar | true | substring of given length starting at an index |
 trim | varchar(x) | varchar(x) | scalar | true | removes whitespace from the beginning and end of a string |
 upper | varchar(x) | varchar(x) | scalar | true | converts the string to upper case |