public InsertSearchTests()
{
var leftInfo = new TableInfo(ObjectName.Parse("tab1"));
leftInfo.Columns.Add(new ColumnInfo("a", PrimitiveTypes.Integer()));
leftInfo.Columns.Add(new ColumnInfo("b", PrimitiveTypes.Boolean()));
leftInfo.Columns.Add(new ColumnInfo("c", PrimitiveTypes.Double()));
left = new TemporaryTable(leftInfo);
left.AddRow(new[] { SqlObject.Integer(23), SqlObject.Boolean(true), SqlObject.Double(5563.22) });
left.AddRow(new[] { SqlObject.Integer(54), SqlObject.Boolean(null), SqlObject.Double(921.001) });
left.AddRow(new[] { SqlObject.Integer(23), SqlObject.Boolean(true), SqlObject.Double(2010.221) });
}
public TableIndexTests()
{
var tableInfo = new TableInfo(ObjectName.Parse("test_table1"));
tableInfo.Columns.Add(new ColumnInfo("a", PrimitiveTypes.BigInt()));
tableInfo.Columns.Add(new ColumnInfo("b", PrimitiveTypes.String()));
var temp = new TemporaryTable(tableInfo);
temp.AddRow(new [] { SqlObject.BigInt(22), SqlObject.String("o102") });
temp.AddRow(new [] { SqlObject.BigInt(103), SqlObject.String("t-23") });
temp.AddRow(new[] { SqlObject.BigInt(104), SqlObject.String("test22") });
temp.BuildIndex();
table = temp;
}
