[
https://issues.apache.org/jira/browse/CALCITE-4788?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17417647#comment-17417647
]
Stamatis Zampetakis commented on CALCITE-4788:
----------------------------------------------
Hi [~Macronova], for general questions it is better to use the dev@ list
instead of creating JIRAs.
The only effort that I remember around foreign keys in Calcite was done in
CALCITE-1731 for supporting certain view rewrittings. If you want more
information I would suggest to look in the commit which introduced the
respective APIs (CALCITE-1731). You can find also some relevant discussion in
CALCITE-2967.
To answer your question, I don't know of any core rules exploiting foreign key
contraints (apart those for view based rewritting), and I doubt there is any
test in {{RelOptRulesTest}} class.
> Does RelOptRulesTest use foreign keys or not?
> ---------------------------------------------
>
> Key: CALCITE-4788
> URL: https://issues.apache.org/jira/browse/CALCITE-4788
> Project: Calcite
> Issue Type: Test
> Components: core
> Affects Versions: 1.27.0
> Reporter: Sicheng Pan
> Priority: Minor
>
> It seems that the tests for rewrite rules depends on the famous SCOTT table
> from Oracle, yet it also seems unclear if there exists foreign key
> constraints between the EMP and DEPT tables. If there are such constraints,
> are they considered in any optimization rules (CoreRules)? And if so, are
> these constraints stored in RelOptTable?
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
