Function TestCreateTable

testing/go/create_table_test.go:24–478

(t *testing.T)

)

func TestCreateTable(t *testing.T) {
	RunScripts(t, []ScriptTest{
		{
			// https://github.com/dolthub/doltgresql/issues/2580
			Name: "create table with UTF8 identifiers",
			Assertions: []ScriptTestAssertion{
				{
					Query:    `CREATE TABLE foo😏(data🍆 TEXT);`,
					Expected: []sql.Row{},
				},
				{
					Query:    `CREATE INDEX idx🍤 ON foo😏(data🍆);`,
					Expected: []sql.Row{},
				},
				{
					Query:    `Insert into foo😏 (data🍆) VALUES ('foo');`,
					Expected: []sql.Row{},
				},
				{
					Query:    `SELECT data🍆 FROM foo😏;`,
					Expected: []sql.Row{{"foo"}},
				},
			},
		},
		{
			Name: "create table with primary key",
			Assertions: []ScriptTestAssertion{
				{
					// TODO: we don't currently have a way to check for warnings in these tests, but this query was incorrectly
					//  producing a warning. Would be nice to assert no warnings on most queries.
					Query: "create table employees (" +
						"    id int8," +
						"    last_name text," +
						"    first_name text," +
						"    primary key(id));",
				},
				{
					Query: "insert into employees (id, last_name, first_name) values (1, 'Doe', 'John');",
				},
				{
					Query: "select * from employees;",
					Expected: []sql.Row{
						{1, "Doe", "John"},
					},
				},
				{
					// Test that the PK constraint shows up in the information schema
					Query:    "SELECT conname FROM pg_constraint WHERE conrelid = 'employees'::regclass AND contype = 'p';",
					Expected: []sql.Row{{"employees_pkey"}},
				},
				{
					Query:    "ALTER TABLE employees DROP CONSTRAINT employees_pkey;",
					Expected: []sql.Row{},
				},
			},
		},
		{
			// TODO: We don't currently support storing a custom name for a primary key constraint.