Details
-
Type:
New Feature
-
Status: Resolved
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: None
-
Fix Version/s: 0.8.0
-
Component/s: Function/UDF
-
Labels:None
Description
SQL standard provides various string operators and functions:
- String concatenation ('||')
- bit_length
- char_length or
- lower
- position
- substring
- trim
- upper
We also need to include these standard functions.
1. |
Implement UPPER(text), LOWER(text) function |  |
Resolved | Hyunsik Choi | |
2. |
Implement trim(text), ltrim(text), and rtrim(text) function | |
Resolved | Hyunsik Choi | |
3. |
Implement bit_length(string) function | |
Resolved | DaeMyung Kang | |
4. |
Implement char_length(string) function | |
Resolved | Hyunsik Choi | |
5. |
Implement String concatenation operator (||) | |
Resolved | Hyunsik Choi | |
6. |
Implement hex function | |
Resolved | DaeMyung Kang | |
7. |
Implement octet_length(text) | |
Resolved | DaeMyung Kang | |
8. |
Implement md5(text) | |
Resolved | DaeMyung Kang | |
9. |
Implement reverse(text) | |
Resolved | DaeMyung Kang | |
10. |
Implement right/left(text, size) function | |
Resolved | DaeMyung Kang | |
11. |
Implement repeat(text,int) function | |
Resolved | DaeMyung Kang | |
12. |
Implement sha1(text) | |
Resolved | DaeMyung Kang | |
13. |
Implement digest(text, text) function | |
Resolved | DaeMyung Kang |
Activity
- All
- Comments
- Work Log
- History
- Activity
- Transitions
I fix this issue as resolved. We already have more than SQL standard string functions.