* fix logic
* clear all tuples immediately when there is no chance of returning a resultset