Spracherkennung für: .test vermutete Sprache: SQL {SQL[116] Masm[82] ADA[58]} [Methode: maximale Elemente, drei Dimensionen]
--source include/not_embedded.inc
#
# statement timeout
#
SELECT @@MAX_STATEMENT_TIME;
SET STATEMENT MAX_STATEMENT_TIME=3 FOR SELECT SLEEP(1);
SHOW STATUS LIKE "max_statement_time_exceeded";
--error ER_STATEMENT_TIMEOUT
SET STATEMENT MAX_STATEMENT_TIME=1 FOR SELECT SLEEP(10);
SHOW STATUS LIKE "max_statement_time_exceeded";
SELECT @@MAX_STATEMENT_TIME;
--echo #
--echo # MDEV-31209 Queries with window functions do not obey KILL / max_statement_time
--echo #
create table t (i int);
insert into t values(1),(2),(3);
--error ER_STATEMENT_TIMEOUT
set statement max_statement_time=0.03 for select max(sleep(0.1)) over( ) from t;
drop table t;
--echo # End of 10.11 tests
[Dauer der Verarbeitung: 0.14 Sekunden, vorverarbeitet 2026-10-08]
