none
Possible bug in handling Boolean values in ADFv2 Copy Activity from a JSON source.

    Question

  •  I have recently been working with json files in ADFv2 and I believe there is a bug around the way it is handling tristate boolean values in json.

    Consider the following json:


    "data": [
            {
     "bool2bitFails": false
    }
    {
            {
     "bool2bitfails": true
    }
           {
     "bool2bitfails": ""
    }
    ]
    }

    when I try to map a boolean json value to a bit in SQL Server all is well as long as the value is true or false However I believe json allows a empty string to represent null (3rd case above)
    in a normal js environment, this should map to false.

     I suspect that the correct behavior for sql should be to map it to null if the column is nullable and perhaps false if the column is non-nullable. 

    to work around, I tried loading the boolean field into a nvarchar but that returned the same error

    Thursday, August 30, 2018 9:59 PM

All replies