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 2021/08/05 12:28:33 UTC
[GitHub] [incubator-doris] caiconghui opened a new issue #6385: [Optimize] Speed up converting the data of other type to string in mysql_result_writer
caiconghui opened a new issue #6385:
URL: https://github.com/apache/incubator-doris/issues/6385
now,
1. we can still improve the speed for converting the data of other type to string in mysql_result_writer
2. use decimal behave like used in mysql, for decimal_cch13 is defined as DECIMAL(10,3)
mysql> select * from test_decimal limit 3;
+------+---------------+-------+------+------+------+-------+
| id | decimal_cch13 | tat | aa | tt | c2 | c1 |
+------+---------------+-------+------+------+------+-------+
| 1 | 2.344 | 212 | 1 | 13 | 2.2 | 5.678 |
| 1 | 2.335 | 22213 | 133 | 13 | 2.32 | 5.678 |
| 1 | 2.335 | 22213 | 133 | 13 | 2.32 | 5.678 |
+------+---------------+-------+------+------+------+-------+
3 rows in set (0.01 sec)
mysql> insert into test_decimal values(1, 2, "3", 4, 6, 7);
ERROR 1058 (21S01): errCode = 2, detailMessage = Column count doesn't match value count
mysql> insert into test_decimal values(1, 2, "3", 4, 6.0, 7.0, 8.0);
Query OK, 1 row affected (0.16 sec)
{'label':'insert_2d08b9f28d344f6d-abfe2663974ce181', 'status':'VISIBLE', 'txnId':'17056'}
mysql> select * from test_decimal where c2> 5;
+------+---------------+------+------+------+------+------+
| id | decimal_cch13 | tat | aa | tt | c2 | c1 |
+------+---------------+------+------+------+------+------+
| 1 | 2.000 | 3 | 4 | 6 | 7 | 8 |
+------+---------------+------+------+------+------+------+
1 row in set (0.07 sec)
mysql>
--
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
[GitHub] [incubator-doris] caiconghui closed issue #6385: [Optimize] Speed up converting the data of other type to string in mysql_result_writer
Posted by GitBox <gi...@apache.org>.
caiconghui closed issue #6385:
URL: https://github.com/apache/incubator-doris/issues/6385
--
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