← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/t/key_diff.test

  • Committer: Mark Atwood
  • Date: 2008-10-03 01:39:40 UTC
  • mto: This revision was merged to the branch mainline in revision 437.
  • Revision ID: mark@fallenpegasus.com-20081003013940-mvefjo725dltz41h
rename logging_noop to logging_query

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/t/key_diff.test
1
 
#
2
 
# Check on condition on different length keys.
3
 
 
4
 
--disable_warnings
5
 
drop table if exists t1;
6
 
--enable_warnings
7
 
 
8
 
CREATE TABLE t1 (
9
 
  a char(5) NOT NULL,
10
 
  b char(4) NOT NULL,
11
 
  KEY (a),
12
 
  KEY (b)
13
 
);
14
 
 
15
 
INSERT INTO t1 VALUES ('A','B'),('b','A'),('C','c'),('D','E'),('a','a');
16
 
 
17
 
--sorted_result
18
 
select * from t1 CROSS JOIN t1 as t2;
19
 
explain select t1.*,t2.* from t1,t1 as t2 where t1.A=t2.B;
20
 
#select t1.*,t2.* from t1,t1 as t2 where t1.A=t2.B;
21
 
select t1.*,t2.* from t1,t1 as t2 where t1.A=t2.B order by binary t1.a,t2.a;
22
 
select * from t1 where a='a';
23
 
drop table t1;
24
 
 
25
 
# End of 4.1 tests