pingcap/tidb

Change EXPLAIN operatorInfo to use ; separator

Open

#20,520 创建于 2020年10月19日

在 GitHub 查看
 (1 评论) (0 反应) (1 负责人)Go (6,186 fork)batch import
good first issuesig/plannertype/enhancement

仓库指标

Star
 (40,090 star)
PR 合并指标
 (平均合并 14天 4小时) (30 天内合并 346 个 PR)

描述

Development Task

This is a fork from the discussion in https://github.com/pingcap/tidb/pull/20482

Currently the operatorInfo is separated by ,, but since this character is commonly used in range(a,b), it would make it easier for automated programs to split based on a semicolon ;. i.e.

+------------------------------+----------+-----------+---------------+---------------------------------------------------+
| id                           | estRows  | task      | access object | operator info                                     |
+------------------------------+----------+-----------+---------------+---------------------------------------------------+
| HashJoin_17                  | 12487.50 | root      |               | inner join; equal:[eq(test.t2.t1_id, test.t1.id)] |
| ├─TableReader_20(Build)      | 9990.00  | root      |               | data:Selection_19                                 |
| │ └─Selection_19             | 9990.00  | cop[tikv] |               | not(isnull(test.t2.t1_id))                        |
| │   └─TableFullScan_18       | 10000.00 | cop[tikv] | table:t2      | keep order:false; stats:pseudo                    |
| └─TableReader_22(Probe)      | 10000.00 | root      |               | data:TableFullScan_21                             |
|   └─TableFullScan_21         | 10000.00 | cop[tikv] | table:t1      | keep order:false; stats:pseudo                    |
+------------------------------+----------+-----------+---------------+---------------------------------------------------+
6 rows in set (0.00 sec)```

贡献者指南