public override void CanCreateUniqueClusteredIndexWithDefaultSchema()
{
var expression = GeneratorTestHelper.GetCreateUniqueIndexExpression();
expression.Index.IsClustered = true;
var result = Generator.Generate(expression);
result.ShouldBe("CREATE UNIQUE CLUSTERED INDEX [TestIndex] ON [TestTable1] ([TestColumn1] ASC)");
}
public override void CanCreateUniqueIndexWithCustomSchema()
{
var expression = GeneratorTestHelper.GetCreateUniqueIndexExpression();
expression.Index.SchemaName = "TestSchema";
var result = _generator.Generate(expression);
result.ShouldBe("CREATE UNIQUE INDEX [TestIndex] ON [TestSchema].[TestTable1] ([TestColumn1] ASC)");
}
public void CanCreateUniqueIndexWithDistinctNulls()
{
var expression = GeneratorTestHelper.GetCreateUniqueIndexExpression();
expression.Index.Columns.First().SetAdditionalFeature(SqlServerExtensions.IndexColumnNullsDistinct, true);
var result = _generator.Generate(expression);
result.ShouldBe("CREATE UNIQUE INDEX [TestIndex] ON [dbo].[TestTable1] ([TestColumn1] ASC)");
}
public void CanCreateClusteredUniqueIndexWithCustomSchema()
{
var expression = GeneratorTestHelper.GetCreateUniqueIndexExpression();
expression.Index.SchemaName = "TestSchema";
expression.Index.IsClustered = true;
var sql = generator.Generate(expression);
sql.ShouldBe("CREATE UNIQUE CLUSTERED INDEX [TestIndex] ON [TestSchema].[TestTable1] ([TestColumn1] ASC)");
}
public override void CanCreateUniqueIndexWithCustomSchema()
{
var expression = GeneratorTestHelper.GetCreateUniqueIndexExpression();
expression.Index.SchemaName = "TestSchema";
var result = _generator.Generate(expression);
result.ShouldBe(string.Empty);
}
public void CanCreateUniqueClusteredIndexTreatedAsNonClustered()
{
var expression = GeneratorTestHelper.GetCreateUniqueIndexExpression();
expression.Index.IsClustered = true;
var result = Generator.Generate(expression);
result.ShouldBe("CREATE UNIQUE INDEX [TestIndex] ON [TestTable1] ([TestColumn1] ASC)");
}
public override void CanCreateUniqueIndexWithCustomSchema()
{
var expression = GeneratorTestHelper.GetCreateUniqueIndexExpression();
expression.Index.SchemaName = "TestSchema";
var result = Generator.Generate(expression);
result.ShouldBe("CREATE UNIQUE INDEX \"TestIndex\" ON \"TestSchema\".\"TestTable1\" (\"TestColumn1\" ASC);");
}
public override void CanCreateUniqueIndex()
{
var expression = GeneratorTestHelper.GetCreateUniqueIndexExpression();
string sql = _generator.Generate(expression);
sql.ShouldBe("CREATE UNIQUE INDEX TestIndex ON TestTable1 (TestColumn1 ASC)");
sql = quotedIdentiferGenerator.Generate(expression);
sql.ShouldBe("CREATE UNIQUE INDEX \"TestIndex\" ON \"TestTable1\" (\"TestColumn1\" ASC)");
}
public override void CanCreateUniqueIndexWithCustomSchema()
{
Assert.Ignore("HANA does not support schema like us know schema in hana is a database name");
var expression = GeneratorTestHelper.GetCreateUniqueIndexExpression();
expression.Index.SchemaName = "TestSchema";
var result = Generator.Generate(expression);
result.ShouldBe("CREATE UNIQUE INDEX \"TestIndex\" ON \"TestSchema\".\"TestTable1\" (\"TestColumn1\" ASC)");
}
