Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Change EXPLAIN operatorInfo to use ; separator #20520

Open
ghost opened this issue Oct 19, 2020 · 1 comment
Open

Change EXPLAIN operatorInfo to use ; separator #20520

ghost opened this issue Oct 19, 2020 · 1 comment
Assignees
Labels
good first issue Denotes an issue ready for a new contributor, according to the "help wanted" guidelines. sig/planner SIG: Planner type/enhancement The issue or PR belongs to an enhancement.

Comments

@ghost
Copy link

ghost commented Oct 19, 2020

Development Task

This is a fork from the discussion in #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)```
@ghost ghost added type/enhancement The issue or PR belongs to an enhancement. good first issue Denotes an issue ready for a new contributor, according to the "help wanted" guidelines. sig/planner SIG: Planner hacktoberfest labels Oct 19, 2020
@rubb1sh
Copy link
Contributor

rubb1sh commented Oct 21, 2020

/assign

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
good first issue Denotes an issue ready for a new contributor, according to the "help wanted" guidelines. sig/planner SIG: Planner type/enhancement The issue or PR belongs to an enhancement.
Projects
None yet
2 participants