public void LeafLevelNonclusteredWithNullBitmapAndVariableLength2012_A()
{
var rawBytes = TestHelper.GetBytesFromByteString(@"
36a50100 00020000 01004400 66006f00 72007200
65007300 74003000 40006100 64007600 65006e00
74007500 72006500 2d007700 6f007200 6b007300
2e006300 6f006d00
");
var record = new RawIndexRecord(new ArrayDelimiter<byte>(rawBytes), 5, 0);
Assert.AreEqual(4, record.FixedLengthData.Count);
Assert.AreEqual(true, record.HasNullBitmap);
Assert.AreEqual(true, record.HasVariableLengthColumns);
Assert.AreEqual(2, record.NullBitmapColumnCount);
Assert.IsNull(record.ChildPageID);
Assert.IsNull(record.ChildFileID);
dynamic row = RawColumnParser.Parse(record, new IRawType[] {
RawType.NVarchar("EmailAddress"),
RawType.Int("CustomerID")
});
Assert.AreEqual("*****@*****.**", row.EmailAddress);
Assert.AreEqual(421, row.CustomerID);
}
public void BranchLevelNonClusteredWithNullBitmapAndVariableLength2012_FirstRecord()
{
var rawBytes = TestHelper.GetBytesFromByteString(@"
36ca0000 00760200 00010002 00000100 3e006100
30004000 61006400 76006500 6e007400 75007200
65002d00 77006f00 72006b00 73002e00 63006f00
6d00
");
var record = new RawIndexRecord(new ArrayDelimiter<byte>(rawBytes), 11, 1);
// First record has implicit null values
Assert.AreEqual(1, record.ChildFileID);
Assert.AreEqual(630, record.ChildPageID);
}
public void BranchLevelNonClusteredWithNullBitmapAndVariableLength2012_SecondRecord()
{
var rawBytes = TestHelper.GetBytesFromByteString(@"
36d90000 00780200 00010002 00000100 46006300
68007200 69007300 36004000 61006400 76006500
6e007400 75007200 65002d00 77006f00 72006b00
73002e00 63006f00 6d00
");
var record = new RawIndexRecord(new ArrayDelimiter<byte>(rawBytes), 11, 1);
Assert.AreEqual(1, record.ChildFileID);
Assert.AreEqual(632, record.ChildPageID);
dynamic row = RawColumnParser.Parse(record, new IRawType[] {
RawType.NVarchar("EmailAddress"),
RawType.Int("CustomerID")
});
Assert.AreEqual("*****@*****.**", row.EmailAddress);
Assert.AreEqual(217, row.CustomerID);
}