Hello. My name is Bruno, and I'm a Software Engineer student at University of Minho.
I am developing a Calcite application that works like a translator from SQL to Unicage language. Whenever i do a Join with Selection of Rows, it just always seems to do the pushing of the LogicalProject and the LogicalSort past the Join. I have tried to remove the rules that can transpose the Filter, Sort and Joins, and ddi change the computeSelfOfCost functions so that the Join tries to be done first, but then it just always does a scan of the file. Can you help me with this? What can be the best solution? Com os melhores cumprimentos, Bruno Dias...