Bug #114315 Field_name has one more space when using ignore_space

Description:
Field_name has one more space when setting sql_mode=ignore_space.

How to repeat:
➜  ~ mysql -uroot --column-type-info

mysql> set sql_mode='ignore_space';
mysql> select current_timestamp from dual;
Field   1:  `current_timestamp `   <--one more whitespace
Catalog:    `def`
Database:   ``
Table:      ``
Org_table:  ``
Type:       DATETIME
Collation:  binary (63)
Length:     19
Max_length: 19
Decimals:   0
Flags:      NOT_NULL BINARY

+---------------------+
| current_timestamp   |
+---------------------+
| 2024-03-12 17:00:36 |
+---------------------+
1 row in set (0.00 sec)

mysql> set sql_mode='STRICT_TRANS_TABLES';
Query OK, 0 rows affected, 1 warning (0.00 sec)

mysql> select current_timestamp from dual;
Field   1:  `current_timestamp`   <-- no whitespace
Catalog:    `def`
Database:   ``
Table:      ``
Org_table:  ``
Type:       DATETIME
Collation:  binary (63)
Length:     19
Max_length: 19
Decimals:   0
Flags:      NOT_NULL BINARY

+---------------------+
| current_timestamp   |
+---------------------+
| 2024-03-12 17:02:05 |
+---------------------+
1 row in set (0.00 sec)

Suggested fix:
I have read the mysql refernece manual section about ignore_space: 'Permit spaces between a function name and the ( character. '.The above phenomenon is inconsistent with this description and will lead to error when getting value by actual field_name.

FIX: right trim whitespace if no spectified alias

Hello hao chen,

Thank you for the report and test case.

regards,
Umesh