You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by GitBox <gi...@apache.org> on 2022/06/29 09:09:24 UTC
[GitHub] [doris] eldenmoon opened a new issue, #10497: [Enhancement] vectorized array mysql_result_writer should wrap nested string type with ''
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-unsubscribe@doris.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
[GitHub] [doris] yiguolei closed issue #10497: [Enhancement] vectorized array mysql_result_writer should wrap nested string type with ''
Posted by GitBox <gi...@apache.org>.
yiguolei closed issue #10497: [Enhancement] vectorized array mysql_result_writer should wrap nested string type with ''
URL: https://github.com/apache/doris/issues/10497
--
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-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org