File: model.bin

package info (click to toggle)
sphinxsearch 2.2.11-8
links: PTS, VCS
area: main
in suites: bookworm, sid, trixie
size: 25,720 kB
sloc: cpp: 102,259; xml: 85,608; sh: 9,259; php: 3,790; ansic: 3,158; yacc: 1,969; java: 1,336; ruby: 1,289; python: 1,062; pascal: 912; perl: 381; lex: 275; makefile: 150; sql: 77; cs: 35
file content (1 line) | stat: -rw-r--r-- 23,554 bytes
parent folder | download | duplicates (4)
a:2:{i:0;a:63:{i:0;a:3:{s:8:"sphinxql";s:37:"select * from test where match('mix')";s:10:"total_rows";i:3;s:4:"rows";a:3:{i:0;a:1:{s:2:"id";s:3:"100";}i:1;a:1:{s:2:"id";s:3:"102";}i:2;a:1:{s:2:"id";s:3:"103";}}}i:1;a:3:{s:8:"sphinxql";s:48:"select * from test where match('русский')";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:1:{s:2:"id";s:3:"102";}}}i:2;a:3:{s:8:"sphinxql";s:38:"select * from test where match('test')";s:10:"total_rows";i:3;s:4:"rows";a:3:{i:0;a:1:{s:2:"id";s:3:"102";}i:1;a:1:{s:2:"id";s:3:"103";}i:2;a:1:{s:2:"id";s:3:"104";}}}i:3;a:3:{s:8:"sphinxql";s:39:"select * from test where match('test2')";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:1:{s:2:"id";s:3:"105";}}}i:4;a:3:{s:8:"sphinxql";s:40:"select * from test where match('許多')";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:1:{s:2:"id";s:3:"101";}}}i:5;a:3:{s:8:"sphinxql";s:37:"select * from test where match('則')";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:1:{s:2:"id";s:3:"103";}}}i:6;a:2:{s:8:"sphinxql";s:37:"select * from test where match('來')";s:10:"total_rows";i:0;}i:7;a:3:{s:8:"sphinxql";s:55:"select * from test where match('這群白髮蒼蒼，')";s:10:"total_rows";i:2;s:4:"rows";a:2:{i:0;a:1:{s:2:"id";s:3:"106";}i:1;a:1:{s:2:"id";s:3:"105";}}}i:8;a:3:{s:8:"sphinxql";s:38:"select * from test where match('ruin')";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:1:{s:2:"id";s:3:"106";}}}i:9;a:3:{s:8:"sphinxql";s:37:"select * from test where match('aaa')";s:10:"total_rows";i:3;s:4:"rows";a:3:{i:0;a:1:{s:2:"id";s:3:"100";}i:1;a:1:{s:2:"id";s:3:"102";}i:2;a:1:{s:2:"id";s:3:"103";}}}i:10;a:3:{s:8:"sphinxql";s:37:"select * from test where match('bbb')";s:10:"total_rows";i:3;s:4:"rows";a:3:{i:0;a:1:{s:2:"id";s:3:"100";}i:1;a:1:{s:2:"id";s:3:"102";}i:2;a:1:{s:2:"id";s:3:"103";}}}i:11;a:3:{s:8:"sphinxql";s:41:"select * from test where match('aaa-bbb')";s:10:"total_rows";i:3;s:4:"rows";a:3:{i:0;a:1:{s:2:"id";s:3:"100";}i:1;a:1:{s:2:"id";s:3:"102";}i:2;a:1:{s:2:"id";s:3:"103";}}}i:12;a:3:{s:8:"sphinxql";s:40:"select * from test where match('msgCnt')";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:1:{s:2:"id";s:3:"107";}}}i:13;a:3:{s:8:"sphinxql";s:49:"select * from test where match('今天的心情')";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:1:{s:2:"id";s:3:"107";}}}i:14;a:3:{s:8:"sphinxql";s:46:"select * from test where match('@content 則')";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:1:{s:2:"id";s:3:"103";}}}i:15;a:3:{s:8:"sphinxql";s:45:"select * from test where match('querymapped')";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:1:{s:2:"id";s:3:"108";}}}i:16;a:3:{s:8:"sphinxql";s:41:"select * from test_xml where match('mix')";s:10:"total_rows";i:3;s:4:"rows";a:3:{i:0;a:2:{s:2:"id";s:3:"100";s:3:"gid";s:1:"1";}i:1;a:2:{s:2:"id";s:3:"102";s:3:"gid";s:1:"3";}i:2;a:2:{s:2:"id";s:3:"103";s:3:"gid";s:1:"4";}}}i:17;a:3:{s:8:"sphinxql";s:52:"select * from test_xml where match('русский')";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:2:{s:2:"id";s:3:"102";s:3:"gid";s:1:"3";}}}i:18;a:3:{s:8:"sphinxql";s:42:"select * from test_xml where match('test')";s:10:"total_rows";i:3;s:4:"rows";a:3:{i:0;a:2:{s:2:"id";s:3:"102";s:3:"gid";s:1:"3";}i:1;a:2:{s:2:"id";s:3:"103";s:3:"gid";s:1:"4";}i:2;a:2:{s:2:"id";s:3:"104";s:3:"gid";s:1:"5";}}}i:19;a:3:{s:8:"sphinxql";s:43:"select * from test_xml where match('test2')";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:2:{s:2:"id";s:3:"105";s:3:"gid";s:1:"6";}}}i:20;a:3:{s:8:"sphinxql";s:44:"select * from test_xml where match('許多')";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:2:{s:2:"id";s:3:"101";s:3:"gid";s:1:"2";}}}i:21;a:3:{s:8:"sphinxql";s:41:"select * from test_xml where match('則')";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:2:{s:2:"id";s:3:"103";s:3:"gid";s:1:"4";}}}i:22;a:2:{s:8:"sphinxql";s:41:"select * from test_xml where match('來')";s:10:"total_rows";i:0;}i:23;a:3:{s:8:"sphinxql";s:59:"select * from test_xml where match('這群白髮蒼蒼，')";s:10:"total_rows";i:2;s:4:"rows";a:2:{i:0;a:2:{s:2:"id";s:3:"106";s:3:"gid";s:1:"7";}i:1;a:2:{s:2:"id";s:3:"105";s:3:"gid";s:1:"6";}}}i:24;a:3:{s:8:"sphinxql";s:42:"select * from test_xml where match('ruin')";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:2:{s:2:"id";s:3:"106";s:3:"gid";s:1:"7";}}}i:25;a:3:{s:8:"sphinxql";s:41:"select * from test_xml where match('aaa')";s:10:"total_rows";i:3;s:4:"rows";a:3:{i:0;a:2:{s:2:"id";s:3:"100";s:3:"gid";s:1:"1";}i:1;a:2:{s:2:"id";s:3:"102";s:3:"gid";s:1:"3";}i:2;a:2:{s:2:"id";s:3:"103";s:3:"gid";s:1:"4";}}}i:26;a:3:{s:8:"sphinxql";s:41:"select * from test_xml where match('bbb')";s:10:"total_rows";i:3;s:4:"rows";a:3:{i:0;a:2:{s:2:"id";s:3:"100";s:3:"gid";s:1:"1";}i:1;a:2:{s:2:"id";s:3:"102";s:3:"gid";s:1:"3";}i:2;a:2:{s:2:"id";s:3:"103";s:3:"gid";s:1:"4";}}}i:27;a:3:{s:8:"sphinxql";s:45:"select * from test_xml where match('aaa-bbb')";s:10:"total_rows";i:3;s:4:"rows";a:3:{i:0;a:2:{s:2:"id";s:3:"100";s:3:"gid";s:1:"1";}i:1;a:2:{s:2:"id";s:3:"102";s:3:"gid";s:1:"3";}i:2;a:2:{s:2:"id";s:3:"103";s:3:"gid";s:1:"4";}}}i:28;a:3:{s:8:"sphinxql";s:44:"select * from test_xml where match('msgCnt')";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:2:{s:2:"id";s:3:"107";s:3:"gid";s:1:"8";}}}i:29;a:3:{s:8:"sphinxql";s:53:"select * from test_xml where match('今天的心情')";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:2:{s:2:"id";s:3:"107";s:3:"gid";s:1:"8";}}}i:30;a:3:{s:8:"sphinxql";s:50:"select * from test_xml where match('@content 則')";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:2:{s:2:"id";s:3:"103";s:3:"gid";s:1:"4";}}}i:31;a:2:{s:8:"sphinxql";s:94:"insert into test2 values(1,'this is some mixed text in english. and some blended aaa-bbb',10 )";s:14:"total_affected";i:1;}i:32;a:2:{s:8:"sphinxql";s:103:"insert into test2 values(2,'許多社區長青學苑多開設有書法、插花、土風舞班，',11 )";s:14:"total_affected";i:1;}i:33;a:2:{s:8:"sphinxql";s:126:"insert into test2 values(3,'а это - текст на русском. mixed in fact. test tested. more blended aaa-bbb',12 )";s:14:"total_affected";i:1;}i:34;a:2:{s:14:"total_affected";i:1;s:8:"sphinxql";s:131:"insert into test2 values(4,'文山區長青學苑則有個十分特別的「英文歌唱班」，test; mixed blended aaa-bbb', 13 )";}i:35;a:2:{s:8:"sphinxql";s:74:"insert into test2 values(5,'成員年齡均超過六十歲，tested', 14 )";s:14:"total_affected";i:1;}i:36;a:2:{s:8:"sphinxql";s:61:"insert into test2 values(6,'這群白髮蒼蒼，test2', 15 )";s:14:"total_affected";i:1;}i:37;a:2:{s:8:"sphinxql";s:79:"insert into test2 values(7,'這群白髮蒼蒼 RUINED 這群白髮蒼蒼', 16 )";s:14:"total_affected";i:1;}i:38;a:2:{s:8:"sphinxql";s:167:"insert into test2 values(8,'<div class="msgCnt">说说<a href="http://k.t.qq.com/k/%E4%BB%8A%E5%A4%A9%E7%9A%84%E5%BF%83%E6%83%85">#今天的心情#</a>：</div>', 17 )";s:14:"total_affected";i:1;}i:39;a:3:{s:8:"sphinxql";s:38:"select * from test2 where match('mix')";s:10:"total_rows";i:3;s:4:"rows";a:3:{i:0;a:2:{s:2:"id";s:1:"1";s:3:"tag";s:2:"10";}i:1;a:2:{s:2:"id";s:1:"3";s:3:"tag";s:2:"12";}i:2;a:2:{s:2:"id";s:1:"4";s:3:"tag";s:2:"13";}}}i:40;a:3:{s:8:"sphinxql";s:49:"select * from test2 where match('русский')";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:2:{s:2:"id";s:1:"3";s:3:"tag";s:2:"12";}}}i:41;a:3:{s:8:"sphinxql";s:39:"select * from test2 where match('test')";s:10:"total_rows";i:3;s:4:"rows";a:3:{i:0;a:2:{s:2:"id";s:1:"3";s:3:"tag";s:2:"12";}i:1;a:2:{s:2:"id";s:1:"4";s:3:"tag";s:2:"13";}i:2;a:2:{s:2:"id";s:1:"5";s:3:"tag";s:2:"14";}}}i:42;a:3:{s:8:"sphinxql";s:40:"select * from test2 where match('test2')";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:2:{s:2:"id";s:1:"6";s:3:"tag";s:2:"15";}}}i:43;a:3:{s:8:"sphinxql";s:41:"select * from test2 where match('許多')";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:2:{s:2:"id";s:1:"2";s:3:"tag";s:2:"11";}}}i:44;a:3:{s:8:"sphinxql";s:38:"select * from test2 where match('則')";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:2:{s:2:"id";s:1:"4";s:3:"tag";s:2:"13";}}}i:45;a:2:{s:8:"sphinxql";s:38:"select * from test2 where match('來')";s:10:"total_rows";i:0;}i:46;a:3:{s:8:"sphinxql";s:56:"select * from test2 where match('這群白髮蒼蒼，')";s:10:"total_rows";i:2;s:4:"rows";a:2:{i:0;a:2:{s:2:"id";s:1:"7";s:3:"tag";s:2:"16";}i:1;a:2:{s:2:"id";s:1:"6";s:3:"tag";s:2:"15";}}}i:47;a:3:{s:8:"sphinxql";s:39:"select * from test2 where match('ruin')";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:2:{s:2:"id";s:1:"7";s:3:"tag";s:2:"16";}}}i:48;a:3:{s:8:"sphinxql";s:38:"select * from test2 where match('aaa')";s:10:"total_rows";i:3;s:4:"rows";a:3:{i:0;a:2:{s:2:"id";s:1:"1";s:3:"tag";s:2:"10";}i:1;a:2:{s:2:"id";s:1:"3";s:3:"tag";s:2:"12";}i:2;a:2:{s:2:"id";s:1:"4";s:3:"tag";s:2:"13";}}}i:49;a:3:{s:8:"sphinxql";s:38:"select * from test2 where match('bbb')";s:10:"total_rows";i:3;s:4:"rows";a:3:{i:0;a:2:{s:2:"id";s:1:"1";s:3:"tag";s:2:"10";}i:1;a:2:{s:2:"id";s:1:"3";s:3:"tag";s:2:"12";}i:2;a:2:{s:2:"id";s:1:"4";s:3:"tag";s:2:"13";}}}i:50;a:3:{s:8:"sphinxql";s:42:"select * from test2 where match('aaa-bbb')";s:10:"total_rows";i:3;s:4:"rows";a:3:{i:0;a:2:{s:2:"id";s:1:"1";s:3:"tag";s:2:"10";}i:1;a:2:{s:2:"id";s:1:"3";s:3:"tag";s:2:"12";}i:2;a:2:{s:2:"id";s:1:"4";s:3:"tag";s:2:"13";}}}i:51;a:3:{s:8:"sphinxql";s:41:"select * from test2 where match('msgCnt')";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:2:{s:2:"id";s:1:"8";s:3:"tag";s:2:"17";}}}i:52;a:3:{s:8:"sphinxql";s:50:"select * from test2 where match('今天的心情')";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:2:{s:2:"id";s:1:"8";s:3:"tag";s:2:"17";}}}i:53;a:3:{s:8:"sphinxql";s:45:"select * from test2 where match('@title 則')";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:2:{s:2:"id";s:1:"4";s:3:"tag";s:2:"13";}}}i:54;a:2:{s:8:"sphinxql";s:49:"select * from test_stripped where match('msgCnt')";s:10:"total_rows";i:0;}i:55;a:3:{s:8:"sphinxql";s:58:"select * from test_stripped where match('今天的心情')";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:1:{s:2:"id";s:3:"107";}}}i:56;a:3:{s:8:"sphinxql";s:66:"select * from test_spec where match('凤1 凤凤凤 轉注转注')";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:3:{s:2:"id";s:3:"300";s:5:"title";s:17:"凤1 轉注转注";s:3:"idd";s:2:"11";}}}i:57;a:3:{s:8:"sphinxql";s:69:"select * from test_spec where match('凤1  凤凤凤   轉注转注')";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:3:{s:2:"id";s:3:"300";s:5:"title";s:17:"凤1 轉注转注";s:3:"idd";s:2:"11";}}}i:58;a:3:{s:8:"sphinxql";s:45:"select * from test_spec where match('"凤1"')";s:10:"total_rows";i:3;s:4:"rows";a:3:{i:0;a:3:{s:2:"id";s:3:"100";s:5:"title";s:10:"the 凤1 a";s:3:"idd";s:2:"11";}i:1;a:3:{s:2:"id";s:3:"200";s:5:"title";s:4:"凤1";s:3:"idd";s:2:"11";}i:2;a:3:{s:2:"id";s:3:"300";s:5:"title";s:17:"凤1 轉注转注";s:3:"idd";s:2:"11";}}}i:59;a:3:{s:8:"sphinxql";s:43:"select * from test_spec where match('凤1')";s:10:"total_rows";i:3;s:4:"rows";a:3:{i:0;a:3:{s:2:"id";s:3:"100";s:5:"title";s:10:"the 凤1 a";s:3:"idd";s:2:"11";}i:1;a:3:{s:2:"id";s:3:"200";s:5:"title";s:4:"凤1";s:3:"idd";s:2:"11";}i:2;a:3:{s:2:"id";s:3:"300";s:5:"title";s:17:"凤1 轉注转注";s:3:"idd";s:2:"11";}}}i:60;a:2:{s:8:"sphinxql";s:51:"select * from test_spec where match('^凤 轉注$')";s:10:"total_rows";i:0;}i:61;a:3:{s:8:"sphinxql";s:59:"select * from test_spec where match('注 ^凤 轉凤$ 注')";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:3:{s:2:"id";s:3:"400";s:5:"title";s:14:"凤 注 轉凤";s:3:"idd";s:2:"11";}}}i:62;a:3:{s:8:"sphinxql";s:47:"select * from test_spec where match('凤 !注')";s:10:"total_rows";i:3;s:4:"rows";a:3:{i:0;a:3:{s:2:"id";s:3:"100";s:5:"title";s:10:"the 凤1 a";s:3:"idd";s:2:"11";}i:1;a:3:{s:2:"id";s:3:"200";s:5:"title";s:4:"凤1";s:3:"idd";s:2:"11";}i:2;a:3:{s:2:"id";s:3:"300";s:5:"title";s:17:"凤1 轉注转注";s:3:"idd";s:2:"11";}}}}i:1;a:63:{i:0;a:3:{s:8:"sphinxql";s:37:"select * from test where match('mix')";s:10:"total_rows";i:3;s:4:"rows";a:3:{i:0;a:1:{s:2:"id";s:3:"100";}i:1;a:1:{s:2:"id";s:3:"102";}i:2;a:1:{s:2:"id";s:3:"103";}}}i:1;a:3:{s:8:"sphinxql";s:48:"select * from test where match('русский')";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:1:{s:2:"id";s:3:"102";}}}i:2;a:3:{s:8:"sphinxql";s:38:"select * from test where match('test')";s:10:"total_rows";i:3;s:4:"rows";a:3:{i:0;a:1:{s:2:"id";s:3:"102";}i:1;a:1:{s:2:"id";s:3:"103";}i:2;a:1:{s:2:"id";s:3:"104";}}}i:3;a:3:{s:8:"sphinxql";s:39:"select * from test where match('test2')";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:1:{s:2:"id";s:3:"105";}}}i:4;a:3:{s:8:"sphinxql";s:40:"select * from test where match('許多')";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:1:{s:2:"id";s:3:"101";}}}i:5;a:3:{s:8:"sphinxql";s:37:"select * from test where match('則')";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:1:{s:2:"id";s:3:"103";}}}i:6;a:2:{s:8:"sphinxql";s:37:"select * from test where match('來')";s:10:"total_rows";i:0;}i:7;a:3:{s:8:"sphinxql";s:55:"select * from test where match('這群白髮蒼蒼，')";s:10:"total_rows";i:2;s:4:"rows";a:2:{i:0;a:1:{s:2:"id";s:3:"106";}i:1;a:1:{s:2:"id";s:3:"105";}}}i:8;a:3:{s:8:"sphinxql";s:38:"select * from test where match('ruin')";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:1:{s:2:"id";s:3:"106";}}}i:9;a:3:{s:8:"sphinxql";s:37:"select * from test where match('aaa')";s:10:"total_rows";i:3;s:4:"rows";a:3:{i:0;a:1:{s:2:"id";s:3:"100";}i:1;a:1:{s:2:"id";s:3:"102";}i:2;a:1:{s:2:"id";s:3:"103";}}}i:10;a:3:{s:8:"sphinxql";s:37:"select * from test where match('bbb')";s:10:"total_rows";i:3;s:4:"rows";a:3:{i:0;a:1:{s:2:"id";s:3:"100";}i:1;a:1:{s:2:"id";s:3:"102";}i:2;a:1:{s:2:"id";s:3:"103";}}}i:11;a:3:{s:8:"sphinxql";s:41:"select * from test where match('aaa-bbb')";s:10:"total_rows";i:3;s:4:"rows";a:3:{i:0;a:1:{s:2:"id";s:3:"100";}i:1;a:1:{s:2:"id";s:3:"102";}i:2;a:1:{s:2:"id";s:3:"103";}}}i:12;a:3:{s:8:"sphinxql";s:40:"select * from test where match('msgCnt')";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:1:{s:2:"id";s:3:"107";}}}i:13;a:3:{s:8:"sphinxql";s:49:"select * from test where match('今天的心情')";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:1:{s:2:"id";s:3:"107";}}}i:14;a:3:{s:8:"sphinxql";s:46:"select * from test where match('@content 則')";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:1:{s:2:"id";s:3:"103";}}}i:15;a:3:{s:8:"sphinxql";s:45:"select * from test where match('querymapped')";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:1:{s:2:"id";s:3:"108";}}}i:16;a:3:{s:8:"sphinxql";s:41:"select * from test_xml where match('mix')";s:10:"total_rows";i:3;s:4:"rows";a:3:{i:0;a:2:{s:2:"id";s:3:"100";s:3:"gid";s:1:"1";}i:1;a:2:{s:2:"id";s:3:"102";s:3:"gid";s:1:"3";}i:2;a:2:{s:2:"id";s:3:"103";s:3:"gid";s:1:"4";}}}i:17;a:3:{s:8:"sphinxql";s:52:"select * from test_xml where match('русский')";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:2:{s:2:"id";s:3:"102";s:3:"gid";s:1:"3";}}}i:18;a:3:{s:8:"sphinxql";s:42:"select * from test_xml where match('test')";s:10:"total_rows";i:3;s:4:"rows";a:3:{i:0;a:2:{s:2:"id";s:3:"102";s:3:"gid";s:1:"3";}i:1;a:2:{s:2:"id";s:3:"103";s:3:"gid";s:1:"4";}i:2;a:2:{s:2:"id";s:3:"104";s:3:"gid";s:1:"5";}}}i:19;a:3:{s:8:"sphinxql";s:43:"select * from test_xml where match('test2')";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:2:{s:2:"id";s:3:"105";s:3:"gid";s:1:"6";}}}i:20;a:3:{s:8:"sphinxql";s:44:"select * from test_xml where match('許多')";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:2:{s:2:"id";s:3:"101";s:3:"gid";s:1:"2";}}}i:21;a:3:{s:8:"sphinxql";s:41:"select * from test_xml where match('則')";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:2:{s:2:"id";s:3:"103";s:3:"gid";s:1:"4";}}}i:22;a:2:{s:8:"sphinxql";s:41:"select * from test_xml where match('來')";s:10:"total_rows";i:0;}i:23;a:3:{s:8:"sphinxql";s:59:"select * from test_xml where match('這群白髮蒼蒼，')";s:10:"total_rows";i:2;s:4:"rows";a:2:{i:0;a:2:{s:2:"id";s:3:"106";s:3:"gid";s:1:"7";}i:1;a:2:{s:2:"id";s:3:"105";s:3:"gid";s:1:"6";}}}i:24;a:3:{s:8:"sphinxql";s:42:"select * from test_xml where match('ruin')";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:2:{s:2:"id";s:3:"106";s:3:"gid";s:1:"7";}}}i:25;a:3:{s:8:"sphinxql";s:41:"select * from test_xml where match('aaa')";s:10:"total_rows";i:3;s:4:"rows";a:3:{i:0;a:2:{s:2:"id";s:3:"100";s:3:"gid";s:1:"1";}i:1;a:2:{s:2:"id";s:3:"102";s:3:"gid";s:1:"3";}i:2;a:2:{s:2:"id";s:3:"103";s:3:"gid";s:1:"4";}}}i:26;a:3:{s:8:"sphinxql";s:41:"select * from test_xml where match('bbb')";s:10:"total_rows";i:3;s:4:"rows";a:3:{i:0;a:2:{s:2:"id";s:3:"100";s:3:"gid";s:1:"1";}i:1;a:2:{s:2:"id";s:3:"102";s:3:"gid";s:1:"3";}i:2;a:2:{s:2:"id";s:3:"103";s:3:"gid";s:1:"4";}}}i:27;a:3:{s:8:"sphinxql";s:45:"select * from test_xml where match('aaa-bbb')";s:10:"total_rows";i:3;s:4:"rows";a:3:{i:0;a:2:{s:2:"id";s:3:"100";s:3:"gid";s:1:"1";}i:1;a:2:{s:2:"id";s:3:"102";s:3:"gid";s:1:"3";}i:2;a:2:{s:2:"id";s:3:"103";s:3:"gid";s:1:"4";}}}i:28;a:3:{s:8:"sphinxql";s:44:"select * from test_xml where match('msgCnt')";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:2:{s:2:"id";s:3:"107";s:3:"gid";s:1:"8";}}}i:29;a:3:{s:8:"sphinxql";s:53:"select * from test_xml where match('今天的心情')";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:2:{s:2:"id";s:3:"107";s:3:"gid";s:1:"8";}}}i:30;a:3:{s:8:"sphinxql";s:50:"select * from test_xml where match('@content 則')";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:2:{s:2:"id";s:3:"103";s:3:"gid";s:1:"4";}}}i:31;a:2:{s:8:"sphinxql";s:94:"insert into test2 values(1,'this is some mixed text in english. and some blended aaa-bbb',10 )";s:14:"total_affected";i:1;}i:32;a:2:{s:8:"sphinxql";s:103:"insert into test2 values(2,'許多社區長青學苑多開設有書法、插花、土風舞班，',11 )";s:14:"total_affected";i:1;}i:33;a:2:{s:8:"sphinxql";s:126:"insert into test2 values(3,'а это - текст на русском. mixed in fact. test tested. more blended aaa-bbb',12 )";s:14:"total_affected";i:1;}i:34;a:2:{s:14:"total_affected";i:1;s:8:"sphinxql";s:131:"insert into test2 values(4,'文山區長青學苑則有個十分特別的「英文歌唱班」，test; mixed blended aaa-bbb', 13 )";}i:35;a:2:{s:8:"sphinxql";s:74:"insert into test2 values(5,'成員年齡均超過六十歲，tested', 14 )";s:14:"total_affected";i:1;}i:36;a:2:{s:8:"sphinxql";s:61:"insert into test2 values(6,'這群白髮蒼蒼，test2', 15 )";s:14:"total_affected";i:1;}i:37;a:2:{s:8:"sphinxql";s:79:"insert into test2 values(7,'這群白髮蒼蒼 RUINED 這群白髮蒼蒼', 16 )";s:14:"total_affected";i:1;}i:38;a:2:{s:8:"sphinxql";s:167:"insert into test2 values(8,'<div class="msgCnt">说说<a href="http://k.t.qq.com/k/%E4%BB%8A%E5%A4%A9%E7%9A%84%E5%BF%83%E6%83%85">#今天的心情#</a>：</div>', 17 )";s:14:"total_affected";i:1;}i:39;a:3:{s:8:"sphinxql";s:38:"select * from test2 where match('mix')";s:10:"total_rows";i:3;s:4:"rows";a:3:{i:0;a:2:{s:2:"id";s:1:"1";s:3:"tag";s:2:"10";}i:1;a:2:{s:2:"id";s:1:"3";s:3:"tag";s:2:"12";}i:2;a:2:{s:2:"id";s:1:"4";s:3:"tag";s:2:"13";}}}i:40;a:3:{s:8:"sphinxql";s:49:"select * from test2 where match('русский')";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:2:{s:2:"id";s:1:"3";s:3:"tag";s:2:"12";}}}i:41;a:3:{s:8:"sphinxql";s:39:"select * from test2 where match('test')";s:10:"total_rows";i:3;s:4:"rows";a:3:{i:0;a:2:{s:2:"id";s:1:"3";s:3:"tag";s:2:"12";}i:1;a:2:{s:2:"id";s:1:"4";s:3:"tag";s:2:"13";}i:2;a:2:{s:2:"id";s:1:"5";s:3:"tag";s:2:"14";}}}i:42;a:3:{s:8:"sphinxql";s:40:"select * from test2 where match('test2')";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:2:{s:2:"id";s:1:"6";s:3:"tag";s:2:"15";}}}i:43;a:3:{s:8:"sphinxql";s:41:"select * from test2 where match('許多')";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:2:{s:2:"id";s:1:"2";s:3:"tag";s:2:"11";}}}i:44;a:3:{s:8:"sphinxql";s:38:"select * from test2 where match('則')";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:2:{s:2:"id";s:1:"4";s:3:"tag";s:2:"13";}}}i:45;a:2:{s:8:"sphinxql";s:38:"select * from test2 where match('來')";s:10:"total_rows";i:0;}i:46;a:3:{s:8:"sphinxql";s:56:"select * from test2 where match('這群白髮蒼蒼，')";s:10:"total_rows";i:2;s:4:"rows";a:2:{i:0;a:2:{s:2:"id";s:1:"7";s:3:"tag";s:2:"16";}i:1;a:2:{s:2:"id";s:1:"6";s:3:"tag";s:2:"15";}}}i:47;a:3:{s:8:"sphinxql";s:39:"select * from test2 where match('ruin')";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:2:{s:2:"id";s:1:"7";s:3:"tag";s:2:"16";}}}i:48;a:3:{s:8:"sphinxql";s:38:"select * from test2 where match('aaa')";s:10:"total_rows";i:3;s:4:"rows";a:3:{i:0;a:2:{s:2:"id";s:1:"1";s:3:"tag";s:2:"10";}i:1;a:2:{s:2:"id";s:1:"3";s:3:"tag";s:2:"12";}i:2;a:2:{s:2:"id";s:1:"4";s:3:"tag";s:2:"13";}}}i:49;a:3:{s:8:"sphinxql";s:38:"select * from test2 where match('bbb')";s:10:"total_rows";i:3;s:4:"rows";a:3:{i:0;a:2:{s:2:"id";s:1:"1";s:3:"tag";s:2:"10";}i:1;a:2:{s:2:"id";s:1:"3";s:3:"tag";s:2:"12";}i:2;a:2:{s:2:"id";s:1:"4";s:3:"tag";s:2:"13";}}}i:50;a:3:{s:8:"sphinxql";s:42:"select * from test2 where match('aaa-bbb')";s:10:"total_rows";i:3;s:4:"rows";a:3:{i:0;a:2:{s:2:"id";s:1:"1";s:3:"tag";s:2:"10";}i:1;a:2:{s:2:"id";s:1:"3";s:3:"tag";s:2:"12";}i:2;a:2:{s:2:"id";s:1:"4";s:3:"tag";s:2:"13";}}}i:51;a:3:{s:8:"sphinxql";s:41:"select * from test2 where match('msgCnt')";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:2:{s:2:"id";s:1:"8";s:3:"tag";s:2:"17";}}}i:52;a:3:{s:8:"sphinxql";s:50:"select * from test2 where match('今天的心情')";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:2:{s:2:"id";s:1:"8";s:3:"tag";s:2:"17";}}}i:53;a:3:{s:8:"sphinxql";s:45:"select * from test2 where match('@title 則')";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:2:{s:2:"id";s:1:"4";s:3:"tag";s:2:"13";}}}i:54;a:2:{s:8:"sphinxql";s:49:"select * from test_stripped where match('msgCnt')";s:10:"total_rows";i:0;}i:55;a:3:{s:8:"sphinxql";s:58:"select * from test_stripped where match('今天的心情')";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:1:{s:2:"id";s:3:"107";}}}i:56;a:3:{s:8:"sphinxql";s:66:"select * from test_spec where match('凤1 凤凤凤 轉注转注')";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:3:{s:2:"id";s:3:"300";s:5:"title";s:17:"凤1 轉注转注";s:3:"idd";s:2:"11";}}}i:57;a:3:{s:8:"sphinxql";s:69:"select * from test_spec where match('凤1  凤凤凤   轉注转注')";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:3:{s:2:"id";s:3:"300";s:5:"title";s:17:"凤1 轉注转注";s:3:"idd";s:2:"11";}}}i:58;a:3:{s:8:"sphinxql";s:45:"select * from test_spec where match('"凤1"')";s:10:"total_rows";i:3;s:4:"rows";a:3:{i:0;a:3:{s:2:"id";s:3:"100";s:5:"title";s:10:"the 凤1 a";s:3:"idd";s:2:"11";}i:1;a:3:{s:2:"id";s:3:"200";s:5:"title";s:4:"凤1";s:3:"idd";s:2:"11";}i:2;a:3:{s:2:"id";s:3:"300";s:5:"title";s:17:"凤1 轉注转注";s:3:"idd";s:2:"11";}}}i:59;a:3:{s:8:"sphinxql";s:43:"select * from test_spec where match('凤1')";s:10:"total_rows";i:3;s:4:"rows";a:3:{i:0;a:3:{s:2:"id";s:3:"100";s:5:"title";s:10:"the 凤1 a";s:3:"idd";s:2:"11";}i:1;a:3:{s:2:"id";s:3:"200";s:5:"title";s:4:"凤1";s:3:"idd";s:2:"11";}i:2;a:3:{s:2:"id";s:3:"300";s:5:"title";s:17:"凤1 轉注转注";s:3:"idd";s:2:"11";}}}i:60;a:2:{s:8:"sphinxql";s:51:"select * from test_spec where match('^凤 轉注$')";s:10:"total_rows";i:0;}i:61;a:3:{s:8:"sphinxql";s:59:"select * from test_spec where match('注 ^凤 轉凤$ 注')";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:3:{s:2:"id";s:3:"400";s:5:"title";s:14:"凤 注 轉凤";s:3:"idd";s:2:"11";}}}i:62;a:3:{s:8:"sphinxql";s:47:"select * from test_spec where match('凤 !注')";s:10:"total_rows";i:3;s:4:"rows";a:3:{i:0;a:3:{s:2:"id";s:3:"100";s:5:"title";s:10:"the 凤1 a";s:3:"idd";s:2:"11";}i:1;a:3:{s:2:"id";s:3:"200";s:5:"title";s:4:"凤1";s:3:"idd";s:2:"11";}i:2;a:3:{s:2:"id";s:3:"300";s:5:"title";s:17:"凤1 轉注转注";s:3:"idd";s:2:"11";}}}}}