1
|
a:1:{i:0;a:10:{i:0;a:3:{s:8:"sphinxql";s:37:"select * from i1 where match ('some')";s:10:"total_rows";i:3;s:4:"rows";a:3:{i:0;a:6:{s:2:"id";s:1:"1";s:5:"attr1";s:2:"10";s:4:"mva1";s:7:"101,103";s:4:"mva2";s:11:"110,111,112";s:4:"str1";s:13:"some data 100";s:4:"str2";s:16:"another data 110";}i:1;a:6:{s:2:"id";s:1:"2";s:5:"attr1";s:2:"20";s:4:"mva1";s:11:"201,202,203";s:4:"mva2";s:10:"21,110,212";s:4:"str1";s:13:"some data 200";s:4:"str2";s:16:"another data 210";}i:2;a:6:{s:2:"id";s:1:"3";s:5:"attr1";s:2:"30";s:4:"mva1";s:10:"12,302,303";s:4:"mva2";s:11:"110,312,313";s:4:"str1";s:13:"some data 300";s:4:"str2";s:16:"another data 310";}}}i:1;a:3:{s:8:"sphinxql";s:66:"select attr1, groupby() from i1 where match ('some') group by mva1";s:10:"total_rows";i:8;s:4:"rows";a:8:{i:0;a:2:{s:5:"attr1";s:2:"10";s:9:"groupby()";s:3:"103";}i:1;a:2:{s:5:"attr1";s:2:"10";s:9:"groupby()";s:3:"101";}i:2;a:2:{s:5:"attr1";s:2:"20";s:9:"groupby()";s:3:"203";}i:3;a:2:{s:5:"attr1";s:2:"20";s:9:"groupby()";s:3:"202";}i:4;a:2:{s:5:"attr1";s:2:"20";s:9:"groupby()";s:3:"201";}i:5;a:2:{s:5:"attr1";s:2:"30";s:9:"groupby()";s:3:"303";}i:6;a:2:{s:5:"attr1";s:2:"30";s:9:"groupby()";s:3:"302";}i:7;a:2:{s:5:"attr1";s:2:"30";s:9:"groupby()";s:2:"12";}}}i:2;a:3:{s:8:"sphinxql";s:66:"select attr1, groupby() from i1 where match ('some') group by mva2";s:10:"total_rows";i:7;s:4:"rows";a:7:{i:0;a:2:{s:5:"attr1";s:2:"10";s:9:"groupby()";s:3:"112";}i:1;a:2:{s:5:"attr1";s:2:"10";s:9:"groupby()";s:3:"111";}i:2;a:2:{s:5:"attr1";s:2:"10";s:9:"groupby()";s:3:"110";}i:3;a:2:{s:5:"attr1";s:2:"20";s:9:"groupby()";s:3:"212";}i:4;a:2:{s:5:"attr1";s:2:"20";s:9:"groupby()";s:2:"21";}i:5;a:2:{s:5:"attr1";s:2:"30";s:9:"groupby()";s:3:"313";}i:6;a:2:{s:5:"attr1";s:2:"30";s:9:"groupby()";s:3:"312";}}}i:3;a:3:{s:8:"sphinxql";s:66:"select attr1, groupby() from ld where match ('some') group by mva1";s:10:"total_rows";i:8;s:4:"rows";a:8:{i:0;a:2:{s:5:"attr1";s:2:"10";s:9:"groupby()";s:3:"101";}i:1;a:2:{s:5:"attr1";s:2:"10";s:9:"groupby()";s:3:"103";}i:2;a:2:{s:5:"attr1";s:2:"20";s:9:"groupby()";s:3:"201";}i:3;a:2:{s:5:"attr1";s:2:"20";s:9:"groupby()";s:3:"202";}i:4;a:2:{s:5:"attr1";s:2:"20";s:9:"groupby()";s:3:"203";}i:5;a:2:{s:5:"attr1";s:2:"30";s:9:"groupby()";s:2:"12";}i:6;a:2:{s:5:"attr1";s:2:"30";s:9:"groupby()";s:3:"302";}i:7;a:2:{s:5:"attr1";s:2:"30";s:9:"groupby()";s:3:"303";}}}i:4;a:3:{s:8:"sphinxql";s:66:"select attr1, groupby() from ld where match ('some') group by mva2";s:10:"total_rows";i:7;s:4:"rows";a:7:{i:0;a:2:{s:5:"attr1";s:2:"10";s:9:"groupby()";s:3:"110";}i:1;a:2:{s:5:"attr1";s:2:"10";s:9:"groupby()";s:3:"111";}i:2;a:2:{s:5:"attr1";s:2:"10";s:9:"groupby()";s:3:"112";}i:3;a:2:{s:5:"attr1";s:2:"20";s:9:"groupby()";s:2:"21";}i:4;a:2:{s:5:"attr1";s:2:"20";s:9:"groupby()";s:3:"212";}i:5;a:2:{s:5:"attr1";s:2:"30";s:9:"groupby()";s:3:"312";}i:6;a:2:{s:5:"attr1";s:2:"30";s:9:"groupby()";s:3:"313";}}}i:5;a:3:{s:8:"sphinxql";s:66:"select attr1, groupby() from dd where match ('some') group by mva1";s:10:"total_rows";i:8;s:4:"rows";a:8:{i:0;a:2:{s:5:"attr1";s:2:"10";s:9:"groupby()";s:3:"101";}i:1;a:2:{s:5:"attr1";s:2:"10";s:9:"groupby()";s:3:"103";}i:2;a:2:{s:5:"attr1";s:2:"20";s:9:"groupby()";s:3:"201";}i:3;a:2:{s:5:"attr1";s:2:"20";s:9:"groupby()";s:3:"202";}i:4;a:2:{s:5:"attr1";s:2:"20";s:9:"groupby()";s:3:"203";}i:5;a:2:{s:5:"attr1";s:2:"30";s:9:"groupby()";s:2:"12";}i:6;a:2:{s:5:"attr1";s:2:"30";s:9:"groupby()";s:3:"302";}i:7;a:2:{s:5:"attr1";s:2:"30";s:9:"groupby()";s:3:"303";}}}i:6;a:3:{s:8:"sphinxql";s:66:"select attr1, groupby() from dd where match ('some') group by mva2";s:10:"total_rows";i:7;s:4:"rows";a:7:{i:0;a:2:{s:5:"attr1";s:2:"10";s:9:"groupby()";s:3:"110";}i:1;a:2:{s:5:"attr1";s:2:"10";s:9:"groupby()";s:3:"111";}i:2;a:2:{s:5:"attr1";s:2:"10";s:9:"groupby()";s:3:"112";}i:3;a:2:{s:5:"attr1";s:2:"20";s:9:"groupby()";s:2:"21";}i:4;a:2:{s:5:"attr1";s:2:"20";s:9:"groupby()";s:3:"212";}i:5;a:2:{s:5:"attr1";s:2:"30";s:9:"groupby()";s:3:"312";}i:6;a:2:{s:5:"attr1";s:2:"30";s:9:"groupby()";s:3:"313";}}}i:7;a:3:{s:8:"sphinxql";s:48:"select mva1, least(mva1), greatest(mva1) from i1";s:10:"total_rows";i:3;s:4:"rows";a:3:{i:0;a:3:{s:4:"mva1";s:7:"101,103";s:11:"least(mva1)";s:3:"101";s:14:"greatest(mva1)";s:3:"103";}i:1;a:3:{s:4:"mva1";s:11:"201,202,203";s:11:"least(mva1)";s:3:"201";s:14:"greatest(mva1)";s:3:"203";}i:2;a:3:{s:4:"mva1";s:10:"12,302,303";s:11:"least(mva1)";s:2:"12";s:14:"greatest(mva1)";s:3:"303";}}}i:8;a:3:{s:8:"sphinxql";s:56:"select groupby() from i1 group by str1 order by str1 asc";s:10:"total_rows";i:3;s:4:"rows";a:3:{i:0;a:1:{s:9:"groupby()";s:13:"some data 100";}i:1;a:1:{s:9:"groupby()";s:13:"some data 200";}i:2;a:1:{s:9:"groupby()";s:13:"some data 300";}}}i:9;a:3:{s:8:"sphinxql";s:57:"select groupby() from i1 group by str1 order by str1 desc";s:10:"total_rows";i:3;s:4:"rows";a:3:{i:0;a:1:{s:9:"groupby()";s:13:"some data 300";}i:1;a:1:{s:9:"groupby()";s:13:"some data 200";}i:2;a:1:{s:9:"groupby()";s:13:"some data 100";}}}}}
|