← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/t/func_math.test

  • Committer: Brian Aker
  • Date: 2009-03-01 03:29:52 UTC
  • mfrom: (907.1.6 trunk-with-temporal)
  • Revision ID: brian@tangent.org-20090301032952-y210opnqxsfyhcla
Merge Jay's temporal

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/t/func_math.test
120
120
 
121
121
DROP TABLE t1;  
122
122
 
123
 
#
124
 
# Bug #14009: use of abs() on null value causes problems with filesort
125
 
#
126
 
# InnoDB is required to reproduce the fault, but it is okay if we default to
127
 
# MyISAM when testing.
128
 
--disable_warnings
129
 
create table t1 (a varchar(90), ts datetime not null, index (a)) engine=innodb;
130
 
--enable_warnings
131
 
insert into t1 values ('http://www.foo.com/', now());
132
 
select a from t1 where a='http://www.foo.com/' order by abs(timediff(ts, 0));
133
 
drop table t1;
134
 
 
135
123
# End of 4.1 tests
136
124
 
137
125
#