In a transaction, if I select results to display to the screen, I get the message Query result with x rows discarded.
How can I view those results? Something is amiss with my query and I want to see what the values are in a temp table at a certain point.