Subject: | diff false positive due to case sensitivity of FK action |
I have two SQL files with these two foreign key declarations:
CONSTRAINT instrument_question_fk_2 FOREIGN KEY (`parentquestion_id`)
REFERENCES `instrument_question` (`id`) ON DELETE set null,
vs.
CONSTRAINT instrument_question_fk_2 FOREIGN KEY (`parentquestion_id`)
REFERENCES `instrument_question` (`id`) ON DELETE SET NULL
The only difference is that the trailing "set null" is upper case in one
and lower case in the other. Running "sqlt-diff --case-insensitive" on
them, I get the following false positive:
ALTER TABLE instrument_question DROP FOREIGN KEY instrument_question_fk_2,
ADD CONSTRAINT instrument_question_fk_2
FOREIGN KEY (parentquestion_id) REFERENCES instrument_question (id) ON
DELETE set null;