作者：p欧阳宏生 | 来源：互联网 | 2023-09-25 10:32
I'd love to see more friendliness when handling binary uuid fields.
My typical use for uuids is in primary keys.
Currently, if you define a field as binary, you get in display a content like
1
| 0x11ea5ee2fa5a30f29ae70242ac1a0003 |
.
It would be nice if, at least with primary keys (where we can reasonably suppose that binary is an uuid and not some kind of data), display were applying a transformation into a human-readable format.
If not possible, it would be nice (as fallback), provide a transformation function to achieve the same result.
Additionally, for pks the binary content should not display a download link.
I'm not sure if this can be done on Mysql 8.0+ only, but even a limited support (i.e. not for mysql 5.7-) would be nice
Other annoyance: it's impossible to search by fk (when both fields are binary uuid). While the select is compiled with correct referenced values, choosing one is leading to an empty result set.
In such case, it's again impossible in browse mode to click on fk field to go to referenced row.
- phpMyAdmin version: 5.0.1
该提问来源于开源项目：phpmyadmin/phpmyadmin
In our use case, we have also encountered the following when using binary UUIDs:
While editing the row with the phpmyadmin UI, it seems to add a
to the end of the binary field.
As demonstration, if the field was
when editing it becomes
. This causes the query to fail due to being "too long".
The dropdown selection for the other foreign fields does not have this, but could have some improvements as well. The selections are
, duplicating the UUID in the dropdown menu.
京公网安备 11010802041100号