[CALCITE-2994] Least restrictive type among structs does not consider nullability

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.20.0
• Labels: pull-request-available
• Assignee: Stamatis Zampetakis
• Reporter: Stamatis Zampetakis
• Created: 12/Apr/19 17:10
• Updated: 24/Jun/19 15:02
• Resolved: 16/Apr/19 12:41

Description

Consider the following high-level example:

CREATE TYPE Coordinates AS (
  x INT,
  y INT);

CREATE TABLE Address (
  loc1 Coordinates NOT NULL,
  loc2 Coordinates)

The least restrictive type between loc1 and loc2 is the type of loc2 (i.e., a nullable Coordinates type).

The existing code (i.e., RelDataTypeFactory#leastRestrictive) does take into account nullability when the type is structured type (or row type).

Issue Links

• links to: GitHub Pull Request #1165