TVCs can be used separately, with UNION/UNION ALL, in derived tables,
in views and in common table expressions.

Tests corrected.
Test results added.