Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Bug report: wrong table sorting #570

Open
LutzT opened this Issue Mar 13, 2019 · 1 comment

Comments

Projects
None yet
2 participants
@LutzT
Copy link

LutzT commented Mar 13, 2019

How to reproduce:

  1. execute the commands below
  2. select database HeidiSQL_bugreport at left panel
  3. go to right panel and order tables by name
  4. you will find, that tables are not order alphabetically (see screenshot attached) image description
DROP DATABASE  HeidiSQL_bugreport;
CREATE DATABASE HeidiSQL_bugreport;
CREATE TABLE HeidiSQL_bugreport.`40AB_Abc` (
    `dummy` VARCHAR(32) NOT NULL
)
COLLATE='utf8_general_ci'
ENGINE=MyISAM
;
CREATE TABLE HeidiSQL_bugreport.`2SN_beta` (
    `dummy` VARCHAR(32) NOT NULL
)
COLLATE='utf8_general_ci'
ENGINE=MyISAM
;
CREATE TABLE HeidiSQL_bugreport.`2SN100_beta` (
    `dummy` VARCHAR(32) NOT NULL
)
COLLATE='utf8_general_ci'
ENGINE=MyISAM
;
CREATE TABLE HeidiSQL_bugreport.`2SN100_gamma_3` (
    `dummy` VARCHAR(32) NOT NULL
)
COLLATE='utf8_general_ci'
ENGINE=MyISAM
;
CREATE TABLE HeidiSQL_bugreport.`2SN100_alpha_1` (
    `dummy` VARCHAR(32) NOT NULL
)
COLLATE='utf8_general_ci'
ENGINE=MyISAM
;
CREATE TABLE HeidiSQL_bugreport.`lorem` (
    `dummy` VARCHAR(32) NOT NULL
)
COLLATE='utf8_general_ci'
ENGINE=MyISAM
;
CREATE TABLE HeidiSQL_bugreport.`ipsum` (
    `dummy` VARCHAR(32) NOT NULL
)
COLLATE='utf8_general_ci'
ENGINE=MyISAM
;

Current behavior

wrong ordering of tables

Expected behavior

correct ordering of tables

Possible solution

unknown

Environment

  • HeidiSQL version:
    10.1.0.5464
  • Database system and version:
    MySQL 5.6
  • Operating system:
    Windows

@ansgarbecker ansgarbecker added this to the v10.2 milestone Mar 13, 2019

@ansgarbecker

This comment has been minimized.

Copy link
Collaborator

ansgarbecker commented Mar 13, 2019

Confirmed. Seems my sorting algorithm removes non-digits from names which start with a digit. If you do that virtually here, the names look as follows:

2
40
2100
21001
21003
ipsum
lorem

This is of course wrong.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.