Idea

Jeremy R avatar image
1 Like"
Jeremy R suggested Jeremy R commented

Allow querying an empty Global Table

Currently, attempting to run an SQL query on a Global Table with 0 rows produces a generic error message (exception: FlexScript exception).

Instead, I think it would be better to handle it as an empty table (that still has all of its columns, but no rows). Any SQL query would only be able to return 0 rows, but that would be fine (as long as it doesn't throw exceptions).

global tablequerysql
· 2
5 |100000

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

Joerg Vogel avatar image Joerg Vogel commented ·

And if the result is a table of 0 rows with a starting table of filled rows.

0 Likes 0 ·
Jeremy R avatar image Jeremy R Joerg Vogel commented ·

Currently, FlexSim SQL queries will successfully return 0 rows if you run a query on a nonempty table but the query returns no results. You only receive an error message if the table has no rows to begin with.

0 Likes 0 ·

No Comments

·

Write a Comment

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

Your Opinion Counts

Share your great idea, or help out by voting for other people's ideas.