1
|
a:1:{i:0;a:8:{i:0;a:2:{s:8:"sphinxql";s:70:"insert into test (id,flt,title) values (1,0.3,'zero'),(2,.3,'no zero')";s:14:"total_affected";i:2;}i:1;a:3:{s:8:"sphinxql";s:50:"select .1 as zz, flt from test where match('zero')";s:10:"total_rows";i:2;s:4:"rows";a:2:{i:0;a:2:{s:2:"zz";s:8:"0.100000";s:3:"flt";s:8:"0.300000";}i:1;a:2:{s:2:"zz";s:8:"0.100000";s:3:"flt";s:8:"0.300000";}}}i:2;a:3:{s:8:"sphinxql";s:51:"select 0.1 as zz, flt from test where match('zero')";s:10:"total_rows";i:2;s:4:"rows";a:2:{i:0;a:2:{s:2:"zz";s:8:"0.100000";s:3:"flt";s:8:"0.300000";}i:1;a:2:{s:2:"zz";s:8:"0.100000";s:3:"flt";s:8:"0.300000";}}}i:3;a:2:{s:8:"sphinxql";s:54:"insert into test (id,flt,title) values (10,-123,'neg')";s:14:"total_affected";i:1;}i:4;a:2:{s:8:"sphinxql";s:31:"select * from test where id=-10";s:10:"total_rows";i:0;}i:5;a:3:{s:8:"sphinxql";s:30:"select * 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:3:"flt";s:11:"-123.000000";}}}i:6;a:3:{s:8:"sphinxql";s:19:"select * from test2";s:10:"total_rows";i:3;s:4:"rows";a:3:{i:0;a:2:{s:2:"id";s:1:"1";s:3:"gid";s:1:"1";}i:1;a:2:{s:2:"id";s:1:"2";s:3:"gid";s:1:"1";}i:2;a:2:{s:2:"id";s:1:"3";s:3:"gid";s:1:"1";}}}i:7;a:3:{s:8:"sphinxql";s:39:"select * from test2 where match ( 'c' )";s:10:"total_rows";i:3;s:4:"rows";a:3:{i:0;a:2:{s:2:"id";s:1:"1";s:3:"gid";s:1:"1";}i:1;a:2:{s:2:"id";s:1:"2";s:3:"gid";s:1:"1";}i:2;a:2:{s:2:"id";s:1:"3";s:3:"gid";s:1:"1";}}}}}
|