← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/func_math.result

Merge Devananda's LENGTH UDF plugin

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/r/func_math.result
95
95
1       SIMPLE  NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    No tables used
96
96
Warnings:
97
97
Note    1003    select pow(10,log10(10)) AS `pow(10,log10(10))`,pow(2,4) AS `power(2,4)`
98
 
set @@rand_seed1=10000000,@@rand_seed2=1000000;
99
 
select rand(999999),rand();
100
 
rand(999999)    rand()
101
 
0.014231365187309091    0.028870999839968048
102
98
explain extended select rand(999999),rand();
103
99
id      select_type     table   type    possible_keys   key     key_len ref     rows    filtered        Extra
104
100
1       SIMPLE  NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    No tables used
214
210
122.34661925802624      405.40353712197725
215
211
644.97318737672 405.40353712197725
216
212
DROP TABLE t1;
217
 
create table t1 (a varchar(90), ts datetime not null, index (a)) engine=innodb;
218
 
insert into t1 values ('http://www.foo.com/', now());
219
 
select a from t1 where a='http://www.foo.com/' order by abs(timediff(ts, 0));
220
 
a
221
 
http://www.foo.com/
222
 
drop table t1;
223
213
select round(111,-10);
224
214
round(111,-10)
225
215
0