diff options
| author | unknown <evgen@moonbone.local> | 2007-12-07 22:54:47 +0300 |
|---|---|---|
| committer | unknown <evgen@moonbone.local> | 2007-12-07 22:54:47 +0300 |
| commit | 0ad7fc58c7e149fe7885d6a3558637f87513047a (patch) | |
| tree | bd8982e97f8d03f3047d3e63414a037a880aa8ee /mysql-test/r/user_var.result | |
| parent | f448c62558cbd74940261e4eb8e67c3347ceb235 (diff) | |
| download | mariadb-git-0ad7fc58c7e149fe7885d6a3558637f87513047a.tar.gz | |
Bug#32482: Crash for a query with ORDER BY a user variable.
The Item_func_set_user_var::register_field_in_read_map() did not check
that the result_field was null.This caused server crashes for queries that
required order by such a field and were executed without using a temporary
table.
The Item_func_set_user_var::register_field_in_read_map() now checks the
result_field to be not null.
mysql-test/t/user_var.test:
Added a test case for the bug#32482: Crash for a query with ORDER BY a user variable.
mysql-test/r/user_var.result:
Added a test case for the bug#32482: Crash for a query with ORDER BY a user variable.
sql/item_func.cc:
Bug#32482: Crash for a query with ORDER BY a user variable.
The Item_func_set_user_var::register_field_in_read_map() now checks the
result_field to be not null.
Diffstat (limited to 'mysql-test/r/user_var.result')
| -rw-r--r-- | mysql-test/r/user_var.result | 7 |
1 files changed, 7 insertions, 0 deletions
diff --git a/mysql-test/r/user_var.result b/mysql-test/r/user_var.result index 6fd7b39f226..2988a13de41 100644 --- a/mysql-test/r/user_var.result +++ b/mysql-test/r/user_var.result @@ -353,3 +353,10 @@ select @a:=f4, count(f4) from t1 group by 1 desc; 2.6 1 1.6 4 drop table t1; +create table t1 (f1 int); +insert into t1 values (2), (1); +select @i := f1 as j from t1 order by 1; +j +1 +2 +drop table t1; |