framework/resources/Functional/union/VarcharSubstringAndDate.sql (3 lines of code) (raw):

SELECT SUBSTRING('ABC some text', 1, 3) AS ExtractString UNION SELECT date '2017-04-06';