Can't set field to NULL

[dcowan-london]

Please answer the questions below, it helps us to track the issue.

1. Database version (Ex: PostgreSQL 10.0): PostgreSQL 13.3

2. TablePlus version (the number on the welcome or about screen, Ex: build 81): 176

3. Linux distro (Ex: Ubuntu 18.04): elementaryOS 5.1.7 (based on Ubuntu 18.04.6)

4. The steps to reproduce this issue: Right click on field and select "Set NULL" and click the checkmark. Error is "ERROR: multiple assignments to same column '{column_name}'".

Noted: If the bug is related to data, please attach an example SQL data.

UPDATE "public"."{table_name}" SET "{column_name}" = NULL,"{column_name}" = NULL WHERE "{field1}" = '{field1value}' AND "{field2}" = '{field2value}' AND "{field3}" = '{field3value}' AND "{field4}" = '{field4value}' AND "{column_name}" = '{previous_column_data}';

Note all values in {} are placeholders by me.

{column_name} is the column of the field I am trying to set to NULL.

Thank you!

[lucacarrara00]

Got the same problem today, on Ubuntu 20.04.

The problem is that after SET the "{column_name}" is duplicated. The temporary solution is just to remove one "{column_name}" by hand and run the query.