maria-discuss team mailing list archive

[Roberto Spadim <roberto@xxxxxxxxxxxxx>]

Hi guys
I will comment Justin Swanhart mail, that's reasonable

>>Hi,
>>I suggest creating an MDEV spec for COLUMN_BSON() to return BSON data
which can handle binary (MongoDB uses it to store binary data).

Nice, solve a binary representation problem, maybe we will need
BSON_TO_COLUMN and JSON_TO_COLUMN too


>>In the same MDEV, COLUMN_JSON should be modified to omit binary columns
and return a warning to use COLUMN_BSON for a complete representation of
the data.

I think we should extend the COLUMN_JSON function
instead of
COLUMN_JSON(  dyncol )

"we" could have:

COLUMN_JSON(  dyncol ,  binary_output )

at binary_output we explain how binary values will be returned:

'base64'  -> return as base64
'raw'  -> do what COLUMN_JSON do today
'buffer'  -> like node.js encoding binary as array [12,34,52,42,123, etc
...]
'null' -> return NULL

any binary_output 'conversion' should report a warning that we have 'binary
casting' with column_json function
or maybe, a warning to use column_bson function