← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/func_math.result

  • Committer: Brian Aker
  • Date: 2009-02-20 22:48:37 UTC
  • Revision ID: brian@tangent.org-20090220224837-fw5wrf46n4ru3e6a
First pass of stripping uint

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
178
174
show create table t1;
179
175
Table   Create Table
180
176
t1      CREATE TABLE `t1` (
181
 
  `round(1, 6)` int NOT NULL
182
 
) ENGINE=InnoDB
 
177
  `round(1, 6)` int NOT NULL DEFAULT '0'
 
178
) ENGINE=X
183
179
select * from t1;
184
180
round(1, 6)
185
181
1