Ignores nullable columns

[avoidik]

Hello,

Great tool, I was exploring some data, and stumbled upon an issue, when optional columns have been dropped, here is a basic repro case:

$ echo -e '{"method": "GET"}\n{"method": "POST", "meta.user": "with.dot"}' | trdsql "SELECT * FROM -"
"{""method"": ""GET""}"
"{""method"": ""POST"""

is this something expected?

[noborus]

yes. If the number of columns is not constant, you need to specify the number of rows to pre-read. It is recommended to specify it as follows.

echo -e '{"method": "GET"}\n{"method": "POST", "meta.user": "with.dot"}' |trdsql -ir 2 "SELECT * FROM -"
"{""method"": ""GET""}",
"{""method"": ""POST"""," ""meta.user"": ""with.dot""}"

[avoidik]

Thanks, that's it!