a:1:{i:0;a:11:{i:0;a:3:{s:8:"sphinxql";s:18:"select * from dist";s:10:"total_rows";i:9;s:4:"rows";a:9:{i:0;a:3:{s:2:"id";s:1:"1";s:3:"idd";s:1:"1";s:6:"aagent";s:1:"1";}i:1;a:3:{s:2:"id";s:1:"2";s:3:"idd";s:2:"10";s:6:"aagent";s:1:"1";}i:2;a:3:{s:2:"id";s:1:"3";s:3:"idd";s:1:"2";s:6:"aagent";s:1:"1";}i:3;a:3:{s:2:"id";s:1:"4";s:3:"idd";s:2:"11";s:6:"aagent";s:1:"1";}i:4;a:3:{s:2:"id";s:1:"5";s:3:"idd";s:1:"3";s:6:"aagent";s:1:"2";}i:5;a:3:{s:2:"id";s:1:"6";s:3:"idd";s:2:"12";s:6:"aagent";s:1:"2";}i:6;a:3:{s:2:"id";s:1:"7";s:3:"idd";s:1:"4";s:6:"aagent";s:1:"2";}i:7;a:3:{s:2:"id";s:1:"8";s:3:"idd";s:1:"5";s:6:"aagent";s:1:"2";}i:8;a:3:{s:2:"id";s:1:"9";s:3:"idd";s:2:"13";s:6:"aagent";s:1:"2";}}}i:1;a:3:{s:8:"sphinxql";s:41:"select idd, aagent from dist group by idd";s:10:"total_rows";i:9;s:4:"rows";a:9:{i:0;a:2:{s:3:"idd";s:1:"1";s:6:"aagent";s:1:"1";}i:1;a:2:{s:3:"idd";s:2:"10";s:6:"aagent";s:1:"1";}i:2;a:2:{s:3:"idd";s:1:"2";s:6:"aagent";s:1:"1";}i:3;a:2:{s:3:"idd";s:2:"11";s:6:"aagent";s:1:"1";}i:4;a:2:{s:3:"idd";s:1:"3";s:6:"aagent";s:1:"1";}i:5;a:2:{s:3:"idd";s:2:"12";s:6:"aagent";s:1:"2";}i:6;a:2:{s:3:"idd";s:1:"4";s:6:"aagent";s:1:"2";}i:7;a:2:{s:3:"idd";s:1:"5";s:6:"aagent";s:1:"2";}i:8;a:2:{s:3:"idd";s:2:"13";s:6:"aagent";s:1:"2";}}}i:2;a:3:{s:8:"sphinxql";s:44:"select *, idd, aagent from dist group by idd";s:10:"total_rows";i:9;s:4:"rows";a:9:{i:0;a:3:{s:2:"id";s:1:"1";s:3:"idd";s:1:"1";s:6:"aagent";s:1:"1";}i:1;a:3:{s:2:"id";s:1:"2";s:3:"idd";s:2:"10";s:6:"aagent";s:1:"1";}i:2;a:3:{s:2:"id";s:1:"3";s:3:"idd";s:1:"2";s:6:"aagent";s:1:"1";}i:3;a:3:{s:2:"id";s:1:"4";s:3:"idd";s:2:"11";s:6:"aagent";s:1:"1";}i:4;a:3:{s:2:"id";s:1:"5";s:3:"idd";s:1:"3";s:6:"aagent";s:1:"1";}i:5;a:3:{s:2:"id";s:1:"6";s:3:"idd";s:2:"12";s:6:"aagent";s:1:"2";}i:6;a:3:{s:2:"id";s:1:"7";s:3:"idd";s:1:"4";s:6:"aagent";s:1:"2";}i:7;a:3:{s:2:"id";s:1:"8";s:3:"idd";s:1:"5";s:6:"aagent";s:1:"2";}i:8;a:3:{s:2:"id";s:1:"9";s:3:"idd";s:2:"13";s:6:"aagent";s:1:"2";}}}i:3;a:3:{s:8:"sphinxql";s:49:"select idd, @count, aagent from dist group by idd";s:5:"error";s:70:"Using the old-fashion @variables (@count, @weight, etc.) is deprecated";s:5:"errno";i:1064;}i:4;a:3:{s:8:"sphinxql";s:51:"select idd, count(*), aagent from dist group by idd";s:10:"total_rows";i:9;s:4:"rows";a:9:{i:0;a:3:{s:3:"idd";s:1:"1";s:8:"count(*)";s:1:"1";s:6:"aagent";s:1:"1";}i:1;a:3:{s:3:"idd";s:2:"10";s:8:"count(*)";s:1:"1";s:6:"aagent";s:1:"1";}i:2;a:3:{s:3:"idd";s:1:"2";s:8:"count(*)";s:1:"1";s:6:"aagent";s:1:"1";}i:3;a:3:{s:3:"idd";s:2:"11";s:8:"count(*)";s:1:"1";s:6:"aagent";s:1:"1";}i:4;a:3:{s:3:"idd";s:1:"3";s:8:"count(*)";s:1:"2";s:6:"aagent";s:1:"1";}i:5;a:3:{s:3:"idd";s:2:"12";s:8:"count(*)";s:1:"1";s:6:"aagent";s:1:"2";}i:6;a:3:{s:3:"idd";s:1:"4";s:8:"count(*)";s:1:"1";s:6:"aagent";s:1:"2";}i:7;a:3:{s:3:"idd";s:1:"5";s:8:"count(*)";s:1:"1";s:6:"aagent";s:1:"2";}i:8;a:3:{s:3:"idd";s:2:"13";s:8:"count(*)";s:1:"1";s:6:"aagent";s:1:"2";}}}i:5;a:3:{s:8:"sphinxql";s:51:"select idd, count(*), aagent from dist group by idD";s:10:"total_rows";i:9;s:4:"rows";a:9:{i:0;a:3:{s:3:"idd";s:1:"1";s:8:"count(*)";s:1:"1";s:6:"aagent";s:1:"1";}i:1;a:3:{s:3:"idd";s:2:"10";s:8:"count(*)";s:1:"1";s:6:"aagent";s:1:"1";}i:2;a:3:{s:3:"idd";s:1:"2";s:8:"count(*)";s:1:"1";s:6:"aagent";s:1:"1";}i:3;a:3:{s:3:"idd";s:2:"11";s:8:"count(*)";s:1:"1";s:6:"aagent";s:1:"1";}i:4;a:3:{s:3:"idd";s:1:"3";s:8:"count(*)";s:1:"2";s:6:"aagent";s:1:"1";}i:5;a:3:{s:3:"idd";s:2:"12";s:8:"count(*)";s:1:"1";s:6:"aagent";s:1:"2";}i:6;a:3:{s:3:"idd";s:1:"4";s:8:"count(*)";s:1:"1";s:6:"aagent";s:1:"2";}i:7;a:3:{s:3:"idd";s:1:"5";s:8:"count(*)";s:1:"1";s:6:"aagent";s:1:"2";}i:8;a:3:{s:3:"idd";s:2:"13";s:8:"count(*)";s:1:"1";s:6:"aagent";s:1:"2";}}}i:6;a:3:{s:8:"sphinxql";s:33:"select idd, idd*2 as rr from dist";s:10:"total_rows";i:9;s:4:"rows";a:9:{i:0;a:2:{s:3:"idd";s:1:"1";s:2:"rr";s:1:"2";}i:1;a:2:{s:3:"idd";s:2:"10";s:2:"rr";s:2:"20";}i:2;a:2:{s:3:"idd";s:1:"2";s:2:"rr";s:1:"4";}i:3;a:2:{s:3:"idd";s:2:"11";s:2:"rr";s:2:"22";}i:4;a:2:{s:3:"idd";s:1:"3";s:2:"rr";s:1:"6";}i:5;a:2:{s:3:"idd";s:2:"12";s:2:"rr";s:2:"24";}i:6;a:2:{s:3:"idd";s:1:"4";s:2:"rr";s:1:"8";}i:7;a:2:{s:3:"idd";s:1:"5";s:2:"rr";s:2:"10";}i:8;a:2:{s:3:"idd";s:2:"13";s:2:"rr";s:2:"26";}}}i:7;a:3:{s:8:"sphinxql";s:38:"select idd as r0, r0*2 as rr from dist";s:10:"total_rows";i:9;s:4:"rows";a:9:{i:0;a:2:{s:2:"r0";s:1:"1";s:2:"rr";s:1:"2";}i:1;a:2:{s:2:"r0";s:2:"10";s:2:"rr";s:2:"20";}i:2;a:2:{s:2:"r0";s:1:"2";s:2:"rr";s:1:"4";}i:3;a:2:{s:2:"r0";s:2:"11";s:2:"rr";s:2:"22";}i:4;a:2:{s:2:"r0";s:1:"3";s:2:"rr";s:1:"6";}i:5;a:2:{s:2:"r0";s:2:"12";s:2:"rr";s:2:"24";}i:6;a:2:{s:2:"r0";s:1:"4";s:2:"rr";s:1:"8";}i:7;a:2:{s:2:"r0";s:1:"5";s:2:"rr";s:2:"10";}i:8;a:2:{s:2:"r0";s:2:"13";s:2:"rr";s:2:"26";}}}i:8;a:3:{s:8:"sphinxql";s:29:"select idd as agent from dist";s:10:"total_rows";i:9;s:4:"rows";a:9:{i:0;a:1:{s:5:"agent";s:1:"1";}i:1;a:1:{s:5:"agent";s:2:"10";}i:2;a:1:{s:5:"agent";s:1:"2";}i:3;a:1:{s:5:"agent";s:2:"11";}i:4;a:1:{s:5:"agent";s:1:"3";}i:5;a:1:{s:5:"agent";s:2:"12";}i:6;a:1:{s:5:"agent";s:1:"4";}i:7;a:1:{s:5:"agent";s:1:"5";}i:8;a:1:{s:5:"agent";s:2:"13";}}}i:9;a:3:{s:8:"sphinxql";s:44:"select agent as idd, idd * 3 as rr from dist";s:5:"error";s:208:"index dist: agent <AGENT1_ADDRESS/>: remote query error: index loc1: parse error: unknown column: agent;
index dist: agent <AGENT2_ADDRESS/>: remote query error: index loc2: parse error: unknown column: agent";s:5:"errno";i:1064;}i:10;a:3:{s:8:"sphinxql";s:62:"select idd as agent, agent + 2 as idd, idd - 3 as rr from dist";s:10:"total_rows";i:9;s:4:"rows";a:9:{i:0;a:3:{s:5:"agent";s:1:"3";s:3:"idd";s:1:"3";s:2:"rr";s:1:"0";}i:1;a:3:{s:5:"agent";s:2:"12";s:3:"idd";s:2:"12";s:2:"rr";s:1:"9";}i:2;a:3:{s:5:"agent";s:1:"4";s:3:"idd";s:1:"4";s:2:"rr";s:1:"1";}i:3;a:3:{s:5:"agent";s:2:"13";s:3:"idd";s:2:"13";s:2:"rr";s:2:"10";}i:4;a:3:{s:5:"agent";s:1:"5";s:3:"idd";s:1:"5";s:2:"rr";s:1:"2";}i:5;a:3:{s:5:"agent";s:2:"14";s:3:"idd";s:2:"14";s:2:"rr";s:2:"11";}i:6;a:3:{s:5:"agent";s:1:"6";s:3:"idd";s:1:"6";s:2:"rr";s:1:"3";}i:7;a:3:{s:5:"agent";s:1:"7";s:3:"idd";s:1:"7";s:2:"rr";s:1:"4";}i:8;a:3:{s:5:"agent";s:2:"15";s:3:"idd";s:2:"15";s:2:"rr";s:2:"12";}}}}}