public void CanCreateMultiColumnIndexWithDefaultSchema() { var expression = GeneratorTestHelper.GetCreateMultiColumnCreateIndexExpression(); var sql = generator.Generate(expression); sql.ShouldBe("CREATE INDEX [TestIndex] ON [dbo].[TestTable1] ([TestColumn1] ASC, [TestColumn2] DESC)"); }
public override void CanCreateMultiColumnIndex() { var expression = GeneratorTestHelper.GetCreateMultiColumnCreateIndexExpression(); string sql = generator.Generate(expression); sql.ShouldBe("CREATE INDEX 'TestIndex' ON 'TestTable1' ('TestColumn1' ASC, 'TestColumn2' DESC)"); }
public override void CanCreateMultiColumnIndex() { var expression = GeneratorTestHelper.GetCreateMultiColumnCreateIndexExpression(); var sql = generator.Generate(expression); sql.ShouldBe("CREATE INDEX [TestIndex] ON [TestTable1] ([TestColumn1] ASC, [TestColumn2] DESC)"); }
public override void CanCreateMultiColumnIndex() { var expression = GeneratorTestHelper.GetCreateMultiColumnCreateIndexExpression(); string sql = _generator.Generate(expression); sql.ShouldBe("CREATE INDEX TestIndex ON TestTable1 (TestColumn1 ASC, TestColumn2 DESC)"); }
public override void CanCreateMultiColumnIndexWithDefaultSchema() { var expression = GeneratorTestHelper.GetCreateMultiColumnCreateIndexExpression(); var result = Generator.Generate(expression); result.ShouldBe("CREATE INDEX \"TestIndex\" ON \"public\".\"TestTable1\" (\"TestColumn1\" ASC,\"TestColumn2\" DESC);"); }
public override void CanCreateMultiColumnIndexWithDefaultSchema() { var expression = GeneratorTestHelper.GetCreateMultiColumnCreateIndexExpression(); var result = _generator.Generate(expression); result.ShouldBe(string.Empty); }
public override void CanCreateMultiColumnIndexWithDefaultSchema() { var expression = GeneratorTestHelper.GetCreateMultiColumnCreateIndexExpression(); var result = Generator.Generate(expression); result.ShouldBe("CREATE INDEX `TestIndex` ON `TestTable1` (`TestColumn1` ASC, `TestColumn2` DESC)"); }
public override void CanCreateMultiColumnIndex() { var expression = GeneratorTestHelper.GetCreateMultiColumnCreateIndexExpression(); var sql = generator.Generate(expression); sql.ShouldBe("CREATE INDEX `TestIndex` ON `TestTable1` (`TestColumn1` ASC, `TestColumn2` DESC)"); }
public override void CanCreateMultiColumnIndexWithDefaultSchema() { var expression = GeneratorTestHelper.GetCreateMultiColumnCreateIndexExpression(); var result = Generator.Generate(expression); result.ShouldBe("CREATE ASC INDEX TestIndex ON TestTable1 (TestColumn1, TestColumn2)"); }
public void CanCreateClusteredMultiColumnIndex() { var expression = GeneratorTestHelper.GetCreateMultiColumnCreateIndexExpression(); expression.Index.IsClustered = true; var sql = generator.Generate(expression); sql.ShouldBe("CREATE CLUSTERED INDEX [TestIndex] ON [TestTable1] ([TestColumn1] ASC, [TestColumn2] DESC)"); }
public void CanCreateMultiColumnIndexWithCustomSchema() { var expression = GeneratorTestHelper.GetCreateMultiColumnCreateIndexExpression(); expression.Index.SchemaName = "TestSchema"; var sql = generator.Generate(expression); sql.ShouldBe("CREATE INDEX [TestIndex] ON [TestSchema].[TestTable1] ([TestColumn1] ASC, [TestColumn2] DESC)"); }
public void CanCreateMultiColumnClusteredIndexTreatedAsNonClustered() { var expression = GeneratorTestHelper.GetCreateMultiColumnCreateIndexExpression(); expression.Index.IsClustered = true; var result = Generator.Generate(expression); result.ShouldBe("CREATE INDEX [TestIndex] ON [TestTable1] ([TestColumn1] ASC, [TestColumn2] DESC)"); }
public override void CanCreateMultiColumnIndexWithCustomSchema() { var expression = GeneratorTestHelper.GetCreateMultiColumnCreateIndexExpression(); expression.Index.SchemaName = "TestSchema"; var result = Generator.Generate(expression); result.ShouldBe("CREATE INDEX \"TestIndex\" ON \"TestTable1\" (\"TestColumn1\" ASC, \"TestColumn2\" DESC)"); }
public override void CanCreateMultiColumnClusteredIndexWithDefaultSchema() { var expression = GeneratorTestHelper.GetCreateMultiColumnCreateIndexExpression(); expression.Index.IsClustered = true; var result = Generator.Generate(expression); result.ShouldBe("CREATE CLUSTERED INDEX [TestIndex] ON [dbo].[TestTable1] ([TestColumn1] ASC, [TestColumn2] DESC)"); }
public override void CanCreateMultiColumnIndexWithCustomSchema() { Assert.Ignore("HANA does not support schema like us know schema in hana is a database name"); var expression = GeneratorTestHelper.GetCreateMultiColumnCreateIndexExpression(); expression.Index.SchemaName = "TestSchema"; var result = Generator.Generate(expression); result.ShouldBe("CREATE INDEX \"TestIndex\" ON \"TestSchema\".\"TestTable1\" (\"TestColumn1\" ASC,\"TestColumn2\" DESC)"); }