diff options
| author | unknown <serg@serg.mylan> | 2003-07-31 13:45:35 +0200 |
|---|---|---|
| committer | unknown <serg@serg.mylan> | 2003-07-31 13:45:35 +0200 |
| commit | 687ebba461075af77544c3bf1d268148fc3b2c90 (patch) | |
| tree | 86e22579e5e385304471e69daba4abd0971763dc /mysql-test/t/fulltext.test | |
| parent | 20e39672fb84d3ce70ff466713b84f7d9c78c7fe (diff) | |
| download | mariadb-git-687ebba461075af77544c3bf1d268148fc3b2c90.tar.gz | |
bug #942. docid == ftb->lastpos in join on looping over nested table
Diffstat (limited to 'mysql-test/t/fulltext.test')
| -rw-r--r-- | mysql-test/t/fulltext.test | 16 |
1 files changed, 15 insertions, 1 deletions
diff --git a/mysql-test/t/fulltext.test b/mysql-test/t/fulltext.test index 942552f5e98..387a36f1f52 100644 --- a/mysql-test/t/fulltext.test +++ b/mysql-test/t/fulltext.test @@ -189,7 +189,7 @@ select * from t1 where match (a) against ('aaaa'); drop table t1; # -# bug 283 by jocelyn fournier <joc@presence-pc.com> +# bug #283 by jocelyn fournier <joc@presence-pc.com> # FULLTEXT index on a TEXT filed converted to a CHAR field doesn't work anymore # @@ -201,3 +201,17 @@ alter table t1 change ref_mag ref_mag char (255) not null; select ref_mag from t1 where match ref_mag against ('+test' in boolean mode); drop table t1; +# +# bug #942: JOIN +# + +create table t1 (t1_id int(11) primary key, name varchar(32)); +insert into t1 values (1, 'data1'); +insert into t1 values (2, 'data2'); +create table t2 (t2_id int(11) primary key, t1_id int(11), name varchar(32)); +insert into t2 values (1, 1, 'xxfoo'); +insert into t2 values (2, 1, 'xxbar'); +insert into t2 values (3, 1, 'xxbuz'); +select * from t1 join t2 using(`t1_id`) where match (t1.name, t2.name) against('xxfoo' in boolean mode); +drop table t1,t2; + |