summaryrefslogtreecommitdiff
path: root/mysql-test/t/analyze_format_json.test
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/t/analyze_format_json.test')
-rw-r--r--mysql-test/t/analyze_format_json.test12
1 files changed, 12 insertions, 0 deletions
diff --git a/mysql-test/t/analyze_format_json.test b/mysql-test/t/analyze_format_json.test
index 88a907718d9..915e0c2bf3c 100644
--- a/mysql-test/t/analyze_format_json.test
+++ b/mysql-test/t/analyze_format_json.test
@@ -212,3 +212,15 @@ GROUP BY sq ORDER BY gc;
drop table t1,t2,t3;
+
+--echo #
+--echo # MDEV-13286: Floating point exception in Filesort_tracker::print_json_members(Json_writer*)
+--echo #
+create table t0(a int);
+insert into t0 values (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+create table t1 (a int, b int, c int);
+insert into t1 select a,a,a from t0;
+create table t2 as select * from t1;
+--source include/analyze-format.inc
+analyze format=json select a, (select t2.b from t2 where t2.a<t1.a order by t2.c limit 1) from t1 where t1.a<0;
+drop table t0,t1,t2;