← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/t/compare.test

  • Committer: Padraig O'Sullivan
  • Date: 2009-03-21 20:26:28 UTC
  • mto: (960.2.5 mordred)
  • mto: This revision was merged to the branch mainline in revision 961.
  • Revision ID: osullivan.padraig@gmail.com-20090321202628-nh6qsi825m4d4av6
Removing the queues.[h,cc] files from the mysys directory. The only place
where they are needed now is in the MyISAM storage engine. Thus, I moved the
files there and updated the files in the MyISAM storage engine
appropriately.

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/t/compare.test
41
41
#
42
42
#Bug #21159: Optimizer: wrong result after AND with different data types
43
43
#
44
 
create table t1 (a int(1),b binary(1));
 
44
create table t1 (a int,b varbinary(1));
45
45
insert into t1 values (0x01,0x01);
46
46
select * from t1 where a=b;
47
47
select * from t1 where a=b and b=0x01;
52
52
# in version 5
53
53
#
54
54
 
55
 
CREATE TABLE  t1 (b int(2) zerofill, c int(2) zerofill);
 
55
CREATE TABLE  t1 (b int, c int);
56
56
INSERT INTO t1 (b,c) VALUES (1,2), (1,1), (2,2);
57
57
 
58
58
SELECT CONCAT(b,c), CONCAT(b,c) = '0101' FROM t1;