[CALCITE-4535] ServerDdlExecutor cannot execute DROP commands with qualified object names

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.26.0
• Fix Version/s: 1.27.0
• Component/s: server
• Labels: pull-request-available
• Assignee: Vladimir Ozerov
• Reporter: Vladimir Ozerov
• Created: 13/Mar/21 10:57
• Updated: 28/Aug/24 16:54
• Resolved: 15/Apr/21 04:18

Description

Consider the query DROP TABLE s.t. The ServerDdlExecutor will attempt to resolve the default schema path, and the would try to invoke SqlIdentifier.getSimple on the s.t identifier. When assertions are enabled this would lead to an AssertionError. When assertions are disabled this would lead to an incorrectly resolved table name: s instead of t.

All DROP commands are affected.

Issue Links

• relates to: CALCITE-6553 In server, several CREATE and DROP commands are incorrect if schema does not exist
• links to: GitHub Pull Request #2371