You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@calcite.apache.org by "Sicheng Pan (Jira)" <ji...@apache.org> on 2021/09/20 04:47:00 UTC

[jira] [Created] (CALCITE-4788) Does RelOptRulesTest use foreign keys or not?

Sicheng Pan created CALCITE-4788:
------------------------------------

             Summary: 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


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)