[GH-ISSUE #91] The sql generated for indexes is incorrect. #61

New issue

Open

opened 2026-02-25 21:33:10 +03:00 by kerem · 1 comment

kerem commented

2026-02-25 21:33:10 +03:00

Owner

Originally created by @jianwubayiba on GitHub (Apr 12, 2019).
Original GitHub issue: https://github.com/DBDiff/DBDiff/issues/91

example:
ALTER TABLE logsDROP INDEXid; ALTER TABLE logs ADD PRIMARY KEY (id) USING BTREE;

But the index are both in server1 and 2,why it shown in the sql file?

Originally created by @jianwubayiba on GitHub (Apr 12, 2019). Original GitHub issue: https://github.com/DBDiff/DBDiff/issues/91 example: `ALTER TABLE `logs` DROP INDEX `id`; ALTER TABLE `logs` ADD PRIMARY KEY (`id`) USING BTREE;` But the index are both in server1 and 2,why it shown in the sql file?

kerem commented

2026-02-25 21:33:10 +03:00

Author

Owner

@raducumbogdan commented on GitHub (Aug 3, 2021):

Bump, have the same issue, and not just for the "id" but for other indexes as well.
The script generates alters to delete and create same indexes.

@raducumbogdan commented on GitHub (Aug 3, 2021): Bump, have the same issue, and not just for the "id" but for other indexes as well. The script generates alters to delete and create same indexes.