1
|
a:1:{i:0;a:18:{i:0;a:2:{s:8:"sphinxql";s:57:"insert into rt (id, idd1, body) values ( 11, 14, 'bird' )";s:14:"total_affected";i:1;}i:1;a:2:{s:8:"sphinxql";s:65:"insert into rt (id, idd1, body) values ( 12, 13, 'dog eats cat' )";s:14:"total_affected";i:1;}i:2;a:2:{s:8:"sphinxql";s:66:"insert into rt (id, idd1, body) values ( 13, 12, 'cat eats bird' )";s:14:"total_affected";i:1;}i:3;a:2:{s:8:"sphinxql";s:59:"insert into rt (id, idd1, body) values ( 14, 11, 'a bird' )";s:14:"total_affected";i:1;}i:4;a:2:{s:8:"sphinxql";s:58:"insert into rt (id, idd1, body) values ( 15, 11, 'a cat' )";s:14:"total_affected";i:1;}i:5;a:2:{s:8:"sphinxql";s:58:"insert into rt (id, idd1, body) values ( 16, 11, 'a dog' )";s:14:"total_affected";i:1;}i:6;a:3:{s:8:"sphinxql";s:19:"select * from plain";s:10:"total_rows";i:6;s:4:"rows";a:6:{i:0;a:2:{s:2:"id";s:1:"1";s:4:"idd1";s:2:"11";}i:1;a:2:{s:2:"id";s:1:"2";s:4:"idd1";s:2:"11";}i:2;a:2:{s:2:"id";s:1:"3";s:4:"idd1";s:2:"11";}i:3;a:2:{s:2:"id";s:1:"4";s:4:"idd1";s:2:"12";}i:4;a:2:{s:2:"id";s:1:"5";s:4:"idd1";s:2:"13";}i:5;a:2:{s:2:"id";s:1:"6";s:4:"idd1";s:2:"14";}}}i:7;a:3:{s:8:"sphinxql";s:16:"select * from rt";s:10:"total_rows";i:6;s:4:"rows";a:6:{i:0;a:2:{s:2:"id";s:2:"11";s:4:"idd1";s:2:"14";}i:1;a:2:{s:2:"id";s:2:"12";s:4:"idd1";s:2:"13";}i:2;a:2:{s:2:"id";s:2:"13";s:4:"idd1";s:2:"12";}i:3;a:2:{s:2:"id";s:2:"14";s:4:"idd1";s:2:"11";}i:4;a:2:{s:2:"id";s:2:"15";s:4:"idd1";s:2:"11";}i:5;a:2:{s:2:"id";s:2:"16";s:4:"idd1";s:2:"11";}}}i:8;a:3:{s:8:"sphinxql";s:18:"select * from both";s:10:"total_rows";i:12;s:4:"rows";a:12:{i:0;a:2:{s:2:"id";s:1:"1";s:4:"idd1";s:2:"11";}i:1;a:2:{s:2:"id";s:1:"2";s:4:"idd1";s:2:"11";}i:2;a:2:{s:2:"id";s:1:"3";s:4:"idd1";s:2:"11";}i:3;a:2:{s:2:"id";s:1:"4";s:4:"idd1";s:2:"12";}i:4;a:2:{s:2:"id";s:1:"5";s:4:"idd1";s:2:"13";}i:5;a:2:{s:2:"id";s:1:"6";s:4:"idd1";s:2:"14";}i:6;a:2:{s:2:"id";s:2:"11";s:4:"idd1";s:2:"14";}i:7;a:2:{s:2:"id";s:2:"12";s:4:"idd1";s:2:"13";}i:8;a:2:{s:2:"id";s:2:"13";s:4:"idd1";s:2:"12";}i:9;a:2:{s:2:"id";s:2:"14";s:4:"idd1";s:2:"11";}i:10;a:2:{s:2:"id";s:2:"15";s:4:"idd1";s:2:"11";}i:11;a:2:{s:2:"id";s:2:"16";s:4:"idd1";s:2:"11";}}}i:9;a:2:{s:8:"sphinxql";s:36:"select * from both where match ('a')";s:10:"total_rows";i:0;}i:10;a:3:{s:8:"sphinxql";s:39:"select * from both where match ('bird')";s:10:"total_rows";i:6;s:4:"rows";a:6:{i:0;a:2:{s:2:"id";s:1:"3";s:4:"idd1";s:2:"11";}i:1;a:2:{s:2:"id";s:1:"4";s:4:"idd1";s:2:"12";}i:2;a:2:{s:2:"id";s:1:"6";s:4:"idd1";s:2:"14";}i:3;a:2:{s:2:"id";s:2:"11";s:4:"idd1";s:2:"14";}i:4;a:2:{s:2:"id";s:2:"13";s:4:"idd1";s:2:"12";}i:5;a:2:{s:2:"id";s:2:"14";s:4:"idd1";s:2:"11";}}}i:11;a:3:{s:8:"sphinxql";s:32:"select * from both where idd1=11";s:10:"total_rows";i:6;s:4:"rows";a:6:{i:0;a:2:{s:2:"id";s:1:"1";s:4:"idd1";s:2:"11";}i:1;a:2:{s:2:"id";s:1:"2";s:4:"idd1";s:2:"11";}i:2;a:2:{s:2:"id";s:1:"3";s:4:"idd1";s:2:"11";}i:3;a:2:{s:2:"id";s:2:"14";s:4:"idd1";s:2:"11";}i:4;a:2:{s:2:"id";s:2:"15";s:4:"idd1";s:2:"11";}i:5;a:2:{s:2:"id";s:2:"16";s:4:"idd1";s:2:"11";}}}i:12;a:3:{s:8:"sphinxql";s:33:"select * from both where idd1!=11";s:10:"total_rows";i:6;s:4:"rows";a:6:{i:0;a:2:{s:2:"id";s:1:"4";s:4:"idd1";s:2:"12";}i:1;a:2:{s:2:"id";s:1:"5";s:4:"idd1";s:2:"13";}i:2;a:2:{s:2:"id";s:1:"6";s:4:"idd1";s:2:"14";}i:3;a:2:{s:2:"id";s:2:"11";s:4:"idd1";s:2:"14";}i:4;a:2:{s:2:"id";s:2:"12";s:4:"idd1";s:2:"13";}i:5;a:2:{s:2:"id";s:2:"13";s:4:"idd1";s:2:"12";}}}i:13;a:3:{s:8:"sphinxql";s:52:"select * from both where match ('bird') and idd1!=11";s:10:"total_rows";i:4;s:4:"rows";a:4:{i:0;a:2:{s:2:"id";s:1:"4";s:4:"idd1";s:2:"12";}i:1;a:2:{s:2:"id";s:1:"6";s:4:"idd1";s:2:"14";}i:2;a:2:{s:2:"id";s:2:"11";s:4:"idd1";s:2:"14";}i:3;a:2:{s:2:"id";s:2:"13";s:4:"idd1";s:2:"12";}}}i:14;a:3:{s:8:"sphinxql";s:33:"select * from both where idd1!=10";s:10:"total_rows";i:12;s:4:"rows";a:12:{i:0;a:2:{s:2:"id";s:1:"1";s:4:"idd1";s:2:"11";}i:1;a:2:{s:2:"id";s:1:"2";s:4:"idd1";s:2:"11";}i:2;a:2:{s:2:"id";s:1:"3";s:4:"idd1";s:2:"11";}i:3;a:2:{s:2:"id";s:1:"4";s:4:"idd1";s:2:"12";}i:4;a:2:{s:2:"id";s:1:"5";s:4:"idd1";s:2:"13";}i:5;a:2:{s:2:"id";s:1:"6";s:4:"idd1";s:2:"14";}i:6;a:2:{s:2:"id";s:2:"11";s:4:"idd1";s:2:"14";}i:7;a:2:{s:2:"id";s:2:"12";s:4:"idd1";s:2:"13";}i:8;a:2:{s:2:"id";s:2:"13";s:4:"idd1";s:2:"12";}i:9;a:2:{s:2:"id";s:2:"14";s:4:"idd1";s:2:"11";}i:10;a:2:{s:2:"id";s:2:"15";s:4:"idd1";s:2:"11";}i:11;a:2:{s:2:"id";s:2:"16";s:4:"idd1";s:2:"11";}}}i:15;a:2:{s:8:"sphinxql";s:17:"flush ramchunk rt";s:14:"total_affected";i:0;}i:16;a:3:{s:8:"sphinxql";s:39:"select * from rt where match ('a bird')";s:10:"total_rows";i:3;s:4:"rows";a:3:{i:0;a:2:{s:2:"id";s:2:"11";s:4:"idd1";s:2:"14";}i:1;a:2:{s:2:"id";s:2:"13";s:4:"idd1";s:2:"12";}i:2;a:2:{s:2:"id";s:2:"14";s:4:"idd1";s:2:"11";}}}i:17;a:3:{s:8:"sphinxql";s:33:"call keywords ('a bird', 'rt', 1)";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:5:{s:4:"qpos";s:1:"2";s:9:"tokenized";s:4:"bird";s:10:"normalized";s:4:"bird";s:4:"docs";s:1:"3";s:4:"hits";s:1:"3";}}}}}
|