Database boolean default value not working

Data Service
1

Hello team.
Facing the issue with DB column of type boolean with default value true not working. I set default value to be true, but when creating records via code(JS SDK) or Rest console it creates records with value as false instead of true.
PS: via Backendless UI it works well, as expected.

Steps to reproduce:

  1. there is a table in DB with a column of type boolean which has the default value true.
  2. create a record in DB(Rest console, code, doesn’t matter) without specifying a value for that target column.

expected result: the record is created, and the target column’s value is set to default value(true).
actual result: the record is created with no default value specified for target column(it is set to false).
Example:
I have a table with column boolean_column(Boolean) DefaultValue: true and when creating a record without specifying a value for boolean_column column, the record is created in which boolean_column has value false (expected true).

It worked in that way in Backendless v6, but now we migrated to Backendless v7 and it started to fail, so we trying to understand if this is a bug on the Backendless side or an expected behavior.

Our current backendless version: Pro v7.0.14

2

here are few screenshots to describe.
the DB table was created from scratch manually via Backendless UI for this test, but even tables created via the code migrations behaves the same way.

I also tried to turn Enable dynamic schema definition on/off and it doesn’t help

image
image1780×522 54.3 KB

image
image1833×654 71.1 KB

3

Hello @Sasha_Grin,

I was able to reproduce the issue. We need some more time to investigate and provide either an explanation or a fix.

As a workaround, you can save the object with null for the boolean type. For example, if you have a column isOk with a default value of true, saving an object with {"isOk": null} will result in isOk being set to true.

Here’s an example request using cURL:

curl -X POST -H 'Content-Type:application/json' 'https://<custom-domain>/api/data/MyTable' -d '{"isOk": null}' -i

Response:

HTTP/1.1 200 OK
server: nginx
date: Tue, 18 Mar 2025 09:11:48 GMT
content-type: application/json
content-length: 156
access-control-allow-origin: *
access-control-allow-methods: POST, GET, OPTIONS, PUT, DELETE, PATCH
access-control-allow-credentials: true
strict-transport-security: max-age=31536000; includeSubDomains

{"created":1742289108474,"isOk":true,"name":null,"___class":"A","time":null,"ownerId":null,"updated":null,"objectId":"8D8F23B1-3A1A-4A8B-B9A4-A07E7D116602"}

We’ll update you as soon as we have more details. Thanks for your patience!

1 Like