[CALCITE-5537] Slow test case failures in LatticeSuggesterTest

• Type: Test
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.34.0
• Labels: pull-request-available
• Assignee: peng wang
• Reporter: peng wang
• Created: 21/Feb/23 12:13
• Updated: 14/Mar/23 13:53
• Resolved: 23/Feb/23 16:21

Description

LatticeSuggesterTest#testFoodMartAll

LatticeSuggesterTest#testFoodMartAllEvolve

May be failed in slow test.

The default value of SqlToRelConverter.Config.expand is changed from true to false in CALCITE-3870.

Maybe we can set SqlToRelConverter.Config.expand to true explicitly In these two test case. 

Issue Links

• Discovered while testing: CALCITE-5510 RelToSqlConverter should use ordinal for ORDER BY if the dialect allows
• relates to: CALCITE-5540 Wrong plan for query with COUNT(DISTINCT subQuery)
• links to: GitHub Pull Request #3080