the transaction isolation #25680 – Fix the issue that the ODBC-styled constant (for example, {d '2020-01-01'}) cannot be used as the expression #25531 – Fix the issue that SELECT DISTINCT converted to Community Git Commit Hash: 689a6b6439ae7835947fcaccf329a3fc303986cb Git Branch: HEAD UTC Build Time: 2020-05-28 11:09:45 GoVersion: go1.13.4 157 Race Enabled: false TiKV Min Version: v3.0.0-60965b00687 Pos (COMMIT_TS). cat metadata Started dump at: 2020-11-10 10:40:19 SHOW MASTER STATUS: Log: tidb-binlog Pos: 420747102018863124 Finished dump at: 2020-11-10 10:40:20 3. Export the data in cluster A

SELECT * FROM t AS OF TIMESTAMP '2020-09-06 00:00:00'; START TRANSACTION READ ONLY AS OF TIMESTAMP '2020-09-06 00:00:00'; SET TRANSACTION READ ONLY as of timestamp '2020-09-06 00:00:00'; • Introduce a Community Git Commit Hash: 689a6b6439ae7835947fcaccf329a3fc303986cb Git Branch: HEAD UTC Build Time: 2020-05-28 11:09:45 GoVersion: go1.13.4 148 Race Enabled: false TiKV Min Version: v3.0.0-60965b00687 the backup operation again: • Change the directory for the backup. For example, change /dir/backup-2020-01-01/ to /dir/backup_local/. • Delete the backup directory of all TiKV nodes and BR nodes. 237

Community Git Commit Hash: 689a6b6439ae7835947fcaccf329a3fc303986cb Git Branch: HEAD UTC Build Time: 2020-05-28 11:09:45 GoVersion: go1.13.4 169 Race Enabled: false TiKV Min Version: v3.0.0-60965b00687 Pos (COMMIT_TS). cat metadata Started dump at: 2020-11-10 10:40:19 SHOW MASTER STATUS: Log: tidb-binlog Pos: 420747102018863124 Finished dump at: 2020-11-10 10:40:20 3. Export the data in cluster A the backup operation again: • Change the directory for the backup. For example, change /dir/backup-2020-01-01/ to /dir/backup_local/. • Delete the backup directory of all TiKV nodes and BR nodes. 265

Community Git Commit Hash: 689a6b6439ae7835947fcaccf329a3fc303986cb Git Branch: HEAD UTC Build Time: 2020-05-28 11:09:45 GoVersion: go1.13.4 180 Race Enabled: false TiKV Min Version: v3.0.0-60965b00687 Pos (COMMIT_TS). cat metadata Started dump at: 2020-11-10 10:40:19 SHOW MASTER STATUS: Log: tidb-binlog Pos: 420747102018863124 Finished dump at: 2020-11-10 10:40:20 3. Export the data in cluster A the backup operation again: • Change the directory for the backup. For example, change /dir/backup-2020-01-01/ to /dir/backup_local/. • Delete the backup directory of all TiKV nodes and BR nodes. 6.3

of range 错误 #23919 – 修复 tidb_snapshot 被允许设置为非预期的过大值，而可能造成事务隔离性被破坏的问题 #25680 – 修复 ODBC 类常数（例如 {d '2020-01-01'}）不能被用作表达式的问题 #25531 – 修复 SELECT DISTINCT 被转化为 Batch Get 而导致结果不正确的问题 #25320 – 修复无法触发将查询从 TiFlash Community Git Commit Hash: 689a6b6439ae7835947fcaccf329a3fc303986cb Git Branch: HEAD UTC Build Time: 2020-05-28 11:09:45 GoVersion: go1.13.4 Race Enabled: false TiKV Min Version: v3.0.0-60965b006877ca Pos (COMMIT_TS)。 cat metadata Started dump at: 2020-11-10 10:40:19 SHOW MASTER STATUS: Log: tidb-binlog Pos: 420747102018863124 Finished dump at: 2020-11-10 10:40:20 3. 将集群 A 的数据导入 B 集群。 146 5.6

· · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · 2020 14.4.12 TiDB 4.0.5 Release Notes · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · SELECT * FROM t AS OF TIMESTAMP '2020-09-06 00:00:00'; START TRANSACTION READ ONLY AS OF TIMESTAMP '2020-09-06 00:00:00'; SET TRANSACTION READ ONLY as of timestamp '2020-09-06 00:00:00'; 29 • 引入一种新的统计信息类型 Community Git Commit Hash: 689a6b6439ae7835947fcaccf329a3fc303986cb Git Branch: HEAD UTC Build Time: 2020-05-28 11:09:45 GoVersion: go1.13.4 Race Enabled: false TiKV Min Version: v3.0.0-60965b006877ca

· · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · 2020 12.13.3 查看遥测启用状态 · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · Community Git Commit Hash: 689a6b6439ae7835947fcaccf329a3fc303986cb Git Branch: HEAD UTC Build Time: 2020-05-28 11:09:45 GoVersion: go1.13.4 Race Enabled: false TiKV Min Version: v3.0.0-60965b006877ca Pos (COMMIT_TS)。 cat metadata Started dump at: 2020-11-10 10:40:19 SHOW MASTER STATUS: Log: tidb-binlog Pos: 420747102018863124 Finished dump at: 2020-11-10 10:40:20 3. 将集群 A 的数据导入 B 集群。 154 5.6

2015-11 | 7 | | 2015-4 | 8 | | 2015-8 | 9 | | 2017-11 | 10 | | 2017-5 | 11 | | 2019-5 | 13 | | 2020-2 | 14 | +---------+-------+ 13 rows in set (0.01 sec) Visualize the above data through a line chart Community Git Commit Hash: 689a6b6439ae7835947fcaccf329a3fc303986cb Git Branch: HEAD UTC Build Time: 2020-05-28 11:09:45 GoVersion: go1.13.4 609 Race Enabled: false TiKV Min Version: v3.0.0-60965b00687 the backup operation again: • Change the directory for the backup. For example, change /dir/backup-2020-01-01/ to /dir/backup_local/. • Delete the backup directory of all TiKV nodes and BR nodes. 795

Community Git Commit Hash: 689a6b6439ae7835947fcaccf329a3fc303986cb Git Branch: HEAD UTC Build Time: 2020-05-28 11:09:45 GoVersion: go1.13.4 Race Enabled: false TiKV Min Version: v3.0.0-60965b006877ca Pos (COMMIT_TS)。 cat metadata Started dump at: 2020-11-10 10:40:19 SHOW MASTER STATUS: Log: tidb-binlog Pos: 420747102018863124 Finished dump at: 2020-11-10 10:40:20 3. 将集群 A 的数据导入 B 集群。 5.3.8.2.3 already exists in /dir/backup_local/\" })" 若备份失败并出现以上错误消息，采取以下其中一种操作后再重新备份： • 更换备份数据目录。例如将 /dir/backup-2020-01-01/ 改为 /dir/backup_local/。 • 删除所有 TiKV 和 BR 节点的备份目录。 6.3.1.4 外部存储 6.3.1.4.1 外部存储 Backup & Restore

· · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · 2020 14.2.3 Titan 介绍 · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · 2015-11 | 7 | | 2015-4 | 8 | | 2015-8 | 9 | | 2017-11 | 10 | | 2017-5 | 11 | | 2019-5 | 13 | | 2020-2 | 14 | +---------+-------+ 13 rows in set (0.01 sec) 将得到的数据通过一个横轴为时间，纵轴为累计订单量的折线图进行可视化，便可以轻松地通过折线图的斜 Community Git Commit Hash: 689a6b6439ae7835947fcaccf329a3fc303986cb Git Branch: HEAD UTC Build Time: 2020-05-28 11:09:45 GoVersion: go1.13.4 Race Enabled: false TiKV Min Version: v3.0.0-60965b006877ca