diff options
| author | Sergei Petrunia <sergey@mariadb.com> | 2022-08-04 12:51:32 +0300 |
|---|---|---|
| committer | Sergei Petrunia <sergey@mariadb.com> | 2022-08-04 17:10:20 +0300 |
| commit | 3b071bad1981a12e76769cbfc31b62fbd7362372 (patch) | |
| tree | 3c9efd8fc6d8cacbc58251eb499d933a2e731769 /mysql-test/main/range_notembedded.test | |
| parent | ea12dafe6543977bd98c61ffab8cc317b4f0b55b (diff) | |
| download | mariadb-git-3b071bad1981a12e76769cbfc31b62fbd7362372.tar.gz | |
MDEV-29242: Assertion `computed_weight == weight' failed SEL_ARG::verify_weight
Make SEL_ARG::make_root() maintain SEL_ARG::weight.
Also, an unrelated change: fix dbug_print_sel_arg() to correctly
print SQL NULL for the right endpoint.
Diffstat (limited to 'mysql-test/main/range_notembedded.test')
| -rw-r--r-- | mysql-test/main/range_notembedded.test | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/mysql-test/main/range_notembedded.test b/mysql-test/main/range_notembedded.test index 4e77d6a4810..00d16a5d564 100644 --- a/mysql-test/main/range_notembedded.test +++ b/mysql-test/main/range_notembedded.test @@ -150,3 +150,12 @@ FROM mysql.help_relation WHERE (help_topic_id < '2' OR help_topic_id != 8 OR help_topic_id < 1) AND help_keyword_id = help_topic_id; + +--echo # +--echo # MDEV-29242: Assertion `computed_weight == weight' failed SEL_ARG::verify_weight +--echo # +CREATE TABLE t1 (id INT, KEY (id)); +INSERT INTO t1 VALUES (1),(5); +SELECT id FROM t1 WHERE id IS NULL OR id NOT BETWEEN 1 AND 4; +DROP TABLE t1; + |