diff options
author | unknown <bell@sanja.is.com.ua> | 2002-10-07 00:56:21 +0300 |
---|---|---|
committer | unknown <bell@sanja.is.com.ua> | 2002-10-07 00:56:21 +0300 |
commit | 72a3c80dbb131339406ec4a815f423a1bd8926cc (patch) | |
tree | 67ba411e803347bf61a47c18c0ae34ab22fbbdc1 /mysql-test | |
parent | d319dea894150e6899d3099d4fbad222ba13038a (diff) | |
download | mariadb-git-72a3c80dbb131339406ec4a815f423a1bd8926cc.tar.gz |
after merging fix
Diffstat (limited to 'mysql-test')
-rw-r--r-- | mysql-test/r/subselect.result | 2 | ||||
-rw-r--r-- | mysql-test/t/subselect.test | 2 |
2 files changed, 2 insertions, 2 deletions
diff --git a/mysql-test/r/subselect.result b/mysql-test/r/subselect.result index aa058a97109..911065890e2 100644 --- a/mysql-test/r/subselect.result +++ b/mysql-test/r/subselect.result @@ -121,7 +121,7 @@ id select_type table type possible_keys key key_len ref rows Extra 2 DEPENDENT SUBSELECT t1 system NULL NULL NULL NULL 1 where used 3 DEPENDENT UNION t5 ALL NULL NULL NULL NULL 2 where used select (select a from t1 where t1.a=t2.a union all select a from t5 where t5.a=t2.a), a from t2; -Subselect return more than 1 record +Subselect returns more than 1 record create table attend (patient_uq int, clinic_uq int, index i1 (clinic_uq)); create table clinic( uq int primary key, name char(25)); insert into clinic values(1,"Oblastnaia bolnitsa"),(2,"Bolnitsa Krasnogo Kresta"); diff --git a/mysql-test/t/subselect.test b/mysql-test/t/subselect.test index 3ae695c8967..bf98090eb43 100644 --- a/mysql-test/t/subselect.test +++ b/mysql-test/t/subselect.test @@ -45,7 +45,7 @@ select (select a from t1 where t1.a=t2.a union select a from t5 where t5.a=t2.a) insert into t5 values (2); select (select a from t1 where t1.a=t2.a union select a from t5 where t5.a=t2.a), a from t2; explain select (select a from t1 where t1.a=t2.a union select a from t5 where t5.a=t2.a), a from t2; --- error 1230 +-- error 1240 select (select a from t1 where t1.a=t2.a union all select a from t5 where t5.a=t2.a), a from t2; create table attend (patient_uq int, clinic_uq int, index i1 (clinic_uq)); create table clinic( uq int primary key, name char(25)); |