[Squirrel-sql-users] MS SQL select from a function with an option (recompile) hint

[Alex M. <ale...@bl...>]

If I run a select statement against a table valued function and include OPTION(RECOMPILE) and leave "Limit rows" checked off, the query fails with the following error:

Error: Invalid state, the Connection object is closed.
SQLState:  HY010
ErrorCode: 0

It runs fine w/o row limiting.
The select statements which do not query from a function work fine with the option with or w/o row limiting.

Thanks,
Alex