[#MDEV-6597] Bad column name for SELECT '8bit-string' when "SET NAMES binary"

[MDEV-6597] Bad column name for SELECT '8bit-string' when "SET NAMES binary" Created: 2014-08-18 Updated: 2022-09-08
Status:	Open
Project:	MariaDB Server
Component/s:	None
Affects Version/s:	5.3.12, 5.5.39, 10.0.13
Fix Version/s:	5.5

Type:

Bug

Priority:

Minor

Reporter:

Alexander Barkov

Assignee:

Alexander Barkov

Resolution:

Unresolved

Votes:

Labels:

None

Description

Run this SQL script in a UTF8 console:

SET NAMES binary;

SELECT 'aa','aä','äa','ää';

The output is:

+----+-----+-----+------+

| aa | aä  | a   |      |

+----+-----+-----+------+

| aa | aä  | äa  | ää   |

+----+-----+-----+------+

Column names for the third and the fourth columns are wrong.

Generated at Thu Feb 08 07:13:07 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.