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

Enum not sorting alphabetically #34

Open
rbibby opened this issue Jan 16, 2023 · 0 comments
Open

Enum not sorting alphabetically #34

rbibby opened this issue Jan 16, 2023 · 0 comments
Labels
bug Something isn't working

Comments

@rbibby
Copy link
Contributor

rbibby commented Jan 16, 2023

What is the issue?

ENUM values are sorted based on their index numbers, which 
depend on the order in which the enumeration members were listed in the 
column specification. For example, 'b' sorts before 'a' for ENUM('b', 'a').

Steps To Reproduce

  1. Create an enum but don't have the options in alphabetical order in the database
  2. Try and sort on the column and notice it is sorted by the enum index order rather than alphabetically

Expected behaviour

Sort alphabetically

Possible fixes

Needs some consideration on how to fix this, probably need to do some different sorting when the filter type is enum

@rbibby rbibby added the bug Something isn't working label Jan 16, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working
Development

No branches or pull requests

1 participant