# E071-05: Columns combined via table operators need not have exactly the same data type

statement ok
CREATE TABLE TABLE_E071_05_01_011 ( ID INT PRIMARY KEY, A INT, C FLOAT );

statement ok
CREATE TABLE TABLE_E071_05_01_012 ( ID INT PRIMARY KEY, B FLOAT, D INT );

statement ok
INSERT INTO TABLE_E071_05_01_011(ID,A,C) VALUES (0,1,1.2),(1,2,2.3),(2,1,5.4)

statement ok
INSERT INTO TABLE_E071_05_01_012(ID,B,D) VALUES (1,2.12,23)

query II rowsort
SELECT A,C FROM TABLE_E071_05_01_011 UNION ALL SELECT B,D FROM TABLE_E071_05_01_012
----
1.0 1.2
1.0 5.4
2.0 2.3
2.12 23.0

query II rowsort
SELECT B,D FROM TABLE_E071_05_01_012 UNION ALL SELECT A,C FROM TABLE_E071_05_01_011
----
1.0 1.2
1.0 5.4
2.0 2.3
2.12 23.0