public void BigInt()
{
CompressedRecord parser;
// 9223372036854775807
parser = new CompressedRecord(TestHelper.GetBytesFromByteString("010119ff ffffffff ffffff"), null);
Assert.AreEqual(1, parser.NumberOfColumns);
Assert.AreEqual(8, parser.GetPhysicalColumnBytes(0).GetBytes().Count());
// 36028797018963967
parser = new CompressedRecord(TestHelper.GetBytesFromByteString("010118ff ffffffff ffff"), null);
Assert.AreEqual(1, parser.NumberOfColumns);
Assert.AreEqual(7, parser.GetPhysicalColumnBytes(0).GetBytes().Count());
// 140737488355327
parser = new CompressedRecord(TestHelper.GetBytesFromByteString("010117ff ffffffff ff"), null);
Assert.AreEqual(1, parser.NumberOfColumns);
Assert.AreEqual(6, parser.GetPhysicalColumnBytes(0).GetBytes().Count());
// 549755813887
parser = new CompressedRecord(TestHelper.GetBytesFromByteString("010116ff ffffffff 00"), null);
Assert.AreEqual(1, parser.NumberOfColumns);
Assert.AreEqual(5, parser.GetPhysicalColumnBytes(0).GetBytes().Count());
// 2147483647
parser = new CompressedRecord(TestHelper.GetBytesFromByteString("010115ff ffffff00 00"), null);
Assert.AreEqual(1, parser.NumberOfColumns);
Assert.AreEqual(4, parser.GetPhysicalColumnBytes(0).GetBytes().Count());
}
private void parseRecords()
{
Records = new CompressedRecord[Header.SlotCnt];
int cnt = 0;
foreach (short recordOffset in SlotArray)
Records[cnt++] = new CompressedRecord(ArrayHelper.SliceArray(RawBytes, recordOffset, RawBytes.Length - recordOffset), this);
}
public void Datetime()
{
CompressedRecord parser;
// 2012-01-29 23:57:42.997
parser = new CompressedRecord(TestHelper.GetBytesFromByteString("01011880 9FE7018A E173"), null);
Assert.AreEqual(1, parser.NumberOfColumns);
Assert.AreEqual(7, parser.GetPhysicalColumnBytes(0).GetBytes().Count());
// 2012-01-29 23:57:42.447
parser = new CompressedRecord(TestHelper.GetBytesFromByteString("01011880 9FE7018A E0CE"), null);
Assert.AreEqual(1, parser.NumberOfColumns);
Assert.AreEqual(7, parser.GetPhysicalColumnBytes(0).GetBytes().Count());
// 2099-12-31 23:59:59.997
parser = new CompressedRecord(TestHelper.GetBytesFromByteString("01011881 1D58018B 81FF"), null);
Assert.AreEqual(1, parser.NumberOfColumns);
Assert.AreEqual(7, parser.GetPhysicalColumnBytes(0).GetBytes().Count());
// 1753-01-01 00:00:00.000
parser = new CompressedRecord(TestHelper.GetBytesFromByteString("0101187F 2E460000 0000"), null);
Assert.AreEqual(1, parser.NumberOfColumns);
Assert.AreEqual(7, parser.GetPhysicalColumnBytes(0).GetBytes().Count());
// NULL
parser = new CompressedRecord(TestHelper.GetBytesFromByteString("01011084 00000000 A8"), null);
Assert.AreEqual(1, parser.NumberOfColumns);
Assert.AreEqual(null, parser.GetPhysicalColumnBytes(0));
// 1900-01-01 00:00:00.000
parser = new CompressedRecord(TestHelper.GetBytesFromByteString("01011100 01010100 01"), null);
Assert.AreEqual(1, parser.NumberOfColumns);
Assert.AreEqual(0, parser.GetPhysicalColumnBytes(0).GetBytes().Count());
// 1900-01-02 00:00:00.000
parser = new CompressedRecord(TestHelper.GetBytesFromByteString("01011681 00000000 01"), null);
Assert.AreEqual(1, parser.NumberOfColumns);
Assert.AreEqual(5, parser.GetPhysicalColumnBytes(0).GetBytes().Count());
// 1900-01-02 18:22:11.123
parser = new CompressedRecord(TestHelper.GetBytesFromByteString("01011681 012EB969 01"), null);
Assert.AreEqual(1, parser.NumberOfColumns);
Assert.AreEqual(5, parser.GetPhysicalColumnBytes(0).GetBytes().Count());
// 1900-01-01 22:17:21.447
parser = new CompressedRecord(TestHelper.GetBytesFromByteString("01011581 6F50F200 00"), null);
Assert.AreEqual(1, parser.NumberOfColumns);
Assert.AreEqual(4, parser.GetPhysicalColumnBytes(0).GetBytes().Count());
// 1899-01-02 18:22:11.123
parser = new CompressedRecord(TestHelper.GetBytesFromByteString("0101177E 94012EB9 69"), null);
Assert.AreEqual(1, parser.NumberOfColumns);
Assert.AreEqual(6, parser.GetPhysicalColumnBytes(0).GetBytes().Count());
}
public void Int()
{
CompressedRecord parser;
// 127
parser = new CompressedRecord(TestHelper.GetBytesFromByteString("010112ff 00000000 10"), null);
Assert.AreEqual(1, parser.NumberOfColumns);
Assert.AreEqual(1, parser.GetPhysicalColumnBytes(0).GetBytes().Count());
// 128
parser = new CompressedRecord(TestHelper.GetBytesFromByteString("01011380 80000000 10"), null);
Assert.AreEqual(1, parser.NumberOfColumns);
Assert.AreEqual(2, parser.GetPhysicalColumnBytes(0).GetBytes().Count());
// 32767
parser = new CompressedRecord(TestHelper.GetBytesFromByteString("010113ff ff000000 10"), null);
Assert.AreEqual(1, parser.NumberOfColumns);
Assert.AreEqual(2, parser.GetPhysicalColumnBytes(0).GetBytes().Count());
// 32768
parser = new CompressedRecord(TestHelper.GetBytesFromByteString("01011480 80000000 10"), null);
Assert.AreEqual(1, parser.NumberOfColumns);
Assert.AreEqual(3, parser.GetPhysicalColumnBytes(0).GetBytes().Count());
// 8388607
parser = new CompressedRecord(TestHelper.GetBytesFromByteString("010114ff ffff0000 10"), null);
Assert.AreEqual(1, parser.NumberOfColumns);
Assert.AreEqual(3, parser.GetPhysicalColumnBytes(0).GetBytes().Count());
// 2147483647
parser = new CompressedRecord(TestHelper.GetBytesFromByteString("010115ff ffffff00 10"), null);
Assert.AreEqual(1, parser.NumberOfColumns);
Assert.AreEqual(4, parser.GetPhysicalColumnBytes(0).GetBytes().Count());
// -128
parser = new CompressedRecord(TestHelper.GetBytesFromByteString("01011200 00000000 10"), null);
Assert.AreEqual(1, parser.NumberOfColumns);
Assert.AreEqual(1, parser.GetPhysicalColumnBytes(0).GetBytes().Count());
// -129
parser = new CompressedRecord(TestHelper.GetBytesFromByteString("0101137f 7f000000 00"), null);
Assert.AreEqual(1, parser.NumberOfColumns);
Assert.AreEqual(2, parser.GetPhysicalColumnBytes(0).GetBytes().Count());
// -8388608
parser = new CompressedRecord(TestHelper.GetBytesFromByteString("01011400 00000000 10"), null);
Assert.AreEqual(1, parser.NumberOfColumns);
Assert.AreEqual(3, parser.GetPhysicalColumnBytes(0).GetBytes().Count());
// -8388609
parser = new CompressedRecord(TestHelper.GetBytesFromByteString("0101157f 7fffff00 10"), null);
Assert.AreEqual(1, parser.NumberOfColumns);
Assert.AreEqual(4, parser.GetPhysicalColumnBytes(0).GetBytes().Count());
}
public void TinyInt()
{
CompressedRecord parser;
// 1
parser = new CompressedRecord(TestHelper.GetBytesFromByteString("01011201 00000000 00"), null);
Assert.AreEqual(1, parser.NumberOfColumns);
Assert.AreEqual(1, parser.GetPhysicalColumnBytes(0).GetBytes().Count());
// 127
parser = new CompressedRecord(TestHelper.GetBytesFromByteString("0101127f 00000000 00"), null);
Assert.AreEqual(1, parser.NumberOfColumns);
Assert.AreEqual(1, parser.GetPhysicalColumnBytes(0).GetBytes().Count());
// 128
parser = new CompressedRecord(TestHelper.GetBytesFromByteString("01011280 00000000 00"), null);
Assert.AreEqual(1, parser.NumberOfColumns);
Assert.AreEqual(1, parser.GetPhysicalColumnBytes(0).GetBytes().Count());
// 255
parser = new CompressedRecord(TestHelper.GetBytesFromByteString("010112ff 00000000 00"), null);
Assert.AreEqual(1, parser.NumberOfColumns);
Assert.AreEqual(1, parser.GetPhysicalColumnBytes(0).GetBytes().Count());
// NULL
parser = new CompressedRecord(TestHelper.GetBytesFromByteString("01011084 00000000 a8"), null);
Assert.AreEqual(1, parser.NumberOfColumns);
Assert.AreEqual(null, parser.GetPhysicalColumnBytes(0));
}
public void SmallInt()
{
CompressedRecord parser;
// NULL
parser = new CompressedRecord(TestHelper.GetBytesFromByteString("01011083 00000000 a8"), null);
Assert.AreEqual(1, parser.NumberOfColumns);
Assert.AreEqual(null, parser.GetPhysicalColumnBytes(0));
// 1
parser = new CompressedRecord(TestHelper.GetBytesFromByteString("01011281 00000000 00"), null);
Assert.AreEqual(1, parser.NumberOfColumns);
Assert.AreEqual(1, parser.GetPhysicalColumnBytes(0).GetBytes().Count());
// -1
parser = new CompressedRecord(TestHelper.GetBytesFromByteString("0101127f 00000000 00"), null);
Assert.AreEqual(1, parser.NumberOfColumns);
Assert.AreEqual(1, parser.GetPhysicalColumnBytes(0).GetBytes().Count());
// -130
parser = new CompressedRecord(TestHelper.GetBytesFromByteString("0101137f 7e000000 00"), null);
Assert.AreEqual(1, parser.NumberOfColumns);
Assert.AreEqual(2, parser.GetPhysicalColumnBytes(0).GetBytes().Count());
// 127
parser = new CompressedRecord(TestHelper.GetBytesFromByteString("010112ff 00000000 00"), null);
Assert.AreEqual(1, parser.NumberOfColumns);
Assert.AreEqual(1, parser.GetPhysicalColumnBytes(0).GetBytes().Count());
// 128
parser = new CompressedRecord(TestHelper.GetBytesFromByteString("01011380 80000000 00"), null);
Assert.AreEqual(1, parser.NumberOfColumns);
Assert.AreEqual(2, parser.GetPhysicalColumnBytes(0).GetBytes().Count());
// 255
parser = new CompressedRecord(TestHelper.GetBytesFromByteString("01011380 ff000000 00"), null);
Assert.AreEqual(1, parser.NumberOfColumns);
Assert.AreEqual(2, parser.GetPhysicalColumnBytes(0).GetBytes().Count());
// -32768
parser = new CompressedRecord(TestHelper.GetBytesFromByteString("01011300 00000000 00"), null);
Assert.AreEqual(1, parser.NumberOfColumns);
Assert.AreEqual(2, parser.GetPhysicalColumnBytes(0).GetBytes().Count());
}
