Function act_create_view

src/gpre/sql.cpp:2089–2146

//

static act* act_create_view()
{
	gpre_req* request = MSC_request(REQ_ddl);
	gpre_rel* relation = par_relation(request);

	// create action block

	act* action = MSC_action(request, ACT_create_view);
	action->act_whenever = gen_whenever();
	action->act_object = (ref*) relation;

	// if field list is present parse it and create corresponding field blocks

	if (MSC_match(KW_LEFT_PAREN))
	{
		gpre_fld** ptr = &relation->rel_fields;
		for (;;)
		{
			*ptr = make_field(relation);
			ptr = &(*ptr)->fld_next;
			if (MSC_match(KW_RIGHT_PAREN))
				break;
			MSC_match(KW_COMMA);
		}
	}

	// skip 'AS SELECT'

	if (!MSC_match(KW_AS))
		CPR_s_error("AS");

	relation->rel_view_text = CPR_start_text();
	if (!MSC_match(KW_SELECT))
		CPR_s_error("SELECT");

	// reserve context variable 0 for view

	request->req_internal++;

	// parse the view SELECT

	gpre_rse* select = SQE_select(request, true);
	relation->rel_view_rse = select;
	EXP_rse_cleanup(select);

	if (MSC_match(KW_WITH))
	{
		if (!MSC_match(KW_CHECK))
			CPR_s_error("CHECK");
		if (!MSC_match(KW_OPTION))
			CPR_s_error("OPTION");
		relation->rel_flags |= REL_view_check;
	}

	CPR_end_text(relation->rel_view_text);

	return action;
}