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/r/order_by.result | |
| 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/r/order_by.result')
| -rw-r--r-- | mysql-test/r/order_by.result | 12 |
1 files changed, 12 insertions, 0 deletions
diff --git a/mysql-test/r/order_by.result b/mysql-test/r/order_by.result index eedc2fa476b..9f6a1b3932c 100644 --- a/mysql-test/r/order_by.result +++ b/mysql-test/r/order_by.result @@ -1064,3 +1064,15 @@ a b 10 00:00:10 0 00:00:00 DROP TABLE t1; +# +# Bug#31590: Wrong error message on sort buffer being too small. +# +create table t1(a int, b tinytext); +insert into t1 values (1,2),(3,2); +set session sort_buffer_size= 30000; +Warnings: +Warning 1292 Truncated incorrect sort_buffer_size value: '30000' +set session max_sort_length= 2180; +select * from t1 order by b; +ERROR HY001: Out of sort memory; increase server sort buffer size +drop table t1; |