← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/select.result

  • Committer: Monty Taylor
  • Date: 2008-07-15 21:40:58 UTC
  • mfrom: (77.1.113 codestyle32)
  • mto: This revision was merged to the branch mainline in revision 176.
  • Revision ID: mordred@camelot-20080715214058-rm3phulldos9xehv
Merged from codestyle.

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/r/select.result
2742
2742
1       SIMPLE  NULL    NULL    NULL    NULL    NULL    NULL    NULL    Select tables optimized away
2743
2743
select max(key1) from t1 where key1 <= 0.6158;
2744
2744
max(key1)
2745
 
0.6158000230789185
 
2745
0.6158
2746
2746
select max(key2) from t2 where key2 <= 1.6158;
2747
2747
max(key2)
2748
 
1.6158000230789185
 
2748
1.6158
2749
2749
select min(key1) from t1 where key1 >= 0.3762;
2750
2750
min(key1)
2751
 
0.37619999051094055
 
2751
0.3762
2752
2752
select min(key2) from t2 where key2 >= 1.3762;
2753
2753
min(key2)
2754
 
1.3761999607086182
 
2754
1.3762
2755
2755
select max(key1), min(key2) from t1, t2
2756
2756
where key1 <= 0.6158 and key2 >= 1.3762;
2757
2757
max(key1)       min(key2)
2758
 
0.6158000230789185      1.3761999607086182
 
2758
0.6158  1.3762
2759
2759
select max(key1) from t1 where key1 <= 0.6158 and rand() + 0.5 >= 0.5;
2760
2760
max(key1)
2761
 
0.6158000230789185
 
2761
0.6158
2762
2762
select min(key1) from t1 where key1 >= 0.3762 and rand() + 0.5 >= 0.5;
2763
2763
min(key1)
2764
 
0.37619999051094055
 
2764
0.3762
2765
2765
DROP TABLE t1,t2;
2766
2766
CREATE TABLE t1 (i BIGINT UNSIGNED NOT NULL);
2767
2767
INSERT INTO t1 VALUES (10);