When a record column and its child column are retrieved together, the record column might not be inferred as record type properly

For example, given a following query, the column 'glossary' can be inferred as the TEXT type rather than the RECORD type.

default> select glossary from self_desc_table2 where char_length(glossary."GlossDiv".title) > 0 

This is because columns of the query are inferred in an arbitrary order, and there isn't any routine to resolve the conflict of inferred data type.