Retrieve All Partitioned Tables in TiDB

Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.

Original topic: tidb 获取所有分区表

| username: 裤衩儿飞上天

  • Issue Category:

Query results contain non-partitioned tables

  • Appearing Page:

Partitioned Table | PingCAP Documentation Center

  • Error Occurred:

The result of this SQL statement execution will contain non-partitioned tables

Related Post: tidb Get All Partitioned Tables, Questions About Official Example - :ringer_planet: TiDB Technical Issues - TiDB Q&A Community (asktug.com)

| username: 我是咖啡哥 | Original post link

Isn’t this simple? Just add a condition.

SELECT DISTINCT CONCAT(TABLE_SCHEMA,'.',TABLE_NAME)
    FROM information_schema.PARTITIONS t
    WHERE TABLE_SCHEMA NOT IN ('INFORMATION_SCHEMA','mysql','sys','PERFORMANCE_SCHEMA','METRICS_SCHEMA')
    AND partition_name IS NOT NULL;
| username: 裤衩儿飞上天 | Original post link

Hmm, this is mainly to report a documentation error.

| username: Billmay表妹 | Original post link

Got it~ The issue has been reported~ I’ll CC you when there’s progress.

| username: Billmay表妹 | Original post link

PR: partitioned-table: fix a command by ran-huang · Pull Request #13420 · pingcap/docs-cn · GitHub

The related issue has been addressed in the PR. You can check the progress at the PR link.

| username: 裤衩儿飞上天 | Original post link

:+1: :+1: :+1:

| username: system | Original post link

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.