Distinct URLs are broken on nullable text fields

[williamdes]

Describe the bug

Distinct URLs are broken on text fields because they are detected as numeric

To Reproduce

CREATE TABLE `t1` (
  `id` int(11) NOT NULL,
  `text` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,
  `text2` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

INSERT INTO `t1` (`id`, `text`, `text2`) VALUES
(1, 'zz', 'd'),
(2, 'bb', 'f');

Steps to reproduce the behavior:

1. Go to table structure
2. Click on distinct values for nullable column
3. The link is broken

Expected behavior

Working links

Server configuration

• phpMyAdmin version: 5.1

[williamdes]

For information: the code calls getDataCellForNumericColumns for this column

[williamdes]

diff --git a/libraries/classes/Display/Results.php b/libraries/classes/Display/Results.php
index 6ff0992919..fcfee0d0d5 100644
--- a/libraries/classes/Display/Results.php
+++ b/libraries/classes/Display/Results.php
@@ -2950,7 +2950,9 @@ class Results
             // even for a string type
             // for decimal numeric is returning 1
             // have to improve logic
-            if (($meta->numeric == 1 && $meta->type !== 'string') || $meta->type === 'real') {
+            // Nullable text fields and text fields have the blob flag
+            $isNumericAndNotBlob = $meta->numeric == 1 && $meta->blob == 0;
+            if (($isNumericAndNotBlob && $meta->type !== 'string') || $meta->type === 'real') {
                 // n u m e r i c
 
                 $display_params['data'][$row_no][$i]

here is the patch, to be tested
real blob fields do not work for distinct values