public void CanAddDecimalColumnWithDefaultSchema() { var expression = GeneratorTestHelper.GetCreateDecimalColumnExpression(); var sql = generator.Generate(expression); sql.ShouldBe("ALTER TABLE [dbo].[TestTable1] ADD [TestColumn1] DECIMAL(19,2) NOT NULL"); }
public override void CanAddDecimalColumn() { var expression = GeneratorTestHelper.GetCreateDecimalColumnExpression(); var sql = _generator.Generate(expression); sql.ShouldBe("ALTER TABLE [TestTable1] ADD [TestColumn1] DECIMAL(19,2) NOT NULL"); }
public override void CanAddDecimalColumn() { var expression = GeneratorTestHelper.GetCreateDecimalColumnExpression(); string sql = generator.Generate(expression); sql.ShouldBe("ALTER TABLE \"TestTable1\" ADD \"TestColumn1\" NUMBER(19,2) NOT NULL"); }
public override void CanAddDecimalColumn() { var expression = GeneratorTestHelper.GetCreateDecimalColumnExpression(); string sql = _generator.Generate(expression); sql.ShouldBe("ALTER TABLE 'TestTable1' ADD COLUMN 'TestColumn1' NUMERIC NOT NULL"); }
public override void CanCreateDecimalColumnWithDefaultSchema() { var expression = GeneratorTestHelper.GetCreateDecimalColumnExpression(); var result = Generator.Generate(expression); result.ShouldBe("ALTER TABLE \"TestTable1\" ADD \"TestColumn1\" DECIMAL(2,19) NOT NULL"); }
public override void CanCreateDecimalColumnWithDefaultSchema() { var expression = GeneratorTestHelper.GetCreateDecimalColumnExpression(); var result = Generator.Generate(expression); result.ShouldBe("ALTER TABLE `TestTable1` ADD COLUMN `TestColumn1` DECIMAL(19,2) NOT NULL"); }
public override void CanCreateDecimalColumnWithDefaultSchema() { var expression = GeneratorTestHelper.GetCreateDecimalColumnExpression(); var result = Generator.Generate(expression); result.ShouldBe("ALTER TABLE [TestTable1] ADD [TestColumn1] NUMERIC(19,2) NOT NULL"); }
public override void CanCreateDecimalColumnWithCustomSchema() { var expression = GeneratorTestHelper.GetCreateDecimalColumnExpression(); expression.SchemaName = "TestSchema"; var result = Generator.Generate(expression); result.ShouldBe("ALTER TABLE TestTable1 ADD TestColumn1 DECIMAL(19, 2) NOT NULL"); }
public override void CanCreateDecimalColumnWithCustomSchema() { var expression = GeneratorTestHelper.GetCreateDecimalColumnExpression(); expression.SchemaName = "TestSchema"; var result = Generator.Generate(expression); result.ShouldBe("ALTER TABLE \"TestSchema\".\"TestTable1\" ADD COLUMN \"TestColumn1\" TEXT NOT NULL"); }
public override void CanCreateDecimalColumnWithCustomSchema() { Assert.Ignore("Hana support change default value with type like bellow"); var expression = GeneratorTestHelper.GetCreateDecimalColumnExpression(); expression.SchemaName = "TestSchema"; var result = Generator.Generate(expression); result.ShouldBe("ALTER TABLE \"TestTable1\" ADD (\"TestColumn1\" DECIMAL(19,2))"); }