You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
postgres=# select '1.2' as a union select 2.3 as b union select 3 as b ;
a
-----
2.3
3
1.2
(3 rows)
postgres=# \gdesc
Column | Type
--------+---------
a | numeric
(1 row)
Maybe we can open a ticket support this ?
In datafusion
SELECT 1 as NUMBER union SELECT '1' ;
Plan("UNION ALL schemas are expected to be the same")
❯ SELECT 1 as NUMBER union SELECT '1';
+--------+
| number |
+--------+
| 1 |
+--------+
1 row in set. Query took 0.013 seconds.
❯ SELECT 1 as NUMBER union all SELECT '1';
+--------+
| number |
+--------+
| 1 |
| 1 |
Activity
Jefffrey commentedon Nov 14, 2022
Seems to be resolved as of master 96512ac
Running on datafusion-cli:
Probably fixed by #3407?
Ted-Jiang commentedon Nov 14, 2022
@Jefffrey Thanks
i will close this issue