不指定访问路径生成的执行计划中有乱码

不指定访问路径方式生成的执行计划为啥有乱码?

EXPLAIN SELECT * FROM `teacher` WHERE `email` like 'zhang%';

输出结果如下:

obclient [testdb]> EXPLAIN SELECT * FROM `teacher` WHERE `email` like 'zhang%';
+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Query Plan                                                                                                                                                                                                      |
+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| =====================================================================                                                                                                                                           |
| |ID|OPERATOR        |NAME                     |EST.ROWS|EST.TIME(us)|                                                                                                                                           |
| ---------------------------------------------------------------------                                                                                                                                           |
| |0 |TABLE RANGE SCAN|teacher(ux_teacher_email)|1       |7           |                                                                                                                                           |
| =====================================================================                                                                                                                                           |
| Outputs & filters:                                                                                                                                                                                              |
| -------------------------------------                                                                                                                                                                           |
|   0 - output([teacher.id], [teacher.name], [teacher.sex], [teacher.mobile_phone], [teacher.email], [teacher.create_time], [teacher.update_time]), filter(nil), rowset=16                                        |
|       access([teacher.id], [teacher.email], [teacher.name], [teacher.sex], [teacher.mobile_phone], [teacher.create_time], [teacher.update_time]), partitions(p0)                                                |
|       is_index_back=true, is_global_index=false,                                                                                                                                                                |
|       range_key([teacher.email], [teacher.shadow_pk_0]), range(zhang,MIN ; zhang�                                                                                        |
|       ���                                                                                                                                        |
|       ��,                                                                                                                                            |
|       MAX),                                                                                                                                                                                                     |
|       range_cond([(T_OP_LIKE, teacher.email, 'zhang%', '\\')])                                                                                                                                                  |
+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
15 rows in set (0.003 sec)
1 个赞

和你的客户端设置的字符集有关系吧