diff options
| author | Vladislav Vaintroub <wlad@mariadb.com> | 2021-10-07 19:52:18 +0200 |
|---|---|---|
| committer | Vladislav Vaintroub <wlad@mariadb.com> | 2021-10-14 12:13:05 +0200 |
| commit | 5b5a67b2a9aecdc41b35b5cb12ebbf960384f7bd (patch) | |
| tree | e6312e28f995813d1503912c2147b4d03fc5b997 /mysql-test/main/natural_sort_key.test | |
| parent | 6c5c1fd55ab2b771c78fb241c1cf749860a0d5cf (diff) | |
| download | mariadb-git-5b5a67b2a9aecdc41b35b5cb12ebbf960384f7bd.tar.gz | |
MDEV-26786 Inserting NULL into base column breaks NATURAL_SORT_KEY column
When returning non-null value from natural_sort_key, make sure
Item::null_value is false.
Diffstat (limited to 'mysql-test/main/natural_sort_key.test')
| -rw-r--r-- | mysql-test/main/natural_sort_key.test | 7 |
1 files changed, 7 insertions, 0 deletions
diff --git a/mysql-test/main/natural_sort_key.test b/mysql-test/main/natural_sort_key.test index dda25c9e1f8..4f4e2b0e05e 100644 --- a/mysql-test/main/natural_sort_key.test +++ b/mysql-test/main/natural_sort_key.test @@ -86,3 +86,10 @@ SELECT RPAD(val,20,' ') value, NATURAL_SORT_KEY(val) FROM ('a01b3') )AS data ORDER BY 2,1; +# MDEV-27686 (null value indicator not always reset) +create table t (a varchar(8), b varchar(8) as (natural_sort_key(a))); +insert into t (a) values ('a2'),(NULL),('a11'); +select * from t order by b; +select a, b from t order by b; +drop table t; + |