Does the error "Table 'information_schema.KEYWORDS' doesn't exist" indicate that TiDB is missing this table?

Translated
1

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

Original topic: Table ‘information_schema.KEYWORDS’ doesn’t exist，请问下这是因为tidb缺少这张表吗？

| username: 突破边界

To improve efficiency, please provide the following information. A clear problem description can lead to a quicker resolution:

[Overview] Introducing the Flowable framework, it seems to use Liquibase internally, and the following error is prompted during startup:

java.sql.SQLSyntaxErrorException: Table 'information_schema.KEYWORDS' doesn't exist

[Application Framework and Business Logic Adaptation]
Spring Boot framework, introducing the Flowable process engine

[Business Impact] Application startup failure

[TiDB Version] 7.5.0

2
| username: 突破边界 | Original post link

Upgrading to 7.6.0 resolved it.

3
| username: 啦啦啦啦啦 | Original post link

Changing the version from 7.5 to 8.0.11-TiDB-v7.5.1 directly by modifying the version is also fine.

image
image1062×186 14.7 KB

4
| username: DBAER | Original post link

There is a similar case in the community, you can try it out. I copied someone else’s:

   <dependency>
        <groupId>mysql</groupId>
        <artifactId>mysql-connector-java</artifactId>
        <version>8.0.32</version>
    </dependency>

Replace the driver with

    <dependency>
        <groupId>mysql</groupId>
        <artifactId>mysql-connector-java</artifactId>
        <version>5.1.47</version>
    </dependency>

The program returned to normal. I also did not find the KEYWORDS table in the MySQL 5.7 database. This should be an issue with the MySQL 8 driver. Although the 8.0 driver can adapt to MySQL 5.7, it seems it cannot adapt to TiDB.

5
| username: 小于同学 | Original post link

Upgrade version

6
| username: TiDBer_H5NdJb5Q | Original post link

Thank you, OP, I learned a lot.

7
| username: TiDBer_QYr0vohO | Original post link

Upgrade version