- When using subquery join lateral table function as followed:
'SqlValidatorException: Column 'F0' not found in any table' was thrown out.
I find the reason is that SqlValidatorImpl add the namespace of Identifier 's.t' to the children of tableScope,but not the subquey's namespace,just as the code show bellow in SqlValidatorImpl#registerFrom:
I think the namespace of JoinScope's left child should be the children of tableScope which was referenced by the table function,just as the code show bellow in SqlValidatorImpl#registerFrom:
After this modification,the case upon runs well.
Is there any problem for this modification? Any suggestions is welcomed.Thanks a lot.