question

Mischa Spelt avatar image
1 Like"
Mischa Spelt asked anthony.johnson commented

Query works or not, depending on FROM order

I ran into a weird issue where a query that I knew should give me some rows returned an empty result set.

After a lot of trial-and-error, I found out that swapping the order of the tables in the FROM statement fixed the problem.

Is this a bug?

In the attached model, emptyresultset.fsm, run the Script to see the empty result set in the DEBUG table. If you swap the order of the tables in the FROM, as per the comment at the bottom of the script, you will get one row.

FlexSim 17.1.2
querybug reportsql join
emptyresultset.fsm (20.6 KiB)
5 |100000
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

1 Answer

anthony.johnson avatar image
1 Like"
anthony.johnson answered anthony.johnson commented

Yes, this is a bug. We'll get it fixed for the next release.

· 2
5 |100000
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

Mischa Spelt avatar image Mischa Spelt commented ·

@anthony.johnson did you mean 17.1.3? Because the demo model attached to the original post still does not give consistent results for both table orders.

0 Likes 0 ·
anthony.johnson avatar image anthony.johnson ♦♦ Mischa Spelt commented ·

Mischa,

Yes, you are correct, and we managed, in fixing one bug, to introduce another more pernicious one. We will make a new release that fixes this by the end of this week. I apologize for the hassle that this has caused you, and thank you for your patience.

Also, our 17.2 beta, which should be out in the next day or two, includes yet more significant changes to our sql parser engine. Among other minor things, we have added the ability to use FlexScript dot syntax in SQL queries, as well as added support for SQL window functions. Since our SQL parser is apparently still pretty bug-prone, and since Talumis is one of our most advanced users of the SQL capabilities, could you please make sure to try running some of your SQL-using models in the beta when it comes out, and let us know if you run into any problems? That would really be appreciated. Thanks.

1 Like 1 ·