#670 Wrong column displayed when data is NULL in previous column(s)

[Nemanja Stambolic]

Adminer: 4.7.1 (latest)
MySQL version: 5.5.5-10.2.21-MariaDB-10.2.21+maria~xenial through PHP extension MySQLi

Please see attached images. Bug and noBug respectively.

Raw SQL works of course. Only Adminer view eats up entire column and mixes up data from two columns where column with NULL values simply vanishes from the view.

[Nemanja Stambolic]

So basically how I stumbled upon the bug: I have mistekenly selected same column twice accepts_head_requests. The adminer somehow then mixed values from the last column max_crawls_per_hour with column title being all good as shown.

[Jakub Vrána]

Selecting the same column twice is not supported but it should be or there should be at least an error message.

[Olaf van der Spek]

Selecting the same column twice is not supported

Why?

[Jakub Vrána]

As of 95e6a659, Adminer now at least removes the duplicate columns from select.