Function TestModifyColumn

main_test.go:1531–1683

(t *testing.T)

					Query:    "ALTER TABLE mytable1 RENAME COLUMN i TO i2, RENAME COLUMN s TO s2",
					Expected: []sql.Row{{types.NewOkResult(0)}},
				},
				{
					Query: "SHOW FULL COLUMNS FROM mytable1",
					Expected: []sql.Row{
						{"i2", "bigint", nil, "NO", "", nil, "", "", ""},
						{"s2", "varchar(20)", "utf8mb4_0900_bin", "NO", "", nil, "", "", "column s"},
					},
				},
				{
					Query: "select * from mytable1 order by i2 limit 1",
					Expected: []sql.Row{
						{1, "first row"},
					},
				},
			},
		},
	}
	enginetest.TestRenameColumn(t, NewDefaultDuckHarness())
}

func TestAddColumn(t *testing.T) {
	queries.AddColumnScripts = []queries.ScriptTest{
		{
			Name: "column at end with default",
			Assertions: []queries.ScriptTestAssertion{
				{
					Query:    "ALTER TABLE mytable ADD COLUMN i2 INT COMMENT 'hello' default 42",
					Expected: []sql.Row{{types.NewOkResult(0)}},
				},
				{
					Query: "SHOW FULL COLUMNS FROM mytable",
					// | Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
					// TODO: missing privileges
					Expected: []sql.Row{
						{"i", "bigint", nil, "NO", "PRI", nil, "", "", ""},
						{"s", "varchar(20)", "utf8mb4_0900_bin", "NO", "UNI", nil, "", "", "column s"},
						{"i2", "int", nil, "YES", "", "42", "", "", "hello"},
					},
				},
				{
					Query: "SELECT * FROM mytable ORDER BY i;",
					Expected: []sql.Row{
						sql.NewRow(int64(1), "first row", int32(42)),
						sql.NewRow(int64(2), "second row", int32(42)),
						sql.NewRow(int64(3), "third row", int32(42)),
					},
				},
			},
		},
		{
			Name: "add column, no default",
			Assertions: []queries.ScriptTestAssertion{
				{
					Query:    "ALTER TABLE mytable ADD COLUMN s2 TEXT COMMENT 'hello';",
					Expected: []sql.Row{{types.NewOkResult(0)}},
				},
				{
					Query: "SHOW FULL COLUMNS FROM mytable",