← Back to branch summary

~mdcallag/+junk/5.1-map

« back to all changes in this revision

Viewing changes to mysql-test/t/fulltext_left_join.test

  • Committer: msvensson at pilot
  • Date: 2007-04-24 09:11:45 UTC
  • mfrom: (2469.1.106)
  • Revision ID: sp1r-msvensson@pilot.blaudden-20070424091145-10463
Merge pilot.blaudden:/home/msvensson/mysql/my51-m-mysql_upgrade
into  pilot.blaudden:/home/msvensson/mysql/mysql-5.1-maint

Show diffs side-by-side

added added

removed removed

Lines of Context:
mysql-test/t/fulltext_left_join.test
87
87
DROP TABLE t1,t2;
88
88
 
89
89
# End of 4.1 tests
 
90
 
 
91
#
 
92
# BUG#25729 - boolean full text search is confused by NULLs produced by LEFT
 
93
#             JOIN
 
94
#
 
95
CREATE TABLE t1 (a INT);
 
96
CREATE TABLE t2 (b INT, c TEXT, KEY(b));
 
97
INSERT INTO t1 VALUES(1);
 
98
INSERT INTO t2(b,c) VALUES(2,'castle'),(3,'castle');
 
99
SELECT * FROM t1 LEFT JOIN t2 ON a=b WHERE MATCH(c) AGAINST('+castle' IN BOOLEAN MODE);
 
100
DROP TABLE t1, t2;