To reproduce

SELECT * FROM (
  SELECT 456 AS "5_sum"
  UNION ALL 
  SELECT 789 AS "5_sum"
  UNION ALL 
  SELECT 123 AS "5_sum"
)
ORDER BY "5_sum"

Invalid column: 5_sum

We follow the branch that tries to parse the value as a number, even though it is not one.

QuestDB version:

8.2.2+ (master)

OS, in case of Docker specify Docker and the Host OS:

N/A

File System, in case of Docker specify Host File System:

N/A

Full Name:

Nick Woolmer

Affiliation:

QuestDB

Have you followed Linux, MacOs kernel configuration steps to increase Maximum open files and Maximum virtual memory areas limit?

• Yes, I have

Additional context

No response