-
Notifications
You must be signed in to change notification settings - Fork 796
Description
Describe the bug
I have a table where various columns have a default value, both integer and character types. If I remove the existing value from a column, it shows "[default]" in the grid display. Trying to save the changes results in an error.
To Reproduce
Steps to reproduce the behaviour:
- Go to Query Tool.
- Select some rows from a table that has some columns defined with default values.
- Edit a column with a default value by clearing its existing value.
- Try to save the changes to the table.
- Error shown: syntax error at or near "WHERE" LINE 2: WHERE
Expected behaviour
On saving the row, the column with the default value should be assigned the default value.
Error message
Error text as shown above. From the log, there is a UPDATE command, example:
UPDATE table SET WHERE primary_key = value;
Clearly, the column(s) to be updated are missing, hence the error.
Screenshots
Not applicable.
Desktop (please complete the following information):
- OS: Windows Server 2019 1809 build 17763.4010
- Version: 6.21
- Mode: Desktop
- Package type: Windows EXE.
Additional context
If any columns without a default value are modified at the same time, then the row is saved correctly. The generated UPDATE statement refers only to the columns without the default values.