public void SetNullOnUpdateConstraintCheck()
{
var query = CreateQuery(CreateAdminSession(Database));
var tableName = ObjectName.Parse("APP.test_table");
var expr = SqlExpression.Parse("first_name = 'Jane' AND last_name = 'Doe'");
var count = query.Update(tableName, expr, new [] {
new SqlColumnAssignment("id", SqlExpression.Constant(10))
});
query.Commit();
Assert.AreEqual(1, count);
query = CreateQuery(CreateAdminSession(Database));
var linkedTable = query.Access().GetTable(ObjectName.Parse("APP.test_table2"));
var rows = linkedTable.GetIndex(0).SelectEqual(Field.Integer(1));
var value = linkedTable.GetValue(rows.First(), 1);
Assert.IsTrue(Field.IsNullField(value));
}