Files
aevolution/migrations/0019_cellular_action_records.sql
dingo 08519b66af
Foundation / checks (deploy) (push) Successful in 5s
Foundation / checks (checks) (push) Failing after 40s
Foundation / checks (ecs) (push) Successful in 1m50s
Foundation / checks (tsan) (push) Canceled after 0s
Foundation / postgres-tools (push) Canceled after 0s
Foundation / server-image (push) Canceled after 0s
Foundation / image (push) Canceled after 0s
Foundation / checks (postgres) (push) Canceled after 26s
Foundation / checks (network) (push) Canceled after 1m49s
Foundation / checks (client) (push) Canceled after 2m29s
Add cellular durable action record lookup
2026-10-10 23:05:10 -04:00

56 lines
2.7 KiB
PL/PgSQL

-- M11.3d-5e, ADR-0112: persist canonical biological input and cellular result.
-- Existing kind-1 probe rows remain byte-for-byte identifiable by NULL input.
ALTER TABLE evolution.region_actions ADD COLUMN input_bytes bytea;
ALTER TABLE evolution.region_actions ADD COLUMN result smallint NOT NULL DEFAULT 1;
ALTER TABLE evolution.region_actions DROP CONSTRAINT region_actions_kind_check;
ALTER TABLE evolution.region_actions ADD CONSTRAINT region_actions_kind_check CHECK (kind IN (1, 2));
CREATE FUNCTION evolution.valid_cellular_action_input(p_input bytea, p_tick evolution.u64)
RETURNS boolean LANGUAGE plpgsql IMMUTABLE STRICT
SET search_path = pg_catalog, pg_temp AS $$
BEGIN
IF octet_length(p_input) <> 24 THEN
RETURN false;
END IF;
IF evolution.manifest_uint(p_input, 0, 8) = 0
OR evolution.manifest_uint(p_input, 0, 8) <> p_tick OR get_byte(p_input, 12) > 1
OR substring(p_input FROM 14 FOR 3) <> '\x000000' THEN
RETURN false;
END IF;
IF get_byte(p_input, 12) = 0 AND substring(p_input FROM 17 FOR 8) <> '\x0000000000000000' THEN
RETURN false;
END IF;
RETURN true;
END $$;
ALTER TABLE evolution.region_actions ADD CONSTRAINT region_actions_result_input_check CHECK (
(kind = 1 AND result = 1 AND input_bytes IS NULL) OR
(kind = 2 AND result = 5 AND input_bytes IS NOT NULL AND
evolution.valid_cellular_action_input(input_bytes, tick))
);
CREATE FUNCTION evolution.find_region_action_record(p_world evolution.u64,
p_region evolution.u64, p_holder uuid, p_epoch evolution.u64, p_account uuid,
p_action evolution.u64)
RETURNS TABLE(action_region evolution.u64, action_tick evolution.u64,
action_commit evolution.u64, action_kind smallint, action_result smallint,
action_input bytea)
LANGUAGE plpgsql SECURITY DEFINER SET search_path = pg_catalog, pg_temp AS $$
BEGIN
IF p_account IS NULL OR p_action IS NULL THEN
RAISE EXCEPTION 'invalid action request' USING ERRCODE = '22023';
END IF;
PERFORM evolution.check_region_lease(p_world, p_region, p_holder, p_epoch);
RETURN QUERY SELECT a.region_id, a.tick, a.commit_sequence, a.kind, a.result, a.input_bytes
FROM evolution.region_actions a
WHERE a.world_id = p_world AND a.account_id = p_account AND a.action_id = p_action;
END $$;
REVOKE ALL ON FUNCTION evolution.valid_cellular_action_input(bytea,evolution.u64),
evolution.find_region_action_record(evolution.u64,evolution.u64,uuid,evolution.u64,uuid,
evolution.u64) FROM PUBLIC;
GRANT EXECUTE ON FUNCTION
evolution.find_region_action_record(evolution.u64,evolution.u64,uuid,evolution.u64,uuid,
evolution.u64) TO :"runtime_role";
INSERT INTO evolution.schema_migrations(version, sha256) VALUES (19, :'migration_sha_19');