[Feature request] treat bit(1) type as boolean

[spacewander]

It is common to use bit(1) type field to represent boolean type in the schema. Currently, 0 in bit(1) type is shown as ^@ and 1 is shown as ^A in the terminal. Can we treat this type as boolean (shown as true or false) instead of one real bit?

[guest73]

There is one small bug related to this. If I use https://github.com/okbob/pspg as a pager and if I have such bit(1) column in my results all the data in all subsequent columns are displayed blank. With the regular mysql client it works ok. I've tried it with different output formats ascii, csv, plain. We definitely have to fix this somehow.

Those last 2 columns should not be blank.

[guest73]

This ^A ^@ symbols mess the layout for mycli itself without any pager.

[meldafert]

Note that since #876 was fixed, bit(1) fields are displayed as 0x00 and 0x01, which fixes the alignment issue/the columns vanishing with certain pagers. In general, it would still be nicer if they were displayed as false and true instead (or at least just 0 and 1), so this issue is still relevant in my opinion.