Union with no-table-select (eg: select now()) will error, and following no-table-select will hang

Raised by: @sevenFH 
```
select id from testdb_test3 union select now(); // error
select * from testdb_test3;  //succeed
select abs(-1);  //hang
```