File: model.bin

package info (click to toggle)
sphinxsearch 2.8.2-1
  • links: PTS, VCS
  • area: main
  • in suites: experimental
  • size: 23,028 kB
  • sloc: cpp: 129,264; xml: 78,187; ansic: 9,422; sh: 8,843; php: 3,710; yacc: 2,300; java: 1,334; ruby: 1,287; python: 1,253; pascal: 1,111; lex: 291; makefile: 186; perl: 150; sql: 77; cs: 38
file content (1 line) | stat: -rw-r--r-- 44,946 bytes parent folder | download 
1
 
a:1:{i:0;a:149:{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:7:{s:3:"sel";i:1;s:2:"aa";i:1;s:2:"mm";i:1073741825;s:2:"kk";i:7;s:2:"f1";i:5;s:2:"f2";i:5;s:11:"poly2d_attr";i:7;}s:7:"matches";a:4:{i:1;a:2:{s:6:"weight";s:1:"1";s:5:"attrs";a:7:{s:3:"sel";i:1;s:2:"aa";i:2;s:2:"mm";a:0:{}s:2:"kk";s:3:"one";s:2:"f1";d:0;s:2:"f2";d:0;s:11:"poly2d_attr";s:13:"1,2,3,4,5,6.0";}}i:10;a:2:{s:6:"weight";s:1:"1";s:5:"attrs";a:7:{s:3:"sel";i:1;s:2:"aa";i:3;s:2:"mm";a:2:{i:0;i:7;i:1;i:40;}s:2:"kk";s:3:"ten";s:2:"f1";d:0;s:2:"f2";d:0;s:11:"poly2d_attr";s:13:"1,2,3,4,5,6.0";}}i:11;a:2:{s:6:"weight";s:1:"1";s:5:"attrs";a:7:{s:3:"sel";i:2;s:2:"aa";i:4;s:2:"mm";a:0:{}s:2:"kk";s:8:"eleventy";s:2:"f1";d:0.12312299758195877;s:2:"f2";d:0.4567889869213104;s:11:"poly2d_attr";s:13:"1,2,3,4,5,6.0";}}i:21;a:2:{s:6:"weight";s:1:"1";s:5:"attrs";a:7:{s:3:"sel";i:2;s:2:"aa";i:5;s:2:"mm";a:0:{}s:2:"kk";s:5:"Omagh";s:2:"f1";d:0.9528930187225342;s:2:"f2";d:-0.12749600410461426;s:11:"poly2d_attr";s:13:"1,2,3,4,5,6.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: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:7:{s:3:"sel";i:5;s:2:"aa";i:1;s:2:"mm";i:1073741825;s:2:"kk";i:7;s:2:"f1";i:5;s:2:"f2";i:5;s:11:"poly2d_attr";i:7;}s:7:"matches";a:4:{i:1;a:2:{s:6:"weight";s:1:"1";s:5:"attrs";a:7:{s:3:"sel";d:1;s:2:"aa";i:2;s:2:"mm";a:0:{}s:2:"kk";s:3:"one";s:2:"f1";d:0;s:2:"f2";d:0;s:11:"poly2d_attr";s:13:"1,2,3,4,5,6.0";}}i:10;a:2:{s:6:"weight";s:1:"1";s:5:"attrs";a:7:{s:3:"sel";d:1.5;s:2:"aa";i:3;s:2:"mm";a:2:{i:0;i:7;i:1;i:40;}s:2:"kk";s:3:"ten";s:2:"f1";d:0;s:2:"f2";d:0;s:11:"poly2d_attr";s:13:"1,2,3,4,5,6.0";}}i:11;a:2:{s:6:"weight";s:1:"1";s:5:"attrs";a:7:{s:3:"sel";d:2;s:2:"aa";i:4;s:2:"mm";a:0:{}s:2:"kk";s:8:"eleventy";s:2:"f1";d:0.12312299758195877;s:2:"f2";d:0.4567889869213104;s:11:"poly2d_attr";s:13:"1,2,3,4,5,6.0";}}i:21;a:2:{s:6:"weight";s:1:"1";s:5:"attrs";a:7:{s:3:"sel";d:2.5;s:2:"aa";i:5;s:2:"mm";a:0:{}s:2:"kk";s:5:"Omagh";s:2:"f1";d:0.9528930187225342;s:2:"f2";d:-0.12749600410461426;s:11:"poly2d_attr";s:13:"1,2,3,4,5,6.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: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:7:{s:3:"sel";i:1;s:2:"aa";i:1;s:2:"mm";i:1073741825;s:2:"kk";i:7;s:2:"f1";i:5;s:2:"f2";i:5;s:11:"poly2d_attr";i:7;}s:7:"matches";a:4:{i:1;a:2:{s:6:"weight";s:1:"1";s:5:"attrs";a:7:{s:3:"sel";i:0;s:2:"aa";i:2;s:2:"mm";a:0:{}s:2:"kk";s:3:"one";s:2:"f1";d:0;s:2:"f2";d:0;s:11:"poly2d_attr";s:13:"1,2,3,4,5,6.0";}}i:10;a:2:{s:6:"weight";s:1:"1";s:5:"attrs";a:7:{s:3:"sel";i:1;s:2:"aa";i:3;s:2:"mm";a:2:{i:0;i:7;i:1;i:40;}s:2:"kk";s:3:"ten";s:2:"f1";d:0;s:2:"f2";d:0;s:11:"poly2d_attr";s:13:"1,2,3,4,5,6.0";}}i:11;a:2:{s:6:"weight";s:1:"1";s:5:"attrs";a:7:{s:3:"sel";i:0;s:2:"aa";i:4;s:2:"mm";a:0:{}s:2:"kk";s:8:"eleventy";s:2:"f1";d:0.12312299758195877;s:2:"f2";d:0.4567889869213104;s:11:"poly2d_attr";s:13:"1,2,3,4,5,6.0";}}i:21;a:2:{s:6:"weight";s:1:"1";s:5:"attrs";a:7:{s:3:"sel";i:1;s:2:"aa";i:5;s:2:"mm";a:0:{}s:2:"kk";s:5:"Omagh";s:2:"f1";d:0.9528930187225342;s:2:"f2";d:-0.12749600410461426;s:11:"poly2d_attr";s:13:"1,2,3,4,5,6.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: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:7:{s:3:"sel";i:1;s:2:"aa";i:1;s:2:"mm";i:1073741825;s:2:"kk";i:7;s:2:"f1";i:5;s:2:"f2";i:5;s:11:"poly2d_attr";i:7;}s:7:"matches";a:4:{i:1;a:2:{s:6:"weight";s:1:"1";s:5:"attrs";a:7:{s:3:"sel";i:0;s:2:"aa";i:2;s:2:"mm";a:0:{}s:2:"kk";s:3:"one";s:2:"f1";d:0;s:2:"f2";d:0;s:11:"poly2d_attr";s:13:"1,2,3,4,5,6.0";}}i:10;a:2:{s:6:"weight";s:1:"1";s:5:"attrs";a:7:{s:3:"sel";i:1;s:2:"aa";i:3;s:2:"mm";a:2:{i:0;i:7;i:1;i:40;}s:2:"kk";s:3:"ten";s:2:"f1";d:0;s:2:"f2";d:0;s:11:"poly2d_attr";s:13:"1,2,3,4,5,6.0";}}i:11;a:2:{s:6:"weight";s:1:"1";s:5:"attrs";a:7:{s:3:"sel";i:0;s:2:"aa";i:4;s:2:"mm";a:0:{}s:2:"kk";s:8:"eleventy";s:2:"f1";d:0.12312299758195877;s:2:"f2";d:0.4567889869213104;s:11:"poly2d_attr";s:13:"1,2,3,4,5,6.0";}}i:21;a:2:{s:6:"weight";s:1:"1";s:5:"attrs";a:7:{s:3:"sel";i:1;s:2:"aa";i:5;s:2:"mm";a:0:{}s:2:"kk";s:5:"Omagh";s:2:"f1";d:0.9528930187225342;s:2:"f2";d:-0.12749600410461426;s:11:"poly2d_attr";s:13:"1,2,3,4,5,6.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:4;a:3:{s:8:"sphinxql";s:102:"SELECT 0 AND 0 OR 1 AS a, 0 AND 1 OR 1 AS b, 1 OR 0 AND 0 AS c, 1 OR 1 AND 0 AS d FROM test WHERE id=1";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:4:{s:1:"a";s:1:"1";s:1:"b";s:1:"1";s:1:"c";s:1:"1";s:1:"d";s:1:"1";}}}i:5;a:3:{s:8:"sphinxql";s:36:"SELECT id, aa div 2 as sel from test";s:10:"total_rows";i:4;s:4:"rows";a:4:{i:0;a:2:{s:2:"id";s:1:"1";s:3:"sel";s:1:"1";}i:1;a:2:{s:2:"id";s:2:"10";s:3:"sel";s:1:"1";}i:2;a:2:{s:2:"id";s:2:"11";s:3:"sel";s:1:"2";}i:3;a:2:{s:2:"id";s:2:"21";s:3:"sel";s:1:"2";}}}i:6;a:3:{s:8:"sphinxql";s:34:"SELECT id, aa / 2 as sel from test";s:10:"total_rows";i:4;s:4:"rows";a:4:{i:0;a:2:{s:2:"id";s:1:"1";s:3:"sel";s:8:"1.000000";}i:1;a:2:{s:2:"id";s:2:"10";s:3:"sel";s:8:"1.500000";}i:2;a:2:{s:2:"id";s:2:"11";s:3:"sel";s:8:"2.000000";}i:3;a:2:{s:2:"id";s:2:"21";s:3:"sel";s:8:"2.500000";}}}i:7;a:3:{s:8:"sphinxql";s:36:"SELECT id, aa mod 2 as sel from test";s:10:"total_rows";i:4;s:4:"rows";a:4:{i:0;a:2:{s:2:"id";s:1:"1";s:3:"sel";s:1:"0";}i:1;a:2:{s:2:"id";s:2:"10";s:3:"sel";s:1:"1";}i:2;a:2:{s:2:"id";s:2:"11";s:3:"sel";s:1:"0";}i:3;a:2:{s:2:"id";s:2:"21";s:3:"sel";s:1:"1";}}}i:8;a:3:{s:8:"sphinxql";s:34:"SELECT id, aa % 2 as sel from test";s:10:"total_rows";i:4;s:4:"rows";a:4:{i:0;a:2:{s:2:"id";s:1:"1";s:3:"sel";s:1:"0";}i:1;a:2:{s:2:"id";s:2:"10";s:3:"sel";s:1:"1";}i:2;a:2:{s:2:"id";s:2:"11";s:3:"sel";s:1:"0";}i:3;a:2:{s:2:"id";s:2:"21";s:3:"sel";s:1:"1";}}}i:9;a:3:{s:8:"sphinxql";s:35:"select f1, f2 FROM test where id=21";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:2:{s:2:"f1";s:8:"0.952893";s:2:"f2";s:9:"-0.127496";}}}i:10;a:3:{s:8:"sphinxql";s:46:"SELECT id, CRC32('test') FROM test WHERE id=10";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:2:{s:2:"id";s:2:"10";s:13:"crc32('test')";s:10:"3632233996";}}}i:11;a:3:{s:8:"sphinxql";s:51:"SELECT id, ABS(CRC32('test')) FROM test WHERE id=10";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:2:{s:2:"id";s:2:"10";s:18:"abs(crc32('test'))";s:9:"662733300";}}}i:12;a:3:{s:8:"sphinxql";s:41:"SELECT id, IF(IN(mm,7),111,222) FROM test";s:10:"total_rows";i:4;s:4:"rows";a:4:{i:0;a:2:{s:2:"id";s:1:"1";s:20:"if(in(mm,7),111,222)";s:3:"222";}i:1;a:2:{s:2:"id";s:2:"10";s:20:"if(in(mm,7),111,222)";s:3:"111";}i:2;a:2:{s:2:"id";s:2:"11";s:20:"if(in(mm,7),111,222)";s:3:"222";}i:3;a:2:{s:2:"id";s:2:"21";s:20:"if(in(mm,7),111,222)";s:3:"222";}}}i:13;a:3:{s:8:"sphinxql";s:47:"SELECT IN(aa-(aa-15), 15) FROM test WHERE id=10";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:1:{s:18:"in(aa-(aa-15), 15)";s:1:"1";}}}i:14;a:3:{s:8:"sphinxql";s:38:"SELECT SINT(1-2) FROM test WHERE id=10";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:1:{s:9:"sint(1-2)";s:2:"-1";}}}i:15;a:3:{s:8:"sphinxql";s:41:"SELECT FIBONACCI(5) FROM test WHERE id=10";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:1:{s:12:"fibonacci(5)";s:1:"5";}}}i:16;a:3:{s:8:"sphinxql";s:50:"SELECT INTERVAL(1, -1,3,5.0) FROM test WHERE id=10";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:1:{s:21:"interval(1, -1,3,5.0)";s:1:"1";}}}i:17;a:3:{s:8:"sphinxql";s:53:"SELECT INTERVAL(id, id-1, id+2) FROM test WHERE id=10";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:1:{s:24:"interval(id, id-1, id+2)";s:1:"1";}}}i:18;a:3:{s:8:"sphinxql";s:48:"SELECT BITDOT(5, 11,33,55) FROM test WHERE id=10";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:1:{s:19:"bitdot(5, 11,33,55)";s:2:"66";}}}i:19;a:3:{s:8:"sphinxql";s:45:"SELECT GEODIST(0,0,1,1) FROM test WHERE id=10";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:1:{s:16:"geodist(0,0,1,1)";s:14:"8120146.500000";}}}i:20;a:3:{s:8:"sphinxql";s:105:"SELECT CONTAINS(POLY2D(1,2,3,4,5,6.0),2,3), CONTAINS(POLY2D(1.0,1+1,aa,4,5,6),22,3) FROM test WHERE id=10";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:2:{s:35:"contains(poly2d(1,2,3,4,5,6.0),2,3)";s:1:"1";s:39:"contains(poly2d(1.0,1+1,aa,4,5,6),22,3)";s:1:"0";}}}i:21;a:3:{s:8:"sphinxql";s:138:"SELECT CONTAINS(GEOPOLY2D(55.7522222, 37.6155556, 40.7141667, -74.0063889, 37.9833333, 23.7333333), 51.5, -0.116667) FROM test WHERE id=10";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:1:{s:109:"contains(geopoly2d(55.7522222, 37.6155556, 40.7141667, -74.0063889, 37.9833333, 23.7333333), 51.5, -0.116667)";s:1:"1";}}}i:22;a:3:{s:8:"sphinxql";s:140:"SELECT CONTAINS(GEOPOLY2D(55.7522222, 37.6155556, 40.7141667, -74.0063889, 37.9833333, 23.7333333), 43.25, -2.9666667) FROM test WHERE id=10";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:1:{s:111:"contains(geopoly2d(55.7522222, 37.6155556, 40.7141667, -74.0063889, 37.9833333, 23.7333333), 43.25, -2.9666667)";s:1:"0";}}}i:23;a:3:{s:8:"sphinxql";s:56:"SELECT CRC32(TO_STRING(123 + 877)) FROM test WHERE id=10";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:1:{s:27:"crc32(to_string(123 + 877))";s:10:"3022496535";}}}i:24;a:3:{s:8:"sphinxql";s:112:"SELECT ABS(-1), ABS(-1.1), CEIL(1.3), FLOOR(1.3), COS(3.14/2), LN(2.7), LOG10(100), EXP(1) FROM test WHERE id=10";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:8:{s:7:"abs(-1)";s:1:"1";s:9:"abs(-1.1)";s:8:"1.100000";s:9:"ceil(1.3)";s:1:"2";s:10:"floor(1.3)";s:1:"1";s:11:"cos(3.14/2)";s:10:"0.00079627";s:7:"ln(2.7)";s:10:"0.99325180";s:10:"log10(100)";s:8:"2.000000";s:6:"exp(1)";s:10:"2.71828175";}}}i:25;a:3:{s:8:"sphinxql";s:62:"SELECT SINT(aa), NOT SINT(aa), CRC32(kk) FROM test WHERE id=10";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:3:{s:8:"sint(aa)";s:1:"3";s:12:"not sint(aa)";s:1:"0";s:9:"crc32(kk)";s:9:"507103779";}}}i:26;a:3:{s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:1:{s:12:"in(id, 10.1)";s:1:"0";}}s:8:"sphinxql";s:42:"SELECT IN(id, 10.1) FROM test WHERE id=10;";}i:27;a:3:{s:8:"sphinxql";s:87:"SELECT (1=1 AND 1=0), (1=1 AND 1=1), (1=0 AND 1=0), (1=0 AND 1=1) FROM test WHERE id=10";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:4:{s:13:"(1=1 and 1=0)";s:1:"0";s:13:"(1=1 and 1=1)";s:1:"1";s:13:"(1=0 and 1=0)";s:1:"0";s:13:"(1=0 and 1=1)";s:1:"0";}}}i:28;a:3:{s:8:"sphinxql";s:83:"SELECT (1=1 OR 1=0), (1=1 OR 1=1), (1=0 OR 1=0), (1=0 OR 1=1) FROM test WHERE id=10";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:4:{s:12:"(1=1 or 1=0)";s:1:"1";s:12:"(1=1 or 1=1)";s:1:"1";s:12:"(1=0 or 1=0)";s:1:"0";s:12:"(1=0 or 1=1)";s:1:"1";}}}i:29;a:3:{s:8:"sphinxql";s:45:"SELECT NOT 1=1, NOT 1=0 FROM test WHERE id=10";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:2:{s:7:"not 1=1";s:1:"0";s:7:"not 1=0";s:1:"1";}}}i:30;a:3:{s:8:"sphinxql";s:51:"SELECT 1<=1, 1<=2, 1<>1, 1<>0 FROM test WHERE id=10";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:4:{s:4:"1<=1";s:1:"1";s:4:"1<=2";s:1:"1";s:4:"1<>1";s:1:"0";s:4:"1<>0";s:1:"1";}}}i:31;a:3:{s:8:"sphinxql";s:102:"SELECT 3/2, id*2-2.1, 1.0-(1.0+id), 2*(3*id), 2.0/(3.0*id), 3 div 2, 3.1 div 2.2 FROM test WHERE id=10";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:7:{s:3:"3/2";s:8:"1.500000";s:8:"id*2-2.1";s:9:"17.900000";s:12:"1.0-(1.0+id)";s:10:"-10.000000";s:8:"2*(3*id)";s:2:"60";s:12:"2.0/(3.0*id)";s:10:"0.06666667";s:7:"3 div 2";s:1:"1";s:11:"3.1 div 2.2";s:8:"1.000000";}}}i:32;a:3:{s:8:"sphinxql";s:59:"SELECT (1-id)+id, (1.0/id)*id, id/2.5 FROM test WHERE id=10";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:3:{s:9:"(1-id)+id";s:1:"1";s:11:"(1.0/id)*id";s:8:"1.000000";s:6:"id/2.5";s:8:"4.000000";}}}i:33;a:3:{s:8:"sphinxql";s:60:"SELECT 1&3, 1&2, 1|3, 1|2, 13%10, 3%10 FROM test WHERE id=10";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:6:{s:3:"1&3";s:1:"1";s:3:"1&2";s:1:"0";s:3:"1|3";s:1:"3";s:3:"1|2";s:1:"3";s:5:"13%10";s:1:"3";s:4:"3%10";s:1:"3";}}}i:34;a:3:{s:8:"sphinxql";s:231:"SELECT 1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+11 FROM test WHERE id=10";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:1:{s:202:"1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+11";s:3:"111";}}}i:35;a:2:{s:8:"sphinxql";s:28:"SET GLOBAL @happyvar = (432)";s:14:"total_affected";i:0;}i:36;a:3:{s:8:"sphinxql";s:46:"SELECT IN(mm, @happyvar) FROM test WHERE id=10";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:1:{s:17:"in(mm, @happyvar)";s:1:"0";}}}i:37;a:3:{s:8:"sphinxql";s:67:"SELECT FLOOR(f1*1000)*100000 + FLOOR(f2*1000) FROM test WHERE id=11";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:1:{s:38:"floor(f1*1000)*100000 + floor(f2*1000)";s:8:"12300456";}}}i:38;a:3:{s:8:"sphinxql";s:69:"SELECT FLOOR(f1*1000)*10000000 + FLOOR(f2*1000) FROM test WHERE id=11";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:1:{s:40:"floor(f1*1000)*10000000 + floor(f2*1000)";s:10:"1230000456";}}}i:39;a:3:{s:8:"sphinxql";s:36:"SELECT id FROM cmp, cmp2 WHERE f1>22";s:10:"total_rows";i:2;s:4:"rows";a:2:{i:0;a:1:{s:2:"id";s:1:"3";}i:1;a:1:{s:2:"id";s:1:"4";}}}i:40;a:3:{s:8:"sphinxql";s:51:"SELECT id FROM cmp, cmp2 WHERE f1 between 21 and 32";s:10:"total_rows";i:2;s:4:"rows";a:2:{i:0;a:1:{s:2:"id";s:1:"2";}i:1;a:1:{s:2:"id";s:1:"3";}}}i:41;a:3:{s:8:"sphinxql";s:32:"SELECT id FROM cmp WHERE f1<31.3";s:10:"total_rows";i:2;s:4:"rows";a:2:{i:0;a:1:{s:2:"id";s:1:"1";}i:1;a:1:{s:2:"id";s:1:"2";}}}i:42;a:3:{s:8:"sphinxql";s:33:"SELECT id FROM cmp WHERE f1>=31.3";s:10:"total_rows";i:2;s:4:"rows";a:2:{i:0;a:1:{s:2:"id";s:1:"3";}i:1;a:1:{s:2:"id";s:1:"4";}}}i:43;a:3:{s:8:"sphinxql";s:42:"SELECT id, mva32 FROM cmp WHERE mva32<=310";s:10:"total_rows";i:3;s:4:"rows";a:3:{i:0;a:2:{s:2:"id";s:1:"1";s:5:"mva32";s:11:"101,102,107";}i:1;a:2:{s:2:"id";s:1:"2";s:5:"mva32";s:11:"201,210,220";}i:2;a:2:{s:2:"id";s:1:"3";s:5:"mva32";s:11:"301,310,330";}}}i:44;a:3:{s:8:"sphinxql";s:41:"SELECT id, mva32 FROM cmp WHERE mva32>220";s:10:"total_rows";i:2;s:4:"rows";a:2:{i:0;a:2:{s:2:"id";s:1:"3";s:5:"mva32";s:11:"301,310,330";}i:1;a:2:{s:2:"id";s:1:"4";s:5:"mva32";s:11:"400,601,900";}}}i:45;a:3:{s:8:"sphinxql";s:41:"SELECT id, mva32 FROM cmp WHERE mva32<301";s:10:"total_rows";i:2;s:4:"rows";a:2:{i:0;a:2:{s:2:"id";s:1:"1";s:5:"mva32";s:11:"101,102,107";}i:1;a:2:{s:2:"id";s:1:"2";s:5:"mva32";s:11:"201,210,220";}}}i:46;a:3:{s:8:"sphinxql";s:42:"SELECT id, mva32 FROM cmp WHERE mva32>=330";s:10:"total_rows";i:2;s:4:"rows";a:2:{i:0;a:2:{s:2:"id";s:1:"3";s:5:"mva32";s:11:"301,310,330";}i:1;a:2:{s:2:"id";s:1:"4";s:5:"mva32";s:11:"400,601,900";}}}i:47;a:3:{s:8:"sphinxql";s:43:"SELECT id, mva64 FROM cmp WHERE mva64<=-350";s:10:"total_rows";i:2;s:4:"rows";a:2:{i:0;a:2:{s:2:"id";s:1:"2";s:5:"mva64";s:9:"-350,-200";}i:1;a:2:{s:2:"id";s:1:"3";s:5:"mva64";s:13:"-350,-300,320";}}}i:48;a:3:{s:8:"sphinxql";s:42:"SELECT id, mva64 FROM cmp WHERE mva64>-200";s:10:"total_rows";i:3;s:4:"rows";a:3:{i:0;a:2:{s:2:"id";s:1:"1";s:5:"mva64";s:14:"-100,-50,20,70";}i:1;a:2:{s:2:"id";s:1:"3";s:5:"mva64";s:13:"-350,-300,320";}i:2;a:2:{s:2:"id";s:1:"4";s:5:"mva64";s:12:"401,500,1000";}}}i:49;a:3:{s:8:"sphinxql";s:58:"SELECT id, mva64 FROM cmp WHERE mva64 between -100 and 400";s:10:"total_rows";i:2;s:4:"rows";a:2:{i:0;a:2:{s:2:"id";s:1:"1";s:5:"mva64";s:14:"-100,-50,20,70";}i:1;a:2:{s:2:"id";s:1:"3";s:5:"mva64";s:13:"-350,-300,320";}}}i:50;a:3:{s:8:"sphinxql";s:57:"SELECT id, mva32 FROM cmp WHERE mva32 between 105 and 205";s:10:"total_rows";i:2;s:4:"rows";a:2:{i:0;a:2:{s:2:"id";s:1:"1";s:5:"mva32";s:11:"101,102,107";}i:1;a:2:{s:2:"id";s:1:"2";s:5:"mva32";s:11:"201,210,220";}}}i:51;a:3:{s:8:"sphinxql";s:66:"SELECT id, mva32, mva64, mva32 m1, mva64 m2 FROM cmp WHERE m1<=300";s:10:"total_rows";i:2;s:4:"rows";a:2:{i:0;a:5:{s:2:"id";s:1:"1";s:5:"mva32";s:11:"101,102,107";s:5:"mva64";s:14:"-100,-50,20,70";s:2:"m1";s:11:"101,102,107";s:2:"m2";s:14:"-100,-50,20,70";}i:1;a:5:{s:2:"id";s:1:"2";s:5:"mva32";s:11:"201,210,220";s:5:"mva64";s:9:"-350,-200";s:2:"m1";s:11:"201,210,220";s:2:"m2";s:9:"-350,-200";}}}i:52;a:3:{s:8:"sphinxql";s:65:"SELECT id, mva32, mva64, mva32 m1, mva64 m2 FROM cmp WHERE m2>300";s:10:"total_rows";i:2;s:4:"rows";a:2:{i:0;a:5:{s:2:"id";s:1:"3";s:5:"mva32";s:11:"301,310,330";s:5:"mva64";s:13:"-350,-300,320";s:2:"m1";s:11:"301,310,330";s:2:"m2";s:13:"-350,-300,320";}i:1;a:5:{s:2:"id";s:1:"4";s:5:"mva32";s:11:"400,601,900";s:5:"mva64";s:12:"401,500,1000";s:2:"m1";s:11:"400,601,900";s:2:"m2";s:12:"401,500,1000";}}}i:53;a:3:{s:8:"sphinxql";s:52:"SELECT id, WEIGHT()*10 FROM test WHERE MATCH('ohai')";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:2:{s:2:"id";s:2:"10";s:11:"weight()*10";s:5:"16950";}}}i:54;a:3:{s:8:"sphinxql";s:82:"SELECT crc32('one two'), crc32('one\ttwo'), crc32('one\ntwo') FROM test WHERE id=1";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:3:{s:16:"crc32('one two')";s:10:"3439823151";s:17:"crc32('one\ttwo')";s:9:"272460187";s:17:"crc32('one\ntwo')";s:8:"42518133";}}}i:55;a:3:{s:8:"sphinxql";s:41:"SELECT @@session.auto_increment_increment";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:1:{s:34:"@@session.auto_increment_increment";s:1:"1";}}}i:56;a:3:{s:8:"sphinxql";s:14:"SHOW COLLATION";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:6:{s:9:"Collation";s:15:"utf8_general_ci";s:7:"Charset";s:4:"utf8";s:2:"Id";s:2:"33";s:7:"Default";s:3:"Yes";s:8:"Compiled";s:3:"Yes";s:7:"Sortlen";s:1:"1";}}}i:57;a:3:{s:8:"sphinxql";s:18:"SHOW CHARACTER SET";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:4:{s:7:"Charset";s:4:"utf8";s:11:"Description";s:13:"UTF-8 Unicode";s:17:"Default collation";s:15:"utf8_general_ci";s:6:"Maxlen";s:1:"3";}}}i:58;a:3:{s:8:"sphinxql";s:48:"SELECT id, IN(mva32,220,230) from cmp WHERE id=2";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:2:{s:2:"id";s:1:"2";s:17:"in(mva32,220,230)";s:1:"1";}}}i:59;a:3:{s:8:"sphinxql";s:49:"SELECT id, IN(mva64,-350,230) from cmp WHERE id=2";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:2:{s:2:"id";s:1:"2";s:18:"in(mva64,-350,230)";s:1:"1";}}}i:60;a:3:{s:8:"sphinxql";s:44:"SELECT id, IN(mva64,320) from cmp WHERE id=3";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:2:{s:2:"id";s:1:"3";s:13:"in(mva64,320)";s:1:"1";}}}i:61;a:3:{s:8:"sphinxql";s:47:"SELECT id, to_string(mva32) from cmp WHERE id=3";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:2:{s:2:"id";s:1:"3";s:16:"to_string(mva32)";s:11:"301,310,330";}}}i:62;a:3:{s:8:"sphinxql";s:47:"SELECT id, to_string(mva64) from cmp WHERE id=3";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:2:{s:2:"id";s:1:"3";s:16:"to_string(mva64)";s:13:"-350,-300,320";}}}i:63;a:3:{s:8:"sphinxql";s:44:"SELECT id, length(mva32) from cmp WHERE id=3";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:2:{s:2:"id";s:1:"3";s:13:"length(mva32)";s:1:"3";}}}i:64;a:3:{s:8:"sphinxql";s:44:"SELECT id, length(mva64) from cmp WHERE id=3";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:2:{s:2:"id";s:1:"3";s:13:"length(mva64)";s:1:"3";}}}i:65;a:3:{s:8:"sphinxql";s:43:"SELECT id, least(mva64) from cmp WHERE id=3";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:2:{s:2:"id";s:1:"3";s:12:"least(mva64)";s:4:"-350";}}}i:66;a:3:{s:8:"sphinxql";s:46:"SELECT id, greatest(mva32) from cmp WHERE id=3";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:2:{s:2:"id";s:1:"3";s:15:"greatest(mva32)";s:3:"330";}}}i:67;a:3:{s:8:"sphinxql";s:46:"SELECT id, greatest(mva64) from cmp WHERE id=3";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:2:{s:2:"id";s:1:"3";s:15:"greatest(mva64)";s:3:"320";}}}i:68;a:3:{s:8:"sphinxql";s:41:"SELECT id, min(mva32) from cmp WHERE id=3";s:5:"error";s:57:"index cmp: can not aggregate non-scalar attribute 'mva32'";s:5:"errno";i:1064;}i:69;a:3:{s:8:"sphinxql";s:41:"SELECT id, max(mva32) from cmp WHERE id=3";s:5:"error";s:57:"index cmp: can not aggregate non-scalar attribute 'mva32'";s:5:"errno";i:1064;}i:70;a:3:{s:8:"sphinxql";s:41:"SELECT id, min(mva64) from cmp WHERE id=3";s:5:"error";s:57:"index cmp: can not aggregate non-scalar attribute 'mva64'";s:5:"errno";i:1064;}i:71;a:3:{s:8:"sphinxql";s:41:"SELECT id, max(mva64) from cmp WHERE id=3";s:5:"error";s:57:"index cmp: can not aggregate non-scalar attribute 'mva64'";s:5:"errno";i:1064;}i:72;a:3:{s:8:"sphinxql";s:43:"SELECT id, log10(mva32) from cmp WHERE id=3";s:5:"error";s:56:"index cmp: parse error: log10() arguments can not be MVA";s:5:"errno";i:1064;}i:73;a:3:{s:8:"sphinxql";s:43:"SELECT id, log10(mva64) from cmp WHERE id=3";s:5:"error";s:56:"index cmp: parse error: log10() arguments can not be MVA";s:5:"errno";i:1064;}i:74;a:3:{s:8:"sphinxql";s:50:"SELECT bigint(timediff(curtime(),utc_time())) % 15";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:1:{s:43:"bigint(timediff(curtime(),utc_time())) % 15";s:1:"0";}}}i:75;a:3:{s:8:"sphinxql";s:22:"SELECT 1000000*1000000";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:1:{s:15:"1000000*1000000";s:10:"-727379968";}}}i:76;a:3:{s:8:"sphinxql";s:30:"SELECT bigint(1000000)*1000000";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:1:{s:23:"bigint(1000000)*1000000";s:13:"1000000000000";}}}i:77;a:3:{s:8:"sphinxql";s:30:"SELECT 1000000*bigint(1000000)";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:1:{s:23:"1000000*bigint(1000000)";s:13:"1000000000000";}}}i:78;a:3:{s:8:"sphinxql";s:32:"SELECT bigint(1000000.0)*1000000";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:1:{s:25:"bigint(1000000.0)*1000000";s:19:"999999995904.000000";}}}i:79;a:3:{s:8:"sphinxql";s:46:"SELECT 1000000000000=bigint(1000000.0)*1000000";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:1:{s:39:"1000000000000=bigint(1000000.0)*1000000";s:1:"1";}}}i:80;a:2:{s:8:"sphinxql";s:52:"SHOW SESSION VARIABLES LIKE 'lower_case_table_names'";s:10:"total_rows";i:0;}i:81;a:3:{s:8:"sphinxql";s:21:"SELECT current_user()";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:1:{s:14:"current_user()";s:1:"0";}}}i:82;a:3:{s:8:"sphinxql";s:22:"SELECT connection_id()";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:1:{s:15:"connection_id()";s:1:"0";}}}i:83;a:2:{s:8:"sphinxql";s:22:"SET CHARACTER SET utf8";s:14:"total_affected";i:0;}i:84;a:2:{s:8:"sphinxql";s:22:"SET SQL_SAFE_UPDATES=1";s:14:"total_affected";i:0;}i:85;a:2:{s:8:"sphinxql";s:38:"SHOW SESSION VARIABLES LIKE 'sql_mode'";s:10:"total_rows";i:0;}i:86;a:2:{s:8:"sphinxql";s:14:"SHOW DATABASES";s:10:"total_rows";i:0;}i:87;a:3:{s:8:"sphinxql";s:58:"SELECT CONTAINS(POLY2D(poly2d_attr),2,3) FROM test LIMIT 1";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:1:{s:33:"contains(poly2d(poly2d_attr),2,3)";s:1:"1";}}}i:88;a:3:{s:8:"sphinxql";s:43:"SELECT 0 zero, 1/0, 1/zero FROM cmp LIMIT 1";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:3:{s:4:"zero";s:1:"0";s:3:"1/0";s:8:"0.000000";s:6:"1/zero";s:8:"0.000000";}}}i:89;a:3:{s:8:"sphinxql";s:88:"SELECT 0 zero, SINT(-1) negative, ln(0), ln(zero), ln(-1), ln(negative) FROM cmp LIMIT 1";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:6:{s:4:"zero";s:1:"0";s:8:"negative";s:2:"-1";s:5:"ln(0)";s:8:"0.000000";s:8:"ln(zero)";s:8:"0.000000";s:6:"ln(-1)";s:8:"0.000000";s:12:"ln(negative)";s:8:"0.000000";}}}i:90;a:3:{s:8:"sphinxql";s:96:"SELECT 0 zero, SINT(-1) negative, log2(0), log2(zero), log2(-1), log2(negative) FROM cmp LIMIT 1";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:6:{s:4:"zero";s:1:"0";s:8:"negative";s:2:"-1";s:7:"log2(0)";s:8:"0.000000";s:10:"log2(zero)";s:8:"0.000000";s:8:"log2(-1)";s:8:"0.000000";s:14:"log2(negative)";s:8:"0.000000";}}}i:91;a:3:{s:8:"sphinxql";s:97:"SELECT 0 zero, SINT(-1) negative, log10(0), log10(zero), log10(-1), ln(negative) FROM cmp LIMIT 1";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:6:{s:4:"zero";s:1:"0";s:8:"negative";s:2:"-1";s:8:"log10(0)";s:8:"0.000000";s:11:"log10(zero)";s:8:"0.000000";s:9:"log10(-1)";s:8:"0.000000";s:12:"ln(negative)";s:8:"0.000000";}}}i:92;a:3:{s:8:"sphinxql";s:96:"SELECT 0 zero, SINT(-1) negative, sqrt(0), sqrt(zero), sqrt(-1), sqrt(negative) FROM cmp LIMIT 1";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:6:{s:4:"zero";s:1:"0";s:8:"negative";s:2:"-1";s:7:"sqrt(0)";s:8:"0.000000";s:10:"sqrt(zero)";s:8:"0.000000";s:8:"sqrt(-1)";s:8:"0.000000";s:14:"sqrt(negative)";s:8:"0.000000";}}}i:93;a:3:{s:8:"sphinxql";s:46:"SELECT IN(kk,'one','ten','eleventy') FROM test";s:10:"total_rows";i:4;s:4:"rows";a:4:{i:0;a:1:{s:29:"in(kk,'one','ten','eleventy')";s:1:"1";}i:1;a:1:{s:29:"in(kk,'one','ten','eleventy')";s:1:"1";}i:2;a:1:{s:29:"in(kk,'one','ten','eleventy')";s:1:"1";}i:3;a:1:{s:29:"in(kk,'one','ten','eleventy')";s:1:"0";}}}i:94;a:3:{s:8:"sphinxql";s:42:"SELECT IN(kk,'is','not','there') FROM test";s:10:"total_rows";i:4;s:4:"rows";a:4:{i:0;a:1:{s:25:"in(kk,'is','not','there')";s:1:"0";}i:1;a:1:{s:25:"in(kk,'is','not','there')";s:1:"0";}i:2;a:1:{s:25:"in(kk,'is','not','there')";s:1:"0";}i:3;a:1:{s:25:"in(kk,'is','not','there')";s:1:"0";}}}i:95;a:3:{s:8:"sphinxql";s:39:"SELECT ATAN2(0,1) FROM test WHERE id=10";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:1:{s:10:"atan2(0,1)";s:8:"0.000000";}}}i:96;a:3:{s:8:"sphinxql";s:39:"SELECT ATAN2(1,0) FROM test WHERE id=10";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:1:{s:10:"atan2(1,0)";s:10:"1.57079637";}}}i:97;a:3:{s:8:"sphinxql";s:45:"SELECT ATAN2(0.75,0.25) FROM test WHERE id=10";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:1:{s:16:"atan2(0.75,0.25)";s:10:"1.24904573";}}}i:98;a:3:{s:8:"sphinxql";s:45:"SELECT ATAN2(0.25,0.75) FROM test WHERE id=10";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:1:{s:16:"atan2(0.25,0.75)";s:10:"0.32175055";}}}i:99;a:3:{s:8:"sphinxql";s:73:"SELECT GEODIST(0,0,1,1,{in=radians,out=kilometers}) FROM test WHERE id=10";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:1:{s:44:"geodist(0,0,1,1,{in=radians,out=kilometers})";s:11:"8120.146973";}}}i:100;a:3:{s:8:"sphinxql";s:51:"SELECT bigint(timediff(now(),utc_timestamp())) % 15";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:1:{s:44:"bigint(timediff(now(),utc_timestamp())) % 15";s:1:"0";}}}i:101;a:3:{s:8:"sphinxql";s:110:"select id, rand()*0, rand(0), rand(1) as p, rand(2) as q, rand(id), rand(id+1) from test order by p asc, q asc";s:10:"total_rows";i:4;s:4:"rows";a:4:{i:0;a:7:{s:2:"id";s:1:"1";s:8:"rand()*0";s:8:"0.000000";s:7:"rand(0)";s:8:"0.000000";s:1:"p";s:10:"0.28083506";s:1:"q";s:10:"0.56167012";s:8:"rand(id)";s:10:"0.28083506";s:10:"rand(id+1)";s:10:"0.56167012";}i:1;a:7:{s:2:"id";s:2:"21";s:8:"rand()*0";s:8:"0.000000";s:7:"rand(0)";s:8:"0.000000";s:1:"p";s:10:"0.30352929";s:1:"q";s:10:"0.58071792";s:8:"rand(id)";s:10:"0.16954263";s:10:"rand(id+1)";s:10:"0.74157506";}i:2;a:7:{s:2:"id";s:2:"10";s:8:"rand()*0";s:8:"0.000000";s:7:"rand(0)";s:8:"0.000000";s:1:"p";s:10:"0.67113727";s:1:"q";s:10:"0.34227452";s:8:"rand(id)";s:10:"0.51715314";s:10:"rand(id+1)";s:10:"0.79798818";}i:3;a:7:{s:2:"id";s:2:"11";s:8:"rand()*0";s:8:"0.000000";s:7:"rand(0)";s:8:"0.000000";s:1:"p";s:10:"0.72584617";s:1:"q";s:10:"0.46205461";s:8:"rand(id)";s:10:"0.79798818";s:10:"rand(id+1)";s:10:"0.80681664";}}}i:102;a:3:{s:8:"sphinxql";s:79:"select id, floor(1 + rand(id) * 4294967295) as rand from test order by rand asc";s:10:"total_rows";i:4;s:4:"rows";a:4:{i:0;a:2:{s:2:"id";s:2:"21";s:4:"rand";s:9:"728180032";}i:1;a:2:{s:2:"id";s:1:"1";s:4:"rand";s:10:"1206177408";}i:2;a:2:{s:2:"id";s:2:"10";s:4:"rand";s:10:"2221155840";}i:3;a:2:{s:2:"id";s:2:"11";s:4:"rand";s:10:"3427333120";}}}i:103;a:3:{s:8:"sphinxql";s:44:"select * from strings where string_value!=''";s:10:"total_rows";i:3;s:4:"rows";a:3:{i:0;a:2:{s:2:"id";s:1:"1";s:12:"string_value";s:4:"asdf";}i:1;a:2:{s:2:"id";s:1:"2";s:12:"string_value";s:4:"ASDF";}i:2;a:2:{s:2:"id";s:1:"3";s:12:"string_value";s:4:"qwer";}}}i:104;a:3:{s:8:"sphinxql";s:43:"select * from strings where string_value=''";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:2:{s:2:"id";s:1:"4";s:12:"string_value";s:0:"";}}}i:105;a:3:{s:8:"sphinxql";s:115:"select id, string_value, in(string_value,'asdf','qwer') as in_string, string_value='asdf' AS is_string from strings";s:10:"total_rows";i:4;s:4:"rows";a:4:{i:0;a:4:{s:2:"id";s:1:"1";s:12:"string_value";s:4:"asdf";s:9:"in_string";s:1:"1";s:9:"is_string";s:1:"1";}i:1;a:4:{s:2:"id";s:1:"2";s:12:"string_value";s:4:"ASDF";s:9:"in_string";s:1:"1";s:9:"is_string";s:1:"1";}i:2;a:4:{s:2:"id";s:1:"3";s:12:"string_value";s:4:"qwer";s:9:"in_string";s:1:"1";s:9:"is_string";s:1:"0";}i:3;a:4:{s:2:"id";s:1:"4";s:12:"string_value";s:0:"";s:9:"in_string";s:1:"0";s:9:"is_string";s:1:"0";}}}i:106;a:3:{s:8:"sphinxql";s:62:"select id, string_value from strings where string_value='asdf'";s:10:"total_rows";i:2;s:4:"rows";a:2:{i:0;a:2:{s:2:"id";s:1:"1";s:12:"string_value";s:4:"asdf";}i:1;a:2:{s:2:"id";s:1:"2";s:12:"string_value";s:4:"ASDF";}}}i:107;a:3:{s:8:"sphinxql";s:95:"select id, string_value, (string_value='asdf' or string_value='ASDF') as in_string from strings";s:10:"total_rows";i:4;s:4:"rows";a:4:{i:0;a:3:{s:2:"id";s:1:"1";s:12:"string_value";s:4:"asdf";s:9:"in_string";s:1:"1";}i:1;a:3:{s:2:"id";s:1:"2";s:12:"string_value";s:4:"ASDF";s:9:"in_string";s:1:"1";}i:2;a:3:{s:2:"id";s:1:"3";s:12:"string_value";s:4:"qwer";s:9:"in_string";s:1:"0";}i:3;a:3:{s:2:"id";s:1:"4";s:12:"string_value";s:0:"";s:9:"in_string";s:1:"0";}}}i:108;a:3:{s:8:"sphinxql";s:95:"select id, string_value, (string_value='asdf' or string_value='qwer') as in_string from strings";s:10:"total_rows";i:4;s:4:"rows";a:4:{i:0;a:3:{s:2:"id";s:1:"1";s:12:"string_value";s:4:"asdf";s:9:"in_string";s:1:"1";}i:1;a:3:{s:2:"id";s:1:"2";s:12:"string_value";s:4:"ASDF";s:9:"in_string";s:1:"1";}i:2;a:3:{s:2:"id";s:1:"3";s:12:"string_value";s:4:"qwer";s:9:"in_string";s:1:"1";}i:3;a:3:{s:2:"id";s:1:"4";s:12:"string_value";s:0:"";s:9:"in_string";s:1:"0";}}}i:109;a:3:{s:8:"sphinxql";s:77:"select id, string_value from strings where string_value in ('asdf','qwer','')";s:10:"total_rows";i:4;s:4:"rows";a:4:{i:0;a:2:{s:2:"id";s:1:"1";s:12:"string_value";s:4:"asdf";}i:1;a:2:{s:2:"id";s:1:"2";s:12:"string_value";s:4:"ASDF";}i:2;a:2:{s:2:"id";s:1:"3";s:12:"string_value";s:4:"qwer";}i:3;a:2:{s:2:"id";s:1:"4";s:12:"string_value";s:0:"";}}}i:110;a:3:{s:8:"sphinxql";s:74:"select id, string_value from strings where string_value in ('asdf','qwer')";s:10:"total_rows";i:3;s:4:"rows";a:3:{i:0;a:2:{s:2:"id";s:1:"1";s:12:"string_value";s:4:"asdf";}i:1;a:2:{s:2:"id";s:1:"2";s:12:"string_value";s:4:"ASDF";}i:2;a:2:{s:2:"id";s:1:"3";s:12:"string_value";s:4:"qwer";}}}i:111;a:3:{s:8:"sphinxql";s:67:"select id, string_value from strings where string_value not in ('')";s:10:"total_rows";i:3;s:4:"rows";a:3:{i:0;a:2:{s:2:"id";s:1:"1";s:12:"string_value";s:4:"asdf";}i:1;a:2:{s:2:"id";s:1:"2";s:12:"string_value";s:4:"ASDF";}i:2;a:2:{s:2:"id";s:1:"3";s:12:"string_value";s:4:"qwer";}}}i:112;a:3:{s:8:"sphinxql";s:62:"select id, to_string(id) as p from strings where p in('1','3')";s:10:"total_rows";i:2;s:4:"rows";a:2:{i:0;a:2:{s:2:"id";s:1:"1";s:1:"p";s:1:"1";}i:1;a:2:{s:2:"id";s:1:"3";s:1:"p";s:1:"3";}}}i:113;a:3:{s:8:"sphinxql";s:79:"select id, string_value from strings_dist where string_value in ('asdf','qwer')";s:10:"total_rows";i:3;s:4:"rows";a:3:{i:0;a:2:{s:2:"id";s:1:"1";s:12:"string_value";s:4:"asdf";}i:1;a:2:{s:2:"id";s:1:"2";s:12:"string_value";s:4:"ASDF";}i:2;a:2:{s:2:"id";s:1:"3";s:12:"string_value";s:4:"qwer";}}}i:114;a:3:{s:8:"sphinxql";s:72:"select id, string_value from strings_dist where string_value not in ('')";s:10:"total_rows";i:3;s:4:"rows";a:3:{i:0;a:2:{s:2:"id";s:1:"1";s:12:"string_value";s:4:"asdf";}i:1;a:2:{s:2:"id";s:1:"2";s:12:"string_value";s:4:"ASDF";}i:2;a:2:{s:2:"id";s:1:"3";s:12:"string_value";s:4:"qwer";}}}i:115;a:3:{s:8:"sphinxql";s:53:"select CRC32('4759') AS test_crc FROM strings LIMIT 1";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:1:{s:8:"test_crc";s:10:"2182940993";}}}i:116;a:3:{s:8:"sphinxql";s:61:"select BIGINT(CRC32('4759')) AS test_crc FROM strings LIMIT 1";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:1:{s:8:"test_crc";s:10:"2182940993";}}}i:117;a:3:{s:8:"sphinxql";s:89:"select CRC32('4759') AS test_crc, CRC32('4759')=2182940993 AS is_crc FROM strings LIMIT 1";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:2:{s:8:"test_crc";s:10:"2182940993";s:6:"is_crc";s:1:"1";}}}i:118;a:3:{s:8:"sphinxql";s:97:"SELECT CONTAINS(GEOPOLY2D(44.0,-88.0, 44.3,-88.6, 44.6,-88.0), 44.3, -88.5 ) from strings limit 1";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:1:{s:69:"contains(geopoly2d(44.0,-88.0, 44.3,-88.6, 44.6,-88.0), 44.3, -88.5 )";s:1:"1";}}}i:119;a:3:{s:8:"sphinxql";s:97:"SELECT CONTAINS(GEOPOLY2D(44.0,-88.0, 44.3,-88.6, 44.6,-88.0), 44.6, -88.5 ) from strings limit 1";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:1:{s:69:"contains(geopoly2d(44.0,-88.0, 44.3,-88.6, 44.6,-88.0), 44.6, -88.5 )";s:1:"0";}}}i:120;a:3:{s:8:"sphinxql";s:110:"SELECT CONTAINS(GEOPOLY2D(44.0,-88.0, 44.0, -88.0, 44.3,-88.6, 44.6,-88.0), 44.3, -88.5 ) from strings limit 1";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:1:{s:82:"contains(geopoly2d(44.0,-88.0, 44.0, -88.0, 44.3,-88.6, 44.6,-88.0), 44.3, -88.5 )";s:1:"1";}}}i:121;a:3:{s:8:"sphinxql";s:110:"SELECT CONTAINS(GEOPOLY2D(44.0,-88.0, 44.0, -88.0, 44.3,-88.6, 44.6,-88.0), 44.6, -88.5 ) from strings limit 1";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:1:{s:82:"contains(geopoly2d(44.0,-88.0, 44.0, -88.0, 44.3,-88.6, 44.6,-88.0), 44.6, -88.5 )";s:1:"0";}}}i:122;a:3:{s:8:"sphinxql";s:55:"select GEODIST(0,0,1,1, {in=radians, out=m} ) FROM dist";s:10:"total_rows";i:4;s:4:"rows";a:4:{i:0;a:1:{s:38:"geodist(0,0,1,1, {in=radians, out=m} )";s:14:"8120146.500000";}i:1;a:1:{s:38:"geodist(0,0,1,1, {in=radians, out=m} )";s:14:"8120146.500000";}i:2;a:1:{s:38:"geodist(0,0,1,1, {in=radians, out=m} )";s:14:"8120146.500000";}i:3;a:1:{s:38:"geodist(0,0,1,1, {in=radians, out=m} )";s:14:"8120146.500000";}}}i:123;a:3:{s:8:"sphinxql";s:55:"select GEODIST(0,0,1,1, {out=m, in=radians} ) FROM dist";s:10:"total_rows";i:4;s:4:"rows";a:4:{i:0;a:1:{s:38:"geodist(0,0,1,1, {out=m, in=radians} )";s:14:"8120146.500000";}i:1;a:1:{s:38:"geodist(0,0,1,1, {out=m, in=radians} )";s:14:"8120146.500000";}i:2;a:1:{s:38:"geodist(0,0,1,1, {out=m, in=radians} )";s:14:"8120146.500000";}i:3;a:1:{s:38:"geodist(0,0,1,1, {out=m, in=radians} )";s:14:"8120146.500000";}}}i:124;a:3:{s:8:"sphinxql";s:43:"select GEODIST(0,0,1,1, {out=m} ) FROM dist";s:10:"total_rows";i:4;s:4:"rows";a:4:{i:0;a:1:{s:26:"geodist(0,0,1,1, {out=m} )";s:14:"8120146.500000";}i:1;a:1:{s:26:"geodist(0,0,1,1, {out=m} )";s:14:"8120146.500000";}i:2;a:1:{s:26:"geodist(0,0,1,1, {out=m} )";s:14:"8120146.500000";}i:3;a:1:{s:26:"geodist(0,0,1,1, {out=m} )";s:14:"8120146.500000";}}}i:125;a:3:{s:8:"sphinxql";s:48:"select GEODIST(0,0,1,1, {in=radians} ) FROM dist";s:10:"total_rows";i:4;s:4:"rows";a:4:{i:0;a:1:{s:31:"geodist(0,0,1,1, {in=radians} )";s:14:"8120146.500000";}i:1;a:1:{s:31:"geodist(0,0,1,1, {in=radians} )";s:14:"8120146.500000";}i:2;a:1:{s:31:"geodist(0,0,1,1, {in=radians} )";s:14:"8120146.500000";}i:3;a:1:{s:31:"geodist(0,0,1,1, {in=radians} )";s:14:"8120146.500000";}}}i:126;a:3:{s:8:"sphinxql";s:77:"select @@session.auto_increment_increment AS v1, @@character_set_client as v2";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:2:{s:2:"v1";s:1:"1";s:2:"v2";s:4:"utf8";}}}i:127;a:3:{s:8:"sphinxql";s:67:"SELECT id, IN(string_value,'as\'df') FROM test1_loc order by id asc";s:10:"total_rows";i:4;s:4:"rows";a:4:{i:0;a:2:{s:2:"id";s:1:"1";s:25:"in(string_value,'as\'df')";s:1:"1";}i:1;a:2:{s:2:"id";s:1:"2";s:25:"in(string_value,'as\'df')";s:1:"0";}i:2;a:2:{s:2:"id";s:1:"3";s:25:"in(string_value,'as\'df')";s:1:"0";}i:3;a:2:{s:2:"id";s:1:"4";s:25:"in(string_value,'as\'df')";s:1:"0";}}}i:128;a:3:{s:8:"sphinxql";s:68:"SELECT id, IN(string_value,'as\'df') FROM test1_dist order by id asc";s:10:"total_rows";i:4;s:4:"rows";a:4:{i:0;a:2:{s:2:"id";s:1:"1";s:25:"in(string_value,'as\'df')";s:1:"1";}i:1;a:2:{s:2:"id";s:1:"2";s:25:"in(string_value,'as\'df')";s:1:"0";}i:2;a:2:{s:2:"id";s:1:"3";s:25:"in(string_value,'as\'df')";s:1:"0";}i:3;a:2:{s:2:"id";s:1:"4";s:25:"in(string_value,'as\'df')";s:1:"0";}}}i:129;a:3:{s:8:"sphinxql";s:63:"SELECT id, j j1, to_string ( j ) FROM test_json order by id asc";s:10:"total_rows";i:3;s:4:"rows";a:3:{i:0;a:3:{s:2:"id";s:1:"1";s:2:"j1";s:133:"{"name":"Alice","uid":123,"lon":-0.079858,"lat":0.937717,"pct":12.400000,"sq":9,"poly":"1,2,3,4,5,6.0","points":[1,2,3,4,5,6.000000]}";s:15:"to_string ( j )";s:133:"{"name":"Alice","uid":123,"lon":-0.079858,"lat":0.937717,"pct":12.400000,"sq":9,"poly":"1,2,3,4,5,6.0","points":[1,2,3,4,5,6.000000]}";}i:1;a:3:{s:2:"id";s:1:"2";s:2:"j1";s:138:"{"name":"Bob","uid":234,"gid":12,"lon":-0.079999,"lat":0.891975,"pct":-103.700000,"sq":16,"poly":"1,-2,1,2,-5,6","points":[1,-2,1,2,-5,6]}";s:15:"to_string ( j )";s:138:"{"name":"Bob","uid":234,"gid":12,"lon":-0.079999,"lat":0.891975,"pct":-103.700000,"sq":16,"poly":"1,-2,1,2,-5,6","points":[1,-2,1,2,-5,6]}";}i:2;a:3:{s:2:"id";s:1:"3";s:2:"j1";s:131:"{"name":"Charlie","uid":345,"lon":-0.072146,"lat":0.926761,"pct":4.100000,"sq":225,"poly":"-1,2,12,4,5,6","points":[-1,2,12,4,5,6]}";s:15:"to_string ( j )";s:131:"{"name":"Charlie","uid":345,"lon":-0.072146,"lat":0.926761,"pct":4.100000,"sq":225,"poly":"-1,2,12,4,5,6","points":[-1,2,12,4,5,6]}";}}}i:130;a:3:{s:8:"sphinxql";s:64:"SELECT id, j j1, to_string ( j1 ) FROM test_json order by id asc";s:10:"total_rows";i:3;s:4:"rows";a:3:{i:0;a:3:{s:2:"id";s:1:"1";s:2:"j1";s:133:"{"name":"Alice","uid":123,"lon":-0.079858,"lat":0.937717,"pct":12.400000,"sq":9,"poly":"1,2,3,4,5,6.0","points":[1,2,3,4,5,6.000000]}";s:16:"to_string ( j1 )";s:133:"{"name":"Alice","uid":123,"lon":-0.079858,"lat":0.937717,"pct":12.400000,"sq":9,"poly":"1,2,3,4,5,6.0","points":[1,2,3,4,5,6.000000]}";}i:1;a:3:{s:2:"id";s:1:"2";s:2:"j1";s:138:"{"name":"Bob","uid":234,"gid":12,"lon":-0.079999,"lat":0.891975,"pct":-103.700000,"sq":16,"poly":"1,-2,1,2,-5,6","points":[1,-2,1,2,-5,6]}";s:16:"to_string ( j1 )";s:138:"{"name":"Bob","uid":234,"gid":12,"lon":-0.079999,"lat":0.891975,"pct":-103.700000,"sq":16,"poly":"1,-2,1,2,-5,6","points":[1,-2,1,2,-5,6]}";}i:2;a:3:{s:2:"id";s:1:"3";s:2:"j1";s:131:"{"name":"Charlie","uid":345,"lon":-0.072146,"lat":0.926761,"pct":4.100000,"sq":225,"poly":"-1,2,12,4,5,6","points":[-1,2,12,4,5,6]}";s:16:"to_string ( j1 )";s:131:"{"name":"Charlie","uid":345,"lon":-0.072146,"lat":0.926761,"pct":4.100000,"sq":225,"poly":"-1,2,12,4,5,6","points":[-1,2,12,4,5,6]}";}}}i:131;a:3:{s:8:"sphinxql";s:71:"SELECT id, j.gid j1, to_string ( j.gid ) FROM test_json order by id asc";s:10:"total_rows";i:3;s:4:"rows";a:3:{i:0;a:3:{s:2:"id";s:1:"1";s:2:"j1";N;s:19:"to_string ( j.gid )";s:0:"";}i:1;a:3:{s:2:"id";s:1:"2";s:2:"j1";s:2:"12";s:19:"to_string ( j.gid )";s:2:"12";}i:2;a:3:{s:2:"id";s:1:"3";s:2:"j1";N;s:19:"to_string ( j.gid )";s:0:"";}}}i:132;a:3:{s:8:"sphinxql";s:68:"SELECT id, j.gid j1, to_string ( j1 ) FROM test_json order by id asc";s:10:"total_rows";i:3;s:4:"rows";a:3:{i:0;a:3:{s:2:"id";s:1:"1";s:2:"j1";N;s:16:"to_string ( j1 )";s:0:"";}i:1;a:3:{s:2:"id";s:1:"2";s:2:"j1";s:2:"12";s:16:"to_string ( j1 )";s:2:"12";}i:2;a:3:{s:2:"id";s:1:"3";s:2:"j1";N;s:16:"to_string ( j1 )";s:0:"";}}}i:133;a:3:{s:8:"sphinxql";s:71:"SELECT id, j.uid j1, to_string ( j.uid ) FROM test_json order by id asc";s:10:"total_rows";i:3;s:4:"rows";a:3:{i:0;a:3:{s:2:"id";s:1:"1";s:2:"j1";s:3:"123";s:19:"to_string ( j.uid )";s:3:"123";}i:1;a:3:{s:2:"id";s:1:"2";s:2:"j1";s:3:"234";s:19:"to_string ( j.uid )";s:3:"234";}i:2;a:3:{s:2:"id";s:1:"3";s:2:"j1";s:3:"345";s:19:"to_string ( j.uid )";s:3:"345";}}}i:134;a:3:{s:8:"sphinxql";s:68:"SELECT id, j.uid j1, to_string ( j1 ) FROM test_json order by id asc";s:10:"total_rows";i:3;s:4:"rows";a:3:{i:0;a:3:{s:2:"id";s:1:"1";s:2:"j1";s:3:"123";s:16:"to_string ( j1 )";s:3:"123";}i:1;a:3:{s:2:"id";s:1:"2";s:2:"j1";s:3:"234";s:16:"to_string ( j1 )";s:3:"234";}i:2;a:3:{s:2:"id";s:1:"3";s:2:"j1";s:3:"345";s:16:"to_string ( j1 )";s:3:"345";}}}i:135;a:3:{s:8:"sphinxql";s:61:"SELECT j.uid, bigint ( j.uid ) FROM test_json order by id asc";s:10:"total_rows";i:3;s:4:"rows";a:3:{i:0;a:2:{s:5:"j.uid";s:3:"123";s:16:"bigint ( j.uid )";s:3:"123";}i:1;a:2:{s:5:"j.uid";s:3:"234";s:16:"bigint ( j.uid )";s:3:"234";}i:2;a:2:{s:5:"j.uid";s:3:"345";s:16:"bigint ( j.uid )";s:3:"345";}}}i:136;a:3:{s:8:"sphinxql";s:63:"SELECT j.uid, bigint ( j.uid )+1 FROM test_json order by id asc";s:10:"total_rows";i:3;s:4:"rows";a:3:{i:0;a:2:{s:5:"j.uid";s:3:"123";s:18:"bigint ( j.uid )+1";s:3:"124";}i:1;a:2:{s:5:"j.uid";s:3:"234";s:18:"bigint ( j.uid )+1";s:3:"235";}i:2;a:2:{s:5:"j.uid";s:3:"345";s:18:"bigint ( j.uid )+1";s:3:"346";}}}i:137;a:3:{s:8:"sphinxql";s:58:"SELECT j.uid, abs ( j.uid ) FROM test_json order by id asc";s:10:"total_rows";i:3;s:4:"rows";a:3:{i:0;a:2:{s:5:"j.uid";s:3:"123";s:13:"abs ( j.uid )";s:3:"123";}i:1;a:2:{s:5:"j.uid";s:3:"234";s:13:"abs ( j.uid )";s:3:"234";}i:2;a:2:{s:5:"j.uid";s:3:"345";s:13:"abs ( j.uid )";s:3:"345";}}}i:138;a:3:{s:8:"sphinxql";s:62:"SELECT j.uid, abs ( j.uid ) + 1 FROM test_json order by id asc";s:10:"total_rows";i:3;s:4:"rows";a:3:{i:0;a:2:{s:5:"j.uid";s:3:"123";s:17:"abs ( j.uid ) + 1";s:3:"124";}i:1;a:2:{s:5:"j.uid";s:3:"234";s:17:"abs ( j.uid ) + 1";s:3:"235";}i:2;a:2:{s:5:"j.uid";s:3:"345";s:17:"abs ( j.uid ) + 1";s:3:"346";}}}i:139;a:3:{s:8:"sphinxql";s:58:"SELECT j.pct, abs ( j.pct ) FROM test_json order by id asc";s:10:"total_rows";i:3;s:4:"rows";a:3:{i:0;a:2:{s:5:"j.pct";s:9:"12.400000";s:13:"abs ( j.pct )";s:2:"12";}i:1;a:2:{s:5:"j.pct";s:11:"-103.700000";s:13:"abs ( j.pct )";s:3:"103";}i:2;a:2:{s:5:"j.pct";s:8:"4.100000";s:13:"abs ( j.pct )";s:1:"4";}}}i:140;a:3:{s:8:"sphinxql";s:62:"SELECT j.pct, abs ( j.pct ) + 1 FROM test_json order by id asc";s:10:"total_rows";i:3;s:4:"rows";a:3:{i:0;a:2:{s:5:"j.pct";s:9:"12.400000";s:17:"abs ( j.pct ) + 1";s:2:"13";}i:1;a:2:{s:5:"j.pct";s:11:"-103.700000";s:17:"abs ( j.pct ) + 1";s:3:"104";}i:2;a:2:{s:5:"j.pct";s:8:"4.100000";s:17:"abs ( j.pct ) + 1";s:1:"5";}}}i:141;a:3:{s:8:"sphinxql";s:64:"SELECT j.pct, abs ( j.pct ) + 1.1 FROM test_json order by id asc";s:10:"total_rows";i:3;s:4:"rows";a:3:{i:0;a:2:{s:5:"j.pct";s:9:"12.400000";s:19:"abs ( j.pct ) + 1.1";s:9:"13.500000";}i:1;a:2:{s:5:"j.pct";s:11:"-103.700000";s:19:"abs ( j.pct ) + 1.1";s:10:"104.799995";}i:2;a:2:{s:5:"j.pct";s:8:"4.100000";s:19:"abs ( j.pct ) + 1.1";s:8:"5.200000";}}}i:142;a:3:{s:8:"sphinxql";s:66:"SELECT j.pct, abs ( double(j.pct) ) FROM test_json order by id asc";s:10:"total_rows";i:3;s:4:"rows";a:3:{i:0;a:2:{s:5:"j.pct";s:9:"12.400000";s:21:"abs ( double(j.pct) )";s:9:"12.400000";}i:1;a:2:{s:5:"j.pct";s:11:"-103.700000";s:21:"abs ( double(j.pct) )";s:10:"103.699997";}i:2;a:2:{s:5:"j.pct";s:8:"4.100000";s:21:"abs ( double(j.pct) )";s:8:"4.100000";}}}i:143;a:3:{s:8:"sphinxql";s:58:"SELECT j.uid, sqrt ( j.sq ) FROM test_json order by id asc";s:10:"total_rows";i:3;s:4:"rows";a:3:{i:0;a:2:{s:5:"j.uid";s:3:"123";s:13:"sqrt ( j.sq )";s:8:"3.000000";}i:1;a:2:{s:5:"j.uid";s:3:"234";s:13:"sqrt ( j.sq )";s:8:"4.000000";}i:2;a:2:{s:5:"j.uid";s:3:"345";s:13:"sqrt ( j.sq )";s:9:"15.000000";}}}i:144;a:3:{s:8:"sphinxql";s:85:"select GEODIST(j.lat, j.lon,0.937717,-0.0798578, {in=radians, out=m} ) FROM test_json";s:10:"total_rows";i:3;s:4:"rows";a:3:{i:0;a:1:{s:63:"geodist(j.lat, j.lon,0.937717,-0.0798578, {in=radians, out=m} )";s:8:"0.000000";}i:1;a:1:{s:63:"geodist(j.lat, j.lon,0.937717,-0.0798578, {in=radians, out=m} )";s:13:"291635.531250";}i:2;a:1:{s:63:"geodist(j.lat, j.lon,0.937717,-0.0798578, {in=radians, out=m} )";s:12:"75791.835938";}}}i:145;a:3:{s:8:"sphinxql";s:52:"SELECT CONTAINS(POLY2D(j.poly), 2, 3) FROM test_json";s:10:"total_rows";i:3;s:4:"rows";a:3:{i:0;a:1:{s:30:"contains(poly2d(j.poly), 2, 3)";s:1:"1";}i:1;a:1:{s:30:"contains(poly2d(j.poly), 2, 3)";s:1:"0";}i:2;a:1:{s:30:"contains(poly2d(j.poly), 2, 3)";s:1:"1";}}}i:146;a:3:{s:8:"sphinxql";s:122:"SELECT CONTAINS(POLY2D(j.points[0], j.points[1], j.points[2], j.points[3], j.points[4], j.points[5]), 2, 3) FROM test_json";s:10:"total_rows";i:3;s:4:"rows";a:3:{i:0;a:1:{s:100:"contains(poly2d(j.points[0], j.points[1], j.points[2], j.points[3], j.points[4], j.points[5]), 2, 3)";s:1:"1";}i:1;a:1:{s:100:"contains(poly2d(j.points[0], j.points[1], j.points[2], j.points[3], j.points[4], j.points[5]), 2, 3)";s:1:"0";}i:2;a:1:{s:100:"contains(poly2d(j.points[0], j.points[1], j.points[2], j.points[3], j.points[4], j.points[5]), 2, 3)";s:1:"1";}}}i:147;a:3:{s:8:"sphinxql";s:57:"SELECT CONTAINS(POLY2D(j.poly), j.pct, 3 ) FROM test_json";s:10:"total_rows";i:3;s:4:"rows";a:3:{i:0;a:1:{s:35:"contains(poly2d(j.poly), j.pct, 3 )";s:1:"0";}i:1;a:1:{s:35:"contains(poly2d(j.poly), j.pct, 3 )";s:1:"0";}i:2;a:1:{s:35:"contains(poly2d(j.poly), j.pct, 3 )";s:1:"1";}}}i:148;a:3:{s:8:"sphinxql";s:57:"SELECT CONTAINS(POLY2D(j.poly), 3, j.pct ) FROM test_json";s:10:"total_rows";i:3;s:4:"rows";a:3:{i:0;a:1:{s:35:"contains(poly2d(j.poly), 3, j.pct )";s:1:"0";}i:1;a:1:{s:35:"contains(poly2d(j.poly), 3, j.pct )";s:1:"0";}i:2;a:1:{s:35:"contains(poly2d(j.poly), 3, j.pct )";s:1:"1";}}}}}