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