Function TestCreateViewStatementPool

pkg/sql/ast/pool_ddl_test.go:335–397

============================================================ CreateViewStatement pool tests ============================================================

(t *testing.T)

// ============================================================

func TestCreateViewStatementPool(t *testing.T) {
	t.Run("Get returns non-nil", func(t *testing.T) {
		stmt := GetCreateViewStatement()
		if stmt == nil {
			t.Fatal("GetCreateViewStatement() returned nil")
		}
		PutCreateViewStatement(stmt)
	})

	t.Run("Put nil is safe", func(t *testing.T) {
		PutCreateViewStatement(nil)
	})

	t.Run("Fields zeroed after Put", func(t *testing.T) {
		inner := GetSelectStatement()
		inner.TableName = "users"

		stmt := GetCreateViewStatement()
		stmt.Name = "active_users"
		stmt.OrReplace = true
		stmt.Temporary = true
		stmt.IfNotExists = true
		stmt.Columns = append(stmt.Columns, "id", "name")
		stmt.Query = inner
		stmt.WithOption = "CASCADED"

		PutCreateViewStatement(stmt)

		if stmt.Name != "" {
			t.Errorf("Name not cleared, got %q", stmt.Name)
		}
		if stmt.OrReplace {
			t.Error("OrReplace not cleared")
		}
		if stmt.Temporary {
			t.Error("Temporary not cleared")
		}
		if stmt.IfNotExists {
			t.Error("IfNotExists not cleared")
		}
		if len(stmt.Columns) != 0 {
			t.Errorf("Columns not cleared, len=%d", len(stmt.Columns))
		}
		if stmt.Query != nil {
			t.Error("Query not cleared")
		}
		if stmt.WithOption != "" {
			t.Errorf("WithOption not cleared, got %q", stmt.WithOption)
		}
	})

	t.Run("Pool roundtrip reuse", func(t *testing.T) {
		stmt1 := GetCreateViewStatement()
		stmt1.Name = "my_view"
		PutCreateViewStatement(stmt1)

		stmt2 := GetCreateViewStatement()
		if stmt2.Name != "" {