CAP: incorrect DB insert of boolean values in string fields from CSV

[alicegavanelli]

Dear Experts,

I have an entity with a string field called "defaultValue".

entity PropertiesTest : cuid { 
    defaultValue : String(1000); 
}

If in this field I put string "true" or "false", the value is interpreted as boolean and is converted to "1" and "0".

Data are inserted by csv file. I have tried also with quotation marks.

ID;defaultValue
bc1c3c82-6ade-11eb-9439-0242ac130002;true
773a6a34-6adf-11eb-9439-0242ac130002;false
7b96940e-6adf-11eb-9439-0242ac130002;alice test
7b96940e-6adf-11eb-9439-0242ac130005;'false'
7b96940e-6adf-11eb-9439-0242ac130006;"false" 

If I try by OData, the string is correctly inserted.

HTTP/1.1 200 OK
{
  "d": {
    "ID": "773a6a34-6adf-11eb-9439-0242ac130002",
    "defaultValue": "false",
    "__metadata": {
      "type": "WTest.PropertiesTest",
    }
  }
}

We have solved using a workaround but maybe it should be fixed.

Best.

[gregorw]

Please file that also as an Issue via the SAP Service Marketplace.

[alicegavanelli]

Thank you Gregor,

I've opened the incidente:

161611 / 2021 CAP: incorrect DB insert of boolean values in string fields from CSV

Best

Alice

[chgeo]

Thanks for reporting. We will track progress in the incident now. Please understand that we cannot keep this community issue up to date as well.

[gregorw]

So Alice please give us an update when you've got a solution from SAP.

[alicegavanelli]

SAP hasn't given me any answer yet.

[gregorw]

Any updates?

[alicegavanelli]

Unfortunately not yet.

The incident is still in "In process by SAP".

I had asked for a feed-back in April but no one answered me.

It will certainly be my care to update you as soon as SAP will answer me.

[gregorw]

I would suggest to reach out to the SAP Support Hotline and ask for a speedup.

[gregorw]

I've now also filed an issue: 757245 / 2021

[alicegavanelli]

Has SAP answered to you?

[gregorw]

No. Status "in processing" and that since 17th November 2021.

[steffenwaldmann]

Hi Alice,

Good news, we shipped a fix for this issue in the most recent @sap/cds release (5.9.0). The SQLite CSV importer will now interpret quoted "true" and "false" as strings instead of Booleans.

Best regards,

Steffen