[CALCITE-1679] Schemas.path does not traverse schemas with empty-string name

• Type: Improvement
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Affects Version/s: 1.11.0
• Labels: view
• Assignee: Unassigned
• Reporter: Kevin Liew
• Created: 08/Mar/17 07:02
• Updated: 22/Feb/19 01:21

Description

Schemas.path does not traverse schemas with empty-string name but the parsed schema path may be relative to some nested schema with an empty name rather than been relative to the input root-schema.

ie.
rootSchema is "CATALOG"
the view table full-path is "CATALOG".""."VIEW" (the schema name is empty)
names is ("VIEW")

Schemas.path will fail as it tries to find "VIEW" relative to rootSchema but does not try to traverse the intermediate schema.

If the first value in names is not found, we should try to traverse all prepending schema with empty-string name.