[GitHub] [flink] hanyuzheng7 commented on a diff in pull request #22834: [FLINK-32260]-table-Add-ARRAY_SLICE-function

["hanyuzheng7 (via GitHub)" <gi...@apache.org>]

hanyuzheng7 commented on code in PR #22834:
URL: https://github.com/apache/flink/pull/22834#discussion_r1243947905


##########
docs/data/sql_functions.yml:
##########
@@ -643,6 +643,9 @@ collection:
   - sql: ARRAY_REVERSE(haystack)
     table: haystack.arrayReverse()
     description: Returns an array in reverse order. If the array itself is null, the function will return null.
+  - sql: ARRAY_SLICE(array, start, length)
+    table: array.arraySlice(start, length)
+    description: Returns an array that is a subset of array, extracted based on the specified start index and length. Supports both positive and negative indices. Positive indices start from 1 (the first element) while negative indices start from the end of the array (-1 being the last element). If array, or start or length are null, null is returned. If the length exceeds the available elements starting from the start index, all elements till the end of the array are returned. If abs(start) is greater than the length of the array or start equal to 0 or length is smaller than 0 or equal to 0, return null.

Review Comment:
   Ok, let me  change behavior of the function.



-- 
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: issues-unsubscribe@flink.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org