1
|
a:1:{i:0;a:25:{i:0;a:2:{s:8:"sphinxql";s:104:"insert into rt (id, gid, bint, bfloat, body) values (1, 1, 1, 1.0, 'dummy'), (3, 33, 44, 55.0, 'dummy1')";s:14:"total_affected";i:2;}i:1;a:3:{s:8:"sphinxql";s:16:"select * from rt";s:10:"total_rows";i:2;s:4:"rows";a:2:{i:0;a:4:{s:2:"id";s:1:"1";s:3:"gid";s:1:"1";s:4:"bint";s:1:"1";s:6:"bfloat";s:8:"1.000000";}i:1;a:4:{s:2:"id";s:1:"3";s:3:"gid";s:2:"33";s:4:"bint";s:2:"44";s:6:"bfloat";s:9:"55.000000";}}}i:2;a:3:{s:8:"sphinxql";s:21:"select * from dist_no";s:10:"total_rows";i:3;s:4:"rows";a:3:{i:0;a:4:{s:2:"id";s:1:"1";s:7:"section";s:3:"101";s:4:"bint";s:10:"7000000000";s:6:"bfloat";s:8:"3.140000";}i:1;a:4:{s:2:"id";s:1:"2";s:7:"section";s:3:"102";s:4:"bint";s:10:"8000000000";s:6:"bfloat";s:8:"1.440000";}i:2;a:4:{s:2:"id";s:1:"3";s:7:"section";s:3:"103";s:4:"bint";s:11:"-7000000000";s:6:"bfloat";s:8:"3.420000";}}}i:3;a:2:{s:8:"sphinxql";s:86:"update dist_no set bint=-4560000000000, bfloat=55.5, section=111 where match ('test1')";s:14:"total_affected";i:1;}i:4;a:3:{s:8:"sphinxql";s:21:"select * from dist_no";s:10:"total_rows";i:3;s:4:"rows";a:3:{i:0;a:4:{s:2:"id";s:1:"1";s:7:"section";s:3:"111";s:4:"bint";s:14:"-4560000000000";s:6:"bfloat";s:9:"55.500000";}i:1;a:4:{s:2:"id";s:1:"2";s:7:"section";s:3:"102";s:4:"bint";s:10:"8000000000";s:6:"bfloat";s:8:"1.440000";}i:2;a:4:{s:2:"id";s:1:"3";s:7:"section";s:3:"103";s:4:"bint";s:11:"-7000000000";s:6:"bfloat";s:8:"3.420000";}}}i:5;a:2:{s:8:"sphinxql";s:81:"update dist0 set bint=40000000000, bfloat=55.5, section=111 where match ('test1')";s:14:"total_affected";i:1;}i:6;a:3:{s:8:"sphinxql";s:19:"select * from dist0";s:10:"total_rows";i:3;s:4:"rows";a:3:{i:0;a:4:{s:2:"id";s:1:"1";s:7:"section";s:3:"111";s:4:"bint";s:11:"40000000000";s:6:"bfloat";s:9:"55.500000";}i:1;a:4:{s:2:"id";s:1:"2";s:7:"section";s:3:"102";s:4:"bint";s:10:"8000000000";s:6:"bfloat";s:8:"1.440000";}i:2;a:4:{s:2:"id";s:1:"3";s:7:"section";s:3:"103";s:4:"bint";s:11:"-7000000000";s:6:"bfloat";s:8:"3.420000";}}}i:7;a:2:{s:8:"sphinxql";s:82:"update dist1 set bint=410000000000, bfloat=56.6, section=112 where match ('test1')";s:14:"total_affected";i:1;}i:8;a:3:{s:8:"sphinxql";s:19:"select * from dist1";s:10:"total_rows";i:3;s:4:"rows";a:3:{i:0;a:4:{s:2:"id";s:1:"1";s:7:"section";s:3:"112";s:4:"bint";s:12:"410000000000";s:6:"bfloat";s:9:"56.599998";}i:1;a:4:{s:2:"id";s:1:"2";s:7:"section";s:3:"102";s:4:"bint";s:10:"8000000000";s:6:"bfloat";s:8:"1.440000";}i:2;a:4:{s:2:"id";s:1:"3";s:7:"section";s:3:"103";s:4:"bint";s:11:"-7000000000";s:6:"bfloat";s:8:"3.420000";}}}i:9;a:2:{s:8:"sphinxql";s:82:"update dist2 set bint=420000000000, bfloat=57.7, section=113 where match ('test1')";s:14:"total_affected";i:1;}i:10;a:3:{s:8:"sphinxql";s:19:"select * from dist2";s:10:"total_rows";i:3;s:4:"rows";a:3:{i:0;a:4:{s:2:"id";s:1:"1";s:7:"section";s:3:"113";s:4:"bint";s:12:"420000000000";s:6:"bfloat";s:9:"57.700001";}i:1;a:4:{s:2:"id";s:1:"2";s:7:"section";s:3:"102";s:4:"bint";s:10:"8000000000";s:6:"bfloat";s:8:"1.440000";}i:2;a:4:{s:2:"id";s:1:"3";s:7:"section";s:3:"103";s:4:"bint";s:11:"-7000000000";s:6:"bfloat";s:8:"3.420000";}}}i:11;a:2:{s:8:"sphinxql";s:83:"update dist3 set bint=-430000000000, bfloat=58.8, section=114 where match ('test1')";s:14:"total_affected";i:1;}i:12;a:3:{s:8:"sphinxql";s:19:"select * from dist3";s:10:"total_rows";i:3;s:4:"rows";a:3:{i:0;a:4:{s:2:"id";s:1:"1";s:7:"section";s:3:"114";s:4:"bint";s:13:"-430000000000";s:6:"bfloat";s:9:"58.799999";}i:1;a:4:{s:2:"id";s:1:"2";s:7:"section";s:3:"102";s:4:"bint";s:10:"8000000000";s:6:"bfloat";s:8:"1.440000";}i:2;a:4:{s:2:"id";s:1:"3";s:7:"section";s:3:"103";s:4:"bint";s:11:"-7000000000";s:6:"bfloat";s:8:"3.420000";}}}i:13;a:2:{s:8:"sphinxql";s:82:"update dist4 set bint=440000000000, bfloat=59.9, section=115 where match ('test1')";s:14:"total_affected";i:1;}i:14;a:3:{s:8:"sphinxql";s:19:"select * from dist4";s:10:"total_rows";i:3;s:4:"rows";a:3:{i:0;a:4:{s:2:"id";s:1:"1";s:7:"section";s:3:"115";s:4:"bint";s:12:"440000000000";s:6:"bfloat";s:9:"59.900002";}i:1;a:4:{s:2:"id";s:1:"2";s:7:"section";s:3:"102";s:4:"bint";s:10:"8000000000";s:6:"bfloat";s:8:"1.440000";}i:2;a:4:{s:2:"id";s:1:"3";s:7:"section";s:3:"103";s:4:"bint";s:11:"-7000000000";s:6:"bfloat";s:8:"3.420000";}}}i:15;a:2:{s:8:"sphinxql";s:83:"update dist5 set bint=-450000000000, bfloat=60.4, section=116 where match ('test1')";s:14:"total_affected";i:1;}i:16;a:3:{s:8:"sphinxql";s:19:"select * from dist5";s:10:"total_rows";i:3;s:4:"rows";a:3:{i:0;a:4:{s:2:"id";s:1:"1";s:7:"section";s:3:"116";s:4:"bint";s:13:"-450000000000";s:6:"bfloat";s:9:"60.400002";}i:1;a:4:{s:2:"id";s:1:"2";s:7:"section";s:3:"102";s:4:"bint";s:10:"8000000000";s:6:"bfloat";s:8:"1.440000";}i:2;a:4:{s:2:"id";s:1:"3";s:7:"section";s:3:"103";s:4:"bint";s:11:"-7000000000";s:6:"bfloat";s:8:"3.420000";}}}i:17;a:2:{s:8:"sphinxql";s:66:"update rt set gid=3212, bfloat=55.5, bint=2340000000000 where id=1";s:14:"total_affected";i:1;}i:18;a:3:{s:8:"sphinxql";s:16:"select * from rt";s:10:"total_rows";i:2;s:4:"rows";a:2:{i:0;a:4:{s:2:"id";s:1:"1";s:3:"gid";s:4:"3212";s:4:"bint";s:13:"2340000000000";s:6:"bfloat";s:9:"55.500000";}i:1;a:4:{s:2:"id";s:1:"3";s:3:"gid";s:2:"33";s:4:"bint";s:2:"44";s:6:"bfloat";s:9:"55.000000";}}}i:19;a:3:{s:8:"sphinxql";s:25:"select 100500some from rt";s:5:"error";s:72:"sphinxql: syntax error, unexpected BAD_NUMERIC near '100500some from rt'";s:5:"errno";i:1064;}i:20;a:3:{s:8:"sphinxql";s:19:"select `id` from rt";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:"3";}}}i:21;a:2:{s:8:"sphinxql";s:37:"update idx1 set bfloat=123 where id=1";s:14:"total_affected";i:1;}i:22;a:3:{s:8:"sphinxql";s:34:"select bfloat from idx1 where id=1";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:1:{s:6:"bfloat";s:10:"123.000000";}}}i:23;a:2:{s:8:"sphinxql";s:35:"update rt set bfloat=123 where id=1";s:14:"total_affected";i:1;}i:24;a:3:{s:8:"sphinxql";s:32:"select bfloat from rt where id=1";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:1:{s:6:"bfloat";s:10:"123.000000";}}}}}
|