Visualization GIS doesn't work

[erdnaaa]

Describe the bug

i had a column that shows linestring and i can see the visualization of the data in browse tab, however if i run a query and click visualize data, it doesn't show anything

To Reproduce

Steps to reproduce the behavior:

1. Create some linestring data
2. Go to SQL tab
3. run SELECT *
4. Click Visualize GIS Data
5. Nothing

Expected behavior

The line should be visible

Screenshots

This one works perfectly if i click the visualize button on browse tab

If i use query, it doesn't show

Server configuration

• Operating system: Windows 10
• Web server: xampp 3.3.0 (Apache/2.4.51 (Win64) OpenSSL/1.1.1l PHP/8.0.12)
• Database version: libmysql - mysqlnd 8.0.12
• PHP version: 8.0.12
• phpMyAdmin version: 5.1.1

Client configuration

• Browser: Chrome Version 95.0.4638.69
• Operating system: Windows 10

[MoonE]

A query like

SELECT * FROM `geometries` WHERE label = '1';

is changed by the visualization to

SELECT ST_ASTEXT(`point`) AS `point`, ST_SRID(`point`) AS `srid` FROM (
  SELECT * FROM `geometries` WHERE label = '1';
) AS `temp_gis` LIMIT 0, 25

Notice the semicolon at the end of the original query is kept and causes a syntax error.

[MoonE]

When clicking on the browse button to view a table the query is executed / displayed without a semicolon. When it is edited inline, a semicolon is automatically added.

Should a semicolon be added to the query when a table is browsed to be consistent?

phpmyadmin/libraries/classes/Sql.php

Lines 533 to 534 in 090d2ee

	$sqlQuery = 'SELECT * FROM ' . Util::backquote($table)
	. $defaultOrderByClause;

The resulting sql error is silently ignored here

phpmyadmin/libraries/classes/Gis/GisVisualization.php

Lines 252 to 260 in 090d2ee

	private function fetchRawData()
	{
	global $dbi;
	$modified_result = $dbi->tryQuery($this->modifiedSql);
	if ($modified_result === false) {
	return [];
	}

Would it be possible to show an error message instead?

[williamdes]

Thank you for the report and fix @MoonE
Sorry for the response time