← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/t/func_group.test

  • Committer: Monty Taylor
  • Date: 2009-01-01 00:33:21 UTC
  • mto: This revision was merged to the branch mainline in revision 756.
  • Revision ID: mordred@inaugust.com-20090101003321-szs1ertpp0y9fccj
Updated mysql.test for distcheck.

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/t/func_group.test
199
199
insert into t2 values('AAA','AAA','AA','AME');
200
200
 
201
201
# Show the table contents
202
 
--sorted_result
203
202
select * from t1;
204
 
--sorted_result
205
203
select * from t2;
206
204
 
207
205
# Queries with min/max functions 
365
363
#
366
364
create table t1 (a char);
367
365
insert into t1 values ('a'),('b');
368
 
--replace_regex /ENGINE=[a-zA-Z]+/ENGINE=DEFAULT/
369
366
show create table t1;
370
367
create table t2 select max(a),min(a) from t1;
371
 
--replace_regex /ENGINE=[a-zA-Z]+/ENGINE=DEFAULT/
372
368
show create table t2;
373
369
drop table t2;
374
370
create table t2 select concat(a) from t1;
375
 
--replace_regex /ENGINE=[a-zA-Z]+/ENGINE=DEFAULT/
376
371
show create table t2;
377
372
drop table t2,t1;
378
373
 
447
442
create table t1(a int, b datetime);
448
443
insert into t1 values (1, NOW()), (2, NOW());
449
444
create table t2 select MAX(b) from t1 group by a;
450
 
--replace_regex /ENGINE=[a-zA-Z]+/ENGINE=DEFAULT/
451
445
show create table t2;
452
446
drop table t1, t2;
453
447
 
618
612
  (3,2,1), (3,2,2), (3,2,3),
619
613
  (3,3,1), (3,3,2), (3,3,3);
620
614
 
621
 
--sorted_result
622
615
SELECT b/c as v, a FROM t1 ORDER BY v;
623
616
SELECT b/c as v, SUM(a) FROM t1 GROUP BY v;
624
617
SELECT SUM(a) FROM t1 GROUP BY b/c;
647
640
#
648
641
 
649
642
create table t1 select variance(0);                                               
650
 
--replace_regex /ENGINE=[a-zA-Z]+/ENGINE=DEFAULT/
651
643
show create table t1;                                                           
652
644
drop table t1;                                                                  
653
645
create table t1 select stddev(0);
654
 
--replace_regex /ENGINE=[a-zA-Z]+/ENGINE=DEFAULT/
655
646
show create table t1;
656
647
drop table t1;
657
648