You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
{{ message }}
Repository navigation
[Bug]: Geometry column not truncated when table is joined #20430
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
CREATETABLE `t1` (
`id`int(11) NOT NULL AUTO_INCREMENT,
`p`polygonNOT 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 (SELECT1) AS`1`; -- will display `p` as the full WKT polygon, even with `Partial texts` active
Activity
liviuconcioiu commentedon Aug 19, 2026
Removing the
ifcheck will solve the problem:phpmyadmin/libraries/classes/Sql.php
Line 1502 in 9c41d99
phpmyadmin/templates/display/results/table.twig
Lines 174 to 179 in 9c41d99
liviuconcioiu commentedon Aug 19, 2026
Related #14125