Clarification on GetObjects FOREIGN KEY
Open
Type: question
- Dominant language
- C#
- Stars
- 627
- Forks
- 217
- Avg merge
- 17h
- Merged PRs (30d)
- 57
Description
### What would you like help with?
Is the intent of the `FOREIGN KEY` constraints returned by `AdbcConnectionGetObjects` that they include relational constraints in both directions? That is, for a `CUSTOMER` table defined as in [TPC-H](https://docs.snowflake.com/en/user-guide/sample-data-tpch), should it return both `"ORDERS"."CUSTKEY"` (which references `"CUSTOMER"."CUSTKEY"`) and `"NATION"."NATIONKEY"` (which is referenced by `"CUSTOMER"."NATIONKEY"`)?
If so, the documentation could probably be improved by indicating this explicitly.
If not, if it only returns references in one direction then this is a feature gap with ODBC and JDBC.
Contributor guide
Assessment
This issue has not been assessed yet.