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-- 23,888 bytes parent folder | download | duplicates (5) 
1
 
a:2:{i:0;a:29:{i:0;a:3:{s:8:"sphinxql";s:56:"select * from test where match('test') order by fval asc";s:10:"total_rows";i:4;s:4:"rows";a:4:{i:0;a:3:{s:2:"id";s:1:"4";s:4:"ival";s:2:"22";s:4:"fval";s:10:"-40.000000";}i:1;a:3:{s:2:"id";s:1:"3";s:4:"ival";s:2:"11";s:4:"fval";s:10:"-30.000000";}i:2;a:3:{s:2:"id";s:1:"1";s:4:"ival";s:2:"11";s:4:"fval";s:9:"10.000000";}i:3;a:3:{s:2:"id";s:1:"2";s:4:"ival";s:2:"11";s:4:"fval";s:9:"20.000000";}}}i:1;a:3:{s:8:"sphinxql";s:69:"select *, fval+1 as f1 from test where match('test') order by f1 desc";s:10:"total_rows";i:4;s:4:"rows";a:4:{i:0;a:4:{s:2:"id";s:1:"2";s:4:"ival";s:2:"11";s:4:"fval";s:9:"20.000000";s:2:"f1";s:9:"21.000000";}i:1;a:4:{s:2:"id";s:1:"1";s:4:"ival";s:2:"11";s:4:"fval";s:9:"10.000000";s:2:"f1";s:9:"11.000000";}i:2;a:4:{s:2:"id";s:1:"3";s:4:"ival";s:2:"11";s:4:"fval";s:10:"-30.000000";s:2:"f1";s:10:"-29.000000";}i:3;a:4:{s:2:"id";s:1:"4";s:4:"ival";s:2:"22";s:4:"fval";s:10:"-40.000000";s:2:"f1";s:10:"-39.000000";}}}i:2;a:3:{s:8:"sphinxql";s:32:"select * from test group by fval";s:10:"total_rows";i:4;s:4:"rows";a:4:{i:0;a:3:{s:2:"id";s:1:"1";s:4:"ival";s:2:"11";s:4:"fval";s:9:"10.000000";}i:1;a:3:{s:2:"id";s:1:"2";s:4:"ival";s:2:"11";s:4:"fval";s:9:"20.000000";}i:2;a:3:{s:2:"id";s:1:"3";s:4:"ival";s:2:"11";s:4:"fval";s:10:"-30.000000";}i:3;a:3:{s:2:"id";s:1:"4";s:4:"ival";s:2:"22";s:4:"fval";s:10:"-40.000000";}}}i:3;a:3:{s:8:"sphinxql";s:44:"select *, ival-1 as i1 from test group by i1";s:10:"total_rows";i:2;s:4:"rows";a:2:{i:0;a:4:{s:2:"id";s:1:"1";s:4:"ival";s:2:"11";s:4:"fval";s:9:"10.000000";s:2:"i1";s:2:"10";}i:1;a:4:{s:2:"id";s:1:"4";s:4:"ival";s:2:"22";s:4:"fval";s:10:"-40.000000";s:2:"i1";s:2:"21";}}}i:4;a:3:{s:8:"sphinxql";s:59:"select *, weight()+ival as i1 from test where match('test')";s:10:"total_rows";i:4;s:4:"rows";a:4:{i:0;a:4:{s:2:"id";s:1:"1";s:4:"ival";s:2:"11";s:4:"fval";s:9:"10.000000";s:2:"i1";s:4:"1315";}i:1;a:4:{s:2:"id";s:1:"2";s:4:"ival";s:2:"11";s:4:"fval";s:9:"20.000000";s:2:"i1";s:4:"1315";}i:2;a:4:{s:2:"id";s:1:"3";s:4:"ival";s:2:"11";s:4:"fval";s:10:"-30.000000";s:2:"i1";s:4:"1315";}i:3;a:4:{s:2:"id";s:1:"4";s:4:"ival";s:2:"22";s:4:"fval";s:10:"-40.000000";s:2:"i1";s:4:"1326";}}}i:5;a:3:{s:8:"sphinxql";s:71:"select *, weight()+ival as i1 from test where match('test') and i1>1315";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:4:{s:2:"id";s:1:"4";s:4:"ival";s:2:"22";s:4:"fval";s:10:"-40.000000";s:2:"i1";s:4:"1326";}}}i:6;a:3:{s:8:"sphinxql";s:92:"select *, weight() as w, w+ival as i1, i1+10 as i2 from test where match('test') and i2>1325";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:6:{s:2:"id";s:1:"4";s:4:"ival";s:2:"22";s:4:"fval";s:10:"-40.000000";s:1:"w";s:4:"1304";s:2:"i1";s:4:"1326";s:2:"i2";s:4:"1336";}}}i:7;a:3:{s:8:"sphinxql";s:66:"select *, 10+ival as i1, 50+i1 as i2 from test where match('test')";s:10:"total_rows";i:4;s:4:"rows";a:4:{i:0;a:5:{s:2:"id";s:1:"1";s:4:"ival";s:2:"11";s:4:"fval";s:9:"10.000000";s:2:"i1";s:2:"21";s:2:"i2";s:2:"71";}i:1;a:5:{s:2:"id";s:1:"2";s:4:"ival";s:2:"11";s:4:"fval";s:9:"20.000000";s:2:"i1";s:2:"21";s:2:"i2";s:2:"71";}i:2;a:5:{s:2:"id";s:1:"3";s:4:"ival";s:2:"11";s:4:"fval";s:10:"-30.000000";s:2:"i1";s:2:"21";s:2:"i2";s:2:"71";}i:3;a:5:{s:2:"id";s:1:"4";s:4:"ival";s:2:"22";s:4:"fval";s:10:"-40.000000";s:2:"i1";s:2:"32";s:2:"i2";s:2:"82";}}}i:8;a:3:{s:8:"sphinxql";s:46:"select *, 10+ival as i1, 50+i1 as i2 from test";s:10:"total_rows";i:4;s:4:"rows";a:4:{i:0;a:5:{s:2:"id";s:1:"1";s:4:"ival";s:2:"11";s:4:"fval";s:9:"10.000000";s:2:"i1";s:2:"21";s:2:"i2";s:2:"71";}i:1;a:5:{s:2:"id";s:1:"2";s:4:"ival";s:2:"11";s:4:"fval";s:9:"20.000000";s:2:"i1";s:2:"21";s:2:"i2";s:2:"71";}i:2;a:5:{s:2:"id";s:1:"3";s:4:"ival";s:2:"11";s:4:"fval";s:10:"-30.000000";s:2:"i1";s:2:"21";s:2:"i2";s:2:"71";}i:3;a:5:{s:2:"id";s:1:"4";s:4:"ival";s:2:"22";s:4:"fval";s:10:"-40.000000";s:2:"i1";s:2:"32";s:2:"i2";s:2:"82";}}}i:9;a:3:{s:8:"sphinxql";s:59:"select *, 10+ival as i1, 50+i1 as i2, i2*10 as i3 from test";s:10:"total_rows";i:4;s:4:"rows";a:4:{i:0;a:6:{s:2:"id";s:1:"1";s:4:"ival";s:2:"11";s:4:"fval";s:9:"10.000000";s:2:"i1";s:2:"21";s:2:"i2";s:2:"71";s:2:"i3";s:3:"710";}i:1;a:6:{s:2:"id";s:1:"2";s:4:"ival";s:2:"11";s:4:"fval";s:9:"20.000000";s:2:"i1";s:2:"21";s:2:"i2";s:2:"71";s:2:"i3";s:3:"710";}i:2;a:6:{s:2:"id";s:1:"3";s:4:"ival";s:2:"11";s:4:"fval";s:10:"-30.000000";s:2:"i1";s:2:"21";s:2:"i2";s:2:"71";s:2:"i3";s:3:"710";}i:3;a:6:{s:2:"id";s:1:"4";s:4:"ival";s:2:"22";s:4:"fval";s:10:"-40.000000";s:2:"i1";s:2:"32";s:2:"i2";s:2:"82";s:2:"i3";s:3:"820";}}}i:10;a:3:{s:8:"sphinxql";s:62:"select *, 10+ival as i1, 50+i1 as i2, i2*10-i1 as i3 from test";s:10:"total_rows";i:4;s:4:"rows";a:4:{i:0;a:6:{s:2:"id";s:1:"1";s:4:"ival";s:2:"11";s:4:"fval";s:9:"10.000000";s:2:"i1";s:2:"21";s:2:"i2";s:2:"71";s:2:"i3";s:3:"689";}i:1;a:6:{s:2:"id";s:1:"2";s:4:"ival";s:2:"11";s:4:"fval";s:9:"20.000000";s:2:"i1";s:2:"21";s:2:"i2";s:2:"71";s:2:"i3";s:3:"689";}i:2;a:6:{s:2:"id";s:1:"3";s:4:"ival";s:2:"11";s:4:"fval";s:10:"-30.000000";s:2:"i1";s:2:"21";s:2:"i2";s:2:"71";s:2:"i3";s:3:"689";}i:3;a:6:{s:2:"id";s:1:"4";s:4:"ival";s:2:"22";s:4:"fval";s:10:"-40.000000";s:2:"i1";s:2:"32";s:2:"i2";s:2:"82";s:2:"i3";s:3:"788";}}}i:11;a:3:{s:8:"sphinxql";s:61:"select *, 10+ival as i1, 50+i1 as i2, i2*fval as i3 from test";s:10:"total_rows";i:4;s:4:"rows";a:4:{i:0;a:6:{s:2:"id";s:1:"1";s:4:"ival";s:2:"11";s:4:"fval";s:9:"10.000000";s:2:"i1";s:2:"21";s:2:"i2";s:2:"71";s:2:"i3";s:10:"710.000000";}i:1;a:6:{s:2:"id";s:1:"2";s:4:"ival";s:2:"11";s:4:"fval";s:9:"20.000000";s:2:"i1";s:2:"21";s:2:"i2";s:2:"71";s:2:"i3";s:11:"1420.000000";}i:2;a:6:{s:2:"id";s:1:"3";s:4:"ival";s:2:"11";s:4:"fval";s:10:"-30.000000";s:2:"i1";s:2:"21";s:2:"i2";s:2:"71";s:2:"i3";s:12:"-2130.000000";}i:3;a:6:{s:2:"id";s:1:"4";s:4:"ival";s:2:"22";s:4:"fval";s:10:"-40.000000";s:2:"i1";s:2:"32";s:2:"i2";s:2:"82";s:2:"i3";s:12:"-3280.000000";}}}i:12;a:3:{s:8:"sphinxql";s:77:"select *, 10+ival as i1, 50+i1 as i2, i2*fval as i3 from test order by i3 asc";s:10:"total_rows";i:4;s:4:"rows";a:4:{i:0;a:6:{s:2:"id";s:1:"4";s:4:"ival";s:2:"22";s:4:"fval";s:10:"-40.000000";s:2:"i1";s:2:"32";s:2:"i2";s:2:"82";s:2:"i3";s:12:"-3280.000000";}i:1;a:6:{s:2:"id";s:1:"3";s:4:"ival";s:2:"11";s:4:"fval";s:10:"-30.000000";s:2:"i1";s:2:"21";s:2:"i2";s:2:"71";s:2:"i3";s:12:"-2130.000000";}i:2;a:6:{s:2:"id";s:1:"1";s:4:"ival";s:2:"11";s:4:"fval";s:9:"10.000000";s:2:"i1";s:2:"21";s:2:"i2";s:2:"71";s:2:"i3";s:10:"710.000000";}i:3;a:6:{s:2:"id";s:1:"2";s:4:"ival";s:2:"11";s:4:"fval";s:9:"20.000000";s:2:"i1";s:2:"21";s:2:"i2";s:2:"71";s:2:"i3";s:11:"1420.000000";}}}i:13;a:3:{s:8:"sphinxql";s:86:"select *, 10+ival as i1, 50+i1 as i2, i2*fval as i3 from test order by i1 asc, i3 desc";s:10:"total_rows";i:4;s:4:"rows";a:4:{i:0;a:6:{s:2:"id";s:1:"2";s:4:"ival";s:2:"11";s:4:"fval";s:9:"20.000000";s:2:"i1";s:2:"21";s:2:"i2";s:2:"71";s:2:"i3";s:11:"1420.000000";}i:1;a:6:{s:2:"id";s:1:"1";s:4:"ival";s:2:"11";s:4:"fval";s:9:"10.000000";s:2:"i1";s:2:"21";s:2:"i2";s:2:"71";s:2:"i3";s:10:"710.000000";}i:2;a:6:{s:2:"id";s:1:"3";s:4:"ival";s:2:"11";s:4:"fval";s:10:"-30.000000";s:2:"i1";s:2:"21";s:2:"i2";s:2:"71";s:2:"i3";s:12:"-2130.000000";}i:3;a:6:{s:2:"id";s:1:"4";s:4:"ival";s:2:"22";s:4:"fval";s:10:"-40.000000";s:2:"i1";s:2:"32";s:2:"i2";s:2:"82";s:2:"i3";s:12:"-3280.000000";}}}i:14;a:3:{s:8:"sphinxql";s:73:"select *, 10+ival as i1, 50+i1 as i2, i2*fval as i3 from test group by i2";s:10:"total_rows";i:2;s:4:"rows";a:2:{i:0;a:6:{s:2:"id";s:1:"1";s:4:"ival";s:2:"11";s:4:"fval";s:9:"10.000000";s:2:"i1";s:2:"21";s:2:"i2";s:2:"71";s:2:"i3";s:10:"710.000000";}i:1;a:6:{s:2:"id";s:1:"4";s:4:"ival";s:2:"22";s:4:"fval";s:10:"-40.000000";s:2:"i1";s:2:"32";s:2:"i2";s:2:"82";s:2:"i3";s:12:"-3280.000000";}}}i:15;a:3:{s:8:"sphinxql";s:71:"select *, 10+ival as i1, 50+i1 as i2, i2*id as i3 from test group by i3";s:10:"total_rows";i:4;s:4:"rows";a:4:{i:0;a:6:{s:2:"id";s:1:"1";s:4:"ival";s:2:"11";s:4:"fval";s:9:"10.000000";s:2:"i1";s:2:"21";s:2:"i2";s:2:"71";s:2:"i3";s:2:"71";}i:1;a:6:{s:2:"id";s:1:"2";s:4:"ival";s:2:"11";s:4:"fval";s:9:"20.000000";s:2:"i1";s:2:"21";s:2:"i2";s:2:"71";s:2:"i3";s:3:"142";}i:2;a:6:{s:2:"id";s:1:"3";s:4:"ival";s:2:"11";s:4:"fval";s:10:"-30.000000";s:2:"i1";s:2:"21";s:2:"i2";s:2:"71";s:2:"i3";s:3:"213";}i:3;a:6:{s:2:"id";s:1:"4";s:4:"ival";s:2:"22";s:4:"fval";s:10:"-40.000000";s:2:"i1";s:2:"32";s:2:"i2";s:2:"82";s:2:"i3";s:3:"328";}}}i:16;a:3:{s:8:"sphinxql";s:54:"select *, IN ( mva, 11 ) as cnd1 from mva where cnd1=1";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:4:{s:2:"id";s:2:"10";s:3:"idd";s:1:"1";s:3:"mva";s:11:"10,11,12,13";s:4:"cnd1";s:1:"1";}}}i:17;a:3:{s:8:"sphinxql";s:113:"select id, idd1, idd2, idd1 + idd2 as i2 from final group by idd1 order by id desc limit 0,2 option max_matches=4";s:10:"total_rows";i:2;s:4:"rows";a:2:{i:0;a:4:{s:2:"id";s:2:"35";s:4:"idd1";s:3:"305";s:4:"idd2";s:5:"35000";s:2:"i2";s:5:"35305";}i:1;a:4:{s:2:"id";s:2:"34";s:4:"idd1";s:3:"304";s:4:"idd2";s:5:"34000";s:2:"i2";s:5:"34304";}}}i:18;a:3:{s:8:"sphinxql";s:113:"select id, idd1, idd2, idd1 + idd2 as i2 from final group by idd1 order by id desc limit 2,2 option max_matches=4";s:10:"total_rows";i:2;s:4:"rows";a:2:{i:0;a:4:{s:2:"id";s:2:"33";s:4:"idd1";s:3:"303";s:4:"idd2";s:5:"33000";s:2:"i2";s:5:"33303";}i:1;a:4:{s:2:"id";s:2:"32";s:4:"idd1";s:3:"302";s:4:"idd2";s:5:"32000";s:2:"i2";s:5:"32302";}}}i:19;a:3:{s:8:"sphinxql";s:35:"select * from test where fval<=10.0";s:10:"total_rows";i:3;s:4:"rows";a:3:{i:0;a:3:{s:2:"id";s:1:"1";s:4:"ival";s:2:"11";s:4:"fval";s:9:"10.000000";}i:1;a:3:{s:2:"id";s:1:"3";s:4:"ival";s:2:"11";s:4:"fval";s:10:"-30.000000";}i:2;a:3:{s:2:"id";s:1:"4";s:4:"ival";s:2:"22";s:4:"fval";s:10:"-40.000000";}}}i:20;a:3:{s:8:"sphinxql";s:35:"select * from test where fval>=10.0";s:10:"total_rows";i:2;s:4:"rows";a:2:{i:0;a:3:{s:2:"id";s:1:"1";s:4:"ival";s:2:"11";s:4:"fval";s:9:"10.000000";}i:1;a:3:{s:2:"id";s:1:"2";s:4:"ival";s:2:"11";s:4:"fval";s:9:"20.000000";}}}i:21;a:3:{s:8:"sphinxql";s:34:"select * from test where fval<10.0";s:10:"total_rows";i:2;s:4:"rows";a:2:{i:0;a:3:{s:2:"id";s:1:"3";s:4:"ival";s:2:"11";s:4:"fval";s:10:"-30.000000";}i:1;a:3:{s:2:"id";s:1:"4";s:4:"ival";s:2:"22";s:4:"fval";s:10:"-40.000000";}}}i:22;a:3:{s:8:"sphinxql";s:34:"select * from test where fval>10.0";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:3:{s:2:"id";s:1:"2";s:4:"ival";s:2:"11";s:4:"fval";s:9:"20.000000";}}}i:23;a:3:{s:8:"sphinxql";s:34:"select * from test where fval=10.0";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:3:{s:2:"id";s:1:"1";s:4:"ival";s:2:"11";s:4:"fval";s:9:"10.000000";}}}i:24;a:3:{s:8:"sphinxql";s:35:"select * from test where fval<>10.0";s:10:"total_rows";i:3;s:4:"rows";a:3:{i:0;a:3:{s:2:"id";s:1:"2";s:4:"ival";s:2:"11";s:4:"fval";s:9:"20.000000";}i:1;a:3:{s:2:"id";s:1:"3";s:4:"ival";s:2:"11";s:4:"fval";s:10:"-30.000000";}i:2;a:3:{s:2:"id";s:1:"4";s:4:"ival";s:2:"22";s:4:"fval";s:10:"-40.000000";}}}i:25;a:2:{s:8:"sphinxql";s:44:"select * from test_lengths where title_len=0";s:10:"total_rows";i:0;}i:26;a:3:{s:8:"sphinxql";s:44:"select * from test_lengths where title_len=2";s:10:"total_rows";i:4;s:4:"rows";a:4:{i:0;a:4:{s:2:"id";s:1:"1";s:4:"ival";s:2:"11";s:4:"fval";s:9:"10.000000";s:9:"title_len";s:1:"2";}i:1;a:4:{s:2:"id";s:1:"2";s:4:"ival";s:2:"11";s:4:"fval";s:9:"20.000000";s:9:"title_len";s:1:"2";}i:2;a:4:{s:2:"id";s:1:"3";s:4:"ival";s:2:"11";s:4:"fval";s:10:"-30.000000";s:9:"title_len";s:1:"2";}i:3;a:4:{s:2:"id";s:1:"4";s:4:"ival";s:2:"22";s:4:"fval";s:10:"-40.000000";s:9:"title_len";s:1:"2";}}}i:27;a:3:{s:8:"sphinxql";s:45:"select 50+ival*10 as ii1, 50+bad*10 from test";s:5:"error";s:44:"index test: parse error: unknown column: bad";s:5:"errno";i:1064;}i:28;a:3:{s:8:"sphinxql";s:63:"select ival*ival as p, sum(p), avg(p), min(p), max(p) from test";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:5:{s:1:"p";s:3:"121";s:6:"sum(p)";s:3:"847";s:6:"avg(p)";s:10:"211.750000";s:6:"min(p)";s:3:"121";s:6:"max(p)";s:3:"484";}}}}i:1;a:29:{i:0;a:3:{s:8:"sphinxql";s:56:"select * from test where match('test') order by fval asc";s:10:"total_rows";i:4;s:4:"rows";a:4:{i:0;a:3:{s:2:"id";s:1:"4";s:4:"ival";s:2:"22";s:4:"fval";s:10:"-40.000000";}i:1;a:3:{s:2:"id";s:1:"3";s:4:"ival";s:2:"11";s:4:"fval";s:10:"-30.000000";}i:2;a:3:{s:2:"id";s:1:"1";s:4:"ival";s:2:"11";s:4:"fval";s:9:"10.000000";}i:3;a:3:{s:2:"id";s:1:"2";s:4:"ival";s:2:"11";s:4:"fval";s:9:"20.000000";}}}i:1;a:3:{s:8:"sphinxql";s:69:"select *, fval+1 as f1 from test where match('test') order by f1 desc";s:10:"total_rows";i:4;s:4:"rows";a:4:{i:0;a:4:{s:2:"id";s:1:"2";s:4:"ival";s:2:"11";s:4:"fval";s:9:"20.000000";s:2:"f1";s:9:"21.000000";}i:1;a:4:{s:2:"id";s:1:"1";s:4:"ival";s:2:"11";s:4:"fval";s:9:"10.000000";s:2:"f1";s:9:"11.000000";}i:2;a:4:{s:2:"id";s:1:"3";s:4:"ival";s:2:"11";s:4:"fval";s:10:"-30.000000";s:2:"f1";s:10:"-29.000000";}i:3;a:4:{s:2:"id";s:1:"4";s:4:"ival";s:2:"22";s:4:"fval";s:10:"-40.000000";s:2:"f1";s:10:"-39.000000";}}}i:2;a:3:{s:8:"sphinxql";s:32:"select * from test group by fval";s:10:"total_rows";i:4;s:4:"rows";a:4:{i:0;a:3:{s:2:"id";s:1:"1";s:4:"ival";s:2:"11";s:4:"fval";s:9:"10.000000";}i:1;a:3:{s:2:"id";s:1:"2";s:4:"ival";s:2:"11";s:4:"fval";s:9:"20.000000";}i:2;a:3:{s:2:"id";s:1:"3";s:4:"ival";s:2:"11";s:4:"fval";s:10:"-30.000000";}i:3;a:3:{s:2:"id";s:1:"4";s:4:"ival";s:2:"22";s:4:"fval";s:10:"-40.000000";}}}i:3;a:3:{s:8:"sphinxql";s:44:"select *, ival-1 as i1 from test group by i1";s:10:"total_rows";i:2;s:4:"rows";a:2:{i:0;a:4:{s:2:"id";s:1:"1";s:4:"ival";s:2:"11";s:4:"fval";s:9:"10.000000";s:2:"i1";s:2:"10";}i:1;a:4:{s:2:"id";s:1:"4";s:4:"ival";s:2:"22";s:4:"fval";s:10:"-40.000000";s:2:"i1";s:2:"21";}}}i:4;a:3:{s:8:"sphinxql";s:59:"select *, weight()+ival as i1 from test where match('test')";s:10:"total_rows";i:4;s:4:"rows";a:4:{i:0;a:4:{s:2:"id";s:1:"1";s:4:"ival";s:2:"11";s:4:"fval";s:9:"10.000000";s:2:"i1";s:4:"1315";}i:1;a:4:{s:2:"id";s:1:"2";s:4:"ival";s:2:"11";s:4:"fval";s:9:"20.000000";s:2:"i1";s:4:"1315";}i:2;a:4:{s:2:"id";s:1:"3";s:4:"ival";s:2:"11";s:4:"fval";s:10:"-30.000000";s:2:"i1";s:4:"1315";}i:3;a:4:{s:2:"id";s:1:"4";s:4:"ival";s:2:"22";s:4:"fval";s:10:"-40.000000";s:2:"i1";s:4:"1326";}}}i:5;a:3:{s:8:"sphinxql";s:71:"select *, weight()+ival as i1 from test where match('test') and i1>1315";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:4:{s:2:"id";s:1:"4";s:4:"ival";s:2:"22";s:4:"fval";s:10:"-40.000000";s:2:"i1";s:4:"1326";}}}i:6;a:3:{s:8:"sphinxql";s:92:"select *, weight() as w, w+ival as i1, i1+10 as i2 from test where match('test') and i2>1325";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:6:{s:2:"id";s:1:"4";s:4:"ival";s:2:"22";s:4:"fval";s:10:"-40.000000";s:1:"w";s:4:"1304";s:2:"i1";s:4:"1326";s:2:"i2";s:4:"1336";}}}i:7;a:3:{s:8:"sphinxql";s:66:"select *, 10+ival as i1, 50+i1 as i2 from test where match('test')";s:10:"total_rows";i:4;s:4:"rows";a:4:{i:0;a:5:{s:2:"id";s:1:"1";s:4:"ival";s:2:"11";s:4:"fval";s:9:"10.000000";s:2:"i1";s:2:"21";s:2:"i2";s:2:"71";}i:1;a:5:{s:2:"id";s:1:"2";s:4:"ival";s:2:"11";s:4:"fval";s:9:"20.000000";s:2:"i1";s:2:"21";s:2:"i2";s:2:"71";}i:2;a:5:{s:2:"id";s:1:"3";s:4:"ival";s:2:"11";s:4:"fval";s:10:"-30.000000";s:2:"i1";s:2:"21";s:2:"i2";s:2:"71";}i:3;a:5:{s:2:"id";s:1:"4";s:4:"ival";s:2:"22";s:4:"fval";s:10:"-40.000000";s:2:"i1";s:2:"32";s:2:"i2";s:2:"82";}}}i:8;a:3:{s:8:"sphinxql";s:46:"select *, 10+ival as i1, 50+i1 as i2 from test";s:10:"total_rows";i:4;s:4:"rows";a:4:{i:0;a:5:{s:2:"id";s:1:"1";s:4:"ival";s:2:"11";s:4:"fval";s:9:"10.000000";s:2:"i1";s:2:"21";s:2:"i2";s:2:"71";}i:1;a:5:{s:2:"id";s:1:"2";s:4:"ival";s:2:"11";s:4:"fval";s:9:"20.000000";s:2:"i1";s:2:"21";s:2:"i2";s:2:"71";}i:2;a:5:{s:2:"id";s:1:"3";s:4:"ival";s:2:"11";s:4:"fval";s:10:"-30.000000";s:2:"i1";s:2:"21";s:2:"i2";s:2:"71";}i:3;a:5:{s:2:"id";s:1:"4";s:4:"ival";s:2:"22";s:4:"fval";s:10:"-40.000000";s:2:"i1";s:2:"32";s:2:"i2";s:2:"82";}}}i:9;a:3:{s:8:"sphinxql";s:59:"select *, 10+ival as i1, 50+i1 as i2, i2*10 as i3 from test";s:10:"total_rows";i:4;s:4:"rows";a:4:{i:0;a:6:{s:2:"id";s:1:"1";s:4:"ival";s:2:"11";s:4:"fval";s:9:"10.000000";s:2:"i1";s:2:"21";s:2:"i2";s:2:"71";s:2:"i3";s:3:"710";}i:1;a:6:{s:2:"id";s:1:"2";s:4:"ival";s:2:"11";s:4:"fval";s:9:"20.000000";s:2:"i1";s:2:"21";s:2:"i2";s:2:"71";s:2:"i3";s:3:"710";}i:2;a:6:{s:2:"id";s:1:"3";s:4:"ival";s:2:"11";s:4:"fval";s:10:"-30.000000";s:2:"i1";s:2:"21";s:2:"i2";s:2:"71";s:2:"i3";s:3:"710";}i:3;a:6:{s:2:"id";s:1:"4";s:4:"ival";s:2:"22";s:4:"fval";s:10:"-40.000000";s:2:"i1";s:2:"32";s:2:"i2";s:2:"82";s:2:"i3";s:3:"820";}}}i:10;a:3:{s:8:"sphinxql";s:62:"select *, 10+ival as i1, 50+i1 as i2, i2*10-i1 as i3 from test";s:10:"total_rows";i:4;s:4:"rows";a:4:{i:0;a:6:{s:2:"id";s:1:"1";s:4:"ival";s:2:"11";s:4:"fval";s:9:"10.000000";s:2:"i1";s:2:"21";s:2:"i2";s:2:"71";s:2:"i3";s:3:"689";}i:1;a:6:{s:2:"id";s:1:"2";s:4:"ival";s:2:"11";s:4:"fval";s:9:"20.000000";s:2:"i1";s:2:"21";s:2:"i2";s:2:"71";s:2:"i3";s:3:"689";}i:2;a:6:{s:2:"id";s:1:"3";s:4:"ival";s:2:"11";s:4:"fval";s:10:"-30.000000";s:2:"i1";s:2:"21";s:2:"i2";s:2:"71";s:2:"i3";s:3:"689";}i:3;a:6:{s:2:"id";s:1:"4";s:4:"ival";s:2:"22";s:4:"fval";s:10:"-40.000000";s:2:"i1";s:2:"32";s:2:"i2";s:2:"82";s:2:"i3";s:3:"788";}}}i:11;a:3:{s:8:"sphinxql";s:61:"select *, 10+ival as i1, 50+i1 as i2, i2*fval as i3 from test";s:10:"total_rows";i:4;s:4:"rows";a:4:{i:0;a:6:{s:2:"id";s:1:"1";s:4:"ival";s:2:"11";s:4:"fval";s:9:"10.000000";s:2:"i1";s:2:"21";s:2:"i2";s:2:"71";s:2:"i3";s:10:"710.000000";}i:1;a:6:{s:2:"id";s:1:"2";s:4:"ival";s:2:"11";s:4:"fval";s:9:"20.000000";s:2:"i1";s:2:"21";s:2:"i2";s:2:"71";s:2:"i3";s:11:"1420.000000";}i:2;a:6:{s:2:"id";s:1:"3";s:4:"ival";s:2:"11";s:4:"fval";s:10:"-30.000000";s:2:"i1";s:2:"21";s:2:"i2";s:2:"71";s:2:"i3";s:12:"-2130.000000";}i:3;a:6:{s:2:"id";s:1:"4";s:4:"ival";s:2:"22";s:4:"fval";s:10:"-40.000000";s:2:"i1";s:2:"32";s:2:"i2";s:2:"82";s:2:"i3";s:12:"-3280.000000";}}}i:12;a:3:{s:8:"sphinxql";s:77:"select *, 10+ival as i1, 50+i1 as i2, i2*fval as i3 from test order by i3 asc";s:10:"total_rows";i:4;s:4:"rows";a:4:{i:0;a:6:{s:2:"id";s:1:"4";s:4:"ival";s:2:"22";s:4:"fval";s:10:"-40.000000";s:2:"i1";s:2:"32";s:2:"i2";s:2:"82";s:2:"i3";s:12:"-3280.000000";}i:1;a:6:{s:2:"id";s:1:"3";s:4:"ival";s:2:"11";s:4:"fval";s:10:"-30.000000";s:2:"i1";s:2:"21";s:2:"i2";s:2:"71";s:2:"i3";s:12:"-2130.000000";}i:2;a:6:{s:2:"id";s:1:"1";s:4:"ival";s:2:"11";s:4:"fval";s:9:"10.000000";s:2:"i1";s:2:"21";s:2:"i2";s:2:"71";s:2:"i3";s:10:"710.000000";}i:3;a:6:{s:2:"id";s:1:"2";s:4:"ival";s:2:"11";s:4:"fval";s:9:"20.000000";s:2:"i1";s:2:"21";s:2:"i2";s:2:"71";s:2:"i3";s:11:"1420.000000";}}}i:13;a:3:{s:8:"sphinxql";s:86:"select *, 10+ival as i1, 50+i1 as i2, i2*fval as i3 from test order by i1 asc, i3 desc";s:10:"total_rows";i:4;s:4:"rows";a:4:{i:0;a:6:{s:2:"id";s:1:"2";s:4:"ival";s:2:"11";s:4:"fval";s:9:"20.000000";s:2:"i1";s:2:"21";s:2:"i2";s:2:"71";s:2:"i3";s:11:"1420.000000";}i:1;a:6:{s:2:"id";s:1:"1";s:4:"ival";s:2:"11";s:4:"fval";s:9:"10.000000";s:2:"i1";s:2:"21";s:2:"i2";s:2:"71";s:2:"i3";s:10:"710.000000";}i:2;a:6:{s:2:"id";s:1:"3";s:4:"ival";s:2:"11";s:4:"fval";s:10:"-30.000000";s:2:"i1";s:2:"21";s:2:"i2";s:2:"71";s:2:"i3";s:12:"-2130.000000";}i:3;a:6:{s:2:"id";s:1:"4";s:4:"ival";s:2:"22";s:4:"fval";s:10:"-40.000000";s:2:"i1";s:2:"32";s:2:"i2";s:2:"82";s:2:"i3";s:12:"-3280.000000";}}}i:14;a:3:{s:8:"sphinxql";s:73:"select *, 10+ival as i1, 50+i1 as i2, i2*fval as i3 from test group by i2";s:10:"total_rows";i:2;s:4:"rows";a:2:{i:0;a:6:{s:2:"id";s:1:"1";s:4:"ival";s:2:"11";s:4:"fval";s:9:"10.000000";s:2:"i1";s:2:"21";s:2:"i2";s:2:"71";s:2:"i3";s:10:"710.000000";}i:1;a:6:{s:2:"id";s:1:"4";s:4:"ival";s:2:"22";s:4:"fval";s:10:"-40.000000";s:2:"i1";s:2:"32";s:2:"i2";s:2:"82";s:2:"i3";s:12:"-3280.000000";}}}i:15;a:3:{s:8:"sphinxql";s:71:"select *, 10+ival as i1, 50+i1 as i2, i2*id as i3 from test group by i3";s:10:"total_rows";i:4;s:4:"rows";a:4:{i:0;a:6:{s:2:"id";s:1:"1";s:4:"ival";s:2:"11";s:4:"fval";s:9:"10.000000";s:2:"i1";s:2:"21";s:2:"i2";s:2:"71";s:2:"i3";s:2:"71";}i:1;a:6:{s:2:"id";s:1:"2";s:4:"ival";s:2:"11";s:4:"fval";s:9:"20.000000";s:2:"i1";s:2:"21";s:2:"i2";s:2:"71";s:2:"i3";s:3:"142";}i:2;a:6:{s:2:"id";s:1:"3";s:4:"ival";s:2:"11";s:4:"fval";s:10:"-30.000000";s:2:"i1";s:2:"21";s:2:"i2";s:2:"71";s:2:"i3";s:3:"213";}i:3;a:6:{s:2:"id";s:1:"4";s:4:"ival";s:2:"22";s:4:"fval";s:10:"-40.000000";s:2:"i1";s:2:"32";s:2:"i2";s:2:"82";s:2:"i3";s:3:"328";}}}i:16;a:3:{s:8:"sphinxql";s:54:"select *, IN ( mva, 11 ) as cnd1 from mva where cnd1=1";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:4:{s:2:"id";s:2:"10";s:3:"idd";s:1:"1";s:3:"mva";s:11:"10,11,12,13";s:4:"cnd1";s:1:"1";}}}i:17;a:3:{s:8:"sphinxql";s:113:"select id, idd1, idd2, idd1 + idd2 as i2 from final group by idd1 order by id desc limit 0,2 option max_matches=4";s:10:"total_rows";i:2;s:4:"rows";a:2:{i:0;a:4:{s:2:"id";s:2:"35";s:4:"idd1";s:3:"305";s:4:"idd2";s:5:"35000";s:2:"i2";s:5:"35305";}i:1;a:4:{s:2:"id";s:2:"34";s:4:"idd1";s:3:"304";s:4:"idd2";s:5:"34000";s:2:"i2";s:5:"34304";}}}i:18;a:3:{s:8:"sphinxql";s:113:"select id, idd1, idd2, idd1 + idd2 as i2 from final group by idd1 order by id desc limit 2,2 option max_matches=4";s:10:"total_rows";i:2;s:4:"rows";a:2:{i:0;a:4:{s:2:"id";s:2:"33";s:4:"idd1";s:3:"303";s:4:"idd2";s:5:"33000";s:2:"i2";s:5:"33303";}i:1;a:4:{s:2:"id";s:2:"32";s:4:"idd1";s:3:"302";s:4:"idd2";s:5:"32000";s:2:"i2";s:5:"32302";}}}i:19;a:3:{s:8:"sphinxql";s:35:"select * from test where fval<=10.0";s:10:"total_rows";i:3;s:4:"rows";a:3:{i:0;a:3:{s:2:"id";s:1:"1";s:4:"ival";s:2:"11";s:4:"fval";s:9:"10.000000";}i:1;a:3:{s:2:"id";s:1:"3";s:4:"ival";s:2:"11";s:4:"fval";s:10:"-30.000000";}i:2;a:3:{s:2:"id";s:1:"4";s:4:"ival";s:2:"22";s:4:"fval";s:10:"-40.000000";}}}i:20;a:3:{s:8:"sphinxql";s:35:"select * from test where fval>=10.0";s:10:"total_rows";i:2;s:4:"rows";a:2:{i:0;a:3:{s:2:"id";s:1:"1";s:4:"ival";s:2:"11";s:4:"fval";s:9:"10.000000";}i:1;a:3:{s:2:"id";s:1:"2";s:4:"ival";s:2:"11";s:4:"fval";s:9:"20.000000";}}}i:21;a:3:{s:8:"sphinxql";s:34:"select * from test where fval<10.0";s:10:"total_rows";i:2;s:4:"rows";a:2:{i:0;a:3:{s:2:"id";s:1:"3";s:4:"ival";s:2:"11";s:4:"fval";s:10:"-30.000000";}i:1;a:3:{s:2:"id";s:1:"4";s:4:"ival";s:2:"22";s:4:"fval";s:10:"-40.000000";}}}i:22;a:3:{s:8:"sphinxql";s:34:"select * from test where fval>10.0";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:3:{s:2:"id";s:1:"2";s:4:"ival";s:2:"11";s:4:"fval";s:9:"20.000000";}}}i:23;a:3:{s:8:"sphinxql";s:34:"select * from test where fval=10.0";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:3:{s:2:"id";s:1:"1";s:4:"ival";s:2:"11";s:4:"fval";s:9:"10.000000";}}}i:24;a:3:{s:8:"sphinxql";s:35:"select * from test where fval<>10.0";s:10:"total_rows";i:3;s:4:"rows";a:3:{i:0;a:3:{s:2:"id";s:1:"2";s:4:"ival";s:2:"11";s:4:"fval";s:9:"20.000000";}i:1;a:3:{s:2:"id";s:1:"3";s:4:"ival";s:2:"11";s:4:"fval";s:10:"-30.000000";}i:2;a:3:{s:2:"id";s:1:"4";s:4:"ival";s:2:"22";s:4:"fval";s:10:"-40.000000";}}}i:25;a:2:{s:8:"sphinxql";s:44:"select * from test_lengths where title_len=0";s:10:"total_rows";i:0;}i:26;a:3:{s:8:"sphinxql";s:44:"select * from test_lengths where title_len=2";s:10:"total_rows";i:4;s:4:"rows";a:4:{i:0;a:4:{s:2:"id";s:1:"1";s:4:"ival";s:2:"11";s:4:"fval";s:9:"10.000000";s:9:"title_len";s:1:"2";}i:1;a:4:{s:2:"id";s:1:"2";s:4:"ival";s:2:"11";s:4:"fval";s:9:"20.000000";s:9:"title_len";s:1:"2";}i:2;a:4:{s:2:"id";s:1:"3";s:4:"ival";s:2:"11";s:4:"fval";s:10:"-30.000000";s:9:"title_len";s:1:"2";}i:3;a:4:{s:2:"id";s:1:"4";s:4:"ival";s:2:"22";s:4:"fval";s:10:"-40.000000";s:9:"title_len";s:1:"2";}}}i:27;a:3:{s:8:"sphinxql";s:45:"select 50+ival*10 as ii1, 50+bad*10 from test";s:5:"error";s:44:"index test: parse error: unknown column: bad";s:5:"errno";i:1064;}i:28;a:3:{s:8:"sphinxql";s:63:"select ival*ival as p, sum(p), avg(p), min(p), max(p) from test";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:5:{s:1:"p";s:3:"121";s:6:"sum(p)";s:3:"847";s:6:"avg(p)";s:10:"211.750000";s:6:"min(p)";s:3:"121";s:6:"max(p)";s:3:"484";}}}}}