qidaye opened a new issue #6127:
URL: https://github.com/apache/incubator-doris/issues/6127
**Describe the bug**
`show dynamic partition tables;` ReplicationNum of the result is wrong, it's
always default (3).
**To Reproduce**
Steps to reproduce the behavior:
1. create dynamic table
```sql
CREATE TABLE `table111` (
`k1` date NULL COMMENT "",
`k2` int(11) NULL COMMENT "",
`k3` varchar(32) NULL COMMENT ""
) ENGINE=OLAP
DUPLICATE KEY(`k1`, `k2`, `k3`)
COMMENT "OLAP"
PARTITION BY RANGE(`k1`)
(PARTITION p20210627 VALUES [('2021-06-27'), ('2021-06-28')),
PARTITION p20210628 VALUES [('2021-06-28'), ('2021-06-29')),
PARTITION p20210629 VALUES [('2021-06-29'), ('2021-06-30')),
PARTITION p20210630 VALUES [('2021-06-30'), ('2021-07-01')),
PARTITION p20210701 VALUES [('2021-07-01'), ('2021-07-02')),
PARTITION p20210702 VALUES [('2021-07-02'), ('2021-07-03')),
PARTITION p20210703 VALUES [('2021-07-03'), ('2021-07-04')))
DISTRIBUTED BY HASH(`k1`) BUCKETS 10
PROPERTIES (
"replication_num" = "3",
"dynamic_partition.enable" = "true",
"dynamic_partition.time_unit" = "DAY",
"dynamic_partition.time_zone" = "Asia/Shanghai",
"dynamic_partition.start" = "-3",
"dynamic_partition.end" = "3",
"dynamic_partition.prefix" = "p",
"dynamic_partition.replication_num" = "1",
"dynamic_partition.buckets" = "16",
"dynamic_partition.create_history_partition" = "true",
"dynamic_partition.hot_partition_num" = "0",
"in_memory" = "false",
"storage_format" = "V2"
);
```
2. execute show commands
```sql
show partitions from table111;
show dynamic partition tables;
```
**Expected behavior**
The results of two commands should be the same.
But the latter command's result `ReplicationNum` is always 3, the default
value.
**Screenshots**
**Desktop (please complete the following information):**
- OS: [e.g. iOS]
- Browser [e.g. chrome, safari]
- Version [e.g. 22]
**Smartphone (please complete the following information):**
- Device: [e.g. iPhone6]
- OS: [e.g. iOS8.1]
- Browser [e.g. stock browser, safari]
- Version [e.g. 22]
**Additional context**
Add any other context about the problem here.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org
