Describe the bug
You can union columns with different types. And it crashes if we order by this column
To Reproduce
it is just strange behavior:
select 1 a union all select 'a';
+---+
| a |
+---+
| 1 |
| a |
+---+
it should work, however since 1 is an integer and 1.1 is a decimal, it crashes:
select 1 a union all select 1.1 order by 1;
Additional context
Physical Sort Node does concat and it crashes. Looks like Union node has to autocast numeric types and returns error for rest types;
Describe the bug
You can union columns with different types. And it crashes if we order by this column
To Reproduce
it is just strange behavior:
select 1 a union all select 'a';it should work, however since 1 is an integer and 1.1 is a decimal, it crashes:
select 1 a union all select 1.1 order by 1;Additional context
Physical Sort Node does concat and it crashes. Looks like Union node has to autocast numeric types and returns error for rest types;