We read every piece of feedback, and take your input very seriously.
To see all available qualifiers, see our documentation.
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Describe the bug
CSV empty fields should be handled as NULL, not empty string.
To Reproduce
$ cat address.csv | sq '.data | .[:5]' address_id address address2 district city_id postal_code phone last_update 1 47 MySakila Drive 300 NULL 2020-02-15T06:59:28Z 2 28 MySQL Boulevard 576 NULL 2020-02-15T06:59:28Z 3 23 Workhaven Lane 300 NULL 2020-02-15T06:59:28Z 4 1411 Lillydale Drive 576 NULL 2020-02-15T06:59:28Z 5 1913 Hanoi Way 463 35200 2020-02-15T06:59:28Z
In JSON:
{"address_id": 1, "address": "47 MySakila Drive", "address2": "", "district": "", "city_id": 300, "postal_code": null, "phone": "", "last_update": "2020-02-15T06:59:28Z"} {"address_id": 2, "address": "28 MySQL Boulevard", "address2": "", "district": "", "city_id": 576, "postal_code": null, "phone": "", "last_update": "2020-02-15T06:59:28Z"} {"address_id": 3, "address": "23 Workhaven Lane", "address2": "", "district": "", "city_id": 300, "postal_code": null, "phone": "", "last_update": "2020-02-15T06:59:28Z"} {"address_id": 4, "address": "1411 Lillydale Drive", "address2": "", "district": "", "city_id": 576, "postal_code": null, "phone": "", "last_update": "2020-02-15T06:59:28Z"} {"address_id": 5, "address": "1913 Hanoi Way", "address2": "", "district": "", "city_id": 463, "postal_code": 35200, "phone": "", "last_update": "2020-02-15T06:59:28Z"}
Expected behavior I expected the address2 and district fields to be null in the example above.
address2
district
null
The text was updated successfully, but these errors were encountered:
Fixed.
Sorry, something went wrong.
No branches or pull requests
Describe the bug
CSV empty fields should be handled as NULL, not empty string.
To Reproduce
In JSON:
Expected behavior
I expected the
address2
anddistrict
fields to benull
in the example above.The text was updated successfully, but these errors were encountered: