[CALCITE-4788] Does RelOptRulesTest use foreign keys or not?

• Type: Test
• Status: Closed
• Priority: Minor
• Resolution: Not A Problem
• Affects Version/s: 1.27.0
• Fix Version/s: 1.28.0
• Component/s: core
• Assignee: Unassigned
• Reporter: Sicheng Pan
• Created: 20/Sep/21 04:46
• Updated: 20/Oct/21 05:28
• Resolved: 20/Sep/21 13:04

Description

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?