File: model.bin

package info (click to toggle)
sphinxsearch 2.2.11-11
links: PTS, VCS
area: main
in suites: forky, sid
size: 25,724 kB
sloc: cpp: 102,259; xml: 85,608; sh: 9,259; php: 3,790; ansic: 3,158; yacc: 1,969; java: 1,336; ruby: 1,289; python: 1,062; pascal: 912; perl: 381; lex: 275; makefile: 150; sql: 77; cs: 35
file content (1 line) | stat: -rw-r--r-- 31,385 bytes
parent folder | download | duplicates (4)
a:1:{i:0;a:119:{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:3:{i:1;a:2:{s:6:"weight";s:1:"1";s:5:"attrs";a:7:{s:3:"sel";s:1:"1";s:2:"aa";s:1:"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";s:1:"1";s:2:"aa";s:1:"3";s:2:"mm";a:2:{i:0;s:1:"7";i:1;s:2:"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";s:1:"2";s:2:"aa";s:1:"4";s:2:"mm";a:0:{}s:2:"kk";s:8:"eleventy";s:2:"f1";d:0.123122997581958770751953125;s:2:"f2";d:0.4567889869213104248046875;s:11:"poly2d_attr";s:13:"1,2,3,4,5,6.0";}}}s:5:"total";s:1:"3";s:11:"total_found";s:1:"3";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:3:{i:1;a:2:{s:6:"weight";s:1:"1";s:5:"attrs";a:7:{s:3:"sel";d:1;s:2:"aa";s:1:"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";s:1:"3";s:2:"mm";a:2:{i:0;s:1:"7";i:1;s:2:"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";s:1:"4";s:2:"mm";a:0:{}s:2:"kk";s:8:"eleventy";s:2:"f1";d:0.123122997581958770751953125;s:2:"f2";d:0.4567889869213104248046875;s:11:"poly2d_attr";s:13:"1,2,3,4,5,6.0";}}}s:5:"total";s:1:"3";s:11:"total_found";s:1:"3";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:3:{i:1;a:2:{s:6:"weight";s:1:"1";s:5:"attrs";a:7:{s:3:"sel";s:1:"0";s:2:"aa";s:1:"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";s:1:"1";s:2:"aa";s:1:"3";s:2:"mm";a:2:{i:0;s:1:"7";i:1;s:2:"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";s:1:"0";s:2:"aa";s:1:"4";s:2:"mm";a:0:{}s:2:"kk";s:8:"eleventy";s:2:"f1";d:0.123122997581958770751953125;s:2:"f2";d:0.4567889869213104248046875;s:11:"poly2d_attr";s:13:"1,2,3,4,5,6.0";}}}s:5:"total";s:1:"3";s:11:"total_found";s:1:"3";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:3:{i:1;a:2:{s:6:"weight";s:1:"1";s:5:"attrs";a:7:{s:3:"sel";s:1:"0";s:2:"aa";s:1:"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";s:1:"1";s:2:"aa";s:1:"3";s:2:"mm";a:2:{i:0;s:1:"7";i:1;s:2:"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";s:1:"0";s:2:"aa";s:1:"4";s:2:"mm";a:0:{}s:2:"kk";s:8:"eleventy";s:2:"f1";d:0.123122997581958770751953125;s:2:"f2";d:0.4567889869213104248046875;s:11:"poly2d_attr";s:13:"1,2,3,4,5,6.0";}}}s:5:"total";s:1:"3";s:11:"total_found";s:1:"3";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:3;s:4:"rows";a:3:{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:6;a:3:{s:8:"sphinxql";s:34:"SELECT id, aa / 2 as sel from test";s:10:"total_rows";i:3;s:4:"rows";a:3:{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:7;a:3:{s:8:"sphinxql";s:36:"SELECT id, aa mod 2 as sel from test";s:10:"total_rows";i:3;s:4:"rows";a:3:{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:8;a:3:{s:8:"sphinxql";s:34:"SELECT id, aa % 2 as sel from test";s:10:"total_rows";i:3;s:4:"rows";a:3:{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:9;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:10;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:11;a:3:{s:8:"sphinxql";s:41:"SELECT id, IF(IN(mm,7),111,222) FROM test";s:10:"total_rows";i:3;s:4:"rows";a:3:{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:12;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:13;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:14;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:15;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:16;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:17;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:18;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:19;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:20;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:21;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:22;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:23;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:8:"0.000796";s:7:"ln(2.7)";s:8:"0.993252";s:10:"log10(100)";s:8:"2.000000";s:6:"exp(1)";s:8:"2.718282";}}}i:24;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:25;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:26;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:27;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:28;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:29;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:30;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:8:"0.066667";s:7:"3 div 2";s:1:"1";s:11:"3.1 div 2.2";s:8:"1.000000";}}}i:31;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:32;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:33;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:34;a:2:{s:8:"sphinxql";s:28:"SET GLOBAL @happyvar = (432)";s:14:"total_affected";i:0;}i:35;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:36;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:37;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:38;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:39;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:40;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:41;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:42;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:43;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:44;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:45;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:46;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:47;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:48;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:49;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:50;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:"16800";}}}i:51;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:52;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:53;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:54;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:55;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:56;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:57;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:58;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:59;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:60;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:61;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:62;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:63;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:64;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:65;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:66;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:67;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:68;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:69;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:70;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:71;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:72;a:2:{s:8:"sphinxql";s:52:"SHOW SESSION VARIABLES LIKE 'lower_case_table_names'";s:10:"total_rows";i:0;}i:73;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:74;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:75;a:2:{s:8:"sphinxql";s:22:"SET CHARACTER SET utf8";s:14:"total_affected";i:0;}i:76;a:2:{s:8:"sphinxql";s:22:"SET SQL_SAFE_UPDATES=1";s:14:"total_affected";i:0;}i:77;a:2:{s:8:"sphinxql";s:38:"SHOW SESSION VARIABLES LIKE 'sql_mode'";s:10:"total_rows";i:0;}i:78;a:2:{s:8:"sphinxql";s:14:"SHOW DATABASES";s:10:"total_rows";i:0;}i:79;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:80;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:81;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:82;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:83;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:84;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:85;a:3:{s:8:"sphinxql";s:46:"SELECT IN(kk,'one','ten','eleventy') FROM test";s:10:"total_rows";i:3;s:4:"rows";a:3:{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:86;a:3:{s:8:"sphinxql";s:42:"SELECT IN(kk,'is','not','there') FROM test";s:10:"total_rows";i:3;s:4:"rows";a:3:{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:87;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:88;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:8:"1.570796";}}}i:89;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:8:"1.249046";}}}i:90;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:8:"0.321751";}}}i:91;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:92;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:93;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:94;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:95;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:96;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:97;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:98;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:99;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:100;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:101;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:102;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:103;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:104;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:105;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:106;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:107;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:108;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:109;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:110;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:111;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:112;a:3:{s:8:"sphinxql";s:55:"select GEODIST(0,0,1,1, {in=radians, out=m} ) FROM dist";s:10:"total_rows";i:3;s:4:"rows";a:3:{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:113;a:3:{s:8:"sphinxql";s:55:"select GEODIST(0,0,1,1, {out=m, in=radians} ) FROM dist";s:10:"total_rows";i:3;s:4:"rows";a:3:{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:114;a:3:{s:8:"sphinxql";s:43:"select GEODIST(0,0,1,1, {out=m} ) FROM dist";s:10:"total_rows";i:3;s:4:"rows";a:3:{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:115;a:3:{s:8:"sphinxql";s:48:"select GEODIST(0,0,1,1, {in=radians} ) FROM dist";s:10:"total_rows";i:3;s:4:"rows";a:3:{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:116;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:117;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:118;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";}}}}}