yeyudefeng opened a new issue, #17981: URL: https://github.com/apache/doris/issues/17981
### Search before asking - [X] I had searched in the [issues](https://github.com/apache/doris/issues?q=is%3Aissue) and found no similar issues. ### Version Initially, my version was 1.5, and then I upgraded to 1.2.1 Git : file://d5e4c4d78ca4@Unknown Version : doris-1.2.1-rc01 BuildInfo : d5e4c4d78ca4 BuildTime : Thu, 12 Jan 2023 08:56:16 UTC ### What's Wrong? When I learned Doris SQL, I found that the SQL query results were inconsistent with those displayed on the official website sql from the official website : https://doris.incubator.apache.org/zh-CN/docs/dev/sql-manual/sql-functions/table-functions/explode-json-array select k1, e1 from example1 lateral view explode_json_array_int('[1,"b",3]') tmp1 as e1 order by k1, e1; +------+------+ | k1 | e1 | +------+------+ | 1 | 1 | | 1 | 3 | | 2 | 1 | | 2 | 3 | | 3 | 1 | | 3 | 3 | +------+------+ No null in query results. However, the query results for the same SQL on the machine are as follows +------+------+ | k1 | e1 | +------+------+ | 1 | NULL | | 1 | 1 | | 1 | 3 | | 2 | NULL | | 2 | 1 | | 2 | 3 | | 3 | NULL | | 3 | 1 | | 3 | 3 | | 4 | NULL | | 4 | 1 | | 4 | 3 | | 5 | NULL | | 5 | 1 | | 5 | 3 | | 6 | NULL | | 6 | 1 | | 6 | 3 | +------+------+ The query result contains null. It seems that there are similar problems with several other SQL statements on this page of the official website. My confusion is which side of the result is wrong? ### What You Expected? My confusion is which side of the result is wrong? ### How to Reproduce? _No response_ ### Anything Else? _No response_ ### Are you willing to submit PR? - [X] Yes I am willing to submit a PR! ### Code of Conduct - [X] I agree to follow this project's [Code of Conduct](https://www.apache.org/foundation/policies/conduct) -- 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: commits-unsubscr...@doris.apache.org.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
