A bug of sql union all

Question

question

yexioamu asked Nov 27 2024 at 1:14 PM yexioamu commented Dec 03 2024 at 8:31 AM

A bug of sql union all

a bug of union all sql.fsmWhen i create a GlobalTable ,then use union all, the rows of result is incorrect, it is the last select limit nums。

what can i do for it?

Software Version:

FlexSim 21.2.4

sql

1.png (28.5 KiB)

2.png (25.2 KiB)

a-bug-of-union-all-sql.fsm (25.3 KiB)

· 2

Answer 1 · 2024-12-03T07:21:11Z

Felix Möhlmann answered Dec 03 2024 at 7:21 AM yexioamu commented Dec 03 2024 at 8:31 AM

I have found two possible workarounds:

Nest the select clauses in another select that simply copies the results.

Table.query("SELECT A FROM (SELECT A FROM table WHERE A = 1 LIMIT 2)\
                        UNION ALL\
                        SELECT A FROM (SELECT A FROM table WHERE A = 2 LIMIT 2)");

Or add an extra select clause at the end that you know won't return anything but doesn't have a limit.

Table.query("SELECT A FROM table WHERE A = 1 LIMIT 2\
                        UNION ALL\
                        SELECT A FROM table WHERE A = 2 LIMIT 2\
                        UNION ALL\
                        SELECT A FROM table WHERE A = -1 AND A = 1");

· 1

question