1
|
a:1:{i:0;a:30:{i:0;a:2:{s:8:"sphinxql";s:50:"insert into test (id,content) values (1,'content')";s:14:"total_affected";i:1;}i:1;a:2:{s:8:"sphinxql";s:51:"insert into test1 (id,content) values (1,'content')";s:14:"total_affected";i:1;}i:2;a:3:{s:8:"sphinxql";s:18:"select * from test";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:2:{s:2:"id";s:1:"1";s:3:"idd";s:1:"0";}}}i:3;a:3:{s:8:"sphinxql";s:19:"select * from test1";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:2:{s:2:"id";s:1:"1";s:3:"idd";s:1:"0";}}}i:4;a:2:{s:8:"sphinxql";s:16:"set autocommit=0";s:14:"total_affected";i:0;}i:5;a:2:{s:8:"sphinxql";s:50:"insert into test (id,content) values (2,'content')";s:14:"total_affected";i:1;}i:6;a:3:{s:8:"sphinxql";s:51:"insert into test1 (id,content) values (2,'content')";s:5:"error";s:50:"current txn is working with another index ('test')";s:5:"errno";i:1064;}i:7;a:3:{s:8:"sphinxql";s:28:"delete from test1 where id=1";s:5:"error";s:63:"index test1: current txn is working with another index ('test')";s:5:"errno";i:1064;}i:8;a:2:{s:8:"sphinxql";s:27:"delete from test where id=1";s:14:"total_affected";i:0;}i:9;a:2:{s:8:"sphinxql";s:16:"set autocommit=1";s:14:"total_affected";i:0;}i:10;a:3:{s:8:"sphinxql";s:18:"select * from test";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:2:{s:2:"id";s:1:"2";s:3:"idd";s:1:"0";}}}i:11;a:3:{s:8:"sphinxql";s:19:"select * from test1";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:2:{s:2:"id";s:1:"1";s:3:"idd";s:1:"0";}}}i:12;a:2:{s:8:"sphinxql";s:5:"begin";s:14:"total_affected";i:0;}i:13;a:2:{s:8:"sphinxql";s:51:"insert into test1 (id,content) values (2,'content')";s:14:"total_affected";i:1;}i:14;a:2:{s:8:"sphinxql";s:8:"rollback";s:14:"total_affected";i:0;}i:15;a:3:{s:8:"sphinxql";s:19:"select * from test1";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:2:{s:2:"id";s:1:"1";s:3:"idd";s:1:"0";}}}i:16;a:2:{s:8:"sphinxql";s:17:"start transaction";s:14:"total_affected";i:0;}i:17;a:2:{s:8:"sphinxql";s:51:"insert into test1 (id,content) values (2,'content')";s:14:"total_affected";i:1;}i:18;a:2:{s:8:"sphinxql";s:6:"commit";s:14:"total_affected";i:0;}i:19;a:3:{s:8:"sphinxql";s:19:"select * from test1";s:10:"total_rows";i:2;s:4:"rows";a:2:{i:0;a:2:{s:2:"id";s:1:"1";s:3:"idd";s:1:"0";}i:1;a:2:{s:2:"id";s:1:"2";s:3:"idd";s:1:"0";}}}i:20;a:2:{s:8:"sphinxql";s:16:"set autocommit=0";s:14:"total_affected";i:0;}i:21;a:2:{s:8:"sphinxql";s:50:"insert into test (id,content) values (3,'content')";s:14:"total_affected";i:1;}i:22;a:3:{s:8:"sphinxql";s:18:"select * from test";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:2:{s:2:"id";s:1:"2";s:3:"idd";s:1:"0";}}}i:23;a:2:{s:8:"sphinxql";s:16:"set autocommit=1";s:14:"total_affected";i:0;}i:24;a:3:{s:8:"sphinxql";s:18:"select * from test";s:10:"total_rows";i:2;s:4:"rows";a:2:{i:0;a:2:{s:2:"id";s:1:"2";s:3:"idd";s:1:"0";}i:1;a:2:{s:2:"id";s:1:"3";s:3:"idd";s:1:"0";}}}i:25;a:3:{s:8:"sphinxql";s:19:"select * from test1";s:10:"total_rows";i:2;s:4:"rows";a:2:{i:0;a:2:{s:2:"id";s:1:"1";s:3:"idd";s:1:"0";}i:1;a:2:{s:2:"id";s:1:"2";s:3:"idd";s:1:"0";}}}i:26;a:2:{s:8:"sphinxql";s:40:"insert into test2 values (1, 'test', 11)";s:14:"total_affected";i:1;}i:27;a:3:{s:8:"sphinxql";s:81:"insert into test2 values (2, 'test of my things going well', 22), (1, 'test', 12)";s:5:"error";s:16:"duplicate id '1'";s:5:"errno";i:1064;}i:28;a:2:{s:8:"sphinxql";s:74:"insert into test2 values (3, 'test', 22), (3, 'test', 12), (3, 'test', 23)";s:14:"total_affected";i:3;}i:29;a:3:{s:8:"sphinxql";s:20:"select id from test2";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";}}}}}
|