[Bug]: Geometry column not truncated when table is joined
Author: M393Created Aug 19, 2026Updated Aug 19, 2026
LabelsBug
Describe the bug
There is an inconsistency when displaying geometry columns.
A normal select displays the column as [GEOMETRY - 461 B]``, but when the table is used in a join it displays the full wkt data, without truncating it, even with Partial texts` active (the default).
I get that without a unique id it might not be possible to link to the data like in the plain select, but it should respect the max length for partial texts.
How to Reproduce
CREATE TABLE `t1` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`p` polygon NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB;
INSERT INTO `t1` (`p`) VALUES (ST_GeomFromText('POLYGON((45.15387153625488 41.1986026763916,45.0229434967041 41.29705238342285,43.460771560668945 41.11296272277832,43.75193977355957 40.739999771118164,43.65749549865723 40.108598709106445,44.34721565246582 40.02388954162598,44.77886390686035 39.70638465881348,45.083322525024414 39.76804542541504,45.81998634338379 39.54972267150879,46.17824745178223 38.84115028381348,46.54037666320801 38.87558937072754,46.54138374328613 39.56443977355957,45.5958194732666 39.978044509887695,46.00193977355957 40.22554969787598,45.15387153625488 41.1986026763916),(45.009992599487305 41.03305244445801,45.00111198425293 41.08888053894043,45.045270919799805 41.0352725982666,45.009992599487305 41.03305244445801),(45.19582176208496 40.99777030944824,45.24527168273926 40.97694206237793,45.22916221618652 40.96915245056152,45.19582176208496 40.99777030944824),(45.57305335998535 40.632490158081055,45.513051986694336 40.607221603393555,45.51749229431152 40.66554069519043,45.57305335998535 40.632490158081055))'));
SELECT * FROM `t1`; -- will display `p` as a link with text [GEOMETRY - 461 B]
SELECT `t1`.* FROM `t1` JOIN (SELECT 1) AS `1`; -- will display `p` as the full WKT polygon, even with `Partial texts` activeExpected behavior
No response
Screenshots
Operating System
Windows
Web Server
No response
Database Server
MariaDB
Database version
11.4.12-MariaDB
PHP version
8.1
phpMyAdmin version
5.2.3
browser
No response
Additional context
No response
Source: phpmyadmin/phpmyadmin