cfml

I'm trying to test code to handle queries that run way unexpectedly long.
I'm adding timeout="5" to some cfqueries, and in the query itself, using the SQL Server-specific construct `WAITFOR DELAY '00:01'` to push execution time out enough to trigger a timeout exception in cf.
It's not acting like I'd expect, seems the query times out anyway, which it shouldn't.
Seems like MSSQL treats any WAITFOR as meaning something different that the <https://docs.microsoft.com/en-us/sql/t-sql/language-elements/waitfor-transact-sql?view=sql-server-ver15|docs I've seen>.
Thoughts?

Plot thickens. Far as I can tell the timeout parameter for cfquery doesn't work. This is cf 0218 with SQL Server. I found some <https://www.carehart.org/blog/2010/7/14/hidden_gem_in_cf9_admin_querytimeout|semi-conclusive> semi-<https://tracker.adobe.com/#/view/CF-3041771|evidence> that this has been an issue for a long time and ignored by Adobe, but nothing solid, beyond my own testing.

Does anyone have definitive knowledge about this? <@U01EY27APNH> <@U0BJHDX1Q>

Alternatively, is there any way to tell SQL Server to throw if query execution takes longer than an amount of time you say?