diff options
| author | unknown <jimw@mysql.com> | 2005-10-27 18:46:00 -0700 |
|---|---|---|
| committer | unknown <jimw@mysql.com> | 2005-10-27 18:46:00 -0700 |
| commit | 80a8d8c4f818e80cae612a3bb020039a3846437a (patch) | |
| tree | 16be35acb7bbb6062af06b67f2f9e599b8d7670a /mysql-test/t/func_math.test | |
| parent | a397d1f7149dcdeac86e9e4870780dcd8e99a908 (diff) | |
| parent | 5e8515d9f2ccada3e19b109196fb5654e7c9db92 (diff) | |
| download | mariadb-git-80a8d8c4f818e80cae612a3bb020039a3846437a.tar.gz | |
Merge mysql.com:/home/jimw/my/mysql-4.1-clean
into mysql.com:/home/jimw/my/mysql-5.0-clean
mysql-test/t/func_math.test:
Auto merged
mysql-test/r/func_math.result:
Resolve conflict
sql/item_func.cc:
Resolve conflict
Diffstat (limited to 'mysql-test/t/func_math.test')
| -rw-r--r-- | mysql-test/t/func_math.test | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/mysql-test/t/func_math.test b/mysql-test/t/func_math.test index 2935f24f2d7..24dd18daab1 100644 --- a/mysql-test/t/func_math.test +++ b/mysql-test/t/func_math.test @@ -116,6 +116,16 @@ insert into t1 values (1); select rand(i) from t1; drop table t1; +# +# Bug #14009: use of abs() on null value causes problems with filesort +# +# InnoDB is required to reproduce the fault, but it is okay if we default to +# MyISAM when testing. +create table t1 (a varchar(90), ts datetime not null, index (a)) engine=innodb default charset=utf8; +insert into t1 values ('http://www.foo.com/', now()); +select a from t1 where a='http://www.foo.com/' order by abs(timediff(ts, 0)); +drop table t1; + # End of 4.1 tests # |