Function TestColumnDefaults

main_test.go:1977–2065

(t *testing.T)

					Expected: []sql.Row{{types.NewOkResult(0)}},
				},
				{
					Skip:  true,
					Query: "SHOW FULL COLUMNS FROM t3",
					Expected: []sql.Row{
						{"b", "varchar(10)", "utf8mb4_0900_bin", "YES", "", nil, "", "", ""},
						{"c", "bigint", nil, "YES", "", nil, "", "", ""},
					},
				},
				{
					Skip:  true,
					Query: "SELECT * FROM t3 ORDER BY b",
					Expected: []sql.Row{
						{"abc", 2},
						{"def", 4},
					},
				},
			},
		},
		{
			Name: "error cases",
			SetUpScript: []string{
				"create table t4 (a int primary key, b int, c int default (10))",
			},
			Assertions: []queries.ScriptTestAssertion{
				{
					Query:       "ALTER TABLE not_exist DROP COLUMN s",
					ExpectedErr: sql.ErrTableNotFound,
				},
				{
					Query:       "ALTER TABLE t4 DROP COLUMN s",
					ExpectedErr: sql.ErrTableColumnNotFound,
				},
				{
					Skip:        true,
					Query:       "ALTER TABLE t4 DROP COLUMN b",
					ExpectedErr: sql.ErrDropColumnReferencedInDefault,
				},
			},
		},
	}
	enginetest.TestDropColumn(t, NewDefaultDuckHarness())
}

func TestDropColumnKeylessTables(t *testing.T) {
	enginetest.TestDropColumnKeylessTables(t, NewDefaultDuckHarness())
}

func TestCreateDatabase(t *testing.T) {
	enginetest.TestCreateDatabase(t, NewDefaultDuckHarness())
}

func TestPkOrdinalsDDL(t *testing.T) {
	t.Skip("wait for fix")
	enginetest.TestPkOrdinalsDDL(t, NewDefaultDuckHarness())
}

func TestPkOrdinalsDML(t *testing.T) {
	enginetest.TestPkOrdinalsDML(t, NewDefaultDuckHarness())