summaryrefslogtreecommitdiff
path: root/mysql-test/main/func_json_notembedded.result
diff options
context:
space:
mode:
authorDaniel Black <daniel@mariadb.org>2022-02-28 10:16:26 +1100
committerDaniel Black <daniel@mariadb.org>2022-03-16 09:41:54 +1100
commitb2c81e06b042025663ea01fa98dac0ff536c7706 (patch)
treed46e6aafc9e5a86ebb05a1f7769400de3bf7a396 /mysql-test/main/func_json_notembedded.result
parent4ef44cc2f96bbb669216fc436eaa26e3a8a83799 (diff)
downloadmariadb-git-b2c81e06b042025663ea01fa98dac0ff536c7706.tar.gz
MDEV-27955 main.func_json_notembedded test fails on out-of-memory
Uses 500M+ of memory by repeating an 8 byte sequence 62.5M times. Reduce the number of repeats on string reduced by 100 times. Tested by applying against the reverted MDEV-24909 code. 1000 times reduction was too much, but 100 still managed to trigger the bug.
Diffstat (limited to 'mysql-test/main/func_json_notembedded.result')
-rw-r--r--mysql-test/main/func_json_notembedded.result6
1 files changed, 3 insertions, 3 deletions
diff --git a/mysql-test/main/func_json_notembedded.result b/mysql-test/main/func_json_notembedded.result
index be879dfc9d6..756d2e85f7c 100644
--- a/mysql-test/main/func_json_notembedded.result
+++ b/mysql-test/main/func_json_notembedded.result
@@ -4,11 +4,11 @@ connect u,localhost,root;
# MDEV-24909 JSON functions don't respect KILL QUERY / max_statement_time limit
#
set group_concat_max_len= 4294967295;
-set @obj=concat_ws('','{', repeat('"a":"b",', 125000000/2), '"c":"d"}');
-set @arr=concat_ws('','[', repeat('1234567,', 125000000/2), '2345678]');
+set @obj=concat_ws('','{', repeat('"a":"b",', 1250000/2), '"c":"d"}');
+set @arr=concat_ws('','[', repeat('1234567,', 1250000/2), '2345678]');
select length(@obj), length(@arr);
length(@obj) length(@arr)
-500000009 500000009
+5000009 5000009
set max_statement_time=0.0001;
select json_array_append(@arr, '$[0]', 1);
ERROR 70100: Query execution was interrupted (max_statement_time exceeded)