Skip to content

bug: (Primary/Secondary)Tables that contain secondary indexes cannot be synchronized from the primary database to the secondary database. #1325

@haitaoguan

Description

@haitaoguan

Have you read the Contributing Guidelines on issues?

Please confirm if bug report does NOT exists already ?

  • I confirm there is no existing issue for this

Describe the problem

###master
mysql> create table ttt(id int primary key,name varchar(10),key idx_name(name));
Query OK, 0 rows affected (0.01 sec)

mysql> show tables;
+--------------+
| Tables_in_db |
+--------------+
| ttt          |
+--------------+
1 row in set (0.00 sec)


###slave
mysql> show variables like 'sql_mode';
+---------------+----------------------------------------------------------------------------------------------+
| Variable_name | Value                                                                                        |
+---------------+----------------------------------------------------------------------------------------------+
| sql_mode      | STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION,MANDATORY_TIANMU,NO_KEY_ERROR |
+---------------+----------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)

mysql> show tables;
Empty set (0.00 sec)

Expected behavior

No response

How To Reproduce

No response

Environment

No response

Are you interested in submitting a PR to solve the problem?

  • Yes, I will!

Metadata

Metadata

Assignees

Labels

A-bugSomething isn't working

Type

No type

Projects

Status

Done

Relationships

None yet

Development

No branches or pull requests

Issue actions