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; }