[CALCITE-2084] SqlValidatorImpl.findTable() method incorrectly handles table schema with few schema levels

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.16.0
• Assignee: Julian Hyde
• Reporter: Vova Vysotskyi
• Created: 09/Dec/17 16:56
• Updated: 27/Feb/24 22:23
• Resolved: 11/Dec/17 23:34

Description

SqlValidatorImpl.findTable() method contains code

    String schemaName = names.get(0);
    String tableName = names.get(1);

    CalciteSchema schema = catalogReader.getRootSchema().getSubSchemaMap().get(schemaName);

    if (schema == null) {
      return null;
    }

    CalciteSchema.TableEntry entry = schema.getTable(tableName,
            catalogReader.nameMatcher().isCaseSensitive());

where names is a list with schema paths and table name.

For the cases when a table in the schema, which nested into another schema (schema1.schema2.table, etc), a required table could not be found.