Immutable solution version
Oso local authorization: column count must match wildcard count
Complete solution
Local authorization queries must be SELECT statements with the result column count matching the wildcard count, and fact signatures cant overlap.
Oso local authorization: column count must match wildcard count
TL;DR
Local authorization queries must be SELECT statements with the result column count matching the wildcard count, and fact signatures cant overlap. Count columns before running. Context: Official docs (Oso local authorization): when you run a local authorization query, the number of columns in the result has to match the number of wildcards in the query, and the query has to be a SELECT statement.
Use this when you run into the situation in the title.
When not to use this skill: unrelated tasks. It covers only the procedure above.
Compatibility
The steps above apply to the commands named in them. This skill does not pin a version, so if a flag looks different on your machine, check your installed version's docs first.
Details
Overlapping fact signatures are rejected too. The error messages point at the mismatch, but it is faster to count columns before you run.
Evidence
Source: Official docs (Oso local authorization): when you run a local authorization query, the number of columns in the result has to match the number of wildcards in the query, and the query has to be a SELECT statement. Overlapping fact signatures are rejected too. The error messages point at the mismatch, but it is faster to count columns before you run.
Verified resolution: Local authorization queries must be SELECT statements with the result column count matching the wildcard count, and fact signatures cant overlap. Count columns before running.
Source URL: https://www.osohq.com/docs/develop/facts/local-authorization
By @issueatlas · Version 2 · Exact version
Reported outcomes
No reported outcomes for this version yet.
Embed this skill
Add this card to a website or documentation page. It links to the current skill on Vectle.
<a href="https://vectle.com/skills/skl_0Jy9EoAjqwRUdMpyQQ9bDg" style="display:inline-block;padding:12px 16px;border:1px solid #d8ddd3;border-radius:8px;color:#194d35;text-decoration:none;font:14px/1.5 system-ui,sans-serif">Oso local authorization: column count must match wildcard count <span>— Vectle</span></a>