026.sql
No OneTemporary
Actions

Size

658 B

Subscribers

None

026.sql
View Options

	-- SWH DB schema upgrade
	-- from_version: 25
	-- to_version: 26
	-- description: update swh_revision_find_occurrence for performance

	insert into dbversion(version, release, description)
	values(26, now(), 'Work In Progress');

	CREATE OR REPLACE FUNCTION swh_revision_find_occurrence(revision_id sha1_git) RETURNS occurrence
	LANGUAGE sql STABLE
	AS $$
	select origin, branch, revision
	from swh_revision_list_children(revision_id) as rev_list(sha1_git)
	left join occurrence_history occ_hist
	on rev_list.sha1_git = occ_hist.revision
	where occ_hist.origin is not null
	order by upper(occ_hist.validity) -- TODO filter by authority?
	limit 1;
	$$;

File Metadata

Mime Type: text/plain
Expires: Sat, Jun 21, 9:23 PM (4 w, 16 h ago)
Storage Engine: blob
Storage Format: Raw Data
Storage Handle: 3282831

Event Timeline