FWIW, no one else behaves like this (Oracle, MSSQL, and Postgres error, MySQL and SQLite cast to varchar).

Is this due to existing type casting or something explicit with the UNION work.