a:1:{i:0;a:23:{i:0;a:3:{s:8:"sphinxql";s:51:"select * from test where match ('ZONE:zoneA dummy')";s:10:"total_rows";i:2;s:4:"rows";a:2:{i:0;a:2:{s:2:"id";s:1:"1";s:3:"idd";s:1:"1";}i:1;a:2:{s:2:"id";s:1:"2";s:3:"idd";s:1:"2";}}}i:1;a:3:{s:8:"sphinxql";s:51:"select * from test where match ('@body[1024] text')";s:10:"total_rows";i:2;s:4:"rows";a:2:{i:0;a:2:{s:2:"id";s:1:"1";s:3:"idd";s:1:"1";}i:1;a:2:{s:2:"id";s:1:"3";s:3:"idd";s:1:"3";}}}i:2;a:3:{s:8:"sphinxql";s:52:"select * from test where match ('@body[1024] dummy')";s:10:"total_rows";i:3;s:4:"rows";a:3:{i:0;a:2:{s:2:"id";s:1:"1";s:3:"idd";s:1:"1";}i:1;a:2:{s:2:"id";s:1:"2";s:3:"idd";s:1:"2";}i:2;a:2:{s:2:"id";s:1:"3";s:3:"idd";s:1:"3";}}}i:3;a:3:{s:8:"sphinxql";s:62:"select * from start_end where match ('@body ABB') group by idd";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:3:{s:2:"id";s:1:"1";s:4:"body";s:3:"ABB";s:3:"idd";s:1:"1";}}}i:4;a:3:{s:8:"sphinxql";s:63:"select * from start_end where match ('@body ^ABB') group by idd";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:3:{s:2:"id";s:1:"1";s:4:"body";s:3:"ABB";s:3:"idd";s:1:"1";}}}i:5;a:3:{s:8:"sphinxql";s:63:"select * from start_end where match ('@body ABB$') group by idd";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:3:{s:2:"id";s:1:"1";s:4:"body";s:3:"ABB";s:3:"idd";s:1:"1";}}}i:6;a:3:{s:8:"sphinxql";s:64:"select * from start_end where match ('@body ^ABB$') group by idd";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:3:{s:2:"id";s:1:"1";s:4:"body";s:3:"ABB";s:3:"idd";s:1:"1";}}}i:7;a:3:{s:8:"sphinxql";s:59:"select * from i1 where match (' "=Republic =of =Ireland" ')";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:3:{s:2:"id";s:1:"1";s:5:"title";s:8:"Footpath";s:7:"country";s:19:"Republic of Ireland";}}}i:8;a:3:{s:8:"sphinxql";s:60:"select * from i1 where match (' "^=Republic =of =Ireland" ')";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:3:{s:2:"id";s:1:"1";s:5:"title";s:8:"Footpath";s:7:"country";s:19:"Republic of Ireland";}}}i:9;a:3:{s:8:"sphinxql";s:60:"select * from i1 where match (' "=Republic =of =Ireland$" ')";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:3:{s:2:"id";s:1:"1";s:5:"title";s:8:"Footpath";s:7:"country";s:19:"Republic of Ireland";}}}i:10;a:3:{s:8:"sphinxql";s:61:"select * from i1 where match (' "^=Republic =of =Ireland$" ')";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:3:{s:2:"id";s:1:"1";s:5:"title";s:8:"Footpath";s:7:"country";s:19:"Republic of Ireland";}}}i:11;a:3:{s:8:"sphinxql";s:45:"select * from i1 where match (' =Footpath$ ')";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:3:{s:2:"id";s:1:"1";s:5:"title";s:8:"Footpath";s:7:"country";s:19:"Republic of Ireland";}}}i:12;a:3:{s:8:"sphinxql";s:46:"select * from i1 where match (' ^=Footpath$ ')";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:3:{s:2:"id";s:1:"1";s:5:"title";s:8:"Footpath";s:7:"country";s:19:"Republic of Ireland";}}}i:13;a:3:{s:8:"sphinxql";s:51:"select * from fl where match (' (@title we) live ')";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:3:{s:2:"id";s:1:"1";s:5:"title";s:16:"we are from here";s:4:"body";s:27:"but live there all the time";}}}i:14;a:3:{s:8:"sphinxql";s:79:"select * from fl where match (' (@title we are) (@body live there) from time ')";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:3:{s:2:"id";s:1:"1";s:5:"title";s:16:"we are from here";s:4:"body";s:27:"but live there all the time";}}}i:15;a:3:{s:8:"sphinxql";s:59:"select * from fl where match (' are (@body we) from time ')";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:3:{s:2:"id";s:1:"2";s:5:"title";s:27:"but live there all the time";s:4:"body";s:16:"we are from here";}}}i:16;a:3:{s:8:"sphinxql";s:77:"select * from fl where match (' are (@body we) from (@title time the) here ')";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:3:{s:2:"id";s:1:"2";s:5:"title";s:27:"but live there all the time";s:4:"body";s:16:"we are from here";}}}i:17;a:3:{s:8:"sphinxql";s:64:"select * from idx_blend_crc where match (' x-com NEAR/10 valid')";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:3:{s:2:"id";s:1:"1";s:5:"title";s:33:"dummy1 dummy1 dummy1 dummy1 X-COM";s:4:"body";s:84:"dummy1 dummy1, dummy1, dummy1 dummy1 dummy1 valid dummy1 dummy1 dummy1 X-COM, dummy1";}}}i:18;a:3:{s:8:"sphinxql";s:64:"select * from idx_blend_kw where match (' x-com NEAR/10 valid ')";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:3:{s:2:"id";s:1:"1";s:5:"title";s:33:"dummy1 dummy1 dummy1 dummy1 X-COM";s:4:"body";s:84:"dummy1 dummy1, dummy1, dummy1 dummy1 dummy1 valid dummy1 dummy1 dummy1 X-COM, dummy1";}}}i:19;a:3:{s:8:"sphinxql";s:130:"CALL SNIPPETS ( 'dummy1 dummy1 valid dummy1 dummy1 dummy1 X-COM, dummy1', 'idx_blend_kw', 'x-com NEAR/10 valid', 1 as query_mode )";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:1:{s:7:"snippet";s:68:"dummy1 dummy1 <b>valid</b> dummy1 dummy1 dummy1 <b>X-COM</b>, dummy1";}}}i:20;a:2:{s:8:"sphinxql";s:125:"REPLACE INTO rt (id, title, description) VALUES (1, 'This is a simple test', 'This is a longer description of a simple test')";s:14:"total_affected";i:1;}i:21;a:3:{s:8:"sphinxql";s:50:"SELECT id FROM rt WHERE MATCH('@description test')";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:1:{s:2:"id";s:1:"1";}}}i:22;a:3:{s:8:"sphinxql";s:54:"SELECT id FROM rt WHERE MATCH('@description[10] test')";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:1:{s:2:"id";s:1:"1";}}}}}