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 default value of tidb_remove_orderby_in_subquery to true #44163

Closed
elsa0520 opened this issue May 25, 2023 · 0 comments · Fixed by #44164 or pingcap/docs-cn#14045
Closed

Change default value of tidb_remove_orderby_in_subquery to true #44163

elsa0520 opened this issue May 25, 2023 · 0 comments · Fixed by #44164 or pingcap/docs-cn#14045
Labels
type/enhancement The issue or PR belongs to an enhancement.

Comments

@elsa0520
Copy link
Contributor

Enhancement

Change the default value tidb_remove_orderby_in_subquery to true.
It will not change the behaviors of upgrade cluster.
It just change the behaviors of new cluster after v7.2

Example

  1. create table
CREATE TABLE `t1` ( `a` int(11) DEFAULT NULL, `b` int(11) DEFAULT NULL, `c` int(11) DEFAULT NULL);
  1. explain query
    without order by plan node
"TableReader 10000.00 root  data:TableFullScan",
			"└─TableFullScan 10000.00 cop[tikv] table:t1 keep order:false, stats:pseudo"
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
type/enhancement The issue or PR belongs to an enhancement.
Projects
None yet
1 participant