[MDEV-7010] Docs: KB page suggests wrong syntax for per-query MAX_STATEMENT_TIME Created: 2014-11-02  Updated: 2015-01-28  Resolved: 2014-11-05

Status: Closed
Project: MariaDB Server
Component/s: Documentation
Affects Version/s: N/A
Fix Version/s: N/A

Type: Bug Priority: Minor
Reporter: Elena Stepanova Assignee: Ian Gilfillan
Resolution: Fixed Votes: 0
Labels: documentation


 Description   

https://mariadb.com/kb/en/mariadb/documentation/optimization-and-tuning/query-optimizations/aborting-statements-that-exceed-than-a-certain-time-to-execute/

It says:

Individual queries can also be limited by adding a MAX_STATEMENT_TIME clause to the query. For example:

SELECT MAX_STATEMENT_TIME=2 * FROM t1;

It's not the right syntax, apparently it's supposed to be
SET STATEMENT MAX_STATEMENT_TIME=2 FOR SELECT * FROM t1

 Comments   
Comment by Ian Gilfillan [ 2014-11-05 ]

Yes, it seems this was not implemented in this way for 10.1.1. The suggested syntax doesn't work either, I will remove the reference from the docs until it's implemented or there's clarity on how it's supposed to work.

Comment by Elena Stepanova [ 2014-11-05 ]

This is a new syntax expected to appear in 10.1.2 (it's in a separate tree so far). MDEV-5231.

Comment by Ian Gilfillan [ 2014-11-05 ]

Documentation updated. Will add the 10.1.2 syntax when it is released.

Generated at Thu Feb 08 07:16:16 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.