maria-discuss team mailing list archive

[Federico Razzoli <federico_raz@xxxxxxxx>]

Why a warning? NULL has a meaning that cannot be represented in other ways. A missing death_date means that you John is alive. death_date=NULL means that we don't know when John has died.
Representing an information in the only correct way should not cause a warning.

Redards
Federico


--------------------------------------------
Mar 3/2/15, Roberto Spadim <roberto@xxxxxxxxxxxxx> ha scritto:

 Oggetto: Re: [Maria-discuss] Restated: JSON cannot represent binary data
 A: "Federico Razzoli" <federico_raz@xxxxxxxx>
 Cc: "Justin Swanhart" <greenlion@xxxxxxxxx>, "Tom Worster" <fsb@xxxxxxxxxx>, "maria-discuss email list" <maria-discuss@xxxxxxxxxxxxxxxxxxx>
 Data: Martedì 3 febbraio 2015, 20:45
 
 back to the question    What *should*
 COLUMN_JSON() do when a dynamic column contains BINARY
 values?
 today what
 should be expect? return "wrong"
 (incompatible with json specs) json value? 
 return null+warning? 
 return
 "wrong"+warning?
 
 i think it's a 'sql_mode' that
 should be set to strict or
 not