Function RunModifyColumnTest

main_test.go:1685–1707

(t *testing.T, harness enginetest.Harness)

			se.NewConnection(ctx)
		}
		enginetest.TestQueryWithContext(t, ctx, e, harness, "select database()", []sql.Row{{nil}}, nil, nil, nil)
		enginetest.TestQueryWithContext(t, ctx, e, harness, "ALTER TABLE mydb.mytable_m1 MODIFY COLUMN s VARCHAR(21) NULL COMMENT 'changed again'", []sql.Row{{types.NewOkResult(0)}}, nil, nil, nil)
		enginetest.TestQueryWithContext(t, ctx, e, harness, "SHOW FULL COLUMNS FROM mydb.mytable_m1", []sql.Row{
			{"i", "bigint", nil, "NO", "", nil, "", "", "ok"},
			{"s", "varchar(21)", "utf8mb4_0900_bin", "YES", "", nil, "", "", "changed again"},
		}, nil, nil, nil)
	})
}

func TestDropColumn(t *testing.T) {
	queries.DropColumnScripts = []queries.ScriptTest{
		{
			Name: "drop column",
			SetUpScript: []string{
				"CREATE TABLE mytable_drop_column (i bigint primary key, s varchar(20))",
				"INSERT INTO mytable_drop_column VALUES (1, 'first row'), (2, 'second row'), (3, 'third row')",
				"ALTER TABLE mytable_drop_column DROP COLUMN s",
			},
			Assertions: []queries.ScriptTestAssertion{
				{
					Query:    "SHOW FULL COLUMNS FROM mytable_drop_column",
					Expected: []sql.Row{{"i", "bigint", nil, "NO", "PRI", nil, "", "", ""}},
				},
				{
					Query:    "select * from mytable_drop_column order by i",
					Expected: []sql.Row{{1}, {2}, {3}},