[ms, entity metas] add 'actual source' to entities table / base entity metadata cache. Closes #1767090
this is needed since for entities from 'copy based sources' such as
datafeed, we want entity.cw_metainformation() to return as 'source'
the datafeed source, not the system source (ie the source where the
entity is actually stored).
For both performance and bootstraping reasons, we should store this
information in the `entities` table and in the _type_source cache.
/* -*- sql -*-
mysql specific registered procedures,
*/
/* XXX limit_size version dealing with format as postgres version does.
XXX mysql doesn't support overloading, each function should have a different name
NOTE: fulltext renamed since it cause a mysql name conflict
*/
CREATE FUNCTION text_limit_size(vfulltext TEXT, maxsize INT)
RETURNS TEXT
NO SQL
BEGIN
IF LENGTH(vfulltext) < maxsize THEN
RETURN vfulltext;
ELSE
RETURN SUBSTRING(vfulltext from 1 for maxsize) || '...';
END IF;
END ;;