diff options
| author | unknown <evgen@sunlight.local> | 2008-02-08 13:35:00 +0300 |
|---|---|---|
| committer | unknown <evgen@sunlight.local> | 2008-02-08 13:35:00 +0300 |
| commit | d8eab9769309b36b96c2239d436fdb93b175a760 (patch) | |
| tree | 7d06158ebe951a5928e7c15652180d5de8b87794 /mysql-test/t/order_by.test | |
| parent | 1919d238e530d6c551ca60893f62e51dbad325cd (diff) | |
| download | mariadb-git-d8eab9769309b36b96c2239d436fdb93b175a760.tar.gz | |
Bug#31590: Wrong error message on sort buffer being too small.
The out of memory error was thrown when the sort buffer size were too small.
This led to a user confusion.
Now filesort throws the error message about sort buffer being too small.
mysql-test/t/order_by.test:
Added a test case for the bug#31590: Wrong error message on sort buffer being too small.
mysql-test/r/order_by.result:
Added a test case for the bug#31590: Wrong error message on sort buffer being too small.
sql/filesort.cc:
Bug#31590: Wrong error message on sort buffer being too small.
Now filesort throws the error message about sort buffer being too small
instead of out of memory error.
Diffstat (limited to 'mysql-test/t/order_by.test')
| -rw-r--r-- | mysql-test/t/order_by.test | 12 |
1 files changed, 12 insertions, 0 deletions
diff --git a/mysql-test/t/order_by.test b/mysql-test/t/order_by.test index 29a290c7fbf..9a55c27df99 100644 --- a/mysql-test/t/order_by.test +++ b/mysql-test/t/order_by.test @@ -726,3 +726,15 @@ SELECT a, b FROM t1 ORDER BY b DESC; SELECT a, b FROM t1 ORDER BY SEC_TO_TIME(a) DESC; DROP TABLE t1; + +--echo # +--echo # Bug#31590: Wrong error message on sort buffer being too small. +--echo # +create table t1(a int, b tinytext); +insert into t1 values (1,2),(3,2); +set session sort_buffer_size= 30000; +set session max_sort_length= 2180; +--error 1038 +select * from t1 order by b; +drop table t1; + |