bug: (Primary/Secondary)After a column is added.Data on the primary database and that on the secondary database are inconsistent.

[haitaoguan]

Have you read the Contributing Guidelines on issues?

• I have 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

create table ttt(id int primary key,name varchar(5));
insert into ttt values(1,'AAA'),(2,'BBB');
alter table ttt add column age int not null;
mysql> select * from ttt;
+----+------+-----+
| id | name | age |
+----+------+-----+
|  1 | AAA  |   0 |
|  2 | BBB  |   0 |
+----+------+-----+
2 rows in set (0.00 sec)

###slave

mysql> select * from ttt;
+----+------+-----+
| id | name | age |
+----+------+-----+
| NULL | AAA  | NULL |
| NULL | BBB  | NULL |
+----+------+-----+
2 rows in set (0.00 sec)

Expected behavior

###slave

mysql> select * from ttt;
+----+------+-----+
| id | name | age |
+----+------+-----+
|  1 | AAA  |   0 |
|  2 | BBB  |   0 |
+----+------+-----+
2 rows in set (0.00 sec)

How To Reproduce

No response

Environment

./mysqld Ver 5.7.36-StoneDB for Linux on x86_64 (build-)
build information as follow:
Repository address: https://github.com/stoneatom/stonedb.git:HEAD
Branch name: HEAD
Last commit ID: b44a51c
Last commit time: Date: Fri Dec 2 16:11:06 2022 +0000
Build time: Date: Mon Dec 5 06:12:44 UTC 2022

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

• Yes, I will!

[DandreChen]

ACK

[konghaiya]

The reason for this problem should be that not null does not take effect when adding columns,
Innodb assigns a value of 0 by default, but tianmu directly assigns a value of null.
Therefore, we need to troubleshoot the problem that not null does not take effect when adding new columns.

[DandreChen]

test case without primary key：

mysql> create table ttt(id int,name varchar(5));
Query OK, 0 rows affected (0.01 sec)

mysql> insert into ttt values(1,'AAA'),(2,'BBB');
Query OK, 2 rows affected (0.00 sec)
Records: 2  Duplicates: 0  Warnings: 0

mysql> alter table ttt add column age int not null;
Query OK, 0 rows affected (0.02 sec)
Records: 0  Duplicates: 0  Warnings: 0

mysql> select * from ttt;
+------+------+-----+
| id   | name | age |
+------+------+-----+
|    1 | AAA  | NULL |
|    2 | BBB  | NULL |
+------+------+-----+
2 rows in set (0.00 sec)

[DandreChen]

the inplace method of tianmu don‘t support primary key
need support primary key

[DandreChen]

the similar to #1188