pepijnve opened a new pull request, #25887: URL: https://github.com/apache/datafusion/pull/25887
## Which issue does this PR close? - Closes #15960. - Supersedes PR #24200. ## Rationale for this change Catalog-qualified information schema queries currently return metadata from every registered catalog. For example, `my_catalog.information_schema.tables` should describe only `my_catalog`, consistent with PostgreSQL's information schema representing the current database. ## What changes are included in this PR? - The catalog list provided to `InformationSchemaProvider` is now constructed dynamically based on the catalog being queries. An optional 'system' catalog provides the existing global catalog behaviour. All other catalogs are restricted to just their own content. - Unqualified information_schema queries now use the configured default catalog instead of returning metadata from all catalogs. ## What is the testing strategy for this PR? Added multi-catalog SQL logic coverage for qualified and unqualified information schema queries. ## Are there any user-facing changes? Yes. Information schema results are now scoped to the resolved catalog. -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
