MySQL Forums
Forum List  »  Chinese

mtr用例main.mysql_binary_mode失败
Posted by: linfeng chen
Date: November 01, 2020 07:40PM

-INSERT INTO `A
-B` VALUES("A
+INSERT INTO `A
+B` VALUES("A
B");
-SELECT HEX(c1) FROM `A
+SELECT HEX(c1) FROM `A
B`;
HEX(c1)
410042
410D0A42

FLUSH LOGS;
-DROP TABLE `A
+DROP TABLE `A
B`;

RESET MASTER;
@@ -36,13 +36,13 @@
# In binary_mode, table name '0x410D0A42' and string '0x410042' can be
# handled correctly.
RESET MASTER;
-SELECT HEX(c1) FROM `A
+SELECT HEX(c1) FROM `A
B`;
HEX(c1)
410042
提示显示结果不对,显示隐藏字符后,发现执行结果文件里面有^M字符,mysql版本8.0.20,centos系统。

Options: ReplyQuote


Subject
Views
Written By
Posted
mtr用例main.mysql_binary_mode失败
848
November 01, 2020 07:40PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.