Debian Codegraph @

mysql-test/suite/sys_vars/r/ft_boolean_syntax_func.result

raw
1 '#--------------------FN_DYNVARS_033_01-------------------------#'
2 SET @@global.ft_boolean_syntax = ' -+()<>~*:``&|';
3 connect con1,localhost,root,,,,;
4 connection con1;
5 SELECT @@global.ft_boolean_syntax;
6 @@global.ft_boolean_syntax
7 -+()<>~*:``&|
8 SET @@global.ft_boolean_syntax = '+ -><()~*:""&|';
9 connect con2,localhost,root,,,,;
10 connection con2;
11 SELECT @@global.ft_boolean_syntax;
12 @@global.ft_boolean_syntax
13 + -><()~*:""&|
14 disconnect con2;
15 disconnect con1;
16 '#--------------------FN_DYNVARS_033_02-------------------------#'
17 connection default;
18 DROP TABLE IF EXISTS t1;
19 CREATE TABLE articles (
20 id INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY,
21 title VARCHAR(200),
22 body TEXT,
23 FULLTEXT (title,body)
24 );
25 INSERT INTO articles (title,body) VALUES
26 ('MySQL Tutorial','DBMS stands for DataBase ...'),
27 ('How To',''),
28 ('How To Use MySQL Well','After you went through a ...'),
29 ('Optimizing MySQL','In this tutorial we will show .... Run command line ...'),
30 ('1001 MySQL Tricks','1. Never run mysqld as root. 2. ...'),
31 ('100 Tips for Myisam','1. Myisam is faster than innodb 2. Tricks and Tips for Myisam...'),
32 ('MySQL vs. YourSQL','In the following database comparison ...'),
33 ('MySQL Security','When configured properly, MySQL ...'),
34 ('Database Security','Configuring MySQL for ...');
35 SET @@global.ft_boolean_syntax = DEFAULT;
36 SELECT * FROM articles WHERE MATCH (title,body)
37 AGAINST ('+mySQL -yourSQL' IN BOOLEAN MODE);
38 id title body
39 1 MySQL Tutorial DBMS stands for DataBase ...
40 3 How To Use MySQL Well After you went through a ...
41 4 Optimizing MySQL In this tutorial we will show .... Run command line ...
42 5 1001 MySQL Tricks 1. Never run mysqld as root. 2. ...
43 8 MySQL Security When configured properly, MySQL ...
44 9 Database Security Configuring MySQL for ...
45 SELECT * FROM articles WHERE MATCH (title,body)
46 AGAINST ('+MySQL +YourSQL' IN BOOLEAN MODE);
47 id title body
48 7 MySQL vs. YourSQL In the following database comparison ...
49 SELECT * FROM articles WHERE MATCH (title,body)
50 AGAINST ('MySQL' IN BOOLEAN MODE);
51 id title body
52 1 MySQL Tutorial DBMS stands for DataBase ...
53 3 How To Use MySQL Well After you went through a ...
54 4 Optimizing MySQL In this tutorial we will show .... Run command line ...
55 5 1001 MySQL Tricks 1. Never run mysqld as root. 2. ...
56 7 MySQL vs. YourSQL In the following database comparison ...
57 8 MySQL Security When configured properly, MySQL ...
58 9 Database Security Configuring MySQL for ...
59 SELECT * FROM articles WHERE MATCH (title,body)
60 AGAINST ('mysql tutorial dbms' IN BOOLEAN MODE);
61 id title body
62 1 MySQL Tutorial DBMS stands for DataBase ...
63 3 How To Use MySQL Well After you went through a ...
64 4 Optimizing MySQL In this tutorial we will show .... Run command line ...
65 5 1001 MySQL Tricks 1. Never run mysqld as root. 2. ...
66 7 MySQL vs. YourSQL In the following database comparison ...
67 8 MySQL Security When configured properly, MySQL ...
68 9 Database Security Configuring MySQL for ...
69 SELECT id,title,body, (MATCH (title,body)
70 AGAINST ('+security configuring' IN BOOLEAN MODE)) AS relevance
71 FROM articles WHERE MATCH (title,body)
72 AGAINST ('+security configuring' IN BOOLEAN MODE);
73 id title body relevance
74 8 MySQL Security When configured properly, MySQL ... 1
75 9 Database Security Configuring MySQL for ... 1.3333333730697632
76 SELECT * FROM articles WHERE MATCH (title,body)
77 AGAINST ('"faster than"' IN BOOLEAN MODE);
78 id title body
79 6 100 Tips for Myisam 1. Myisam is faster than innodb 2. Tricks and Tips for Myisam...
80 SELECT * FROM articles WHERE MATCH (title,body)
81 AGAINST ('+tutorial ~line' IN BOOLEAN MODE);
82 id title body
83 1 MySQL Tutorial DBMS stands for DataBase ...
84 4 Optimizing MySQL In this tutorial we will show .... Run command line ...
85 SELECT * FROM articles WHERE MATCH (title,body)
86 AGAINST ('10*' IN BOOLEAN MODE);
87 id title body
88 5 1001 MySQL Tricks 1. Never run mysqld as root. 2. ...
89 SELECT id,title,body, (MATCH (title,body)
90 AGAINST ('+MySQL +(>show <dbms)' IN BOOLEAN MODE)) AS relevance
91 FROM articles WHERE MATCH (title,body)
92 AGAINST ('+MySQL +(>show <dbms)' IN BOOLEAN MODE)
93 ORDER BY relevance DESC;
94 id title body relevance
95 4 Optimizing MySQL In this tutorial we will show .... Run command line ... 1.25
96 1 MySQL Tutorial DBMS stands for DataBase ... 0.8333333730697632
97 '---try setting different operators. Default '+ -><()~*:""&|'--'
98 SET @@global.ft_boolean_syntax='~ /!@#$%^&*()-';
99 SELECT * FROM articles WHERE MATCH (title,body)
100 AGAINST ('~mySQL /yourSQL' IN BOOLEAN MODE);
101 id title body
102 1 MySQL Tutorial DBMS stands for DataBase ...
103 3 How To Use MySQL Well After you went through a ...
104 4 Optimizing MySQL In this tutorial we will show .... Run command line ...
105 5 1001 MySQL Tricks 1. Never run mysqld as root. 2. ...
106 8 MySQL Security When configured properly, MySQL ...
107 9 Database Security Configuring MySQL for ...
108 SET @@global.ft_boolean_syntax=DEFAULT;
109 DROP TABLE articles;