/**
* Copyright (C) 2009-2013 FoundationDB, LLC
*
* This program is free software: you can redistribute it and/or modify
* it under the terms of the GNU Affero General Public License as published by
* the Free Software Foundation, either version 3 of the License, or
* (at your option) any later version.
*
* This program is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
* GNU Affero General Public License for more details.
*
* You should have received a copy of the GNU Affero General Public License
* along with this program. If not, see <http://www.gnu.org/licenses/>.
*/
package com.foundationdb.server.test.mt;
import com.foundationdb.qp.row.Row;
import org.junit.Test;
/** Interleaved DML during an ALTER ADD FOREIGN KEY ON UPDATE CASCADE ON DELETE SET NULL. */
public class OnlineAlterAddForeignKeyCascadeNullMT extends OnlineAlterAddForeignKeyMT
{
protected static final String ALTER_ADD_FK = "ALTER TABLE "+CHILD_TABLE+" ADD CONSTRAINT fk1 FOREIGN KEY(pid) "+
"REFERENCES "+PARENT_TABLE+"(pid) ON UPDATE CASCADE ON DELETE SET NULL";
@Override
protected String getDDL() {
return ALTER_ADD_FK;
}
// Note: Not actually violations with CASCADE or SET NULL
@Override
@Test
public void updateViolationPostMetaToPreFinal_Parent() {
Row oldRow = testRow(parentRowType, 2);
Row newRow = testRow(parentRowType, 3);
dmlViolationPostMetaToPreFinal(updateCreator(pID, oldRow, newRow),
replace(parentGroupRows, 1, newRow),
replace(childGroupRows, 1, testRow(childRowType, 20, 3)),
true);
}
@Override
@Test
public void deleteViolationPostMetaToPreFinal_Parent() {
Row oldRow = testRow(parentRowType, 2);
dmlViolationPostMetaToPreFinal(deleteCreator(pID, oldRow),
remove(parentGroupRows, 1),
replace(childGroupRows, 1, testRow(childRowType, 20, null)),
true);
}
}