diff options
| author | Sergey Glukhov <Sergey.Glukhov@sun.com> | 2009-02-19 17:59:00 +0400 |
|---|---|---|
| committer | Sergey Glukhov <Sergey.Glukhov@sun.com> | 2009-02-19 17:59:00 +0400 |
| commit | fafeaf460bdb72e8f9976aada6c1c8bcce48f993 (patch) | |
| tree | 5b584f2a2468cfc4803488226ffce1ee093eb3d5 /mysql-test/r/row.result | |
| parent | b2a8faebea8b83c2d90096dac2627290f090bb07 (diff) | |
| parent | c2e23208ef7ae6b315ca4988e903bff2bc0284d4 (diff) | |
| download | mariadb-git-fafeaf460bdb72e8f9976aada6c1c8bcce48f993.tar.gz | |
5.0-bugteam->5.1-bugteam merge
Diffstat (limited to 'mysql-test/r/row.result')
| -rw-r--r-- | mysql-test/r/row.result | 14 |
1 files changed, 14 insertions, 0 deletions
diff --git a/mysql-test/r/row.result b/mysql-test/r/row.result index 3feaa6255c1..2eaec67c547 100644 --- a/mysql-test/r/row.result +++ b/mysql-test/r/row.result @@ -443,3 +443,17 @@ SELECT ROW(a, 1) IN (SELECT SUM(b), 3) FROM t1 GROUP BY a; ROW(a, 1) IN (SELECT SUM(b), 3) 0 DROP TABLE t1; +create table t1 (a varchar(200), +b int unsigned not null primary key auto_increment) +default character set 'utf8'; +create table t2 (c varchar(200), +d int unsigned not null primary key auto_increment) +default character set 'latin1'; +insert into t1 (a) values('abc'); +insert into t2 (c) values('abc'); +select * from t1,t2 where (a,b) = (c,d); +a b c d +abc 1 abc 1 +select host,user from mysql.user where (host,user) = ('localhost','test'); +host user +drop table t1,t2; |