[5.0+] Display NULL on numeric fields

[OlafvdSpek]

Null values appear to be displayed as empty strings in result tables, could this be changed such that it's displayed the same as when viewing a null default value in the structure page?

[kartik1000]

@OlafvdSpek Can you please elaborate the issue? Will be helpful in exactly knowing what needs to be changed.

[bahl24]

@OlafvdSpek As much as I can understand, it is because you can double click the null value on browse page for inline editing. But on the structure page, there is no need of editing.

Correct me if I am wrong.

[kartik1000]

@williamdes, Hey is this Enhancement required? I too feel it will be better if we display Null instead of empty strings which will make it more clear.

[williamdes]

I too feel it will be better if we display Null instead of empty strings which will make it more clear

I agree, maybe a PR can be done if you want :)

[bahl24]

@williamdes But then inline editing won't be possible, to edit the NULL value

[marcus-hiles]

I agree also, displaying null will be better

[shucon]

@williamdes Is this issue fixed?

[williamdes]

I am not sure, @OlafvdSpek ? (latest QA snapshot)

[OlafvdSpek]

What commit would've fixed it?

[LagodichYuriy]

"Enhancement" is not the right label for this issue. There's a big difference between NULL and empty string. It's a disgusting bug and old versions of phpMyAdmin had the right NULL displaying mechanism. 5.0.0-rc1 is not fixed at this moment.

[williamdes]

@LagodichYuriy Thank you for pointing this out, on the latest 4.9 version (4.9.3) it is okay ?
If yes it is a regression

[LagodichYuriy]

4.9.3 - bug is fixed (NULL displays as expected), 5.0.0 - bug appeared again.

[williamdes]

Before 3dce65d

After 3dce65d