Column sorting does not work when names contain dots

[MoonE]

Describe the bug

A clear and concise description of what the bug is.

To Reproduce

Steps to reproduce the behavior:

1. Create a table like this:

CREATE TABLE `as.df` (
  `i.d` int(11) NOT NULL AUTO_INCREMENT,
  `a.b.c` int(11) NOT NULL,
  PRIMARY KEY (`i.d`)
);

INSERT INTO `as.df` (`i.d`, `a.b.c`) VALUES
(1, 1),
(2, 2);

2. Browse table
3. Click column header to change sorting
4. Nothing happens

Expected behavior

The column should be sorted.

Server configuration

• Operating system: Linux
• Web server: Apache 2.4
• Database version: MariaDB 10.11.6
• PHP version: 8.2
• phpMyAdmin version: 5.2.2 da10e0b

Client configuration

• Browser: Firefox 125.0.3
• Operating system: Linux

Additional context

The code uses str_contains($clause, '.') to check whether the name has table and column parts and explode('.', $clause) to split table from column.

phpmyadmin/libraries/classes/Display/Results.php

Lines 1758 to 1760 in cfb05d2

	foreach ($sortExpressionNoDirection as $index => $clause) {
	if (str_contains($clause, '.')) {
	$fragments = explode('.', $clause);

The name should have never been concatenated in the first place, better use an array.

This problem affects a few other places where explode is used, too.