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?
A bug of sql union all
FlexSim 21.2.4
Hi @yexioamu,
Thank you for contributing to our community! We couldn't identify a maintained license or subscription linked to your account.
You may need to update your profile information to identify yourself as a license owner or their associate. Check out our article for how to ensure you receive timely support. If you update your profile comment back to let us know - we'll adjust the priority of your post accordingly.
If your current license is expired, please contact your local distributor to renew.
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");
13 People are following this question.
