[CALCITE-2478] SqlAdvisor: purge from_clause when _suggest_ token is located in one of the from sub-queries

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.17.0
• Fix Version/s: 1.18.0
• Component/s: core
• Assignee: Vladimir Sitnikov
• Reporter: Vladimir Sitnikov
• Created: 19/Aug/18 15:32
• Updated: 23/Dec/18 00:12
• Resolved: 05/Sep/18 14:18

Description

Testcase:

select axc from (select (select ^ from dummy) axc from dummy a), dummy b

Expected output:

SELECT * FROM ( SELECT ( SELECT _suggest_ FROM dummy ) axc FROM dummy a )

Actual output:

SELECT * FROM ( SELECT ( SELECT _suggest_ FROM dummy ) axc FROM dummy a ) , dummy b

Issue Links

• links to: PR 773