hhniao opened a new issue #8194:
URL: https://github.com/apache/shardingsphere/issues/8194
这是我的docker-compose.yml文件主要内容
version: '3'
services:
mysql:
image: "mysql:5.7.30"
proxy:
image: "apache/sharding-proxy:4.1.1"
下面这条写入语句, 包含一个emoji字符. 导致写入失败
INSERT INTO `sharding_db`.`t_order` ( `id`, `title`, `user_id`,
`order_id`, `amount`, `actual_amount`, `items_count`, `total_weight`,
`order_status`, `status`, `remark`, `created_at`, `updated_at` ) VALUES ( 5,
'😊Smiling Face with Smiling Eyes', 1, 3, 1, 1, 1, 1, 1, 1, '水电费', '2020-11-17
20:20:18', '2020-11-17 20:20:21' );
// 给出了一个看不明白的错误提示
1064 - You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near ')'
at line 1
下面这条语句不包含emoji字符, 写入成功
INSERT INTO `sharding_db`.`t_order` ( `id`, `title`, `user_id`,
`order_id`, `amount`, `actual_amount`, `items_count`, `total_weight`,
`order_status`, `status`, `remark`, `created_at`, `updated_at` ) VALUES ( 5,
'Smiling Face with Smiling Eyes', 1, 4, 1, 1, 1, 1, 1, 1, '水电费', '2020-11-17
20:20:18', '2020-11-17 20:20:21' );
下面这条更新语句, 包含一个emoji字符, 更新无任何问题, 更新成功
UPDATE `sharding_db`.`t_order` SET `title` = '水电费水电费😊' WHERE `id` = 4
----------------------------------------------------------------
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.
For queries about this service, please contact Infrastructure at:
[email protected]
