Mismatch columns manes / data

Problem found when connect to Microsoft SQL -> open database -> open table -> use "Data" sheet view.

When database contains more than 10 columns, column names mismatch to its data.

See attachment, where shown difference between incorrect "Data" view and "select * SQL query" :-)

Which HeidiSQL version are you running?

Which HeidiSQL version are you running?

Actual stable version {9.3}

Could you please update to the latest nightly build to see if that was already fixed? (Just click on Help > Check for updates, then on "Download and install build xyz")

Hi, now I'm on heidisql32.r5051

"Data" sheet display "no data" (there are SQL errors in log) - see. "Data.gif"

"Query" sheet show data correctly - see. "Query.gif"

Hi, I'm also running into this issue. I can replicate it as follows:

HeidiSQL version 9.5.5453 (64 Bit) on Windows 10

Server running on the same machine is:

Sample SQL commands (attached):

DROP DATABASE IF EXISTS colswap;
CREATE DATABASE colswap;
USE colswap;
CREATE TABLE components (Number VARCHAR(50) PRIMARY KEY, Category TINYTEXT);
INSERT INTO components(Number, Category) VALUES ('120-00001', 'Capacitor');
CREATE VIEW colview AS SELECT Number, Category FROM components;

The data looks like this:

The view has the columns swapped:

The problem goes away when I use a different version of MySQL (5.7.xx) on a Linux machine, or if I use another UI client such as SQLyog or MySQL Workbench.

So is this a bug?

thank you Michael