opteryx icon indicating copy to clipboard operation
opteryx copied to clipboard

🪲 [Fuzzer] ORDER BY and DISTINCT on different columns returns too many rows

Open joocer opened this issue 9 months ago • 0 comments

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

To help us respond to your request, please provide the following details about the bug.

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 planetId FROM $satellites WHERE planetId <= 1009708.519 ORDER BY name ASC 

joocer avatar Feb 03 '25 20:02 joocer