🪲 SELECT DISTINCT ... ORDER BY - doesn't correctly DISTINCT if ORDER BY columns aren't in the SELECT

[joocer]

trafficstars

Thank you for taking the time to report a problem with Opteryx.

To help us to respond to your request we ask that you try to provide the below detail about the bug.

Describe the bug A clear and specific description of what the bug is. What the error, incorrect or unexpected behaviour was. We should probably error in this situation

Sample Code/Statement If you can, please submit the SQL statement or Python code snippet, or a representative example using the sample datasets.

SELECT DISTINCT Company FROM launches ORDER BY Mission

Additional context Add any other context about the problem here, for example what you have done to try to diagnose or workaround the problem.