← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to mysql-test/r/fulltext_multi.result

  • Committer: Monty Taylor
  • Date: 2008-10-16 06:32:30 UTC
  • mto: (511.1.5 codestyle)
  • mto: This revision was merged to the branch mainline in revision 521.
  • Revision ID: monty@inaugust.com-20081016063230-4brxsra0qsmsg84q
Added -Wunused-macros.

Show diffs side-by-side

added added

removed removed

Lines of Context:
mysql-test/r/fulltext_multi.result
1
 
DROP TABLE IF EXISTS t1;
2
 
CREATE TABLE t1 (
3
 
a int(11) NOT NULL auto_increment,
4
 
b text,
5
 
c varchar(254) default NULL,
6
 
PRIMARY KEY (a),
7
 
FULLTEXT KEY bb(b),
8
 
FULLTEXT KEY cc(c),
9
 
FULLTEXT KEY a(b,c)
10
 
);
11
 
INSERT INTO t1 VALUES (1,'lala lolo lili','oooo aaaa pppp');
12
 
INSERT INTO t1 VALUES (2,'asdf fdsa','lkjh fghj');
13
 
INSERT INTO t1 VALUES (3,'qpwoei','zmxnvb');
14
 
SELECT a, round(MATCH  b  AGAINST ('lala lkjh'),5) FROM t1;
15
 
a       round(MATCH  b  AGAINST ('lala lkjh'),5)
16
 
1       0.67003
17
 
2       0.00000
18
 
3       0.00000
19
 
SELECT a, round(MATCH  c  AGAINST ('lala lkjh'),5) FROM t1;
20
 
a       round(MATCH  c  AGAINST ('lala lkjh'),5)
21
 
1       0.00000
22
 
2       0.67756
23
 
3       0.00000
24
 
SELECT a, round(MATCH b,c AGAINST ('lala lkjh'),5) FROM t1;
25
 
a       round(MATCH b,c AGAINST ('lala lkjh'),5)
26
 
1       0.64841
27
 
2       0.66266
28
 
3       0.00000
29
 
drop table t1;