Date: 2013-09-02 10:26:21 +0200
From: @mlkersten
To: SQL devs <>
Version: 11.15.11 (Feb2013-SP3)

Last updated: 2014-02-20 15:02:44 +0100

Comment 19106

Date: 2013-09-02 10:26:21 +0200
From: @mlkersten

User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.7; rv:23.0) Gecko/20100101 Firefox/23.0
Build Identifier:

Make the MAL interpreter time out available in SQL.
Preferable to available at transaction level, including the idle time a transaction consumes.

Reproducible: Always

Comment 19113

Date: 2013-09-03 08:51:19 +0200
From: @mlkersten

Most of the stuff was already available in MAL.

Both query and session timeouts can be set by specifying the max seconds allowed.
The session timeout check runs at the beginning of a query.
The query timeout is checked between all MAL instructions.

To make it work, you probable have to re-compile from scratch.

From SQL (once 22_clients.sql is (re-)loaded) you can

call settimeout(10); -- terminates queries after 10 seonds
call settimeout(5,300); -- terminates queries after 5 seconds and session after 5 minutes

call settimeout(0,0); -- turns off the limit (to be called before
session timeout has fired

Comment 19215

Date: 2013-09-30 11:20:22 +0200
From: @sjoerdmullender

This bug was not fixed in Feb2013-SP4 but will be in the next feature release.

Comment 19605

Date: 2014-02-20 15:02:44 +0100
From: @sjoerdmullender

Jan2014 has been released.