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-unsubscr...@doris.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
