Hi,
I’ve been debugging some issues in the Trafodion compiler where the fix involves transforming the query tree in a certain way. One issue I’m running into is getting the transformation right. What would be really helpful is some utility that would show the details of a tree (the RelExpr nodes and all the dangling ItemExpr subtrees under it, complete with ValueIDs) so I could compare my transformation with other transformations; that is, so I can get a visual picture of what a good transformation looks like. I have been using the DISPLAY utility, but it doesn’t seem to show the ItemExpr subtrees. Perhaps there’s a bug in there that needs to be fixed? The ItemExpr nodes have a display() method that is handy to call from gdb. If I could have something like that on RelExpr nodes as well, and with ValueIDs added in all the ItemExpr nodes, that would be great, I think. Perhaps this capability exists and I just haven’t stumbled upon it yet? Thanks for any suggestions, Dave
