mtr用例main.mysql_binary_mode失败
-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系统。
Subject
Views
Written By
Posted
mtr用例main.mysql_binary_mode失败
1182
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.