diff options
| author | timour@mysql.com <> | 2005-08-12 19:27:54 +0300 |
|---|---|---|
| committer | timour@mysql.com <> | 2005-08-12 19:27:54 +0300 |
| commit | 354ce1d0244d647922521a1fa3fc7249815bf232 (patch) | |
| tree | 47cfdff5ea22001b614037779ee931abbc209636 /mysql-test/t/fulltext.test | |
| parent | 2316f8cb337b0f2ee1d83908df405bd4bf96178e (diff) | |
| parent | a247282aa6270e809f4ad3f5205dc79ca7be8ec0 (diff) | |
| download | mariadb-git-354ce1d0244d647922521a1fa3fc7249815bf232.tar.gz | |
Merge mysql.com:/home/timka/mysql/src/5.0-virgin
into mysql.com:/home/timka/mysql/src/5.0-2486-merge
Diffstat (limited to 'mysql-test/t/fulltext.test')
| -rw-r--r-- | mysql-test/t/fulltext.test | 12 |
1 files changed, 6 insertions, 6 deletions
diff --git a/mysql-test/t/fulltext.test b/mysql-test/t/fulltext.test index 300bea1c917..08648f4e0a6 100644 --- a/mysql-test/t/fulltext.test +++ b/mysql-test/t/fulltext.test @@ -128,14 +128,14 @@ WHERE ticket2.id = ttxt.ticket AND t1.id = ticket2.ticket and match(ttxt.inhalt) against ('foobar'); # In the following query MySQL didn't use the fulltext index -select t1.id FROM t2 as ttxt,t1 INNER JOIN t1 as ticket2 ON -ticket2.id = ttxt.ticket -WHERE t1.id = ticket2.ticket and match(ttxt.inhalt) against ('foobar'); +select ticket2.id FROM t2 as ttxt,t2 INNER JOIN t1 as ticket2 ON +ticket2.id = t2.ticket +WHERE ticket2.id = ticket2.ticket and match(ttxt.inhalt) against ('foobar'); INSERT INTO t1 VALUES (3,3); -select t1.id FROM t2 as ttxt,t1 -INNER JOIN t1 as ticket2 ON ticket2.id = ttxt.ticket -WHERE t1.id = ticket2.ticket and +select ticket2.id FROM t2 as ttxt,t2 +INNER JOIN t1 as ticket2 ON ticket2.id = t2.ticket +WHERE ticket2.id = ticket2.ticket and match(ttxt.inhalt) against ('foobar'); # Check that we get 'fulltext' index in SHOW CREATE |