[jira] [Created] (CALCITE-5441) Unknown Types value with Postgres and NULL value in dynamic parameter

[Ulrich Kramer (Jira)]

Ulrich Kramer created CALCITE-5441:
--------------------------------------

             Summary: Unknown Types value with Postgres and NULL value in 
dynamic parameter
                 Key: CALCITE-5441
                 URL: https://issues.apache.org/jira/browse/CALCITE-5441
             Project: Calcite
          Issue Type: Bug
            Reporter: Ulrich Kramer


Calcite uses 
{{preparedStatement.setObject(i, (Object)null, SqlType.ANY.id)}} 
in 
{{ResultSetEnumerable::setDynamicParam}} to set a NULL value. 

For Postgres 42.5.1, this will throw an exception: 

{{new PSQLException(GT.tr("Unknown Types value.", new Object[0]), 
PSQLState.INVALID_PARAMETER_TYPE)}}



--
This message was sent by Atlassian Jira
(v8.20.10#820010)