[jira] [Created] (CALCITE-2994) Least restrictive type among structs does not consider nullability

["Stamatis Zampetakis (JIRA)" <ji...@apache.org>]

Stamatis Zampetakis created CALCITE-2994:
--------------------------------------------

             Summary: Least restrictive type among structs does not consider nullability 
                 Key: CALCITE-2994
                 URL: https://issues.apache.org/jira/browse/CALCITE-2994
             Project: Calcite
          Issue Type: Bug
            Reporter: Stamatis Zampetakis
            Assignee: Stamatis Zampetakis
             Fix For: 1.20.0


Consider the following high-level example:
{code:sql}
CREATE TYPE Coordinates AS (
  x INT,
  y INT);

CREATE TABLE Address (
  loc1 Coordinates NOT NULL,
  loc2 Coordinates)
{code}

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). 



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)