summaryrefslogtreecommitdiff
path: root/mysql-test/t/fulltext_left_join.test
diff options
context:
space:
mode:
authorunknown <serg@sergbook.mylan>2003-11-20 22:20:54 +0100
committerunknown <serg@sergbook.mylan>2003-11-20 22:20:54 +0100
commitb6bbbf0832513e96ae8c476066bf7fd6e1e593a7 (patch)
tree1376e61d93698ec9eb2340a58d2fa803627e28e5 /mysql-test/t/fulltext_left_join.test
parent20da41c5d6c57fc0c951d9187bd17eb074b8386e (diff)
downloadmariadb-git-b6bbbf0832513e96ae8c476066bf7fd6e1e593a7.tar.gz
more left join tests
Diffstat (limited to 'mysql-test/t/fulltext_left_join.test')
-rw-r--r--mysql-test/t/fulltext_left_join.test2
1 files changed, 2 insertions, 0 deletions
diff --git a/mysql-test/t/fulltext_left_join.test b/mysql-test/t/fulltext_left_join.test
index da4df13bc0c..a785cc6a61c 100644
--- a/mysql-test/t/fulltext_left_join.test
+++ b/mysql-test/t/fulltext_left_join.test
@@ -38,5 +38,7 @@ create table t2 (name varchar(255) not null default '', entity_id int(11) not nu
insert into t2 (name, entity_id) values ('aberdeen town hall', 1), ('glasgow royal concert hall', 2), ('queen\'s hall, edinburgh', 3);
select * from t1 left join t2 on venue_id = entity_id where match(name) against('aberdeen' in boolean mode) and dt = '2003-05-23 19:30:00';
select * from t1 left join t2 on venue_id = entity_id where match(name) against('aberdeen') and dt = '2003-05-23 19:30:00';
+select * from t1 left join t2 on (venue_id = entity_id and match(name) against('aberdeen' in boolean mode)) where dt = '2003-05-23 19:30:00';
+select * from t1 left join t2 on (venue_id = entity_id and match(name) against('aberdeen')) where dt = '2003-05-23 19:30:00';
drop table t1,t2;