diff options
| author | unknown <monty@donna.mysql.com> | 2001-01-16 12:38:58 +0200 |
|---|---|---|
| committer | unknown <monty@donna.mysql.com> | 2001-01-16 12:38:58 +0200 |
| commit | 64289e22b6e234a9888869264d01160d241e0548 (patch) | |
| tree | cdb2dc82be698822213f193e98907ad9e7801eac /mysql-test/t/fulltext_cache.test | |
| parent | 0365e2d3dceccb1dc3727336e1596869e3c1a180 (diff) | |
| download | mariadb-git-64289e22b6e234a9888869264d01160d241e0548.tar.gz | |
Added ORDER BY to test case to make the result comparable
Docs/manual.texi:
Added replication information
mysql-test/mysql-test-run.sh:
Don't start master when we are running a test against the running server
mysql-test/r/fulltext_cache.result:
Added sort to make the result comparable
mysql-test/t/fulltext_cache.test:
Added sort to make the result comparable
Diffstat (limited to 'mysql-test/t/fulltext_cache.test')
| -rw-r--r-- | mysql-test/t/fulltext_cache.test | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/mysql-test/t/fulltext_cache.test b/mysql-test/t/fulltext_cache.test index c6c76ee9182..fc5f0e266b3 100644 --- a/mysql-test/t/fulltext_cache.test +++ b/mysql-test/t/fulltext_cache.test @@ -2,6 +2,7 @@ # Bugreport due to Roy Nasser <roy@vem.ca> # +drop table if exists t1, t2; CREATE TABLE t1 ( id int(10) unsigned NOT NULL auto_increment, q varchar(255) default NULL, @@ -26,10 +27,9 @@ INSERT INTO t2 VALUES (7,1,'Bife'); INSERT INTO t2 VALUES (8,1,'Pizza de Salmao'); SELECT t1.q, t2.item, t2.id, MATCH t2.item AGAINST ('sushi') as x FROM t1, t2 -WHERE (t2.id2 = t1.id) ORDER BY x DESC; +WHERE (t2.id2 = t1.id) ORDER BY x DESC,t2.id; SELECT t1.q, t2.item, t2.id, MATCH t2.item AGAINST ('sushi') as x FROM t2, t1 -WHERE (t2.id2 = t1.id) ORDER BY x DESC; +WHERE (t2.id2 = t1.id) ORDER BY x DESC,t2.id; drop table t1, t2; - |