Function nodeCreateView

server/ast/create_view.go:27–108

nodeCreateView handles *tree.CreateView nodes.

(ctx *Context, node *tree.CreateView)

// nodeCreateView handles *tree.CreateView nodes.
func nodeCreateView(ctx *Context, node *tree.CreateView) (*vitess.DDL, error) {
	if node == nil {
		return nil, nil
	}
	if node.Persistence.IsTemporary() {
		return nil, errors.Errorf("CREATE TEMPORARY VIEW is not yet supported")
	}
	if node.IsRecursive {
		return nil, errors.Errorf("CREATE RECURSIVE VIEW is not yet supported")
	}
	var checkOption = tree.ViewCheckOptionUnspecified
	var sqlSecurity string
	if node.Options != nil {
		for _, opt := range node.Options {
			switch strings.ToLower(opt.Name) {
			case "check_option":
				switch strings.ToLower(opt.CheckOpt) {
				case "local":
					checkOption = tree.ViewCheckOptionLocal
				case "cascaded":
					checkOption = tree.ViewCheckOptionCascaded
				default:
					return nil, errors.Errorf(`"ERROR:  syntax error at or near "%s"`, opt.Name)
				}
			case "security_barrier":
				if opt.Security {
					return nil, errors.Errorf("CREATE VIEW '%s' = true option is not yet supported", opt.Name)
				}
			case "security_invoker":
				if opt.Security {
					sqlSecurity = "invoker"
				} else {
					sqlSecurity = "definer"
				}
			default:
				return nil, errors.Errorf(`"ERROR:  syntax error at or near "%s"`, opt.Name)
			}
		}
	}

	if checkOption != tree.ViewCheckOptionUnspecified && node.CheckOption != tree.ViewCheckOptionUnspecified {
		return nil, errors.Errorf(`ERROR:  parameter "check_option" specified more than once`)
	} else {
		checkOption = node.CheckOption
	}

	vCheckOpt := vitess.ViewCheckOptionUnspecified
	switch checkOption {
	case tree.ViewCheckOptionCascaded:
		vCheckOpt = vitess.ViewCheckOptionCascaded
	case tree.ViewCheckOptionLocal:
		vCheckOpt = vitess.ViewCheckOptionLocal
	default:
	}

	tableName, err := nodeTableName(ctx, &node.Name)
	if err != nil {
		return nil, err