diff options
| author | unknown <evgen@moonbone.local> | 2005-10-27 18:36:11 +0400 |
|---|---|---|
| committer | unknown <evgen@moonbone.local> | 2005-10-27 18:36:11 +0400 |
| commit | ef12b2c8de6e8157e0a08eaf7caea101526f88f3 (patch) | |
| tree | 932cf82ee8f0602fe35c07be32737faeb82bdb1c /mysql-test | |
| parent | 32b21cfa488257370e984190a269b3c299e3288f (diff) | |
| download | mariadb-git-ef12b2c8de6e8157e0a08eaf7caea101526f88f3.tar.gz | |
select.result:
After merge fix
mysql-test/r/select.result:
After merge fix
Diffstat (limited to 'mysql-test')
| -rw-r--r-- | mysql-test/r/select.result | 16 |
1 files changed, 8 insertions, 8 deletions
diff --git a/mysql-test/r/select.result b/mysql-test/r/select.result index 27a0c8276e0..64c329ee104 100644 --- a/mysql-test/r/select.result +++ b/mysql-test/r/select.result @@ -2400,14 +2400,6 @@ id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE t1 ALL NULL NULL NULL NULL 5 1 SIMPLE t2 ref a a 23 test.t1.a 2 DROP TABLE t1, t2; -create table t1 (f1 int primary key, f2 int); -create table t2 (f3 int, f4 int, primary key(f3,f4)); -insert into t1 values (1,1); -insert into t2 values (1,1),(1,2); -select distinct count(f2) >0 from t1 left join t2 on f1=f3 group by f1; -count(f2) >0 -1 -drop table t1,t2; CREATE TABLE t1 ( city char(30) ); INSERT INTO t1 VALUES ('London'); INSERT INTO t1 VALUES ('Paris'); @@ -2706,3 +2698,11 @@ a b c d 1 2 2 1 1 2 3 1 DROP TABLE IF EXISTS t1, t2; +create table t1 (f1 int primary key, f2 int); +create table t2 (f3 int, f4 int, primary key(f3,f4)); +insert into t1 values (1,1); +insert into t2 values (1,1),(1,2); +select distinct count(f2) >0 from t1 left join t2 on f1=f3 group by f1; +count(f2) >0 +1 +drop table t1,t2; |