diff options
| -rw-r--r-- | mysql-test/r/fulltext_cache.result | 4 | ||||
| -rw-r--r-- | mysql-test/r/fulltext_left_join.result | 2 | ||||
| -rw-r--r-- | mysql-test/r/fulltext_multi.result | 8 | ||||
| -rw-r--r-- | mysql-test/r/fulltext_order_by.result | 18 |
4 files changed, 16 insertions, 16 deletions
diff --git a/mysql-test/r/fulltext_cache.result b/mysql-test/r/fulltext_cache.result index b908840ad92..29395520791 100644 --- a/mysql-test/r/fulltext_cache.result +++ b/mysql-test/r/fulltext_cache.result @@ -24,7 +24,7 @@ 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,t2.id; q item id x -aaaaaaaaa dsaass de sushi 1 1.92378665219675 +aaaaaaaaa dsaass de sushi 1 1.92378664016724 aaaaaaaaa dsaass de Bolo de Chocolate 2 0 aaaaaaaaa dsaass de Feijoada 3 0 aaaaaaaaa dsaass de Mousse de Chocolate 4 0 @@ -35,7 +35,7 @@ aaaaaaaaa dsaass de Pizza de Salmao 8 0 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,t2.id; q item id x -aaaaaaaaa dsaass de sushi 1 1.92378665219675 +aaaaaaaaa dsaass de sushi 1 1.92378664016724 aaaaaaaaa dsaass de Bolo de Chocolate 2 0 aaaaaaaaa dsaass de Feijoada 3 0 aaaaaaaaa dsaass de Mousse de Chocolate 4 0 diff --git a/mysql-test/r/fulltext_left_join.result b/mysql-test/r/fulltext_left_join.result index 03751a17308..34b8de31061 100644 --- a/mysql-test/r/fulltext_left_join.result +++ b/mysql-test/r/fulltext_left_join.result @@ -20,6 +20,6 @@ from t1 left join t2 on t2.id=t1.id; match(t1.texte,t1.sujet,t1.motsclefs) against('droit') 0 0 -0.67003110026735 +0.67003107070923 0 drop table t1, t2; diff --git a/mysql-test/r/fulltext_multi.result b/mysql-test/r/fulltext_multi.result index 27374e9e4aa..72b7102fd3f 100644 --- a/mysql-test/r/fulltext_multi.result +++ b/mysql-test/r/fulltext_multi.result @@ -14,17 +14,17 @@ INSERT INTO t1 VALUES (2,'asdf fdsa','lkjh fghj'); INSERT INTO t1 VALUES (3,'qpwoei','zmxnvb'); SELECT a, MATCH b AGAINST ('lala lkjh') FROM t1; a MATCH b AGAINST ('lala lkjh') -1 0.67003110026735 +1 0.67003107070923 2 0 3 0 SELECT a, MATCH c AGAINST ('lala lkjh') FROM t1; a MATCH c AGAINST ('lala lkjh') 1 0 -2 0.67756324121582 +2 0.67756325006485 3 0 SELECT a, MATCH b,c AGAINST ('lala lkjh') FROM t1; a MATCH b,c AGAINST ('lala lkjh') -1 0.64840710366884 -2 0.66266459031789 +1 0.64840710163116 +2 0.66266459226608 3 0 drop table t1; diff --git a/mysql-test/r/fulltext_order_by.result b/mysql-test/r/fulltext_order_by.result index cc94ba7e041..e096de2af1b 100644 --- a/mysql-test/r/fulltext_order_by.result +++ b/mysql-test/r/fulltext_order_by.result @@ -9,19 +9,19 @@ INSERT INTO t1 (message) VALUES ("Testing"),("table"),("testbug"), ("steve"),("is"),("cool"),("steve is cool"); SELECT a, MATCH (message) AGAINST ('steve') FROM t1 WHERE MATCH (message) AGAINST ('steve'); a MATCH (message) AGAINST ('steve') -4 0.90587321329654 -7 0.89568988462614 +4 0.90587323904037 +7 0.89568990468979 SELECT a, MATCH (message) AGAINST ('steve') FROM t1 WHERE MATCH (message) AGAINST ('steve') ORDER BY a; a MATCH (message) AGAINST ('steve') -4 0.90587321329654 -7 0.89568988462614 +4 0.90587323904037 +7 0.89568990468979 SELECT a, MATCH (message) AGAINST ('steve') FROM t1 WHERE a in (2,7,4) and MATCH (message) AGAINST ('steve') ORDER BY a DESC; a MATCH (message) AGAINST ('steve') -7 0.89568988462614 -4 0.90587321329654 +7 0.89568990468979 +4 0.90587323904037 SELECT a, MATCH (message) AGAINST ('steve') FROM t1 WHERE a=7 and MATCH (message) AGAINST ('steve') ORDER BY 1; a MATCH (message) AGAINST ('steve') -7 0.89568988462614 +7 0.89568990468979 SELECT a, MATCH (message) AGAINST ('steve') as rel FROM t1 ORDER BY rel; a rel 1 0 @@ -29,6 +29,6 @@ a rel 3 0 5 0 6 0 -7 0.89568988462614 -4 0.90587321329654 +7 0.89568990468979 +4 0.90587323904037 drop table t1; |