diff options
| author | Varun Gupta <varun.gupta@mariadb.com> | 2019-08-16 16:49:12 +0530 |
|---|---|---|
| committer | Varun Gupta <varun.gupta@mariadb.com> | 2019-08-16 16:49:12 +0530 |
| commit | 4d5382504d61ec27ace2d0dd4dd6cc71442ce067 (patch) | |
| tree | c0c81ead50dde11c2b55df188468e8bdf6b37502 /mysql-test/main/opt_trace.test | |
| parent | c221bcdce7714a74b89a02de941e8d8df2994ce3 (diff) | |
| download | mariadb-git-4d5382504d61ec27ace2d0dd4dd6cc71442ce067.tar.gz | |
MDEV-20349: Assertion `to_len >= 8' failed in convert_to_printable
Use convert_to_printable function to write only non-empty ranges to the optimizer trace
Diffstat (limited to 'mysql-test/main/opt_trace.test')
| -rw-r--r-- | mysql-test/main/opt_trace.test | 13 |
1 files changed, 13 insertions, 0 deletions
diff --git a/mysql-test/main/opt_trace.test b/mysql-test/main/opt_trace.test index e5d635db042..085b7e0aea8 100644 --- a/mysql-test/main/opt_trace.test +++ b/mysql-test/main/opt_trace.test @@ -536,4 +536,17 @@ explain select * from t0 A, one_k B where A.a=B.b and B.a<800; select JSON_DETAILED(JSON_EXTRACT(trace, '$**.considered_execution_plans')) from INFORMATION_SCHEMA.OPTIMIZER_TRACE; drop table t0, one_k; +--echo # +--echo # Assertion `to_len >= 8' failed in convert_to_printable +--echo # + +CREATE TABLE t1 ( a blob, KEY (a(255))); +insert into t1 values ('foo'), ('bar'); + +EXPLAIN SELECT * FROM t1 WHERE a= REPEAT('a', 0); +SELECT * FROM t1 WHERE a= REPEAT('a', 0); +select JSON_DETAILED(JSON_EXTRACT(trace, '$**.analyzing_range_alternatives')) from INFORMATION_SCHEMA.OPTIMIZER_TRACE; + +DROP TABLE t1; + set optimizer_trace='enabled=off'; |