The GitHub Actions job "Check newsfragment PR number" on 
airflow.git/restore-asset-uri-exact-lookup has failed.
Run started by GitHub user seanmuth (triggered by seanmuth).

Head commit for run:
d549e9b731aa850f808dbb163d94b15f7664b515 / seanmuth <[email protected]>
Add exact-match uri filter to GET /assets endpoint

Resolving a single asset by its full URI currently requires uri_pattern,
which compiles to ILIKE '%...%' and cannot use a database index, so it
degrades to a full table scan on large asset tables. This is the fast,
index-backed exact-URI lookup that the Airflow 2 REST API exposed via
GET /datasets/{uri} but that was not carried forward when the endpoint
moved to FastAPI under AIP-84.

The uri query parameter matches an asset by its exact URI using an
equality comparison, backed by a new single-column index on asset.uri
(the existing unique index leads with name and cannot serve uri-only
lookups). Passing it as a query parameter rather than a path segment
avoids the URI-encoding problems that path parameters have with the
'/' and ':' characters in asset URIs.

Report URL: https://github.com/apache/airflow/actions/runs/28815641280

With regards,
GitHub Actions via GitBox


---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to