1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
|
a:1:{i:0;a:273:{i:0;a:12:{s:5:"error";s:0:"";s:7:"warning";s:0:"";s:6:"status";i:0;s:6:"fields";a:1:{i:0;s:5:"title";}s:5:"attrs";a:5:{s:1:"j";i:7;s:3:"gid";i:1;s:6:"@count";i:6;s:8:"@groupby";i:6;s:11:"@groupbystr";i:7;}s:7:"matches";a:5:{i:1;a:2:{s:6:"weight";s:1:"1";s:5:"attrs";a:5:{s:1:"j";s:11:"{"uid":123}";s:3:"gid";i:1;s:6:"@count";i:2;s:8:"@groupby";s:19:"5003431119771845851";s:11:"@groupbystr";s:3:"123";}}i:2;a:2:{s:6:"weight";s:1:"1";s:5:"attrs";a:5:{s:1:"j";s:11:"{"uid":234}";s:3:"gid";i:2;s:6:"@count";i:1;s:8:"@groupby";s:19:"6936161455428368914";s:11:"@groupbystr";s:3:"234";}}i:4;a:2:{s:6:"weight";s:1:"1";s:5:"attrs";a:5:{s:1:"j";s:11:"{"uid":456}";s:3:"gid";i:1;s:6:"@count";i:1;s:8:"@groupby";s:19:"3162435238262057340";s:11:"@groupbystr";s:3:"456";}}i:5;a:2:{s:6:"weight";s:1:"1";s:5:"attrs";a:5:{s:1:"j";s:11:"{"uid":567}";s:3:"gid";i:2;s:6:"@count";i:2;s:8:"@groupby";s:19:"2510495211647253119";s:11:"@groupbystr";s:3:"567";}}i:100;a:2:{s:6:"weight";s:1:"1";s:5:"attrs";a:5:{s:1:"j";s:2:"{}";s:3:"gid";i:1;s:6:"@count";i:1;s:8:"@groupby";i:0;s:11:"@groupbystr";s:0:"";}}}s:5:"total";s:1:"5";s:11:"total_found";s:1:"5";s:4:"time";s:5:"0.001";s:8:"resarray";i:0;s:8:"roundoff";i:0;s:5:"query";s:0:"";}i:1;a:12:{s:5:"error";s:0:"";s:7:"warning";s:0:"";s:6:"status";i:0;s:6:"fields";a:1:{i:0;s:5:"title";}s:5:"attrs";a:5:{s:1:"j";i:7;s:3:"gid";i:1;s:6:"@count";i:6;s:8:"@groupby";i:6;s:11:"@groupbystr";i:7;}s:7:"matches";a:5:{i:1;a:2:{s:6:"weight";s:1:"1";s:5:"attrs";a:5:{s:1:"j";s:11:"{"uid":123}";s:3:"gid";i:1;s:6:"@count";i:2;s:8:"@groupby";s:19:"5003431119771845851";s:11:"@groupbystr";s:3:"123";}}i:2;a:2:{s:6:"weight";s:1:"1";s:5:"attrs";a:5:{s:1:"j";s:11:"{"uid":234}";s:3:"gid";i:2;s:6:"@count";i:1;s:8:"@groupby";s:19:"6936161455428368914";s:11:"@groupbystr";s:3:"234";}}i:4;a:2:{s:6:"weight";s:1:"1";s:5:"attrs";a:5:{s:1:"j";s:11:"{"uid":456}";s:3:"gid";i:1;s:6:"@count";i:1;s:8:"@groupby";s:19:"3162435238262057340";s:11:"@groupbystr";s:3:"456";}}i:5;a:2:{s:6:"weight";s:1:"1";s:5:"attrs";a:5:{s:1:"j";s:11:"{"uid":567}";s:3:"gid";i:2;s:6:"@count";i:2;s:8:"@groupby";s:19:"2510495211647253119";s:11:"@groupbystr";s:3:"567";}}i:100;a:2:{s:6:"weight";s:1:"1";s:5:"attrs";a:5:{s:1:"j";s:2:"{}";s:3:"gid";i:1;s:6:"@count";i:1;s:8:"@groupby";i:0;s:11:"@groupbystr";s:0:"";}}}s:5:"total";s:1:"5";s:11:"total_found";s:1:"5";s:4:"time";s:5:"0.001";s:8:"resarray";i:0;s:8:"roundoff";i:0;s:5:"query";s:0:"";}i:2;a:12:{s:5:"error";s:0:"";s:7:"warning";s:0:"";s:6:"status";i:0;s:6:"fields";a:1:{i:0;s:5:"title";}s:5:"attrs";a:5:{s:1:"j";i:7;s:3:"gid";i:1;s:6:"@count";i:6;s:8:"@groupby";i:6;s:11:"@groupbystr";i:7;}s:7:"matches";a:5:{i:1;a:2:{s:6:"weight";s:1:"1";s:5:"attrs";a:5:{s:1:"j";s:11:"{"uid":123}";s:3:"gid";i:1;s:6:"@count";i:2;s:8:"@groupby";s:19:"5003431119771845851";s:11:"@groupbystr";s:3:"123";}}i:2;a:2:{s:6:"weight";s:1:"1";s:5:"attrs";a:5:{s:1:"j";s:11:"{"uid":234}";s:3:"gid";i:2;s:6:"@count";i:1;s:8:"@groupby";s:19:"6936161455428368914";s:11:"@groupbystr";s:3:"234";}}i:4;a:2:{s:6:"weight";s:1:"1";s:5:"attrs";a:5:{s:1:"j";s:11:"{"uid":456}";s:3:"gid";i:1;s:6:"@count";i:1;s:8:"@groupby";s:19:"3162435238262057340";s:11:"@groupbystr";s:3:"456";}}i:5;a:2:{s:6:"weight";s:1:"1";s:5:"attrs";a:5:{s:1:"j";s:11:"{"uid":567}";s:3:"gid";i:2;s:6:"@count";i:2;s:8:"@groupby";s:19:"2510495211647253119";s:11:"@groupbystr";s:3:"567";}}i:100;a:2:{s:6:"weight";s:1:"1";s:5:"attrs";a:5:{s:1:"j";s:2:"{}";s:3:"gid";i:1;s:6:"@count";i:1;s:8:"@groupby";i:0;s:11:"@groupbystr";s:0:"";}}}s:5:"total";s:1:"5";s:11:"total_found";s:1:"5";s:4:"time";s:5:"0.001";s:8:"resarray";i:0;s:8:"roundoff";i:0;s:5:"query";s:0:"";}i:3;a:12:{s:5:"error";s:0:"";s:7:"warning";s:0:"";s:6:"status";i:0;s:6:"fields";a:1:{i:0;s:5:"title";}s:5:"attrs";a:5:{s:1:"j";i:7;s:3:"gid";i:1;s:6:"@count";i:6;s:8:"@groupby";i:6;s:11:"@groupbystr";i:7;}s:7:"matches";a:7:{i:1;a:2:{s:6:"weight";s:1:"1";s:5:"attrs";a:5:{s:1:"j";s:11:"{"uid":123}";s:3:"gid";i:1;s:6:"@count";i:2;s:8:"@groupby";s:19:"5003431119771845851";s:11:"@groupbystr";s:3:"123";}}i:2;a:2:{s:6:"weight";s:1:"1";s:5:"attrs";a:5:{s:1:"j";s:11:"{"uid":234}";s:3:"gid";i:2;s:6:"@count";i:1;s:8:"@groupby";s:19:"6936161455428368914";s:11:"@groupbystr";s:3:"234";}}i:3;a:2:{s:6:"weight";s:1:"1";s:5:"attrs";a:5:{s:1:"j";s:11:"{"uid":345}";s:3:"gid";i:3;s:6:"@count";i:2;s:8:"@groupby";s:19:"6284221428813564693";s:11:"@groupbystr";s:3:"345";}}i:4;a:2:{s:6:"weight";s:1:"1";s:5:"attrs";a:5:{s:1:"j";s:11:"{"uid":456}";s:3:"gid";i:1;s:6:"@count";i:1;s:8:"@groupby";s:19:"3162435238262057340";s:11:"@groupbystr";s:3:"456";}}i:5;a:2:{s:6:"weight";s:1:"1";s:5:"attrs";a:5:{s:1:"j";s:11:"{"uid":567}";s:3:"gid";i:2;s:6:"@count";i:2;s:8:"@groupby";s:19:"2510495211647253119";s:11:"@groupbystr";s:3:"567";}}i:6;a:2:{s:6:"weight";s:1:"1";s:5:"attrs";a:5:{s:1:"j";s:11:"{"uid":678}";s:3:"gid";i:3;s:6:"@count";i:1;s:8:"@groupby";s:19:"4473923911957372102";s:11:"@groupbystr";s:3:"678";}}i:100;a:2:{s:6:"weight";s:1:"1";s:5:"attrs";a:5:{s:1:"j";s:2:"{}";s:3:"gid";i:1;s:6:"@count";i:1;s:8:"@groupby";i:0;s:11:"@groupbystr";s:0:"";}}}s:5:"total";s:1:"7";s:11:"total_found";s:1:"7";s:4:"time";s:5:"0.001";s:8:"resarray";i:0;s:8:"roundoff";i:0;s:5:"query";s:0:"";}i:4;a:12:{s:5:"error";s:0:"";s:7:"warning";s:0:"";s:6:"status";i:0;s:6:"fields";a:1:{i:0;s:5:"title";}s:5:"attrs";a:3:{s:13:"bigint ( id )";i:6;s:5:"j.uid";i:7;s:6:"j.name";i:7;}s:7:"matches";a:4:{i:3;a:2:{s:6:"weight";s:1:"1";s:5:"attrs";a:3:{s:13:"bigint ( id )";i:3;s:5:"j.uid";s:3:"345";s:6:"j.name";s:7:"Charlie";}}i:4;a:2:{s:6:"weight";s:1:"1";s:5:"attrs";a:3:{s:13:"bigint ( id )";i:4;s:5:"j.uid";s:3:"456";s:6:"j.name";s:5:"Damon";}}i:5;a:2:{s:6:"weight";s:1:"1";s:5:"attrs";a:3:{s:13:"bigint ( id )";i:5;s:5:"j.uid";s:3:"567";s:6:"j.name";s:0:"";}}i:8;a:2:{s:6:"weight";s:1:"1";s:5:"attrs";a:3:{s:13:"bigint ( id )";i:8;s:5:"j.uid";s:3:"567";s:6:"j.name";s:0:"";}}}s:5:"total";s:1:"4";s:11:"total_found";s:1:"4";s:4:"time";s:5:"0.000";s:8:"resarray";i:0;s:8:"roundoff";i:0;s:5:"query";s:0:"";}i:5;a:12:{s:5:"error";s:0:"";s:7:"warning";s:0:"";s:6:"status";i:0;s:6:"fields";a:1:{i:0;s:5:"title";}s:5:"attrs";a:3:{s:13:"bigint ( id )";i:6;s:5:"j.uid";i:7;s:6:"j.name";i:7;}s:7:"matches";a:18:{i:12;a:2:{s:6:"weight";s:1:"1";s:5:"attrs";a:3:{s:13:"bigint ( id )";i:12;s:5:"j.uid";s:0:"";s:6:"j.name";s:0:"";}}i:8;a:2:{s:6:"weight";s:1:"1";s:5:"attrs";a:3:{s:13:"bigint ( id )";i:8;s:5:"j.uid";s:0:"";s:6:"j.name";s:0:"";}}i:5;a:2:{s:6:"weight";s:1:"1";s:5:"attrs";a:3:{s:13:"bigint ( id )";i:5;s:5:"j.uid";s:0:"";s:6:"j.name";s:0:"";}}i:6;a:2:{s:6:"weight";s:1:"1";s:5:"attrs";a:3:{s:13:"bigint ( id )";i:6;s:5:"j.uid";s:0:"";s:6:"j.name";s:0:"";}}i:7;a:2:{s:6:"weight";s:1:"1";s:5:"attrs";a:3:{s:13:"bigint ( id )";i:7;s:5:"j.uid";s:0:"";s:6:"j.name";s:0:"";}}i:9;a:2:{s:6:"weight";s:1:"1";s:5:"attrs";a:3:{s:13:"bigint ( id )";i:9;s:5:"j.uid";s:0:"";s:6:"j.name";s:0:"";}}i:10;a:2:{s:6:"weight";s:1:"1";s:5:"attrs";a:3:{s:13:"bigint ( id )";i:10;s:5:"j.uid";s:0:"";s:6:"j.name";s:0:"";}}i:11;a:2:{s:6:"weight";s:1:"1";s:5:"attrs";a:3:{s:13:"bigint ( id )";i:11;s:5:"j.uid";s:0:"";s:6:"j.name";s:0:"";}}i:13;a:2:{s:6:"weight";s:1:"1";s:5:"attrs";a:3:{s:13:"bigint ( id )";i:13;s:5:"j.uid";s:0:"";s:6:"j.name";s:0:"";}}i:14;a:2:{s:6:"weight";s:1:"1";s:5:"attrs";a:3:{s:13:"bigint ( id )";i:14;s:5:"j.uid";s:0:"";s:6:"j.name";s:0:"";}}i:15;a:2:{s:6:"weight";s:1:"1";s:5:"attrs";a:3:{s:13:"bigint ( id )";i:15;s:5:"j.uid";s:0:"";s:6:"j.name";s:0:"";}}i:16;a:2:{s:6:"weight";s:1:"1";s:5:"attrs";a:3:{s:13:"bigint ( id )";i:16;s:5:"j.uid";s:0:"";s:6:"j.name";s:0:"";}}i:17;a:2:{s:6:"weight";s:1:"1";s:5:"attrs";a:3:{s:13:"bigint ( id )";i:17;s:5:"j.uid";s:0:"";s:6:"j.name";s:0:"";}}i:18;a:2:{s:6:"weight";s:1:"1";s:5:"attrs";a:3:{s:13:"bigint ( id )";i:18;s:5:"j.uid";s:0:"";s:6:"j.name";s:0:"";}}i:1;a:2:{s:6:"weight";s:1:"1";s:5:"attrs";a:3:{s:13:"bigint ( id )";i:1;s:5:"j.uid";s:3:"123";s:6:"j.name";s:5:"Alice";}}i:2;a:2:{s:6:"weight";s:1:"1";s:5:"attrs";a:3:{s:13:"bigint ( id )";i:2;s:5:"j.uid";s:3:"234";s:6:"j.name";s:3:"Bob";}}i:3;a:2:{s:6:"weight";s:1:"1";s:5:"attrs";a:3:{s:13:"bigint ( id )";i:3;s:5:"j.uid";s:3:"345";s:6:"j.name";s:7:"Charlie";}}i:4;a:2:{s:6:"weight";s:1:"1";s:5:"attrs";a:3:{s:13:"bigint ( id )";i:4;s:5:"j.uid";s:3:"456";s:6:"j.name";s:5:"Damon";}}}s:5:"total";s:2:"18";s:11:"total_found";s:2:"18";s:4:"time";s:5:"0.000";s:8:"resarray";i:0;s:8:"roundoff";i:0;s:5:"query";s:0:"";}i:6;a:12:{s:5:"error";s:0:"";s:7:"warning";s:0:"";s:6:"status";i:0;s:6:"fields";a:1:{i:0;s:5:"title";}s:5:"attrs";a:3:{s:13:"bigint ( id )";i:6;s:6:"j.name";i:7;s:5:"j.uid";i:7;}s:7:"matches";a:18:{i:4;a:2:{s:6:"weight";s:1:"1";s:5:"attrs";a:3:{s:13:"bigint ( id )";i:4;s:6:"j.name";s:5:"Damon";s:5:"j.uid";s:3:"456";}}i:3;a:2:{s:6:"weight";s:1:"1";s:5:"attrs";a:3:{s:13:"bigint ( id )";i:3;s:6:"j.name";s:7:"Charlie";s:5:"j.uid";s:3:"345";}}i:2;a:2:{s:6:"weight";s:1:"1";s:5:"attrs";a:3:{s:13:"bigint ( id )";i:2;s:6:"j.name";s:3:"Bob";s:5:"j.uid";s:3:"234";}}i:1;a:2:{s:6:"weight";s:1:"1";s:5:"attrs";a:3:{s:13:"bigint ( id )";i:1;s:6:"j.name";s:5:"Alice";s:5:"j.uid";s:3:"123";}}i:5;a:2:{s:6:"weight";s:1:"1";s:5:"attrs";a:3:{s:13:"bigint ( id )";i:5;s:6:"j.name";s:0:"";s:5:"j.uid";s:0:"";}}i:6;a:2:{s:6:"weight";s:1:"1";s:5:"attrs";a:3:{s:13:"bigint ( id )";i:6;s:6:"j.name";s:0:"";s:5:"j.uid";s:0:"";}}i:7;a:2:{s:6:"weight";s:1:"1";s:5:"attrs";a:3:{s:13:"bigint ( id )";i:7;s:6:"j.name";s:0:"";s:5:"j.uid";s:0:"";}}i:9;a:2:{s:6:"weight";s:1:"1";s:5:"attrs";a:3:{s:13:"bigint ( id )";i:9;s:6:"j.name";s:0:"";s:5:"j.uid";s:0:"";}}i:10;a:2:{s:6:"weight";s:1:"1";s:5:"attrs";a:3:{s:13:"bigint ( id )";i:10;s:6:"j.name";s:0:"";s:5:"j.uid";s:0:"";}}i:11;a:2:{s:6:"weight";s:1:"1";s:5:"attrs";a:3:{s:13:"bigint ( id )";i:11;s:6:"j.name";s:0:"";s:5:"j.uid";s:0:"";}}i:13;a:2:{s:6:"weight";s:1:"1";s:5:"attrs";a:3:{s:13:"bigint ( id )";i:13;s:6:"j.name";s:0:"";s:5:"j.uid";s:0:"";}}i:14;a:2:{s:6:"weight";s:1:"1";s:5:"attrs";a:3:{s:13:"bigint ( id )";i:14;s:6:"j.name";s:0:"";s:5:"j.uid";s:0:"";}}i:15;a:2:{s:6:"weight";s:1:"1";s:5:"attrs";a:3:{s:13:"bigint ( id )";i:15;s:6:"j.name";s:0:"";s:5:"j.uid";s:0:"";}}i:16;a:2:{s:6:"weight";s:1:"1";s:5:"attrs";a:3:{s:13:"bigint ( id )";i:16;s:6:"j.name";s:0:"";s:5:"j.uid";s:0:"";}}i:17;a:2:{s:6:"weight";s:1:"1";s:5:"attrs";a:3:{s:13:"bigint ( id )";i:17;s:6:"j.name";s:0:"";s:5:"j.uid";s:0:"";}}i:18;a:2:{s:6:"weight";s:1:"1";s:5:"attrs";a:3:{s:13:"bigint ( id )";i:18;s:6:"j.name";s:0:"";s:5:"j.uid";s:0:"";}}i:8;a:2:{s:6:"weight";s:1:"1";s:5:"attrs";a:3:{s:13:"bigint ( id )";i:8;s:6:"j.name";s:0:"";s:5:"j.uid";s:0:"";}}i:12;a:2:{s:6:"weight";s:1:"1";s:5:"attrs";a:3:{s:13:"bigint ( id )";i:12;s:6:"j.name";s:0:"";s:5:"j.uid";s:0:"";}}}s:5:"total";s:2:"18";s:11:"total_found";s:2:"18";s:4:"time";s:5:"0.000";s:8:"resarray";i:0;s:8:"roundoff";i:0;s:5:"query";s:0:"";}i:7;a:12:{s:5:"error";s:0:"";s:7:"warning";s:0:"";s:6:"status";i:0;s:6:"fields";a:1:{i:0;s:5:"title";}s:5:"attrs";a:9:{s:13:"bigint ( id )";i:6;s:6:"j.name";i:7;s:4:"j.34";i:7;s:5:"j.179";i:7;s:5:"j.uid";i:7;s:4:"j.sv";i:7;s:4:"j.t6";i:7;s:5:"j. f2";i:7;s:4:"j.f1";i:7;}s:7:"matches";a:18:{i:1;a:2:{s:6:"weight";s:1:"1";s:5:"attrs";a:9:{s:13:"bigint ( id )";i:1;s:6:"j.name";s:5:"Alice";s:4:"j.34";s:0:"";s:5:"j.179";s:0:"";s:5:"j.uid";s:3:"123";s:4:"j.sv";s:0:"";s:4:"j.t6";s:0:"";s:5:"j. f2";s:0:"";s:4:"j.f1";s:0:"";}}i:2;a:2:{s:6:"weight";s:1:"1";s:5:"attrs";a:9:{s:13:"bigint ( id )";i:2;s:6:"j.name";s:3:"Bob";s:4:"j.34";s:0:"";s:5:"j.179";s:0:"";s:5:"j.uid";s:3:"234";s:4:"j.sv";s:0:"";s:4:"j.t6";s:0:"";s:5:"j. f2";s:0:"";s:4:"j.f1";s:0:"";}}i:3;a:2:{s:6:"weight";s:1:"1";s:5:"attrs";a:9:{s:13:"bigint ( id )";i:3;s:6:"j.name";s:7:"Charlie";s:4:"j.34";s:0:"";s:5:"j.179";s:0:"";s:5:"j.uid";s:3:"345";s:4:"j.sv";s:0:"";s:4:"j.t6";s:0:"";s:5:"j. f2";s:0:"";s:4:"j.f1";s:0:"";}}i:4;a:2:{s:6:"weight";s:1:"1";s:5:"attrs";a:9:{s:13:"bigint ( id )";i:4;s:6:"j.name";s:5:"Damon";s:4:"j.34";s:0:"";s:5:"j.179";s:0:"";s:5:"j.uid";s:3:"456";s:4:"j.sv";s:0:"";s:4:"j.t6";s:0:"";s:5:"j. f2";s:0:"";s:4:"j.f1";s:0:"";}}i:5;a:2:{s:6:"weight";s:1:"1";s:5:"attrs";a:9:{s:13:"bigint ( id )";i:5;s:6:"j.name";s:0:"";s:4:"j.34";s:3:"567";s:5:"j.179";s:0:"";s:5:"j.uid";s:0:"";s:4:"j.sv";s:0:"";s:4:"j.t6";s:0:"";s:5:"j. f2";s:0:"";s:4:"j.f1";s:0:"";}}i:6;a:2:{s:6:"weight";s:1:"1";s:5:"attrs";a:9:{s:13:"bigint ( id )";i:6;s:6:"j.name";s:0:"";s:4:"j.34";s:0:"";s:5:"j.179";s:3:"971";s:5:"j.uid";s:0:"";s:4:"j.sv";s:0:"";s:4:"j.t6";s:0:"";s:5:"j. f2";s:0:"";s:4:"j.f1";s:0:"";}}i:7;a:2:{s:6:"weight";s:1:"1";s:5:"attrs";a:9:{s:13:"bigint ( id )";i:7;s:6:"j.name";s:0:"";s:4:"j.34";s:0:"";s:5:"j.179";s:0:"";s:5:"j.uid";s:0:"";s:4:"j.sv";s:0:"";s:4:"j.t6";s:0:"";s:5:"j. f2";s:0:"";s:4:"j.f1";s:0:"";}}i:8;a:2:{s:6:"weight";s:1:"1";s:5:"attrs";a:9:{s:13:"bigint ( id )";i:8;s:6:"j.name";s:0:"";s:4:"j.34";s:0:"";s:5:"j.179";s:0:"";s:5:"j.uid";s:0:"";s:4:"j.sv";s:21:"["one","two","three"]";s:4:"j.t6";s:0:"";s:5:"j. f2";s:0:"";s:4:"j.f1";s:0:"";}}i:9;a:2:{s:6:"weight";s:1:"1";s:5:"attrs";a:9:{s:13:"bigint ( id )";i:9;s:6:"j.name";s:0:"";s:4:"j.34";s:0:"";s:5:"j.179";s:0:"";s:5:"j.uid";s:0:"";s:4:"j.sv";s:0:"";s:4:"j.t6";s:0:"";s:5:"j. f2";s:0:"";s:4:"j.f1";s:0:"";}}i:10;a:2:{s:6:"weight";s:1:"1";s:5:"attrs";a:9:{s:13:"bigint ( id )";i:10;s:6:"j.name";s:0:"";s:4:"j.34";s:0:"";s:5:"j.179";s:0:"";s:5:"j.uid";s:0:"";s:4:"j.sv";s:0:"";s:4:"j.t6";s:0:"";s:5:"j. f2";s:0:"";s:4:"j.f1";s:0:"";}}i:11;a:2:{s:6:"weight";s:1:"1";s:5:"attrs";a:9:{s:13:"bigint ( id )";i:11;s:6:"j.name";s:0:"";s:4:"j.34";s:0:"";s:5:"j.179";s:0:"";s:5:"j.uid";s:0:"";s:4:"j.sv";s:0:"";s:4:"j.t6";s:11:"-9876543210";s:5:"j. f2";s:0:"";s:4:"j.f1";s:0:"";}}i:12;a:2:{s:6:"weight";s:1:"1";s:5:"attrs";a:9:{s:13:"bigint ( id )";i:12;s:6:"j.name";s:0:"";s:4:"j.34";s:0:"";s:5:"j.179";s:0:"";s:5:"j.uid";s:0:"";s:4:"j.sv";s:358:"["\nMary had a little lamb, whose fleece was white as snow.\nAnd everywhere that Mary went, the lamb was sure to go.\nIt followed her to school one day which was against the rules.\nIt made the children laugh and play, to see a lamb at school.\nAnd so the teacher turned it out, but still it lingered near.","another world, another time, the age of wonders"]";s:4:"j.t6";s:0:"";s:5:"j. f2";s:0:"";s:4:"j.f1";s:0:"";}}i:13;a:2:{s:6:"weight";s:1:"1";s:5:"attrs";a:9:{s:13:"bigint ( id )";i:13;s:6:"j.name";s:0:"";s:4:"j.34";s:0:"";s:5:"j.179";s:0:"";s:5:"j.uid";s:0:"";s:4:"j.sv";s:0:"";s:4:"j.t6";s:0:"";s:5:"j. f2";s:15:"16777217.123000";s:4:"j.f1";s:8:"3.150000";}}i:14;a:2:{s:6:"weight";s:1:"1";s:5:"attrs";a:9:{s:13:"bigint ( id )";i:14;s:6:"j.name";s:0:"";s:4:"j.34";s:0:"";s:5:"j.179";s:0:"";s:5:"j.uid";s:0:"";s:4:"j.sv";s:0:"";s:4:"j.t6";s:0:"";s:5:"j. f2";s:9:"-7.400000";s:4:"j.f1";s:8:"3.150000";}}i:15;a:2:{s:6:"weight";s:1:"1";s:5:"attrs";a:9:{s:13:"bigint ( id )";i:15;s:6:"j.name";s:0:"";s:4:"j.34";s:0:"";s:5:"j.179";s:0:"";s:5:"j.uid";s:0:"";s:4:"j.sv";s:0:"";s:4:"j.t6";s:0:"";s:5:"j. f2";s:0:"";s:4:"j.f1";s:0:"";}}i:16;a:2:{s:6:"weight";s:1:"1";s:5:"attrs";a:9:{s:13:"bigint ( id )";i:16;s:6:"j.name";s:0:"";s:4:"j.34";s:0:"";s:5:"j.179";s:0:"";s:5:"j.uid";s:0:"";s:4:"j.sv";s:0:"";s:4:"j.t6";s:0:"";s:5:"j. f2";s:0:"";s:4:"j.f1";s:0:"";}}i:17;a:2:{s:6:"weight";s:1:"1";s:5:"attrs";a:9:{s:13:"bigint ( id )";i:17;s:6:"j.name";s:0:"";s:4:"j.34";s:0:"";s:5:"j.179";s:0:"";s:5:"j.uid";s:0:"";s:4:"j.sv";s:0:"";s:4:"j.t6";s:0:"";s:5:"j. f2";s:0:"";s:4:"j.f1";s:0:"";}}i:18;a:2:{s:6:"weight";s:1:"1";s:5:"attrs";a:9:{s:13:"bigint ( id )";i:18;s:6:"j.name";s:0:"";s:4:"j.34";s:0:"";s:5:"j.179";s:0:"";s:5:"j.uid";s:0:"";s:4:"j.sv";s:0:"";s:4:"j.t6";s:0:"";s:5:"j. f2";s:0:"";s:4:"j.f1";s:0:"";}}}s:5:"total";s:2:"18";s:11:"total_found";s:2:"18";s:4:"time";s:5:"0.000";s:8:"resarray";i:0;s:8:"roundoff";i:0;s:5:"query";s:0:"";}i:8;a:12:{s:5:"error";s:0:"";s:7:"warning";s:0:"";s:6:"status";i:0;s:6:"fields";a:1:{i:0;s:3:"gid";}s:5:"attrs";a:1:{s:5:"json1";i:7;}s:7:"matches";a:1:{i:123;a:2:{s:6:"weight";s:1:"1";s:5:"attrs";a:1:{s:5:"json1";s:52:"{"username":"Alice","year":2000,"floatkey":1.010000}";}}}s:5:"total";s:1:"1";s:11:"total_found";s:1:"1";s:4:"time";s:5:"0.000";s:8:"resarray";i:0;s:8:"roundoff";i:0;s:5:"query";s:0:"";}i:9;a:12:{s:5:"error";s:0:"";s:7:"warning";s:0:"";s:6:"status";i:0;s:6:"fields";a:1:{i:0;s:3:"gid";}s:5:"attrs";a:1:{s:5:"json1";i:7;}s:7:"matches";a:1:{i:456;a:2:{s:6:"weight";s:1:"1";s:5:"attrs";a:1:{s:5:"json1";s:52:"{"username":"Damon","year":2003,"floatkey":4.440000}";}}}s:5:"total";s:1:"1";s:11:"total_found";s:1:"1";s:4:"time";s:5:"0.000";s:8:"resarray";i:0;s:8:"roundoff";i:0;s:5:"query";s:0:"";}i:10;a:12:{s:5:"error";s:0:"";s:7:"warning";s:0:"";s:6:"status";i:0;s:6:"fields";a:1:{i:0;s:3:"gid";}s:5:"attrs";a:2:{s:1:"j";i:7;s:16:"j.key1.key2.key3";i:7;}s:7:"matches";a:1:{i:10;a:2:{s:6:"weight";s:1:"1";s:5:"attrs";a:2:{s:1:"j";s:34:"{"key1":{"key2":{"key3":"value"}}}";s:16:"j.key1.key2.key3";s:5:"value";}}}s:5:"total";s:1:"1";s:11:"total_found";s:1:"1";s:4:"time";s:5:"0.000";s:8:"resarray";i:0;s:8:"roundoff";i:0;s:5:"query";s:0:"";}i:11;a:3:{s:8:"sphinxql";s:58:"select *, count(*) from loc group by j.uid order by id asc";s:10:"total_rows";i:5;s:4:"rows";a:5:{i:0;a:4:{s:2:"id";s:1:"1";s:1:"j";s:11:"{"uid":123}";s:3:"gid";s:1:"1";s:8:"count(*)";s:1:"2";}i:1;a:4:{s:2:"id";s:1:"2";s:1:"j";s:11:"{"uid":234}";s:3:"gid";s:1:"2";s:8:"count(*)";s:1:"1";}i:2;a:4:{s:2:"id";s:1:"4";s:1:"j";s:11:"{"uid":456}";s:3:"gid";s:1:"1";s:8:"count(*)";s:1:"1";}i:3;a:4:{s:2:"id";s:1:"5";s:1:"j";s:11:"{"uid":567}";s:3:"gid";s:1:"2";s:8:"count(*)";s:1:"2";}i:4;a:4:{s:2:"id";s:3:"100";s:1:"j";N;s:3:"gid";s:1:"1";s:8:"count(*)";s:1:"1";}}}i:12;a:3:{s:8:"sphinxql";s:59:"select *, count(*) from loc1 group by j.uid order by id asc";s:10:"total_rows";i:5;s:4:"rows";a:5:{i:0;a:4:{s:2:"id";s:1:"1";s:1:"j";s:11:"{"uid":123}";s:3:"gid";s:1:"1";s:8:"count(*)";s:1:"2";}i:1;a:4:{s:2:"id";s:1:"2";s:1:"j";s:11:"{"uid":234}";s:3:"gid";s:1:"2";s:8:"count(*)";s:1:"1";}i:2;a:4:{s:2:"id";s:1:"4";s:1:"j";s:11:"{"uid":456}";s:3:"gid";s:1:"1";s:8:"count(*)";s:1:"1";}i:3;a:4:{s:2:"id";s:1:"5";s:1:"j";s:11:"{"uid":567}";s:3:"gid";s:1:"2";s:8:"count(*)";s:1:"2";}i:4;a:4:{s:2:"id";s:3:"100";s:1:"j";N;s:3:"gid";s:1:"1";s:8:"count(*)";s:1:"1";}}}i:13;a:3:{s:8:"sphinxql";s:59:"select *, count(*) from dist group by j.uid order by id asc";s:10:"total_rows";i:5;s:4:"rows";a:5:{i:0;a:4:{s:2:"id";s:1:"1";s:1:"j";s:11:"{"uid":123}";s:3:"gid";s:1:"1";s:8:"count(*)";s:1:"2";}i:1;a:4:{s:2:"id";s:1:"2";s:1:"j";s:11:"{"uid":234}";s:3:"gid";s:1:"2";s:8:"count(*)";s:1:"1";}i:2;a:4:{s:2:"id";s:1:"4";s:1:"j";s:11:"{"uid":456}";s:3:"gid";s:1:"1";s:8:"count(*)";s:1:"1";}i:3;a:4:{s:2:"id";s:1:"5";s:1:"j";s:11:"{"uid":567}";s:3:"gid";s:1:"2";s:8:"count(*)";s:1:"2";}i:4;a:4:{s:2:"id";s:3:"100";s:1:"j";N;s:3:"gid";s:1:"1";s:8:"count(*)";s:1:"1";}}}i:14;a:3:{s:8:"sphinxql";s:60:"select *, count(*) from dist1 group by j.uid order by id asc";s:10:"total_rows";i:7;s:4:"rows";a:7:{i:0;a:4:{s:2:"id";s:1:"1";s:1:"j";s:11:"{"uid":123}";s:3:"gid";s:1:"1";s:8:"count(*)";s:1:"2";}i:1;a:4:{s:2:"id";s:1:"2";s:1:"j";s:11:"{"uid":234}";s:3:"gid";s:1:"2";s:8:"count(*)";s:1:"1";}i:2;a:4:{s:2:"id";s:1:"3";s:1:"j";s:11:"{"uid":345}";s:3:"gid";s:1:"3";s:8:"count(*)";s:1:"2";}i:3;a:4:{s:2:"id";s:1:"4";s:1:"j";s:11:"{"uid":456}";s:3:"gid";s:1:"1";s:8:"count(*)";s:1:"1";}i:4;a:4:{s:2:"id";s:1:"5";s:1:"j";s:11:"{"uid":567}";s:3:"gid";s:1:"2";s:8:"count(*)";s:1:"2";}i:5;a:4:{s:2:"id";s:1:"6";s:1:"j";s:11:"{"uid":678}";s:3:"gid";s:1:"3";s:8:"count(*)";s:1:"1";}i:6;a:4:{s:2:"id";s:3:"100";s:1:"j";N;s:3:"gid";s:1:"1";s:8:"count(*)";s:1:"1";}}}i:15;a:3:{s:8:"sphinxql";s:40:"select * from count() loc group by j.uid";s:5:"error";s:83:"sphinxql: syntax error, unexpected '(', expecting $end near '() loc group by j.uid'";s:5:"errno";i:1064;}i:16;a:3:{s:8:"sphinxql";s:18:"select * from test";s:10:"total_rows";i:18;s:4:"rows";a:18:{i:0;a:3:{s:2:"id";s:1:"1";s:3:"gid";s:1:"1";s:1:"j";s:26:"{"name":"Alice","uid":123}";}i:1;a:3:{s:2:"id";s:1:"2";s:3:"gid";s:1:"1";s:1:"j";s:33:"{"name":"Bob","uid":234,"gid":12}";}i:2;a:3:{s:2:"id";s:1:"3";s:3:"gid";s:1:"2";s:1:"j";s:28:"{"name":"Charlie","uid":345}";}i:3;a:3:{s:2:"id";s:1:"4";s:3:"gid";s:1:"2";s:1:"j";s:35:"{"name":"Damon","uid":456,"gid":23}";}i:4;a:3:{s:2:"id";s:1:"5";s:3:"gid";s:1:"3";s:1:"j";s:19:"{"12":345,"34":567}";}i:5;a:3:{s:2:"id";s:1:"6";s:3:"gid";s:1:"3";s:1:"j";s:20:"{"12":346,"179":971}";}i:6;a:3:{s:2:"id";s:1:"7";s:3:"gid";s:1:"3";s:1:"j";s:375:"{"long":"\nYou can run on for a long time\nRun on for a long time\nRun on for a long time\nSooner or later God'll cut you down\nSooner or later God'll cut you down\n\nGo tell that long tongue liar\nGo and tell that midnight rider\nTell the rambler, the gambler, the back biter\nTell 'em that God's gonna cut 'em down\nTell 'em that God's gonna cut 'em down\n","short":"ohai"}";}i:7;a:3:{s:2:"id";s:1:"8";s:3:"gid";s:1:"3";s:1:"j";s:38:"{"sv":["one","two","three"],"gid":315}";}i:8;a:3:{s:2:"id";s:1:"9";s:3:"gid";s:1:"3";s:1:"j";s:2:"{}";}i:9;a:3:{s:2:"id";s:2:"10";s:3:"gid";s:1:"3";s:1:"j";N;}i:10;a:3:{s:2:"id";s:2:"11";s:3:"gid";s:1:"3";s:1:"j";s:98:"{"t1":123456789,"t2":-123456789,"t3":3123456789,"t4":-3123456789,"t5":9876543210,"t6":-9876543210}";}i:11;a:3:{s:2:"id";s:2:"12";s:3:"gid";s:1:"3";s:1:"j";s:375:"{"sv":["\nMary had a little lamb, whose fleece was white as snow.\nAnd everywhere that Mary went, the lamb was sure to go.\nIt followed her to school one day which was against the rules.\nIt made the children laugh and play, to see a lamb at school.\nAnd so the teacher turned it out, but still it lingered near.","another world, another time, the age of wonders"],"gid":316}";}i:12;a:3:{s:2:"id";s:2:"13";s:3:"gid";s:1:"3";s:1:"j";s:303:"{"i1":123,"i2":-123,"i3":"18446744073709551615","i4":"-18446744073709551615","i5":9223372036854775807,"i6":"9223372036854775808","i7":"9223372036854775809","i8":-9223372036854775807,"i9":-9223372036854775808,"i10":"-9223372036854775809","i11":"123abc","i12":"-123abc","f1":3.150000,"f2":16777217.123000}";}i:13;a:3:{s:2:"id";s:2:"14";s:3:"gid";s:1:"3";s:1:"j";s:69:"{"f1":3.150000,"f2":-7.400000,"f3":65536.700000,"f4":16777217.123000}";}i:14;a:3:{s:2:"id";s:2:"15";s:3:"gid";s:1:"3";s:1:"j";N;}i:15;a:3:{s:2:"id";s:2:"16";s:3:"gid";s:1:"4";s:1:"j";s:19:"{"nick":"One\nTwo"}";}i:16;a:3:{s:2:"id";s:2:"17";s:3:"gid";s:1:"4";s:1:"j";s:19:"{"nick":"One\nTwo"}";}i:17;a:3:{s:2:"id";s:2:"18";s:3:"gid";s:1:"4";s:1:"j";s:19:"{"nick":"One\nTwo"}";}}}i:17;a:3:{s:8:"sphinxql";s:34:"select * from test where j.uid>200";s:10:"total_rows";i:3;s:4:"rows";a:3:{i:0;a:3:{s:2:"id";s:1:"2";s:3:"gid";s:1:"1";s:1:"j";s:33:"{"name":"Bob","uid":234,"gid":12}";}i:1;a:3:{s:2:"id";s:1:"3";s:3:"gid";s:1:"2";s:1:"j";s:28:"{"name":"Charlie","uid":345}";}i:2;a:3:{s:2:"id";s:1:"4";s:3:"gid";s:1:"2";s:1:"j";s:35:"{"name":"Damon","uid":456,"gid":23}";}}}i:18;a:3:{s:8:"sphinxql";s:31:"select * from test where j.t1>0";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:3:{s:2:"id";s:2:"11";s:3:"gid";s:1:"3";s:1:"j";s:98:"{"t1":123456789,"t2":-123456789,"t3":3123456789,"t4":-3123456789,"t5":9876543210,"t6":-9876543210}";}}}i:19;a:3:{s:8:"sphinxql";s:31:"select * from test where j.t2<0";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:3:{s:2:"id";s:2:"11";s:3:"gid";s:1:"3";s:1:"j";s:98:"{"t1":123456789,"t2":-123456789,"t3":3123456789,"t4":-3123456789,"t5":9876543210,"t6":-9876543210}";}}}i:20;a:3:{s:8:"sphinxql";s:31:"select * from test where j.t5>0";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:3:{s:2:"id";s:2:"11";s:3:"gid";s:1:"3";s:1:"j";s:98:"{"t1":123456789,"t2":-123456789,"t3":3123456789,"t4":-3123456789,"t5":9876543210,"t6":-9876543210}";}}}i:21;a:3:{s:8:"sphinxql";s:31:"select * from test where j.t6<0";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:3:{s:2:"id";s:2:"11";s:3:"gid";s:1:"3";s:1:"j";s:98:"{"t1":123456789,"t2":-123456789,"t3":3123456789,"t4":-3123456789,"t5":9876543210,"t6":-9876543210}";}}}i:22;a:3:{s:8:"sphinxql";s:39:"select * from test where j.name='Alice'";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:3:{s:2:"id";s:1:"1";s:3:"gid";s:1:"1";s:1:"j";s:26:"{"name":"Alice","uid":123}";}}}i:23;a:2:{s:8:"sphinxql";s:39:"select * from test where j.name='alice'";s:10:"total_rows";i:0;}i:24;a:3:{s:8:"sphinxql";s:39:"select * from test where j.short='ohai'";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:3:{s:2:"id";s:1:"7";s:3:"gid";s:1:"3";s:1:"j";s:375:"{"long":"\nYou can run on for a long time\nRun on for a long time\nRun on for a long time\nSooner or later God'll cut you down\nSooner or later God'll cut you down\n\nGo tell that long tongue liar\nGo and tell that midnight rider\nTell the rambler, the gambler, the back biter\nTell 'em that God's gonna cut 'em down\nTell 'em that God's gonna cut 'em down\n","short":"ohai"}";}}}i:25;a:3:{s:8:"sphinxql";s:34:"select * from test where j.gid=315";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:3:{s:2:"id";s:1:"8";s:3:"gid";s:1:"3";s:1:"j";s:38:"{"sv":["one","two","three"],"gid":315}";}}}i:26;a:2:{s:8:"sphinxql";s:36:"select * from test where j.gid='315'";s:10:"total_rows";i:0;}i:27;a:3:{s:8:"sphinxql";s:34:"select * from test where j.gid>315";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:3:{s:2:"id";s:2:"12";s:3:"gid";s:1:"3";s:1:"j";s:375:"{"sv":["\nMary had a little lamb, whose fleece was white as snow.\nAnd everywhere that Mary went, the lamb was sure to go.\nIt followed her to school one day which was against the rules.\nIt made the children laugh and play, to see a lamb at school.\nAnd so the teacher turned it out, but still it lingered near.","another world, another time, the age of wonders"],"gid":316}";}}}i:28;a:3:{s:8:"sphinxql";s:33:"select * from test where j.gid=12";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:3:{s:2:"id";s:1:"2";s:3:"gid";s:1:"1";s:1:"j";s:33:"{"name":"Bob","uid":234,"gid":12}";}}}i:29;a:3:{s:8:"sphinxql";s:30:"select * from test where id=13";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:3:{s:2:"id";s:2:"13";s:3:"gid";s:1:"3";s:1:"j";s:303:"{"i1":123,"i2":-123,"i3":"18446744073709551615","i4":"-18446744073709551615","i5":9223372036854775807,"i6":"9223372036854775808","i7":"9223372036854775809","i8":-9223372036854775807,"i9":-9223372036854775808,"i10":"-9223372036854775809","i11":"123abc","i12":"-123abc","f1":3.150000,"f2":16777217.123000}";}}}i:30;a:3:{s:8:"sphinxql";s:30:"select * from test where id=14";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:3:{s:2:"id";s:2:"14";s:3:"gid";s:1:"3";s:1:"j";s:69:"{"f1":3.150000,"f2":-7.400000,"f3":65536.700000,"f4":16777217.123000}";}}}i:31;a:3:{s:8:"sphinxql";s:54:"select id, j from test order by j.name asc, j.gid desc";s:10:"total_rows";i:18;s:4:"rows";a:18:{i:0;a:2:{s:2:"id";s:2:"12";s:1:"j";s:375:"{"sv":["\nMary had a little lamb, whose fleece was white as snow.\nAnd everywhere that Mary went, the lamb was sure to go.\nIt followed her to school one day which was against the rules.\nIt made the children laugh and play, to see a lamb at school.\nAnd so the teacher turned it out, but still it lingered near.","another world, another time, the age of wonders"],"gid":316}";}i:1;a:2:{s:2:"id";s:1:"8";s:1:"j";s:38:"{"sv":["one","two","three"],"gid":315}";}i:2;a:2:{s:2:"id";s:1:"5";s:1:"j";s:19:"{"12":345,"34":567}";}i:3;a:2:{s:2:"id";s:1:"6";s:1:"j";s:20:"{"12":346,"179":971}";}i:4;a:2:{s:2:"id";s:1:"7";s:1:"j";s:375:"{"long":"\nYou can run on for a long time\nRun on for a long time\nRun on for a long time\nSooner or later God'll cut you down\nSooner or later God'll cut you down\n\nGo tell that long tongue liar\nGo and tell that midnight rider\nTell the rambler, the gambler, the back biter\nTell 'em that God's gonna cut 'em down\nTell 'em that God's gonna cut 'em down\n","short":"ohai"}";}i:5;a:2:{s:2:"id";s:1:"9";s:1:"j";s:2:"{}";}i:6;a:2:{s:2:"id";s:2:"10";s:1:"j";N;}i:7;a:2:{s:2:"id";s:2:"11";s:1:"j";s:98:"{"t1":123456789,"t2":-123456789,"t3":3123456789,"t4":-3123456789,"t5":9876543210,"t6":-9876543210}";}i:8;a:2:{s:2:"id";s:2:"13";s:1:"j";s:303:"{"i1":123,"i2":-123,"i3":"18446744073709551615","i4":"-18446744073709551615","i5":9223372036854775807,"i6":"9223372036854775808","i7":"9223372036854775809","i8":-9223372036854775807,"i9":-9223372036854775808,"i10":"-9223372036854775809","i11":"123abc","i12":"-123abc","f1":3.150000,"f2":16777217.123000}";}i:9;a:2:{s:2:"id";s:2:"14";s:1:"j";s:69:"{"f1":3.150000,"f2":-7.400000,"f3":65536.700000,"f4":16777217.123000}";}i:10;a:2:{s:2:"id";s:2:"15";s:1:"j";N;}i:11;a:2:{s:2:"id";s:2:"16";s:1:"j";s:19:"{"nick":"One\nTwo"}";}i:12;a:2:{s:2:"id";s:2:"17";s:1:"j";s:19:"{"nick":"One\nTwo"}";}i:13;a:2:{s:2:"id";s:2:"18";s:1:"j";s:19:"{"nick":"One\nTwo"}";}i:14;a:2:{s:2:"id";s:1:"1";s:1:"j";s:26:"{"name":"Alice","uid":123}";}i:15;a:2:{s:2:"id";s:1:"2";s:1:"j";s:33:"{"name":"Bob","uid":234,"gid":12}";}i:16;a:2:{s:2:"id";s:1:"3";s:1:"j";s:28:"{"name":"Charlie","uid":345}";}i:17;a:2:{s:2:"id";s:1:"4";s:1:"j";s:35:"{"name":"Damon","uid":456,"gid":23}";}}}i:32;a:3:{s:8:"sphinxql";s:54:"select id, j from test order by j.name desc, j.gid asc";s:10:"total_rows";i:18;s:4:"rows";a:18:{i:0;a:2:{s:2:"id";s:1:"4";s:1:"j";s:35:"{"name":"Damon","uid":456,"gid":23}";}i:1;a:2:{s:2:"id";s:1:"3";s:1:"j";s:28:"{"name":"Charlie","uid":345}";}i:2;a:2:{s:2:"id";s:1:"2";s:1:"j";s:33:"{"name":"Bob","uid":234,"gid":12}";}i:3;a:2:{s:2:"id";s:1:"1";s:1:"j";s:26:"{"name":"Alice","uid":123}";}i:4;a:2:{s:2:"id";s:1:"5";s:1:"j";s:19:"{"12":345,"34":567}";}i:5;a:2:{s:2:"id";s:1:"6";s:1:"j";s:20:"{"12":346,"179":971}";}i:6;a:2:{s:2:"id";s:1:"7";s:1:"j";s:375:"{"long":"\nYou can run on for a long time\nRun on for a long time\nRun on for a long time\nSooner or later God'll cut you down\nSooner or later God'll cut you down\n\nGo tell that long tongue liar\nGo and tell that midnight rider\nTell the rambler, the gambler, the back biter\nTell 'em that God's gonna cut 'em down\nTell 'em that God's gonna cut 'em down\n","short":"ohai"}";}i:7;a:2:{s:2:"id";s:1:"9";s:1:"j";s:2:"{}";}i:8;a:2:{s:2:"id";s:2:"10";s:1:"j";N;}i:9;a:2:{s:2:"id";s:2:"11";s:1:"j";s:98:"{"t1":123456789,"t2":-123456789,"t3":3123456789,"t4":-3123456789,"t5":9876543210,"t6":-9876543210}";}i:10;a:2:{s:2:"id";s:2:"13";s:1:"j";s:303:"{"i1":123,"i2":-123,"i3":"18446744073709551615","i4":"-18446744073709551615","i5":9223372036854775807,"i6":"9223372036854775808","i7":"9223372036854775809","i8":-9223372036854775807,"i9":-9223372036854775808,"i10":"-9223372036854775809","i11":"123abc","i12":"-123abc","f1":3.150000,"f2":16777217.123000}";}i:11;a:2:{s:2:"id";s:2:"14";s:1:"j";s:69:"{"f1":3.150000,"f2":-7.400000,"f3":65536.700000,"f4":16777217.123000}";}i:12;a:2:{s:2:"id";s:2:"15";s:1:"j";N;}i:13;a:2:{s:2:"id";s:2:"16";s:1:"j";s:19:"{"nick":"One\nTwo"}";}i:14;a:2:{s:2:"id";s:2:"17";s:1:"j";s:19:"{"nick":"One\nTwo"}";}i:15;a:2:{s:2:"id";s:2:"18";s:1:"j";s:19:"{"nick":"One\nTwo"}";}i:16;a:2:{s:2:"id";s:1:"8";s:1:"j";s:38:"{"sv":["one","two","three"],"gid":315}";}i:17;a:2:{s:2:"id";s:2:"12";s:1:"j";s:375:"{"sv":["\nMary had a little lamb, whose fleece was white as snow.\nAnd everywhere that Mary went, the lamb was sure to go.\nIt followed her to school one day which was against the rules.\nIt made the children laugh and play, to see a lamb at school.\nAnd so the teacher turned it out, but still it lingered near.","another world, another time, the age of wonders"],"gid":316}";}}}i:33;a:3:{s:8:"sphinxql";s:55:"select id, j.uid, j.name from loc_field where j.uid>250";s:10:"total_rows";i:4;s:4:"rows";a:4:{i:0;a:3:{s:2:"id";s:1:"3";s:5:"j.uid";s:3:"345";s:6:"j.name";s:7:"Charlie";}i:1;a:3:{s:2:"id";s:1:"4";s:5:"j.uid";s:3:"456";s:6:"j.name";s:5:"Damon";}i:2;a:3:{s:2:"id";s:1:"5";s:5:"j.uid";s:3:"567";s:6:"j.name";N;}i:3;a:3:{s:2:"id";s:1:"8";s:5:"j.uid";s:3:"567";s:6:"j.name";N;}}}i:34;a:3:{s:8:"sphinxql";s:71:"select id, j.uid, j.name from loc_field order by j.name asc, j.gid desc";s:10:"total_rows";i:18;s:4:"rows";a:18:{i:0;a:3:{s:2:"id";s:2:"12";s:5:"j.uid";N;s:6:"j.name";N;}i:1;a:3:{s:2:"id";s:1:"8";s:5:"j.uid";N;s:6:"j.name";N;}i:2;a:3:{s:2:"id";s:1:"5";s:5:"j.uid";N;s:6:"j.name";N;}i:3;a:3:{s:2:"id";s:1:"6";s:5:"j.uid";N;s:6:"j.name";N;}i:4;a:3:{s:2:"id";s:1:"7";s:5:"j.uid";N;s:6:"j.name";N;}i:5;a:3:{s:2:"id";s:1:"9";s:5:"j.uid";N;s:6:"j.name";N;}i:6;a:3:{s:2:"id";s:2:"10";s:5:"j.uid";N;s:6:"j.name";N;}i:7;a:3:{s:2:"id";s:2:"11";s:5:"j.uid";N;s:6:"j.name";N;}i:8;a:3:{s:2:"id";s:2:"13";s:5:"j.uid";N;s:6:"j.name";N;}i:9;a:3:{s:2:"id";s:2:"14";s:5:"j.uid";N;s:6:"j.name";N;}i:10;a:3:{s:2:"id";s:2:"15";s:5:"j.uid";N;s:6:"j.name";N;}i:11;a:3:{s:2:"id";s:2:"16";s:5:"j.uid";N;s:6:"j.name";N;}i:12;a:3:{s:2:"id";s:2:"17";s:5:"j.uid";N;s:6:"j.name";N;}i:13;a:3:{s:2:"id";s:2:"18";s:5:"j.uid";N;s:6:"j.name";N;}i:14;a:3:{s:2:"id";s:1:"1";s:5:"j.uid";s:3:"123";s:6:"j.name";s:5:"Alice";}i:15;a:3:{s:2:"id";s:1:"2";s:5:"j.uid";s:3:"234";s:6:"j.name";s:3:"Bob";}i:16;a:3:{s:2:"id";s:1:"3";s:5:"j.uid";s:3:"345";s:6:"j.name";s:7:"Charlie";}i:17;a:3:{s:2:"id";s:1:"4";s:5:"j.uid";s:3:"456";s:6:"j.name";s:5:"Damon";}}}i:35;a:3:{s:8:"sphinxql";s:72:"select id, j.name, j.uid from dist_field order by j.name desc, j.gid asc";s:10:"total_rows";i:18;s:4:"rows";a:18:{i:0;a:3:{s:2:"id";s:1:"4";s:6:"j.name";s:5:"Damon";s:5:"j.uid";s:3:"456";}i:1;a:3:{s:2:"id";s:1:"3";s:6:"j.name";s:7:"Charlie";s:5:"j.uid";s:3:"345";}i:2;a:3:{s:2:"id";s:1:"2";s:6:"j.name";s:3:"Bob";s:5:"j.uid";s:3:"234";}i:3;a:3:{s:2:"id";s:1:"1";s:6:"j.name";s:5:"Alice";s:5:"j.uid";s:3:"123";}i:4;a:3:{s:2:"id";s:1:"5";s:6:"j.name";N;s:5:"j.uid";N;}i:5;a:3:{s:2:"id";s:1:"6";s:6:"j.name";N;s:5:"j.uid";N;}i:6;a:3:{s:2:"id";s:1:"7";s:6:"j.name";N;s:5:"j.uid";N;}i:7;a:3:{s:2:"id";s:1:"9";s:6:"j.name";N;s:5:"j.uid";N;}i:8;a:3:{s:2:"id";s:2:"10";s:6:"j.name";N;s:5:"j.uid";N;}i:9;a:3:{s:2:"id";s:2:"11";s:6:"j.name";N;s:5:"j.uid";N;}i:10;a:3:{s:2:"id";s:2:"13";s:6:"j.name";N;s:5:"j.uid";N;}i:11;a:3:{s:2:"id";s:2:"14";s:6:"j.name";N;s:5:"j.uid";N;}i:12;a:3:{s:2:"id";s:2:"15";s:6:"j.name";N;s:5:"j.uid";N;}i:13;a:3:{s:2:"id";s:2:"16";s:6:"j.name";N;s:5:"j.uid";N;}i:14;a:3:{s:2:"id";s:2:"17";s:6:"j.name";N;s:5:"j.uid";N;}i:15;a:3:{s:2:"id";s:2:"18";s:6:"j.name";N;s:5:"j.uid";N;}i:16;a:3:{s:2:"id";s:1:"8";s:6:"j.name";N;s:5:"j.uid";N;}i:17;a:3:{s:2:"id";s:2:"12";s:6:"j.name";N;s:5:"j.uid";N;}}}i:36;a:3:{s:8:"sphinxql";s:80:"select id, j.name, j.34, j.179, j.uid, j.sv, j.t6, j. f2, j.f1 from dist_field ";s:10:"total_rows";i:18;s:4:"rows";a:18:{i:0;a:9:{s:2:"id";s:1:"1";s:6:"j.name";s:5:"Alice";s:4:"j.34";N;s:5:"j.179";N;s:5:"j.uid";s:3:"123";s:4:"j.sv";N;s:4:"j.t6";N;s:5:"j. f2";N;s:4:"j.f1";N;}i:1;a:9:{s:2:"id";s:1:"2";s:6:"j.name";s:3:"Bob";s:4:"j.34";N;s:5:"j.179";N;s:5:"j.uid";s:3:"234";s:4:"j.sv";N;s:4:"j.t6";N;s:5:"j. f2";N;s:4:"j.f1";N;}i:2;a:9:{s:2:"id";s:1:"3";s:6:"j.name";s:7:"Charlie";s:4:"j.34";N;s:5:"j.179";N;s:5:"j.uid";s:3:"345";s:4:"j.sv";N;s:4:"j.t6";N;s:5:"j. f2";N;s:4:"j.f1";N;}i:3;a:9:{s:2:"id";s:1:"4";s:6:"j.name";s:5:"Damon";s:4:"j.34";N;s:5:"j.179";N;s:5:"j.uid";s:3:"456";s:4:"j.sv";N;s:4:"j.t6";N;s:5:"j. f2";N;s:4:"j.f1";N;}i:4;a:9:{s:2:"id";s:1:"5";s:6:"j.name";N;s:4:"j.34";s:3:"567";s:5:"j.179";N;s:5:"j.uid";N;s:4:"j.sv";N;s:4:"j.t6";N;s:5:"j. f2";N;s:4:"j.f1";N;}i:5;a:9:{s:2:"id";s:1:"6";s:6:"j.name";N;s:4:"j.34";N;s:5:"j.179";s:3:"971";s:5:"j.uid";N;s:4:"j.sv";N;s:4:"j.t6";N;s:5:"j. f2";N;s:4:"j.f1";N;}i:6;a:9:{s:2:"id";s:1:"7";s:6:"j.name";N;s:4:"j.34";N;s:5:"j.179";N;s:5:"j.uid";N;s:4:"j.sv";N;s:4:"j.t6";N;s:5:"j. f2";N;s:4:"j.f1";N;}i:7;a:9:{s:2:"id";s:1:"8";s:6:"j.name";N;s:4:"j.34";N;s:5:"j.179";N;s:5:"j.uid";N;s:4:"j.sv";s:21:"["one","two","three"]";s:4:"j.t6";N;s:5:"j. f2";N;s:4:"j.f1";N;}i:8;a:9:{s:2:"id";s:1:"9";s:6:"j.name";N;s:4:"j.34";N;s:5:"j.179";N;s:5:"j.uid";N;s:4:"j.sv";N;s:4:"j.t6";N;s:5:"j. f2";N;s:4:"j.f1";N;}i:9;a:9:{s:2:"id";s:2:"10";s:6:"j.name";N;s:4:"j.34";N;s:5:"j.179";N;s:5:"j.uid";N;s:4:"j.sv";N;s:4:"j.t6";N;s:5:"j. f2";N;s:4:"j.f1";N;}i:10;a:9:{s:2:"id";s:2:"11";s:6:"j.name";N;s:4:"j.34";N;s:5:"j.179";N;s:5:"j.uid";N;s:4:"j.sv";N;s:4:"j.t6";s:11:"-9876543210";s:5:"j. f2";N;s:4:"j.f1";N;}i:11;a:9:{s:2:"id";s:2:"12";s:6:"j.name";N;s:4:"j.34";N;s:5:"j.179";N;s:5:"j.uid";N;s:4:"j.sv";s:358:"["\nMary had a little lamb, whose fleece was white as snow.\nAnd everywhere that Mary went, the lamb was sure to go.\nIt followed her to school one day which was against the rules.\nIt made the children laugh and play, to see a lamb at school.\nAnd so the teacher turned it out, but still it lingered near.","another world, another time, the age of wonders"]";s:4:"j.t6";N;s:5:"j. f2";N;s:4:"j.f1";N;}i:12;a:9:{s:2:"id";s:2:"13";s:6:"j.name";N;s:4:"j.34";N;s:5:"j.179";N;s:5:"j.uid";N;s:4:"j.sv";N;s:4:"j.t6";N;s:5:"j. f2";s:15:"16777217.123000";s:4:"j.f1";s:8:"3.150000";}i:13;a:9:{s:2:"id";s:2:"14";s:6:"j.name";N;s:4:"j.34";N;s:5:"j.179";N;s:5:"j.uid";N;s:4:"j.sv";N;s:4:"j.t6";N;s:5:"j. f2";s:9:"-7.400000";s:4:"j.f1";s:8:"3.150000";}i:14;a:9:{s:2:"id";s:2:"15";s:6:"j.name";N;s:4:"j.34";N;s:5:"j.179";N;s:5:"j.uid";N;s:4:"j.sv";N;s:4:"j.t6";N;s:5:"j. f2";N;s:4:"j.f1";N;}i:15;a:9:{s:2:"id";s:2:"16";s:6:"j.name";N;s:4:"j.34";N;s:5:"j.179";N;s:5:"j.uid";N;s:4:"j.sv";N;s:4:"j.t6";N;s:5:"j. f2";N;s:4:"j.f1";N;}i:16;a:9:{s:2:"id";s:2:"17";s:6:"j.name";N;s:4:"j.34";N;s:5:"j.179";N;s:5:"j.uid";N;s:4:"j.sv";N;s:4:"j.t6";N;s:5:"j. f2";N;s:4:"j.f1";N;}i:17;a:9:{s:2:"id";s:2:"18";s:6:"j.name";N;s:4:"j.34";N;s:5:"j.179";N;s:5:"j.uid";N;s:4:"j.sv";N;s:4:"j.t6";N;s:5:"j. f2";N;s:4:"j.f1";N;}}}i:37;a:3:{s:8:"sphinxql";s:72:"select id, j.Attr as j1, j.aTTr j2, j.Str as j3, j.STR j4 from json_case";s:10:"total_rows";i:8;s:4:"rows";a:8:{i:0;a:5:{s:2:"id";s:1:"1";s:2:"j1";s:3:"123";s:2:"j2";s:2:"12";s:2:"j3";s:4:"nope";s:2:"j4";s:3:"yep";}i:1;a:5:{s:2:"id";s:1:"2";s:2:"j1";s:2:"23";s:2:"j2";N;s:2:"j3";s:4:"nope";s:2:"j4";s:4:"yep2";}i:2;a:5:{s:2:"id";s:1:"3";s:2:"j1";s:3:"123";s:2:"j2";s:2:"12";s:2:"j3";N;s:2:"j4";s:3:"yep";}i:3;a:5:{s:2:"id";s:1:"4";s:2:"j1";s:3:"123";s:2:"j2";s:3:"212";s:2:"j3";s:6:"nope11";s:2:"j4";N;}i:4;a:5:{s:2:"id";s:1:"5";s:2:"j1";s:2:"12";s:2:"j2";s:2:"12";s:2:"j3";N;s:2:"j4";N;}i:5;a:5:{s:2:"id";s:1:"6";s:2:"j1";N;s:2:"j2";N;s:2:"j3";s:4:"nope";s:2:"j4";s:3:"yep";}i:6;a:5:{s:2:"id";s:1:"7";s:2:"j1";N;s:2:"j2";s:3:"212";s:2:"j3";N;s:2:"j4";s:4:"yep2";}i:7;a:5:{s:2:"id";s:1:"8";s:2:"j1";s:2:"12";s:2:"j2";N;s:2:"j3";s:6:"nope11";s:2:"j4";N;}}}i:38;a:3:{s:8:"sphinxql";s:71:"select id, j.Attr, j.aTTr, j.Str, j.STR from json_case where j.Attr>100";s:10:"total_rows";i:3;s:4:"rows";a:3:{i:0;a:5:{s:2:"id";s:1:"1";s:6:"j.Attr";s:3:"123";s:6:"j.aTTr";s:2:"12";s:5:"j.Str";s:4:"nope";s:5:"j.STR";s:3:"yep";}i:1;a:5:{s:2:"id";s:1:"3";s:6:"j.Attr";s:3:"123";s:6:"j.aTTr";s:2:"12";s:5:"j.Str";N;s:5:"j.STR";s:3:"yep";}i:2;a:5:{s:2:"id";s:1:"4";s:6:"j.Attr";s:3:"123";s:6:"j.aTTr";s:3:"212";s:5:"j.Str";s:6:"nope11";s:5:"j.STR";N;}}}i:39;a:3:{s:8:"sphinxql";s:71:"select id, j.Attr, j.aTTr, j.Str, j.STR from json_case where j.aTTr<100";s:10:"total_rows";i:3;s:4:"rows";a:3:{i:0;a:5:{s:2:"id";s:1:"1";s:6:"j.Attr";s:3:"123";s:6:"j.aTTr";s:2:"12";s:5:"j.Str";s:4:"nope";s:5:"j.STR";s:3:"yep";}i:1;a:5:{s:2:"id";s:1:"3";s:6:"j.Attr";s:3:"123";s:6:"j.aTTr";s:2:"12";s:5:"j.Str";N;s:5:"j.STR";s:3:"yep";}i:2;a:5:{s:2:"id";s:1:"5";s:6:"j.Attr";s:2:"12";s:6:"j.aTTr";s:2:"12";s:5:"j.Str";N;s:5:"j.STR";N;}}}i:40;a:3:{s:8:"sphinxql";s:73:"select id, j.Attr, j.aTTr, j.Str, j.STR from json_case where j.Str='nope'";s:10:"total_rows";i:3;s:4:"rows";a:3:{i:0;a:5:{s:2:"id";s:1:"1";s:6:"j.Attr";s:3:"123";s:6:"j.aTTr";s:2:"12";s:5:"j.Str";s:4:"nope";s:5:"j.STR";s:3:"yep";}i:1;a:5:{s:2:"id";s:1:"2";s:6:"j.Attr";s:2:"23";s:6:"j.aTTr";N;s:5:"j.Str";s:4:"nope";s:5:"j.STR";s:4:"yep2";}i:2;a:5:{s:2:"id";s:1:"6";s:6:"j.Attr";N;s:6:"j.aTTr";N;s:5:"j.Str";s:4:"nope";s:5:"j.STR";s:3:"yep";}}}i:41;a:3:{s:8:"sphinxql";s:72:"select id, j.Attr, j.aTTr, j.Str, j.STR from json_case where j.STR='yep'";s:10:"total_rows";i:3;s:4:"rows";a:3:{i:0;a:5:{s:2:"id";s:1:"1";s:6:"j.Attr";s:3:"123";s:6:"j.aTTr";s:2:"12";s:5:"j.Str";s:4:"nope";s:5:"j.STR";s:3:"yep";}i:1;a:5:{s:2:"id";s:1:"3";s:6:"j.Attr";s:3:"123";s:6:"j.aTTr";s:2:"12";s:5:"j.Str";N;s:5:"j.STR";s:3:"yep";}i:2;a:5:{s:2:"id";s:1:"6";s:6:"j.Attr";N;s:6:"j.aTTr";N;s:5:"j.Str";s:4:"nope";s:5:"j.STR";s:3:"yep";}}}i:42;a:3:{s:8:"sphinxql";s:82:"select id, count(*) c, j.Attr, j.aTTr, j.Str, j.STR from json_case group by j.Attr";s:10:"total_rows";i:4;s:4:"rows";a:4:{i:0;a:6:{s:2:"id";s:1:"1";s:1:"c";s:1:"3";s:6:"j.Attr";s:3:"123";s:6:"j.aTTr";s:2:"12";s:5:"j.Str";s:4:"nope";s:5:"j.STR";s:3:"yep";}i:1;a:6:{s:2:"id";s:1:"2";s:1:"c";s:1:"1";s:6:"j.Attr";s:2:"23";s:6:"j.aTTr";N;s:5:"j.Str";s:4:"nope";s:5:"j.STR";s:4:"yep2";}i:2;a:6:{s:2:"id";s:1:"5";s:1:"c";s:1:"2";s:6:"j.Attr";s:2:"12";s:6:"j.aTTr";s:2:"12";s:5:"j.Str";N;s:5:"j.STR";N;}i:3;a:6:{s:2:"id";s:1:"6";s:1:"c";s:1:"2";s:6:"j.Attr";N;s:6:"j.aTTr";N;s:5:"j.Str";s:4:"nope";s:5:"j.STR";s:3:"yep";}}}i:43;a:3:{s:8:"sphinxql";s:82:"select id, count(*) c, j.Attr, j.aTTr, j.Str, j.STR from json_case group by j.aTTr";s:10:"total_rows";i:3;s:4:"rows";a:3:{i:0;a:6:{s:2:"id";s:1:"1";s:1:"c";s:1:"3";s:6:"j.Attr";s:3:"123";s:6:"j.aTTr";s:2:"12";s:5:"j.Str";s:4:"nope";s:5:"j.STR";s:3:"yep";}i:1;a:6:{s:2:"id";s:1:"2";s:1:"c";s:1:"3";s:6:"j.Attr";s:2:"23";s:6:"j.aTTr";N;s:5:"j.Str";s:4:"nope";s:5:"j.STR";s:4:"yep2";}i:2;a:6:{s:2:"id";s:1:"4";s:1:"c";s:1:"2";s:6:"j.Attr";s:3:"123";s:6:"j.aTTr";s:3:"212";s:5:"j.Str";s:6:"nope11";s:5:"j.STR";N;}}}i:44;a:3:{s:8:"sphinxql";s:81:"select id, count(*) c, j.Attr, j.aTTr, j.Str, j.STR from json_case group by j.Str";s:10:"total_rows";i:3;s:4:"rows";a:3:{i:0;a:6:{s:2:"id";s:1:"1";s:1:"c";s:1:"3";s:6:"j.Attr";s:3:"123";s:6:"j.aTTr";s:2:"12";s:5:"j.Str";s:4:"nope";s:5:"j.STR";s:3:"yep";}i:1;a:6:{s:2:"id";s:1:"3";s:1:"c";s:1:"3";s:6:"j.Attr";s:3:"123";s:6:"j.aTTr";s:2:"12";s:5:"j.Str";N;s:5:"j.STR";s:3:"yep";}i:2;a:6:{s:2:"id";s:1:"4";s:1:"c";s:1:"2";s:6:"j.Attr";s:3:"123";s:6:"j.aTTr";s:3:"212";s:5:"j.Str";s:6:"nope11";s:5:"j.STR";N;}}}i:45;a:3:{s:8:"sphinxql";s:81:"select id, count(*) c, j.Attr, j.aTTr, j.Str, j.STR from json_case group by j.STR";s:10:"total_rows";i:3;s:4:"rows";a:3:{i:0;a:6:{s:2:"id";s:1:"1";s:1:"c";s:1:"3";s:6:"j.Attr";s:3:"123";s:6:"j.aTTr";s:2:"12";s:5:"j.Str";s:4:"nope";s:5:"j.STR";s:3:"yep";}i:1;a:6:{s:2:"id";s:1:"2";s:1:"c";s:1:"2";s:6:"j.Attr";s:2:"23";s:6:"j.aTTr";N;s:5:"j.Str";s:4:"nope";s:5:"j.STR";s:4:"yep2";}i:2;a:6:{s:2:"id";s:1:"4";s:1:"c";s:1:"3";s:6:"j.Attr";s:3:"123";s:6:"j.aTTr";s:3:"212";s:5:"j.Str";s:6:"nope11";s:5:"j.STR";N;}}}i:46;a:3:{s:8:"sphinxql";s:83:"select id, j.Attr, j.aTTr, j.Str, j.STR from json_case order by j.Attr asc, id desc";s:10:"total_rows";i:8;s:4:"rows";a:8:{i:0;a:5:{s:2:"id";s:1:"7";s:6:"j.Attr";N;s:6:"j.aTTr";s:3:"212";s:5:"j.Str";N;s:5:"j.STR";s:4:"yep2";}i:1;a:5:{s:2:"id";s:1:"6";s:6:"j.Attr";N;s:6:"j.aTTr";N;s:5:"j.Str";s:4:"nope";s:5:"j.STR";s:3:"yep";}i:2;a:5:{s:2:"id";s:1:"8";s:6:"j.Attr";s:2:"12";s:6:"j.aTTr";N;s:5:"j.Str";s:6:"nope11";s:5:"j.STR";N;}i:3;a:5:{s:2:"id";s:1:"5";s:6:"j.Attr";s:2:"12";s:6:"j.aTTr";s:2:"12";s:5:"j.Str";N;s:5:"j.STR";N;}i:4;a:5:{s:2:"id";s:1:"4";s:6:"j.Attr";s:3:"123";s:6:"j.aTTr";s:3:"212";s:5:"j.Str";s:6:"nope11";s:5:"j.STR";N;}i:5;a:5:{s:2:"id";s:1:"3";s:6:"j.Attr";s:3:"123";s:6:"j.aTTr";s:2:"12";s:5:"j.Str";N;s:5:"j.STR";s:3:"yep";}i:6;a:5:{s:2:"id";s:1:"1";s:6:"j.Attr";s:3:"123";s:6:"j.aTTr";s:2:"12";s:5:"j.Str";s:4:"nope";s:5:"j.STR";s:3:"yep";}i:7;a:5:{s:2:"id";s:1:"2";s:6:"j.Attr";s:2:"23";s:6:"j.aTTr";N;s:5:"j.Str";s:4:"nope";s:5:"j.STR";s:4:"yep2";}}}i:47;a:3:{s:8:"sphinxql";s:84:"select id, j.Attr, j.aTTr, j.Str, j.STR from json_case order by j.aTTr desc, id desc";s:10:"total_rows";i:8;s:4:"rows";a:8:{i:0;a:5:{s:2:"id";s:1:"7";s:6:"j.Attr";N;s:6:"j.aTTr";s:3:"212";s:5:"j.Str";N;s:5:"j.STR";s:4:"yep2";}i:1;a:5:{s:2:"id";s:1:"4";s:6:"j.Attr";s:3:"123";s:6:"j.aTTr";s:3:"212";s:5:"j.Str";s:6:"nope11";s:5:"j.STR";N;}i:2;a:5:{s:2:"id";s:1:"5";s:6:"j.Attr";s:2:"12";s:6:"j.aTTr";s:2:"12";s:5:"j.Str";N;s:5:"j.STR";N;}i:3;a:5:{s:2:"id";s:1:"3";s:6:"j.Attr";s:3:"123";s:6:"j.aTTr";s:2:"12";s:5:"j.Str";N;s:5:"j.STR";s:3:"yep";}i:4;a:5:{s:2:"id";s:1:"1";s:6:"j.Attr";s:3:"123";s:6:"j.aTTr";s:2:"12";s:5:"j.Str";s:4:"nope";s:5:"j.STR";s:3:"yep";}i:5;a:5:{s:2:"id";s:1:"8";s:6:"j.Attr";s:2:"12";s:6:"j.aTTr";N;s:5:"j.Str";s:6:"nope11";s:5:"j.STR";N;}i:6;a:5:{s:2:"id";s:1:"6";s:6:"j.Attr";N;s:6:"j.aTTr";N;s:5:"j.Str";s:4:"nope";s:5:"j.STR";s:3:"yep";}i:7;a:5:{s:2:"id";s:1:"2";s:6:"j.Attr";s:2:"23";s:6:"j.aTTr";N;s:5:"j.Str";s:4:"nope";s:5:"j.STR";s:4:"yep2";}}}i:48;a:3:{s:8:"sphinxql";s:82:"select id, j.Attr, j.aTTr, j.Str, j.STR from json_case order by j.Str asc, id desc";s:10:"total_rows";i:8;s:4:"rows";a:8:{i:0;a:5:{s:2:"id";s:1:"7";s:6:"j.Attr";N;s:6:"j.aTTr";s:3:"212";s:5:"j.Str";N;s:5:"j.STR";s:4:"yep2";}i:1;a:5:{s:2:"id";s:1:"5";s:6:"j.Attr";s:2:"12";s:6:"j.aTTr";s:2:"12";s:5:"j.Str";N;s:5:"j.STR";N;}i:2;a:5:{s:2:"id";s:1:"3";s:6:"j.Attr";s:3:"123";s:6:"j.aTTr";s:2:"12";s:5:"j.Str";N;s:5:"j.STR";s:3:"yep";}i:3;a:5:{s:2:"id";s:1:"6";s:6:"j.Attr";N;s:6:"j.aTTr";N;s:5:"j.Str";s:4:"nope";s:5:"j.STR";s:3:"yep";}i:4;a:5:{s:2:"id";s:1:"2";s:6:"j.Attr";s:2:"23";s:6:"j.aTTr";N;s:5:"j.Str";s:4:"nope";s:5:"j.STR";s:4:"yep2";}i:5;a:5:{s:2:"id";s:1:"1";s:6:"j.Attr";s:3:"123";s:6:"j.aTTr";s:2:"12";s:5:"j.Str";s:4:"nope";s:5:"j.STR";s:3:"yep";}i:6;a:5:{s:2:"id";s:1:"8";s:6:"j.Attr";s:2:"12";s:6:"j.aTTr";N;s:5:"j.Str";s:6:"nope11";s:5:"j.STR";N;}i:7;a:5:{s:2:"id";s:1:"4";s:6:"j.Attr";s:3:"123";s:6:"j.aTTr";s:3:"212";s:5:"j.Str";s:6:"nope11";s:5:"j.STR";N;}}}i:49;a:3:{s:8:"sphinxql";s:83:"select id, j.Attr, j.aTTr, j.Str, j.STR from json_case order by j.STR desc, id desc";s:10:"total_rows";i:8;s:4:"rows";a:8:{i:0;a:5:{s:2:"id";s:1:"7";s:6:"j.Attr";N;s:6:"j.aTTr";s:3:"212";s:5:"j.Str";N;s:5:"j.STR";s:4:"yep2";}i:1;a:5:{s:2:"id";s:1:"2";s:6:"j.Attr";s:2:"23";s:6:"j.aTTr";N;s:5:"j.Str";s:4:"nope";s:5:"j.STR";s:4:"yep2";}i:2;a:5:{s:2:"id";s:1:"6";s:6:"j.Attr";N;s:6:"j.aTTr";N;s:5:"j.Str";s:4:"nope";s:5:"j.STR";s:3:"yep";}i:3;a:5:{s:2:"id";s:1:"3";s:6:"j.Attr";s:3:"123";s:6:"j.aTTr";s:2:"12";s:5:"j.Str";N;s:5:"j.STR";s:3:"yep";}i:4;a:5:{s:2:"id";s:1:"1";s:6:"j.Attr";s:3:"123";s:6:"j.aTTr";s:2:"12";s:5:"j.Str";s:4:"nope";s:5:"j.STR";s:3:"yep";}i:5;a:5:{s:2:"id";s:1:"8";s:6:"j.Attr";s:2:"12";s:6:"j.aTTr";N;s:5:"j.Str";s:6:"nope11";s:5:"j.STR";N;}i:6;a:5:{s:2:"id";s:1:"5";s:6:"j.Attr";s:2:"12";s:6:"j.aTTr";s:2:"12";s:5:"j.Str";N;s:5:"j.STR";N;}i:7;a:5:{s:2:"id";s:1:"4";s:6:"j.Attr";s:3:"123";s:6:"j.aTTr";s:3:"212";s:5:"j.Str";s:6:"nope11";s:5:"j.STR";N;}}}i:50;a:2:{s:8:"sphinxql";s:81:"insert into rt (id, title, data) values (1, 'title1','{attr1:10, attr2:"test1"}')";s:14:"total_affected";i:1;}i:51;a:2:{s:8:"sphinxql";s:81:"insert into rt (id, title, data) values (2, 'title2','{attr1:20, attr2:"test2"}')";s:14:"total_affected";i:1;}i:52;a:2:{s:8:"sphinxql";s:81:"insert into rt (id, title, data) values (3, 'title3','{attr1:30, attr2:"test3"}')";s:14:"total_affected";i:1;}i:53;a:3:{s:8:"sphinxql";s:16:"select * from rt";s:10:"total_rows";i:3;s:4:"rows";a:3:{i:0;a:2:{s:2:"id";s:1:"1";s:4:"data";s:28:"{"attr1":10,"attr2":"test1"}";}i:1;a:2:{s:2:"id";s:1:"2";s:4:"data";s:28:"{"attr1":20,"attr2":"test2"}";}i:2;a:2:{s:2:"id";s:1:"3";s:4:"data";s:28:"{"attr1":30,"attr2":"test3"}";}}}i:54;a:3:{s:8:"sphinxql";s:36:"select * from rt where data.attr1=20";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:2:{s:2:"id";s:1:"2";s:4:"data";s:28:"{"attr1":20,"attr2":"test2"}";}}}i:55;a:3:{s:8:"sphinxql";s:36:"select * from rt group by data.attr1";s:10:"total_rows";i:3;s:4:"rows";a:3:{i:0;a:2:{s:2:"id";s:1:"1";s:4:"data";s:28:"{"attr1":10,"attr2":"test1"}";}i:1;a:2:{s:2:"id";s:1:"2";s:4:"data";s:28:"{"attr1":20,"attr2":"test2"}";}i:2;a:2:{s:2:"id";s:1:"3";s:4:"data";s:28:"{"attr1":30,"attr2":"test3"}";}}}i:56;a:2:{s:8:"sphinxql";s:87:"replace into rt (id, data) values (3, '{attr1:100, attr2:"replaced", new_attr:"text"}')";s:14:"total_affected";i:1;}i:57;a:3:{s:8:"sphinxql";s:16:"select * from rt";s:10:"total_rows";i:3;s:4:"rows";a:3:{i:0;a:2:{s:2:"id";s:1:"1";s:4:"data";s:28:"{"attr1":10,"attr2":"test1"}";}i:1;a:2:{s:2:"id";s:1:"2";s:4:"data";s:28:"{"attr1":20,"attr2":"test2"}";}i:2;a:2:{s:2:"id";s:1:"3";s:4:"data";s:50:"{"attr1":100,"attr2":"replaced","new_attr":"text"}";}}}i:58;a:3:{s:8:"sphinxql";s:39:"select * from rt group by data.new_attr";s:10:"total_rows";i:2;s:4:"rows";a:2:{i:0;a:2:{s:2:"id";s:1:"1";s:4:"data";s:28:"{"attr1":10,"attr2":"test1"}";}i:1;a:2:{s:2:"id";s:1:"3";s:4:"data";s:50:"{"attr1":100,"attr2":"replaced","new_attr":"text"}";}}}i:59;a:3:{s:8:"sphinxql";s:48:"select data.attr2 from rt group by data.new_attr";s:10:"total_rows";i:2;s:4:"rows";a:2:{i:0;a:1:{s:10:"data.attr2";s:5:"test1";}i:1;a:1:{s:10:"data.attr2";s:8:"replaced";}}}i:60;a:3:{s:8:"sphinxql";s:23:"select * from json_attr";s:10:"total_rows";i:4;s:4:"rows";a:4:{i:0;a:2:{s:2:"id";s:3:"123";s:5:"json1";s:52:"{"username":"Alice","year":2000,"floatkey":1.010000}";}i:1;a:2:{s:2:"id";s:3:"234";s:5:"json1";s:50:"{"username":"Bob","year":2001,"floatkey":2.220000}";}i:2;a:2:{s:2:"id";s:3:"345";s:5:"json1";s:54:"{"username":"Charlie","year":2002,"floatkey":3.000000}";}i:3;a:2:{s:2:"id";s:3:"456";s:5:"json1";s:52:"{"username":"Damon","year":2003,"floatkey":4.440000}";}}}i:61;a:3:{s:8:"sphinxql";s:49:"select json1.username from json_attr where id=123";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:1:{s:14:"json1.username";s:5:"Alice";}}}i:62;a:3:{s:8:"sphinxql";s:45:"select json1.year from json_attr where id=123";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:1:{s:10:"json1.year";s:4:"2000";}}}i:63;a:3:{s:8:"sphinxql";s:50:"select * from json_attr where json1.floatkey>1.234";s:10:"total_rows";i:3;s:4:"rows";a:3:{i:0;a:2:{s:2:"id";s:3:"234";s:5:"json1";s:50:"{"username":"Bob","year":2001,"floatkey":2.220000}";}i:1;a:2:{s:2:"id";s:3:"345";s:5:"json1";s:54:"{"username":"Charlie","year":2002,"floatkey":3.000000}";}i:2;a:2:{s:2:"id";s:3:"456";s:5:"json1";s:52:"{"username":"Damon","year":2003,"floatkey":4.440000}";}}}i:64;a:3:{s:8:"sphinxql";s:60:"select * from json_attr where json1.floatkey between 1 and 3";s:10:"total_rows";i:3;s:4:"rows";a:3:{i:0;a:2:{s:2:"id";s:3:"123";s:5:"json1";s:52:"{"username":"Alice","year":2000,"floatkey":1.010000}";}i:1;a:2:{s:2:"id";s:3:"234";s:5:"json1";s:50:"{"username":"Bob","year":2001,"floatkey":2.220000}";}i:2;a:2:{s:2:"id";s:3:"345";s:5:"json1";s:54:"{"username":"Charlie","year":2002,"floatkey":3.000000}";}}}i:65;a:3:{s:8:"sphinxql";s:65:"select * from json_attr where json1.floatkey between 1.01 and 3.0";s:10:"total_rows";i:3;s:4:"rows";a:3:{i:0;a:2:{s:2:"id";s:3:"123";s:5:"json1";s:52:"{"username":"Alice","year":2000,"floatkey":1.010000}";}i:1;a:2:{s:2:"id";s:3:"234";s:5:"json1";s:50:"{"username":"Bob","year":2001,"floatkey":2.220000}";}i:2;a:2:{s:2:"id";s:3:"345";s:5:"json1";s:54:"{"username":"Charlie","year":2002,"floatkey":3.000000}";}}}i:66;a:3:{s:8:"sphinxql";s:66:"select * from json_attr where json1.floatkey between 1.01 and 1.02";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:2:{s:2:"id";s:3:"123";s:5:"json1";s:52:"{"username":"Alice","year":2000,"floatkey":1.010000}";}}}i:67;a:3:{s:8:"sphinxql";s:49:"select * from json_attr where json1.floatkey>2.22";s:10:"total_rows";i:2;s:4:"rows";a:2:{i:0;a:2:{s:2:"id";s:3:"345";s:5:"json1";s:54:"{"username":"Charlie","year":2002,"floatkey":3.000000}";}i:1;a:2:{s:2:"id";s:3:"456";s:5:"json1";s:52:"{"username":"Damon","year":2003,"floatkey":4.440000}";}}}i:68;a:3:{s:8:"sphinxql";s:50:"select * from json_attr where json1.floatkey>=2.22";s:10:"total_rows";i:3;s:4:"rows";a:3:{i:0;a:2:{s:2:"id";s:3:"234";s:5:"json1";s:50:"{"username":"Bob","year":2001,"floatkey":2.220000}";}i:1;a:2:{s:2:"id";s:3:"345";s:5:"json1";s:54:"{"username":"Charlie","year":2002,"floatkey":3.000000}";}i:2;a:2:{s:2:"id";s:3:"456";s:5:"json1";s:52:"{"username":"Damon","year":2003,"floatkey":4.440000}";}}}i:69;a:3:{s:8:"sphinxql";s:65:"select *, groupby(), count(*) from test group by gid, j.t1, j.gid";s:10:"total_rows";i:9;s:4:"rows";a:9:{i:0;a:5:{s:2:"id";s:1:"1";s:3:"gid";s:1:"1";s:1:"j";s:26:"{"name":"Alice","uid":123}";s:9:"groupby()";s:20:"-8517097267634966620";s:8:"count(*)";s:1:"1";}i:1;a:5:{s:2:"id";s:1:"2";s:3:"gid";s:1:"1";s:1:"j";s:33:"{"name":"Bob","uid":234,"gid":12}";s:9:"groupby()";s:20:"-2373716570211279320";s:8:"count(*)";s:1:"1";}i:2;a:5:{s:2:"id";s:1:"3";s:3:"gid";s:1:"2";s:1:"j";s:28:"{"name":"Charlie","uid":345}";s:9:"groupby()";s:20:"-1820151046732198393";s:8:"count(*)";s:1:"1";}i:3;a:5:{s:2:"id";s:1:"4";s:3:"gid";s:1:"2";s:1:"j";s:35:"{"name":"Damon","uid":456,"gid":23}";s:9:"groupby()";s:20:"-2396262009976883440";s:8:"count(*)";s:1:"1";}i:4;a:5:{s:2:"id";s:1:"5";s:3:"gid";s:1:"3";s:1:"j";s:19:"{"12":345,"34":567}";s:9:"groupby()";s:20:"-4052466453699787802";s:8:"count(*)";s:1:"8";}i:5;a:5:{s:2:"id";s:1:"8";s:3:"gid";s:1:"3";s:1:"j";s:38:"{"sv":["one","two","three"],"gid":315}";s:9:"groupby()";s:20:"-6831488740572856958";s:8:"count(*)";s:1:"1";}i:6;a:5:{s:2:"id";s:2:"11";s:3:"gid";s:1:"3";s:1:"j";s:98:"{"t1":123456789,"t2":-123456789,"t3":3123456789,"t4":-3123456789,"t5":9876543210,"t6":-9876543210}";s:9:"groupby()";s:20:"-4613611387524301066";s:8:"count(*)";s:1:"1";}i:7;a:5:{s:2:"id";s:2:"12";s:3:"gid";s:1:"3";s:1:"j";s:375:"{"sv":["\nMary had a little lamb, whose fleece was white as snow.\nAnd everywhere that Mary went, the lamb was sure to go.\nIt followed her to school one day which was against the rules.\nIt made the children laugh and play, to see a lamb at school.\nAnd so the teacher turned it out, but still it lingered near.","another world, another time, the age of wonders"],"gid":316}";s:9:"groupby()";s:20:"-3272816110436498139";s:8:"count(*)";s:1:"1";}i:8;a:5:{s:2:"id";s:2:"16";s:3:"gid";s:1:"4";s:1:"j";s:19:"{"nick":"One\nTwo"}";s:9:"groupby()";s:19:"3232700585171816769";s:8:"count(*)";s:1:"3";}}}i:70;a:3:{s:8:"sphinxql";s:40:"select double(json1.year) from json_attr";s:10:"total_rows";i:4;s:4:"rows";a:4:{i:0;a:1:{s:18:"double(json1.year)";s:11:"2000.000000";}i:1;a:1:{s:18:"double(json1.year)";s:11:"2001.000000";}i:2;a:1:{s:18:"double(json1.year)";s:11:"2002.000000";}i:3;a:1:{s:18:"double(json1.year)";s:11:"2003.000000";}}}i:71;a:3:{s:8:"sphinxql";s:44:"select double(json1.floatkey) from json_attr";s:10:"total_rows";i:4;s:4:"rows";a:4:{i:0;a:1:{s:22:"double(json1.floatkey)";s:8:"1.010000";}i:1;a:1:{s:22:"double(json1.floatkey)";s:8:"2.220000";}i:2;a:1:{s:22:"double(json1.floatkey)";s:8:"3.000000";}i:3;a:1:{s:22:"double(json1.floatkey)";s:8:"4.440000";}}}i:72;a:3:{s:8:"sphinxql";s:46:"select sum(integer(json1.year)) from json_attr";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:1:{s:24:"sum(integer(json1.year))";s:4:"8006";}}}i:73;a:3:{s:8:"sphinxql";s:49:"select sum(double(json1.floatkey)) from json_attr";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:1:{s:27:"sum(double(json1.floatkey))";s:9:"10.670000";}}}i:74;a:3:{s:8:"sphinxql";s:49:"select avg(double(json1.floatkey)) from json_attr";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:1:{s:27:"avg(double(json1.floatkey))";s:8:"2.667500";}}}i:75;a:3:{s:8:"sphinxql";s:50:"select avg(integer(json1.floatkey)) from json_attr";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:1:{s:28:"avg(integer(json1.floatkey))";s:8:"2.667500";}}}i:76;a:3:{s:8:"sphinxql";s:49:"select min(bigint(json1.floatkey)) from json_attr";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:1:{s:27:"min(bigint(json1.floatkey))";s:1:"1";}}}i:77;a:3:{s:8:"sphinxql";s:45:"select min(bigint(json1.year)) from json_attr";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:1:{s:23:"min(bigint(json1.year))";s:4:"2000";}}}i:78;a:3:{s:8:"sphinxql";s:49:"select max(double(json1.floatkey)) from json_attr";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:1:{s:27:"max(double(json1.floatkey))";s:8:"4.440000";}}}i:79;a:3:{s:8:"sphinxql";s:50:"select max(integer(json1.floatkey)) from json_attr";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:1:{s:28:"max(integer(json1.floatkey))";s:1:"4";}}}i:80;a:3:{s:8:"sphinxql";s:67:"select double(json1.year) as year from json_attr where year>=2002.0";s:10:"total_rows";i:2;s:4:"rows";a:2:{i:0;a:1:{s:4:"year";s:11:"2002.000000";}i:1;a:1:{s:4:"year";s:11:"2003.000000";}}}i:81;a:3:{s:8:"sphinxql";s:75:"select integer(json1.floatkey) as floatkey from json_attr where floatkey>=2";s:10:"total_rows";i:3;s:4:"rows";a:3:{i:0;a:1:{s:8:"floatkey";s:1:"2";}i:1;a:1:{s:8:"floatkey";s:1:"3";}i:2;a:1:{s:8:"floatkey";s:1:"4";}}}i:82;a:3:{s:8:"sphinxql";s:70:"select * from json_attr where json1.year=2000 and json1.floatkey>=1.01";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:2:{s:2:"id";s:3:"123";s:5:"json1";s:52:"{"username":"Alice","year":2000,"floatkey":1.010000}";}}}i:83;a:3:{s:8:"sphinxql";s:97:"select * from json_attr where json1.year=2000 and json1.floatkey>=1.01 and json1.username='Alice'";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:2:{s:2:"id";s:3:"123";s:5:"json1";s:52:"{"username":"Alice","year":2000,"floatkey":1.010000}";}}}i:84;a:2:{s:8:"sphinxql";s:51:"insert into rt1 (id, title) values (100, 'title1' )";s:14:"total_affected";i:1;}i:85;a:3:{s:8:"sphinxql";s:30:"select * from rt1 where id=100";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:3:{s:2:"id";s:3:"100";s:2:"s1";N;s:2:"j1";N;}}}i:86;a:3:{s:8:"sphinxql";s:66:"select * from json_attr where json1.year>=2001 and json1.year<2003";s:10:"total_rows";i:2;s:4:"rows";a:2:{i:0;a:2:{s:2:"id";s:3:"234";s:5:"json1";s:50:"{"username":"Bob","year":2001,"floatkey":2.220000}";}i:1;a:2:{s:2:"id";s:3:"345";s:5:"json1";s:54:"{"username":"Charlie","year":2002,"floatkey":3.000000}";}}}i:87;a:3:{s:8:"sphinxql";s:68:"select * from json_attr where json1.year>=2001.0 and json1.year<2003";s:10:"total_rows";i:2;s:4:"rows";a:2:{i:0;a:2:{s:2:"id";s:3:"234";s:5:"json1";s:50:"{"username":"Bob","year":2001,"floatkey":2.220000}";}i:1;a:2:{s:2:"id";s:3:"345";s:5:"json1";s:54:"{"username":"Charlie","year":2002,"floatkey":3.000000}";}}}i:88;a:3:{s:8:"sphinxql";s:70:"select * from json_attr where json1.year>=2001.0 and json1.year<2003.0";s:10:"total_rows";i:2;s:4:"rows";a:2:{i:0;a:2:{s:2:"id";s:3:"234";s:5:"json1";s:50:"{"username":"Bob","year":2001,"floatkey":2.220000}";}i:1;a:2:{s:2:"id";s:3:"345";s:5:"json1";s:54:"{"username":"Charlie","year":2002,"floatkey":3.000000}";}}}i:89;a:3:{s:8:"sphinxql";s:76:"select * from json_attr where json1.year>=2000.0001 and json1.year<2003.0001";s:10:"total_rows";i:3;s:4:"rows";a:3:{i:0;a:2:{s:2:"id";s:3:"234";s:5:"json1";s:50:"{"username":"Bob","year":2001,"floatkey":2.220000}";}i:1;a:2:{s:2:"id";s:3:"345";s:5:"json1";s:54:"{"username":"Charlie","year":2002,"floatkey":3.000000}";}i:2;a:2:{s:2:"id";s:3:"456";s:5:"json1";s:52:"{"username":"Damon","year":2003,"floatkey":4.440000}";}}}i:90;a:3:{s:8:"sphinxql";s:80:"select * from json_attr where json1.year>=2000.000001 and json1.year<2003.000001";s:10:"total_rows";i:3;s:4:"rows";a:3:{i:0;a:2:{s:2:"id";s:3:"123";s:5:"json1";s:52:"{"username":"Alice","year":2000,"floatkey":1.010000}";}i:1;a:2:{s:2:"id";s:3:"234";s:5:"json1";s:50:"{"username":"Bob","year":2001,"floatkey":2.220000}";}i:2;a:2:{s:2:"id";s:3:"345";s:5:"json1";s:54:"{"username":"Charlie","year":2002,"floatkey":3.000000}";}}}i:91;a:3:{s:8:"sphinxql";s:51:"select * from dist_str where json1.username='Alice'";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:2:{s:2:"id";s:3:"123";s:5:"json1";s:52:"{"username":"Alice","year":2000,"floatkey":1.010000}";}}}i:92;a:3:{s:8:"sphinxql";s:51:"select * from dist_str where json1.username='Damon'";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:2:{s:2:"id";s:3:"456";s:5:"json1";s:52:"{"username":"Damon","year":2003,"floatkey":4.440000}";}}}i:93;a:3:{s:8:"sphinxql";s:42:"select * from test where j.nick='One\nTwo'";s:10:"total_rows";i:3;s:4:"rows";a:3:{i:0;a:3:{s:2:"id";s:2:"16";s:3:"gid";s:1:"4";s:1:"j";s:19:"{"nick":"One\nTwo"}";}i:1;a:3:{s:2:"id";s:2:"17";s:3:"gid";s:1:"4";s:1:"j";s:19:"{"nick":"One\nTwo"}";}i:2;a:3:{s:2:"id";s:2:"18";s:3:"gid";s:1:"4";s:1:"j";s:19:"{"nick":"One\nTwo"}";}}}i:94;a:2:{s:8:"sphinxql";s:42:"select * from test where j.nick='one\ntwo'";s:10:"total_rows";i:0;}i:95;a:3:{s:8:"sphinxql";s:41:"select * from test where j.nick='One
Two'";s:10:"total_rows";i:3;s:4:"rows";a:3:{i:0;a:3:{s:2:"id";s:2:"16";s:3:"gid";s:1:"4";s:1:"j";s:19:"{"nick":"One\nTwo"}";}i:1;a:3:{s:2:"id";s:2:"17";s:3:"gid";s:1:"4";s:1:"j";s:19:"{"nick":"One\nTwo"}";}i:2;a:3:{s:2:"id";s:2:"18";s:3:"gid";s:1:"4";s:1:"j";s:19:"{"nick":"One\nTwo"}";}}}i:96;a:3:{s:8:"sphinxql";s:20:"select * from arrays";s:10:"total_rows";i:4;s:4:"rows";a:4:{i:0;a:2:{s:2:"id";s:3:"123";s:1:"j";s:36:"{"a":[1,2,3,4],"t":["t1","t2","t3"]}";}i:1;a:2:{s:2:"id";s:3:"234";s:1:"j";s:36:"{"a":[2,3,4,5],"t":["t2","t3","t4"]}";}i:2;a:2:{s:2:"id";s:3:"345";s:1:"j";s:36:"{"a":[3,4,5,1],"t":["t3","t4","t5"]}";}i:3;a:2:{s:2:"id";s:3:"456";s:1:"j";s:36:"{"a":[4,5,6,2],"t":["t4","t5","t6"]}";}}}i:97;a:3:{s:8:"sphinxql";s:25:"select j.a[0] from arrays";s:10:"total_rows";i:4;s:4:"rows";a:4:{i:0;a:1:{s:6:"j.a[0]";s:1:"1";}i:1;a:1:{s:6:"j.a[0]";s:1:"2";}i:2;a:1:{s:6:"j.a[0]";s:1:"3";}i:3;a:1:{s:6:"j.a[0]";s:1:"4";}}}i:98;a:3:{s:8:"sphinxql";s:40:"select j.a[2] from arrays where j.a[2]>2";s:10:"total_rows";i:4;s:4:"rows";a:4:{i:0;a:1:{s:6:"j.a[2]";s:1:"3";}i:1;a:1:{s:6:"j.a[2]";s:1:"4";}i:2;a:1:{s:6:"j.a[2]";s:1:"5";}i:3;a:1:{s:6:"j.a[2]";s:1:"6";}}}i:99;a:3:{s:8:"sphinxql";s:46:"select j.a[2] from arrays order by j.a[2] desc";s:10:"total_rows";i:4;s:4:"rows";a:4:{i:0;a:1:{s:6:"j.a[2]";s:1:"6";}i:1;a:1:{s:6:"j.a[2]";s:1:"5";}i:2;a:1:{s:6:"j.a[2]";s:1:"4";}i:3;a:1:{s:6:"j.a[2]";s:1:"3";}}}i:100;a:3:{s:8:"sphinxql";s:45:"select in(j.a,4,6) as p from arrays where p=1";s:10:"total_rows";i:4;s:4:"rows";a:4:{i:0;a:1:{s:1:"p";s:1:"1";}i:1;a:1:{s:1:"p";s:1:"1";}i:2;a:1:{s:1:"p";s:1:"1";}i:3;a:1:{s:1:"p";s:1:"1";}}}i:101;a:3:{s:8:"sphinxql";s:25:"select j.t[2] from arrays";s:10:"total_rows";i:4;s:4:"rows";a:4:{i:0;a:1:{s:6:"j.t[2]";s:2:"t3";}i:1;a:1:{s:6:"j.t[2]";s:2:"t4";}i:2;a:1:{s:6:"j.t[2]";s:2:"t5";}i:3;a:1:{s:6:"j.t[2]";s:2:"t6";}}}i:102;a:3:{s:8:"sphinxql";s:43:"select j.t[2] from arrays where j.t[2]='t3'";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:1:{s:6:"j.t[2]";s:2:"t3";}}}i:103;a:3:{s:8:"sphinxql";s:46:"select j.t[2] from arrays order by j.t[2] desc";s:10:"total_rows";i:4;s:4:"rows";a:4:{i:0;a:1:{s:6:"j.t[2]";s:2:"t6";}i:1;a:1:{s:6:"j.t[2]";s:2:"t5";}i:2;a:1:{s:6:"j.t[2]";s:2:"t4";}i:3;a:1:{s:6:"j.t[2]";s:2:"t3";}}}i:104;a:3:{s:8:"sphinxql";s:56:"select j.t, in(j.t,'t4','t6') as p from arrays where p=1";s:10:"total_rows";i:3;s:4:"rows";a:3:{i:0;a:2:{s:3:"j.t";s:16:"["t2","t3","t4"]";s:1:"p";s:1:"1";}i:1;a:2:{s:3:"j.t";s:16:"["t3","t4","t5"]";s:1:"p";s:1:"1";}i:2;a:2:{s:3:"j.t";s:16:"["t4","t5","t6"]";s:1:"p";s:1:"1";}}}i:105;a:3:{s:8:"sphinxql";s:51:"select j.a[-1], j.t[-1], j.a[5], j.t[5] from arrays";s:10:"total_rows";i:4;s:4:"rows";a:4:{i:0;a:4:{s:7:"j.a[-1]";N;s:7:"j.t[-1]";N;s:6:"j.a[5]";N;s:6:"j.t[5]";N;}i:1;a:4:{s:7:"j.a[-1]";N;s:7:"j.t[-1]";N;s:6:"j.a[5]";N;s:6:"j.t[5]";N;}i:2;a:4:{s:7:"j.a[-1]";N;s:7:"j.t[-1]";N;s:6:"j.a[5]";N;s:6:"j.t[5]";N;}i:3;a:4:{s:7:"j.a[-1]";N;s:7:"j.t[-1]";N;s:6:"j.a[5]";N;s:6:"j.t[5]";N;}}}i:106;a:3:{s:8:"sphinxql";s:71:"select least(j.a), greatest(j.a), least(j.t), greatest(j.t) from arrays";s:10:"total_rows";i:4;s:4:"rows";a:4:{i:0;a:4:{s:10:"least(j.a)";s:1:"1";s:13:"greatest(j.a)";s:1:"4";s:10:"least(j.t)";s:2:"t1";s:13:"greatest(j.t)";s:2:"t3";}i:1;a:4:{s:10:"least(j.a)";s:1:"2";s:13:"greatest(j.a)";s:1:"5";s:10:"least(j.t)";s:2:"t2";s:13:"greatest(j.t)";s:2:"t4";}i:2;a:4:{s:10:"least(j.a)";s:1:"1";s:13:"greatest(j.a)";s:1:"5";s:10:"least(j.t)";s:2:"t3";s:13:"greatest(j.t)";s:2:"t5";}i:3;a:4:{s:10:"least(j.a)";s:1:"2";s:13:"greatest(j.a)";s:1:"6";s:10:"least(j.t)";s:2:"t4";s:13:"greatest(j.t)";s:2:"t6";}}}i:107;a:3:{s:8:"sphinxql";s:21:"select j from objects";s:10:"total_rows";i:14;s:4:"rows";a:14:{i:0;a:1:{s:1:"j";s:24:"[6,[6,[6,[6,6.000000]]]]";}i:1;a:1:{s:1:"j";s:52:"[1,2,3.000000,1000000000000,["a","b","c"],{"a":"b"}]";}i:2;a:1:{s:1:"j";s:29:"{"a":"tag","b":"another tag"}";}i:3;a:1:{s:1:"j";s:21:"[1,2,3,[4,5,6,[7,8]]]";}i:4;a:1:{s:1:"j";s:22:"{"MixedCase":"passed"}";}i:5;a:1:{s:1:"j";s:51:"[1,2,3,[4,5,[6]],7,8,{"a":"b"},{},[6,6,6.000000,6]]";}i:6;a:1:{s:1:"j";s:76:"[1,"x",{"y":3,"assoc":{"a1":6,"a2":5,"a3":"tag1","a4":{"b1":1,"b2":2}}},123]";}i:7;a:1:{s:1:"j";s:29:"{"a":{"c":"d"},"b":"c","e":6}";}i:8;a:1:{s:1:"j";s:25:"[false,true,null,"15øC"]";}i:9;a:1:{s:1:"j";s:34:"{"key1":{"key2":{"key3":"value"}}}";}i:10;a:1:{s:1:"j";s:28:"{"1234":1,"123":2,"1234a":3}";}i:11;a:1:{s:1:"j";s:2:"{}";}i:12;a:1:{s:1:"j";s:2:"[]";}i:13;a:1:{s:1:"j";N;}}}i:108;a:3:{s:8:"sphinxql";s:47:"select j[0] from objects where j[0] is not null";s:10:"total_rows";i:6;s:4:"rows";a:6:{i:0;a:1:{s:4:"j[0]";s:1:"6";}i:1;a:1:{s:4:"j[0]";s:1:"1";}i:2;a:1:{s:4:"j[0]";s:1:"1";}i:3;a:1:{s:4:"j[0]";s:1:"1";}i:4;a:1:{s:4:"j[0]";s:1:"1";}i:5;a:1:{s:4:"j[0]";s:1:"0";}}}i:109;a:3:{s:8:"sphinxql";s:47:"select j[1] from objects where j[1] is not null";s:10:"total_rows";i:6;s:4:"rows";a:6:{i:0;a:1:{s:4:"j[1]";s:20:"[6,[6,[6,6.000000]]]";}i:1;a:1:{s:4:"j[1]";s:1:"2";}i:2;a:1:{s:4:"j[1]";s:1:"2";}i:3;a:1:{s:4:"j[1]";s:1:"2";}i:4;a:1:{s:4:"j[1]";s:1:"x";}i:5;a:1:{s:4:"j[1]";s:1:"1";}}}i:110;a:3:{s:8:"sphinxql";s:47:"select j[2] from objects where j[2] is not null";s:10:"total_rows";i:4;s:4:"rows";a:4:{i:0;a:1:{s:4:"j[2]";s:8:"3.000000";}i:1;a:1:{s:4:"j[2]";s:1:"3";}i:2;a:1:{s:4:"j[2]";s:1:"3";}i:3;a:1:{s:4:"j[2]";s:64:"{"y":3,"assoc":{"a1":6,"a2":5,"a3":"tag1","a4":{"b1":1,"b2":2}}}";}}}i:111;a:3:{s:8:"sphinxql";s:71:"select j[2]['assoc'].a4 from objects where j[2]['assoc'].a4 is not null";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:1:{s:16:"j[2]['assoc'].a4";s:15:"{"b1":1,"b2":2}";}}}i:112;a:3:{s:8:"sphinxql";s:80:"select j['MixedCase'], j['mixedcase'] from objects where j.MixedCase is not null";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:2:{s:14:"j['MixedCase']";s:6:"passed";s:14:"j['mixedcase']";N;}}}i:113;a:3:{s:8:"sphinxql";s:65:"select j[1][1][1][1] from objects where j[1][1][1][1] is not null";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:1:{s:13:"j[1][1][1][1]";s:8:"6.000000";}}}i:114;a:3:{s:8:"sphinxql";s:55:"select j.a[j.b] from objects where j.a[j.b] is not null";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:1:{s:8:"j.a[j.b]";s:1:"d";}}}i:115;a:3:{s:8:"sphinxql";s:49:"select j[id] from objects where j[id] is not null";s:10:"total_rows";i:3;s:4:"rows";a:3:{i:0;a:1:{s:5:"j[id]";s:20:"[6,[6,[6,6.000000]]]";}i:1;a:1:{s:5:"j[id]";s:8:"3.000000";}i:2;a:1:{s:5:"j[id]";s:9:"{"a":"b"}";}}}i:116;a:3:{s:8:"sphinxql";s:57:"select j[2*id-3] from objects where j[2*id-3] is not null";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:1:{s:9:"j[2*id-3]";s:1:"2";}}}i:117;a:3:{s:8:"sphinxql";s:36:"select j.a from objects group by j.a";s:10:"total_rows";i:3;s:4:"rows";a:3:{i:0;a:1:{s:3:"j.a";N;}i:1;a:1:{s:3:"j.a";s:3:"tag";}i:2;a:1:{s:3:"j.a";s:9:"{"c":"d"}";}}}i:118;a:3:{s:8:"sphinxql";s:38:"select j[0] from objects group by j[0]";s:10:"total_rows";i:3;s:4:"rows";a:3:{i:0;a:1:{s:4:"j[0]";s:1:"6";}i:1;a:1:{s:4:"j[0]";s:1:"1";}i:2;a:1:{s:4:"j[0]";N;}}}i:119;a:3:{s:8:"sphinxql";s:38:"select j[1] from objects group by j[1]";s:10:"total_rows";i:4;s:4:"rows";a:4:{i:0;a:1:{s:4:"j[1]";s:20:"[6,[6,[6,6.000000]]]";}i:1;a:1:{s:4:"j[1]";s:1:"2";}i:2;a:1:{s:4:"j[1]";N;}i:3;a:1:{s:4:"j[1]";s:1:"x";}}}i:120;a:3:{s:8:"sphinxql";s:45:"select j, in(j,6) as p from objects where p=1";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:2:{s:1:"j";s:24:"[6,[6,[6,[6,6.000000]]]]";s:1:"p";s:1:"1";}}}i:121;a:3:{s:8:"sphinxql";s:53:"select j.a, in(j.a,'tag') as p from objects where p=1";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:2:{s:3:"j.a";s:3:"tag";s:1:"p";s:1:"1";}}}i:122;a:3:{s:8:"sphinxql";s:53:"select j[0], in(j[0],1,2) as p from objects where p=1";s:10:"total_rows";i:4;s:4:"rows";a:4:{i:0;a:2:{s:4:"j[0]";s:1:"1";s:1:"p";s:1:"1";}i:1;a:2:{s:4:"j[0]";s:1:"1";s:1:"p";s:1:"1";}i:2;a:2:{s:4:"j[0]";s:1:"1";s:1:"p";s:1:"1";}i:3;a:2:{s:4:"j[0]";s:1:"1";s:1:"p";s:1:"1";}}}i:123;a:3:{s:8:"sphinxql";s:53:"select j[2], in(j[2],2,3) as p from objects where p=1";s:10:"total_rows";i:2;s:4:"rows";a:2:{i:0;a:2:{s:4:"j[2]";s:1:"3";s:1:"p";s:1:"1";}i:1;a:2:{s:4:"j[2]";s:1:"3";s:1:"p";s:1:"1";}}}i:124;a:3:{s:8:"sphinxql";s:57:"select j[3][3], in(j[3][3],7) as p from objects where p=1";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:2:{s:7:"j[3][3]";s:5:"[7,8]";s:1:"p";s:1:"1";}}}i:125;a:3:{s:8:"sphinxql";s:71:"select j.1234, j.123, .1234, .123 from objects where j.1234 is not null";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:4:{s:6:"j.1234";s:1:"1";s:5:"j.123";s:1:"2";s:5:".1234";s:8:"0.123400";s:4:".123";s:8:"0.123000";}}}i:126;a:3:{s:8:"sphinxql";s:61:"select j.1234, j.1234a from objects where j.1234a is not null";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:2:{s:6:"j.1234";s:1:"1";s:7:"j.1234a";s:1:"3";}}}i:127;a:3:{s:8:"sphinxql";s:37:"select j 0.1234 as error from objects";s:5:"error";s:105:"sphinxql: syntax error, unexpected CONST_FLOAT, expecting FROM or ',' near '0.1234 as error from objects'";s:5:"errno";i:1064;}i:128;a:3:{s:8:"sphinxql";s:41:"select j from objects where j is not null";s:10:"total_rows";i:13;s:4:"rows";a:13:{i:0;a:1:{s:1:"j";s:24:"[6,[6,[6,[6,6.000000]]]]";}i:1;a:1:{s:1:"j";s:52:"[1,2,3.000000,1000000000000,["a","b","c"],{"a":"b"}]";}i:2;a:1:{s:1:"j";s:29:"{"a":"tag","b":"another tag"}";}i:3;a:1:{s:1:"j";s:21:"[1,2,3,[4,5,6,[7,8]]]";}i:4;a:1:{s:1:"j";s:22:"{"MixedCase":"passed"}";}i:5;a:1:{s:1:"j";s:51:"[1,2,3,[4,5,[6]],7,8,{"a":"b"},{},[6,6,6.000000,6]]";}i:6;a:1:{s:1:"j";s:76:"[1,"x",{"y":3,"assoc":{"a1":6,"a2":5,"a3":"tag1","a4":{"b1":1,"b2":2}}},123]";}i:7;a:1:{s:1:"j";s:29:"{"a":{"c":"d"},"b":"c","e":6}";}i:8;a:1:{s:1:"j";s:25:"[false,true,null,"15øC"]";}i:9;a:1:{s:1:"j";s:34:"{"key1":{"key2":{"key3":"value"}}}";}i:10;a:1:{s:1:"j";s:28:"{"1234":1,"123":2,"1234a":3}";}i:11;a:1:{s:1:"j";s:2:"{}";}i:12;a:1:{s:1:"j";s:2:"[]";}}}i:129;a:3:{s:8:"sphinxql";s:46:"select j as p from objects where p is not null";s:10:"total_rows";i:12;s:4:"rows";a:12:{i:0;a:1:{s:1:"p";s:24:"[6,[6,[6,[6,6.000000]]]]";}i:1;a:1:{s:1:"p";s:52:"[1,2,3.000000,1000000000000,["a","b","c"],{"a":"b"}]";}i:2;a:1:{s:1:"p";s:29:"{"a":"tag","b":"another tag"}";}i:3;a:1:{s:1:"p";s:21:"[1,2,3,[4,5,6,[7,8]]]";}i:4;a:1:{s:1:"p";s:22:"{"MixedCase":"passed"}";}i:5;a:1:{s:1:"p";s:51:"[1,2,3,[4,5,[6]],7,8,{"a":"b"},{},[6,6,6.000000,6]]";}i:6;a:1:{s:1:"p";s:76:"[1,"x",{"y":3,"assoc":{"a1":6,"a2":5,"a3":"tag1","a4":{"b1":1,"b2":2}}},123]";}i:7;a:1:{s:1:"p";s:29:"{"a":{"c":"d"},"b":"c","e":6}";}i:8;a:1:{s:1:"p";s:25:"[false,true,null,"15øC"]";}i:9;a:1:{s:1:"p";s:34:"{"key1":{"key2":{"key3":"value"}}}";}i:10;a:1:{s:1:"p";s:28:"{"1234":1,"123":2,"1234a":3}";}i:11;a:1:{s:1:"p";s:2:"[]";}}}i:130;a:3:{s:8:"sphinxql";s:61:"select j[2]['assoc'].a4 as p from objects where p is not null";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:1:{s:1:"p";s:15:"{"b1":1,"b2":2}";}}}i:131;a:3:{s:8:"sphinxql";s:29:"select length(j) from objects";s:10:"total_rows";i:14;s:4:"rows";a:14:{i:0;a:1:{s:9:"length(j)";s:1:"2";}i:1;a:1:{s:9:"length(j)";s:1:"6";}i:2;a:1:{s:9:"length(j)";s:1:"2";}i:3;a:1:{s:9:"length(j)";s:1:"4";}i:4;a:1:{s:9:"length(j)";s:1:"1";}i:5;a:1:{s:9:"length(j)";s:1:"9";}i:6;a:1:{s:9:"length(j)";s:1:"4";}i:7;a:1:{s:9:"length(j)";s:1:"3";}i:8;a:1:{s:9:"length(j)";s:1:"4";}i:9;a:1:{s:9:"length(j)";s:1:"1";}i:10;a:1:{s:9:"length(j)";s:1:"3";}i:11;a:1:{s:9:"length(j)";s:1:"0";}i:12;a:1:{s:9:"length(j)";s:1:"0";}i:13;a:1:{s:9:"length(j)";s:1:"0";}}}i:132;a:3:{s:8:"sphinxql";s:32:"select length(j[0]) from objects";s:10:"total_rows";i:14;s:4:"rows";a:14:{i:0;a:1:{s:12:"length(j[0])";s:1:"1";}i:1;a:1:{s:12:"length(j[0])";s:1:"1";}i:2;a:1:{s:12:"length(j[0])";s:1:"0";}i:3;a:1:{s:12:"length(j[0])";s:1:"1";}i:4;a:1:{s:12:"length(j[0])";s:1:"0";}i:5;a:1:{s:12:"length(j[0])";s:1:"1";}i:6;a:1:{s:12:"length(j[0])";s:1:"1";}i:7;a:1:{s:12:"length(j[0])";s:1:"0";}i:8;a:1:{s:12:"length(j[0])";s:1:"0";}i:9;a:1:{s:12:"length(j[0])";s:1:"0";}i:10;a:1:{s:12:"length(j[0])";s:1:"0";}i:11;a:1:{s:12:"length(j[0])";s:1:"0";}i:12;a:1:{s:12:"length(j[0])";s:1:"0";}i:13;a:1:{s:12:"length(j[0])";s:1:"0";}}}i:133;a:3:{s:8:"sphinxql";s:31:"select length(j.a) from objects";s:10:"total_rows";i:14;s:4:"rows";a:14:{i:0;a:1:{s:11:"length(j.a)";s:1:"0";}i:1;a:1:{s:11:"length(j.a)";s:1:"0";}i:2;a:1:{s:11:"length(j.a)";s:1:"0";}i:3;a:1:{s:11:"length(j.a)";s:1:"0";}i:4;a:1:{s:11:"length(j.a)";s:1:"0";}i:5;a:1:{s:11:"length(j.a)";s:1:"0";}i:6;a:1:{s:11:"length(j.a)";s:1:"0";}i:7;a:1:{s:11:"length(j.a)";s:1:"1";}i:8;a:1:{s:11:"length(j.a)";s:1:"0";}i:9;a:1:{s:11:"length(j.a)";s:1:"0";}i:10;a:1:{s:11:"length(j.a)";s:1:"0";}i:11;a:1:{s:11:"length(j.a)";s:1:"0";}i:12;a:1:{s:11:"length(j.a)";s:1:"0";}i:13;a:1:{s:11:"length(j.a)";s:1:"0";}}}i:134;a:2:{s:8:"sphinxql";s:70:"select j.str from dist_case where j.str is not null order by j.str asc";s:10:"total_rows";i:0;}i:135;a:3:{s:8:"sphinxql";s:70:"select j.Str from dist_case where j.Str is not null order by j.Str asc";s:10:"total_rows";i:5;s:4:"rows";a:5:{i:0;a:1:{s:5:"j.Str";s:4:"nope";}i:1;a:1:{s:5:"j.Str";s:4:"nope";}i:2;a:1:{s:5:"j.Str";s:4:"nope";}i:3;a:1:{s:5:"j.Str";s:6:"nope11";}i:4;a:1:{s:5:"j.Str";s:6:"nope11";}}}i:136;a:3:{s:8:"sphinxql";s:70:"select j.STR from dist_case where j.STR is not null order by j.STR asc";s:10:"total_rows";i:5;s:4:"rows";a:5:{i:0;a:1:{s:5:"j.STR";s:3:"yep";}i:1;a:1:{s:5:"j.STR";s:3:"yep";}i:2;a:1:{s:5:"j.STR";s:3:"yep";}i:3;a:1:{s:5:"j.STR";s:4:"yep2";}i:4;a:1:{s:5:"j.STR";s:4:"yep2";}}}i:137;a:3:{s:8:"sphinxql";s:67:"select j.Str as p from json_case where p is not null order by p asc";s:10:"total_rows";i:5;s:4:"rows";a:5:{i:0;a:1:{s:1:"p";s:4:"nope";}i:1;a:1:{s:1:"p";s:4:"nope";}i:2;a:1:{s:1:"p";s:4:"nope";}i:3;a:1:{s:1:"p";s:6:"nope11";}i:4;a:1:{s:1:"p";s:6:"nope11";}}}i:138;a:3:{s:8:"sphinxql";s:68:"select j.Str as p from json_case where p is not null order by p desc";s:10:"total_rows";i:5;s:4:"rows";a:5:{i:0;a:1:{s:1:"p";s:6:"nope11";}i:1;a:1:{s:1:"p";s:6:"nope11";}i:2;a:1:{s:1:"p";s:4:"nope";}i:3;a:1:{s:1:"p";s:4:"nope";}i:4;a:1:{s:1:"p";s:4:"nope";}}}i:139;a:3:{s:8:"sphinxql";s:67:"select j.Str as p from dist_case where p is not null order by p asc";s:10:"total_rows";i:5;s:4:"rows";a:5:{i:0;a:1:{s:1:"p";s:4:"nope";}i:1;a:1:{s:1:"p";s:4:"nope";}i:2;a:1:{s:1:"p";s:4:"nope";}i:3;a:1:{s:1:"p";s:6:"nope11";}i:4;a:1:{s:1:"p";s:6:"nope11";}}}i:140;a:3:{s:8:"sphinxql";s:68:"select j.Str as p from dist_case where p is not null order by p desc";s:10:"total_rows";i:5;s:4:"rows";a:5:{i:0;a:1:{s:1:"p";s:6:"nope11";}i:1;a:1:{s:1:"p";s:6:"nope11";}i:2;a:1:{s:1:"p";s:4:"nope";}i:3;a:1:{s:1:"p";s:4:"nope";}i:4;a:1:{s:1:"p";s:4:"nope";}}}i:141;a:2:{s:8:"sphinxql";s:43:"update json_inplace set j.a[0]=5 where id=1";s:14:"total_affected";i:1;}i:142;a:3:{s:8:"sphinxql";s:26:"select * from json_inplace";s:10:"total_rows";i:4;s:4:"rows";a:4:{i:0;a:3:{s:2:"id";s:1:"1";s:3:"gid";s:1:"1";s:1:"j";s:48:"{"a":[5,2,3,4],"f":[1.000000,3.000000,2.000000]}";}i:1;a:3:{s:2:"id";s:1:"2";s:3:"gid";s:1:"1";s:1:"j";s:48:"{"a":[2,3,4,5],"f":[2.000000,4.000000,3.000000]}";}i:2;a:3:{s:2:"id";s:1:"3";s:3:"gid";s:1:"2";s:1:"j";s:23:"{"a":"tag1","b":"tag2"}";}i:3;a:3:{s:2:"id";s:1:"4";s:3:"gid";s:1:"3";s:1:"j";s:13:"{"a":1,"c":2}";}}}i:143;a:2:{s:8:"sphinxql";s:68:"update json_inplace set j.a[0]=10.0, j.f[1]=3.1415926535 where gid=1";s:14:"total_affected";i:2;}i:144;a:3:{s:8:"sphinxql";s:26:"select * from json_inplace";s:10:"total_rows";i:4;s:4:"rows";a:4:{i:0;a:3:{s:2:"id";s:1:"1";s:3:"gid";s:1:"1";s:1:"j";s:49:"{"a":[10,2,3,4],"f":[1.000000,3.141593,2.000000]}";}i:1;a:3:{s:2:"id";s:1:"2";s:3:"gid";s:1:"1";s:1:"j";s:49:"{"a":[10,3,4,5],"f":[2.000000,3.141593,3.000000]}";}i:2;a:3:{s:2:"id";s:1:"3";s:3:"gid";s:1:"2";s:1:"j";s:23:"{"a":"tag1","b":"tag2"}";}i:3;a:3:{s:2:"id";s:1:"4";s:3:"gid";s:1:"3";s:1:"j";s:13:"{"a":1,"c":2}";}}}i:145;a:2:{s:8:"sphinxql";s:44:"update json_inplace set j.a[0]=-5 where id=1";s:14:"total_affected";i:1;}i:146;a:3:{s:8:"sphinxql";s:26:"select * from json_inplace";s:10:"total_rows";i:4;s:4:"rows";a:4:{i:0;a:3:{s:2:"id";s:1:"1";s:3:"gid";s:1:"1";s:1:"j";s:49:"{"a":[-5,2,3,4],"f":[1.000000,3.141593,2.000000]}";}i:1;a:3:{s:2:"id";s:1:"2";s:3:"gid";s:1:"1";s:1:"j";s:49:"{"a":[10,3,4,5],"f":[2.000000,3.141593,3.000000]}";}i:2;a:3:{s:2:"id";s:1:"3";s:3:"gid";s:1:"2";s:1:"j";s:23:"{"a":"tag1","b":"tag2"}";}i:3;a:3:{s:2:"id";s:1:"4";s:3:"gid";s:1:"3";s:1:"j";s:13:"{"a":1,"c":2}";}}}i:147;a:2:{s:8:"sphinxql";s:46:"update json_inplace set j.a[1]=-15 where gid>0";s:14:"total_affected";i:2;}i:148;a:3:{s:8:"sphinxql";s:26:"select * from json_inplace";s:10:"total_rows";i:4;s:4:"rows";a:4:{i:0;a:3:{s:2:"id";s:1:"1";s:3:"gid";s:1:"1";s:1:"j";s:51:"{"a":[-5,-15,3,4],"f":[1.000000,3.141593,2.000000]}";}i:1;a:3:{s:2:"id";s:1:"2";s:3:"gid";s:1:"1";s:1:"j";s:51:"{"a":[10,-15,4,5],"f":[2.000000,3.141593,3.000000]}";}i:2;a:3:{s:2:"id";s:1:"3";s:3:"gid";s:1:"2";s:1:"j";s:23:"{"a":"tag1","b":"tag2"}";}i:3;a:3:{s:2:"id";s:1:"4";s:3:"gid";s:1:"3";s:1:"j";s:13:"{"a":1,"c":2}";}}}i:149;a:2:{s:8:"sphinxql";s:62:"update json_inplace set j.a[1]=-20 where gid=1 option strict=1";s:14:"total_affected";i:2;}i:150;a:3:{s:8:"sphinxql";s:26:"select * from json_inplace";s:10:"total_rows";i:4;s:4:"rows";a:4:{i:0;a:3:{s:2:"id";s:1:"1";s:3:"gid";s:1:"1";s:1:"j";s:51:"{"a":[-5,-20,3,4],"f":[1.000000,3.141593,2.000000]}";}i:1;a:3:{s:2:"id";s:1:"2";s:3:"gid";s:1:"1";s:1:"j";s:51:"{"a":[10,-20,4,5],"f":[2.000000,3.141593,3.000000]}";}i:2;a:3:{s:2:"id";s:1:"3";s:3:"gid";s:1:"2";s:1:"j";s:23:"{"a":"tag1","b":"tag2"}";}i:3;a:3:{s:2:"id";s:1:"4";s:3:"gid";s:1:"3";s:1:"j";s:13:"{"a":1,"c":2}";}}}i:151;a:3:{s:8:"sphinxql";s:62:"update json_inplace set j.a[1]=-30 where gid>0 option strict=1";s:5:"error";s:91:"index json_inplace: attribute 'j.a[1]' can not be updated (not found or incompatible types)";s:5:"errno";i:1064;}i:152;a:3:{s:8:"sphinxql";s:26:"select * from json_inplace";s:10:"total_rows";i:4;s:4:"rows";a:4:{i:0;a:3:{s:2:"id";s:1:"1";s:3:"gid";s:1:"1";s:1:"j";s:51:"{"a":[-5,-20,3,4],"f":[1.000000,3.141593,2.000000]}";}i:1;a:3:{s:2:"id";s:1:"2";s:3:"gid";s:1:"1";s:1:"j";s:51:"{"a":[10,-20,4,5],"f":[2.000000,3.141593,3.000000]}";}i:2;a:3:{s:2:"id";s:1:"3";s:3:"gid";s:1:"2";s:1:"j";s:23:"{"a":"tag1","b":"tag2"}";}i:3;a:3:{s:2:"id";s:1:"4";s:3:"gid";s:1:"3";s:1:"j";s:13:"{"a":1,"c":2}";}}}i:153;a:2:{s:8:"sphinxql";s:58:"update json_inplace set j.a=5, j.c=5, j.a[0]=5 where gid>0";s:14:"total_affected";i:3;}i:154;a:3:{s:8:"sphinxql";s:26:"select * from json_inplace";s:10:"total_rows";i:4;s:4:"rows";a:4:{i:0;a:3:{s:2:"id";s:1:"1";s:3:"gid";s:1:"1";s:1:"j";s:50:"{"a":[5,-20,3,4],"f":[1.000000,3.141593,2.000000]}";}i:1;a:3:{s:2:"id";s:1:"2";s:3:"gid";s:1:"1";s:1:"j";s:50:"{"a":[5,-20,4,5],"f":[2.000000,3.141593,3.000000]}";}i:2;a:3:{s:2:"id";s:1:"3";s:3:"gid";s:1:"2";s:1:"j";s:23:"{"a":"tag1","b":"tag2"}";}i:3;a:3:{s:2:"id";s:1:"4";s:3:"gid";s:1:"3";s:1:"j";s:13:"{"a":5,"c":5}";}}}i:155;a:3:{s:8:"sphinxql";s:77:"update json_inplace set j.a=10, j.c=10, j.a[0]=10 where gid>0 option strict=1";s:5:"error";s:88:"index json_inplace: attribute 'j.a' can not be updated (not found or incompatible types)";s:5:"errno";i:1064;}i:156;a:3:{s:8:"sphinxql";s:26:"select * from json_inplace";s:10:"total_rows";i:4;s:4:"rows";a:4:{i:0;a:3:{s:2:"id";s:1:"1";s:3:"gid";s:1:"1";s:1:"j";s:50:"{"a":[5,-20,3,4],"f":[1.000000,3.141593,2.000000]}";}i:1;a:3:{s:2:"id";s:1:"2";s:3:"gid";s:1:"1";s:1:"j";s:50:"{"a":[5,-20,4,5],"f":[2.000000,3.141593,3.000000]}";}i:2;a:3:{s:2:"id";s:1:"3";s:3:"gid";s:1:"2";s:1:"j";s:23:"{"a":"tag1","b":"tag2"}";}i:3;a:3:{s:2:"id";s:1:"4";s:3:"gid";s:1:"3";s:1:"j";s:13:"{"a":5,"c":5}";}}}i:157;a:2:{s:8:"sphinxql";s:66:"update json_inplace set j.a=15, j.c=15 where gid=3 option strict=1";s:14:"total_affected";i:1;}i:158;a:3:{s:8:"sphinxql";s:26:"select * from json_inplace";s:10:"total_rows";i:4;s:4:"rows";a:4:{i:0;a:3:{s:2:"id";s:1:"1";s:3:"gid";s:1:"1";s:1:"j";s:50:"{"a":[5,-20,3,4],"f":[1.000000,3.141593,2.000000]}";}i:1;a:3:{s:2:"id";s:1:"2";s:3:"gid";s:1:"1";s:1:"j";s:50:"{"a":[5,-20,4,5],"f":[2.000000,3.141593,3.000000]}";}i:2;a:3:{s:2:"id";s:1:"3";s:3:"gid";s:1:"2";s:1:"j";s:23:"{"a":"tag1","b":"tag2"}";}i:3;a:3:{s:2:"id";s:1:"4";s:3:"gid";s:1:"3";s:1:"j";s:15:"{"a":15,"c":15}";}}}i:159;a:2:{s:8:"sphinxql";s:212:"insert into json_inplace_rt (id, gid, title, j) values
( 1,1,'','{"a":[1,2,3,4],"f":[1.0,3.0,2.0]}'),
( 2,1,'','{"a":[2,3,4,5],"f":[2.0,4.0,3.0]}'),
( 3,2,'','{"a":"tag1","b":"tag2"}'),
( 4,3,'','{"a":1,"c":2}')
";s:14:"total_affected";i:4;}i:160;a:2:{s:8:"sphinxql";s:46:"update json_inplace_rt set j.a[0]=5 where id=1";s:14:"total_affected";i:1;}i:161;a:3:{s:8:"sphinxql";s:29:"select * from json_inplace_rt";s:10:"total_rows";i:4;s:4:"rows";a:4:{i:0;a:3:{s:2:"id";s:1:"1";s:3:"gid";s:1:"1";s:1:"j";s:48:"{"a":[5,2,3,4],"f":[1.000000,3.000000,2.000000]}";}i:1;a:3:{s:2:"id";s:1:"2";s:3:"gid";s:1:"1";s:1:"j";s:48:"{"a":[2,3,4,5],"f":[2.000000,4.000000,3.000000]}";}i:2;a:3:{s:2:"id";s:1:"3";s:3:"gid";s:1:"2";s:1:"j";s:23:"{"a":"tag1","b":"tag2"}";}i:3;a:3:{s:2:"id";s:1:"4";s:3:"gid";s:1:"3";s:1:"j";s:13:"{"a":1,"c":2}";}}}i:162;a:2:{s:8:"sphinxql";s:71:"update json_inplace_rt set j.a[0]=10.0, j.f[1]=3.1415926535 where gid=1";s:14:"total_affected";i:2;}i:163;a:3:{s:8:"sphinxql";s:29:"select * from json_inplace_rt";s:10:"total_rows";i:4;s:4:"rows";a:4:{i:0;a:3:{s:2:"id";s:1:"1";s:3:"gid";s:1:"1";s:1:"j";s:49:"{"a":[10,2,3,4],"f":[1.000000,3.141593,2.000000]}";}i:1;a:3:{s:2:"id";s:1:"2";s:3:"gid";s:1:"1";s:1:"j";s:49:"{"a":[10,3,4,5],"f":[2.000000,3.141593,3.000000]}";}i:2;a:3:{s:2:"id";s:1:"3";s:3:"gid";s:1:"2";s:1:"j";s:23:"{"a":"tag1","b":"tag2"}";}i:3;a:3:{s:2:"id";s:1:"4";s:3:"gid";s:1:"3";s:1:"j";s:13:"{"a":1,"c":2}";}}}i:164;a:2:{s:8:"sphinxql";s:47:"update json_inplace_rt set j.a[0]=-5 where id=1";s:14:"total_affected";i:1;}i:165;a:3:{s:8:"sphinxql";s:29:"select * from json_inplace_rt";s:10:"total_rows";i:4;s:4:"rows";a:4:{i:0;a:3:{s:2:"id";s:1:"1";s:3:"gid";s:1:"1";s:1:"j";s:49:"{"a":[-5,2,3,4],"f":[1.000000,3.141593,2.000000]}";}i:1;a:3:{s:2:"id";s:1:"2";s:3:"gid";s:1:"1";s:1:"j";s:49:"{"a":[10,3,4,5],"f":[2.000000,3.141593,3.000000]}";}i:2;a:3:{s:2:"id";s:1:"3";s:3:"gid";s:1:"2";s:1:"j";s:23:"{"a":"tag1","b":"tag2"}";}i:3;a:3:{s:2:"id";s:1:"4";s:3:"gid";s:1:"3";s:1:"j";s:13:"{"a":1,"c":2}";}}}i:166;a:2:{s:8:"sphinxql";s:49:"update json_inplace_rt set j.a[1]=-15 where gid>0";s:14:"total_affected";i:2;}i:167;a:3:{s:8:"sphinxql";s:29:"select * from json_inplace_rt";s:10:"total_rows";i:4;s:4:"rows";a:4:{i:0;a:3:{s:2:"id";s:1:"1";s:3:"gid";s:1:"1";s:1:"j";s:51:"{"a":[-5,-15,3,4],"f":[1.000000,3.141593,2.000000]}";}i:1;a:3:{s:2:"id";s:1:"2";s:3:"gid";s:1:"1";s:1:"j";s:51:"{"a":[10,-15,4,5],"f":[2.000000,3.141593,3.000000]}";}i:2;a:3:{s:2:"id";s:1:"3";s:3:"gid";s:1:"2";s:1:"j";s:23:"{"a":"tag1","b":"tag2"}";}i:3;a:3:{s:2:"id";s:1:"4";s:3:"gid";s:1:"3";s:1:"j";s:13:"{"a":1,"c":2}";}}}i:168;a:2:{s:8:"sphinxql";s:65:"update json_inplace_rt set j.a[1]=-20 where gid=1 option strict=1";s:14:"total_affected";i:2;}i:169;a:3:{s:8:"sphinxql";s:29:"select * from json_inplace_rt";s:10:"total_rows";i:4;s:4:"rows";a:4:{i:0;a:3:{s:2:"id";s:1:"1";s:3:"gid";s:1:"1";s:1:"j";s:51:"{"a":[-5,-20,3,4],"f":[1.000000,3.141593,2.000000]}";}i:1;a:3:{s:2:"id";s:1:"2";s:3:"gid";s:1:"1";s:1:"j";s:51:"{"a":[10,-20,4,5],"f":[2.000000,3.141593,3.000000]}";}i:2;a:3:{s:2:"id";s:1:"3";s:3:"gid";s:1:"2";s:1:"j";s:23:"{"a":"tag1","b":"tag2"}";}i:3;a:3:{s:2:"id";s:1:"4";s:3:"gid";s:1:"3";s:1:"j";s:13:"{"a":1,"c":2}";}}}i:170;a:3:{s:8:"sphinxql";s:65:"update json_inplace_rt set j.a[1]=-30 where gid>0 option strict=1";s:5:"error";s:94:"index json_inplace_rt: attribute 'j.a[1]' can not be updated (not found or incompatible types)";s:5:"errno";i:1064;}i:171;a:3:{s:8:"sphinxql";s:29:"select * from json_inplace_rt";s:10:"total_rows";i:4;s:4:"rows";a:4:{i:0;a:3:{s:2:"id";s:1:"1";s:3:"gid";s:1:"1";s:1:"j";s:51:"{"a":[-5,-20,3,4],"f":[1.000000,3.141593,2.000000]}";}i:1;a:3:{s:2:"id";s:1:"2";s:3:"gid";s:1:"1";s:1:"j";s:51:"{"a":[10,-20,4,5],"f":[2.000000,3.141593,3.000000]}";}i:2;a:3:{s:2:"id";s:1:"3";s:3:"gid";s:1:"2";s:1:"j";s:23:"{"a":"tag1","b":"tag2"}";}i:3;a:3:{s:2:"id";s:1:"4";s:3:"gid";s:1:"3";s:1:"j";s:13:"{"a":1,"c":2}";}}}i:172;a:2:{s:8:"sphinxql";s:61:"update json_inplace_rt set j.a=5, j.c=5, j.a[0]=5 where gid>0";s:14:"total_affected";i:3;}i:173;a:3:{s:8:"sphinxql";s:29:"select * from json_inplace_rt";s:10:"total_rows";i:4;s:4:"rows";a:4:{i:0;a:3:{s:2:"id";s:1:"1";s:3:"gid";s:1:"1";s:1:"j";s:50:"{"a":[5,-20,3,4],"f":[1.000000,3.141593,2.000000]}";}i:1;a:3:{s:2:"id";s:1:"2";s:3:"gid";s:1:"1";s:1:"j";s:50:"{"a":[5,-20,4,5],"f":[2.000000,3.141593,3.000000]}";}i:2;a:3:{s:2:"id";s:1:"3";s:3:"gid";s:1:"2";s:1:"j";s:23:"{"a":"tag1","b":"tag2"}";}i:3;a:3:{s:2:"id";s:1:"4";s:3:"gid";s:1:"3";s:1:"j";s:13:"{"a":5,"c":5}";}}}i:174;a:3:{s:8:"sphinxql";s:80:"update json_inplace_rt set j.a=10, j.c=10, j.a[0]=10 where gid>0 option strict=1";s:5:"error";s:91:"index json_inplace_rt: attribute 'j.a' can not be updated (not found or incompatible types)";s:5:"errno";i:1064;}i:175;a:3:{s:8:"sphinxql";s:29:"select * from json_inplace_rt";s:10:"total_rows";i:4;s:4:"rows";a:4:{i:0;a:3:{s:2:"id";s:1:"1";s:3:"gid";s:1:"1";s:1:"j";s:50:"{"a":[5,-20,3,4],"f":[1.000000,3.141593,2.000000]}";}i:1;a:3:{s:2:"id";s:1:"2";s:3:"gid";s:1:"1";s:1:"j";s:50:"{"a":[5,-20,4,5],"f":[2.000000,3.141593,3.000000]}";}i:2;a:3:{s:2:"id";s:1:"3";s:3:"gid";s:1:"2";s:1:"j";s:23:"{"a":"tag1","b":"tag2"}";}i:3;a:3:{s:2:"id";s:1:"4";s:3:"gid";s:1:"3";s:1:"j";s:13:"{"a":5,"c":5}";}}}i:176;a:2:{s:8:"sphinxql";s:69:"update json_inplace_rt set j.a=15, j.c=15 where gid=3 option strict=1";s:14:"total_affected";i:1;}i:177;a:3:{s:8:"sphinxql";s:29:"select * from json_inplace_rt";s:10:"total_rows";i:4;s:4:"rows";a:4:{i:0;a:3:{s:2:"id";s:1:"1";s:3:"gid";s:1:"1";s:1:"j";s:50:"{"a":[5,-20,3,4],"f":[1.000000,3.141593,2.000000]}";}i:1;a:3:{s:2:"id";s:1:"2";s:3:"gid";s:1:"1";s:1:"j";s:50:"{"a":[5,-20,4,5],"f":[2.000000,3.141593,3.000000]}";}i:2;a:3:{s:2:"id";s:1:"3";s:3:"gid";s:1:"2";s:1:"j";s:23:"{"a":"tag1","b":"tag2"}";}i:3;a:3:{s:2:"id";s:1:"4";s:3:"gid";s:1:"3";s:1:"j";s:15:"{"a":15,"c":15}";}}}i:178;a:2:{s:8:"sphinxql";s:75:"insert into json_inplace_rt (id, gid, title, j) values (666, 666, '', '{}')";s:14:"total_affected";i:1;}i:179;a:2:{s:8:"sphinxql";s:51:"insert into rt (id, data) values (4, '{"f": 1e-5}')";s:14:"total_affected";i:1;}i:180;a:2:{s:8:"sphinxql";s:50:"insert into rt (id, data) values (5, '{"f": 1e5}')";s:14:"total_affected";i:1;}i:181;a:2:{s:8:"sphinxql";s:52:"insert into rt (id, data) values (6, '{"f": -1e-5}')";s:14:"total_affected";i:1;}i:182;a:2:{s:8:"sphinxql";s:51:"insert into rt (id, data) values (7, '{"f": -1e5}')";s:14:"total_affected";i:1;}i:183;a:2:{s:8:"sphinxql";s:55:"insert into rt (id, data) values (8, '{"f": 6.022e+3}')";s:14:"total_affected";i:1;}i:184;a:2:{s:8:"sphinxql";s:59:"insert into rt (id, data) values (9, '{"f": 1.4738223E-1}')";s:14:"total_affected";i:1;}i:185;a:3:{s:8:"sphinxql";s:38:"select * from rt where id>=4 and id<=9";s:10:"total_rows";i:6;s:4:"rows";a:6:{i:0;a:2:{s:2:"id";s:1:"4";s:4:"data";s:14:"{"f":0.000010}";}i:1;a:2:{s:2:"id";s:1:"5";s:4:"data";s:19:"{"f":100000.000000}";}i:2;a:2:{s:2:"id";s:1:"6";s:4:"data";s:15:"{"f":-0.000010}";}i:3;a:2:{s:2:"id";s:1:"7";s:4:"data";s:20:"{"f":-100000.000000}";}i:4;a:2:{s:2:"id";s:1:"8";s:4:"data";s:17:"{"f":6022.000000}";}i:5;a:2:{s:2:"id";s:1:"9";s:4:"data";s:14:"{"f":0.147382}";}}}i:186;a:3:{s:8:"sphinxql";s:40:"select * from json_inplace_rt group by j";s:10:"total_rows";i:5;s:4:"rows";a:5:{i:0;a:3:{s:2:"id";s:1:"1";s:3:"gid";s:1:"1";s:1:"j";s:50:"{"a":[5,-20,3,4],"f":[1.000000,3.141593,2.000000]}";}i:1;a:3:{s:2:"id";s:1:"2";s:3:"gid";s:1:"1";s:1:"j";s:50:"{"a":[5,-20,4,5],"f":[2.000000,3.141593,3.000000]}";}i:2;a:3:{s:2:"id";s:1:"3";s:3:"gid";s:1:"2";s:1:"j";s:23:"{"a":"tag1","b":"tag2"}";}i:3;a:3:{s:2:"id";s:1:"4";s:3:"gid";s:1:"3";s:1:"j";s:15:"{"a":15,"c":15}";}i:4;a:3:{s:2:"id";s:3:"666";s:3:"gid";s:3:"666";s:1:"j";s:2:"{}";}}}i:187;a:3:{s:8:"sphinxql";s:47:"select * from json_inplace_rt group by title, j";s:5:"error";s:67:"index json_inplace_rt: JSON blob can't be used in multiple group-by";s:5:"errno";i:1064;}i:188;a:2:{s:8:"sphinxql";s:423:"insert into json_search (id, title, j) values
(1, 'a1', '{"array":[{gid:1,name:"a1"},{gid:2,name:"a2"},{gid:3,name:"a3"}], "intarray":[1,2,3], "tags":["a1","a2","a3"]}'),
(2, 'a5', '{"array":[{gid:4,name:"a4"},{gid:5,name:"a5"},{gid:6,name:"a6"}], "intarray":[4,5,6], "tags":["a4","a5","a6"]}'),
(3, 'a9', '{"array":[{gid:7,name:"a7"},{gid:8,name:"a8"},{gid:9,name:"a9"}], "intarray":[7,8,9], "tags":["a7","a8","a9"]}')
";s:14:"total_affected";i:3;}i:189;a:3:{s:8:"sphinxql";s:60:"select all(x>3 and x<7 for x in j.intarray) from json_search";s:10:"total_rows";i:3;s:4:"rows";a:3:{i:0;a:1:{s:36:"all(x>3 and x<7 for x in j.intarray)";s:1:"0";}i:1;a:1:{s:36:"all(x>3 and x<7 for x in j.intarray)";s:1:"1";}i:2;a:1:{s:36:"all(x>3 and x<7 for x in j.intarray)";s:1:"0";}}}i:190;a:3:{s:8:"sphinxql";s:60:"select any(x>1 and x<3 for x in j.intarray) from json_search";s:10:"total_rows";i:3;s:4:"rows";a:3:{i:0;a:1:{s:36:"any(x>1 and x<3 for x in j.intarray)";s:1:"1";}i:1;a:1:{s:36:"any(x>1 and x<3 for x in j.intarray)";s:1:"0";}i:2;a:1:{s:36:"any(x>1 and x<3 for x in j.intarray)";s:1:"0";}}}i:191;a:3:{s:8:"sphinxql";s:64:"select indexof(x>2 and x<4 for x in j.intarray) from json_search";s:10:"total_rows";i:3;s:4:"rows";a:3:{i:0;a:1:{s:40:"indexof(x>2 and x<4 for x in j.intarray)";s:1:"2";}i:1;a:1:{s:40:"indexof(x>2 and x<4 for x in j.intarray)";s:2:"-1";}i:2;a:1:{s:40:"indexof(x>2 and x<4 for x in j.intarray)";s:2:"-1";}}}i:192;a:3:{s:8:"sphinxql";s:52:"select all(x>5 for x in j.intarray) from json_search";s:10:"total_rows";i:3;s:4:"rows";a:3:{i:0;a:1:{s:28:"all(x>5 for x in j.intarray)";s:1:"0";}i:1;a:1:{s:28:"all(x>5 for x in j.intarray)";s:1:"0";}i:2;a:1:{s:28:"all(x>5 for x in j.intarray)";s:1:"1";}}}i:193;a:3:{s:8:"sphinxql";s:57:"select all(1+x.gid+1>5 for x in j.array) from json_search";s:10:"total_rows";i:3;s:4:"rows";a:3:{i:0;a:1:{s:33:"all(1+x.gid+1>5 for x in j.array)";s:1:"0";}i:1;a:1:{s:33:"all(1+x.gid+1>5 for x in j.array)";s:1:"1";}i:2;a:1:{s:33:"all(1+x.gid+1>5 for x in j.array)";s:1:"1";}}}i:194;a:3:{s:8:"sphinxql";s:89:"select indexof(x.gid=any(y.gid=x.gid for y in j.array) for x in j.array) from json_search";s:10:"total_rows";i:3;s:4:"rows";a:3:{i:0;a:1:{s:65:"indexof(x.gid=any(y.gid=x.gid for y in j.array) for x in j.array)";s:1:"0";}i:1;a:1:{s:65:"indexof(x.gid=any(y.gid=x.gid for y in j.array) for x in j.array)";s:2:"-1";}i:2;a:1:{s:65:"indexof(x.gid=any(y.gid=x.gid for y in j.array) for x in j.array)";s:2:"-1";}}}i:195;a:3:{s:8:"sphinxql";s:102:"select id, j.array[indexof(1+x.gid=2 for x in j.array)].name as p from json_search where p is not null";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:2:{s:2:"id";s:1:"1";s:1:"p";s:2:"a1";}}}i:196;a:3:{s:8:"sphinxql";s:79:"select all(z.gid=1 for x in j.array) as error_unknown_column_z from json_search";s:5:"error";s:49:"index json_search: parse error: unknown column: z";s:5:"errno";i:1064;}i:197;a:3:{s:8:"sphinxql";s:61:"select indexof(x.name='a2' for x in j.array) from json_search";s:10:"total_rows";i:3;s:4:"rows";a:3:{i:0;a:1:{s:37:"indexof(x.name='a2' for x in j.array)";s:1:"1";}i:1;a:1:{s:37:"indexof(x.name='a2' for x in j.array)";s:2:"-1";}i:2;a:1:{s:37:"indexof(x.name='a2' for x in j.array)";s:2:"-1";}}}i:198;a:3:{s:8:"sphinxql";s:91:"select indexof(x.name='a2' or x.name='a6' or x.name='a7' for x in j.array) from json_search";s:10:"total_rows";i:3;s:4:"rows";a:3:{i:0;a:1:{s:67:"indexof(x.name='a2' or x.name='a6' or x.name='a7' for x in j.array)";s:1:"1";}i:1;a:1:{s:67:"indexof(x.name='a2' or x.name='a6' or x.name='a7' for x in j.array)";s:1:"2";}i:2;a:1:{s:67:"indexof(x.name='a2' or x.name='a6' or x.name='a7' for x in j.array)";s:1:"0";}}}i:199;a:3:{s:8:"sphinxql";s:87:"select indexof(x.name='a2' or x.gid=6 or x.name='a7' for x in j.array) from json_search";s:10:"total_rows";i:3;s:4:"rows";a:3:{i:0;a:1:{s:63:"indexof(x.name='a2' or x.gid=6 or x.name='a7' for x in j.array)";s:1:"1";}i:1;a:1:{s:63:"indexof(x.name='a2' or x.gid=6 or x.name='a7' for x in j.array)";s:1:"2";}i:2;a:1:{s:63:"indexof(x.name='a2' or x.gid=6 or x.name='a7' for x in j.array)";s:1:"0";}}}i:200;a:3:{s:8:"sphinxql";s:73:"select indexof(x.name='a2' and x.gid=2 for x in j.array) from json_search";s:10:"total_rows";i:3;s:4:"rows";a:3:{i:0;a:1:{s:49:"indexof(x.name='a2' and x.gid=2 for x in j.array)";s:1:"1";}i:1;a:1:{s:49:"indexof(x.name='a2' and x.gid=2 for x in j.array)";s:2:"-1";}i:2;a:1:{s:49:"indexof(x.name='a2' and x.gid=2 for x in j.array)";s:2:"-1";}}}i:201;a:3:{s:8:"sphinxql";s:62:"select indexof(x.name=title for x in j.array) from json_search";s:10:"total_rows";i:3;s:4:"rows";a:3:{i:0;a:1:{s:38:"indexof(x.name=title for x in j.array)";s:1:"0";}i:1;a:1:{s:38:"indexof(x.name=title for x in j.array)";s:1:"1";}i:2;a:1:{s:38:"indexof(x.name=title for x in j.array)";s:1:"2";}}}i:202;a:3:{s:8:"sphinxql";s:61:"select indexof('a2'=x.name for x in j.array) from json_search";s:10:"total_rows";i:3;s:4:"rows";a:3:{i:0;a:1:{s:37:"indexof('a2'=x.name for x in j.array)";s:1:"1";}i:1;a:1:{s:37:"indexof('a2'=x.name for x in j.array)";s:2:"-1";}i:2;a:1:{s:37:"indexof('a2'=x.name for x in j.array)";s:2:"-1";}}}i:203;a:3:{s:8:"sphinxql";s:62:"select indexof(title=x.name for x in j.array) from json_search";s:10:"total_rows";i:3;s:4:"rows";a:3:{i:0;a:1:{s:38:"indexof(title=x.name for x in j.array)";s:1:"0";}i:1;a:1:{s:38:"indexof(title=x.name for x in j.array)";s:1:"1";}i:2;a:1:{s:38:"indexof(title=x.name for x in j.array)";s:1:"2";}}}i:204;a:3:{s:8:"sphinxql";s:75:"select indexof(to_string(1)=to_string(1) for x in j.array) from json_search";s:10:"total_rows";i:3;s:4:"rows";a:3:{i:0;a:1:{s:51:"indexof(to_string(1)=to_string(1) for x in j.array)";s:1:"0";}i:1;a:1:{s:51:"indexof(to_string(1)=to_string(1) for x in j.array)";s:1:"0";}i:2;a:1:{s:51:"indexof(to_string(1)=to_string(1) for x in j.array)";s:1:"0";}}}i:205;a:3:{s:8:"sphinxql";s:51:"select all(x='a1' for x in j.tags) from json_search";s:10:"total_rows";i:3;s:4:"rows";a:3:{i:0;a:1:{s:27:"all(x='a1' for x in j.tags)";s:1:"0";}i:1;a:1:{s:27:"all(x='a1' for x in j.tags)";s:1:"0";}i:2;a:1:{s:27:"all(x='a1' for x in j.tags)";s:1:"0";}}}i:206;a:3:{s:8:"sphinxql";s:51:"select any(x='a3' for x in j.tags) from json_search";s:10:"total_rows";i:3;s:4:"rows";a:3:{i:0;a:1:{s:27:"any(x='a3' for x in j.tags)";s:1:"1";}i:1;a:1:{s:27:"any(x='a3' for x in j.tags)";s:1:"0";}i:2;a:1:{s:27:"any(x='a3' for x in j.tags)";s:1:"0";}}}i:207;a:3:{s:8:"sphinxql";s:55:"select indexof(x='a5' for x in j.tags) from json_search";s:10:"total_rows";i:3;s:4:"rows";a:3:{i:0;a:1:{s:31:"indexof(x='a5' for x in j.tags)";s:2:"-1";}i:1;a:1:{s:31:"indexof(x='a5' for x in j.tags)";s:1:"1";}i:2;a:1:{s:31:"indexof(x='a5' for x in j.tags)";s:2:"-1";}}}i:208;a:2:{s:8:"sphinxql";s:145:"insert into json_order (id, j) values
(1, '{i:123,d:123.0,b:12300000000}'),
(2, '{i:23,d:23.0,b:2300000000}'),
(3, '{i:3,d:3.0,b:300000000}')
";s:14:"total_affected";i:3;}i:209;a:3:{s:8:"sphinxql";s:43:"select j.i from json_order order by j.i asc";s:10:"total_rows";i:3;s:4:"rows";a:3:{i:0;a:1:{s:3:"j.i";s:3:"123";}i:1;a:1:{s:3:"j.i";s:2:"23";}i:2;a:1:{s:3:"j.i";s:1:"3";}}}i:210;a:3:{s:8:"sphinxql";s:52:"select j.i from json_order order by integer(j.i) asc";s:10:"total_rows";i:3;s:4:"rows";a:3:{i:0;a:1:{s:3:"j.i";s:1:"3";}i:1;a:1:{s:3:"j.i";s:2:"23";}i:2;a:1:{s:3:"j.i";s:3:"123";}}}i:211;a:3:{s:8:"sphinxql";s:43:"select j.d from json_order order by j.d asc";s:10:"total_rows";i:3;s:4:"rows";a:3:{i:0;a:1:{s:3:"j.d";s:10:"123.000000";}i:1;a:1:{s:3:"j.d";s:9:"23.000000";}i:2;a:1:{s:3:"j.d";s:8:"3.000000";}}}i:212;a:3:{s:8:"sphinxql";s:51:"select j.d from json_order order by double(j.d) asc";s:10:"total_rows";i:3;s:4:"rows";a:3:{i:0;a:1:{s:3:"j.d";s:8:"3.000000";}i:1;a:1:{s:3:"j.d";s:9:"23.000000";}i:2;a:1:{s:3:"j.d";s:10:"123.000000";}}}i:213;a:3:{s:8:"sphinxql";s:43:"select j.b from json_order order by j.b asc";s:10:"total_rows";i:3;s:4:"rows";a:3:{i:0;a:1:{s:3:"j.b";s:11:"12300000000";}i:1;a:1:{s:3:"j.b";s:10:"2300000000";}i:2;a:1:{s:3:"j.b";s:9:"300000000";}}}i:214;a:3:{s:8:"sphinxql";s:51:"select j.b from json_order order by bigint(j.b) asc";s:10:"total_rows";i:3;s:4:"rows";a:3:{i:0;a:1:{s:3:"j.b";s:9:"300000000";}i:1;a:1:{s:3:"j.b";s:10:"2300000000";}i:2;a:1:{s:3:"j.b";s:11:"12300000000";}}}i:215;a:3:{s:8:"sphinxql";s:98:"select j[0] is null, if(j[0] is null,0,1), j[0] is not null, if(j[0] is not null,0,1) from objects";s:10:"total_rows";i:14;s:4:"rows";a:14:{i:0;a:4:{s:12:"j[0] is null";s:1:"0";s:20:"if(j[0] is null,0,1)";s:1:"1";s:16:"j[0] is not null";s:1:"1";s:24:"if(j[0] is not null,0,1)";s:1:"0";}i:1;a:4:{s:12:"j[0] is null";s:1:"0";s:20:"if(j[0] is null,0,1)";s:1:"1";s:16:"j[0] is not null";s:1:"1";s:24:"if(j[0] is not null,0,1)";s:1:"0";}i:2;a:4:{s:12:"j[0] is null";s:1:"1";s:20:"if(j[0] is null,0,1)";s:1:"0";s:16:"j[0] is not null";s:1:"0";s:24:"if(j[0] is not null,0,1)";s:1:"1";}i:3;a:4:{s:12:"j[0] is null";s:1:"0";s:20:"if(j[0] is null,0,1)";s:1:"1";s:16:"j[0] is not null";s:1:"1";s:24:"if(j[0] is not null,0,1)";s:1:"0";}i:4;a:4:{s:12:"j[0] is null";s:1:"1";s:20:"if(j[0] is null,0,1)";s:1:"0";s:16:"j[0] is not null";s:1:"0";s:24:"if(j[0] is not null,0,1)";s:1:"1";}i:5;a:4:{s:12:"j[0] is null";s:1:"0";s:20:"if(j[0] is null,0,1)";s:1:"1";s:16:"j[0] is not null";s:1:"1";s:24:"if(j[0] is not null,0,1)";s:1:"0";}i:6;a:4:{s:12:"j[0] is null";s:1:"0";s:20:"if(j[0] is null,0,1)";s:1:"1";s:16:"j[0] is not null";s:1:"1";s:24:"if(j[0] is not null,0,1)";s:1:"0";}i:7;a:4:{s:12:"j[0] is null";s:1:"1";s:20:"if(j[0] is null,0,1)";s:1:"0";s:16:"j[0] is not null";s:1:"0";s:24:"if(j[0] is not null,0,1)";s:1:"1";}i:8;a:4:{s:12:"j[0] is null";s:1:"0";s:20:"if(j[0] is null,0,1)";s:1:"1";s:16:"j[0] is not null";s:1:"1";s:24:"if(j[0] is not null,0,1)";s:1:"0";}i:9;a:4:{s:12:"j[0] is null";s:1:"1";s:20:"if(j[0] is null,0,1)";s:1:"0";s:16:"j[0] is not null";s:1:"0";s:24:"if(j[0] is not null,0,1)";s:1:"1";}i:10;a:4:{s:12:"j[0] is null";s:1:"1";s:20:"if(j[0] is null,0,1)";s:1:"0";s:16:"j[0] is not null";s:1:"0";s:24:"if(j[0] is not null,0,1)";s:1:"1";}i:11;a:4:{s:12:"j[0] is null";s:1:"1";s:20:"if(j[0] is null,0,1)";s:1:"0";s:16:"j[0] is not null";s:1:"0";s:24:"if(j[0] is not null,0,1)";s:1:"1";}i:12;a:4:{s:12:"j[0] is null";s:1:"1";s:20:"if(j[0] is null,0,1)";s:1:"0";s:16:"j[0] is not null";s:1:"0";s:24:"if(j[0] is not null,0,1)";s:1:"1";}i:13;a:4:{s:12:"j[0] is null";s:1:"1";s:20:"if(j[0] is null,0,1)";s:1:"0";s:16:"j[0] is not null";s:1:"0";s:24:"if(j[0] is not null,0,1)";s:1:"1";}}}i:216;a:3:{s:8:"sphinxql";s:45:"select id, j.uid from loc1 order by j.uid asc";s:10:"total_rows";i:7;s:4:"rows";a:7:{i:0;a:2:{s:2:"id";s:3:"100";s:5:"j.uid";N;}i:1;a:2:{s:2:"id";s:1:"1";s:5:"j.uid";s:3:"123";}i:2;a:2:{s:2:"id";s:1:"7";s:5:"j.uid";s:3:"123";}i:3;a:2:{s:2:"id";s:1:"2";s:5:"j.uid";s:3:"234";}i:4;a:2:{s:2:"id";s:1:"4";s:5:"j.uid";s:3:"456";}i:5;a:2:{s:2:"id";s:1:"5";s:5:"j.uid";s:3:"567";}i:6;a:2:{s:2:"id";s:1:"8";s:5:"j.uid";s:3:"567";}}}i:217;a:3:{s:8:"sphinxql";s:46:"select id, j.uid from loc1 order by j.uid desc";s:10:"total_rows";i:7;s:4:"rows";a:7:{i:0;a:2:{s:2:"id";s:1:"5";s:5:"j.uid";s:3:"567";}i:1;a:2:{s:2:"id";s:1:"8";s:5:"j.uid";s:3:"567";}i:2;a:2:{s:2:"id";s:1:"4";s:5:"j.uid";s:3:"456";}i:3;a:2:{s:2:"id";s:1:"2";s:5:"j.uid";s:3:"234";}i:4;a:2:{s:2:"id";s:1:"1";s:5:"j.uid";s:3:"123";}i:5;a:2:{s:2:"id";s:1:"7";s:5:"j.uid";s:3:"123";}i:6;a:2:{s:2:"id";s:3:"100";s:5:"j.uid";N;}}}i:218;a:3:{s:8:"sphinxql";s:54:"select id, j.uid from loc1 order by integer(j.uid) asc";s:10:"total_rows";i:7;s:4:"rows";a:7:{i:0;a:2:{s:2:"id";s:3:"100";s:5:"j.uid";N;}i:1;a:2:{s:2:"id";s:1:"1";s:5:"j.uid";s:3:"123";}i:2;a:2:{s:2:"id";s:1:"7";s:5:"j.uid";s:3:"123";}i:3;a:2:{s:2:"id";s:1:"2";s:5:"j.uid";s:3:"234";}i:4;a:2:{s:2:"id";s:1:"4";s:5:"j.uid";s:3:"456";}i:5;a:2:{s:2:"id";s:1:"5";s:5:"j.uid";s:3:"567";}i:6;a:2:{s:2:"id";s:1:"8";s:5:"j.uid";s:3:"567";}}}i:219;a:3:{s:8:"sphinxql";s:53:"select id, j.uid from loc1 order by double(j.uid) asc";s:10:"total_rows";i:7;s:4:"rows";a:7:{i:0;a:2:{s:2:"id";s:3:"100";s:5:"j.uid";N;}i:1;a:2:{s:2:"id";s:1:"1";s:5:"j.uid";s:3:"123";}i:2;a:2:{s:2:"id";s:1:"7";s:5:"j.uid";s:3:"123";}i:3;a:2:{s:2:"id";s:1:"2";s:5:"j.uid";s:3:"234";}i:4;a:2:{s:2:"id";s:1:"4";s:5:"j.uid";s:3:"456";}i:5;a:2:{s:2:"id";s:1:"5";s:5:"j.uid";s:3:"567";}i:6;a:2:{s:2:"id";s:1:"8";s:5:"j.uid";s:3:"567";}}}i:220;a:3:{s:8:"sphinxql";s:53:"select id, j.uid from loc1 order by bigint(j.uid) asc";s:10:"total_rows";i:7;s:4:"rows";a:7:{i:0;a:2:{s:2:"id";s:3:"100";s:5:"j.uid";N;}i:1;a:2:{s:2:"id";s:1:"1";s:5:"j.uid";s:3:"123";}i:2;a:2:{s:2:"id";s:1:"7";s:5:"j.uid";s:3:"123";}i:3;a:2:{s:2:"id";s:1:"2";s:5:"j.uid";s:3:"234";}i:4;a:2:{s:2:"id";s:1:"4";s:5:"j.uid";s:3:"456";}i:5;a:2:{s:2:"id";s:1:"5";s:5:"j.uid";s:3:"567";}i:6;a:2:{s:2:"id";s:1:"8";s:5:"j.uid";s:3:"567";}}}i:221;a:3:{s:8:"sphinxql";s:46:"select id, j.uid as p from loc1 order by p asc";s:10:"total_rows";i:7;s:4:"rows";a:7:{i:0;a:2:{s:2:"id";s:3:"100";s:1:"p";N;}i:1;a:2:{s:2:"id";s:1:"1";s:1:"p";s:3:"123";}i:2;a:2:{s:2:"id";s:1:"7";s:1:"p";s:3:"123";}i:3;a:2:{s:2:"id";s:1:"2";s:1:"p";s:3:"234";}i:4;a:2:{s:2:"id";s:1:"4";s:1:"p";s:3:"456";}i:5;a:2:{s:2:"id";s:1:"5";s:1:"p";s:3:"567";}i:6;a:2:{s:2:"id";s:1:"8";s:1:"p";s:3:"567";}}}i:222;a:3:{s:8:"sphinxql";s:47:"select id, j.uid as p from loc1 order by p desc";s:10:"total_rows";i:7;s:4:"rows";a:7:{i:0;a:2:{s:2:"id";s:1:"5";s:1:"p";s:3:"567";}i:1;a:2:{s:2:"id";s:1:"8";s:1:"p";s:3:"567";}i:2;a:2:{s:2:"id";s:1:"4";s:1:"p";s:3:"456";}i:3;a:2:{s:2:"id";s:1:"2";s:1:"p";s:3:"234";}i:4;a:2:{s:2:"id";s:1:"1";s:1:"p";s:3:"123";}i:5;a:2:{s:2:"id";s:1:"7";s:1:"p";s:3:"123";}i:6;a:2:{s:2:"id";s:3:"100";s:1:"p";N;}}}i:223;a:3:{s:8:"sphinxql";s:51:"select count(*), groupby() from arrays group by j.a";s:10:"total_rows";i:6;s:4:"rows";a:6:{i:0;a:2:{s:8:"count(*)";s:1:"4";s:9:"groupby()";s:1:"4";}i:1;a:2:{s:8:"count(*)";s:1:"3";s:9:"groupby()";s:1:"3";}i:2;a:2:{s:8:"count(*)";s:1:"3";s:9:"groupby()";s:1:"2";}i:3;a:2:{s:8:"count(*)";s:1:"2";s:9:"groupby()";s:1:"1";}i:4;a:2:{s:8:"count(*)";s:1:"3";s:9:"groupby()";s:1:"5";}i:5;a:2:{s:8:"count(*)";s:1:"1";s:9:"groupby()";s:1:"6";}}}i:224;a:3:{s:8:"sphinxql";s:51:"select count(*), groupby() from arrays group by j.t";s:10:"total_rows";i:6;s:4:"rows";a:6:{i:0;a:2:{s:8:"count(*)";s:1:"3";s:9:"groupby()";s:2:"t3";}i:1;a:2:{s:8:"count(*)";s:1:"2";s:9:"groupby()";s:2:"t2";}i:2;a:2:{s:8:"count(*)";s:1:"1";s:9:"groupby()";s:2:"t1";}i:3;a:2:{s:8:"count(*)";s:1:"3";s:9:"groupby()";s:2:"t4";}i:4;a:2:{s:8:"count(*)";s:1:"2";s:9:"groupby()";s:2:"t5";}i:5;a:2:{s:8:"count(*)";s:1:"1";s:9:"groupby()";s:2:"t6";}}}i:225;a:3:{s:8:"sphinxql";s:84:"select count(*) as p, groupby() as q from arrays group by j.t order by q asc, p desc";s:10:"total_rows";i:6;s:4:"rows";a:6:{i:0;a:2:{s:1:"p";s:1:"3";s:1:"q";s:2:"t3";}i:1;a:2:{s:1:"p";s:1:"3";s:1:"q";s:2:"t4";}i:2;a:2:{s:1:"p";s:1:"2";s:1:"q";s:2:"t2";}i:3;a:2:{s:1:"p";s:1:"2";s:1:"q";s:2:"t5";}i:4;a:2:{s:1:"p";s:1:"1";s:1:"q";s:2:"t1";}i:5;a:2:{s:1:"p";s:1:"1";s:1:"q";s:2:"t6";}}}i:226;a:3:{s:8:"sphinxql";s:84:"select count(*) as p, groupby() as q from loc1 group by j.uid order by q asc, p desc";s:10:"total_rows";i:5;s:4:"rows";a:5:{i:0;a:2:{s:1:"p";s:1:"2";s:1:"q";s:3:"123";}i:1;a:2:{s:1:"p";s:1:"2";s:1:"q";s:3:"567";}i:2;a:2:{s:1:"p";s:1:"1";s:1:"q";s:3:"234";}i:3;a:2:{s:1:"p";s:1:"1";s:1:"q";s:3:"456";}i:4;a:2:{s:1:"p";s:1:"1";s:1:"q";N;}}}i:227;a:2:{s:8:"sphinxql";s:202:"insert into json_toplevel (id, j) values
(1, '[1,2,3,4]'),
(2, '[1,2,3]'),
(3, '[1,2]'),
(4, '["a","b","c"]'),
(5, '["a","b"]'),
(6, '["a"]'),
(7, '[]'),
(8, ''),
(9, '{"a":"b"}'),
(10, '{}')
";s:14:"total_affected";i:10;}i:228;a:3:{s:8:"sphinxql";s:76:"select count(*) p, groupby() q from json_toplevel group by j order by p desc";s:10:"total_rows";i:9;s:4:"rows";a:9:{i:0;a:2:{s:1:"p";s:1:"3";s:1:"q";s:1:"2";}i:1;a:2:{s:1:"p";s:1:"3";s:1:"q";s:1:"1";}i:2;a:2:{s:1:"p";s:1:"3";s:1:"q";s:1:"a";}i:3;a:2:{s:1:"p";s:1:"3";s:1:"q";N;}i:4;a:2:{s:1:"p";s:1:"2";s:1:"q";s:1:"3";}i:5;a:2:{s:1:"p";s:1:"2";s:1:"q";s:1:"b";}i:6;a:2:{s:1:"p";s:1:"1";s:1:"q";s:1:"4";}i:7;a:2:{s:1:"p";s:1:"1";s:1:"q";s:1:"c";}i:8;a:2:{s:1:"p";s:1:"1";s:1:"q";s:9:"{"a":"b"}";}}}i:229;a:2:{s:8:"sphinxql";s:69:"replace into rt (id, data) values (1,'{"html":"p class="document""}')";s:14:"total_affected";i:1;}i:230;a:3:{s:8:"sphinxql";s:41:"select data, data.html from rt where id=1";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:2:{s:4:"data";N;s:9:"data.html";N;}}}i:231;a:2:{s:8:"sphinxql";s:71:"replace into rt (id, data) values (1,'{"html":"p class=\"document\""}')";s:14:"total_affected";i:1;}i:232;a:3:{s:8:"sphinxql";s:41:"select data, data.html from rt where id=1";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:2:{s:4:"data";N;s:9:"data.html";N;}}}i:233;a:2:{s:8:"sphinxql";s:73:"replace into rt (id, data) values (1,'{"html":"p class=\\"document\\""}')";s:14:"total_affected";i:1;}i:234;a:3:{s:8:"sphinxql";s:41:"select data, data.html from rt where id=1";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:2:{s:4:"data";s:31:"{"html":"p class=\"document\""}";s:9:"data.html";s:18:"p class="document"";}}}i:235;a:3:{s:8:"sphinxql";s:52:"select j.a, interval(uint(j.a[0]),1,2,3) from arrays";s:10:"total_rows";i:4;s:4:"rows";a:4:{i:0;a:2:{s:3:"j.a";s:9:"[1,2,3,4]";s:28:"interval(uint(j.a[0]),1,2,3)";s:1:"1";}i:1;a:2:{s:3:"j.a";s:9:"[2,3,4,5]";s:28:"interval(uint(j.a[0]),1,2,3)";s:1:"2";}i:2;a:2:{s:3:"j.a";s:9:"[3,4,5,1]";s:28:"interval(uint(j.a[0]),1,2,3)";s:1:"3";}i:3;a:2:{s:3:"j.a";s:9:"[4,5,6,2]";s:28:"interval(uint(j.a[0]),1,2,3)";s:1:"3";}}}i:236;a:3:{s:8:"sphinxql";s:46:"select j.a, interval(j.a[0],1,2,3) from arrays";s:10:"total_rows";i:4;s:4:"rows";a:4:{i:0;a:2:{s:3:"j.a";s:9:"[1,2,3,4]";s:22:"interval(j.a[0],1,2,3)";s:1:"1";}i:1;a:2:{s:3:"j.a";s:9:"[2,3,4,5]";s:22:"interval(j.a[0],1,2,3)";s:1:"2";}i:2;a:2:{s:3:"j.a";s:9:"[3,4,5,1]";s:22:"interval(j.a[0],1,2,3)";s:1:"3";}i:3;a:2:{s:3:"j.a";s:9:"[4,5,6,2]";s:22:"interval(j.a[0],1,2,3)";s:1:"3";}}}i:237;a:3:{s:8:"sphinxql";s:53:"select * from json_up1, json_up2 order by j.R158S asc";s:10:"total_rows";i:2;s:4:"rows";a:2:{i:0;a:2:{s:2:"id";s:3:"100";s:1:"j";s:51:"{"R158S":100,"rom":303,"t1":"B","t2":"BC","T1":"D"}";}i:1;a:2:{s:2:"id";s:1:"1";s:1:"j";s:51:"{"R158S":901,"rom":202,"t1":"A","t2":"AB","T1":"C"}";}}}i:238;a:3:{s:8:"sphinxql";s:54:"select * from json_up1, json_up2 order by j.R158S desc";s:10:"total_rows";i:2;s:4:"rows";a:2:{i:0;a:2:{s:2:"id";s:1:"1";s:1:"j";s:51:"{"R158S":901,"rom":202,"t1":"A","t2":"AB","T1":"C"}";}i:1;a:2:{s:2:"id";s:3:"100";s:1:"j";s:51:"{"R158S":100,"rom":303,"t1":"B","t2":"BC","T1":"D"}";}}}i:239;a:3:{s:8:"sphinxql";s:51:"select * from json_up1, json_up2 order by j.rom asc";s:10:"total_rows";i:2;s:4:"rows";a:2:{i:0;a:2:{s:2:"id";s:1:"1";s:1:"j";s:51:"{"R158S":901,"rom":202,"t1":"A","t2":"AB","T1":"C"}";}i:1;a:2:{s:2:"id";s:3:"100";s:1:"j";s:51:"{"R158S":100,"rom":303,"t1":"B","t2":"BC","T1":"D"}";}}}i:240;a:3:{s:8:"sphinxql";s:52:"select * from json_up1, json_up2 order by j.rom desc";s:10:"total_rows";i:2;s:4:"rows";a:2:{i:0;a:2:{s:2:"id";s:3:"100";s:1:"j";s:51:"{"R158S":100,"rom":303,"t1":"B","t2":"BC","T1":"D"}";}i:1;a:2:{s:2:"id";s:1:"1";s:1:"j";s:51:"{"R158S":901,"rom":202,"t1":"A","t2":"AB","T1":"C"}";}}}i:241;a:3:{s:8:"sphinxql";s:42:"select * from dist_up order by j.R158S asc";s:10:"total_rows";i:2;s:4:"rows";a:2:{i:0;a:2:{s:2:"id";s:3:"100";s:1:"j";s:51:"{"R158S":100,"rom":303,"t1":"B","t2":"BC","T1":"D"}";}i:1;a:2:{s:2:"id";s:1:"1";s:1:"j";s:51:"{"R158S":901,"rom":202,"t1":"A","t2":"AB","T1":"C"}";}}}i:242;a:3:{s:8:"sphinxql";s:43:"select * from dist_up order by j.R158S desc";s:10:"total_rows";i:2;s:4:"rows";a:2:{i:0;a:2:{s:2:"id";s:1:"1";s:1:"j";s:51:"{"R158S":901,"rom":202,"t1":"A","t2":"AB","T1":"C"}";}i:1;a:2:{s:2:"id";s:3:"100";s:1:"j";s:51:"{"R158S":100,"rom":303,"t1":"B","t2":"BC","T1":"D"}";}}}i:243;a:3:{s:8:"sphinxql";s:40:"select * from dist_up order by j.rom asc";s:10:"total_rows";i:2;s:4:"rows";a:2:{i:0;a:2:{s:2:"id";s:1:"1";s:1:"j";s:51:"{"R158S":901,"rom":202,"t1":"A","t2":"AB","T1":"C"}";}i:1;a:2:{s:2:"id";s:3:"100";s:1:"j";s:51:"{"R158S":100,"rom":303,"t1":"B","t2":"BC","T1":"D"}";}}}i:244;a:3:{s:8:"sphinxql";s:41:"select * from dist_up order by j.rom desc";s:10:"total_rows";i:2;s:4:"rows";a:2:{i:0;a:2:{s:2:"id";s:3:"100";s:1:"j";s:51:"{"R158S":100,"rom":303,"t1":"B","t2":"BC","T1":"D"}";}i:1;a:2:{s:2:"id";s:1:"1";s:1:"j";s:51:"{"R158S":901,"rom":202,"t1":"A","t2":"AB","T1":"C"}";}}}i:245;a:3:{s:8:"sphinxql";s:32:"select id, j.id, j.uid from dist";s:10:"total_rows";i:7;s:4:"rows";a:7:{i:0;a:3:{s:2:"id";s:1:"1";s:4:"j.id";N;s:5:"j.uid";s:3:"123";}i:1;a:3:{s:2:"id";s:1:"2";s:4:"j.id";N;s:5:"j.uid";s:3:"234";}i:2;a:3:{s:2:"id";s:1:"4";s:4:"j.id";N;s:5:"j.uid";s:3:"456";}i:3;a:3:{s:2:"id";s:1:"5";s:4:"j.id";N;s:5:"j.uid";s:3:"567";}i:4;a:3:{s:2:"id";s:1:"7";s:4:"j.id";N;s:5:"j.uid";s:3:"123";}i:5;a:3:{s:2:"id";s:1:"8";s:4:"j.id";N;s:5:"j.uid";s:3:"567";}i:6;a:3:{s:2:"id";s:3:"100";s:4:"j.id";N;s:5:"j.uid";N;}}}i:246;a:3:{s:8:"sphinxql";s:60:"select id, j.uid, j.uid is null, j.uid is not null from dist";s:10:"total_rows";i:7;s:4:"rows";a:7:{i:0;a:4:{s:2:"id";s:1:"1";s:5:"j.uid";s:3:"123";s:13:"j.uid is null";s:1:"0";s:17:"j.uid is not null";s:1:"1";}i:1;a:4:{s:2:"id";s:1:"2";s:5:"j.uid";s:3:"234";s:13:"j.uid is null";s:1:"0";s:17:"j.uid is not null";s:1:"1";}i:2;a:4:{s:2:"id";s:1:"4";s:5:"j.uid";s:3:"456";s:13:"j.uid is null";s:1:"0";s:17:"j.uid is not null";s:1:"1";}i:3;a:4:{s:2:"id";s:1:"5";s:5:"j.uid";s:3:"567";s:13:"j.uid is null";s:1:"0";s:17:"j.uid is not null";s:1:"1";}i:4;a:4:{s:2:"id";s:1:"7";s:5:"j.uid";s:3:"123";s:13:"j.uid is null";s:1:"0";s:17:"j.uid is not null";s:1:"1";}i:5;a:4:{s:2:"id";s:1:"8";s:5:"j.uid";s:3:"567";s:13:"j.uid is null";s:1:"0";s:17:"j.uid is not null";s:1:"1";}i:6;a:4:{s:2:"id";s:3:"100";s:5:"j.uid";N;s:13:"j.uid is null";s:1:"1";s:17:"j.uid is not null";s:1:"0";}}}i:247;a:3:{s:8:"sphinxql";s:102:"select all(x=1 for x in j.uid), any(x='1' for x in j.uid), indexof(x.uid='1' for x in j.uid) from dist";s:10:"total_rows";i:7;s:4:"rows";a:7:{i:0;a:3:{s:23:"all(x=1 for x in j.uid)";s:1:"0";s:25:"any(x='1' for x in j.uid)";s:1:"0";s:33:"indexof(x.uid='1' for x in j.uid)";s:2:"-1";}i:1;a:3:{s:23:"all(x=1 for x in j.uid)";s:1:"0";s:25:"any(x='1' for x in j.uid)";s:1:"0";s:33:"indexof(x.uid='1' for x in j.uid)";s:2:"-1";}i:2;a:3:{s:23:"all(x=1 for x in j.uid)";s:1:"0";s:25:"any(x='1' for x in j.uid)";s:1:"0";s:33:"indexof(x.uid='1' for x in j.uid)";s:2:"-1";}i:3;a:3:{s:23:"all(x=1 for x in j.uid)";s:1:"0";s:25:"any(x='1' for x in j.uid)";s:1:"0";s:33:"indexof(x.uid='1' for x in j.uid)";s:2:"-1";}i:4;a:3:{s:23:"all(x=1 for x in j.uid)";s:1:"0";s:25:"any(x='1' for x in j.uid)";s:1:"0";s:33:"indexof(x.uid='1' for x in j.uid)";s:2:"-1";}i:5;a:3:{s:23:"all(x=1 for x in j.uid)";s:1:"0";s:25:"any(x='1' for x in j.uid)";s:1:"0";s:33:"indexof(x.uid='1' for x in j.uid)";s:2:"-1";}i:6;a:3:{s:23:"all(x=1 for x in j.uid)";s:1:"0";s:25:"any(x='1' for x in j.uid)";s:1:"0";s:33:"indexof(x.uid='1' for x in j.uid)";s:2:"-1";}}}i:248;a:3:{s:8:"sphinxql";s:110:"select title, j.array[0].name, title='a1', j.array[0].name='a4', if(j.array[1].name='a5',0,1) from json_search";s:10:"total_rows";i:3;s:4:"rows";a:3:{i:0;a:5:{s:5:"title";s:2:"a1";s:15:"j.array[0].name";s:2:"a1";s:10:"title='a1'";s:1:"1";s:20:"j.array[0].name='a4'";s:1:"0";s:28:"if(j.array[1].name='a5',0,1)";s:1:"1";}i:1;a:5:{s:5:"title";s:2:"a5";s:15:"j.array[0].name";s:2:"a4";s:10:"title='a1'";s:1:"0";s:20:"j.array[0].name='a4'";s:1:"1";s:28:"if(j.array[1].name='a5',0,1)";s:1:"0";}i:2;a:5:{s:5:"title";s:2:"a9";s:15:"j.array[0].name";s:2:"a7";s:10:"title='a1'";s:1:"0";s:20:"j.array[0].name='a4'";s:1:"0";s:28:"if(j.array[1].name='a5',0,1)";s:1:"1";}}}i:249;a:3:{s:8:"sphinxql";s:91:"select j.array as some_alias, any(some_alias.name>x.name for x in j.array) from json_search";s:10:"total_rows";i:3;s:4:"rows";a:3:{i:0;a:2:{s:10:"some_alias";s:67:"[{"gid":1,"name":"a1"},{"gid":2,"name":"a2"},{"gid":3,"name":"a3"}]";s:44:"any(some_alias.name>x.name for x in j.array)";s:1:"0";}i:1;a:2:{s:10:"some_alias";s:67:"[{"gid":4,"name":"a4"},{"gid":5,"name":"a5"},{"gid":6,"name":"a6"}]";s:44:"any(some_alias.name>x.name for x in j.array)";s:1:"0";}i:2;a:2:{s:10:"some_alias";s:67:"[{"gid":7,"name":"a7"},{"gid":8,"name":"a8"},{"gid":9,"name":"a9"}]";s:44:"any(some_alias.name>x.name for x in j.array)";s:1:"0";}}}i:250;a:3:{s:8:"sphinxql";s:82:"select j.intarray as p, p[1], indexof(x>p[1] for x in j.intarray) from json_search";s:10:"total_rows";i:3;s:4:"rows";a:3:{i:0;a:3:{s:1:"p";s:7:"[1,2,3]";s:4:"p[1]";s:1:"2";s:35:"indexof(x>p[1] for x in j.intarray)";s:1:"2";}i:1;a:3:{s:1:"p";s:7:"[4,5,6]";s:4:"p[1]";s:1:"5";s:35:"indexof(x>p[1] for x in j.intarray)";s:1:"2";}i:2;a:3:{s:1:"p";s:7:"[7,8,9]";s:4:"p[1]";s:1:"8";s:35:"indexof(x>p[1] for x in j.intarray)";s:1:"2";}}}i:251;a:2:{s:8:"sphinxql";s:71:"insert into json_remap(id,j1,j2) values (1, '[1]','[1]'), (2, '','[2]')";s:14:"total_affected";i:2;}i:252;a:3:{s:8:"sphinxql";s:44:"select groupby() from json_remap group by j2";s:10:"total_rows";i:2;s:4:"rows";a:2:{i:0;a:1:{s:9:"groupby()";s:1:"1";}i:1;a:1:{s:9:"groupby()";s:1:"2";}}}i:253;a:3:{s:8:"sphinxql";s:64:"select count(*), groupby() from json_up1, json_up2 group by j.t1";s:10:"total_rows";i:2;s:4:"rows";a:2:{i:0;a:2:{s:8:"count(*)";s:1:"1";s:9:"groupby()";s:1:"A";}i:1;a:2:{s:8:"count(*)";s:1:"1";s:9:"groupby()";s:1:"B";}}}i:254;a:3:{s:8:"sphinxql";s:64:"select count(*), groupby() from json_up1, json_up2 group by j.T1";s:10:"total_rows";i:2;s:4:"rows";a:2:{i:0;a:2:{s:8:"count(*)";s:1:"1";s:9:"groupby()";s:1:"C";}i:1;a:2:{s:8:"count(*)";s:1:"1";s:9:"groupby()";s:1:"D";}}}i:255;a:3:{s:8:"sphinxql";s:53:"select count(*), groupby() from dist_up group by j.t1";s:10:"total_rows";i:2;s:4:"rows";a:2:{i:0;a:2:{s:8:"count(*)";s:1:"1";s:9:"groupby()";s:1:"A";}i:1;a:2:{s:8:"count(*)";s:1:"1";s:9:"groupby()";s:1:"B";}}}i:256;a:3:{s:8:"sphinxql";s:53:"select count(*), groupby() from dist_up group by j.T1";s:10:"total_rows";i:2;s:4:"rows";a:2:{i:0;a:2:{s:8:"count(*)";s:1:"1";s:9:"groupby()";s:1:"C";}i:1;a:2:{s:8:"count(*)";s:1:"1";s:9:"groupby()";s:1:"D";}}}i:257;a:3:{s:8:"sphinxql";s:44:"select integer(j.rom)=202 as p from json_up1";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:1:{s:1:"p";s:1:"1";}}}i:258;a:3:{s:8:"sphinxql";s:35:"select j.rom=202 as p from json_up1";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:1:{s:1:"p";s:1:"1";}}}i:259;a:3:{s:8:"sphinxql";s:37:"select j.rom='202' as p from json_up1";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:1:{s:1:"p";s:1:"0";}}}i:260;a:3:{s:8:"sphinxql";s:70:"select id as v, double(v) as dv, v is null, v is not null from dist_up";s:10:"total_rows";i:2;s:4:"rows";a:2:{i:0;a:4:{s:1:"v";s:1:"1";s:2:"dv";s:8:"1.000000";s:9:"v is null";s:1:"0";s:13:"v is not null";s:1:"1";}i:1;a:4:{s:1:"v";s:3:"100";s:2:"dv";s:10:"100.000000";s:9:"v is null";s:1:"0";s:13:"v is not null";s:1:"1";}}}i:261;a:3:{s:8:"sphinxql";s:73:"select j.rom as v, double(v) as dv, v is null, v is not null from dist_up";s:10:"total_rows";i:2;s:4:"rows";a:2:{i:0;a:4:{s:1:"v";s:3:"202";s:2:"dv";s:10:"202.000000";s:9:"v is null";s:1:"0";s:13:"v is not null";s:1:"1";}i:1;a:4:{s:1:"v";s:3:"303";s:2:"dv";s:10:"303.000000";s:9:"v is null";s:1:"0";s:13:"v is not null";s:1:"1";}}}i:262;a:3:{s:8:"sphinxql";s:89:"select j.rom as v, double(v) as dv, v is null, v is not null from dist_up order by dv asc";s:10:"total_rows";i:2;s:4:"rows";a:2:{i:0;a:4:{s:1:"v";s:3:"202";s:2:"dv";s:10:"202.000000";s:9:"v is null";s:1:"0";s:13:"v is not null";s:1:"1";}i:1;a:4:{s:1:"v";s:3:"303";s:2:"dv";s:10:"303.000000";s:9:"v is null";s:1:"0";s:13:"v is not null";s:1:"1";}}}i:263;a:2:{s:8:"sphinxql";s:66:"update json_inplace set j.f[0]=345345345354, j.f[1]=777 where id=1";s:14:"total_affected";i:1;}i:264;a:3:{s:8:"sphinxql";s:50:"select j.f[0], j.f[1] from json_inplace where id=1";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:2:{s:6:"j.f[0]";s:19:"345345345354.000000";s:6:"j.f[1]";s:10:"777.000000";}}}i:265;a:2:{s:8:"sphinxql";s:69:"update json_inplace_rt set j.f[0]=345345345354, j.f[1]=777 where id=1";s:14:"total_affected";i:1;}i:266;a:3:{s:8:"sphinxql";s:53:"select j.f[0], j.f[1] from json_inplace_rt where id=1";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:2:{s:6:"j.f[0]";s:19:"345345345354.000000";s:6:"j.f[1]";s:10:"777.000000";}}}i:267;a:3:{s:8:"sphinxql";s:81:"select j.f, indexof(x>345345345353 for x in j.f) as p from json_inplace where p=0";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:2:{s:3:"j.f";s:41:"[345345345354.000000,777.000000,2.000000]";s:1:"p";s:1:"0";}}}i:268;a:3:{s:8:"sphinxql";s:76:"select id, count(*), groupby(), j.a as p from arrays where id=123 group by p";s:10:"total_rows";i:4;s:4:"rows";a:4:{i:0;a:4:{s:2:"id";s:3:"123";s:8:"count(*)";s:1:"1";s:9:"groupby()";s:1:"4";s:1:"p";s:9:"[1,2,3,4]";}i:1;a:4:{s:2:"id";s:3:"123";s:8:"count(*)";s:1:"1";s:9:"groupby()";s:1:"3";s:1:"p";s:9:"[1,2,3,4]";}i:2;a:4:{s:2:"id";s:3:"123";s:8:"count(*)";s:1:"1";s:9:"groupby()";s:1:"2";s:1:"p";s:9:"[1,2,3,4]";}i:3;a:4:{s:2:"id";s:3:"123";s:8:"count(*)";s:1:"1";s:9:"groupby()";s:1:"1";s:1:"p";s:9:"[1,2,3,4]";}}}i:269;a:3:{s:8:"sphinxql";s:65:"select j from objects where id=9 and j[0]=0 and j[1]=1 and j[2]=0";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:1:{s:1:"j";s:25:"[false,true,null,"15øC"]";}}}i:270;a:3:{s:8:"sphinxql";s:66:"select j from objects where id=9 and j[0]!=1 and j[1]>0 and j[2]<1";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:1:{s:1:"j";s:25:"[false,true,null,"15øC"]";}}}i:271;a:3:{s:8:"sphinxql";s:92:"select j from objects where id=9 and integer(j[0])=0 and integer(j[1])=1 and integer(j[2])=0";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:1:{s:1:"j";s:25:"[false,true,null,"15øC"]";}}}i:272;a:3:{s:8:"sphinxql";s:91:"select j from objects where id=9 and integer(j[0])!=1 and double(j[1])>0 and bigint(j[2])<1";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:1:{s:1:"j";s:25:"[false,true,null,"15øC"]";}}}}}
|
