Details
-
Bug
-
Status: Open
-
Major
-
Resolution: Unresolved
-
None
-
None
-
None
-
None
Description
FAILED: Error in semantic analysis: Schema of both sides of union should match: Column time is of type bigint on first table and type int on second table
...makes perfect sense, assuming that there are only two tables being unioned. However, UNION ALL can be used to tie together many queries (more than 2). The above error was generated when column "time" was of type bigint in the first, second, and third tables, and of type int in the fourth.
This could be fixed either by adding a row/column number of where the errors occurred:
Column time is of type bigint at line 14:15 and type int at line 18:15
...or by using the actual table indices:
Column time is of type bigint on table 3 and type int on table 4.