1 files changed, 17 insertions, 0 deletions
diff --git a/mysql-test/main/opt_trace.test b/mysql-test/main/opt_trace.test
index 0785d828a07..1bc48b6f75a 100644
--- a/mysql-test/main/opt_trace.test
+++ b/mysql-test/main/opt_trace.test
@@ -678,5 +678,22 @@ SELECT a FROM t1 WHERE (a,b) in (SELECT @c,@d);
 DROP TABLE t1;
 
 --echo #
+--echo # MDEV-30334 Optimizer trace produces invalid JSON with WHERE subquery
+--echo #  Simple code rearrangement to stop it displaying an unsigned int in a String.
+--echo #
+
+SET optimizer_trace= 'enabled=on';
+ 
+CREATE TABLE t1 (id INT PRIMARY KEY);
+INSERT INTO t1 VALUES (1),(2);
+CREATE TABLE t2 (a INT);
+INSERT INTO t2 VALUES (3),(4);
+ 
+SELECT * FROM t1 WHERE id < ( SELECT SUM(a) FROM t2 );
+SELECT JSON_VALID(trace) FROM information_schema.optimizer_trace;
+ 
+DROP TABLE t1, t2;
+
+--echo #
 --echo # End of 10.4 tests
 --echo #