Debian Codegraph @

mysql-test/suite/sys_vars/t/ft_boolean_syntax_func.test

raw
1 ############## mysql-test\t\ft_boolean_syntax_func.test ######################
2 # #
3 # Variable Name: ft_boolean_syntax #
4 # Scope: GLOBAL #
5 # Access Type: Dynamic #
6 # Data Type: string #
7 # Default Value: + -><()~*:""& #
8 # Range: NA #
9 # #
10 # #
11 # Creation Date: 2008-03-08 #
12 # Author: Rizwan #
13 # #
14 # Description: Test Cases of Dynamic System Variable ft_boolean_syntax #
15 # that checks the behavior of this variable #
16 # #
17 # Reference: http://dev.mysql.com/doc/refman/5.1/en/ #
18 # server-system-variables.html #
19 # #
20 ###############################################################################
21 --source include/force_myisam_default.inc
22
23 # Skip the test if MyISAM is not available
24 --source include/have_myisam.inc
25
26 --echo '#--------------------FN_DYNVARS_033_01-------------------------#'
27 ###################################################################
28 # Check if setting ft_boolean_syntax is changed in new connection #
29 ###################################################################
30
31 SET @@global.ft_boolean_syntax = ' -+()<>~*:``&|';
32 # con1 will be default connection from now on
33 --echo 'connect (con1,localhost,root,,,,)'
34 connect (con1,localhost,root,,,,);
35 --echo 'connection con1'
36 connection con1;
37 SELECT @@global.ft_boolean_syntax;
38 SET @@global.ft_boolean_syntax = '+ -><()~*:""&|';
39 --echo 'connect (con2,localhost,root,,,,)'
40 connect (con2,localhost,root,,,,);
41 --echo 'connection con2'
42 connection con2;
43 SELECT @@global.ft_boolean_syntax;
44 disconnect con2;
45 disconnect con1;
46
47 --echo '#--------------------FN_DYNVARS_033_02-------------------------#'
48 #########################################################
49 # Begin the functionality Testing of ft_boolean_syntax #
50 #########################################################
51
52 --echo 'connection default'
53 connection default;
54
55 --disable_warnings
56 DROP TABLE IF EXISTS t1;
57 --enable_warnings
58
59 CREATE TABLE articles (
60 id INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY,
61 title VARCHAR(200),
62 body TEXT,
63 FULLTEXT (title,body)
64 );
65
66 INSERT INTO articles (title,body) VALUES
67 ('MySQL Tutorial','DBMS stands for DataBase ...'),
68 ('How To',''),
69 ('How To Use MySQL Well','After you went through a ...'),
70 ('Optimizing MySQL','In this tutorial we will show .... Run command line ...'),
71 ('1001 MySQL Tricks','1. Never run mysqld as root. 2. ...'),
72 ('100 Tips for Myisam','1. Myisam is faster than innodb 2. Tricks and Tips for Myisam...'),
73 ('MySQL vs. YourSQL','In the following database comparison ...'),
74 ('MySQL Security','When configured properly, MySQL ...'),
75 ('Database Security','Configuring MySQL for ...');
76
77 SET @@global.ft_boolean_syntax = DEFAULT;
78
79 SELECT * FROM articles WHERE MATCH (title,body)
80 AGAINST ('+mySQL -yourSQL' IN BOOLEAN MODE);
81
82 SELECT * FROM articles WHERE MATCH (title,body)
83 AGAINST ('+MySQL +YourSQL' IN BOOLEAN MODE);
84
85 SELECT * FROM articles WHERE MATCH (title,body)
86 AGAINST ('MySQL' IN BOOLEAN MODE);
87
88 SELECT * FROM articles WHERE MATCH (title,body)
89 AGAINST ('mysql tutorial dbms' IN BOOLEAN MODE);
90
91 SELECT id,title,body, (MATCH (title,body)
92 AGAINST ('+security configuring' IN BOOLEAN MODE)) AS relevance
93 FROM articles WHERE MATCH (title,body)
94 AGAINST ('+security configuring' IN BOOLEAN MODE);
95
96
97 SELECT * FROM articles WHERE MATCH (title,body)
98 AGAINST ('"faster than"' IN BOOLEAN MODE);
99
100 SELECT * FROM articles WHERE MATCH (title,body)
101 AGAINST ('+tutorial ~line' IN BOOLEAN MODE);
102
103 SELECT * FROM articles WHERE MATCH (title,body)
104 AGAINST ('10*' IN BOOLEAN MODE);
105
106 SELECT id,title,body, (MATCH (title,body)
107 AGAINST ('+MySQL +(>show <dbms)' IN BOOLEAN MODE)) AS relevance
108 FROM articles WHERE MATCH (title,body)
109 AGAINST ('+MySQL +(>show <dbms)' IN BOOLEAN MODE)
110 ORDER BY relevance DESC;
111
112 #==============================================================================
113 --echo '---try setting different operators. Default '+ -><()~*:""&|'--'
114 #==============================================================================
115 SET @@global.ft_boolean_syntax='~ /!@#$%^&*()-';
116 SELECT * FROM articles WHERE MATCH (title,body)
117 AGAINST ('~mySQL /yourSQL' IN BOOLEAN MODE);
118
119 #restore default
120 SET @@global.ft_boolean_syntax=DEFAULT;
121
122 #########################################################
123 # End of functionality Testing for ft_boolean_syntax #
124 #########################################################
125 DROP TABLE articles;
126