Skip Menu |

This queue is for tickets about the SQL-Translator CPAN distribution.

Report information
The Basics
Id: 35394
Status: new
Priority: 0/
Queue: SQL-Translator

People
Owner: Nobody in particular
Requestors: chris+rt [...] chrisdolan.net
Cc:
AdminCc:

Bug Information
Severity: Unimportant
Broken in: 0.09000
Fixed in: (no value)



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;