boluor opened a new issue, #3889: URL: https://github.com/apache/doris-website/issues/3889
On the `EXPLODE_SPLIT` page (`table-functions/explode-split.md`, version-3.x and version-2.1), one example shows an output that contradicts its own `ORDER BY`: ```sql select k1, e1 from example1 lateral view explode_split(k2, ,) tmp1 as e1 where k1 = 5 order by k1, e1; ``` ```text +------+------+ | k1 | e1 | +------+------+ | 5 | 2 | | 5 | 3 | | 5 | 1 | +------+------+ ``` `k2` for `k1 = 5` is `1,2,3`, so `explode_split` yields `1, 2, 3`. With `ORDER BY k1, e1` the rows must come back sorted by `e1` — i.e. `1, 2, 3` — which is exactly what the current engine returns (3.1.4 and 2.1.11). The documented order `2, 3, 1` is not sorted and cannot be produced by the shown query. Suggested fix — update the expected output to the sorted order: ```text | 5 | 1 | | 5 | 2 | | 5 | 3 | ``` Filing separately from the missing `example1` setup for this page (handled in a Line-B setup PR); all other examples on the page reproduce correctly. -- 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] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
