eldenmoon opened a new issue, #10497: URL: https://github.com/apache/doris/issues/10497
### Search before asking - [X] I had searched in the [issues](https://github.com/apache/incubator-doris/issues?q=is%3Aissue) and found no similar issues. ### Description ``` mysql> create table test_array_string (k1 INT, k2 INT, k3 array<string>) ENGINE=olap DUPLICATE KEY(k1, k2) PARTITION BY RANGE (k1) (partition `p1` values less than ("1000"), partition `p2` values less than ("2000"),partition `p3` values less than ("3000")) DISTRIBUTED BY HASH(k2) BUCKETS 3 PROPERTIES("replication_num" = "1"); mysql> insert into test_array_string values(1, 2, ["a", "b", "c"]),(1, 2, ["a", "b"]),(1, 2, ["a", "xxqwdqw", "c"]),(1, 2, ["a", "b"]),(1, 2, ["a", "b", "c"]),(1, 2, ["a", "b", "c"]),(1, 2, ["a", "b", "c"]),(1, 2, ["a", "b"]),(1, 2, ["a", "b", "c", "d", "e"]),(1, 2, ["a", "b", "c"]), (1, 2, ["a", "b", "cdsdasd"]),(1, 2, [ "nishidabenzhu123"]),(1, 2, ["a", "b", "c"]),(1, 2, ["a", "b", "c", "d", "e", "f", "g", "h", "i", "j"]), (1, 2, ["a", "cdsdasd"]), (1, 2, ["cdsdasd", "xxxx", "3", "4", "5"]); mysql> select k3 from test_array_string order by k1 limit 1; +------------------------------+ | k3 | +------------------------------+ | [cdsdasd, xxxx, 3, 4, 5] | +------------------------------+ 1 row in set (0.01 sec) mysql> set enable_vectorized_engine = false; Query OK, 0 rows affected (0.00 sec) mysql> select k3 from test_array_string order by k2 limit 1; +----------------------------------------+ | k3 | +----------------------------------------+ | ['cdsdasd', 'xxxx', '3', '4', '5'] | +----------------------------------------+ 1 row in set (0.01 sec) ``` if enable_vectorized_engine = true, the output of nested type of string will not be wrapped with '' eg. cdsdasd, the behavior is not the same with none vectorized eg 'cdsdasd' ### Solution wrap the string nested type of array with '' ### 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
