Function SQL_par_field_collate

src/gpre/sql.cpp:487–520

//

void SQL_par_field_collate(gpre_req*, //request,
						   gpre_fld* field)
{
	if (MSC_match(KW_COLLATE))
	{

		if ((field->fld_dtype != dtype_text) &&
			(field->fld_dtype != dtype_cstring) &&
			(field->fld_dtype != dtype_varying))
		{
			PAR_error("COLLATE applies only to character columns");
		}
		if (gpreGlob.token_global.tok_type != tok_ident)
			CPR_s_error("<collation name>");
		gpre_sym* symbol = MSC_find_symbol(gpreGlob.token_global.tok_symbol, SYM_collate);
		if (!symbol)
			PAR_error("The named COLLATION was not found");
		field->fld_collate = (intlsym*) symbol->sym_object;

		// Is the collation valid for declared character set?
		// The character set is either declared (fld_character_set) or inferered
		// from the global domain (fld_global & fld_charset_id)


		if ((field->fld_character_set &&
				field->fld_character_set->intlsym_charset_id != field->fld_collate->intlsym_charset_id)
			||
			(field->fld_global && field->fld_charset_id != field->fld_collate->intlsym_charset_id))
		{
			PAR_error("Specified COLLATION is incompatible with column CHARACTER SET");
		}
		PAR_get_token();
	}
}


//____________________________________________________________