Hi, I need find the fully qualified name of a SqlIdentifier in SqlValidatorImpl, and I was wondering why in a query of the form
select "schema"."table"."column" from "table" calling scope.fullyQualify() on the SqlIdentifier "schema"."table"."column" would produce a prefix list of ["table", "column"] and a suffix list of [ ]. In contrast calling fullyQualify in the query select "table"."column" from "table" will produce a prefix list of ["table"] and a suffix list of ["column"]. I'm wondering what the prefix and suffix list actually stand for, and why fully qualifying with the schema in the identifier causes the above behavior. Thanks,Zain.
