Dropping and readding constraints generates schema diff

[CaptainStabs]

1. Dropped constraint

us_housing_prices> ALTER TABLE `sales` DROP CONSTRAINT extra_spaces_removed;

2. Readded constraint (no changes to schema)

3. Generated diff
   dolt diff --limit 5

Schema diff generated

Interestingly, dolthub showed no changes to the schema

[timsehn]

Can't repro:

mysql> create table t (pk int primary key, check (pk > 3));
Query OK, 0 rows affected (0.01 sec)

mysql> call dolt_add('t');
+--------+
| status |
+--------+
|      0 |
+--------+
1 row in set (0.00 sec)

mysql> call dolt_commit('-m', 'Added table');
+----------------------------------+
| hash                             |
+----------------------------------+
| ko6m98822gl80i5qnj7e92koq1t0nil9 |
+----------------------------------+
1 row in set (0.00 sec)

mysql> show create table t;
+-------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Table | Create Table                                                                                                                                                                  |
+-------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| t     | CREATE TABLE `t` (
  `pk` int NOT NULL,
  PRIMARY KEY (`pk`),
  CONSTRAINT `chk_3quoua1t` CHECK ((`pk` > 3))
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_bin |
+-------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)

mysql> alter table t drop constraint chk_3quoua1t;
Query OK, 0 rows affected (0.00 sec)

mysql> select * from dolt_status;
+------------+--------+----------+
| table_name | staged | status   |
+------------+--------+----------+
| t          |      0 | modified |
+------------+--------+----------+
1 row in set (0.00 sec)

mysql> alter table t add constraint CHECK (`pk` > 3);
Query OK, 0 rows affected (0.00 sec)

mysql> select * from dolt_status;
Empty set (0.00 sec)

You have to make sure you named and defined the constraint exactly.