summaryrefslogtreecommitdiff
path: root/mysql-test/r/subselect.result
diff options
context:
space:
mode:
authorunknown <bell@sanja.is.com.ua>2004-05-28 21:31:51 +0300
committerunknown <bell@sanja.is.com.ua>2004-05-28 21:31:51 +0300
commitbfaaee5343737f5899b88ebcd341374c9a67535d (patch)
treea71db9259836ae08f70ab4ec5e0326555fef4475 /mysql-test/r/subselect.result
parentc2f6dff9f4abb3072e81cfe8eb6ad2e41475ad18 (diff)
downloadmariadb-git-bfaaee5343737f5899b88ebcd341374c9a67535d.tar.gz
if exists should not be used inside test
removed influence of some tests on other tests mysql-test/r/multi_update.result: removed influence on other tests mysql-test/r/subselect.result: if exists should not be used inside test mysql-test/t/multi_update.test: removed influence on other tests mysql-test/t/subselect.test: if exists should not be used inside test mysql-test/t/system_mysql_db_fix.test: removed influence on other tests
Diffstat (limited to 'mysql-test/r/subselect.result')
-rw-r--r--mysql-test/r/subselect.result2
1 files changed, 1 insertions, 1 deletions
diff --git a/mysql-test/r/subselect.result b/mysql-test/r/subselect.result
index 9ad3a5a9cf2..a6ff608ab66 100644
--- a/mysql-test/r/subselect.result
+++ b/mysql-test/r/subselect.result
@@ -334,7 +334,7 @@ Note 1276 Field or reference 'clinic_uq' of SELECT #2 was resolved in SELECT #1
Note 1003 select test.t6.patient_uq AS `patient_uq`,test.t6.clinic_uq AS `clinic_uq` from test.t6 where exists(select test.t7.uq AS `uq`,test.t7.name AS `name` from test.t7 where (test.t7.uq = test.t6.clinic_uq))
select * from t1 where a= (select a from t2,t4 where t2.b=t4.b);
ERROR 23000: Column: 'a' in field list is ambiguous
-drop table if exists t1,t2,t3;
+drop table t1,t2,t3;
CREATE TABLE t3 (a varchar(20),b char(1) NOT NULL default '0');
INSERT INTO t3 VALUES ('W','a'),('A','c'),('J','b');
CREATE TABLE t2 (a varchar(20),b int NOT NULL default '0');