Unable to update Postgresql column to null in Trino

[qikijames]

Getting the error message "Value is missing" when an SQL update attempts to set a NULLABLE column to NULL.

trino:public> update test set updated_by=null  where id='f75afcdb-6545-4675-b341-4fdf17a9d14b';

Query 20241120_170254_00032_x2wwq, FAILED, 1 node
Splits: 1 total, 0 done (0.00%)
0.04 [0 rows, 0B] [0 rows/s, 0B/s]

Query 20241120_170254_00032_x2wwq failed: Value is missing

The same command works when directly use the psql.

db=# update test set updated_by=null where id='f75afcdb-6545-4675-b341-4fdf17a9d14b';
UPDATE 1

Trino version: 462 Postgresql server 16.4

[wendigo]

@ebyhr ptal

[ebyhr]

Here's the full stacktrace:

Query 20241120_233613_00032_py2uc failed: Value is missing
com.google.common.base.VerifyException: Value is missing
    at io.trino.plugin.jdbc.DefaultQueryBuilder.lambda$prepareStatement$12(DefaultQueryBuilder.java:295)
    at java.base/java.util.Optional.orElseThrow(Optional.java:403)
    at io.trino.plugin.jdbc.DefaultQueryBuilder.prepareStatement(DefaultQueryBuilder.java:295)
    at io.trino.plugin.postgresql.PostgreSqlClient.update(PostgreSqlClient.java:967)
    at io.trino.plugin.jdbc.ForwardingJdbcClient.update(ForwardingJdbcClient.java:480)
    at io.trino.plugin.jdbc.jmx.StatisticsAwareJdbcClient.lambda$update$51(StatisticsAwareJdbcClient.java:500)
    at io.trino.plugin.jdbc.jmx.JdbcApiStats.wrap(JdbcApiStats.java:34)
    at io.trino.plugin.jdbc.jmx.StatisticsAwareJdbcClient.update(StatisticsAwareJdbcClient.java:500)
    at io.trino.plugin.jdbc.RetryingJdbcClient.update(RetryingJdbcClient.java:510)
    at io.trino.plugin.jdbc.CachingJdbcClient.update(CachingJdbcClient.java:638)
    at io.trino.plugin.jdbc.CachingJdbcClient.update(CachingJdbcClient.java:638)
    at io.trino.plugin.jdbc.DefaultJdbcMetadata.executeUpdate(DefaultJdbcMetadata.java:1312)
    at io.trino.plugin.base.classloader.ClassLoaderSafeConnectorMetadata.executeUpdate(ClassLoaderSafeConnectorMetadata.java:757)
    at io.trino.tracing.TracingConnectorMetadata.executeUpdate(TracingConnectorMetadata.java:895)
    at io.trino.metadata.MetadataManager.executeUpdate(MetadataManager.java:1322)
    at io.trino.tracing.TracingMetadata.executeUpdate(TracingMetadata.java:775)
    at io.trino.sql.planner.LocalExecutionPlanner$Visitor.lambda$visitTableUpdate$63(LocalExecutionPlanner.java:3638)
    at io.trino.operator.TableMutationOperator.getOutput(TableMutationOperator.java:122)
    at io.trino.operator.Driver.processInternal(Driver.java:403)
    at io.trino.operator.Driver.lambda$process$8(Driver.java:306)
    at io.trino.operator.Driver.tryWithLock(Driver.java:709)
    at io.trino.operator.Driver.process(Driver.java:298)
    at io.trino.operator.Driver.processForDuration(Driver.java:269)
    at io.trino.execution.SqlTaskExecution$DriverSplitRunner.processFor(SqlTaskExecution.java:890)
    at io.trino.execution.executor.dedicated.SplitProcessor.run(SplitProcessor.java:77)
    at io.trino.execution.executor.dedicated.TaskEntry$VersionEmbedderBridge.lambda$run$0(TaskEntry.java:201)
    at io.trino.$gen.Trino_testversion____20241120_233436_71.run(Unknown Source)
    at io.trino.execution.executor.dedicated.TaskEntry$VersionEmbedderBridge.run(TaskEntry.java:202)
    at io.trino.execution.executor.scheduler.FairScheduler.runTask(FairScheduler.java:172)
    at io.trino.execution.executor.scheduler.FairScheduler.lambda$submit$0(FairScheduler.java:159)
    at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:572)
    at com.google.common.util.concurrent.TrustedListenableFutureTask$TrustedFutureInterruptibleTask.runInterruptibly(TrustedListenableFutureTask.java:131)
    at com.google.common.util.concurrent.InterruptibleTask.run(InterruptibleTask.java:76)
    at com.google.common.util.concurrent.TrustedListenableFutureTask.run(TrustedListenableFutureTask.java:82)
    at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1144)
    at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:642)
    at java.base/java.lang.Thread.run(Thread.java:1575)