DDL RowsAffected is not correct?

Description

Bug Report

TiDB Always return 0 Rows Affected in DDL.

1. What did you do? If possible, provide a recipe for reproducing the error.

create database rrrr;
use rrrr;
create table r (i int);
drop database rrrr;

2. What did you expect to see?

In Mysql 8.0.16

mysql> create database rrrr;
Query OK, 1 row affected (0.03 sec)

mysql> use rrrr;
Database changed
mysql> create table r (i int);
Query OK, 0 rows affected (0.06 sec)

mysql> drop database rrrr;
Query OK, 1 row affected (0.04 sec)

3. What did you see instead?

In TiDB

mysql> create database rrrr;
Query OK, 0 rows affected (0.18 sec)

mysql> use rrrr;
Database changed
mysql> create table r (i int);
Query OK, 0 rows affected (0.18 sec)

mysql> drop database rrrr;
Query OK, 0 rows affected (0.36 sec)

4. What version of TiDB are you using (tidb-server -V or run select tidb_version(); on TiDB)?

mysql> select tidb_version();
+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| tidb_version()                                                                                                                                                                                                                                                                                                      |
+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Release Version: v3.0.4-17-g0607ada6ca
Git Commit Hash: 0607ada6cab0bf72a82aaf754813fbbb423115ee
Git Branch: HEAD
UTC Build Time: 2019-10-12 06:34:41
GoVersion: go version go1.13 linux/amd64
Race Enabled: false
TiKV Min Version: v3.0.0-60965b006877ca7234adaced7890d7b029ed1306
Check Table Before Drop: false |
+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)

SIG slack channel

#sig-exec

Score

• 900

Mentor

• @lzmhhh123