To reproduce

query 1: yes good very nice at demo questdb
select timestamp,bid_volume/ask_volume as lolzings,lolzings*bid_price as schmalolzers from core_price
query 2: no good very very bad error, bad query! bad bad query!

select avg(schmalolzers) from (
select timestamp,bid_volume/ask_volume as lolzings,lolzings*bid_price as schmalolzers from core_price
)

why bad query? yes good query :( me very sad.

QuestDB version:

9.2.3

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

unknown

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

unknown

Full Name:

Super

Affiliation:

None

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