Function par_fkey_extension

src/gpre/sql.cpp:6127–6208

//

static void par_fkey_extension(cnstrt* cnstrt_val)
{
	// Extended foreign key definition could be as follows :
	//
	// [ON DELETE { NO ACTION | CASCADE | SET DEFAULT | SET NULL } ]
	// [ON UPDATE { NO ACTION | CASCADE | SET DEFAULT | SET NULL } ]

	fb_assert(gpreGlob.token_global.tok_keyword == KW_ON);
	fb_assert(cnstrt_val != NULL);

	PAR_get_token();

	const kwwords_t keyword = gpreGlob.token_global.tok_keyword;
	switch (keyword)
	{
	case KW_DELETE:
		// NOTE: action must be defined only once
		if (cnstrt_val->cnstrt_fkey_def_type & REF_DELETE_ACTION)
			CPR_s_error("UPDATE");
		else
			cnstrt_val->cnstrt_fkey_def_type |= REF_DELETE_ACTION;
		break;
	case KW_UPDATE:
		// NOTE: action must be defined only once
		if (cnstrt_val->cnstrt_fkey_def_type & REF_UPDATE_ACTION)
			CPR_s_error("DELETE");
		else
			cnstrt_val->cnstrt_fkey_def_type |= REF_UPDATE_ACTION;
		break;
	default:
		// unexpected keyword
		CPR_s_error("UPDATE or DELETE");
		break;
	}

	PAR_get_token();

	switch (gpreGlob.token_global.tok_keyword)
	{
	case KW_NO:
		PAR_get_token();
		if (gpreGlob.token_global.tok_keyword != KW_ACTION)
			CPR_s_error("ACTION");
		else if (keyword == KW_DELETE)
			cnstrt_val->cnstrt_fkey_def_type |= REF_DEL_NONE;
		else
			cnstrt_val->cnstrt_fkey_def_type |= REF_UPD_NONE;
		break;
	case KW_CASCADE:
		if (keyword == KW_DELETE)
			cnstrt_val->cnstrt_fkey_def_type |= REF_DEL_CASCADE;
		else
			cnstrt_val->cnstrt_fkey_def_type |= REF_UPD_CASCADE;
		break;
	case KW_SET:
		PAR_get_token();
		switch (gpreGlob.token_global.tok_keyword)
		{