This repository was archived by the owner on Jul 24, 2024. It is now read-only.
This repository was archived by the owner on Jul 24, 2024. It is now read-only.
BR full restore won't rebase auto_random counter #241
Description
Please answer these questions before submitting your issue. Thanks!
-
What did you do?
If possible, provide a recipe for reproducing the error.
BR didn't rebase auto_random after restore- set tidb config
auto_randomto true. create table t(a int key auto_random); insert into t values (), (), ();br backup table --db t --table t --pd xxx -s xxxdrop table tbr restore table --db t --table t --pd xxx -s xxxinsert into t values (),(),();
- set tidb config
before backup:
MySQL [t]> select a & b'0000011111111111111111111111111' from t.t;
+----------------------------------------+
| a & b'0000011111111111111111111111111' |
+----------------------------------------+
| 1 |
| 2 |
| 3 |
+----------------------------------------+
- What did you expect to see?
after restore:
select a & b'0000011111111111111111111111111' from t.t;
+----------------------------------------+
| a & b'0000011111111111111111111111111' |
+----------------------------------------+
| 4 |
| 5 |
| 6 |
| 1 |
| 2 |
| 3 |
+----------------------------------------+
- What did you see instead?
after restore:
select a & b'0000011111111111111111111111111' from t.t;
+----------------------------------------+
| a & b'0000011111111111111111111111111' |
+----------------------------------------+
| 1 |
| 2 |
| 3 |
| 1 |
| 2 |
| 3 |
+----------------------------------------+
- What version of BR and TiDB/TiKV/PD are you using?
master