[#740 state:resolved] The insert ignore and unique index did not factor in grade or principal so these records were being silently dropped.   I needed to switch the order to get the test to fail.