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-- 12,408 bytes
parent folder | download | duplicates (5)
a:1:{i:0;a:26:{i:0;a:2:{s:8:"sphinxql";s:85:"insert into rt1 (id, idd, str1, mva1, body) values ( 1, 1, '', ( 100, 10, 1), 'the' )";s:14:"total_affected";i:1;}i:1;a:2:{s:8:"sphinxql";s:85:"insert into rt1 (id, idd, str1, mva2, body) values ( 2, 2, '', ( 11, 13, 12), 'the' )";s:14:"total_affected";i:1;}i:2;a:3:{s:8:"sphinxql";s:31:"select * from rt1 where mva1>12";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:5:{s:2:"id";s:1:"1";s:3:"idd";s:1:"1";s:4:"str1";s:0:"";s:4:"mva1";s:8:"1,10,100";s:4:"mva2";s:0:"";}}}i:3;a:3:{s:8:"sphinxql";s:50:"select * from rt1 where match ('the')  and mva1>12";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:5:{s:2:"id";s:1:"1";s:3:"idd";s:1:"1";s:4:"str1";s:0:"";s:4:"mva1";s:8:"1,10,100";s:4:"mva2";s:0:"";}}}i:4;a:3:{s:8:"sphinxql";s:31:"select * from rt1 where mva1=10";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:5:{s:2:"id";s:1:"1";s:3:"idd";s:1:"1";s:4:"str1";s:0:"";s:4:"mva1";s:8:"1,10,100";s:4:"mva2";s:0:"";}}}i:5;a:3:{s:8:"sphinxql";s:50:"select * from rt1 where match ('the')  and mva1=10";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:5:{s:2:"id";s:1:"1";s:3:"idd";s:1:"1";s:4:"str1";s:0:"";s:4:"mva1";s:8:"1,10,100";s:4:"mva2";s:0:"";}}}i:6;a:3:{s:8:"sphinxql";s:33:"select * from rt1 where mva1!=100";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:5:{s:2:"id";s:1:"2";s:3:"idd";s:1:"2";s:4:"str1";s:0:"";s:4:"mva1";s:0:"";s:4:"mva2";s:8:"11,12,13";}}}i:7;a:3:{s:8:"sphinxql";s:52:"select * from rt1 where match ('the')  and mva1!=100";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:5:{s:2:"id";s:1:"2";s:3:"idd";s:1:"2";s:4:"str1";s:0:"";s:4:"mva1";s:0:"";s:4:"mva2";s:8:"11,12,13";}}}i:8;a:2:{s:8:"sphinxql";s:112:"insert into rt1 (id, idd, str1, mva1, mva2, body) values ( 3, 3, '', ( 200, 201, 210),  (300, 301, 310), 'the' )";s:14:"total_affected";i:1;}i:9;a:3:{s:8:"sphinxql";s:33:"select * from rt1 order by id asc";s:10:"total_rows";i:3;s:4:"rows";a:3:{i:0;a:5:{s:2:"id";s:1:"1";s:3:"idd";s:1:"1";s:4:"str1";s:0:"";s:4:"mva1";s:8:"1,10,100";s:4:"mva2";s:0:"";}i:1;a:5:{s:2:"id";s:1:"2";s:3:"idd";s:1:"2";s:4:"str1";s:0:"";s:4:"mva1";s:0:"";s:4:"mva2";s:8:"11,12,13";}i:2;a:5:{s:2:"id";s:1:"3";s:3:"idd";s:1:"3";s:4:"str1";s:0:"";s:4:"mva1";s:11:"200,201,210";s:4:"mva2";s:11:"300,301,310";}}}i:10;a:3:{s:8:"sphinxql";s:53:"select * from rt1 where match ('the') order by id asc";s:10:"total_rows";i:3;s:4:"rows";a:3:{i:0;a:5:{s:2:"id";s:1:"1";s:3:"idd";s:1:"1";s:4:"str1";s:0:"";s:4:"mva1";s:8:"1,10,100";s:4:"mva2";s:0:"";}i:1;a:5:{s:2:"id";s:1:"2";s:3:"idd";s:1:"2";s:4:"str1";s:0:"";s:4:"mva1";s:0:"";s:4:"mva2";s:8:"11,12,13";}i:2;a:5:{s:2:"id";s:1:"3";s:3:"idd";s:1:"3";s:4:"str1";s:0:"";s:4:"mva1";s:11:"200,201,210";s:4:"mva2";s:11:"300,301,310";}}}i:11;a:3:{s:8:"sphinxql";s:34:"select * from rt1 order by id desc";s:10:"total_rows";i:3;s:4:"rows";a:3:{i:0;a:5:{s:2:"id";s:1:"3";s:3:"idd";s:1:"3";s:4:"str1";s:0:"";s:4:"mva1";s:11:"200,201,210";s:4:"mva2";s:11:"300,301,310";}i:1;a:5:{s:2:"id";s:1:"2";s:3:"idd";s:1:"2";s:4:"str1";s:0:"";s:4:"mva1";s:0:"";s:4:"mva2";s:8:"11,12,13";}i:2;a:5:{s:2:"id";s:1:"1";s:3:"idd";s:1:"1";s:4:"str1";s:0:"";s:4:"mva1";s:8:"1,10,100";s:4:"mva2";s:0:"";}}}i:12;a:3:{s:8:"sphinxql";s:54:"select * from rt1 where match ('the') order by id desc";s:10:"total_rows";i:3;s:4:"rows";a:3:{i:0;a:5:{s:2:"id";s:1:"3";s:3:"idd";s:1:"3";s:4:"str1";s:0:"";s:4:"mva1";s:11:"200,201,210";s:4:"mva2";s:11:"300,301,310";}i:1;a:5:{s:2:"id";s:1:"2";s:3:"idd";s:1:"2";s:4:"str1";s:0:"";s:4:"mva1";s:0:"";s:4:"mva2";s:8:"11,12,13";}i:2;a:5:{s:2:"id";s:1:"1";s:3:"idd";s:1:"1";s:4:"str1";s:0:"";s:4:"mva1";s:8:"1,10,100";s:4:"mva2";s:0:"";}}}i:13;a:3:{s:8:"sphinxql";s:61:"select * from rt1 group by mva1 within group order by id desc";s:10:"total_rows";i:6;s:4:"rows";a:6:{i:0;a:5:{s:2:"id";s:1:"1";s:3:"idd";s:1:"1";s:4:"str1";s:0:"";s:4:"mva1";s:8:"1,10,100";s:4:"mva2";s:0:"";}i:1;a:5:{s:2:"id";s:1:"1";s:3:"idd";s:1:"1";s:4:"str1";s:0:"";s:4:"mva1";s:8:"1,10,100";s:4:"mva2";s:0:"";}i:2;a:5:{s:2:"id";s:1:"1";s:3:"idd";s:1:"1";s:4:"str1";s:0:"";s:4:"mva1";s:8:"1,10,100";s:4:"mva2";s:0:"";}i:3;a:5:{s:2:"id";s:1:"3";s:3:"idd";s:1:"3";s:4:"str1";s:0:"";s:4:"mva1";s:11:"200,201,210";s:4:"mva2";s:11:"300,301,310";}i:4;a:5:{s:2:"id";s:1:"3";s:3:"idd";s:1:"3";s:4:"str1";s:0:"";s:4:"mva1";s:11:"200,201,210";s:4:"mva2";s:11:"300,301,310";}i:5;a:5:{s:2:"id";s:1:"3";s:3:"idd";s:1:"3";s:4:"str1";s:0:"";s:4:"mva1";s:11:"200,201,210";s:4:"mva2";s:11:"300,301,310";}}}i:14;a:3:{s:8:"sphinxql";s:81:"select * from rt1 where match ('the') group by mva1 within group order by id desc";s:10:"total_rows";i:6;s:4:"rows";a:6:{i:0;a:5:{s:2:"id";s:1:"1";s:3:"idd";s:1:"1";s:4:"str1";s:0:"";s:4:"mva1";s:8:"1,10,100";s:4:"mva2";s:0:"";}i:1;a:5:{s:2:"id";s:1:"1";s:3:"idd";s:1:"1";s:4:"str1";s:0:"";s:4:"mva1";s:8:"1,10,100";s:4:"mva2";s:0:"";}i:2;a:5:{s:2:"id";s:1:"1";s:3:"idd";s:1:"1";s:4:"str1";s:0:"";s:4:"mva1";s:8:"1,10,100";s:4:"mva2";s:0:"";}i:3;a:5:{s:2:"id";s:1:"3";s:3:"idd";s:1:"3";s:4:"str1";s:0:"";s:4:"mva1";s:11:"200,201,210";s:4:"mva2";s:11:"300,301,310";}i:4;a:5:{s:2:"id";s:1:"3";s:3:"idd";s:1:"3";s:4:"str1";s:0:"";s:4:"mva1";s:11:"200,201,210";s:4:"mva2";s:11:"300,301,310";}i:5;a:5:{s:2:"id";s:1:"3";s:3:"idd";s:1:"3";s:4:"str1";s:0:"";s:4:"mva1";s:11:"200,201,210";s:4:"mva2";s:11:"300,301,310";}}}i:15;a:2:{s:8:"sphinxql";s:107:"insert into rt1 (id, idd, str1, mva1, mva2, body) values ( 4, 4, '', ( 200, 210),  (100, 101, 102), 'the' )";s:14:"total_affected";i:1;}i:16;a:3:{s:8:"sphinxql";s:77:"select *, count (*) as c from rt1 group by mva1 within group order by id desc";s:10:"total_rows";i:6;s:4:"rows";a:6:{i:0;a:6:{s:2:"id";s:1:"1";s:3:"idd";s:1:"1";s:4:"str1";s:0:"";s:4:"mva1";s:8:"1,10,100";s:4:"mva2";s:0:"";s:1:"c";s:1:"1";}i:1;a:6:{s:2:"id";s:1:"1";s:3:"idd";s:1:"1";s:4:"str1";s:0:"";s:4:"mva1";s:8:"1,10,100";s:4:"mva2";s:0:"";s:1:"c";s:1:"1";}i:2;a:6:{s:2:"id";s:1:"1";s:3:"idd";s:1:"1";s:4:"str1";s:0:"";s:4:"mva1";s:8:"1,10,100";s:4:"mva2";s:0:"";s:1:"c";s:1:"1";}i:3;a:6:{s:2:"id";s:1:"3";s:3:"idd";s:1:"3";s:4:"str1";s:0:"";s:4:"mva1";s:11:"200,201,210";s:4:"mva2";s:11:"300,301,310";s:1:"c";s:1:"1";}i:4;a:6:{s:2:"id";s:1:"4";s:3:"idd";s:1:"4";s:4:"str1";s:0:"";s:4:"mva1";s:7:"200,210";s:4:"mva2";s:11:"100,101,102";s:1:"c";s:1:"2";}i:5;a:6:{s:2:"id";s:1:"4";s:3:"idd";s:1:"4";s:4:"str1";s:0:"";s:4:"mva1";s:7:"200,210";s:4:"mva2";s:11:"100,101,102";s:1:"c";s:1:"2";}}}i:17;a:3:{s:8:"sphinxql";s:97:"select *, count (*) as c from rt1 where match ('the') group by mva1 within group order by id desc";s:10:"total_rows";i:6;s:4:"rows";a:6:{i:0;a:6:{s:2:"id";s:1:"1";s:3:"idd";s:1:"1";s:4:"str1";s:0:"";s:4:"mva1";s:8:"1,10,100";s:4:"mva2";s:0:"";s:1:"c";s:1:"1";}i:1;a:6:{s:2:"id";s:1:"1";s:3:"idd";s:1:"1";s:4:"str1";s:0:"";s:4:"mva1";s:8:"1,10,100";s:4:"mva2";s:0:"";s:1:"c";s:1:"1";}i:2;a:6:{s:2:"id";s:1:"1";s:3:"idd";s:1:"1";s:4:"str1";s:0:"";s:4:"mva1";s:8:"1,10,100";s:4:"mva2";s:0:"";s:1:"c";s:1:"1";}i:3;a:6:{s:2:"id";s:1:"3";s:3:"idd";s:1:"3";s:4:"str1";s:0:"";s:4:"mva1";s:11:"200,201,210";s:4:"mva2";s:11:"300,301,310";s:1:"c";s:1:"1";}i:4;a:6:{s:2:"id";s:1:"4";s:3:"idd";s:1:"4";s:4:"str1";s:0:"";s:4:"mva1";s:7:"200,210";s:4:"mva2";s:11:"100,101,102";s:1:"c";s:1:"2";}i:5;a:6:{s:2:"id";s:1:"4";s:3:"idd";s:1:"4";s:4:"str1";s:0:"";s:4:"mva1";s:7:"200,210";s:4:"mva2";s:11:"100,101,102";s:1:"c";s:1:"2";}}}i:18;a:3:{s:8:"sphinxql";s:89:"select *, count (distinct mva2) as c from rt1 group by mva1 within group order by id desc";s:10:"total_rows";i:6;s:4:"rows";a:6:{i:0;a:6:{s:2:"id";s:1:"1";s:3:"idd";s:1:"1";s:4:"str1";s:0:"";s:4:"mva1";s:8:"1,10,100";s:4:"mva2";s:0:"";s:1:"c";s:1:"1";}i:1;a:6:{s:2:"id";s:1:"1";s:3:"idd";s:1:"1";s:4:"str1";s:0:"";s:4:"mva1";s:8:"1,10,100";s:4:"mva2";s:0:"";s:1:"c";s:1:"1";}i:2;a:6:{s:2:"id";s:1:"1";s:3:"idd";s:1:"1";s:4:"str1";s:0:"";s:4:"mva1";s:8:"1,10,100";s:4:"mva2";s:0:"";s:1:"c";s:1:"1";}i:3;a:6:{s:2:"id";s:1:"3";s:3:"idd";s:1:"3";s:4:"str1";s:0:"";s:4:"mva1";s:11:"200,201,210";s:4:"mva2";s:11:"300,301,310";s:1:"c";s:1:"1";}i:4;a:6:{s:2:"id";s:1:"4";s:3:"idd";s:1:"4";s:4:"str1";s:0:"";s:4:"mva1";s:7:"200,210";s:4:"mva2";s:11:"100,101,102";s:1:"c";s:1:"2";}i:5;a:6:{s:2:"id";s:1:"4";s:3:"idd";s:1:"4";s:4:"str1";s:0:"";s:4:"mva1";s:7:"200,210";s:4:"mva2";s:11:"100,101,102";s:1:"c";s:1:"2";}}}i:19;a:3:{s:8:"sphinxql";s:97:"select *, count (*) as c from rt1 where match ('the') group by mva1 within group order by id desc";s:10:"total_rows";i:6;s:4:"rows";a:6:{i:0;a:6:{s:2:"id";s:1:"1";s:3:"idd";s:1:"1";s:4:"str1";s:0:"";s:4:"mva1";s:8:"1,10,100";s:4:"mva2";s:0:"";s:1:"c";s:1:"1";}i:1;a:6:{s:2:"id";s:1:"1";s:3:"idd";s:1:"1";s:4:"str1";s:0:"";s:4:"mva1";s:8:"1,10,100";s:4:"mva2";s:0:"";s:1:"c";s:1:"1";}i:2;a:6:{s:2:"id";s:1:"1";s:3:"idd";s:1:"1";s:4:"str1";s:0:"";s:4:"mva1";s:8:"1,10,100";s:4:"mva2";s:0:"";s:1:"c";s:1:"1";}i:3;a:6:{s:2:"id";s:1:"3";s:3:"idd";s:1:"3";s:4:"str1";s:0:"";s:4:"mva1";s:11:"200,201,210";s:4:"mva2";s:11:"300,301,310";s:1:"c";s:1:"1";}i:4;a:6:{s:2:"id";s:1:"4";s:3:"idd";s:1:"4";s:4:"str1";s:0:"";s:4:"mva1";s:7:"200,210";s:4:"mva2";s:11:"100,101,102";s:1:"c";s:1:"2";}i:5;a:6:{s:2:"id";s:1:"4";s:3:"idd";s:1:"4";s:4:"str1";s:0:"";s:4:"mva1";s:7:"200,210";s:4:"mva2";s:11:"100,101,102";s:1:"c";s:1:"2";}}}i:20;a:3:{s:8:"sphinxql";s:89:"select *, count (distinct mva1) as c from rt1 group by mva1 within group order by id desc";s:10:"total_rows";i:6;s:4:"rows";a:6:{i:0;a:6:{s:2:"id";s:1:"1";s:3:"idd";s:1:"1";s:4:"str1";s:0:"";s:4:"mva1";s:8:"1,10,100";s:4:"mva2";s:0:"";s:1:"c";s:1:"1";}i:1;a:6:{s:2:"id";s:1:"1";s:3:"idd";s:1:"1";s:4:"str1";s:0:"";s:4:"mva1";s:8:"1,10,100";s:4:"mva2";s:0:"";s:1:"c";s:1:"1";}i:2;a:6:{s:2:"id";s:1:"1";s:3:"idd";s:1:"1";s:4:"str1";s:0:"";s:4:"mva1";s:8:"1,10,100";s:4:"mva2";s:0:"";s:1:"c";s:1:"1";}i:3;a:6:{s:2:"id";s:1:"3";s:3:"idd";s:1:"3";s:4:"str1";s:0:"";s:4:"mva1";s:11:"200,201,210";s:4:"mva2";s:11:"300,301,310";s:1:"c";s:1:"1";}i:4;a:6:{s:2:"id";s:1:"4";s:3:"idd";s:1:"4";s:4:"str1";s:0:"";s:4:"mva1";s:7:"200,210";s:4:"mva2";s:11:"100,101,102";s:1:"c";s:1:"1";}i:5;a:6:{s:2:"id";s:1:"4";s:3:"idd";s:1:"4";s:4:"str1";s:0:"";s:4:"mva1";s:7:"200,210";s:4:"mva2";s:11:"100,101,102";s:1:"c";s:1:"1";}}}i:21;a:3:{s:8:"sphinxql";s:109:"select *, count (distinct mva2) as c from rt1 where match ('the') group by mva1 within group order by id desc";s:10:"total_rows";i:6;s:4:"rows";a:6:{i:0;a:6:{s:2:"id";s:1:"1";s:3:"idd";s:1:"1";s:4:"str1";s:0:"";s:4:"mva1";s:8:"1,10,100";s:4:"mva2";s:0:"";s:1:"c";s:1:"1";}i:1;a:6:{s:2:"id";s:1:"1";s:3:"idd";s:1:"1";s:4:"str1";s:0:"";s:4:"mva1";s:8:"1,10,100";s:4:"mva2";s:0:"";s:1:"c";s:1:"1";}i:2;a:6:{s:2:"id";s:1:"1";s:3:"idd";s:1:"1";s:4:"str1";s:0:"";s:4:"mva1";s:8:"1,10,100";s:4:"mva2";s:0:"";s:1:"c";s:1:"1";}i:3;a:6:{s:2:"id";s:1:"3";s:3:"idd";s:1:"3";s:4:"str1";s:0:"";s:4:"mva1";s:11:"200,201,210";s:4:"mva2";s:11:"300,301,310";s:1:"c";s:1:"1";}i:4;a:6:{s:2:"id";s:1:"4";s:3:"idd";s:1:"4";s:4:"str1";s:0:"";s:4:"mva1";s:7:"200,210";s:4:"mva2";s:11:"100,101,102";s:1:"c";s:1:"2";}i:5;a:6:{s:2:"id";s:1:"4";s:3:"idd";s:1:"4";s:4:"str1";s:0:"";s:4:"mva1";s:7:"200,210";s:4:"mva2";s:11:"100,101,102";s:1:"c";s:1:"2";}}}i:22;a:3:{s:8:"sphinxql";s:31:"select mva1 as somemva from rt1";s:10:"total_rows";i:4;s:4:"rows";a:4:{i:0;a:1:{s:7:"somemva";s:8:"1,10,100";}i:1;a:1:{s:7:"somemva";s:0:"";}i:2;a:1:{s:7:"somemva";s:11:"200,201,210";}i:3;a:1:{s:7:"somemva";s:7:"200,210";}}}i:23;a:2:{s:8:"sphinxql";s:404:"insert into rt1 (id, idd, str1, mva1, mva2, body) values ( 10, 10, '', ( 210, 211, 220),  (310, 311, 340), 'the' ),  ( 5, 5, '', ( 220, 221, 230),  (320, 321, 350), 'the' ),  ( 6, 6, '', ( 230, 231, 240),  (330, 331, 360), 'the' ),  ( 7, 7, '', ( 240, 241, 244),  (340, 341, 370), 'the' ),  ( 8, 8, '', ( 250, 251, 254),  (350, 351, 380), 'the' ),  ( 9, 9, '', ( 260, 261, 264),  (360, 361, 360), 'the' )";s:14:"total_affected";i:6;}i:24;a:3:{s:8:"sphinxql";s:109:"select *, count (distinct mva1) as c from rt1 group by mva1 within group order by id asc option max_matches=2";s:10:"total_rows";i:2;s:4:"rows";a:2:{i:0;a:6:{s:2:"id";s:1:"1";s:3:"idd";s:1:"1";s:4:"str1";s:0:"";s:4:"mva1";s:8:"1,10,100";s:4:"mva2";s:0:"";s:1:"c";s:1:"1";}i:1;a:6:{s:2:"id";s:1:"1";s:3:"idd";s:1:"1";s:4:"str1";s:0:"";s:4:"mva1";s:8:"1,10,100";s:4:"mva2";s:0:"";s:1:"c";s:1:"1";}}}i:25;a:2:{s:8:"sphinxql";s:99:"update rt1 set nonexistent=1.1, mva1=(210,211,220)  where id=10 option ignore_nonexistent_columns=1";s:14:"total_affected";i:1;}}}