diff options
Diffstat (limited to 'mysql-test/main/order_by_zerolength-4285.test')
-rw-r--r-- | mysql-test/main/order_by_zerolength-4285.test | 15 |
1 files changed, 15 insertions, 0 deletions
diff --git a/mysql-test/main/order_by_zerolength-4285.test b/mysql-test/main/order_by_zerolength-4285.test new file mode 100644 index 00000000000..079ce8da71e --- /dev/null +++ b/mysql-test/main/order_by_zerolength-4285.test @@ -0,0 +1,15 @@ +# +# MDEV-4285 Server crashes in ptr_compare on NOW and CAST in ORDER BY +# +create table t1 (pk int primary key); +insert into t1 values (1),(2),(3),(4),(5),(6),(7),(8),(9),(10); + +# In strict mode the query produces result in a different order +# (not ordered implicitly by PK and indeterministic), so we force sorting. +# However, sorting also affects warnings, so we'll check them separately. +--disable_warnings +--sorted_result +select * from t1 order by now(), cast(pk as char(0)); +--enable_warnings +show warnings; +drop table t1; |