Function ValidateCreateSchema

server/analyzer/validate_create_schema.go:29–54

ValidateCreateSchema validates that CREATE SCHEMA is executed with a valid database context. In PostgreSQL, schemas exist within databases, so CREATE SCHEMA requires an active database. See: https://github.com/dolthub/doltgresql/issues/1863

(
	ctx *sql.Context,
	a *analyzer.Analyzer,
	n sql.Node,
	scope *plan.Scope,
	sel analyzer.RuleSelector,
	qFlags *sql.QueryFlags,
)

// In PostgreSQL, schemas exist within databases, so CREATE SCHEMA requires an active database.
// See: https://github.com/dolthub/doltgresql/issues/1863
func ValidateCreateSchema(
	ctx *sql.Context,
	a *analyzer.Analyzer,
	n sql.Node,
	scope *plan.Scope,
	sel analyzer.RuleSelector,
	qFlags *sql.QueryFlags,
) (sql.Node, transform.TreeIdentity, error) {
	cs, ok := n.(*plan.CreateSchema)
	if !ok {
		return n, transform.SameTree, nil
	}

	// Check if the current database actually has a working root.
	// GetRootFromContext will return sql.ErrDatabaseNotFound if the database
	// is not properly initialized.
	_, _, err := core.GetRootFromContext(ctx)
	if err != nil {
		if sql.ErrDatabaseNotFound.Is(err) {
			return nil, transform.SameTree, sql.ErrNoDatabaseSelected.New()
		}
		return nil, transform.SameTree, err
	}

	return cs, transform.SameTree, nil
}