Skip to content

placement rule info not show the SURVIVAL_PREFERENCES #51699

@aytrack

Description

@aytrack

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

CREATE PLACEMENT POLICY singleaz CONSTRAINTS="[+region=us-east-1]" SURVIVAL_PREFERENCES="[zone]";
SHOW CREATE PLACEMENT POLICY singleaz;

2. What did you expect to see? (Required)

show placement policy have the SURVIVAL_PREFERENCES info

3. What did you see instead (Required)

[15:28:39]TiDB root:(none)> CREATE PLACEMENT POLICY singleaz CONSTRAINTS="[+region=us-east-1]" SURVIVAL_PREFERENCES="[zone]";
Query OK, 0 rows affected
Time: 0.031s
[15:29:06]TiDB root:(none)> SHOW CREATE PLACEMENT POLICY singleaz;
+----------+----------------------------------------------------------------------+
| Policy   | Create Policy                                                        |
+----------+----------------------------------------------------------------------+
| singleaz | CREATE PLACEMENT POLICY `singleaz` CONSTRAINTS="[+region=us-east-1]" |
+----------+----------------------------------------------------------------------+
1 row in set
Time: 0.003s
[15:29:06]TiDB root:(none)>

4. What is your TiDB version? (Required)

[16:04:00]TiDB root:(none)> select tidb_version();
+-----------------------------------------------------------+
| tidb_version()                                            |
+-----------------------------------------------------------+
| Release Version: v8.0.0-alpha-357-g1d24b1caf2             |
| Edition: Community                                        |
| Git Commit Hash: 1d24b1caf2f616de1946b5d66fcd51b173655daf |
| Git Branch: HEAD                                          |
| UTC Build Time: 2024-03-01 02:49:23                       |
| GoVersion: go1.21.6                                       |
| Race Enabled: false                                       |
| Check Table Before Drop: false                            |
| Store: unistore                                           |
+-----------------------------------------------------------+

Metadata

Metadata

Assignees

Labels

affects-7.1This bug affects the 7.1.x(LTS) versions.affects-7.5This bug affects the 7.5.x(LTS) versions.report/communityThe community has encountered this bug.severity/moderatesig/sql-infraSIG: SQL Infratype/bugThe issue is confirmed as a bug.

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions