LT JOIN table aliases does not support more then one nested iteration

To reproduce

all examples on demo
Working LT JOIN:

SELECT a.timestamp,a.symbol,a.price,b.timestamp,b.symbol,b.price
from trades a lt join (trades) b on symbol limit 10

Extending to one more timestamp back does not work

SELECT a.timestamp,a.symbol,a.price,b.timestamp,b.symbol,b.price,c.timestamp,c.symbol,c.price
from trades a lt join (trades lt join (trades) c on symbol) b on symbol limit 10

Invalid table name or alias

I remember once upon a time this thing worked.. no?

QuestDB version:

8.2.0

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

CLOUD DEMO

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

CLOUD DEMO

Full Name:

Super Richman

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

Reproduce the nested LT JOIN query on the QuestDB demo using version 8.2.0, then trace the SQL JOIN and table-alias handling in the Java codebase. Done means the nested query resolves all aliases and returns the expected rows, with regression coverage for both the working and failing examples.