@Test
public void nonCascading() {

    AkibanInformationSchema ais = AISBBasedBuilder.create(SCHEMA, MTypesTranslator.INSTANCE)
            .table("c")
                .colInt("cid")
                .colString("name", 64)
                .pk("cid")
            .table("o")
                .colInt("oid")
                .colInt("c_id")
                .colString("date", 32)
                .pk("oid")
                .joinTo("c").on("c_id", "cid")
            .table("i")
                .colInt("iid")
                .colInt("o_id")
                .colInt("sku")
                .pk("iid")
                .joinTo("o").on("o_id", "oid")
            .ais();
    checkHKeyColumn(
            ais, "c",
            expectedSegments(1).checkSegment(0).expectedCols(1).checkCol(0).expectAtIndex(0),
            c("c", "cid"), c("o", "c_id"));
    checkHKeyColumn(
            ais, "o",
            expectedSegments(2).checkSegment(0).expectedCols(1).checkCol(0).expectAtIndex(1),
            c("c", "cid"), c("o", "c_id"));
    checkHKeyColumn(
            ais, "o",
            expectedSegments(2).checkSegment(1).expectedCols(1).checkCol(0).expectAtIndex(0),
            c("o", "oid"), c("i", "o_id"));
    checkHKeyColumn(
            ais, "i",
            expectedSegments(3).checkSegment(0).expectedCols(1).checkCol(0).expectAtIndex(1),
            c("c", "cid"), c("o", "c_id"));
    checkHKeyColumn(
            ais, "i",
            expectedSegments(3).checkSegment(1).expectedCols(1).checkCol(0).expectAtIndex(1),
            c("o", "oid"), c("i", "o_id"));
    checkHKeyColumn(
            ais, "i",
            expectedSegments(3).checkSegment(2).expectedCols(1).checkCol(0).expectAtIndex(0),
            c("i", "iid"));
}